Vidya Charan Vempati
Richardson,TX
Summary
Results-driven data professional with a keen eye for detail and a passion for uncovering actionable insights from data. Demonstrated success in utilizing data analysis and visualization tools to drive business decisions and optimize processes. Team-oriented individual with a strong focus on collaboration and adaptability, consistently delivering reliable results in dynamic environments.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Data Analyst
Ivynova
07.2023 - Current
- Conducted comprehensive document analysis on existing ERP, POS, CRM, and on-premises databases, ensuring seamless coordination with the new system.
- Executed source analysis to pinpoint and analyze crucial data points, resulting in a 10% reduction in integration issues and saving approximately 8% in overall project costs
- Used statistical methods to analyze data and generate useful business reports.
- Conducted GAP analysis to understand as-is process flow and determine to-be process flow to capture all the essential Functional, Non-Functional, GUI requirements of the new system.
- Applied SAS for customer analysis, achieving a 17% boost in satisfaction and driving a 9% sales increase through targeted tier based strategies.
- Participated in the UAT to rigorously test the Loyalty program interface with multiple scenarios.
- Conducted extensive consultations with marketing teams to identify and document requirements for customer analysis
- Presented findings on customer behavior, preferences, and trends to guide targeted marketing efforts
- Utilized data visualization tools to effectively communicate business insights.
- Conducted thorough competitor analysis to identify industry trends and benchmark marketing strategies.
- Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
- Provided actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.
- Automated routine data analysis tasks, freeing up time for more complex analysis.
- Supported marketing strategies by providing detailed customer segmentation analysis.
Marketing Analyst
Digital Savants
08.2022 - 05.2023
- Analyzed multiple years of scanner data on various products and competitors to calculate market share and gain insights into brand performance
- Compared results to top brands in the category to identify market trends and growth opportunities
- Collected data from various sources using methods such as surveys, observations, and measurements to gain first-hand knowledge and original insights into research problems
- Analyzed third-party data and investigated new growth opportunities.
- Streamlined email marketing efforts for better open rates, click-through rates, and overall engagement.
- Implemented A/B testing methods to refine ad copy, design elements, and landing page content for optimal performance.
- Assessed KPIs to achieve in-depth understanding of campaign performance.
- Cleaned and prepared data for analysis by performing key data cleaning tasks, ensuring high-quality data for generating insights
Associate Business Analyst, Forecasting
Novartis
06.2019 - 07.2021
- Analyzed large and complex data sets to produce analytical solutions, including predictive modeling, optimization, and data visualization resulting in proper business understanding
- Conducted time series analysis to understand the data patterns and to predict future sales values with 89% accuracy
- Developed and maintained interactive QlikSense dashboards, utilizing data visualization techniques
- Automated data load processes using SQL queries, optimizing operations such as filtering, sorting, aggregating and data validation, resulting in increased efficiency and reduced manual intervention in data management tasks
- Presented key insights effectively with strong communication skills and a strategic approach Resulting in shared vision and alignment within the company
- Collaborated with internal teams to gain insights on existing dashboards, leveraging feedback for continuous improvement and optimization to enhance team performance and decision-making
- Developed, deployed, and maintained metrics and benchmarks, utilizing a strategic approach to review performance and key performance indicators (KPIs) for continuous improvement
- Developed interactive dashboards using Qliksense for different products and regions, utilizing SQL queries for data extraction and manipulation
- Developed both product and portfolio-level dashboards for Sandoz and Oncology divisions
- Collaborated with cross-functional teams to ensure the successful execution of crucial initiatives.
- Enhanced business processes by analyzing data and creating detailed reports for management review.
Education
Master of Science - Business Analytics
The University of Texas At Dallas
Richardson, TX05-2023
Master of Technology - Software Engineering
Vellore Institute of Technology
Chennai, India06-2020
Skills
- Data Visualization Expertise
- Data analysis
- Advanced Excel Functions
- SQL Data Analysis Expertise
- Data Quality Management
- Analytical problem solving
- Quantitative Analysis Skills
- Attention to detail
- Interactive Dashboard Development
- Experienced in R Programming
- Data Quality Assurance
- ETL Workflow Management
- Narrative Data Analysis
- Data mining
- Data mapping
- Reporting tools
- Data Analysis with SAS
- Software development life cycle (SDLC)
- Requirements Specification
- Predictive analytics
Certification
- Google Data Analytics Professional Certificate - Google.
Timeline
Data Analyst
Ivynova
07.2023 - Current
Marketing Analyst
Digital Savants
08.2022 - 05.2023
Associate Business Analyst, Forecasting
Novartis
06.2019 - 07.2021
Master of Science - Business Analytics
The University of Texas At Dallas
Master of Technology - Software Engineering
Vellore Institute of Technology
Similar Profiles
Aiman AbuawadAiman Abuawad
Online Sales Manager at SupremeLiquidationOnline Sales Manager at SupremeLiquidation
Kyle FiniganKyle Finigan
Caretaker at Family Member With Progressive DiseaseCaretaker at Family Member With Progressive Disease
Carlton MayiengaCarlton Mayienga
Crew Member at Raising Cane'sCrew Member at Raising Cane's
SHWETA PATWARDHANSHWETA PATWARDHAN
Talent Acquisition Specialist at GlobantTalent Acquisition Specialist at Globant
Manoj Singh RawatManoj Singh Rawat
Data Analyst/Data Migration Analyst at Sopra SteriaData Analyst/Data Migration Analyst at Sopra Steria