Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic
Pranay Vatsal

Pranay Vatsal

Bengaluru

Summary

Results-driven professional with a Master’s degree in Business Administration, specializing in Business Analytics, and a Bachelor’s degree in Commerce. Possesses 5 years of hands-on experience in data management, governance, and consulting, demonstrating strong capabilities in driving organizational outcomes. Known for exceptional organizational skills and reliability while managing multiple priorities effectively. Committed to contributing to team objectives through a proactive approach and willingness to assume additional responsibilities.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Data Engineer

Tiger Analytics
Bengaluru
07.2024 - Current
  • Managed the team of 12 as a Data Governance & Catalogue lead across three different continents
  • Structured and implemented data governance frameworks, policies and procedures across the organization to ensure compliance with all applicable laws; reduced audit time by 40%
  • Implented Data governance strategy for the client by developing enterprise wide Data catalog and lineage strategy to provide consistency across the organization
  • Identified CDEs, OKRs and Glossaries, implementing it across all the data products in Microsoft Purview
  • Maintained and ensured smooth integration of Purview and Azure Data Lake Storage gen2 and Azure table Databricks
  • Created and participated in the Architecture documents, project design and implementation discussions
  • Work closely across teams (Support, Solution architecture) and peers to establish and follow best practices while solving customer problems
  • Excellent problem-solving and troubleshooting skills

Software Developer

HEB
Austin
03.2023 - 05.2024
  • Participated in the development and implementation of Enterprise Metadata standards, guidelines, and processes to ensure quality metadata and support for ongoing data governance
  • Analyzed data lineage through Informatica Enterprise Data Catalog tool to map data flow, pinpoint data origins, and ensure adherence to regulations
  • Established and managed numerous data resources like glossaries and catalogs to aid in discovering data, tracking its lineage, and managing metadata
  • Devised and executed strategies for categorizing data and implementing access controls to safeguard sensitive PII, PHI or PCI
  • Incorporated AI capabilities of Informatica Axon and EDC to automatically detect sensitive data elements within the customer database by configuring custom data domains and training AI models
  • Teamed up with IT professionals to integrate data governance tools such as those for data quality, metadata management, and overall data governance platforms
  • Actively managing relationships between the key Data Domain Stakeholders, SMEs and IT
  • Worked on Informatica IDQ to create the Standards and rules to measure Data Quality of the organization
  • Worked on customizing the reports by creating Python programmes and integrating it through the APIs
  • Worked Extensively with querying databases for Data Analysis like PostGres SQL and MS SQL Server
  • Worked in AWS environment

Software Developer

Health and Human Services, State of Texas
Austin
02.2021 - 03.2023
  • Worked as a Data Governance consultant for State of Texas, Health and Human Services and M&T Bank
  • Established and enforced Enterprise Metadata standards and processes for robust data governance
  • Managed the integration of technical and business metadata into Informatica EDC and Axon systems, ensuring data lineage and linkage
  • Collaborated with Data Owners and Stewards to develop business glossaries, policies, and quality rules for Critical Data elements
  • Configured Data Catalog scanners to visualize end-to-end data lineage and origins
  • Developed over 30 Glossaries by validating data dictionaries and extracting business definitions
  • Automated asset onboarding and Data Quality Rule implementation by integrating Axon Data
  • Worked as an Implementation Partner strategist in Governance with EDC and Informatica Data Quality
  • Conducted Data Domain Discovery to identify PII and PHI, using AI/ML utilizing various methods for supported metadata systems
  • Implemented organizational policies on Data Protection, Retention, destruction and Storage leveraging the Texas State laws and federal laws
  • Designed over 100 process designs, workflows and change request system to implement Data Democratization in the organization
  • Acted as the primary contact for server activities, managing user groups, roles, and version upgrades
  • Integrated Tableau Reports to Data Governance platform and Created Data domain discovery and the lineage of the data to track the source and the origin
  • Exposure to Tableau Dashboards Development and data analysis using SQL and Tableau Dashboards
  • Implemented more than 20 Privacy Laws and regulations to the organization

Data Steward

Vitosha Inc.
06.2020 - 01.2021
  • Collaborate with the product team to understand requirements and business specifications around portfolio management, analytics, and risk
  • Experience with Informatica Powercenter ETL
  • Conduct cadences and workshops to understand the technical and business metadata of the organization
  • Execute standards onboarding of technical and business metadata into the Informatica EDC and Axon environments, ensuring the population of data lineage and linkage
  • Collaborated with Data Owners and Data Stewards to define business glossaries, policies and data quality rules for Critical Data elements and curate Catalog assets accordingly
  • Integrate Axon Data Governance with EDC and INFA Data Quality to automate asset onboarding and Data Quality Rule automation
  • Establish Axon operating model facets - Organizational Units, People and Roles and Identify & define Systems, their owners, system map scaffolding and system lineage

SOFTWARE DEVELOPER

Itrending Solutions LLC
Tampa
03.2020 - 05.2020
  • Developed and presented findings and solutions to audiences including senior executives and stakeholders
  • Helped the client to Explore the features of newly acquired Informatica Axon and EDC tools and helped them in carving out the business use cases
  • Performed Data Domain Discovery (PII, PHI etc.) - out of box, custom, proximity, and smart data domains for supported metadata source systems
  • Collaborated with business teams to define key performance indicators (KPIs) and metrics, establishing data collection processes and measurement frameworks to track business performance
  • Assisted in the Crisis care initiative at Client 'Bright Horizons' in response to Covid-19 by optimizing and establishing the database infrastructure for the project
  • Extensively worked with the management to create MS Powerpoint presentations for the top management and Business stakeholders
  • Utilized Agile methodologies such as Scrum or Kanban to manage project workflows, prioritize tasks, and track progress effectively

DEMAND PLANNING & CUSTOMER SERVICE INTERN

GOODBABY INTERNATIONAL INC
Canton
08.2019 - 01.2020
  • Collaborated with the teams to fully actualize a demand forecast for $200 million/year revenue and across all channels in United States for 2020
  • Developed Tableau reports and various dashboards to the top management and other teams to visualize the Organization's performance in 2019 in comparison to 2018 and previous years
  • Published forecast reports, variance reports and investigated the missing data on weekly and monthly basis
  • Working closely with the internal cross-functional teams - Sales, Product, Finance, Operations, and IT
  • Created pre-S&OP and executive S&OP reports delivering them during meetings
  • Responsible for the monthly demand planning for major clients like Amazon, Walmart, Target and Best Buy in the entire North American region
  • Analyze business trends and adjust forecast for more than 500 SKUs and products with the help of Sales and Operations team using Advance MS Excel
  • Predicting risks and opportunities for the organization and drive a meeting to discuss and analyze it with the higher management

GRADUATE TEACHING ASSISTANT

UNIVERSITY OF MASSACHUSETTS
Dartmouth
05.2017 - 05.2019
  • Grading and Proctoring the university semester exams
  • Proofreading the research papers and format it in respect to assist the Professor of the department
  • Maintaining records and grades of Assignments, tests, lab results as well as the exams in the portal
  • Addressing grievances, feedbacks and complaints and ensure that the solution to it is provided on time by the university
  • Replying to the e-mails of the students and the management to assist the professor

BUSINESS TAX CONSULTANT

DELOITTE
Hyderabad
06.2015 - 05.2017
  • Experience in management consulting to more than 500 corporate clients based in the Netherlands
  • Reviewed Financial Statements and prepared analysis sheet of the Client's operations on Quarterly basis
  • Reconciliations of Tax Assessments and preparation of deviation reports from the Financial reports and Reporting it to the Dutch Tax Authorities
  • Managed and collaborated with the team of 15 people on industry research and analysis and reported the findings to the manager on a quarterly basis
  • Created visualizations reports as per the business requirements using Tableau desktop and publishing reports to Tableau server
  • Extensively worked on MS Excel functions that include working with large data sets, creating standardized reports, utilizing VLOOKUP's and advanced functions/formulas; creating, using and interpreting pivot tables, filtering and formatting
  • Developing detailed and summary reports of all types, including reports that include PIVOT tables to visualize, analyze and understand the pattern and flow of data

Education

MBA - Business Analytics

University of Massachussetts
Dartmouth, United States
05.2019

B.com (Hons) -

University of Delhi
New Delhi
05.2015

Skills

  • Data Processing Coordination
  • Data Analysis
  • Data Migration Expertise
  • Data modeling
  • Data governance
  • Data curating
  • Data integration
  • SQL and databases
  • Advanced analytics
  • Relational databases
  • Risk analysis

Certification

  • Informatica Axon Governance 6 Professional, 02/01/22
  • Informatica Enterprise Data Catalog 10.5 Developer, 02/01/22
  • Data Governance for Analytics & Regulatory Compliance, 04/01/24
  • Informatica CDGC Partner Bootcamp Associate, 10/01/24

Languages

  • English
  • Hindi
  • German

Timeline

Data Engineer

Tiger Analytics
07.2024 - Current

Software Developer

HEB
03.2023 - 05.2024

Software Developer

Health and Human Services, State of Texas
02.2021 - 03.2023

Data Steward

Vitosha Inc.
06.2020 - 01.2021

SOFTWARE DEVELOPER

Itrending Solutions LLC
03.2020 - 05.2020

DEMAND PLANNING & CUSTOMER SERVICE INTERN

GOODBABY INTERNATIONAL INC
08.2019 - 01.2020

GRADUATE TEACHING ASSISTANT

UNIVERSITY OF MASSACHUSETTS
05.2017 - 05.2019

BUSINESS TAX CONSULTANT

DELOITTE
06.2015 - 05.2017

MBA - Business Analytics

University of Massachussetts

B.com (Hons) -

University of Delhi

Similar Profiles

CREATE PROFILE
Pranay Vatsal