Objective
To obtain a position of responsibilities that utilizes my skills and experience and keen to work in an Environment where I can enrich my knowledge.
Professional summary:
- Having 5 years of experience as Oracle APEX developer and on Oracle apps Technical. I had been worked in Abu Dhabi for 3months for ADAC Airport Project. (Abu Dhabi Airport Company)
- Having 3+ years of experience in Application Development using Oracle Application Express(ORACLE APEX) with 5.1, 19.1, 19.2 and 20.1 versions.
- Developed complete Retail Sales data application of approx. 32 pages, to capture daily sales data from different concessionaires (customers) from Abu Dhabi international airport where we have list of customers for car rental as well.
- Worked on different validation on ORACLE APEX.
- Worked on sales transaction manual creation screen in oracle apex where user enter header, lines, tax, discount and payment information as well as they can able to apply tax and discount either at header level or at line level.
- Worked on development of LUMPSUM transaction manual creation.
- Developed integration status monitor page, where users can view success and failure of sales transaction’s interfaced data represented in calendar within 6hrs of time
- Worked on web services and REST APIs.
- Worked on PL/SQL Function Body returning SQL Query to get the list of values of particular SQL data based on other LOV selection.
- Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express(ORACLE APEX).
- Hands-on experience on forms migration in Oracle apex 5.1.
- Developed Time sheet application using Oracle apex 19.1 to share working hours details for approval from Manager (Designed and created to share details to clients mostly on wipro specific holidays).
- Worked on Email notification, custom authentication, authorization, list of values and dynamic actions in oracle apex.
- Having 2+ years of professional experience in ORACLE as an Oracleapps Techno-Functional analyst and SQL & PL/SQL Developer.
- Creating concurrent programs based on interface requirements (both inbound & outbound) and reports like rdf, rtf and xml.
- Strong skills include Oracle 11g, SQL, and PL/SQL.
- Involved in Month end closure activities on AP Module.
- Supported Issues on P2P (item, requisition, invoice supplier) and O2C Flow (Item, salesorder, Transaction and Customer).
- As a team member, participated in all types of releases and enhancement.
- Extensive experience in writing stored procedures, functions, packages and triggers.
- Proficient in PL/SQL and creation/modification of database objects like tables, constraints, views, indexes and sequences.
- Extensive experience in writing cursors and ref cursors as a part of the procedure to retrieve the selected data.
- Good knowledge UNIX server and UNIX Commands. Also, worked on WINSCP and PUTTY tools while deploying scripts on server.
- Excellent skills in Designing and Development of Oracle Database Objects, SQL*LOADER.
- Quick workaround of P1 issues with Troubleshooting of alerts and resolution as per SLA.
- Good in Understanding of Business logic and ability to work well as a part of a team and as an individual.
Education Qualification:
- MTech. from Velluru institute of Technology (VIT) in 2019.
- B.Sc. from Acharya Nagarjuna University (ASN Degree College, Tenali) in 2015.
Technical Proficiency:
Languages |
SQL, PL/SQL, CSS , HTML |
Databases |
Oracle 10g,11g |
Tools |
FSQL Developer, SQL Plus, Toad , WINSCP, PUTTY |
Report Tools |
Oracle 10g,11g |
Operating Systems |
Windows Family, Unix/Linux |
Projects Profile:
- Project#1:
Organization |
WIPRO |
Project Name |
OBP (British Petrolium) Oil & Gas |
Technologies |
Oracle 11g. |
Tools Used |
Toad, WINSCP , Putty , BI Publisher |
Description:BP is a British multinational oil and gas company headquartered in London, United Kingdom. It is one of the world's seven oil and gas company.
Roles & Responsibilities:
- Deployed and monitored the services proactively in production environment an Oracleapps Techno-Functional analyst and SQL & PL/SQL Developer.
- Developed interface requirements (both inbound & outbound) and reports like rdf, rtf and xml on change requests.
- Supported on issues on P2P (item, requisition, invoice supplier) and O2C Flow (Item, salesorder, Transaction and Customer).
- Checking Logs and providing solution to existing error if any.
- Analyzing route cause for increase in number of SNOW and REMEDY tickets and reducing it.
- File transferring through Putty and WINSCP on UNIX Server.
- Project#2:
Organization |
WIPRO |
Project Name |
ACTIVISION |
Technologies |
SQL, PL-SQL, CSS ,HTML , Javascript |
Tools Used |
Oracle Apex 5.1 |
Description:ACTIVISION is an American video game holding company based in Santa Monica, California. The company was founded in July 2008 through the merger of Activision, Inc.
Roles & Responsibilities:
- Supported APEX DATA VISION applications.
- Developed Master Detail, Detail reports using tabular and Group above reports.
- Supported on List of values creation, DASHBOARD Page Graphs.
- Worked on Email notification and dynamic actions.
- Hands-on experience on forms migration in Oracle apex 5.1.
- Developed Time sheet application using Oracle apex 19.1 to share working hours details for approval from Manager (Designed and created to share details to clients mostly on wipro specific holidays).
- In addition to Oracle support I worked on project management activities to lead teams and to supervise the Document updating with customer and in local handling internal team and conducting daily huddle call.
- Project#3:
Organization |
WIPRO |
Project Name |
ADAC Airport |
Technologies |
SQL, PL-SQL, CSS ,HTML , Javascript |
Tools Used |
Oracle Apex 19.1,19.2 and 20.1 |
Description:Abu Dhabi Airports Company was created on the 4 March 2006 and offers aviation-related services at Abu Dhabi's airports. The airports it is responsible for include Abu Dhabi International Airport, Al Ain International Airport, Al Bateen Executive Airport, Dalma Airport and Sir Bani Yas Airport
Roles & Responsibilities:
- Developed complete Retail Sales data application of approx. 32 pages, to capture daily sales data from different concessionaires (customers) from Abu Dhabi international airport where we have list of customers for car rental as well.
- Worked on 13 master screens development where we define all master setups for customers, shops, POS, item master, item category, tax, discount, transaction type etc...
- Worked on validations for each page to eliminate duplicate records, effective date from should be less than effective date to validation, effective to date should be greater than of effective date from while creating a record of end dated record etc.
- Worked on development of manual transaction creation, where user can create complete transaction header, lines ,discount ,tax and payment details in one page
- Worked on development of handling lump sum transaction manual creation, where user can enter tax and discount either at header or line level.
- Worked on JavaScript to capture transaction amounts from line details.
- Developed integration status monitor, where user can view success and failure records in calendar for interfaced data and in each 6hrs of interval of time.
- Developed screen to view success and failure records in a report for interfaced data
- Developed contract master screen where we need to define exclusions as per contracts. While data is entering through the screen, it will be validate by the validations of exclusions should be defined according to the duration of contract details and company and shop of the exclusions should be same as contract details.
- Worked on PL/SQL Function Body returning SQL Query to get the list of values of particular sql data based on other lov selection.
- Worked on Email notification, custom authentication, authorization, list of values and dynamic actions in oracle apex.
Hobbies: