PROFESSIONAL SUMMARY:

• 14+ years of experience in analysis, design, development and maintenance in IT industry.
• 10 years of extensive experience in Data Warehouse applications using Informatica, Oracle, DB2, MS SQL server on Windows, IBM and UNIX platforms.
• Experienced to work in Development team, Production support teams in handling critical situations to meet the deadlines for successful completion of the tasks/projects.
• Excellent interpersonal and communication skills, technically competent and result - oriented with problem solving skills and ability to work independently and use sound judgment.
• Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using Informatica Power Center 9.x/8.x/7.x ETL tool.
• Good Knowledge on Star Schema/Snowflake Schema, OLAP tools, Fact and Dimensions tables, Physical and logical data modeling
• Experienced in Repository Configuration/using Transformations, creating Informatica Mappings, Maplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
• Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Expertise in scheduling Informatica jobs using Control-M
• Experienced in working for the post development cycle and applications in Production Support.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.6/9.5.1/ 9.6. x

Operating Environment: Unix(solaris) 9.0, AIX 5.2,MS Windows 95/98/NT/2000/XP, HDFS

RDBMS Tools: TOAD 7.x/8.5, SQL Developer

Databases: Oracle 11g/10g/9i/8i, DB2, SQL server 2000

Reporting Tools: Discoverer, OBIEE

Languages: SQL, PL/SQL, COBOL, JCL, VSAM, Java

Scripting: Unix shell scripting

Big Data: Hadoop, Map Reduce, Hive, Pig, Sqoop

Scheduling Tools: Control: M, CA7

Graphics / Tools: MS: visio. HP ALM (Quality Center)

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Lead ETL Developer

Responsibilities:

• Automated the review process of ETL workflows by developing Unix scripts, resulting in reduced post production issues and review effort
• Processed unstructured data by designing optimum ETL process and reducing the processing time from 2.5 hours to few minutes.
• Created a generic process to build extract files that was used to produce ~30 extract files (of different layout) to be sent to various entities, thereby saving the budget to be used for other work.
• Designed the data model for CHOICE business and developed the ETL process to efficiently build the dimension tables for the data mart.
• Data Analysis, cleansing, loading data, data modeling using tools and technologies such as Informatica Power Center, Informatica Data Quality, Informatica Analyst, Oracle 11g (and other RDBMS), Erwin (and other data modeling tools), etc.
• Support QA testing, Integration testing, User Acceptance testing and production go live.
• Lead a team of 6 to migrate the reporting platform from Discoverer to OBIEE
• Coordinate and trouble shoot issues between different functional and technical teams.
• Created training material for users whenever needed.
• Worked with complex mapping using transformations such as Expression, Router, Lookup, sorter, Filter, Joiner, SQ, Stored Procedures and Aggregator.

Environment: Informatica Power Center 9.6, Oracle 11g/12c, Windows 7, UNIX shell scripting, PL/SQL, OBIEE, Control-M, SVN, Toad

Confidential, Lexington, MA

Sr. ETL Developer

Responsibilities:

• Assisted Business Analyst with drafting the requirements, implementing design and development of various components of ETL for various applications.
• Worked exclusively on performing the ETL to Level 1 as is staging, Level 2 staging, DW load based on the business rules and transformation specifications.
• Analyzed requirements from the users and created, reviewed the specifications for the ETL.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Created Complex ETL Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and unconnected lookups, Filters, Sequence, Router and Update Strategy
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.

Environment: Informatica Power Center 9.5, Oracle 11g, Windows 7, Flat files (fixed width/delimited), MS-Excel, UNIX shell scripting. Tidal, Cognos, Toad, SQL Developer

Confidential

Sr. ETL Developer

Responsibilities:

• Comprehensively analyzed and systematically documented the end-to-end flow of the Inbound and Outbound claims file (834 HIPAA). Informatica B2B
• Extensively Worked in Processing Structured and Unstructured data.
• Resolved the anomalies arising in the file processing across individual stages of data flow.
• Designed, Developed and unit tested the ETL process for loading the Medicaid/Medicare records across STAGE, LOAD and ACCESS schemas.
• Accomplished the Provider directory load (a five-step sequential process) using Informatica for the states of AZ and FL.
• Extended the functionalities of existing ETL process of Medicaid for Medicare.
• Extensively worked on the transformations like Source Qualifier, Filter, Joiner, Aggregator, Expression and Lookup.
• Used session logs, workflow logs and debugger to debug the session and analyze the problem associated with the mappings and generic scripts.
• Maintained documents for Design reviews, Engineering Reviews, ETL Technical specifications, Unit test plans, Migration checklists and Schedule plans.

Environment: Informatica Power Center 8.6, HIPPA5010, SQL server 2000, Oracle 10g, Windows NT,VB, Flat files (fixed width/delimited), MS-Excel, UNIX shell scripting.

Confidential

Sr. Consultant, Data Warehousing

Responsibilities:

• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems(oracle 10g,DB2,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Have generated reports using OBIEE 10.1.3 for the future business utilities.
• This role carries primary responsibility for problem determination and resolution for each SAP application system database server and application server.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Constantly interacted with business users to discuss requirements.

Environment: Informatica PowerCenter Designer 8.6/8.1, Informatica Repository Manager, Oracle10g/9i, DB2 6.1, Erwin, TOAD, SAP Version: 3.1.H,Unix- SunOS, PL/SQL,SQL Developer

Confidential

Consultant, Data Warehousing

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data
• Consolidation, standardization, matching Trillium for the unstructured flat file data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 8.5.
• Experience in integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Improved session Performance by enabling property incremental aggregation to load incremental data into target table.
• Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
• Copied/Exported/Imported the mappings/sessions/ worklets /workflows from development to Test Repository and promoted to Production.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.
• Used PMCMD command to automate the Power Center sessions and workflows through UNIX.

Environment: Informatica Power Center 8.5, Oracle 10g, SQL Server 2005, DB2, SQL*Plus, SQL Loader, SQL Developer, Autosys, Flat files, UNIX, Windows 2000

Confidential

Associate Consultant, Data Warehousing

Responsibilities:

• Gathered business requirements from Business Analyst.
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.
• Designed and developed Informatica ETL mappings to extract master and transactional data from heterogeneous data feeds and load
• Installed and Configured the Informatica Client tools.
• Worked on loading of data from several flat files to XML Targets.
• Designed the procedures for getting the data from all systems to Data Warehousing system.
• Created the environment for Staging area, loading the Staging area with data from multiple sources.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Created UNIX shell scripts for Informatica ETL tool to automate sessions.
• Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.

Environment: Informatica Power Center 5.1.2/7.1, Erwin 4.5, Oracle 9i, Windows NT, Flat files, SQL, Relational Tools, Clear Case, UNIX (HP-UX, Sun Solaris, AIX) and UNIX Shell Scripts.