PROFESSIONAL SUMMARY:

• Having 7+ Years’ experience in Full life cycle of Software Development (SDLC) including Business Requirement Gathering & Analysis, System study, Application Design, Development, testing, Implementation, System Maintenance, Support and Documentation.
• Enterprise Data Warehousing: Experience and Expertise in Teradata 13, ETL process (Fort ETL, Informatica Power Center 9.0.1), Informatica Developer 9.1.0.
• Experience and Expertise in ETL process (Informatica PowerCenter) Mappings, Mapplets, Transformations, Workflow Manager and Workflow Monitor. Also, Experience in Extraction / Transformation / Loading of legacy data to Data Warehouse using Informatica Developer9.1.0.
• Database: 6+ years of experience using Teradata, Oracle 9i/8i, SQL Scripting.
• Good Knowledge in Maestro and other scheduler tools.
• Testing skills include performing Regression, Integration, and Volume testing as well as Development, Execution, and Maintenance of Test plans, Test specifications and Test scenarios.
• Strong knowledge of Data Warehousing concepts and end - to-end Data Warehousing project life cycle.
• Experience in providing On Call (24*7) Support for Production Problem Resolution (Resolve Production issues and problems in an expedited manner).
• Good understanding of Data warehousing, ER Modeling and Dimensional Modeling concepts.
• Good understanding of Product Life Cycle and Comprehensive Delivery Process’s.
• Team player with strong People Management skills, excellent Communication and Problem Solving skills and exposed to various design and presentation tools like Visio and MS-Office utilities.
• Domain knowledge in Retail and Insurance.
• Experienced in implementing error-handling process.
• Experienced in using parameter files, mapping parameters in mappings.
• Experience working with UNIX Shell Scripts and Perl for automatically running sessions,
• Aborting sessions and creating parameter files.
• Strong Database skills in Teradata, Oracle 11g/10g, DB2 UDB, MS SQL Server.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills.
• Teradata DBA role has been performed.

TECHNICAL SKILLS:

BI Tools: SAP Business Objects XI R2,Fort Reporting

ETL Tools: Informatica Power center 9.1,Dataintegrator,SSIS,Fort Runner

Database: Oracle 9i, Teradata, SQL server 2005

Modeling Tools: Erwin, MS Visio

Operating system: Microsoft XP professional, Microsoft server 2000,UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Senior ETL Informatica Developer

Responsibilities:

• Demand Management
• Gathering requirements from business user and transform into a requirement document
• To Build an ETL process to retrieve data from Enterprise Data warehouse(Teradata)
• Extracted data is populated into a mart table
• On top of the mart table, build a reporting view
• From the reporting, the fort reporting layer is built
• The ETL is therefore scheduled on a daily,week,monthly,quarterly or yearly based on the reporting needs
• By this process the reports are generated on time with immense power on displaying it within a fraction of second.
• Send it for review and sign off

Environment: Fort Runner, Fort Reporting, Teradata

Confidential, Minneapolis, MN

Senior ETL Informatica and Teradata Developer

Responsibilities:

• Define the high level scope of design changes, high level Solution and Application Architecture for Scoping of the BTP-Monthly
• Development of new and modification of existing interfaces ( Informatica Mapping/Teradata scripts-BTEQ,Fast Load, Data Quality Audits) to get the BTP monthly related data
• Data model Update
• To Build a Adhoc reports for business users

Environment: Informatica 9.1, Teradata.

Confidential, Minneapolis, MN

Senior ETL Informatica and Teradata Developer

Responsibilities:

• Co-ordinate with onsite counterpart for requirement gathering.
• Preparing High Level design/Low level design document.
• Development of new and modification of existing interfaces ( Informatica Mapping/Teradata scripts-BTEQ,Fast Load, Data Quality Audits) to get the PAC/MDC sale into EDW(Enterprise data warehouse).
• Modification of existing reports to accommodate PAC/MDC data
• Preparing release notes for delivery
• UAT co-ordination and deployment activity

Environment: Informatica 8.6, Teradata.

Confidential, Minneapolis, MN

Senior ETL Informatica and Teradata Developer

Responsibilities:

• Understood the business and started Data profiling on the requirements.
• This project consists of 19 phase i.e. 19 iterations.
• The iteration 2 was completely given to me and I started my analysis, Requirement, Design and coding.
• I stared preparing Requirement document, High Level design, Low level Design, Technical Architecture, Unit test cases, Coding.

Environment: Informatica 8.6, Teradata, Oracle 10g, SQL server 2005

Confidential

Developer

Responsibilities:

• Understanding the business
• A lead in charge for off shore, Interacting with onsite coordinator and gathering requirements understood the client requirements and analysis was done on the old system based on the analysis new system was developed.
• As a result of analysis an Approach doc was sent to client after the acceptance the development activity was started.
• As an ETL Developer, Developed the mappings and sessions as per the client's requirements.
• Involved in the testing of the mappings that were developed and checked the validity of the data.
• Developed the testing documents with the test scripts and test results for validation of data.
• Release notes were prepared with ATL file, DDL scripts. Finally uploading it in share point where we store our project related doc, it’s like central repository. After the release we will get the approval from onsite.

Environment: Data integrator Xi, SQL server 2005

Confidential

Junior data warehouse developer

Responsibilities:

• Load monitoring and reporting to client on daily basis Scheduling and coordinating the day-to-day activities of the team.
• Interact with the client for understanding the new enhancements business process.
• Developing solutions for new requirements to enhance the current system.
• Understanding the Mapping Documents and translating the Mapping Document into Packages to extract and Populate Data.
• Preparation of Production deployment documents and checklists.

Environment: Informatica 7.1, Oracle 9i