Prajit Swain

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.

Similar Profiles