SUMMARY

• Over 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 Snowflake schema) Concepts.
• Demonstrated expertise in utilizing ETL tool Informatica power center 8.x/7.x/6.x/5.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, creation and upgradation of repository contents, creation of folders and users and their permissions.
• Significant Multi - dimensional and Relational data modeling experience, Data Flow 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.
• 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 technical audiences.
• Excellent analytical, programming, written and verbal communication skills with ability to interact with individuals at all levels.

TECHNICAL SKILLS

Informatica: Informatica Power Center 8.6/8.1/8.0/7.1.5/7.1.4/7.1.3/7.1.2/7.1.1/7.0/6.1.2/6.1.1 , 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 10g/9i/8i/7.x, Teradata, MS SQL Server 2000/7.0/6.5 , MS Access 7.0/2000, SQL, PL/SQL

Languages: C, C++, HTML, ASP, Java, 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, Jersey City, NJ

Sr ETL/Informatica Lead

Responsibilities:

• Data has been extracted from the flat files, relational databases and transformed the data according to the target database and performed loading using Informatica 9.1
• Worked extensively with complex mapping using, Lookups, Expression, Filter, aggregator, Update Strategy, Sequence generator and more.
• Worked with offshore team and conducted daily meetings to get status update. Used JIRA software to track assigned tasks and update the stories.
• Worked on performance issues and bottlenecks to reduce the load time and monitored the data loads.
• Used Autosys scheduler to run all the workflows involved in loading the data.
• Created mappings to support delta loads to targets.
• Created a process control framework to capture statistics of all the loads without having an access to the informatica metadata.
• Well versed in developing the complex SQL queries, unions and multiple table joins and experience with views.
• Involved in UNIX Shell scripting.
• Identified and implemented slowly changing dimension methodology for accessing the full history of accounts and transaction information.
• Involved in unit testing in DEV, UAT, and PROD environments. Performed positive and negative testing of the application for identification of bugs after fixing of errors in each subsequent build during the process of development.
• Involved in production support to solve critical issues.
• Parameterized the mappings and increased the re-usability.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Closely worked with the BO reporting team to ensure that correct data is presented in the reports.

Environment: Informatica Power Center 9.1/8.6, Sybase, DB2, Delimited Flat Files, Aqua Data Studio 7.0, UNIX, Win XP, Transact-SQL, Control-M, Putty, Autosys Scripts, XML, MS-Excel.

Confidential, Philadelphia, PA

Sr ETL/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, Workflow Manager, and Workflow Monitor
• Extensively worked on Power Center 8.6 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzed the source data coming from different sources (Oracle and SAP Flat files) and worked on developing ETL mappings.
• Created Parameter files and validation scripts.
• Created used custom Mload 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/7 production support to solve critical issues.
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session 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.
• Provided 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 8.6, Oracle 10g, SAP BW Flat Files, Teradata 13, UNIX, Win XP, SQL * Plus, Transact-SQL, Control-M, Putty, BTEQ

Confidential, St. Louis, MO

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 Unit testing, 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: Informatica Power Center 8.6, Business Objects XI, Oracle 11i/10g, Sybase 12.5, 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 Informatica Power Center 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 Debugger in 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.
• Involved in extensive Performance tuning by determining bottlenecks at various points like targets, sources and systems. This led to better session performance.

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, Mettawa, IL

Informatica Consultant

Responsibilities:

• Involved in complete Life Cycle of developing Enterprise Data Warehouse Application and, developing ETL Architecture using Informatica.
• Interacted with Source system SME’s to analyze how various business processes have been tracked across the source tables.
• Designed Data warehouse target tables by using Dimensional Modeling Techniques - Star and Snowflake Schemas. Created Dimensions and Fact tables using Erwin.
• Extracted data from various data sources such as Oracle, Flat file, XML, DB2 and transformed and loaded into targets using Informatica.
• Created various complex mappings using different transformations such as Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc.
• Designed and developed initial and incremental data loads using Informatica.
• Designed and Developed several mapplets and worklets for reusability.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
• Developed sessions using different types of partitioning techniques like round robin, hash key portioning for better performance.
• Implemented audit process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Created Shell scripts with PMCMD command and scheduled using Maestroscheduler for nightly batch processing.
• Involved in Unit testing, User Acceptance testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Provided Nightly batch loads support and implemented solutions to correct the data issues raised by end user during production support phase of the project.

Environment: Informatica Power Center 8.1, Oracle SQL, Pl/SQL 10g, Toad, Unix Maestro, XML, Flat file, Erwin, AS 400 DB2, Windows XP, UNIX, Shell Scripting.

Confidential, Kansas City, KS

Informatica Developer

Responsibilities:

• Involved in developing mapping from the design documents.
• Worked on Informatica PowerCenter 7.x tools like Source Analyzer, warehouse designer,
• Mapping Designer, Server Manager, Mapplets, and Reusable Transformations.
• Developed various Mappings, Mapplet and Transformations for migration of data from various existing systems to the new system using Informatica Designer.
• Used various Transformations like Router, Filter, Joiner, Update Strategy and connected and unconnected lookups for better data messaging and to migrate clean and consistent data using the Informatica PowerCenter Designer.
• Built Repositories using Informatica PowerCenter Repository Manager to store Source, Target Transformations, Mapplet and Mappings metadata information
• ModifiedBTEQscripts to load data fromTeradataStaging area toTeradata data mart.
• Created ScriptsusingTeradatautilities(Fast load, Multi load, Fast export).
• Involved in creatingsecondary, join indexesfor efficient access of data based on the requirements.
• Extensively used Multi-Load and Fast-Load utility to populate the flat file data into the Teradata database Worked on performance tuning and optimization of the Sessions, Mappings, Sources and Target Worked with the Business Analysts for requirements gathering, business analysis and testing.
• Created Informatica mappings with PL/SQL procedures/Functions to build business rules to load the data.
• Unix Scripts were written at various situations like event automation and job scheduling.

Environment: Informatica PowerCenter 7.x, SQL Server2005, HP-UX, Erwin 4.0, Teradata, Oracle 8i, WINDOWS XP, UNIX

Confidential

System Engineer

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.

Confidential

Software Engineer

Responsibilities:

• Studied the project requirement and designed the project.
• Created tables, views, synonyms and sequences
• Created Database Triggers, Stored Procedure, Functions and Packages
• Optimized queries using rule based & cost based approach.
• Used SQL Loader for data loading.
• Modified existing forms, reports, and graphs as per the enhancement.
• Tested all the new and modified program units.

Environment: Oracle 7.x, SQL*Forms 3.0, SQL*Plus, SQL*Loader, SQL*Report Writer, Unix, Windows 95