We provide IT Staff Augmentation Services!

Sr. Techno Functional Developer Resume

Frisco, TX

SUMMARY

  • Around 26 years of experience in positions of increasing responsibility, emphasizing skills in Software Development Life Cycle of Software Engineering, i.e. systems design, analysis, development, testing, documenting and implementation of Oracle based systems using Oracle Forms 10g, Reports 10g, Oracle Application Framework (OAF), Oracle Discoverer 10g, Oracle BI/XML Publisher, Oracle Workflow Builder, PL/SQL, WebADI, SQL Loader.
  • Experience in using Oracle BI/XML Publisher, Oracle BI Discoverer Administrator by creating End User Layers. Business Areas/folders/Item classes/Hierarchies. Experience in developing Oracle BI Discoverer Plus adhoc reports.
  • Proficient in working with Oracle Applications as Techno - Functional, Oracle Applications Developer. Experienced in customization by extension and modification of the standard application suite using Application Object Library.
  • Experience in writing OUM/AIM documents MC, AN, DS/MD70 and MD120 for CEMLI/RICE components.
  • Proven expertise in the customization, enhancement, and maintenance of forms, reports, workflows, interfaces, working with files, and data conversion for importing the data from feeder system to Oracle EBS.
  • Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency using Explain Plan and TK Prof.
  • Expertise in System Administration including Oracle Applications activities like defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, request sets, profiles
  • Experience in Post Go-Live support, and assist in issue resolution
  • Experience in managing and working with offshore teams outside US.
  • Commitment to excellence proven by outstanding career track. Good Analytical and communication skills.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, Java, XML, HTML

Databases: Oracle 6.0/7.x/8.0/9i/10g, 11i, 12g, Microsoft Access 2.0, SQL Server

Data warehouse Tools: Oracle Discoverer 10g, Informatica, Business Objects, and Cognos

Tools: Oracle Developer 10g (Forms 3.0/4.0/4.5/5.0/6 i/10g, Reports 2.0/2.5/3.0/6 i/10g, RPT Reports), Oracle BI Publisher, Oracle Workflow Builder, Oracle Application Framework (OAF), Oracle Discoverer 10g, Oracle JDeveloper 10g, Oracle Application Express 4.2 (APEX), Data Loader, SQL*Loader, TOAD, PL/SQL developer, STATcm, CVS, PVCS, HEAT, SQA, Visual Café, JBuilder, MS Office, Subversion, Sharepoint

O/S: Windows7, Windows 10, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Frisco TX

Sr. Techno Functional Developer

Responsibilities:

  • Worked on migrating AX2012 Financial and Supply Chain data into Oracle EBS R12.1.3
  • Worked on Several Financial, SCM and HCM Modules like AP, AR, Order Management, Purchase Orders, Inventory, Projects, Project Billing, General Ledger and Human Resource
  • Actively involved in gap analysis, remediation and migration efforts of Oracle EBS R12.1.3 to Oracle EBS R12.2 and Oracle Fusion.
  • Worked on migrating Oracle EBS R12.1.3 to Oracle EBS R12.2
  • Worked on Conversions like Purchase Orders, AP Invoices, AR Customers, HR Employees, AP Suppliers, Purchase Order Receipts, Inventory
  • Worked on Inbound interfaces like ADP to GL, AR Customers, TechPay Invoice to AP, AR Customer Invoices
  • Worked on Outbound interfaces like Oracle HR to SPI, Oracle HR to ADP, Oracle HR to Adelman, Oracle Purchase Orders to 3rd party system, Projects to ChromeRiver
  • Worked on HR Periodic Notification Alerts
  • Worked on customizing seeded Workflows like Project Supplier Invoice account Generator, PO Requisition Account Generator, PO Requisition Approval, PO Approval
  • Worked on several custom programs supporting Payables, Purchasing, Receivables and Project Billing modules
  • Customized Forms using Custom.pll and forms personalization in Purchasing, Receivables modules
  • Worked on several custom reports using Oracle BI Publisher and Oracle Reports 6i using Data Templates, Layout Templates and Bursting Templates.
  • Worked on creating several Oracle Discoverer reports in HR, Purchasing, AP, AR, Inventory and Project Billing.
  • Worked on code migration scripts FNDLOAD, WFLOAD and XDOLOAD to move code across instances.
  • Worked on MD120 documents to list the steps needed for code migration.
  • Supported Month end closing process.
  • Involved in supporting the users during the application user testing.

Environment: - Oracle EBS 11i (AP, AR, GL, HR, INV, PO), Oracle EBS R12.2, WebADI, Oracle 10g, TOAD, Data Loader

Confidential, Arlington TX

Techno Functional/Sr. Programmer

Responsibilities:

  • Worked on Several Finance Module Conversions like Purchase Orders, Invoices, Receipts, Fixed Assets and GL
  • Worked on HCM Module Conversions like Courses, Active Enrollments, Elements, Open Requisitions and Job Postings.
  • Designed and developed Outbound Interface of HR Benefits employee and disability data are sent to Cigna Insurance, HR Benefits data to Ceridian and HR New Hire employee enrollments including Plans enrollments and deduction factor for each plan to ADP
  • Designed and developed Inbound Interface of Trowe Price (401k), loading data from file into staging tables, validating and pushing into the seeded interface table and submitting seeded Standard Batch Entry process.
  • Designed and developed multiple Invoice/Refund Invoice interface files received from different sources with different formats into Oracle Payables
  • Worked on Dealer/Vendor interface to update or create suppliers in Payables module
  • Worked on Balance forward billing.
  • Worked on customizing OAF pages in iRequisitions and Payable Modules and custom eBilling process
  • Created new form functions and assigned OAF screens developed, sub-menus, menus and based on the user roles. Created new custom top menus and assigned to new custom responsibilities. Used MVC design patterns and created Entity object (EO), Entity Associations, View Objects (VO), View Links, Regions, Pages, Page Controllers and Application modules (AM) to maintain Transactions context when the transaction flow spans multiple page. Also implemented Partial Page Rendering (PPR).
  • Customized Forms using Custom.pll and forms personalization in AP, AR, FA and Purchasing.
  • Worked on several custom reports using BI Publisher and Oracle Reports 6i using Data Templates, Layout Templates and Bursting Templates.
  • Worked on creating several Oracle Discoverer reports in HR, Benefits, Purchasing, Payables and Receivables.
  • Worked on code migration scripts FNDLOAD, WFLOAD and XDOLOAD to move code across instances.
  • Actively involved in remediation and migration efforts of Oracle EBS R12.1.3 to Oracle EBS R12.2
  • Involved in supporting the users during the application user testing.
  • Performed SQL and PL/SQL tuning for performance improvements using Explain Plan and TKPROF.

Environment: - Oracle Application Framework (OAF), Oracle EBS R12.1.3 (AP, AR, GL, FA, HCM(HR, OAB, OLM, iRec), INV, PO), OAF, Sub ledger Accounting (SLA), WebADI, Oracle 10g, TOAD, Data Loader, SQL*Loader

Confidential, NY

Techno Functional/Sr. Developer

Responsibilities:

  • Managed and worked with INDIA offshore team effectively in delivering the Oracle BI Publisher Reports
  • Designed and developed conversion of Supplier invoices into Project Billing and wrote custom program to generate draft invoices for each of the unpaid invoices.
  • Designed and developed creating custom desktop integrator (WebADI) to upload Fixed Assets physical inventory location data into FA interface table and wrote custom program to compare and update the asset location.
  • Worked on customizing various workflows like Account generator workflow to build accounts using auto-accounting rules defined in project accounting, Budget Approval Workflow, Contract Approval Workflow and OEOL workflow to generate billing events in Project Billing for OM shipments instead of creating Invoices in AR
  • Designed and developed custom program to Autocreate Cost groups and associating the WIP accounting classes for each project manufacturing organization. Also associating cost groups to project parameters.
  • Developed custom API’s utilizing seeded API’s from Project Costing modules.
  • Developed Project related account generator workflow changes like PO, Requisition, Supplier Invoice and Expense report.
  • Worked on Projects client extension like Project Security Extension, Project and Task Date Extension, Project Verification Extension, Transaction Control Extension
  • Worked on Project Status Inquiry to add additional columns.
  • Worked on several custom programs supporting Purchasing, Payables, Receivables and Fixed Assets modules
  • Customized Forms of Project Costing and Fixed Assets using Custom.pll and forms personalization
  • Designed and Developed conversion program of Depot Repair Orders into Order Management, Install Base and Service Contracts.
  • Developed several custom reports using BI Publisher and Oracle Reports 6i using Data Templates, Layout Templates and Bursting Templates.
  • Developed several Oracle Discoverer reports in Projects, Purchasing, Payables and Receivables modules.
  • Worked on code migration scripts FNDLOAD, WFLOAD and XDOLOAD to move code across instances.
  • Worked on MD120 documents to list the steps needed for code migration
  • Involved in supporting the users during the application user testing.
  • Performed SQL and PL/SQL tuning for performance improvements using Explain Plan and TKPROF.

Environment: - Oracle EBS R12.1.3 (AP, AR, GL, FA, IB, SC, PA, PB, INV, PO), OAF, Sub ledger Accounting (SLA)WebADI, Oracle 10g, TOAD, Data Loader, SQL*Loader, Oracle Workflow Builder

Confidential

Techno Functional/Sr. Developer

Responsibilities:

  • Involved in R12 upgrade of Purchasing, iProcurement, Inventory, AP, AR, Projects, FA and GL modules.
  • Worked on uploading Project Expenditure items using WebADI and wrote a custom program to do Split and Transfer the expenditure items in Project Costing module.
  • Worked on custom API’s utilizing seeded API’s from Project Costing modules.
  • Worked on Project related account generator workflow changes like PO, Requisition, Supplier Invoice and Expense Report.
  • Worked on Projects client extension like Project Security Extension, Project and Task Date, Project Verification, Transaction Control Extensions. Worked on Project Status Inquiry to add additional columns.
  • Worked on several custom programs supporting Purchasing, Payables, Receivables and Fixed Assets modules
  • Worked on custom reports using BI Publisher and Reports 6i using Data, Layout and Bursting Templates.
  • Worked on creating several Oracle Discoverer reports in Projects, Purchasing, Payables and Receivables modules.
  • Worked on several data extracts in Purchasing, Inventory, Payables, Receivables, Projects, Fixed Assets modules.
  • Worked on code migration scripts FNDLOADER and XDOLOADER to move code across instances.
  • Involved in implementation of EDI (850, 855, 856, 810)

Environment: - Oracle EBS R12, Oracle EBS 11.5.10.2 (AP, AR, GL, FA, PA, INV, PO, iProcurement), OAF, Sub ledger Accounting (SLA), Multiple Reporting Currencies (MRC), WebADI, Oracle e-Commerce Gateway (EDI)

Confidential

Techno Functional Consultant

Responsibilities:

  • Wrote several technical design documents (MD70) following AIM Methodology standards, analyzing the business requirements from functional document (MD50) and MD120 documents.
  • Designed and developed several custom zoom forms using Oracle Forms, called from Order Management module.
  • Worked on customizing the seeded Contact Center screen (Customer Service module)
  • Designed and developed custom API’s utilizing seeded API’s from TCA, OM and Service Contracts modules.
  • Customized Forms from various modules (Customer Service, Service Contracts, Order Management) using Custom.pll and forms personalization
  • Worked on Oracle Trading Community Architecture (TCA) Data Quality Management (DQM), setting up Match rules, attributes and transformation functions.
  • Worked on customization of Order Header and Order Line workflows using Oracle Workflow Builder.
  • Designed and developed custom reports using XML Publisher and Oracle Reports 6i.
  • Coordinated the development efforts with off-shore team in India

Environment: - Oracle Applications R12.1.3 (TCA, ONT, SC, INV, JTF, AR, AK), Sub ledger Accounting (SLA), Multiple Reporting Currencies (MRC), Oracle 10g, TOAD, SQL*Loader, Oracle Workflow Builder

Hire Now