Personal Overview:

• Seven years of extensive experience in complete Software development life cycle (SDLC) with a strong background in Design/Modeling, database development and implementation of various business intelligence and data warehouse / data marts projects that cover gathering Business Requirements, GAP Analysis, Development, Implementations and Documentation.
• Over Six years of extensive experience as an Informatica Developer in Data Integration, Migration and ETL process using Informatica Power Center 8.x/7.x/6.x/5.x.
• Experience in integration of various Operational Data Source (ODS) with Multiple Relational Databases like Oracle, SQL server and DB2 and Worked on integrating data from flat files like fixed width and delimited.
• Sound knowledge of Relational and Dimensional modeling techniques of Data warehouse (EDS/Data marts) concepts and principles (Kimball/Inman) - Star, Snowflake schema, SCD, Surrogate keys, and Normalization/De normalization.
• Data modeling experience in designing and implementing Data Mart and Data Warehouse applications using Erwin.
• Extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Experienced in Installation, Configuration, Administration, & Support of Informatica Power Center on Client or Server environment.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer, Workflow Manager and Monitor.
• Worked on Informatica features (i.e. created complex mappings using Source Qualifier, Lookup, Joiner, Aggregator, Expression, Filter, Router, Union, Stored procedure and various other transformations, Configuration of email task for automating the monitoring process, Created and Executed Workflows using Workflow Manager, and Monitor).
• Worked on Slowly Changing Dimensions (SCD\'s) and its implementation (Type1, Type 2, and Type 3) to keep track of historical data.
• Knowledge on business intelligence technologies such as Teradata, Business Objects XI, SQL Server 2008, OLAP, Informatica.
• Knowledge in Data Analyzer tools like Informatica Power Exchange (Power Connect), Informatica Data Quality (IDQ), Informatica Data Explorer (IDE).
• Optimized the Solution using various performance tuning methods (SQL tuning, ETL tuning (i.e. optimal configuration of transformations, Targets, Sources, Mappings and Sessions), Database tuning using Hints, Indexes, partitioning, Materialized Views, External Table, Procedures, functions...)
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Worked on Data warehouse projects in Financials, Pharmaceuticals, Insurance, and have acquired comprehensive ETL experience and skills.
• Experience interacting with Business users and Architecting high level requirements, high level design and detailed level design documents.
• Experience with multi-terabyte platforms.
• Have worked on scheduling tools like Autosys, DAC (Data warehouse Administration Console).
• Solid understanding of OLAP concepts and challenges with large sets of data.
• Good Project Coordination skills, onsite coordination and offshore team management.
• Proficient in Toad, SQL navigator, and UNIX Shell Scripting.

Summary of Qualifications:

Data Warehousing ETL:

Informatica Power Center 8.x/7.x/6.x/5.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server) ETL, Power Exchange 8.0, Repository, Metadata, Data Mart, OLAP, OLTP.

Data Modeling:

Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flack, Fact, Dimensions), Entities, Attributes.

Databases:

Oracle 10g/9i/8.0, MS SQL Server 7.0/2000/2005/2008, DB2, OLTP, Teradata.

Programming:

SQL, T-SQL, PL/SQL, SQL*Loader, Unix, Shell Scripting, SQL Tuning/Optimization, C, Java, HTML.

Tools: TOAD, SQL*Plus, Excel, Word, Autosys, Control-M, Erwin .

Reporting Tools:

Business Objects, Oracle Business Intelligence.

Environment: UNIX, Windows XP, Windows 7, Linux.

Client: Confidential,WA

Position: Informatica Developer

Confidential, is the hub for introducing new tools and technologies in all over World. The Project is mainly based on cloud computing which is an emerging Methodology used in highly developed IT companies. Cloud Computing is a new paradigm in software industry by which software, data access and storage services are provided to end users without the need or limitation of the physical location and storage requirements at end-user side. Microsoft has been successfully transitioning to cloud computing in past few years and has launched innovative new products like office 365, CRM Online, Windows Azure and Windows Azure in the cloud.

The Objectives of this project is to

• To integrate the Online Service information
• Provide core platform for business intelligence solution.
• Provide preliminary set of metrics for report generation.
• Report Delivery mechanism through MSRA.

Responsibilities:

• Used Data vault model and maintained ETL (Data Extraction, Transformation and Loading) mappings accordingly as per the user requirements.
• Created a huge number of complex mappings to implement ETL throughout from Source (SQL Databases, CSV files and Flat files) to Staging (HUB’s, SAT’s, LINK’s, LINKSAT’s) and then to DataMart (Dimensions, Facts and Materialized Facts).
• Created mappings using Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations, Union transformation, Stored procedure transformation.
• Used debugger to test the data flow and fixed the mappings.
• Implemented slowly changing Dimensions Type-1 and Type-2.
• Maintained version control to keep track of the changes in the Dev.
• Written complex SQL, T-SQL queries as source query overrides and wrote SQL scripts to update the source queries in the database.
• Created Pre SQL scripts and Post SQL scripts in the workflow sessions when needed.
• Used Dynamic parameter files concept. Loaded parameters files using SQL Server 2008 database.
• Performed Unit testing and validated. Also involved in Integration testing and Patch drops (Resolved issues in bits to UAT).
• Deployed Informatica objects from Dev. to UAT and maintained versions at each deployment.
• Extensively involved in resolving the bugs using Visual Studio team Foundation (VSTF 2010 Premium) where all the bugs are raised.
• Involved in development of MSRA Reports (Microsoft Reporting Analytics), which is Microsoft Cloud BI reporting solution.

Environment: Informatica Power center 9.0.1(Designer, Workflow Manager, Workflow Monitor, Repository Manager), SQL Server 2008, Visual Studio Team Foundation Server 2010 Premium, Windows 7, MSRA 02.07.0001.

Client: Confidential,IL

Position: ETL Onsite-Coordinator

This project is mainly about maintaining the sales data in the data warehouse to predict the sales and decision making for future purpose. SalesOps Analytics project has different modules like sales force, Xactly system, MS SQL SERVER as a source to integrate the data into target system oracle and then into BI server for decision making.

Responsibilities:

• Worked as an ETL onsite coordinator at client site.
• Involved in meetings to gather information and requirements from the clients.
• Analyzed the requirements to identify the necessary tables that need to be populated in to the staging database.
• Interacted with users about the requirements and reported the status of the project on weekly basis.
• Coordinated with offshore team and conducted meetings twice a day to discuss on project status up-to-date.
• Have documented design, requirement documents. Documented clearly the implementation release notes to production team to implement the code correctly in production.
• Played a crucial role as a team lead and delivered project to users on schedule.
• Extensive hands on experience in ETL domain. Have Designed, Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Power Center -Designer to extract the data from source systems to target systems.
• Executed, scheduled workflows using Informatica Cloud tool to load data from Source to Target.
• Created mappings using transformations like Source Qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, Union, and Stored procedure, and XML transformations.
• Created mapplets, mappings, complex worklets and workflows.
• Implemented Type1 and Type2 methodologies in ODS tables loading, to keep historical data in data warehouse.
• Solid extensive exposure to PLSQL and UNIX Shell Scripting
• Extensively worked on OBIEE testing.
• Have migrated the code into different instances using kintana application.
• Worked on Apex coding and tested it as the user need.
• Have involved in resolving the issues faced during the testing.
• Used IOD tool to run the workflows in order to bring data from source system to staging area.
• Prepared unit test cases and SIT test cases.
• Have done unit testing, SIT testing and UIT in different instances.
• Tested and compared data on OBIEE results with Database results.

Environment: Informatica powercenter6.1/8.1,Informatica Cloud,SQL Server, Oracle, winscp, OBIEE APEX, Unix Shell scripting, Kintana, Compass, IOD, Citrix.

Client: Confidential,NY

Position: Informatica Developer

Confidential,is a world leader in Quality of Daily Life Solutions in the U.S., Canada and Mexico serving 10 million in 60,000 locations every day. Sodexodesigns, manages and delivers comprehensive service solutionsthroughOn-site Service SolutionsandMotivation Solutionsto create an outstanding experience for the people. Worked on Cornerstone Project is mainly about HR Payrolls in an enterprise in different department levels in different areas.

Responsibilities:

• Worked closely with Business Analyst and the end users in writing the functional and technical specifications based on the business requirement needs.
• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets.
• Designed, Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Power Center -Designer to extract the data from source systems like Oracle to the target database UNIX Server.
• Created mappings using transformations like Source Qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, Union, and Stored procedure, and XML transformations.
• Extensively used Informatica Functions LTRIM, RTRIM, DECODE, ISNULL, IIF, INSTR and date functions in Transformations.
• Used debugger to test the data flow and fixed the mappings.
• Created Interface validations-Header and Trailers to the target file in UNIX environment.
• Developed UNIX shell and SQL scripts for database monitoring and backups.
• Created UNIX Shell Scripts for batch scheduling and loading process and also used Autosys in scheduling the jobs on daily and weekly basis.
• Worked on Migration Strategies between Development, Test and Production Repositories and also migrated code from V8 to V9.
• Helped in Upgrading Informatica V8 to V9 and went through the server performance issues.
• Worked closely with QA team during the testing phase and fixed bugs that were reported.
• Copied/Exported/Imported the mappings/sessions/ worklets /workflows from development to Test Repository and promoted to Production.
• Involved in Version control of the jobs to keep track of the changes in the Development, Testing Environments of both V8 to V9.

Environment: Informatica Powecenter 8.6.3/9.0.1 (Designer, Workflow Manager, Workflow Monitor, Repository Manager),Putty 0.60& winscp, Oracle 10g/11g, Toad, Autosys 4, SQL* loader, UNIX shell scripting, Windows professional.

Client: Confidential,TX Jan ’10-June ‘10

Position: Informatica Developer

The Business Intelligence Analysis application provides business intelligence analysis services to the sales department through interactive client tools. Data from various online transaction processing (OLTP) applications and other sources is selectively extracted, related, transformed and loaded into the Oracle data warehouse using Informatica Power Center 8.6.3 ETL tool. Then the transformed data from data warehouse is loaded into an OLAP server to provide Business Intelligence Analysis Services.

Responsibilities:

• Analyzed user requirements for the system.
• Supported in Design, Development, Test and Deployment of project development.
• Responsible for verification of functional specifications and review of deliverables. Designed and Created data cleansing, validation and loading scripts for Oracle data warehouse using Informatica Power Center 8.6.3.
• Extensively used Informatica Client Tools - Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, MappletDesigner, and Informatica Repository.
• Created reusable transformations and mapplets to use in multiple mappings.
• Created and monitored workflows and tasks using Informatica Power Center Workflow Manager.
• Extensively used transformations like router, aggregator, lookup, source qualifier, joiner, expression, aggregator and sequence generator transformations in extracting data in compliance with the business logic developed.
• Designed the Data Model using Erwin 7.2 and integrating E-R models with the Oracle Database.
• Analyzed newly converted data to establish a baseline measurement for data quality in data warehouse.
• Created global repository, Groups, Users assigned privileges using repository manager.
• Setting up batches and sessions to schedule the loads at required frequency using Power Center server manager.
• Involved in Version control of the jobs to keep track of the changes in the Development Environment.
• Performed SQL Tuning using Explain Plan, Hints and Indexes
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules, security efficiently and test cases.
• Implemented Type1 and Type2 methodologies in ODS tables loading, to keep historical data in data warehouse.
• Developed Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables.
• Documented the purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.
• Developed Unit test cases for the jobs.
• Provided assistance during user testing (interaction with the users).

Environment: Informatica Power Center 8.6.3/8.6.1 (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Informatica Power Connect, OBIEE, DB2, Oracle11g/10g, UNIX Shell Scripting, TOAD Oracle Designer, ERWIN 7.2.

Client: Confidential,IL

Position: Informatica Developer

Confidential,more than 5 million members in all 50 states across a full range of products and services including group and individual health insurance, Medicare and Medicaid programs, and coverage for specialty services such as workers’ compensation. The primary objective of the project was to make a data warehousing system out of life insurance customers having different insurance policies.

Responsibilities:

• Involved in the full software development life cycle.
• Participated in Requirement Gathering, Business Analysis, User meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.
• Designed, Developed and maintained ETL mappings using Power Center -Designer to extract the data from multiple source systems like Oracle, Flat file and Teradata to the target database Oracle.
• Worked on Teradata utilities Fast-Load, MultiLoad, BTEQ & Fast-Export
• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Used connected and unconnected lookups whenever appropriate, with appropriate caches
• Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations.
• Implemented slowly changing dimension (SCD) for accessing the full history of Customer and transactions of customer. Implement Type I, II, and III changes in slowly changing dimension tables.
• Used Informatica Designer to create reusable transformations to be used in Informatica mappings and mapplets.
• Used debugger to test the mapping and fixed the bugs
• Created and configured workflows, worklets & Sessions to transport the data to target systems using Informatica Workflow Manager.
• Involved in designing technical specifications for building Data Mart.
• Implemented error processing strategy to reprocess error data and manage notification of error data to corresponding business team.
• Assisted in Data Modeling using Erwin modeling tool .Captured data error records corrected and loaded into target system and used CDC for changing data.
• Created Effective Test Data and Unit Test cases for Vendor Reporting System to ensure the successful execution of the data loading processes, Created sql scripts to verify test cases from source to target database oracle.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Used Autosys Scheduler in creating and scheduling the job’s run timings.
• Worked in fixing poorly designed mappings, workflows, worklets, sessions, and target data loads for better performance.
• Wrote SQL, PL/SQL codes, stored procedures and packages.
• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
• Involved in Fine-tuning of sources, targets, mappings and sessions for Performance Optimization.
• Created Complex Reports by using functionalities like Slice and Dice, Drill Down, Master Detail, etc.
• Created and deployed WEBI Reports through Info View.
• Worked on Broadcast Agent server and Customized Scheduling, Refreshing and Publishing Reports.

Environment: ETL- Informatica Power Exchange, Power Center 8.1,,Oracle10g,PL/SQL,Teradata,TOAD, DB2, Erwin7.2, Autosys, XML,WinNT & UNIX.

Client: Confidential,India July’06-May ’08

Position: Informatica Developer

Confidential,is a custom oriented and quality conscious software housestrongly believes in customer’s business needs driving the technology and application needs. Credit Card Management System (CCMS) is a web-based software system for credit card management that provides Internet access to bank commercial card customers. CCMS allows Cardholders to view their statements and associated transactions and also it provides the billing and invoicing to the customers.

Responsibilities:

• Extensively involved to implement customer data mart and also data ware house.
• Analyzed the source data coming from Oracle, SQL server, and flat files.
• Extracted data from different source systems like Oracle, SQL server, flat file.
• Worked with Star Schema and Snow flake schema for the data warehouse.
• Extensively used Informatica Power center for extracting, transforming and loading into different databases.
• Designed, developed and tested the different Mappings according to Requirements.
• Analyzed the load dependencies and scheduled the workflows accordingly to avoid the loading conflict issues.
• Analyzed Session Log files in case the session fails in order to resolve errors in mapping or session configurations.
• Developed UNIX shell scripts as part of the ETL process for scheduling.
• Extensively worked in Oracle SQL, SQL*Plus, SQL*Loader, Created database objects like Tables, Indexes
• Performed unit testing, knowledge transfer and mentored other team members.

Environment: Informatica Power Center 5.1.1, Oracle 9i, MS SQL SERVER 2000, SQL, SQL*Loader, UNIX Shell Script.

Confidential,India

Position: PL/SQL Developer

The client is a large Finance company, financing major industries. A large database is maintained regarding the details of the customers and the transactions involved with each customer. The Main system gets various feeds from all sub-systems in different regions by the end of the day and the system we developed processed these feeds to update the corporate database that was used by the marketing and various administrative departments for decision-making.

Responsibilities:

• Involved in design, development, testing and implementation of the application
• Created database Tables, Views, Triggers, Packages, Stored Procedures and Functions
• Designed interactive client server applications using Forms 6i and invoked reports created in Oracle Reports 6i from Oracle Forms 6i
• Developed validation and Transactional Triggers to achieve data integrity and maintain business and technical standards
• Extensively used EXPLAIN PLAN to analyze PL/SQL programs and modify them for faster querying using performance tuning techniques
• Used SQL* Loader, Export, Import to load data into the Oracle database from various sources such as flat files, Excel sheets etc.
• Generated reports periodically as per functional requirements using Oracle Reports 6i and customized reports for managerial needs
• Documented Technical as well as end user manuals and trained end users on using the new system

Environment: Oracle 8i Database, SQL, PL/SQL, Oracle Forms 6i, Oracle Reports 6i, SQL * Loader, UNIX, Windows XP/NT, MS-Office