Rohit C. Email & Phone Number

Mumbai, Mh, In

Mumbai, Maharashtra, India

• Design and develop interactive dashboards and reports using Tableau to meet business requirements.• Analyze complex datasets to identify trends, patterns, and insights that support business decisions.• Work closely with stakeholders to gather requirements and understand business needs.• Optimize Tableau workbooks and dashboards for performance and efficiency.• Collaborate with data engineering teams to ensure the proper extraction, transformation, and loading of data into Tableau.

United States

• Created insightful and interactive Tableau dashboards using Oracle database, custom SQL queries, and Tableau Prep Flow outputs, offering a comprehensive view of clients’ performance and KPIs.• Developed Tableau reports using advanced functions, including statistical forecasting, Basic expressions, Level of Detail expressions, Table calculations, spatial data, background images, etc.• Collaborated with clients, internal teams, and Executive Leadership Team to understand their expectations and define problems and solution requirements for Tableau reports development.• Designed intuitive visualizations in Tableau that enhanced communication with clients regarding pharmacy claims utilization, providing analytical insights for informed leadership decisions.• Managed 30 million records in Oracle database writing SQL queries for in-depth analysis, research, finding discrepancies, and cross-checking to maintain overall data integrity and accuracy.• Led the successful migration from Oracle data source to Tableau Prep flows, using the ETL tool for data cleaning, extraction, transformation, and consolidation across various tables.• Created and implemented Tableau Prep flow outputs as data sources, using functions such as join, union, pivot, aggregate, wildcard, geocoding, trim, custom calculation, etc.• Designed and implemented customized, self-service Tableau report templates on Tableau Server for the Account Management team, enabling them to generate reports by selecting desired parameters significantly reducing the process time from weeks to a more efficient timeline.

United States

• Employed ML image processing in Python using Scikit-Image and NumPy and analyzed the output in SQL to identify and process a targeted working dataset of warranty repairs of Dell laptops.• Conducted data pre-processing for the analysis of master claims data, resulting in a 15% reduction in losses due to warranty-void repairs.• Designed business analysis, created, and maintained Tableau dashboards to track business trendson a weekly and monthly basis

Tempe, Arizona, United States

• Reduced time for the Risk Manager to identify risky sellers from 4 hours to instantaneous by analyzing process flow • Prepared Data Models (DBMS) to define the logical structure of the relation of entities and their attributes to build ER models • Automated high-risk transaction prioritization using SQL queries, Tableau visualizations, machinelearning, and threshold analysis, saving $50,000 in costs

• Conducted a comprehensive audit of Asset Management Company investments database,ensuring compliance with country regulations and industry policies at a rate exceeding 99%.• Executed ad-hoc data analysis to deepen understanding of market trends and businessperformance, contributing to compliance initiatives.• Recommended business strategy to C-Suite on key profitability areas and showcased it bydesigning, and developing beautiful MS PowerPoint reports.

• Optimized the controls testing process by > 90% by identifying priority business operation areas by testing products and services• Presented the full-stack data analysis to the clients and the management on a bi-monthly basis• Identified key data elements, critical metrics, entities, sources, and relationships in business and technical terms in MS Excel

Master Of Science - Ms, Business Analytics

Master Of Business Administration - Mba, Finance