Shashank Gupta
Greater Noida
Summary
Seasoned information technology manager knowledgeable about data technology & visualization along with operations management. Proactive and decisive leader with several years of related experience.
Overview
12
12
years of professional experience
Work History
Data Analytics Manager
Omnicom media group
Gurgaon
10.2023 - Current
- Handling a huge dataset from meta platform for a client to transform uninstructed data into meaningful structured tables with data modeling.
- Provided technical guidance on data collection processes to ensure accuracy of results.
- Analyzed large datasets from various sources including SQL databases, web APIs and CSV files.
- Optimized query performance for large scale analytic queries running on distributed computing clusters.
- Conducted exploratory data analysis, identified trends and created visualizations for insights.
Manager of Operations & Analytics
Genpact India Pvt Ltd
Noida
02.2020 - 10.2023
- Served multiple projects for global and leading US Banking & Healthcare client under operations, customer data management and risk analytics.
- Managed a team of 9 people for monitoring workflow, resource alignment for quarter close activity along with implementation of automation of process by analyzing data flow trend & activity during high volume flow.
- Create forecast of demand to be prepared for upcoming requirements using Power BI tool(Dax function/data modeling), Advance excel and other related transformation tools.
- Understanding requirement from business vertical and working on SQL databases/share-point to design visualization/dashboard as per client/stake holder requirements and act as Single Point of Contact for all data repository and develop metrics to analyze pertinent information and share insights through various reports, dashboards on sustainable basis using DAX query on Power desktop.
- Establishing weekly calls with stakeholders to ensure data collection is optimized to provide crystal-clear visibility into past, present, and future behaviors of customers
- Planned, created, tested and deployed system life cycle methodology (SDLC) to produce high quality systems to meet and exceed customer expectations.
Procurement & Data Specialist
SoftwareOne India Pvt Ltd
Gurgaon
07.2018 - 02.2020
- Generated price request, Publishing Sales order & Reviewed delivery orders to ensure supply is met, taking availability, manufacturing process and lead times into consideration for global market in Hardware / software / licenses business category.
- Management of item catalog with various levels of supplier & distributer and Oversee all inventory and equipment purchases, identifying areas of potential savings.
- Prepare Reports based on data to provide business solution and discover performance of operation and generate reports on SLA performance.
- Create forecast of demand to be prepared for upcoming requirements using Power BI tool, Advance excel and other related database sources.
- Prepare daily, weekly, and monthly reports/deliverables using ODS/Excel, Pivot tables and Existing Dashboards
- Prepare Dashboards and Decks at the end of Month/Quarter to provide analysis of trend of business progress
- Identified, analyzed and interpreted trends or patterns in complex data sets on SQL server and tested data prediction algorithms based on historical data.
Customer Service Representative
Agilent Technologies Pvt Ltd
Manesar - Gurgaon
04.2014 - 07.2018
- Part of Customer Operations center, managing services business for European Countries
- Handled Service support division part of Order Management end to end, from Quote to Cash for more than 20 Sales coordinators for global region (majorly european clients)
- Mentoring & monitoring the performance of team members to ensure efficiency in process operations and meeting of individual & group targets
- Conceptualizing & developing need-based training modules for developing multi skilled work force for utilization within sub processes for optimum efficiency
- Monitoring overall functioning of processes, identifying improvement areas and implementing measures to maximize customer satisfaction level
- Framing work direction & plan for associates after assessment of their capabilities, preparing & presenting various weekly/monthly reports pertaining to process/productivity
Technical Research Intern
Council of Scientific & Industrial research
New Delhi
05.2012 - 03.2014
- Designing and maintaining of Databases using web based application for international S&T division
- Contributing & executing highly skilled ideas of developing front-end tools
- Preparation of technical reports and presentations for exploratory visits of CSIR Scientists and DG, CSIR and also Preparation of Memorandum of Understanding (MoU)
- Successfully completed 2 projects in functional designing tool
- Completed research, compiled data, updated spreadsheets, and produced timely reports.
- Gathered, arranged, and corrected research data to create representative graphs and charts highlighting results for presentations.
Education
Bachelor of Technology - Information Technology
Baldev Ram Mirdha Institute of Technology
Jaipur, Rajasthan05-2011
Skills
- Report Generation
- Data Quality Management
- Dashboard creation
- Data Warehousing
- Advanced Excel
- Predictive analysis
- Agile work processes
- Equipment procurement
- Project Leadership
- People Management
Tools
- SAP - CRM
- SAP - ECC
- SAP - HANA
- SAP - Ariba
- JIRA
- POWER BI
- TABLEAU
- SQL Server
- Starburst Enterprise
Timeline
Data Analytics Manager
Omnicom media group
10.2023 - Current
Manager of Operations & Analytics
Genpact India Pvt Ltd
02.2020 - 10.2023
Procurement & Data Specialist
SoftwareOne India Pvt Ltd
07.2018 - 02.2020
Customer Service Representative
Agilent Technologies Pvt Ltd
04.2014 - 07.2018
Technical Research Intern
Council of Scientific & Industrial research
05.2012 - 03.2014
Bachelor of Technology - Information Technology
Baldev Ram Mirdha Institute of Technology
Similar Profiles
Harleen KaurHarleen Kaur
Regional Client Lead at Ptarmigan Media (Part of Omnicom Media Group)Regional Client Lead at Ptarmigan Media (Part of Omnicom Media Group)
Sahil VermaSahil Verma
Associate Director at PHD Media - Omnicom Media GroupAssociate Director at PHD Media - Omnicom Media Group
Olivia BeringerOlivia Beringer
Senior Research Director at PHD Media, Omnicom Media GroupSenior Research Director at PHD Media, Omnicom Media Group
Deepayan MaitraDeepayan Maitra
Lead Designer Trainer, Lead Designer Digital, Subject Matter Expert at Annalect - Omnicom Media GroupLead Designer Trainer, Lead Designer Digital, Subject Matter Expert at Annalect - Omnicom Media Group
Neeraj KumarNeeraj Kumar
Business Head at Supermarket Grocery Supplies Pvt. Ltd (Big Basket)Business Head at Supermarket Grocery Supplies Pvt. Ltd (Big Basket)