Data Analytics Business

PANKAJ NANDAL

Minneapolis • 763-***-**** • ********@***.*** • www.linkedin.com/in/pankaj-nandal

EDUCATION

UNIVERSITY OF MINNESOTA, Minneapolis, MN

Carlson School of Management

Candidate for Master of Science in Business Analytics Expected August 2025 4.00/4.00

Major in Business Analytics.

NATIONAL INSTITUTE OF TECHNOLOGY KURUKSHETRA, India NIT Kurukshetra

Bachelor of Technology May 2018

3.77/4.00

Major in Mechanical Engineering.

Relevant Course Work: Operation Research, Statistics, Business Management, and Mathematics.

EXPERIENCE

AMERICAN EXPRESS, India

Analyst-Risk Management November 2021 - August 2024

Early Tenure Ramp (US Small market): Collaborated with the ETR Team and moved the Excel-based reporting to Tableau with interactive and insightful views. Accelerated speeds to market by 50%, by streamlining and automating the processes. Managed the segment for two years while introducing new performance metrics.

Client Specialist: Developed Tableau Dashboard to analyze and report the performance of the Client Specialist teams. Incorporated a new verification process to enhance the managers' overall efficiency.

Top Client Expansion (US Middle Market): Extended strategic support towards the team in streamlining and automating the credit payouts and reporting to the US Middle Market Team. Automated and standardized the reporting processes and ensured timely & accurate delivery of reports and insights for teams.

WCO & I-Success Tool: Displayed excellence in developing several tools to assist Business SMEs in planning goals according to current/average run rate performance. The tool facilitated the teams in accomplishing year-end targets. It helped to up-lift the overall performance of the segment from 110% to 135% attainment.

MCKINSEY & COMPANY, India

Solution Delivery Analyst July 2021 - November 2021

Workforce HQ: It is a tool to support providers in tracking overall performance and identifying the scope of improvements. The tool is built around working hours, salary paid to colleagues across different departments, and the number of patients the provider treats. Extended support towards onboarding of 2 significant providers from the USA. OPTUM GLOBAL SOLUTIONS (UHG), India

Associate Data Analyst June 2018 - July 2021

GRIP (Group Retiree Intelligent Platform): The project facilitated 600+ groups with 1.6 million members. Developed an analytical solution for the leadership to make mission-critical business decisions. Consulted business partners and incorporated drill-down views to support Operations Team. The project was adopted across other segments as well.

SAM-CRT Tracking: Tracked near real-time issues for SAM (Service Account Management) and CRT (Critical Resolution Team) teams with the functionality of root cause drill-down and agent performance tracking. Facilitated teams in improving KPIs from 85% to 93% (issues resolved within TAT).

Member Experience Platform: Designed solution focused on enhancing member satisfaction and identifying gaps using sentiment analysis of customer feedback and ratings. It helped improve the overall call-handling process.

Risk Assessment Tool: Created a tool for early risk detection across business areas such as Calls, Appeals, SAM, CRT, and CTM. The tool helped leadership take proactive action based on different performance metrics. Later updated the tool to run at daily frequency in comparison to monthly frequency.

PROJECTS

LIVE CASE

Consultant November 2024 - December 2024

Partnered with The Good Acre to investigate five potential locations for a new warehouse, analyzing data related to nearby farms, farmers, and other metrics. Delivered interactive Tableau dashboard with dynamic functionality.

TRENDS MARKETPLACE

Analyst November 2024 - December 2024

Presented the TabPy library and its use cases to industry professionals at a tabling event, demonstrating its functionality for integrating Python scripts with Tableau for advanced analytics.

SKILLS

Technical: Python, R, SQL, Tableau, Databricks, A/B Testing, Causal Inference, Statistical Analysis, Predictive Analytics, and Microsoft Office Suite (Excel, Powerpoint, Word).

Soft Skills: Effective Communication, Leadership, Critical Thinking, Problem-Solving, Collaboration/Teamwork, and Time Management.

Language: English (Professional), Hindi (Native). CERTIFICATIONS

Harvard Leadership Edge: conducted by Harvard Business publishing corporate learning, focuses on “Communicating to Connect-Engage Others.

Contact this candidate