← Back to list
middle
Registration: 06.02.2025

Sriram Rathikota

Skills

Agile
AWS
Azure
Critical Thinking
Data Cleaning
Data Modeling
Data Wrangling
DecisionMaking
ELT Process
ERP Process
GCP
Google Colab
Google Sheets
Information Management
Jira
Jupiter Notebook
Linux
Microsoft Excel
MongoDB
MySQL
Oracle
Power BI
Presentation Skills
Problem-solving
PyCharm
Python
R
SAS
SDLC
SQL Server
Tableau
Visual Studio Code
Waterfall
Windows

Work experience

Data Analyst
since 02.2024 - Till the present day |Capital One
N/A
• Implementing Agile Methodology for building an internal application. • Perform data manipulation, development, and validation of data models using R, and SQL. • Using packages like ggplot2 in R Studio for data visualization and generated scatter plots and high-low graphs to identify relations between different variables. • Automate month-end contract value spreadsheet also making it more robust in the process. • Initiated and designed dashboards locally before publishing to Tableau Server for data visualization, statistical trend analysis & KPI evaluation. • Developed and optimized MySQL functions, triggers, views, and stored procedures to streamline database operations, improve query performance, and ensure data integrity. • Conducted data analysis and trend interpretation for developing statistical process control methods in support of aviation information and readiness reporting requirements. • Developed internal systems with VBA and automation, fully incorporating and integrating the Microsoft Office and Windows environments. • Performed data extraction, data transformation and load processes on call center data to evaluate customer eligibility and create retention standards.
Data Analyst
01.2019 - 07.2022 |Groovy Web
N/A
• Used the Waterfall methodology to build the different phases of the Software development life cycle. • Developed SAS program to auto generate PDF school specific reports for educational facilities participating in the vaccination assessment. • Created SQL queries and reports to support inventory control and improve sales profitability. • Worked on data cleaning and reshaping, generated segmented subsets using NumPy, Pandas, Matplotlib, and SciPy in Python. • Utilized Power BI (Power View) to create various analytical dashboards that depict critical KPIs, and multiple scorecards along with slicers and dicers enabling end-user to make filters. • Performed slicing and dicing of data using SQL and MS Excel for data cleaning and data preparation. • Gathered and consolidated data from diverse data sources into a uniform Business Intelligence SQL Server data warehouse. • Conducted data quality investigations and made necessary improvements, in response to operational assessments, self-driven investigations, and customer inquiries. • Partnered with customers that provided Verizon with a low customer service rating to identify center and organizational opportunities. • Maintained strong analytical and problem-solving skills, excellent communication and presentation skills.

Educational background

Advanced Data Analytics (Masters Degree)
2022 - 2024
University of North Texas
Electronics and Communication Engineering (Bachelor’s Degree)
2016 - 2020
Saveetha Engineering College, Chennai, India

Languages

EnglishProficient