SUMMARY

• Extensive in - depth experience on Oracle r12.x implementation, upgrade and conversion. Worked on 11i (11.5.10.2 to R 12.0.6) upgrade.
• Possess hands on and indepth experience in customizing Oracle EBS, developing reports, conversion processes, interfaces and systems integration, workflow development, forms customization, Oracle alerts, XML Development and Web services as part of r12.x upgrade initiatives.
• Actively involved in Implementation, re-Implementation, Process Re-engineering, Customization and Upgrade of Oracle Applications. This includes Version upgrades, Data conversions, Data Migration, Interfaces Development, Module Implementation (Financial & Manufacturing), Customization and Development.
• Worked at different clients using versions Oracle EBS r12.2.5, r12.1.x, r12.0.x, 11.5.x, 11.03, 10.7sc. Responsible for diagnosing and resolving various issues. Provided solutions such as tuning complex programs, performing fit-gap analysis between versions, databases, redefining best practices to improve system stability.
• Writing Stored Procedures, Triggers, Creating DB Links, & Working with files, Worked onAPI, Interface& Conversion for importing the data using the SQL * Loader, External Tables& PL/SQL, FBDI, ADFDi.Worked programs based on Java, Javascripts. Creating Custom Oracle Forms, Forms Personalization, Using Java customizing the Confidential Forms, OAF Frame Work,OAF personalization. Creating Reports using Oracle Reporting Tools, XML Publisher, Oracle Discoverer, SSRS Tool, OBIEE, OTBI.
• Delivered numerous customizations on r12.x applications foundation of global Order To Cash and Procure to Pay. Responsible for implementation and support using Oracle ERP R12 applications including Service Contract, Installed Base, Order Management, Inventory, Advance Pricing, Quoting, Accounts Receivable, Fixed Assets, Accounts Payable, Internet Expense, Purchasing, HRMS, MSCA, Product Planning, Projects and General Ledger. Worked on Oracle Fusion Applications - Financial. Extracting data from Oracle Fusion.
• Experienced in ERP Applications & Client Server Technologies, along with Development, Testing, Support, Upgrade and Tuning of Oracle Programs.
• Worked on Oracle Developer Suite 10g, 9i, 6i, Developer 2000, PL/SQL, SQL, and Oracle Forms 10g, 6i and Reports 10g, 6i. SSRS Tool 2012, XML Publisher.

TECHNICAL SKILLS

• ERP: Oracle EBS r12.x, 11.5.x, 11.0.3, 10x:
• Sales: Oracle Order Management with Configurator, Advanced Pricing, Oracle Shipping Execution, Oracle Sales Compensation
• Manufacturing/Supply Chain: Oracle iProcurement, Oracle iStore: Oracle Inventory, Oracle Forecasting, Oracle MRP and Supply chain Management, Oracle Bill of Material, Oracle Work In Progress, Oracle Purchasing
• Financial: Oracle General Ledger, Oracle Payables, Oracle Receivables, Assets, Cash Management, Oracle Financials Fusion
• Human Resource: Human Resource, Payroll, Time and Labor, Advanced Benefits,
• Oracle Projects: Mobile Supply Chain Application(MSCA), Advance Supply Chain Planning (ASCP), Quality
• Oracle AOL & SysAdmin, Metalink Support
• Concurrent Processing Management
• Oracle Development Suite 10g, 9i, 6i, 2000(includes Oracle Forms and Reports)
• SQL Server Reporting Service Tool (SSRS)
• Oracle PLSQL 11g, 10g, 9i, 8i and 8.x
• Oracle Web PLSQL 10g,9i,8i and 8.x
• Java Stored Procedures 10g, 9i (for 11i and later)
• Java concurrent programs 11i and 12i
• HP-UX RISC 9k and Solaris 10.x and up shell programming using ksh and bsh
• Workflow builder 2.6
• Discoverer 4.x+, SQL Loader, TOAD
• XML Publisher, XML SOP protocols, XML, Altova XML Spy, Oracle XML DB 10g+
• Discoverer 2000, Discover 10g+, Discoverer reports, Discoverer Administration
• Forms Customizations, Forms Extension, OAF Pages Personalization, Java Script web pages for EBS, Reports Customization and development, SOA, BPM,
• Oracle workflow management, workflow builder 2.6+ Notification mailer admin, Workflow customizations
• Sales Force Admin, Declarative Programming, APEX, Mulesoft, SOA, Web Services
• DATABASES: Oracle RDBMS 11g r2, 10g r2, 9i, 8i, MS Access
• LANGUAGES: PL/SQL, and SQL C, C++, Java, HTML
• DEVELOPMENT TOOLS: Oracle SOA Suite, Oracle Developer Suite 9i, Forms 9i, Reports 9i, Forms 6i, Reports 6i, Developer 2000, Web services.
• REPORTING TOOLS: Oracle Reports 10g, 6i. Discoverer 10g, 9i. Oracle XML Publisher, SSRS Reporting Tool, OBIEE, OTBI.
• OTHER TOOLS: SQL * Loader (Export/Import), Data Loader, Visual Source Safe, Kintana, Hummingbird Connectivity V7.1(Exceed), MS Projects, STAT 6.1, Putty, Winscp, TOAD, SQL Developer, Java Developer, AeroCare Ticketing, FBDI, ADFDi.
• WEB: Java Script, VB Script, JSP, HTML and IIS.
• OPERATING SYSTEMS: HP-UX 9000 RISC, SUN SOLARIS 8.x and Higher, Red Hat Linux, All major flavors of UNIX, Windows NT based OS, XP, VISTA, 95

PROFESSIONAL EXPERIENCE

Senior Oracle Application Developer,

Responsibilities:

• Confidential Project Champion: Confidential Manufacturing Operation wanted to track the Labor and non Labor hours in Manufacturing. Also they required to Auto log out the Assembler if they are logged into another activity. This made sure the Assemblers are always logged in either Labor or Non Labor Workorder. I have worked on creating a program to capture the time on Shop Floor once the work Order is selected by the Assembler. Also created the XML Reports and SSRS reports as per the user requirements to send the details of the Time captured. Worked on creating multiple Java programs to log the details of the Assembler and the Work Order and also to Auto-logout in case of the Assembler is logged into other activity.
• HR Hierarchy Organization: An organization hierarchy illustrates the relationships between the organizations. When you define a hierarchy, you tell Oracle Projects which organizations are subordinate to which other organizations. Oracle Projects uses the hierarchy version to determine which organizations are used for reporting and processing. I was involved in creating any missing organizations, changing the Effective start date of the organization in order to update or create new Hierarchies as provided by the business. Delete any duplicate or obsolete Organization and also to update the organizations names. This was done using the API programs and also creating required reports using the XML Publisher.
• CSS Query Project: To manage how a Change is implemented, a Change Control Sheet (CSS) is created per BL-WI-39-06-02. This process today requires a manual search of Oracle EBS to determine where used and PO applicability, and then a manual creation of the CSS. To Leverage the business by automation of the process a concurrent program was created which gives all the Work orders and the affected work order including the multi-level WIP Demands. Also created a SSRS report and to generated the output in Excel format.
• Worked on the Oracle Fusion Financial implementation. I worked on the journal import to Oracle Cloud GL with BPEL and SOA Design. Payable import to Oracle Cloud AP with BPEL and SOA Design. Conversion for suppliers, customers, Items.
• I have worked on multiple Projects in Financial, Quality, Manufacturing, and Inventory - Vertex Project, Inspyrus, Non Conformance Quality, KRATOS, Sub System of Quality.
• I have extensively worked on Oracle Custom Forms (Approved Supplier List form) and personalization of Standard Oracle Forms (Invoice, Order, and Customer, Disabling the Adjusted Rate and Basic rate in Mass Addition Fixed Assets, Adding DFF on Addition form to track additional details) and OAF Pages.
• I have worked on multiple Oracle Reports customizing the standard reports and creating new oracle reports, XML based reports, Oracle Discoverer, SSRS Reports. (Asset Transaction Report, Asset Mass Addition Report, Pick List Reports, Delivery Advice Reports, WIP Component Reports, Commercial Invoice Report, Invoice Payment Detail Report, Material Transaction Report, ISO Goods Received not delivered Report, ASCP Demand, etc).
• I have also helped in Web Services Project where I have customized the Web Services Call to mitigate the issues faced by the Web Team. Have successfully resolved Production Support tickets by writing Programs/Scripts. These tickets were validated by BSA's and Users in Production and no issues or bugs were found. Writing API Scripts for cancelling the incorrect Pos and their related PRs, Update the VAT Tax details for the customers and the suppliers. Updating the Item Masters with given requirements for multiple projects, Releasing Secondary Holds on AP etc.
• I have worked closely with the Auditors to help them understand the business process and provided them with complex data by writing scripts.
• Worked with the Business on their month end closing issues and also with the OBIEE team in building scripts and to migrate the discoverer reports to OBIEE.
• I have been trained in Sales Force Admin, APEX, Declarative Programming and Mulesoft Technology and was involved closely with the Sales Force during their implementation in Panasonic.
• I have been recognized in my organization for my quick turn around and completing the task before deadlines with no bugs and performance issues.

Environment: Oracle EBS Fusion, r12.x, GL, AR, AP, Oracle 10g, PL/SQL, Discoverer 10g, Reports 6i, XML Publisher, XML, PL/SQL, Oracle Weblogic Application Server 11.1.1.5, Oracle Enterprise Manager (Grid Control), Oracle BI Pub, JDeveloper 11.1.1.5, Oracle R12g Database, Oracle BI Publisher Enterprise Edition, Toad 8.0.0.47, Linux x86, Windows XP.

Confidential, Rancho Cucamonga, CA

Responsibilities:

• Confidential Change Implementation Project: Confidential requires a custom package to comprehensively calculate and apply parcel freight rates during the order entry cycle. The package will consist of automated (minimal user interaction) processes, that will update the order header with pricing and packaging requirements. This information will be passed to the warehouse. Packaging suggestions, as per the order header, will be clearly communicated to the warehouse to facilitate the picking and packing part of the shipping process. Actual costs, tracking numbers, labels and packaging requirements will be confirmed at time of ship confirm. Worked on making changes / updates to the Confidential programs to resolve critical issues that impacted the business. Added new functionality to Confidential programs as per the business requirement to satisfy the customer needs and increase efficiency. Supported the business on all critical Confidential production issues and resolved them in a timely manner to avoid any downtime of the system.
• Confidential implementation: Worked on the Confidential process for implementing the Freight Charges File for Illinois and Ohio zip codes as per the business need. Researched in the functionality of Confidential process and the objects required to bring in the customization of the Freight Charges file for the two zip codes (Illinois and Ohio) and implemented successfully. Working with the customer service to get the licensed for the files and executing the programs to get the files available for the business to process.
• Confidential Implementation: Worked on the Confidential 11g Implementation and 830 Forecasting process successfully. Worked on the implementation of 830 Forecast process with version controlling as part of the 11g implementation. Worked on changing the code and testing the process from end-to-end for the various Confidential files like ASN 856, INV, 810, 846, 997, 869, 870, 855 for both ISA and RSO files. Worked on the change implementation on Confidential Error report and creating new Confidential Order import alert reports.
• Discovers & XML Reports: Worked on the various discoverer reports and XML Reports as per the business requirement. Worked on various new/enhance discoverer and XML reports like Locator quantities report, Trade Management reports, XML Open Order Report, AR Statement Report, Invoice Print Report, Fill Rate Report, Monthly Adjustment Report, Warranty Adjustment report, Min-Max Onhand Quantity report, Bill of Lading Report, Warranty report orders with invoices, Scheduled Shipment Report, Asset retirement Report, Mass Addition Report, Asset Cost Detail Report.
• Oracle Alerts, Oracle Reports and Forms: Worked on various Oracle Alerts, Reports, Forms successfully as per the business requirement. TM Alerts, Financial Alerts, Sales alerts, Confidential Alerts. Oracle reports like Closed line report, FET Category Check and Item Category reports. PLSQL programs like FET Update freight process, Update Price check process, Credit Hold Process. Customizing the Sales order form as per the requirement. Adding DFF to the Mass Addition to capture the additional information regarding the Company assets.
• Confidential: Worked on the Confidential project on design review, code review and testing the tool to enhance the tool as per the business requirement. In order to create Sale Orders for Dealer Website Orders, the new inbound program has to be build. This program creates order headers and lines with order header status as Entered and Materialized views and SOA Packages has to be created to track the changes in order, invoice, customer, shipping, On hand, Item categories an, Product Cross s and AR billing data
• Confidential Project: These procedures are designed to educate the customs brokers concerning their obligations and responsibilities with respect to Falken’s transactions involving the Confidential principle. The procedures have been provided to ensure full compliance with Customs and Border Protection laws and regulations, clarify new procedures, and maintain efficiency on Confidential transactions. I was involved in creating programs and implementing the changes to the Custom Form
• Worked on Production support and Gap analysis as and when required. Resolved critical production support issues on a timely manner to increase the productivity of the system. Created test scripts for various business scenarios as needed. Work on the timely closure of the tickets that needed immediate resolution and provided complete support to the business
• Worked on creating custom blank stock check printing report. The report had new format printing the invoice details, customer detail and the check details along with the micro font text for the black stock.
• Worked on creating a custom quick sales order form for the Warranty Return Forms. 90% of the Warranty Claims are submitted through Confidential and are processed in oracle and are finalized as Warranty credit memo with three steps. FTC claim staff enters the measurement details and finalize the claim. This requires multiple screen navigation, key strokes and time consuming to enter the details in descriptive flex field. This project required customizing the form to address the issues.
• Responsible for load and validating the data in staging table and writing programs to import the data and run the Mass Additions concurrent program to migrate the data in FA tables. Also created few of the reports related to FA like create Mass Addition Report, Post Mass Addition Report.
• Worked on creating the XML Reports like AR Aging 7 bucket, Invoice print report, Pick slip report, AR statement Report, Confidential Open order report. Creating new Discoverer report and customizing the existing discoverer reports like DTC Rejected Claim Report, Confidential Daily Shipment Report, PO closed and open order detail report, Stock on hand detail report, Monthly Adjustment report etc. Locator quantities report and managing and the workbook and folder as a discoverer administrator. Working on building new or customizing the existing forms like Confidential Global Inventory Form, Sales Order form, creating the fill rate form for sales order, shipping transaction form with new requirement of OE tires from Chrysler and DTC. Worked on interfaces and API like Item master, Item Categories and Catalogue, updating the AR customer Ship-to, updating the RMA details for items using item revision interface. Worked on FalkenDealerweb project in development of the EBS code and testing the functionality of the Confidential site.

Environment: Oracle Applications 11i (11.5.10.2), GL, AR, AP, Oracle 10g, PL/SQL, Discoverer 10g, Reports 6i, XML Publisher, XML, PL/SQL, Oracle Weblogic Application Server 11.1.1.5, Oracle Enterprise Manager (Grid Control), Oracle BI Pub, JDeveloper 11.1.1.5, Oracle R12g Database, Oracle BI Publisher Enterprise Edition, Toad 8.0.0.47, Linux x86, Windows XP.

Confidential, San Clemente, CA

Responsibilities:

• Worked as Discoverer Lead coordinating with Onsite and Offshore Teams to gather functional requirements and complete development.
• Also worked as overall Oracle Applications Technical consultant, involving in development and coordination with off-shore team.
• Worked closely with Management team to get Functional Requirements and transformed them into Technical Documentation using AIM methodology.
• Designed and developed AP Distribution Set Upload Program and a report to validate the Distribution sets.
• Designed and developed AP Withholding Tax report as part of India localization project.
• Analyzed Business Requirements (MD50s), worked with users to assist with the functional design, developed/customized reports for upgrade from 11.53 to 11510 and r12.1.3
• Modules AR, MFG modules (ONT, BOM. CST, INV) using Oracle Development Suite/Reports 6i. 9i and BI Publisher. Created custom values sets, menus, and responsibilities as a part of r12 Upgrade from 11.5.10
• Customized Oracle Receivables r12.1.3 standard JSP based web pages in Customer Standard, Collections workbench and Advance collections.
• Created MD70 documents, shell and fnd load scripts, built new workflows to replenish or supplement the upgraded functionality in r12.
• Developed OM Sales Order Conversion from websites into Oracle Order Management as part of r12 Upgrade project
• Customized Customers Standard webpage in r12 using Forms personalization to hide, rename and reposition some columns for different operating units.
• Upgraded AR Customer, Invoice and Receipt Conversion programs for multiple entities with different validations as per requirements from 11.510 to r12.
• Conversion of 32 11i reports (Report 6i) to BI Publisher reports in r12.
• Customized Oracle’s Order Entry workbench to bypass online credit card authorization functionality.
• Customized Oracle Forecasting workbench to include MRP consumed sales order in roll forward Forecasts.
• Developed new forms for various business needs as extensions to Oracle EBS.
• Maintained refreshes of materialized views created for Discoverer Workbooks on daily basis.
• Always been the primary contact for all Discoverer related issues for both Technical and Management Teams.
• Involved in integrating BI Publisher with Discoverer to burst and email reports to Users according to security rules.
• Scheduled and bursted BI Publisher reports to distribute monthly reports to users.
• Developed various Operational reports in Discoverer including AR Aging Report with GL segment hierarchies with summary and detail worksheets.
• Customized standard ATO Order Header and standard ATO Order line workflows using Oracle workflow builder 2.6.8+.
• Also worked on updating interfaces like Out of Pocket Expense, Fee Transfer and Oracle XML Publisher Reports.
• Extensively utilized the Application Object Library to register SQL*Loader programs, shell scripts, PL/SQL procedures and RDF Reports. In addition, also used the System Administrator responsibility to create users, responsibilities, custom profiles, request groups, request sets and Value sets.
• Resolved several issues by coordinating with Oracle Support Team through Service Requests of all levels of severity including data fixes on production system during go live.
• Always met deadlines within the stipulated time frames and met team’s expectations.

Environment: Oracle Applications 11i (11.5.10.2), GL, AR, AP, Oracle 10g, PL/SQL, Discoverer 10g, Reports 6i, XML Publisher, XML, PL/SQL, Oracle Weblogic Application Server 11.1.1.5, Oracle Enterprise Manager (Grid Control), Oracle BI Pub, JDeveloper 11.1.1.5, Oracle R12g Database, Oracle BI Publisher Enterprise Edition, Toad 8.0.0.47, Linux x86, Windows XP.

Confidential, Irvine, CA

Responsibilities:

• Worked on the new development, customization and support projects. Key initiative included upgrade of 11.5.9 to r.12.06, 11.53 to 11.5.9
• Worked on Advance Collection in developing the new delinquencies, scoring components, Engines & strategies, and metrics.
• Created various Oracle alerts based on the requirements. Upgraded Alerts to Workflow Notification mailer as a part of Upgrade process to r12
• Migrate Rules and Time values for Oracle Service Contracts from 11.5.9 to r12
• Worked on report conversions from 11.5.x to r12 by migrating Report 6i file to XML publisher.
• Subledger accounting related customizations - post upgrade scenario included addition of two segments in GL Key accounting flexfields - Worked on flexified customization and in corporation of the change in Oracle Reports
• Supported Migrations of HRMS based organizations and Inventory Organizations to Legal Entity Configurator.
• Perform Customizations around TCA and Customer Master. This included integrating Customer zip codes with vertex sales tax location codes, and updating customer master with DUNS number.
• Worked on customized e-payables system (developed by Tiffworks) that is integrated with Oracle EBS.
• Design and Develop Oracle Application Framework OAF development for self-service modules of R12 such as Internet Expenses, iReceivables, iProcurement
• Design and Develop Integration between Oracle Apps R12 and other systems such as SF.com, ultipro, Next Generation Provision Tool.
• Manage effective communicate with others at all levels of the Company both verbally and in writing. Demonstrates a courteous, tactful and professional approach with employees and others.
• Manage to accurately establish the length and difficulty of tasks and projects, set reasonable objectives and goals, anticipate and adjust for problems/roadblocks and measure results against goals.
• Worked on Oracle interface process to interface data from Oracle to data tree systems, CLASS and ePayables.
• Worked on AR invoice customizations, AR invoice print, statement print processes.
• Extensive development of Discoverer reports, BI Reports. Few examples: Aging report- tabular, Hierarchy Detail, Aging Hierarchy Summary, Aging File Closed Date, Aging File Open Date, and Payables Aging.
• Development of numerous BI Publisher reports using Oracle Reports, and BI Publisher combined. Few examples are Check printing reports, Property Tax Report, Un-invoiced Receipt Report, Unapproved Invoice Report, Bank Reconciliation Report, Recurring Invoice Report, Statement Report, Multiple Invoice Print report and Recurring Invoices Alert.
• Development of Supplier conversion interface.
• Worked on conversion projects like Receipts, invoices, customer, supplier.
• Worked on ad-hoc queries based on customer requirement.
• Extensively worked on Customization of standard functionality and form personalization.
• Identified and strategies which pieces of functionality would be satisfied by which technology, obtained approval from the customer that the requirements were satisfied and communicated areas of responsibility to the development teams.
• Modeled the business entities that were required to solve the business problem. From this structure, the business domain portion of the solution was developed.
• Prepared Architecture Decisions, Architecture Overview and Architecture Design Documents
• Provided total Oracle EBS post production support to users.
• Form Customizations of Oracle Payable's Invoice workbench, Oracle Receivables customer standard form and transactions workbench. Developed a new form from scratch for GL hierarchy mapping.
• Extensive hands on SQL tuning. Worked on numerous SQL based programs to tune them to boost performance of the process.
• Development of Unix Shell Scripts, SQL Loader scripts to support various outbound and inbound conversion processes in and out of Oracle EBS.
• Worked on FA Conversion, Mass addition process from FA to Payables. Worked on the FA related reports FA Addition, FA Addition by Source, Asset Transaction Report etc.

Environment: Oracle Applications r12.06, 11.5.10 RUP2, 11.5.10 RUP6, GL AP, AR, INV, PO, PL/SQL, Reports 6i, Forms 6i, SQL*Plus, Oracle RDBM67, PL/SQL, Oracle Weblogic Application Server 11.1.1.5

Confidential, Valencia, CA

Responsibilities:

• Worked on new development, customization and support projects.
• Worked on custom Payment process to BOFA. The purpose was to automate the payments directly to vendor’s bank accounts from Oracle Payables.
• Automated the Payment process for Canadian Operating Unit.
• Customized the standard Payables Payment Processor Package (AP PAYMENT PROCESSOR PKG) by calling the custom process within the Payment Workbench Process.
• Customized the Invoice Workbench Form.
• Worked on the Invoice detail report which gives the vendor and their invoice details.
• Worked on analyzing, designing and development of the automation of the banking process for JP Morgan. Created the functional specs, data flow diagrams, functional flow charts and technical specs. The Payment process creates, builds and formats the payments and generates a payment file which would be sent to JP Morgan for the payments.
• Automated the remittance notification to the vendor based on the payment details.
• Worked with the Oracle support team on SR for Data fixes, Oracle Bugs and Patches on GL, AP, AR, PO modules.
• Worked on importing the period end rates for all set of books.
• Worked on the IBAN Validation process.
• Working on the upgrade process from 11.5.10 RUP2 to 11.5.10 RUP6. Upgrading the Custom objects, DFFs etc and testing each module.
• Worked on Oracle Asset Adjustment API. Worked on Cost Adjustment Report on FA, Asset Transfer Report.

Environment: Oracle Applications 11.5.10 RUP2, 11.5.10 RUP6, GL AP, AR, FA, INV, PO, PL/SQL, Reports 6i, Forms 6i, SQL*Plus, Oracle RDBMS 9i/10g, Unix.

Senior Oracle Apps Techno-Functional Consultant,

Confidential, San Diego, CA

Responsibilities:

• Worked on new developments, customization of Order reports in Oracle Order Management and Manufacturing - Total 20 reports.
• Worked on Production support for the user of 11.0.3. Resolved any issues related to the 11.0.3 production environment. Modules involved Oracle Financial, Oracle Order Entry and Shipping and Oracle Manufacturing.
• Development and deployment Data cleanup and maintenance scripts to support business needs of the company.
• Development, testing and bug fixing of Key interface processes for the organization.
• Development, testing and bug fixing of Customer Interface and Order import processes.
• Supported and bug fixed around Customization and third party systems such as Confidential (a home grown system).
• Created custom forms for Order Import maintenance and data cleanup. This form shows all the rejected records of the customer detail and Order Detail. The rejected records made the required changes to rerun the interface.
• Bug fixing of Unix shell scripts that support key business processes for the company.
• Collected all the requirements from the user for the objects and prepared a functional and technical documentation Environment: Oracle Applications 11.5.8 (GL), Oracle 8i, Reports 6i, Forms 6i, SQL Loader, Unix, SQL, PL/SQL.
• Upgrade of customized form for the company to 11.5.10.

Environment: Oracle Applications 11.5.10.2, Oracle RDBMS 9i, HP-UX RISC 64 Bit 9000.

Senior Oracle Apps Techno-Functional Consultant,

Confidential, Sacramento, CA

Responsibilities:

• Worked on ARMS ( Confidential System) and BATS ( Confidential System). This is Custom Application which is built using the Oracle Applications 11.5.8. This Application allocates the resources and tracks the budgets of the fiscal year with respect to the Allocation Input, Spending Delegation, Category, Division, Projects. This application also gives the clear understanding of the YTD Amount, Pending Items, and Encumbrance.
• Worked on analyzing and designing the custom database schema.
• Analyzed their present application and collected the requirements from the user. Prepared functional and technical documentations for the required objects.
• Worked on creating the forms and report required to build these custom applications.
• Worked on SQL Loader and UNIX to upload the data into the database.
• Also acting as a Software Configuration Manager by managing the entire database object.

Environment: Oracle Applications 11.5.8 (GL), Oracle 8i, Reports 6i, Forms 6i, SQL Loader, UNIX, SQL, PL/SQL

Senior Oracle Apps Techno-Functional Consultant,

Confidential, Santa Monica, CA

Responsibilities:

• Worked on gathering the requirement from the user, preparing the Scope and Requirement Document, Functional Document, Technical Design Document, Oracle Setup Document and Production Change Control Document.
• Worked on GL Interface, uploaded the data and then imported the GL data for a specific period and currency code.
• Customized the AP Check Printing Report to include the signatures based on amount value on the check.
• Customized Master BOM Report, Production BOM Report, Transaction Source Summary Report, Sub-Inventory Quantities Report & Inventory Item Master Audit.
• Worked on creating a discrete job manufacturing report.
• Maintained the custom database for the company that has custom tables and stores information regarding the company’s sales, product, title mapping, platform mapping, and monthly data for each instance.
• Worked on FSG Reports Trial Balance - QTD, Trial Balance - YTD, Tax Balance Sheet Report.
• Customized the Custom.pll to enforce uniqueness for the descriptive flex field ADP number
• Worked on creating descriptive flex fields for HR module like Dependent Birth date, ADP Number and 10 Supervisors which are unique for an employee.
• Created new reports in HR Module like HR Audit Report, HR Active Supervisors Report, and HR Proxy Report.
• Customized HR Compensation Spreadsheet report, Contract Spreadsheet report, Personal History Change report, Position and Bonus Report, HR ‘As of Date’ Report.
• Worked on developing new report in HR Benefits like HR Work Bench Compensation Report, HR Employee Bonus Benefit report.
• Worked on Cost Detail Report, Cost Summary Report, Asset Retirement Report related to FA.

Environment: Oracle Applications 11.0.3/11.5.10 (GL, AP, FA, AR, Purchasing, Quality, Inventory, BOM, WIP, HR Benefits & HRMS), SQL, PL/SQL, Reports 6i/2.5, Forms 6i/4.5, SQL * Loader & MS Excel, VSS, e-room

Senior Oracle Apps Techno-Functional Specialist,

Confidential, Ventura, CA

Responsibilities:

• Worked on Understanding the business process and gathering the requirement from the End user, Analyzing and Understanding the mapping from AS400 to Oracle Application, Preparing the Functional and Technical Design Documentations, Development, Unit Testing Documents and explaining the process to the user using AIM Methodology.
• Worked in Customer Conversions to import the data of Customer data, Customer profile, Customer contact, Customer Bank information. The data was imported from the legacy data AS400 to the Oracle application 11.5.10.
• Worked on Vendor Conversion to import the data of Vendor data, Vendor Sites, Vendor Contacts. The data was imported from the legacy data AS400 to the Oracle Application 11.5.10.
• Worked on GL Journal Conversion to import the data journals from the legacy data to the Oracle applications.
• Worked on Data loader to load the GL Code combinations into the Oracle applications.
• Worked on Auto Invoice Interface, to import data with all validations. The logic was written based on the invoice type like Credit Memo, Debit Memo, Invoice etc and the Line Type like line, Tax, Freight etc.
• Worked on Customizing the AP Check Printing Report.

Environment: Oracle Applications 11.5.10 (GL, AP, AR, PO, BOM & WIP), SQL, PL/SQL, Reports 6i, Forms 6i, SQL * Loader, Data Loader & MS Excel.