Power Bi Business Intelligence
Resume:
SNEHAL SHENDE **************@*****.***
Meridale forest dr, charlotte NC
Summary
Results-driven Power BI Analyst with 10 years of experience in business intelligence, data analysis, and visualization. Expertise in transforming raw data into meaningful insights using Power BI, SQL, DAX, and data modelling techniques. Adept at designing interactive dashboards, reports, and data-driven solutions to support business decision-making. Strong background in ETL processes, data warehousing, and integrating Power BI with multiple data sources.
Proven expertise in implementing multiple Proof of Concepts (PoC’s) using Tableau, QlikView etc by optimizing data models, and transforming complex data into actionable insights.
Adept at working with stakeholders to deliver strategic business solutions and drive data-driven decision-making.
Technical Skills:
BI & Data Visualization: Power BI (Dashboards, DAX, Data Modeling, Power Query), Tableau, OBIEE (Reporting, Dashboards, Repository Development)
Databases & ETL: SQL (Querying, Optimization, Data Manipulation), Oracle SQL, PL/SQL, SQL Server, OWB, SSIS
Programming & Scripting: Python
Methodologies: Agile, Waterfall SDLC
Tools: Microsoft Office Suite (Excel, Word, PowerPoint, Outlook, Project)
Education & Certification
Master of Computer Science, Pune University, 2011
Bachelor of Computer Science, Pune University, 2009
Microsoft Certified: Data Analyst Associate (PL-300)
Professional Experience
State Street Global Advisors Jul 2022 – Till date
Senior BI Analyst Location: USA
Led a team of BI developers to design and develop power BI dashboards to analyse General Ledger (GL) data, providing real-time financial insights for banking operations.
Partnered with stakeholders to define KPIs, gather requirements, and develop data visualization strategies.
Integrated Power Apps with Power BI for seamless end-to-end BI solutions.
Analyzed complex datasets using SQL and Power BI to drive insights on customer behavior, portfolio performance and risk metrics.
Designed and managed ETL pipelines to extract, transform, and load data from AWS S3 to Redshift using AWS Glue and SQL.
Utilized DAX and Power Query for advanced data modeling and analysis of Traded Products datasets.
Automated reporting processes, reducing manual GL reconciliation efforts and improving efficiency, boosting performance by 40% through tuning strategies.
Developed interactive dashboards integrating data from Redshift, Azure, and SharePoint to enhance decision-making.
Created executive-level PowerPoint presentations and data-driven storytelling for strategic insights.
Used Jira for issue tracking and resolution, improving dashboard accuracy.
Automated data pipelines using SQL and Power Automate, reducing manual reporting efforts by 40%.
Developed and optimized Power BI Paginated Reports for data-driven insights.
Designed and implemented self-service Power BI modules to empower business users with interactive dashboards and reports. (using filed parameter, bookmark etc)
Developed user-friendly data models, enabling non-technical users to explore data, generate insights, and create custom reports.
Atos Syntel Ltd Jul 2015 – Jul 2020
BI Analyst Location: India/UK
Client: FedEx India BI Analyst Feb 2018 – July 2020
Developed end-to-end Power BI solutions for FedEx, collaborating with stakeholders to gather requirements, define KPIs, and create logistics-focused dashboards while managing project design, data migration, SQL queries, testing, and maintenance.
Developed interactive dashboards to monitor real-time shipping metrics, package tracking, delivery performance, and fleet management.
Integrated Snowflake with Power BI for efficient data extraction, transformation, and analysis, designing data pipelines using import modes and direct query to visualize real-time data.
Created complex data models and relationships to manage data sources, ensuring data integrity and accuracy for FedEx's large datasets.
Utilized DAX functions, visualization, filters/slicers, Bookmarks, parameters, dynamic visualizations, actions for data-driven insights.
Ensured security compliance by integrating Power BI with Azure AD and AWS IAM roles.
Collaborated with data engineers to design ETL processes for smooth data integration.
Deployed Power Platform solutions and Python applications, utilizing Pandas, NumPy, and Matplotlib for advanced analytics.
Leveraged Python scripts within Power BI to perform complex data transformation and statistical analysis.
Automated data ingestion pipelines by embedding Python scripts for preprocessing and cleansing large datasets.
Reduced data reporting time by 30% by automating data refresh schedules and report delivery.
Client: Student Loans Company Glasgow Scotland, UK BI Analyst Lead Sep 2016 – Feb 2018
Designed and implemented interactive Power BI dashboards to track student loan disbursement, repayments, and delinquency rates.
Developed and maintained data warehouses using MS SQL Server, SSIS, and Power BI for end-to-end data integration and reporting
Created data models with DAX and Power Query, integrating data from internal loan systems and external financial databases.
Collaborated with business stakeholders to gather requirements and define KPIs, ensuring accurate visualization of loan repayment trends and forecasting.
Identified gaps and opportunities regarding data governance and data ownership and provided recommendations for improvements incorporating best practices.
Built real-time analytics solutions by integrating Power BI with Azure SQL Database and other sources.
Created drill-down and drill-through reports for detailed analysis of loan application trends and repayment schedules.
Automated ETL workflows, scheduled SSIS jobs, and configured Power BI data refresh alerts for seamless reporting.
Also, Scheduled data sets in Power BI Workspace for data refresh and created alert notifications in case of failure.
Utilized GitHub for version control, Power BI Direct Query for real-time updates, and DAX in SSAS for data validation.
Leveraged Excel (VLOOKUP) for data verification and optimized data governance practices.
Client: Humana India BI Analyst Jul 2015 – Sep 2016
Collaborated with stakeholders, healthcare analysts, business users, and IT teams to design insightful Power BI dashboards.
Developed interactive reports on patient outcomes, claims data, key operational metrics and cost-saving opportunities.
Integrated diverse data sources (SQL, Azure, Excel) and performed ETL using Power Query.
Leveraged DAX for complex calculations and measures to enhance data analysis.
Generated tabular, parameterized, Drill Through and Drill Down reports.
Migrated reports from OBIEE to Power BI, ensuring seamless data transition.
Used SVN for code retrieval and merging.
Ensured HIPAA compliance while handling sensitive patient data.
Deployed reports via Power BI Service, enabling real-time insights for senior management.
Creating Gateways and assigning them to the datasets for the Refresh Schedule.
Forbes Marshall Pvt Ltd Dec 2012 – Jul 2015
Data Analyst Location: India
Configured and created repository using OBIEE Administration Tool.
Developed request queries using BI Answer and assigned them to specific Dashboards.
Managed security privileges for each subject area and dashboard according to requirement.
Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
Performed unit and integration testing of reports and dashboards.
Involved in the end-to-end implementation of the dashboards i.e., from understanding requirements and identifying data sources to building the data model by writing ETL.
Multiple Colleges Schools / ETH Ltd Dec 2011 – Aug 2012
OBIEE Consultant Data Analyst Location: India
Expertise in OBIEE implementation, administration, and reporting.
I am skilled in data modeling, dashboard development, and report automation.
Strong SQL, PL/SQL, and data warehousing knowledge.
Experienced in gathering business requirements and translating them into technical solutions.
Proven ability to collaborate with cross-functional teams in educational institutions.
Contact this candidate