Data Analyst Power Bi

Harika VD

********.***@*****.*** +1-270-***-**** Nashville, TN

https://www.linkedin.com/in/harika-vd-0514b0328/

PROFILE

• Data analyst with hand-on experience in the Analysis, design, development, testing & implementation of ETL and Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, SQL SERVER, MSBI, and Power BI experienced in Extraction, Transformation, and Loading (ETL) processes using MS-SSIS and DTS application tools, experience in Data Warehousing implementation using SQL SERVER Integration Services

(SSIS), SQL SERVER Reporting Services (SSRS), /Power BI, Tableau. SKILLS

Languages: SQL, MY SQL Databases: MySQL, PostgreSQL, MongoDB Programming Languages: Python

(NumPy, Pandas, Scikit Learn) Data Modelling Techniques: Star Schema, Snowflake Schema Data Processing: ETL Processes, Big Data Technologies. Data Management: Data Warehousing, Data Cleaning Cloud Platforms: AWS, Azure, Google Cloud

PROFESSIONAL EXPERIENCE

Data Analyst -Abbott, United States July 2024 – Present

• Designed and optimized ETL workflows to integrate and process over 2TB of data daily, which significantly improved data flow efficiency.

• Gather data using SQL queries to interpret datasets for decision-making on a daily, weekly, monthly, quarterly and annual basis.

• Provide data analyses and coordinate teh development of reports for teh Engineering Department for continual operational improvements

• Use MS Excel's various functions such as Pivot tables, VLOOKUP, Concatenate, transpose, etc. to perform extensive data manipulation on teh raw data, helped in a better, clean dataset to work with.

• O Perform Data cleaning, Data analysis using R and Data visualization using Looker, helped in improving effective decision making.

• Develop dashboards in Looker to visualize teh suspicious patterns/activities in real time for business users.

• O Implement topic modeling using LDA to predict teh product category of feedback and detect specific issues in each category by analyzing teh feedback collected from customer service.

• Perform sentiment analysis on customer feedback after every release.

• Create and presented executive dashboards and scorecards to show teh trends in teh data using Excel and VBA- Macros.

• Work on multiple datasets alone from data cleaning to data visualization.

• Create and maintain rich interactive visualizations through data interpretation and analysis integrating various reporting components from multiple data sources

• Environment: MySQL, Hyperion, Looker, Oasis, JIRA, Microsoft Office Suit (Word, Excel, PowerPoint, Outlook)

• Skills: SQL, Python, ETL, Snowflake, Data Warehousing, Power BI, Microsoft Excel Data Engineer Intern -Murray State University, Murray. January 2024 – May 2024 Skills: SQL, Python, ETL, Snowflake, Data Warehousing, Power BI, Microsoft Excel

• Designed and optimized ETL workflows to integrate and process over 2TB of data daily, which significantly improved data flow efficiency.

• Utilized SQL and Snowflake to manage and optimize data storage, ensuring seamless integration of diverse data sources and maintaining high data quality.

• Developed interactive dashboards and reports using Power BI and Microsoft Excel, providing actionable insights into web traffic, sales trends, and inventory performance.

• Automated data extraction and reporting tasks with Python, reducing data retrieval times by 85% and allowing team members to focus on high-value analysis tasks.

• Managed and processed a substantial volume of diverse data, leading to an estimated $30,000 in annual savings through enhanced data integration and performance improvements. Data Analyst - Accenture, India June 2018 – June2022 Skills: SQL, ETL, Data Warehousing, Power BI, Microsoft Excel

• Designed and optimized ETL workflows to integrate and process over 2TB of data daily, which significantly improved data flow efficiency.

• Utilized SQL and Snowflake to manage and optimize data storage, ensuring seamless integration of diverse data sources and maintaining high data quality.

• Developed interactive dashboards and reports using Power BI and Microsoft Excel, providing actionable insights into web traffic, sales trends, and inventory performance.

• Automated data extraction and reporting tasks with Python, reducing data retrieval times by 85% and allowing team members to focus on high-value analysis tasks.

• Managed and processed a substantial volume of diverse data, leading to an estimated $30,000 in annual savings through enhanced data integration and performance improvements. PROJECTS

• Course management and Scheduling Application August 2023-Decemeber 2023

• Developed a Python-based application that allows users to view course details, build a conflict-free schedule for students, and generate teaching schedules for instructors. The application will read course data from a file and provide an intuitive interface for data retrieval and scheduling.

• Analysis of sales data January 2024 – May 2024

• Developed dashboard using open-source solution i.e. Stream lit and utilized python programming language with Stream lit library for dashboard development & integrated data processing libraries such as Pandas and NumPy. EDUCATION

M.S in Information Technology (Business Analytics Specialization). May-2024 Murray State University, Murray, KY

B. Tech in Electronics and Communication Engineering. May-2018 Avanthi Institution of Engineering and Technology (JNTUH) – Hyderabad, India

Contact this candidate