Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Additional Information - Experience
Timeline
Generic

VINAY VALETI

Summary

Dedicated data professional with over 14 years of experience as a lead database architect, cloud data engineer, and data analytics leader with handson experience is coding. Seeking an opportunity to leverage my expertise in data management and analytics to support business users in their data interactions, automate data processes, and enhance data workflows for trading strategies. Strong programming skills in SQL, Snowflake and Python, experience in data infrastructure, ETL pipeline management, and working with financial datasets make me an asset for your team. Experienced in managing onshore and offshore teams and enjoys working in a collaborative team environment.

Overview

16
16
years of professional experience
1
1
Certification

Work History

Director - Data Engineer

Apollo Global Management INC
07.2022 - Current
  • Technical lead on snowflake implementation for the organization. Implemented snowflake RBAC, Governance and Security. Worked on firm wide adoption of snowflake platform.
  • Worked with snowflake support team in implementing automated solution for snowflake account switchover for east to central as part of DR strategy.
  • As Part of snowflake COE Worked on building automated processes for snowflake adoption. Documented the snowflake processes in confluence. Built use cases and conducted training session for data engineers and business users.
  • Technical lead for multiple data engagements, worked on different ETL tools
  • Implemented data quality rules in Collibra DQ
  • Collaborated with Developers and Business users to onboard and optimize alternative datasets for portfolio performance
  • Enhanced data workflows for existing datasets, facilitating more streamlined process and made datasets available much faster
  • Worked closely with financial and alternative data vendors like Bloomberg and FactSet, managing various delivery platforms
  • Built tools and automation capabilities to ensure data platform quality
  • Onboarded business intelligence platforms like pyramid analytics.
  • Implemented data ingestion from variety of sources like FTP, API’s, RDBMS systems and File system sources like Excel, CSV and other formats.
  • I run tech scrum for multiple projects, enforced agile software development methods in running the projects
  • Implemented terraform templates to deploy resources in Azure

Technical Database Manager

KPMG LLP
04.2008 - 07.2022
  • Worked on Modernizing database tech stack for a tax practice in KPMG which involves multiple products and thousands of clients while maintaining the system available during the transition process
  • Lead a team of database developers to oversee SQL databases
  • Worked on making sure the team gets required knowledge in transitioning the database stack to cloud and involved in setting the goals and plans for continuous learning of the team members
  • Worked on creating database schema from scratch for multiple in-house tax projects and discussed application requirements with subject matter experts in coming up with logical and physical data models
  • Worked on creating routines for automating database administrative activities like index and stats rebuild, collecting performance tuning metrics, database check dB commands
  • Worked on implementing disaster recovery and high availability solutions
  • Worked on creating database objects like complex stored procedures and fine tuning the code and fixing performance issues within the database
  • Involved in creating multiple POC's in cloud migration of multiple Tax applications
  • Worked on implementation and deployment KPMG Tax solutions on premises and at client locations
  • KPMG Link has hundreds of clients
  • I played an important role during initial client setups, ongoing maintenance of database solutions using SQL server and involved in any client performance issue remediation
  • Created dashboards and Reports using Power BI for multiple client implementations
  • Involved in discussing with client requirements like what kind of insights clients looking to get from the data and provided ideas and solutions on visualizations that makes the data come out and provide value to the business
  • Working as a lead to Migrate the entire DB stack for one of the KPMG practices to cloud
  • Using Azure SQL MI and Azure SQL databases to migrate the data from on premises SQL server deployments
  • Worked on creating routines for data privacy, safeguarding client PII Data
  • Working in Migrating SSIS and Alteryx solutions to Azure cloud
  • Created Data Processing ETL pipelines using python, Azure ADF, SSIS and Alteryx
  • Discussed Product strategies with C level executives and future direction for database solutions in KPMG GMS Practice.

Education

Data Science - Masters

LJMU - UK

Data Science - Post Graduate Diploma

IIIT - INDIA

Electronics - Master of Engineering (M.E)

Satyabhama University - INDIA

Electrical/Electronics - Bachelor of Technology

J.N.T. University - INDIA

Skills

  • Snowflake
  • SQL Server
  • Azure Data Bricks and Spark
  • Data Architecture
  • T-SQL
  • SSIS (SQL Server Integration Services)
  • Power BI
  • Azure SQL
  • Azure SQL MI
  • Azure data factory
  • Azure storage accounts
  • Azure DevOps and Azure AD
  • Azure Synapse analytics DW
  • Knowledge about AWS
  • Collibra Data quality and Data Catalogue
  • Logical and Physical Data Modeling
  • SQL Server Installation and DB Administration
  • High Availability and Disaster recovery Solutions
  • Alteryx
  • Python (NumPy, pandas, machine learning libraries)
  • T- SQL
  • C#
  • Big Data and Machine Learning
  • Worked on machine leaning models as part of master’s in data science Machine Learning Models (Regression, Classification)
  • Worked on creating models using GBM and LGBM algorithms
  • Working knowledge of Data & Analytics tools and platforms like Tableau, Power BI,Data iku and Pyramid analytics
  • CI/CD
  • GitHub
  • Project Management
  • Process Improvement
  • Database Management
  • Team Collaboration and Leadership
  • Critical Thinking
  • AWS S3 and RDS knowledge
  • Knowledge about MongoDB, PostgreSQL and Cosmos DB

Certification

  • Alteryx Designer core certified
  • Scrum Certified
  • AZ-900 Azure Fundamentals certified

Accomplishments

  • Received Microsoft Community Contributor Award for 2012
  • Received encore awards several times in my current and previous organization.

Additional Information - Experience

  • Supports Kids education through World Vision Sponsorship
  • Supports Kids Health through St Jude fundraising.

Timeline

Director - Data Engineer

Apollo Global Management INC
07.2022 - Current

Technical Database Manager

KPMG LLP
04.2008 - 07.2022

Data Science - Masters

LJMU - UK

Data Science - Post Graduate Diploma

IIIT - INDIA

Electronics - Master of Engineering (M.E)

Satyabhama University - INDIA

Electrical/Electronics - Bachelor of Technology

J.N.T. University - INDIA
VINAY VALETI