Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Aditya Chatterjee

Aditya Chatterjee

Technical Delivery Manager | Business Analyst | Solution Designer
Kolkata

Summary

With over 13.8 years of experience in IT, software, and telecom, expertise lies in MS SQL Server, T-SQL, ETL, and PL/SQL. Extensive knowledge of Oracle technologies such as Hyperion, OBIEE, and ODI is also demonstrated. Throughout a career in the HR, Finance, and Telecom domains, the focus has been on data warehousing, ETL, and data modeling. Certifications as a Professional Scrum Master, in Azure Fundamentals, and as an AWS Cloud Practitioner validate these skills. In various roles including Finance SME, Database Programmer, and Business Analyst, teams have been successfully led, projects managed, and data-driven solutions delivered. Excellence in both client-side and offshore environments is maintained, with a proven track record in knowledge/vendor transition and adherence to ITIL processes.

Overview

1825
1825
years of professional experience
5
5
years of post-secondary education
8
8
Certifications
3
3
Languages

Work History

Assistant Consultant

TATA CONSULTANCY SERVICES LTD.
Kolkata
03.201 - Current

Project 7: GFP R12 upgrade

Customer: British Telecom Plc

Work Location: Kolkata, India

Period: Oct 2024 – Current

Role: Technical Delivery Manager and Coordinating with Third Party System Oracle and Spinnaker

  • Overseeing technical delivery and managing stakeholder and third-party communications with Spinnaker and Oracle.
  • Ensuring successful project cutovers and seamless integration of new systems.

Project 6: Insight Driven Analysis with Digital Workplace

Customer: British Telecom Plc

Work Location: London, UK

Period: Jan 2024 – Oct 2024

Role: Business Analyst and Solution Design

(Oct 2023 – 2024, London, United Kingdom):

  • Conducted in-depth data analysis to provide actionable insights for business and help in decision-making to reduce Capex.
  • Worked closely with stakeholders to understand their needs and deliver tailored analytical solutions.
  • Built a solution in Azure Fabric with various integrating systems.

Project 5: BT – Group HR Reporting and Analytics
Customer: British Telecom Plc
Work Location: London, UK
Period: Dec 2021 – Dec 2023
Role: Database Programmer, Reporting and Analytics

Description:

Solution Designing:

  • Collaborated with the People Reporting and Analytics team to design data solutions for BT’s reporting needs.
  • Worked with the Better Workplace Programme to ensure consistent delivery of data requirements.
  • Supported the design of new data architecture and SAP SuccessFactors configuration for reporting and analytics.

HR Database Management:

  • Managed database changes and operational processes to maintain reliable data.
  • Documented database design and management processes.
  • Partnered with Technology support teams for system maintenance and data integration.
  • Ensured compliance with BT security protocols and data controls, including GDPR.

Data Extraction:

  • Managed regular data extracts for applications like HR Reporting, BWP solution, Anaplan, and Orgvue.
  • Automated data extracts for efficiency.
  • Developed complex MS SQL code for new data requests.
  • Guided the People Reporting and Analytics team in managing data queries and extraction.

Data Integrity:

  • Actively managed data transformations to ensure integrity.
  • Identified and addressed data quality risks and issues.
  • Recommended changes to data definitions and requirements for consistent and trusted reporting.

Project 4: BT – Group Finance
Customer: British Telecom Plc
Work Location: Kolkata (TCS offshore) / London, UK
Period: April 2015 – Sep 2021
Role: Technical Lead – R2R (Record to Report)

Description: BT Group Finance Subject Matter Expert on Reporting

Responsibilities:

  • Ensured Period End closure for all books and smooth Month End operations.
  • Managed organization reorganizations and major changes within the business.
  • Handled balance cutovers (reinstatement) and application migrations.
  • Provided module-specific reporting for AP, AR, and PO.
  • Addressed external auditor data and queries for Year End.
  • Ensured ICOFR (SOX) compliance.
  • Supported forecast cycle, budget, and actual reporting.

Solution Environment:

  • Linux Server, Windows Server, SharePoint
  • Oracle ERP 11.5.10
  • Hyperion Planning & Essbase
  • PL/SQL, ETL, ODI, OBIEE
  • Oracle 10g, 12c
  • ITIL Process
  • XFB (File Transfer)

Project 3: BT – Trouble Management & Workflow (Service Assurance/Fulfilment & Engineering Excellence)
Customer: British Telecom Plc
Work Location: Chennai (TCS offshore) / Cardiff, UK
Period: April 2013 – Till Date
Role: Team Lead

Description:
Managed the Trouble Management & Workflow Platform, ensuring 100% uptime for critical applications like OR NEO, WS NEO, SUMO, and COP, which support BT’s Service Assurance and Fulfilment across various lines of business.

Responsibilities:

Operational Management:

  • Led a team to provide 24x7 IT support, ensuring high standards and meeting SLA targets.
  • Ensured infrastructure recoverability, security, configuration, capacity, continuity, and performance.
  • Managed 2nd Line application support, including technical service support, incident recovery, and proactive service improvement.

Leadership and Strategy:

  • Drove operational and transformation strategy, fostering a high-performance culture.
  • Provided leadership for ASM (2nd Line Support) operational service.
  • Contributed to transformational strategy, setting targets for productivity and cost efficiency.
  • Promoted a culture of excellence, focusing on exceeding customer expectations.

Relationship Management:

  • Managed relationships with key stakeholders, including BTO AS&M Management, BTID Platform Directors, and BTO SM CSOC.
  • Ensured application deployment met QOS targets and was fit for purpose.
  • Maintained working relationships with Service Assurance Service Directors and Service Introduction Leads to ensure platform stability and resilience.

Project 2: Infrastructure and Integration Platform
Customer: British Telecom Plc
Work Location: Chennai (TCS Offshore)
Period: Aug 2011 – Mar 2013
Role: Application Support Team Member

Description:
Supported BT’s integration infrastructure platform, which facilitates efficient integration of capabilities/services across business domains, legacy applications, and external partners.

Solution Environment:

  • Linux, Solaris, Windows
  • Oracle 11g, Oracle Fusion Middleware
  • ZXTM (ZEUS), Cyclone
  • WebLogic 8.1, WebLogic 11G

Highlights:

  • Provided application support to production systems.
  • Monitored Linux and UNIX servers.
  • Conducted capacity planning and impact analysis before major configuration changes.
  • Liaised with customers for production issues.
  • Provided 24x7 system support.
  • Automated processes and performed troubleshooting and analysis.
  • Conducted performance testing and managed major releases.

Project 1: ILP Delivery
Customer: TCS Internal
Period: 21st March 2011 – 21st May 2011
Role: Team Member, Trainee

Description:
Participated in the Initial Learning Program to gain basic knowledge of software processes and receive training in computer domains and foreign languages.

Solution Environment:

  • Windows, Unix, Linux
  • SQL, Java, J2EE

Highlights:

  • Acquired foundational knowledge of software processes.
  • Completed basic training in various computer domains and foreign languages.

Work Location: TCS – Ambattur, Chennai

Additional Skills and Achievements:

  • Delivered high-quality presentations showcasing project progress and results, enhancing client confidence in our services.
  • Managed multiple projects simultaneously while maintaining meticulous attention to detail and meeting strict deadlines.
  • Improved client satisfaction by providing thorough and timely project updates and addressing concerns promptly.
  • Adapted quickly to changing project priorities and job specifications with analytical thinking and task prioritization skills.
  • Mentored junior team members, contributing to their professional growth and development within the company.
  • Implemented best practices in project management methodologies, driving consistency across all engagements.

Scheduled and chaired meetings for all relevant stakeholders, whether in-person or via Teams.

Education

Bachelor of Science - Computer Science

WEST BENGAL UNIVERSITY OF TECHNOLOGY
West Bengal, India
07.2006 - 06.2011

Skills

MS SQL 2016

MS Fabric

T-SQL

Power BI

PL/SQL

Qlik

Python

Solution Design

PowerShell

SharePoint online

LINUX

Windows

Oracle9i,10g, 12C

Hyperion Essbase, Planning

Oracle ERP 11510

OBIEE, ODI

OBIEE

WebLogic

Certification

Weblogic 10 G

Timeline

Oracle Pl/SQL

09-2023

AWS Certified Cloud Practitioner

08-2021

Microsoft Azure Fundamentals

06-2020

PSM 1

05-2018

ITIL 2011 Foundation Certification

01-2017

Oracle Business Intelligence Foundation Suite 11 Essentials (17020)

02-2016

Weblogic 11 G

01-2015

Weblogic 10 G

01-2012

Bachelor of Science - Computer Science

WEST BENGAL UNIVERSITY OF TECHNOLOGY
07.2006 - 06.2011

Assistant Consultant

TATA CONSULTANCY SERVICES LTD.
03.201 - Current
Aditya ChatterjeeTechnical Delivery Manager | Business Analyst | Solution Designer