Ankita Rawat
Analytics consultant
Bangalore
Summary
Experienced Analytics Consultant | Proficient in SQL, Python, and Data Visualization | Driving Data-Driven Insights for Business Success
Overview
9
9
years of professional experience
2
2
Languages
Work History
Analytics Consultant
Wells Fargo
12.2023 - Current
- Conducted in-depth customer data analysis using SQL and Teradata to validate eligibility for marketing offers based on evolving business requirements, enhancing targeting accuracy, and ROI.
- Measured and tracked the performance of marketing campaigns, delivering results to stakeholders via management dashboards, and actionable insights.
- Streamlined the bonus inquiry resolution process, reducing the average turnaround time from 10 days to 4 days by redesigning workflows and applying data-driven process improvements.
- Optimized data workflows by reducing manual steps, achieving a 50% decrease in SLA for email responses (from 48 hours to 24 hours) through automation and better data handling.
- Extracted and processed high-volume data using SQL (Teradata), Excel, and automated pipelines to support campaign analytics and data-driven decision-making.
- Proposed and implemented enhancements to existing analytics solutions, improving operational efficiency, and enabling faster decision-making.
Assistant Manager-Data Science
Vodafone
07.2021 - 12.2023
- Enhanced fleet reports for strategic, data-driven decisions.
- Collaborated cross-functionally to streamline report processes.
- Created dashboards to track key service delivery metrics.
Service Management
Ericsson Global Services
04.2016 - 07.2021
- Led team to exceed incident management KPIs effectively.
- Utilized Remedy for efficient incident escalation & coordination.
- Streamlined processes to boost communication & restore services.
- Managed projects for MBNL enhancing network operation support.
Education
B-Tech - Electronics And Communications Engineering
Graphic Era University
Dehradun, India 04.2001 -
High School Diploma -
Moravian Institute
Dehradun, India 04.2001 -
Skills
- SQL
- Data Analysis
- Advanced Microsoft Excel
- Python Programming
- Data Analysis & Reporting
- Dashboard creation using Power BI,data visualization
Strengths
- Data Analysis Proficiency, Transformed complex data into understandable reports leading to a 30% increase in effective decision-making.
- Communication, Proficient in simplifying complex data into clear, actionable insights, enabling seamless communication across departments.
Timeline
Analytics Consultant
Wells Fargo
12.2023 - Current
Assistant Manager-Data Science
Vodafone
07.2021 - 12.2023
Service Management
Ericsson Global Services
04.2016 - 07.2021
B-Tech - Electronics And Communications Engineering
Graphic Era University
04.2001 -
High School Diploma -
Moravian Institute
04.2001 -
Similar Profiles
PATRICIA M. SCHERERPATRICIA M. SCHERER
Regional Bank Private Banker II at Wells Fargo Bank / Wells Fargo AdvisorsRegional Bank Private Banker II at Wells Fargo Bank / Wells Fargo Advisors
Andrew S. HollenbachAndrew S. Hollenbach
Collateral Valuation Analysis at Wells Fargo Home Mortgage and Wells Fargo Bank NACollateral Valuation Analysis at Wells Fargo Home Mortgage and Wells Fargo Bank NA
Laxmikanth ChittampallyLaxmikanth Chittampally
Senior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells FargoSenior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells Fargo
Mayank OberoiMayank Oberoi
Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)
Anil Kumar SawAnil Kumar Saw
Staff Engineer at Altimetrik India Pvt. LtdStaff Engineer at Altimetrik India Pvt. Ltd