SUMMARY

• Information Technology Sr. ETL Developer with around Ten (10) years of experience and broad based technical knowledge and in - depth understanding of system/software engineering lifecycle phases.
• Certified Informatica developer and Microsoft BI Technology Specialist (MCTS)
• Extensive and depth knowledge in Informatica power Center and Informatica IDQ for data migration and data quality.
• Experienced in Gathering & Analysis of requirements, implementation, testing and developing ETL solutions for leading clients.
• ETL experience in using SSIS, Informatica Power Center, Informatica IDQ and Pentaho.
• Have good hands on experience in ETL and Data Cleansing applications using Informatica Power Center, IDQ, SQL
• Providing post-implementation, application maintenance and enhancement support to the client with regard to the product / software application.
• Experience in the Production Support Environment managed Daily/Weekly/Monthly/Yearly Cycle.
• Experience in upgrading Informatica form 8.5 to 9.1.
• Good understanding in Ralph Kimball methodology for Star and Snowflake Schemas, Fact and Dimensions tables, Physical and Logical Data Modeling.
• Proficient in Oracle 11g/10g/9i, MS SQL Server 2012/2008/2005 , (database triggers, materialized views, Packages, stored procedures, functions, and database constraints), SQL Loader, oracle supplied utilities.
• Hands on other Databases like Sybase and IBM DB2. Experience in handling other Source systems like Flat files, CSV, XML and QVD files.
• Experience in Data modeling using SAP Sybase Power Designer & Hands on ERWIN tools.
• Used DB tools like SQL Developer, Embarcadero Rapid SQL, PL SQL Developer and TOAD.
• Used Scheduling tools like TWS, CONTROL-M to schedule the ETL jobs.
• Developed Test strategies to verify the ETL work flows, Data flows and transform logic based on Extraction and Loading.
• Ability to analyze existing systems, conceptualize and design new ones, and deploying innovative solutions with high standards of quality.
• Domain expertise of working for Investment Banking, Insurance, and Health Care
• Good experience in various ETL and Business Intelligence tools that includes Informatica, power Center IDQ, SSIS and Reporting tools SSRS, Business Objects etc.
• Experience on ER Data Modeling in developing Fact & Dimensional tables, Logical and Physical models.
• Awareness of all SDLC methodologies & models: Fixed Prices, Waterfall, Agile, Iterative in both onsite-offshore model
• Deep understanding of PowerCenter Client tool, IDQ, B2B Data Exchange, B2B Data Transformation.
• Excellent in finding creative solutions to complex problems
• Experience in training new team members and being a mentor to support and provide directions on their day to day work
• Strong experience in TFS, Service Now and VSS for Ticketing and Source controlling.

TECHNICAL SKILLS

Business modeling: Microsoft Visio

Requirement Management: Microsoft Office (Word & Excel)

Front end tools: Microsoft Front page, Microsoft Project, Microsoft Office, Business Objects, SSRS

Defect Tracking: TFS, Excel Versioning

Query and Programming: T-SQL, SQL, Macro, VB script

Databases: DB2, MS Access, SQL Server, Oracle 9i, 10g, 11g

Document Management: SharePoint, Network Directory Management

Methodologies: Waterfall, Agile, Iterative

Tools: Informatica 9.1.0 Hotfix 6, Power Center IDQ, SSIS, SSRS, SSAS, Business Object Universe

Scheduling: TWS (Tivoli Work scheduler), Control-M, SQL server Scheduler

PROFESSIONAL EXPERIENCE

Confidential, Windsor, CT

Sr. ETL Developer

Responsibilities:

• Development and Enhancement breakdown in the form of Sprints and Stories managed by Version One, Following core agile process to complete the project work
• Developed and Support Orange Mart ETL Daily, Weekly and Monthly Cycle, Source to Target mapping creation and fixes production issues
• Involved in different levels of data analysis activities in orange Money
• Worked on several different types of Operational Source Systems like

Confidential

Responsibilities:

• Worked as a ETL Informatica Developer, Data Analyst for team size of 2 and project team size of 6
• Successfully performed and Present an End to End process by doing a small POC
• Started project in Agile then converted in Iterative.
• Setup and request access on Informatica Server and Install Client on each systems for Tactical Data Movement for each member in the team
• Request through RITM to get access desired access on Informatica Unix servers
• Provide desired access to all the team members through RITM - Service now
• For Deployment - Setup Deployment group at Informatica for both Prod and Non - Prod Env. to migrate Informatica code into higher Env.
• Re-design existing Fund Performance System because of the performance issues
• Responsible for data analysis and data mapping for Sybase, DB2, Flat Files
• Created around 35+ Mappings, Sessions and Workflows
• Setup TWS jobs and request admin to schedule with the dependencies defined in standard TWS doc.
• Extensively worked on Monitoring and Scheduling of Jobs usingUNIX Shell Scripts.
• Rapidly developed business rules in power center IDQ and in corporate human tasks into the existing workflow
• Writing Most efficient, highly performant procedures to update back the keys in more than 20 Million of rows with dynamic commit logic from Stage Mart to Mart
• SCD 2 logic is applied in most of the Dimensions and some has SCD 1.
• For standardizing the logic, We have written a re-usable mapplets to handle True change detection
• Mentored team members and provided adequate training to new DA in the project
• Served as a liaison between the business specialists and the technical team
• Responsible for gathering user requirements that are specific to our scope of work.
• Created Functional Requirement, reviewed with stakeholders and received sign-offs
• Created Requirements Traceability Matrix document reviewed with stakeholders and received sign-offs
• Participated in Required Data Elements sessions and identifying the sources
• Sources

Confidential

Responsibilities:

• Worked as a ETL Informatica Developer as individual contributor
• Setup and request access on Informatica Server and Install Client on each systems for Task manager for each member in the team
• Developed dynamic Export/import task through ETL Mapping
• Responsible for data analysis and data mapping for DB2, Oracle
• Created 4 Mappings, Sessions and Workflows in Informatica 9.1.0
• Setup TWS jobs and request admin to schedule with the dependencies defined in standard TWS doc.
• Writing most efficient, highly performant thread based ETL Mappings to export and import the files in a short span of time.
• Informatica Scheduling done through TWS
• Responsible for gathering user requirements that are specific to our scope of work.
• Created Functional Requirement, reviewed with stakeholders and received sign-offs
• Participated in Required Data Elements sessions and identifying the sources

Confidential

Responsibilities:

• Increase visibility and controls over service IDs to reduce risk in Confidential ’s complex, dynamic and diverse environment. The focus of this project is on ‘Service IDs’, however, all IDs are required to be controlled based on their categorization.
• Worked as a System Analyst as individual Contributor.
• Remediating Non-Compliant Service IDs associated with Mainframe, UNIX, Windows, Sybase, Oracle, SQL environment
• Used Waterfall approach to achieve the task and delivered on time.
• This project is based on securing service IDs based on their priority, criticality and purpose of use.
• Managed database Service ID, Collecting Information like Application Name, CI Rating, Control Method etc.
• Manage recurring process with metrics & timeline.
• Coordinate with DBA’s to find out the ID’s is active or Inactive.
• Develop a central, robust inventory/repository of non-personal IDs Participated in multi-agency Mutual funds implementation
• Created user permission lists and roles
• Implement operational stability mechanisms: Monitor high priority IDs to enforce compliance, ensure proper ownership, and implement annual ID review. Follows agile methodology and divide the work in sprints and child stories and distribute and assign the task among team members.
• Risk based remediation approach, address highest priority IDs (aligned to highest risk assets C3/C4 & I3/I4) first; tackle the ‘medium’ as a second priority

Confidential

Sr. ETL Developer

Responsibilities:

• Design and Develop process flows; datasources and attributes; dimensions, facts, metrics, filters, etc., Investment Management Control Reporting and Migration
• Design table structure(s) and Data Model through ERWIN for Data Mart
• Created ETL Packages in SSIS to populate Data Model tables and perform UAT ofdata
• Developed cube (SSAS) based SSRS dynamic dashboard for investment Management reporting
• Provided weekly status report Subscribed through SSRS Engine with Data Driven Subscription.
• Worked with SQL, -T-SQL, Writing Procedures, Functions, Triggers, Functions, views etc.
• Knowledgeable indatadiscovery anddataprofiling. Worked on QWD data files
• Developed highly efficient Rendering Engine to generate 1000+ Report pdfs in just 2 hrs. This Engine is written in SSIS to render the reports and save it as pdf and then send the email to business folks.
• Re-Designed cubes in SSAS and migrated from 2008 R2 to 2012 Microsoft Visual Studio
• Writing Multi-dimensional queries (MDX) to populate data on Dashboard
• Experience in complex stored procedure creation and usingperformance tuning techniques.
• Experience writing complexT-SQL scripts.
• Worked on Data Mining Queries during report migration from multidimensional modeling (MDX) to Tabular model (DAX)

Environment: ETL, Data warehousing, Informatica, SSIS, SSRS, SSAS, MDX, DAX, SSMS (Ver. 2008 R2 -2012)

Confidential, Phoenix, AZ

Sr. ETL Developer

Responsibilities:

• Responsible for gathering requirement of the project by directly interacting with client and made analysis accordingly.
• Helped in building the New ETL Design.
• Coordinated the work flow betweenonsite and offshoreteams.
• Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts.
• Extracting, Scrubbing and Transforming data fromOracle, SQL Server, DB2 and then loading into Oracle database using Informatica, SSIS
• Worked on optimizing the ETL Mappings, Sessions in Informatica.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Implementing logical and physical data modeling with STAR and SNOWFLAKE techniques using Erwin in Data warehouse as well as in Data Mart.
• UsedType 1andType 2mappings to update Slowly Changing Dimension Tables.
• Involved in theperformance tuningprocess by identifying and optimizing source, target, and mapping and session bottlenecks.
• Configuredincremental aggregator transformationfunctions to improve the performance of data loading. WorkedDatabase level tuning, SQL Query tuning for the Data warehouse and OLTP Databases.
• Experience in complex stored procedure, Functions, Views, Triggers, etc. creation and usingperformance tuning techniques.
• Experience writing complexT-SQL scripts.
• Experience in handling team and assist in design and development including challenges and issues.

Environment: ETL, Data warehousing, Informatica, SSIS, SSRS, SSMS (Ver. 2008 R2 -2012), T-SQL

Confidential

ETL Developer

Responsibilities:

• Responsible to implement the various clients’ data (US Health Insurance claims data) using provided Team resources, SSIS,SSRS, SSAS, MS SQL Server 2008 and various Milliman’s In-House tools especially MED-INSIGHT.
• Responsible to distribute the work among the team members and assisting them on the data and domain prospects.
• Responsible for working directly with clients to identify their data quality and their issues and business requirements.
• Responsible to Trouble shoot the Software Errors, Data Quality issues and other failures which occurs during the implementation process.
• Processing the data from Excel files, CSV files, Text files as per the required business logics/tasks using SSIS.
• Creating Certain Stored procedures on the basis of ETL logic and Domain logic.
• Completed training for HIPPA complaint policies
• Works with world class Health Insurer and TPA’s like CIGNA, CAREMARK, AETNA, ANTHEM etc.

Environment: ETL, Data warehousing, Informatica, SSIS, SSRS, SSAS, MDX, DAX, SSMS (Ver. 2008 R2 -2012)

Confidential

Database Design Engineer

Responsibilities:

• Worked on establishing ETL Design in such a way that each ETL Jobs identified to data model (subject area).
• Responsible to build System design, ETL data flow diagram, Building of Packages and Run Book.
• Monitor loads and troubleshoot any issues that arise.
• Build Dr. Address transformation to validate the address.
• Build in depth test Cases and automate the test cases by writing the stored procedures. And did the impact analyst for downstream applications.
• Responsible to create procedures, functions etc.

Environment: SSIS, SSRS, SQL Server 2005, SQL Server 2008 R2