SUMMARY:

• Over 8 years of experience in requirement gathering, analysis, database design, software programming, testing, documentation, deployment, maintenance and up gradation of applications using Oracle (SQL, PL/SQL), Oracle Forms and Oracle Reports
• Extensively worked on page development and customization in 11i using Oracle Application Framework (OAF).
• Proficient in implementing project in Agile/SCRUM methodology.
• Great working experience in PL/SQL programming and integrating PL/SQL with OAF.
• Excellent knowledge in MVC Architecture used in Oracle Application Framework (OAF)
• As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.
• Expertise in creating and modifying database objects like Tables, Indexes, Views, Triggers, Synonyms, Sequences, and Materialized views using SQL and PL/SQL.
• Expert level experience on PL/SQL that includes Cursors, Ref - cursors, Procedures, Functions and Packages, Object, and Table Indexing.
• Expertise in using user defined and system defined Exceptions for Error handling.
• Experience in creating composite data types and collections.
• Developing Unix Shell Scripts to Execute the Database Packages and Procedures on daily basis.
• Worked on integration of Sales Force application with a custom application by hitting SOAP/Rest web services.
• Good Knowledge in applications in PL/SQL, developing applications in Oracle Forms and Oracle reports.
• Migrated OAF Pages from development to production instance.
• Excellent interaction with all levels of management, customers, development team members and stakeholders.
• Quick to learn about new business industries and models with excellent organization skills.
• Work under tight schedules with good problem solving skills.
• Created mappings using expression transformations, filter transformations, join transformations, aggregate transformations and stored procedure transformations in Informatica.
• Administrating and fulfilling the user needs.
• Good support, development experience.
• Expert in preparing and giving presentations.
• Trained new joinees in OAF and PL/SQL.
• Lead onsite team by proactively coordinating between onsite and offshore team.
• Performed unit testing, documented unit test cases and code review for QA.
• Understood C101 documents and created P950 documents required for development in JIRA tool.
• Worked on AIM documents like MD 50 and MD 70 to understand technical/functional requirements and TE 20 to prepare unit test case documents.
• Ability to understand the requirement and implement quick logical solutions.
• Took part in scrum, sprint review, sprint retrospective and grooming sessions as part of AGILE/SCRUM environment.
• Excellent analytical, communication skills and a good team player.
• Working experience in Oracle EBS components, AOL objects.
• Working experience on Application Development Framework (ADF).
• Good working experience in Interface using APIs and SQL programming.
• Worked on development, support and UAT issues on RICE components in R12.
• Got trained in Oracle standard O2C cycle and P2P cycle and the modules involved like AR, AP, OM, GL, INV, SCM.
• Working knowledge on Oracle workflows and XML publisher reports.

TECHNICAL SKILLS:

Programming Languages: Oracle 10g/11i/12cOracle Forms/reposts, PL/SQL, JAVA,XML

Declarative Languages: SQL

Database: Oracle 9i/10i

Database Tools: SQL Developer, TOAD

Development Tools: JDeveloper (9i, 10g), BI Publisher, Report builder (6i, 10g), Workflow Builder, Informatica

Tracking Tool: Rally, JIRA

Environment: UNIX, shell scripting

Framework: Oracle Application Framework (OAF), Application Development Framework (ADF)

Operating System: WINDOWS XP

PROFESSIONAL EXPERIENCE:

Confidential, Birmingham, AL

ORACLE Techno Functional Consultant

Responsibilities:

• Analyzed data and created a design document of a legacy reporting system developed using Microsoft Access and currently migrating to oracle.
• Creation of interface screens and reports using oracle forms and oracle reports.
• Create procedures and packages for new modules.
• Generate ad-hoc reports using TOAD.
• Worked on migrating application from oracle forms and reports version 6i to 10g.
• Worked extensively on analysis, design, development, testing, maintenance and enhancement of abacus application using oracle forms and oracle reports.
• Created procedures, functions, packages and database triggers using SQL and PLSQL.
• Worked on creating reports for all users including finance, award tracking, logistics and other OFDA teams.
• Developed the ProC programs to support the Label printing and Purchase Order worksheet.
• Developed numerous Custom Oracle Forms and Reports using Forms and Reports to interact with the Staging tables created through SSRS packages on daily bases as per the user requirement.
• Migrate the existing Bank customer's data from legacy system to Financial System using SQL Loader and PL/SQL stored procedures for business validation
• Responsible for preparing and performing unit testing and system testing of the application.
• Worked extensively in up-gradation of oracle database, oracle forms and oracle reports to the latest versions.
• Worked on UNIX shell scripts to automate report generation.
• Used tools SQL Navigator and Toad for development and creating ad hoc reports
• Designing dataflow diagrams using Visio and prepared data model using Erwin.
• Worked on customizing application for use at State Department's Bureau for Population, Refugees, and Migration.
• Created manuals, cheat sheets and other documents about the system.
• Responsible for identifying changes in database and user interface screens for numerous application releases done on abacus system.
• Worked on internet application server for deployment of the system on the web.
• Involved in user management including creating new users, password resets, access control, and other related tasks.
• Provided technical assistance to end users on system usage.

Environment: Oracle 10g/11g, Oracle Forms/Reports, PL/SQL, TOAD, SQL*Loader, UNIX Shell Scripting, MS Visio, Informatica 9.6.1

Confidential, Buffalo, NY

ORACLE Techno Functional Consultant

Responsibilities:

• Designed Business Required Documents and detailed Functional Design Documents for Financial modules.
• Involved in Oracle analysis, design, development, testing and implementation of the core AR package.
• Implementation of Oracle Accounts Payables to its integration with PO, CE and GL.
• Worked towards Future business flows, Identification of Gaps, Workarounds in order to provide an Integrated Procure to Pay (P2P) business flow.
• Developed Custom Programs to load Data item into Interfaces in Account Receivables (AR)
• Worked on implementing Oracle Inventory to Cash business flow as part of Procure to Pay (P2P)
• Performed Setup steps, defined various Key Flex fields and Descriptive Flex fields for Financial Modules AP, AR, GL.
• Responsible for changing existing forms and reports of Customized Account Receivables (AR)
• Creating and Approving AR Invoices.
• Set up of Account Receivables (AR)
• Define user responsibilities, set up custom menus based on user Responsibilities during Procure to Pay (P2P) implementation.
• Worked as a liaison between the Key Users and Headquarters in order to understand corporate requirements.
• Data migration from Legacy systems - APIs and Open Interfaces.
• Analyzed e-Business Suite system configuration and development changes using Gap analysis.
• Performed Data Validation on Invoice, Payment, Suppliers, Employee Suppliers and Expense Reports data during Conversions.
• Customized applications using Forms Personalization to extend client side validation
• Developed PL/SQL procedures to load Price list Data (Qualifiers, Modifiers and Price Lists)
• Worked towards developing and troubleshooting XML publisher reports.
• Worked on assessing XML publisher reports for batch reporting needs.
• Developed a XSL template for customizing the AR Sales profit report using XML/BI Publisher and distribute the offer document generated from XML Publisher.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS

Environment: Oracle Applications R12 (GL, AP, AR, OM, INV, PO), WINDOWS 7, SQL, PL/SQL, SQL * Plus, Oracle Forms/Oracle Reports, TOAD, SQL*Loader, Shell Scripts, SQL *Loader, SQL Plus, SQL Developer, UNIX, Windows XP

Confidential, Windsor, CT

OAF Developer

Responsibilities:

• Proposed Changes to the existing Database Architecture as per the requirement.
• Drafted a Solution Design Documentation for the proposed changes to the database.
• Changed the Architecture of the Current data flow along with their Exception Handling methodology to handle the unprocessed Transactions.
• Produced physical data models and suggested proper indexing that promotes fast data retrieval.
• Designing, Developing, Enhancing and Maintaining Data warehouse Oracle ETL Processes, PL/SQL scripts, DB Procedures, DB functions, creating tables and indexes.
• Worked on XML pages, java classes and OA pages along with BC4J components for validation and updated records to the oracle database based on the validation checks.
• Imported/Exported different PG files using standard oracle import/export utility for modifications.
• Developed Model Objects like Entity Objects, View Objects, and Application Modules.
• Developed OAF Pages that calls PLSQL packages using Oracle Callable Statement.
• Developed OAF pages that employ DML operations insert, update, delete, SPEL Simplest Possible Extension Language, PPR Partial Page Rendering and Independent and Dependent LOV's.
• Migrated OAF Page Customizations from development to production instance.
• Interaction with the End users for the Functional requirements and Design specifications on daily basis as part of Agile methodology.
• Tuned the SQL Queries by Statically Analyzing the Database Tables.
• Created Stored Procedures, functions, and packages as per ETL Framework.
• Modified Existing Packages, Procedures, Functions, and transformations as per the New Architecture.
• Extensively performed Unit Testing with different test cases.
• Provided Test Data to QA team for validation.
• Created and altered database Objects as per business requirements.
• Create a risk plan and list all the mitigations.
• Present the change requests for approvals during post production support.
• Took part in scrum, sprint review, sprint retrospective and grooming sessions as part of AGILE/SCRUM environment.
• Involved in Technical Documentation, Unit test, Integration Test and writing Test plan.

Environment: Oracle Applications 11i, PL/SQL, Oracle Quoting module, Oracle Application Framework (OAF), MS Visio, Rally tool.

Confidential

OAF Developer

Responsibilities:

• Analyzed the requirements and gave estimates for the task.
• Created 8 new OAF pages.
• Involved in the design and development of various PL/SQL and OAF components.
• Worked on integration of Oracle sales order creation into new iConnect application.
• Provided solutions for integration of iConnect application with Oracle Quoting module.
• Worked on Oracle EBS interfaces to implement standard Oracle functionality for different products in iConnect application.
• Created PLSQL interfaces to load data into iConnect application using upload functionality (only CSV files).
• Developed ValidationReport.jsp to extract data from front end pages of iConnect application
• Used standard Oracle APIs to create Oracle quotes from iConnect application.
• Involved in designing and development of business rules and transactions using BC4J components.
• Worked on different BC4J Components for customizations. Created AM (Application Module), VO (View Objects) and CO (Controllers).
• Worked on Transient View Objects, PPR to render and hide fields based on the button event.
• Imported/Exported different PG files using standard oracle import/export utility for modifications.
• Created new OAF pages which includes custom simple search, advanced search, PPR (partial page rendering) select option, committing data through EO (Entity Objects)
• Calling plsql packages from the OAF page to submit the concurrent request.
• Creation of search pages and drill down pages for the unapproved forms for detailed information allowing to update the data in the pages and resubmit it for triggering of plsql packages.
• Provided software development support by building, testing and deploying Oracle 11g SQL and PL/SQL queries, packages, procedures, functions, triggers, forms and reports. Modified and updated existing ProC code,
• Developed OAF Pages that employs the concept of SPEL for implementing the PPR (Partial Page Rendering) using JDeveloper.
• Migrated OAF Page Customizations from development to production instance.
• Created PL/SQL stored procedures, packages and functions to validate the inbound data of iConnect application.
• Performed unit testing, design and code reviews as part of QA.
• Took part in scrum, sprint review, sprint retrospective and grooming sessions as part of AGILE/SCRUM environment.
• Prepared unit test case documents.
• Migrated files using WINSCP FTP server.
• Interacted with client on daily basis as part of agile methodology.
• Provided post production go-live support.

Environment: Oracle Applications 11i, PL/SQL, ProC, Oracle Quoting module, Oracle Application Framework (OAF), MS Visio, Rally tool.

Confidential

Oracle Techo-Functional Consultant

Responsibilities:

• Generated SQL and PL/SQL scripts to install building database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants, and synonyms with oracle 10gdatabase.
• Created complex functions, stored procedures, and packages by using PL/SQL.
• Responsible working with user groups, analyzing reported problems, performing root cause analysis and presenting alternatives to correct the problem.
• Developed back end interfaces using PL/SQL packages, stored procedures, functions, Object Types and used Collections, Bulk Collects to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
• Wrote complex SQL queries using Joins, sub queries and inline views to retrieve data from the database. worked in Creating, maintaining, and implementing oracle forms application enhancements and reports that interact with an Oracle database
• Created Cursors, Collections, and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Worked on various tables to create Indexes to improve query performance.
• Involved in Data Extraction, Transformation, and Loading (ETL process) from Source to target.
• Developed complex triggers in reports before/after for validation of user input.
• Performed unit testing and supported integration testing and end user testing.
• Extensively worked on production issues with effective defect management.
• Proactively tuned SQL queries and performed refinement of the database design leading to significant improvement of system response time and efficiency.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using EXPLAIN PLAN etc.
• Facilitate timely approval of major milestones, approvals, and signoff.
• Report the project status and generate milestone reports.
• Communicate with developers, database administrators, project managers, Systems analysts and senior management about the issues that impact the project’s success.
• Facilitate and document the post implementation results in the form of closure reports.
• Developed the Error Logs Information for the failed transactions and procedures to handle them.
• Responsible for data analysis, engineering, programming, implementation, and Support for the product.

Environment: s: Oracle 10g/11g, Oracle forms/reports, SQL, PL/SQL, SQL*Plus, Toad, HTML, XML.

Confidential

Oracle Techno Functional Developer

Responsibilities:

• Worked extensively on the Oracle reports and forms.
• Worked extensively on XML Publisher reports.
• Generated Oracle Forms and database objects through Designer.
• Customized the order line workflow in order management by changing one of the functions.
• Customized hundreds of reports to rebrand the company name, operation unit name and the report titles.
• Created BI Publisher Bill of lading report as per the client requirement.
• Customized invoice print report. Added few columns to the standard invoice print report.
• Customized the reps info form, added a tab canvas to the existing canvas and added all the fields to the related tabs in the canvas.
• Created couple of FsSG reports to show balances and budgets in some financial modules.
• Customized the pick slip and pack slip reports in order management.
• Customized workflows in various financial modules.
• Developed Open PO XML report by creating .RTF files.
• Customized the vendor report, added some columns to the existing tables. This report in particular shows weather they are women owned or minority owned.
• Worked on item conversions in inventory.
• Worked extensively in customizations of Workflows in Purchasing (PO).
• Developed reports from scratch in Project Accounting module.
• Worked with development of packages and procedures using PL/SQL.
• Registered Concurrent Programs and custom Applications using System Administration.
• Worked in customization of reports in Lease management module.
• Developed a backlog report. This is a custom report developed to find all the orders lines, which are not fulfilled, Order lines that are not shipped.
• Extensive experience working on all the phases of the development and customization of RICE components, which include documenting the specifications.

Environment: Oracle applications EBS 11i (11.5.10), R12, PO, PL/SQL, SQL*Plus, TOAD, Developer 2000(Reports 6i and Forms 6i), XML Publisher, Windows XP, UNIX, JAVA.