Data Architect

PROFILE EXPERIENCE

** + years of experience in data warehouse design,

Modelling, ETL, visualization, analytics.

Highly excited Data Architect proficient looking

forward to leverage, the analytical skills with a

strong business acumen and hands on experience

in data architecture, data modelling, visualization and analytics, in a fast-paced environment to

showcase the potential to expertise the data world. TECHNICAL SKILLS

Business Intelligence Tools

SSIS, SSAS, Informatica, DTS, Pentaho, SQL Server

Master Data Management, Data governance

Cloud Technologies

AWS Architect, EC2, AWS RedShift, Azure Storage,

Data Catalog, Data factory, Data Lake, AZURE SQ DW, Snowflakes, Cloud migration

Design and Data modeler

Microsoft Visio, Excel,Toad data modeler 6.5,

Erwin data modeler

Programming Languages

VB.NET, C#, Visual basic 6.0, Python, PyCharm

Reporting Visualization

SSRS, Business Objects, Tableau,CR,Power BI

Scripting Languages

VBA, VB Script#, Power Shell scripts,HTML,XML,Bash Version Control Tools

Git,TFS,VSS, Service Now, Remedy,IBM Clear Quest CERTIFICATIONS

AZ-203 Developing Solutions Microsoft Azure training Azure SQL Essentials – CBT Nuggets

AZ-900 Azure Fundamentals – CBT Nuggets

Microsoft SQL Server Implementation and Maintenance Snowflake Decoded-Udemy

Snowflake Datawarehouse and Cloud analytics-Udemy

Python for Data Science and ML -Udemy

Python 3 Master class -Udemy

Python for Finance -Udemy

EDUCATION

BE,MS Ramaiah Institute of Technology, India, 2009 ABHIJEET SHRIVASTAVA

Vice President, Enterprise Datawarehouse Architect ********.**************@*****.*** in linkedin.com/in/abhijeetsshrivastava +1-203-***-**** Vice President, Enterprise Datawarehouse Architect Bank of Hope

Sept 2018 – Ongoing California, USA

• Conceptualized, created and designed BoH’s enterprise data warehouse by understanding various data sources like Fiserv, web director, cash suite, GL/prologue, wires, imaging center and other sources for daily reporting and analysis. Evaluated and Proof of concept on AWS Redshift, Snowflake and Microsoft Azure for migrating on premise data warehouse to cloud.

• Created and designed semantic and data service layer for business users and reporting and Logical and physical data modelling using Toad Data Modeler.

• Design of data marts using advanced technologies like partitioning, partition switching, compression and encryption for security.

• Migrated on premises data warehouse to Azure cloud.

• Data and designed solution for CECL (Current Expected Credit Losses) reporting and built an end to end ETL process to feed data to Moody’s.

• Created and designed KYC customer risk rating program for evaluating customer using python.

• Data Lineage and data mapping for multiple business groups like mortgage, commercial, BSA and Enterprise Wide Risk

• Assessment and developed reports for the users using visualization tools Power BI, Tableau, Microsoft Excel - formulas, Pivot Tables, Charts and DAX Commands

• Formulated bank’s data governance strategy and work with business in defining DQ rules.

• Worked as a Scrum lead to manage and refine Backlogs, writing User Stories/features, help with Sprint Planning and Status Reporting.

• Responsible for planning, scheduling and execution while working with geographically distributed teams in IT, Business.

• Project management – responsible for planning, scoping, estimating, scheduling, execution and controlling the project.

• Team Management – Responsible for guiding the offshore team throughout the SDLC – using task-breakdown and prioritization, creation of task-driven schedule and estimations.

Data Architect, Business Intelligence Lead

CIT Bank

Sept 2016 – Sept 2018 California, USA

• Actimize and Party Master Project. Implemented and designed CIT Master Data Management for customer data and Data service Layer. This project involved development of 400+ SQL objects

• Loan Care Data Migration: Migrated and upgraded around 1000+ SQL Objects

• BDE upgrade from version 14.3 to 17.3. This project involved development/updates for 350+ SQL objects

• FRB: CCAR Regulatory Reporting -2052A, 14M, Y9C top down and bottom’s up approach end to end design and implementation. created a data quality /data validation automated process to validate data /edit checks before submitting to FED’s.

.

ACCOMPLISHMENT

ABHIJEET SHRIVASTAVA

Vice President, Enterprise Datawarehouse Architect ********.**************@*****.*** in linkedin.com/in/abhijeetsshrivastava +1-203-***-**** Business Intelligence Lead

OneWest Bank

Dec 2014 – Sept 2016 California, USA

• CIT –OWB Data center Migration

• Led a team of 10+ developers based in different geographies across critical deliverables like One West Bank (OWB) Integration to CIT, FIS-Bank Integration, OWB-Data Centre Migration, Foreclosure and Default Reporting, Owen Loan Transfer, Jumbo Loan Onboarding

• Designed and architected Banking Data Mart which is the only strategic data mart for the retail banking with 6000+ critical data elements across Customer, Accounts, and Online customer behavior subject areas. This enabled Financial & Modelling group to perform extensive reporting and analytics which was unprecedented. Also used by business units - Risk, Compliance, Retail Campaign Group

• Managed and enhanced PriceWaterHouse Coopers’ solution Servicing Profitability Analysis (SPA) data mart enabling SSAS cubes for Home Loan Servicing Group for analytics and reporting

• Manage and administer 1000+ Business Objects and SSRS reports. Used by Business Units – Finance, Risk and Compliance, Retail Operations, Marketing and many more

• Responsible for dimensional data modelling, technical design and led the development activities related to the BI environment, Data visualization using Excel Power View, Charts

• Designed, architected and implemented industry wide solution to load Bulk Data Extract (BDE – a data extract supplied by BKFS to its clients) and process data from mainframe encoded EBCDIC file format to ASCII including COMP-3 and COMP fields

• Automation of Bulk Data Extract (BDE) Development to save 2 months’ efforts

• Redesign, developed and led a team to improve performance of Servicing Data Mart (SDM). The overall load performance of daily load process improved by more than 60%

Team Lead

Dell,Inc

Jan 2010 – Dec 2014 Danbury, USA

• Designed and Implemented Billing Work Bench Project for Cartus online

• Cartus Data warehousing (EDW and DW) design and

implementation

• Designed and Implemented Bi Directional Parsifal feed

• HOMEEXPRESS Re-platform solution for Cartus.

• Created and designed SSAS cubes user analytics.

• Created and scheduled windows services

Associate Developer

ILead Group

Aug 2009 – Jan 2010 Indore, India

• Data Warehousing design and implementation for a local Hospital in India.

• Created monitoring dashboard in excel for monitoring ETL jobs .

• Automated ETL load process using SSIS and designed SSAS cubes

• BDE automated development phase to save 3

months of development efforts.

Process Improvement: 60%

Net Saving on Year to Year basic: $850,000

• BIML Solution for automating OSPREY

Development

Process Improvement: 30%

Efforts Saved : Total 80 person hours

development efforts

• Trigger SQL jobs to remove Control M, Operating

and DBA dependency for running, scheduling SQL

jobs .

Time Saved : Total 10 person hours

• Automated and build multiple data reconciliation reports and Tuning BWB Financial Service that

resulted in reducing the load process by 4-5 hours.

• Dell Bronze award in Year 2013 for successfully

upgrading BWB application. Spot award and Client

appreciation within one year for leading and taking over the major responsibilities from Cartus.

• Passion Recognition received from Cognizant

Account Manager for OSPREY project and

numerous client appreciation for successfully

completing OSPREY project without any defects.

Numerous client appreciation for completing bulk

data extract (BDE) project.

• Client appreciation for completing CCAR

Reporting

TOTAL SPREAD OF MY WORK

Contact this candidate