Atul Verma

SUMMARY:

·In-depth technology, data and cloud leader and mentor who leverages career achievements and a strong technical skill set to influence and guide corporate strategy and industry focus.

·Relied upon to significantly enhance operational performance, clarify business objectives, solidify client relationships, and create corporate presence in the marketplace. Consulting for a decade, defining enterprise data strategies, roadmaps, successful implementation enablers for large high-profile clients in Banking, Financial Services, Healthcare, Pharmaceutical and Travel & Hospitality. Extensive knowledge and experience of various Business Functions across industries.

·Significant exposure to providing solution map and proposal response involving MDM, Data Governance, Big Data, AI/ML, Analytics and Data Science.

TECHNICAL SKILLS:

·Data Warehousing and Architecture Skills: Data Mart and Data Warehouse Design and Architecture, ETL Architecture and Strategy, MDM Architecture, Big Data Architecture, Cloud Architecture

·Data Management Tools and Techniques: Kimball, Erwin

·Database: Oracle, SQL Server, Postgres, MongoDB

·Visualization: PowerBI

·Programming: Python

·Data Science: Regression, Classification, Clustering, Neural Networks (CNN, RNN, Reinforcement)

·AWS: Data (RDS, Aurora, DynamoDB, Document DB, Redshift)

·Azure: Snowflake, Azure Synapse

·GCP: BigQuery, BigTable, Data Flow, Data Proc, Data Prep

·Databricks: DBFS, Delta Lake, Lakehouse, Delta Tables, MLFLow, Feature Store

EDUCATION:

·Indian Institute of Management, Kolkata, India– Executive MBA, Strategy Management

·Indian Institute of Management, Kozhikode, India– Executive MBA, General Management

·Indian Institute of Technology, Varanasi, India – Bachelor of Technology, Mechanical Engineering

EXPERIENCE:

Architect (Jun 2019 – Current)

Data, Solution, Enterprise and Technical Architecture, Project and Program Management

Major Clients – RW Baird, Milwaukee, WI; TravelCenters of America, Ohio; Prime Therapeutics, Minnesota; Dean Health Plan, Madison, WI; Clarios, Milwaukee, WI; Fidelity Information Services, Milwaukee, WI

·Architected an IT Analytics Solution for SCCM/Intune/Endpoint Manager, ServiceNow and Workday data

·Architected Data Quality and Remediation Strategy and Solution

·Developed POC for Azure Synapse Pipeline, Logic Apps, Azure ML

·Worked on a Recommender System Project For H&M Retailer at Kaggle.com

·Architected an MDM Solution for Location Domain

·Analyzed and Solutioned for an MDM Solution for Location, Vendor and Customer Domains

·Architected a Data Lake on Snowflake and PowerBI on Azure

·Consulted on Solutioning for Microsoft Azure

·Consulted on building the Framework for Foundational Capabilities for Google Cloud BigQuery Data Warehouse

·Consulted on Functional and Technical Solution and Data Architecture for Finance and Rebate Workstreams

·Build a Framework for Integration with Foundational Workstreams on Member, Client, Drug, Formulary, Provider

·Consulted on implementation of GCP services – Composer, STS, Robot, Cloud SQL

·Consulted on building a System of Record for Client Contracts on Salesforce

·Consulted on evaluating the options of connecting Salesforce to BigQuery

·Consulted on design of Data Models for Rebate, Finance, Client, Member, Drug Formulary, Provider

·Consulted on migration and enhancement of Spread, Pass Through, Cohorts and Guarantee Reconciliation

·Consulted on development of Analytics Solutions using Tableau and SAS

·Consulted on design and development of Data Pipelines using Python

·Consulted on design of Load API, Enterprise API and Consuming API architecture using Spark, Kafka, REST and GraphQL for CMS FHIR API rollout for Patient Access and Provider

·Consulted on design of Data Models for Member, Provider, Enrollment, Clinical, Wellness, Care Management Domains for CMS FHIR API rollout for Patient Access and Provider

·Good Understanding of USCDI profiles

·Consulted on development of Analytics Solutions using R and PowerBI

·Consulted on development of Data Pipelines using Python

·Consulted on evaluation AWS Service selection for Data and Data Migration Strategies

·Led the Migration of On Premises Data to Snowflake Cloud using Python.

·Consulted on building Machine Learning solution for Predicting Store Sales

·Consulted on Azure. PowerBI, Data Modeling and SSRS/SSAS project.

·Managed the development from concept to implementation and post-production support of complete BI solutions for Battery Diagnostics on DataBricks.

·Responsible for all aspects of Data Architecture- Data Modeling, ETL Architecture, ETL Load Strategy, BI Architecture, Report Design, Azure Services

·Took initiative to lead and guide Requirement Gathering, Analysis, Elicitation, Engineering

·Technical Project Management

·Data Modeling Reviewer for the Enterprise

·Multiple POC, POV and MVP creation based on Databricks and Kafka.

·Consulted on evaluating AWS Service selection and Data Migration Strategies

Capgemini America (Nov 2018- Jun 2019)

Technical & Functional Solution Architect

Major Clients: Wells Fargo N.A., Charlotte, NC; MUFG, San Francisco, CA.

·Consulted on MDM and Data Integration strategy involving Retail, Wholesale and Private Client business divisions

·Consulted on evaluation AWS Service selection and Data Migration Strategies

·Consulted on solutions involving implementation of Microservices and Rest API.

·Significant contribution in crafting Proposal Response, Roadmap, Functional Use Cases and High-Level Requirements, Data Load and Data Governance Strategy, Future State Architecture

·Build Architecture Solutions including POC, POV, MVP based on Data Lake, HDFS, Hadoop

·Significant contribution in crafting Proposal Response, Roadmap, and Future State Architecture involving MDM, Big Data, AI/ML, Analytics and Data Science.

Tata Consultancy Services (Sep 2016- Nov 2018)

Senior Data and Solution Architect, Project Manager

Major Clients: Flagstar Bank, Troy, MI;

·Led the designing of Data Model and ETL Architecture, Requirements Elicitation, Requirement Engineering, and Tool Evaluation on functional capabilities for an Enterprise MDM Implementation

·Led the Data architecture effort for the Enterprise Data Management and Analytics for Mortgage Lending, Retail Lending, Commercial Lending and Sub Servicing Business Units

·Led the Functional and Technical Analysis and Design for a Mortgage Servicing KPI Dashboard Solution

·Led the Functional and Technical Analysis and Design for a P&L Solution for Commercial Banking Division

·Led the Solution Architecture for Enterprise Data Management and Integration Strategy involving Mortgage Servicing and Origination, Consumer and Commercial Banking and Secondary Markets

·Build Architecture Solutions including POC, POV, MVP based on Data Lake, HDFS, Hadoop

·Consulted on evaluation AWS Service selection and Data Migration Strategies

Cognizant (Aug 2012- Sep 2016)

Senior Data and Solution Architect, Program and Project Manager

Major Clients: LA Care - Los Angeles, CA; Disney- Orlando, FL; State of Nevada – Los Angeles, CA; Takeda Pharmaceutical – Chicago, IL; WestJet, - Calgary, Canada; World Bank – Washington D.C.; JPM Chase – Columbus, OH; Kohls – Wisconsin; ThinkFinance – Dallas, TX.

·Significant contribution in crafting Proposal Response, Roadmap, and Future State Architecture involving MDM, Data Governance, Big Data, Analytics and Data Science.

·Consulted on evaluation AWS Service selection and Data Migration Strategies

·Build Architecture Solutions including POC, POV, MVP based on Data Lake, HDFS, Hadoop

·Led the ETL architecture effort for a Health Insurer

·Led the Design for the MDM, Data Engineering and Data Science (ModelOps) Architecture for a leading Travel & Hospitality Organization

·Led the Data Modeling effort for a leading Travel & Hospitality Organization

·Led the Data Modeling and Data Definition Track for a State Health Insurance Exchange

·Led the Design for MDM and Data Integration for a Specialty Product launch for a Leading Pharmaceutical Organization

·Led the Design team for the Enterprise Data Model for an Independent Airline

·Lead the Design team for P&L DW architecture for a Non-Profit Financial Institution

·Provided expertise on an IBM BDW project for a large Commercial Bank

·Led the Development team for a Teradata DW integration project at a Major Retailer

·Led the Data Architecture team for a Financial Services Client to develop the Data Architecture Framework for their multiple websites

EMC Consulting (Dec 2010- Aug 2012)

Senior Data and Solution Architect, Project Manager

Major Clients: Booz Allen Hamilton - Virginia, BlueCross BlueShield – MA, RI; Vision Services – Sacramento, CA; Pitney Bowes – Stamford, CT;

·Build Architecture Solutions including POC, POV, MVP based on Data Lake, HDFS, Hadoop

·On assignment to a leading health insurance provider to help them kick start their Data Governance and Metadata Management program. Key terms and attributes were identified with the help of client SME and workshops held to come up with their unanimous definition.

·Consulted to a leading consulting firm to build a business case for an MDM implementation by identifying authoritative source for employee data. Collaborated with client IT and business team to identify issues, workarounds in place, and cost of data anomalies and ROI from a solution.

·Consulted to a leading health insurance provider to identify opportunities to scale, enhance and accelerate the build out of their MDM Solution. Collaborated with Client MDM team to create an approach to establish and accelerate the data quality initiative while refining strategic roadmap from both technical and business aspects.

·Consulted as part of a large multi-vendor team helping a large business services provider integrate their worldwide CRM systems into one single instance of SalesForce.com.

Independent Consultant (Aug 2010 – Dec 2010)

Senior Data and Solution Architect

Client: Russell Investment Group – Tacoma, WA;

·Consulted a Leading Investment Services Firm on Enterprise Data Management Strategy for development of Business Intelligence Solutions to support the operations, help fuel growth and improve profits and margins.

iGATE Global Solutions (Mar 2005 – Jul 2010)

Data, MDM & BI Architect, Program & Project Manager

Major Clients: GE Aircraft Engines – Cincinnati, OH, GE Advanced Materials – NC; GE Commercial Finance; GE Corporate – Slough, CT; GE Capital – Stamford, CT; GE Healthcare – Milwaukee, WI;

·Managed the MDM, Data Governance and Metadata Management initiatives for multiple clients.

·Significant contribution on providing Solution Roadmap for multiple clients

·Managed the development from concept to implementation and post production support of complete BI solutions for the Finance, Marketing and Service departments of a leading Healthcare IT services company.

·Drove the requirements and implementation of BI modules for Actuals, Forecast and Orders from a Peoplesoft Source System.

·Oversaw the development and testing of ETL from Peoplesoft Oracle backend to the Teradata ODS using Informatica PowerCenter.

·Led the design of scheduling jobs using Cronacle in a complex multi-use environment.

·Played a crucial role as the technical lead helping guide the team through business modeling, BI architecture, data architecture, ETL architecture, development, design, solution build and deployment.

·Consulted to the corporate office of a large conglomerate to build a HR Dashboard to provide key metrics information to Managers and Executives. Starting point was to arrive at the Data Model based on the analysis of functional needs and existing HR Data.

·Drove the requirement analysis based on the subject matter expertise of the HR Data and the technical expertise in building Data warehouse Dimensional Schemas.

·Facilitating discussion and consensus on Data Model, taking Data Model through to approval by IT and business leaders.

·Created the Logical and Physical Data Model in Erwin including database sizing, index and partition identification.

·Built the ETL Architecture and Design to load the Dashboard Database from existing Data warehouse.

·Led the technical and functional evaluation of Dashboard software in the process identifying technical solutions for the requirements and educating the functional personnel.

·Consulted in Decision Support, Reporting and Analytics activities to Enterprise Sales Group of a leading Commercial Finance firm providing umbrella of credit products to large corporate & industrial clients.

(Sep 1991 – Feb 2005) Available on Request

Contact this candidate