Prajjwal Singh
Noida
Summary
Senior Analyst Programmer with over 9 years of experience in production support and systems administration within the financial services sector. Proven track record at Fidelity International and TCS (Deutsche Bank project) in optimizing mission-critical applications using SQL, Oracle, Unix, Python, and AWS. Expert in SLA management, automation, and root cause analysis (RCA) for high-availability environments.
Overview
10
10
years of professional experience
Work History
Senior Analyst Programmer
Fidelity International
05.2022 - Current
- Production Support: Deliver end-to-end support for critical financial applications, including Fidelity Insight, SDG Mapping Tool, and Analyst Rating Metrics (ARM), and Analyst Model Portfolio (AMP).
- Performance Tuning: Optimize SQL queries and system processes in Oracle and Unix environments to improve system responsiveness and data throughput.
- Automation: Working on automating repetitive tasks, reducing the manual efforts that we have to put in.
- Project Leadership: Spearhead the AMP and ARM yearly reconciliation and reseeding project, ensuring high-integrity data processing, and adherence to strict business deadlines.
- Cloud & SLA Management: Manage application health within AWS environments, consistently exceeding SLA targets through proactive monitoring, and rapid incident resolution.
- Stakeholder Management: Collaborate with cross-functional infrastructure and development teams to ensure seamless production releases, and stable system architecture.
IT Analyst
Tata Consultancy Services
07.2016 - 04.2022
- Shift Leadership: Served as the Shift Lead (UK Shift) for the Deutsche Bank project, acting as the primary point of contact for global stakeholders and vendors.
- Incident & Problem Management: Resolved complex production bugs and conducted deep-dive Root Cause Analysis (RCA) for critical security-related applications.
- Automation & Scripting: Developed PowerShell and Unix scripts to automate daily health checks and production monitoring, reducing manual workload by approximately 20%.
- Infrastructure Oversight: Managed capacity forecasting for Oracle tablespaces and Unix file systems; utilized ITRS Geneos for real-time performance monitoring.
- Disaster Recovery: Planned and executed weekly Disaster Recovery (DR) drills, ensuring 100% system readiness for production failover scenarios.
- Knowledge Management: Authored a comprehensive troubleshooting journal for the incident management team, effectively lowering the Mean Time to Repair (MTTR).
Education
B.Tech -
IMS Engineering College
Ghaziabad, UP07-2016
Skills
- SQL, Oracle, PostgreSQL
- Python, Java, Unix
- Amazon Web Services (AWS)
- ServiceNow, JIRA
- Geneos, Control-M, Informatica, CyberArk
- Performance Tuning, Automation
- Disaster Recovery (DR), Incident/Change Management
Awards
- Best Performer of the Quarter (FIL), For exceptional delivery during the ARM yearly reconciliation cycle.
- Business Appreciation (FIL), For reliable support and impact on core financial systems.
- Star of the Month (TCS), For excellence in production support and stakeholder communication.
- On the Spot Award (TCS), For rapid resolution of high-priority production incidents.
Timeline
Senior Analyst Programmer
Fidelity International
05.2022 - Current
IT Analyst
Tata Consultancy Services
07.2016 - 04.2022
B.Tech -
IMS Engineering College