We provide IT Staff Augmentation Services!

Solutions Architect, Resume

5.00/5 (Submit Your Rating)

Greater Los Angeles, CA

SUMMARY:

  • Certified Scrum Master,
  • Certified Scrum Product Owner,
  • Certified Oracle Implementation Specialist for Oracle Accounts Payable.
  • Over 19 years of experience wif Oracle Cloud, Oracle EBS, ERP working as Solution Architect and Implementation specialist.
  • ~ 2 years’ experience working on Fusion/Cloud solutions (HCM, Financial Cloud including Finance & Accounting)
  • Specialized in Implementing Oracle Fusion Cloud modules - Financials, Supply Chain, Projects and Analytic reporting using both XML Publisher and OTBI
  • Using D Confidential Integrations wif ADFD me, FBD me, Web Services depending on d Confidential volume.
  • Solution provider for JDeveloper, OAF, Forms, Reports, PL/SQL, Unix shell scripts, OBIEE, Oracle SOA, Spot Fire, Discoverer, XML, system testing.
  • 5 years’ experience working on Oracle OBIEE 11.1.1.x.
  • Solution Architect for Oracle Applications Oracle Cloud, R12.2.x, R12.1.x, R11i
  • Specialization on Oracle Financials Cloud, Oracle SOA, Oracle ADF, Oracle APEX, OBIEE, Oracle Application eBusiness Suites R12.2.x, R12.1.x, 11.5ss.10.2, 11.5.9, 11.5.8, 11.5.7, 11i, 11.0.3/10.7 SC (SC and Char), 10.6, Oracle 10g/9i/8i/8.x/7.x/6.x, PL/SQL 8i, 8.x, 3.x, 2.x, Developer 2000, Forms 11g/10g/6i/5.x/4.5 Reports 10g/6i/3.0/2.5, Workflow 2.0.3/2.5/2.6, JDeveloper 10g/11g, OA Framework, Core Java, JSON, JIIRA
  • Experience debugging and scripting Pro*C and Pro*Cobol.
  • Experience in Project Implementation, Upgrade from 10.7(SC and Char) to Release 11.0.3, Upgrade from Oracle Release 10.7(SC and Char) and Release 11.0.3 to Oracle Application 11i, upgrade from Oracle Applications Release 11.5.10.2 to R12.1. x
  • Experience working on Hyperion Administration 11.2.1.3, Smart View plug-in for Hyperion on Windows environment.
  • Oracle Workflow (2.6.x) Customisation, and & Administration of Oracle Financial Release 12.2,x, 12.1.x, 11i, 11.0.3, 10.7 (SC and Char).
  • Expert level Technical/Functional skills on Order Management, Oracle Shipping, Oracle Payables, Oracle Receivables, Oracle Project Accounting, Oracle Fixed Assets, Oracle Inventory, Oracle Purchasing, Oracle Trading Community Architecture (TCA), Oracle Fixed Assets and Oracle Workflow.
  • Excellent skills working on Oracle JDeveloper. Excellent command over customizations, personalization and extensions of VO, EO and CO’s.
  • Over 6 years’ experience working on Oracle OAF 10g and ADF 11g including ADF BC, D Confidential controls, Faces, Actions, Action Listeners etc.,
  • Expert Level Technical skills in Applications Object Library, Open Interfaces, Conversion and third party interface to Oracle Application.
  • Experience wif Salesforce Lightning (Self-learning)
  • Expert level skills in developing reports, forms using Oracle tools like JDeveloper 10g, Developer 9i, Developer 10g, Developer2000, Developer 6i.
  • Expert level skills in Forms Personalization, XML reports (BI Publisher).
  • Implementation Methodologies like AIM (MD200/MD60/70/BR100/CF250), Agile, and Waterfall.
  • Strong experience wif Project Management tools including JIRA, MS Project, Smart Sheet and other project management tools.
  • Knowledge of performance tuning of the d Confidential base, and utilities like Explain plans, SQL*Loader, Export, Import, UTL File.
  • Extensive experience in Oracle back end objects like D Confidential base Triggers, Stored Procedures, Functions, and Packages using PL/SQL.
  • Having strong Conceptual, Business and Analytical and problem-solving skills.
  • Excellent communications and interpersonal skills.
  • Excellent oral and written communication skills.

TECHNICAL SKILLS:

4GL/RDBMS/TOOLS: Oracle 11g/10g/9i/8x/7x, Oracle ADF, Oracle SOA, OBIEE, JDeveloper 11g/10g, PL/SQL, SQL, Oracle Forms 10g/9i/6i/5.0/4.5/2.3, Oracle Reports 10g/9i/6i/3.0/2.5, SQL*Loader, Export & Import, XML Publisher (BI Publisher), Workflow 2.0.3/2.5/2.6, PVCS, CVS, WinCVS and KINTANA.

DBASE FRONT ENDS: Oracle Forms 10g/9i/6i/5.0/4.5/2.3, Oracle Reports 10g/9i/6i/3.0/2.5, OBIEE, Discoverer, SQL Developer, TOAD, XML.

ORACLE APPLICATION: Oracle Application: HCM & Financials Cloud, R12.2.x, R12.1.X, 11.5.10.2, 11i, 11.0.3, 10.7(SC), 10.6 (Character Based). Oracle Application Modules: Order Management, Oracle Shipping, Customer Support, Oracle Pricing, Oracle Fixed Assets, Oracle Installed Base, Oracle Service Contracts, Oracle Payables, Oracle Payments (new to R12), Oracle General Ledger, Oracle Receivables, Oracle iExpense, iProcurement, iSupplier, Purchasing, Oracle Inventory, Oracle eBTax, Trading Community Architecture (TCA), AOL, Oracle Alerts, Oracle Workflow. Oracle OBIEE, Oracle SOA, Hyperion 11.1.2.4

PROFESSIONAL EXPERIENCE:

Solutions Architect,

Confidential, Greater Los Angeles, CA

Responsibilities:

  • Excellent communication and inter-personal skills.
  • Extensively worked on D Confidential Loader, Spreadsheet Loader, HCM Extracts (Cost Centers, Persons, assignments)
  • Inbound Interfaces/Integrations using FBDi and Web Services for “Core HR” in HCM
  • Load Suppliers, Invoices, GL Balances from on-prem/legacy to Oracle Finance AP/GL Cloud.
  • Implemented Expenses Cloud, part of Oracle Finance Cloud for Accounts Payables.
  • Develop OTBI, XML/BI Publisher reports in Oracle cloud for various finance modules.
  • Modify/Customize approval workflows using BPEL and SOA middleware/adapters for various cloud modules.
  • Built custom webpages using Oracle APEX for custom applications
  • Oracle Cloud solution provider for Finance (AP). Working closely wif the external vendor to provide existing business practice to be able to understand and implement the solution into the cloud.
  • Manage and guide the team to support existing Oracle EBS Suite 12.2.x
  • Closely work wif the business to understand the requirements to be able to apply the requirements into cloud environment wif strong skills to provide feasible and acceptable solutions.
  • Oracle Discoverer administration and Desktop versions to migrate to Oracle BIEE.
  • Create Dashboard pages, prompts . Build Answers, Filters, Prompts using Oracle BIEE.
  • Develop custom self-service pages using OA Framework.
  • Customization's to self-service pages related to Oracle Payable, Payments, iProcurement, iSupplier, Purchasing and many other P2P cycle related modules
  • Strong PL/SQL skills including the usage of Oracle API's for Payable, Projects, Fixed Assets, TCA Architecture, Receivables, Purchasing and other modules.
  • Development and support of Interfaces into Oracle Global HR, Performance Management, and Talent acquisition modules.
  • Excellent command over GRC Controls/Preventive Control Manager, forms personalization, Custom.pll and reporting tools like XML Publisher, Reports 6i, Spotfire, SSRS and others.
  • Custom forms for both d Confidential entry of details in custom tables.
  • XML publisher reports and XML publisher bursting feature to send automated emails to reduce manual work.

Techno-Functional Architect,

Confidential, Pasadena, Greater Los Angeles, CA

Responsibilities:

  • Project Manager for upgrade of current system from Oracle Applications 11.5.10.2 to R12.1.3
  • Work wif the business to understand customizations to self-service pages related to Oracle Quoting, Oracle Service contracts and installed base
  • Develop custom self-service pages using OA Framework.
  • Strong PL/SQL skills including the usage of Oracle API's for Order Management, Shipping, Service Contracts, TCA Architecture, Quoting, Receivables, Purchasing and Payables modules
  • Functional inputs for quick resolution of issues related to Purchasing, Payables and Oracle Payments (new to R12).
  • Forms Personalization for customizations that may be required to be handled at the form level and not the CUSTOM.pll level.
  • Custom forms for both d Confidential entry of details in custom tables.
  • Strong skills to provide feasible and acceptable solutions.
  • Great team player and excellent communication and inter-personal skills.
  • XML publisher reports and XML publisher bursting feature to send automated emails to reduce manual work.
  • Develop multiple XML publisher reports for Purchasing, Order Management, Shipping, Quoting, Payables and Receivables modules including
  • Pack Slip report
  • Pick slip report
  • Purchase Order printing in PDF format using XML
  • Invoice printing and XML Bursting.
Techno Functional Lead,

Confidential, Las Vegas, Nevada

Responsibilities:

  • Upgrade of current system from Oracle Applications 11.5.10.2 to R12.1.2
  • Develop custom self-service pages using OA Framework.
  • Custom coding on Self-Service Pages using OA Framework/JDeveloper 10g. dis includes the below
  • Develop a web-page wif information of all the suppliers and other key information which calls an Oracle seeded web-page internally show and update the suppler/vendor records accordingly
  • Extensions to View Objects to show only suppliers information to specific user group. For example: do-not show the supplier information to contractors who are working in an organization.
  • Workflows execution from custom web-based pages developed for iSuppliers module. Call workflow to internally call the workflow related to the PO's and payables depending upon the action used.
  • Customize and personalize existing pages for specific business needs to HRMS .
  • Key-setups done for Check Printing (Oracle Payments Module).
  • Key setups were done for setting up the check printing in Oracle payments module. dis includes the Payment documents, Payment templates and other key setups.
  • Customizations using JDeveloper 10g and OA Framework.
  • SPEL usage for dynamically displaying the details based on the d Confidential selected. dis includes partial page rendering techniques used for showing the details based on the d Confidential selected.
  • Extensions and new developments in HRMS using OA Framework.
  • Develop new reports, custom forms based on the requirements raised by the business.
  • Support for Post - Production issues raised by the business on a regular basis.
  • Feasibility study for the requests raised by the business.
  • Developed several reports using XML (BI Publisher)
  • Developed Expected Receipts report to use bar codes using XML.
  • Define fonts, font mappings and other key setups for use of bar-codes in XML
  • Developed Pick Slip Report using Bar codes using oracle provided java classes to display the bar codes dynamically on the report depending upon the d Confidential .
  • Developed custom PDF Report using Oracle BI Publisher. dis has halped the organization to reduce their costs of paper by automatically printing the PDF's and sending email to the vendors by using an Oracle provided feature called XML Bursting.

Technical Lead,

Confidential, Kansas City, Kansas

Responsibilities:

  • Developed Conversions for Order Management, Receivables, Payables, and Customers.
  • Import sales orders from legacy system to create sales orders in Oracle order management module
  • Interface the sales orders wif Oracle Receivables which would internally call the Auto Invoice process to create the receivable invoice for the specific sales order line.
  • Created interface for Payables, using the interface tables process and run the concurrent programs to create the suppliers, supplier sites, supplier contacts as entered by the users in the legacy system
  • Developed Interfaces from third party systems for AR Invoices, AP Invoices from third party systems like the GECARS (External Customers) and IBS (Internal Billing Systems)
  • Parties import (parties included only customers in the 11i version of Oracle applications)
  • Party sties import, Account sites, account uses imports using the HZ API provided by Oracle.
  • Developed interface from purchasing to Payables to Fixed assets module for inventory and expense items using the FA Mass addition interface.
  • Workflow Customization for Order Management and Purchasing.
  • Customizations include closing the sales order once all the order lines are closed. Oracle standard functionality would wait for the month-end process and tan close the sales order automatically during month-end.
  • Developed multiple reports and forms using Oracle forms 6i, Reports 6i, BI Publisher, Discoverer etc.,
  • Support for Post - Production activities for 3 months.
  • Creating and maintaining AIM Methodology Documents (MD050, MD070 etc,)

Technical Developer,

Confidential, Rockville,MD

Responsibilities:

  • Supporting issues related to Payables, General Ledger, Receivables.
  • Developed conversions related to Payables, General Ledger,
  • D Confidential Conversions related to Customers, Items
  • Developed and Supporting interfaces related to Suppliers, Payable Invoices, AR Invoices, Order Management. Viz., supplier master and supplier interfaces (Using API) and General Ledger.
  • Developed interfaces related to General Leger like GL Interface, GL Daily rates interface
  • Enhancement requests raised by the business. Closely interact wif the business to understand the business requirements.
  • Customizations using Forms Personalization, CUSTOM.pll, developing custom forms for business specific requirements.
  • Call custom procedures from form-personalization instead of using the custom.pll. dis halped the system to have lesser maintenance on the objects that had to be maintained.
  • Call PL/SQL from Pro*C and Pro*Cobol scripts
  • Workflow Customization for Order Management, Pricing Modules.

Technical Developer,

Confidential, Atlanta, GA

Responsibilities:

  • Implementing the Payables, Purchasing, Receivables, Oracle Management on 11.5.10.2 version of Oracle applications
  • Developed interfaces related to Supplier Master, Supplier Interfaces (Using API), AP Invoices, AR Invoices, Auto Invoice, Order Management API’s.
  • Process Order API (OE ORDER PUB) for any sales order related changes that had to be done for cancellation, booking, ship confirm the order
  • Auto invoice interface for creating Receivables invoices
  • Suppliers interface from the legacy system using both interface tables as well as API provided by Oracle.
  • Worked extensively on Inbound/outbound interfaces and Conversions on modules related to GL, AP and AR.
  • Solution provider for business related flow
  • Developed the Customer form for Supply Demand and customized standard forms using CUSTOM.pll and Forms Personalization.
  • Customization of Processing constraints for Order Management
  • Workflow customization for PO Approval workflow
  • Workflow customization for PO Account Generator.
  • Worked on On site-offshore model
  • Performance Tuning for SQL statements and PL/SQL Procedures
  • Used AIM Implementation methodology for Requirement and Technical Design like MD50/70/CF250/BR100.

Technical Lead,

Confidential, San Jose, CA

Responsibilities:

  • Customizations to Oracle seeded sales order work bench form (OEXOEORD). The sales order work bench form was modified to suit the needs of CISCO. The customizations include
  • Changes to the Cancel Sales order form
  • Changes to the Copy Sales Order form
  • Add additional features to the default actions provided by Oracle and many other changes.
  • Support issues raised by the Business at Cisco
  • Requirements gathering, solution specification.
  • Creation of BR100 documents, Process Document, Functional/Technical Solution providing to fit Business requirements
  • Conducted all testing sessions for CRPs
  • Conducted feedback and detailed follow-up sessions for setting up and refining CRPs
  • Creation of setup documents, test scripts document for enhancements.
  • Solution provider for business related flow
  • Completed mapping for “as-is” analysis
  • Performance Tuning for SQL statements and PL/SQL Procedures
  • Developed the Customer form for Service fulfillment, ZOOM functionality, CUSTOM.pll customization
  • Resolving issues related to Accounts Payable module which includes supplier master and payable invoices.
  • Customer Interface, conversion using TCA API’s and Order Interface/conversion
  • Working on onsite-offshore model
  • Coordinate testing and development of documentation wif the technical, functional/end user community
  • Used AIM Implementation methodology for Requirement and Technical Design like MD200/CF250/BR100

Technical Developer,

Confidential., Allentown, PA

Responsibilities:

  • Used AIM Implementation methodology for Requirement and Technical Design like MD200/CF250/BR100
  • Creation of BR100 documents, Process Document, Functional/Technical Solution providing to fit Business requirements
  • Worked on Interfaces related to Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Order Management, Bill of Materials, Oracle Inventory.
  • Interfaces related to Order Management
  • Interfaces related to Oracle Inventory
  • Interfaces related to Oracle Payables
  • Interfaces related to Oracle Receivables
  • Interfaces related to Bills of Material Module
  • Many other form and report level customizations.
  • Developed reports using XML Publisher.
  • Custom reports for Oracle Order management, Inventory, Payables, and Bills of Material reports were developed using XML Publisher/BI Publisher.
  • Used tools like PVCS, Kintana for Code Management.

Technical Lead,

Confidential,

Responsibilities:

  • Support issues raised by the Business at Cisco
  • Requirements gathering, solution specification.
  • Creation of BR100 documents, Process Document, Functional/Technical Solution providing to fit Business requirements
  • Creation of setup documents, test scripts document for enhancements.
  • Solution provider for business related flow
  • Completed mapping for “as-is” analysis
  • Performance Tuning for SQL statements and PL/SQL Procedures
  • Developed the Customer form for Service fulfillment, ZOOM functionality, CUSTOM.pll customization
  • Customer Interface, conversion using TCA API’s and Order Interface/conversion
  • Working on onsite-offshore model
  • Coordinate testing and development of documentation wif the technical, functional/end user community
  • Used AIM Implementation methodology for Requirement and Technical Design like MD200/CF250/BR100

Developer,

Confidential,

Responsibilities:

  • Supporting modules related to Order management, Inventory, Shipping, Pricing.
  • Worked on Inbound/outbound interface and Conversion
  • Solution provider for business related flow
  • Customized standard forms using CUSTOM.pll and Forms Personalization.
  • Customization of Processing constraints for Order Management, Accounts Receivable, Accounts Payable.
  • Worked at offshore, Hyderabad India.
  • AIM Implementation methodology for Requirement and Technical Design like MD50/70/CF250/BR100.

Developer,

Confidential,

Responsibilities:

  • Supporting modules related to Order management, Inventory, Shipping, Pricing.
  • Worked on Inbound/outbound interfaces and Conversion
  • Solution provider for business related flow
  • Customized standard forms using CUSTOM.pll.
  • Customization of Processing constraints for Order Management
  • Used AIM Implementation methodology for Requirement and Technical Design like MD50/70/CF250/BR100.
  • Worked on Interfaces related to Order Management and Purchase Orders (PDOI)

OPM Technical Developer

Confidential

Responsibilities:

  • Worked at offshore location from Hyderabad.
  • Supporting modules related to OPM related Order management and Inventory.
  • Worked on Inbound/outbound interfaces and Conversion.
  • Worked on Complex reports related to Inventory and Order Management.
  • Worked on interfaces related to Oracle Payables viz., Vendors Interface, AP Invoices Interface.
Technical team member.

Confidential, Bedford, MA

Responsibilities:

  • Worked at offshore location from Hyderabad.
  • Prepared SQL* Loader scripts which were part of the development for the interfaces.
  • Tested the Interfaces for accuracy of the d Confidential migrated.
  • Performance Tuning for SQL statements and PL/SQL Procedures
  • Supporting modules related to Order management, Inventory, Accounts Receivables.
  • Worked on Inbound/outbound interfaces and Conversion.
  • Worked on Complex reports related to Inventory and Order Management.

Technical team member.

Confidential, Milwaukee

Responsibilities:

  • Migrating existing system in Oracle Applications 10.7 to 11.5.3
  • Extensively worked on forms, reports and interfaces.
  • Developed the Customer form for Supply Demand and customized standard forms using CUSTOM.pll and Forms Personalization.
  • Worked on onsite-offshore model
  • Used AIM Implementation methodology for Requirement and Technical Design like MD50/70/CF250/BR100.
  • Production support for the newly migrated system of 11.5.3 system.

We'd love your feedback!