SUMMARY:

• 9+ years of experience in Software Industry working widely under Analysis, Design, Development, Implementation, Upgrade, Maintenance, and Support of various applications using Oracle Tools.
• Solid experience in software development and practices. I have been involved in analysis, design, coding, testing, and upgrading phases of different projects. I have extensive knowledge on usage of other technical tools and technologies like Putty, WINSCP, Oracle Reports, E - Text Templates (NACHA,ACH (PPD, CCD)), XML Publisher, Forms, RICE Components, Web ADI, Panaya Tools (Upgrade), Data Loader.
• Having good expertise over functional flow of Oracle Application Modules which include Order Management (OM), Accounts Payable (AP), Cash Management (CM), Trading Community Architecture (TCA), Oracle HRMS, Shipping, Oracle Payroll, Purchasing (PO), General Ledger (GL), Inventory (INV), and Receivables (AR).
• Worked towards leading and managing, handling multiple stakeholders, execution of Project according to Project Plan, Risk management, Requirement analysis, produced high quality deliverable within Project timeline and budgetary targets.
• Involved in performance tuning using Explain plan and TK prof during the project upgrading while extraction of the data for validation. Having good understanding of Oracle built-in utilities like Explain plan and TK-PROF, bulk-binding and Optimizer hints which are useful in Performance Tuning
• I was involved in both 11i and R12 as well as project upgrade from 11i to R12 instance. During R12 upgrade had exposure to identify the R12 related tables which were changed due to the new tables in Cash management, Sub Ledger Accounting (GL), MOAC, E Business Tax modules. I have good knowledge and experience on the O2C(Order to Cash), P2P(Procure to Pay) and R2R (Record to Reporting) cycles.
• Worked in preparing the documents like CV60, MD70, FSUD, TSUD based on the business requirements gathering during the project development phase.
• I have performed the following roles in this time. Expertise includes analysis, design, estimation, coding, testing, migrating and maintenance of application software with good working knowledge in various platforms i.e. Oracle 10g/9i/8.x/7.x, SQL*Plus, PL/SQL, Forms 9i/6i//4.5, Reports 6i/2.5, Discoverer 10g/4i and Unix Shell Scripts, XML Publisher Reports.
• Good understanding of Code movement using FND LOAD for concurrent Programs, Request sets, AOL objects and BI Publisher templates, Value sets, Forms, Functions, Responsibilities, Menus, XML Data templates etc.
• Having good knowledge of Using Oracle Seeded API’s on several modules.
• Successfully accomplished numerous full cycle Oracle EBS implementations, Upgrade Projects and Support Projects across multiple industries in Public/Private Sectors.
• Having strong domain experience on Manufacturing, Healthcare and commercial.

TECHNICAL SKILLS:

ERP: Oracle Applications 11i Suite, Release 12

Databases: Oracle 8i, 9i, 10g, 11i, 12c

Oracle Applications: Sys Admin & AOL, Oracle Supply chain Management(SCM), Account Payables(AP), Receivables(AR), Cash Management(CM), Oracle Payroll, Core HRMS, Oracle Financials/ Manufacturing, Order management(OM), Inventory, PO, General Ledger

Languages: SQL, PL/SQL, C, C++, JAVA

Reporting Tools: E-Text templates (ACH (PPD, CCD), NACHA), Remittance Advice, XML Publisher, BI Publisher, Reports 6i, 10g, Auto Lockbox

Other Tools: Panaya Tool, TOAD, SQL Developer, Data Loader, SQL*Loader, Forms6i/10g, Reports 6i/10g, Bartender tool (Bar codes), WinSCP, Putty, QC(Quality Center), Oracle SOA Suite 10.1.3

Operating Systems: UNIX, Windows NT/XP/98/2000

PROFESSIONAL EXPERIENCE:

Oracle EBS Techno-Functional Consultant

Confidential, San Jose, CA

Roles and Responsibilities:

• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages, created scripts to create new tables, views, queries for new enhancement in the application.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Worked on Production Fixes, Analysis and Development of enhancement requests.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled offshore and onshore team as a team lead.
• Changes to programs that contain the SQL statements to data source to point new hierarchy tables.
• Coordinated with the business analysts and developers to discuss issues in interpreting the Requirements
• Task Allocation, Estimation, Task tracking, Quality Assurance, Project planning, Coding, Code Reviews, Technical assistance to team.
• Test developed program modules against prepared test cases.
• Ensuring quality, timeliness of product delivery and provided support 24*7 in maintenance duration.
• Identifying the objects which are affected with the changes in the GL Accounting.
• Modifying the Existing objects like OBIEE reports, Oracle PL/SQL Packages, RDF reports which are affected with the changes in the GL Accounting program.
• Enhancing the functionality for user to have a flexibility for add a few columns in the OAF. Worked on OAF customization to extend the functionality and provide the user with the required business need.

Environment: Oracle R12 EBS, GL, AP, PO, SQL, PL/SQL, OBIEE, OAF, XML Publisher Reporting.

Oracle EBS Application Developer

Confidential, Mountain View, CA

Roles and Responsibilities:

• Worked on the GL account flex field creation, enhancing the functionality of the future flex field values.
• Identifying the objects which are affected with the changes in the GL Accounting.
• Modifying the Existing objects like OBIEE reports, Oracle PL/SQL Packages, RDF reports which are affected with the changes in the GL Accounting program.
• Enhancing the functionality for user to have a flexibility for add a few columns in the OAF. Worked on OAF customization to extend the functionality and provide the user with the required business need.

Environment: Oracle R12 EBS, GL, SQL, PL/SQL, OBIEE, OAF, XML Publisher Reporting.

Confidential, Chandler, AZ

Sr. Oracle Techno Functional Consultant

Roles and Responsibilities

• Support Business Analysts/Systems Analysts in working SR issues with Oracle.
• Test and coordinate end user testing of patches to fix issues encountered.
• Work service tickets and Projects based on priority.
• Writes expert technical documentation to be used as training and reference materials for System Analysts as well as other IT staff.
• Create and maintain alerts, forms personalizations and Payroll fast formulas.
• Create, debug and run SQL / PL/SQL scripts to conduct data analysis, accuracy validation and data maintenance.
• Provide expert level knowledge, skill and experience to other Systems Analysts, IT Infrastructure Specialists, application super users and IT management;
• Provide support of the OBIEE and Noetix environment
• Attend Functional and Technical Oracle meetings as directed.
• Provides quality assurance relating to code changes, analysis, design, requirements and development
• Current Modules used at the City: HR, Payroll, Projects, iExpense, Financials, GL, AR/AP, - Reporting tools: Oracle Reports; BI Publisher - OBIEE and Noetix

Environment: Oracle R12 EBS, HRMS, Payroll, OBIEE- Noetix View creation, XML Publisher Reporting.

Confidential, Denton, TX

Sr. Oracle Techno Functional Consultant

Roles and Responsibilities:

• Involved in development of reports based on business requirements, documenting the requirements in TSUD based on the FSUD and registered them in Oracle applications. Built the reports with the records extracted as per the business requirements and tested the reports and prepared the test result documents with the test scenario’s as per the business test cases.
• Preparing training and knowledge sharing materials on Costing, Item Revisions, View Potential Shortages for the item using Microsoft PowerPoint
• Worked on Vendor sourcing rules, Blanket Purchase Agreements, Purchase Order Release methods in Oracle Purchasing.
• Creating the Training material documents on various applications in Oracle
• Creating Inter-org transfer setups for Inventory application in Oracle R12
• Worked extensively on Item categories, Category sets, Category codes and prepared the setups for Item categories in Inventory, Purchasing and Order Management modules.
• Setting up of ASL, Sourcing Rules, and Assignment Set for Inventory Min Max Planned Items with release generation method "Automatic Release" for auto generation of Blanket Releases and Standard Purchase Orders.
• Successfully implemented Order Management (Stock and sale, Drop Shipments and Internal Orders) using workflow and Shipping (Trip and Contained Management).
• Developed the customer conversion validation package to import the data from flat file(Lawson) to oracle using API’s and having good knowledge and hands on TCA (Trading Community Architecture).
• Worked on the Account Receivables for Auto Lock Box for importing the data using AR PAYMENTS ALL with SQL Loader and Dunning letter reports, extensions on Account Payable related financial modules with EFT and format payment related templates.
• I have worked on the conversions like Lease Management and invoice transaction in Receivable related objects in their new R12 Oracle EBS Financial Instance. I had experienced Lease Management in Property management module wherein I had an opportunity to develop the code for store master conversion and lease management conversion.
• Defined value sets, concurrent programs, request sets, registering reports and PL/SQL Procedures, and Packages.
• Involved in the development of interfaces/ Conversions to import the data from legacy system into oracle application base tables.
• Worked on UTL PACKAGE and SQL*LOADER for the interfaces and conversions. Performed the unit testing for the code and migrated the files through kintana tool.
• Involved in sysadmin activities and clearing monthly pending transactions. Purchase Report Detailed Item wise allows you to have a detail study of purchases Made during a given period using XML publisher.
• Developed Purchase order and Account Payables Invoice Report to display the PO and corresponding Invoice details.

Environment: Oracle R12 EBS, FSUS, TSUD, Creation of Items in Inventory (SCM), Setups for Order Management (OM), Costing and Inventory, Auto Lockbox, Dunning Report, SOA Integrated gateway WADL Service, Oracle payroll, Advanced PL/SQL, XML Publisher

Confidential, Denton, TX

Sr. Oracle Techno-Functional Consultant

Roles and Responsibilities:

• Worked on 2 US and one Canada based check printing over pre-printed stationary for bank of America and 7 EFT templates for NACHA, ACH (PPD and CCD) based format templates.
• Developed Remittance Advice for the EFT templates and the Positive Pay (PosPay) templates for the templates with the Positive Pay Instruction template format.
• Configured Account Payable related Format Payments, Payment Process Profile, Bank Accounts, Temporary EFT file location sets, Remittance Advice related setups.
• Custom report to obtain details on Purchasing, Receiving and Payables with in specified dates.
• Created Format Instruction Reports of ETF and WIRE payment method to be used by the system.
• Invoice Integration for the third-party tools like ECOVA, TAX, TAX HQ, POS, Freight, Garnishment I have used the Gateway Integration tool with which it is integrated with Rest Service and import the data to oracle.
• Involved in the Process Setup by defining the Key Flex Fields and Descriptive Flex Fields for Jobs, Positions, and Grade as per the company’s existing system.
• Created Value set with dependent, independent, table, special validation type to meet the business requirements to be used by the invoices. Worked on value set tables during validations in interfaces.
• Created a package which will be integrated with Rest Service and generate the XML at WebLogic and send in the data to oracle as part of XML and with Integration tool the data will be imported and migrated to oracle after business validation.
• Created multiple responsibilities of payables, HRMS, general ledger, cash management for US (United States), CA (Canada) and PR (Putorico) and extracted responsibility LDT for new instance during migrations.
• AP Invoices Interface which I worked will be importing the third-party data to oracle in multiple formats using the web service as an interface.
• Created the logic for AP Standard Invoices to interface with REST SERVICE (middleware tool) in getting the inputs and creating the records in oracle without any issues and triggering the standard oracle import program for populating invoices to oracle.
• I have used the tax software 3rd party tool in extracting the inputs and integrating the records to REST SERIVCE for spawning the oracle package for validating the records and populating to oracle.

Environment: Oracle R12 EBS, SQL, PL/SQL, E-Text Templates, XML Publisher, RDF, Oracle Forms, SOA Integrated gateway WADL Service, UNIX Shell Scripting, File Adapter, EFT Template (NACHA, ACH (PPD, CCD)), Check Printing for Bank of America, GL (Journals)

Confidential, Simpsonville, SC

Sr. Oracle Techno-Functional Consultant

Roles and Responsibilities:

• Solely responsible for format payments in payables module related migrations. Identifying the effected objects with the upgrade of the instance using PANAYA Tool and validating the objects and replacing the 11i tables with the relevant R12 tables.
• Involved in Functionally creation of payments and research on tables for populating.
• Worked on 15 complex EFT format payments for upgrade multiple OU’s and to find the replacement tables while creating payments.
• Retrofitted payment formats for Mexico, china and European countries for meeting their requirement for R12 upgrade.
• Worked with ONSITE team for getting inputs and generating the check printing for Bank of America, Dollar and Peso report which are one of the complicated reports.
• Upgrade Assessment of current business process in R11 (GL,AR and Cash Management)
• Impact analysis in current business process due upgrade changes/enhancements.
• Business process mapping with all standard and customized modules.
• Design test scripts of all sub-process identified in assessment phase. Prepared the UAT documentation for the clients to validating the changes for code migration.
• Unit testing execution for each business process.
• Analyze and test integration with 3rd Parties and legacy systems.
• Full CRP1, CRP2 testing cycles, with issue trackers and SME’s sign of.
• Full UAT testing Cycles, with issue trackers and SME’s sign of.
• Assisting in developing and testing software applications.
• Provided Training & Conducted Practice & Additional Business Requirements sessions
• Supported production environments and users on a daily basis by responding to emergency requests
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems

Environment: SQL, PL/SQL, E-Text Templates, XML Publisher, Oracle Report, Oracle Reports (RDF), Oracle Forms, Toad, SQL* Plus

Confidential

Oracle EBS Techno-Functional Associate

Roles and Responsibilities:

• Mainly involved in the ONSITE and OFFSHORE Communications for Issues gathering for updating the changes to meet the R12 related changes.
• Mainly involved in Oracle SQL, PL/SQL design & development.
• Involved in code review and SQL tuning.
• Solely responsible for all project related migrations and deployments to QC and production environments. I have experience in working with Quality Center a HP tool for test planning, test cases capturing with the test results of the development
• Involved in handled production problem tickets and issue resolution.
• Involved in post-production support.
• Mentored new team members.
• Involved majorly in the onsite support roles.

Environment: Toad, SQL Developer, SQL* Plus, MOAC, AOL Objects, Table Schema, SQL, PL/SQL, Oracle Report (RDF), XML Publisher.

Confidential, Milwaukee, WI

Oracle Technical Associate

Roles and Responsibilities:

• Involved in Payroll Creation Setup and running various processes, such as Payroll Run, Prepayments, Cheque Writer, Costing, Cost Break Down Report and finally to Transfer the payroll data by running the Transfer to GL process.
• Analyzing the issues using TOAD, providing the workaround to fix the issues, testing the workaround in TEST instances and providing the updates to Business.
• Extensively worked on Price Lists, Modifiers, Qualifiers, Pricing Attributes in Advanced Pricing and created the setups in TEST instance
• Defining and maintaining ABC classification of items for cycle counting procedures and maintained physical inventory procedures for inventory and sub-inventory locations in Inventory application
• Creating Job, Position, and Position Hierarchy in Oracle Purchasing Module.
• Mainly Involved in Design and Development planning.
• Provided support for OPM financials and Oracle financial apps.
• Supported system administration tasks and implemented Oracle projects.
• Documented financial reports, conversions and extensions.
• Created the conversion logic for populating the oracle base tables with the inbound transactions using EDI (Electronic Data Interchange).
• Requirement gathering and clarification of scope from Customer.
• Preparation of Impact Analysis for Efforts needed out of the scope.
• Solving the high-level issues from customers and Onsite counterparts.
• Involved in data migration of assignment information.

Environment: On-hand Conversion (SCM), Sales Order creation using API’s, Purchase Orders, Hierarchy for Job and Positions, Sub-inventory and locator setups, Oracle HRMS, Toad, Oracle Reports, Putty, SQL, PL/SQL

Confidential, Milwaukee, US.

Sr. Oracle Technical Developer

Roles and Responsibilities:

• Played a very crucial role in gathering the requirement and flat files for mapping the fields involved more on client calls.
• Reviewing the new requests and change the existing mapping based on the new business requirements.
• Prepared the Documentation for the mappings according to the Design logic used in the mapping.
• Resolved if any issues in transformations and mappings with help of Technical specifications.

Environment: Toad, Oracle apps functional setups, SQL, PL/SQL

Confidential, Milwaukee

Oracle Technical Developer

Roles and Responsibilities:

• Reviewed the new requests and change the existing mapping based on the new business requirements.
• Prepared the Documentation for the changes according to the Design logic used in the mapping.
• Resolved if any issues in transformations and mappings with help of Technical specifications.
• Validation program building based on the business requirement for suppliers (OSN) and standard PO’s.
• Experience in Procure to pay process in P2P cycles with respect the suppliers.
• Implemented custom iExpense and iProcurement workflow solution
• Setup iprocurement and iExpense modules for new Sister company and integrated with the financial module
• Configured iSupplier and OSN Oracle Supplier Network modules and customize the PO Layout to meet specific business needs Provided best practice advice on global implementation of Oracle E-business Suite and implemented GL, AP, PO, iSupplier, OSN, iProcurement, iExpenses, and third party interfaces

Environment: Purchase Order, Order Management for supply chain management (SCM), Oracle Report, RDF and XML Publisher reports.

Confidential

Jr. Technical Developer

Roles and Responsibilities:

• Developed control files for SQL* Loader and PL/SQL scripts for loading and validating data into interface tables from legacy system.
• Worked on Inbound Interface like requisition and Journals import.
• Worked on outbound interfaces like Purchase orders and journals using UTL FILE.
• Developed reports from modules like GL, AP and PO.
• Good working experience in System Administration like defining executables, concurrent programs, user set up, defining responsibilities, and adding menus, forms, reports.

Environment: Oracle Applications 11.5.9 (GL, AP, PO, Sys Admin), Oracle 9i, Reports 6i, Windows XP, UNIX, SQL*Loader, Discoverer 4i