Vikrant R.

Experience

• 

  Indian Institute of Technology (Banaras Hindu University), Varanasi

  May 2020 - Jun 2020

  Data Analyst

  ● Refined complex SQL queries to retrieve and manipulate large datasets from relational databases, improving data accessibility for academic research and institutional reporting.● Automated 5+ data analysis and reporting tasks using Excel, integrating advanced functions like Pivot Tables, VLOOKUP, and Macros to streamline research workflows.● Conducted A/B testing to evaluate the impact of research methodologies, providing data-driven recommendations that improved experimental accuracy and outcomes.● Performed data mining using Python (Pandas, NumPy) to uncover hidden patterns in large datasets, supporting research projects in engineering and technology. Show less

• 

  Adani Group

  Oct 2020 - May 2021

  Data Analyst

  ● Contributed to refining ETL processes by leveraging Python (Pandas, NumPy, SQL) to streamline data extraction, transformation, and loading, reducing manual intervention and improving operational efficiency.● Conducted data validation and quality checks on extensive datasets, ensuring accuracy, consistency, and reliability for research-driven insights and decision-making.● Designed dynamic dashboards and analytical reports using Power BI, transforming raw data into meaningful visual narratives to support data-driven strategies.● Coordinated in automating data ingestion and transformation workflows, minimizing redundant tasks and accelerating data processing by 20%.● Explored and interpreted large datasets to uncover patterns, trends, and correlations, providing actionable intelligence for ongoing research initiatives. Show less

• 

  Accenture

  Jul 2021 - Jul 2022

  Business Analyst

  ● Partnered with internal departments to analyze existing workflows and develop clear documentation outlining essential data requirements for system enhancements; identified the top three areas causing delays in processing.● Facilitated digital transformation initiatives by optimizing business processes and assisting in the development of scalable application solutions.● Conducted data-driven analysis using SQL and Snowflake to generate insights that enhanced business decision-making and system performance.● Configured Snowflake Virtual Warehouses to ensure cost-efficient and scalable data processing for enterprise applications.● Coordinated 2+ ETL pipeline management tasks, improving data flow automation and ensuring seamless data integration for business intelligence reporting.● Designed data governance frameworks for 100+ datasets, ensuring compliance, accuracy, and standardization across analytics and reporting functions.● Monitored and maintained data quality standards on 10,000+ records, identifying inconsistencies and implementing validation processes to improve data integrity.● Applied Azure SQL Database and Snowflake to enhance storage and retrieval of enterprise analytics, improving access to critical insights for executive decision-making.● Constructed 2 Power BI dashboards providing real-time business performance insights, facilitating data-driven decision-making for internal and external stakeholders.● Facilitated UAT (User Acceptance Testing) and application enhancements, working closely with developers to ensure business requirements.● Coordinated in optimizing system workflows and business processes, aligning technology solutions with business objectives to drive efficiency and operational improvements. Show less

• 

  Uber

  Jul 2024 - now

  Data Analyst

  ● Maintained interactive dashboards in Power BI, delivering real-time insights into ride demand, driver performance, and operational efficiencies, improving reporting accuracy by 20%.● Conducted SQL-based data analysis on large-scale trip datasets (5+ TB), identifying inefficiencies in routing and surge pricing, leading to improved cost-saving strategies.● Collaborated with cross-functional teams (finance, operations, and engineering) to leverage Azure Databricks, enhancing data-driven decision-making for fleet management and reducing resource allocation inefficiencies by 15%.● Optimized SQL queries for database performance, ensuring seamless data retrieval for real-time ride analytics and compliance reporting.● Built data pipelines using Azure Data Factory, integrating trip records, driver metrics, and customer feedback to improve ride experience and operational insights.● Performed data cleansing and transformation in Azure Synapse Analytics, improving trip data accuracy and reducing inconsistencies in predictive demand models.● Enhanced ETL workflows with Azure Data Factory and PySpark, streamlining integration from GPS tracking, financial, and ride management systems, reducing data processing time by 30%.● Developed 5+ scalable data models in Snowflake, improving driver-partner analytics and supporting demand forecasting strategies.● Automated ETL workflows for ride and operational data, enabling faster processing of trip records and optimizing service delivery. Show less