EXPERIENCE SUMMARY:

• 9+ years of experience in Oracle Applications as Techno Functional Consultant in System Analysis, Design, Development, Customization, Interfacing, Implementation, Support and Maintenance of business applications using Oracle EBS.
• 3 Years of experience working in onsite offshore model and customer facing role.
• Proven hands on experience in gathering requirements from users, design and implementation of customizations including preparation of MD050, BR100, CV040, MD070, MD120, development of technical objects like PLSQL packages, customization of Forms, reports, interfaces, API’s and Oracle Alerts
• Extensive experience in implementation, Migration, Customization, Production and support of various modules in Oracle Applications with major focus in Purchasing (PO), Accounts Payables (AP), Accounts Receivable (AR), General Ledger (GL), EBTAX, IExpense
• Technically proficient in RICE components (Reports, Interfaces, Conversions, Extensions), FORMS, XML/BI publisher, WORKFLOW.
• Extensively worked on development and customization of XML reports and templates including customization of XML templates for AP payments check printing, PO printing and other standard Oracle XML/BI reports
• Expertise on designing and implementing Oracle Alerts and Lookups. Descriptive flex fields, Key Flex fields, profiles, security profiles.
• Extensive Experience on Materialized views, Collections like Nested Tables, Objects, Autonomous Transactions, Dynamic SQL, SQL* Loader.
• Working experience in data extraction, transformation and loading operations into oracle using SQL Loader, External tables, DB links, Export/import and UTL FILE to read and write the files.
• Skilled in developing complex Inbound and Outbound Interface programs.
• Good working experience in loading and generating XML files through Oracle DB.
• Extensive experience in customizing existing form through form personalization and creating new DFF's, values sets, lookups, concurrent programs, executables, request groups, request sets and responsibilities. Experience in developing new workflow as well as customization of existing standard workflow.
• Proficient in developing and maintaining of packages, functions, application procedures, stored procedures, triggers, tables, indexes, views using Oracle PL/SQL database programming Language and maintaining the DDL scripts.
• Played an interface role between business and IT in seeking business requirements; provided various proof of concepts to demonstrate the product capabilities, articulated the customer requirements and contributed to the technical designs for most of the engagements. Prepared technical\functional design specifications.
• Experience in implementing third party vendor software which are integrated with Oracle. Example: Vertex, Markview, SMART Tool Etc.
• Played onsite Coordinator\Designer\Lead Developer\SME roles at USA& India and was solely responsible for the delivery of the integration projects under stringent deadlines.
• Handled various in - house s related to Oracle Integration technologies across geographic locations.
• Worked along with DBAs\peers for production migrations, participated in production preparedness meetings and suggested the impacts upon deployments & operations and supportability to ensure timely and uninterrupted service for the end user, provided the effort estimations, contributed to production migration, handled postproduction issues and performed root-cause analysis to ensure the issues are properly closed.
• Expertise in developing forms using Forms 6i/9i/10g.
• Experience in designing Data Conversion programs both inbound and outbound to integrate Oracle Applications modules to import data from various sources using PL/SQL, SQL*Loader.
• Capable of Performance Tuning, Optimizing SQL and PL/SQL scripts.

TECHNICAL SKILLS:

ERP: Oracle EBS 11i/11.5.10, Oracle EBS R12 (12.1.3 & 12.2.4)

Ticketing System: Service Now

Source Control Tool: Source Version Check (SVN)

Modules: AOL, PO, Iprocurement, IExpense, AME, AP, AR, GL

Database Language: SQL, PL/SQL, Advanced PL/SQL

Technical Tools/Application: Oracle Forms Builder, Oracle Report Builder, Workflow Builder, OA Framework, BI Publisher, Toad/SQL Developer, Vertex, Markview

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Oracle Apps Techno Functional Lead

Responsibilities:

• Responsible for leading Capgemini team for Confidential US region and responsible for all the deliverables.
• Daily standup calls with Offshore and other regions (Australia and UK).
• Responsible for all the overall Technical as well as functional deliverables including service incidents related to production instance as well as change request.
• Prioritize outstanding defects and system problems, ensuring accuracy and deadlines are met.
• Work on Month End and Year End Issues.
• Work on P1 and P2 critical issues impacting production. Take proactive actions on the tickets those are business critical.
• Co-ordinate with Offshore Team along with Task allocation, Status monitoring and ensuring quality & timely delivery of the deliverables.
• Review all the tickets daily and provide guidance to team members on complex tickets.
• Development of custom workflow for User Access Provisioning.
• Daily monitoring of SLA for all the tickets and ensure none of them are breached.
• Review of statistic to identify the tickets counts and work along with business user to stream line repetitive issues and conduct in case of any process gap.

Environment: Oracle EBS 12.2.4, Database Oracle 12c, JDeveloper 10g, Workflow builder, Toad

Confidential, Overland Park, KS

Oracle Apps Technical Lead

Responsibilities:

• Responsible for managing the overall Technical deliverables including service incidents related to production instance & Minor Enhancements.
• Prioritize outstanding defects and system problems, ensuring accuracy and deadlines are met.
• Work on Month End and Year End Issues.
• Work on P1 and P2 critical issues impacting production. Take proactive actions on the tickets those are business critical.
• Co-ordinate with Offshore Team along with Task allocation, Status monitoring and ensuring quality & timely delivery of the deliverables.
• Review all the tickets daily and provide guidance to team members on complex tickets.
• Development of custom workflow for User Access Provisioning.
• Daily monitoring of SLA for all the tickets and ensure none of them are breached.
• Work with Third Party Team and Vendors like Vertex, Markview etc for integration related issues which impact the business.
• Prepare and presentation of weekly, monthly and quarterly status report to business stakeholders and CIO Office.
• Review of statistic to identify the tickets counts and work along with business user to stream line repetitive issues and also conduct in case of any process gap.

Environment: Oracle EBS 12.1.3, Database Oracle 12c, Confidential O Series, JDeveloper 10g, Workflow builder, Toad, Oracle Form 10g, Oracle Reports, Filezilla, CRT

Confidential, Overland Park, KS

Oracle Apps Technical Lead

Responsibilities:

• Interacted with the client at onsite and worked on the project documents, proof of concepts; ensured that all the deliverables were reviewed and signed off by the client.
• Played Oracle onsite Coordinator\Designer and took responsibility for the entire delivery of the project. Managed the entire team through the project lifecycle.
• Involving in Technical design meetings for the requirements and preparing solution design of the requirements.
• Worked along with the business SME’s and CIO office in gathering the requirement and translating the same in technical terms.
• Responsible for creating designing the custom page for User access provisioning.
• Creation of custom lookups and value set.
• Design and development the custom Workflow to automate the approval process.
• Complete development of PL/SQL package used by the workflow approval process.
• Resolving Functional/Technical Issues, preparing move sheets to migrate the code across the instances.
• Prepare and presentation of weekly, monthly and quarterly status report to business stakeholders and CIO Office.

Environment: Oracle EBS 12.1.3, Database Oracle 12c, Workflow builder, Toad, Filezilla, CRT

Confidential, Overland Park, KS

Oracle Apps Technical Lead

Responsibilities:

• Study of changes needed to replace existing TaxWare system with Vertex.
• Creation of New Regime, Jurisdiction, Tax, Tax Rates Etc setup in EBTax for Vertex.
• Developing program to end date Item Category Code, Add New Category Code, Item Category Assignment using standard oracle API’s.
• Working along with Confidential Implementation team in doing the setup related to Confidential in Oracle EB-Tax.
• Process ORAMAST file in Oracle to load rate files in Oracle.
• Developed XML Publisher/BI reports.
• Customization in ePOM (Custom module implemented in B&V) to use Confidential for Tax calculation.
• Preparing validation script and program to ensure Confidential connectivity is established between Oracle EBS and Confidential Application.
• Conduct UAT with Business Users.
• Present Weekly and Monthly status to Business Users and CIO Office.

Environment: Oracle EBS 12.1.3, Database Oracle 12c, Confidential O Series, TOAD, Filezilla, CRT

Confidential, Overland Park, KS

Senior Oracle Developer

Responsibilities:

• Requirement gathering and providing technical solution for it.
• Design complete Table structure and technical data flow diagram for the custom module.
• Designing Custom Oracle forms and Reports with XML publisher
• Developing complex Inbound Interfaces to pull data from NORAD to load EDI 850 and 860 details in Oracle.
• Develop outbound interface to send across invoice details as to NORAD for daily reconciliation between Oracle and NORAD.
• Developing complex request set containing sub programs to validate data and use standard API’s to import AR invoices into Oracle.
• Develop notification mechanism using shell to handle error reporting to the business stakeholders responsible for the activity.
• Form and OAF personalization of custom pages as per requirement.
• Preparing User Guide for the module as well as Technical document for the programs developed.
• Preparing scripts for data migration to Production.
• Educating peers and Support team about the ePOM module and helping them in fixing bugs.

Environment: Oracle EBS 12.1.3, Database Oracle 11g, Oracle Forms 10g, TOAD, Filezilla, CRT

Confidential, Overland Park, KS

Senior Oracle Developer

Responsibilities:

• Requirement gathering and designing the complete architecture of the process from Oracle perspective.
• Developed PO Interface using Standard API’s.
• Adding and customizing the validations as per the requirement and accordingly processing data.
• Working with the Client and Third party independently and making them understand about the Oracle Process and data requirement to process in Oracle.
• Preparing User Guide for the module as well as Technical document for the programs developed.

Environment: Oracle EBS 12.1.3, Database Oracle 11g, Oracle Forms 10g, TOAD, Filezilla, CRT

Confidential, Albany, NY

Senior Oracle Developer

Responsibilities:

• Part of the R12 upgrades Team.
• Analyze existing 11i objects that would need change when upgraded to R12.
• Develop supplier interface in R12 using standard API’s in R12.
• Worked with business analysts to translate business needs into functional and technical specifications and process flows.
• Developed an interface that gets the data from the Legacy system for Project Interface and process it in SSS environment.
• Developed a Customized Request set with sub-programs.
• Developed PL/SQL validation procedures and loaded PO’s from legacy system to SSS using SQLLDR.
• Developed programs for mailer notification of error records through UNIX Shell.
• Provided day to day technical and functional support to end users.
• Worked on extensive troubleshooting problems of diverse scope.
• Done the Complete Unit testing of the project.
• Prepared installation scripts to move the code from DEV to UAT and PROD instances.

Environment: Oracle EBS 12.1.3, Database Oracle 11g, Toad, Filezilla, APPWORX, PVCS, Rightfax.

Confidential, Albany, NY

Senior Oracle Developer

Responsibilities:

• Worked with business analysts to translate business needs into functional and technical specifications, process flows.
• Developed A Concurrent Program which takes care of complete validation before End dating.
• Developed program for notifying users before end dating through UNIX Shell.
• Scheduled the program through APPWORX.
• Provided day to day technical and functional support to end users.
• Prepared MD200, UTC.
• Done the Complete Unit testing of the project.
• Prepared installation scripts to move the code from DEV to UAT and PROD instances.

Environment: Oracle EBS 12.1.3, Database Oracle 11g, Toad, Filezilla, APPWORX, PVCS, Rightfax

Confidential, Albany, NY

Senior Oracle Developer

Responsibilities:

• Standardize the report which can be used across all GE business and supporting it with a single Package.
• Developed a Single package which can be used across all GE Business.
• Prepared COOK BOOK having complete setup process.
• Provided KT for the same for all the setup required.
• Effectively communicated to users in all the phases and the work was highly appreciated by the client.

Environment: PL/SQL, JAVA, ADF, Eclipse, RAD Tool, Rational Clear Case, Winscp

Confidential

Software Developer

Responsibilities:

• Development of Forms using ADF.
• Understanding the requirement & designing new Screens. Designing & coding the functional workflow of the screens.

Environment: PL/SQL, JAVA, ADF, Eclipse, RAD Tool, Rational Clear Case, Winscp

Confidentia

Software Developer

Responsibilities:

• Development of Forms using ADF.
• Understanding the requirement & designing new Screens. Designing & coding the functional workflow of the screens.
• Designing new screens coding for functional screens. I was handling Payment & Collection Module
• Coding and validation of code using SQL and PL/SQL Language.

Environment: PL/SQL, JAVA, JavaScript, XML, RAD Tool, Rational Clear Case, Winscp