Data Analysis Power Bi

SHARVARI KHAIRNAR

New York, New York +1-425-***-**** ********@***.*** linkedin.com/in/sharvari-khairnar Highly skilled and results-driven professional with a strong background in data analysis and data visualization. Proven expertise in designing and implementing interactive dashboards, performing exploratory data analysis, and statistical analysis, and utilizing programming languages such as Python, and SQL to extract valuable insights. Experienced in database management, data modeling, data cleaning, data governance, and performance optimization. Excellent communication and collaboration skills demonstrated through successful team leadership and delivering data-driven insights to drive decision-making. Adept at leveraging technical skills and business acumen to provide actionable solutions and contribute to organizational success. EDUCATION

M.S. in Information Systems Syracuse University, New York (GPA:3.9/4.0) Dec 2023 B.E. Computer Engineering Savitribai Phule Pune University, India (Grade: A+) Jun 2014 -May 2018 EXPERIENCE

Empower Federal Credit Union Business Intelligence Analyst Syracuse, NY Sep 2023-present

Effectively conducting data discovery and data modeling using Power BI, SSRS, SQL and Power Query. Using descriptive and predictive analytics to better understand business data and make more informed decisions within the organization.

Gather requirements, create 10+ test case scenarios, and translate functional requirements into technical specifications in cooperation with stakeholders. Using Power BI, DAX, SSRS, SSIS, Python, and other tools, interact with cross-functional teams to improve 10+ BI reporting solutions and create 30+ self-service reports and dashboards.

Implementing data governance policies and procedures to ensure data accuracy, integrity, and security while addressing 100+ bugs and enhancements across FT/UAT/SIT cycles for significant product releases.

Developing SSIS packages to automate tasks and cut down on manual labor by 2 hours every week. iConsult Collaborative at Syracuse University Data Analyst Syracuse, NY Aug 2022 – Aug 2023

Designed and implemented interactive Tableau visualization dashboards to analyze data trends and utilized Python to aggregate and clean data from multiple sources, driving the maximization of key business KPIs, reducing manual reporting efforts by 9 hours per week, and uncovering valuable insights and trends through exploratory data analysis.

Demonstrated proficiency in using Excel functions such as VLOOKUP, SUMIFS, and Pivot tables for data analysis and testing, while employing AWS S3 buckets for efficient data storage. Wipro Technology Data Integration Developer Pune, India Oct 2018 - Jan 2022

Led cross-functional teams for the development of a data model using a snowflake schema, enabling the seamless integration of multiple databases through API, and facilitating the regulation of financial reports.

Achieved up to 50% improvement in process efficiency by implementing database performance enhancements, including Table Partitioning, SQL Query Tuning, Indexing, Hints, and SQL Restructuring techniques in Oracle.

Promoted Agile/SCRUM/SDLC practices, driving improved sprint velocity, reduced churn, and ensured high-quality deliverables; adeptly utilized JIRA to manage queues, generate reports, monitor SLA metrics, collaborate with clients by adding, editing, and deleting comments, and assigned tasks and issues to client stakeholders. ACADEMIC PROJECTS

Hydropower plant Analysis & Location Recommendation - Analyzed hydro powerplant datasets from West Africa and India using Python libraries (Pandas, NumPy, Matplotlib, Seaborn, and Geopandas) to extract insights for informed decision-making. Enhanced data accuracy and reliability through cleaning and transformation, achieving 90% meaningful analysis. Optimal hydropower plant locations were suggested using data visualization, which reduced costs and increased energy output. SKILLS

Business Analysis - Requirement Gathering, Strategic Planning System Analysis, and Design Use Case Development.

Project Management- Agile Development Project Scheduling Quality Assurance & Test Change Request.

Project Planning-Microsoft Excel, MS Project, ALM, JIRA/Confluence, Business/Functional Requirement Documentation.

Programming Languages and Tools - Python, SQL, PL/SQL, HTML, Tableau, Microsoft PowerBI.

Methodologies- Agile, PMLC, SDLC.

Big Data & Cloud-AWS, Google Cloud (GCP), Salesforce. LEADERSHIP

Credit Suisse -APAC STAR Award Wipro Technology Aug 20 -Aug 21

Successfully developed quarterly strategic plans for the reporting team, resulting in 100% resource utilization and a 60% increase in project deliverables.

Outperformed colleagues in a demanding Rotational program designed to foster agile team cohesion and a steep learning curve.

Contact this candidate