SUMMARY:

• 17+ years of professional experience covering all phases of the Software Development Lifecycle; System Analysis; Systems Integration, BASEL III, CCAR, Regulatory Credit Retail Risk, Data Governance, Data Quality, Data trace and Controls Assessment Process.
• Worked as SME for BASEL III /CCAR and Regulatory Risk projects.
• Extensive worked on regulatory Credit risk and identified/ analyzed risk issues, assess controls and identified signs of changing risk levels
• Performed data analysis activities including data profiling, data transformation rules and integration requirements
• Gathered Meta data/Data Dictionary, mapped the data elements data Transformation rules from End to End systems
• Strong Program management skills, problem solving, risk management and internal controls skills.
• Extensive hands - on experience on ETL Strategies & ETL Architecture Design
• Working in ETL process consisting of data transformations, data sourcing, mapping, and loading
• Having experience in ETL process using Informatica-Power Center for large Database in production environment.
• Design of ETL mappings & Tech Specifications
• He has in-depth knowledge on data warehousing concepts and methodologies
• Tremendous experience in customer relationship management and addressing customer issues. Strong Team spirit and relationship management skills.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.

TECHNICAL SKILLS:

RDBMS: Oracle 8i/9i/10g, DB2, SQL Server 2000/2005/2008 , Sybase

OS: Windows 9.x/ NT/2000/XP, UNIX, MS-DOS

Languages: C, Pascal and PL / SQL, C++, Java, python, R

Modeling: Erwin 4.x

Tools: Toad, Aqua DataStudio, Rapid SQL, Putty, Tidal

Web: HTML, VBScript, JavaScript, ASP, XML

Big Data: Hadoop HDFS, Hive, Hue, HBase, Impala, Scoop, Oozie, Spark, Scala, MongoDB

PROFESSIONAL EXPERIENCE:

Vice President- ETL Architect

Confidential, Long Island City, NY

Responsibilities:

• Designed ETL Architecture for data trace Process.
• Designed ETL Strategies, Single point of contact for ETL work.
• Executed the CAR /Data trace projects for Retail line of Business.
• Lead and performed analysis to identified areas of synergy and efficiency opportunities in data and process.
• Lead and performed strategy development analysis to identify areas of opportunity and purpose solutions for Issues affecting BASEL submission process.
• Identified and assessed the effectiveness of controls established by GCB businesses in the Basel submission Process.
• Worked with various businesses, Analytic and Risk to understand the impact of various issues around GCB Process Controls
• Developed a strong working relationship with Global Consumer Businesses, Consumer Risk and Finance
• Created of development project plan, and monitoring and controlling development progress.
• Leading ETL data trace projects and CAR projects
• Leading ETL Development Team of onshore and off shore
• Day - to-day leadership in planning and executing activities

Environment: Oracle 11g, ETL, UNIX, Oracle 11g, Mainframes DB2, SAS, Informatica power center 9.6, Informatica data quality

ETL Consultant

Confidential, Brooklyn, NY

Responsibilities:

• Designed ETL (Informatica) Architecture for the Enterprise Data WarehouseDesigned ETL Strategies Single point of contact for ETL work Studied the existing environment and accumulating the requirements by querying the Clients on various aspects
• Analyzing specifications for various applications enhancements for compatibility within the system.
• Developing ETL Design documents, data mapping documents and migration document.
• Documented the test cases and results for future understanding and
• Unit testing and integration testing

Environment: Oracle 11g, Mainframes DB2, Informatica 9.1.6,Informatica Real Time PowerExchange for Oracle, Informatica Real Time PowerExchange for DB2, Informatica Real Time Web Services, Informatica Real Time Power Exchange for SalesForce, Toad 8.x/9.x, Windows

Informatica Dev Lead /Architect

Confidential, Boise, ID

Responsibilities:

• Designed ETL (Informatica) Architecture for the Enterprise Data WarehouseDesigned and implemented ABAC model for the project Designed and implemented Informatica PowerExchange for SAP
• Designed ETL Strategies Single point of contact for ETL work Studied the existing environment and accumulating the requirements by querying the Clients on various aspects
• Analyzing specifications for various applications enhancements for compatibility within the system.
• Developing ETL Design documents, data mapping documents and migration document.
• Documented the test cases and results for future understanding and
• Leading ETL technical team Leading ETL Development Team of onshore and off shore
• Day-to-day leadership in planning and executing activities

Environment: Oracle 10g, SQL Server, Informatica 9.x, Informatica PowerExchange, Toad 8.x/9.x, Windows

Informatica Architect/ETL Data Architect

Confidential, New York, NY

Responsibilities:

• Designed ETL (Informatica) Architecture for Reporting Data Warehouse Project
• Designed ETL-Data Architecture for Capco data, portfolio management and Risk Console
• Designed ETL Strategies
• Informatica Installation on UNIX and Informatica upgrade from 8.1.1 8.6.1
• Optimizing / tuning mappings for better performance and efficiency
• Studied the existing environment and accumulating the requirements by querying the Clients on various aspects
• Analysing specifications for various applications enhancements for compatibility within the system.
• Developing data mapping documents and migration document.
• Generating ETL mappings, sessions, workflows using Informatica
• Created reusable components (Mapplets, reusable Transformations, Tasks, worklets)
• Implemented slowly changing dimensions Type-1, Type-2 and Hybrid Dimensions
• Involved in writing PL/SQL procedures.
• Involved in writing shell scripts
• Documented the test cases and results for future understanding and
• Unit testing and integration testing
• Migrated Informatica mappings, sessions and workflow from development to QA and QA to Production
• Monitor production loads daily, monthly and quarterly

Informatica Architect/ETL Data Architect /Team Lead

Confidential, New York, NY

Responsibilities:

• Designed ETL (Informatica) Architecture for Reporting DataWarehouse Project
• Designed ETL-Data Architecture for PHR DataMart, SoleSrource and Aetna DataMart. And active advise
• Designed ETL Strategies
• Informatica Installation on UNIX and Informatica upgrade from 7.1.3 8.1.1 8.6.1 9.0.1
• Informatica Administration
• Optimizing / tuning mappings for better performance and efficiency
• Studied the existing environment and accumulating the requirements by querying the Clients on various aspects
• Analyzing specifications for various applications enhancements for compatibility within the system.
• Developing data mapping documents and migration document.
• Generating ETL mappings, sessions, workflows using Informatica
• Implemented slowly changing dimensions Type-1, Type-2 and Hybrid Dimensions
• Created reusable components (Mapplets, reusable Transformations, Tasks, worklets)
• Generated FlatFiles, xml and EDI files
• Involved in writing PL/SQL procedures.
• Involved in writing shell scripts
• Documented the test cases and results for future understanding and
• Unit testing and integration testing
• Migrated Informatica mappings, sessions and workflow from development to QA and QA to Production
• Monitor production loads daily, monthly and quarterly
• On call Production Support.
• Leading ETL technical team Day-to-day leadership in planning and executing activities

Environment: Oracle 10g, SQL Server, Informatica 7.x/8.x/8.6.x, Toad 8.x/9.x, Aqua DataStudio, Win 2K, UNIX

Sr. Informatica Designer/ ETL Data Architect / Onsite Coordinator

Confidential, New York, NY

Responsibilities:

• Designing ETL-Data Architecture
• Understanding the source systems and data model for data mart / data warehouse.
• Developing data mapping documents and migration document.
• Generating ETL mappings, sessions, and workflows using Informatica 7.x.
• Implemented slowly changing dimensions Type-1, Type-2, Type-3 and Hybrid Dimensions and Facts
• Created reusable components (Mapplets, reusable Transformations, Tasks, worklets)
• Involved in writing PL/SQL procedures.
• Involved in writing shell scripts
• Unit testing and integration testing
• Migrated Informatica mappings, sessions and workflow from development to QA and QA to Production
• Optimizing / tuning mappings for better performance and efficiency

Environment: Oracle 9i, Informatica 7.x, Toad, Windows 2000, UNIX

Sr. ETL Developer/ Designer/ ETL Data Architect /Technical Leader

Confidential, Atlanta

Responsibilities:

• Developed ETL mapping Documents, Data Migration documents
• Developed Perl Scripts for Screen Door process.
• Designed ETL Logic for mappings
• Interacted with client for ETL Logic
• Involved in writing scripts, procedures to load data from different legacy systems to staging area as well as to load data from staging area to Star Schema.
• Worked in various types of transformation like Lookup, Update Strategy, Stored Procedure, Joiner, Filter, Aggregation, Rank, Router and XML Source Qualifier etc of Informatica.
• Creation of Mapplets to reduce the development time and complexity of mappings and better maintenance.
• Developed Complex mappings by extensively using Informatica Transformations
• Creating/ Building and scheduling Batches and Sessions using the Server Manager
• Developing Reusable Transformations, Aggregations and created Target Mappings that contain business rules
• Optimizing / tuning mappings for better performance and efficiency
• Involved in writing shell scripts.

Environment: Oracle 8i/9i, Informatica 5.x/6.x,7.x Rapid SQL, Windows 2000, UNIX