Summary:

Over 21+ years of professional experience in Software Development Life Cycle (SDLC), Data warehousing and the implementation of various Business applications. Over 12+ years of Informatica ETL Development. Have a wide variety of experiences in various capacities across different industries such as Telecom, Sales, Hire Purchase, Manufacturing, Finance, Ship Board Management, Airline, Credit Cards and sensitive data Industry.

• Extensive working knowledge in Data warehouse ETL activities using Informatica9/8.6/8.5/8.1/7.1/6.2.
• Working knowledge of Informatica Administration like installation, troubleshooting, maintaining user/group privileges and migrating objects from Dev to QA and QA to Production using Repository Manager export/import.
• Proficient in Oracle 10g / 9i / 8i / 7.x / 6.x, OLAP/OLTP, Data Mart, Data warehousing, SQL Server, Teradata and Oracle Data Base Administration.
• Proficient in Data warehouse ETL activities using SQL, PL/SQL, PRO*C, SQL*LOADER, C, Data structures using C, Unix scripting, Python scripting and Perl scripting.
• Proficient with Star schema and Snowflake schema Data warehouse models using Ralph Kimball/ W. H. Inmon methodologies.
• Working knowledge in Oracle Backup and recovery, imports and exports, performance-tuning, creation of Oracle objects, analyzing objects and monitoring and estimating the table space for oracle tables and indexes.
• My work authorization is US citizen.

Technical Environment

• Hardware:
• SUN Sparc Ultra-enterprise Server, HP9000 Series UNIX server, SGI3200 UNIX server and IBM RISC 6000 Iris server.
• Database:
• Oracle 10g/9i/8i/7.x/6.0/5.0
• MS-Access
• Teradata
• SQL Server
• Data warehouse and WEB Development Tools:
• Informatica PowerCenter 8.1/7.1/6.2
• Python, JAVA, HTML, Servlets and JSP.
• Client Server Development Tool, Programming Languages and Designing tools:
• UNIX, Sun Solaris-OS, AIX, Windows vista/ Windows XP/ Windows 98/ Windows95, MS-Windows/MS-DOS
• Developer 2000 (ORACLE FORMS 4.5 & ORACLE REPORTS 2.5), SQL*Plus, PL/SQL, SQL*FORMS 3.0, Pro*C, SQL Loader and Oracle database Triggers and packages.
• C, Pascal, Data structures and algorithms using C.
• Unix Shell scripts
• Python scripts
• Linux scripts
• Perl scripts
• SQL Navigator, Microsoft Query, TOAD & Oracle Procedure Builder.
• Visual Source Safe (VSS), PVCS (Polytron Version Control System) and DTS (Defect Tracking System)
• ERwin
• Microsoft Visio

Education

• Post Graduate Diploma in Software Technology (PGDST)
• Bachelor of Science (BSC)

• Member of ToastMasters Alpharetta club for improving my leadership skills.
• Teaching Hindi language to kids at Balvihar.

Work Experience

Confidential, Atlanta, GA
(Oct 2011 till present)

The following tasks are accomplished in this project: -

• Working as an ETL Lead implementing ETL processes to design/develop/test/install/migrate/troubleshoot various ATT mappings.
• Designed the Data warehouse using Ralph Kimball methodologies.
• Created oracle tables/indexes as required for the CATS/OTM data in the data warehouse.
• Installed DAC and scheduled Informatica jobs form it.
• Led 2 on shore and 4 offshore developers on the project.
• Performed code reviews for my team.
• Provided guidance to the team for performance tuning/ troubleshooting.
• Made sure the team delivered the deliverables, reviewed their codes, followed the ETL standards and helped them whenever they were looking for help.
• Designed and developed entire CATS datawahouse and OTM data warehouse for ETL implementations.
• Designed and developed the error handling routines.
• Designed, developed, unit tested and documented various type 2 mappings like Parts/Locations/Project.
• Developed SQL, PL/SQL programs and performance tuned the programs.
• Performed performance tuning of Informatica maps for more efficient loads.
• Developed efficient sql, pl/sql programs and also used with/merge statements for efficient on the fly upsert strategies.
• Developed OBIEE RPDs and create reports using BI Answers.
• Developed BI reports with mapping capabilities using Oracle map builder integrated in OBIEE.

Confidential, Atlanta, GA
(Feb 2011 till Aug 2011)

The following tasks are accomplished in this project: -

• Working as a Lead ETL Developer implementing ETL processes to design/develop/test/install/migrate/troubleshoot various Alere mappings.
• Designed the Data warehouse using Ralph Kimball methodologies.
• Developing the source deletes logic for the entire warehouse.
• Designed, developed, unit tested and documented various type 2 mappings for the Apollo Stage five area.
• Developed SQL, PL/SQL programs and unit tested them.
• Mentored other developers on Informatica 8.6 and reviewed their code.
• Performed performance tuning of Informatica maps for more efficient loads.
• Designed and developed complete ETL solutions on different projects.

Confidential, Atlanta, GA
(Feb 2009 till Feb 2011)

The following tasks are accomplished in this project: -

• Working as an ETL Lead/Informatica Admin implementing ETL processes to design/develop/test/install/migrate/troubleshoot various BioSense processes to collect epidemic details across the nation.
• Managing two other resources on this project.
• This Data warehouse design was developed using star schema/ Ralph Kimball methodologies.
• Helping other Informatica resources trouble shoot any problems they might have.
• Assigning work to other resources and making sure the project is delivered on time.
• Installation of Informatica 8.5 on staging/ LAB box.
• Troubleshooting of various errors while installation/ production run/ Data issues.
• Design modifications of the BioSense Data model using Erwin.
• Loading XML messages received from various hospitals across the nation into Database using JMS JBOSS queues/Informatica.
• Added new maps like Message_Observation to the BioSense process.
• Fixing bugs on different mappings to have a more accurate data for the next BioSense release.
• Used Informatica’s built in version control system for source code management.
• Used source side, target side and full pushdown optimization to improve session performance.
• Involved in Informatica Admin work like installation, migrating workflows and mappings from Dev to staging/ Lab Box/Production using Repository Manager and managing user and group privileges on Informatica Folders.
• Performance tuning various maps and SQL, PL/SQL programs to have a better throughput of data received from various hospitals across the nation.
• Developed Korn Shell scripts to move, archive source/ target files.
• Developed some PL/SQL procedures for mass deletes/updates.
• Have some exposure to OBIEE.

Confidential, Alpharetta, GA
(Nov ’08 till Dec ‘08)

The following tasks are accomplished in this project: -

• Worked as an ETL Lead implementing ETL process to fix the C2O site error fix.
• Designed, developed, unit tested Sales Promotions dimension maps.
• Designed complex star schema architecture for Channel Lead Report from Channel Lead Report OLTP schema.

The following tasks are accomplished in this project: -

• Implemented ETL process for CROSS mappings for source data received from courts in Texas Brazoria, Colorado Denver, Texas Elpaso, Kentucky and Nebraska using Informatica PowerCenter 8.1.
• Delegated tasks to offshore team and made sure they were completed on time.
• Performed source data analysis before development and interaction with Business Analysts.
• Created Technical specification and Source to Target mapping documents.
• Used various maps/session performance tuning techniques including parallel pipeline session partitioning.
• Designed and developed ETL architecture for Real Property database in 3NF.
• Performed historical/incremental loads on Real Property database.
• Developed reusable transformations, mapplets and worklets to reduce development efforts whenever possible.
• Used First Logic Name and Address parsers in lot of maps.
• Developed and unit tested reusable transformations for name and address parsing.
• Developed CROSS error handling logic/ reprocess generic map to load manually rectified error data for any court.
• Led a team of four other developers and helped them with technical issues.
• Developed slowly changing dimension mappings.
• Developed complex LANDFLIP report for FBI to give them a list of property owners who flipped their properties to minimize taxes.
• Developed Death Master report to let the Government know about the Dead people in the country to avoid SSN frauds.
• Developed Unix scripts to automate the load process, restart from failure points, Unix workflow scripts to be called from ControlM scheduler and move, archive source/ target files.
• Developed various transformations in the mappings like Source Qualifier, Expression, Union, Filter, Sorter, Aggregator, Joiner, Lookup, Router, Sequence generator, Transaction Control, Update Strategy, Stored procedure, External Procedure and Normalizer transformations.
• Unit tested and peer tested the mappings and workflows and fixed the bugs.
• Designed and developed Bankruptcy customer outputs (PADR/Express financial) and was responsible in providing them monthly output files promptly in required output formats.
• Encrypted and secured FTP the sensitive public data to both internal and external customers.
• Used the $$PushdownConfig Mapping Parameter to do source-side, target-side, or full pushdown optimization at different times, depending upon the database workload.
• Debugged maps using Debugger and Transformation’s verbose data.
• Developed command tasks, email tasks, decision tasks and timer tasks in Workflow manager.
• Created Unit testing, QA migration and Production Turnover documents.
• Involved in Informatica Admin work like migrating workflows and mappings from Dev to QA and QA to Production using Repository Manager and managing user and group privileges on Informatica Folders.
• Followed development standards like ChoicePoint’s object naming conventions, short cuts to sources, targets, source anchors, target anchors and a brief documentation on each transformation that I developed.
• Involved in production support for nightly loads.

Confidential, Atlanta, GA
(Oct \'03 till Jun ‘05)

The following tasks are accomplished in this project: -

• Worked as a Sr. ETL Developer implementing ETL process for CCDS migration (Also known as TrueNorth) using Informatica PowerCenter/PowerMart 7.1.
• Designed, developed and unit tested type 1 and type 2 mappings to load the data in CCDS star schema.
• Developed and unit tested the main Accounts fact table of this data warehouse.
• Developed an accounts persistent cache mapping to improve the performance across all other type 2 mappings.