BI analyst
Resume:
Nikhila Gupta
**************@*****.***
SUMMARY:-
Goal-oriented BI professional with 10 years of experience in Data Analytics and business intelligence Analytics for health tech and fintech organizations. Proven expertise in data-driven decision-making, working with large datasets and delivering insights through data visualization platforms such as Tableau and Power BI. Proven ability to lead cross-functional projects, improve data quality, and create frameworks that align with business objectives. Passionate about storytelling through data and thriving in SaaS based companies. She has applied statistical techniques and hypothesis tests to perform data-driven analysis and prove business assumptions. She utilized GCP, Azure, Hive, and Snowflake data warehouses for data storage and analysis. Skilled in Python and R, the candidate performed data wrangling, and statistical analysis, and developed machine learning models. Proficient in using Tableau, Power BI, and Google Collab, she has created interactive dashboards, reports, and charts to communicate insights and trends. Her expertise also extends to agile methodologies, JIRA, Looker, and collaborative work with research analysts, state agencies, and business stakeholders. She has excellent communication skills and is available to start a new role Immediately
SKILLS
SQL, TABLEAU, PYTHON, POWER BI, EXCEL, SNOWFLAKE, AWS REDSHIFT, AZURE, GCP, BIGQUERY, PYSPARK, DATABRICKS, DBT, ALTERYX, GENAI, MACHINE LEARNING, AB TESTING, AIRFLOW, HIVEQL, R, GOOGLE ANALYTICS
EXPERIENCE
Health Edge Software Inc, Atlanta — Senior Business Intelligence Analyst
NOV 2020 - PRESENT
●Designed and implemented a Patient 360 dashboard in Tableau, integrating data from a centralized healthcare data warehouse on Azure SQL Database, enabling business teams
to improve member lifecycle processes through robust, query-driven insights.
●Improved data quality by developing ETL workflows and data validation routines in the data warehouse, using advanced SQL and Tableau Prep, resulting in 35% more reliable and accurate reports and a 33% increase in dashboard usage.
●Optimized and directed resource allocation in care organizations by 8% through predictive analytics and SQL-based modeling on utilization data stored in the data warehouse, with insights delivered via Tableau dashboards.
●Reduced readmission rates by 15% by conducting advanced statistical analysis and complex SQL queries within the data warehouse, providing actionable insights for readmission strategy.
●Facilitated KPI brainstorming sessions with cross-functional teams and influenced data visualization strategy, leveraging Tableau dashboards sourced from the enterprise data warehouse.
●Collaborated with executives to assess data needs and built technical solutions using SQL and Tableau on top of a scalable data warehouse, improving task management and operational efficiency.
●Designed and developed a Member Demographics dashboard in Tableau, utilizing data from the data warehouse, which helped reduce high-risk conditions among children by 21%.
●Supported the data team in troubleshooting and optimizing SQL code and ETL processes within the data warehouse, ensuring efficient data pipelines for Tableau reporting.
●Modified existing Tableau reports and underlying data sources in the data warehouse, implementing client-specific changes and delivering timely, accurate results.
●Assisted team members in resolving SQL job issues and data inconsistencies within the data warehouse, ensuring seamless Tableau integration and data integrity.
●Managed multiple data projects leveraging the data warehouse, training and mentoring junior analysts on best practices in SQL, ETL, and analytics.
●Spearheaded the development and delivery of impactful reports using SQL and Tableau, extracting data from the Guiding Care application via the data warehouse to support business decision-making.
●Led cross-functional teams in successful project implementation, driving client onboarding and ensuring seamless integration of Tableau reporting solutions with the data warehouse.
●Collaborated with project managers to define milestones and deliverables, providing strategic oversight for data warehouse-driven analytics projects.
●Conducted training sessions for promoting continuous learning in SQL, data warehousing, and Tableau to enhance team expertise.
●Conducted regular code reviews for team members, ensuring high-quality, efficient, and maintainable SQL and Tableau scripts connected to the data warehouse.
Blue cross BlueShield of Michigan, Detroit — Business Intelligence Analyst
JUN 2020 - OCT 2020
●Developed and maintained Employee Survey KPI dashboards in Looker, sourcing and transforming data from Big Query to deliver real-time, actionable insights on employee satisfaction.
●Conducted in-depth analysis of employee feedback and engagement metrics using Looker and Big Query, identifying key drivers of satisfaction and presenting findings to leadership
for targeted interventions.
●Designed and evaluated machine learning models on employee data stored in Big Query, leveraging predictive analytics to identify trends and factors influencing employee retention.
●Collaborated with HR stakeholders to implement data-driven retention strategies, visualizing model results in Looker dashboards, which contributed to a 10% increase in employee retention.
Virtudent, Boston — Data Analyst
JUL 2019 - MAY 2020
●Enhanced the Performance KPI Dashboard using Power BI, providing real-time visibility into key business metrics by integrating live data from Snowflake, saving 40 hours per week for executives.
●Reduced last-minute appointment cancellations by 17% by analyzing appointment and rescheduling data with Python, visualizing trends and actionable insights through Power BI dashboards connected to Snowflake.
●Boosted client adoption of the new BI solution by 7% by delivering data-driven recommendations to the Product team, leveraging advanced analytics in Python and interactive reporting in Power BI.
●Achieved a 25% reduction in latency by optimizing data workflows in Snowflake and automating data processing with Python, resulting in faster and more efficient data handling.
●Analyzed healthcare appointment datasets using Power BI dashboards, extracting key business insights and optimizing performance with data sourced from Snowflake and processed via Python scripts.
●Achieved 80% accuracy in predicting dental health outcomes based on demographics by building and validating data models in Python, utilizing Snowflake for data storage and Power BI for result visualization.
●Built a robust data pipeline at Virtudent using Python and Snowflake to enable a centralized, automated reporting system in Power BI, eliminating manual reporting bottlenecks.
●Proposed new data input processes for improved data collection, leveraging Snowflake’s scalable architecture and Python automation, which increased data generation by 50%.
●Provided data solutions in the form of success story summaries and campaign statistics by integrating data from Snowflake, analyzing with Python, and visualizing in Power BI for efficient marketing campaigns.
● Automated the generation of weekly business performance reports by orchestrating data flows in Snowflake and Python, with results delivered via Power BI, saving 45 person- hours monthly.
Capital One, Chicago — Data Analyst
JUL 2018 - JUN 2019
● Participated in all phases of research including data collection, data cleaning, data mining, visualizations, and developing models.
●Collaborated with data engineers and operation team to collect data from internal systems to fit the analytical requirements (Database, Datawarehouse, API, flat files).
●Worked in GCP (Spanner, Big query), Azure (SQL database, Synapse Analytics), Hive, and Snowflake data warehouse for data storage and data analysis processing.
●Performed data wrangling and standardization using Python (NumPy, Pandas, SciPy, Scikit- learn) and (dplyr, tidy, ggplot2).
●Possessed strong Documentation skills and knowledge sharing among the team, conducted data modeling review sessions for different user groups, and participated in sessions to identify requirement feasibility.
●Optimized data models for high-performance querying, improving model training times by 30%- 50%.
●Reduced downtime of critical data pipelines by 50% through proactive monitoring, optimized scheduling, and load balancing.
●Led the design and development of Azure Databricks-based data engineering solutions to support real-time analytics and machine learning initiatives.
●Consolidated redundant data pipelines, reducing operational costs by 20%-30% annually.
●Performed statistics technique, distribution analysis, and hypothesis test including ANOVA test, T-test, F test, and A/B test to prove the business assumption through data-driven analysis using Python.
Capsource, Syracuse — Website Analytics Engineer
AUG 2017 - JUN 2018
●Designed and implemented tracking infrastructure using Google Tag Manager, enabling accurate data collection for user interactions across CapSource’s web platform.
●Analyzed user behavior through Google Analytics 4 (GA4), identifying top-performing pages and uncovering drop-off points in the user journey that led to a 15% increase in conversion funnel visibility.
●Created custom events and triggers in GTM to monitor engagement metrics such as button clicks, form submissions, and scroll depth, improving UX insights.
●Built interactive dashboards and weekly reports to visualize KPIs like session duration, bounce rate, and traffic sources, empowering business stakeholders with actionable insights.
●Collaborated cross-functionally with marketing and product teams to implement A/B testing strategies and optimize campaign performance using GA audience segmentation.
●Conducted tag audits and QA testing to ensure data integrity and proper firing of GA4 tags and triggers across multiple site environments (dev, staging, production).
●Implemented cross-domain tracking in GA4 to ensure accurate attribution across CapSource’s partner portals and marketing subdomains.
●Collaborated with UX and product teams to define key engagement metrics, aligning GTM tracking implementation with evolving business objectives.
●Conducted traffic source analysis using GA4 acquisition reports, identifying high-converting referral paths and informing budget allocation for paid campaigns.
●Designed a weekly executive dashboard using Google Data Studio (Looker Studio), combining GA4 and GTM data to surface real-time performance insights.
●Set up custom dimensions and metrics in GA4 to capture unique data points (e.g., user type, traffic intent, content category) for more granular segmentation.
●Worked with the content marketing team to analyze blog performance and optimize internal linking structures based on GA4 user flow insights.
●Defined KPIs for stakeholder reporting, linking analytics insights to business outcomes such as lead generation, user engagement, and trial-to-signup conversion rates.
●Conducted training sessions for internal stakeholders on interpreting GA4 dashboards and understanding web analytics terminology and performance indicators.
J.P. Morgan Chase, India — Business Technology Analyst
JUL 2015 - JUN 2017
●Researched and automated the manual process of reviewing rejected transactions by developing SQL queries and Excel-based dashboards, decreasing transaction misrouting by 5%.
●Utilized SQL and advanced Excel functions to perform forecasting and trend analysis, delivering actionable insights that led to a 22% reduction in rejected transactions.
●Reduced customer escalations by 23% by analyzing check encoding errors using SQL data extraction and implementing new coding logic, tracked and reported through Excel.
●Designed and developed SQL validation scripts and Excel data checks to ensure data quality at all stages of customer payment processing.
●Accelerated the process of analyzing client financial data by building summarized reports using SQL queries and Excel pivot tables, and visualizing results in BI tools.
CERTIFICATIONS
●Tableau Desktop Specialist 2020
●Microsoft Office Specialist Excel 2016
●Google Analytics Individual Qualification 2017
EDUCATION
Syracuse University, New York — Master of Science in Information Systems & Data Science
Courses: Data Science, Product management, Data Visualization, Agile Project Management, Business Analytics
Mumbai University, India — Bachelor of Engineering in Information Technology
Courses: Data Warehousing, IT System Analysis, Software Engineering, Statistics, Database management
Contact this candidate