Techno-functional Consultant Resume
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