← Back to list
middle
Registration: 06.02.2025

Sriram Rathikota

Specialization: Data Analyst
— 4+ years of hands-on experience as a Data Analyst, specializing in Data Modeling, Data Warehousing, and Reporting, with a strong background in Application Design and Development. — Proficient in the Software Development Life Cycle (SDLC), with practical experience in both Waterfall and Agile methodologies, ensuring timely and efficient project delivery. — Skilled in using core Python libraries such as NumPy, Pandas, SciPy, Matplotlib, and ggplot2 to manipulate data, perform statistical analysis, and generate insightful visualizations. — Adept at Text Analytics and proficient in creating interactive data visualizations and dashboards using tools like Power BI, Tableau, and Python for actionable insights and decision-making support. — Expert in SQL with hands-on experience in various RDBMS platforms, including MySQL and SQL Server, for developing complex queries, ensuring data integrity, and optimizing database performance. — Strong data cleaning and problem-solving abilities, with a proven track record of effectively addressing data quality issues and optimizing workflows in both team-based and individual settings.
— 4+ years of hands-on experience as a Data Analyst, specializing in Data Modeling, Data Warehousing, and Reporting, with a strong background in Application Design and Development. — Proficient in the Software Development Life Cycle (SDLC), with practical experience in both Waterfall and Agile methodologies, ensuring timely and efficient project delivery. — Skilled in using core Python libraries such as NumPy, Pandas, SciPy, Matplotlib, and ggplot2 to manipulate data, perform statistical analysis, and generate insightful visualizations. — Adept at Text Analytics and proficient in creating interactive data visualizations and dashboards using tools like Power BI, Tableau, and Python for actionable insights and decision-making support. — Expert in SQL with hands-on experience in various RDBMS platforms, including MySQL and SQL Server, for developing complex queries, ensuring data integrity, and optimizing database performance. — Strong data cleaning and problem-solving abilities, with a proven track record of effectively addressing data quality issues and optimizing workflows in both team-based and individual settings.

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
MySQL, R, SQL, Agile
● 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
SQL Server, MS Excel, NumPy, Pandas, Matplotlib, SciPy, Python, Power BI
● 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 / Communication Engineering (Bachelor’s Degree)
2016 - 2020
Saveetha Engineering College

Languages

EnglishProficient