We provide IT Staff Augmentation Services!

Techno - Functional Consultant Resume

Groton, CT

SUMMARY:

  • Over Twenty years of IT experience as System - Business Analyst of software applications. Currently has active Secret clearance. Over Eighteen years of experience in Oracle Applications E-Business suite (R12.x, 11 i, 11.x and 10.7) as Techno Functional consultant - General Ledger, Oracle Payables, Oracle Receivables, Oracle Assets, Project Costing, Oracle Purchasing, Cash Management, Inventory, Service Contracts, Installed Base, Order Management, etc.. Over Eight years of combined Public Sector / Federal Oracle EBS experience.
  • Involved in all aspects of system life cycle.
  • Expertise in implementation, upgrade and maintenance and design of Forms, Reports, Interface, Conversion and Enhancement) components.
  • Involved in GAP analysis, design, defining and implementing business rules.
  • Design architecture of custom applications and its integration with Oracle E-Business Suite.
  • Involved in support of business processes post implementation of ERP, CRM and MFG suite.
  • Responsible for Corporate Consolidation, Translation and Revaluation processes.
  • Team member for implementation and support of Global Implementations, which includes MOAC / Multi-Org and Multi-Language installations.
  • Worked with Clients in business process review, analysis, Business Process Reengineering and Automation for their business processes.
  • Lead support and development team for worldwide support, which involved direct interactions with different end user communities and off-shore teams.
  • Excellent inter-personal and trouble shooting skills.
  • Team player outlook with proven record to meet business goals within allotted time and budget.
  • Ability to interact and communicate with clarity at all level of organization.
  • Ability to work on multiple projects in fast pace environment and quickly learn new relevant technologies as per client’s need.

ORACLE APPLICATIO-NS EXPERTISE:

  • Over 19 years of Oracle E-Business Suite experience.
  • Expertise in multiple Implementation and upgrade of Oracle E-Business Suite (R12, 11i).
  • Support Oracle E-Business Suite (R12.x, 11i, 11, 10.7)
  • General Ledger
  • Oracle Purchasing
  • Oracle Receivables
  • Oracle Payables
  • Oracle Assets
  • Enterprise Asset Management (EAM)
  • Oracle Projects
  • Cash Management
  • Inventory
  • Telesales
  • HRMS
  • Oracle Federal Financials / Public Sector Fin.
  • Oracle Order Management
  • Installed Base
  • Oracle Service
  • Oracle Workflow and Alerts
  • System Administration
  • Application Object Library
  • PVCS / Starteam (Code Version Control Tool)
  • Kintana / STAT (Migration Tool) / OATS / GIT
  • BI Publisher (XML Publisher)

CONSULTING SKILLS:

  • Global Implementation team member
  • Analysis & Design
  • Implementation Expertise
  • Business Requirement Gathering
  • Techno - Functional Team Lead
  • Third party integration with Oracle EBS
  • Standardization for SDLC
  • Project Management skills
  • Expertise in FRICEW (Forms, Reports, Interface, Conversion, Enhancement, Workflow) components
  • Business Process Automation
  • Organization Skills
  • Communication Skills
  • Implementation Methodologies (Oracle AIM, OUM)
  • Visio, Oracle AIM, Microsoft Project, Microsoft Excel, Microsoft Word

PROFESSIONAL EXPERIENCE:

Confidential, Groton, CT

Techno - Functional Consultant

Tools: Linux Shell Script, Oracle Developer Suite 10g (Oracle Forms / Oracle Reports), SQL*PLUS, PL/SQL, SQL*Developer, BI Publisher, FNDLOAD

Responsibilities:

  • Work closely with business team, DBA team and cross functional teams providing technical subject matter expertise to accomplish business goals. Provide technical and / or functional resolution.
  • Worked as backup team lead as needed for team of 9 technical and DBA experts.
  • Initiated and work closely with Architecture team to review, standardize and set documents and coding standards. Coordinate with development team new coding standards to be in effect for future codes.
  • Review AN100 and identify any gaps for technical team for Project Contracts conversion, Projects Interface, custom form for escalation, bill holds report, etc.
  • Design and develop DS140 for Project Contracts conversion, Projects Interface, custom form for escalation, bill holds report, etc.
  • Design and develop Project Escalation custom forms as per AN100 and DS140 documents using Oracle EBS R12 standards.
  • Design and develop code for Project Contracts conversion using custom and standard Oracle API.
  • Design and develop code for Projects Interface using custom code and standard PRC: Transaction Import process
  • Design and develop bill holds report for expenditure items using Oracle Reports and BI templates.
  • Support CRP2, integration testing, UAT and final go-live.
  • Take over components developed by implementation team. Responsible for these components as other team members have rolled off this project.
  • Providing post go-live support for phase 1.
  • Develop deferred custom reports, forms, interface, etc. post go-live.
  • Fix bug and modify existing RICEW objects as per additional business requirements identified post go-live.
  • Ensuring custom codes are as per R12.2.4 / R12.2.6 standards, compliant with patching cycles.
  • Implement Oracle EBS logging framework in custom code.
  • Code review and rewrite for performance tuning bringing the run time from more than 12 hours to less than 2 hours.
  • Review upgrade consideration for R12.2.6 upgrade.
  • Implement phase 2 (SCM) in techno functional capacity. Phase 2 is in initial phase.

Confidential, Groton, CT

Techno - Functional Consultant

Tools: Linux Shell Script, Oracle Developer Suite 10g (Oracle Forms / Oracle Reports), SQL*PLUS, PL/SQL, SQL*Developer, BI Publisher, FNDLOAD

Responsibilities:

  • Work closely with cross functional team and provide technical subject matter expertise identifying gaps in business processes and providing technical and / or functional resolutions.
  • Review AN100 and identify any gaps for technical team for Contracts conversion, Projects Billing customizations.
  • Design and develop DS140 for custom Projects Billing custom forms, customer conversion, etc.
  • Design and develop Project Billing custom forms as per AN100 and DS140 documents and Oracle EBS R12 standards.
  • Team member to develop document standards.
  • Core team member of team conceptualizing and developing generic conversion tool for another client.
  • Designing and developing customer, sites and contacts conversion.

Confidential, Sacramento, CA

Techno - Functional consultant

Tools: Linux Shell Script, Oracle Developer Suite 10g (Oracle Forms / Oracle Reports), SQL*PLUS, PL/SQL, SQL*Developer, Workflow, BI Publisher, FNDLOAD

Responsibilities:

  • Working closely with EVMS expert and generate report and data extract from Project billing and costing modules. Provide technical subject matter expertise in reconciling data between legacy system and Oracle EBS.
  • Review and analyze this data and identify gaps within the system that would potentially cause a DCAA audit failure. Present the findings to the business owner
  • Modify report as necessary per business owners request to include additional data in extract that would help mitigate audit issues.
  • Successfully completed data extract as required by business owners prior to DCAA audit.
  • Review and identify gaps in business processes and control that would potentially cause concern during SOX audit.
  • Assisted in reviewing control processes to be SOX compliance.
  • Review and prepare requirement documents, technical documents, implementation and installation documents, test script documents and peer review documents.
  • Lead and mentor the EAM, BOM and WIP test team to ensure that the test scripts are SOX compliant for the upcoming EBS R12 go-live integration of the merged company with the existing EBS R12instance. Identify and fix gaps that would potentially cause SOX audit failure.
  • Set documentation standards to mitigate any potential audit issue.

Confidential, Reston, VA

Techno - Functional Analyst

Tools: Linux Shell Script, Oracle Developer Suite 10g (Oracle Forms / Oracle Reports), Forms6 i, Reports6 i, SQL*PLUS, PL/SQL, SQL*Developer, Workflow, TOAD, BI Publisher

Responsibilities:

  • Working closely with business providing technical subject matter expertise in identifying valid customers eligible for conversion from 11i to R12. Prepare MD50 and maintain track of various change requests over the course of implementation.
  • Design, develop and test 11i customer data extraction process. Complete MD50 / MD70 documentation for the process.
  • Design, develop and test MOAC compliant R12 customer conversion process using 11i extracted data. Used TCA APIs to create all customer accounts related components. Complete MD50 / MD70 documentation for the process.
  • Working closely with business to identify valid open invoices, on-account receipts and unapplied receipts for conversion. Review MD50 and maintain track of various change requests.
  • Design, develop and test 11i open invoices, on-account receipts and unapplied receipts data extraction processes. Complete MD50 / MD70 documentation for these processes.
  • Design, develop and test MOAC compliant R12 open invoices, on-account receipts and unapplied receipts conversion processes. Complete MD50 / MD70 documentation for these processes.
  • Working closely with business to identify valid assets and tax books eligible for conversion from 11i to R12. Review MD50 and maintain track of various change request.
  • Design, develop and test 11i assets and tax books data extraction processes. Complete MD50 / MD70 documentation for these processes.
  • Design, develop and test R12 assets and tax books conversion processes. Complete MD50 / MD70 documentation for these processes.
  • Design, develop, test and document various custom reports using BI Publisher / Reports10g. Used bursting feature for some of these reports.
  • Working with business to identify and plan for recommended patch collection (RPC) patching schedule for Financials modules.
  • Oracle forms personalization for CLE Swiss add-on localizations and Cash Management forms.
  • Identify and configure patch wizard utility and register flagged file tools. Pre-patch application analysis using patch wizard utility.
  • CRP1, CRP2 and UAT issue management team member.
  • Design and develop custom reports in GL and AR post go-live and prepare its documentation.
  • Design, develop and test Fixed Assets tax lines interface post go-live. Complete MD50 / MD70 documentation for these processes.
  • Modify custom GL form to activate DFF.
  • Modify custom workflow to include additional details for custom GL form.

Confidential, Detroit, MI.

Techno - Functional Analyst

Tools: UNIX Shell Script, Oracle Developer Suite 10g (Oracle Forms / Oracle Reports), Forms6 i, Reports6 i, SQL*PLUS, PL/SQL, TOAD, SQL*Developer, Workflow

Responsibilities:

  • Review impact on existing 11i customizations for R12 upgrade.
  • Modify existing 11i customizations to seamlessly work with R12.
  • Successfully implemented procurement RUP12.
  • Reviewed and recommended creating Receivables setup for Fire Mobile Eyes project to streamline revenue recording in Oracle E-Business Suite.
  • Modify Workflow for Purchasing and Requisition Account Generator.
  • Initiated, designed, develop and tested Fire Mobile Eyes to DRMS Receivables interface integration with Oracle EBS. Used standard Oracle interface processes.
  • Reviewed, designed and developed Functional and Technical Design specification documents for Fire Mobile Eyes interface project.
  • Successfully Setup and implemented Receivables lockbox processing. Trained business user to accomplish business goals in successfully using Lockbox processes.
  • Design and developed third party interface (PPS) for Payables module.
  • Reviewed, design and developed functional and technical design document for Oracle HRMS UIA customization. Configure, Setup and tested HRMS for UIA.
  • Co-ordinated with Purchasing Department, ITS department and Oracle Support resolving high priority Purchasing issues related to encumbrance accounting and other business critical issues as part of Purchasing - Oracle Insight initiative.
  • Reviewed, designed and developed Functional and Technical Design Specification Documents for Oracle Purchasing, Receivables, Payables, HRMS, etc. customizations.
  • Troubleshoot and fix issues in Oracle Purchasing customizations for Contract History POs, outbound interfaces from Oracle E-Business Suite, etc.
  • Worked independently with Oracle Support (Metalink) and Business Support Specialist to successfully resolve issues and close TARs for General Ledger, Oracle Assets, Purchasing, Grants / Projects, Receivables, Payables, HR, etc.
  • Establish standards and co-ordinate with bank’s customer relations and transmission team for file transmissions from and to Confidential to various banks.
  • Designed, developed and tested custom VBScripts script for encrypting or decrypting and transmitting Confidential ’s files to / from vendors.
  • Involved in reviewing mapping document for HRMS implementation with SMEs.
  • End-To-End Application Testing Strategies (Unit, System Integration, Quality Assurance, User Acceptance Test, Sign-Off).
  • Assist COD employees to design and develop technical aspects of new customizations for Oracle HRMS.
  • Conducted SQL and Query Builder for select group of Confidential ’s employees.

Confidential, Parsippany, NJ

Techno - Functional Analyst

Tools: UNIX Shell Script, Forms6 i, Reports6 i, SQL*PLUS, PL/SQL, TOAD, Applimation.

Responsibilities:

  • Involved in creating project plan for identifying technical and functional tasks and resources.
  • Involved in Configuration Management and setting up instances based on BR100 baselines.
  • Configuration setup for Oracle Project Costing and Accounts Payables (new Operating Unit).
  • Designed and developed Functional and Technical Design Specification Documents for Oracle Project Costing module. Design and develop customization reversing the cost of overtime charged on a project by employees.
  • Develop & Document possible business scenarios and creating Crude Matrix for capturing different combinations of business rules.
  • Configuration setup for Oracle Assets for new corporate book to test an alternative to proposed solution.
  • Interface design and development of Fixed Assets for the new corporate book.
  • Designed and develop customization to identify employees in HR base tables and link it with TCA tables.
  • Design and develop approach to identify and filter Travelport data from Confidential instance.
  • Configured Applimation to identify Travelport related data from the Confidential instance for General Ledger, Accounts Payables, Accounts Receivables and Cash Management modules. Data in Oracle Assets and Oracle Projects were handled separately. Verify data integrity post Applimation process in new Travelport instance.
  • Design and developed data cleanup script to identify and flag data in shared operating units and set of books.
  • Addressed Security Access issues for OOD for custom objects. Designed and develop scripts to grant access to custom objects as per OOD’s standards.
  • Worked with teams in Australia, UK and Hong Kong.
  • Involved in developing Testing strategy capturing different business scenarios from Subject Matter Experts (SMEs).
  • Involved in providing strategic solutions for phased implementation.
  • Extensively involved in User interaction and capturing requirements.
  • Involved in documentation of Functional Specifications, Technical Design of various custom extensions including code review and conducting Walkthroughs and Final Signoffs.
  • Extensively involved in cross-functional teams in providing efficient solutions.
  • Involved in meetings with end user both offsite and on site. Interactively participated throughout the project, debugged, tested, implemented and documented all the tasks assigned

Confidential, Orrville, OH.

Techno - Functional Analyst

Tools: UNIX Shell Script, Forms6 i, Reports6 i, SQL*PLUS, PL/SQL, TOAD, FNDLOAD utility, Discoverer Admin / Desktop Edition, Kintana, PVCS.

Responsibilities:

  • Design and develop approach to upgrade custom forms, reports, package, UNIX scripts, etc.
  • Designed, developed and deploy custom reports and forms.
  • Designed and developed new customization to interface data from VISTA, IMI to Oracle E-Business Suite.
  • Troubleshoot and resolve issues in custom reports. Many reports working correctly in 11.5.9 failed in 11.5.10. The cause was the multi-lingual setup in 11.5.10. Modified the reports as per the customization standards.
  • Designed and developed database triggers in VISTA instance for auditing promotions data. This was part of Promotion Audit process integrating VISTA / IMI and Oracle E-Business Suite.
  • Involved in developing testing strategy capturing different business scenarios. Conducting Walkthroughs and Final Signoffs.
  • Developed Functional and Technical Design documents for customization.
  • Involved in Database architecture and process handling and implementation of coding standards.

Confidential, Terre Haute, IN.

Team Lead

Tools: UNIX Shell Script, Forms6 i, Reports6 i, SQL*PLUS, PL/SQL, TOAD, FNDLOAD utility, Discoverer Admin / Desktop Edition.

Responsibilities:

  • Application Configuration, setup requirements for 11i and plan for migration.
  • Data Model transformation & Migration for 11i.
  • CRP Setup, testing strategies & test scenarios development, organize QA testing.
  • Migration to 11i, QA Testing for 11i, Writing Test Script, Testing and verification of results with the existing application results.
  • Assessment of workloads of customization.
  • Managed TAR (SR) with Oracle Metalink Support. Hosted daily scheduled call with Oracle for expediting resolutions and priorities for SRs.
  • Lead team in conducting Working Sessions and make business decisions. Involved in providing solutions to meet requirements from business user community.
  • Conduct Status Meetings, obtain Status reports and include updates on Project plans.
  • Trained business users to use workflow processes - Approval / Rejection, notifications, etc.
  • Meeting with user departments. Resolving the problems in the applications area, defining new requirements.
  • Developed Functional and Technical Design documents for customization.
  • Involved in Technical Design of various custom extensions including code review.
  • Coding, Develop Test Strategy, Unit Testing, System Testing and identifying system readiness criteria.

Confidential, Dallas, TX.

Techno Functional Consultant

Tools: UNIX Shell Script, Forms6 i, Reports6 i, SQL*PLUS, PL/SQL, TOAD, FNDLOAD utility.

Responsibilities:

  • Work closely with business teams providing technical subject matter expertise and leadership to accomplish business goals.
  • Conduct meetings with various financial department heads to discuss conversion and implementation strategies.
  • Documenting BRD (Business Requirement Document), Functional (MD60) & Technical (MD70) Specifications.
  • Involved in Technical Design of various conversions from legacy / Oracle database to Oracle E-Business Suite.
  • Design, Develop and Deploy custom Forms for the Payables Transactions conversion. This conversion was to generate invoices based on the credit card transaction file received from a bank.
  • Activated descriptive flexfield on value set to identify operating unit for a company code. This was used only for Payables Transactions conversion.
  • Created BR100 document and configured Oracle Assets.
  • Designed Interface to Oracle Assets for creating Assets from flat files generated from the legacy Fixed Assets system. Used mix of SQL*LOADER and PL/SQL for loading and validating legacy data.
  • Review and Correct Oracle Payables and Cash Management setups and configuration.
  • Designed customization to create Vendor Sites based on existing data but for a new operating unit.
  • Designed Interface to Cash Management for importing bank statements for reconciliation.
  • End-To-End Application Testing Strategies (Unit, System Integration, Quality Assurance, User Acceptance Test).

Confidential, Richfield, OH.

Techno Functional Consultant / Lead

Tools: UNIX Shell Script, Reports6i, SQL*PLUS, PL/SQL, Discoverer (Admin and User Edition), TOAD, FNDLOAD utility.

Responsibilities:

  • Resolving Open issues in applying business rules with user community and other Cross Product teams.
  • Creating documentation standards.
  • Design Change Management System comprising of review and sign-offs at various levels.
  • Documenting BRD (Business Requirement Document), Functional (MD60) & Technical (MD70) Specifications.
  • Design, Develop and Deploy various custom Reports involving data from multiple modules.
  • Design various custom lookups giving control to IT personnel to manage variables in custom reports instead of hard coding.
  • Gather requirements and created functional and technical specs for off-shore team.
  • Unit tested and implemented UAT strategies for off-shore developed customizations.
  • Design and develop outbound interface data files and reports to ADP.
  • Design and develop customization to automate contract renewal reminder process. The automation reduced process times from weeks to hours. The process created custom reports that were integrated with OPTIO to print the desired letters.
  • Design and Register discoverer views using Discoverer Admin. Design and Develop Discoverer reports.
  • Introduce use of FNDLOAD utility to increase productivity and reduce migration time for customizations.

Hire Now