Data Analyst Power Bi

Dimple Varma Konduru

Data Analyst

+1-661-***-**** ******@*********.*** LinkedIn

SUMMARY

Data Analyst with around 3 years of experience in managing data and analyzing data to bring out the scope of improvements and content for decision-making. Experience in generating reports and dashboards by using Power Bi and Tableau to present data in an easier way to the stakeholders.

Handled large datasets along with the databases like MYSQL, Oracle, and Mongo DB. EDUCATION

Bachelor in Electrical and Electronics Engineering Sree Vidyanikethan Engineering College, India 04/2021 SKILLS

Methodology: SDLC, Agile, Waterfall

Language: SQL, Python, R

IDEs: Visual Studio Code, PyCharm

Packages: NumPy, Pandas, Matplotlib, Seaborn, SciPy, ggplot2, Plotly Visualization Tools: Tableau, Power BI

Cloud technologies: AWS, AWS S3, EC2, Azure

Databases: MYSQL, SQL Server, Oracle, Mongo DB

ETL & Other Tools: Hadoop, SSIS, Talend, Apache NiFi, SAP, SAS, CRM, Salesforce, Google Analytics Operating System: Windows, Linux

EXPERIENCE

Data Analyst, Cigna Healthcare USA 10/2022 – Present

Leveraged NumPy and Pandas for efficient data manipulation, and transformation, improving data processing speed by 40%.

Defined ETL mapping specifications and designed ETL processes to source data from various sources and load it into Data Warehouse tables, resulting in a 20% reduction in data loading time and a 15% improvement in data accuracy.

Wrote SQL queries for profiling and documenting metadata, as well as for extracting data from complex datasets, resulting in a 30% increase in data extraction efficiency and a 25% reduction in query execution time.

Employed Python and Power BI to clean, examine and automate dashboards involving every12 months of reporting data.

Utilized Power BI to create various analytical dashboards that helps business users to get quick insight of the data

Published & maintained workspaces in Power BI Service, allotted time refresh for data, maintained apps and workbooks.

Used DAX functions to create measure and calculated fields to analyze data for logical visualization and used Power Queries to transform the data.

Converted Boulder Tables from Excel to Power BI with better Graphs & visualizations for understanding of business.

Incorporated Azure Blob Storage to analyze datasets, increasing query efficiency by 30% & 20% reduction in data processing time.

Collaborated with stakeholders to define KPIs and automated dashboards, improving data reporting efficiency by 50%. Data Analyst, Hexaware Technologies India 04/2021 – 08/2022

Retrieved and analyzed data using Python, MS Excel, and SQL, connecting new data sources and supporting the leadership team with reports, resulting in a 20% increase in data accessibility.

Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis, resulting in a 30% increase in report accuracy.

Conceptualized AWS services such as Amazon S3 and Amazon Redshift for data storage, and analysis, optimizing data workflows and improving scalability for enhanced data-driven decision-making.

Developed, maintained, and mined a data warehouse, and build interactive dashboards by Tableau for executive management to support data analytics reducing data extraction costs by 40%.

Converted the Boulder Tables from Excel to Tableau with better Graphs and visualizations for the understanding and improvement of business.

Experience in converting Legacy Reports to Tableau dashboards connecting to SQL server.

Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server.

Implemented ETL processes using tools such as SSIS and Talend Open Studio to extract transform and load data into databases, providing technical solutions to business stakeholders.

Contact this candidate