SRAVYA KODALI
Saint Louis,MI
Summary
To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.
Overview
6
6
years of professional experience
6
6
years of post-secondary education
Work History
Business Intelligence Analyst II
Charter Communications
St.Louis, MO
11.2021 - Current
- Advised senior executives and was lead SME on products associated with internet providing services and created necessary documentation and developed tableau reports to track product health, findings helped in reducing errors returned
- Leaded major effort in presenting solution to senior executives for better product improvement
- Developed tableau/splunk reports which helped in identifying the root cause of high volumes of errors and reduced error rate by 24%.
- Developed monthly ad hoc Splunk reports to track changes made in prod environment
- Developed tableau dashboards to monitor product health using various analysis like YoY
- Mentored onboarding team members by providing necessary training
- Held weekly tableau informative sessions to support various cross functional teams.
Business Intelligence Analyst
Equifax Workforce Solutions
St. Louis, MO
01.2020 - 10.2021
- Developed tableau dashboard to track the impact of price increase on transaction volume and revenue generated which helped in increasing the revenue by 30%
- Architected ways to monitor the usage of new products by customers in combination without losing customers using existing products
- Collaborated in migration of data sources from SQL server to the GCP platform using Python scripts, GitHub, Airflow (ETL tool), and Google BigQuery to ensure efficient data processing
- Building strong work relationships with cross-functional teams and training business teams to use latest visualization platforms like Tableau
- Work in an agile team environment to deliver the development tasks/user stories on time
- Developed ad-hoc reports to help functional departments and executives keep pulse on their areas of business using real-time Key Performance Indicator (KPI) reports
- Implemented key metrics like Sales Velocity on the Salesforce data which helped sales leaders in determining the delays occurring in the sales cycle and better equip their sales reps which helped in increasing the number of deals closed per year by 23%
- Create views and scripts using Google BigQuery SQL and work with different types of big data file loads (Txt, CSV, Parquet) to process the files from cloud storage buckets and load them into raw tables in GCP
Business Intelligence Analyst Intern
Equifax Workforce Solutions
St. Louis, MO
05.2019 - 08.2019
- Experienced in direct interaction and requirements gathering with the cross-functional business teams
- Created a forecast model using Machine Learning algorithms SARIMA and XGBoost to forecast transactions and revenue generated for a huge line of products
- Implemented data integration to create a unified view to use for reporting purposes
Graduate Teaching Assistant
Mississippi State University
01.2018 - 01.2019
- Assisted 25 students in creating data models and developing e-commerce platform designs
- Involved in explaining key concepts of various courses for bachelor’s students
Data Analyst Intern
Crayon Data PVT Ltd
05.2017 - 08.2017
- Undertaken Data Curation projects
- Data Collection and Data Analyzing using MySQL
- Worked with Data engineers in data validation and documentation on curated data
Education
Master of Science - Computer Science
Mississippi State University
Starkville, MS 01.2018 - 12.2019
Bachelor of Technology - Information Technology
Sathyabama University
India 01.2013 - 01.2017
Skills
Python
Data Analytics Experience: Tableau, SQL Server,SPLUNK, GCP, Airflow, Jenkins, R studio, SSIS Operating Systems: UNIX, WindowsScripting: JavaScript, PHP, Html, Java Server PageVisualization : Tableau, Power BI
SQL Server
Splunk
Accomplishments
- Collaborated with team of 6 in the migration of multiple databases like data warehouse from on-premise into GCP platform
- Built a website specific to the team which was helpful in keep tracking of the requirements team receive on a daily basis.
- Automated data load process using Python scripts
- Implemented Machine Learning to forecast the revenue generated every month and helped increasing the product usage by mitigating possible upcoming errors.
Timeline
Business Intelligence Analyst II
Charter Communications
11.2021 - Current
Business Intelligence Analyst
Equifax Workforce Solutions
01.2020 - 10.2021
Business Intelligence Analyst Intern
Equifax Workforce Solutions
05.2019 - 08.2019
Graduate Teaching Assistant
Mississippi State University
01.2018 - 01.2019
Master of Science - Computer Science
Mississippi State University
01.2018 - 12.2019
Data Analyst Intern
Crayon Data PVT Ltd
05.2017 - 08.2017
Bachelor of Technology - Information Technology
Sathyabama University
01.2013 - 01.2017