VISHWAS CHEPYALA

ady8l9@r.postjobfree.com +1-225-***-**** BatonRouge, LA

PROFESSIONAL SUMMARY

3+ years of experience as a Data Analyst with a good understanding of Data Modeling,Evaluating Data Sources, and understanding of Data Warehouse/Data Mart Design,and Client/Server applications.

Understanding of Python best Practices and also aware of its packages for Pandas,NumPy and Matplotlib.

Experience in industry as programmer analyst using Python, SQL, MySQL and PowerBI to design, develop and enhance system operation metric.

Leveraged advanced analytics tools, including SQL, Python, and Tableau, to extract, transform, and analyze large datasets.

Developed interactive visualizations and reports to communicate complex findings and facilitate data-driven decision-making processes.

Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended.

Capable of Text Analytics, generating data visualizations using Python, and creating dashboards using tools such as Tableau, Power BI, and MS Excel.

Orchestrated, scheduled, monitored using Cloud Watch and used python shell for external integration of multiple services in AWS.

Excellent communication, interpersonal and analytical skills and a highly-motivated team player with the ability to work independently.

SKILLS

Methodologies: SDLC, Agile, Waterfall

Language: Python, R, SQL, T-SQL, PL/SQL

IDEs: Visual Studio Code, PyCharm

Packages: NumPy, Pandas, Matplotlib, SciPy, ggplot2

ETL: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis

Service (SSAS)

Visualization Tools: Tableau, Power BI,Microsoft Excel

Database: MS SQL Server, PostgreSQL, MongoDB

Other Skills: Data Cleaning, Data Wrangling, Critical Thinking, Communication Skills, Presentation Skills, Problem-Solving

Cloud Services: AWS (Amazon Web Services)

Operating System: Windows, Linux

EDUCATION

Southern University And A&M College - Baton Rouge, LA 05/2021 Master of Science: Computer Science

Gitam University - India 04/2017

Bachelor of Engineering: Mechanical Engineering

WORK HISTORY

Data Analyst Amerisource Bergen - USA 02/2022 - Current

Worked with Python to analyze business requirements and generate ad-hoc reports based on customer requests.

Created customized reports pointing to the reporting servers per the business request using Power BI.

Developed weekly and daily reports on Tableau and exported them to Excel and Access

Developed and maintained comprehensive data analysis reports, dashboards, and visualizations to provide insights into healthcare trends, patient outcomes, and operational efficiency. Utilized tools such as SQL, Python, or R to extract, clean, and analyze large healthcare datasets.

Prepared ETL Log Reports and ETL Audit Reports in SQL Server Reporting Services(SSRS)for a project manager to check run status of ETL packages such as ETL name, dataflow type, start time, finish time, status and error message.

Conducted data validation and quality assurance checks to ensure accuracy and integrity of healthcare datasets.

Ensured compliance with healthcare regulations and privacy standards, such as HIPAA.

Collecting and iteratively refining specifications from management to augment current pivot table reporting with high-quality dashboard visualizations in Excel.

Creating various types of data visualizations using R, Python, and Tableau.

Performing data analysis and maintenance on information stored in MySQL database.

Designed data models for optimized storage and retrieval, and created visualizations and dashboards using Tableau.

Jr. Data Analyst Technology Networks - India 04/2017 - 06/2019

Followed the Waterfall methodology for development lifecycle including Requirements, Planning, Design, and Deployment stages.

Analyzed, profiled, and assessed data for accuracy and quality using Python and popular libraries such as SciPy, NumPy, and Pandas.

Customized reports using Power BI to meet the specific requirements of the business.

Conducted data analysis and profiling by executing complex SQL queries on various source systems including SQL Server.

Employed data mining techniques to discover patterns, relationships, and anomalies in large datasets, contributing to improved business decision-making.

Collaborated with stakeholders to define key performance indicators (KPIs) and develop dashboards and reports to track and monitor business metrics.

Wrote T-SQL cursors, SQL joins, and stored procedures to generate database migration scripts.

Migrated ETL objects from development to production and maintained ETL environments.

Performed data cleaning, feature scaling, and feature engineering using Pandas and NumPy packages in Python, and built models using deep learning frameworks.