09/06/2022 updated


Oracle and SQL Server DBA and Pl/SQl
• Expertise in Software architecture, Gap Study, Design, Analyst, Development, Debug, and Implementation.
• Domain Expertise in Banking Sector (Payment Gateway, Card Operation, Retail Banking, Loans) and Others.
• Experience in Oracle (SQL, PL/SQL), DBA (Installation and configuration, Fine-Tuning, Backup/Recovery, Patches, Database Migration/Upgrade, Data Warehouse, Account Activity, Replication, Golden Gate)
• Experience in SQL Server (SQL, PL/SQL), installation and configuration, Fine-Tuning, Backup/Recovery, Replication, User and Groups)
• Working Experience in ITIL process (Change Management, RMS & Incident ticket).
• Working Experience in SDLC Life Cycle, Agile Methodology, Scrum (Sprint Planning).
• Working Experience in job scheduling (Crone, Bat, Control M Job) in Linux and Windows environment. • Experience in Co-ordination with Business Team Location (IN, BD, PK, AE, BH, USA) and vendor (ATOS, HOGAN, 3i info Tech, Southern California Edison, MasterCard).
• Having Experience in Team handling, Project Co-ordination, Project Lead.
• Having Experience in document in Technical (LLD and HLD), Functional Specification.
• Working Experience in Tools (Control m, TOAD, SQL Developer, IBM MQ, AWS (RDS)
• Working Experience in GIT, Bit Bucket, Flyway, Jenkin Pipeline.
.
Professional Experience:
• Oct 2020 to Mar 2021 -> eSoft Labs Pvt Ltd at Bangalore.
• Feb 2019 to Dec 2019 -> eSoft Labs Pvt Ltd at Bangalore.
• Aug 2017 to Feb 2019 -> JK Technosoft Ltd at Bangalore.
• Jan 2012 to Jul 2017 -> Standard Chartered Global Business Services Pvt Ltd at Chennai.
• Nov 2006 to Jan 2012 -> In-Solutions Global Pvt Ltd. at Mumbai.
Banking Domain Experience:
• Expertise knowledge in Card Operation (Credit Card Production), Loan Processing System.
• Expertise knowledge in Card Operation (Credit & Debit Card), Payment System, Interchange System.
• Working knowledge in Retail, Consumer Banking and Core Banking.
• Knowledge about PowerCard System (Card Production).
• Knowledge in Islamic Bank, RBGMS and IFRS9 MIS Reports.
• Worked with Master card project (Customer on-Boarding, Batch Simulator).
Experience
Languages
Project history
Need to create New Database in Local server .
1.Need to restore Database in Local Server
2.Need to create New User to access database
3.Need to create Partation, Index as per performance issue,
4. Performance Tunning, Checking Query standard,Index,Explain Plan. and check AWR report and Log File.
5.Database Migeration involved in 11g to 12 C using export and import.
6.Creating PL/SQL and writing Queries
Role & Responsibilities:
- Database Setup (Installation and Configuration), Creation Schema through Flyway.
- Database Design, Migration, Backup and Restore in UAT Environment.
- Configuration AQ jobs and XML, JSON Storing in table.
- Find all logic involved in each process and making document.
Skills: Windows, Oracle 11 G with API development Team, Bit Bucket, Git, Flyway, Jenkin Pipeline, Golden Gate.
Description:
Need to create new database and configuration in local Environment. Need to do table design and need to configure Flyway setup to create object in Mastercard Server .AQ setup need to create in database to run job. Need to load XML and JSON file into database table through Procedure.
Role & Responsibilities:
- Requirement gathering from Business, Analysing requirement, Development.
- Data Migration from SQL Server to Oracle 12 C Database.
- Developing PL/SQL Procedure for Data Transfer from SQL Server to Oracle Database.
- Migration SAP BO Report which are Free Hand SQL to PL/ SQL Procedure.
- Developing PL/SQL Procedure for the RBGMIS, Islamic Bank.
- Writing SQL Query as per Business requirement and for reconciliation data between different Systems.
- UAT Co-ordination between Business User and BO Team.
- Front End model developed using Java and J2EE to upload Excel Sheet and PDF Files.
Skills: Windows, SQL Server, Oracle 11 G & 12 C, SAP BO 3.1 and 4.2, Java and J2EE
Description:
Database Migration from SQL Server to Oracle including Tables, Procedure, Function with Data and Migration SAP BO report of Free Hand SQL to PL/SQL Procedure implemented in UAT Server as per Business User Logical. Writing PL/SQL Procedure for the Data Mart to populate data from different system on Daily& Monthly Basics. IFRS9 Report preparation for Default Report and Reconciliation Report between different system data. Islamic Report generated check with budget for reconciliation between them. UAT and Production Deployment Co-Ordination with different team like DBA, AQC and Business Team. Upload Excel and Pdf files into database.