PROFESSIONAL SUMMARY:

• Twenty - Two years of diversified experience in System Analysis, Design, Requirements gathering, Development and Implementation of Data warehouse and Data Mart applications in Finance and Telecommunication industry domains. Extensive experience in ETL Process Design, Optimization, Global team management, Agile and WaterFall project management methodology.
• Handling enterprise level data ware house design and development
• Expertise in global development team management, task and work assessment and solution provider
• Expertise in creating Technical Design document based on the business requirements, Design and Develop Real Time ETL Process using MQ and XML MessagesExpert in Develop and Automate EOD batch Process to load high volume data with optimal performance.
• Developed ETL framework to onboard multiple sources with just Confidential configuration, UNIX Shell Scripting, SQL/PL/SQL and Oracle Objects like Tables, Materialized view and Synonym, Logical /Physical Data Model.
• Developed Job scheduling tool using shell scripts and db objects in TD-Waterhouse for Mantas application.
• Developed Informatica mappings with MapReduce for POC.
• Requirement Analysis Design to completeE2E implementation
• Business Process Modeling (Functional requirement definition)
• Data Modeling (Conceptual Design, Logical and Physical Database Design)
• Application Development, Data Conversion & Migration

TECHNICAL SKILLS:

Tools: Informatica 9.6/10.1, MQ Messaging, Erwin. Visio 6.0, PVCS (Version Control), Confidential, Toad, SQL*Navigator, Ms-Project

Platform: Exadata X5-2, Oracle, Linux, Unix, Hadoop HDFS, MapReduce, Web Spear MQ

PROFESSIONAL EXPERIENCE:

Confidential

VP/Tech Lead/Project, Delivery Manager

Responsibilities:

• As a Lead, Ensure Application Requirement Analysis, Design, Development and Implementation occurred on time, weekly status update to project stakeholders and Sr. Management.
• Create Technical Design document to build ETL Framework for daily Intraday real time process and EOD batches
• Developed Real time workflows, Shell scripts and Confidential Jobs to load MQ XML messages (Trade and Cashflows), and then load into main schema table.
• Developed EOD generic mappings/workflows framework to load regional EOD data (AMER/EMEA/APAC) i.e. Valuations, Explains, Holdings and Trade Control XML and Flat files.
• Proven knowledge in high volume data load (XML and Flat Files) and improving the regional EOD batch process performance to meet SLA deadline, Performance of Single segment batch improved to 8 mins from 60 mins.
• Managed around 10k Confidential jobs/process to load and process transaction and Static data from all regions.
• Developed Automated Data synchronization process between Prod and UAT to test development releases before go live.
• Developed and automated Test Driven Development ( Confidential ) process to automate testing.
• Developed Optimized Shell Scripts, dynamic SQL’s, PL/SQL Packages, Materialized view and Synonyms
• Developed mapplets to capture exceptions and DQ issues while loading the data
• Setup workflow level Pass through partition and parallel degree / hints in source qualifier sql and configured Load balances at informatica node level.
• Expert knowledge in Sprint Planning and Execution as Scrum Master in Agile methodology.
• Managed RFDW global development team and outsourcing work to Tata Consulting Services

Environment: s: Oracle Exadata X5-2, Linux, MQ Messageing, Confidential, PVCS, GIT, VISO MS Power Point and Informatica 10.1/9.6, JIRA, Agile Central and lean Control tools.

Confidential, New York

Senior ETL Tech Lead

Responsibilities:

• Application Requirement Analysis, Design, Development and Implementation of end to end solution
• Developed customer and account balances mappings to load data.
• Developed Confidential jobs and Shell scripts to automate the load process.
• Designed logical and physical data model using ErWin.
• Performance improvement of Informatica work flows

Environment: s: Oracle 10g, Linux, Informatica 9.0, Confidential, JIRA

Confidential

ETL Architect

Responsibilities:

• Create Technical Design Document ( Confidential ) for Confidential
• Understand the data requirement from target system (MDM) and set up an automated feed from source to target
• Design and Develop XML mappings using XML generator to create the Customer (participant) and Account (Contract) files, transformations for Error handling and mappings for source/target record count capture.

Environment: s: Informatica 8.1/9.0, Oracle 10g, Unix, Confidential, Altova XML Spy

Confidential

Senior ETL Consultant

Responsibilities:

• Understand the business requirement document and set up common objects in Informatica.
• Developed one of very complex RT product workflows to load all asset classes.
• Developed new sql transformations and messaging functionality
• Optimized and performance tuned Real Time workflow along with Informatica SME since RT messaging was newly introduced
• Read reference, transaction, party data from MQ message queue and load into ODS and RDW.

Environment: Red hat Linux AS4 64 bit Oracle 10g, Informatica Integration server 8.1.1, Altova XMLSpy

Confidential

Senior ETL Consultant

Responsibilities:

• Involved in Data Architect team to design Logical and Physical Data Model using Erwin
• Informatica Power Center Administration, Upgrades, Setting up Web Services to provide data to SalesForce.com
• Integrating FirstLogic-Informatica software with Power Center Design and Implement House Holding rules and process
• Load the data into Staging area, Creating Informatica Mappings, Workflows and Worklets
• Creating the DIS files for Mantas Application and run the data process and data load utility (DP/DL) to verify the results.
• Created the entire job scheduling solution using the shell scripts and oracle objects, The Job scheduler runs around 250 jobs every business day to extract, transform and load the data into BSDW.

Environment: Sun Fire™ 480, Oracle 9i, Informatica 7.1.2, Exceed, Erwin 4.1, VISIO, MANTAS 4.1.1, LDAP.

Confidential

Senior Software Specialist

Responsibilities:

• Gathered Business Requirement, Analysis, Design and Writing Technical specs describing complex business rules.
• Developed ETL work flows and scripts to load data into data marts

Environment: SUNOS 5.4, Oracle 9i, Erwin, Visio, BRIO Query, PL/SQL, Shell Scripting, FTP, Toad, Informatica 6.2

Confidential

Senior Software Specialist

Responsibilities:

• Sales Management Reporting System
• Production Cost Control Tracking System

Environment: SUN4d, SUNOS 5.4, Oracle 7.3, FORMS 4.5, PL/SQL 2.3, SQL*Loader, SQR, KSH.