Data Warehouse Architect, ETL lead, Onshore-Offshore Coordinator, Lead developer Resume

SUMMARY:

Over 10 years of IT experience in architecting, designing and building Data Warehouse/Data Mart, Business Intelligence and Client/Server applications on Windows NT/XP, Unix and Linux Platforms
Finance (Liquidity Risk Management) and Pharma (Drug Development and Sales) Domain experience.
Experienced as Technical BA for the Treasury projects at Credit Suisse.
Proficient in end - to-end Project execution.
Worked with INFORMATICA Power Center, SSIS and MDM.
Researched and built a bond application in Ethereum blockchain and Smart contract coding using Solidity.
Over 4 years of Project Management experience.
Experienced in Agile and Waterfall methodologies in Project execution.
Over 10 years’ experience in Oracle, SQL Server and other Relational Databases on UNIX platform.
Proficient in UNIX and Linux shell scripting.
Have briefly shadowed an IDQ project.
Experienced in complete SDLC process as per CMMi level 5 standards.

TECHNICAL SKILLS:

ETL Tools: INFORMATICA POWER CENTER, SSIS

Data Management: INFORMATICA MDM

Big Data solutions: INFORMATICA BDE

Data Quality: INFORMATICA IDQ

Block Chain technologies: Ethereum, Smart contracts, Solidity

Scheduling: Autosys, ControlM

Agile Tools: Odessey

Project Management: Microsoft Project Plan, Estimators

Business Modelling: Microsoft Visio

OLAP Tools: COGNOS Web Reports 8.4/10.2, Infomaker, OBIEE

Database: Oracle 10g/11g, SQL Server 2008, MySQL, Vertica, Cassandra

GUI: Visual Basic, XML

Methodologies: Star Schema, Snowflake Schema, Dimensional Modeling

Languages: T-SQL, SQL, PL/SQL, Shell Scripting, VBA, PERL, PYTHON, Java Scripting, Powershell

Testing Tool: HP Quality Center

Operating systems: UNIX, Linux, Windows/XP

Problem/Change Management: Remedy, Service Now

Others: Oracle APEX

PROFESSIONAL EXPERIENCE:

Confidential

Data Warehouse Architect, ETL lead, Onshore-Offshore Coordinator, Lead developer

RESPONSIBILITIES:

Designed the ETLs that deal with millions of data from ~36 sources on daily basis.
Technical BA
Project execution in Agile methodology
Project accountability
Managed Key Client Relationships and Interactions
End to end project management.
Capacity planning of resources and work allocation.
Requirements gathering and ensuring client sign offs.
Build test strategies and plan.
Seek QA approvals for all the documentations as per CMMi level 5 standards.
Manage Environments for releases and Change Management.

Confidential

Technical Architect, Project Manager

RESPONSIBILITIES: