SUMMARY

• Over 16 years of end - to-end experience in various ETL/BI/.NET projects in Healthcare, Life sciences and Insurance domain.
• Over 8 years of experience in Design and development of ETL projects using various ETL tools such as Informatica, SSIS, Datastage and DTS.
• Informatica expertise with an emphasis on working with a diverse set of sources and targets, implementing auditing, error trapping/tracking, reusability and restartablilty, and the ability to troubleshoot and performance tune Informatica mappings, sessions and workflows
• Experience with Data Warehousing principles with hands on experience with slowly changing dimensions and fact tables
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables
• Develop or enhance new/existing dimensional models in achieving scalable, reliable and optimal physical, logical and conceptual data models.
• Prepare Source to Target Data Mappings, ETL Design and technical specification documents in compliance with the Enterprise Data Governance and Stewardship committee standards.
• Experience in generating reports, dashboards using SQL Server Reporting services, Crystal Reports
• Experience in analyzing, designing, building &, testing of OLAP cubes with SSAS
• Experience working in an Agile Methodology(Scrum, XP, Kanban) environment
• Ability to work in a fast paced environment and meet deadlines
• Facilitated planning sessions with team, tracked and reported on project progress
• Extensive experience in Design, development, testing and deployment of various web application and windows applications written in vast range of technologies from C#/VB.NET/ASP.NET based on .NET frameworks 4.0, 3.5, 2.0.
• Extensive experience in writing complex PLSQL scripts/functions/procedures/packages
• Designed and developed new projects as well as extended functionality of existing projects, provided application support and troubleshooting.
• Experience includes 7 years of direct client interaction and coordination at on-site
• Gathering requirements from clients and writing technical specifications for working teams
• Assisted and mentored other members of the team on ongoing projects and solutions.

TECHNICAL SKILLS

ETL Tools: Informatica, SSIS, Datastage, DTS

Reporting Tools: SQL Server Reporting Services, Crystal Reports

OLAP Tools: SSAS

Data Model: ERWIN

Programming Languages: C#, VB.Net, VB6.0

Internet Technologies: ASP.Net, WCF, XML, HTML, CSS, AJAX

Scripting Technologies: Java Script, VB Script

Databases: SQL Server, Oracle

Operating Systems: Windows XP/WIN7

Source Control Tools: SVN,VSS, VSTS

PROFESSIONAL EXPERIENCE

Confidential

Technology Lead

Technologies: Informatica PowerCenter 10.2.1/9.6.1/9.5.1 , Oracle 11g, PL/SQL, Unix Shell Scripting, XML and Trizetto Facets data models

Responsibilities:

• Interfacing with multiple stakeholders for requirements gathering
• Analyzing, Validating and Refining Business Requirements, Functional and Non-Functional requirements, defining development scope and technical specification documents.
• Designing each ETL process with complete data load and refresh strategy, data reconcilement and validation techniques, Error Logging and Restart ability/Recover Strategy, Data Retention and Archival/Purge mechanism.
• Developing/modifying the mappings, workflows as per the requirement.
• Conducting Code Reviews with ETL and DB Admins in order to comply with the Industry Best Practices and Development Standards.
• Support System Integration Testing and UAT
• Support deployment into Dev, QA, Production environments, as required
• Offshore Coordination
• Managing projects progress on an ongoing basis and has responsibility for execution and final delivery and release of the application

Confidential

Technology Lead

Technologies: Informatica PowerCenter 9.5.1, Oracle 11g, PL/SQL, Unix Shell Scripting, XML and Trizetto Facets data models

Responsibilities:

• Interfacing with multiple stakeholders for requirements gathering
• Requirements elicitation and analysis
• Design and build ETL jobs
• Support System Integration Testing and UAT
• Support deployment into Dev, QA, Production environments, as required
• Offshore Coordination
• Managing projects progress on an ongoing basis and has responsibility for execution and final delivery and release of the application

Confidential

Technology Lead

Technologies: SSRS (Reporting tool), SSIS (ETL), SSAS (OLAP), SQL Server 2008

Responsibilities:

• Understanding the existing functional areas
• Interact with the customer and collect customer requirements
• Analyze dashboard KPIs and data mapping from different sources.
• Design and build ETL jobs for data consolidation, aggregation as per reporting requirements
• Design & build budgetary dashboard report for providing utilization metrics, projections, and variance.
• Design and build Analytical Dashboard for Prior authorization and Appeals operations.
• Support System Integration Testing and UAT
• Support deployment into Dev, QA, Production environments, as required
• Status Reporting and communication.

Confidential

Technology Lead

Technologies: SSIS (ETL), SQL Server 2008

Responsibilities:

• Understanding the existing functional areas
• Understand the existing technical SSIS ETL architecture, Source data Models, Business rules around data.
• Understanding and follow the existing governance and operational processes like data stewardships, master and Meta data management, change management, release management and communication processes.
• Partner with client to enhance to implement the ICD 10 and USVI specific changes.
• Apply existing best practices and standards, and continually improving them.
• Perform the unit testing, deployment support activities, Dev/QA data loads and validation work in the ETL area.
• Status Reporting and communication.