SUMMARY

• More than 11+ years of IT experience in Enterprise Data Warehousing development and consulting.
• Experience in ETL, OLAP and Software Development and acquired excellent analytical, co - ordination, interaction skills, have immense leadership potential. Continually provided value-added services to the clients through thoughtful experience.
• Experience in complete life cycle (Gathering Business Users Requirements, System Analysis, Design & Data Modeling, Development, Testing) in Data Analysis, Business Intelligence and Data warehousing.
• Strong Data Architecture & Modeling skills to design Data Warehouse/Data Marts, ODS, Staging Areas using Relational and Dimensional modeling techniques
• Extensively involved in migrating various Informatica sessions and mappings from one version to another.
• Expertise in developing Mappings and Mapplets, Sessions, Workflows, Worklets and Tasks using Informatica Power Center Designer, Workflow Manager and Batch processes.
• Experienced in database design, data analysis, development, SQL performance tuning, data warehousing ETL process and data conversions/migrations.
• Strong Experience in performance tuning of ETL Informatica Mappings, Pushdown Optimization (PDO) techniques and PL/SQL packages.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using PL/SQL and T-SQL.
• Expertise in PostgreSQL database objects development and supporting the existing code.
• Effectively made use ofTable Functions, Indexes, Table Partitioning using Range Partitions, Analytical functions, Materialized Views and Query Re-Write.
• Extensively involved in loading data into Oracle tables usingSQL Loader.
• Involved in developing logical and physical data models to design OLTP system.
• Good experience withPerformance Tuningfor Oracle RDBMS usingExplain PlanandHINTS.
• Strong expertise in Teradata Utilities - Fast Load, Multi Load, TPump, Fast Export and BTEQ.
• Experience in developing ad-hoc reports using the SAP business Object application.
• Domain expertise in Telecom, Hi-tech and Media & Information Science.
• Proven ability to effectively manage time, resources and prioritize tasks in order to consistently complete projects according to specifications and on time.
• Creative problem solving capabilities, analytical approach and exceptional technical writing skills.
• Excellent communication with good interpersonal and team organizing skills.

TECHNICAL SKILLS

RDBMS: Oracle 9i/10g/11g client, MS SQL Server 2000/2005/2016 , Teradata, PostgreSQL 9.0/9.1

ETL Tools: Informatica Power Center 7.1.4/8.1/8.6/9.1/9.5/9.6 (Designer, Workflow Manager, Workflow Monitor, Rep. Server, Repository Manager, Mappings/ Mapplets/Power Center transformations), Informatica Cloud

Data Modeling: Erwin r7.1/7.2Data modeler, ER Studio, Star-Schema Modeling, Snowflakes Modeling, FACT & Dimension Modeling

Reporting Tools: SAP Business Objects 4.1 Web Intelligence.

Operating Systems: Unix, Linux, Microsoft Windows 95/98/00/NT/XP/7, Mac OSX, AIX

Languages: SQL, PL/SQL, UNIX Shell Scripting, Teradata Load Utility Scripts, SQL Loader

Packages: MS Office (MS Access, MS Excel, MS PowerPoint, MS Word)

Scheduler: TWS Scheduler, ESP Scheduler, AutoSys, AppWorx, Control M and Crontab.

PROFESSIONAL EXPERIENCE

Confidential - Southborough, MA

Senior ETL Developer

Responsibilities:

• Involved in requirement gathering and technical discussion to re-write Legacy Gateway product to Informatica ETL.
• Extensively used Informatica Power Center 10.1 for extracting SQL Server source data and loading across different ikaMedicare Gateway modules.
• Converted complex SQL Server procedures/functions into Informatica mappings as part of Legacy Uplift Program.
• Providing support to existing SQL Server database objects in Claims and Billing module.
• Actively involved in PostgreSQL development for Member related modules in ikaSystems that includes functions, views and stored procedures.
• Extensively used Informatica Designer to create complex mappings using different transformations including SQL transformation, Joiner, Update Strategy, Aggregator, Rank, Joiner, Sequence Generator, Sorter, Union, Java and Normalizer to pipeline data to different targets.
• Deployed reusable transformation objects such as transformations, mapplets, worklets to avoid duplication of metadata, reducing the development time.
• Executed, scheduled workflows using Informatica Cloud tool to load data from Source to Target.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Developed Informatica Workflows, sessions, mappings and dynamic parameter files.
• Extensively worked on the performance tuning of the Informatica mappings, sessions & PL/SQL queries to improve system performances and total elapsed time.
• Converted ETL code ran against Legacy code for data comparison and fixed found discrepancies.
• On boarded new client PREMERA in both Legacy and ETL code and compared data for any mismatches.
• Develop Test case documents for Unit Test, System Integration Test and facilitate User Acceptance Testing to check data quality and ensure data between Legacy and Informatica processes matches.
• Performed extensive Troubleshooting as part of Unit Testing and System Integration Testing.
• Developed Control-M jobs to run the workflow sessions thru scheduler tool.

Confidential - Detroit, MI

Senior ETL Developer

Responsibilities:

• Involved in gathering requirements for EDW Foundation layers, BOB data loads of multiple claims and member data, data feeds development to prepare detailed technical design documents adhering BCBSM standards and processes.
• Documented Analysis, Design, Build, Testing and Implementation Plan in the Business Intelligence Data Request (BIDR) document and also prepare SDLC documents for any Data Quality enhancements and development.
• Extensively used Informatica Power Center 9.6.1 for extracting data from multiple source systems like XML, flat files, RDBMS tables, transforming and loading data into different target systems.
• Extensively used PL/SQL to extract the data as per the Business Request and to correct the history data in production.
• Implemented the concepts of Slowly Changing Dimensions (SCD) with Type I/II.
• Used Informatica Designer to create complex mappings using different transformations including SQL transformation, Data masking, Joiner, Update Strategy, Aggregator, Rank, Joiner, Sequence Generator, Sorter and Normalizer to pipeline data to the different target systems.
• Create database objects like tables, indexes, triggers, packages, stored procedures, functions etc.
• Create shell scripts to run daily jobs, file transfers and extract the files from remote location for data loads.
• Extensively worked on the performance tuning of the Mappings, sessions & PL/SQL queries.
• Optimize performance of ETL by the use of index creation, mapping partitioning, encoding logic, optimizing buffer size and modifying commit intervals in data load.
• Extensively used TOAD to analyze data and fix errors and develop.
• Performed Configuration Management (CA SCM) to migrate Informatica mappings, sessions and workflows from development to test to production management.
• Created Test cases for Unit Test, System Integration Test and facilitate User Acceptance Testing to check the data quality
• SIT Defect Tracking and reports are done by Rational Clear Quest.
• Responsible in obliging through many industry standards like HIPAA and guidelines in developing and migrating the code from one environment to another.
• Worked with Business analysts and Data Stewards for requirements gathering, business analysis and designing of the data warehouse.
• Worked with cross-functional teams such as QA, DBA and Environment teams to deploy code from development to QA and Production server.

Confidential, Des Moines, IA

Technical Lead/ ETL Developer

Responsibilities:

• Defines maintains, develops and supports specific software applications that support Confidential ’s business requirements.
• Analyzes, develops, test, implements, documents and maintains programs and systems that meet business requirements.
• Supports and adheres to Confidential Software development lifecycle (SDLC), operational procedures and development and security standards by following required processes.
• Extensively used Informatica Power Center for extracting, transforming, and loading into different databases and planning and preparing technical reports.
• Creating Informatica Workflows, sessions, mappings, dynamic parameter files.
• Developed the ETL logic to load data from various heterogeneous systems such as Oracle, Teradata, Flat files.
• Tuning ETL mappings and SQL queries to improve system performances.
• Extensively used the partitioning features of Informatica mappings.
• Implemented Informatica PDO techniques to push the transformation logic to the target databases.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Developed triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically.
• Involved in implementing table partitions using Range Partitioning techniques.
• Worked on external hints during the sql optimization to fast up the SQL process.
• Developed PackagesandProceduresto automatically drop and re-create table indexes.
• Performance Tuned SQL queries which takes long time to process the request using Explain Plan, Hints to reduce the response time.
• CreatedTables, Views, Constraints, Indexes and usedBulk Collectionsforbetter performanceand easy retrieval of data.
• Familiar with SQL*Loader to load data from external source like flat files into database tables.
• Created materialized views using different clauses like FAST, COMPLETE, FORCE, ON COMMIT.
• Developed Database Triggers for audit and validation purpose. Used pipelined functions for faster data accessibility. Writing validation packages using PL/SQL package.
• Writing Stored Procedures, SQL scripts and calling them Confidential pre and post session.
• Developed/modified UNIX shell scripts.
• Interacting with Functional Team to validate the Source to Target column mappings and extraction logic.
• Preparing Unit/System Testing Test Plans and reviewing their Test Results.
• Coordinating with system testing/TMO team for achieving the required test results and delivered results are as expected.

Confidential - Norwalk, CT

Senior Lead ETL Developer

Responsibilities:

• Interaction with the Business Users to analyze the Business Requirements, High Level Document (HLD), Low Level Document (LLD) and transform the business requirements into the technical requirements.
• Providing Technical and functional guidance to team and helping them to resolve the day to day issues.
• Working on design and development of Informatica mappings, workflows to load data into OFSAA Staging layer.
• Used Informatica Power Center to create mappings, sessions and workflows for populating the data into staging tables from different source systems (Teradata, Oracle and Flat files).
• Created mappings using various Transformations like Source Qualifier, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, Sequence Generator and Aggregator.
• Implemented PDO techniques Confidential both source/target tables to improve performance.
• Performance tuning of Informatica mappings by tuning the Source, Target and Lookup queries and enabling the cache options.
• Leveraged the advanced features such as data masking transformation and Pushdown optimization for developing mappings.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Developedmaterialized viewsfor data replication in distributed environments.
• Handling huge tables by Table Partitioning and Index Creation.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data.
• Extensively worked in Oracle SQL and PL/SQL objects Stored procedures, Stored functions, Packages, TYPE Objects, Triggers, cursors, Parameterized cursors, Views, Materialized Views, PL/SQL collections.
• CreatedPackagesandProceduresto automatically drop and re-create indexes.
• Partitioned fact tables andmaterialized viewsto enhance the performance.
• Involved in preparing stored procedures and complex sql to filter data Confidential source qualifier level itself.
• Involved in DBA and BI Server related issues and activities.
• Informatica Administration activities viz. repository refresh, objects migration and managing users and groups.
• Involved in Unit Testing, User Acceptance Testing (UAT) to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Prepared and used test cases to verify accuracy and completeness of ETL process.
• Extensive Troubleshooting skills.

Confidential - Eagan, MN

Lead ETL Developer

Responsibilities:

• Worked closely with the business in understanding their requirements and translating them to BRD and SRDs.
• Worked extensively on Data modeling for various Data marts in EDW, data profiling and cleansing.
• As a Lead ETL Developer designed and created 40+ mappings/sessions/workflows to move data from SAP BW source system to reporting data warehouse in MIS industry.
• Built mappings to load data into flat files/database which was used by the downstream applications.
• Developed unit and system test cases, using System Procedures to check data consistency with adherence to the data model defined.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.
• Partitioned large Tables usingrange partition technique.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Analyzed existing sql queries, tables and indexes for performance tuning and advised based on the loading time.
• Leading a team of developers both onshore and offshore to integrate EDW with multiple systems.
• Having migrating experience to Production servers and handled all the issues during stabilization/warranty support period.

Confidential, Cupertino, CA

Senior ETL & Teradata Developer

Responsibilities:

• Involved in requirement gathering discussions with Functional Team and also with business users, if required in delivery estimation.
• Involved in preparing Development Requirement & Technical Design document.
• Co-ordination/Development of mappings using Informatica to populate data on the Data Warehouse (EDW).
• Developed Teradata code for data load to EDW using Teradata load utilities.
• Worked with Performance/DBA Team to improve application performance.
• Developed loading scripts using Teradata Utilities - TPT, Fast Load, Multi Load, TPump, Fast Export and BTEQ.
• Created tables, Materialized Views, Triggers, Packages and Procedures.
• Vast experience in writing complex Procedures, Functions and Materialized views.
• Performance tuning of complex PL/SQL blocks and Query Optimizing.
• Performed data quality check and data integrity.
• Developed System Testing Test Plan and reviewed Test Results.
• Coordinating with Functional team for Customer Acceptance Test.
• Interaction with clients on delivery perspective on daily basis.

Confidential - Durham, NC

Teradata & ETL Developer

Responsibilities:

• Involved in low-level design and developed various jobs and performed data loads and transformations using different transformation of INFORMATICA.
• Involved in data analysis, development, debugging data issues, modifying/optimizing the existing code.
• Converted the PLSQL Procedures and Packages into Informatica Mapping
• Developed Informatica mapping to load Aggregate tables which is used for reporting purposes.
• Developed UNIX scripts and scheduling Informatica jobs.
• Involved in developing Teradata load utility scripts.
• Performance tuning has been done to increase the throughput Confidential both mapping and session level and SQL Queries Optimization as well.
• Identified SQL queries running longer and performed tuning using Explain Plan, Hints to reduce the response time.
• Experience in PL/SQL including all database objects: Stored procedures, Stored functions, Packages, TYPE Objects, Triggers, cursors, Views, Materialized Views, PL/SQL collections.
• Experience in PostgreSQL database development and created views, materialized views, triggers, functions and stored procedures.
• Designed multiple refreshes for the Database by flipping over the Database and delivering the most current data to the users.
• Developed UAT/SIT Test Plan and reviewed Test Results.
• Involved in unit testing to test the processed data and user acceptance testing.
• Experienced in troubleshooting and fix the different Development/Production environment issues.
• Involved in production support activities for the existing applications and generated regulatory reports to provide it to business.
• Also, involved in Informatica Administrator activities to upgrade Informatica version.

Confidential

ETL Developer

Responsibilities:

• Performed major role in understanding the business requirements, designing and loading the data into DWH.
• Assigning the trouble ticket to the offshore team.
• Performed root cause analysis for the issue mentioned in trouble ticket and developed code for fixing the issue.
• Used most of the transformations such as Source Qualifier, Filter, Joiner, Sequence Generator, Expression, Aggregator, Connected & Dynamic Lookup, Normalizer, Router and Update Strategy.
• Prepared Solution Review document (SRD) followed by development.
• Involved in modifying Packagesandstored procedures.
• Proposed analysis and code fix to the client and getting approval.
• Involved in unit testing to test the processed data and user acceptance testing.
• Moving the code to system testing team and support the same till the code moves to production.
• Preparing ST plan and Deployment Guide for production deployment.
• Validating production data after their first successful job run post-deployment.
• Code migration to Production according to the Change Management System.
• Effective interaction with Users and coordinating with offshore team.