SUMMARY:

• Over 9 years of experience in Analysis, Design, Development, Implementation, Testing and Support of applications using SQL Server 2008 R2/SQL Server 2012/2014, Azure SQL Database, SSDT, BIDS, C#.NET.
• Extensive experience in Data Extraction, Transformation and Load (ETL) from disparate Data sources and Multiple Relational Databases such as Oracle, SQL Server, DB2, MS Access. Worked on integrating data from flat files, CSV files into a common reporting /analytical Data Model using SSIS
• Good experience in creating and customizing Multidimensional /Tabular Cubes using SQL Server Analysis Services (SSAS).
• Led a team of developers for a complex development project.
• Implemented full life cycle projects from requirement gathering to productionizing.
• Good Confidential Data Warehouse techniques - Dimensional Data Modeling, Star Schema and Snowflake Schema.
• Extensive experience in creating large PDF, Excel, CSV reports using SSRS and Dashboard reports using Power BI.
• Strong experience in working on conceptual, physical and logical data models(3NF) using various Data Modeling tools like Erwin, MS Visio.
• Excellent analytical and problem solving skills for understanding the business requirements, business rules/processes, and detailed design of the application.
• Experienced in Work Estimates, Code Reviews and Project Status Reviews and providing design, coding, testing Confidential various client places.
• Experienced in coordinating cross-functional teams, project management and presenting technical ideas to diverse groups. Proven ability to implement technology based solutions for business problems.
• Good verbal, written, and presentation skill. Excellent team worker. Self-motivated and quick learner. Adaptable to a fast growing and changing environment.

TECHNICAL SKILLS:

Technologies: SQL, T-SQL, C# .NET

RBMS: SQL Server 2008 R2/ SQL Server 2012 & 2014, Microsoft Azure Database, MS Access, Oracle 9i/10g

Development Tools: SQL Server Management Studio, SQL Query Analyzer, MS Visual Studio .NET, BIDS, SSDT, SSAS, PowerShell, ERwin.

ETL Tools: SSIS

Reporting Tools: SSRS, Power BI

Operating Systems: Windows 98, 2000 & XP

Configuration Management Systems: Microsoft Visual Source Safe, TFS, SVN

DETAILED PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Senior Database Developer

Responsibilities:

• Analyzing Mapping requirements and developing a system design that will facilitate easier way to surface data from CIP to the Measure Computation Engine. (CIP is the Confidential Intelligent platform (Data-warehouse) that hosts health-care data)
• Creating ETL routines to populate Fact /Dimension tables (QI Datamart) with measure results calculated from ACE based on the Business Requirements.
• Creating ETL routines to populate UFA Datamart.
• Fine tune the ETL routines by analyzing/proposing indexing strategies to ensure good performance.
• Working with Clinical Analysts to ensure that design specifications and data model designs met the business and data requirements.
• Develop scripts to do initial load of very large datasets(upto terabyte of data) to the datamart.
• Develop SSAS Multidimensional cube, author Measures and coordinate with front-end team to ensure that charts/reports display accurate analytics data.
• Proof of concept project for developing SSAS Tabular Cube.
• Worked on deployment scripts using PowerShell.
• Develop dashboard reports using PowerBI and SQL Azure DB.
• Participating in technical reviews of project team activities; including design and code walk-through, specification review, system change requests, etc.

Technical Environment: T-SQL, C#.NET, SSIS, SSAS, PowerBI.

Configuration Tools: TFS (for source code control)

Special Software: SQL Server Management Studio, MS Visual Studio.NET, SSDT, BIDS.

RDBMS: SQL Server 2012 & 2014, Azure SQL

Confidential, Lynnwood, WA

Senior Developer

Responsibilities:

• Studied Business and Functional requirements and created technical design for various inbound and outbound interfaces.
• Analyzed Mapping documents which include details of field to field mapping between sources and targets, Business Rules, workflows, pre-dependencies, post dependencies, exception error processing methodology.
• Handled multiple feed file formats such as Delimited / Fixed Width flat files, Excel/CSV files.
• Developed and implemented the end to end solution using SQL Server SPs, BatchRunner programs and C# console applications and SSIS.
• Designed complex algorithms in order to address critical Data Transformation solutions.
• Developed and automated mass report generation in PDF format using SSRS.
• Created and customized SSAS cubes.
• Involved in Performance Tuning of large data set
• Participated in technical reviews of project team activities; including design and code walk-through, specification review, system change requests, etc.
• Created effective Test Cases and monitored Unit Testing and Integration Testing.
• Worked with Business Analysts to ensure that design specifications and data model designs met the business and data requirements.
• Facilitated User Acceptance Testing.

Technical Environment: T-SQL, C#.NET, XML (BatchRunner), SSRS, SSIS, SSAS.

Configuration Tools: TFS (for source code control)

Special Software: SQL Server Management Studio, MS Visual Studio.NET, BIDS.

RDBMS: SQL Server 2008 R2/ 2012

Confidential

Project Lead

Responsibilities:

• Led a development team of 6 people to design, develop and implement the end to end ETL solution using SSIS and SQL Server SPs which involves integration of several feeds from different vendor to the various down-stream applications.
• Worked with Business Analysts and Data Modelers to ensure that design specifications, ETL and data model designs met the business and data requirements.
• Designed the solution to automate and dynamically create most of the staging data-structures on the fly.
• Designed, developed and implemented a resolution for the critical deadlock situations.
• Analyzed Mapping documents which included details of field to field mapping between sources and targets, Business (TRANSFORMATION) Rules, workflows, pre-dependencies, post dependencies, exception error processing methodology.
• Handled multiple feed file formats such as Delimited / Fixed Width flat files, Excel/CSV files, Variable data length (VDL) files.
• Developed dashboard reports using SSRS.
• Participated in HLD, LLD, ETL and DA specs creation for developers and designed the overall ETL flow.
• Involved in SQL Performance Tuning.
• Participated in technical reviews of project team activities; including design and code walk-through, specification review, system change requests, etc.
• Created effective Test Cases and monitored Unit Testing and Integration Testing to ensure the successful execution of data loading process. Facilitated User Acceptance Testing.

Technical Environment: T-SQL, SSIS, SSRS, C#.NET

Configuration Tools: SVN (for source code control)

Special Software: SQL Server Management Studio, MS Visual Studio.NET, ERwin, BIDS.

RDBMS: SQL Server 2008 R2

Confidential, Bothell, WA

Developer

Responsibilities:

• Studied the data architecture for the application and created technical interface document.
• Designed backend system in SQL Server 2008 R2.
• Construction of the solution in ASP.NET 3.5, C#.NET, SQL and Stored Programs.
• Designed and Developed the interface using SSIS
• Report generation using T-SQL, Stored Programs and SSRS.
• Designed & implemented algorithm to handle uncompressing dynamic file formats on the fly.
• Worked with project Business Analysts and Data Modelers to ensure that the ETL and data model designs met the business and data requirements.
• Analyzed the Data Quality to determine cleansing requirements.
• Worked closely with project manager to develop and update the task plan for ETL work and reported any critical task issues and dependencies on other teams to the manager.
• Automated many manual jobs and activities to reduce the workload and improve the daily ETL SLAs
• Troubleshoot the mappings and sessions when the ETL failed to find the root cause and determine the possible solution.
• Prepared unit test case which included field level testing, functionality testing.

Technical Environment: T-SQL, SSIS, SSRS.

Configuration Tools: MS-VSS (for source code control)

Special Software: SQL Server Management Studio, MS Visual Studio.NET, BIDS, ERwin.

RDBMS: SQL Server 2008 R2

Confidential, Bothell, WA

Developer

Responsibilities:

• Responsible for end to end development of the system.
• Implemented a full SDLC project.
• Designed backend system in SQL Server 2005.
• Constructed feed into and out of the system using SQL Server Jobs, Stored Program and SQL.
• Construction of the solution in ASP.NET 2.0 and scripting language.
• Report generation using SQL, Stored Programs.
• Responsible for Unit testing.
• Facilitated functional and system testing
• Responsible for Maintenance, Enhancement and Change Requests.

Technical Environment: SQL, Stored Program, ASP.NET 2.0, VB Script, Java Script, HTML

Configuration Tools: MS-VSS (for source code control)

Special Software: SQL Query Analyzer, Enterprise Manager, Visual Studio.NET 2005.

RDBMS: SQL Server 2005

Confidential

Data Analyst /Developer

Responsibilities:

• Researched the system and the data sources.
• Performed Source schema & Target schema analysis.
• Analyzed processes to evaluate data credibility and efficacy.
• Performed Data Mapping and Translations.
• Designed solution using SQL, Stored Procedures and Packages.
• Analyzed the sample of Data Extracts from the source and target system.
• Data Purging and reconciliation of Source and Target system.
• Ensuring consistency with existing databases and warehouses.

Technical Environment: SQL, PL/SQL, UNIX Shell Scripts.

Configuration Tools: MS-VSS (for source code control)

Special Software: PL/SQL Developer, TOAD, WFTP

RDBMS: Oracle 8/9i