Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Generic
Somesh Pandey

Somesh Pandey

Public Health & CSR Enthusiast
Bareilly

Summary

Public Health & CSR Enthusiast with a strong foundation in impact assessment, program management, and stakeholder engagement. Skilled in developing and evaluating sustainable CSR programs, public health interventions, and health policy research. Adept at using data-driven insights and stakeholder collaboration to drive social change and community empowerment.

Overview

3
3
years of professional experience
3
3
Certifications

Work History

Systems Engineer

Tata Consultancy Services Ltd
12.2016 - 11.2019
  • Developed a multi-layered data integration platform (Ingest, Persist, Access) to process standard XML feeds, replacing legacy systems for business users.
  • Executed complex change requests and integrated new data sources by updating Informatica PowerCenter workflows, Unix shell scripts, Oracle database schemas, and CA Workload Automation jobs.
  • Led the Test Data Services team, providing high-quality test datasets and performing XML parsing/generation for development and QA. Conducted impact analysis and optimized data flow across systems.
  • Technical tools: Informatica 9.5.1/10.1, Oracle, SQL/PL-SQL, Flat/XML files, TOAD, CITRIX, CAWA, UNIX, MS Office, Power BI.

Education

Master of Arts - Social Work

Tata Institute of Social Sciences
Mumbai, India
04.2001 -

Master of Arts - Public Administration

Indira Gandhi National Open University
New Delhi, India
04.2001 -

B.Tech - Electrical, Electronics And Communications Engineering

Birla Institute of Applied Sciences
Nainital, India
04.2001 -

Skills

    Impact assessment

    ESG compliance

    KPI development

    Program management

    Stakeholder coordination

    Monitoring and Evaluation

    Proposal Development

    Health policy

    Global Health

    Social Determinants of Health

    Epidemiology

    Health Management and Planning

    Health advocacy

    Quantitative and qualitative research methods

    MS Office Suite

    Advanced Excel

    Power BI

    Oracle

    SQL/PLSQL

    Logical Frameworks Approach

    Canva

    Assessment Planning

    Capacity Building

    Strategy Development

Accomplishments

  • Co-Convenor & School Representative, Career Development & Facilitation Committee (CDFC), TISS – Led placement and career development initiatives, facilitating student-employer engagement through networking events, career guidance sessions, and internship coordination.
  • Founder, first student-led newsletter at the School of Social Work, TISS – Developed content strategy, editorial guidelines, and alumni outreach efforts.
  • Lead Representative, Alumni Outreach Committee, TISS- Spearheaded the organization of alumni events and networking sessions, fostering strong ties between students and alumni.
  • Event Organizer, Box Cricket Tournament for National Sports Day, TISS- Managed all aspects of organizing a campuswide sports event, including logistics, team coordination, and fundraising for the event, ensuring participation from 250+ students across 7 sports.
  • Captain, TISS Inter-University Cricket Team – Led the team through inter-university competitions, focusing on team dynamics, performance analysis, and strategy development.
  • Cultural Secretary, Birla Institute of Applied Sciences – Organized and led college-wide cultural events, fostering student engagement and leadership development.
  • Vice Secretary, Spectrum - The Annual College Fest, Birla Institute of Applied Sciences – Managed event coordination, sponsorship outreach, and logistics for the institute’s flagship festival

Certification

How to Conduct a Social Impact Assessment with SROI

Timeline

How to Conduct a Social Impact Assessment with SROI

03-2025

Google Project Management: Professional Certificate

01-2025

Environmental and Social Framework (ESF)

12-2024

Systems Engineer

Tata Consultancy Services Ltd
12.2016 - 11.2019

Master of Arts - Social Work

Tata Institute of Social Sciences
04.2001 -

Master of Arts - Public Administration

Indira Gandhi National Open University
04.2001 -

B.Tech - Electrical, Electronics And Communications Engineering

Birla Institute of Applied Sciences
04.2001 -
Somesh PandeyPublic Health & CSR Enthusiast