SUMMARY:

• Oracle Certified Professional with strong Technical Skills in Oracle Application 11i/R12. More than 10 years experience in implementing Reports, Interfaces, Conversion and Enhancement (RICE) for Oracle EBS release 11i/R12 modules such as: Order Management, Purchasing, Inventory, HRMS, Cost Management, SLA, FAH, EBTax, Service Contacts, AP, AR, GL, AGIS, Incentive Compensation. TeleService, Fixed Assets, Cash Management, CRM, i - Store.
• Technical Expertise using oracle related tools and software such as Reports/Forms/ Triggers/, API, AQ, OAF, APEX, SOA/BPEL and XML.
• Knowledgeable in Order-to-Cash, Procure-to-Pay and Financial process flow. Familiar with Oracle AIM documentation and waterfall methodology.
• Certified scrum master and have experience in Agile Methodology. Excellent communication, interpersonal, analytical, technical and leadership ability.

TECHNICAL SKILLS:

Programming Languages: PL/SQL, SQL, Unix Scripting, BPEL, SOA, OAF, Core Java, Oracle Workflow,XML Publisher, Forms/Report, Oracle Apex

Operating Systems: UNIX, Linux, Windows.

Databases: Oracle, SQL Server

Others: TOAD, Oracle AIM, Agile Methodology, Project Management

PROFESSIONAL EXPERIENCE:

Confidential, Round Rock, Tx

Solutions Architect/Development Lead

Responsibilities:

• Lead the setup the Oracle EBS R12 instance GL, Inventory and AR module
• Functioned in the role of Development Lead for enhancement of GAAP calculator (Revenue application) for CANADA ASE.
• Designed the enhancement and reviewed the existing store procedure for CA GAAP.
• Designed and Developed the Discount Allocation Program (for US GAAP ASC606).
• Developed the Item synchronization API from calling Web Services from PL/SQL
• Designed and Developed the synchronization program from upstream application using Oracle AQ and PL/SQL and Business Events.
• Helped design and develop the Dell Custom Revenue Application to adhere to US GAAP ASC606 regulations.
• Developed a new tool for creating excel formatted report .
• Designed and develop a new tool to load and processed Microsoft Excel/XML file using OAF
• Helped the designing and developing Arrangement Dashboard developed in the OAF
• Guided the development team on Oracle best practices and standards.
• Provided a meaningful approach to other developers in solving complex situations.
• Developed reconciliation XML report between Virtual Trader(Inter-company solution) and GL.
• Managed the Virtual Trader Installation and Setup inside Oracle EBS R12.
• Worked closely with the Virtual Trader Technical Lead regarding the configuration, setup and interfaces.
• Perform the configuration of data and process flow from AGIS and Treasury to Virtual Trader Schema.
• Prepared MD070 and CV(Data Migration Document)
• Reviewed MD050 and BR100.
• Led the development team and VT technical engagement.
• Created and implemented the orchestration deployment plan.
• Reviewed business requirements, functional and technical specifications.
• Performed knowledge transfer and training to the support team.

Confidential, Austin, Tx

Solution Architect/Technical Lead

Responsibilities:

• Standardized the integration approaches for a variety of business requirements.
• Design and developed the Custom ATP program.
• Oversaw the enhancement and maintenance of the SOA Web Service and processes.
• Served as key person and consultant for any EBS enhancement and extension.
• Led the data conversion from CANADA Legacy system ( ITEMs, PO’s, Invoices, Orders).
• Developed reconciliation report between GL balances and Transactions ( AP,AR, INV)
• Developed program to integrate the Custom Order form to Payment Services a .NET application .
• Developed XML Check Printing program and Bank Payment File.
• Designed the integration of 3rd party fulfillment to EBS.
• Reviewed business requirements, functional and technical specifications.
• Designed and led the CRM Integration technical team.
• Prepared and Reviewed: MD070, MD050, CV, TA, BR100.
• Developed Zero Costing and Trade-In program.
• Performed as a liaison between the Project Manager and the Development T eam.
• Partnered with business and IT teams to design and develop robust and flexible solutions.
• Developed Phone Order Dashboard using OAF to search and monitor phone order status.
• Personalized Payables->Supplier Page to extract Supplier site information to CSV file
• Personalized Supplier Invoice Management to submit the “Supplier Open Balance Letter”
• Drove continuous process improvements and operational efficiencies, as well as scalability initiatives in an effort to make Oracle EBS more reliable, predictable and efficient.
• Oversaw the design, development, integration, deployment/production support and other technical aspects of the development of and modification to the applications.
• Worked with Project Managers, Analysts, Developers and Testers to ensure development requirements were fully documented, agreed on and delivered per System Development Life Cycle (SDLC) standards.
• Managed the data conversion initiative.
• Production Support for Logistics/Inventory, P2P and Order to Cash Tickets/Enhancement
• Collaborated with the DBA team for application performance tuning.

Confidential, Austin, Tx

Senior Oracle Techno-Functional Lead

Responsibilities:

• SiteStuff delivers cost effective high-value business process improvement solutions to real estate organizations..
• Provided Oracle Applications support, custom applications support and Data Warehouse support.
• Developed Custom Forms and Reports.
• Production support for P2P and Order to Cash Issue
• Created Custom OAF Page to facilitate the Oracle SR creation and Monitoring.
• Personalized the I-Store page to add item addition information.
• Performed as Functional resource for OM, AP, GL, AR, Oracle Service/CRM and Inventory.
• Developed and maintained Account and user registration loading; created API to monitor account deployment and completion.
• Designed API to facilitate the Custom Order Approval Process; designed BPEL process for the Custom Order Approval Process.
• Developed API which supported the Recurring Order Process, setup, alert and placement.
• Created API which facilitated the sync of ERP items, pricelist and Catalog to the External Web Store.
• Developed loading program for the following. General Ledger Code, Item Master, Pricelist, PSL and Catalog.
• Developed API used for Special Product Registration, Approval, Pricing and Catalog.

Confidential, Austin, Tx

Senior Oracle Application Consultant

Responsibilities:

• AlphaSoft Services Corporation, is a provider of high quality IT services in the areas of Enterprise Resource Planning (ERP), Data Warehousing, e-Business and related technologies. Vendor specific technologies include Oracle, PeopleSoft, BEA, IBM, ATG, Informatica, Business Objects, Cognos and Microsoft.
• Performed Technical and Functional Support for several clients who logged in Service Requests in the Salesforce. ( OM/OKS/INV/AR/GL/AP/HR/PO) System.
• Designed and developed the Replacement Projects which included Drop-ship-interface to OM, sending PO information to Supplier and Receiving interface and AP interface respectively.
• Produced and developed the Exchange Rate Loading P rogram.
• Built and developed Fixed Assets Report to be ported to BI Publisher Enterprise.
• Designed and implemented FSG reports into Oracle BI Publisher Enterprise.
• Provided maintenance and support for Service Contract Module. The task included re-coding the custom renewal API, creating reports for Contracts due for Renewal, monitoring the flow of data from the Service Contract to AR.
• Developed many reports for the Manufacturing Module such as: Batch Processing Summary, Plant Gross Margin and Plant Manager Daily Summary
• Introduced and developed Custom Workflow for Task re-assignment and escalation.
• Performed many setups for the CRM Foundation and the Oracle TeleService.
• Planned and developed Resource Management API from Payables to Resource Management.
• Set up and developed OIC Transaction Interface from Legacy System.