Skilled IT Professional with 2.8 years in Oracle PL/SQL and hands-on experience
with AWS and Python. Effectively combines database management expertise with
cloud technology skills, demonstrating a proactive approach to learning and
delivering valuable contributions to the team.
Overview
3
3
years of professional experience
1
1
Language
2
2
years of post-secondary education
Work History
System Engineer
Tata Consultancy Services
Kolkata
12.2021 - Current
Worked with UK clients on Demand Forecasting System (DFS) and Renewable
Gas Forecast System (RGFS) project, where we integrated forecasts from 3rd
party vendors
Processed forecasts for both half-hourly and non-half-hourly
periods, supplying generated forecasts to traders for strategic trading
Additionally, analyzed forecast data to estimate the system's electricity
consumption across various segments
Proactive Batch Management: Created PL/SQL scripts for real-time monitoring
of 24/7 batch processes, with built-in mechanisms for automatic failure alerts
and rescheduling in the event of temporary issues
This automation eliminated
the need for manual status checks and scheduling, enhancing operational
efficiency
Health Check Report Automation: Developed a Unix script to generate health
check reports for critical overnight batches and essential files
Scheduled the
script using Control-M to monitor batch status and file counts
Utilized these
reports to take immediate action on data discrepancies before business issues
were reported, ensuring proactive problem resolution
Integrated Data Handling & Monitoring: Developed and deployed a data
pipeline with AWS API Gateway for fetching vendor data, and Lambda functions
scheduled via EventBridge every 30 minutes
Used Python for Lambda functions
to create and store CSV files in Amazon S3, then loaded the data into a
PostgreSQL database
Implemented error tracking with CloudWatch and set up
SNS notifications for failure alerts
Incident Resolution & Business Coordination: Acted as the primary SME,
focusing on the swift resolution of high-priority incidents
Ensured effective
coordination with business stakeholders to prevent escalations and maintain
uninterrupted project flow and stakeholder satisfaction
Effective New Joiner Integration: Provided detailed KT training to new
employees, equipping them with the necessary understanding of project
operations, tools, and best practices.
Education
Master of Computer - Computer And Information
Sciences
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services