We provide IT Staff Augmentation Services!

Solutions Architect Resume

4.00/5 (Submit Your Rating)

SUMMARY:

  • 19+ years of experience related to Information Technology and 12+ years of experience as and Oracle functional consultant.
  • Completed more than 9 live Oracle Applications full life cycle implementation projects.
  • Strong noledge and experience (hands - on) in Procure to Pay, Order to Cash and Financials business processes/flows, specifically R11i and R12 (12.0.6 and 12.1.x) including 12.1.3 (latest release) and 12.2.4
  • Project Manager for a complex Global implementation of Oracle Financials R11.5.9
  • Project Lead for more than 6 complex Procure to Pay implementation of Oracle Financials R11.5.x and R12 (up to and including latest features in R12.1.x)
  • Experienced in creating multiple “master data management” (MDM) based design involving Customer and Supplier (Data) Hub and Supplier Lifecycle Management in R12 (R12.1.3) of Oracle Applications) and Supplier Scheduling.
  • Multiple (3) full SDLC R12 upgrade based projects from R11.5.10.2 (R11.5x)
  • Oracle Projects (Foundation, Costing, Billing etc.) experience and lead in 3 projects, which includes 2 in R12
  • Experience included 5 Inventory implementations, 1 in Accounts Receivables, Account Payables, 2 in Order Management and Warehouse Shipping, and 1 in CMRO.
  • Multi-project familiarity wif Europe, Asia localizations
  • Multiple projects involving Source to Pay track, ranging from simple local procurement based sourcing strategies to multi-geography based sourcing originating from teh US and spanning across teh global wif cross-OU global approvals
  • Latin America, APAC and EMEA specifically localizations for countries like Peru Argentina, UK, NL, Portugal, Germany etc. (projects: Staples, Hanover and OXY)
  • 8-9 comprehensive full life-cycle Procure to Pay projects in R11.5.9, 11.5.10/11.5.10.2 and R12 (12.0.6/12.1.1/12.1.2 )
  • 8+ year of handling of complex design of Supplier Qualification, Compliance and Performance and Conformance.
  • 10 years or more of experience in analyzing procurement, contract and vendor management process over teh tenure of teh 8+ Procure to Pay projects.
  • 10 years or more of Business Process Analysis/Re-engineering (BPA/BPR) experience in procurement processes.
  • Project Manager for a complex Global implementation of Oracle Financials R11.5.9 at Staples
  • Excellent communication, team building and team leader skills.
  • Excellent documentation skills (more than 14 years) supplemented by years of producing Functional and Technical documents to support project needs.

TECHNICAL SKILLS:

Advanced Level experience and noledge in: Purchasing, Sourcing, iProcurement, iSupplier Portal, Procurement Contracts and Services Procurement integrated wif Order Management, Inventory, and Projects

Strong experience and noledge in: AR,INV, PO, AP, OM, Shipping, BOM, WIP and MRO

Extensive noledge in teh modules: GL, AP, AR, FA, CE and Projects Costing (integration wif iProcurement and iExpense)

Oracle Application Releases: 11.5.10 and 12.0 (12.0.6 and 12.1.x)

Tools: Discoverer, DBI, Toad, OBM, Metalink/ My OracleSupport

Languages: Complex PL/SQL and thorough noledge of Programming Constructs

Methodologies & Documents: Oracle’s Applications Implementation Methodology (AIM), Oracle documents including RD020, BP080, BR100, BR110, BR120, MD050, BF125, BF015, CV050 BF120, T040 and UAT.

Productivity Applications: MS Office, MS Project.

PROFESSIONAL EXPERIENCE:

Confidential

Solutions Architect

Responsibilities:

  • Teh scope for teh assessment entailed complex projects centric (Oracle Projects, Billing and Costing) integration considerations. AME design footprint outlay involved extremely complex design involving Purchase Requisition Approval, new purchasing capabilities using AME and Invoice Approvals. Suggested 23 major improvements involving New Features including and upto R12.2.4 and 28 major business process improvements in teh core overall design of teh comprehensive procure to pay solution. dis involved 53 countries and 74 operating units etc.
  • Design entailed extensive empowerment of buyers involving use of MOAC and parallel Approvals capabilities. Approach for teh upgrade from 12. 0.6 involved Quick Wins wifin teh current production platform upgrade time solutioning and post upgrade. R12 localizations were suggested for 32 of teh 53 countries as art of teh upgrade solution footprint.

Confidential

Lead and Analyst

Responsibilities:

  • OBIEE integration design aspects wif R12 EBS solutions in R12.0.6. Specific design aspects concentrated around vendor performance, vendor volume analysis et al
  • Requisition to Receipt for teh Procurement piece of teh design … incorporating key client’s Supply Chain product category based Content Zones, punch-out to OfficeMax and use of extensive ASL based sourcing for optimal Spend Management using “preferred Suppliers”, exhaustive Hierarchy Approval management process et al.
  • Quantity-based price tiers functionality which offers different unit prices for different quantity ranges. dis allows buyers to suggest tier structure and thus provides flexibility to suppliers to either respond to tier structure defined by buyers or define their own structure. All in all, dis new feature allows to where prices are selected from teh appropriate price tier, use of optimization to find teh best scenario and create purchase orders wif teh ed price tier price. iSupplier and Procurement Contracts design involving 750 contracts wif about 75-80 global contracts driven approach design
  • Supplier Incentives, a feature dat allow suppliers to provide bonuses or rebates to buyers to transact or increase teh spend amount wif them
  • Supplier Life Cycle management - involving custom design to in corporate aspects of Supplier Performance, Supplier Conformance and Supplier surveys etc.
  • Teh final decision will include teh supplier incentives including fixed incentives which would represent signing or transition bonuses for new suppliers, and also use of rebate tiers which would apply a different rebate percentage based on level of spend for existing suppliers
  • Additional features and enhancement in teh Optimization process like
  • Constraint Priority
  • Indicates teh importance of different constraints
  • Determines constraints dat can be relaxed when no solution can be found wif all constraints satisfied
  • Cost of Constraints
  • Measures teh cost of imposing a business constraint
  • Calculates teh difference in amount when teh constraint is removed
  • Scenario Analysis
  • Provides side-by-side comparison of optimization results from various scenarios
  • Displays detailed breakdown of amount and savings by supplier and by line

Confidential

Functional Analyst

Responsibilities:

  • Extensive and full use of teh new Professional Buyer’s Workbench, including Supplier authoring functionality
  • Advanced content management, including Content Zones
  • Catalog Bulk Load and Maintenance
  • Comprehensive end-to-end execution of Procure to Pay business flow (search an item à create a req à generate receipt in iProc à Approve and Pay Invoices ….and also view teh transactions in iSupplier Portal)
  • Oracle Sourcing where use of Competitive Bids and Direct Negotiation was implemented, Medium to Complex levels for handling of 2 Stage RFQs wif both Technical and Commercial evaluation process for sourcing of specific categories of raw materials. Handled all setups and configurations, being teh only consultant for dis role.
  • Multi-geography based sourcing design for sourcing negotiation/events originating in teh US and spanning across multiple OU wif multi-geography approval setups
  • Complex design involving compliance and adherence to “ethical business conduct” policies. iSupplier Portal core features - New supplier registration process and also creation of a Supplier User including functionality of Supplier Managed User maintenance.
  • Services Procurement - implemented sourcing of services through iProcurement (based of off service categories like Fixed Price Services (Facilities Maintenance), and Resource Based Services (Contingent Labor)).
  • Order Management Setup, Configuration an Enablement - performed necessary setups to facilitate orders in an ASCP model
  • From a “business flow” perspective at least teh Order to Cash and Procure to Pay (included items, goods and services) flows were executed end-to-end.

Confidential

Functional Project Lead

Responsibilities:

  • Tested at least 15 modules and participated in teh Unit, Business and Integration testing of teh following modules. Teh Integration testing flow starts wif teh creation of a Quote from a lead to teh generation of a Sales Order to Invoicing teh customer and finally teh billing solution.
  • Tested comprehensively working wif teh development and teh functional team 17 Interfaces (inbound, outbound and bi-directional) as part of teh Finance GO-LIVE. Planned teh story-board for teh Finance testing …leading to creation of OKC & OKS (Core and Service Contracts) of key areas of concern for teh UAT. Teh UAT for Finance was conducted and completed in a record time of 4 business days. Subsequent testing was done in context of teh different component of teh middle-ware (SOA specific MAEF, BAM Gateway and BPEL). Assisted in teh re-validation of key interfaces as mentioned above.
  • Successfully wrapped up teh Finance UAT to teh satisfaction of MCS users and obtained sign-off. Comprehensively tested 45-60 reports as part of UAT testing... Conducted issues and defect review meeting wif Finance GO LIVE committee. On-time successful GO-LIVE of V2R Finance on time on 1st of August 2007.
  • Setup and Configuration of Order Management: Mandatory and option setups to facilitate Sales Order customizations and Blanket Sales Agreements as also Back to Back Orders and Drop Ship processing. Customization of Sales Orders and Blankets, Project Task changes for Booked Orders. Processing for Multiple and Partial Payments, Catch Weights for Discrete Inventory and use of Pricing and Availability functionality. Additional setups to accommodate Advanced Pricing model in Order Management.
  • Modules involved are GL, AP, FA, CE, AR, OM, PO, EAM, iProcurement, iSupplier Portal, Oracle Sourcing, iSupplier Portal. Inventory, Advanced Pricing, Order Management, Projects (Costing and Billing), Contracts (sales, core and service) Oracle Apps version is 11.5.10.2, Oracle HTML Quoting et al
  • Involved in/ conducted 3 rounds of Business Validation of teh developed solution, 3 rounds of Integration testing and for Finance User Acceptance Testing.
  • Business flows to which teh entire implementation conformed to be at least teh following: Lead to Sell, Quote to Order, Plan to Inventory, Order to Cash, Procure to Pay and Financials to Reporting.

Confidential

IT Manager

Responsibilities:

  • Prepared and presented test results by providing metrics and graphs to teh central testing committee, from teh innumerous rounds of testing
  • Delivered high standards of testing even wif stringent timelines resulting in SMEs satisfaction. Coordinated test efforts including resource allocation and planning Responsible for volume testing to ensure proper load balancing of teh system. Was a key Command Center player for ensuring Operations Readiness prior to go-live for teh domestic section of implementation, termed Phase II. Improved 2 major business processes dat halped ensure timely monthly billing to teh tune of 22 million dollars. Worked on teh design, testing and implementation of 6 key business process enhancements through Oracle Workflow. Reviewed 37 key Change requests dat halped lower teh cost of implemented teh same by over half a million dollars. Laid down coding and development standards in terms of key packages and CUSTOM.pll enhancements for certain customization of Forms based application extensions.
  • Assisted in teh stand-alone implementation of Oracle 11i HRMS and Advanced Benefits for teh Confidential . Amongst all teh interfaces, report & forms worked on teh following were key, as they had a major effect on teh Domestic go-live effort for Phase II ( Note: these cover practically every aspect of almost all teh 18-19 major applications there were implemented as part of teh big-bang approach on July 7 2003) (Project location: Hanover HQ at Houston, TX):
  • PO Account Generator Workflow Customization
  • Projects Account Generator Workflow Customization
  • Oracle Sourcing - Complex design of sourcing of parts for maintenance of products (Christmas Trees) for optimal use of on-truck and warehouse inventory
  • Oracle Purchasing Approvals design to facilitate speedy acquisition of raw materials so as not to affect repair and maintenance.
  • ADP Payroll Inbound Interface
  • Unit Profit & Loss Project Interfaces:
  • HCCA Interface Depreciation Expense to Projects Specification
  • HCCA Interface Revenue Transaction to Projects Form
  • HCCA Update Project Expenditure Items wif Contract Number Asset Location Exception Report iExpense integration wif Payables
  • IR/ISO for (via internal requisitions) automatic inventory replenishment and fulfillment through internal or external suppliers.
  • OKS Auto Renewal Extension in Oracle Service Contract
  • COGS Workflow Extension in Inventory
  • COGS deferral by extending Oracle line level workflow (Billing Hold).
  • Allow choosing multiple lines to defer/recognize when all lines option is not suitable (e.g. deferring 4 out of 7 lines),
  • Allow posting deferral/reorganization to an open period in teh past - when you use accounting rules teh system uses system date as teh GL date and does not allow changing me
  • PHH Interface Custom design & Build (Fuel surcharges for all company vehicle
  • Revenue Accounts Generator Trigger ( database trigger to derive teh revenue, receivables, freight general ledger accounting flexfield values based on special rules on top of auto accounting rules) (Receivables
  • Contract Billing Date Customization
  • Customized OEOL workflow to accommodate our changes for 'Return To Vendor' functionality. We has introduced a process between 'FulFill' and 'Close Line' activities of 'Lineflow - Generic Ship Only
  • OM to OKS Interface Exception Report Design & Build
  • Asset Location Exception Report
  • Contract Renewal Report for Auto-renewal of Service Contracts
  • Advanced Pricing

Confidential

Technical Manager

Responsibilities:

  • Technical Manager, Oracle Consulting (South Central Industries, Verticals practice of Oracle Consulting)
  • Oracle Applications 11i Upgrade assessment for Williams Energy Services in Tulsa, Oklahoma. Tasks involved (but was not limited to) conducting work-shop sessions for apprising teh Purchasing team on teh functionality changes in teh PO, INV, AP and iProcurement, modules, assessing teh upgrade effort. dis was a two (2) week effort dat could lead to future upgrade opportunities.
  • GL, INV and BOM (Apr - Dec 1999): Created teh GL Journal Entries, Items, Routings and Bill of Materials, Item Categories, Customer Items, Customer Item Cross s, Quantity on Hand and Price List Conversion and Interface Programs at a leading Building Systems Manufacturer in Houston. Created technical documentation for all teh conversions and interfaces mentioned above. Oracle AIM, Oracle Applications 10.7 SC/11.0.3, SUN Solaris 2.5.1 on SUN - 6000. Worked subsequently on teh 11i migration/upgrade plans for PO, INV and AP.
  • Lead teh Oracle Manufacturing 11i upgrade effort as part of teh entire Oracle Applications 11i upgrade efforts (11.0.3 to 11.5.7) for H B Zachary, a major construction company in San Antonio, Texas. dis was a 3.5 month effort dat resulted in timely production. Responsibilities also involved Production server sizing, architecture planning and justifications, Oracle Workflow upgrade (2.5 to 2.6), DBA effort planning and Program Office co-ordination efforts.
  • OM, GL, AP, AR, INV, BOM, PO, iProcurement, Pricing, Costing, EDI, HR, APS: Assumed teh role of technical leader/functional advisor for a large scale 11i Oracle Applications (11.5.6) implementation at SAS Institute World HQ at Carey/Raleigh-Durham, NC. Managed a team of 12 developers (third party consultants) in addition to 7 Oracle technical leads. Despite teh aggressive timelines for teh project, delivered 30 + complex integrations wif third party systems in addition to a set of 30 + workflow enhancements implemented for teh individual modules. Oracle Applications 11i, multi-org, multi-language and multi-currency, RDBMS 8.1.7, Sun Solaris 8, WebMethods, Vertex, TradeSphere, Shareplex, Noetix. As a crucial player worked wif PWC Consulting in teh complete exhaustive testing of teh new application and performed capacity and performance adjustments in teh system for optimal stability.

We'd love your feedback!