SUMMARY:

• Around 8 years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health Insurance, Media, Telecom and Manufacturing Sectors.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Skilled in performing complete process of Extraction, Transformation and Loading of data from single, multiple sources into Data Warehouse or Data Marts
• Expertise in working with Flat file and relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, Teradata and Salesforce
• Experience in using Automation Scheduling tools like Control - M.
• Worked extensively with slowly changing dimensions.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Profound knowledge of unit testing and system testing on Informatica Powercenter code at various levels of the ETL
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Understand the business rules completely based on High Level document specifications and implemented the data transformation methodologies.
• Highly articulate, demonstrating excellent relationship building, communication and interpersonal skills across all levels including management, employees and external agencies
• Independently perform complex troubleshooting, root-cause analysis and solution development.
• Experience with dimensional modeling using star schema and snowflake models.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Comprehensive technical, oral, written and communicational skills
• Eager to contribute in a team-oriented environment having inner desire to gel and work for business growth
• Requirement Gathering & Analysis
• Technical Support & Documentation
• Coding, Designing & Programming
• Quality Assurance
• Client Relationship Management
• Data Warehousing
• Detail oriented

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.x,9.X,Microsoft SSIS

GUI Tools: SQL Developer

Special Software: VSS,CVS, HP OVSD,TFS

Database: Oracle, SQL Server, Teradata

Operating System: Windows XP,UNIX

Programming Language: ASP.NET

PROFESSIONAL EXPERIENCE:

Team Lead

Confidential, Phoenix, Arizona

Responsibilities:

• Responsible for Business Analysis, Requirements Collection and HLD creation
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Worked on complex mappings, mapplets and workflow to meet the business needs ensured they are reusable transformation to avoid duplications.
• Created reusable tools like file splitter and file format checking using Informatica.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Informatica PIM.
• Responsibilities include creating the sessions and scheduling the sessions
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to flat files
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD mappings for CDC (Change Data Capture).
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Team Lead

Confidential, Austin, Texas

Responsibilities:

• Responsible for Business Analysis, Requirements Collection and HLD creation
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used visio to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used SSIS to load data from excel files to tables.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote Batch Scripts to archive the files.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Team Lead

Confidential

Responsibilities:

• Involved in ETL projects requirements gathering, HLD and Technical Specs.
• Gathered and analyzed requirements and designed ETL processes using Informatica tool to load data from Oracle to Teradata target database
• Review existing code, lead efforts to tweak and tune the performance of existing Informatica
• Worked on Teradata BTEQs.
• Worked on Salesforce objects loading.
• Worked on Salesforce lookups.
• Preparation of Analysis document and mapping document.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Used Shell scripting for automation of ETL work.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Leading a team of four members.
• Assigning work to team members.
• Updating project status to client.
• Involving in production move activities like label the workflows and creating RFC.
• Implementation of upsert using Teradata.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

ETL Developer

Confidential, New York

Responsibilities:

• Involved in ETL projects requirements gathering, HLD and Technical Specs.
• Gathered and analyzed requirements and designed ETL processes using Informatica tool to load data from Oracle to Teradata target database
• Worked on Teradata BTEQs.
• Developed reusable Mapplets and Transformations.
• Preparation of Analysis document and mapping document.
• Used Shell scripting for automation of ETL work.
• Performed the testing as per unit test cases.

Developer

Confidential, Tampa, Florida

Tools: Informatica 8x, SQL server 2008, Oracle 10g

Responsibilities:

• Gathered and analyzed requirements and designed ETL processes using Informatica tool to load data from SQL Server and SQL server target database
• Used Informatica Power Center tools - Source Analyzer, Target Designer, Mapping Designer, Workflow Manager and Workflow Monitor extensively
• Developed sessions using Workflow Manager for data loading with ODBC.
• Preparation of release notes.
• Check in the workflows into TFS.
• Preparation of Technical design documents.
• Created various transformations such as Lookup, aggregate, expression, router and update strategy
• Tested applications as per unit test cases.
• Defined and documented requirements for data, workflow and logical processes.
• Used Informatica repository manager to backup and migrate metadata in development and AT.
• Creation of Parameter file in UNIX environment.
• Performed the testing as per unit test cases.

Developer

Confidential

Tools: Informatica 8x, Oracle 10g, SQL server 2005, Teradata

Responsibilities:

• Gathered and analyzed requirements and designed ETL processes using Informatica tool to load data from File system and Oracle staging and SQL server target database
• Used Informatica Power Center tools - Source Analyzer, Target Designer, Mapping Designer, Workflow Manager and Workflow Monitor extensively
• Developed sessions using Workflow Manager for data loading with ODBC
• Created various transformations such as Lookup, aggregate, expression, router and update strategy
• Tested applications as per unit test cases.
• Defined and documented requirements for data, workflow, logical processes and operating system environment
• Developed programs, applications and enhancements based on agreed SLAs
• Reviewed and edited requirements, business processes and recommendations related to proposed solutions

Team Member

Confidential

Tools: Informatica 8x, Oracle 9i, SQL Server 2000

Responsibilities:

• Used Informatica Power Center tools - Source Analyzer, Target Designer, Mapping Designer, Workflow Manager and Workflow Monitor extensively
• Created various transformations such as Lookup, aggregate, expression, router, sequence generator and update strategy
• Reviewed and edited requirements, business processes and recommendations related to proposed solutions
• Fixed invalid Mappings, tested Stored Procedures and Functions, handled Unit and Integration Testing of Informatica Sessions and Target Data
• Checked proper running of all processes in production monitoring
• Performed testing as per unit test cases
• Used Debugger wizard to remove bottlenecks at source level, transformation level and target level for optimum usage of sources, transformations and target loads

Team Member

Confidential

Tools: Informatica 7x, Oracle 9i, SQL Server 2000

Responsibilities:

• Used Informatica Power Center tools - Source Analyzer, Target Designer, Mapping Designer, Workflow Manager and Workflow Monitor extensively
• Created various transformations such as Lookup, aggregate, expression, router, filer and update strategy
• Developed programs, applications and enhancements based on agreed SLAs
• Reviewed and edited requirements, business processes and recommendations related to proposed solutions
• Created various transformations such as Lookup, aggregate, expression, filter and update strategy
• Used workflow manager to create tasks, monitor and analyze loading statistics
• Performed UTC (Unit Test Cases)