Summary
Overview
Work History
Education
Skills
Technologies hands on
Visaholding
Education Summary
Certification
Languages
References
Timeline
Generic

Manish Pandey

Summary

Accomplished IT professional with over 19 years of experience in Lifesciences presales, nearshore operations management, and legacy to LCNC transformation programs as a Program Manager. Proven ability to lead large-scale data and analytics projects as a Technical Lead and excel as a Data Warehouse specialist. Strong strategic planning and operational coordination skills drive process improvements and enhance productivity. Recognized for building collaborative relationships across various organizational levels to achieve business objectives.

Overview

18
18
years of professional experience
1
1
Certification

Work History

Presales Manager (Lifesciences)

HCLTech
Mumbai
07.2024 - Current
  • Oversaw diverse scale strategic opportunities.
  • Managed end-to-end solution cycle including solution response, client sessions, and deep dives.
  • Prepared comprehensive opportunity briefs.
  • Built and briefed solution teams efficiently.
  • Participated in stride run efforts for numerous proposals.
  • Led briefings at the business unit level.
  • Maintained full adherence to process guidelines.
  • Conducted prompt risk assessments.
  • Demonstrated strong program management skills to align efforts.
  • Contributed to winning RFP and RFI strategies during proposals.
  • Ensured compliance with established presale procedures.
  • I do maintain knowledge of industry trends in the domain Research competition and updates on global market trends
  • I possess ability to drive proactive campaigns, articulating solution and value proposition and required to manage host prospect client visits

Presales Consultant (LifeSciences)

Tata Consultancy Services
Mumbai
07.2019 - 07.2024
  • Oversaw diverse scale strategic opportunities.
  • Managed end-to-end solution cycle including solution response, client sessions, and deep dives.
  • Prepared comprehensive opportunity briefs.
  • Built and briefed solution teams efficiently.
  • Designed robust database solutions to enhance overall data infrastructure.
  • Designed, deployed, and delivered end-to-end data architectures including Data Lakes, Warehouses, and Lakehouses.
  • Presales, estimating and proposal writing, responding to RFPs
  • Collaborated with clients to formulate data technology strategies.
  • Oversaw delivery team contributions.
  • Data modelling, design, and build
  • Participated in stride run efforts for numerous proposals.
  • Led briefings at the business unit level.
  • Maintained full adherence to process guidelines.
  • Conducted prompt risk assessments.
  • Demonstrated strong program management skills to align efforts.
  • Contributed to winning RFP and RFI strategies during proposals.
  • Ensured compliance with established presale procedures.
  • Maintain up-to-date knowledge of industry trends.
  • I possess ability to drive proactive campaigns, articulating solution and value proposition and required to manage host prospect client visits

Delivery Lead (Aetna Digital Portfolio)

Tata Consultancy Services Ltd.
06.2018 - 06.2019
  • Lead and manage digital team consists of LCNC (Outsystems Developers), SonarQube, GraphQL, Python/Ruby,Jira, Okta,Jenkins SMEs
  • Process Monitoring and Maintaining Risk Register
  • Planning, Design and get implemented automation of Security controls
  • Improving Delivery and monitoring effort Slippages
  • Ensuring Defect Free CICD Pipeline implementation and Operations
  • Planning and Managing hypercare
  • Mentoring team to adhere standard Agile/DevSecOps development practices
  • RAG/RAID Reporting to leadership
  • Monitoring and enforcement of Standard KPIs and Business XLAs

Operations Manager (LATAM Nearshore)

Tata Consultancy Services Ltd.
06.2017 - 06.2019
  • Escalation Management
  • Audit Management
  • Infrastructure Management
  • Resource management
  • Attrition’s control and associate engagement
  • Customer interactions and management
  • Segment level resource grooming and maintaining learning growth
  • Critical positions backfill and escalation management
  • Helping in new account establishment at location like GDC setup, Resourcing and support until smooth delivery

Technical Lead

Largest US Banking Client
11.2014 - 11.2017
  • Leading team of 8 developers
  • Responsible for application audit and legacy management
  • Resource and budget planning
  • Analyzing, Developing and fine-tuning oracle database stored procedures, functions and packages
  • Segregating and prioritizing the Features in PI planning and complete all the necessary enablers required to achieve the business functionalities
  • Make sure the environment availability for the development, code deployments and testing on time
  • Implementing business logic to analyses/parse diff EDI file formats like 822 (Account Analysis), BAI files (Cash Management
  • Balance reporting)
  • Developing user interface for entry and reporting deals and transactions by using oracle forms and reports
  • Analyze the changes to be done and create the design
  • Involved in Unit testing after implementation of requirement
  • Carry out comprehensive testing and test plan for changes in system
  • This is also used for logging and reporting the test plan
  • Production support of developed application
  • Involved in documentation which includes preparing requirement document, estimation and approach document for change request
  • Technologies used are Python,Netteza,Talend,Oracle Exadata,Oracle 11g,TFS,Autosys,CTRL+M etc.

Data Warehouse Specialists

Largest US Banking Client
06.2012 - 11.2014
  • Involved for requirement gathering from Client to develop new enhancements, process improvements
  • Creating the process flow chart to understand the business logic layer
  • Handling database designing
  • Maintaining database triggers to synchronize specific table data between various Oracle databases
  • Created database procedures and functions to capture all types of user and system activities and ad hoc feed generation reports
  • Carry out comprehensive testing and test plan for changes in system
  • This is also used for logging and reporting the test plan
  • Coordinating all development life cycle processes to be carried out in time successfully
  • Responsible for application customizations and support
  • Analyzing the root cause of issues and providing ETA for issue resolution to clients
  • Checking the application-level errors and implement modification in system according to user’s requirement
  • Fine tuning of packages, procedures, and triggers and materialized views
  • Responsible for carry out data migration activities, deliver extracts

Senior Developer

Nielsen Online
12.2010 - 06.2012
  • Developing oracle database stored procedures, functions and packages
  • Developing user interface for entry and reporting deals and transactions by using oracle forms and reports
  • Analyze the changes to be done and create the design
  • Involved in Unit testing after implementation of requirement
  • Carry out comprehensive testing and test plan for changes in system
  • This is also used for logging and reporting the test plan
  • Production support of developed application
  • Involved in documentation which includes preparing requirement document, estimation and approach document for change request
  • Responsible for mentoring new joiners

Technical Support Engineer

Reliance Communications
06.2007 - 06.2008
  • Day to day activity planning and understanding the issues / problems related to Telecom Billing Application
  • Preparing files for Migrations, MACDS in UNIX
  • Writing PLSQL procedures, functions, materialized view in regards to performance enhancement
  • Using ADC and Clarify CRM developing tools for the Billing CDU team
  • Technical Assistance for the Billing Operations
  • All kinds of Error management
  • Responsible for MIS & Report generation activities
  • Resolved the issues related to National Roaming, World, R-Connect
  • Error rectification and Resolution of Errors of Prebill Observation sent by QAQC Team within certain duration of receipt/identification of Errors
  • Analyse data, rectifying the same by MACD & Run prebill tool application
  • Co-ordination with different teams like mediation, provisioning, QAQC, Bill Run, Phonegen, DBA & System admin etc
  • For issues/errors resolutions
  • Working knowledge of Rating Error analysis, rectifications, escalation to respective team, follow-ups & resolutions & reprocessing
  • Working knowledge of Re-rating & revoking of the incorrectly rated CDR’s
  • Resolved the cases related to Rate plans
  • Perform Error CDR (call data record) cases

Education

PGDFM -

Mumbai University
11.2024

M.Sc. - Information Technology

Mumbai University
01.2023

B.Sc. - Information Technology

Mumbai University
01.2013

Diploma in Computer Engg. -

Vidyalankar Polytechnic
Mumbai
06-2005

HSC - Mathematics

UP Board
01.2002

Skills

  • Project Management
  • Stakeholder Engagement
  • Data Analytics Solution Development
  • AMS Solution Development
  • Estimation
  • P&L Management
  • Delivery and Operations Management
  • Vendor management
  • Expectation setting
  • Relationship building
  • Conflict resolution
  • Clear communication

Technologies hands on

Python, Jupyter,Snowflake, Spark, Pandas,Numpy,Scikit-larn, PowerBI, Jenkins, Docker,Oracle SQL, PL/SQL,

 HP Project and Portfolio Management Center, MS PROJECT, HP PPM, FIELD GLASS, JIRA, Team Foundation Server 2010, Toad for Oracle, PLSQL Developer, SQL Navigator, Putty 0.6, Autosys,Windows, Linux, Ubuntu, Unix, 

Visaholding

  • Mexico Permanent Residency
  • USA B1/B2, 12/31/27

Education Summary

  • PGDFM, Mumbai University, Pursuing
  • M.Sc. In Information Technology, Mumbai University, 2023
  • B.Sc. In Information Technology, Mumbai University, 2013
  • Diploma in Computer Engg., Vidyalankar Polytechnic, 2005
  • HSC Mathematics, UP Board, 2002

Certification

•Ambassador Corps Nov’ 23 (Wave 57), TCS-Mercuri International Sales Leadership program

•Business 4.0 Dojo for leaders (10 Days Long Cloud, DevOps 360°, AI /ML Hands-on training)

•Power BI Associate Certification (PL300)

•Microsoft Azure Data Scientist Associate (DP100),

•Microsoft Azure Fundamental (AZ900),

•Azure Data Fundamental Certifications (DP900)

Languages

Hindi
First Language
English
Upper Intermediate (B2)
B2
Spanish
Intermediate (B1)
B1

References

References available upon request.

Timeline

Presales Manager (Lifesciences)

HCLTech
07.2024 - Current

Presales Consultant (LifeSciences)

Tata Consultancy Services
07.2019 - 07.2024

Delivery Lead (Aetna Digital Portfolio)

Tata Consultancy Services Ltd.
06.2018 - 06.2019

Operations Manager (LATAM Nearshore)

Tata Consultancy Services Ltd.
06.2017 - 06.2019

Technical Lead

Largest US Banking Client
11.2014 - 11.2017

Data Warehouse Specialists

Largest US Banking Client
06.2012 - 11.2014

Senior Developer

Nielsen Online
12.2010 - 06.2012

Technical Support Engineer

Reliance Communications
06.2007 - 06.2008

PGDFM -

Mumbai University

M.Sc. - Information Technology

Mumbai University

B.Sc. - Information Technology

Mumbai University

Diploma in Computer Engg. -

Vidyalankar Polytechnic

HSC - Mathematics

UP Board

Similar Profiles

CREATE PROFILE
Manish Pandey