SUMMARY:

• 13+ years of IT experience in Data Warehousing, Data Modelling, designing Data Marts, ETL, Informatica, Talend, Pentaho, Oracle, MSSQL Server and UNIX.
• 9+ years of concentrated experience in US Health Insurance industry and working with major BCBS licensees.
• Active MBI public trust clearance from OPM.
• Working experience in Affordable Care Act (Obamacare) projects. Worked with EDI files like 834,820 etc.
• Excellent knowledge and experience in data warehouse development life cycle, ETL architecture, designing data marts, requirement analysis, dimensional modeling, implementation of STAR, Snowflake schemas; Incremental loads, Change Data Capture (CDC) and slowly changing dimensions.
• Experience in Data warehouse architecture, in both Kimball and Inmon styles. Database and table design, implementation for data warehouse and related ETL processes. Strong with relational database design concepts.
• Experience in all phases of Data Modeling - Conceptual, Logical and Physical modeling.
• Working experience in different Software Development Lifecycles (SDLC) models like Waterfall Model, Incremental Model and Agile Model.
• Data cleansing experience using Trillium 7.6/6.5 (Converter, Parser, Converter and Geocoder), UNIX Shell Scripting and SQL coding.
• Experience using Oracle 11g/10g/9i/8i/8.0/7.0, DB 2 9.0/8.0/7.0/6.0, Unix, Perl, Shell Scripting, MS SQL Server 2008/2005/2000, MySQL, XML, PL/SQL, SQL*Plus and SQL*Loader, Win 95/98/2000/XP/7, Win NT 4.0 and Sun Solaris.
• Expertise at Enterprise Database Integration and Management among MS SQL Server, Oracle, and DB2.
• Experience in creating Informatica environments for DEV, SIT and PROD environments from the scratch as well as migrating from existing environments.
• Expertise in Informatica PowerCenter Mapping Designer, Workflow Manager, Workflow Monitor, Repository Manager, Informatica Developer, Data Transformation tools while possesses good knowledge on Talend tool.
• Involved in preparing ETL mapping specification documents and Transformation rules for Informatica mappings. Experience in the Logical and Physical Modeling using Erwin 4.2.
• Exclusively worked on different flavors of UNIX and Windows operating systems and good Experience in UNIX shell scripting.
• Trained in HIPAA and PHI regulations and has an extensive knowledge of Individual health insurance for under and over 65 members and of small medium groups.
• Experience in installing, maintaining and supporting Informatica PowerCenter and B2B Data Transformation tools.
• Trained in HIPAA and PHI regulations and has an extensive knowledge of Individual health insurance for under and over 65 members and of small medium groups.

TECHNICAL SKILLS:

Data Warehousing/ ETL: Informatica Power Center 10.2.0/9.x/ 8.6.1/8.1.1/8.0/7.1.2/7.1.1, Informatica Power Exchange, Informatica Cloud, Metadata Manager, Informatica Designer, Workflow Manager, Workflow Monitor, Repository Manager, B2B Data Transformation, Data Quality, Master Data Management, Power Mart, Informatica Power Analyzer, Talend, Pentaho, ETL, Datamart, OLAP, OLTP, Mapplet, Transformations, Autosys.

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 4.5/4.0/3.5/3.2 and Visio.

BI Tools: MicroStrategy, Cognos Series 7.0/6.0, Crystal Reports 8.0, MS Access Reports

Databases: Oracle 11g/10g/9i/8i/8.0/7.x, IBM DB2 UDB 9.0/8.0/7.0, MS SQL Server 2000/7.0/6.0, MySQL.

Programming GUI: SQL, PL/SQL, SQL Plus, Unix, Perl, Shell Scripting, Transact SQL, ANSI SQL.

Environment: Sun Solaris, HP-UX, IBM AIX, MS DOS, Win 3.x/95/98/2000/XP/7, Win NT, Red Hat, Linux.

PROFESSIONAL EXPERIENCE:

Confidential, DC

ETL Lead

Responsibilities:

• Lead the team in developing and designing Facets Enrollment & Billing projects.
• Designing the data stores and modelling the data.
• Responsible for the technical delivery of ETL and Facets Enrollment & Billing Projects.
• Participating and conducting JAD sessions for Functional and Non-functional requirements gathering from business users.
• Prepare Data Flow diagrams, identify major streams like Data Conversion, Historical, Data Retention Archival, Data Quality, Reconciliation
• Worked closely with Development and business managers to evaluate the overall project timeline.
• Worked extensively on Facets enrollment and Billing modules and expertise on Facets data model.
• Identified facts and dimensions from the source system and business requirements to be used for the data warehouse.
• Participated in team meetings and proposed ETL Strategy and provide them best practices.
• Created incremental loads, facts and dimensions, designed new data elements and tables for data marts.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner etc in Informatica Power Center and Informatica Cloud.
• Standardized parameter files to define session parameters such as database connection for sources targets and last updated dates for Incremental loads.
• Performed tuning of Informatica Mappings for optimum performance.
• Extensively used Unix Scripting and Scheduled PMCMD to interact with Informatica Server from command mode.
• Deployment of applications by following the SCM processes.
• Extensively used subversion tool for version controls and deployments.
• Design and develop Informatica Power Center mappings and workflows to transform the data as per the business logic.
• Design and create database tables on Oracle 11g database that are required in the ETL process.
• Develop data transformations and mappings using ETL tools such as Informatica Power Center, Power Exchange.

Environment: Informatica Power Center 10.2.0/9.5.1, Power Exchange, Informatica Cloud Services - Data Integration, Application Integration, Monitor, Oracle 11g, Dimension, Facets application, MicroStrategy, Facets data model, Data Quality, Master Data Management, Data Modelling, shell scripting, Serena NWR, Serena Team Track, SVN Subversion, Tibco, Pega, UNIX Solaris, Mainframe OS 390, Lotus Notes, Microsoft Office, Windows XP Professional/2002, Windows XP/2000.

Confidential, Jersey City, NJ

ETL Architect

Responsibilities:

• Installing Informatica products in Amazon (AWS) windows based cloud servers.
• Working with AWS admin and Database admins to fulfill pre-requisites for Informatica installation.
• Installing, maintaining and supporting Informatica PowerCenter and B2B data transformation tools.
• Creating repository and integration services, maintaining user privileges and deployment activities.
• Creating services for Data Transformation and configuring Data Transformation Studio.
• Setting new DEV, SIT and Training environments for Informatica.
• Migrating objects from existing environments to new environments.
• Worked closely with Development managers to evaluate the overall project timeline.
• Gathering the requirements for the various projects and enhancements
• Participated in team meetings and proposed ETL Strategy and provide them best practices.
• Created incremental loads, facts and dimensions, designed new data elements and tables for data marts in new environment.
• Standardized parameter files to define session parameters such as database connection for sources targets and last updated dates for Incremental loads.
• Performed tuning of Informatica Mappings for optimum performance.

Environment: Informatica Power Center 9.5.1, Power Exchange, B2B Data Transformation, Data Warehousing using MS SQL Server 2012, DB2, PL/SQL, Amazon Web Services (AWS), Subversion.

Confidential, MD

Sr. ETL Consultant

Responsibilities:

• Providing technical and functional Extract Transform and Load (ETL) expertise and guidance as required by the U.S. Department of Health and Human Services management.
• Responsible for system analysis, effort estimation, design, development, unit testing, Implementation and Maintenance of data conversion mappings and ETL processes.
• Design and develop Informatica Power Center mappings and workflows to transform the data as per the business logic.
• Extracting data from the PeopleSoft tables and loading into the target tables by applying the business logic.
• Design and create database tables on Oracle 11g database that are required in the ETL process.
• Participated in team meetings and propose ETL Strategy and provide best practices.
• Gathering the requirements and managing enhancements.
• Worked closely with Development managers to evaluate the overall project timeline.
• Leading development activities for Data conversion and load module.
• Created incremental loads, designed new data elements and tables.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner etc.
• Standardized parameter files to define session parameters such as database connection for sources targets and last updated dates for Incremental loads.
• Created Shell scripts for ETL Execution.

Environment: Informatica Power Center 9.x, Power Exchange, Data Warehousing using Oracle 11g/10g, TOAD, SQL, UNIX, Shell scripting, Utilities like WINSCP, Putty

Confidential, DC

Sr. ETL Developer

Responsibilities:

• Worked closely with Development managers to evaluate the overall project timeline.
• Lead the team in developing Data Warehouse roadmap, strategy and architecture for enterprise data warehouse.
• Participating and conducting JAD sessions for Functional and Non-functional requirements gathering from business users.
• Prepare Data Flow diagrams, identify major streams like Data Conversion, Historical, Data Retention Archival, Data Quality, Reconciliation
• Worked closely with Business managers to understand and the business needs and deliver the projects to meet their needs.
• Worked extensively on Facets enrollment and Billing modules and expertise on Facets data model.
• Identified facts and dimensions from the source system and business requirements to be used for the data warehouse.
• Participated in team meetings and proposed ETL Strategy and provide them best practices.
• Created incremental loads, facts and dimensions, designed new data elements and tables for data marts.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner etc.
• Standardized parameter files to define session parameters such as database connection for sources targets and last updated dates for Incremental loads.
• Performed tuning of Informatica Mappings for optimum performance.
• Extensively used Unix Scripting and Scheduled PMCMD to interact with Informatica Server from command mode.
• Created Shell scripts to automate the Backups, ETL Execution.
• Monitor and communicate the availability of UNIX and Informatica Environment. Follow-up on problem tickets.
• Provided production support by monitoring the processes and Jobs running daily.
• Deployment of applications by following the SCM processes.
• Extensively used Dimensions for version controls and deployments.

Environment: Informatica Power Center 9.5.1/8.6.1, Oracle 11g, Dimension, Facets application, Facets data model, Serena NWR, Serena Team Track, UNIX Solaris, Mainframe OS 390, Lotus Notes, Microsoft Office, Windows XP Professional/2002, Windows XP/2000.

Confidential, IL

Lead/Lead Engineer

Responsibilities:

• Installing, maintaining and supporting Informatica PowerCenter tools.
• Creating repository and integration services, maintaining user privileges and deployment activities.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Designed and developed ETL strategies and Mappings from source systems to target systems. ETL strategies were designed to cater initial and incremental load.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, dynamic Lookup and Router transformations for populating target.
• Performed Informatica Code Migration from Development/Systest/QA/Production.
• Gathering the requirements and Leading the Onshore and Offshore team.
• Standardized parameter files to define session parameters such as database connection for sources targets, last updated dates for Incremental loads and many default values of fact tables.
• Performed tuning of Informatica Mappings for optimum performance.
• Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts. Designed and Deployed UNIX Shell Scripts.
• Monitor and communicate the availability of UNIX and Informatica Environment. Follow-up on problem tickets.
• Managed Change control implementation and coordinating daily, monthly releases and reruns.
• Provided production support by monitoring the processes and Jobs running daily.

Environment: Informatica Power Center 9.1/8.6.1/8.1.1, Oracle 11g/10g, Cognos, Erwin 4.5, Essbase 11.1.1, Business Objects xi, SQL Developer, Autosys, UNIX AIX 5L version 5.1, UNIX Solaris, Linux Red-Hot, Microsoft Office, Windows XP Professional/2002, Windows XP/2000, ClearCase

Confidential, New Jersey

Lead Engineer

Responsibilities:

• Responsible for Power Center and Power Exchange installations, configuring Power Center domain, nodes and integration services.
• Created repository services and repository contents. Restored the repository contents from the backups using Admin console.
• Extensive experience working with repository manager. Was responsible for creating repository users, user groups, giving privileges to the users, granting users with access to the repository folders etc.
• Responsible for creating repository folders and giving access to the users.
• Played a role of Informatica Developer and Lead.
• Created mappings for various sources like Oracle, SQL server, flat files and XML files to load and integrate data to warehouse.
• Developed various mappings, Reusable transformations and validated the ETL logic coded into mappings.
• Extracted data from source systems, transformed as per the business rules specified in the ETL design document and loaded into the staging tables with additional metadata columns.
• Configured High Availability Domain that uses one Primary node and two backup nodes (servers). Also configured a Primary and backup Repository database.
• Monitor and communicate the availability of UNIX and Informatica Environment. Follow-up on problem tickets.
• Managed the privileges of users and folders using Repository Manager and used Informatica Administration Console for Admin activities such as starting / stopping server, upgrading the repository etc.
• Responsible for maintaining repository backups and their restorations.
• Created ODBC connection for importing the source and target definitions.
• Scheduled sessions and work flows using Informatica scheduler and pmcmd command.
• Developed unit test cases and did unit testing for all the developed mappings.
• Install and Configure OBIEE and Essbase on Linux.
• Created Sessions and Workflows to carry out the ETL processes, configured sessions and connection parameters.
• Provided production support by monitoring the processes running daily.
• Worked closely with reporting team and helped them whenever they had any ETL issues.

Environment: Informatica Power Center 8.1.1/7.1, Oracle 10g, Erwin 4.5, Crystal reports, EssBase, SQL server 2005, Transact-SQL, DTS, UNIX AIX 5L version 5.1, Windows XP Professional/2002, Transact-SQL, UNIX AIX4.2, Windows XP/2000.

Confidential

Programmer Analyst

Responsibilities:

• Worked on Informatica Power Center 6.2/7.1 tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplets, and Reusable Transformations.
• Used Informatica Designer designed Mappings that populated the Data into the Dimensions.
• Used Workflow Manager, Repository Manager for Creating, Validating, Testing and running the Batches and Sessions and scheduling them to run at specified time.
• Worked extensively on transformations like Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator and joiner transformations.
• Developed Unix Shell scripts and Perl Scripts to extract and convert data from different legacy systems in databases.
• Generated reports for Underwriting, Claims and Payments, tuned Reporting Queries for faster retrieval time.

Environment: Informatica Power Center 6.2/7.1, Power Mart, Erwin, Business Objects 6.0, Perl, UNIX Shell Scripting, DB2, Mainframes, Microsoft Office, COBOL, Oracle 9i/8i, SQL Server.