CAREER SUMMARY:

• Almost 9 years of experience in analyzing, designing, developing, testing, implementing and maintaining ETL systems
• Experience in developing ETL applications using Informatica PowerCenter to integrate data into data warehouses, data marts, and operational data stores
• Experience in integrating data to/from relational databases such as Oracle, SQL Server, DB2, Teradata, PostgreSQL & applications such as SAP, Salesforce, NetSuite, OpenAir & Flat files such as XML, CSV.
• Experience in Informatica PowerCenter administration
• 7+ years of work experience in USA
• Experience in working on data conversion/migration, data warehousing and operational data store projects
• Worked in business domains such Telecommunications, Utilities, Health Insurance, Financial Services, Metals Manufacturing, Financial Software, Virtualization Software, & Data and Storage Networking
• Good understanding of database, data modeling, & data warehousing concepts
• Experience in working, coordinating, and monitoring in an Onshore - Offshore model
• Excellent analytical, problem solving, communication, and interpersonal skills

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter v10.1/9.5/8.x/7.x/5.x, Informatica PowerExchange v9.1/8.x, Informatica Cloud

Languages: SQL, PL/SQL, UNIX Shell, Perl, C, C++, VB, VC++, Java, COBOL

Databases: Oracle 11g/10g/9i, Teradata v15/v2R5/v2R6, DB2 for iSeries V7R1M0/V6.x/V5.x, Sybase ASE v11.9.2, MS SQL Server 2008 R2, SAP, Greenplum, MS-Access

Database Tools: TOAD, AQT v8.x, SQL Navigator v4.x, PL/SQL Developer v7.1, SQL Server Management Studio 10.5, Teradata SQL Assistant, Golden, WinSQL 7.5, pgAdmin 1.18

Database Utilities: SQL*Loader, Teradata-BTEQ, MLoad, FastLoad, TPump, FastExport, BCP

Other Tools: MS Visio, MS Office, PuTTY, CORE FTP, Text Pad, Ultra Edit, Maestro, Altova XML Spy, HummingBird Connectivity v7.1, Mercury Quality Center 9.0, WinSCP 5.7.3, Perforce Visual Client, Control-M, WLM

Operating Systems: Windows XP Professional/2000, AIX v6.1/5.x, Red Hat Linux v5.4/5.7

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, Virginia

Lead Developer

Responsibilities:

• Analyze change requirements and design solutions
• Create business specification & technical detail documents based on the business requirements
• Develop history and incremental code fixes
• Ensure all code products are thoroughly tested
• Document design changes, test results, & release information
• Deliver tasks as per the Agile development framework
• Coordinate work with offshore development team

Technologies: Informatica PowerCenter 10.1.1, Teradata v15, Teradata SQL Assistant, IBM WLM, Control-M

Confidential, Columbus, Ohio

Sr. ETL Consultant/Programmer Analyst

Responsibilities:

• Develop tasks in ETL/Informatica, DAC & PL/SQL
• Analyze new requirements and design solutions
• Ensure all code products are thoroughly tested
• Document design changes, test results, & release information
• Deliver tasks as per the Agile development framework
• Update change request tickets accordingly on Serena Business Manager

Technologies: Informatica PowerCenter 9.0.1, DAC 11.1, Oracle, Toad for Oracle Base 11.0, WinSCP 4.2.9, Serena Business Manager, Trello

Confidential

Sr. Informatica Developer

Responsibilities:

• Worked on new development and enhancement requests as per business requirements
• Migrated code between development, QA, & UAT environments
• Performed unit & system testing
• Executed & monitored on demand, daily, & monthly loads
• Documented new development, enhancements and load schedule information
• Fine tuned performance and fixed production issues
• Delegated, monitored & reviewed code assigned to junior team member

Technologies: Informatica PowerCenter 9.5.1, SQL Server 2008 R2, SQL Server Management Studio 10.5, NetSuite, Blackline, OpenAir, WinSCP 5.7.3

Confidential

Sr. Informatica Developer

Responsibilities:

• Worked on enhancement requests as per business requirements
• Worked on Integrating data to Salesforce using Informatica Cloud
• Migrated code between development, QA, & UAT environments
• Performed unit & system testing

Technologies: Informatica PowerCenter 9.5, Informatica Cloud, Oracle 11g, Salesforce, Toad for Oracle Base 11.5, PuTTY 0.64, WinSCP 5.7.3

Confidential

Sr. Informatica Developer

Responsibilities:

• Developed mappings & workflows to ETL data using Informatica PowerCenter
• Prepared deployment document for code migration
• Migrated code between development, QA, & UAT environments
• Performed unit & system testing
• Validated the correctness of the reports by comparing actuals with the expected results
• Coordinated with onsite development team

Technologies: Informatica PowerCenter 9.1, Greenplum, pgAdmin 1.18, MS SQL Server 2008, SQL Server Management Studio 10.0, Oracle 11g, Toad for Oracle Base 11.5, PuTTY 0.64, WinSCP 5.7.3, Perforce Visual Client, Windows 7 Enterprise

Confidential, Boise, Idaho

Sr. ETL Developer

Responsibilities:

• Developed mappings & workflows to ETL data using Informatica PowerCenter
• Integrated SAP data using PowerExchange for SAP
• Installed SAP RFC SDK libraries to enable configuration to SAP source data
• Connected to SAP sources through program modes such as file mode & stream mode
• Modified the system generated ABAP queries while generating/installing the SAP R/3 code to include additional filter conditions to extract data from SAP sources
• Developed Perl script to automate loading source extracts in to staging area
• Coordinated work with offshore development team
• Fine-tuned the performance of workflows
• Performed unit and integration testing

Technologies: Informatica PowerCenter 9.1, Informatica PowerExchange 9.1, Oracle 10g, MS SQL Server 2008, SAP, Windows XP Professional

Confidential, Allen, Texas

Sr. ETL Developer/Informatica PowerCenter Administrator

Responsibilities:

• Installed and upgraded Informatica PowerCenter server & PowerExchange client on Linux server
• Administered users, folders and migrated code using Informatica repository manager and Informatica administrator
• Created a grid environment for Informatica server to run sessions on 3 nodes to improve the performance of the workflows
• Worked with Informatica technical support on resolving several service requests
• Developed Perl and Unix shell scripts to validate, cleanse, format and organize data
• Automated the data landing routines using Perl and Unix shell scripts
• Documented issues & challenges faced during data landing to avoid issues in the future
• Developed mappings & workflows to ETL data using Informatica PowerCenter
• Developed Unix shell scripts to execute workflows in batch using PMCMD
• Fine tuned the performance of the sessions by creating partitions both static and dynamic to improve run time
• Performed unit testing, system testing and mock conversions

Technologies: Informatica PowerCenter 9.1/8.x, Informatica PowerExchange 9.1/8.x, DB2 for iSeries V7R1M0, Oracle 11g, PQL/SQL Developer v7.1, Red Hat Enterprise Linux Server v5.7, Windows XP Professional, Mercury Quality Center 9.0, Core FTP, PuTTY

Confidential, Johnston, Iowa

Sr. ETL Developer

Responsibilities:

• Developed mappings & workflows to ETL data using Informatica PowerCenter
• Developed shell script to monitor the arrival of the RMA processed files and start loading the data in to staging area if received
• Fine tuned mappings if necessary to improve the load time
• Performed unit testing to test the correctness of the code

Technologies: Informatica PowerCenter 8.6, Informatica PowerExchange 8.6, DB2 for iSeries, WinSQL 7.5, IBM System iAccess Navigator 6.1, Windows XP Professional, Mercury Quality Center 9.0, Core FTP, PuTTY, Ultra Edit

Confidential, Rochester, New York

Sr. ETL Developer

Responsibilities:

• Developed Perl and Unix shell scripts to validate, cleanse, and organize source extracts
• Developed Perl scripts to convert Telecordia files into XML files
• Created XSD files and parsed the XML files using Altova XML Spy
• Extracted data from XML files and loaded into staging tables using XML Source Qualifier transformation
• Created and managed users, folders and have set privileges using Repository Manager
• Automated the landing routines using Perl and Shell scripts
• Documented issues & challenges faced during data landing to avoid issues in the future
• Developed mappings & workflows to ETL data using Informatica PowerCenter
• Developed Unix shell scripts to execute workflows in batch using PMCMD
• Fine tuned the performance of workflows
• Performed unit testing, system testing and mock conversions

Technologies: Informatica PowerCenter 8.6, Informatica PowerExchange 8.6, DB2 for iSeries v5R4, Oracle 11g, PQL/SQL Developer v7.1, Red Hat Enterprise Linux Server v5.4, Windows XP Professional, Mercury Quality Center 9.0, Core FTP, PuTTY, Altova XML Spy

Confidential, Rochester, New York

Sr. ETL Developer

Responsibilities:

• Developed mappings & workflows to ETL data using Informatica PowerCenter
• Created & managed users, folders and set privileges using Repository Manager
• Developed Unix shell scripts to execute workflows in batch using PMCMD
• Fine tuned the performance of workflows
• Performed unit testing, system testing and mock conversions

Technologies: Informatica PowerCenter 8.5, Informatica PowerExchange 8.5, DB2 for iSeries v5R4, Oracle 11g, PQL/SQL Developer v7.1, Red Hat Enterprise Linux Server v5.4, Mercury Quality Center 9.0, Core FTP, Windows XP Professional

Confidential, Rochester, New York

Sr. ETL Developer/Technical Lead

Responsibilities:

• Interacted with Business Analyst to understand the business requirements and created technical detail design documents
• Reverse engineered pre-existing mappings to understand existing business logic
• Led a team 2 developers by coordinating and monitoring work
• Created and managed users, folders and set privileges using Repository Manager
• Developed mappings & workflows to ETL data using Informatica PowerCenter
• Developed FLoad, MLoad and TPump scripts to extract/load data
• Migrated workflows and mappings from the development environment to the system test and System test to the UAT environment
• Used parameter file to re-use objects in different test environments
• Documented test case scenarios for all test levels
• Fine tuned the performance of workflows
• Performed unit testing, system testing and UAT

Technologies: Informatica PowerCenter 8.1/5.1, Teradata v2R6, Teradata SQL Assistant, Red Hat Enterprise Linux Server v5.4, Windows XP Professional, Mercury Quality Center 9.0

Confidential, Rochester, New York

ETL Developer

Responsibilities:

• Developed mappings & workflows to ETL data using Informatica PowerCenter
• Developed transformations such as Source Qualifier, Expression, Aggregator, Joiner, Sorter, Sequence Generator, Lookup, etc.
• Fine tuned the performance of workflows
• Performed unit testing, system testing and mock conversions
• Resolved defects raised by the testing team

Technologies: Informatica PowerCenter 8.1, Informatica PowerExchange 8.1, DB2 for iSeries v5R4, Oracle 10g, PQL/SQL Developer v7.1, Red Hat Enterprise Linux Server v5.4, Mercury Quality Center 9.0, Windows XP Professional

Confidential, Saint Louis, Missouri

ETL Developer/Onsite Coordinator

Responsibilities:

• Interacted with Business Analyst to understand the business requirements and created technical detail design documents
• Coordinated work with 3 offshore developers
• Used FLoad, MLoad & TPump utilities to extract/load data
• Developed mappings & workflows to ETL data using Informatica PowerCenter
• Developed Unix shell scripts to execute workflows in batch using PMCMD
• Fine tuned the performance of workflows
• Created e-mail tasks to notify the status of the scheduled loads
• Developed BTEQ scripts to balance amounts and rows on both source and target sides to comply with SOX (Sarbanes-Oxley)
• Performed monthly production runs and monitored loads

Technologies: Informatica PowerCenter 7.1.2, Teradata v2R5, Oracle 9i, AIX 5L v5.2, Windows 2000, HummingBird Connectivity v7.1, Teradata Queryman, AQT v8.1.4, Microsoft Visio