Data Analyst Power Bi

Sanjana Deswal

* **** *** ******, *******, Illinois -60605 M: +1-312-***-**** Email : ****************@*****.*** TECHNICAL SKILLS

Tools: SQL, SSRS, SSIS, MS Access, PAR Excellence, OneStream, Allscripts, Epic Systems, Jira, MS Office, Snowflake, Google Analytics, Adobe Analytics, Azure, Excel, Tableau, Power BI, VBA Macros, SAS, Databricks, Python, R, Spark Business skills: Data Analysis, Data Modeling, Data Warehousing, Big Data, Machine Learning, Financial Analysis, Business Intelligence, Forecasting, A/B Testing, Data Visualization, P&L Analysis, Digital Analytics, Data Pipeline Development, Statistical Modeling, Problem Solving

EDUCATION

University of Illinois, Chicago, GPA - 3.69/4 Chicago, IL Master of Science in Business Analytics August 2021 - December 2022 Bharati Vidyapeeth’s College of Engineering, GPA: 3.92/4.0 Delhi, IN Bachelor of Engineering, Information Technology August 2017 - July 2021 PROFESSIONAL EXPERIENCE

Data Analyst, Collabera (Regal Rexnord) July 2024 – Present

●Designed financial reports and forecasting models in Excel and Power BI, improving strategic decision-making.

● Conducted advanced data validation using SAS, ensuring accuracy for over 5,000+ records in OneStream financial reporting.

● Ensure data transformation rules are applied correctly by validating processes and using SAS for statistical analysis and advanced data manipulation.

●Built automated digital analytics pipelines to optimize financial processes, improving reporting efficiency by 20%.

● Collaborated with stakeholders to refine data transformation rules, ensuring alignment with business objectives. Data Analyst, Axios Medical Equipment January 2023 - July 2024

● Analyzed 8 million healthcare records, detected trends and anomalies, and achieved a 10% improvement in patient care outcomes.

● Developed and maintained data models for revenue forecasting, resulting in a 12% increase through data-driven pricing strategies.

● Performed ETL process using SQL, SSRS, SSIS, Excel, and visualizing insightful reports and dashboards through Power BI to track customer spending patterns, improving financial planning.

● Collaborated with 2 teams to reconcile revenue data, resolve discrepancies, ensuring accurate financial reporting.

● Conducted advanced statistical analysis using SAS, including regression modeling and hypothesis testing; generated actionable insights that directly improved patient care quality across a network of 12 healthcare facilities Business Intelligence Analyst, WISEcode September 2022 - December 2022

● Utilized Machine Learning algorithms to predict 7 food categories with 83.54% accuracy.

● Expert in data cleaning, exploration of internal/external audits, and implemented algorithms (Naive Bayes, SVM, Logistic Regression) on a 6 million-row dataset.

●Developed A/B testing frameworks, increasing offer conversion rates by 18%.

● Engineered data pipelines using Python, automating the ingestion, transformation, and loading (ETL) of large-scale datasets, increasing processing efficiency by 25%.

● Applied SAS to conduct multivariate analysis and hypothesis testing, enabling data-driven decision-making in product development. Data Analyst Intern, Adroit Trading Technology May 2022 – August 2022

● Enhanced user efficiency by 50% with a SQL feature enabling trade ID-based audit report generation.

● Ingested, visualized, and reported on 2 million records using Power BI and Advanced Excel.

● Built Power BI dashboards for analyzing transactional data, providing actionable insights for investment strategies.

● Utilized SAS for time series analysis and forecasting, improving the accuracy of financial models and reducing forecast error by 15%. Business Analyst Associate, What After College March 2018 - July 2021

● Implemented Tableau dashboards for cost optimization, reducing marketing expenses by 8% while boosting sales by 9%.

●Achieved a 25% revenue increase by developing comprehensive business plans encompassing market analysis, financial projections, and strategic initiatives.

● Implemented SAS to perform data mining and segmentation, enabling more targeted marketing strategies and improving campaign ROI by 20%.

Contact this candidate