Developer Oracle
Resume:
PROFESSIONAL SUMMARY:
Over **+ years of experience as Oracle PL/SQL, Forms and Reports developer.
8+ years of IT experience in the field of implementation, upgrade and maintenance of Oracle Application 11i/R12 suite.
Sr. Oracle Apps Consultant with a good exposure in system study, design, implementation and use of Oracle E-Biz Suite Application.
Good Functional and Technical knowledge in Procure to Pay Cycle.
Strong knowledge of Application Object Library (AOL) implementation standards, Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).
Extensive experience in developing applications using Oracle Forms / Reports. Experience in almost all the versions of Forms/Reports 6.0/6i/9i/10g/11g.
Extensively used PL/SQL to build Oracle Reports 10g and views for processing data, enforcing referential integrity and needed business rules.
Strong PL/SQL programming experience in creating Stored Procedures, Functions, Triggers and other database objects using SQL, PL/SQL and Shell Scripts.
Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
Experience in creating SQL loader scripts to load data from flat files into the database and also creating External Tables to manage data which is store at the OS level.
Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, EXPLAIN PLAN, TKPROF, SQL Trace and Table Partitioning.
Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, PL/SQL table, Cursors, Ref Cursors, Nested tables, Records, Types and Dynamic SQL for DML operations for better performance.
Extensively worked with third party database tools like TOAD and SQL Developer.
Good understanding of UNIX concepts and architecture.
Well versed with the concepts of SDLC (Software Development Life Cycle) and STLC (Software Testing Life Cycle) methodology.
Experience in creating SQL queries to facilitate UAT and perform data validation.
Documented QA and UAT Test Plans, test scripts, test cases for Surveillance models.
Experienced in development and execution of Test Plan, Test Scripts and Test Cases based on Design document and User Requirement document for testing purposes.
Excellent interpersonal communication and leadership skills. Strong presentation skills and the ability to communicate at different levels within the organization with exceptional problem solving and analytical skills.
Business analysis/Data Analysis experience with business processes in Oracle EBS ERP Apps Purchasing, Banking and Retails Data warehouse projects.
Experienced in integration of various data sources like Oracle 11g/10g/9i/8i sources into staging area and different target databases.
Have extensively worked in Expertise in Third party integrations using SQL Loader & Shell Scripts.
Worked with various stages in the software development life cycle like development, testing, implementation, maintenance and support.
Experience in working with different US Clients like General Electricals and Hanes Brands Inc.
Aggressively identify potential data quality issues; pinpoint trouble spots in data and processes; assess impact on customer needs and retention and make recommendations for improvement.
Perform research and root cause analysis of individual data issues.
TECHNICAL SKILLS:
Databases
Oracle 12C/11g/10g/9i/8i, MS SQL Server 2005/2000, Flat Files
Languages
SQL, PL/SQL, Unix Shell Script, Visual Basic,C
ERP
Oracle applications R12/11i B2P modules (PO, AP, SHRMS)
Tools
Toad, SQL* Loader, SQL developer, PL SQL Developer, Putty, PVCS,Kintana, Autosys Scheduling, Oracle Forms6i,9i, Reports. Clear Case, Putty
Operating Systems
Windows 2003/2000/NT, Unix
Certification
Oracle Certified Professional in both 9i & 11G (Advanced PL/SQL)
EDUCATION: Bachelor of Information Technology, Calicut University MAY-2005.
EXPERIENCE SUMMARY:
Client: Tracfone Wireless. Miami, FL Feb 2017 – Present
Production Support / Development.
Environment: Oracle 12C,Unix, TOAD, SQL Developer, SQL Plus, SQL*Loader, Korn Shell Scripting, PUTTY, CoreFTP
Role: Programmer Analyst
Objective of this project:
As part of Tracfone I am involved in the Data Services team of Tracfone Wireless who develops business solutions and support existing system in Telecom domain.
Responsibilities:
Customized and optimized existing PL/SQL packages, procedures and functions to accommodate change in functionality and better performance.
Developed PL/SQL Packages, Stored Procedures, and Functions in TOAD and SQL Developer.
Supported and developed custom interfaces for Inventory and other Supply Chain areas using Oracle E-Biz OFS order management system .
Used Toad and SQL developer extensively to create procedures for the Oracle forms 11g.
Worked on Korn shell scripts on UNIX platform.
Involved in developing and scheduling jobs to load the data into the database and export/import mechanism for data migration for bulk upload.
Used TKPROF and Explain Plan utilities to analyze the performance of the PL/SQL Stored Procedures and Packages.
Used BULK COLLECT approach for pulling records faster.
Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
Modified several program structures to introduce Performance Tuning techniques like Global Temporary Tables, Bulk Processing and Parallel Execution Methods to improve the performance.
Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Table space.
Developed data conversion procedures in PL/SQL. Involved in maintaining batch processing PL/SQL procedures for data extraction for feed creation.
Involve in the continuous enhancements and fixing of production problems.
Actively involved in day-to-day support activities by troubleshooting, providing solutions and communicating with the users through CA tickets.
Client: Hanes Brands Inc. Winston Salem, NC Aug 2015 – 2017 Feb
BI Datawarehouse Production Support / Development.
Environment: SQL Server 2014, Informatica, Oracle 10G,Unix, TOAD, SQL Developer, SQL Plus, SQL*Loader, Korn Shell Scripting, PUTTY, CoreFTP
Role: Associate Enterprise Solution Specialist
Objective of this project:
As part of HBI I am involved in the analytics team of Hanes BI who develops data warehouse loads and other reporting developments and give analytical details for Hanes top level management.
Responsibilities:
Customized and optimized existing PL/SQL packages, procedures and functions to accommodate change in functionality and better performance.
Developed PL/SQL Packages, Stored Procedures, and Functions in TOAD and SQL Developer.
Used Toad and SQL developer extensively to create procedures for the Oracle forms 11g.
Carried out Form Personalization in 11g for both conventional Forms and Self-Service Pages.
Designed and developed front end applications using Oracle forms 11g.
Developed Procedures, Record groups, LOV’s, and Triggers for Oracle forms 11g.
Maintained several customized reports using Oracle Reports 11g.
Used WEBLOGIC Server for Oracle Forms and Reports 11g.
Worked on Korn shell scripts on UNIX platform.
Involved in developing and scheduling jobs to load the data into the database and export/import mechanism for data migration for bulk upload.
Used TKPROF and Explain Plan utilities to analyze the performance of the PL/SQL Stored Procedures and Packages.
Used BULK COLLECT approach for pulling records faster.
Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
Modified several program structures to introduce Performance Tuning techniques like Global Temporary Tables, Bulk Processing and Parallel Execution Methods to improve the performance.
Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Table space.
Developed data conversion procedures in PL/SQL. Involved in maintaining batch processing PL/SQL procedures for data extraction for feed creation.
Involve in the continuous enhancements and fixing of production problems.
Actively involved in day-to-day support activities by troubleshooting, providing solutions and communicating with the users through CA tickets.
Client: General Electricals January 2011 – Aug 2015
Client (among top 10 companies in fortune 500 list) is moving its indirect Sourcing platform from oracle EBS 11i to R12. This is a multi-phase phase project and each phase is equal to each implementation. Application is considered as one of the world’s most complex business implementation of EBS on Purchase to pay track. Also, this application is referred as case study by oracle for R12 Development. As a part of project, we have to move whole sourcing application to EBS R12 with an objective of reducing the count of customization and brining application close to oracle.
Environment: Oracle 11g, PL/SQL, Reports 10g, Forms 10g, TOAD, Unix Shell Scripting, FTP, SQL*Loader, BI/XML
Role: Oracle EBS Technical Consultant
Responsibilities:
Understanding the existing business processes and interacting with the end users for finalizing the requirements.
Involved in Interface design from various Legacy sources, major interfaces I worked is HR interface .
R11 to R12 data migration was another key task.
Created PL/SQL Packages, Procedures, Functions, and Triggers.
Design and development of data validation, load processes, and test cases using PL/SQL Stored Procedures, Triggers, and Functions of Oracle 11g.
Customized and optimized existing PL/SQL packages, procedures and functions to accommodate change in functionality and better performance.
Wrote high performance queries using Collections, Nested tables, REF Cursors, Pipeline functions so forth.
Developed complex Oracle forms providing extensive GUI features like multi-selects drag and drop, graphical charts, automated system alerts and notifications etc.
Created Test plan for QA and implementation plan for production implementation once the unit test is done.
Used Explain Plan, TKProf for performance tuning of the PL/SQL packages, forms, and reports.
Modified several program structures to introduce Performance Tuning techniques.
Documented all Oracle forms and Reports, Stored Procedures, Packages, and Functions development specifications.
Experience in writing PL/SQL functions that return complex data types and collections.
Preparing test plan for the QA team for testing the code before moving from Systest to Production environment.
Provide ad-hoc reports and perform data analysis, performance tuning of applications.
Created Batch jobs, daily jobs, one time jobs and queues.
Developed Unix Shell Scripts to automate backend jobs, load data into the database.
Client: General Electricals January 2010 – January 2011
Environment: Oracle 11g, PL/SQL, Reports 10g, Forms 10g, TOAD, Unix Shell Scripting, FTP, SQL*Loader, BI/XML
Role: Production Monitoring Support
This project is one of the key projects for GE, monitoring various Buy to Pay applications with the help of Robots. This helps to proactively identify the issues such as lock, memory issues in server as well as in DB. Various types of alerts were involved in these projects
Responsibilities:
Monitor the alerts in each frequency based on the priority
Work with on call DBA to address the issues and take the necessary action.
Takes care of DB Outage and restarting of Concurrent Managers and Appworx.
Identifies the unauthorized access to the DB
Oracle Financial Services, Bangalore, India May 2007 – Dec 2009
Environment: Oracle 10G, Forms Developer 6i,Oracle report Developer 6i, RAD tool, Java script, Clear Case
Role: Associate Consultant
Responsibilities:
Responsible for gathering requirements from users for reports development and interface program customizations and in analyzing business process.
Customized and optimized existing PL/SQL packages, procedures and functions to accommodate change in functionality and better performance.
Involved in writing the database triggers to furnish the audit details.
Involved in master UI development for different Modules.
Worked on LD( Loan & Deposits), BC (Bills & Collections), LS(Loans & Syndication) modules
Had involved in requirement gathering from clients and propose solutions for the same.
Involved in Retrofit tasks, Testing, Development, deployment areas
Extensively used Dynamic SQL in Oracle Forms and Oracle Reports.
Trouble shoot issues with run time performance of the reports and use lexical parameters and bind variables wherever required to improve the performance.
Designed notification process for order movement using PL/SQL.
Developed Unix Shell Scripts to automate backend jobs, load data into the database.
Performance Tuning using Hints, Indexes, Explain Plan, TKPROF.
Performed SQL performance tuning for various PL/SQL packages, Oracle forms and Oracle Reports.
Actively involved and interacted with business users to understand the required functionality that needs to be developed.
City Real Estate, Kochin, India Jun 2006 - May 2007
Environment: Oracle Forms Developer 6i,oracle Reports Developer 6i,Oracle 9i DB
Role: Oracle Forms Developer
Responsibilities:
Involved in developing new reports and customizing standard reports using various report tools as per the requirement.
Designed data models and wrote SQL queries to retrieve data for Reports using Oracle standard Tables and Views in various Database schemas.
Developed Procedures and Packages using PL/SQL cursors that are invoked by report triggers to insert data in custom temporary tables.
Prepare the screens for various master data details including customer, tenants, and other services.
Prepare reports for various payment related data and the tenor.
Contact this candidate