Divya Mary CH

KEMPER

Project Name:- ChampDB

• Worked on Oracle database(Source) to Postgre database(Target) migration by using SCT and AWS Tools.
• and converted all the SQR reports and .sql files to oracle database as procedures/functions manually and migrated to postgres database.
• Written SQL queries as required by connecting databases through SQL developer and PGAdmin.
• Validated all the objects like tables, views, triggers, sequences, synonyms, indexes.
• Tested the functionality and validated the Plsql objects as in procedures, functions and packages.
• Scheduled and ran the jobs by configuring through Control-M and generated reports.

Project Name:- Premium Collection

• I was part of PC team where I have understood and got and idea on the Salesforce to ADMI process and ADMI to Salesforce for collecting the insurance premium and how the data is loaded using informatica.

CME(Chicago Mercantile Exchange)

Project Name:- DB Refractory

• Worked as part of Migration team involved in Development and Oracle to Postgre End to End Structure Conversion and Data migration using Ora2PG platform(Putty) and Ispirer tool(PLSQL Objects) as well as SQL developer & PGAdmin.
• Used Python validator for comparing Source and the Target Structure and Bits for Data Validation.
• Performed Unit Testing with capture replay and checked the functionality of all the PLSQL objects.
• Engaged in developing and debugging all SQL, PLSQL objects like views sequences, Triggers, Procedures, functions etc.
• also handled the issues while Data load like huge data, partitions/Sub partitions and Indexes and Constraints.
• Engaged in Client's AdHoc requests and actively participated in Client Interaction meetings to discuss and understand the requirement and functionality of the application.
• And then migrated all the application to Google cloud using cloud sql.
• Worked on Sequence automation and written a py script.

DEUTSCHE BANK

Project Name:-DB Knowledge Store

• Worked as part of DBKS team as a PLSQL developer and DB Engineer engaged in various activities like developing and enhancing the application as per the client requirement.
• Written SQL/PLSQL Codes and Unix commands/ Scripts as per the client requirement to develop application and to enhance the performance of the application.
• Involved in DB performance tuning, Stats gathering using EXPLAIN PLAN, Query Optimization and generating AWR reports to verify the system specifications taking necessary actions in case of performance issues.
• Fixing application related issues backend and handling exceptions and documentum application as well as production environment. Participated in Disaster recovery activities and in production environment.
• Monitoring all the servers and databases performance and took actions accordingly in application outages like creating incidents and change management.
• Received appreciation for working on tool called Grafana for setting up and configure the database and server specifications using Promotheus.
• Scheduled jobs and runbooks using ORCA and Fabric container.

BARCLAYS

Project Name:- Basel Committee on Banking Supervision(Data Lineage Store)

• Worked as part of the Data Lineage Team as a Data Specialist and sql developer to find out the lineage for SQL, Teradata and SAS scripts as in finding the Golden Table by backtracking method using Metadex tool.
• Analyzed the Scripts sent by client , running and debugging the Scripts and handled the exceptions.
• Ran the scripts by uploading and configuring with the help of reverse engineering to provide the lineage for finding out the Golden table.
• Engaged in DTU process using Winscp and Putty.