Sowmya Ravula
Summary
Experienced in data analysis and interpretation with skills in SQL and Excel. Strong understanding of teamwork dynamics enables seamless adaptation to evolving analytical challenges. Proven track record in data management and reporting, well-equipped to contribute to any organization's success in driving data-informed decision-making.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Analyst,
Celonis
10.2024 - 12.2024
- Analyzed non-conforming cases in production and prepaid travel cost, identifying inefficiencies and bottlenecks.
- Discovered lack of standardization in production process with 607 common variants among cases.
- Highlighted operational impact of deviations, emphasizing the need for a more streamlined approach.
- Discovered that the production process had 607 common variants among 1.05K cases, with the most common variant representing only 10% of the cases. This lack of standardization indicates the need for a more streamlined approach.
- Identified key finding of the extended throughput times. In production, the average case took 94 days, with many clustering between 90-120 days and some exceeding 180 days. Prepaid travel cost cases showed similar inefficiencies, averaging 32 days to complete. These bottlenecks represent clear opportunities for process optimization.
Data Analyst Intern
My Yoga Network
06.2024 - 08.2024
- Built and maintained a comprehensive Power BI dashboard for company analytics, providing actionable insights to support business decisions.
- Designed and implemented dynamic Power BI dashboards across multiple company websites, achieving a 53.28% improvement in overall performance, including efficient querying and data transformation within Power BI
- Optimized web data extraction from PubMed and other publicly available sources, resulting in a 96.07% increase in efficiency for data scraping processes
- Contributed to the development of a sentiment analysis algorithm, which now operates 62.7% faster and boasts an accuracy increase from 4.88% to 77.42% , significantly improving both processing speed and precision. Enhanced user comprehension by integrating interactive visualizations
- Collaborated directly with the CEO to integrate feedback, to ensuring the dashboard met both technical and business needs
- Engaged in presentations, weekly meetings and interacted the insights to make the project successful.
HR Intern
WEST Solutions
07.2021 - 09.2021
- Participated in job posting and candidate outreach
- Maintained and updated employee records and HR databases
- Contributed to the research and development of HR policies
- Gathered and analyzed HR data for reporting purposes
- Worked with HR software to ensure accurate data management
Education
Master of Science - Business Analytics
Montclair State University
Montclair, NJ12-2024
BBA - Human Resources Management
David Memorial Degree & PG College
Hyderabad, India08-2022
Skills
- Programming Languages : Python
- Tools : Power BI, Tableau, Google Analytics, Databricks, Microsoft Excel, Signavio, Celonis, MySQL
- Skills : Data Wrangling, Data Mining, Database Management Systems, Web Scraping, Optimization in Business Problems, Data Visualization, Process Mining, Business Process
- Libraries : Pandas, Numpy, Beautifulsoup, Seaborn, PySpark, Statsmodel, Pyomo, Ipython, Scipy, Sklearn, Requests
- Interpersonal Skills : Communication, Conflict Resolution, Adaptability, Networking, Problem-solving, Team Building
Certification
- Generative AI - Databricks
- Lakehouse - Databricks
- Microsoft Azure - Generative AI Fundamentals
LANGUAGES
English
Native or Bilingual
Telugu
Native or Bilingual
Hindi
Professional Working
Timeline
Analyst,
Celonis
10.2024 - 12.2024
Data Analyst Intern
My Yoga Network
06.2024 - 08.2024
HR Intern
WEST Solutions
07.2021 - 09.2021
- Generative AI - Databricks
- Lakehouse - Databricks
- Microsoft Azure - Generative AI Fundamentals
Master of Science - Business Analytics
Montclair State University
BBA - Human Resources Management
David Memorial Degree & PG College
Similar Profiles
William CaseyWilliam Casey
Principal Talent Acquisition Partner - GTM at CelonisPrincipal Talent Acquisition Partner - GTM at Celonis
Humberto Becerra Humberto Becerra null
CX Researcher at CelonisCX Researcher at Celonis
Deepali MishraDeepali Mishra
FRONTEND DEVELOPER at CelonisFRONTEND DEVELOPER at Celonis