Strategic Analytics Developer

Akanksha Singh

San Francisco, California ****************@*****.*** 628-***-****

linkedin.com/in/akankshalksingh/ github.com/akankshalksingh Portfolio Tableau Work Experience

Strategic Analytics Developer, UPMC Health Plan Apr 2025 - Present San Francisco, CA, USA

● Streamlined automated reporting workflows by utilizing advanced SQL queries and integrating Power Automate, reducing report generation time by 51% and enhancing data accessibility for over 5 cross-functional teams

● Collaborated with stakeholders to integrate diverse data sources into interactive dashboards using Power BI, resulting in a 25% improvement in user engagement and providing actionable insights that drove strategic initiatives

● Analyzed cost trend patterns utilizing financial data in SQL and Excel, identifying $15M in potential savings opportunities, which contributed to a 22% reduction in operational expenses within UPMC’s population health division

● Engineered and optimized multiple Airflow DAGs to streamline SQL-to-Excel reporting workflows, reducing manual processing time by 43% and ensuring the timely delivery of 20+ business reports per month Data Analyst, Project Management Institute SFBAC Dec 2022 - Mar 2025 San Francisco, CA, USA

● Designed end-to-end data solutions integrating Tableau and SQL Server for real-time business intelligence reporting, improving data visibility, and reducing time-to-insight by 25%

● Analyzed trends in event cancellations and membership engagement, identifying key pain points that led to a 12% reduction in recurring issues through targeted data-driven initiatives

● Designed interactive data storytelling modules in Tableau, transforming complex datasets into compelling visual narratives and increasing stakeholder satisfaction by 30% based on meeting feedback Product Data Analyst Intern, Datawisp Jan 2024 - Apr 2024 San Francisco, CA, USA

● Developed actionable insights into customer behavior and marketing campaign performance using Looker and Google Analytics, driving a 15% increase in user retention and engagement

● Optimized feature prioritization and campaign strategies by leading A/B testing initiatives using Google Optimize, resulting in a 12% increase in user conversion rates

● Worked closely with product managers to design surveys and analyze customer feedback, identifying key improvement areas that boosted customer retention by 16%

Data Analyst, Phonon Communication Pvt Ltd Dec 2020 - Jul 2022 Pune, MH, India

● Maintained and developed dashboards for KPI tracking and feedback analysis using Tableau, delivering actionable insights that enhanced product performance metrics for 15+ B2B stakeholders

● Utilized SQL to analyze Salesforce CRM data, uncovering user interaction trends and onboarding bottlenecks, which led to data-driven recommendations that improved user engagement by 23% within the first quarter

● Utilized statistical techniques and clustering algorithms to analyze 1.5 million customer interactions, identifying irregular patterns in IVR paths, leading to a 40% reduction in drop-off rates

● Conducted API testing during User Acceptance Testing (UAT) utilizing Postman to verify data accuracy, resulting in a 19% reduction in integration issues and enhancing system reliability through detailed documentation Business Analyst, Grant Revert Jan 2020 - Nov 2020 Pune, MH, India

● Spearheaded the development of data governance policies, resulting in a 36% improvement in data quality, data review, and compliance adherence across departments, aligning with both organizational and regulatory standards Education

Master of Science in IT Project Management, Golden Gate University Sept 2022 - Dec 2024 San Francisco, CA, USA Bachelor of Engineering (Computer Engineering), Savitribai Phule Pune University Aug 2016 - May 2020 Pune, MH, India Skills

● Programming & BI Tools: Python, Advanced SQL, MongoDB, PostgreSQL, Tableau, Microsoft Power BI, Excel, DAX

● Analytics: Predictive Analytics, A/B Testing, Predictive Modeling, Metrics & Conversion Analysis, Business Process Modelling, KPI Tracking & Performance Metrics, Data Management, SSIS, Looker, Azure Data Factory, Azure Synapse Analytics, Databricks

● Other: Agile Methodologies, ETL, AWS Redshift, Snowflake database, JIRA, Root Cause Analysis, Amazon Web Services, Solution Design, Data manipulation, Ad-hoc analysis, Microsoft Fabric, Airflow, Toad, Figma, Quicksight, QlikSense, Confluence

Contact this candidate