Prajit Swain
Senior Application Support Analyst
Bengaluru,KA
Summary
To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.
Overview
7
7
years of professional experience
Work History
Senior Application Support Analyst
IG Group
09.2017 - Current
- Strong working experience on Oracle SQL/PLSQL , Debugging packages , stored procedures , views , triggers & building SQL queries as per business requirements.
- Strong working experience on Oracle Business Intelligence to support business users for their BAU reporting process.
- Experience on tools like ServiceNow , GIT HUB , JIRA , Splunk & Confluence.
- Extensive experience on Data Warehouse & Enterprise reporting services related projects to deliver required internal finance critical reporting as well as regulatory requirements.
- Strong knowledge on ETL methodologies and experience on Data Extraction , Transformation & Data Load for various business reporting requirements.
- Extensive experience on Production support with strong Service management framework experience(Incident, Problem & Change management).
- Working experience on Root cause analysis for Incidents , Tracking Problem tickets for recurring incidents and finding permanent solutions.
- Designing various reconciliation checks to ensure accuracy & completeness of data with appropriate alerting mechanism.
- Perform code changes/hot fixes to required Oracle objects using GIT HUB , Bitbucket , raising pull requests & deploy required fixes to various environments.
- Extensive troubleshooting knowledge to handle production issues with system analysis , application support on 24*7 model.
- Strong knowledge on various schemas in DW like Staging , ODS.
Education
Bachelor of Engineering -
Biju Patnaik University of Technology
04.2001 -
Skills
Data Migration
Incident Management
Performance Tuning
ITIL Framework
Defect Identification
Ticket management
Data Analysis
Code debugging
Timeline
Senior Application Support Analyst
IG Group
09.2017 - Current
Bachelor of Engineering -
Biju Patnaik University of Technology
04.2001 -