Kavya Chowdary
Frisco,TX
Summary
Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Sr.Data Analyst
United Health Group, Optum
01.2022 - Current
- Use of statistical software, primarily SAS programming and R, to organize, manipulate, clean, and analyze data
- Knowledge of Software Development Life Cycle (SDLC) and various methodologies such as Agile and Waterfall
- Loading the data into database tables into the development environment to test the report functionality
- Good at the using Cross tables, Charts (Pie Chart, Tree Map, Heat Map, Bar Chart, Line Chart), Calculated Columns
- Also involved in converting the Tableau and Business Objects reports to Dashboards
- Implemented numerous SQL queries like joins, views, synonyms, functions for business requirements
- Worked across marketing and product business units to build out the reporting infrastructure in Tableau
- Automated reports with Stored Procedures and SQL JOBS
- Utilized Python and Pandas to clean, preprocess, and analyze large datasets from various sources, identifying patterns and trends to inform business decisions
- Implemented parallel processing and distributed computing using Dask to handle big data and optimize data processing workflows
- Generated descriptive statistics and conducted exploratory data analysis using Pandas to gain insights into dataset characteristics and distributions
- Skilled in implementing rigorous testing methodologies and quality assurance protocols to validate data analysis pipelines, ensuring consistency and correctness across diverse datasets and analytical models
- Experienced in designing and executing systematic testing procedures to identify and resolve discrepancies, anomalies, and data inconsistencies, enhancing the reliability and trustworthiness of analytical insights.
Sr.Data Analyst
Curriculum Associates
06.2019 - 08.2021
- Developed C# scripts and applications to process and transform raw data into meaningful insights
- Providing the different set of filters that the users can limit the data and can interact with the visualizations and see the performance of the business
- Developed dashboards in Tableau Desktop and published them in Tableau Server
- Developed, built, and implemented scalable data models, interpreted, and enable advance analytics capabilities through data visualization using SQL and Power BI
- Used Tableau to carry out data visualization and provide meaningful insight into business data
- Supported application development teams in development of data requirements by identifying and creating well defined data elements and analyzing data models
- Identify problems and provide solutions to business problems using data processing, data visualization and graphical data analysis
- Involved in file movements between HDFS and AWS S3 and extensively worked with S3 bucket in AWS
- Leveraged Polars for high-performance data operations, speeding up data manipulation tasks and reducing processing times
- Strong proficiency in R programming language for data analysis, statistical modeling, and visualization, adept at manipulating and transforming data to extract meaningful insights and patterns
- Experienced in managing code repositories on GIT/Bitbucket, including branching, merging, and resolving conflicts, to maintain a structured and organized development workflow
- Skilled in documenting and maintaining comprehensive commit histories on GIT/Bitbucket, providing transparency and traceability throughout the development lifecycle of analytical solutions.
Data Analyst
Walmart
08.2018 - 05.2019
- Involved in ETL operations using Python, SQL, and Excel to help data scientists build machine learning models to improve ROI
- Worked on views and structured and efficient queries on large data sets using multi-type table joins, multiple keys, and nested queries
- Worked on feature extraction and in creating new features using Pandas
- Worked with marketing and product business units to build out the reporting dashboards with Tableau
- Used SQL, PL/SQL to validate the Data going into the Data warehouse
- Used Tableau for data visualization and presented the analysis reports to the concerned departments
- Coordinated and communicated with technical and business teams for any data requirements
- Analyzed the data by Exploratory Data Analysis (EDA), worked on missing values
- Participated in the sprint meeting, daily stand-ups, sprint review and sprint retrospective meetings
- Helped the product owner in writing the acceptance criteria for the technical user stories
- Involved in multiple usage of analytical and visualization tools to extract and clean data, to form predictive models and to visualize using multiple visualization tools before clients
- Worked daily on data checking routine, conducted data extraction, aggregating, manipulation and statistical analysis from large data sets by using database tools such as SQL
- Involved in retailer sales data reporting process end-to-end and ensure weekly and monthly reporting accuracy with SQL and Excel
- Strong understanding of data validation techniques and statistical analysis methods, enabling the identification and mitigation of data quality issues through rigorous testing and validation procedures
- Actively contribute to the enhancement of testing documentation and methodologies, leveraging insights from testing outcomes to drive improvements in data acquisition, processing, and analysis workflows
- Proficient in conducting user acceptance testing (UAT) and stakeholder validation sessions to gather feedback and insights, ensuring alignment with business requirements and objectives in data analysis projects
- Skilled in using programming languages such as Python or R for data wrangling, statistical modeling, and machine learning tasks, enabling advanced data analysis and predictive modeling.
Education
Bachelor of Technology - Computer and information systems
JNTUK
Masters - Computer science
Sacred Heart Univeristy
12.2022
Skills
- Agile (SAFe, Scrum), Waterfall (Traditional)
- Tabluea, Power BI, MS Visual Studio
- MS Visio, Lucid Chart
- SSIS, Informatica, Power Center
- Python,R,AWS
- XML, JSON, HTML, SOAP, RESTful
- SQL, MYSQL, ORACLE
- GIT,BITBUCKET
Certification
- Databases and SQL for Data Science (IBM)
- Python for Datascience (IBM)
- RDMS(IBM)
- Data Analytics(IBM)
Timeline
Sr.Data Analyst
United Health Group, Optum
01.2022 - Current
Sr.Data Analyst
Curriculum Associates
06.2019 - 08.2021
Data Analyst
Walmart
08.2018 - 05.2019
Bachelor of Technology - Computer and information systems
JNTUK
Masters - Computer science
Sacred Heart Univeristy
Similar Profiles
Susan GabbardSusan Gabbard
Family Nurse Practitioner at United Health Group - Optum HealthFamily Nurse Practitioner at United Health Group - Optum Health
Monica C. ChappellMonica C. Chappell
Manager Case Management, Care & Disease Management Ops External Channel at United Health Group/Optum HealthManager Case Management, Care & Disease Management Ops External Channel at United Health Group/Optum Health
Celina AitonCelina Aiton
Assoc Tech Support Analyst at United Health Group - Optum HealthAssoc Tech Support Analyst at United Health Group - Optum Health
Daniel SuttonDaniel Sutton
Senior Sonographer at United Health Group/ Optum HealthSenior Sonographer at United Health Group/ Optum Health
James SummerallJames Summerall
Senior Technology Manager at Dallas Area Rapid Transit (DART)Senior Technology Manager at Dallas Area Rapid Transit (DART)