Summary:

• Twelve Plus (12+) years of IT experience in the Analysis, Design, Development, Testing, and Implementation of Business application systems for Financial ( Confidential, Confidential, Confidential, Confidential & Confidential ), Confidential (BCBSNJ), Retail ( Confidential Confidential ., Dell Internal Projects), Confidential ( Confidential ), Confidential (Havard Pilgrim)
• Two Plus (2+) years of Project Management exposure
• Seven Plus (8+) Years of strong Data Warehousing ETL experience of using Informatica Power Center 9.x/8.x/7.x, Mappings, Mapplets, Transformations, OLAP, Autosys, Control M, ESP Scheduling.
• Two Plus (2+) Years of Dimensional Data Modeling experience using Data modeling, Erwin Modeling (ERwin 4.5/4.0) Star Join Schema modeling, FACT & Dimensions tables.
• Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Extensive testing ETL experience using Informatica 9.5/9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Nine Plus (9+) years of Database experience using Netezza, Confidential 12c/10g/9i/8i/7i, Confidential V13/V6, Confidential DB2 UDB 8.0/7.0, MS SQL Server 2000/2005/2008, MS Access 7.0/2000

TECHNICAL SKILLS

• Operating Systems: Linux, HP-UX, Windows NT 4.0, Win 95/98/2000/XP/Vista/7/8, Mainframes
• Programming Languages SQL, Transact SQL, PL/SQL, UNIX Shell Scripting, C ++
• Databases Confidential Exadata/10g/9i/8i/8.0/7.x, MS SQL Server 2008/2005/2000/7.0/6.5, Confidential V2R6/V13, Sybase SQL Server 12.0/11.x, DB2 UDB, MS Access 7.0, Netezza
• Data Warehousing Informatica Multi Domain MDM 9.5, Informatica Power Center 9.x/8.x/7.x, Mapping Designer, Warehouse Designer, ETL, Pentaho Data Integration
• Reporting Tools Business Objects 6.5/6.0, ProClarity, MS Access Reports, Pentaho Report Designer, Tableau
• Scheduling tools Autosys, Control M, Maestro, and Informatica In built Scheduler
• Big Data Ecosystems Hadoop, HDFS, Hive, Pig

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Informatica Architect

Responsibilities:

• Played a very important role in team in development of mappings, workflows and troubleshooting the issues.
• Analyzing the source data coming from various databases and files.
• Identifying and tracking the slowly changing dimensions (SCD), used CDC logic (Change Data Capture) for the SCD tables loading in Confidential .
• Designed complex mapping logic to implement SCD1 and SCD2 dimensions and worked on many critical dimensional modeling which helps in structuring and organizing data in uniform manner where constraints are placed within structure major concept of Data modeling
• Extracting data from Confidential and Flat file, Excel files, XML and COBOL sources and performed complex joiner transformations, Expression, aggregate, lookup, stored procedure, filter, Router transformations and Update strategy transformations to extract and load data into the target systems.
• Installed and configured Informatica Power Exchange for CDC and Informatica Data Quality (IDQ).
• Created custom plans for product name discrepancy check using IDQ and incorporated the plan as a Mapplet into Power Centre.
• Involved in massive data profiling using IDQ (Analyst tool) prior to data staging.
• Designed Data Quality using IDQ and developed several informatica mappings.
• Design reference data and data quality rules using IDQ and involved in cleaning the data using IDQ in Informatica Data Quality 9.1 environment.
• Fixing invalid Mappings, Debugging the mappings in designer, Unit and Integration Testing of Informatica Sessions, Worklets, Workflows, and Target Data.
• Created reusable Tasks, Sessions, reusable Worklets and workflows in Workflow manager.
• Worked very closely with Upstream teams all the time in order to fix the issues and completed tasks effectively in time and proceeded to production level.
• Very familiar about Sorter, Filter, Expression, Consolidation, Match, Exception, Association and Address validator transformations.
• Working extensively on Informatica Designer, workflow manager to create, sessions, workflows and monitor the results and validate them according to the requirement.
• Design reference data and data quality rules using IDQ and involved in cleaning the data using IDQ in Informatica Data Quality 9.6.1 environment
• Used IDQ to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes.

Environment: Confidential 11g, PL/SQL, Informatica Power Center 9.x/10.xData Quality 9.x

Confidential, Charllote, NC

APPLICATION SPECIALIST

Responsibilities:

• Interacting with business owners to gather both functional and technical requirements
• Followed agile methodology to meet deadlines for each sprint.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Extracted data from Netzza source system to Staging Area and loaded the data to the target database by ETL process using Informatica Power Center.
• Performed the performance and tuning at source, Target levels using Indexes, Hints and Partitioning in Confidential and Informatica.
• Created and used mapplets for processing complex reusable logic for commercial and retail loans.
• Created box jobs, file watcher jobs, command jobs for archiving the files and jobs to run the workflows through Autosys.
• Worked on JIRA to track and fix tickets related to improvements and bugs.
• Worked on Proof of Concept(POC) for migrating from current Netezza database to Confidential Exadata platform.
• Worked on Pilot project for ECRIS PEAKS migration to Hadoop platform (from Netezza) which would create flat files to be consumed on ATLAS side.
• Used Confidential to write SQL queries that create/alter/delete tables and to extract the necessary data

Environment:TOAD, Confidential Exadata, Netezza, Aginity, Putty, Informatica Power center 9.6.1,Autosys

Client: Confidential & Confidential BANK,Winston Salem,NC

ETL Architect/MDM

Confidential

Responsibilities:

• Co-ordinated monthly roadmap releases to push enhanced/new informatica code to production.
• Working with business users and business analyst for requirements gathering and business analysis.
• Converted business requirement into high level and low level design.
• Created reusable mapplets and Transformations starting concurrent batch process in server and did backup, recovery and tuning of sessions.
• Created sequential batches and concurrent batches for sessions.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Involved in monitoring the workflows and in optimizing the load times.
• Used Change Data Capture (CDC) to simplify ETL in data warehouse applications
• Created mappings using different look-ups like connected, unconnected and Dynamic look-up with different caches such as persistent cache
• Performed Impact Analysis of the changes done to the existing mappings and provided the feedback
• Create mappings using reusable components like worklets, mapplets using other reusable transformations.
• Participated in providing the project estimates for development team efforts for the off shore as well as on-site.
• Coordinated and monitored the project progress to ensure the timely flow and complete delivery of the project
• Worked on Informatica Source Analyzer, Mapping Designer & Mapplet, and Transformations.

Environment: TOAD, DB2, Confidential, Netezza, Aginity, Putty, Informatica Power Center 9.5, SQL Developer

Confidential, Quincy, MA

Project: XRM

Role: Offshore Team Lead

Duration: Feb 2013 - Feb 2014

Responsibilities:

• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed
• Created adhoc reports to users in Tableau by connecting various data sources
• Handled Tableau admin activities granting access, managing extracts and Installations
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it
• Analyzed the source data and handled efficiently by modifying the data types.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Generated context filters and used performance actions while handling huge volume of data.
• Generated tableau dashboards with combination charts for clear understanding
• Generated dashboard for Finance team, provided security by using user filters
• Generated adhoc Tableau reports on demand for downstream users.

Environment: PL/SQL, SQL Developer, Confidential 11g, DB2 9.3/AS400, Remedy, Tableau

Confidential

ETL LEAD

Responsibilities:

• Interact with the BA to understand the reporting requirement of the client.
• Responsible for creation of functional document and the BRD requirement
• Co-ordinated with mainframe team to ensure proper requirement gathering
• Good Experience in Extraction, Transformation and Loading from Homogeneous and Heterogeneous Sources
• Using the data Integration tool Pentaho for designing ETL jobs in the process of building Data warehouses and Data Marts.
• Participation in Performance tuning in database side, transformations, and jobs level
• Good experience in design the jobs and transformations and load the data
• Sequentially & parallel for initial and incremental loads
• Good experience in using various PDI steps in cleansing and load the data as per the business needs
• Good experience in configuration of Data integration server to run the jobs in local, remote server and cluster mode
• Provide weekly status of results to Project Team to ensure we meet the SLAs.
• Co-ordinated onshore-offshore scrum calls for getting the requirement clarifications.
• Estimations for Confidential Audit reports (56 reports).
• Admin for the Pentaho server, involved in creation of users and setting up security level for end users
• Generated different types of reports such as crosstab, chart Master\Detail; used filters, conditions, calculations etc.
• Used Unix Shell scripts using K-shell to automate the process of running jobs/batches
• Designed, developed, maintained materialized view for supporting ad hoc queries and canned reports

Environment: Pentaho Data Integration, Pentaho Report Designer, MySQL, DB2, Mainframe

Confidential, Austin,TX

ETL LEAD

Responsibilities:

• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Reviewed source systems and proposed data acquisition strategy.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Improved development time by leveraging metadata, and reduced IT coordination costs by providing a common working business model across the enterprise architecture.
• Extracted client information data and history from DB2 into flat files, transformed and loaded into Confidential database.
• Worked with the MULTILOAD, FAST LOAD utility of Confidential database for better performance.
• Worked with Confidential BTEQ to run the scripts in batch mode
• Extensively used BTEQ, Query Man and WinDDI for database creation, moving space between databases altering spool space and user creation and management in Confidential .
• Reusable transformations and Mapplets are built wherever redundancy is needed
• Performance tuning is performed at the Mapping level as well as the Database level to increase the data throughput
• Designed the Process Control Table that would maintain the status of all the CDC jobs and thereby drive the load of Derived Master Tables.
• Used Confidential utilities like BTEQ, fast load, fast export, multiload for data conversion.
• Created Post UNIX scripts to perform operations like gunzip, remove and touch files.

Environment: Informatica Power center 8.6.1/8.5, Confidential v13, VSS, Clarity, Test Manager, Quality Center

Confidential, NJ

Off shore Team Lead

Responsibilities:

• Interacting with business analysts and developers for rectifying the requirements, designing and deploying the PBM project for BCBS NJ Horizon
• Provided estimations for the enhancements in the application using Function Point estimation method
• Reviewed legacy source systems and proposed data acquisition strategy.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Improved development time by leveraging metadata, and reduced IT coordination costs by providing a common working business model across the enterprise architecture.
• Tuned Informatica mappings for optimum performance.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Analyzed IMS Data using IMS tools such as Xponent and Xponent Plantrak, regarding segmentation & profiling.
• Extensively used IMS Data component Xponent to get and send the encrypted data over the network.
• Extensively used Power Center/Mart to design multiple mappings with embedded business logic.
• Used Informatica Source Analyzer, Mapping Designer and Server Manager for Extraction, Transformation and Loading.
• Creation of Transformations like Sequence generator, Lookup, joiner and Source qualifier transformations in Informatica Designer.
• Created complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Performed the performance and tuning at source, Target levels using Indexes, Hints and Partitioning in DB2, Confidential and Informatica.
• Designed and developed various PL/SQL stored procedures to perform various calculations related to fact measures.
• Converted the PL/SQL Procedures to Informatica mappings and at the same time created procedures in the database level for optimum performance of the mappings.
• Investigating and fixing the bugs occurred in the production environment and providing the on-call support.
• Performed Unit testing and maintained test logs and test cases for all the mappings.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Parsing high-level design specification to simple ETL coding along with mapping standards.

Environment: Informatica Power center 8.6, Db2 9.3, UNIX, Putty, VSS, Power Connect, Erwin 3.5, Control M, Siebel 2000, PL/SQL, Confidential 8i, SQL Server 2000, DB2 7.0, HP-UX 10.20, Windows NT 4.0

Confidential, SA

Senior ETL Developer

Responsibilities:

• Interacting with business analysts and developers for rectifying the requirements, designing and deploying the Data Integrity (DI) project
• Involved in extracting data from multiple data sources, performing multiple complex transformations and land data in to Confidential target Tables.
• Gathered business requirements from end users.
• Designed and developed logical and physical data model.
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.
• Aided in the documentation of ETL process.
• As a Developer, involved in the complete cycle of Project Plan, Design, Installation, Development, and Testing, Production Cut-Over, End User Training and Post Production Maintenance of the system.
• Developed and supported the Extraction, Transformation and Load process (ETL) for data migration.
• Scheduled and monitored transformation processes using Informatica Server Manager.
• Developed Informatica mappings for data extraction and loading.
• Used Expression, Lookup, Filter, and Sequence generator, Aggregator Transformations to load the data from source to ODS.
• Coded UNIX and PL/SQL scripts for pre & post session processes to automate daily loads.

Environment: Informatica Power center 8.5.1, Confidential 10g, Toad 9.1, Informatica Repository Manager, SQL, PL/SQL, Erwin, MS Access 2000, SQL Server (7.0), Shell Programming, Confidential DB2, UNIX and Windows NT

Confidential, Roseville,CA

Senior System Developer

Responsibilities:

• Gathered business requirements from end users
• Stored procedures and triggers were used to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS)
• Write Confidential -SQL statements for retrieval of data and involved in performance tuning of TSQL queries.
• Loading data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.
• Created documentation as required.

Environment: MS SQL Server 2000, Confidential -SQL, DTS

Confidential, Rochester, NY

Senior System Developer

Responsibilities:

• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Created Interface files that were created by pulling data from legacy billing systems from Common wealth and provided as a source of data for downstream DPI billing system.
• Recommended tuning options to source/target database DBA team to gain optimum performance.
• Designed and developed Informatica Mappings to load data from Source systems to Interface files which were sources for DPI side.
• Importing various Sources, Targets, and Transformations using Informatica Power Center 8.1- Workflow Manager, Workflow Monitor, Repository Manager and Designer.
• Used Admin Console for creating folders and managing the user privileges.
• Developed various Mapplets, Transformations and validated and fine-tuned the ETL logic coded into mappings. Extensively used Informatica Powercenter Transformations, which includes Union, Look Up, Rank, Aggregator, Filter, Router, Joiner, Sequence Generator, Update Strategy, Stored procedure, and Expression
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Mock conversion on weekly basis.
• Created Mapplet and used them in different Mappings.
• Extensively used Power Exchange to import source and target definitions from AS400
• Used appropriate Power Exchange Listener to extract data from a source or load data to a target.
• Writing PL/SQL Stored procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Performance tuning using round robin, hash auto key, Key range partitioning.
• Used shell scripts for automating the execution of maps.
• Created Informatica mappings with PL/SQL, Procedures/Functions to build business rules to load data.
• Used debugger to test the data flow and fix the mappings.
• Designed testing procedures and test plans.

Environment: Informatica Power Center 8.1, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Power Analyzer, Confidential 10g/9i, DB2 / AS400, Windows XP, UNIX, PL/SQL developer, Confidential V2R5/V2R4

Confidential, Richmond, VA

Senior System Developer

Responsibilities:

• Extracting the information of client & history from legacy systems into flat files, transforming and loading into Confidential Based RETEK system
• Optimized query performance, session performance
• Requirements Gathering and Business Analysis.
• Recommended tuning options to source/target database DBA team to gain optimum performance.
• Extensively worked with Informatica to load data from different sources to target database
• Developed various Mapplets, Transformations and validated and fine-tuned the ETL logic coded into mappings
• Worked on Informatica Powercenter Designer tool - Source Analyzer, Warehousing designer, Mapping Designer & Mapplets, and Transformations.
• Developed various mapping by using reusable transformations.
• Most of the transformations were used like Source Qualifier, Aggregator, Filter, Expression, and Unconnected and connected Lookups, Update Strategy.
• Improved the mapping performance using SQL overrides.
• Performed tunings of mappings, sessions for optimum performance.
• Used PL/SQL to write stored procedures to increase the performance.
• Created Mapplets and used them in different mappings.
• Developed various sessions, batches containing parameters files, indicator files and multiple sources files
• Extracted Data from Power Exchange in Change and Real-time Mode
• Used appropriate Power Exchange Listener to extract data from a source or load data to a target.
• To Design and develop various mappings and performed data loads.
• Performed Unit testing and Integrated testing for the mappings created.
• Validated all the applications and run the workflow using Powercenter Workflow Manager.
• Extracted client information data and history from DB2 legacy systems into flat files, transformed and loaded into Confidential Based RETEK system.
• Used debugger to test the data flow and fix the mappings.

Environment: Informatica Power center 8.0/7.2, Power Connect, Confidential 9i/8i, SQL Server, Confidential UDB DB2 8.0, DB2/AS400, MS Access 2000, Autosys, Toad, SQL, PL/SQL, MS SQL Server 2000, Confidential V2R3/V2R2, Erwin 4.0, AIX, UNIX Shell Scripts