Data Analyst Analysis

VINAY KUMAR VASCURI

Ph:+1-385-***-****, *********@*****.*** LINKEDIN GITHUB TABLEAU

EDUCATION

University of Utah, David Eccles School of Business, Salt Lake City, Utah, USA Master of Science (MS) in Business Analytics (MSBA), GPA- 3.96/4.0 Aug 2022 to Dec 2023 Andhra University, India

Bachelor of Engineering (B.E) -Electronics & Communication engineering, GPA- 8.87/10. SKILLS

• Data Visualization/Business Intelligence (BI): Tableau, Power BI (DAX, Power Pivot, Power Query), Power Automate, Power Apps, SnapLogic.

• Database Tools & Cloud Technologies: MS SQL Server, MySQL, PostgreSQL, T-SQL, MS Office, Visio, SharePoint, Advanced Excel (Pivot Tables, Macros), GitHub, Oracle SQL Developer, Oracle Cloud, MS Azure, Azure Synapse Analytics, Microsoft Fabric, ODBC.

• Data warehousing, & ETL Tools: Tableau, Power BI (DAX, Power Pivot, Power Query), OLAP, OLTP, Snowflake, RStudio, Informatica, PeopleSoft, Jupyter Notebook, Google Colab, Domo, Alteryx (ETL), SSMS, SSIS.

• SDLC & Key Skills: Agile, Scrum, Kanban, JIRA, MIRO, Waterfall, Proj Mgmt, A/B Testing, Quality Assurance, Statistical/ Data Analysis.

• Programming Language: SQL, R (dplyr, ggplot, Tidyverse), Python – NumPy, Pandas, KQL

• ERP System: DELTEK -Vision, VantagePoint, Workday, SAP-ERP, SAP-CRM

• AI Integration & Automation: LLM Integration (Open AI Chat Model), Google Sheets API, OpenAI API, WORK EXPERIENCE – 9+ YEARS

Bharat Heavy Electricals Limited (BHEL)( https://bhel.com/) Intermountain Health J-U-B Engineers Inc Summary of experience: Proven to optimize operational efficiency and drive cost savings, I'm a seasoned Data Analyst and Business Intelligence (BI) consultant with over 9 years of experience across India, West Africa, and the USA. I leverage data platforms like MSSQL, Tableau, Power BI, ERP, SSIS, and SSRS to empower stakeholders with actionable insights. EXPERIENCE

J-U-B Engineers, Salt Lake City, USA Mar 2024 to till date BI Team Lead/Analytics Team Lead

• Spearheading a team of 4 members, collaborating with Executive Leadership, Finance and HR to develop scalable BI and data engineering solutions, supporting the company’s growth by 15% increase in Revenue.

• Collaborate closely with internal & external business stakeholders to understand their complex enterprise data needs, including financial, strategic, and enterprise-wide operational data, and translates requirements into effective analytical solutions.

• Created and optimized 30+ SQL templates to supply meaningful & updated data to the Management & Finance teams, thereby standardizing the reporting process and eliminating ad hoc reports

• Led the automation of recurring people analytics projects, achieving 35% increase in productivity and 50% in efficiency, while enhancing customer experience.

• Efficient Data Retrieval: Extracting relevant data from DELTEK ERP systems using SQL Server's powerful transformation functions

(i.e., CTEs, subqueries, Stored Procedures, Views) to prepare data for analysis.

• Integrated data from multiple sources (e.g., ODBC, SQL Server, Excel, and APIs) into Power BI, ensuring consistency and accuracy.

• ETL & Data Modeling: Developed and implemented ETL processes using Power BI to transform raw data. Improved data quality and consistency through effective data cleansing and transformation techniques in Power Query, achieving a 30% reduction in report refresh time and a 15% decrease in data errors.

• Interactive Dashboards: Creating dynamic and visually appealing dashboards in Power BI to showcase KPI’s using the extracted SQL data. Expediting the designing process of interactive dashboards and systemized reports with Power BI, reducing lead time by 35%.

• Power BI App: Developed and deployed a comprehensive Power BI App, ensuring seamless distribution and access to various stakeholders for enhanced data-driven decision-making.

• Power Automate: Designed and deployed automated workflows using Power Automate, streamlining report generation and reducing manual effort by 80%, leading to a significant increase in operational efficiency.

• Enhanced Data Security: Implementing Row Level Security (RLS) to control data access based on user roles and permissions, ensuring sensitive information is protected.

• Developed comprehensive Power BI reports with Dynamic visualizations, Drill-throughs, Smart Narratives and Bookmarks to guide users through complex data sets, reducing analysis time by 30%.

• Dynamic Data Calculations: Leverage DAX (Data Analysis Expressions) to perform complex calculations, create calculated columns and measures, and derive actionable insights from data.

• Managing and publishing Power BI reports to Power BI Service, creating shared workspaces and dashboards for collaborative use, implement auto-refresh of all the reports created for up-to-date insights.

• Collaborating with top director-level leadership (D-Team), IT, HR and Finance teams to analyse HR & Financial data, ensuring alignment of business objectives with data-driven insights and strategic decision-making. Intermountain Health, Salt Lake City, USA May 2023 to Mar 2024 Data Analyst

• Implemented data lifecycle and master data management (MDM) strategies, resulting in a 35% reduction in price discrepancies. Managed procurement data to optimize resource allocation and cost-efficiency within the Enterprise Data Warehouse (EDW) framework. Collaborated with Vizient for GPO portfolio data access and updates.

• Develops and tests temporary fixes in the medical data, manages process modifications as necessary, assesses and tracks outcomes, and makes the necessary adjustments/improvements as required to support financial operations using Advanced excel (automated Excel tasks with macros using VBA) resulting in a 30% decrease in the time needed for monthly financial close processes.

• Managing large data sets including price files, item master content, and contract data content using Advanced SQL queries and creating dashboards using Power BI (DAX, Data Modeling).

• Product owner: Successfully led and facilitated Scrum teams, consistently delivering high-quality products on time. Increased team productivity by 20% through effective sprint planning and retrospectives.

• Platforms used: ServiceNow, Web Now-Perceptive content, Oracle SQL Developer, Oracle Cloud, Workday, Vizient, EDW, Alteryx. Graduate Teaching Assistant - University of Utah Aug 2022 to April 2023 As a Graduate Teaching Assistant in Marketing, I guided students in Business Analytics, Statistics, and Predictive Analytics. BHEL, India (USD $3B Revenue)

Sr. Data & BI Analyst, BHEL Project Management Group April 2018 to July 2022

• Database Administration: Led the team in establishing and managing MSSQL tables for the platform, ensuring data integrity and security by implementing access controls and backup strategies. Collaborated with the cross-functional teams to optimize the MSSQL schema, resulting in a 25% enhancement in query performance and supporting new data requirements.

• Data Visualization: Devised and maintained dashboards using Tableau and SQL (Aggregation, CTEs) to track key performance metrics for the control and instrumentation software operations, resulting in a 20% increase in visibility into operational data and improved decision-making for senior management. (TABLEAU)

• Led the development and optimization of ETL processes using SSIS, achieving a 30% reduction in data processing time and a 20% improvement in overall system efficiency.

• Involved in Designing, developing, generated Sub-reports, Conditional, Drilldown, Drill-through and parameterized reports using SSRS. Achieved a 20% improvement in report efficiency and user interactivity through the implementation of enhanced features and optimized design.

• Spearheaded interdisciplinary project teams through overall analysis, project forecasting, logical testing, risk identification, quality assurance, and post-launch support, reducing lead time by 12%. Data Analyst, BHEL Operations Group April 2016 to Mar 2018

• Designed and Implemented dashboards, enhancing stakeholder productivity by 5% through insightful KPI information.

• Led and managed a cross-functional team to develop and implement a predictive maintenance model using SQL, Tableau, and Excel, resulting in a 20% decrease in maintenance costs and a 10% increase in system uptime.

• Performed a cost-benefit analysis of transportation options using SQL and Tableau and recommended an optimized transportation strategy, resulting in a $20,000 reduction in transportation costs.

• Integrate APIs with databases such as MongoDB and MSSQL. PROJECTS & ACADEMIC COMPETITIONS

• Game Day Analytics Challenge (GDAC): 1st Position (Out of 45 Teams & 6 Universities)- Tools- Alteryx, Excel, Tableau

Analyzed 1.9 million Super Bowl commercial tweets using Alteryx and Azure Cognitive Services via Twitter API.

Conducted sentiment analysis, created 10 impactful data visualizations using Tableau and performed ROI assessment.

• Domo-Layton Hackathon Challenge- Tools – Domo, SQL

Provided Key Performance Indicators (KPIs) and Data-Driven actionable insights for management.

Conducted ETL (Extract, Transform, Load) processes in SQL.

• Automated AI Document Processing Pipeline: Designed and implemented an AI-powered workflow using LangChain Tools Agent to extract structured data from PDF files received via Gmail and append results to Google Sheets.

• Capstone -Kaggle Project:

Led a Capstone Project utilizing various Predictive Modeling Machine Learning (ML) models including Light Gradient Boosting, KNN, Random Forest, and Logistic Regression. The project was executed using Python by leveraging the computational resources of Google Colab for efficient development and execution.

Attained a high-performing solution with a .76 Kaggle score and 92% accuracy for predicting creditworthiness of home mortgage loan applicants.

• Capstone Project Maverik:

Led the development of a dynamic time series forecasting models for Maverik's new store sales, utilizing Python and incorporating qualitative data and seasonality patterns. ACTIVITIES, REWARDS & CERTIFICATIONS

• Microsoft Certified Power BI Analyst- PL300, Azure Certified.

Contact this candidate