Summary
Overview
Work History
Education
Skills
Timeline
Generic

PUNEET GUPTA

Delhi,Delhi

Summary

New Delhi A professional with experience in Data Analytics, Data Mining, Data Manipulation, Deriving Insights, Data Visualizations & Business Intelligence with hands-on experience in Tableau Desktop, Tableau Server, Alteryx, Advanced Excel, VBA (Macro). Gathering user requirements, analyzing, and designing software solutions based on the requirements Puneet Gupta (Senior Analyst) – KPMG Global (Nov’21 to Till) Profile As Business Intelligent Developer with extensive experience in Alteryx and Tableau. Expert in Alteryx, Tableau, Excel, VBA. Command on Technical language – SQL, Basic of Python. Certification in Alteryx – I & Tableau Desktop Specialist Experience in Building Alteryx macros to avoid repetition of tasks. Experience in Building Alteryx app & workflows for automation of reports. Experience in Building Tableau Dashboards and finding other opportunities for business. Worked on Building ETL workflows for Tableau Dashboard. Worked on creating Reports, PPT’s on Excel & Alteryx. Experience in text analysis through Python. Work with Developers, Architects, Development Managers, Business Stakeholders to plan timelines and ensure timely delivery of a high-quality overall solution that meets business requirements and help them in UAT validation. Puneet Gupta (Lead - FPNA) – Guardian India (Apr’17 to October’21) Profile Overall, 4 years of experience as a Business Intelligent Developer with extensive experience in Alteryx and Tableau. Expert in Alteryx, Tableau, Excel, VBA. Command on Technical language – SQL, Basic of Python. Certification in Alteryx – I & Tableau Desktop Specialist Experience in Building Alteryx macros to avoid repetition of tasks. Experience in Building Alteryx app & workflows for automation of reports. Experience in Building Tableau Dashboards and finding other opportunities for business. Worked on Building ETL workflows for Tableau Dashboard. Worked on creating Reports, PPT’s on Excel & Alteryx. Experience in Data Cleansing & Exploratory Data Analysis through Python. Experience in text analysis through Python. Work with Developers, Architects, Development Managers, Business Stakeholders to plan timelines and ensure timely delivery of a high-quality overall solution that meets business requirements and help them in UAT validation.

Overview

6
6
years of professional experience

Work History

Lead

Puneet Gupta, AON
04.2011 - 03.2017
  • Profile Overall, 6 years of experience as a Lead Operation manage the career growth and development of the team by driving focus on Core Values.
  • Plays a critical role in building management depth by providing guidance and mentorship.
  • Develop strong customer focused orientation within the team.
  • Performance appraisals for team as per process stack rankings.
  • Working with the Command center in scheduling and rostering teams according to the forecast sent and the internal historical pattern.
  • Transition knowledge about the findings and solutions to the Claims & Operations team through discussions and presentation.
  • Excellent planning skills with on-going workflow monitoring; ability to multi-task and prioritize responsibilities.
  • Create customized solutions & trainings in line with the root cause analysis findings and ensure error free execution.
  • Review group contract provisions, and submits medical information to identify discrepancies and inconsistencies when assessing disability benefit eligibility.
  • Responsible for the management, investigation and decision making of disability claims within delegated authority.
  • Won “Employee of the Year Award” many times for instrumental role in driving breakthrough performance in the team and ensuring high resolution, customer satisfaction & revenue.
  • Recognized for efforts put in for reducing repeat contacts and time to resolve.
  • Work with Business Stakeholders to plan timelines and ensure timely delivery of a high- quality overall solution that meets business requirements and help them in UAT validation.

ROLE Developer

KPMG
  • Sales Tax Report Automation through APP & Macro TECHNOLOGIES Alteryx, Global Services provides different Sales tax services in America.
  • So, they have different- 2 deadlines to provide multiple tax calculated reports to clients on 15th of the month, some states have deadlines for 30th of the month, some states have 1st of every month those are needed as per their dedicated timelines and to the clients.
  • This is regarding Sales & Tax and asked by different Sales and managers for different Group states and Time interval.
  • I made Alteryx app on which we have to give input i.e., Sales Tax no.
  • For every different states and Time interval then directly export that report and also create macro so that this macro can be used during all the given dates to run.
  • ROLE: Development of full app and macro in Alteryx.
  • Validation of Reports Involved in Post Implementation Support Coordinate with onshore team on the requirement and knowledge transition Involved in Post Implementation Support Projects PROJECT P&C Report Automation through APP.

ROLE Developer

TECHNOLOGIES Alteryx
  • Guardian Life Insurance company of America provides different Insurance services in America.
  • So, they have different account manager who deal directly with the clients.
  • There was a report which is regarding Premium & Claims and asked by different account managers for different Group no.
  • And Time interval.
  • I made Alteryx app on which we have to give input i.e., Group no.
  • And Time interval then directly export that report.
  • ROLE: Development of full app in Alteryx.
  • Validation of Reports Involved in Post Implementation Support PROJECT Operational Stats Dashboard, This Dashboard is especially for operations managers to manage their inventory of overdue cases.
  • And Leadership can check the work state where they are getting the inventory on higher side and how the company is performing at different locations.
  • It captures the status of the claims/ tasks which are submitted by the people working for our clients at different locations and details of the team assigned to complete the task.
  • These claims are related to their US Federal leaves i.e., LOA, STD & LTD.
  • ROLE: Involved in Analysis, designing and developing the requirements Interact with different Operations Managers for data Involved in Post Implementation Support PROJECT Daily Reports Automation, This is an ETL project which needs to visualize on the tableau dashboard, there are around million plus claimant data like (claimant amount, profit, loss ratio summary, lag by days, claim duration by diagnosis) data need to showcase to stakeholder.
  • The purpose of creating the dashboard to save the maintaining cost of the tool which used earlier (Cyrstal).
  • ROLE: Used Alteryx and SQL to retrieve, manipulate and analysis the data from data lakepresto to hive and connect hive with tableau dashboard.
  • Coordinate with onshore team, data team on the requirement and knowledge transition.

Developer

TECHNOLOGIES Alteryx
  • There were around 30 reports which were made using two different data sources i.e., DB2 & CSV file and that consumed around 4 hours on daily basis.
  • I automated the reports using Alteryx workflows and now take around 5 minutes to complete the process.
  • ROLE: Creation of Dynamic workflow in Alteryx.
  • Coordinate with onshore team on the requirement and knowledge transition Involved in Post Implementation Support PROJECT LMER Dashboard TECHNOLOGIES Tableau.

Education

Bachelor of Arts (B.A Programming) - undefined

Diploma - Information Technology & Management

Skills

Technologies Alteryx, Tableau, Excel, VBA, PowerPointundefined

Timeline

Lead

Puneet Gupta, AON
04.2011 - 03.2017

ROLE Developer

KPMG

ROLE Developer

TECHNOLOGIES Alteryx

Developer

TECHNOLOGIES Alteryx

Bachelor of Arts (B.A Programming) - undefined

Diploma - Information Technology & Management

PUNEET GUPTA