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 Informatica 9/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)
• Center for Software Technology (NCST)
• Bachelor of Science (BSC)
• Certified in Informatica PowerCenter 6.0 course

Work Experience

Client: Confidential,Atlanta, GA
(Oct 2011 till present)
Environment: Informatica PowerCenter 9, OBIEE, DAC, Unix, Oracle 11g/ Erwin
This Visual Map Data warehousing project is designed to build a Data Warehouse that keeps inventory of various warehouse locations and displays the real time truck positions and routes on the Google maps. The source data for warehouse is extracted from Networks and Assets (CATS) and Oracle Transportation Management (OTM)

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.

Client: Confidential,Atlanta, GA
(Feb 2011 till Aug 2011)
Environment: Informatica PowerCenter 8.6, Unix, Oracle 10g/SQL Server 2008/ Erwin
This Alere Data warehousing project is designed to build a Data Warehouse that keep track of Alere nurses calling patients.

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.

Client: Confidential,Atlanta, GA
(Feb 2009 till Feb 2011)
Environment: Informatica PowerCenter 8.6/8.5/ Unix/Oracle 10g/ Erwin
This BioSense Data warehousing project is designed to build a CDC Data Warehouse that keep track of epidemics across the nation. The project implemented both star and OLTP schema and size of databases across projects varied from 7-25 terabytes.

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.

Client: Confidential,Alpharetta, GA
(Nov ’08 till Dec ‘08)
Environment: Informatica PowerCenter 8.1/ Unix, Oracle 10g/ Erwin
This Data warehousing project is designed to build a Cox Data Warehouse that keep track of their promotions info and channel lead report info. The project implemented both star and OLTP schema and size of databases across projects varied from 5-10 terabytes.

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.

(Jun ’05 till Oct ‘08)
Environment: Informatica PowerCenter 8.5/8.1/7.1/ Oracle 10g/9i, Unix, Teradata, ERwin
This Data warehousing project was designed to build a ChoicePoint Data Warehouse to load the source data received from various courts in the nation. The data received from courts include Criminal Data (CROSS), Bankruptcy Data (National Data Retrieval) and Foreclosure Data (Real Property). All three projects implemented star schema data models and size of databases across projects varied from 500 GB to couple of terabytes.

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.

Client: Confidential,Atlanta, GA
(Oct \'03 till Jun ‘05)
Environment: Informatica PowerCenter/PowerMart 7.1 Oracle 8i/9i, ERwin 3.5
This Data warehousing project is designed to build a CompuCredit Data Store (CCDS) to load the raw data files from different portfolios of credit card industry. This data is further used to provide Decision Support System to the bankers to take appropriate action on their customers. This was a Star schema model with the main fact table Accounts surrounded by about 20 history tables. The size of this database was around 200 GB.

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.
• Client: Confidential,Atlanta, GA
• (Nov \'01 till Sep \'03)
• Environment: Informatica PowerCenter 6.0/ Oracle 8i
• This Data warehousing project is designed to collect the revenue details across different dimensions such as time, product, Customer service Representative and nine southeastern states. The current size of this database is around 100 Gigabytes in around 25 tables.
• The following tasks are accomplished in this project: -
• Worked as an ETL Developer implementing ETL process for a new Multi channel data mart (MCDM) using Informatica PowerCenter 6.0.
• Migrated the existing pl/sql code and pro*C programs to new informatica mappings.
• Performance tuned the mappings to finish the job in 2.5 hours from earlier 6 hours, well ahead of the deadline time, 7:00 AM.
• Developed PL/SQL stored procedures to integrate the \'CHARGEBACK\' logic in daily loads. Charge back procedure is executed to offset the outgoing revenues from the Rep\'s who took the outgoing orders and charging those Rep\'s who initially took the incoming orders.
• Developed a PL/SQL stored package ranking, which gives the credit of the order to the correct vendor.
• Client: Confidential,Cincinnati, OH.
• (March \'99 to Oct \'01)
• Cognos / OLAP / Data Warehousing
• Environment: Oracle 8i, Cognos Impromptu, Cognos Power play, Cognos Transformer
• The OLAP Project is to provide various reports to the top-level management as a “Decision Support System” & to the individual Manager regarding the transaction volume and revenue details by Shops, Engine Models, Customers and Contracts. Led the offshore development team of seven people to meet the deliverables on time. Worked with various plants to get the required data for MTW from respective source systems
• The following are the tasks accomplished during this project:
• Enhancements to Data models using Erwin.
• ETL was carried out thru SQL, PL/SQL Procedures, PRO*C, Unix scripting and SQL*LOADER for various OSB (Order Shopping Billing) shops.
• Developed programs to populate data in Data Marts using PL/SQL.
• Built Impromptu queries and Power Play Transformer cubes based on the Data Mart data.
• Developed SQL, PL/SQL programs to keep the Master and lookup tables up to date on a daily basis. Automated this process using Appworx scheduler.
• Developed a PL/SQL stored package to log the status of each program in daily nightly loads giving full details on records processed, updated, inserted, deleted, successful completion and error messages with start and end timings.
• Mapped the data between Source system tables and Staging Area tables and between Staging Area tables and Central Data Warehouse tables.
• Developed SQL*LOADER control files to load the data from data files into Staging Area (SA).
• Performing Data Base Administrative activities like creating table spaces, users, tables, indexes, views, synonyms, managing and monitoring the table space, taking exports and imports, granting and revoking the user permissions and troubleshooting.
• Developed PL/SQL programs to massage and scrub the data into Staging Area with the help of Lookup tables and Master tables and finally transferred the data from Staging Area to Central Data Warehouse.
• Creation of new catalogs, IQD\'s, Impromptu Reports, IWR, Power play Transformer cubes and Power play Reports.
• Creation of drill down reports to provide the details till the Part level data.
• Creating Users, Roles, Profiles and Granting and revoking the privileges to the Users.
• Involved in Application performance and Tuning using Explain Plan and Tkprof, creation of Indexes and putting the where clause in the right order.
• Creating daily backup and recovery scripts for hot backups and Cold backups and Export and Import and Schedule the backup scripts.
• Designed and developed Web reports using Java, Java servlets, Java Server Pages (JSP) and HTML.
• Involved in documenting my jobs at a summary level and detail level.
• Client: Confidential,Miami, Florida
• (April \'98 to February \'99)
• Implemented "Shipboard Management Systems" , "IN-CABIN CALLING" (Billing for calls made from ship cabins) and "SEA-VISION" (Billing for movies rented and food and drinks ordered by guests from their cabins).
• The following are the tasks accomplished during this project:
• Developed a PRO*C program "IN-CABIN CALLING" for billing the calls made from ship cabins.
• Developed a PRO*C program "SEA-VISION" for billing the movies rented and food and drinks ordered by guests from their cabins.
• Client : Confidential,
• (December \'97 to March \'98)
• Implemented design development and maintenance of NLC (NATIONAL LEAGUE OF CITIES) Data conversion.
• The following are the tasks accomplished during this project:
• Loading data for NLC using SQL*LOADER and PRO*C programs.
• Creation of views, Indexes, procedures, functions, packages, database triggers and UNIX Shell scripting.
• Developed C++ program for the Object oriented designing and programming module.
• Client: Confidential, (August \'96 to November \'97)
• Implemented maintenance of "Sales And Hire Purchase Accounting System. All the development was done using software development methodology ISO9001.
• The following are the tasks accomplished during this project:
• Developed/modified forms 4.5 and Reports 2.5 (Developer 2000).
• Client: Confidential,
• (October \'90 to July \'96)
• All the development was done using software development methodology ISO9001.
• Implemented maintenance of "Shares And Debentures Accounting System ". Was responsible for executing various warrants processing, buyback of debentures, splits of shares and debentures and sub division processing modules.