PROFILE:

Over fifteen years of progressive experience in system analysis, design, development and implementation of custom solutions on Oracle Confidential platform using related technologies and methodologies including RAD and SDLC methodologies. Possess sound functional knowledge in SCM, Retek, Accounting, Data Management, Child Support and Material Management. Currently an active member Confidential OAUG, PMI and APICS.

SKILLS:

Hardware: IBM PCs, NES Enterprise Servers and UNIX boxes.

OS: Windows NT, 2000, UNIX, Sun Solaris, AIX.

DB: Oracle RDBMS 9i, 10g, Apps 11i, R12 (eBS)

Languages: Shell scripting, SQL, PL/SQL, C, PERL/ CGI, ABAP/ 4, JavaScript, XML.

Tools: Forms 9i, Reports6i, 9i, JDeveloper, ERWIN, ADF, XML Publisher, ClearCase and Retek.

PROFESSIONAL EXPERIENCE:

Confidential, WI

Tech Lead

Responsibilities:

• Co - ordinated business requirements and functional design efforts to implement EAM and integrate with Confidential.
• The effort was to set up assets and schedule maintenance of equipment.
• Implemented integration points between four external sources to Oracle EAM for logging equipment usage and associated costs.

Environment: Oracle e-biz suite modules - EAM.

Confidential, MA

Tech Lead

Responsibilities:

• Performed complete SDLC on integration of 3PL systems to Oracle R12.
• Elicited requirements from business users and analyzed process flows between Oracle and PKMS.
• Transformed the requirements to design and development of custom application to integrate R12 with PKMS for inventory transactions and put-away.
• Solution design and implementation of complete O2C cycle including shipments.
• Implemented the solution as wrapper to existing interfaces based on their infrastructure.

Environment: Oracle e-biz suite modules - OM, INV, WSH, AR and PO modules.

Confidential, Dallas, TX

Project Lead

Responsibilities:

• Gathered requirements from business users and analyzed process flows between Oracle and PKMS.
• Transformed the requirements to functional specification for vendor managed inventory which improved order fulfillment by 25%.
• Conducted CRP sessions and GAP analysis for solution design.
• Implemented enhancements for pick ticket slips with barcoding and logics for price adjustments.
• Customized interface applications between Oracle OM and Manhattan PKMS for NAOps.
• Designed custom ASN interface application to customers.
• Provided POC for different format definitions and customer grouping for ASN.
• Design logics for customer import from legacy system Shiva/ CIM into TCA and set up of customer contacts and communications.
• Designed custom solution and specifications for workflow events and remittance advice to vendors.
• Facilitated remediation of custom objects for Confidential Engine implementation.
• Currently implementing R12 Technical Upgrade and support remediation of 2500+ custom objects.
• Allocating and overseeing roles and duties of off shore team members.
• Customization on DRP and MRP processes.
• Design and write specifications for custom reporting tool for sales team. It is a homegrown system STATS.

Environment: Oracle e-biz suite modules - OM, INV, AR, AP and PO modules.

Confidential, Richardson, TX

Project Lead

Responsibilities:

• Solicited and gathered requirements from users to design a custom application for reconciliation of inventory transactions and posting to GL through SLA.
• Designed custom application to scrub and mask sensitive customer data.
• Customization and importing of service contracts and designed custom templates.

Environment: Oracle e-biz suite modules - INV, AR, OKS, SLA and GL modules.

Confidential, Plano, TX

Project Lead

Responsibilities:

• As lead consultant, was responsible for prototyping custom application and implementation of Direct Fulfillment project that integrated the TPA and CATS transactions with Oracle ERP modules INV, OM, PO, FA, PA and AR. Managed a team of offshore consultants to implement the application per schedule.
• Designed and analyzed custom interfaces and business data flow between Oracle 11i (11.5.10) and other third party tools like Telcordia and VIPS/ VMI and mirrored transactions into CATS and Red Prairie.
• Design and specifications of custom application for error handling of order conversions in OM and interface to down stream systems like OTIVA. Facilitated tax data extracts to TPA. Custom application design for PO requisition cancellations thereby improving the inventory turnover by 13% and reducing backorders.
• Gathered and analyzed BR to design and implement an application to do away with use-up items and substituted for items in vogue within the EPL system. The solution helped reduce the inventory of use-up items and set up of item relationships for use-up. Data integration between legacy MRO application to Oracle.
• Implementation of applications using RUP concepts and tools like ClearCase and ClearQuest.

Environment: Oracle e-biz suite modules - INV, OM, P2P, BOM, AR and FA modules, TelcoBuy, CATS.

Confidential, Plano, TX

Sr Lead Consultant

Responsibilities:

• Gathered requirements thru CRP discussions and analyzed process flows and SOP to design custom application for diversity spending and reporting against total revenue.
• Implemented custom application to monitor project spending on small businesses categorized to WBE, DVBE and MBE.
• PO, Invoice importing from UA system into Oracle and custom reporting for Oracle Time and Labor and categorization against WON.

Environment: Oracle e-biz suite modules - OTL, PA, AP, AR and UA Solutions.

Confidential, Dallas, TX

IT Lead

Responsibilities:

• Reviewed existing systems and completed functional analysis of legacy system for data mapping between SAM and HEC to Oracle 11i modules.
• Gathered requirements, determined the gaps and provided enhancements to the interfaces in consultation with business users.
• Implemented custom application and enhancements to Shipping Execution on Oracle 11i (11.5.9 and 11.5.10) platform.
• Customized personalization of applications and facilitated Enterprise Application Integration between engineering and shipping divisions of the organization.
• Trained end users and helped test the functionality implemented. Participated in integration testing of shipping execution end-to-end.
• Mentored a team of 4 consultants to drive and complete the project.

Environment: Oracle e-biz suite modules - OM, WSH, INV, PO and BOM modules.

Confidential, Dallas, TX

Tech Lead

Responsibilities:

• As lead consultant, I was responsible for implementation of Network Error Handling application and integration between systems.
• Managed a team of 6 consultants to implement the application per schedule.
• Analyzed the custom interfaces and business data flow between Oracle 11i (11.5.9) and other third party CATS, TelcoBuy, Red Prairie and EPL tools.
• Designed, developed custom solution for sourcing optimization.
• Designed and developed custom application for analyses and facilitated error correction and resolutions.
• Suggested process improvements to minimize errors occurring out of the custom interface between applications. Provided a means to identify and synchronize assets between SCM organizations.
• Was responsible to co-ordinate design and development activities between teams and facilitate deliverables.

Environment: Oracle e-biz suite modules - INV, OM, FA, AP, PA, PO and BOM modules.

Confidential, Irvine, CA

Consultant

Responsibilities:

• Interfaced with end users to plan the flow process.
• Functional design and setup of warehouse locator system for receiving and picking of goods and prepacks that reduced the turnaround time for dispatch by 35%.
• Provided batch support and enhanced the markdown pricing user interfaces for RMS.
• Redesigned the logic for deal promotions to effectively download the price changes to stores per style/ SKU combination.
• Development for invoice import from Retek/ Stock Ledger to AP/ GL modules of Oracle 11i.
• Designed and developed automation for custom replenishments per store. Defined style analysis reports.

Environment: Oracle e-biz suite modules - AP, GL and Retek (RMS and RPM).

Confidential, Irving, TX

Consultant

Responsibilities:

• Reviewed existing business processes and gathered requirements for generating GAP analysis. Analysis of sub-applications and modules requiring changes and rewriting for the HYBRID project to enhance Supply Chain Management.
• Designed and developed custom interfaces for warehouse transfers and direct transfers from DCs within Retek RMS.
• Designed look ups and interfaces for currency conversion.
• Developed batch processes to map and load recollections, stock ledger and warehouse-store revenue data to GL interface for accounting.
• Developed interfaces for stock allocations, shipping schedules and SKU conversions.

Environment: Oracle e-biz suite modules - GL and Retek (RMS).

Confidential, Michigan

Consultant

Responsibilities:

• Actively participated with a highly spirited team of child support specialists to help achieve Federal Certification by the state and developed the web-enabled child support enforcement system.
• Designed and developed the financial application for the Confidential . Applied the DMADV methodology. Was instrumental in streamlining customer merges and sites.
• Defined journal entries and interfaced GL module of Treasury with CSES for distribution and disbursement accounting. Defined and generated specific reports for interstate and intrastate collections, disbursements.
• Business reports generation facilitated improved collections. Also developed applications for receipts handling and EFT transactions through congruent screens. Support to migrate Forms from 6i to 9i.
• Managed TANF and Foster care cases, support order processing, billings and notices.