SUMMARY

• Around 8 Years of IT Experience in Analysis, Design, development, implementation and troubleshooting of Data warehouse applications.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional and Dimensional modeling (Star and Snowflakeschema) Concepts.
• Demonstrated expertise in utilizing ETL tool Informatica power center 9.x/8.x/7.x/6.x for developing the Data warehouse loads as per client requirement.
• Excellent knowledge in identifying performance bottlenecks and tuning the Informatica Load for better performance and efficiency.
• Excellent knowledge of Informatica Administration. Involved in grid management, creationand upgradation of repository contents, creation of folders and users and their permissions.
• Significant Multi - dimensional and Relational data modeling experience, DataFlow Diagrams, Process Models, ER diagrams with modeling tools like ERWIN & VISIO.
• Involved in all phases of data warehouse project life cycle. Designed and developed ETL Architecture to load data from various sources like DB2 UDB, Oracle, Flat files, XML files, Teradata, Sybase and MS SQL Server into Oracle, Teradata, XML, and SQL server targets.
• Extensive knowledge in developing Teradata, Fast Export, Fast Load, Multi load and BTEQ scripts. Coded complex scripts and finely tuned the queries to enhance performance.
• Profound knowledge about the architecture of the Teradata database.
• Extensively involved in both Manual and Automated testing of Object Oriented, Client-Server, Web based and N-Tier complex large scale applications.
• Extensively worked on composing and execution of Test plans, Test cases and Test scripts.
• Extensive experience in implementation of Data Cleanup procedures, transformations Scripts, Triggers, Stored Procedures and execution of test plans for loading the data successfully into the targets
• Experienced In working with various Scheduling tools like Autosys, Control-M, Informatica Scheduler and Cronjob.
• Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments.
• Strong understanding of Data warehouse project development life cycle. Expertise in documenting all the phases of DWH projects.
• Demonstrated ability to work and communicate effectively with both business and technicalaudiences.
• Excellent analytical, programming, written and verbal communication skills with ability to interact with individuals at all levels.

TECHNICAL SKILLS

InformaticaPowerCenter: 9.x/8.x/7.x/6.x, Repository Manager, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, mappings, re-usable transformations, Mapplets, Shortcuts, sessions, and workflows

Data Modeling: Dimensional Modeling, Star Schema, Snow Flake Schema, Fact Tables, Dimension Tables, Erwin and Microsoft Visio

Databases: Oracle 11g/10g/9i, Teradata, MS SQL Server, MS Access, SQL, PL/SQL

Languages: C, C++, HTML, PHP

Job Scheduling: Tivoli, Control-M

Environment: UNIX (Sun Solaris, HP, Linux), Windows

Utilities and Tools: SQL Loader, TOAD 9.5

Others: Microsoft Word, Microsoft Excel

PROFESSIONAL EXPERIENCE

Confidential, Woonsocket, RI

Sr.Informatica Developer

Responsibilities:

• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all applications and system.
• Interacted with Business Users and Managers in gathering business requirements.
• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Extensively used Teradata utilities like Fast load, Multiload to load data into target database.
• Extensively worked on Power Center Client Tools like Power center Designer, WorkflowManager, and Workflow Monitor
• Extensively worked on Power Center 9.x Designer client tools like Source Analyzer, TargetDesigner, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzed the source data coming from different sources (Oracle and SAP Flat files) andworked on developing ETL mappings.
• Created Parameter files and validation scripts.
• Created used custom load Scripts from command task.
• Created Process Control and Metadata for informatica jobs.
• Created Reusable and Non-Reusable command task in Workflow Manager.
• Created Sessions, command task, reusable worklets and workflows in Workflow Manager.
• Involved in providing 24/7production supportto solve critical issues.
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level andSession Level.
• Assisted with peer code reviews and testing of development team's T-SQL code.
• Performed Unit testing and Data validation testing using Validation scripts.
• Proven Accountability including professional documentation and weekly status report..

Environment: Informatica Power Center 9.1, Oracle 11g/10g, UNIX, Win XP, SQL * Plus, Transact-SQL, Control-M, Putty, BTEQ.

Confidential, Detroit MI

Sr.ETL/Informatica Developer

Responsibilities:

• Involved in understanding of architecture design part,businessprocesses and data modeling design.
• Have prepared requirement understanding documents at the time of estimation on planning on design and implementation of ETL flows as per the business flow.
• Working with the clients to create Technical design documents and field-field level mapping spread sheets.
• Working with the Offshore team and coordinating the Development activities.
• Working as a developer creating mappings, sessions and workflows in Informatica powercenter.
• Writing DB SQL scripts using Oracle SQL developer.
• Performing Unit testing of the developed mappings and workflows and documenting the results.
• Developing UNIX shell scripts to invoke informatica workflows and testing them.
• Performing data population tests against target system to ensure accuracy and quality of data.
• Involved in extensive Performance tuning by determining bottlenecks at various points like targets, sources and systems.
• This led to better session performanceProvided production support for the Executive Management Information System (EMIS), a web reporting portal to informatica and teradata data sources
• Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document.

Environment: Informatica Power Center 9.5/9.1, Oracle 11g/10g, Teradata 13, UNIX, Win XP, SQL * Plus, Transact-SQL, Control-M, Putty, BTEQ

Confidential, SFO CA

Informatica Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
• Worked on dimensional modeling to design and develop STAR schemas by identifying the facts and dimensions. Designed logical models as per business requirements using Erwin.
• Designed and Developed ETL mappings using transformation logic for extracting the data from various sources systems.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Developed processes on both Teradata and Oracle using shell scripting and RDBMS utilities such as Multi Load, Fast Load, Fast Export, BTEQ (Teradata) and SQL*Plus, SQL*Loader (Oracle).
• Created, Tested and debugged the Stored Procedures, Functions, Packages, Cursors and triggers using PL/SQL developer.
• Used the feature EXPLAIN PLAN to find out the bottlenecks in a given Query, thus improving the performance of the job.
• Involved in Unittesting, User Acceptance testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Automated UNIX shell scripts to verify the count of records added everyday due to incremental data load for few of the base tables in order to check for the consistency.
• Involved in production and deployment phase to make sure the job schedules and dependencies are developed in such a way that we are not missing the SLA on a day to day basis.

Environment: InformaticaPowerCenter 8.6, Business Objects XI, Oracle 11g/10g,SQL Server, XML Files, TOAD, SQL, PL/SQL, Windows XP, UNIX.

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.
• Used Informatica as the tool for extracting data from the flat files, relational databases and transforming the data according to the target database and performed loading.
• Identified and tracked the slowly changing dimensions from heterogeneous sources and determined the hierarchies in dimensions.
• Worked on InformaticaPowerCenter tool - Source Analyzer, Warehouse designer, Mapping and Mapplet designer, Informatica Repository Manager and Informatica Workflow Manager.
• Worked extensively with complex mapping using, Lookups, Expression, Filter, aggregator, Update Strategy, Sequence generator and more.
• Involved in creating non-reusable and reusable sessions in Workflow designer and Task developer and define schedules for sessions.
• Extensively worked with Workflow Monitor and Debuggerin the Designer.
• Used Informatica Repository manager to migrate objects from individual developer folders to the integrated project folder to the TST/UAT environment.
• Performed Informatica Administrative functions created folders, granted permissions, maintained security, setup, backed up and restored repositories using the Informatica Repository Manager.
• Coded BTEQ scripts to populate data mart tables from EDW to cater specific reporting needs.
• Developed Fast Export scripts to send data files to other teams.
• Developed Mload scripts to load data into Teradata EDW.
• Used the Informatica Server Manager to embed sessions with pre-session and post-session shell scripts.
• Also Wrapped Session pmcmd commands in Shell scripts for nightly batch processing using AutoSys scheduler
• Performed Unit Testing and verified the data and performed Error Handling on sessions in Workflow.
• Involved in writing BTEQ scripts to load data efficiently to targets.
• Used Korn shell scripts to control the ETL process.

Environment: Informatica Power Center 8.1, Business Objects 5.1, Erwin 4.0, Oracle 9i, DB2, UNIX, Windows XP Professional, UltraEdit-32, MS Visio 2002, XML, MS-Excel, Ms-Access, SQL Navigator, Clear Quest, Clear Case

Confidential

ETL/Oracle Developer

Responsibilities:

• Extraction, Transformation and data loading were performed using stored procedures into the database. Involved in Logical and Physical modeling of the drugs database.
• Based on the requirements created Functional design documents and Technical design specification documents for ETL.
• Created tables, views, indexes, sequences and constraints.
• Developed stored procedures, functions and database triggers using PL/SQL according to specific business logic.
• Transferred data using SQL*Loader to database.
• Involved in testing of Stored Procedures and Functions. Designed and developed table structures, stored procedures, and functions to implement business rules.
• Used legacy systems, Oracle, and SQL Server sources to extract the data and to load the data.
• Involved in design and development of data validation, load process and error control routines.
• Analyzed the database for performance issues and conducted detailed tuning activities for improvement.
• Generated monthly and quarterly drugs inventory/purchase reports.
• Coordinated database requirements with Oracle programmers and wrote reports for sales data.

Environment: Oracle 8i, SQL, PL/SQL, Windows 2000.