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
INDIA
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