Saurabh Srivastava
Assistant Manager IT
New Delhi
Summary
Results-driven IT Project Manager and Data Analyst with over 6 years of experience delivering digital transformation projects, executive dashboards, and integrated communication systems across public sector and global IT environments. Adept at managing end-to-end project lifecycles using Agile methodologies, Jira, Power BI, and Excel. Proven ability to bridge business and technical teams, lead vendor negotiations, support IT audit responses, and drive performance through data-led insights. Experienced in understanding and interpreting SOC 1/2 reports and ISO 27001 audit requirements. Known for reviving stalled projects by identifying bottlenecks and mobilizing teams to restore progress. Successfully implemented digital transformation by automating manual approval notes and HR processes. Currently pursuing an MBA in Business Analytics from BITS Pilani.
Overview
7
7
years of professional experience
7
7
years of post-secondary education
5
5
Certifications
Work History
Assistant Manager – IT
Balmer Lawrie & Co. Ltd.
01.2022 - Current
- Company Overview: Govt. of India Public Sector Enterprise
- Spearheaded digital transformation initiatives including Power BI dashboards and internal communication systems across departments.
- Automated manual approval note processes and HR workflows, reducing approval turnaround time and improving process transparency.
- Designed 10+ interactive dashboards used for ministry-level reviews, improving decision-making efficiency.
- Automated WhatsApp, SMS, and email workflows via API integrations, reducing manual workload by 35%.
- Administered Jira projects: customized workflows, user roles, sprint boards, and dashboards.
- Led IT procurement cycles for M365, SQL Server, SSL Certificates, aligning with GEM and internal compliance protocols.
- Facilitated stakeholder workshops, UAT sessions, and prepared test cases for new system rollouts.
- Developed Excel-based financial models for CAPEX/REVEX tracking, enhancing budget visibility.
- Coordinated responses to IT audits and internal compliance reviews; interpreted SOC 2 and ISO 27001 audit feedback.
- Regularly assigned to stalled or delayed projects; identified blockers, restructured plans, and brought initiatives back on track.
Associate Consultant
Capgemini Technology Services India Ltd
08.2018 - 01.2022
- Acted as liaison between US-based BFSI client and offshore Salesforce teams for CRM enhancements.
- Created BRDs, user stories, and change requests through business requirement sessions.
- Maintained Jira sprint logs, facilitated backlog grooming, and tracked deliverables.
- Built Salesforce and Excel dashboards for regulatory and KPI reporting.
- Automated monthly reporting workflows via Excel Macros and formulas, saving significant analyst hours.
- Supported training and documentation for CRM adoption across business units.
Education
MBA - Business Analytics
Birla Institute of Technology and Science (BITS)
01.2025 - 01.2027
Post Graduate Diploma - Operations Management
Indira Gandhi National Open University
01.2020 - 01.2021
Bachelor of Technology - Computer Science Engineering
Dr. A.P.J. Abdul Kalam Technical University
01.2014 - 01.2018
Skills
- IT Project Management (Agile/Scrum, Jira Administration)
- Power BI Development (DAX, Power Query, Data Modeling)
- Business Analysis & Requirements Gathering
- KPI Reporting & Performance Dashboards
- Excel (Pivot Tables, Power Query, VBA, Macros)
- Vendor & Contract Management (GEM, RFP, Procurement)
- Stakeholder Communication & Executive Reporting
- IT Audit Coordination, SOC 1/2/3 & ISO Certificate Understanding
- Project Recovery & Team Mobilization
- Business Process Automation (Approval Notes, HR Workflows)
- Tools: Jira, Power BI, Excel, Salesforce, SQL Server
- API Integration SMS API, Email and Whatsapp Business API
Certification
Salesforce Certified Administrator
Projects And Achievements
- Developed Power BI dashboards aligning actual vs target KPIs for ministry reviews.
- Built Excel & Power BI models for real-time CAPEX usage tracking.
- Streamlined internal communication channels by automating approval processes, significantly reducing delays previously caused by manual interventions.
- Commissioned Jira across the organisation, onboarding over 50 users and designing tailored workflows to track IT projects effectively and enable Agile delivery with defined issue types, permissions, and role-based access.
- Participated in internal IT audits and supported the compilation of control evidence.
- Revived multiple delayed or stalled projects by implementing structured review mechanisms and cross-functional collaboration.
- Implemented digital workflows replacing manual approval notes and HR requests, significantly improving operational efficiency.
Timeline
MBA - Business Analytics
Birla Institute of Technology and Science (BITS)
01.2025 - 01.2027
Assistant Manager – IT
Balmer Lawrie & Co. Ltd.
01.2022 - Current
Post Graduate Diploma - Operations Management
Indira Gandhi National Open University
01.2020 - 01.2021
Associate Consultant
Capgemini Technology Services India Ltd
08.2018 - 01.2022
Bachelor of Technology - Computer Science Engineering
Dr. A.P.J. Abdul Kalam Technical University
01.2014 - 01.2018
Similar Profiles
Chandan kumar GogoiChandan kumar Gogoi
Assistant Manager(Project In-charge) at M/S Balmer Lawrie & Co.ltdAssistant Manager(Project In-charge) at M/S Balmer Lawrie & Co.ltd
Adrija BanerjeeAdrija Banerjee
Assistant Manager - Sales and Key Accounts Manager at Balmer Lawrie & Co. Ltd - Vacations ExoticaAssistant Manager - Sales and Key Accounts Manager at Balmer Lawrie & Co. Ltd - Vacations Exotica
BIPIN SATHYANBIPIN SATHYAN
Asst, Manager_HSE at Balmer Lawrie LLCAsst, Manager_HSE at Balmer Lawrie LLC
Ankit TanejaAnkit Taneja
Founder at Uphaar - Roohani EnterprisesFounder at Uphaar - Roohani Enterprises
Ajit SinghAjit Singh
Financial Modeling Student(Internship) at InvactFinancial Modeling Student(Internship) at Invact