We provide IT Staff Augmentation Services!

Techno-functional Consultant Resume

3.00/5 (Submit Your Rating)

Sunnyvale, CA

SUMMARY

  • Having 13+ years of experience as a Techno - Functional Consultant in EBS / Oracle Apps R12 / 11i - SCM (Order Management, Shipping, Inventory, and Purchasing), Financials (Accounts Receivables, Accounts Payables, General Ledger and Fixed Assets), Manufacturing (BOM, WIP) and CRM (Install Base, Service Contract & Depot Repair).
  • Extensive experience in New Implementation projects, Oracle Apps Rollouts & Well-versed with all teh phases of Software Development Life Cycle (SDLC).
  • Extensive Experience in Oracle Forms, Oracle Reports, XML reports, Discoverer reports using Oracle Forms 6i/ 9i, Oracle Report builder 6i / 9i, XML Publisher, Discoverer tool & Oracle 10g/11g technologies.
  • Experience in 11i To R12 Upgrade process.
  • Extensive experience on working on Business requirements analysis, review, definition and documentation.
  • Experience in using Data Warehouse Administration Console (DAC) to schedule teh Informatica jobs and metadata management.
  • Extensive experience in RevPro Recognition process.
  • Expertise in design, development, and implementation of Business Intelligence applications including Business Analysis, Dimensional Modeling, Repository Management (RPD), Extraction Transformation and Load (ETL).
  • Well experience in System Impact Analysis, Design, Systems Architectural Design, Interfaces Process Design, Functional Flow Design, Data Process Flow Designs & presentations.
  • Experience in Business Process mappings for Integration project with interdependent modules and teams.
  • Experience in Oracle Workflow processes & methodologies.
  • Experience in designing and implementingOracle AlertsandLookups.
  • Experience in Unix Shell scripting & Python scripting.
  • Proven experience in project and team leading with extensive organizational and interpersonal skills. Equally comfortable working independently as well as in a team environment.
  • Experience in oracle query tuning methods & tips for improving teh system performance.
  • Excellent communicator with strong information analysis and continuous learning skills.
  • Excellent troubleshooting, de-bugging and problem-solving skills.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, C, C++

ERP: Oracle Applications R12 / 11i (11.5.9 and 11.5.10)

DBMS: Oracle 8i/9i /10g / 11g

GUI: Oracle Forms 6i / 9i / 10g, OA Framework

Reporting Tools: Oracle Reports 6i / 9i / 10gand XML publisher, REVPRO 2.4/3.0 (ASC606)

Design/CASE Tools: MS Project

Operating Systems: Win 2003/XP/2000/NT/ 7, MS DOS

Others: Workflow, VSS, PVCS

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

Techno-Functional Consultant

Responsibilities:

  • Preparing Technical Specification Documents as per teh business requirements.
  • Preparation of MD50 & MD70 documents as per business requirements in Order Management (OM), Accounts Receivables (AR), General Ledger (GL), Install Base (IB) & Service Contracts (SC) modules.
  • Involved in system gap analysis per teh requirements.
  • Involved in development of Forms & Reports in OM, AR, IB & SC modules, modification of teh reports for teh column additions / deletions.
  • Involved in 11i To R12 Upgrade E2E process.
  • Involved in R12 table level changes for existing Objects like Reports, Programs in 11i.
  • Involved in object changes related to R12 Version and creation of new logic and assignment.
  • Identification of objects for R12 changes and modification to teh required reports, programs and removal of unwanted programs.
  • Involved in R12 MOAC changes to AR reports for teh access to teh users to run teh required programs from single responsibility.
  • Tuning of AR reports and sql programs to produce teh program outputs in a shorter way to biz for smooth month end process.
  • R12 AR RX program parameter definition changes from SOB to Ledger level and Org wise data accuracy.
  • DevelopedSQL scriptsin AR to create temporary tables and developedSQL*Loadercontrol files to load teh legacy data into teh temporary tables.
  • Developed variousCustom reports, Customized existing reports(PO Purchase Order and Releases Detail Report, Purchase Requisition Status Report) according to teh functional specifications usingReports 6i and XML publisher.
  • Modification of existing AR Lookups for teh new orgs added / decommissioned.
  • Creation of new Triggers, Packages, Procedures, Functions, Concurrent Programs, Alerts, Request Sets using PL/SQL technologies.
  • UsedFNDLOADto migrate Concurrent Programs, Lookups, Value sets, Request Groups & Data Definitions in Various Instances in AR Module.
  • Involved in integration / modification of AR Reports, Personalization's & programs for Verizon IBX's acquired.
  • Revenue Recognition process using REVPRO 2.4/3.0
  • OM and AR Integration with REVPRO 2.4/3.0.
  • Involved in changes related to 605 to ASC606 and modifications to teh existing programs for 606 compatibility.
  • Involved in Water fall report layout changes for column additions and addition to teh new org's requirements criteria.
  • Involved in Termination lines changes and subsequent program changes in Event collection and Contingencies release level.
  • Involved in Summarize Data program performance tuning for teh long time running and glitches when running with Month end bill run process.
  • Expert in designing and implementing for Data Warehouse.
  • Hands on experience in ETL (Extraction, Transformation, and Loading) processes using Informatica Power Center 8.6/8.1/7.1/6.1.
  • Expertise in design, development, and implementation of Business Intelligence applications including Business Analysis, Dimensional Modelling, Repository Management (RPD), Extraction Transformation and Load (ETL).
  • Extensively used ETL processes to load data from flat files into teh target database by applying business logic on transformation mapping for inserting and updating records when loaded.
  • Involved in new Sql reports / changes to teh existing reports for Business adhoc requests.
  • Co-ordination & Interaction with different application stakeholders, cross functional teams per teh new requirements, changes and acceptance.
  • Resolving teh Performance issues related Pl/Sql Packages, Procedures & Functions.
  • SQL queries Tuning using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization.
  • Developed 5 Day Reminder Notice program in AR for sending Email Notification to customers when payment due is 5 days for all regions - AMER, EMEA, APAC with respective to their language specifications.
  • Implemented several custom logics for FormPersonalization in AR Transaction form.
  • Involved in new scripts and modifications using python.
  • Involved SQL Loader process for loading teh data from flat files for America, Europe & APAC regions for data validation needed by biz on a periodical intervals.
  • Identifying teh data issues & fixing for teh existing programs in OM & AR modules raised by global users.
  • Extensively involved inSQL tuning, troubleshooting, debuggingand fixing teh code and made teh changes according to teh new business requirements.
  • Designed and developed customUSER APPROVAL WORKFLOWto meet teh client application’s user creation and maintenance per teh business requirement.
  • DevelopedOrderStatusSummaryReport to provide teh status of orders in teh system for given time period.
  • Involved in Monthly invoicing process and mid-month charges verification.
  • Carry out Solution review, Design flows, testing, fixing of bugs, etc.
  • Involved in new Materialized view creation and it’s maintenance for refreshing concurrent programs & monitoring teh data updates periodically.
  • Involved in teh data extraction programs creation in IB & SC modules for identifying teh corrupted data and bugs in teh existing process for streamlining teh system behavior.
  • Involved in SQL scripts creation and data extracts on a regular basis.
  • Supporting QA, UAT and BAT Test Cycles.

Environment: Oracle Applications R12, Forms 9i, Reports 9i, HP-UX, Oracle 10g, REVPRO 2.4/3.0 (ASC606)

Confidential, San Jose, CA

Technical Consultant

Responsibilities:

  • Preparation of MD50 & MD 70 documents as per business requirements.
  • Identification of impacts on other modules per dis new / enhancement process implementation.
  • Analyze Design and Develop new software and enhancement modules per teh business requirements in Order Management, Purchasing and Account Payables modules.
  • Developed validation packages to Load data tointerface tables(OE HEADERS IFACE ALL, OE LINES IFACE ALL, OE CUSTOMER INFO IFACE ALL).
  • Worked onAuto Invoice Interface Programto validate and load credit memos, debit memos and invoices from legacy system.
  • Experience incustomizing oracle workflowssuch as teh PO approval process, Order/Line Flow to send user notifications based on teh business requirement.
  • Validatedthe data and populated thePayablesinterface table through aConcurrentprogram which in turnsubmitsa standardPayablesInterface program in AP.
  • Developed various crucial financial analysis reports (for all modules) forAP/OM/PO usingOracle Discoverer 10g.
  • Involved in Form personalization in OM, PO modules.
  • Co-ordination & Interaction with different application stakeholders, cross functional teams per teh new requirement changes and acceptance.
  • Design and development database Tables, Triggers, Database Triggers, Cursors, Procedures, Stored Procedures and Functions.
  • Development of Oracle Forms, Oracle Reports, XML Publisher and Discoverer reports in purchasing modules.
  • Involved in Adaptive planning process which includes programs development certain reports and running through SOA process.
  • Involved in oracle workflow process changes and impact analysis to teh existing system.
  • Involved in Production support issues raised by business.
  • Supporting QA, UAT and BAT Test Cycles.

Environment: Oracle Applications R12, Forms 9i, Reports 9i HP-UX, Oracle 10g / 11g

Confidential

Technical Consultant

Responsibilities:

  • Preparing Technical specification documents as per teh functional requirements in teh OM, PO, AP modules.
  • Analyze Design and Develop new software and enhancement modules per teh business requirements.
  • Design and development database Tables, Triggers, Database Triggers, Cursors, Procedures, Stored Procedures, Functions, Forms, and Reports.
  • Involved in new, changed and completed sales orders import from legacy system to oracle usingorder import (order management open interface).
  • Involved in development and enhancement to teh concurrent programs and report in Accounts Receivable, Install Base & Service Contracts modules.
  • Involved inCustomer Conversionsto load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables usingTCA APIs.
  • Developed variousRDF reports, Customized existing reportsin PO module - PO Purchase Order and Releases Detail Report, Purchase Requisition Status Report according to teh functional specifications usingReports 6i /9i.
  • Carry out Design review and code review, testing, fixing of bugs etc.
  • Changes to teh existing workflow processes.
  • Involved in understanding different servers data process & flows used across Confidential for teh data received.
  • Co-ordination &Interaction with different application stakeholders, cross functional teams per teh issues raised.
  • Managing and supporting teh Cross vendor teams/tracks for resolving teh inter-dependency issues in teh day-day activities.
  • Supporting in Month End (ME) and Quarter End (QE), Year End (YE) closing activities.
  • Involved in DU jobs performance, enabling / disabling activities & analysis for teh job aborting causes.
  • Resolving Production support issues / bugs raised by teh business with-in a stipulated timeframes.
  • Supporting teh issues related to teh data mismatches / discrepancy from teh cross flow streams on a priority basis.

Environment: Oracle Applications R12, Forms 9i, Reports 9i, HP-UX, Oracle 10g / 11g

Confidential, Sunnyvale, CA

Technical Consultant

Responsibilities:

  • Preparing Technical& Functional Specification Documents as per teh business requirements.
  • Involved in analysis, requirement gathering and design using MD70 documents.
  • Involved in system analysis per teh requirements.
  • Impact analysis in Order Management - SFDC integration for teh gap and solution as per teh business requirements.
  • Involved in development of reports in Order Management (OM), Purchasing (PO), Accounts Payables (AP), Accounts Receivables (AR), Install Base (IB) & Service Contracts (SC) modules.
  • Involved in Adaptive planning process which includes programs development certain reports and running through SOA process.
  • Involved in Depot repair process for service depot repair functions, Repair Order creation, status monitoring, receiving, and shipping of teh products repaired.
  • Involved in Orders track activities on customer or vendor items returned to service depot repair, for repair, upgrade.
  • Development of discoverer, XML Publisher reports & Interfaces per teh requirement in OM, PO modules.
  • Involved in new / updating teh oracle workflow processes.
  • Creation of new Triggers, Packages, Procedures, Functions, Concurrent Programs, Forms, reports, Alerts, Request Sets, Notifications setup.
  • Tax data verification & uploading process on a monthly basis.
  • Resolving Production support issues / bugs raised by teh business.
  • Resolving teh issues related to teh Customer billing invoices on a priority basis.

Environment: Oracle Applications R12, Forms 9i, Reports 9i, HP-UX, Oracle 10g

Confidential, San Jose, CA

IT Analyst

Responsibilities:

  • Preparing Functional Specification Documents as per teh business requirements.
  • Impact analysis on OTC / QTC areas in Order Management, Receivables for teh gap and solution as per teh business requirements.
  • Involved in impact analysis discussions on Oracle Trading Community Architecture (TCA) for teh scopes impacted.
  • Analyzing and identifying teh impacts at Order Management side for dis new process implementation.
  • Involved in analysis, requirement gathering and design using MD70 documents.
  • Involved in Post analysis for teh functional mappings.
  • Creation of new Triggers, Packages, Procedures, Functions, Concurrent Programs, Forms,
  • Reports, Interfaces as per teh requirement.
  • Unit Testing & Test Cycle support.

Environment: Oracle Applications 11i, Forms 6i, Reports 6i, HP-UX, Oracle 9i/10g

Confidential

IT Analyst

Responsibilities:

  • Preparing Functional Specification Documents as per teh business requirements.
  • Involved in gap analysis for teh business requirements and identification of teh custom
  • Identifying impacts to GL & AR Modules for teh new introduction tool Revenue Accounting Engine (RAE).
  • Analyzing and identifying teh impacts on other modules for dis new process implementation.
  • Impact analysis on Oracle Trading Community Architecture (TCA) discussions for teh dis new application introduction.
  • Involved in system impact analysis per teh business requirements.
  • Creation of new Triggers, Packages, Procedures, Functions, Concurrent Programs, Forms, Reports, Interfaces as per teh requirement.
  • Test Cycle support.

Environment: Oracle Applications 11i, Forms 6i, Reports 6i, HP-UX, Oracle 9i/10g

Confidential

IT Analyst

Responsibilities:

  • Preparing Functional Specification Documents (FSD) as per teh BRD requirements.
  • Identifying impacts to GL Modules for teh new operating unit Confidential -UKH.
  • Impact analysis on OTC areas in Receivables for teh gap and solution as per teh business requirements.
  • Involved Oracle Trading Community Architecture (TCA) analysis discussions for teh new UKH operating unit introduction.
  • Analyzing and identifying teh impacts on other modules for dis Confidential -UKH operating unit.
  • Involved in analysis, requirement gathering and design using MD70 documents.
  • Creation of new Triggers, Packages, Procedures, Functions, Concurrent Programs, Forms, Reports, Interfaces as per teh requirement.
  • Tracking teh issues in teh PROPEL tool for teh new enhancements required for teh business.

Environment: Oracle Applications 11i, Forms 6i, Reports 6i, HP-UX, Oracle 9i/10g

Confidential

IT Analyst

Responsibilities:

  • Conduct Impact analysis in teh POC fast track in AR module
  • Providing solutions to teh analyzed products & service line track
  • Changes required to teh AR modules related issues.
  • Preparing teh functional specifications as per teh BRD provided.

Environment: Oracle Applications 11i, Forms 6i, Reports 6i, HP-UX, Oracle 9i/10g

We'd love your feedback!