Prathamesh Parab

• Created dashboards for an insurance company to highlight different types of frauds.
• Documented the AS-IS Process for Anti-Corruption Bureau, Maharashtra after discussions with numerous police and law officers.
• Built a descriptive dashboard for Anti-Corruption Bureau, Maharashtra to summarize their case history across districts and cities.
• Led a team of analysts for a project which identified frauds in a Delivery Startup.
• Analyzed AADHAR data for UIDAI to showcase discrepancies in the data.
• Was involved in a POC for a Oil and Natural Gas Company to highlight the frauds happening at the fuel stations and during the transportation of the fuel.

• Built Pricing Analytics model to help business sell off slow-moving inventory.
• Created ad effectiveness dashboard for business to optimize their ad spends.
• Analyzed and interpreted web-scrapped data to give insights and highlight whitespace in business.
• Managed team of data engineers and business analysts to migrate data from MariaDB to MySQL database.
• Built demand forecasting model which had 10% more accuracy than existing forecasting tool.

Projects:

1. Welspun Group

• Increased efficiency of previous dashboards by 50%

• Engaged with client to understand current business scenario and data flow of the company

• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports

• Created DAX Queries to generate KPIs like Pareto%, CAGR, COGS in Power BI

• Used bookmarks to make interactive visualizations buttons

• Explored data in a variety of ways and across multiple visualizations using Power BI

• Implemented dynamic row level security on datasets

• Automated Financials of the company viz. Income Statement and Balance Sheet

• Eliminated the use of Microsoft Excel by the users by at least 70%

• Created Debtors and Creditors Dashboard which included Ageing, Credit Exposure, Advances and DSO/DPO trend over the months.

• Teamed up with the Backend Team on multiple occasions to implement complex logics

• Managed a team of data analysts to ensure go-live within the timeline

• Used Power Automate to send Alert Triggers.

2. 5Nance India

• Understood business requirements by client engagement

• Learnt about the technical indicators like Bollinger Bands and MACD

• Plotted the indicators in Python using inbuilt libraries

3. Sony Pictures Networks India

• Learnt about the measures used in TV viewership analysis and conventions used in media industry

• Researched about HR Analytics and the important measures used in the same

4. Integrated R, RStudio and Hadoop in Cloudera

• Designed custom HTML emails for newsletter and subscription invitation

• Ensured consistent page appearance/behavior across multiple browsers (IE6+, Firefox, Chrome, Safari)

• Developed API's using JavaScript and PHP