Sports: Cricket, Soccer, Tennis
Self Improvement: Reading, Solving Puzzles, Logical Reasoning
Others: Philosophy, Psychology, Fitness, Nutrition, Neuroscience
VENKATESH SIRANGU
Senior BI Analyst
Spring Hill
Summary
With over 10 years of work experience, I have a strong background in data analysis and business intelligence. My expertise lies in leveraging data to drive actionable insights, optimize processes, and support strategic decision-making. I am known for collaborating effectively with teams, adapting to changing environments, and consistently delivering results. My passion lies in understanding business processes and interpreting and analyzing data to present detailed reports to clients from various domains. I am skilled in providing business solutions, programming, visualization, and problem-solving.
Overview
15
15
years of professional experience
Work History
Senior BI Analyst
Nissan North America, Inc.
09.2023 - Current
- Led the migration project sourced from a third-party vendor to an internal system, resulting in annual savings of $2.2M for the company.
- Spearheaded the Dealer Scorecard project, which monitors key performance indicators (KPIs) for all 1,272 active dealers to enhance their performance.
- Discovered opportunities worth significant revenue for various KPIs, including Service Retention, QRO traffic, Parts, Marketing, and Tires, at the regional level, helping each dealership increase revenue by an average of $220K to $600K annually.
- Improved data collection processes by pinpointing gaps in existing databases and suggesting corrective measures, leading to better overall data quality.
Senior Data/BI Analyst
Eargo
07.2022 - 08.2023
- Conducted an analysis to determine the reasons behind product returns and maintenance requests by examining demographic data.
- Boosted overall sales by $1.1M by developing a real-time dashboard displaying key KPIs such as Leads, Orders, Commissions, Qualified Leads, Store Training, and Welcome Call rate.
- Analyzed data to demonstrate that Android users within a specific age group were returning devices at a higher rate than iOS users.
- Worked on personalizing the customer journey based on website interactions, resulting in a 7% increase in registration rate and a 2.8% improvement in conversion rate.
Senior Data Analyst
Airbnb
02.2021 - 06.2022
- Conducted an analysis to assess the financial and user impact caused by outages, migrations, or database disconnects.
- Monitored Merchant Fees Payins and Payouts KPIs and recommended that a 0.2% adjustment in merchant fees could lead to annual savings of $7M.
- Improved the payment conversion rate for bookings by addressing drop-offs in the conversion funnel after customers clicked the Confirm and Pay button.
- Developed dashboards in Superset to track KPIs such as Gross Payin Volume, Refund Volume, Payout Volume, Merchant Fee Payins and Payouts, and Payments Customer Contact Rate.
Data Analyst II
Asurion
06.2019 - 12.2020
- Designed and developed the Soluto and Protection leadership reports, showcasing KPIs such as Opportunity Rate, Accept Rate, SP100, Resolution Rate, and Net Promoter Score.
- Saved $1.2M annually by reducing the overall Customer Resolution Time by 10 seconds.
- Reduced churn rate by 2% through customer surveys aimed at enhancing satisfaction.
SQL Data Analyst
Summit Materials
05.2018 - 05.2019
- Developed dashboards to track KPIs such as Material Volume, Sales, Plant Costs, Volume Ordered, and Volume Delivered across various business lines, including Aggregates, Cement, Concrete, and Asphalt.
- Conducted an analysis of Driver Punch In and Punch Out times, along with travel distances, to assess driver performance, leading to increased logistics efficiency and saving $140K per month.
- Streamlined operations by monitoring daily loads, trucks, and the average number of drivers using data from Point of Sale systems.
Business Data Analyst
Prudential Financial
08.2017 - 04.2018
- Led the development of a financial prediction tool to assist in planning future financial goals and reduce potential over-expenditure by at least 17%. The tool contributed to a 1% increase in the overall customer base over a 6-month period.
- Created a comprehensive migration plan for transitioning from a legacy system to Drupal, detailing phases such as Analysis, Mapping, Development, and Launch, while identifying risks, dependencies, and mitigation strategies.
- Performed a gap analysis by querying data from the legacy system and mapping components to the new system.
Technical Business Analyst
Scanadu
12.2016 - 07.2017
- Assisted the team in successfully integrating Magento with Salesforce and Netsuite, and implemented a one-page checkout in Magento, replacing the default two-page checkout.
- Converted business requirements into functional specifications for development and QA teams.
- Ensured the platform effectively supports key business functions, including Customers, Orders, Fulfillment, Reporting, and CRM.
Associate Analyst
Ciber Sites India Pvt Ltd
09.2010 - 12.2014
- Effectively communicated client business requirements by creating clear and understandable data and process models.
- Maintained well-organized documentation of completed work, ensuring easy access to historical records for future reference or audits.
- Collaborated with cross-functional teams to gather relevant data, improving the quality of analysis and reporting.
Education
Master of Science - Management Information Systems
Northern Illinois University
Dekalb, IL 05.2001 -
Bachelor of Technology - Electronics And Communications Engineering
Jawaharlal Nehru Technological University
India 05.2001 -
Skills
- Databases: MS SQL Server, MySQL, PostgreSQL, NoSQL
- Programming Languages: SQL, Python, PHP
- Data Visualization: Power BI, Superset, Tableau, Qlikview
- Miscellaneous: ETL, Data Warehousing, Data Modelling, Airflow, Snowflake, AWS, Microsoft Azure, Data Cleansing, Data Quality Management, Github, Agile Methodology, JIRA, Confluence, SharePoint
- Microsoft Office Suite: Excel, Word, Access, MS Project, Visio, Power Point
- Soft Skills: Team player, Deliver results, Communication, Critical Thinking, Problem Solving
Interests
Timeline
Senior BI Analyst
Nissan North America, Inc.
09.2023 - Current
Senior Data/BI Analyst
Eargo
07.2022 - 08.2023
Senior Data Analyst
Airbnb
02.2021 - 06.2022
Data Analyst II
Asurion
06.2019 - 12.2020
SQL Data Analyst
Summit Materials
05.2018 - 05.2019
Business Data Analyst
Prudential Financial
08.2017 - 04.2018
Technical Business Analyst
Scanadu
12.2016 - 07.2017
Associate Analyst
Ciber Sites India Pvt Ltd
09.2010 - 12.2014
Master of Science - Management Information Systems
Northern Illinois University
05.2001 -
Bachelor of Technology - Electronics And Communications Engineering
Jawaharlal Nehru Technological University
05.2001 -
Similar Profiles
Caleb HernandezCaleb Hernandez
Service Advisor at Nissan North America, Inc.Service Advisor at Nissan North America, Inc.
JT AmbergJT Amberg
Lot Technician at Nissan North America, Inc.Lot Technician at Nissan North America, Inc.
Dimitri GenwrightDimitri Genwright
Automotive Technician at Nissan North AmericaAutomotive Technician at Nissan North America