Ankush BHANDARI

Work History

State of Texas

02.2024 - 07.2025

Creating Data models for 3 databases (SnF, Archive and FES) in target system
Leading data migration from legacy databases to AWS Postgres
Created data migration workflow, strategy and mapping Documents

Bank of America

07.2024 - 01.2025

Validating the current Data Model
Ensure the load process to model which also captures history
Validate mockup against Data family process
Complete the process Flow of processing Data Family updates
How to generate graphical capabilities from the data family data
How to generate reporting capabilities from the data family data

Commonwealth of Pennsylvania

01.2023 - 12.2023

Managed team for the data migration from the legacy system to Azure
Manage ETL team to get the transformation done for the target system
Optimizing data ingestion, data processing and distribution data from variety of sources, including prophet, web data, 3rd party sources and text files / excel files from the business
Manages the data dependencies between policy admin and source systems, modeling platforms, and hedging and valuation processes
Perform solution designing and analysis by defining data flow framework, data Consolidation, Cleansing, Lineage expertise
Helping team in their SWOT analysis which helps in coping with their increased workload at time of deliveries

Solution Architect

Deloitte & Touché LLP

11.2022 - 12.2023

Pacific Life

04.2021 - 11.2022

Created various Logical and Physical Data models for different subject areas
Optimizing data ingestion, data processing and distribution data from variety of sources, including prophet, web data, 3rd party sources and text files / excel files from the business
Worked on data protection and security policies
Also created Data standards and procedures to implement them
Defined various data protection use cases by documenting business requirements and technology solutions evaluation
Manages the data dependencies between policy admin and source systems, modeling platforms, and hedging and valuation processes
Gathered business requirements, and analyzes and evaluates business needs, requirements, data processes, and systems
Design data quality and protection plan with high Quality standards and drive cross-functional support for implementation
Develop and maintain long-term relationships with stakeholders in account portfolio, where appropriate, by networking between customers, partners, and end users
Create specifications and produce supporting artifacts such as flow charts, use cases, and test scripts and any others deemed necessary by the agile team
Facilitate design sessions for projects with Developers, QA and Product Owners
Lead troubleshooting for production problems and acts as liaison among business areas and technology teams, keeping all parties informed of status, and coordinates problem resolution
Support major initiatives involving modernization of actuarial platform and technologies
Demonstrated ability to think strategically about business, product, and technical challenges in an enterprise environment
Working on Snowflake Database Environment
Represents IT in business meetings, facilitates the development process, and tracks project status
Maintain strong relationships with a both CTS internal and client’s stakeholder, including senior executives, consulting personnel, technical teams, and sales personnels

Associate Director / Principal Data Solution Architect

Cognizant Technology Solution

11.2014 - 11.2022

Lead Pre-Sales team and focuses On-Prem to Target (Cloud) Database migration

Albertsons Companies

08.2020 - 04.2021

Managed 56-member team
Created/configured Azure SQL Databases (PaaS/SaaS/ Managed Instance)
Worked on implementing data risk program design, including alignment to Azure Cybersecurity and its compliance
Created Server/Database firewall rules in Azure SQL Databases
Developed data protection strategies, roadmaps, and framework
Created and configuring Azure SQL Database Managed Instance
Worked on Data Encryption and Cloud Security Protocols
Created Azure Virtual Machines on Windows
Created Azure Virtual Machine Images (including SQL Server)
Migrated On-Prem Databases to Azure SQL Databases (Singleton) using DMA & DMS
Exposure to DMA tools for On-Prem and Azure migrations
Exporting BACPAC from Azure SQL Databases
Understand Active Directory on Azure (Azure AD Connect service)
Having knowledge on Azure Elastic Pool Databases and Elastic Jobs
Creating Shared Storage using File and sharing the files across multiple VMs
Understanding of Regions, Availability Zones and Availability Sets
Working exposure to different types of Storage available (Blob, File, Queue, Table)
Understanding on Premium/Standard Storage accounts
Understanding Azure Networking (VNets, Subnets, Private-Public IPs)
Managing Firewall (NSG) rules to VMs and following security norms of Organization
Helped team by appreciating and honoring their commitments and doing consistent follow up so that deadlines are met

BCBS Healthcare

03.2020 - 07.2020

Developed enterprise Data Governance and Data protection policies, standards, and processes
Worked on Data Discovery, Data Classification and Data Quality management
Provided oversight on existing DW/BI projects and creating architectural direction and Strategic Analytics data initiatives
Cover source to target Data Analysis after understanding Data requirements from Business team
Developed OLTP & OLAP logical data models based on client approved conceptual data models
Engage with All Team (Application/Test/Product Owner) to understand product data needs
Integrated with other projects to support a program approach

Emblem Healthcare

01.2018 - 02.2020

Created Data models for subject areas like Payer, Consumers, Billing
Created Data Environment migration to AWS Cloud environment
Optimize and automate data ingestion, data processing and distribution data from variety of sources, including facets, advertising data, web data, 3rd party sources and text files / excel files from the business
Design data quality plan with high Quality standards and drive cross-functional support for implementation
Designed and implemented Data Access Governance, Data Loss Prevention, Data Recovery Plan
Manage, Monitor, Troubleshoot and solve problems on AWS Infrastructure using resources as Cloud Trail, Cloud Watch, SNS, and S3 for storage, Redshift for Data Warehouse and Lambda etc
Migrated oracle data warehousing environments into AWS
Ensured the product(s) adhere to target reliability, availability, scalability, performance, and security goals/targets
Served as a technology thought leader and expert for assigned business functions and advised business partners accordingly
Identify risks to the customer achieving their stated business goals and work with the account team to build a risk mitigation plan or escalate as needed
Engage with All Team (Application/Test/Product Owner) to understand product data needs
Integrated with other projects to support a program approach

Aetna

12.2016 - 12.2017

Provide guidance on application and integration best practices, Enterprise Architecture standards, functional & technical solution architecture & design, environment management and testing
Coach customers to on how to establish and manage their Change Management/Governance/Centre of Excellence programs
Provide oversight on existing DW/BI projects and creating architectural direction and Strategic Analytics data initiatives
Work with data stewards and did complete end to end data analysis for the source to target system
Did RCA (Root cause Analysis) for data issues and take / implement corrective actions
Project plan is integrated with each team and follows internal project methodology
Developed OLTP & OLAP logical data models based on client approved conceptual data models
Implemented AWS Cloud Technology for Security Module
Used AWS S3 for storage and RDS for OLTP Database
Demonstrated ability to think strategically about business, product, and technical challenges in an enterprise environment
Develop and maintain long-term relationships with stakeholders in account portfolio, where appropriate, by networking between customers, partners and end users
Work as Scrum Master and implemented agile project management principles and practices

TD Bank

03.2015 - 12.2016

Data Governance Lead of executing enterprise data governance, data management and data quality initiatives in line with the organizations business strategy and objectives
Developed OLTP & OLAP logical data models based on client approved conceptual data models
Develop enterprise Data Governance / Data quality policies, standards, and processes
Develop a comprehensive understanding of typical business challenges faced by customers and develop common objectives
Understanding of database and analytical technologies in the industry including MPP databases, NoSQL storage, Data Warehouse design, BI reporting and Dashboard development
Work with business owners to defines and establish data quality rules and definitions consistent with enterprise strategies
Helping team in creating Collateral Wise Dashboard
Knowledge of Apache Hadoop tools such as Pig and Hive
Worked in Scrum methodology with self-organizing, cross-functional team and followed sprint 0-5
Plan and coordinate schema migration task flows and database access requests
Work on UNIX scripts to extract source data files
On-boarding of new team members, including orientation of Data Modelers on project methodology and procedures

United Health Care

11.2014 - 02.2015

Served as a technology thought leader and expert for assigned business functions and advised business partners accordingly
Worked with business partners and SME’s to gather business requirements and translate into functional specification document
Established and implemented project methodologies and processes within work teams
Established project plans, based line the plans, managed schedule and resource load
Assured project plan is integrated with each team and follows internal project methodology
Collaborated and partnered with the users to develop functional and Technical documentation
Led and developed project team members
Integrated with other projects to support a program approach

Senior Data Architect

Icon Technologies

07.2014 - 10.2014

Worked on Physical Inventory Application which enables a variety of opportunities to modify data in its Physical Inventory database
The users modify physical inventory information that resides in a SQL Server Database
Lead the team as Scrum master with sprints 0-3
Performed current state analysis, data quality assessment and root cause analysis of supply chain master data
Conducted comprehensive gap analysis and identification of improvement requirements based on best practices and industry benchmarks
Redesigned Data management processes and procedures to support companywide centralized processes and Data Quality at entry point
Led teams across broad technical and business disciplines
Focused teams on business objectives and tracked progress to ensure project milestones were completed on time, on budget and with the desired results

Horizon BCBS

02.2014 - 06.2014

Worked on Pre-Sales of Big Data Project that was a Proof of Concept for sales team
Gathered medical data i.e
Physician, Patient, Treatment, Diagnosis, and related data from Internet using Mozenda Tool
Gathered additional personal data, such as date of birth, location of birth, Weight and Height, any personal data that reflects the individual
Developed a Data Model to support the storage of content analytics, and to store the full extractions onto AWS EMR (Elastic Map Reduce) environment
Tested the Data in the Alchemy API tool to check for the Alchemy API standards and the keywords which can be used for Descriptive and Performance Analysis
Created the data for Qlikview, an exploration & discovery Analysis
Creating Dashboard from OPENEMR database
Ensured that data once extracted from the EMR was HIPAA compliant
Handled both on-shore and off-shore team of four

Senior Data Architect

Ciber INC.

10.2013 - 06.2014

Wyndham Vacations

10.2013 - 02.2014

Worked on Wyndham's Physical Inventory Application which enables a variety of opportunities to modify data in its Physical Inventory database
The users modify physical inventory information that resides in a SQL Server Database
Performed current state analysis, data quality assessment and root cause analysis of supply chain master data
Conducted comprehensive gap analysis and identification of improvement requirements based on best practices and industry benchmarks
Developed Data Management strategy, established business rules and DM standards, developed metrics for constant service improvement
Redesigned Data management processes and procedures to support companywide centralized processes and Data Quality at entry point
Defined Data Technology requirements and data cleansing strategy to improve effectiveness, efficiency and automation of core business processes

Data Governance Architect

Johnson and Johnson

12.2012 - 10.2013

IBM GLOBAL SERVICES (US and India)

08.2006 - 10.2013

Data Quality Architect

Nasco

03.2011 - 12.2012

Senior Data Architect

State of Michigan, Detroit, MI

09.2010 - 02.2011

Data Architect/ Migration Lead

ONCOR

06.2010 - 09.2010

Data Quality Lead

Care Continuum

04.2010 - 06.2010

Deployment Administrator

T-Mobile

01.2009 - 03.2010

Oracle Consultant & Data Lead

CPCR

08.2009 - 10.2009

DB2DBA

VISTA

10.2007 - 07.2009

Team Lead

Bharti-Airtel

10.2006 - 10.2007

Team Lead

Hewitt Packard

05.2006 - 07.2006

Senior Oracle Consultant

DLF

10.2005 - 05.2006

Summary

Overview

Work History

Solution Architect

Associate Director / Principal Data Solution Architect

Senior Data Architect

Senior Data Architect

Data Governance Architect

Data Quality Architect

Senior Data Architect

Data Architect/ Migration Lead

Data Quality Lead

Deployment Administrator

Oracle Consultant & Data Lead

DB2DBA

Team Lead

Team Lead

Senior Oracle Consultant

Education

Master of Computer Applications -

Graduate in Computer Application - GNIIT

Bachelor of Science Pharmacy -

Skills

Profile Summary

Timeline

Similar Profiles

Avis DupreeAvis Dupree

David SilgeroDavid Silgero

Matt GreenMatt Green

ARUNAVA SAHAARUNAVA SAHA

Patrick LindPatrick Lind