We provide IT Staff Augmentation Services!

Senior Apps Techno/functional Consultant Resume

2.00/5 (Submit Your Rating)

Houston, TX

SUMMARY

  • Over 11+ Years of IT experience in ERP implementation and Enterprise Applications Practice with proven experience in Developing, Customizing, Supporting/Maintenance and Migrating / Up gradation of Oracle Applications E - business Suite R12& 11i,These includes Analysis, Customizations, Design, Development and Implementation for applications based on Relational DBMS and in the field of Oracle e-business Suite and very strong in PL/SQL development, worked around 10 projects, and customer oriented, multitask professional with excellent analytical and logical skills possesses.
  • Having excellent experience in development & maintenance of Oracle Applications Fusion, R12& 11i.
  • Good Technical skills in developing RICEW or CEMLI Components in the domain of Oracle E-Business Suite
  • Areas of expertise technical developments and having functional knowledge in Multi-org, MOAC, SLA, INV, PO, AP, OM, AR, GL, BOM,FAand Advance Pricing Trading Community Architecture (TCA) of ERP modules
  • Having 4 full life cycle implementation, 1 Upgrade and Support experience with exposure to viz. AIM 3.0,Agile and OUM methodologies
  • Strong Domain knowledge in various business flows including Financial Modules like Account Receivables, Account Payables, Order to Cash (O2C) and Procure to Pay (P2P) cycles.
  • Good Experience in Software Change Management (SCM) of Implementation, Custom, Migration, Support Projects.
  • Having excellent work experience with having knowledge on generating XML reportsand EIS reports
  • Rich experience in registration/migration of Forms, Reports, PLSQL programs and XML Publisher Reports.
  • Good Experience in registration of Menus, Functions, Value Sets and Concurrent programs
  • Developed forms using customizing the forms and Form Personalization
  • Good at development of interface and conversion programs using PLSQL and Oracle Standard APIs
  • Having excellent experience in the areas of D2K (Forms6i&10g, Reports 6i&10g) based applications using Oracle 9i, 10g& 11g(SQL&PLSQL) Technologies
  • Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL FILE, Oracle packaged APIs etc.
  • Good experience in Oracle Change Management with Materialized views, Package, Procedure, Functions etc.
  • Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.
  • Expert in developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120)
  • Write technical design documents for conversions, extensions, interfaces, and reports. Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs)
  • Ability to handle user defined errors by developing Error-Handling Package using PL/SQL
  • Having good experience in development and customization of Work Flow (WF), Oracle Application Framework (OAF) & Oracle APEX according to business needs
  • Having knowledge on development of Business Process Engineering Language (BPEL) using Service Oriented Architecture (SOA) Concepts
  • Strong in UNIX shell scripting and performance tuning of several objects using hints and several other processes, analyzing TK-Prof files and Explain Plan.
  • Having good expertise in Preparing Technical Documents, Unit Test Scripts (UTS), Code Review Checklist (CRC), Test Plan and Test Results documents based on the user/customer requirements.
  • Having Experience on Oracle Fusion Middleware 11g with JDeveloper
  • Having Experience on perform documentation adhere to the SOX & SOP
  • Expertise in working with end-users for support, troubleshooting and giving effective & efficient resolutions for the technical issues
  • Analytical and problem solving skills with ability to work independently when needed.
  • As a member of the software engineering division, we will develop software according to provided design specifications. Analyze system specifications and existing business processes and information systems
  • Expertise in working in fast-paced, high-tech environments requiring skills in scheduling, management and team building
  • Adopting new technologies, Very flexible and perform tasks are ad-hoc basis
  • Team Player with Excellent Technical, Communication, Interpersonal skills & Leadership abilities

TECHNICAL SKILLS

OS/Environment: Ms-Dos, Windows, Linux and UNIX.

RDBMS (Database): Oracle 9i, 10g & 11g.

Oracle E-Biz Suite (EBS): Oracle Applications 11i, R12 and fusion apps.Manufacturing, DistributionSupply Chain Management (SCM),P2P Inventory (INV), Purchasing (PO), Order Quote, Order Management (OM/OE/ONT), Work In Progress (WIP), Bills of Materials (BOM),, Shipping Execution (WSH), Project Accounting (PA), Advanced Pricing, Human Resource (HRMS), Sys. Admin & Appl. Dev.

Financials: Accounts Payables (AP), Accounts Receivables (AR), iReceivables, Fixed Assets (FA) & General Ledger (GL).

CRM Modules: Trading Community Architecture (TCA/HZ).

Languages, Scrips & Frameworks: SQL, PL/SQL, JAVA, OAF, SOA, Oracle APEX, C, C++, Shell, HTML, Java and SQL Server.

Middleware: Oracle Fusion 11g (ADF & SOA (BPEL))

Front-end Tools (GUI): Forms 6i&10g, Reports6i&10g, Jdeveloper10g, Work Flow Builder.

Business Intelligence (BI): Oracle Discoverer 10g, XML Publisher.

Tools: TOAD, SQL Developer, PL/SQL Developer, SQL Navigator, SQL*PLUS, SQL*LOADER, WINSCP, Putty, FTP, WSFTP, JIRA, FileZilla, MS-Office, Open Office, SQL Mgmt Studio. Version Controls SCM, Jira, SCCS, PVCS, Mercurial.

Key Competencies& Skills: Client Relations, Business Analysis, Product Mapping and Consultancy, Data Migration Mapping, Test planning, UAT & Testing.

PROFESSIONAL EXPERIENCE

Senior Apps Techno/Functional Consultant

Confidential

Responsibilities:

  • R12.2.6 Development and Support Project.
  • Worked on Inbound interfaces (Sales order, BPA, AP invoices).
  • Developed outbound interfaces (suppliers, Invoices) for OPENTEXT.
  • Developed custom program to send emails with invoice hold details.
  • Developed Oracle APEX pages for new requisition creations and updates.
  • Created/Modified Metadata repository (.RPD), Customized BI Repository, defined/developed Physical Data Layer, Business Model & Mapping Layer and Presentation Layer using BI Administration Tool.
  • Developed Reports with different Analytics Views (Drill-Down, Pivot, View Selector and Tabular with Filters) using OBIEE Answers.

Environment: Oracle EBS 12.2.6(AP, AR, OM, PO) JDeveloper, Oracle RDBMS 10g, EIS, Oracle APEX, UNIX, HTML, CSS, and Java Script.

Senior Apps Technical/ Functional Consultant

Confidential

Responsibilities:

  • R12.2.3 Development and Support Project.
  • Worked on Custom OAF application, Extensions and customizations.
  • Developed REST services for Customers, Sales orders, BOM components.
  • Developed the PL/SQL programs using dbms xmldom to generate XML files for outbound messages.
  • Developed custom interactive reports in APEX.
  • Developed UI in Oracle APEX and integrated with EBS.
  • Developed custom application for patients expenses using APEX.
  • Worked on Interactive grid, interactive reports and classic reports in APEX.
  • Developed the REST services for customer creation and updates using WS02.
  • Developed the integrations using oracle cloud integrator (ICS) between HCM and EBS.
  • Worked on Payment Process request to create bank files.
  • Developed Custom XML Publisher reports.

Environment: Oracle EBS 12.2.3(AP, AR, OM,Service Contracts(OKC),BOM,HCM), Jdeveloper, Oracle RDBMS 10g, XML Publisher, Oracle APEX, HTML, CSS, Java Script, UNIX, WS02,Workflow and ICS.

Senior Apps Technical/ Functional Consultant

Confidential

Responsibilities:

  • R12.2.5 Upgrade Project.
  • Customized the Customer OAF pages using CO/VO Extensions.
  • Modified/Personalized multiple OAF pages (Restricting the size of the address fields, created run time VO’S to add new columns in oaf pages).
  • Designed and developed an Inbound Interface between web based Order Management system to Order Management (OM) for import Sales Orders.
  • Customized the sales order acknowledge report using xml publisher.
  • Customized the AR invoice interface program.
  • Wrote custom PL/SQL API’s for converting Sub processes in Order to Cash (O2C) like Customer, Order entry, Order fulfillment, Invoicing, Customer payments, Receipt.
  • Worked on SOX compliance audit.
  • Developed Test scripts, Code review check list, Test plan, and Test result in SCM and finance
  • Modified the 11i objects for R12 compatibility.

Environment: Oracle EBS 12.2.5(AP, AR, OM,shipping), Jdeveloper, Oracle RDBMS 10g, XML Publisher, Oracle APEX,UNIX, Workflow and SQL Loader.

Oracle Apps Consultant

Confidential

Responsibilities:

  • R12.1.3 Production support and R12.2.4 Upgrade.
  • Developed the XMLBursting program to send AR invoice to customers.
  • Customized the AP checks for bank of America.
  • Developed GL Daily rates package to import rates from OANDA site.
  • Developed conversion program to load inventory item, categories.
  • Developed the Project costing cross charge intercompany program AR (Provider) and AP (Receiver) Invoices.
  • Customized accounting generated workflow for supplier invoice and PO requisitions.
  • Developed BPA reports and AR Statements.
  • Worked on Oracle Projects Billing Interface with Oracle Receivables.
  • Developed Time sheet/billing for internal Smartdog applications using APEX.
  • Developer APEX pages for Oracle custom reports.
  • Developed Dash Boards, Pages for custom interfaces using APEX
  • Personalize the OAF page for enable iReceivables for external user.
  • Added new tabs to an existing OAF page, restructure the VO queries, call database packages to retrieve the values and display them on the tabs of the page according to the business requirements.
  • Worked on PO accounting generator workflow

Environment: Oracle EBS 12.1.3(AP, AR, GL, PA, PO, iReceivables), Jdeveloper, Oracle RDBMS 10g, Developer 2000 (Reports 6i/9i), XML Publisher, Oracle APEX, UNIX, Workflow and SQL Loader.

Fusion Developer

Confidential

Responsibilities:

  • Fusion Apps Implementation.
  • Customized the seeded payment files (ACH file, Positive Pay file, AP checks).
  • Involved in conversions using “File-based Data Import” web services for loading legacy data to Fusion apps.
  • Developed custom OTBI reports ex: AP Invoice on hold, Invoice exception report.
  • Developed diagnostics reports in fusion apps.
  • Designed the documents to migrate the payment files from one instance to another instance.

Environment: Oracle Fusion(AP, AR, GL, PA, PO) Jdeveloper, OTBI, BI Publisher, UNIX and SQL Loader.

EBS Techno functional Consultant

Confidential, Houston, TX

Responsibilities:

  • Working on out bound interfaces programs to integrate Oracle with Stratix system.
  • Developing the Pl/Sql program for Product interface to collect the item information from oracle to send it to Stratix.
  • Developing the program to extract the catalogs information from item description.
  • Developed pages for reports using oracle application express (APEX).

We'd love your feedback!