We provide IT Staff Augmentation Services!

Techno Functional Lead Resume

AtlantA

SUMMARY:

  • 15+ years of Technical and Functional Experience in design, development and customization of oracle applications.
  • Extensive experience in Oracle Financials and Supply Chain Modules.
  • Managed Onsite - Offshore Teams for global implementations.
  • Worked as individual contributor, Lead and Associate project manager.
  • Handled R12 and 11i AP, AR, GL, E-business Tax, Payments, iExpenses, PA, PO, FA, CM, I Expense, Projects Accounting, HRMS, Payroll, OM, INV, BOM, WIP, Install Base, Sales Contracts and Service Contracts Modules and Advance Collections.
  • Expertise in Implementation, Upgrade Projects using AGILE/SCRUM Methodologies.
  • Expertise in P2P and O2C processes.
  • Full life cycle implementation experience in ORACLE Applications Release R12 and Release 11i.
  • RICE: Technical Expertise in Reports, Interfaces, Conversions, Customizations, Enhancements.
  • Expertise in ORACLE DB, SQL*Plus, PL/SQL, Forms, Reports, SQL*Loader, Data Loader Scripts and experience using XML Publisher Reports, Discoverer and Alert, Workflows and Concurrent Manager, OAF and Workflow.
  • Expertise in Database Performance Tuning, Triggers, Procedures, Packages, Functions and Libraries.
  • Hands on Experience in BI Tools like Discoverer Admin/End User Editions, XML/BI Publisher and BI Dashboards, Views & BI Answers and OBIEE.
  • Experience System Requirement Study, System Analysis & Development, Test Plan Preparation, Unit testing, System Integration testing and documentation. Interacted with the Oracle Applications end users, analyzed their business requirements and changed them to requirements, Customized and tested Oracle Applications modules.
  • Developed Technical and Functional Specification (MD 50&MD 70) documents.
  • Developed Test Cases. Conducted End User Trainings.
  • Implemented Projects as per SOX compliances.
  • Good understanding on SOA and Oracle Fusion Middleware Architectures.

TECHNICAL SKILLS:

Operating Systems: Windows 9x/2000/NT, LINUX, UNIX on Sun/HP-UX OS, MS-DOS.

RDBMS: Oracle 10.7/11i (Oracle 11.5.8/11.5.9/11.5.10 ), Oracle 8i/9i/10g, MS-Access

Languages: C and C++, Java, SQL, PL/SQL.

Development Tools: Developer2000, Forms/Reports 6i/9i, Discoverer Administration, Discoverer Plus/Desktop, TOAD, SQL Plus, XML publisher, Work Flow Builder, Oracle System Administration, BI Publisher, Noetix Views, OBIEE Admin and Developer, JDeveloper, FSG and WEB ADI.

Networking: TCP/IP, FTP, TELNET, and HTTP.

Utilities: SQL Loader, UNIX Scripts vi Editor.

Version Control Tools: KINTANA Mercury IT Governance Suite, PVCS, Microsoft Visual SourceSafe

Project Management Tools: MS Visio, Microsoft Project.

WORK EXPERIENCE:

Techno Functional Lead

Confidential

Responsibilities:

  • As a Lead, Managed Procure to Pay Implementation with external vendors Like Accenture to design, developed Technical and Functional Components for R12.2.3 implementation.
  • Developed Technical and Functional Specifications as per Requirements.
  • Designed and Developed Reports using XML/BI Publisher. Oracle Application reports were developed in XML/BI Publisher in Oracle Application Modules (Open Invoice and Open PO Reports)
  • Designed and Developed Supplier Conversion Program.
  • Designed and Developed Purchase Order Reports in XML Publisher. Synchrony customized its PO Templates for Standard, Blanket and Contract PO. Separate Package was created to get custom fields.
  • Architected Design and Development for Check Printing and Positive Pay for Payables.
  • Led team members in finding solutions for various RICE development activities.
  • Resolved Web Center(Fusion) Issues and Procure to Pay Issues.
  • Did OAF Personalization to meet user requirements.
  • Configured Custom Responsibilities (Procurement Contracts).
  • Customized Self Service Pages using OAF. Controller Extension on I procurement Pages.
  • Customized workflows and resolved workflow notification issues.
  • Supported Day-to-Day Operations and Production Support issues (Technical and Functional).
  • RICE object Development in AP and IExpenses.

Sr. Technical Lead Consultant

Confidential, Atlanta

Responsibilities:

  • Developed Technical Specifications as per Requirements.
  • Resolved Technical and Functional issues.
  • Designed and Developed Reports using XML/BI Publisher. Oracle Application reports were developed in XML/BI Publisher in Financials and Supply Chain Modules.
  • Resolved IExpense related Functional Issues.
  • Designed and Developed Order Conversion and PO Conversion Program.
  • Led team members in finding solutions for various RICE development activities.
  • Discoverer11g Administration and Reports Development for Financials, HRMS and Supply Chain Modules. Designed and Developed Discoverer Reports and Administered Discoverer - Several Ad-hoc Reports were developed for Users according to their request. Created Business Areas. Migrated EULs and Business Areas and Folders from Discoverer 9g to 10g. Converted reports from 11i to R12.
  • Administered and Developed Reports in OBIEE.
  • Supported Day-to-Day Operations and Production Support issues in IExpenses, Oracle Financials and Projects.
  • RICE object Development in PO, AP and IExpenses.
  • Architected Design and Development for Check Printing and Positive Pay for Payables.

Sr. Oracle Technical Consultant

Confidential, Atlanta

Responsibilities:

  • Provided expertise in getting solutions for development tasks.
  • Created Reports using XML/BI Publisher and OBIEE.
  • Developed Technical and Functional Specifications as per Requirements.
  • Developed Customer Conversion. Migrated Legacy customer information into Oracle.
  • Developed WEB applications using Oracle APEX 3 and 4. Upgraded APEX applications from APEX version 3 to 4.1.
  • Developed BI Publisher Reports in 10g and 11g.
  • Customized Oracle Reports 10g.
  • Developed PL-SQL packages for Financials/Supply Chain/HRMS Modules for various customer requirements in Oracle Applications.
  • Discoverer 11g Administration and Reports Development for Financials and Supply Chain Modules.
  • Customized Self Service Pages using OAF and workflows.
  • Designed and Developed OBIEE Reports.
  • Supported Day-to-Day Operations and Production Support issues. Resolved Technical and Functional issues.

Sr. Oracle Technical Lead Consultant

Confidential

Responsibilities:

  • Managed On-Site and Off-Shore Team Members in Financials and Supply Chain Module Related Development tasks.
  • Resolved Technical and Functional issues.
  • Developed Technical and Functional Specifications as per Requirements.
  • Supported Day-to-Day Operations and Production Support issues.
  • Designed and Developed AP Invoice Interface: AP interface program was created to handle the new business logic. Invoices from Legacy systems were imported into Oracle.
  • Designed and Developed Contractor Workflow Notification workflow for management of contractor’s Working period in Manheim. This workflow sends notifications when a contractor’s tenure is about to expire. Using the notification the respective manager will determine whether to extend or terminate the contractor. PL-SQL and workflow tools were extensively used.
  • Developed BI Publisher Reports in 10g and 11g. Migrated BI Publisher Reports from 10g to 11g.
  • Discoverer11g Administration and Reports Development for Financials and Supply Chain Modules.
  • Administered and Developed Reports in OBIEE.

Sr. Consultant and Lead

Confidential, Atlanta

Responsibilities:

  • Managed developers in getting RICE development for R12 Financials and Supply Chain Modules.
  • Designed and Developed Conversion programs for Customers and AP invoices, Sales Orders and Purchasing.
  • Architected and Developed Check printing so that client can print checks out of E-Business Suite. The payment profile and formatting were done in Oracle R12 Payments Module. The templates were created in BI Publisher for Confidential / Confidential .
  • Designed and Developed E-text Templates for Positive Pay File/ACH/WIRE Payments
  • Developed Technical and Functional Specifications as per Requirements.
  • Designed and Developed Discoverer Reports and Administered Discoverer - Several Ad-hoc Reports were developed (Around 72 for modules like GL, AP, AR, PO, INV) for Users according to their request. Created Business Areas. Migrated EULs and Business Areas and Folders from Discoverer 9g to 10g.
  • Converted reports from 11i to R12. Finance Reports like AR Aging Report and AP Trial Balance Reports were modified and converted to Discoverer Reports. PO Reports like Open PO Report by Buyer/Cost Center, Uninvoiced Receipts Report Were customized and also converted into Discoverer.
  • Developed BI Publisher Reports in 10g and 11g. Migrated BI Publisher Reports from 10g to 11g.
  • Customized Oracle Reports 10g.
  • Discoverer 11g Administration and Reports Development for Financials and Supply Chain Modules.

Sr. Consultant

Confidential

Responsibilities:

  • Provided expertise and guidance to team members in getting solutions for various issues.
  • Developed Packages to extract data from 3rd party applications.
  • Developed Reports in XML Publisher.
  • Designed and Developed Objects with SQL, PL-SQL. Developed Concurrent Programs.
  • Designed and Developed PL/SQL programs to load the assets from the acquired company into existing Oracle system.
  • Customized PO Templates using XSL-FO and XML languages.
  • Discoverer Administration and Reports Development for Financials and Supply Chain Modules.
  • Supported Day-to-Day Operations and Production Support issues.
  • Resolved Technical and Functional issues.
  • Customized Self Service Pages using OAF.

Sr. Lead Consultant

Confidential, Atlanta

Responsibilities:

  • Managed On-site and Off-Shore Team Members in various Development Activities.
  • Designed and developed the following reports: Used XML Publisher, XML and XSL-FO extensively.
  • Designed and Developed reports in XML/BI Publisher - Pick Slip Report, AR Invoice Print and AR statement reports.
  • Customized Purchasing Workflows.
  • Customized Self Service Pages using OAF.
  • Developed Packages to extract data from 3rd party applications.
  • Designed and Developed Objects with SQL, PL-SQL. Developed Concurrent Programs.
  • Discoverer Administration and Reports Development for Financials and Supply Chain Modules.

Confidential

Sr. Lead Consultant

Responsibilities:

  • Led Onsite and Offshore developers in Financials, Supply Chain, HRMS and CRM Module related developments.
  • Designed and Developed AP Invoice Interface: AP interface program was created to handle the new business logic. Imagistics wanted to change the way it was receiving invoice files in their OMD system. Instead of different Batch files for different zones (East, West and South) they wanted to receive all these in a single file.
  • Developed Order Conversion and PO Conversion Programs. Migrated Legacy SO and PO information (headers and Lines) into Oracle.
  • Developed Conversion Program to bring Sales Contracts and Service Contracts into Oracle.
  • Designed and Customized Reports in XML Publisher - Orders on Hold Report, Picking Slip Report& Order Status Report and AR Statement Report and AR Invoice Printing Reports and List of Available Sales Contracts, Order Status Report and Backlog Orders Report.
  • Developed Alerts, OAF customizations and Personalization for various business requirements.
  • Developed PL-SQL Packages for various requirements.
  • Developed ad hoc reports: PO Expiration report, On hand demand report Revenue by New item -Detail Report, backlog detail by salesperson, backlog summary by salesperson, backlog schedule by month by customer.
  • Customized the DW History Form: The logic for generating the previous year details for the present year input has been incorporated. For e.g. once the client details for the year 2004 have been entered the client details for year 2003 will be displayed.
  • Created new users and administered their privileges, permissions and security.
  • Developed a package for handling financial, fiscal year, KMART, WALMART and SOUNDSCAN data for HDW (Hand leman Data warehouse).
  • Automation of Reports: Developed Reports for collecting statistics for the billing cycle were incorporated as Concurrent Requests and Discoverer Reports. The reports were used to display statistics about the billing cycle like failed invoices, incorrect counter readings, prorated metrics and pre-validation statistics, report outputs were migrated to middleware using automated FTP program.
  • Developed customs programs to import data into data warehouse.
  • Developed Discoverer Reports for users’ ad-hoc query requests- Order Status Report, Backlog Orders Report and OM to AR Status Report, Revenue by Salesrep report.
  • Developed AR Invoice Report using XML Publisher. Created Invoice Printing Solution for Teradyne’s branches around the world for 11 countries using XML Publisher.
  • Prepared Test Scripts for various scenarios. Conducted CRP at various levels with different groups of End Users from each Lines of Business.
  • This is done so that the present inventory items under the existing Legal Entity can be moved to a new Legal entity.
  • Customized Oracle Work Flow for sending email to sales reps for the sales orders that are backordered
  • Involved in Customization of Reports - Purchase Summary Report, Purchase Requisition Summary Report and Pick Slip Report.
  • Several Custom Discoverer Reports were created according to user needs- Paid invoices by Cost Center report, On hand demand for 12 months report, Min Max Quantity Report.

Hire Now