Profile
HDFC ERGO GENERAL INSURANCE LTD
Role (Manager - Module Lead):
Customer policy and claims transactions integration and monitor data flow to data warehouse (T-1) on daily basis.
Implementation of Source system integration changes (e.g. Policy-Claims level changes, Service Tax / GST) with data warehouse as per requirements from business users, maintaining change requests tracker and testing of requests from UAT to PRODUCTION rollouts.
PL SQL/TranactSQL Scripting skills, Development of Stored procedures and functions as enhancements for Data warehouse system.
Acquiring all required approvals for change and production rollouts and maintaining the required documentation.
National Securities Depository Ltd :
Role(Assistant Manager):
Oracle BI Publisher reports design and testing as per requirement from business user
Execution, Monitoring and Troubleshoot Data warehouse ETL on daily basis
[SQL loader and OWB].
Handling database scheduled jobs. Exposure to Disaster recovery, Log shipping process.
Experience in using profiler for performance tuning and error finding, resolving assigned tickets from application user, Ability to collate stored procedures, triggers, views, constraints, UDF's, UDT's.
Understanding of Software Development Life Cycle (SDLC), Follow up with vendor for timely delivery of Releases and resolution of issues and insisting on the quality deliverables, Production movement/roll-out of enhancements.
Acquiring all required approvals for change and production rollouts and maintaining the required documentation.
ISMS activities (Auditing) and Data matching activities (UN Sanction list of terrorists).