SUMMARY

• 9 + years of IT experience.
• Possesses good experience in Application development, Data warehousing, Data modelling and ETL process.
• Has solid programming experience in Oracle PL/SQL, Teradata and Informatica.
• Having extensive knowledge on Informatica power center tools, Teradata and Oracle.
• Developed mappings in Informatica to load the data from various sources into the Data warehouse using different transformations like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner.
• Experience in resolving on - going maintenance issues and bug fixes, monitoring Informatica sessions
• Extensive experience in developing packages, stored procedures, functions, Views, Triggers and Complex queries using Oracle SQL and PL/SQL.
• Experience in Oracle supplied Dynamic SQL, Ref Cursors, Record typesandCollections and SQL Loader.
• Experience in using Teradata SQL Assistant, writing TD Stored Procedures, Global Temporary Tables (GTT), Volatile Tables, UPI, NUPI, USI, NUSI, data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export, and Exposure to T pump, TPT on UNIX/Windows environments and running the batch process for Teradata.
• Tuning of queries and procedures/functions in Oracle and Teradata.

TECHNICAL SKILLS

Languages: Oracle SQL, PL/SQL

Tools: Informatica 9, Teradata BTEQ, Toad, PL/SQL Developer, SQL Developer, Oracle Warehouse Builder, HP Quality Center, Autosys

Database Technologies: Oracle 11g, Teradata 14, Sybase

Platforms: Windows XP/7, UNIX

Version Control: Clear Case, GIT, CVS

Testing Tools: HP Quality Centre, JIRA

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Responsibilities:

• Designing data model for new enhancements to the system
• Designing ELT (Extract, Load and Transform) strategies for the Next Generation datawareshouse using Teradata data and Informatica.
• Develop and maintain Teradata semantic procedure and process flows for implementing designed ELT strategies.
• Understanding the business requirements and performing the Analysis, Design and Implementation of the enhancements.
• Played onsite lead role
• Unit testing and Peer QA
• Production support and business support

Environment: Teradata 14, Informatica 9.6, Toad 12, UNIX, SQL Developer, Express Studio, Aqua data studio, UC4, Microstrategy.

Confidential, Cupertino, CA

Responsibilities:

• Designing data model for new enhancements to the system
• Designing ELT (Extract, Load and Transform) strategies for the GBI AC Repair using Teradata data and Informatica.
• Develop and maintain Teradata semantic procedure and process flows for implementing designed ELT strategies.
• Understanding the business requirements and performing the Analysis, Design and Implementation of the enhancements.
• Played onsite lead role
• Unit testing and Peer QA
• Production support and business support

Environment: Teradata 14, Oracle 11g,, Informatica 9.6,, Toad 12, UNIX, SQL Developer, Express Studio, Aqua data studio, Autosys.

Confidential, San Francisco, CA

Responsibilities:

• Designing ETL (Extract, Transform and Load) strategies for the Confidential data warehouse.
• Develop and maintain Informatica and Oracle Warehouse Builder Mappings and Workflows/Process flows for implementing designed ETL strategies.
• Understanding the client requirements and performing the Analysis, Design and Implementation of the Change Control Requests.
• Responsible to coordinate with the offshore team for requirements
• Unit testing and Peer QA
• Production support and business support
• Designing data model for new enhancements to the system

Environment: Informatica 9.6, Oracle Warehouse Builder 11, Oracle 11g, Teradata 14, Toad 12, UNIX, PL/SQL Developer, Perforce, Jira.

Confidential, San Jose, CA

Responsibilities:

• Involve in discussions with the Business partners to gather the requirements and help the BU team in laying out the BRD (Business Requirement Documents).
• Analyze the BRD’s and DRD’s and design the ERD (Engineering Requirements Documents) also known as Technical design documents.
• Interact with various vendors to get their system requirements, discuss the limitations and accordingly developed the Interface flat files etc.
• Develop various compensation programs and transactional workflow logics in the Oracle DB for the application ECT where I had to create various stored procedures, triggers, packages, Functions, Materialized views, PL/SQL collection types etc.
• Involve in full SDLC of the ECT project. Use Clearcase for maintaining project Versions and ClearQuest, sharepoint, HP Quality Center as a bug-tracking and bug repository tools for maintaining and preparing Test Cases, Test Plans and Defect raising/fixing.
• Create data models various projects after analyzing the technical and data requirements at the IT Business systems (ITBS) department of Confidential Inc.
• Troubleshoot performance issues and bugs within the Application/s by analyzing the queries and create Oracle Indexes if necessary.
• Performance tuning in various applications on an on-demand basis at Confidential .
• Part of Production support team for Level1 application ECT where the availability of the system has to be 100%.

Environment: Java, Oracle 11g, HP Quality center, Toad, PL/SQL Developer, GIT, CVS, JIRA.

Confidential

Responsibilities:

• Analysis and design of rule extraction automation process analyze the ETL Processes and identify the design patterns.
• For new design patterns, coordinate with Amex and create technical approach.
• Migrate existing Ab Initio feeds to new meta data driven ELT framework (MDF) in Teradata/Informatica.
• Create Informatica mapping using IDN Informatica developer guidelines for feeds.
• Create custom load procedures in TD.
• Obtain/Extract test data for unit testing using load scripts.
• Perform unit test for each feed and upload results to Quality Center.
• Create and configure nodes on the Event Engine in Development environment for the feeds.
• Coordinate with onsite and offshore teams.

Environment: Teradata 14, Infomatica 9.6, Event Engine, UNIX, Sybase

Confidential

Responsibilities:

• Worked for Automation to reduce human effort/errors.
• Designing ETL (Extract, Transform and Load) strategies for the Fox data warehouse.
• Develop and maintain Informatica Mappings and Workflows for implementing designed ETL strategies.
• Understanding the client requirements and performing the Analysis, Design and Implementation of the Change Control Requests.
• Responsible to coordinate with the onshore team for requirements

Environment: Informatica 8.6, Teradata, Microsoft SQL Server, Oracle, Toad, UNIX, PL/SQL Developer.

Confidential

Responsibilities:

• Understanding the client requirements, analysis and study of impact
• Bug fixing
• Develop new Report
• Enhancements to the existing Reports.
• Bug fixes during unit testing and system testing of the product
• Knowledge sharing at project level
• Providing customer support and maintenance for the earlier releases.
• Releases of the product in parallel with development
• Preparation of test cases for the features developed in the module.
• Application and Business support.

Environment: Oracle 11g, Teradata 12, Java, CVS version control, Toad, PL/SQL Developer, JIRA

Confidential

Responsibilities:

• Understanding the client requirements, analysis and study of impact
• Bug fixing
• Enhancements
• Bug fixes during unit testing and system testing of the product
• Knowledge sharing at project level
• Providing customer support and maintenance for the earlier releases.
• Releases of the product in parallel with development
• Preparation of test cases for the features developed in the module.
• Application and Business support.

Environment: Oracle 11g, Teradata, Java, CVS version control, Toad, PL/SQL Developer, JIRA

Confidential

Responsibilities:

• Understanding the client requirements, analysis and study of impact
• Bug fixing
• Enhancements
• Bug fixes during unit testing and system testing of the product
• Knowledge sharing at project level
• Providing customer support and maintenance for the earlier releases.
• Releases of the product in parallel with development
• Preparation of test cases for the features developed in the module.
• Application and Business support.
• On-site co-ordination

Environment: Oracle Forms and Reports, UNIX, Peregrine, HP Quality Centre, Window XP, Toad, PL/SQL Developer

Confidential

Responsibilities:

• Understanding the client requirements, analysis and study of impact
• Bug fixing
• Enhancements
• Bug fixes during unit testing and system testing of the product
• Knowledge sharing at project level
• Providing customer support and maintenance for the earlier releases.
• Releases of the product in parallel with development
• Preparation of test cases for the features developed in the module.
• Application and Business support.