Vishal Kumar Email & Phone Number

United States

• Forecasted Manpower Needs: Developed Excel-based analytical models to accurately forecast manpower requirements, achieving a 10% reduction in labor costs.• Dashboard Creation & Strategic Planning: Created ad-hoc reports and Excel dashboards using advanced functions tailored to specified KPIs, supporting strategic planning initiatives.• Data Infrastructure Development: Built data and reporting infrastructure from the ground up in Tableau and SQL, enabling real-time insights into key operational and performance analytics.• Automated Reporting with VBA: Developed and automated reporting processes using VBA Macros, streamlining data processing and reducing manual analysis time.• Model Calibration & Trend Reporting: Calibrated model input parameters and generated periodic trend-focused reports, enhancing decision-making accuracy.• Develop Predictive Models & Statistical Analysis: Leveraged Linear Regression and advanced statistical techniques in R to create predictive models, supporting data-driven decision-making.• Advanced SQL Querying: Used complex SQL queries with joins and sub-queries to retrieve complex data sets and analyze key metrics, improving data accuracy and supporting high-quality insights.

United States

• Transitioned existing Tableau dashboards into Power BI, achieving 15% reduction in delivery time and improving revenue forecasting accuracy for real estate property management. Developed interactive user interfaces, making insights more accessible for business stakeholders and decision-makers.• Designed and implemented comprehensive data models in Power BI, integrating financial and residential real estate datasets. Established essential KPI tracking functionality, ensuring real-time visibility of performance and profitability.• Collaborated with Product, Data Engineering, Data Science, Finance, and Business Ops teams to understand data requirements and ensure data models fully meet their needs.• Developed complex DAX calculations in Power BI for advanced revenue metrics, creating robust formulas to handle intricate scenarios, including prorated revenue for partial periods, multi-tiered calculations, and time-based analysis.• Meticulously gathered, aggregated, and analyzed internal and external data sources, ensuring high levels of data accuracy, integrity, and consistency. • Tested and validated dashboards using Azure SQL, ensuring data consistency and accuracy. Conducted comprehensive usability and user acceptance testing (UAT) to identify and mitigate risks before final deployment.• Automated data cleaning and pre-processing tasks using Power Query within Power BI, streamlining data workflows and reducing manual data preparation by 25%, leading to faster, more reliable reporting processes.• Worked alongside Data Scientists, supporting machine learning model development by optimizing ETL data pipelines and ensuring that data inputs met the necessary quality and consistency requirements.• Performed ad hoc analyses leveraging statistical models and advanced analytical techniques, providing actionable insights to leadership team. Utilized agile development methodologies to ensure quick turnarounds and continuous improvement in analytical processes.

Chennai, Tamil Nadu, India

• Customer Retention & Sales Growth: Conducted in-depth people analytics using Python (Pandas, Matplotlib, Seaborn), achieving a 5% increase in sales by identifying and retaining high-value customers.• Lead Segmentation & Conversion Optimization: Provided data-driven reports to the sales team, resulting in a 17% improvement in conversion rates by segmenting and prioritizing qualified leads.• Predictive Modeling for Engagement: Built a predictive K-Means clustering model in Python, which contributed to a 15% increase in customer engagement through targeted marketing efforts.• Data-Driven Marketing Insights: Developed interactive Tableau dashboards to deliver actionable insights to the marketing team, significantly enhancing data-driven decision-making.

• Analyzed healthcare claims data and utilized Power Query in Excel for data cleaning, eliminating data format errors, which improved data accuracy and reliability.• Designed client-focused Power BI dashboards with high attention to detail, ensuring client satisfaction and enhancing user experience.• Demonstrated expertise in SQL and relational databases (RDBMS), for data collection and applying advanced data modeling techniques and performing impactful data visualizations for healthcare datasets using Python and Power BI.• Automated data cleaning and transformation processes using Python, ensuring high data quality and creating robust data models for accurate reporting.• Performed ad hoc data retrieval and analysis using relational databases, Excel, and other data management systems.• Supported cross-functional teams on the day-to-day execution of projects and initiatives, helping develop requirements and specifications with business and development teams.• Collaborated in agile environments to meet project timelines, fostering cross-functional teamwork and consistently delivering actionable recommendations.

Master'S Degree, Management Information Systems, General, 3.81 Cgpa

Courses taken- IST 660 Data Mining and Business Intelligence IST 610 Object-Oriented Programming for Information Systems IST 612 Business.

(B.E.), Computer Science