Worked as PLSQL Developer for migrating writebiz legacy system to policy center oracle database system.

The purpose of General Motors Automation Process is to auto process data from different sources and integrate the necessary data from different data feeds for use in future campaigns and reporting.Data is sent or retrieved from different sources at different intervals. Data files delivery intervals can be hourly, daily, weekly, monthly, quarterly or adhoc. The objective is to have the process built in such a way that everything gets processed automatically and produces necessary reports to support business.Roles:• Working as a senior PLSQL developer and Unix Shell Scripting• Gather requirement from BA• Prepare TDD for the task assigned• Develop the code for the requirement, writing PLSQL Code and Unix Shell Scripting• Have peer to peer code review and discussion with colleague• Provide the demo to BSA• Deliver code to UAT using Azure Devops• Following agile methodologies and actively participating sprint planning, retrospective, backlog refinement meeting.• Using Azure Devops to capture all the task and its progress

Module Name : Risk AssessmentProject Description : Risk Assessment module is all about to control the risk on the organization level.Various Risks are assessed by the assessor to make sure that the organization does not go under financial loss, reputation loss etc.The module consists of various factors, perspectives, plan, risks, and Risk assessment task.Business Flow: 1) Head of the organization creates a plan for the product to be assessed.2) Head Creates task/assessment for assessor who is going to assess the product3) Assessor will assess the assessment and provide his rating and score for the product according to the risk level and send for approval to head4) Head will approve/ask for clarification5) Once head approves the assessment then assessment cycle is considered to be completed and then all the data will go to the reporting table.6) Reports are created for Senior management user to see the statistics.Roles:- Working as a Senior PLSQL developer- Writing sql queries to develop the business report- Proficient in writing complex queries- Achieving milestone within the time frame- Deliver the project with good quality and minimal defects.

Company Name : HCL Technologies Aug 2014 – Jul 2016Client Name : UBSProject Title : OGC – Online Grant Communications• A product that allows participants to accept or reject equity awards online through the UBS one source website by notifying the participant via email and/or by notifications that appears after login to the website. Mapping the grant agreement which is created in the system to a specific grant containing all the details of products, grants type, vesting periods etc. Core of OGC Functionality is acceptance, notifications, acknowledgment and setting up a new grant.• It is part of WebAdmin system used by the Companies Admin/UBS Internal User. The Admin will upload the Agreement doc in system and the list will be mapped with the list of participants who ever eligible to allocate the Grants/Awards. Once the participant will login to OneSource system, they will be able to see the Agreements and they can choose Accept/Declined or Decide later option and WebAdmin system will display the count of Accepted, Declined/ No Action participant list. For No action we also have functionality to send the reminder mail to the entire participant against the agreement form (form code).Roles: • Worked in HCL as a senior PLSQL developer.• Active participation in technical design documents discussion to design the structure of the table.• Involvement in development activities to create the database object like creating table, Stored Procedure, Package, function, Cursor, Exception handling.

Company Name : Wipro Technologies Oct 2010 - Jul 2014Client Name : Lloyds BankProject Title : Interest Calculation System• Interest Calculation System is an application which calculates interest of the Corporate and Commercial customers. It’s an in-house application. It also allows City Office branch to maintain, calculate & generate reports for customers. It calculates the interest on a daily basis for end of day balances of Corporate and Commercial customers. Customers can view their account balances and calculated interest on daily basis through frond end screens.Roles:• Joined Wipro as a fresher and worked as an Oracle Developer.• Got training on Oracle PLSQL, DBA.• Participated in requirement gathering Meeting/Discussion.• Prepared Functional documents and design documents with the help of seniors.• As part of Oracle development activities, I was involved in writing Procedure, Package, Function, Cursor, Exception Handling etc.• I was also involved in defect fix activities which helped me to gain knowledge in debugging the issue.• Worked in Automation Project.• Active involvements in writing Unix Shell Scripting to automate the job to reduce manual efforts and mistakes.