DEBOJYOTI BANERJEE
Site Reliability Engineer || Technical Lead || Automation First || AI enthusiast
Unix and shell scripting
Python programming
Ab Initio
.Net and C#
Oracle, PLSQL
Professional Status
Employed
Available
About Me
Worked as an Application Support Technical Lead with over 5 years of experience in Production Management. Specialized in maintaining system reliability, process automation through batch scripting, and optimizing infrastructure performance. Proficient in Incident Management, Problem Management, Batch Management, Change Management, Root Cause Analysis (RCA) and Disaster recovery Management for Continuity of Business.
Worked extensively in data processing and reporting automation tasks using Python and Shell scripting.
Having sound knowledge in Python for data science concepts, used Pandas and NumPy Python libraries for data manipulation and analysis requirements.
Around 5+ years of experience in Ab Initio ETL data processing Business Intelligence projects under Banking and Finance domain having sound
knowledge in Co>Operating system, EME, GDE, Transform components, Data parallelism, Control Center and other Ab Initio products.
Experienced in writing Oracle SQL Queries, Stored procedures, functions, packages, tables, views, triggers.
With excellent communication skills having experience in Incident and Problem management using ServiceNow and JIRA tools.
Experienced in handling client escalations by providing instant workaround solutions and driving permanent fix by collaborating with multiple teams.
Worked extensively in data processing and reporting automation tasks using Python and Shell scripting.
Having sound knowledge in Python for data science concepts, used Pandas and NumPy Python libraries for data manipulation and analysis requirements.
Around 5+ years of experience in Ab Initio ETL data processing Business Intelligence projects under Banking and Finance domain having sound
knowledge in Co>Operating system, EME, GDE, Transform components, Data parallelism, Control Center and other Ab Initio products.
Experienced in writing Oracle SQL Queries, Stored procedures, functions, packages, tables, views, triggers.
With excellent communication skills having experience in Incident and Problem management using ServiceNow and JIRA tools.
Experienced in handling client escalations by providing instant workaround solutions and driving permanent fix by collaborating with multiple teams.
Assistant consultant | Application Support Specialist | Business Intelligence Lead
Tata Consultancy Services Ltd.
Since November 2021
- Deputed to Mexico to grow business at Near shore location with expertise in handling client requirements and adding members to projects.
- Managing Service life cycle per ITIL methodologies for all core service management areas including Incident, Change, Problem, Capacity, Configuration and Service Improvement using ServiceNow. Helped in resolving critical application performance or data quality related issues by proper root cause analysis (RCA) avoiding major incident tagging. Helped with regular change management process working with Development teams.
- Instantly acknowledging batch failure issues and working on resolution by checking batch logs and debugging scripts. Analyzed issues and provided instant workarounds, raising Problem tickets for permanent resolution.
- Trained multiple trainees in Unix, PLSQL, Python programming and Ab Initio ETL tool to help deploy in projects across CITI.
- Worked on gathering automation requirements and implementation of the same using Python and shell scripting.
- Wrote Python scripts to analyze data variance in different banking products using trades or accounts as unique identifiers in order to predict issues in data processing.
- Managing a 14-member team that works on application support and maintenance activities for various CITIBANK projects.
IT Analyst | Data Engineer
Tata Consultancy Services Ltd.
July 2018
to November 2021
- Worked as a Python cum Ab Initio ETL developer to automate solutions in various CITIBANK projects.
- Worked on design and development Ab Initio plans as part of the ETL process to automate the process of loading.
- Worked on File Transfer Protocols to push or pull data and loading into output files or database tables.
- Wrote Python and batch scripts to automate ETL scripts that runs periodically.
- Developed ETL scripts in Python to get data from one database table and insert or update the resultant data to another database table.
- Wrote Python scripts to parse XML documents and load the data in database.
System Engineer | Application Support Specialist | Ab Initio support executive
Tata Consultancy Services Ltd.
November 2014
to July 2018
- Worked on various Banking and Finance domain projects as an Application Support Specialist across CITIBANK portfolios Risk, Finance and Compliance.
- Proficient in ITIL methodologies with huge experience in Incident, Problem, Change and Batch management maintaining SLAs, SLOs and SLIs.
- Worked on project transition and trained multiple trainees on support processes.
- Trained individuals on Unix command line data and file handling processes.
- Built scripts to automate various manual support processes using Unix Shell scripting. Gained sound knowledge in Sed and AWK commands.
- Worked on building multiple automated reports as per management requirement to present statistics of application data processing timeline and daily end user deliverables using Python and Shell scripting.
- Worked on Ab Initio ETL tool to build Graphs and Plans to automate data processing as per business need.
- Supported Applications where the whole data processing was built on Ab Initio ETL tool and scheduled in Autosys and Control Center.
Assistant System Engineer | Application Support and System Analyst
Tata Consultancy Services Ltd.
March 2014
to November 2014
- Allocated to CITI account as a support executive to support RAPID application (Loan management web application for CITIBANK customers)
- Worked on Oracle and Sybase databases to pull data and load DB tables.
- Worked on application health rule alert setup in AppDynamics to monitoring Web/Application/Database health.
- Worked on Autowatch tool to monitor incoming and outgoing application data.
- Gained knowledge on Incident and Problem management to support application or user issues and queries meeting standard SLA.
- Worked on application job setup in schedulers like Autosys and Control Center.
- Worked on application checkouts post release or maintenance activities.
- Gained sound knowledge in designing and implementation of automation solutions to minimize manual work using Python or Unix Shell scripts.
Assistant System Engineer Trainee | .Net Developer
Tata Consultancy Services Ltd.
November 2013
to February 2014
- Joined as an ASE Trainee at Tata Consultancy Services Ltd. (TCS) and attended training program for 3 months held at TCS Trivandrum where I worked as a developer to design a web application on an e-commercial shopping website.
- Technologies used : Web development framework - ASP .Net; Programming language - C#; Database - SQL server 2008
- Python, Unix, Shell scripting,Numpy, Pandas
- Oracle, Sybase, SQL server 2008
- Pycharm, Ab Initio
- Control Center, Autosys
- ServiceNow, JIRA
- AppDynamics, Autowatch
BTECH degree in Electronics and Instrumentation Engineering
Languages
-
English
Advanced
-
Hindi
Advanced
-
Spanish
Notions
