Software Engineer Pl Sql

ANISHYA PAUL

*************@*****.*** +1-248-***-**** Novi Michigan

Professional Summary

●A logical, analytical thinker with good database skills having experience of 9+ year as Oracle PL/SQL developer.

●Work experience in Analysis, Design and Implementation of Business Applications using Oracle Database Technologies (SQL, PL/SQL), Oracle 11g and Oracle 12c.

●Developed Complex database objects like Stored Procedures, Functions,Triggers, Cursors, Exceptions, Packages, Collections,Records using PL/SQL

Effectively made use of Analytical & Aggregate functions, Create Tables, Indexes, Views, Set Operators, Joins, Complex Queries, Materialized Views,and Constraints for fetching the data from database.

Have done Performance tuning of complex queries using Index, Parallel Hints, AWR Reports and Optimization using Oracle Hints, Explain plans, DBMS_PROFILER,Tk-Prof and Table Partitioning.

Good experience in advance PLSQL programming using Records,Collections, performing Bulk operations, Ref Cursors, Dynamic SQL, SQL LOADER and External Tables

Experience in handling errors/exceptions and debugging issues in large scale applications.

Excellent hands-on coding and design skills in Oracle SQL, PL/SQL with exposure to analytical functions and data modelling.

Excellent exposure to PL/SQL,J2EE and Struts,JSP,Angular JavaScript,HTML,CSS,AJAX,XML.

Good exposure working as Frontend + Backend Developer.

Expertise in working as Frontend Developement using JSP, Javascript,CSS,HTML,AJAX,Angular JS

Expertise in creating JASPER reports using TIBCO Jaspersoft and IReport tools

Good experience in Test Case Preparation, Test Case Execution, Bug Reporting and Bug Fixing.

Good experience of direct communication with clients and handling escalations.

Worked both in Waterfall and Agile Methodology.

Worked on version control tools such as GitHub, Tortoise SVN,Clearcase and used JIRA bug tracking tool.

Responsible for analyzing on existing stored procedures for new enhancements, designed PLSQL programs using PLSQL collections, record types and object types, and implemented new features by wring packages/functions/procedures for new and existing business application and production support for the existing application.

●Expertise in Requirement analysis, Designing, developing, implementing and executing a project.

●Knowledge in Power BI and Oracle APEX

●Learning Python Programming

●Part of Data Analysis team and contribute my experience to work as a team.

●Experience in all phases of SDLC including analysis, specification, software and database administration, development, maintenance, testing and documentation.

●Self-motivated, goal-oriented performer with an ability to work independently with minimal supervision to meet deadlines.

●Has experience in working with Healthcare, Financial,Insurance and Telecom Domains.

●Experience in working with Microsoft Excel,Powerpoint,Ms Access

Skill Set

Languages : SQL,PLSQL,Advanced PLSQL,Java Database : Oracle 10g,11g,12c MySQL

Web Tech : HTML,CSS,Javascript,JSP,AngularJS,AJAX,JSON Servlets, Struts Middleware : Apache Tomcat, Weblogic, Oracle Apps

Tools : Toad, SQL Developer,Clearcase,SVN,TIBCO

Jaspersoft,Ireport,Putty,Winscp,GitHub, Power BI, Oracle APEX

IDE : NetBeans, Eclipse,Notepad++,Dreamweaver

Scripting Languages : JavaScript,Typescript

Project Details

Technology Consultant(Sr PLSQL Developer) Shell Finance DXC Technology (Former Hewlett Packard)

July 2017 – May 2019

Description: Shell is a global group of energy and petrochemicals companies. With around 94,000 employees in more than 70 countries and territories, Shell helps to meet the world's growing demand for energy in economically,environmentally and socially responsible ways.

This project covers reports of daily, monthly, yearly transactional reports and fuel reports.

It involves generating jasper reports for Shell Petrol Pump for more than 20 countries which includes card and transaction details at each SHELL Outlet.

Technologies Used: Jasper, Oracle PLSQL, Unix,JSON

Tools: SQL Developer, Tibco Jaspersoft, Putty, Winscp, GitHub

Role: Internal Report Developer

Responsibilities:

•Design and Develop jasper reports on jasper soft reporting tool

•Interacted with Business Analysts and Users in requirement gathering.

•Created Technical Design for the Back End PL/SQL based on Business Requirement Documents and the Functional System Design and implementation of business application using the Oracle RDBMS

•Creation of database objects like tables, views, synonyms, materialized views, stored procedures, packages using oracle tools like PL/SQL Developer.

•Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

•Experience in Oracle RDBMS database installation, configuration, and maintenance and knowledge on design and implement normalized relational database schemas.

•Constant monitoring and performance tuning of oracle database, checking the most queries.

•Involved in updating procedures, functions, triggers, and packages based on the change request.

•Built Complex queries using SQL and wrote stored procedures using PL/SQL.

•Writing Procedures and complex queries to fetch data from database

•Resolving Performance issues to ensure reports do not take long time to generate

Configured Jasper report server.

Effectively made use of Analytical & Aggregate functions, Create Tables, Indexes, Views, Set Operators, Joins, Complex Queries, Materialized Views,and Constraints for fetching the data from database.

Have done Performance tuning of complex SQL queries using Index, Parallel Hints, AWR Reports and Optimization using Oracle Hints, Explain plans, DBMS_PROFILER,Tk-Prof and Table Partitioning.

Deployment and version control of reports using SVN, GIT.

Having subreports when required.

Involved in project support.

Designed statistical reports.

Optimizing the performance from the query and tool side.

SQL queries to retrieve data from ORACLE database.

Creating temp table for performance improvement.

Creating view, materialized view, procedures

Involved in Query tuning.

Analyzing AWR and ADDM reports.

Worked on projects in Agile/Scrum methodology contributing to Sprint Planning and Daily Stand-up meetings.

In Agile Supported release planning and solution architectre design as needed.Directed daily scrums with different scrum teams. Actively participated in sprint planning sessions, offering insights into technical feasibility and effort estimation.

Worked closely with users in gathering and analyzing requirements and providing solutions that meet their requirements.

Participate in daily scrum to discuss on the current status and burn down of the hours for the tasks assigned.

Technology Analyst– Healthways-Data Intake

Hewlett Packard

Dec 2014 – June 2017

Description: Healthways is the largest and most experienced global disease management and wellbeing provider. Healthways offers comprehensive solutions that helps to improve well-being, decrease healthcare costs, enhance performance and generate economic value for their customers.

We have a set of informatica mappings and PLSQL and .NET codes which will take the data from BizTalk server and sends into the downstream system database SQL SERVER.

Data Intake – TA is coming in the phase of Healthways Data Fix. If any Data Fix is required for any of the schemas for Healthways, TA is looking in to that.

Technologies Used: Oracle PLSQL, .NET, Packages, Procedures, Functions, Logging, Cursors

Tools: Toad, Eclipse

Role: Data Intake-Technology Analyst

Responsibilities:

Communicated with business customers to discuss the issues and requirements.

Involved in the production support activities to resolve the ongoing issues and troubleshoot the problems.

Finding and fixing the data issues using PL/SQL.

Creating and solving the incidents and change requests for the required data fixes.

Involved in deployment activities.

Involved in analyzing the PL/SQL blocks to find the issues.

Working on L2, L3 incidents and bringing them to closure as soon as possible.

Responsible for the incident management process by supervising the resource.

Involved in data loading to production, Data fixes using T-SQL and communication with the account team and clients.

Documented steps taken to trouble shoot and fix the issues

Creating and resolving the incidents and change requests for the required data fixes

Sr.Software Engineer– British Telecom - CS Inventory Alignment

Tech Mahindra,Pune, India Oct 2013 – Mar 2014

Description: For BT they have one tool to re-sign (renew) their contract with customers. But for BT Global Services, they have different source system to get data. Due to the discrepancy of data in each system re-sign tool is not in use. So we have some defined set of rules to identify and rectify the data discrepancy and make the system to function properly.

Technologies Used: Oracle PLSQL, Packages, Procedures, Functions, Logging, Cursors

Tools: Toad, Eclipse

Responsibilities:

Identify and rectify data discrepancy by changing/creating procedure.

Monitoring the daily, weekly and monthly jobs.

Involved in the production support activities to resolve the ongoing issues and troubleshoot the problems.

Unit testing and integration testing of the modules.

Sr.Software Engineer– General Insurance – Notional Float

Bajaj Allianz,Pune, India Nov 2012– Sep 2013

Description: The module was developed for agents so that they can issue policy with virtual float balance. The designated user has the rights to assign virtual float balance to privileged agents along with a due date. Once this is done, the agent can issue policy utilizing actual float balance and Notional float balance. Once the due date is passed and if the policy is not settled, (i.e. the agent has not paid for the utilized notional float), the system will block the policy issuance by showing ‘0’ float balance for that

particular user. Once the agent pays for notional float amount automatically, system will unlock the float.

Notional float can have impact in policy issuance, Receipt Generation and Policy cancellation etc. We are passing accounting for each notional float transactions.

Technologies Used: Oracle PLSQL, Struts, JSP, JavaScript,Ajax, Packages, Procedures, Functions, Logging, Cursors

Tools: Toad, Dreamweaver

Role: Database and Frontend Developer

Responsibilities:

Designed and Developed Webpages usin Jsp,Css,Ajax,Struts and XML

Fornt end and backend validation for all the forms created using Javascript and PL/SQL

Validated input values to make sure that they will be accepted before they are submitted to the server.

Created packages,procedures and Functions to perform this module.

Part of the entite life cycle of this application, beginning from the requirement gathering, designning for user interface and DB tables,Coding, Unit testing and Maintenance.

Leading a Team to succesfull implementation of this project.

Software Engineer– General Insurance – Covernote Control Process

Bajaj Allianz,Pune, India Nov 2011– Oct 2012

Description: It is a process before policy Issuance. As an insurance company Bajaj Allianz aim of introducing this process is to eliminate the disadvantages of manual reconciliation, manual updation of records. By this process cover note control can be audited on real time basis.In existing process of cover note control, user needs to maintain excel sheet and manually update it on regular basis. User also does daily reconciliation with Premium register & inward register to know the current status of cover notes. This manual updation task takes lots of time and effort and also there will be possibility of errors.

Monitoring of no of books assigned to one particular IMD is also done manually and sometime it creates confusion and mismatches with the actual position. Current process involves tracing missing & intermittent cover notes, which needs regular physical verification of cover note leaves which is very time consuming & tedious process.

Hence this project aims at avoiding manual covernote reconciliation & Covernote approvals will be done through online only instead of mails .Only the correct covernote numbers will be ready for allotement to branches an all the incorrect covernote entries created will be rejected& cancelled. This is having many approval/rejection stages till it reaches to IMDs bucket.

Technologies Used: Oracle PLSQL, Struts, JSP, JavaScript,Ajax, Packages, Procedures, Functions, Logging, Cursors

Tools: Toad, Dreamweaver

Role: Database and Frontend Developer

Responsibilities:

It is a New Module Developed, so able to participated in entite life cycle of this application, beginning from the requirement gathering, designning for user interface and DB tables,Coding, Unit testing and Maintenance.

Development and Unit Testing.

Testing the application in the different phases of development cycle.

Resolving Issues, backtracking to get the root cause, and fixing the issue.

Provided production support.

Software Engineer– Life Insurance – Scrutiny Tagging

Bajaj Allianz,Pune, India Mar 2010– Oct 2011

Description: The aim of the project is to track the utilization of the money and reduce fraud activities. This was achieved by tagging the receipt with a unique number called as scrutiny number. The scrutiny is used for each and every proposal. When the receipt amount is tagged with scrutiny the exact amount is available for that particular transaction.

Apart form the above requirements, whole accounting structure and process has been changed. This project mainly focused on re engineering of bajaj allianz General Insurance products.

Technologies Used: Oracle PLSQL, Struts, JSP, JavaScript,Ajax, Packages, Procedures, Functions, Logging, Cursors

Tools: Toad, Dreamweaver

Role: Database and Frontend Developer

Responsibilities:

Development and Unit Testing.

Testing the application in the different phases of development cycle.

Resolving Issues, backtracking to get the root cause, and fixing the issue.

Provided production support.

Programmer– Jewellery – Gold Management Software Canowalk Software Solutions,Kollam, India

June 2009– Feb 2010

Description: Gold Management System automates the daily activities of the ‘Kanakanidhi’ section of Sultana Jewellery (client). Kanakanidhi is a process, which maintains the gold- scheme organized by Sultana Jewellery for their customers. Customer has to pay a certain amount for their scheme every month. There are different types of employees in Kanakanidhi like Registration Agent, Collection Agent, Team Leader, Admin etc. Collection Agent collects amount from the customers. Registration Agent canvasses customers for the schemes. The software take care the entire process in the jewellery right from customer, employee, Collection Agent, Scheme, Reports, alerts, and many more.

Main Modules Are: -

Customer,Employee Registration,Scheme Management,Daily Board Rate Settings,Passbook Management for scheme & Reward Card,Privilege (Panel) Settings,Reports & Alerts,Executive Passbook,Point & Incentive Settings.

Technologies Used: Java 1.5, Jsp 1.2, Servlet 2.4, MySQL5,Tomcat 5.0

Tools: Eclipse Role: Programmer Responsibilities:

Development and Unit Testing

Involved in maintaining, debugging and troubleshooting systems and software to ensure that everything is running smoothly.

Testing the application in the different phases of development cycle.

Educational Qualification

BE in Computing from Staffordshire University, APIIT Panipat

Contact this candidate