Techno Functional Consultant Sample Resume Format in Word Free Download

640Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

SUMMARY

·         Over 7 years of experience as Techno-Functional Consultant in Oracle E-Business Suite Applications implementing

a.       Full Life Cycle Implementation Projects

b.       Post Production Support Project

c.       Upgrading Projects

·         Extensive experience as Techno-Functional consultant in implementation of Oracle Applications R12/11i/. Strong conceptual knowledge and highly Proficient in design, development and Implementation of Oracle Supply Chain Management, Manufacturing and Financial Modules like Purchasing(PO),Account Payables(AP), Accounts Receivables(AR) & General Ledger(GL), Fixed Assets (FA), Inventory(INV), Order Management(OM), Work In Process(WIP), Bill Of Materials(BOM),Oracle Apps Framework(OAF), Shipping(WSH).

·         Functional responsibilities: Requirements gathering fit gap analysis, design, configuration, customization and testing the script.

·         Technical responsibilities: identifying the functional and technical gaps, interacting with functional lead and users, designing custom solutions for the functional configuration, programming and testing the programming

·         Good Understanding and implementation experience of Order to Cash & Procure to Pay life cycles.

• Excellent understanding of Multi Org and TCA Architecture.
• Used AIM (Application Implementation Methodology) for Documentation purposes like MD, CV, BRD.
• Experienced in development, Customizing, modifying Forms (6i/9i/10g), Reports (6i/9i/10g) existing in Oracle applications according to business requirements and specifications.
• Expertise in design and development of RICE (Reports, Interfaces, Conversions and Extensions) components.

·         Expertise in Oracle Developer Suite: Oracle 10g/9i/6i SQL,PL/SQL, Oracle Forms 10g/6i/9i, Oracle Reports 6i/9i/10g, Oracle Designer, Crystal Reports, Discoverer, Toad, SQL *Plus.

·         Experienced in Performance Tuning using Explain plan, tkprof, optimizer hints.

·         Knowledge of UNIX Shell scripting, Java, Servlets, JSP, XML and HTML.

·         Goal Oriented individual with ability to direct complex projects from concepts to fully operational status. Organized, Excellent interpersonal, communication, documentation and leadership skills.

Technical skills

	Packages	Oracle Applications EBS11i (Versions 11.0.3/11.5.6/11.5.9/11.5.10.1/11.5.10.2, R12)
	ERP Modules	General Ledger (GL), Accounts Payables (AP), Accounts Receivables(AR), Advanced Pricing(QP), Inventory (INV), Work in Process (WIP), Bills of material(BOM), Order Management (OM), Purchasing (PO), Material Resource Planning(MRP), Shipping(WSH),    Application Object Library (AOL).
	Processes	Order to Cash, Procure to Pay
	Operating Systems	UNIX, Windows NT/200/2003 Server
	Database	Oracle 8i / 9i / 10g
	GUI	Developer 2000/6i
	Tools	Discoverer, XML Publisher, SQL * Loader, Toad, SQL *plus
	Languages	C, C++, SQL, PL/SQL, Java, JSP, Servlets, Web Services, JDBC
	Web Scripts	HTML, XML, X L, PHP, CFML, JavaScript
	Packages	MS-Office
Certifications /achievements

·         Oracle Certified Associate

·         Oracle 11i E-Business Suite Essentials

PROFESSIONAL EXPERIENCE

Client:             NPC, Louisville, KY.                                                                                                       Feb 2011 – Present

Project:           Oracle Applications Release 11i Implementation

Designation:   Oracle Apps TECHNO- FUNCTIONAL CONSULTANT

Description:     National Processing Company (NPC) Headquarters in Louisville, KY provides a wide range of business transaction processing, from point-of-sale credit card processing to e-commerce solutions. These services include the electronic acceptance of credit, debit, gift and loyalty cards, and electronic checks.

Responsibilities:

• Wrote Functional (MD50), Technical (MD70) and Conversion Mapping document (CV40) and Designed and Developed Staging tables, Data Conversion SQL Loader Program to import the Legacy system data using Open interface tables in Oracle.

·         Involved in Auto Invoice Interface to load invoices automatically from legacy systems to Oracle Receivables (AR).

·         Worked on Customer Party Relationship in Receivables AR using TCA Architecture.

·         TCA/customer clean-up project including building PL/SQL scripts to seed core Party and Customer merge tables.

·         Developed Sales Order Interface by designing Staging tables, SQL*Loader Program and Custom PL/SQL to import the Sales Orders using Open interface tables in Oracle Order Management.

·         Developed Customer Conversion in Receivables. Created PL/SQL procedures and functions necessary for customer record validations before loading records into customer interface tables.

·         Developed PL/SQL procedures for obtaining and fixing interface trip stop program in the process of interfacing internal sales order.

·         Worked on the Oracle Inbound Ship Confirm APIs, which perform actions on Deliveries, Updating shipping attributes, updating the Freight costs, through WSH_DELIVERIES_PUB, WSH_DELIVERY_DETAILS_PUB and WSH_FREIGHT_COSTS_PUB shipping APIs.

·         Involved in customization of several standard reports to serve important business processes very specific to the client. Such reports include Purchase Order Detail Report in PO, OM reports like Pack List Main Report, Summary Pack List Report, Sales Acknowledgement Report, Order Holds Report and Inventory Movement from one inventory org from another inventory org in INV using Oracle Reports and XML/BI publisher.

·         Developed SQL loader scripts and custom interface programs for importing, validating and inserting the On Hand Quantity data from legacy system to staging and interface tables. Scheduled a standard API to load data into the target base tables of INV Inventory.

·         Developed OM queries to Count Orders by Order Types, Order Source. Identified, demonstrated and documented Order Entry, drop shipments, Internal Orders, RMAs.

·         Developed PL/SQL script to define business specific picking rules and avoid reservations to modify the stand order flow.

·         Customized pick slip, packing list reports based on functional specification.

·         Developed Order Status Summary Report to provide the status of orders in the system for given time period.

·         Developed Inventory Account Book report to display the inventory transactions based on a specified period.

·         Customized the AR aging reports to add additional fields and change the format of the report as per the business requirements.

Environment:  Oracle Applications R12 (GL, AR, AP, OM, PO, INV), PL/SQL, SQL*Plus, SQL*Loader, Reports 9i, Shell Scripting, TOAD, Discoverer, Windows XP, UNIX.

Client:             E.ON, Louisville, Kentucky                                                                                  May 2010 – Feb 2011

Project:           Oracle Applications Release 11i Implementation

Designation:    Oracle Apps TECHNO- FUNCTIONAL CONSULTANT

Description:     E.ON is a leading renewable energy company and its business is the development, construction and operation of large scale wind farms and other renewable energy systems.

Responsibilities:

·         Used AOL and System Administrator modules for registering the developed and customized reports. Also used features like Descriptive Flex fields, LOV’s, Value Sets, Concurrent Programs, Standard Request Submissions (SRS) and Parameters in the process of development.

·         Modified existing codes and developed oracle reports, PL/SQL packages to perform certain specialized functions/enhancements on oracle Application as specified by the user.

·         Worked with Administration and desktop Edition of Oracle Discoverer. Involved in creating business areas, user views, custom folders and material views for reporting using Oracle Discoverer 9i. Generated ad hoc reports in end user layer.

·         Involved in design, development, and Implementation of Oracle ERP (GL and AR) and CRM modules.

·         Prepared technical documents MD70 and functional document MD50 as per the business requirement.

·         Involved in the data mapping and conversion programs for moving legacy data to Oracle Service Contracts, Field Service and Install Base.

·         Worked on the generation of Field service Report based on the information captured in Tasks.

·         Customized the Auto Renewal process in Service Contracts by listing out the reasons for service contracts not being renewed, and modifying it accordingly.

·         Designed and implemented customizations for sales commissions, billing procedures, and costs of goods sold.

·         Involved in design, development, Implementation and testing of Oracle manufacturing modules INV, OM, and also Oracle Sales and Quoting.

·         Created and Customized Reports in AR, INV, PO, BOM using Oracle Discoverer 9i and Oracle Reports 6i.

·         Developed and customized various Reports like Customer Summary Listing, Invoice Report, Prepayment Status, Invoice On-Hold Reports and Invoice Aging Report.

·         Worked on GL budgets interface to load the budgets data into the base tables using the budgets upload program.

• Defined tax rates, setting up the tax payables control options. Developed programs for Oracle Payable (AP) Invoices and Vendor conversions. Loaded all suppliers into Oracle Payables. Created routine of import supplier invoices from legacy system to Oracle Payables

·         Customized the AR aging reports to add additional fields and change the format of the report as per the business requirements.

·         Customized Return Material Authorization (RMA) workflows to send custom notifications depending on item type and shipping organization.

·         Successfully designed and implemented the Purchase Orders Open Interface. Activities involved creation of control file, porting data into the interface tables and then used Import Standard Purchase orders concurrent program to port the data into the Oracle base tables.

·         Involved in customization of several standard reports to serve important business processes very specific to the client. Such reports include Purchase Order Detail Report in PO, OM reports like Pack List Main Report, Summary Pack List Report, Sales Acknowledgement Report, Order Holds Report and Inventory Movement from one inventory org from another inventory org in INV using Oracle Reports and XML/BI publisher.

Environment: Oracle Applications 11.5.10.2 (OM, AR, GL, PO, WSH, INV), Oracle 9i, Reports 6i, XML Publisher, Forms 6i, SQL, PL/SQL, SQL*Loader, Windows 2000, UNIX.

           

Client:              Handleman, Troy, MI                                                                                           Sept 2009 – May 2010

Project:            Oracle Applications Release 11i Implementation

Designation:    Oracle Apps TECHNO-FUNCTIONAL Consultant

Description:    Handleman Company operates as a category manager and distributor of prerecorded music titles to retailers in the United States, the United Kingdom, and Canada. The company manages the selection, acquisition, delivery, retail ticketing, display, and return of music product for its retail customers’ stores. It also distributes video game hardware, software, and accessories to retailers in the United States the Project involved Implementation of Oracle Applications 11i. I was involved in developing conversion programs and interfaces and in the design and development of Reports and modification of Standard Oracle application reports using Discoverer in AR, OM, PO, AP, INV and GL modules.

Responsibilities:

·         Interacted with functional leads, technical lead and data management team in order to document the technical and development specifications using standard AIM Standards.

·         Prepared documents like MD070, CV060 and MD120 and resolved certain data requirement issues.

• Used SQL*loader scripts to load the invoices from other accounting systems to payables staging tables.
• Involved in checking the validity and accuracy of the legacy data by writing PL/SQL packages.

·         Imported Items from legacy system into Oracle Inventory (INV) base tables using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.

• Imported customer data into Oracle Receivables tables using TCA APIs.
• Developed PL/SQL scripts to load order data from external system to OM interface tables and OE base tables.
• Performed PO data conversion by developing a wrapper program in order to validate and load the data from staging tables into PO interface tables and then populating the Oracle base tables through a standard PDOI Interface program.
• Worked in resolving the technical related issues related to OTC and P2P cycle.
• Worked on Auto Invoice Conversion Program to validate, load credit memos, debit memos and invoices from legacy system.
• Performed the system administrator role by setting up the user privileges, assigning responsibilities, customizing the menus, adding new concurrent requests, creating Request
• Frequently worked with defining accounting and descriptive flex fields DFF, writing validations to custom forms.

·         Designed and Implemented Order Discount Hold system and developed reports for holds placed and released.

• Groups for reports, registering custom forms and custom reports with applications so that they can be accessed from within the applications.

·         Used Form Personalization to use ZOOM functionality which pops up an appropriate form based on the item context.

• Standard reports in INV module like
• Customer Item Report
• Inactive Item Reports were enhanced according to the business needs.
• Created custom folders, item classes in Discoverer Administration, cross tab, page detail reports, conditions, parameters, sharing of workbooks in Desktop edition of 9i/10g.
• Creation of new custom reports using Oracle XML Publisher & Discoverer as per client requirements.
• Involved in writing the UNIX shell scripts.

·         Performed performance tuning SQL queries to improve performance.

Environment: Oracle E-Business Suite 11.5.9(INV, OM, PO, AP, AR and GL), Oracle 9i, PL/SQL, Forms 6i,       Reports 6i, Discoverer 9i, UNIX, TOAD.

Client:             Tulane University, New Orleans, LA.                                                            Aug 2008 – Sept 2009

Designation:   Oracle APPS TECHNO-FUNCTIONAL Consultant.

Description:    Tulane is one of the most highly regarded and selective independent research universities in the United States. This university implements Oracle Applications 11i and I was involved in developing conversion programs and interfaces and in the design and development of Reports and modification of Standard Oracle application reports using Discoverer in AR, OM, PO, AP, INV and GL modules.     

Responsibilities:

• Involved in implementation of the complete life cycle of Order to Cash and worked extensively on modules like ONT, INV, PO, WSH, WIP Move, AP and AR.
• Involved in interacting with functional leads, technical lead and data management team in order to document the technical and development specifications using standard AIM documents like MD070, CV060, and MD120 and resolve certain data requirement issues.
• Documented functional features and behavior of required customizations using AIM.
• Prepared conversion documents.
• Developed different types of Discoverer reports in AOL module.

·         Used TCA APIs to create new customers, customer sites, customer accounts and contact points

·         Developed Reports in Reports 6i to suit the company business requirement to create Debit Memo/Credit Memo when there is a difference with customer agreement rate and unit selling price in the Invoice. This Report will basically extract data from various base tables within Order Management and Receivables

·         Designed and developed Inbound and Outbound Interfaces using PL/SQL and SQL*Loader and UNIX Shell Scripts, to load/extract the data into/from Oracle tables.

·         Developed scripts for Open Replenishment Interface.

·         Developed multiple custom Reconciliation Reports in INV module using Oracle Reports. Designed and developed custom statistical reports using Discoverer 6i.

Environment: Oracle Application 11.5.10.2 (OM, GL, PO, AR), OEM, SQL* plus, imp/exp, SQL, pl/sql, SQL* loader, Forms and Reports 6i, XML Publisher, Toad, Excel Code, Discoverer 6i.

 

Client:             Nummi Inc., Fremont, California                                                                    Oct 2007 – Aug 2008

Designation:               Oracle Apps Techno-Functional Consultant

Description:                New United Motor manufacturing, Inc. (NUMMI) was an automobile manufacturing Plant, which assembles automobiles by gathering different parts from different suppliers.

Responsibilities:

·         Responsibilities included discussing MD-50 documents and suggesting modifications.

·         Involved in creating Technical Documents (MD70).

·         Involved in Customer Master Cleanup project. Developed a custom Interface to: Update the customer account numbers that are no longer active, Create a relationship with the newly added customer account numbers. Delete the existing outdated customer account number relationship and Update the ‘bill_to_site_use_id’ corresponding to the ‘ship_to’ locations of the existing customer account numbers.

·         Involved in WIP move transactions interface, AP invoices Interface & Item Conversion.

·         Created and customized standard reports in GL, WIP & OM modules.

·         Involved in creating Queries for Business Objects to produce reports, Generating XML flat files from select queries, developing SQL*Loader scripts to load data into tables, and working with the Production Support team to fix many high priority bugs.

·         Worked with Administrative and Desktop Edition of Oracle Discoverer.

·         Personalized standard reports and forms according to business requirements, using Oracle Forms and Reports.

·         Involved in training end users on the functionality of Order to Cash (O2C), PO Modules.

Environment:  Oracle Applications 11i Oracle 10g, TOAD, SQL, PL/SQL, SQL *Loader, Forms 6i, Reports 6i, Discoverer 6i.

Client:             Praga Tools Ltd, Hyderabad, India.                                                              Aug 2006 – Oct 2007

Designation:   Oracle APPS TECHNO-FUNCTIONAL Consultant

Description:                Praga is one of the leading Machine Tool manufacturing units in India. These company products are well known in the field of Machine Tools. This company is equipped with modern facilities for design, development and manufacture of Machine Tools. This company also does Machine Tools- Cutter and Tool Grinders, Copy lathes, Thread Rolling Machines.

Responsibilities:

·         Used Application Implementation Methodology (AIM) for documenting the technical and functional specifications in MD 70 and MD 50.

·         Worked on GL budgets interface to load the budgets data into the base tables using the budgets upload program.

·         Worked on OM Interface programs to resolve interface issues between OM and a third party shipping support system.

·         Using APIs imported the Invoices data into the Oracle payables from the flat file. The data is loaded & validated from the staging tables into the AP Invoice interface tables. Run the Payables Open Interface Import Program to import the data from the Invoice interface tables to the Invoice base tables. Created the Staging table’s script. Developed PL/SQL Program for the AP Payments API. Created the Staging table script.

·      Performed functional testing for existing modules to understand existing business process, created documents to understand functional requirements for interfaces.

·         Worked with developers for custom reports for the Vendor performance analysis, Printed Purchase Order and Order Acknowledgement reports.

• Designed and developed an inbound interface to load the legacy data to Oracle Receivables (Customer, Contact Information).

·         Involved in the upgrade of the legacy system to load the legacy data to Oracle Order Management.

• Developed and customized various reports using Reports 6i and sql plus.
• Designed and developed order import timings report (custom) and order invoice details report as per the user requirements.
• Designed and developed Inbound and Outbound Interfaces using PL/SQL and SQL*Loader and UNIX Shell Scripts, to load/extract the data into/from Oracle tables.

Environment: Oracle Applications 11.5.9 E-Business Suite AR, PO, WIP, ONT, BOM, GL, AP, Oracle 9i,   Developer 2000 (Forms, Reports), UNIX, RED HAT Linux, TOAD.

 

Client:                         BPL, Mumbai, India                                                                                       Nov 2005 - Aug 2006

Designation:               Oracle Programmer Analyst

Description:    British Physical Laboratories (BPL) is most recognized as brand names in the India for power line communications carrier, televisions, telephones, etc., it is known for its strong service presence across the country through a distributive network comprising of over 7000 channels.

Responsibilities:

·         Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.

• Familiar with entity relationships, schema analysis, documentation, troubleshooting and unit testing. Establish and maintain positive business relationships with key personnel and work with them to prioritize work according to their needs, and help them with the ad-hoc analysis and research into data issues.

·         Involved in testing and fixing bugs on test and on-line data.

·         Involved in database and GUI design.

·         Troubleshooting production problems and worked effectively with other team members to identify and address problems.

• Analysed, developed, and tested Oracle, PL/SQL programs for Automated Financial Improvement Program (AFIP). Developed interfaces in Microsoft Access for Windows on PC.
• Developed SQL Applications for extracting the data from the Oracle tables.
• Created user defined Exceptions while Handling Exceptions.
• Developed new interfaces in ORACLE using PL/SQL and SQR on Unix Sun Sparc system for SFS.

·         Involved in complete documentation using MS Office.

·         Written JDBC coding for oracle database connectivity.

Environment: Oracle9i, Windows 2000/UNIX, Advanced Server, TOAD, PL/SQL, Oracle Developer, Java, JSP, JSF, JDBC, Tomcat Server

 

Client:             Buywell Technology, Hyderabad, India                                                         July 2004 – Nov 2005

Designation:    Oracle Developer

Description:   Buywell is a marketing affiliate of Indian Petrochemicals Corporation Limited, one of the largest Petrochemical companies in India. As a developer, I was involved in the development of various software business applications in the three-tier environment. As a member of database group was involved in project specification, designing and implementation of database applications.

Responsibilities:

·         Worked closely with database developers to ensure adherence of the database guidelines, standards and procedures and generated system plans.

·         Writing UNIX Shell scripts and commands for file management, job automation and administration tasks.

·         Actively involved in all stages of project life cycle.

·         Developed validation procedures and error reporting on the data in the intermediate tables.

·         Designed and developed the web – based application using Java Servlets and JDBC concepts and JavaScript. Also consists of various metrics developed using Java Applets.

·         Worked with various functional experts to implement their functional knowledge into working Procedures like database maintenance, employee maintenance, and employee’s payment schedule.

·         Migrated the data from Excel sheets, text files into the respective Oracle Database tables using SQL *Loader    scripts.

·         Development of screens in forms using oracle forms 4.5 at backend according to the requirements of Client.

·         Designed custom reports using Report Builder.

·         Extensive use of PL/SQL programming like creation of Procedures, Functions & Packages.

Environment: Oracle 8i, TOAD, SQL plus, SQL Loader, Java, Windows, UNIX

Education

·         Bachelors in Computer Science & Information Technology.

 

Download Resume Format