Technical Skills: UML, (use cases, sequence diagrams, class packages and component collaboration design), . SQL Server 2005 & 2008, T-SQL, Stored Procs, SSIS ETL, SSRS, SSAS cubes, Oracle PL/SQL.
Development Tools: Team Foundation Server, Visual Studio, BIDS, Visual Source Safe. Harvest Change Control. SSMS.
- Developed 30 SQL Server 2008 SSRS reports using MS SQL 2008 complex stored procedures for the data tier. Deployed reports to the SSRS server. Used SSRS Web Services objects in an ASP.NET 3.5 application. Rendered reports in a report viewer control.
- Designed reports using Tablix, List, Images, groups, expressions, and VB code. Not just wizards. Used MDX query designer against cubes
- Developed SQL Server 2005 SSIS packages importing and exporting external client data. Used many of the Control Flow tasks and Data Flow tasks. Input and output XML, Flat Files, Excel, and RDBMS. Transformed and merged, and output to ftp servers.
- Developed OLAP cubes using MS SQL Server Analysis Services to be data sources for SSRS reports and MS Excel spreadsheets. Designed cube partitions and perspectives. Designed star schemas and populated using SSIS.
- Coded a ASP.NET C# User Control to display report lists from SSRS server, and used rs web services to render the report selected from the list.
- Developed SQL Server 2005 SSIS packages. Used many of the Control Flow tasks and Data Flow tasks. Input and output XML, Flat Files, Excel, and RDBMS. Transformed and merged, and output to ftp servers, Oracle and SQL Server data bases and OLAP cubes. Coded variables and SSIS expressions for many of the tasks. Also executed OLAP SSAS within SSIS.
- Developed SQL Server 2005 SSRS projects to report on the data created from SSIS packages. Set up and configured SSRS report server. Deployed reports to the SSRS server and used SSRS Report manager to manage the security and display of the reports to the user community.
- Brought in to debug MS .NET Windows and Web form C# code problems that current staff was not successful in doing. The cause of problems are of the “end of life cycle” nature, embedded deep into the business logic layer of C# code.
- Coded 30+ PL/SQL stored procedures which made heavy use of Oracle cursors, cursor for and into loops, select, select into, various types of joins, and PL/SQL CRUD logic. Used the Oracle DB tools, TOAD and SQL Navigator.
- Gathered and documented requirements for a membership eligibility feed from legacy systems to a new claims billing and payment system. Designed a small RDBMS to support the functional requirements discovered.
- For the Trizetto Facets application, On a Clams Payments project: provided leadership in business requirements collection, analysis, and specification. Facilitated JAR/JAD sessions for requirements discovery. Established excellent relationships with the business customers and bridged the technical communication gap between business and IT. Also did data requirement analysis including ETL mapping for data feed to an SAP accounting system.
- Managed requirement trace ability, scope, risk and change control throughout the development life cycle. Translated business requirements to software design using UML including business process modeling, domain modeling, and use case modeling. Used Borland CaliberRM / Eclipse / Together, and Visio as requirement gathering tools. Used Mercury for the testing phase tool.
- Followed CMMI methodology wrapped around an iterative RUP
development process.
- Linn Benton CC. Associate, Computer Programming
Download Resume Format
0 comments:
Post a Comment