Shrushti Shah
San Francisco,CA
Summary
Data Analyst/BI Developer with 6 years of professional experience. Specializing in crafting visually engaging analytical solutions that clearly convey insights and support business objectives. Well versed in end-to-end design development using DataWarehouse concepts and working with varied data sources like Excel, SQL, AWS, GCP and Azure.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Consultant - Power BI SME
Fractal Analytics
08.2021 - 08.2024
- Lead development of dashboards for web-based application on Patient Analytics which created a rule based predictive analytics engine using Machine Learning models.
- Development of end-to-end data model design, data transformations, self-service semantic design and its implementation on Power BI and Looker
- Formulate CPG/Healthcare domain specific KPIs using business logic in DAX, LookML and SQL
- Configuration of Row Level Security and user management in Power BI/Looker
- Data validation and end-to-end deployment, debugging data discrepancies in DAX, SQL, and Python scripts
BI Developer
Predoole Analytics
11.2019 - 08.2021
- Collaborated with clients to identify data requirements and source to target mappings for creating performance optimized business dashboards in QlikSense and Power BI
- Implementation of interactive storytelling in Power BI, similar to an existing feature available in QlikSense
- Migration of legacy reports to QlikSense and Power BI
- Developed Pharma domain Sharepoint website and used Power BI embedded functionality within the portal
- Created SSIS packages with various transformations and error handling use cases for ETL processes in Azure Synapse
- Developed POC to explore integration of backend data with Microsoft PowerApps
- Collaborated with cross-functional teams to identify business requirements and translate them into technical specifications.
Associate Software Engineer
Accenture
03.2018 - 03.2019
- Developed, deployed and supported Informatica workflows/mappings in production using business logic
- Analysis of data issues reported by business users in SQL, Netezza
- Creating and debugging SQL scripts with stored procedures, functions and triggers to enable data flow
- Designed reports in Business Objects and Crystal. Management of BO Admin role which included setting privileges and scheduling reports
- Creation and maintenance of MicroStrategy cubes to populate business reports, sourced from Data Warehouse
Education
Master of Science - Business Analytics
San Francisco State University
San Francisco, CA12.2025
Bachelor of Engineering -
University of Mumbai - Father Conceicao Rodrigues College of Engineering
Mumbai, India05.2017
Skills
- Data Visualization & Storytelling - Power BI, QlikSense, Looker, Business Objects, SSRS
- Data Analysis & Modelling - Informatica Power Center, BigQuery, Azure Synapse, SQL Server Management Studio, Python
Certification
- Microsoft Certified Data Analyst
- Fractal Certified SQL Developer
- Power BI using Python - Coursera
- Microsoft Azure SQL - Coursera
- Analyzing and Visualizing Data using Looker - Coursera
- Predictive Modelling, Model Fitting and Regression Analysis - Coursera
Projects
1. Icarus Innovations Internship, 2019, Developer -
Created a Content Management System for backend use for Cloth Merchants using Spring Boot Web App. Developed admin and user login, CRUD operations for managing Cloth-Fabrics data.
2. Power BI Freelancing, 2019, Developer -
Completed EdX certification course 'Analyzing and Visualizing Data in Microsoft Power BI'. Developed user friendly reports/dashboards and its deployment on Power BI Service. Designed data models, used data transformations to streamline data, and developed KPI measures using MDX/DAX query. Implemented Row Level Security and conducted functional testing of the dashboard.
3. Blood Donation App, 2018, Developer -
Worked on UI components of the app using custom XML schemas for the components. Explored understanding of Android Background services, SQLite database and Fragment Transaction in Android.
4.Python Summer Internship - IIT Bombay, 2017, Developer -
Contributed to the Textbook Companion Scilab Activity under the FOSSEE Project. Worked on creating a library of textbook numerical problems coded in Python and Scilab.
5. B.E Final Year Project, 2017, Developer -
The Neural Network was trained to recognize alphanumeric samples of handwritten text that had been scanned into a digital format. Different ML models and pattern recognition algorithms were studied and tested to detect and classify the images to attain higher accuracy.
Published Paper: http://www.ijste.org/articles/IJSTEV4I2050.pdf
Timeline
Consultant - Power BI SME
Fractal Analytics
08.2021 - 08.2024
BI Developer
Predoole Analytics
11.2019 - 08.2021
Associate Software Engineer
Accenture
03.2018 - 03.2019
- Microsoft Certified Data Analyst
- Fractal Certified SQL Developer
- Power BI using Python - Coursera
- Microsoft Azure SQL - Coursera
- Analyzing and Visualizing Data using Looker - Coursera
- Predictive Modelling, Model Fitting and Regression Analysis - Coursera
Master of Science - Business Analytics
San Francisco State University
Bachelor of Engineering -
University of Mumbai - Father Conceicao Rodrigues College of Engineering
Similar Profiles
ONKAR BELGAMWARONKAR BELGAMWAR
Architect at Fractal Analytics, Formerly Neal AnalyticsArchitect at Fractal Analytics, Formerly Neal Analytics
Vaishali RavichandranVaishali Ravichandran
Data Engineer at Fractal AnalyticsData Engineer at Fractal Analytics
MOHAMMED NIZAMUDDIN FAROOQUIMOHAMMED NIZAMUDDIN FAROOQUI
Manager at Fractal Analytics Private LimitedManager at Fractal Analytics Private Limited