Data Engineer - IT
Pwc
مجموع سنوات الخبرة :11 years, 7 أشهر
Working as a PL-SQL developer/Analyst for a Banking client.
▪Integral part of core team as a Platform Expert in Group Risk Data Warehouse project for Royal Bank of Scotland
▪ Liaised with BA's, client, lead designers for requirement analysis and steered walkthroughs of design artifacts with client
▪ Prepared functional and technical detailed design, created procedures and functions in PL/SQL for ETL and optimized code to
produce data extracts for liquidity risk reporting within SLAs
▪ Prepared technical implementation plan and coordinated deployment into different test environments; deployment and rollout
of release in coordination with all involved members(IT Project Lead, Test Manager, Database team)
▪ Provided standalone overnight/weekend support for critical test phases, production deployment and warranty phase
▪ Performed change request management activities, root cause analysis and technical proof of concept
▪ Organized knowledge sharing sessions(KM), quality control activities for CMMi Level 5 standards.
▪ Responsibilities also include Quarterly release implementation activities and support post releases.
Resolving and root cause analyzing the issues as a part of IT Team of the company.
▪ Creating SR’s with Oracle and working on them severity wise.
▪ Implementing the new features in Oracle EBS as per the requirements.
▪ Handling the issues raised by the company employees.
▪ Debugging and troubleshooting existing PL-SQL programming and applications.
▪ Providing solution on day to day issue with the functional knowledge and code analysis in Oracle Apps.
▪ Responsible for the code enhancement/maintenance of Oracle Purchasing and support of existing applications
▪ Understanding the business functionality of the tool used by client.
▪ Providing solution on day to day issue with the functional knowledge and code analysis.
▪ Debugging and troubleshooting existing PL-SQL code.
▪ Creating test plans for the fix implementation.
▪ Good team player and Proactive in taking initiatives.
▪ Proficient at completing tasks timely and meeting deadlines under diverse and high-pressure environments.
▪ Excellent communication, interpersonal and presentation skills with strong analytical mind-set.
▪ Providing technical support and defect fixes.
▪ Monitoring status of scheduled jobs and analyzing job logs in $U and Informatica.
Graduate in computer science and engineering