SUMMARY

• Over 10 years of IT experience in Software Analysis, Design, Development, Implementation of data warehousing solutions.
• Excellent knowledge of various Software Development Life Cycle (SDLC) methodologies including Waterfall, Agile, Rational Unified Process (RUP)
• Experience in analyzing Star/Snow Flake schema, Dimensional Data Modeling, Logical and Physical Data Modeling.
• Extensive development experience for the Extraction, Transformation and Loading of data from multiple disparate sources such as Oracle 10g/9i/8i, MS SQL Server, DB2, Flat Files, XML Files into ODS (Operational Data Store) and EDW (Enterprise Data Warehouse) systems
• Experience on working with Claims/Member data from the FACETS system
• Experience in working with PL/SQL stored procedures, triggers, cursors and working with complex SQL queries.
• Used Data transformation Studio 9.5/9.1 to create scripts that converts complex data formats in to standard ones and then Integrate to Informatica standard platform
• Experience processing HIPAA EDI Format files (837,277,999 Files) using Informatica B2B
• Experience in maintaining the data warehouse using Informatica Power Center Client tools - Designer, Repository manager, workflow manager/monitor.
• Expertise developing Complex ETL mappings with varied transformation logics like Connected and Unconnected Lookups, Router, Aggregator, Joiner, Update Strategy etc..
• Expertise in performance tuning of transformations, mappings, targets, workflows and sessions.
• Excellent hands on experience in UNIX and writing Shell scripts for Informatica pre & post session operations and database administration activities
• Excellent communication and interpersonal skills, good analytical reasoning and ability to learn quickly, high adaptability to new technologies and tools.

TECHNICAL SKILLS

ETL Tools: InformaticaPower Center 9.5/9.6/8.6/8.1/7.1 (Repository Manager, Designer, Work Flow Monitor, Work Flow Manager)

Reporting Tools: Cognos 8.4/7.0

Databases: Oracle 10g/9i/8i/7.x, SQL Server 2008/2005/2000, Teradata 13.0,SYBASE

Data Modeling: Erwin 7.2/4.0

Programming: PL/SQL,BTEQ Scripts, Unix-Shell Scripting

Tools: TOAD, Visio, DB Artisan for SYBASE

Operating Systems: UNIX(Sun Solaris 2.x,HP/UX), Win 95/NT/98/2000/XP

Scheduling Tools: Tidal, Autosys

PROFESSIONAL EXPERIENCE

Confidential, Irving, Texas

SR ETL INFORMATICA CONSULTANT /LEAD

Responsibilities:

• Analyzed the business and functional requirements and provided high level technical design specifications to drive ETL Development efforts.
• Lead Development team of 8 developers
• Assigning tasks
• Prioritizing tasks
• Enforcing Project process and Policies
• Helping to formulate estimates and timelines for project activities
• Acting as technical mentor to developers
• Perform code reviews to ensure coding standards have been followed
• Update Project status to the Management in Daily scrum meetings
• Create weekly status reports to share with client Managers
• Created CNR’s and Managed QA and PROD deployments.
• Provided assistance in diagnosing production Issues related to the project.

Environment: Informatica Power Center 9.5/9.6,Oracle 10g/Facets 4.7, Teradata 14.10, Tidal Scheduler 5.3, Mercury Quality Center

Confidential, Virginia Beach, VA

SR ETL INFORMATICA CONSULTANT /LEAD

Responsibilities:

• Analyzed the business and functional requirements and provided high level technical design specifications to drive ETL Development efforts.
• Designed and developed ETL mappings using various transformations for populating target tables/Files in an efficient manner.
• Created projects,parsers,serializers in DT Studio for processing HIPAA EDI format files in DT studio
• Developed complex ETL mappings to process various HIPAA EDI files (837,999,277) using UTD and XML trasnformations
• Designed and developed ETL workflows with job dependencies and scheduling.
• Participated in code reviews of ETL processes.
• Developed BTEQ scripts to move data from staging layer to final Analytical layer.
• Implemented Error handling logic to capture Invalid/Null records coming from staging tables.
• Tuned and optimized ETL jobs for performance and throughput.
• Created test plans for unit testing, integration testing and UAT.
• Developed SQL Scripts and ad-hoc queries for data verification and validation processes.
• Managed QA and PROD deployments.
• Developed Tidal jobs to automation ETL process.
• Provided assistance in diagnosing production problems related to the project.

Environment: Informatica Power Center 9.1/ Power Exchange 9.1,Oracle 10g/Facets 4.7, Teradata 13.10, Tidal Scheduler 5.3,Mercury Quality Center

Confidential, West Norriton, PA

SR ETL INFORMATICA CONSULTANT /LEAD

Responsibilities:

• Gathered user requirements and reporting requirements for a better understanding of the business process and the current reporting system
• Analyzed the source data that is in the form of Oracle tables, Sequential files and Excel sheets.
• Designed and developed mappings in Power Center to accommodate business requirements for data extraction, transformation and loading.
• Developed various complex Informatica mappings based on the business requirements that read from the source, make the necessary transformations and load into the target database tables, using the various database and transform components, along with surrogate Key’s.
• Designed ETL jobs for extracting data from heterogeneous source systems, transform and finally load in to data marts.
• Fine-tuned sources, targets, mappings and sessions to improve the performance.
• Used Workflow Manager for creating, validating, testing and running sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases
• Developed Pre-Session and Post-Session UNIX scripts to automate the data load processes to target Data warehouse
• Maintained the backup of all the source flat files, which get loaded every day in the production server.
• Experience in creating the migration documents to migrate the Informatica, UNIX and PL/SQL code using PVCS.
• Performed Unit testing and Regression testing for Informatica mappings and workflows in both development and QA environments.
• Developed Oracle Views to transfer the data in to PBViews Application.

Environment: Informatica Power Center 8.1, Cognos 8.4, Flat files, XML,Oracle 10g, SQL Server 2005, PL/SQL Developer 8.0, Unix,PeopleSoft 8.4,Smart FTP Client, DBArtisan(for SYABSE)

Confidential - Owings Mills, MD 

SR ETL INFORMATICA CONSULTANT /LEAD

Responsibilities:

• Understanding the overall system and the existing data-model in the data warehouse.
• Actively involved in the Design and development of the STAR schema data model.
• Designed ETL specification documents to load the data in target using various transformations according to the business requirements
• Created Visio diagrams of ETL process to include in the design documents.
• Created check-lists for coding, reviewing, bug logging, troubleshooting, testing and release for smooth functioning of the entire project.
• Extensively worked withInformaticaPower Center 8.1to load data from flat files, oracle and other source systems into target database
• Developed complex mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, and Rank.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Scheduling the sessions to extract, transform and load data in to warehouse database on Business requirements.
• Written Unix Scripts to invoke Informatica Workflows and sessions.

Environment: Informatica Power Center 8.1, Erwin - 4.0,Flat files, Oracle 10g/9i, TOAD 9.x, PL/SQL,Facets 4.5 and Unix.

Confidential - Mason, OH

 ETL Developer

Responsibilities:

• Designed and developed Star Schema and created Fact and Dimension Tables for the Warehouse using Erwin
• Created High level technical design documents.
• Used Informatica Designer to create mappings using different transformations to move data to Oracle Data Warehouse.
• Developed complex mappings in Informatica to load the data from various sources into the Oracle Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, and Rank.
• Responsible for creating different sessions and workflows to load the data to Data Warehouse using Informatica Workflow Manager.
• Involved in identifying the bottlenecks in Sources, Targets & Mappings and accordingly optimized them.
• Involved in using the Stored Procedures, Functions and Triggers at Data Base level and imported them in Informatica for ETL.
• Extensively used SQL * Loader for Bulk loading from Flat Files to Oracle Tables.
• Involved in generating various reports using Cognos 7.0.Designed and developed Impromptu reports.
• Extensively used command, event-wait, event-raise and control tasks for keeping track of events in the ETL process.
• Created UNIX shell script to FTP flat files from different ordering systems to the ETL server.
• Exported 24/7 Support for the Production of Daily, Weekly and Monthly refresh for Production OLAP instance

Environment: Informatica Power Center 7.1/8.1, SQL Server 2000, Flat files, Oracle 9i, UNIX, Erwin 4.0, TOAD, Ultra Edit, Cognos 7.0.