Project Management Power Bi

Akshada Patil

Ph: 860-***-**** ad5dws@r.postjobfree.com https://www.linkedin.com/in/akshada-patil-5135861b3/ EDUCATION

Master of Science in Business Analytics Aug 2021 – May 2023 Southern New Hampshire University, New Hampshire GPA: 4.0/4.0 Related Course: Predictive Analytics, Data structures & Database Management, Prescriptive Analytics, Decision Support Systems, Business Statistics, Project Management, Object Oriented App Development, Data Mining and Data Warehousing. Bachelor of Technology in Electronics and Communication Engineering Aug 2016 – Jun2020 Gujarat Technological University, Gujarat, India GPA: 3.6/4.0 CERTIFICATIONS

1. Issued by: American Institute of Certified Public Accountants (CPAs) I. Analyzing and Visualizing Data with Microsoft Power BI II. Coaching and Mentoring

2. Issued by: Microsoft.

I. Microsoft Excel for Accounting

TECHNICAL SKILLS

Programming Languages: C#, R, Java, Python, SQL, PL/SQL, T-SQL Project Management: MS Project, Jira Databases: Microsoft SQL Server, MongoDB, Oracle, Teradata, SAS, SSMS Others: Supervised Machine Learning Visualization Tools: Tableau, Power Bi, Microsoft Visio, Lucid Charts, SSAS, SSRS Version Control: Git. PROFESSIONAL EXPERIENCE

0

Business System Analyst - Proximate Technologies Inc, Plano June 2023 - Present

• Participated in project planning, documenting BRD, FRD and configuration workbook to outline proposed solution plan.

• Integrated an XG Boost Model to predict sales, streamline supply chain, and enhance inventory planning, and achieved 93% R-squared rate.

• Implemented advanced statistical tests and analyses, including descriptive statistics, time-series analysis, regression, hypothesis testing, A/B tests (minimizing type I and type II errors) and visualization, resulted in actionable insights that significantly enhanced strategic decision-making for businesses and investors in navigating the complexities of Mergers and Acquisitions (M&A) dynamics.

• Designed and developed a data model using RNN and CNN to forecast annual sales by incorporating external factors with 6% error for Oct ‘23 and hence supported demand planning in Sales and Operations Planning (S&OP) and Executive S&OP.

• Employed a dual approach to handle missing values: Leveraged K-Nearest Neighbors (KNN) imputation for localized predictions and Principal Component Analysis (PCA) for broader pattern preservation enhancing dataset integrity and accessibility by managing databases with adding, editing, and deleting required information.

• Streamlined the database design process, reducing development time by 15% implementing architectural E-R diagrams on Lucid Charts. Created a module for customer segmentation implementing k-means clustering algorithm in Python.

• Expertly extracted, cleaned, and visualized data for user data queries for audits and inspections, ensuring accuracy and efficiency in order to data injection in Quality Management Systems like QAAD and Trackwise.

• Forecasted the profit trend by analyzing historical transaction data through statistical modeling on the current volatile financial situation, consequently leading to a 10% increase in organizational profits by mitigating discrepancies in budgeting and cash outflows by 35%.

• Recognized growth opportunities by analyzing sales data, comprising of 1.4 million transactions, via advanced SQL queries and hypothesis testing methods (t-tests, Chi-squared, F-ratio and ANOVA).

• Executed Customer Relationship Management system that resulted in a 20% increase in customer satisfaction and a 15% improvement in sales performance by applying analysis to refine CRM workflows.

• Developed interactive Tableau dashboards for KPI visualization on market, boosting data-driven decision-making by 20% and implemented moving average and exponential smoothing, reducing sales forecasting errors by 15%. Business Intelligence Engineer – Advata, Seattle – Healthcare Domain May 2022 - December 2022

• Performed Data Modeling to define and analyze data requirements such as insurance bills' claim date, invoice number, claim type, and status to support the healthcare analysis processes.

• Proficiently extracted valuable insights from unstructured patent text and image data using Python, employing NLTK and PIL. Therefore, integrated automated pipelines with data modeling techniques to define data requirements such as claim date, invoice number, and status to foster the healthcare analysis processes.

• Optimized SQL join queries and database indexes by collaborating with DBA to manage database objects, resulting in a 30% improvement in database performance and 20% reduction in query response time.

• Implemented DAX to encrypt sensitive customer data (PII or SSN) using algorithms like AES or DES, ensuring secure data storage, authorized user access and strengthening data protection measures.

• Conducted performance tuning, required predictions were forecasted and offered insightful prescriptions from optimization and simulation modeling resulting in high ROI and 12% cost reduction.

• Developed & published Power BI dynamic dashboards, providing a holistic view that showcased real-time data, enabling stakeholders to access up-to-the-minute insights for quick decision-making on customer’s insurance invoice.

• Identified areas of improvement in staffing, scheduling, and resource allocation for reducing waste and boosting efficiency, resulting in increased productivity and profits by $50K+ in healthcare organizations.

• Wrote ad hoc SQL queries to extract and analyze customer’s medical claim data for revenue cycle forecasting and marketing strategy development yielding 20K+ customer’s insurance reimbursements with multiple payers.

• Successfully harnessed social media analytics, employing advanced modeling techniques like text mining and Natural Language Processing (NLP) to deliver consumer behavior insights which facilitated a nuanced understanding of customer sentiments, preferences, and trends, empowering informed marketing and business strategies.

• Increased claiming process efficiency by 30% by analyzing pending claim reports, thereby creating financial reports. Financial Business Analyst - Home First Finance Company, INDIA June 2020 - June 2021

• Performed statistical analysis and Equity analysis to diagnosed root causes of customer service & come up with different strategies, resulted in customer retention by 25%.

• Delivered reports on a weekly, monthly, quarterly, and annual basis. Identifying, developing, and adjusting key performance indicators (KPI) for all products (Home Loan/Mortgage Loan).

• Optimized data integration with SSIS, achieving 25% speed improvement and 20% reduction in errors for a more efficient ETL process, enhancing overall data accuracy and system reliability.

• Employed Alteryx's spatial analytics tools to conduct geospatial analysis, visualizing location-based data yielding optimized market penetration, enhanced site selection strategies, and bolstered data-driven decision support.

• Improved customer experience by creating a Tableau dashboard of EMI time series trend, yield in a 50% increase in customer repayment ratio.

• Leveraged Tableau to perform cohort analysis, identifying customer behavior patterns and supporting targeted marketing strategies.

• Elicited statistical database through gap and current state analysis, generating financial reports that led to a high ROI, improved strategic planning, and optimized budget allocation. PERSONAL PROJECTS

Car Sales Model: (Microsoft Excel, Tableau, Multiple Regression)

• Imported data from multiple data sources into Excel workbook, derived relationships between heterogeneous data, created calculated columns and measures using VLOOKUP and formulas, built PivotTables and pivot charts using power pivot skills.

• Designed & created actionable Excel model for evaluating selling price to their manufacturing price by adding features for various cars on their manufacturing price to retail price.

• Visualized Tableau charts to represent analyzed selling prices of the cars as per their age, km driven, number of owners and fuel type.

Data Science Project Life Expectancy Rate by vaccines

• Data driven decision making: Performed bivariate and multivariate regression analysis, relationship and trends reports, outliers, chart dashboards and Power BI visualizations.

• Implemented Descriptive Analysis and Predictive Analysis to plot graphs in Tableau.

• Explored the structure of the dataset by spotting, reporting, and correcting unexpected data patterns and anomalies for the usage of the data catalog and data compliance, as well as giving final suggestions and recommendations. Project Management

• Able to scope a project using Work Breakdown Structure (WBS)

• Able to build a project schedule using Critical Path Method

• Able to perform project risk analysis using Project Evaluation & Review Technique (PERT) Covid-19 Project Global Covid cases v/s deaths for the year 2020-21:

• Performed data collection, data discovery and data mining before modelling the covid confirmed cases, deaths, vaccinations, and policy reports for 5 different countries which are Canada, Nigeria, Italy, Iran, and Ecuador.

• With the use of the cleaned covid-19 dataset and based upon the key metrics, 16 visualizations on Tableau and Power BI have been created, analyzed, and retrieved to show each country’s level of status and condition.

• Required predictions were forecasted and offered insightful prescriptions from the modelled graphical outputs. AWARDS & ACHIEVEMENTS

• Recognized with Difference Maker Award for outstanding contributions on cost savings of $50k at Advata.

Contact this candidate