PROFESSIONAL SUMMARY:

SUMMARY

• 7 years experience in Analysis/Design/Development/Implementation of ETL/DWH processes.
• Experience in Data Analysis, Design, Development, Implementation and Testing of Database/Data warehousing/Client/Server/Legacy applications using Data Modeling, Data Extraction, Data Transformation, Data Loading and Data Analysis.
• Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading ETL of data from multiple sources into Data Warehouse.
• Experience in design and implementation of Star, Snowflake schemas and multi dimensional modeling.
• Strong knowledge of Extraction Transformation and Loading ETL processes using UNIX shell scripting, SQL Loader.
• Sound knowledge on Informatica/Unix based ETL development and performance tuning
• Experience in integration of various data sources like SQL Server, Oracle, Sybase, MS Access and Flat Files into staging area.
• Thorough experience in unit testing, system integration testing, UAT, implementation, maintenance and performance tuning.
• Strong understanding of RDBMS concepts and experience in writing PL/SQL and SQL statements in databases.
• Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension Type II phenomenon, surrogate key assignment and change data capture.
• Proficient in Data analysis, Data modeling, Database design and Data migration.
• Worked extensively on different types of Transformations like Router, Lookup, Stored Procedure, XML, Expression, Aggregator, Source Qualifier, Sort, Update Strategy, Change Data Capture CDC , Filter, Mapplet for developing jobs.
• Used the Informatica Workflow Monitor and Tivoli Maestro Scheduler extensively to run, schedule, monitor, debug and test the application on development, and to obtain the performance statistics.
• Good working knowledge of various Databases like Oracle 9i, DB2 UDB and Teradata.
• Unique ability to understand long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts with strong analytical, organizational, presentation and problem solving skills.
• Extensively worked on SQLs for data extraction and tuning.
• Used Agile Development Methodology for project requirement gathering in advance. Worked on multi-vendor multi-sourcing models including offshoring .
• Good analytical skills, team skills and capable of working independently.
• Excellent communication and interpersonal skills and strong ability to perform as part of a team and individually.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Informatica Developer

Responsibilities:

• ETL Technical Lead for Enterprise Data Warehouse
• Extracting data from MS SQL server datamart using informatica and Unix shell scripts.
• Joiner, Lookup , Aggregation and serveral other stages were involved before loading to final Aggregated tables.
• Involved multiple sessions to bring data into Type-2 format following BCBSM standards.
• Built a reusable mapplet to do Change data capture CDC that was used in several other mappings.
• Involved in Design, Testing/Documentation and test plan review
• Designed the ETL jobs using Informatica Power Center 9.5.1 to Extract, Transform and load the data into Staging and then into Oracle Database.
• Developed source-to-staging ETL jobs that perform data cleansing, data validation and bring into standard format.
• Design and development of Extract, Transform, and Load processes for extracting data Sql server, Flat Files etc. from various systems and loading into Oracle tables, Flat file.
• Developed Unix shell scripts to invoke informatica workflows.
• Prepared generic workflows and Unix scripts that perform Audit, Balance and Control for all the tables.
• Extensively defined used Parameters and Variables in Mapping for many ETL Jobs.
• Involved in Performance tuning of all the ETL jobs and DB queries for bottleneck encounter during development and after migration to production environment.
• Created UNIX scripts for file transfers FTP .
• Create, Publish, Schedule Informatica Statistics report for leadership using Data Analyzer and IDS
• Created Tivoli jobs and scheduling process to run the jobs in development and test environment.
• Worked to get the better performance of the ETL jobs where the file size was 5 gig based on Performance Statistics
• Developed Source to Target mapping document for all the ETL jobs including but not limited to Unit Test Cases.
• Worked closely with ETL Architect in finalizing the requirements and in preparing the ETL Technical design document
• Worked with Toad and Toad for Data analyst to interact with Oracle 10g and used the tool for data validation
• Involved in fine tuning, trouble shooting, bug fixing, defect analysis and enhancement of the Informatica workflows.
• Worked with the SCM code management tool to move the code to Production

Environment: AIX, Informatica 8.6.1/9.5.1 Power Center, SQL Server 2008, Tivoli workload scheduler, Toad 8.5 , Informatica data profiling, Informatica power exchange, Putty, WinSCP, SCM Serena change management

Confidential

ETL Tech Lead

Responsibilities:

• Attending the meetings with Data Architects and Business Analysts of both Ameriprise and Bank of America to understand the data flow, existing logic and create Data Mapping sheet for Informatica mapping development to convert the existing logic to integrate with Ameriprise Infrastructure and technology.
• Creation of Business Requirement Document on the business logic involved in creation of feeds.
• Creation of mapping document on the approach to be used for the migration of feed generation logic from BOA to distributed end in Ameriprise infrastructure using Informatica Power Exchange and Informatica PowerCenter
• Analysis of business requirements and preparing the Design Documents.
• Reviewing the Design and Requirements documents with Architects and Business Analysts to finalize the Design.
• Creation of Database Design Document on the approach to be used for creation of SQL server Database tables which will be further used by DBA's to create the tables .
• Creation and validation of source layout using Informatica Power Exchange.
• Creation of mappings and workflows using Informatica PowerCenter by implementing the feed generation logic captured in reverse engineering document.
• Creation of TWS Jobs to automate the feed generation process.
• Reconciliation of the feed generated at mainframes with the feed generated at distributed end by automated testing.
• Attending the in person meetings with the clients on daily basis.
• Reporting to the clients on the status of the deliverables.
• Involved in the preparation of Test cases and Test Scripts.
• Handling User Acceptance Testing UAT with the downstream feed users for validation of feeds.
• System Integration Testing will be done to check whether all the applications Mainframe, TWS, ETL Databases are working fine when it's integrated.
• Monitoring the TWS jobs, Informatica Monitor and Unix Boxes often to ensure the success of jobs.

Environment: IBM Mainframe, IBM Z/OS, UNIX, WINDOWS, Informatica Power Center, Informatica Power Exchange, SQL Server ,Oracle, TWS, Control-M.

Confidential

ETL Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Translated requirements into business rules made recommendations for innovative IT solution
• Involved in the Design and development of Data Mart and populating the data from different data sources using Informatica.
• Documented data conversion, integration, load and verification specifications.
• Parsing high-level design specifications to simple ETL coding and mapping standards.
• Worked with the various enterprise groups to document user requirements, translate requirements into system solutions and produce development, testing and implementation plan and schedule.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
• Developed, documented and executed unit test plans for the components.
• Documenting the developed code, run the sessions and workflows, while keeping track of source and target row count.
• Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Extensively used un-connected Look-Ups for minimizing the run time and add to the performance of the server, while making sure to avoid duplicates of data from other source systems.
• Created pre-session and post-session shell scripts and mail-notifications.
• Extensively worked on the Informatica Designer, Repository Manager, Repository Server, Workflow Manager/Server Manager and Workflow Monitor.
• Extensive use of Performance tuning techniques to minimize the run time and create pre-session caches with load being balanced on server.
• Created Workflows containing command, email, session, decision and a wide variety of tasks.
• Scheduled batch and sessions within Informatica using Informatica scheduler and also wrote shell scripts for job scheduling.
• Employed performance tuning to improve the performance of the entire system.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Understanding the entire functionality and major algorithms of the project and adhering to the company testing process.

Environment: Informatica Power Center 8.6/8.1, Oracle10g, PL/SQL Developer, SQL Server 2005, UNIX, Windows 2003.

Confidential

Informatica ETL Consultant

Responsibilities:

• Analyzed the source data arriving from different source systems like Vendor Management Inventory, Invoice Processing System, Materials Forecasting, Purchase Orders and Requisition on Stores.
• Interacted with business teams for gathering business requirements and involved in documentation of specifications.
• Designed and developed the ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation.
• Developed standard mappings using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Developed mapplets for re-usability in ETL process.
• Involved in performance tuning and unit testing.
• Used Pipeline partitioning and External Loader to improve Session performance.
• Scheduled and ran Extraction and Load processes and monitored tasks and workflows.
• Tuned the MMW databases stage, target for better, faster and efficient loading and user query performance.
• Involved in creating reports using Business Objects 8.1.

Environment: Informatica PowerCenter 8.1, Erwin 4.1, Sun-OS, UNIX Shell Scripting, Oracle 10g, PL/SQL, BO 8.1, Windows XP/2007.

Confidential

ETL Developer

Responsibilities:

• Business Analysis and Requirements gathering from the Business Users and Technical document design of these requirements.
• Created the physical logical data models using ERwin.
• Designed mapping documents and developed ETL mappings using Informatica.
• Designed and developed Informatica mappings to build business rules to load data.
• Extensively worked on Informatica Lookup, Aggregator, Expression, Stored Procedure and Update Transformations to implement complex rules and business logic.
• Implemented Slowly Changing Dimensions, for the data which were used to analyze the data.
• Implemented Slowly Changing Dimensions for the drugs that were been tested on patients to store the history of patients data.
• Used Informatica power center for ETL extraction, transformation and loading data from heterogeneous source systems.
• Involved in importing Source/Target Tables from the respective databases and created Reusable Transformations Joiner, Routers, Lookups, Rank, Filter, Expression, and Aggregator .
• Mapplets and Mappings using Designer module of Informatica.
• Analyzed and created Facts, Dimension tables.
• Created Stored Procedures for data transformation purpose.
• Generated PL/SQL and Shell scripts for scheduling periodic load processes.
• Extensively worked on the Database Triggers, Functions and Database Constraints.
• Worked on External Loader to populate the target Oracle.
• Performed Unit regression testing for the Application.

Environment: Informatica Power Center 7.1/8.1 Source Analyzer, Warehouse Designer, Mapplets Designer, Mapping Designer and Transformation developer , ERwin 4.0, DB2, SQL Server 7.0/2000, Oracle 10g, Shell Scripting, SQL, PL/SQL, Toad, Sun Solaris 2.6, Windows, 2000 Server.