PROJECTS: PRAS Rectification and Automation
• Role: PL/SQL Developer
• Domain: Banking and Insurance
• Technology : Oracle 11g, PL/SQL, UNIX Shell scripting o Client requirement was to build an automated process where in they can update/ change the demographic details of their customers directly at the back-end, whilst performing various validations and generating Miscellaneous reports on the data which was updated, the data which got failed to update- the reason associated with it, maintaining the Audit details to as to track back the updates made. o The Project has 3Phases wherein in each phase a different functionality was introduced to meet the requirements. Unix Shell scripting was also used to load the file in database. Different teams where involved for smooth running of the process. PRAS AE New Worker
• Role: PL/SQL Developer
• Domain: Banking and Insurance
• Technology : Oracle 11g, PL/SQL, UNIX Shell scripting o Client requirement was to compare the data present in two different Applications having different databases at their back-end and making the unmatched records into sync. Data was to be communicated from SQL server to ORACLE database and the update was to be made at Oracle end. PRAS Extracts
• Role: PL/SQL Developer
• Domain: Banking and Insurance
• Technology : PL/SQL o Generating extracts on Fortnightly basic to share with the BI team for further processing. The extracts are generated from Oracle database first and then data from SQL database is merger using Tools and then shared with clients. This whole process needs to be executed every alternate weekend