We provide IT Staff Augmentation Services!

Consultant Resume

Lisman, AL

SUMMARY:

  • Close to 14 years of overall industry experience and 10+ years of experience in Oracle Applications11i/R12, Oracle Fusion Middleware with SOA, BPEL and all phases of implementation, support, up gradation, migration in Financials, Distributions, SCM, CRM modules of Oracle Applications E - Business Suite including Business Requirements Mapping, Application Module Design and Development, Data conversion, Documentation, Testing, Performance enhancements and Production Support.
  • Expertise in the modules Like GL, AP, AR, PO, Service Contracts/Contracts Core (OKS/OKC), CRM Foundation (JTF), TeleService, Install Base, Field Service, Depot Repair, Order Management, Service and Trading Community Architecture (TCA/HZ).
  • Commendable experience in complete project life cycle implementation involving Pre-Implementation Analysis & planning, business requirement analysis, gap analysis & resolution, solution design & development, Systems configuration & data migration, Production systems roll-out & Post-Implementation support and Documentation.
  • Excellent analytical skills in Business requirements gathering from end users to the client for suggesting workarounds and customizations and experience in creating and using mapping documents.
  • Experience as Project Lead with responsibilities such as business requirements gathering and mapping, technical design, estimating development and testing time, assigning individual tasks, and creating comprehensive testing scenarios.
  • Extensive experience in RICE (Reports, Interfaces, Conversions and Extensions) components, Onsite/Offshore Model, and maintaining documentation and following the processes for maintaining standards.
  • Worked with Confidential team as Senior Applications Developer and took part in the development of various projects in R12 and 11.5.10.
  • Professional with rich varied experience in:
  • Project Management & Planning System Analysis SDLC
  • Business Analysis Pre Sales Client Interaction
  • Time Management Team Management Requirement-
  • Mapping & Analysis Cost Control Meeting Deadlines
  • Risk Management Documentation Application Development Technical Support MIS Management
  • Experience in implementation, conversions, interface and customization of Oracle Applications objects.
  • Proficient programming experience in SQL, PL/SQL, SQL*Loader, Oracle Developer 2000 (Forms 6i/9i/10g, Reports 6i/9i/10g), XML Publisher, OAF and Workflows.
  • Design and development experience on Oracle SOA Suite which includes BPEL, ESB, WSM, Oracle Rules Engine/Rule Author and Worklist Application all with the latest version 11g.
  • Lead the team of Developers in the implementation of Reports, Forms and developing them from scratch and customizing.
  • Expertise in SOAP, WSDL, and Web services, XSD, XML, XSLT and XPATH.
  • Lead the team in Designing and Development of SOA Suite Components using BPEL and OSB.
  • Expertise in Production Support, Requirement gathering, functional gap analysis, configuration, module setup, test script generation, training users.
  • Experience in customizations and Enhancements of Interfaces, Reports, Forms and Workflows.
  • Knowledge of Application Object Library (AOL), Application Programming Interface (API) and System Administrator activities.
  • Expertise in customizing ORACLE Alerts
  • Experience in System Administration responsibilities such as registration of concurrent programs, request sets, creation of Users, Responsibilities, Forms, Functions, Values Sets and Flex fields in Oracle Applications.
  • Expertise in Performance Tuning of Queries, Reports and high volume transaction processing.
  • Significant Experience with System Requirements Gathering, Analysis, Design and Development, Test Plan Preparation, Unit testing, System Integration testing and documentation.
  • Involved in End User training, preparation of user manuals, user guides and Desktop procedures for various projects.
  • Ability to work with Cross-functional teams including Users, Financial Analyst, Business Analyst and Technical Consultants
  • Testing of module functionality after patch Application and after Applying customization releases.
  • Follows ups of TAR and Applications of Patches as and when required with Oracle Corp.
  • Guide Users in formulating requirements, advice on alternatives and on the implications of new or revised processing analysis.
  • Strong analytical and troubleshooting skills with excellent verbal and written communication skills.
  • Familiar with change and configuration management methodologies, the Oracle AIM and Oracle UOM methodology, and project management techniques.
  • Conversant with:
  • Oracle Apps 11i, R12 Financials, Oracle Fusion Middleware, PL/SQL, Java, BPEL.
  • Oracle ERP Application.
  • Oracle Applications 11i Financials, CRM and Distribution.
  • RICE (Reports, Interfaces, Conversions and Extensions) components, Onsite/Offshore methodology.
  • OAF customizations and Creation of new pages using OAF.
  • Key Deliverables across the tenures
  • A project planner with demonstrated success in end-to-end project management by ensuring effective management of various resources to meet the project objectives.
  • Insightful experience in IT project management activities including project scoping, estimation, planning, risk management, finalization of technical / functional specifications, resource administration & optimization and quality management of the software applications.
  • An effective leader with proven ability in leading and guiding the teams during the project phases and enabling knowledge sharing among the teams.
  • Hands-on experience in end-to-end development of software products from requirement analysis to system study, designing, coding, testing, de-bugging, documentation and implementation.
  • Acquires a clear understanding of the technology trends with the distinction of instituting new practices to achieve business excellence at the lowest overall cost.
  • Extensive experience of environments requiring direct customer interaction during specifications, effort estimation, development, product implementation phases & production support.
  • An effective communicator with excellent relationship building & interpersonal skills. Strong analytical, problem solving & organizational abilities. Possess a flexible & detail oriented attitude.

TECHNICAL SKILLS:

ERP: Oracle Applications12.1,4/11i/ 11.5.10/11.5.9/11.5.8/11.5.7/11.5.6/11.0.3, GL, AR, AP, CE, INV, PA, OE, OM, Work Flow, Alerts, iProcurement, iPayment, Shipping, Pricing, PO, BOM, WIP, TCA, Service Contracts, Install Base, Field Service, Depot Repair, Quoting, AOL, System Administration.

Fusion Middleware Technology: Oracle SOA 11g/10g, BPEL, ESB,BPEL Activities, Adapters, Mediator, Fault Management Framework, OSB and B2B

Programming Languages: Sql, Plsql, XML, Java, C, C++

Web Technologies: HTML, XML, XSD, WSDL, UDDI, XSL

Framework: Oracle Application OA Framework

Database: Oracle9i,10g

Tools: Oracle JDeveloper 10g/11g, Oracle Developer 2000, Oracle Workflow, XML Publisher, DATA LOADER, VSS, Putty and Mercury IT Governance Suite (formerly KINTANA - Objects Migration Tool), ITIL Support Management Tool, ipat, Oracle SQL Developer, TOAD, SQL Loader GUI, Forms 6i/9i/10g & Reports 6i/10g, Oracle Discoverer, Workflow Builder 2.6.3

Project Management: Project Initiation, Planning, execution and controlling processes Risk Management Agile Methodology. Aim Methodology

Operating Systems: Linux, Unix, Windows 95/98, Win2000/XP.

PROFESSIONAL EXPERIENCE:

Confidential, Lisman, AL .

Consultant

Responsibilities:

  • Task Management, On-time Delivery and overall setup for critical milestones.
  • Working on the implementation of Oracle E-Business Suite R12 system.
  • Involved in the following business analyst tasks: Performing configurations,
  • Gathering business requirements, identifying gaps, design solutions to resolve gaps in the standard Oracle system.
  • Writing up Technical specifications for customizations (including working with users on requirements) and creating high-level technical design documents.
  • Converted Sales Territory conversions from legacy to Oracle E-Business system R12.
  • Worked on the Enrollment to Service which is business requirement in CCHS.
  • Provided Customized API’s for the Creation of CSI Instances, Service Contracts thru API’s to acquire the business requirement.
  • Worked on the BOM explosion and created the install base Instance.
  • Handled complete Order to Service Contracts working on integration of Java UI(which is an e-commerce).
  • Service Contracts created for the Service Items and instances for Covered Products.

Environment: Oracle E-Business Suite R12 (12.0.6); TeleService/Service Requests/ Install Base (CSI),Service Contracts (OKS),Order Management(OM), AR, BOM, Customer Care (CSC),Trading Community Architecture (TCA/HZ), CRM Foundation/Tasks/Resources (JTF), iSupport (IBU),Oracle (10g): PL/SQL, SQL, Toad, GIT, Jira ticketing system, Agile PM methodology(Sprint).

Confidential

SOA Integration Architect

Responsibilities:

  • Nationwide Coverage on America’s Best and Most Dependable Networks.
  • Calls Nationally, 100 International Destinations or Roam at local call rates.
  • TracFone Wireless markets its handsets and airtime cards at over 90,000 retail locations across the United States, Hawaii, Alaska and Puerto Rico.
  • Project Involved integrating Oracle E-Business Suite to Different Systems E-Commerce, CLARIFY using Oracle Fusion Middleware 11g SOA BPEL/OSB.
  • Responsibilities:
  • Heading the Fusion Middleware team TracFone Wireless Inc for integration with Oracle E-Business Suite.
  • Task Management, On-time Delivery and overall setup for critical milestones.
  • Involved in B2B and B2C Project Implementation for TracFone WireLess Inc., For which integrating
  • Oracle E-Business Suite to Different Systems E-Commerce, CLARIFY using Oracle Fusion Middleware 11g SOA BPEL/OSB.
  • Involved in Business Discussions for Implementation of Oracle E-Business suite and Integrated with E-Commerce and Clarify using Oracle Fusion Middleware OSB and BPEL, WEBLOGIC.
  • Developed New Package to call the webservices from the data base and pass the parameters to them.
  • Worked on the incidents/tickets from the client as part of the support.
  • Implemented Oracle E-Business suite and Integrated with E-Commerce and Clarify using Oracle Fusion Middleware OSB and BPEL, WEBLOGIC
  • Developed New Package to call the Fusion Middleware OSB webservices from the Oracle E-Business Suite data base and pass the parameters to them.
  • Exposed the Fusion Middleware OSB Services to E-Commerce and Clarify systems

Environment: Oracle Applications 12R: GL, AP, AR, Fusion Middleware 11g BPEL, Forms10g & Reports10g, Putty, WinSCP3, GIT HUB, OSB, Virtualization-LISA, CA-Tools, Clarify, Quality Center, Weblogic.

Confidential, San Diego, CA .

Project Lead

Responsibilities:

  • Supported day-to-day business process and addressed the production issues.
  • Worked on AIM methodology for new Custom designs to best suit the user requirement.
  • Assisting the accounting team in smooth month-end closing.
  • Debugged the reports in case of incorrectness of data.
  • Customized the form(10g) for their inter-company orders know as IVIC.
  • The custom form was built to enter orders for their IVIC department and this would in turn create orders in OM.
  • Worked on Order to Cash flow process.
  • Provide bug fix for the long pending issues like unable to receive orders, Purchasing approval hierarchy, Accounts for a particular customer site.
  • Assisted in Functional support to business on the Order management issues (Booking, Picking, and Shipping, Closing of order).
  • Used Forms personalization in one of the OM form to be able to copy orders only for some of the Order types.
  • Added columns in OM report to be able to view more data with clarity using Oracle Report Developer (10g).
  • Supported the business users in understanding the functioning of the reports.
  • Interacted with users in gathering all the requirement information.
  • Performance tuning for business critical GL Detail report, Account analysis report.
  • Fixed the long pending flex field issue related to event sales when end dated.
  • Prepared documentations using the Oracle UPK for user training.
  • Worked closely with Oracle Support (TAR) for critical production outage issues and other SR’s for business.
  • Worked with Oracle On-Demand to apply patch and test the impact on the business
  • Worked on the Kinatana, PVCS tools for the code promotion for the Project Phases.

Environment: Oracle Apps (12.0.4) OM, Cash Management, SQL, PL/SQL, MS Excel, Toad, SQL Plus, UNIX Box & XML Reports.

Confidential

SOA Integration Architect

Responsibilities:

  • Team Lead/Offshore coordinator for overall Oracle Financial ApplicationsR12 Project.
  • Headed the Fusion Middleware team at Sunera Technologies.
  • Task Management, On-time Delivery and overall setup for critical milestones.
  • Worked on RICE Objects in Financial modules of Oracle Applications.
  • Worked on the Enhancements of the existing RICE objects.
  • Worked on customizations for reports, XML Publishers.
  • Worked on the incidents/tickets for the oracle financial modules provided from the client as part of the support.
  • Implemented Oracle ESB and Integrated with BPEL.
  • Provided presentation for Integration of Oracle Ebussiness suite with Oracle RTS.
  • Established the integration of data flow between Oracle Ebussiness suite with Oracle RTS.
  • Worked on designing and developing the integration through bpel and pl/sql.
  • Understanding the Requirements and Design Specifications.
  • Involved in creating BPEL processes.
  • Creating jar file from WSDLs.
  • Analyze the requirements and subsequently development of the integration module.
  • Design and implemented Business Processes using Oracle BPEL PM and JDeveloper.
  • Involved in design and development of BPEL processes that contain Human Workflows.
  • Developed BPEL processes that contain Exception Handling to capture the Remote and Binding Faults.
  • Conversion of different XML formats in each other.
  • Developed different SOAP services and Web Services using WSDL, SOAP and Oracle JDeveloper.
  • Provided Technical specifications and solutions for the Project.
  • Provided the Technical and Test Documentation for the objects created.

Environment: Oracle Applications 12R: GL, AP, AR, Fusion Middleware BPEL, Forms10g & Reports10g, Putty, WinSCP3.

Confidential, NJ

Sr.Systems Analyst--Oracle SOA Integration

Responsibilities:

  • Tech Lead/Offshore coordinator for overall Oracle & Fusion project of Miasole.
  • Interfaced between the client and BPEL Interface development team offshore.
  • Task Management, On-time Delivery and overall setup for critical milestones.
  • Fully designed and developed a BPEL process to publish legacy data into Oracle E-Business Suite Open interface tables using APPS-Adapter.
  • Implemented BPEL Process Rejection Handler (File system based).
  • Invoked BPEL Process thru PL/SQL.
  • Managing different BPEL Domains thru Bpel Admin.
  • Worked on RICE Objects in various modules of Oracle Applications.
  • Worked on customizations for reports, forms and Oaf.
  • Developed and involved in the POC of the Confidential Project and developed new
  • OAF page using oracle frame work and personalization for the business requirement.
  • Provided the Technical and Test Documentation for the Projects

Environment: Oracle SOA, Jdeveloper10g, SOA Architecture, Bpel, Esb, Oracle Rule Author, OJMS, XML, WSDL, XSLT, XSD, AIA, PIP. Oracle Applications 12R: GL, AP, PO, OM, Forms10g & Reports10g, Putty, WinSCP3.

Confidential, Sunnyvale, CA

Technical Lead

Responsibilities:

  • Supported day-to-day business process and addressed the production issues.
  • Support to the business’s various Supply chain modules.
  • Involved in supporting the daily Order Management, Inventory, Receivables (AR), Cash Management, Shipping and Picking issues.
  • Resolved the issues in pending transactions and any stuck transactions.
  • Monitored that the period close every month takes places as scheduled without any issues.
  • Debugged the reports in case of incorrectness of data
  • Work on AIM methodology for new Custom designs to best suit the user requirement.
  • Created new Discoverer (10g) reports for HR data, Shipment information, Customer Service data
  • Assist the end-users with minor issues like Printing issues, Unable to Ship an order, unable to receive an order, miscellaneous transactions and others.
  • Support on business critical Discoverer reports which contains their monthly sales data.
  • Provide bug fix for the long pending issues like unable to receive orders, Purchasing approval hierarchy, Accounts for a particular customer site.
  • Added columns in OM report to be able to view more data with clarity using Oracle Report Developer (10g)
  • Supported the business users in understanding the functioning of the reports.
  • Interacted with users in gathering all the requirement information
  • Supported the issues with oracle Alert, replicate the issues, test it and movement to production with help if MD-50, MD-70.
  • Worked with Oracle as part of SR’s (TAR) creation for standard Oracle issues and scheduled calls on weekly basis to resolve the issues faster.
  • Worked with DBA’s to apply patch and test the impact on the business.

Environment: Oracle Apps (11.5.9) SQL, PL/SQL, MS Excel, SQL Developer, Toad, SQL Plus, UNIX Box.

Confidential, San Jose, CA

Sr. IT-Analyst.

Responsibilities:

  • Worked as IT-Analyst for the Upgradation of R12 Oracle applications for the modules GL, AP, AR, CE, iExpenses, PO, iProcurement and FA.
  • Delegation & monitoring of work to the team members. Estimating the time required for tasks.
  • Assisting the Project Manager in allotting the work to team members, monitoring the delivery of the project in time and preparing the plans for the test cycles in the Test Instance.
  • Designed of MD50, MD70, CV40, MD120 and TE40 documents as per client’s requirements.
  • Responsible for Implemented Multi-Currencies for different OU based on Multi-Org Functionality for the new business Operating Units across the Globe.
  • Custom Package for updating GL Accounts at Customer Bill to Site based on the values defined for Team and Business Unit at Customer Site level.
  • Involved in analyzing business requirements and designing the functional document MD50 and also translated functional document into technical document MD70.
  • Responsible for Migration of Suppliers, Supplier Addresses and Supplier Open Invoices, Matched Invoices/Receiving Accrual.
  • Worked on Personalizations and customization of JSP pages using OA Frame work for iexpenses and iprocurement modules.
  • Designed the migration/conversion strategy for all the interfaces and conversions for GL, AP, PO
  • Responsible for Developing and customizing all Forms and reports using Forms10g, Reports 10g.
  • Designed and Developed new reports like Bill to Customer, Unapplied Receipts Register, Cost Report and several other reports customization.
  • Building the interface tables required for performing validations before inserting the data into the Oracle Applications main tables.
  • Code walk through, unit testing, guiding the developers in completing their tasks in time.
  • Handled all the major issues while migration of the project from 11i to R12 Oracle applications.
  • Involved in debugging the code review for the RICE Components.
  • Designed and developed custom reports for the business in the R12.

Environment: Oracle Applications 12R: GL, AP, PO, CE, iExpenses, iProcurementFA, Forms10g, Reports10g, Java, Oracle Frame Work, SOA Architecture, BPEL, XML Publisher and Linux.

Confidential, Richardson, TX

Sr. Oracle Financials Applications Consultant

Module: Receivables, GL, AR, Order Management, Service Contracts, Install Base, Depot Repair

Responsibilities:

  • Designed the customization of Main Billing program to soft close the line and insert the billing information in a staging table and bill once the read comes in.
  • Designed and developed an end-to-end Applications Development Framework based workbench which allows contract authoring and modification.
  • Responsible for integration of Contracts Import with Oracle Receivables (AR) and Cash Management (CE).
  • Modified the OA Framework page “View Impacted Contracts” to add additional attributes to the page.
  • Responsible for the extensions in Order Management workflows and resolving and troubleshooting issues in Order to Cash flow.
  • Responsible for importing Regular, Debit memo, Credit memo invoices from legacy system to Oracle Receivables tables using CTL file and Auto Invoice import program.
  • Responsible for the design and development of a custom solution to import service contracts from a legacy (or custom) front-end system into Oracle Service Contracts and Order Management instance for the purposes of future administration, billing and to provide entitlements with a backend programmatic mechanism that supports typically high volume of contracts.
  • Responsible for the creation of correspondence templates in Oracle XML/BI Publisher for Dunning Plans in Oracle Advanced Collections.
  • Used Auto Lockbox functionality in this project.
  • Designed Service Contracts Import Concurrent program that triggers Worker program which validates the interface data with respect to existing setup in other modules like Pricing.
  • Designed Customized Reports like ageing analysis, Outstanding Invoices, and Customer wise report for amount that is considered bad debt.
  • Designed Payment Monitoring Program to update the contract Status to Terminated, Signed, Active and Unpaid Renewal depending on the Payment Status. This Interface also involves the termination of contract if it is not paid within 30 days of contract effective date.
  • Setting up the test data for CRPs.
  • Responsible for performance tuning and guiding the technical team with the analytic functions and multi table inserts in SQL and PL/SQL
  • Designed system architecture and pseudo code for Technical Design Document.
  • Modified the existing behavior of Systems transfer merge in Install Base in order to treat imported contracts differently.
  • Responsible for all the Source Control Activities for this project like checking in the code changes.

Environment: Oracle E-Business Suite 11.5.10 (AR, GL, IB, OM, OKS), SQL, PL/SQL, Reports9i, Forms 9i, JDeveloper, OA Framework, Toad.

Confidential, Los Angeles, CA

Sr. Applications Consultant

Module: Oracle Order Management, Service Contracts, Install Base, AR

Responsibilities:

  • Modified Advanced Search Page in Order Information Portal in Applications Development Framework to add Line Status additional criteria to query for Sales Orders.
  • Responsible for importing sales tax records into Order Entry application from sales tax feeder having different sales tax rates, dates and postal codes using interface program.
  • Designed the Generate Pre-Billing Customer Acceptance Concurrent Program to perform implicit acceptance of the all the Sales Order lines that have passed the expiration date. Expiration days attribute is defaulted from the Account Receivables Revenue Management setup for Customer Acceptance.
  • Designed a concurrent processing architecture for processing transactions in each period for a Periodic Average Costing cost type across multiple Cost Groups in a Legal Entity.
  • Responsible for resolving and troubleshooting issues in Order to Cash flow.
  • Designed and developed a custom program to convert the service contracts from legacy system to Oracle.
  • Designed and Developed the IB Upload Program.
  • Designed Utility Program to change the billing frequency and base rate of service contracts.
  • Designed the Custom Service Contract Extension Interface. The customization includes calculating the price Increase depending on the Age of the Machine or Service, Overage price Increases maintained in the Master Sales Contract. This Interface involves extending the contract last billing stream start date-2 for QTR/SA contracts and 60 days in advance for YR, SINGLE, MTH billing frequency. Creation of Billing Schedules depending on proration. This interface requires the setup of renewal rules, pricing context, Contract Approvers, Rule DFF.
  • Designed the Custom Termination API to allow future termination along with credit and re-bill.
  • Designed the custom update Contract post Install program to create billing schedules once the item is installed.

Environment: Oracle E-Business Suite 11.5.9 (OM, OKS, IB,), SQL, PL/SQL, Reports9i, Forms 9i, JDeveloper, Toad.

Confidential, Tampa, FL

Senior Applications Engineer

Module: Order Management, Purchasing, Receiving, Pricing, AP, AR, GL

Responsibilities:

  • System study, gap analysis, project methodology discussions (AIM methodology), High-level Business Analysis and recommendations.
  • Responsible for the delivery of the project in UAT Phase.
  • Migrating Customer Interface into Trading Community Architecture mapping the interface tables and columns using both the API’s.
  • Imported Sales Order and Customers using BPEL Process.
  • Worked on the PO Approval Process work flow by attaching the notification to contingent manager for the approval process and escalating it to permanent manager at the same time.
  • Developed Oracle reports related to AR, AP and GL.
  • Migration of Customers, Customer Addresses and Customer Open Invoices & create ship to address at Invoice level. Used TCA API’s to create customers under a party.
  • Used TCA API’s in migrating the legacy data into Oracle Application Tables.
  • Tax ware tax interfacing with Oracle Applications using the ar tax interface table.
  • Worked on Update TCA API’s of all the above as per the requirement.
  • Developing custom interfaces using PL/SQL, Setup concurrent programs and request sets to run interfaces.
  • Involved in controlling functions on the pages using SPEL programming thru OA Frame work.
  • Developing and customizing reports for AR, AP and PO using Reports 6i.
  • Responsible for unit test runs of complete flow including the setup of organizations, supplier/customer sites and relationships for both Discrete and Project Manufacturing scenarios.
  • Developed in collaboration with Confidential Team, the “Auto Receive subcontracting components” program that creates receipts after predefined in-transit lead time once the components are shipped against replenishment sales order.

Environment: Oracle Applications 11.5.10.0.2: OM, AR, AP, GL, Install Base, Service Contracts, Discoverer, BPEL Process, Forms6i/9i, Reports6i/9i and OAFrame Work, Java

Confidential, Mountain View, CA

Applications Engineer

Module: General Ledger, Account Receivables, Account Payables, Purchase Order

Responsibilities:

  • Developed PL/SQL Packages for GL Outbound interface to Legacy Systems.
  • Involved in Automation of oracle applications with Microsoft Active Directory System (Legacy system).
  • Developed PL/SQL Packages for Populate Service Parts Request Data into Oracle Base Tables using Oracle Standard API.
  • Involved in Developing Technical Specification and Documentation before developing the code and working with onsite Business Analyst.
  • Upgrade from 11.5.9 to 11.5.10
  • Played a key role in upgrading oracle 11.5.9 to 11.5.10 for PTP and RTR Tracks.
  • Identified various custom objects that needs to be rebuilt for 11.5.10 in General Ledger, Payables, Fixed Assets, Purchasing, iProcurement, Iexpenses.
  • Rebuilt iExpense Workflow.
  • Provided UI Customizations to iProcurement using OA personalization.
  • Mentored junior developers to rebuild various custom reports that have undergone changes in 11510.
  • Tuned various Custom discoverer views and reports.
  • GL Data ETL Extracts to Hyperion
  • Designed and Developed ETL programs to extract General Ledger and related sub ledger data to Hyperion system.
  • Improved the performance by eliminating problem queries and redesigning the programs.
  • Receivables
  • Developed ETL programs to extract AR waterfall data to Hyperion system.
  • Developed Customer Credit Limits Report to display the currency credit limits for a given customer account range.
  • Developed Customer Credit Limits Report to display the currency credit limits for a given customer account range.

Environment: Oracle Applications 11.5.9, 11.5.10: GL, AP, AR, PO, AOL, Sysadmin, Oracle 8i/9i, Forms6i, Reports6i, SQL Loader, UNIX and Windows N/T.

Confidential

Applications Engineer

Module: Order management, Account Receivables, General Ledger, PO, AP

Responsibilities:

  • Developed and Customized the Reports like PO Detail by Item Etc. PO Invoice Details Reports.
  • Vendor Payment Reports, PO Wise Invoice Details Report, Vendor Wise Invoice Details, Account Wise Invoice Details Report.
  • Developed and Customized below mentioned Forms.
  • Documentation - Documented Data Testing results in Unit Test Document and Code Changes Technical Design Document.

Environment: Oracle Applications 11.5.3: GL, AP, AR, OM, PO, AOL, Sysadmin, Developer Forms/Reports, Sql Loader, Linux and Windows N/T.

Confidential, San Jose, CA

Applications Engineer

Modules: Oracle Inventory, Oracle Bills of Material

Responsibilities:

  • Assisted in Enhancements to existing APIs such as migrating implementation from iSetup (Java) Framework to PL/SQL to improve the performance.
  • Implemented validations and middle tier logic for some APIs such as WIP Parameters using OA Framework BC4J components
  • Modified the Report Design which is created using Oracle Reports to show the new APIs.
  • Modified the Interface table to add a new column SITE ID for retail. Retail Team will invoke Copy Inventory Organization and update this column linking it to their site id after Copy Inventory Organization finishes copying.
  • Resolved numerous Customer issues in a timely manner.

Environment: Oracle E-Business Suite 11.5.9/11.5.10 (INV, BOM, WIP), OA Framework, Java, PL/SQL, XML, Reports 6i, Oracle 9i.

Confidential

Applications Engineer

Module: Order management, Account Receivables

Responsibilities:

  • Performance tuning and performing the Running of the Load Scripts.
  • Involved in OM and AR Interface Program Tuning and Developing.
  • Worked on OM order process workflow for customizing and providing notification to customers and partner customers.
  • Developed the performance of the concurrent programs by debugging the code.
  • Involved in the testing phase of the code review.
  • Monitoring the performance of the load of the data when transferring the orders.

Environment: Oracle Applications 11i: OM, AR, GL, AP, IB, OKC/OKS, workflow builder, Forms, Reports, Sql Loader

Confidential

Applications Engineer

Module: Order Management, Account Receivables, General Ledger, Account Payables, Purchase Order.

Responsibilities:

  • Responsible for preparation of Technical specifications from the functional specifications like CV45, CV60 and MD70.
  • Responsible for Complete Project Delivery and handling different project teams.
  • Responsible for rectifying the errors and fixing the bugs during Unit testing.
  • Developing custom reports, conversion and interface programs that are registered as concurrent programs and which are run from SRS form.
  • Developed 50 Custom Reports as per the client requirement with the team of 5.
  • Implemented Reports, Forms and Developing from scratch and customizing.

Environment: Oracle E-Business Suite 11.5.10: Om, AR, GL, AP, PO SQL, PL/SQL, Oracle Reports .

Confidential, Oakland, CA

Research Analyst

Modules: General ledger, Account Payables, Purchase Order

Responsibilities:

  • Responsible for PO Interface - Developed Conversion Package to load data from flat file to staging table and validate the data and load the validated data into PO Interface tables.
  • Involved in Developing Technical Specification and Documentation before developing the code and working with onsite Business Analyst.
  • Developed PL/SQL Packages for GL Outbound interface to Legacy Systems.
  • Worked on Pl/Sql Procedures, Triggers and Packages as part of Implementation and Production Support.
  • Debuging, Testing and maintaining the various OA Frame work components across multiple environment

Environment: Oracle Applications 11.5.10.0.2: GL, AP, PO, iprocurement, Oracle 8i/9i, OA Frame work, Discoverer, Forms6i, Reports6i, SQL Loader, Linux and Window N/T.

Hire Now