Summary
Overview
Work History
Education
Skills
Certification
Timeline
BusinessAnalyst

DEEPAK SINGH MEHRA

Homebush,Australia

Summary

Accomplished Business Analyst with a robust history at Tata Consultancy Services, adept in project management and data analysis. Excelled in driving efficiency improvements and system enhancements, notably in legislative changes and migration projects. Proven leadership as a Technical Lead, blending decision-making prowess with technical expertise to deliver impactful solutions.

Overview

18
18
years of professional experience
1
1
Certification

Work History

Business Analyst

Tata Consultancy Services
03.2017 - Current

Project - Trust System (BT Financial Group)


  • Working with customers to formulate and document business requirements
  • Identifying, investigating and analyzing business processes, procedures and work practices
  • Identifying and evaluating inefficiencies and recommending optimal, business practices, system functionality and behaviour
  • Creating user and training documentation, and conducting formal, training classes
  • Developing functional specifications for use by system developers
  • Using data and process modelling techniques to create clear system specifications for the design and development of system software
  • Acting as a central reference and information source, providing guidance and assistance in the system project decision making process
  • Review Test plans, which ensure acceptable quality and integrity of the system
  • Handled Legislative & Regulatory Changes/projects (Protect your Super, Covid19 early release of super, temporary reduction in minimum pension drawdown, member contributions age update, Design & distribution obligations, AIIR reporting etc) for BT Financial group major registry system TRUST
  • Handled multiple migration projects (Pendal, Budgie and FAA)

Technical Lead

Tata Consultancy Services
10.2014 - 03.2017

Project - Trust System (BT Financial Group)


  • Consulting, assessing, and analyzing IT business requirements
  • Performing Impact Analysis of complex technical application changes within the application
  • Conducting internal and Peer reviews of all deliverables
  • Writing, updating, and maintaining technical programs, technical documentation, end user documentation and operational procedures
  • Developing, testing, and delivering Superannuation solutions using COBOL and DCL
  • Tracking and updating assigned tasks, defects, and change request
  • Performance tuning in Sybase queries and in the application components
  • Fixing bugs and implementing the CRQ based as per priority
  • Preparing ad hoc queries reports for both technical and business teams
  • Developing Intact screens
  • Provide technical support to Development/Enhancements
  • Coaching and mentoring junior programmers

Senior Developer

Tata Consultancy Services
05.2014 - 10.2014

Project - Trust System (BT Financial Group)


  • Consulting, assessing, and analyzing IT business requirements
  • Identifying technology limitations and deficiencies in existing systems and associated processes, procedures, and methods
  • Acting as Point of Contact for the customer IT Team; Bridging and Balancing multiple teams involved in the Project for smooth and defect free delivery; Representation in Project meetings; Conducting peer reviews of the project deliverables
  • Writing, updating, and maintaining technical programs, technical documentation, end user documentation and operational procedures
  • Developing, testing, and delivering Superannuation solutions using COBOL and DCL
  • Participating in the Design / Data model Discussions
  • Coordinating of multiple large-scale releases
  • Provide technical support to Development/Enhancements

Senior Developer

Tata Consultancy Services
09.2012 - 05.2014

Project – ABN AMRO Bank Netherlands


  • Writing, updating, and maintaining technical programs, technical documentation, end user documentation and operational procedures
  • Developing, testing, and delivering commercial client solutions for Banking using COBOL and JCL
  • Participating in the Design / Data model Discussions
  • Coordinating of multiple large-scale releases
  • Conducting internal and Peer reviews of all deliverables
  • Fixing bugs and implementing the CRQ based as per priority
  • Investigate root cause analysis for frequent reoccurring incidents and fix them permanently
  • Tracking and updating assigned tasks, defects, and change request
  • Decommissioning of the obsolete banking applications
  • Performance tuning in DB2 and IMS queries
  • Provide technical support to Development/Enhancements
  • Coaching and mentoring junior programmers

Developer

Tata Consultancy Services
01.2010 - 09.2012

Project – ABN AMRO Bank Netherlands


  • Consulting, assessing, and analyzing IT business requirements
  • Identifying technology limitations and deficiencies in existing systems and associated processes, procedures, and methods
  • Acting as Point of Contact for the customer IT Team; Bridging and Balancing multiple teams involved in the Project for smooth and defect free delivery; Representation in Project meetings; Conducting peer reviews of the project deliverables
  • Writing, updating, and maintaining technical programs, technical documentation, end user documentation and operational procedures
  • Developing, testing, and delivering commercial client solutions for Banking using COBOL and JCL
  • Participating in the Design / Data model Discussions
  • Coordinating multiple large-scale releases

Developer

Tata Consultancy Services
11.2006 - 01.2010

Project – ABN AMRO Bank Netherlands


  • Writing, updating, and maintaining technical programs, technical documentation, end user documentation and operational procedures
  • Performance tuning in DB2 and IMS queries
  • Fixing bugs and implementing the CRQ based as per priority
  • Preparing ad hoc queries reports for both technical and business teams
  • Conducting internal and Peer reviews of all deliverables
  • Unit testing, debugging, diagnosing, and correcting errors and faults in applications programming languages within established testing protocols, guidelines, and quality standards to ensure programs and applications perform to specifications

Education

Master of Computer Application -

Madan Mohan Malviya Engineering College
Gorakhpur, Uttar Pradesh
06.2006

Bachelor of Science - undefined

Motiram Baburam Government Post Graduate College
Haldwani, Uttarakhand
05.2002

Skills

    Domain Expertise:
    Legislation and Regulatory Banking and Finance Experience in Superannuation, Regulatory reports, Commercial Banking and Pension

    Technical Languages:
    COBOL, SQL , JCL, DCL, DTR

    Tools:

    MS Office, Rapid SQL, Sybase, HP, Quality Center QC, Microsoft Visio, JIRA, Confluence, Google Docs, IBM mainframes DB2, Service Now

    Paradigms :
    SDLC Waterfall Model, Agile Software Development

Certification

  • ScrumMaster Certification (CSM) - Scrum Alliance.
  • Certificate IV in Superannuation (ASFA100) course
  • Microsoft Certified: Azure Fundamentals

Timeline

Business Analyst

Tata Consultancy Services
03.2017 - Current

Technical Lead

Tata Consultancy Services
10.2014 - 03.2017

Senior Developer

Tata Consultancy Services
05.2014 - 10.2014

Senior Developer

Tata Consultancy Services
09.2012 - 05.2014

Developer

Tata Consultancy Services
01.2010 - 09.2012

Developer

Tata Consultancy Services
11.2006 - 01.2010

Bachelor of Science - undefined

Motiram Baburam Government Post Graduate College

Master of Computer Application -

Madan Mohan Malviya Engineering College
DEEPAK SINGH MEHRA