Developer Oracle

Rachel Madhuri Jampa

248-***-**** • *************@*****.*** • www.linkedin.com/in/rachel-mj-45287a59/

Professional Summary:

Experienced PL/SQL with 3.5 years of professional exposure in IT who brings analytical, personable and efficient approach to all assigned works.

Proficient in Oracle 9i/10g/11g/12c software installations.

Proficient in an assortment of technologies, including Oracle 12c

Able to conceive and complete projects seamlessly with a history of productivity and successful project outcomes.

Strong problem solving with a broad range of computer expertise. A skilled communicator with the ability to establish rapport with members of diverse groups.

Strong knowledge on Oracle database virtualization and Oracle 12c, cloud technology

Proficient in SDLC including design strategy preparation, design plan development, development environment setup.

Has a strong grasp of coding, debugging, troubleshooting, testing and able to both conceive and complete projects in time

Expertise in Oracle table data manipulation using SQL queries and UNIX commands

Experienced in developing stored procedures, triggers and functions in PL/SQL

Proficient in designing and requirements for RICE (Reports, Interfaces, Configuration, Enhancements) Implementation, Conversion, Data Migration

Experienced in writing complex queries, views and indexes to database improve the database performance

Experienced in reviewing the queries code and code optimization.

Experienced in developing the application code for JAVA programs

Experienced in technical designs for application development and in transforming the requirements into stipulations.

Good Technical Knowledge on SQL, PL*SQL, Forms and Reports using for Inbound, Outbound, Extensions and Reports.

Designed solutions to enhance standard oracle flows for Order to Cash(O2C), Procure to Pay(P2P), Assets to GL, Inventory, TCA, Credit Card Transactions, GL Accounting processes

Experienced in developing new CR’s by integration and configurations of different system and modules.

Involved in registering the forms and concurrent requests in oracle apps

Designed the Functional solutions to the Key Gaps through Interface, Extension, Customization, Reports.

Collaboration with the Business users during the various stages of project lifecycle.

Wide experience in requirement analysis, GAP analysis, Design the ‘to be’ process, Process mapping, Data Conversion Management, Testing (unit/integration/system).

Expertise in post implementation support, prepared training manuals and also trained end users.

Well experienced with Application Tools TOAD, SQL Developer, PL/SQL Developer, Data loader, ADI & Web ADI.

Designed solutions to enhance standard oracle flows for Order to Cash (O2C), Procure to Pay(P2P), Assets to GL, Inventory, TCA, Credit Card Transactions, GL Accounting processes.

Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.

Strong in Performance Tuning, UNIX shell scripting.

Write technical design documents for conversions, extensions, interfaces, and reports. Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).

Ability to handle user defined errors by developing Error-Handling Package using PL/SQL.

Interacted with users, fixed the bugs, developed test plans and provides daily production support.

Experience in customizing oracle workflows such as the PO approval process, Order/Line Flow to send user notifications based on the business requirement.

Experienced in developing the full stack application from planning, designing, developing testing and deployment.

Strong knowledge on Java multithreaded, OOPS concepts.

Developed application using JAVA servlets, JDBC connections that connects the front end UI and the database.

Good knowledge on HTML, JSP, CSS.

Experienced in recommended changes to improve established java application processes

Education/Certification:

Master’s Degree in Information Technology March 2017

Southern New Hampshire University (Manchester, NH) GPA: 3.87/4.0

Bachelor’s Degree in Computer Science Engineering May 2012

Jawaharlal Nehru Technological University (India) GPA: 3.8

TECHNICAL SKILLS:

Programming Languages

SQL, PL/SQL, Java, HTML,UNIX

Web Technologies

HTML5, JavaScript, Bootstrap, PHP, JQuery

Database

MySQL, Oracle 9i/10g, Microsoft SQL server 2012, MS-Access

ERP

Oracle E-Business Suite R11i(EBS), SCM(Inventory, Order Management), Purchasing, General Ledgers, Account Receivables (AR), Account Payables (AP), AO

DB Management Tools

Microsoft SQL Server, Toad database developer

IDE Tools

Eclipse IDE, NetBeans IDE

Bug Tracking Tools

JIRA, ALM/QC

Version Control Tools

Tortoise SVN, GIT Hub

Automation

Testing Tools

Application Lifecycle Management (ALM)/ Quality Center (QC)

Operating Systems

Windows, Unix, Linux

Project Methodologies

Agile, SDLC, Waterfall

Other Tools

Kenan tool, Seibel tool, Oracle Reports6i, SQL*Plus, PL/SQL developer, SQL developer, MS Visio, MS-Project, Oracle Forms 6i

Had Knowledge On

C, C++, Tableau, Python, Shell scripting

PROFESSIONAL EXPERIENCE:

WATANIYA RAS IMPL, Kuwait Jan 2013-April 2014

Title: Oracle Apps Developer

Project Description: The National Mobile Telecommunications Company (Wataniya Telecom) is a leading telecommunications provider in Kuwait. Wataniya has embarked upon a program “Retail Activation System (RAS)” to modernize the IT applications at Point of Sale outlets including dealers and partners. Also to enhance the existing Oracle ERP Applications to cater various business requirements right from the Stock procurement from its suppliers to Sales to its Partners. RAS is called to help Wataniya to improve operational efficiency, gain more visibility and control on stock, enhance customer satisfaction and get repeat business and to grow business.

Responsibilities: Involved and completed work in the following areas in Oracle Applications 11i SCM Modules such as Purchasing, Inventory, General ledger and Order Management and .

Development of the Solution to fulfill the business requirements in Oracle E-Business Suite.

Was Involved in CR's where optimize the performance of the Deleiverables.

Preparation of Unit Test Cases for the components developed.

Optimize the performance of the deliverables.

Preparing Technical Design Documents.

Implementation of Inventory, Purchasing, Order Management modules in the current Oracle ERP Applications 11i environment.

Oracle Apps technofunctional such as Concurrent Managers,Application Developer,System Administrator.

Creating the user using Sysadmin responsibility.

Creating Concurrent programs and attaching them to respective responsibilities.

Developed 2 new CR’s from scratch to end and released in the live environment which involves of connecting different system, configuration, code development, attaching responsibilities and testing etc.,

Developed and designed reports and forms using the report builder and form builder.

Wrote PL/SQL stored procedures, function, triggers as per the requirements.

Done code reviews written by other team members.

Technologies Used: Windows, Oracle 9i database, Oracle Applications 11i (CRM & SCM Modules), Oracle SOA Suite 11g, Oracle 10g database, Oracle Applications R12, Oracle 8i/9i/10g/11g/12c

BSNL CDR PROJECT April 2014 –July 2015

Title: PL/SQL Developer

Project Description: The National Mobile Telecommunications Company (BSNL a Telecom) is a leading telecommunications provider in India. BSNL has embarked upon a program “CDR” to automate their daily applications from customer services to plans, billing and ledger reports which changes according to the government. CDRS will help BSNL to improve operational efficiency, gain more visibility, quality and control on transactions, payments and enhance customer satisfaction and get repeat business and to grow business.

Responsibilities: Involved in the following areas of billing in Oracle Applications 11i SCM Modules such as Purchasing, Inventory, and Order Management, General ledger and development of new procedures and configuration of new plans.

Development of the Solution to fulfill the business requirements in Oracle E-Business Suite and billing module.

Preparation of Unit Test Cases and tested for the components developed.

Optimize the performance of the deliverables.

Wrote SRS, Technical Design Documents regarding the process flow and posted in the internal TCS website.

Implementation of Inventory, General ledger modules in the current Oracle ERP Applications R12 environment.

Involved in developing sub-ledger reports and journals.

Configuration and maintenance of Asset management responsibility in oracle EBS.

Configuration, adjustments, billing, plans are always developed.

Designed billing reports for the end customers and maintenance and tracking of end customer data using the SQL, PL/SQL.

Fixed bugs that will pop up in the code and done code reviews.

Scheduled scrum meetings on regular basis and handled and dealt with client calls regarding the code development.

Involved in conducting interviews for new team members and delivered KT sessions for new team members.

Gathering of data form files using UNIX and storing the data in database using the stored procedures

Received Star of the Month award consecutively for 3 months

Technologies Used: Windows, Oracle 10g database, Oracle Applications R12 (CRM & SCM Modules), Oracle SOA Suite 11g, UNIX, MS Office (MS Excel, MS Word, MS PowerPoint) PL/SQL Developer, Kenan, ALM(testing), Oracle application EBS, Oracle 8i/9i/10g/11g/12c

E-Recruitment System, Manchester, New Hampshire Sep 2012-Dec 2012

Title: Java Developer and Team Lead

Project Description:

To meet the demands of the expanding industry, Company has been increasing the recruitment of new employees by almost 20% every six months. It is thus very important to Company that its recruitment process is efficient, robust and effective. The Recruitment process of Company involves taking into account many parameters under consideration in order to recruit the right candidate. It is key to the success of the growth of Company professional services. Company proposes e-recruitment process to meet the needs of a rapidly growing business in the age of internet. E-recruitment system solves some of the challenges faced by rapidly growing organizations.

Responsibilities

Involved in development and testing of E- recruitment system

Planned and designed various user workflows, modules as per the business requirements.

Served as technical lead over one module.

Developed code i.e. front end GUI, backed end database tables, middle components using JDBC servlets to form the full stack application.

Designed workflows using ER, use case, diagrams.

Developed attractive UI using the CSS styling.

Bugs fixation and monitoring using the JIRA tool.

Performed integration of modules after independent development to form the whole system.

Wrote test cases and perform different testing to check the functionality.

Technologies Used: Windows, Oracle 10g database, Java/J2EE, Eclipse, Gliffy, JIRA, UNIX

Surface cleaning company website Jan 2017

Title: Front End developer/Tester

Project Description:

Surface cleaning company proposed a requirement to build its website to attract the customers and to show their products and different services offered.

Responsibilities

Involved in development of website using PHP

Planned and designed various user workflows, modules as per the business requirements.

Developed database tables using Wamp server and front end in PHP

Developed attractive UI using the CSS styling.

Bugs fixation and monitoring using the JIRA tool.

Performed integration of modules after independent development to form the whole system.

Responsible for transactions and information to be present in the website using bootstrap and PHP

Technologies Used: Windows, MAC, oracle database, WAMP server, Oracle database, Bootstrap, MS project, MS Visio, HTML 5, PHP, Oracle

Contact this candidate