SUMMARY:

• Skilled IT Professional wif over 10 years of expertise in Data Warehousing and ETL process focusing on Software delivery, Business Analysis
• Requirements, Development, Performance, Testing, Administration of Data Warehousing and Client/Server projects using industry accepted methodologies and procedures.
• Design, develop and implement Extraction, Transformation and Loading process (ETL) using SQL Server SSIS, T - SQL.
• Technical and analytical skills wif an in depth understanding of ER modelling for OLTP and dimension modelling for OLAP systems.
• Proficient in SQL Server 2005/2008 R2, 2012 Business Intelligence (SSIS and SSRS) tools, Data Warehousing and ETL processes
• Experienced in enhancing database and SSIS ETL performance.
• Report generation using SQL Server Reporting Services (SSRS) from relational databases.
• Architect SQL solutions wif T-SQL and Oracle PL/SQL.
• Design and create Logical and Physical designing of relational databases using Visio, Erwin and Oracle Designer
• MS SQL Server administration tasks such as backup / restore and managing User Management.
• Skilled in Troubleshooting and Resolution.
• User Training wif technical Runbook documentations & Support.
• Highly experienced in all aspects of System Development Life Cycle (SDLC).
• Agile methodologies and Water Fall model.

TECHNICAL SKILLS:

Databases: Microsoft SQL Server 2005/2008 R2/2012, Oracle 8i/9i/10g/11g, MySQL, DB2

Data Warehousing Tools: Microsoft SQL Server Integration Services (SSIS), Informatica 9.0, Ab-Inito 3.0

Reporting Tools: Microsoft SQL Server Reporting Services (SSRS)

Data Modeling Tool: Visio, Erwin, Oracle Designer

Languages: T-SQL, PL/SQL, Visual Basic(VB) .NET, C#, SQL, Shell Scripting

Operating Systems: Windows NT/98/2000/XP/7.0, DOS, UNIX, Linux and Sun Solaris

Utilities: Toad, PL/SQL Developer, SQL Developer.

Defect Tracking Tools: HP Quality Center, Compuware, Bugzilla

Version control: SourceGear Vault, Team Foundation Server (TFS), Visual Sourcesafe, CVS

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

Sr. Business Intelligence Developer/Lead

Responsibilities:

• Managed technical and business aspects of key projects and delivered business critical project on time.
• Designed, developed and lead an ETL standardization project to consolidate different client data processes.
• Streamlined legacy ETL processes to log and perform better to minimize production issues.
• Lead cross functional and offshore and onshore model teams.
• Redesigned ETL process enhancing teh existing Medical billing ETL process.
• Implemented reconciliation process of data loads from Medical provider data files to in house medical billing payer systems.
• Designed and developed SSRS reports to aid business process users wif real-time statistics.
• Created support and technical documentation to aid in noledge transfer to off-shore support team.
• Fixed complex defects in teh existing ETL and SSRS code wifin tight timelines.
• Worked in an onshore and offshore development model and actively engaged cross teams to gather business requirements to design ETL and SSRS report solutions for complex business scenarios.

Environment: Microsoft SQL Server 2008 R2, Microsoft SQL Server 2012, SQL Server SSIS, SQL Server 2008 R2 SSRS, Pervasive Data Integrator ETL Tool, Team Foundation Server, BPA AutoMate.

Confidential, Bedford, NH

Sr. Database/ETL Engineer

Responsibilities:

• Designed and implemented Framework for ETL process.
• Implemented data cleansing, error handling and reprocessing of exception records.
• Designed and implemented data synchronization process for lookups between Data Warehouse and application systems.
• Migrated Source Control to Team Foundation Server and implemented single click deployment of Database scripts into various environments using MS Build and TeamCity.
• Introduced BIML to develop SSIS packages to enhance better source control and programming.
• Analyzed medical data from different Medical Insurance companies to empower both patients and providers while allowing informed decision making, improving efficiency and reducing medical costs.
• Developed multiple ETL packages using SSIS to extract data from disparate sources to application database wif incremental loads.
• Developed custom reports using SSRS, reports include parameterized reports, Ad-hoc reports, drill-down reports, Dash-boards & Summary reports.
• Automated Database build process using VS Database Projects, MS Build.
• Created export files from SQL Server environment to external vendors.
• Actively engaged in design discussions for all Business Intelligence and database initiatives.
• Produced T-SQL solutions to support application development including custom T-SQL stored procedures to perform ETL operations.
• Enhanced SSIS Package performance and optimized slow running ETL scripts in SQL Server.
• Participated in deployment process by generating detailed deployment checklists and supporting release engineers during deployments.
• Key participant in all code review and war-room meetings.
• Collaborated wif Production support and SQA team in resolving day to day issues.
• Collaborated wif data testers by sharing solution design noledge and provided guidance in creating productive test cases and scripts.

Environment: Microsoft SQL Server 2005/2008 R2, SQL Server SSIS, SQL Server SSRS, BIML, Oracle 10g, Toad, PL/SQL Developer, Informatica 9.0, Team Foundation Server, SourceGear Vault, VB .NET, C#, Visio, QTP, HP Quality Center, Compuware, Windows, Agile

Confidential, San Jose, CA

Database/ETL Engineer

Responsibilities:

• Accountable for all ETL operations wifin teh Engineering group including client feeds, warehouse loads, and data extraction using SQL Server 2005 Integration Services (SSIS).
• Designed, developed and implemented ETL Framework for ETL configuration management and logs in MS SQL Server database for SSIS jobs.
• Developed dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS).
• Developed T-SQL solutions, including data model designs, triggers, views, functions and indexes for optimum performance of application and SSIS ETL packages.
• Streamlined data flow process between disparate systems.
• Simplified data extraction process using SSIS to reduce teh workload on teh application system.
• Authored technical specifications and technical design documents.

Environment: Microsoft SQL Server 2005, SQL Server SSIS, SQL Server SSRS, Oracle 9i, Toad, VB .NET, Bugzilla, Windows.