Data Analyst Power Bi

Summary

Vishwas Chepyala

vishwas.chepyala**@gmail 225-***-**** LinkedIn

Results-driven Data Analyst with 4+ years of experience in leveraging advanced analytics tools and techniques to uncover valuable insights and drive data-driven decision-making. Proven expertise in extracting, transforming, and analyzing large datasets, developing interactive visualizations, and communicating complex findings effectively. Adept in Python, SQL, PowerBI, and cloud computing (AWS) with a demonstrated ability to optimize processes and deliver quantifiable results, including a 40% reduction in redundant tasks and a 30% improvement in manufacturing operations efficiency.

Professional Experience

Eurofins Lancaster Laboratories Professional Scientific Services, LLC

Technical PowerBI Business Analyst

Jan 2024 – April 2024 Rensselaer, NY

Spearheaded the integration of manufacturing operations data from multiple sources into Power BI Desktop, enabling comprehensive data visualization and analysis, resulting in a 25% faster data-driven decision-making process.

Developed custom visualizations using R-Programming Language, enhancing report interactivity and storytelling capabilities, leading to a 30% improvement in stakeholder engagement and understanding.

Architected and implemented automated data flows and analytics pipelines using SQL, Python, and Power BI, streamlining data visualization processes and optimizing manufacturing operations by 30%.

Pioneered the creation and maintenance of complex data visualization dashboards, providing comprehensive insights and supporting data- driven strategies that drove a 20% increase in operational efficiency.

Championed automated solutions, reducing redundant tasks by 40% and significantly enhancing operational efficiency.

Ensured strict adherence to Standard Operating Procedures (SOPs), promptly reporting any deviations or quality issues, maintaining 100% compliance and data integrity.

Amerisource Bergen

Data Analyst

Feb 2022 – Jan 2024 Los Angeles, CA

Leveraged Python to conduct in-depth analysis of business requirements and generate ad-hoc reports based on customer requests, streamlining data delivery by 20% and improving customer satisfaction.

Developed customized reports in Power BI, enabling seamless data access and analysis, resulting in a 15% reduction in report generation time. Employed Tableau and Excel to create weekly and daily reports, providing stakeholders with timely and actionable insights into operational performance, contributing to a 10% increase in data-driven decision-making.

Designed and maintained comprehensive data analysis reports, dashboards, and visualizations using SQL, Python, and R, delivering valuable insights into healthcare trends, patient outcomes, and operational efficiency, driving a 25% improvement in data-driven initiatives.

Conducted data validation and quality assurance checks, ensuring the accuracy and integrity of healthcare datasets, resulting in a 15% reduction in data-related errors and improved decision-making confidence.

Ensured strict compliance with healthcare regulations and privacy standards, such as HIPAA, safeguarding sensitive data and mitigating risk, maintaining a 100% compliance record.

Amazon – Alexa Data Services

ML Data Associate - 1

Apr 2017 – Jun 2019 Hyderabad, India

Leveraged Python and libraries such as SciPy, NumPy, and Pandas to analyze, profile, and assess data for accuracy and quality, resulting in a 20% improvement in data quality and reliability.

Customized reports using Power BI to meet specific business requirements, enhancing data-driven decision-making capabilities and stakeholder satisfaction by 30%.

Executed complex SQL queries on various source systems, including SQL Server, to conduct data analysis and profiling, enabling efficient data exploration and insights discovery.

Employed data mining techniques to uncover patterns, relationships, and anomalies in large datasets, contributing to improved business decision-making and a 15% increase in operational efficiency.

Collaborated with stakeholders to define key performance indicators (KPIs) and develop dashboards and reports to track and monitor business metrics, facilitating data-driven performance management and a 25% improvement in KPI achievement.

Wrote T-SQL cursors, SQL joins, and stored procedures to generate database migration scripts, ensuring seamless data migration and minimizing downtime.

Migrated ETL objects from development to production and maintained ETL environments, ensuring a 99.9% uptime and reliable data integration processes.

Performed data cleaning, feature scaling, and feature engineering using Pandas and NumPy packages in Python, and built models using deep learning frameworks, improving model accuracy by 12%.

Skills

Programming Languages & Libraries: Python (NumPy, Pandas, Matplotlib, SciPy), R (ggplot2), SQL (T-SQL, PL/SQL)

Data Visualization & Business Intelligence Tools: Tableau, Power BI, Alteryx, Microsoft Excel (VLookup, Macros) SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)

Databases & Data Warehousing: Microsoft SQL Server, PostgreSQL, MongoDB, Snowflake, Amazon Redshift

Cloud Services: Amazon Web Services (AWS) - EC2, S3, Lambda, CloudWatch

Data Techniques & Methodologies: Data Cleaning & Wrangling, Data Modeling, ETL (Informatica Talend), Data Mining, Agile, Scrum and Waterfall Methodologies

Education

Master of Science: Computer Science

Southern University And A&M College - Baton Rouge, LA

Bachelor of Engineering: Mechanical Engineering

GITAM University - India

Contact this candidate