Business Analysis, performance Tuning, Oracle,PL SQL , SQL , Unix Shell Scripting, Python Scripting

Migration of Oracle database from 11g to 12C on AWS cloud with remediating all the restrictions of webservice calls , DB links and other external dependencies to pyhton and writing orchestration platform in Python from UNIX

Orcale , PL/SQL, SQL - development , Unix Shell Scripting , business Analysis , requirement gathering, client interaction , team management were few tasks taken in this project, delivered 8! successful project in this stint.

Prepared new Data model but in accordance to current architecture Created to new Fact and Dimension model while using some existing Dimensions to on-board new type of product. A new reporting View was created as well with New tables , Materialized views , Mlogs , Packages and other Database Objects

Consuming New feed from upstream and Generating MIS out of the Data. Providing Application Specific Flags to get easy simple view of the Trades from the system used by higher management to review performance and make further decision

Re –engineered the Legacy system both technically and logically to provide better MIS.

Along with other 2 Team members created a framework which is being used to automate test cases in Database and would replace UA Testing completely going forward, part of continuous integration.

Seamlessly migrating Oracle database version from 11g to 12c on Be-spoke Servers

A complete product from scratch was built . A complete end to end fund processor was made. The idea was to make the product free from dependencies of partner system and do the processing within the system. This is a generic product which constitutes of functionalities for all type of payment flows, inwards, outwards, inward returns, this product is further capable of handling different countries (same as well as different database) with minimal property and configuration based changes.

New Payment product specific to India is added to the existing functionality, New performance enhanced codes written in PL/SQL and shell scripts to call and automate the tasks – Headed the off-shore team, impact analysis, code designing, FRD were few of the tasks taken up

Project taken from partner system and rebuilt in our system. A completely new application with same functionality but enhanced features was built from the scratch and incorporated in our application , opportunity of heading (analyzing and implementing ) all the Database (procedures , functions , packages etc ) and shell scripting tasks was given.

This was an end to end project where the complete application was Migrated from UNIX (AIX) to Linux (Redhat) . The architecture of the application changed and from two tier we moved to three tier application hence resulting into a lot of changes, Several new function and procedures were written DB operations requiring file operations were sunset and substituted by shell scripts, each and every shell script was made Linux compatible , new shell scripts were written to accommodate changes , cron tab operations were sunset and logic incorporated into shell scripts , with the change also came a new scheduling tool – Autosys

This was a minor project where opportunity to head the project was given, A mandatory run twice a year is required as per the rules laid down by governing body of Malaysia , The complete application swings to alternate servers in COB site. In this project, requirement was taken from client , impact analysis was done , new shell scripts were made and handling of changes in properties was done, complete end to end testing with two successful dry runs followed by a successful live run. Analysis and Communication with client, users, stakeholders and all partners was of the essence here.

Maintenance of NBIN (National Bank Identification Number) through a front end screen by Operations team. Lead the project, Gathered Requirements from clients, Analyzed and suggested business validations, reviewed and fine-tuned the queries for better performance.