SUMMARY

• Over 8 years of extensive IT experience in Capital markets, Investment Banking, Insurance, Retail and healthcare domains which helped me to groom as a Data warehouse specialist, by performing SDLC process right from requirement gathering, analysis, design, development, testing, deployment, and Maintenance for various software applications.
• Hands on experience in ETL design, development of SQL Scripts, Stored Procedures, Functions, Packages, Triggers and maintenance using Oracle PL/SQL, DB2 SQL, Informatica Power Center 9.x/8.x/7.x on UNIX and Windows platforms.
• Expertise in Data Analysis, Data Requirement Analysis, Data Mapping, Data Warehousing, Data Migration, Data Integration for ETL processes using Business Intelligence (BI) tools such as Informatica Power Center, Informatica Cloud Data Wizard, Power Exchange Change Data Capture, B2B Data Transformation, Informatica Data Quality, Informatica Data Explorer, MDM, OBIEE etc.,
• Extensive knowledge of various Performance Tuning Techniques on various source systems such as Relational Sources, Flat files, XML, Mainframe COBOL and VSAM files, SAP Sources/Targets, web based applications in Java using Servlets, JSPs and Web Services etc.., Informatica Mappings, Sessions, and Data Base Tuning.
• Proficient in defining and documenting ETL Process Flow, Job Execution Sequence, Job Scheduling and Alerting Mechanisms using command line utilities, integration mappings including dynamic cache lookup, shared, and persistent cache for mappings of Type I, Type II, and Type III Slowly Changing Dimensions and implementing update strategies, incremental loads, and change data capture.
• Strong knowledge of various Data Modeling techniques such as E - R modeling, and Dimensional modeling (Star/Snowflake Schema) and in implementing Error Handling, Auditing and Reconciliation and Balancing Mechanisms in ETL process.
• Committed individual with excellent interpersonal, analytical and communication skills.
• Ability to work simultaneously on multiple projects, work independently as well as a team member.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9, 8.6, 8.5, 8.1, Power Exchange 9.1, 8.6.1, 8.1., Power Exchange (Power Connect), Metadata Manager, Informatica Data Quality, Informatica Data Explorer, Ab-Initio

Databases: Oracle 11g/10g/9i, TOAD, MS SQL Server 2008/2005/2000, Java, MS Access, IBM DB2, IMS etc.

Data Modelling: Dimensional Data Modeling, Star SchemaModeling, Snow Flake Modeling, FACT and Dimension Tables, Physical and Logical Data Modeling.

Environment: s: UNIX, Windows 2000/XP/7, Windows server 2000/2003, HP-Unix, Linux, Z/OS

Languages: C, C++, Java, SQL, PL/SQL, HTML, DHTML, XML, UNIX, Visual basic, JCL, COBOL.

Tools: Visio, SQL developer, MS Office Suite, IBM Web sphere MQ, Autosys, Business Objects, OBIEE

PROFESSIONAL EXPERIENCE

Confidential, New York City - NY

Senior Lead Informatica Developer

Responsibilities:

• Lead the project CHOICE Analytical Data mart for building a new central repository for the members/patients of VNSNY CHOICE business and membership enrolment, eligibility information which is currently stored and processed by external vendor application. Overall responsibility in research, evaluate and synthesize technical information to develop application and build services for the CHOICE business.
• Analyzed complex business requirements for membership eligibility, enrolment data mart of CHOICE, including assigning a unique number for the member irrespective of his enrolment/disenrollment at any point of time, capture the data change on certain Type 2 fields including date fields to store the history, extract and archive historical information since 2007 before go live of new data mart, performance requirements of 50ms per transaction, 2 million transactions per day, etc.
• Interacted with business operation users, various application teams and Business analysts to find a better approach for proposed solutions and preparing data modelling and design data dictionary, Entity Relation Diagrams, High Level & Low Level design documents in MS Visio and to evaluate the performance and reliability of designs.
• Created Informatica Mappings using various transformations, including Filters, Expressions, Lookups, Joiner, SQL, and Update Strategy to bring data from Source systems to Staging areas, then from Staging areas into Dimension and Fact tables. Implemented mapping for slowly changing dimensions (SCD) Type I & Type II to maintain current data as well as historical data
• Frequently used Pre-/Post-Session Tasks, Email, Command, Event Wait and Decision Tasks, as well as Variables and Parameters on Unix server. Created mapping documents to map the processed feed to table columns.
• Design all the Meta data required for processing the feeds. Develop jobs to process the feeds, create the load ready files and develop the scheduling frame work to automate the load using CONTROL-M
• Developed custom Reports/Ad-hoc queries using OBIEE Answers and assigned them to application specific dashboards. Used Filters (global and local) and provided customized Prompts in OBIEE to avoid excessive data showing up in the Reports.
• Configured Intelligence Dashboards in OBIEE 10g by including embedded content such as links/images & HTML objects.
• Assisted with end-user training (both managers and business users) with excellent documentation support to migrate from DISCOVERER to OBIEE and provided technical documentation to access OBIEE.
• Tracking the schedule of BRD, FRD and Technical design documents using Blueprint tool for defining governance structure and planning and budgetary estimates, to minimize the risk of failure and improve the business value.
• Perform code review in regular basis to ensure team is following coding guidelines and tracking them. It provides application insight & quality measurements to various stake holders. Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors
• Administration and maintenance of 700+ Production mappings and over 2,000 total mappings, attending user queries, issues and batch failures using on call weekly batch support.
• Perform root cause analysis and Defect Prevention activities for P1/P2, Sev-1,2 bugs raised in UAT/SIT stage.

Environment: Informatica Power Center 9.5, TOAD, SAS, Windows NT/2003, DB2, CONTROL-M, Oracle 11g, OBIEE.

Confidential, Jersey City - NJ

Senior Data Warehouse Developer

Responsibilities:

• Lead the project technically at Onshore which comprises a team of members (3 programmer analyst, 4 software developers, 4 QA and 3 trainees) and effectively worked on Onsite and Offshore work model.
• Overall responsibility in Research, evaluate and synthesize technical information to develop application and build services for the private wealth management - Brokerage services and accounting subledger services.
• Interacting with operation users, various application teams and Business analysts to find a better approach for proposed solutions and preparing data modelling and design data dictionary, Entity Relation Diagrams, High Level & Low Level design documents in MS Visio and to evaluate the performance and reliability of designs.
• Analysed and created mapping documents to map the processed feed to table columns. Design all the Meta data required for processing the feeds. Develop jobs to process the feeds, create the load ready files and develop the scheduling frame work to automate the load.
• Analysed and verified large complex software, programs, batch jobs to increase the robustness, reliability and correctness of the application. Track and consolidate the business requirements from customers using BRD for eliciting better quality requirements.
• Performing root cause analysis and Defect Prevention activities for P1/P2, Sev-1,2 bugs raised in UAT/SIT stage. Administration and maintenance of 1,100+ Production mappings and over 3,500 total mappings during the weekly on call production support for nightly load process.
• Capture and document Trades Processing and General Ledger functional requirements for legacy applications through reverse engineering. This helps to abstract business functionality, understand functional behaviour, create data-flow rules, analyse the application source code, and extract application structure and program flow.
• Preparing the effort estimations for development tasks for the new enhancements and migration related activities
• Tracking the schedule of BRD, FRD and Technical design documents using Blueprint tool for defining governance structure and planning and budgetary estimates, to minimize the risk of failure and improve the business value.
• Work on RPD files in OBIEE and assist in migrating the reports for the users.
• Perform code review in regular basis to ensure team is following coding guidelines and tracking them. It provides application insight & quality measurements to various stake holders.
• Attend user queries, issues and batch failures using CCM - Customer Call Management.
• Reviews Traceability matrix, SIT Test Plan, Test Cases for each release and shares the Test Progress Report with all the stake holders
• Groom new junior associates and trainees in the team by conducting knowledge sharing sessions

Environment: Ab-initio, SQL, PL/SQL, SQL Server 2008/2014, Windows NT/2003, DB2, Autosys, Oracle 11g, OBIEE.

Confidential, Plano, TX

Sr. Informatica Developer

Responsibilities:

• Gathered complex requirements from business users and transformed them into Low level & high level technical design documents. Participated in design meetings, and prepared technical and mapping documentation.
• Created complex mappings using Informatica Power Center 9.5 for data migration from source systems into Data warehouse which involved Slowly Changing Dimensions, implementation of Business Logic and the mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator. Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Created Mappings using Web Service calls to pull Solutions by text data, as part of texting service for customers. Also, created multiple re-usable Sessions to make use of existing Mapping logic selection criteria to ensure that all customers received the correct account and marketing messages.
• Utilized Command Task and Event-Wait functionality to ensure all Staging jobs complete before running Dimension and Fact loads.
• Worked on configuring the Java class path in the session properties while using third-party Java packages, built-in Java packages, and custom Java packages in a Java transformation and in Java SDK Custom transformation.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically. Used Analyst and Developer tool to create and rules, profiles and mapplets for profiling standardizing source data.
• Debugged mappings to gain troubleshooting information about data and error conditions using Informatica Debugger
• Experience in Informatica Performance Tuning at the mapping level using active transformations early in the mappings, replacing filters with router, using sorter with aggregator, and at the session level using push down optimization.
• Worked in highly structured division across Infra developers/Data Architects (data modelling team)/DBAs/ Change Management etc.
• Conformed to project standards for Unit test/UAT testing. Carried out end - to end testing and supported UAT effort with immediate requirement document change/fixes/resolution for all changes/defects.

Environment: Informatica Power Center 9.5, Informatica Analyst, IDE, Java, Oracle 11g, MS SQL Server 2008/2012, Windows 7, Java, Informatica cloud data wizard.

Confidential, Minneapolis, MN

Data Warehouse Developer

Responsibilities:

• Interacted with business people for Need Analysis and to define Business and Functional Specifications.
• Worked on all phases of the development lifecycle supporting data consistency and data integrity for Enterprise Operational Data Stores, Enterprise Data Warehouses, and Data Marts with 4 Tb of data in multiple environments (Prod, QA, and Test)
• Participated in the Design team and user requirement gathering meetings, and prepared technical and mapping documentation.
• Design, implementation and maintenance of data integration, ad-hoc SQL Server based reporting and BI solutions used to provide key metrics to business leaders in a fast-paced market.
• Worked on Power Center client tools like Source Analyser, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer. Used Power Exchange Data Change option (CDC) to capture modified records.
• Created mainframe data maps using Power Exchange Navigator for the sources and targets. Created and modified COBOL copybook to connect source data using Power Exchange Navigator
• Imported data from various Sources transformed and loaded into Data Warehouse Targets using Informatica.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Optimizing Query Performance, Session Performance.
• Expertise in developing SCD mappings using Power Exchange change data capture.
• Identified and eliminated duplicate datasets and performed Columns, Primary Key, Foreign Key profiling using IDQ 9.5.1. for MDM and IDE tool for data profiling used for Data Analysis for Data migration.
• Analysed Session Log files in case the session fail in order to resolve errors in mapping or session configurations.

Environment: Informatica Power Center 8.5, Informatica Power Exchange Change Data Capture, Oracle 10g, SQL, PL/SQL, TOAD, SQL Server 2005, Windows NT/2003, UNIX, Autosys, Informatica cloud data wizard, OBIEE.

Confidential

Informatica (ETL) Developer

Responsibilities:

• Interacted with the Functional Analysts to understand the process flow and the business.
• Involved in gathering the business requirements from Business Analyst.
• Analysing Source to Confidential mapping Excel document.
• Coordinating the team and assigning dependencies tasks to team.
• Created Data Flow Mappings to extract data from source system and Loading to staging area.
• Analysed the AR data and developed the code to extract the data for the AR module and implemented in the Informatica.
• Extensively worked on Filter, Router, Sequence Generator, Look Ups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Worked on various tasks like Session, E-Mail task and Command task.
• Used Mapplet, parameters and variables in mappings as per the requirement.
• Used Informatica Data Quality for data quality, integration and profiling.
• Worked on Informatica Scheduler for scheduling the delta loads and master loads.
• Involved in performance tuning of the process at mapping, session, source level and at Confidential level.
• Involved in testing by using Informatica workflow manager and monitor, etc. and extensive testing on log files to detect errors.
• Tested different data load databases by comparing source and Confidential table counts and tested Informatica data loads from database to database.

Environment: Informatica Power Center 8.1, Oracle 11g, SQL Server 2005/2008IBM DB2, Teradata, PL/SQL, SQL Developer, Windows XP, Sybase, Java, Informatica cloud data wizard

Confidential

Developer

Responsibilities:

• Analysis and Feasibility Study of User Requirements and discussing with end users to understand their business scenarios
• Preparing functional requirements and converting them to BRD/SRS and discussing the software solution prototype to clients
• Tracking and coordinating with different business teams for identifying and closing the gaps on the process front
• Identifying and Verifying whether the proposed solution meets the customer requirements
• Development of software UI and business logic components and computer programs in mainframe without impacting the existing functionalities
• Development activities for user requested console components, macros, Batch Jobs, NDM Scripts for file transfer to other application within and outside Confidential .
• UAT and Production Support. Given immediate solutions/workarounds for continuity of business.
• Performed root cause analysis for the bugs raised in Production environment, updating the same to my immediate supervisor and taken necessary corrective action to minimize them in future
• Performing the sanity and functionality testing prior to moving the release to UAT
• Prepare reports, manuals and other documentation on the status, operation and maintenance of software
• Maintained the Base line code, document control and release control in share point for easy check-in check-out process

Environment: CHANGEMAN, Z/OS, MVS, Unix, IBM DB2, COBOL, JCL, REXX, VSAM Cobol sources, Oracle 10g, Sql Server 2005, Windows xp