Kanaka Raju Mantri ac3agz@r.postjobfree.com

Oracle APEX Developer +91-996*******

Professional Summary:

Around 5 years of experience in Application Development using Oracle SQL, PL/SQL, and Developer Oracle Application Express (APEX).

Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors.

Good in creating users and maintaining their roles and responsibilities.

Worked on front-end designing and backend PL/SQL coding.

Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX).

Experience in creating Tables, Joins, Indexes and sequences.

Experience in export CSV and Export to excel of APEX reports.

Around 5 years of overall software experience in Design, Coding and Unit Testing of various Web based applications using PL/SQL, Oracle Apex and Java scripting.

4+ years working experience in PL/SQL and Java Scripting of various Web based applications.

Experience in writing Technical design documents and developing unit test documents.

Experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections development using Apex-Oracle Application.

Used Collection, Dynamic actions, different Plug-in, notifications for extra features and more functionality.

Created different type of Pages, Region, Items, Validations and Process.

Hands-on experience with Oracle APEX 3.2/4.x/5.x (Oracle Application Express).

Oracle Apex, PL/SQL with knowledge of the most recent updates.

Experience in JQuery from last 1 Year in Oracle Apex level (wherever it is required in Apex).

Experience in using DBMS_SCHEDULER to run jobs in parallel to improve time-constrained performance.

Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.

Involved in migration of Oracle Apex 4.2 to 5.1.

Technical Skills:

Programming Languages

Apex-Oracle, PL/SQL, SQL

Technology Framework

Oracle APEX 4.x, APEX 5.x

Operating Systems

Windows XP and Windows 7

Web Technologies

HTML, JavaScript

Application IDE

Oracle Application Express

Career Profile:

Dates

Organization

Role

Domain

17-Aug-2016 to till

Tech Mahindra Limited

Sr Software Engineer

Apex-Oracle,PL/SQL, JavaScript

30-Dec 2014 to 12- AUG-2016

IBM India Pvt. Ltd.

Software Engineer

Apex-Oracle,PL/SQL, JavaScript

24-Dec-2013 to 24-Dec-2014

Oracle India Pvt Ltd.,

Sr.Software Engineer

Apex-Oracle, PL/SQL,Javascript

4th-July-2011 to 18-May-2013

ProSaamya Systems(I) India Pvt. Ltd.

Software Developer

Apex-Oracle, PL/SQL

Professional Experience:

Project Title

Revenue Assurance

Time Period

March 17 – Till

Framework

Oracle APEX 5.x

Role

Sr.Software Developer

Responsibilities

Involved in migration of Apex 4.2 to 5.1.

Analyzed application and create checklist

Worked on front-end designing and backend PL/SQL scripts

Developed APEX Pages, Page Process, IR Reports, IG Reports, Classic Reports

Updated, Java script and Ajax for attractive front end.

Testing the pages and solving the errors.

Attending status calls and updating the status

Involved in updating procedures, functions, triggers, and packages for validation based on the client requirement.

Client

British Telecommunication(BT)

Description

Revenue assurance is a practical response to perceived or actual issues with operational under performance, most commonly relating to billing and collection of revenue. revenue assurance varies greatly between telecommunications service providers, but is usually closely related to back office functions where small errors may have a disproportionately large impact on revenues or costs.

Project Title

AS Watson Retail Application

Time Period

Aug 16 – March 17

Framework

Oracle APEX 5.x

Role

Sr.Software Developer

Responsibilities

Developed APEX Pages, Page Process, IR Reports, Classic Reports

Created Custom authorization and authentication for the application.

Used Collection, Java script and Ajax for attractive front end.

Testing the pages and solving the errors.

Attending status calls and updating the status

Designed and developed various custom packages triggers and forms.

Involved in updating procedures, functions, triggers, and packages for validation based on the client requirement.

Primary responsibilities included system analysis, coding, testing, debugging

Good in creating users and maintaining their roles and responsibilities.

Client

AS Watson

Description

A.S. Watson Retail (HK) Ltd operates health and beauty retail stores in Asia and Europe with over 13,000 stores. It’s having oracle retail enterprise software and they are decided to move to oracle APEX. So migrating the Oracle Retail Objects to Oracle APEX. Currently WATSON is having oracle retail forms, reports, database objects and working on migration/Re-implementation from oracle retail objects to oracle apex.

Project Title

Uptake Management – Automate Uptake Process

Time Period

Dec 2014 – Aug 2016

Framework

Oracle APEX 4.x

Role

Software Developer

Responsibilities

Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.

Developed export CSV and Export to excel of APEX Reports.

Designed and developed various custom packages triggers and forms.

Involved in updating procedures, functions, triggers, and packages for validation based on the current requirement.

Good knowledge in front end development using oracle forms/reports.

Primary responsibilities included system analysis, coding, testing, debugging

Used Collection, Java script and Ajax for attractive front end.

Good in creating users and maintaining their roles and responsibilities.

Created Pages and different types of reports like classic report and interactive report.

Testing the pages and solving the errors.

Client

Maersk Line

Description

The purpose of this application is to establish an automated revenue optimization process based on input from new Origin and Destination forecasting process which will enable short term pricing and acceptance of the highest yielding cargo across all vessel legs in our network. The AUP solution covers both Revenue Optimization and the smaller UTM BI Sourcing project.

Project Title

ITR and Follow-up Tool

Time Period

Dec 2013 – Dec 2014

Framework

Oracle APEX 4.x

Role

Software Developer

Responsibilities

Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.

Experience in using DBMS_SCHEDULER to run jobs in parallel to improve time-constrained performance.

Created Custom authorization and authentication Based on Region and country level access.

Ability to effectively provide technical documentation.

Involved in updating procedures, functions, triggers, and packages for validation based on the current requirement.

Good knowledge in front end development using oracle forms/reports.

Created forms and reports

Testing the pages and solving the errors.

Provided export CSV and Export to excel.

Provided auto flag for survey based on access.

Client

Oracle Internal

Description

Customer satisfaction surveys can helps in determining how the customers are satisfied with the company, product, or service or with the assistance they’ve received on recent support issues. Service and marketing teams can also helps in understanding how the rules will trigger surveys.

Project Title

Beef Asset Pro

Time Period

Dec 2011 – June 2012.

Framework

Oracle APEX 4.x

Role

Developer

Responsibilities

Created Custom authorization and authentication for the application.

Reviewed and corrected programs

Prepared test case for the GUI screens and tested the application

Primary responsibilities included system analysis, coding, testing, debugging

Used Collection, Java script, SVG map for Feedyard map, page zero and jquery for attractive front end

Modifying the procedures and functions based on the requirements

Created Functions, Procedure and triggers

Created forms and reports

Client

GAM, USA

Description

Beef Asset Pro is software developed by Cattle Investors, Inc., to address the increasing needs of feed yards, cattle owners, packers and financial institutions to better manage cattle through the feed yard process to maximize return. It will help you better manage your conventional and program cattle to maximize efficiencies and profits. It will help you get more customers for greater economies of scale and revenues. It will help you attract more packers who will prefer working with your operation.And It will help you get better financing and preferred terms since you produce more consistent profits

Project Title

Equine

Time Period

July 2011 – Dec 2011.

Framework

Oracle APEX 4.x

Role

Developer

Responsibilities

Created Custom authorization and authentication for the application.

Understanding the client requirements by studying functional document

Was involved in creating tables, functions, procedure, triggers, views and packages using SQL Developer.

Involved in the preparation of test data

Modifying the procedures and functions based on the requirements

Primary responsibilities included system analysis, coding, testing, debugging

Involved in Debugging, Troubleshooting Procedures, functions, packages, customizing the existing ones within tight deadlines

Prepared test case for the GUI screens and tested the application

Created upload routine to upload data from Excel sheet in our database.

Used Collection, Java script, SVG map for Feedyard map, page zero and jquery for attractive front end.

Was involved in bug fixing, documenting, moving the application through different environment ( dev - QA- Demo, Production).

Client

GAM, USA

Description

The provision of a state of art application to support the processes and supply chain of this industry will capture and sustain its economic productivity. The need to capture relevant details related to an individual horse and to track its progress in equestrian events benefit new and previous owners equally. These traits are important to breeders who rely on pedigree, a mandatory requirement for participation in many events.

Equine application provides end to end information at ranch and individual horse level that can be accessed upon logging to the from anywhere. It enhances data management efficiency..

Educational Qualification:

B.Tech in Electronics and Communication Engineering (ECE) from St. Theressa Engg. College, Vizianagaram, Andhra Pradesh, India. Affiliated to JNTU Kakinada completed in Nov 2009.

Achievements:

Awarded the ‘Group Excellence Award’ for successful implementation of Equine project from ProSaamya

Stood 4th in a robotics event called “Get A Grip” at Shaastra-07 conducted by IITM, Chennai. Our machine implements unique Multimotor drive mechanism that had high degree of accuracy.

Personal Details:

Name

Kanaka Raju Mantri

Date of Birth

01 July 1984

Gender

Male

Marital Status

Single

Nationality

Indian

Passport

H5519930

Permanent Address

D.NO 26-32-4,Ramakrishna Street,

Visakhapatnam – 530001,Andhra Pradesh

Present Communication Address

Flat# 202, 3rd Floor,Sadhana’s Kowmudhi Residency, Plot A12, Apuroopa colony, Pragathi Nagar, Opp JNTU, KPHP, Hyderabad – 500072, Telangana.

Contact this candidate