SUMMARY

• 5 years of IT experience in Analysis, Design, Development and Implementation of Data warehouse systems and Expertise in Teradata, Informatica, Oracle and Unix/Linux.
• Worked on Teradata Client Utilities using BTEQ, Fast load, MultiLoad, TPT and Fast export.
• Extensively worked in Designing, Coding and Testing phases of software development life cycle process, which includes implementing and supporting Teradata & batch - processing jobs.
• Extensive experience in creating theMappings, Mapplets, Reusable transformations Workflows, Worklets,and scheduling theWorkflows and sessionsusingInformatica Power Center.
• Worked in Analysis & Migrating SAS Code to Informatica and Teradata.
• Identifying the bottleneck and involved in performance tuning and optimization of ETL loads both at the mapping and the session level and also at the database level.
• Worked on queries for avoiding FTS in Teradata.
• Involved in the design of Multi-Dimensional Data Modeling (Star, Snow Flake schema) using Erwin, MS-Visio.
• Sound knowledge in Relational and Dimensional modeling techniques of Data warehouse concepts and principles - Star, Snowflake schema, SCD, Surrogate keys, and Normalization/De normalization
• Designed and developed complex mappings using different transformations like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner Update Strategy and more
• Excellent Knowledge of relational database management systems and extensively worked on Data extraction, transformation, loading with Oracle and Teradata using Informatica
• Worked in conceptual, logical and physical data models using ERWIN.
• Worked in SQL and PLSQL in Teradata and Oracle.
• Worked on Design Docs, Unit Test Cases, QA Test Cases, QA Test Plan & Test Strategy.
• Worked on Basic Administrative Activities in Teradata.
• Worked on developing various test cases for testing Informatica code.
• Worked with major Pharma Clients like Pfizer, Bayer, Abbott
• Worked on Data modeling.
• Experience in Life Sciences Domain.
• Excellent communicational, interpersonal, analytical and problem solving skills.
• Extensively worked on executing Bteqs through Shell scripts.

TECHNICAL SKILLS

Operating System: Windows 95/98/2000, Unix /Linux

Languages: SQL,C,plsql

Databases: Teradata 12 and 13, Oracle

Tools: & Utilities Informatica,Teradata Tools like BTEQ, Fast load, Multiload, Fast Export, TpT, Erwin, Toad

Domain Knowledge: Life Sciences

PROFESSIONAL EXPERIENCE

Confidential, Waukegan

Informatica Lead

Responsibilities:

• Interacted with Functional teams to understand the requirements.
• Data Profiling Activities.
• As a Sr. Informatica developer, performed requirements gathering, developed Analysis & Design document, developed Project time line.
• Involved with Business Analyst in requirements gathering, business analysis and project co-ordination
• Analyzed existing SAS codes for conversion into Informatica ETL code.
• Design, Development and Testing and coordination with Offshore Team.
• Data comparison with SAS files and ETL output Files.
• Involved in writing SQL scripts for unit and functional testing.
• Extensively involved in Performance Tuning for ETL process at source, target, InformaticaMappings, Sessions and at database level for optimum performance.
• Coordinated the project tasks with the team and ensured that the projects are completed on time.
• Worked on Autosys Scheduling Tool for Scheduling and Monitoring of jobs.
• Used Teradata utilities Fload,Mload, for loading tables and Fast export exporting data from table
• Extensively involved in ETL testing, Created Unit test plan to test the mappings, created test data.
• Documentation for the Informatica processes, naming conventions and best practices.

Environment: Informatica, Teradata, UNIX

Confidential, Waukegan

Informatica Lead

Responsibilities:

• Interacted with Functional teams to understand the requirements.
• Data Profiling Activities.
• Analyzed existing SAS codes for conversion into Informatica ETL code.
• Involved in all phases of SDLC from requirement, design, and development and testing. Performed business analysis and requirements per high-end users and managers and prepared design documents.
• Involved in creating comprehensive Technical and Mapping Design documents for the project.
• Responsible for coding of mappings and unit testing and integration testing. Prepared mapping specification documents for the same.
• Involved in writing SQL scripts for unit and functional testing.
• Had worked on calling bteq’s Through Shell scripts
• Extensively worked on Informatica Power Center - Mapping Designer & Mapplets, and Transformations, Reusable Transformations, Workflow manager, Repository manager, Workflow Monitor, Sessions, workflows.
• Responsible for coordinating with the offshore team.
• Extensively worked on tuning and thereby improving the load time.
• Used Teradata utilities Fload,Mload, for loading tables and Fast export exporting data from table.

Environment: Informatica, Teradata, UNIX

Confidential, Waukegan

Informatica Lead

Responsibilities:

• Interacted with Functional teams to understand the requirements.
• Data Profiling Activities.
• Design, Development and Testing and coordination with Offshore Team.
• Involved in writing SQL scripts for unit and functional testing.
• Provided recommendations at query-level & also at Table-Level to improve the performance.

Environment: Informatica, Oracle, UNIX

Confidential

Informatica Lead

Responsibilities:

• Interacted with development & Functional teams to understand the History Load requirements.
• Performed Data profiling on the existing IDEA Sales Production data
• Developed business models confirming to functional mapping-defined logical and complex joins for the dimension tables.
• Responsible for History Load and Design, Interact with offshore for Development and Test and do Functional Testing.
• Involved in writing SQL scripts for unit and functional testing.
• Provided recommendations at query-level & also at Table-Level to improve the performance.
• Interacted with Business users on analyzing their requirements.

Environment: Informatica, Oracle, UNIX

Confidential

Teradata/Informatica Developer

Responsibilities:

• Interacted with development & Functional teams to understand the requirements.
• Worked in Data Profiling by loading Files using FLOAD, Requirements gathering.
• Design of Product Subject Area for Bayer Products.
• Involved in Teradata architect activities.
• Worked in porting Oracle code in Teradata for ITRAK Reporting Tool.
• Prepared Design, UTC, STC and deployment document
• Worked on Informatica tool for developing mappings.
• Worked on Data modeling using Erwin.
• Development and deployment of Database Objects
• Used to support client for data extraction, fixing issues and reloading data
• Worked on Reporting Queries for performance tunings on them.
• Recommended better standards in Teradata to Team members
• Coordinated with Team for any issue fixes they faced in Informatica and Teradata.
• Data profiling from existing Data warehouse application.
• Handled CR’s requested by Client.
• Involved in Setting up Teradata and Informatica environment for our Project.
• Worked Extensively on Teradata utilities to load Data in Our project Using FLOAD, Fast Export, MLOAD, and BTEQ, had worked on some basics Teradata administrator tasks.
• Worked on Informatica tool for developing mappings.
• Had worked on executing Bteqs through Shell scripts.
• Worked on logical and physical data models ERWIN as Modeling Tool.

Environment: Informatica, Teradata 12 & 13, Oracle 10g, UNIX

Confidential

Informatica Developer

Responsibilities:

• Gathered Requirements from functional team.
• Worked in Design of Mappings and Development and Testing.
• Reconcile with existing application
• Load BU Product master details in Table.
• Preparation of unit test cases
• Interacted with onsite team, gathered requirements and shared it with offshore team
• Performed Impact Analysis based on the Change request
• Development and deployment of Database Objects
• Prepared Design, UTC, STC and deployment document
• Used Shell scripts to execute Bteq Queries.
• Worked on Informatica tool for developing mappings.
• Used Bteq,Fload,Mload, Fload as Teradata Load Utilities
• Used Fast export for Exporting Data from database.

Environment: Informatica, Teradata, UNIX

Confidential

Informatica Developer

Responsibilities:

• Design, Develop and Test the informatica code.
• Load file till data marts and do reconcile HFM with MIC data.
• Prepared Design, UTC, STC and deployment document
• Development and deployment of Database Objects
• Involved in Performance tuning activities on queries for avoiding FTS.
• Interact with Functional team for any issues on HFM adjustments due to wrong map of products in Product cross- file and fix them.

Environment: Informatica, Teraadata, UNIX

Confidential

Developer

Responsibilities:

• Had supported the application by fixing any data issue when job fails
• Reconcile data among data marts.
• Interacted with Users for the requirements.
• Worked on Reporting Queries for performance tunings
• Development and deployment of Database Objects
• Prepared Design, UTC, STC and deployment document
• ETL Coding and Job design implementation, which involved extensive use of different Transformations
• Worked as a team member, managed team and coordinate with different teams to ensure successful delivery
• Acquired the knowledge of business process flow.
• Involved in Rejection recovery and reconciliation process
• Mload, Fload were used as part of Teradata Loading Utilities.
• Used to handle reconcile issues on products by tracing back the load.
• Used to support client for data extraction, fixing issues and reloading data
• Handled CR’s in system.

Environment: Informatica, Teradata, UNIX