SUMMARY

• A self - motivated, hardworking, responsible, solution oriented Oracle Certified Professional having around 10 yrs of experience in Oracle PL/SQL.
• Possessing rich technical experience in formulating the business requirements into technical implementation.
• Proficient in technical & process oriented activities such as Architecture definition, Design, Software development, Review and Testing.
• Extensively worked on Incident, Change, Problem & Service Management, Migration, development.
• Excellent communication, analytical skills and strong ability to perform as a part of team.
• Creative and Problem solving ability with assignments; while working with clients & ensuring effective service deliverables.
• Extensive experience in most of the phases of Software development life cycle, i.e., Requirement study, Design, Construction/Development and Testing.
• Have been involved in customizing ERP finance module- Extensively involved in most of the phases of software development life cycle such as-requirement gathering, impact analysis, Design, development and review of code components built on Oracle standard APIs for business logic implementation.
• Have been involved in change request reviews, root cause analysis, finding the fix and reviewing the fix for production issues and delivering the resolution with in SLA.
• Have extensive knowledge of Oracle CC&B:- CC&B Billing, CC&B data model and CC&B user interface.
• Worked for development, support, migration and maintenance projects.
• Worked in Supply Chain, Telecom, Utilities and finance domains.
• Owning the responsibility from load balancing the work in team till delivery of resolution with proper release.
• Contributed to CMMI standards-involved in maintaining quality related activities, configuration management and release management.
• Created various PL/SQL procedures, functions, triggers as a part of project requirement.
• Written rectification scripts as a part of defect/issue fixing.
• Performed unit testing after development of the code component.
• Developed Automation tool for data error analysis.
• Got appreciation notes for work and team management.
• Getting trained in ETL tool Informatica.

TECHNICAL SKILLS

Operating System: MS-Windows 98, Windows XP/2000.UNIX, Linux

Software Package: MS Office.

Database: ORACLE 9i /10g/11g/12c

Web technologies: HTML, JavaScript

Skills: SQL, PL/SQL, MySQL, Oracle Performance Tuning, Oracle CC&B, ERP Finance Module-Account Payable and account Receivable

System Design and Development: Requirement gathering, impact analysis, Design, development and review, support, migration

Tools: Toad, SQL Developer, MySQL, Kibana, ETL - Informatica

Project Management: Project planning using IPM+

Version Control tools: VSS, SVN, GitHub

PROFESSIONAL EXPERIENCE

Confidential

PL/SQL Developer

Environment: Oracle 11g-SQL, PL/SQL

Responsibilities:

• Involved in developing complex business logic in Oracle.
• Created multiple procedures as a part of project requirement.
• Used Bulk Collections and FORALL for better performance and easy retrieval of data.
• Created triggers based on project requirement.
• Interact with RM team in order to address the application related issues.
• Interact with Client for better clarity about the requirements/reported issue/defect.
• Involved in code migration from dev to QA and QA to Production.

Confidential

PL/SQL Developer

Environment: Oracle 11g, 12c-SQL, PL/SQL, Kibana, Elastic search, Kafka, Spark

Responsibilities:

• Involved in developing complex business logic in Oracle.
• Created multiple procedures and created procedures for automating the process.
• Created triggers based on project requirement.
• Created JSON views to support the data transfer from Oracle to Elastic search through Kafka and Spark.
• Created process to convert oracle data into JSON formatted object.
• Involved in querying and data search using Kibana to ensure the data presence in Elastic search.
• Created Dashboards using Kibana.
• Interact with OM and WM team in order to achieve a consistence data flow.
• Involved in code migration from dev to QA and QA to Production.

Confidential

Technology Lead

Environment: Oracle 10g/11g/9i-SQL, PL/SQL, Oracle APPS Finance Module

Responsibilities:

• Have been involved in customizing ERP finance module- Extensively involved in most of the phases of software development life cycle such as-requirement gathering, impact analysis, Design, development and review of code components built on Oracle standard APIs for business logic implementation.
• Created multiple procedures as a part of project requirement.
• Used Bulk Collections and FORALL for better performance and easy retrieval of data.
• Involved in change request reviews, root cause analysis, finding the fix and reviewing the fix for production issues and delivering the resolution with in SLA.
• Contributed to CMMI standards- involved in maintaining quality related activities, configuration management and release management.
• Owning the responsibility from load balancing the work in team till delivery of resolution with proper release.
• Interacted with Client for better clarity about the requirements/reported issue/defect.
• Contributed to IPM+ activities.

Confidential

Module Lead

Environment: Oracle 10g/11g- SQL, PL/SQL, Unix (Putty, VNC), Oracle CCB V.2.3.0

Responsibilities:

• Creating/modifying of various PL/SQL procedures, functions and writing rectification scripts as per project requirement.
• Knowledge on using CC&B User Interface.
• Customized the MBC functionality of CC&B utility as per the Project specifications.
• Understood the AS IS process and developed scripts for TO BE process.
• Fixing implementation and production issues within SLA.
• Played multiple roles in project which includes Client Interaction, development, support, mentoring and Training.
• Involved in pre migration and post migration checks.
• Developed automation tool for pre migration error analysis and smoother migration.

Confidential

Team Member

Environment: Oracle 9i-SQL, PL/SQL, Unix, Linux, shell scripting, HTML, MagicCrystal report, Putty, VNC

Responsibilities:

• Creating of various PL/SQL procedures, functions and writing rectification scripts as per project requirement.
• Strong knowledge on using @billity User Interface.
• Doing pre bill checks before each bill run.
• Analyzing reported issues and resolving incidents with in SLA.
• Preparing IPA, fixing bugs, doing unit testing before releasing patch to QC.
• Prepared Test scenarios for various functionalities developed and assisted the testing team in creation of test scripts that are used in testing oracle stored procedures.
• Created Triggers in order to capture the root cause.
• Attending conference calls and interacting with clients for better understanding of the issue and requirements.
• Providing bill run support and ensuring a smooth bill run.
• Resolving the post bill check issues.
• Resolving application related issues.
• Raising Change Requests and Problem Tickets for reoccurring issues.

Confidential

Team Member

Environment: Oracle 9i-SQL, PL/SQL, HTML, Java Script

Responsibilities:

• Responsible for Creation of various PL/SQL Packages, functions, procedures and Triggers as per the need of project.
• Developed SQL queries for the manipulation of data.
• Generated the front-end pages using HTML and Java Scripts.
• Extensively used advanced features of PL/SQL like Ref Cursors and Dynamic SQL.
• Worked on User-defined and System defined exceptions to handle different types of Errors.
• Optimized the code component to a fewer line code with no alteration in functionality.
• Prepared the Test plan and involved in Unit test.
• Created jobs as per project requirements.

Confidential

Team Member

Environment: Oracle 9i-SQL, PL/SQL, HTML, Java Script

Responsibilities:

• Responsible for Creation of various PL/SQL Packages, functions, procedures and Triggers as per the need of project.
• Developed SQL queries for the manipulation of data.
• Used proper Exception handling to capture the error.
• Developed the UI screens using HTML and used Java Scripts for validations.
• Involved in creation of tables and sequences.
• Created parameterized cursors, file upload utilities.
• Used alerts for field restrictions.
• Extensively used advanced features of PL/SQL like Ref Cursors and Dynamic SQL.
• Prepared Technical Documentation, Test plan and Involved in Unit test, Integration test.
• Delivered the code with zero defects.

Confidential

Team Member

Environment: Oracle 9i(SQL/PL/SQL), HTML, Java Script

Responsibilities:

• Involved in creation of tables, views, indexes and sequences.
• Responsible for Creation of various PL/SQL Packages, functions, procedures and Triggers as per the need of project.
• Extreme Use of Exception Handling methods along with PRAGMA EXCEPTION INIT in order to associate user defined exception names.
• Developed SQL queries for the manipulation of data.
• Created all kinds of cursors: Explicit cursors, Ref cursors, for cursors, parameterized cursors.
• Involved in all phases of software development life cycle.
• Developed the UI screens using HTML and used Java Script for validations.
• Involved in the maintenance of the project post production.
• Strong knowledge of using both implicit cursors and explicit cursors and their attributes.
• Used proper Exception handling to capture the error.
• Prepared Technical Documentation, Test plan and Involved in Unit test.