Advanced Excel
Ankit Srivastava
Manager - Data Analytics
Jaipur,Rajasthan
Summary
Resourceful Project Manager with 12 years of expertise in organizing business operations and managing datasets. Having extensive exposure in data analysis and generating insights, gained vast experience working into MIS for multiple large-scale organizations. Excels in generating insights and resource management. Possesses a keen eye for learning.
Comes with Prince2 Project Management Certification; Proven Project Management and Resource Management skills, having handled projects single handedly as well as managing teams. Work experience includes Health & Development, Pharma, Manufacturing & Marketing, Consumer Healthcare, Telecom and Financial domains.
Overview
13
13
years of professional experience
6
6
years of post-secondary education
3
3
Certifications
Work History
Project Manager
08.2021 - 12.2021
- Management of Community based HIV Testing and Linkages in India Aimed towards improving and contributing to achieve the goal of accelerating the reversal of HIV epidemic in the states of India, Palladium is reaching out at the targeted key population and communities to accelerate HIV testing, counselling, and linking to the Integrated Counselling and Testing Centre (ICTC) for treatment and care services in 19 sites of 16 districts spread over 9 selected states of India. My role in this project involves:.
- Manage the overall project and achieve key deliverables.
- Creation of a data model which helps in bringing out the key information based on input data from various sites.
- Developing a data management system which is usable by field teams having minimal data reporting skills.
- Forecasting the testing and sero positivity figures to identify the opportunities and fill the gaps using predictive analysis.
Manager
Palladium Consulting Pvt. Ltd
06.2019 - 08.2021
- Utkrisht DIB is first of such kind of initiative globally, where working with our global partners (UBS, USAID, Merck for Mothers), Utkrisht DIB bond addresses Maternal and Neonatal care.
- My profile required coordinating with stakeholders and real-time performance monitoring on the field level – collating and integrating data from various sources and various formats, cleaning and normalizing them, aligning them to create a database and use for qualitative analysis.
- Creation of a robust information system – developing ‘Utkrisht Weekly Dashboard’, which provides the role-based information to all the stakeholders along with key analysis.
- Creating automated reports using VBA, custom reports, and ad-hoc analysis: creating custom SQL queries to extract data for analysis, creating automated reports using VBA.
- Development of VBA based dashboard.
- Using Power BI for creating dynamic reports for field teams to find the gaps and opportunities.
- Raw data for the report is fetched from the SQL server and excel reports.
- Working as an individual contributor and supporting the global team for data and analytics queries.
- Designing the standard data protocol for the process and development of the automated data entry templates.
Project Manager - Tele Medicine Project
Palladium Consulting
Jaipur, RJ
08.2020 - 04.2021
- Tele-Medicine Project.
- The project started with the aim of contacting the pregnant and lactating women and counseling them for Ante-Natal and Post-Natal care amid the coronavirus pandemic.
- As a Project Manager, I opted a data-centric approach and digitalized systems of Data Collation, Data Storage and Data Analysis.
- The Feedback mechanisms in-place to the ensure that there is a continuous improvement plan.
- Clinical guidance and consultations were arranged through our empanelled Doctors.
- Promoting access to healthcare through remote mode for presumptive, prophylactic and curative treatment.
- We emphasized on better connect with the patient, as it helped patients feel more comfortable in sharing their problems.
- Soft skills and communication were given the utmost priority and counsellors were trained on communicating with empathy and assurance while doing the probing whenever required.
- Overall, we counselled more than 18,000 beneficiaries on COVID prevention while more than 3000 patients were connected to the doctor who needed critical attention.
Consultant
Delta Group
Jaipur, RJ
04.2018 - 10.2018
- Delta Intelitech is an Analytics and Project Management Consulting firm. As an external consultant, I was involved in developing the business models and create their GTM strategies.
- Based in Delhi, I was involved in client liasoning and creating data models. Also provided expertise in database management
- Creation of Power BI based dynamic reports
- Set up ‘DeltaWeb Solutions’, which is a dedicated arm for web solutions and digital marketing
Business Analyst
Optiemus Infracom
Noida, UP
07.2017 - 05.2018
- Being India’s leading smart phone distributors and mobile phone manufacturers, Optiemus Infracomm provided me an opportunity to explore Indian & Global consumer market.
- Led the Market Research and various sales campaigns with a mix of quantitative and qualitative approach
- Roadmap for shifting sales strategy from General trade to modern trade
Reporting to Company Chairman, directly involved with Directors, Vertical Heads and VPs in strategy making for revamp of Brand Blackberry - Worked with CyBex and Statista for insights on Indian Telecom Market for handset users
- Established ‘Reporting & Analytics’ team with tools like Qlik-view and Power BI
Carried out in-depth market analysis for Blackberry re-launch in India with its flagship brand ‘KeyOne’ - Introduced the automated sales performance dashboard and business review report
- Automated reports for HR; integrating HRMS with excel dashboards
Assistant Manager (Lead Analyst)
WNS Global Services
05.2013 - 06.2017
- Conducting competitor Analysis, Risk analysis, Forecasting and ad-hoc analysis
Led the project from Analytics team for the compatibility and feasibility analysis of Novartis and GSK CH merger, which became #1 in Global Consumer Healthcare; also, later involved in smooth transition of reports. Received “Earl of KC”, the highest individual award in KC for the same - Creating new reports and dashboards, performing UAT and implementation
Data manipulation - re-working existing information in Excel, merging data sets, removing duplication, data cleaning - Managing resources in achieving project targets. Resource planning and scheduling as per 24/5 model
- Analyzing and enriching critical data using Advanced Excel, Qlik-sense & Spotfire
Lead Analyst
HCL Technologies Ltd
Noida, UP
10.2008 - 05.2013
- Developed HCL Penalty/Bonus Dashboard: One of the most critical dashboards that showcase revenue leakages, penalty/bonus predictions and billing forecast for different processes of HCL BServe. Received best Dashboard award across India for the same.
- Worked as a Business Analyst for leading global telecom players, AT&T Corporation and British telecom
- As an SME, helped in the revolution of teams and providing more exposure to my team
- Coordinating with the Stakeholders and Marketers of various geographies
- As a Team lead, received the several accolades for leadership
- Worked closely with the PM in preparation of the QBR (Quarterly Business Review) presentations and Strategic Planning and execution
Education
B. Tech - IT
UPTU
ABES Engineering College 08.2004 - 06.2008
10+2 -
U.P. Board
UP 07.2000 - 06.2002
Skills
Resource Management
Software
VBA Coding
Power BI
Tableau
Nielson Answers
SQL queries
IMS Data Viewer
Python
Certification
Prince2 Project Management
Interests
Driving
Sports
Reading
Timeline
Project Manager
08.2021 - 12.2021
Prince2 Project Management
06-2021
Project Manager - Tele Medicine Project
Palladium Consulting
08.2020 - 04.2021
Power BI
02-2020
Manager
Palladium Consulting Pvt. Ltd
06.2019 - 08.2021
Tableau
07-2018
Consultant
Delta Group
04.2018 - 10.2018
Business Analyst
Optiemus Infracom
07.2017 - 05.2018
Assistant Manager (Lead Analyst)
WNS Global Services
05.2013 - 06.2017
Lead Analyst
HCL Technologies Ltd
10.2008 - 05.2013
B. Tech - IT
UPTU
08.2004 - 06.2008
10+2 -
U.P. Board
07.2000 - 06.2002
Similar Profiles
Emmanuelle GARDESEmmanuelle GARDES
Photographe indépendante at NAPhotographe indépendante at NA
Nathan BIGERNathan BIGER
Garde d'enfants at NAGarde d'enfants at NA
Delaney Degan-DiepDelaney Degan-Diep
Babysitter at NABabysitter at NA
Ella MetcalfElla Metcalf
Childcare at NAChildcare at NA
Kishore HingoraniKishore Hingorani
Vice President-Wealth at State Bank of IndiaVice President-Wealth at State Bank of India