Data Analyst Power Bi

SRINIVAS GUNJI

DATA ANALYST

551-***-**** ****************@*****.***

PROFESSIONAL SUMMARY

Results-driven Data Analyst with 4+ years of experience in data visualization, business intelligence, statistical analysis, and predictive modeling. Proficient in SQL, Python, R, Tableau, Power BI, and ETL processes to extract insights, drive decision-making, and optimize business performance. Hands-on experience in cloud platforms (AWS, Azure, GCP) and working with large-scale datasets in financial, banking, and insurance sectors. Adept at collaborating with cross-functional teams to improve operational efficiency and implement data governance best practices. TECH SKILLS

Programming Languages: SQL, PL/SQL, HTML5, C++, Java, XML and HTML.

Database: Microsoft SQL Server Management Studio (SSMS), PostgreSQL, MySQL, Oracle 12c/11g, PowerShell, Teradata.

Datawarehouse/ETL: Microsoft SQL Server Integration Services (SSIS)

Data Analysis and Manipulation: Microsoft Excel, Google Collaboratory, Jupiter Notebook, Data Modelling, Data Mining.

Other Tools: Workday, Canva, Microsoft Vision, Qualtrics, Microsoft PowerPoint, Microsoft Office, Git.

Methodologies: System Development Life Cycle (SDLC), Agile, Waterfall Model.

Operating System: Windows, OS, Unix, Sun Solaris. EDUCATION

Masters in Data Science

Saint Peters University, New Jersey, NJ

Bachelors of Technology in Computer Science & Engineering Bharath Institute of Higher Education & Research, India WORK HISTORY

Data Analyst McKesson Irving TX Mar 2024 – Present

Designing and implementing data pipelines for healthcare analytics, ensuring HIPAA compliance.

Developing interactive dashboards using Power BI/Tableau to monitor pharmaceutical supply chain metrics.

Performing data cleansing and transformation using SQL and Python to improve data accuracy by 30%.

Conducting predictive analytics on patient data to enhance operational efficiency and reduce costs.

Collaborating with cross-functional teams to optimize data governance policies and ensure regulatory adherence.

Extracting, transforming, and analyzing large datasets using SQL, Python, and R to generate actionable insights.

Built ETL pipelines and automated reporting solutions to streamline data processing workflows.

Utilizing statistical techniques and machine learning models to identify trends and improve decision- making.

Creating interactive dashboards and reports using Tableau, Power BI, and Looker for executive stakeholders.

Working closely with business stakeholders to define KPIs and provide data-driven recommendations.

Involving in writing, testing, and implementing triggers, stored procedures and functions at Database level using PL/SQL

Data Analyst Qualcomm Iselin, NJ Mar 2023 – Mar 2024

Designed logical and physical data models for various data sources on AWS Redshift.

Performed data analysis, unit testing, integration testing, performance testing, and UAT for business reports/dashboards in QA, Dev, and Production.

Developed Tableau dashboards using AWS Redshift, Smartsheet, Oracle DB, text files, and Excel as data sources.

Created and maintained analytics reports, ad-hoc reports, interactive dashboards via iBots, MS-Excel, and root cause analysis.

Built Power BI reports and dashboards by connecting to Azure Databricks, Oracle General Ledger, SQL Server, Excel, and text files.

Analyzed and formatted data using Machine Learning algorithms in Python.

Deployed data dictionary, data mapping for ETL, application support, DFD, ERD, metadata, DDL, and DML.

Extracted data using SQL, performed data analysis, created/modifed scoring reports, and conducted gap analysis for system improvements.

Built ETL pipelines for data extraction, transformation, and loading into analytic databases using Apache Airflow for automation.

Data Analyst HFCL India July 2021 – Aug 2022

Created reporting dashboards and performed data mining & analysis to understand customer purchase behavior.

Analyzed business requirements and developed functional, implementable technical data solutions.

Developed and maintained a data dictionary to generate metadata reports for technical and business purposes.

Designed long-term data warehouse roadmaps, architectures, and frameworks for scalable solutions.

Wrote, tested, and implemented PL/SQL triggers, stored procedures, and functions at the database level.

Participated in JAD sessions, gathered requirements from Business Analysts, end users, and stakeholders.

Provided technical leadership on ETL design and development best practices for the team.

Refined SQL stored procedures to automate manual tasks, reducing report processing time by 40 hours.

Managed data storage and processing using Big Data tools like Hadoop, HDFS, Hive, and Spark.

Analyzed large-scale user log data and generated features for classification models using SparkSQL. Technical Data Analyst BT Group India May 2020 – Jun 2021

Maintained and published business reports/dashboard standardization on Confluence, SharePoint, and Box.

Refined SQL stored procedures to automate manual tasks, reducing report processing time by 40 hours.

Used ETL tool SSIS to extract data from CSV, JSON, Excel, and internal/external sources into databases.

Collected and cleaned data from MySQL for aggregation, reporting, and further analysis.

Gathered business requirements and translated them into technical insights as per business needs.

Automated data extraction using Excel VBA, integrating with Tableau for reports and dashboards.

Reviewed SQL logic, designed Tableau dashboards, and performed data validation.

Used Excel, Python, and PowerPoint to present insights, with 60% of recommendations implemented.

Analyzed large datasets targeting high-value consumers using Google Collaboratory (Python Notebook), saving 4 hours of processing time.

Monitored email delivery statistics and optimized efficiency to increase customer engagement.

Contact this candidate