SUMMARY:

• 8+ years of overall experience in IT Industry with Data warehousing, OLAP reporting tools, ETL tools using industry accepted methodologies and procedures.
• Expert knowledge in working with Data Warehousing ETL using Informatica Power Center 9.x/8.x/7.x (Designer, Repository manager, Repository Server Administrator console, Server Manager, Work flow manager, workflow monitor) and Knowledge of Informatica 7.x/8.x/9.x in installation and setup.
• Senior ETL Developer with 12 years of experience in BI, Data Modeling, ETL Architecture, Data Analysis, SQL Server Database design for Data warehousing (OLAP) and OLTP systems.
• Experienced in SQL Server Database Administration.
• Have experience in developing and implementing complex business logic in SQL Server using TSQL
• Designed ETL Process using and SSIS, SSRS & Informatica Power center, Informatica Data Quality and Informatica MDM Administrator.
• Experience mostly involved in ETL design & development using MSBI suit SSIS, SSRS & SSAS, Informatica Power Center.
• Experienced in Implementing ETL architecture for more than a thousand tables.
• Experience in SQL server database administration.
• Implemented replication, CDC & Partitioning.
• 8+ years of experience in Healthcare domain ETL design & data modelling.
• Experience in Data profiling & scorecards using Informatica Data Quality development.
• Experienced in Administration of Informatica Data Quality, Power Center & MDM tools.
• Achieved Desired System Performance in tuning SQL, TSQL code, ETL code for Database size of more than 130 TB.
• Experience in setting up MongoDB environment and implementing replica sets and MongoDB development.
• Worked on HL7 2.x standards.
• 5+ years of experience in BizTalk Server 2010 Development & support.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2008 R2, Linux

ETL & BI Tools: SSIS, Informatica Power Center, SSRS, SSAS, Informatica IDQ Developer, Informatica MDM administration

Database: SQL Server 2008, 2012

NOSQL Databases: MongoDB 2.x

Programming Languages: C#, Shell Scripting

Web Technologies: Asp.Net, Webservices, WCF, Java Script, XML/XSLT/XSD

Integration Tools: Biztalk Server 2006, 2010

Web Servers: IIS

Healthcare Messaging: HL7 v2x. HL7 3.0 Trained in CDA

WORK EXPERIENCE:

Confidential, North Little Rock, AR

Sr. ETL/DWH/QA Tester

Responsibilities:

• Setting up the Informatica environment by creating Informatica Domains for DQ & Power Center.
• Designing, Coding of ETL process to extract data from flat files using SSIS.
• Developing Informatica mapping, sessions & workflow to load data in Target database.
• Designed and directed the ETL process, including data quality and testing
• Developed ETL packages process to move Data from Meditech Data Repository to the EDW.
• Profiling the data, creating score cards using Informatica Data Quality.
• Developed Data quality mappings and workflows and hosted as application to run on schedule.
• Database design & development using SQL server 2005(developed SP, Functions, Triggers, performance tuning of TSQL queries)
• Developed ETL packages process to move Data from Staging to Target tables.
• Database design & development using SQL server 2005(developed SP, Functions, Triggers, performance tuning of TSQL queries)
• Designed the New Project Infrastructure, Hardware requirements, Physical Data Modelling with Architect team.
• Developed strategies for data acquisitions, archive recovery, and implementation of a Staging database.
• Designed and directed the ETL process, including data quality and testing.
• Developing Informatics mapping, sessions & workflow to load data in Target Database.
• Preparation of Functional Specifications.
• Created the HLD and LLD Document for the Data Modelling Team.
• Implemented SQL Server replication(transactional, merge replications & P2P)
• Designed & implement file groups to store data in multiple file groups for better performance.
• Developed strategies for data reconciliation for the ETL process.
• Administration of Informatica MDM (Managing MDM HUB & ORS)
• Preparation of Functional Specifications.
• Developing reports using SSRS.
• Moving MDM & DQ objects from Dev to QA & Prod.

Environment: Intel Pentium O/s: Windows 2003,SSIS, Informatica Power Center, SSAS, Visual Studio 2008, Sqlserver 2008, SSRS, Informatica Data Quality, Tableau, BizTalk Server 2010 & Biztalk HL7 accelerator.

Confidential, Rogers, AR

Sr. ETL/DWH/QA Tester

Responsibilities:

• Designed and developed the SSIS & power center ETL process, including data quality and testing.
• Developing Informatics mapping, sessions & workflow to load data in Target Database.
• Developed ETL packages process to move Data from Meditech Data Repository to the EDW.
• ETL design for more than 1000 tables from source Meditech DR tables
• Profiling the data, creating score cards using Informatica Data Quality.
• Database design & development using SQL server 2005(developed SP, Functions, Triggers, performance tuning of TSQL queries)
• Implemented SQL Server replication(transactional, merge replications & P2P)
• Designed & implement file groups to store data in multiple file groups for better performance.
• Developed strategies for data reconciliation for the ETL process.
• Designing, Coding of ETL process to extract data from flat files using SSIS.
• Set up the environment for MongoDB and implement MongoDB replicatica sets. Designed MongoDB database and collections for adhoc data and reporting.
• Developing the reports using SSRS.
• Designed Tableau dashboards for Informatica Data quality scorecards
• Performed Code Review, assigned Tasks and Mentored the ETL Development Team.
• Lead the Implementation, ETL roll out and deployment phase.
• Developed Biztalk Interfaces for consuming HL7 messages using Biztalk Server HL7 accelerator.

Environment: Intel Pentium O/s: Windows 2003,SSIS, Informatica Power Center, SSAS, Visual Studio 2008, Sqlserver 2008, SSRS, Informatica Data Quality, Tableau, Biztalk Server 2010 & Biztalk HL7 accelerator.

Confidential, Little Rock, AR

ETL QA Tester

Responsibilities:

• Developed SSIS ETL packages process to move Data from source to Target tables.
• Database design & development using SQL server 2005(developed SP, Functions, Triggers, performance tuning of TSQL queries)
• Designing, Coding of ETL process to extract data from flat files using SQL Server.
• Developing the reports using Crystal Reports tools.
• Performed Code Review, assigned Tasks and Mentored the ETL Development Team.
• Lead the Implementation, ETL roll out and deployment phase.
• Developed UI.
• Involved in the DAL.
• Created database objects(tables, views & stored procedures)
• Prepared Unit test cases using NUnit framework
• Involved in writing & executing the integration and system test cases.
• Preparing User manuals for the application and training end users.
• Implemented SQL Server replication(transactional & merge replications)
• Developed strategies for data acquisitions, archive recovery, and implementation of a Staging database.
• Preparation of Functional Specifications.
• Created the HLD and LLD Document for the Data Modelling Team.
• Designing, Coding of ETL process to extract data from flat files.
• Developing the reports using SSRS.
• Performed Code Review, assigned Tasks and Mentored the ETL Development Team.
• Lead the Implementation, ETL roll out and deployment phase.

Environment: Intel Pentium O/s: Windows 2003,SSIS, Informatica Power Center, SSAS, Visual Studio 2008, Sqlserver 2008, SSRS, Informatica Data Quality, Tableau, Biztalk Server 2010 & Biztalk HL7 accelerator.

Confidential, Little Rock, AR

ETL QA Tester

Responsibilities:

• Developed ETL packages process to move Data from Staging to Target tables.
• Developing SSIS Packages to load data in Target Database.
• Database design & development using SQL server 2005(developed SP, Functions, Triggers, performance tuning of TSQL queries)
• Implemented SQL Server replication(transactional & merge replications)
• Developed strategies for data acquisitions, archive recovery, and implementation of a Staging database.
• Designed and directed the ETL process, including data quality and testing.
• Preparation of Functional Specifications.
• Created the HLD and LLD Document for the Data Modelling Team.
• Developed ETL packages process to move Data from Staging to Target tables.
• Database design & development using SQL server 2005(developed SP, Functions, Triggers, performance tuning of TSQL queries)
• Designed the New Project Infrastructure, Hardware requirements, Physical Data Modelling with Architect team.
• Developed strategies for data acquisitions, archive recovery, and implementation of a Staging database.
• Designed and directed the ETL process, including data quality and testing.
• Developing Informatics mapping, sessions & workflow to load data in Target Database.
• Preparation of Functional Specifications.
• Created the HLD and LLD Document for the Data Modelling Team.
• Designing, Coding of ETL process to extract data from flat files using SQL Server.
• Developing the reports using Crystal Reports tools.
• Performed Code Review, assigned Tasks and Mentored the ETL Development Team.
• Lead the Implementation, ETL roll out and deployment phase.

Environment: Intel Pentium O/s: Windows 2003,SSIS, Informatica Power Center, SSAS, Visual Studio 2008, Sqlserver 2008, SSRS, Informatica Data Quality, Tableau, Biztalk Server 2010 & Biztalk HL7 accelerator.