Vaibhav Sharma
Pune
Summary
Seasoned Master Consultant - Data & AI adept at understanding mandates, developing plans and implementing enterprise-wide solutions. Complex problem-solver with an innovative approach. Ready to bring 15 years of progressive experience and take on a challenging new role with growth potential.
Overview
15
15
years of professional experience
Work History
Master Consultant - Data and AI
Wipfli India LLP
Pune
08.2022 - Current
- Created a data warehouse model to store and manage large amounts of structured and unstructured data.
- Designed a logical and physical data model for the organization's database system, ensuring scalability and maintainability.
- Implemented ETL processes (Medallion Architecture) to integrate disparate datasets into the organization's big-data platform.
- Determined optimal approaches for storing, managing, analyzing, and visualizing large volumes of complex data.
- Performed detailed analysis on existing data sources to determine their suitability for integration into the new architecture.
- Collaborated with stakeholders to identify business requirements for analytics solutions, recommending best practices in developing architectures.
- Provided guidance on how to utilize various technologies such as Microsoft Fabric, Databricks, Snowflake, DBT, Rivery, Data Factory, Azure Synapse to maximize efficiency in the organization's data infrastructure.
- Assisted in troubleshooting any issues related to the organization's data warehouse or other analytics solutions implemented within it.
- Built relationships with key stakeholders including IT managers, executives, operations personnel and vendors to ensure smooth implementation of projects.
- Maintained up-to-date documentation on all aspects of the enterprise data architecture.
- Provided training sessions on topics related to Databricks, Fabric analytics solutions.
- Created conceptual, logical and physical data models for use in different business areas.
- Trained non-technical users and answered technical support questions.
- Implemented Artificial Intelligence and Generative AI solutions using Azure Open AI and Google Cloud Platform (GCP) services such as Whisper AI, GPT 4o, Gemini Pro.
- Developed and fine-tuned Generative AI models (LLMs, diffusion models, GANs, VAEs, etc.) to optimize business processes and enhance productivity.
- Build & optimize LLM’s applications, leveraging RAG and build robust Machine Learning pipelines for NLP, Multimodal AI tasks.
- Harnessed the power of Vector Databases (e.g., Pinecone, FAISS, ChromaDB) and LLM APIs (OpenAI, Anthropic, Hugging Face, Mistral, Llama).
- Partnered with cross-functional teams to integrate AI solutions into real-world applications like chatbots, copilots, automation tools, etc.
- Performing continuous research on state-of-the-art AI methodologies, exploring advancements in Generative AI, Autonomous Agents, and NLP to drive innovation.
Data Strategist
Young Living Essential Oils
Pune
05.2022 - 08.2022
- Developed and implemented process improvement strategies to optimize data management processes.
- Analyzed current data flow and identified opportunities for improved efficiency.
- Drafted detailed reports outlining findings and recommendations on various aspects of the data strategy.
- Worked with stakeholders to develop, implement, and maintain a comprehensive data strategy framework.
- Created and maintained documentation related to changes in processes, procedures, or standards related to the data strategy.
- Provided technical guidance on best practices for managing large amounts of structured and unstructured data.
Senior Specialist
L&T Infotech
Pune
12.2021 - 04.2022
- Lead data engineering and analytics development team at Criteo across different geographies
- Worked on data architecture approaches to migrate legacy systems/databases to cloud native services
- Experience on migrating SQL databases to Azure Data Lake, Azure SQL Database, Azure
- Databricks, Azure SQL DW
- Migrating on-premise databases to Azure Data Lake Storage using Azure Data Factory
- Implemented data mining, modeling, and visualization solutions to provide helpful insights using Spark SQL and Power BI
- Developed ETL pipelines for data ingestion into Azure Data Lake Storage and Azure SQL
- DW from Jira, Workday, Salesforce, Hive and Parquet les using Azure data factory
- Data analysis on different sources which includes Salesforce, SAP, big data les, and excel to generate insights for media campaigns
- Helped Criteo on monitoring resources and service utilization to save cost on cloud subscriptions using Azure Monitor, also created dashboards to provide cost analysis for all types of services and environments
- Automated code deployments from lower to higher environments using DevOps CI/CD pipelines
- Wrote Azure functions for serverless computes and streaming data ingestions
- Implemented logic apps for integration between Azure could services and setup Slack channel notfications
- Experience on Power BI workspaces and deployment pipelines
- Refreshing PBI datasets using API calls.
Technical Architect
HCL Technologies
Pune
03.2020 - 12.2021
- Led a team of 5 data analysts and engineers to supervise data analysis, migration, and development of ETL pipelines via SSIS and Azure Data Factory
- Directed SQL Server developments and deployments of data warehousing solutions
- Developed and operated proof of concept (POC) for On-prem data migration to Azure cloud platform
- Managed work allocation by Kanban board, developing Project plans, and estimations using JIRA
- Actively involved in all technical discussions to make sure the team has the right tools at its disposal
- Monitoring progress, time management, and ensuring customer satisfaction
- Lift and shift existing SSIS packages to SQL Server managed instance SSISDB to run them on SQL Agent and ADF pipelines
- Developed Azure Data Factory pipelines for daily data ingestion from On-Prem and
- CRM sources to Azure data lake storage and Azure SQL Server
- Orchestrated different Azure services using Azure Functions and Logic Apps
- Worked on Azure DevOps to manage the boards and automate the production releases using CI/CD pipelines
- Developed Power BI dashboards to provide data insights on the customer life cycle and sales trends
- Developed Tableau dashboards for retail, banking, and insurance clients
- Worked with business to implement the analytics model on NoSQL Elasticsearch database using Kibana data visualization tool
- Experienced on writing JSON queries to fetch un-structured data from Elasticsearch for analysis and data cleansing purposes.
Associate Consultant
Tata Consultancy Services
Sydney
01.2016 - 03.2020
- Led a team of 11 data engineer and analyst professionals
- Managed yearly appraisals, goal settings, and performance feedback of team members
- Developed On-Prem data warehouses from scratch on SQL Server 2016 and designed
- SSIS frameworks to transform and load the data into the reporting layer
- Involved in cloud migration proof of concepts and development plans
- Developed Azure Data Factory pipelines to ingest source data to Azure Data Lake and
- Azure SQL DB
- Designed and developed the interactive and static reports on Power BI using advanced inbuilt charts, DAX expressions, and functions available in the tool
- Experience on creating Power BI workspaces, manage accesses and develop deployment pipelines
- Designed Business Reports as per industry metrics in banking and insurance domain as member experience and business forecasting.
Senior Software Engineer
L&T Infotech
Mumbai
02.2015 - 12.2015
- Supported database management for insurance products and upgraded code to add new business requirements
- Wrote stored procedures, tables, views, and synonyms for new clients and added new business logics in the existing system
- Developed PowerBI reports and implemented subscriptions
- Designed SSIS packages for data integration from different sources and implemented data transformations & KPI calculations
- Collaborated with cross-functional development team members to analyze potential system solutions based on evolving client requirements
- Discussed project progress with customers, collected feedback on different stages, and directly addressed concerns
- Gathered and dened customer requirements to develop clear specications for creating well-organized project plans.
Software Developer
Accenture
Mumbai
07.2013 - 01.2015
- Designed end-to-end framework for data loading, transformation, and reporting using
- MSBI stack
- Researched, designed, and implemented scalable applications for information identication, extraction, analysis, retrieval, and indexing
- Reviewed project specications and design technology solutions that met or exceeded client expectations
- Experience on middleware software like Cozyroc, OLEDB, ODBC, and .Net providers to connect to databases from different sources like Excel, Teradata, MS CRM.
Consultant
Capgemini
Mumbai
06.2010 - 06.2013
- Worked on warehouse designs, schema implementation and data modelling
- Designed and developed SSIS packages to perform ETL operations and SSRS reports for data insights
- Created OLAP applications using analysis services (SSAS) and build cubes using both star and snowake schemas.
Education
Post-Graduate Certificate - Chief Digital Transformation Officer
Indian Institute of Management
Indore04-2025
Bachelor of Technology - Computer Science
U.P. Technical University
08.2008
Skills
- Microsoft Fabric
- Snowflake
- Databricks
- DBT, Rivery
- Synapse
- Azure Data Factory, Purview
- Power BI, Tableau
- SSIS, SSAS, SSRS
- Data Modeling
- DevOps - CI/CD
- Python, PySpark, Spark SQL
- Streamlit
- Artificial Intelligence, Generative AI
- Vector DBs (Pinecone, FAISS, ChromaDB)
- LLM APIs (Azure OpenAI, Google, Hugging Face, Cuda)
AREAS OF EXPERTIES
- Data Analytics
- Data Modelling
- Data Warehouse Designing
- Cloud Computing
- Performance Coaching
Languages
Hindi
First Language
English
Proficient (C2)
C2
Websites
HOBBIES
- Travelling
- Reading
Timeline
Master Consultant - Data and AI
Wipfli India LLP
08.2022 - Current
Data Strategist
Young Living Essential Oils
05.2022 - 08.2022
Senior Specialist
L&T Infotech
12.2021 - 04.2022
Technical Architect
HCL Technologies
03.2020 - 12.2021
Associate Consultant
Tata Consultancy Services
01.2016 - 03.2020
Senior Software Engineer
L&T Infotech
02.2015 - 12.2015
Software Developer
Accenture
07.2013 - 01.2015
Consultant
Capgemini
06.2010 - 06.2013
Bachelor of Technology - Computer Science
U.P. Technical University
Post-Graduate Certificate - Chief Digital Transformation Officer
Indian Institute of Management
Similar Profiles
K. G. PragadeeshK. G. Pragadeesh
Associate Director Marketing & Sales Enablement at Brand & Strategy Wipfli India LLPAssociate Director Marketing & Sales Enablement at Brand & Strategy Wipfli India LLP
Vinod Kumar M RVinod Kumar M R
Audit Senior at Wipfli India LLPAudit Senior at Wipfli India LLP
PRAGADEESH GAJAPATHYPRAGADEESH GAJAPATHY
Associate Director Marketing & Sales Intelligence at Wipfli India LLPAssociate Director Marketing & Sales Intelligence at Wipfli India LLP