Avantika Singh

Management Consultant

Republic Services

Mar 2024 - Current (2 years 4 months)

As a Management Consultant, I developed data models in Denodo for the Order-to-Cash (OTC) vertical, optimizing reporting processes and enabling self-service capabilities. I automated metadata updates in Denodo using Python, which reduced processing time by 95% and significantly improved workflow efficiency. Utilizing advanced SQL techniques, I analyzed, validated, and tested data models to ensure data accuracy and integrity. I built Streamlit apps on Snowflake that empowered over 200 field and corporate teams to easily access AR transaction data through an intuitive, self-service interface with customizable filters. Additionally, I streamlined data pipelines by migrating more than 20 tables to Snowflake using dbt transformations and Informa

C

Technological Data Intern

City of Tucson

Jun 2023 - Aug 2023 (3 months)

Achieved a 15% increase in conversion rate by analyzing campaign performance metrics (click-through & conversion) using R. Delivered a 30% decrease in data preparation time by automating data cleaning process for training records using SQL and R. Generated a 20% increase in customer satisfaction score by analyzing 10,000+ qualitative customer feedback records using Excel. Utilized regression analysis in R to investigate pricing data and determine the impact of price changes on customer churn rate. Conducted competitive analysis to devise A/B testing strategy for customer portal, resulting in 50% higher user engagement.

C

Graduate Research Assistant - Data Analyst

College of Medicine, University of Arizona

Jan 2023 - Dec 2023 (1 year)

Employed learning analytics to assess grade distributions and student performances across 20+ clerkships and 5+ cohorts. Translated qualitative data into insights, helping uncover diversity and inclusion issues, positively impacting over 900 students. Empowered stakeholders with critical insights and KPIs using Power BI, fueling strategic decisions across all 20+ medical clerkships.

M

Data Analyst II

McAfee, Inc.

Oct 2019 - Jul 2022 (2 years 10 months)

Succeeded in eliminating manual efforts by 90% through the automation of IIS log parsing using Python (NumPy and pandas). Reduced data processing time by 25% through the creation of advanced SQL triggers and stored procedures across 3 verticals. Delivered a 25% increase in product sales by transforming user behavior data into actionable insights using Adobe Analytics. Elevated Customer Satisfaction Score (CSAT) by 20% by creating RESTful APIs that integrated seamlessly with payment gateways. Eliminated security risks by 20% through the implementation of SSO using AWS to streamline authentication for the employees. Spearheaded digital transformation of 50+ on-premises server to AWS cloud by leading cross-functional teams using S3 and EC2. Co

Research and Development Intern

Hewlett Packard Inc

Jan 2019 - Jun 2019 (6 months)

Streamlined product-specific asset files generation for HP Print using C# automation, resulting in 80% decrease in manual errors. Reduced asset file creation errors by 90% and increased user satisfaction by 80%, leading to lower development time and cost. Revamped collation of device-specific information from different specification files into a uniformed format for easier accessibility.

About

Detail

Timeline

Résumé