We provide IT Staff Augmentation Services!

Staff Engineer - Software Resume

Englewood, CO

SUMMARY

  • 9+ years of Oracle EBS experience focusing on analysis, design, development, customization and implementation of various businesses applications using Oracle Applications E Business Suite 11i / R12/ HCM.
  • Well experienced in the following modules:
  • Oracle Fusion HCM
  • Financials: Accounts Payable (AP), Accounts Receivables (AR), General ledger (GL), Project Accounts (PA), Fixed Assets (FA), Cash Management (CM)
  • Supply Chain Management (SCM): Inventory (INV), Purchasing (PO), Order Management (OM), Advanced Pricing (QP), Shipping (WSH)
  • Others: iExpenses, iProcurement, Human Resources Management Systems (HRMS), Install Base, Workflow, Application Data Interface (ADI) and Electronic Data Interface (EDI) modules
  • Experienced in full life cycle implementations, conversions, upgrades and support of Oracle E - Business Suite 11i / R12 environments
  • Experience in Oracle HCM Implementation.
  • Experience in Procure to Pay (P2P) and Order to Cash (O2C) cycles
  • Expertise in designing functional & technical specification documents
  • Expertise in developing MD-50, MD-70, BR-100, CV-60 documents using AIM methodology
  • Proficient in performing FIT / GAP analysis, designing Reports, Interfaces, Conversions and Extensions (RICE) Objects. Expertise in Forms and Form Personalization’s
  • Commendable experience in data conversions, interfaces, migrations, import and export using tools like SQL*Loader
  • Excellent verbal and written communication skills. Work well under pressure. Meet ambitious deadlines. Works well in a team as well as by self

TECHNICAL SKILLS

Oracle Applications: HCM, OIC, Oracle Applications R12, 11i, 11.0.3, 10.7

Operating Systems: HP UNIX, Sun Solaris, Windows 7, XP/2000/NT, MS-DOS

Programming: C, C++, C#, VB.NET, ASP.NET, Unix Shell Scripting, PL/SQL, Python,VB, Silverlight, WCF, WPF

Web Specific lang.: ASP.NET, PHP, XML, DHTML, HTML, PHP, JavaScript, JSP(JDeveloper)

RDBMS: Oracle 11g/10g/9i/8i, MS SQL Server

Tools: Toad, SQL*PLUS, SQL*Loader, Oracle Workflow 2.0.3/2.5/2.6

Internet Tools: TCP/IP, FTP, Telnet, Gopher, Microsoft Front Page, Netscape Composer

Version Control Tools: Clearcase, Visual Source Safe, PVCS

Reporting Tools: Reports 2.5/ 6i, Oracle Discoverer 3i/4i, Crystal Reports

Methodology: AIM 3.0

Development Tools: Developer 2000, Oracle Forms 4.5 and Visual Studio

Oracle Applications Modules: Account Receivables (AR), Accounts Payables (AP), Project Accounting (PA), Purchasing (PO), Fixed Assets (FA), General Ledger (GL), Cash Management (CM), Human Resources(HRMS), iProcurement, iExpense, Order Management (OM), Work in Process (WIP), Inventory (INV), Quality (QA)

PROFESSIONAL EXPERIENCE

Staff Engineer - Software

Confidential, Englewood, CO

Responsibilities:

  • Worked on Order Import interface, to load all the legacy orders in booked status into Oracle for Project Emily.
  • Developed PL/SQL interface to load FA Locations automatically in to R12 and developed XML Publisher reports to generate daily reports for locations created using the custom interface.
  • Customized the Credit Analysis Report, and Pick Slip reports in Order Management OM.
  • Developed custom workflow for Cycle Count Approval for non-serialized items in Inventory.
  • Developed custom OAF webpages for Vendor Creation in AP Module. Also, developed a custom workflow for the approval process for vendor creation.
  • Wrote PL/SQL packages for different validations, for processing data in order to create Valid POs and Receipts and for populating the PO interface tables and called the seeded import programs to populate the base tables.
  • Designed and Developed and Outbound Interface to send the Order details for a given customer.
  • Developed custom PL/SQL interface to load Dish One Vendors from a csv file and to generate reports for successfully loaded and rejected vendors.
  • Worked on custom OAF workbench in Oracle QA module used for inspecting items based on sample inspection plans.
  • Developed XML Publisher reports for QA Inspection and Black hole reports.
  • Worked on several conversions of Work Structures like Grade, Grade Rate, and Locations for HCM Implementation from R12.
  • Worked on Oracle Integration Cloud to develop integrations for Fidelity 401k, ADP, Success Factors, FurstPerson and TextRecruit.
  • Worked on Fast Formulas used in Extracts for Work Structures in Oracle HCM.
  • Worked on OIC Integrations for implanting Oracle Recruiting Cloud feature.
  • Create a PL/SQL interface for making mass changes to part number GL coding across organizational units.
  • Created new GL and responsibilities for Echostar merger with Dish.
  • Worked on custom PL/SQL interfaces and conversions for managing warranty information for Set Top Boxes manufactured by contract manufacturers.
  • Performed ERP production support environment for the Oracle AP, AR, SCM, HR application modules.
  • Worked on Customer conversion to import data from Legacy System into Oracle Account Receivables by using Customer Interface. Created SQL*Loader control programs and validation procedures to execute along with Customer Interface (AR).
  • Worked on UTL PACKAGE and SQL*LOADER for the interfaces and conversions.
  • Created personalization's on the order management form to show values in the field dynamically, as per the requirement.
  • Modified the custom form for Serialized Items to add functionalities as per the business requirements using form builder.
  • Actively participated in SQL statements tuning using Explain Plan, SQL Trace, and TKPROF.
  • Developed technical documents for the extensions using functional documents and trained end users in detail.

Environment: Oracle Applications - AP, AR, GL, OM, PO, INV, HRMS, OA Framework, iProcurement, Work Flow, Oracle HCM, Oracle Apps R12, Oracle 10g/12i, Forms 9i/6i, Reports 9i/6i, SQL*Loader, XML Publisher, PL/SQL, TOAD, Hyperion.

Programmer Analyst

Confidential, Salt Lake City, UT

Responsibilities:

  • Performed Tier II system troubleshooting in a production support environment for the Oracle SCM, HR, Financials application modules.
  • Build a custom RTF document type for printable view of Purchase Orders in iSupplier.
  • Developed Custom Oracle Forms for entering Trading Partners and raise custom business event to validate trading partners for sales orders and purchase orders using SAP GTS system.
  • Developed XML Publisher Reports for the Custom QA Collections report.
  • Worked on Unix Shell scripts to load files into database using CTL, SQLLOADER.
  • Worked on modifying several Oracle Custom Reports in Purchasing, Inventory, HRMS modules.
  • Worked on converting RDF reports to XML Publisher Reports to generate Excel and PDF output files.
  • Customized forms using CUSTOM.PLL file to meet the specific requirements.
  • Developed custom PL SQL Package to Finally Close and Close old Standard PO, Purchase Agreement, Releases to clean up the system.
  • Developed custom PL SQL Packages to generate XML, text files and SFTP the files to corresponding SFTP locations.
  • Written several MD70s for all the above projects at EchoStar.
  • Converted many custom forms, reports, PL SQL objects from single Org to multi Org.
  • Designed and created financial and accounting reports using Hyperion Financial Reporting Studio on a monthly and quarterly basis.
  • Personalized OAF Form for iSupplier.
  • Customized seeded OAF Form for Quality collections form.
  • Built custom OAF Forms for Quality.
  • Developed Custom OAF search and entry page for entering PROFORMA invoices for corresponding sales orders and sending the invoices to validate using SAP GTS system.

Environment: Oracle Applications - AP, AR, GL, OM, PO, INV, HRMS, OA Framework, iSupplier, Work Flow, Oracle 10g/12i, Forms 9i/6i, Reports 9i/6i, SQL*Loader, XML Publisher, PL/SQL, TOAD, Hyperion.

Oracle Technical Consultant

Confidential, Renton, WA

Responsibilities:

  • Designed and developed an interface custom package to create and Update vendor/vendor sites implementation according to BR which is not provided by standard API’s.
  • Communication from legacy to Oracle applications were established through IBM MQ series using data contracts which were signed off for both parties integrating the applications.
  • Designed and developed the Reconciliation process for GL module.
  • Provided hands on training to business user community for Post- Production support issues & daily and month-end closing of accounting periods for GL.
  • Written an API for Converting the Invoice Payments (AP) and was able to convert all the Historical Invoice Payment History into Production.
  • Written an Interface for Account Payables (AP) Invoice Upload, which creates invoices from a CSV file.
  • Created Asset categories and assigned the assets to that particular category in Fixed Assets.
  • Invoked standard API’s within custom packages for creating and updating Customer, Sites and Contacts.
  • Developed PL/SQL Procedures for Customer interface in Accounts Receivables (AR).
  • Analyzed, developed, configured and tested the AT&T customer model into the Oracle 11i TCA (Trading Community Architecture) framework.
  • Involved in System Analysis, Design, Development, Testing, Documentation and Implementation of AP, AR, GL modules.
  • Prepared Functional and Technical Specification documents.

Environment: Oracle Applications - AP, AR, GL, OM, PO, INV, Service Contracts, OA Framework, iExpense, Work Flow, Oracle 10g, Forms 9i/6i, Reports 9i/6i, SQL*Loader, XML Publisher, BPEL, PL/SQL developer, TOAD, OA Framework, Java, JSP/Servlets, JDK, J2EE, Crystal Reports, .net, MS SQL Server.

Oracle Apps Developer

Confidential, Indianapolis, IN

Responsibilities:

  • Designed customizations, interface/conversion mapping, pre-production testing, and related documentation.
  • Developed and customized Financial Modules (GL, AR, AP, PO), Interacted with end users to gather requirements and Draft specifications for development Phase.
  • Written an API for Converting the Invoice Payments (AP) and was able to convert all the Historical Invoice Payment History into Production.
  • Worked on Order import using Order Management OE ORDER PUB API to import data into Oracle. Developed PL/SQL Packages for Validations of data. And populated the data into base tables.
  • Prepared Functional and Technical Specification documents.
  • Built the custom screens for the Benefits to show the Employees and Assignment history, Leave information and ESM using OAF.
  • Modified the Seeded Forms Contact & Employee Balances forms to show from the Benefit Service Center

Environment: UNIX, Oracle Applications (R12) - AP, AR, Purchasing, GL, FA, HRMS, Cash Management, OM, INV, TCA, Procurement (I-Procurement, I-Supplier Portal, Purchasing, Payables), OA Framework, Work Flow, Oracle Approvals Management (AME), Oracle 10g, Forms 9i, Reports 9i, Discoverer 4.1/9.0.2, XML publisher, SQL*Loader, PL/SQL developer, UNIX, Java, JSP/Servlets, Crystal Reports, JDK, J2EE, TOAD, .net, MS SQL Server.

Oracle Techno Consultant

Confidential, Arlington, VA

Responsibilities:

  • Designed and developed a procedure to capture the existing metrics in Legacy system and make them available with Oracle as Advanced Collection Notes.
  • Customized HR Payroll changes Report using XML/BI Publisher.
  • Developed HR Termination Report using XML/BI Publisher.
  • Customized OTL Missing Timecard Report using XML/BI Publisher.
  • Customized OTL Timesheet Review Report using XML/BI Publisher. Basically this report gives the information of Project Name, Task, and Expenditure etc.
  • Prepared Functional and Technical Specification documents.
  • Designed and developed a process to provide an Extract File at the end of each GL period, with general ledger summary details of invoicing and cash activities for that period.
  • Developed SQL Loader Programs and PL/SQL procedures to load
  • Invoice data into Oracle from various feeder systems
  • Receipts data from the Bank files into AR tables using AUTO LOCKBOX
  • Legacy systems data into Project Accounting interface tables.

Environment: Oracle Application EBS 11i/R12 (AR, GL, HRMS, IEX, OM), Toad 9, UNIX, SQL, PL/SQL, Oracle 10g, Workflow Builder 2.6, Developer 6i, Crystal Reports, ASP.NET, C#, MS SQL Server

Hire Now