SUMMARY

• Over 7+ 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 9.x/8.x/7.x/6.x/5.x for developing the Data warehouse loads as per client requirement.
• Experience in implementing CDC using Informatica Power Exchange 8.x/7.x.
• Excellent knowledge in identifying performance bottlenecks and tuning the Informatica Load for better performance and efficiency.
• Excellent knowledge of Informatica Administration. Involved in creation of folders, users and their permissions.
• Experience in deploying Informatica code using Informatica deployment groups, import/export option.
• Knowledge in Multi - dimensional and Relational data modeling, Data Flow Diagrams, Process Models, ER diagrams with modeling tools like ERWIN.
• Involved in all phases of data warehouse project life cycle. Designed and developed ETL Architecture to load data from various sources like 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.
• Extensive experience in writing complex SQL queries, PL/SQL procedures, Triggers.
• Experienced In working with various Scheduling tools like Tidal, Autosys, Control-M, Informatica Scheduler and Crontab.
• Experience in writing UNIX shell scripts.
• Experience in developing Web based Distributed and Front End applications in a three-tier architecture using Java, J2EE.
• Used Java Servlets extensively and using JDBC for database access.
• 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 9.1/8.6/8.5/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, Gantt Chart, Task View, 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: Tidal,Autosys,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, Merrimack, NH

Informatica Developer

Responsibilities:

• Involved in developing ETL application using Informatica.
• Interacted with users and involved in creating Requirement and Design Documents.
• Performed extensive data analysis to study the source files.
• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Designed various mappings using transformations like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner transformation in the mappings.
• Created and scheduled Session, jobs based on demand, run on time using Workflow Manager.
• Monitored Workflows and Sessions using Workflow Monitor.
• Used debugger to test the mapping and fixed the bugs.
• Analyzed the bugs, performance of PL/SQL Queries and provided solutions to improve the same.
• Worked extensively with Flat Files and ORACLE Database to load the data.
• 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 9.1/8.6, Oracle 10g, SQL, PL/SQL, UNIX Shell Scripting, TOAD.

Confidential, Buffalo, NY

Informatica Developer

Responsibilities:

• Involved in complete Life Cycle of developing Enterprise Data Warehouse Application and, developing ETL application using Informatica.
• Performed extensive data analysis along with subject matter experts and identified source data and implemented data cleansing strategy.
• Designed data model structure and E-R modeling with all the related entities and relationship with each entity based on the rules provided by the business manager using Erwin.
• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Designed various mappings using transformations like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner transformation in the mappings.
• Created and scheduled Session, jobs based on demand, run on time using Workflow Manager.
• Monitored Workflows and Sessions using Workflow Monitor.
• Used debugger to test the mapping and fixed the bugs.
• Analyzed the bugs, performance of PL/SQL Queries and provided solutions to improve the same.
• ModifiedBTEQscripts to load data fromTeradataStaging area toTeradata data mart.
• CreatedTeradata External Loaderconnections such asMLoad Upsert, MLoad Update, FastLoad and Tpumpin the Informatica Workflow Manager while loading data into the target tables in Teradata Database.
• Handled On-Call support calls from the data center and identifying the issue and performing root- cause analysis and providing them with the solution.
• Worked on Data Migration project and Data Archival project.
• Implemented best practices in Data extraction and Data Cleansing.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.
• Involved in Informatica upgrade project.

Environment: Informatica Power Center 9.1/8.6, Oracle 10g,Teradata, SQL, PL/SQL, UNIX Shell Scripting, TOAD, Erwin.

Confidential, Oakland, 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.
• 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.
• Responsible for migrations/upgrades from V8.0 to V9.0 of Informatica.
• 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.
• Tuning the teradata and Oracle SQL for implementing in production to handle large volumes of data.

Environment: Informatica Power Center 8.6, Business Objects XI R2, Oracle 10g, Teradata, SQL Server 2000, XML Files, TOAD, SQL, PL/SQL, Windows XP, UNIX.

Confidential, Columbus, OH

Sr. Informatica Developer

Responsibilities:

• Interacted with users and involved in creating Requirement and Design Documents.
• Performed extensive data analysis to study the source files.
• Developed various Mappings, Mapplets and Transformations to Extract, Transform and Load the data.
• Worked extensively on Expression, Lookup, Filter and Update Strategy to create maps through Informatica designer
• Worked extensively with XML Source files and SQL database to load the data.
• Created Indexes, views on SQL database for better performance.
• Created Unit test case, and involved in User Acceptance Test to make sure everything is done according to Requirement and Design documents.
• Created and maintained logical models of applications in the client's billing system using Erwin.
• Accountable for Process models for the event driven dynamic data models.
• Developed logical entity-key/attribute mapping across applications in the client's system
• Worked across domains to verify data mappings as well as document changes to the data architecture to keep all domains on the same page.
• Experience in creating reports using Cognos.
• Extracted data from different sources such as SQL Server, Oracle, XML, flat files.
• Raised inconsistencies in meetings to avoid future re-work.
• Developed strategies for data extraction and loading from the source systems across domain using Informatica.
• Interacted with Test Team across domains during the Integrated Product Testing and assisted the Test Analysts in developing SQL Queries for data mining according to the Test Scenarios.
• Coordinated with off shore team.
• Created Informatica mappings with SQL procedures/functions to build business rules to load data. Used the Expression and Aggregator transformations to summarize the volume of stocks traded in a Day/Month/Year. Stored Procedure transformations were extensively used in the ETL Process.
• Responsible for Analysis, Design and Development of Technical documentation.
• Coded and modified to enforce business rules and to improve performance of the system.
• Provided nightly batch loads and supported when issues raised.

Environment: Informatica Power Center 8.6, Cognos, SQL Server, XML Files, SQL, PL/SQL, Windows 7 Professional, SSIS, Sharepoint.

Confidential, Cambridge, MA

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.
• Writing BTEQ scripts & extensively used most popular tool of Teradata system Priority Scheduler in controlling the load of the system where we define performance Group Allocation groups performance periods Resource Partition.
• 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, TERADATA, UNIX, Windows XP Professional, UltraEdit-32, MS Visio 2002, XML, MS-Excel, Ms-Access, SQL Navigator, Clear Quest, Clear Case.

Confidential, Richmond, VA

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 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.
• Implemented CDC using Informatica Power Exchange.
• 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 Control-M 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, Control-M, XML, Flat file, Erwin, Windows XP, UNIX, Shell Scripting.

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 Java Servlets extensively and using JDBC for database access.
• Using JavaScript performed client side validations on Registration module.
• 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.