SUMMARY:

• IT professional with over 16 years’ experience in a database production environment specializing in project management, analysis/design, development and architecture of client information with a focus on data warehousing in Banking and Financial Service Industry (BFSI).
• Designed technical processes as a Team Lead by using internal modeling and working with analytical teams to gather requirements and create specifications.
• 13 years of experience in Information Technology with a broad range of computer expertise, analytical skills, backend database applications and 12 years in ETL Architecture and Business Intelligence (DW) applications.
• Managed all aspects of the SDLC process - requirement analysis, time estimates, functional specification, design, development, testing, packaging, and support/maintenance.
• Proficient in both Waterfall and Agile development methodologies.
• Proficient in analysis, design, development of Database Management systems using Oracle.
• Expertise in UNIX/Linux shell scripting, job scheduling in CRON, Autosys and Control-M.
• Expertise in implementing business logic in Oracle using Stored Procedures, Functions, Packages, Views, materialized views, functional based indexes and Triggers, Dynamic SQL, ad-hoc reporting using SQL.
• Expertise in Oracle Database Design and ETL with Confidential Infosphere (Data stage), Ab Initio and Informatica.
• Mentored, coached cross-trained junior developers by providing domain knowledge, design advice.
• Proven ability in defining goals, coordinating teams and achieving results.

SKILL:

ETL Tools: Data Stage, Ab Initio, Informatica

OLAP/DSS tools: OBIEE.

RDBMS: Oracle, DB2 UDB, MS SQL Server, DB2, Teradata.

Modeling Tools: Visio

Scheduling Tools: Autosys, Control-M.

Version Control Tools: Confidential Rational Clear Case.

O/S: UNIX, Windows and LINUX.

Software Package: Microsoft office, Toad, Beyond Compare 3, Confidential Rational Quest.

Management: Team Lead, Project Management, Agile, Waterfall, SDLC process

CONSULTING EXPERTISE SUMMARY:

Industries: Banking and Financials, Retail, Energy.

Solution Areas: ETL design/ development, Data Architecture, Solution Design.

Data Models: Enterprise Data warehouse (EDW) and Reporting Data mart.

EXPERIENCE:

Confidential, Pleasanton, CA

Solutions Architect / ETL Data stage Developer

Responsibilities:

• Provide solution architecture to address the new initiatives around the web based single sing on OKTA system data requirements.
• Designing and overseeing development of highly complex IIS Data stage 8.5code and Scheduling packages to transfer the LDAP data to Cloud environment. As well as providing detailed documentation and knowledge support to the Production Control team...
• Lead the team in the design and delivery of data validation rules with IIS Data stage for loading data into the Grocery offer systems.
• Worked Closely with Business Analyst to understand business rules and developed Data stage jobs.
• Designed and developed Shell scripts, scheduling mechanism to support daily batch loads.
• Worked with deployment team to deploy the code in different environments (QA, UAT, PRE-PROD, PROD)
• Extensively used Autosys and CRON for scheduling the DataStage Jobs.
• Mentor and challenge junior and other team members, while growing the technical, functional and leadership skills.

Environment: IIS Data stage, DB2, Oracle, Shell scripting, Big data (Design), SQL Developer, Toad, and Teradata

Confidential, Bakersfield, LA

Tech Lead / ETL Data stage developer

Responsibilities:

• Provide solution architecture to address the new initiatives around the Data Warehouse data requirements.
• Participated in ETL Architecture meetings and define ETL best practices, guidelines on performance tuning for the ETL jobs.
• Supporting the off-shore team by setting up the Infrastructure, ramping up development and production support.
• Designing and overseeing development of highly complex IIS Data stage code and Scheduling packages as well as providing detailed documentation and knowledge support to the client.
• Lead the off-shore team in the design and delivery of data validation rules with IIS Data stage for loading data into the EDW.
• Worked Closely with Business Analyst to understand business rules and developed Data stage jobs.
• Designed and developed Shell scripts, AutoSys scheduling mechanism to support daily batch loads.
• Developed balance reconciliations processes, point to point controls, capturing operational info for the reporting team.

Environment: Team management, IIS Data stage 11.5, Teradata, DB2, Oracle, SQL Server & Shell scripting.

Confidential, Dearborn, MI

Data Analyst / Quality Stage Developer

Responsibilities:

• Provide solution architecture to address the new initiatives around the customer address standardization data requirements.
• Review existing address conversion codes in Java and translate them to Quality stage modules.
• Develop new Quality stage modules to add additional functionalities that does not in the existing applications.
• Designing and overseeing development of highly complex IIS Data stage/Informatica code and Scheduling packages as well as providing detailed documentation and knowledge support to the bank.
• On a Weekly basis, produced reconciliation report with metrics and reviewed with management team.

Environment: IIS Data stage, Quality Stage, UNIX, Oracle, DB2, SQL Server.

Confidential, Herndon, Virginia

ETL Architect / Designer

Responsibilities:

• Provide solution architecture to address the new initiatives around the CRM Data Warehouse data requirements.
• Participated in ETL Architecture meetings and define ETL best practices, guidelines on performance tuning for the ETL jobs.
• Supporting the 5/3rd team by setting up the Infrastructure, ramping up development and production support.
• Designing and overseeing development of highly complex Informatica code and Scheduling packages as well as providing detailed documentation and knowledge support to the bank.
• Lead the team in the design and delivery of data validation rules with Informatica ETL tool for loading data into the EDW.
• Worked Closely with Business Analyst to understand business rules and developed Informatica jobs.
• Designed and developed Shell scripts, AutoSys scheduling mechanism to support daily batch loads.
• Developed balance reconciliations processes, point to point controls, capturing operational info for management dashboards.

Environment: Team management, Informatica with DT, JENS Message broker, DB2, Oracle, Auto Sys.

Confidential

ETL Architect / Designer / Business Analyst

Responsibilities:

• Provide solution architecture to address the new initiatives around the single view data mart requirements.
• Supporting the DC3 support team by setting up the Infrastructure, ramping up development and production support.
• Designing and overseeing development of highly complex Informatica code and Scheduling packages as well as providing detailed documentation and knowledge support to the client transition team.
• Lead the team in the design and delivery of data validation rules with Informatica for loading data into the payment system data base.
• Worked Closely with Business Analyst to understand business rules and developed Informatica codes.

Environment: Informatica, DB2, Oracle, SQL Server & Shell scripting, Informatica and Toad.

Confidential, Deerfield, IL

ETL Designer / Ab Initio Developer

Responsibilities:

• Provide solution architecture to address the new initiatives around the Customer billing data requirements.
• Participated in ETL Architecture meetings and define ETL best practices, guidelines on performance tuning for the ETL jobs.
• Designing and overseeing development of highly complex Ab Intio code and Scheduling packages as well as providing detailed documentation and knowledge support to the team.
• Worked Closely with Business Analyst to understand business rules and Ab Initio ETL codes.
• Designed and developed Shell scripts, Auto Sys scheduling mechanism to support daily batch loads.
• Developed balance reconciliations processes, point to point controls, capturing operational info for management report.

Environment: Team management, Ab Intio, DB2, Oracle and Shell scripting.

Confidential, Charlotte North Carolina

ETL Designer / Ab Initio developer

Responsibilities:

• Provide solution architecture to address the new initiatives around the CRM Data Warehouse data requirements.
• Participated in ETL Architecture meetings and define ETL best practices, guidelines on performance tuning for the ETL jobs.
• Supporting the 5/3rd team by setting up the Infrastructure, ramping up development and production support.
• Designing and overseeing development of highly complex Ab Initio jobs code and Scheduling packages as well as providing detailed documentation and knowledge support to the bank.
• Lead the team in the design and delivery of data validation rules with Ab Initio ETL modules for loading data into the EDW.
• Worked Closely with Business Analyst to understand business rules and Ab Initio jobs.
• Designed and developed Shell scripts, TWS scheduling mechanism to support daily batch loads.

Environment: Team management, Ab Initio, DB2, Oracle, SQL Server & Shell scripting.

Confidential, Richmond, Virginia

ETL Designer / ETL developer

Responsibilities:

• Provide solution architecture to address the new initiatives around the CRM Data Warehouse data requirements.
• Participated in ETL Architecture meetings and define ETL best practices, guidelines on performance tuning for the ETL jobs.
• Supporting the 5/3rd team by setting up the Infrastructure, ramping up development and production support.
• Designing and overseeing development of highly complex IIS data stage/Informatica code and Scheduling packages as well as providing detailed documentation and knowledge support to the bank.
• Lead the team in the design and delivery of data validation rules with IIS data stage for loading data into the EDW.
• Worked Closely with Business Analyst to understand business rules and developed data stage and Informatica jobs.
• Designed and developed Shell scripts, TWS scheduling mechanism to support daily batch loads.
• Developed balance reconciliations processes, point to point controls, capturing operational info for management dashboards.

Environment: Team management, Ab Initio, DB2, Oracle, SQL Server & Shell scripting.

Confidential, Middletown, CT

Data warehouse/Ab Initio Developer

Responsibilities:

• Involved in building a prototype without mapping documents.
• Exporting the jobs to Testing Environment from Development and then to Production.
• Worked closely with Project lead/Manager, Architects, and Data Modelers, System Analyst to understand the business process and functional requirements. Fixed defects highlighted by testing team.
• Did unit testing of the jobs developed before taking them for UAT and finally Production.
• Extensively Used the ETL Tool Ab Initio to develop jobs to extract, transform and load data from various source systems into the Data Warehouse.
• Participated in the meeting with Business Users and support Analyst for getting the more information and understanding of the Application.

Environment: Team management, Ab Initio, Informix XPS, DB2 EEE & Shell scripting