PROFESSIONAL SUMMARY:

• 8+ 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 (RDF), E - Text Templates (NACHA, ACH (PPD, CCD)), XML Publisher, TIBCO, Forms, RICE Components, Web ADI, OBIEE, ODI, Panaya Tools (Upgrade), Data Loader.
• Having good expertise over functional flow of Oracle Application Modules which include Accounts Payable (AP), Oracle HRMS, iExpense, Cash Management (CM), Trading Community Architecture (TCA), Shipping, Oracle Payroll, Purchasing (PO), General Ledger (GL), Inventory (INV), 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.
• Excellent at doing setups by defining and designing the Key Flex Fields and Descriptive Flex Fields based on the Context Sensitivity for the oracle HRMS Job, Position, Grade, Cost Allocation and Competency.
• 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, OBIEE, ODI, 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, TIBCO

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

PROFESSIONAL EXPERIENCE:

Confidential, Chandler, AZ

Sr. Oracle Techno Functional Consultant

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 and materials for System Analysts as well as other IT staff.
• Create and maintain alerts, forms personalizations and Payroll fast formulas.
• Creates debugs and run SQL / PL/SQL scripts to conduct data analysis, accuracy validation and data maintenance.
• Provides expert level knowledge, skill and experience to other Systems Analysts, IT Infrastructure Specialists, application super users and IT management.
• Provide support and creation 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
• The IT Applications Support Manager or Oracle Team Lead may assign other duties as required to maintain support of the Confidential Oracle E-Business Suite and reporting.
• The consultant must provide clear and precise documentation of any changes made and present documentation for review. This includes detail steps outlined for fixes within resolution portion of tickets worked.

Environment: Oracle HRMS, Payroll, Alert, Functions, Menus, OAF Personalization, OBIEE Reports, Noetix Views.

Confidential, Denton, TX

Sr. Oracle Techno Functional Consultant

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 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.
• Developed business processes by configuring shared resources, creating process definitions, creating activities and configuring message transports using TIBCO Business Works.
• Designed XML schema definitions (XSDs) to support the mapping of standard TIBCO ActiveEnterprise message payloads onto SOAP API calls.
• Installed ODI. Set up the ODI connection with Oracle, MS SQL Server and flat files.
• Trouble shooted the ODI connection with oracle by fixing the tnsnames.ora file, TNS listener and DNS entries.
• Used ODI commands like ODIFile Move, odiFileAppend, odiFilecopy etc
• Involved in Oracle HRMS functionality such as Creating Security profile, Responsibility, registering concurrent programs, executables, form functions, defining users, administer responsibilities, adding custom reports/processes to request groups and several other related tasks. Configuring Jobs, KFF, DFF, Organization, Hierarchy, Grades, Locations, SIT, People Group, Absence, Appraisal, Fast Formulae, Web-ADI, OA-Framework, Form Personalization, and User hooks etc.
• HRMS Employee Personal, Assignment, Basic Salary, Job Title and Additional Information.
• Package development for Auto Element Entry Creation (Annual Leave Salary Advance & Deduction, Lieu Leave, Loans & Advance, Business/ Travel Allowance Domestic/International, Payments/Reimbursements).
• Report, Assignment Details, Payroll Summary Reconciliation, Payslip Report, Salary Register, Cheque Format Print, Cash Register, Bank Transfer Report, Payroll Wire Transfer and Loans & Advances
• Creating the 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 LockBox 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,ODI, 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

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.
• Worked on the credit card processing for the US Bank Visa Cards in iExpense and imported the invoices and payments related data into oracle EBS.
• 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 Valueset 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)), AMEX Credit Card,Check Printing for Bank of America, GL (Journals)

Confidential, Simpsonville, SC

Sr. Oracle Techno-Functional Consultant

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 using RDF Oracle Report builder.
• 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 & 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

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.
• Enhancements of the pick release and pack confirm oracle reports.

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

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

Responsibilities:

• Played a very crucial role in gathering the requirement and flat files for mapping the fields involved more on client calls.
• Worked on the 10g RDF reports using oracle report builder customization for the Order Management module.
• 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, Oracle Reports(10g)

Confidential, Milwaukee, US

Oracle Technical Developer

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.
• Developed custom Oracle Report (GE ONT Quote Report).
• 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.

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

Confidential

Jr. Technical Developer

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