Summary

• Proven track record in Data Conversion, Go Live planning and initial load to third party systems with daily net changes at major clients. Delivering Financial and Supply Chain solutions, stabilization, improvements and ROI. Led Supported multiple projects in various capacities during design, development, support upgrade.
• Clients from multiple industries like HealthCare, Automotive, Retail, Insurance, Sales and Distributors, banking, airlines and hospitality, Benefit administration.
• A few clients: Ascension Health Hospitals, Accenture, Navistar, State Farm Insurance, Sears/K-Mart, Rockwell Automation UPMC Pittsburg.
• Employers: Hewitt Associates, Shorr Packaging, PeopleSoft Inc., Underwriters Labs, Sears Roebuck,
• Citizen of USA. Willing to travel. Telecommute works as well

Professional Experience

Confidential

SCM Consultant

• Reviewing various Requirement Gathering Documents and offering insights and recommending changes as relevant in a complex team structure and responsibility matrix. Working closely with design lead to fine tune, modify or clarify the requirements.
• Coordination with Offshore testing resources to ensure testing is completed as needed and rotate between Onshore and Offshore resources.
• Developing and uploading test scripts to the HP/ALM test repository. Performing testing and coordinating defects with the development team.
• Working closely with technical team to ensure various incidents and bug-fixes get tested as relevant before being released to productions.
• Activation of POXMLP feature for PO PDF generation in a selective manner resulting into significant saving on Pricing time for end users.
• Assessment of various bugs and defects coming up in Production and testing Oracle or in-house fixes.
• Partcipating in business process conversations and recommending options to primary support members dealing with end users on a regular basis
• Troubleshooting incidents involving interfaces when data mismatch is found.
• Troubleshooting incidents or transaction glitches involving inventory processes.

Confidential

• Assessment of various bugs and defects impacted by the PeopleSoft bundles 15 thru 23 on being applied to the client installation.
• Reviewing and Reclassification of marked complexity of the individual bug ids and assessing the risk and priority with SME on the team.
• Developed test scripts for testing individual bugs as relevant to the existing business process and system usage, and also for testing custom and delivered functionalities and processes
• Testing of various custom and delivered functionalities within PO, ePro, Inventory and Payables.
• Testing of End to End Processes PO, ePro, Inventory and Payables. For example Req to Voucehr, Replenishment to Purchase Orders.
• Document various defects and working with the SME and technical team to resolve and retest defects. Bill-Only, Minimum Order, LUM, SciQuest, Special Request, Contract and Item sync etc
• Assisted users during actual UAT testing to ensure scripts were executed in accordance with the fixes delivered where applicable. Participated in discussions to decide which scripts need not or could not be tested as per actual system usage and customizations.
• Assisted other consultant in Query and Report development as necessary.
• Custom Functionalities involving Minimum Order Consolidation, Least UOM, Contract Distributor and Markups, Bill Only and Repair Requisitions, etc.

Confidential

Supply Chain Consultant Integration lead, Solution architect Support

Wholesale Notes Administration

Bolt-On application developed for managing financing, interest and receivables

• Designed multiple new business process and technical integrations to support various business requirements. Worked with offshore resource on the development and testing the following.
• NEFT - Custom AR Credit to AP Refund process
• Mapped dealers to vendors thru delivered mapping fields. Loaded vendor data thru ExcelToCI component interface.
• Interface from legacy systems to Peoplesoft for the AR Credits
• Allowing users to manually select/deselect staged credits and/or add new.
• Redirecting those credits into the Refund process to feed to AP
• Managing the Vouchers with unique customer/vendor setup
• Managing payments thru individual pay group and paycycle
• Passing ACH details to related bank thru ftp with pgp encryption
• Ability to identify transactions that are in error or are stuck at any level.
• PART Notes - Customer AR to Financing/Note process based on various sales terms code
• Evaluating daily open AR to identify transactions eligible for financing
• Identifying the AR to Financing ratios per sales terms and other variables
• Consolidation of eligible transactions and generating corresponding credits and financing installments
• Tracking the processed transactions to prevent reprocessing
• Tracking the correlated AR Invoices with the corresponding credits and notes.
• Rate and Flat Charge - Ability to maintain various interest rates for dealers and service charges
• Dealer Interest Reimbursement for internal subsidiary
• Ability to identify Financed AR/Notes eligible for interest reimbursements
• Credit to be applied to customer AR for eligible interest reimbursement
• Ability to identify applied credits and print them as an invoice/report
• Ability to display monthly reimbursements to the dealer/customer thru customer portal
• Ability to generate and apply various service charges to dealers and family of dealers
• Different dealer groups have different level of service charges per month
• Dealer groups have individual or collective rates and caps per year.
• Eliminated the need to track charges manually and issue credits each month.
• o Stellent repository for attachment
• Designed the logic to allow users to attach documents to newly entered Notes transactions
• Manage add/delete ability for such attachments based on if a note is approved or not
• Testing
• Participated in unit and system testing of above functionalities
• Worked with users in UAT and defect processing
• Participated in testing of other functionalities for interest processing different from reimbursement
• Coordinated partial go-live activities of pieces that were ready.

Confidential

• Project lead during requirement, design, development and testing stages of the project. Coordinated weekly calls with internal and external partners to keep project moving forward.
• Designed and developed overall procure to pay process and solution to allow voucher details to be put on a trading portal/exchange for early payment for participating suppliers. It allowed better cash flow management for my client and early payments for the supplier.
• Developed custom extension to capture supplemental vendor attributes like pay terms, pay method, pay group bank and account at the AP business unit level.
• Developed custom extension to allow mass changes for vouchers for such attributes thru online screens.
• Developed an application engine that would realign new vouchers created thru online entry or batch interface to the above attributes before getting processed thru matching and posting. The same application engine also produced the outbound data file and applied inbound remit advice details.
• Outbound and Inbound solution used different approaches where data was moved thru SFTP, PGP Encryption, Unix and Mainframe.

Confidential

• Senior process and data flow analyst during the assessment and discovery stages of the project to replace 40 year old mainframe based accounting and reporting systems.
• Analyzed data flow to various mainframe files and database tables and develop process and dataflow diagrams to identify 'cut-off' points of relevant data streams to identify the impact.
• Assessment involved data flow from various business activities like vehicle sales new and used , warranty and notes/financing.

Confidential

• Applied Bundles 14 thru 37 for Peoplesoft PO, ePro SPro applications on version 8.9 and Oracle. Project was completed under budget.
• Lead Procure to Pay analyst and worked closely with business partners during testing stages.

Confidential

• Served as data architect/integration lead for supplier and contract data across multiple systems impacted by the project. It included in-house demand planning system and new systems like eBS, ASCP and Demantra. Part of the project also included changes to the mainframe based payable system.
• Member of the strategic team which developed the cutover plan an environment builds. Contributed significantly in the decision and planning for the pilot go-live with select suppliers and develop parallel system maintenance between Pilot and ultimate full go-live.
• Designed the supplier and contract data interfaces from Peoplesoft to various application depending on it. Led the development team within Peoplesoft and WBI which developed web service based solution using integration broker and application engine. XML size was managed thru chunking.
• Participated in design conversation for Sourcing Engine and system splits and shut-down.

Confidential

Global Systems Administrator

• Implemented ePro/PO systems with workflow for UK. Led data conversion and testing efforts for the same. Developed the admin teams via knowledge transfer and mentoring. Defined high level Multi-Language requirements for Poland and other European countries.
• Designed and implemented workflow based Req to Contract process for UK and India.
• Defined business requirements and implemented best practices after detailed fit-gap analysis and designed dynamic solutions. Worked directly with various development and support teams in US and India offshore to optimize cost and use onshore/offshore model effectively and meet the budget and timelines with quality deliverables.
• Defined requirements and listed risk during implementation of Invoice Approval and Contract Release functionality to replace manual invoice processing steps. Used workflow for approvals.
• Defined requirements for a new PO Reconciliation and close process with user defined variables. Defined requirements for a new Receipt Close process to streamline accrual calculations.
• Collaborated with offshore developers and Dell technical team to integrate Dell-UK as a direct-link/Punch-out vendor.
• Reviewed, prioritized and tracked work pipeline from IT-teams as per the changing business requirements. Put various enhancements and fixes to stabilize the system.
• Maintained global ownership of the PO/ePro systems for functional setup, configuration, SOX-Audit and compliance and leverage system functionalities to achieve higher user efficiency.

Confidential

Business and Technical Analyst

• Identified shortcomings and recommended best practices to save payroll cost for the payables, credit, purchasing, and warehouse teams respectively by system improvement and stabilization.
• Designed and developed multiple enhancements for specific business requirements and generated recurring savings of approx 250K per annum
• Analyzed, designed, and developed a new custom receipt accrual process replacing manual entries allowing better visibility to accruals in shorter timeframe and comply with SOX and audit
• Developed a new pricing system to ensure better price presentation at Order Entry time helping maintain and improve margins and profitability.
• Designed and automated the freight tracking process by developing a custom freight tracking and matching tool for real-time integration between warehouse and payable and reduce manual intervention and reconciliation
• Designed and developed a custom freight surcharge solution to Passover increased fuel and transport cost to customers and improve profitability thru auto-invoicing of the surcharges.
• Redesigned additional cost capturing tool, sales person charge backs, and improved sales and commission reporting.
• Implemented a complete EDI solution from PO thru EFT advisory earning an additional 1 rebate from a major vendor.
• Improved billing and invoicing process by changing the invoice sequencing and adding more details to the crystal invoices. This freed almost 2 hours per day for the Invoice sorting clerk Modified Pickplan, Packing Slip, Bill of Lading and Shipping functionality to assist warehouse operations gain efficiency. Implemented BlindShipping functionality via customization.
• Modified major application engines processes to develop customized solutions. AP VCHRBLD, PO POCREATE, IN USG DSKTP, PO PORECON, BIIF0001 to meet specific business needs
• Implemented EDI Dispatch of Purchase Orders.
• Implemented EDI receipt of vendor invoices and auto generation of related Vouchers.

Confidential

Senior Supply Chain Consultant

Recipient of multiple PeopleSoft e-Hero nomination for being top consultant for the PSC Midwest SCM team.

• Mentored staff-level consultants on client relationship and efficient solution design and delivery.
• Successful solution delivery to multiple clients from various industries and complex processes.
• Contributed multiple postings to the shared data repository for the consulting team.
• 8.4 eProcurement 8.x Purchasing
• Led various fit-gap sessions to understand existing legacy applications with which the new PeopleSoft Purchasing applications had to integrate.
• Designed solution and led the development effort of four developers in integrating receiving data from legacy systems and synchronizing item master, synchronizing asset profiles, and item buyer.
• Accelerated item conversion effort that had fallen behind, improved execution time from 24 hours to 2 hours and involved 3 sets of item data with a total volume of 25,000 items 3.6 million rows worth of data .
• Led the design and development/coding efforts for various item restriction-related interfaces between legacy system and PeopleSoft eProcurement.
• Analyzed, defined, designed, and developed various online customizations to facilitate item restrictions at requisition level to accommodate complex business requirement for catalog management.
• Developed test scripts and participated in system and user-acceptance testing.

Confidential

• 7.5 Purchasing Global Implementation ranging from US, Canada, and Europe
• Designed and modified existing EDI setup and functionality to manage PO dispatch via Web.
• Developed various custom reports for purchasing, warehouse, and flat file related requirements.

Confidential

Purchasing Maintenance and Improvement

• Coached, mentored, and trained four-person technical team on their respective development efforts.
• Designed, and developed a solution for accurate distribution of purchasing cost to avoid rounding errors.
• Enhanced Requisition and PO entry process by facilitating project as a part of defaults.
• Enhanced Voucher entry processes by facilitating PO Line level selection to copy into the Voucher.

Confidential

• Purchasing Inventory Improvement and Streamlining
• Enhanced Cart replenishment process by preventing redundant and excessive purchase of items to prevent space conflicts and cost caused by duplicate ordering triggered by the system.
• Designed and developed a new SQR process to capture new replenishment requests triggered by supporting warehouses as per distribution networks.
• Developed a custom SQR solution to maintain Unit of Measure in sync between their internal usage and suppliers.

Confidential

• Consolidated backorder demand lines, saving on processing time and volume while picking and shipping.
• Developed online code and custom SQR to accommodate freight conversion for sales orders in foreign currency.

Confidential

Senior Programmer Analyst

• Designed, developed, and released a new item master load from vendor-delivered Excel file.
• Collaborated with workflow and security administrator and DBAs when needed.
• Developed various reports. Bug-fixing and enhancements.
• Lead Y2K-related efforts and led other developers as needed.

Confidential

Programmer Analyst

• Developed complex Tree Structure for reporting, Summary ledger etc.
• Designed, managed, and modified various nVision reports.
• Developed SQR and Crystal training documents craze.mdb for development team.
• Provided end user support on production issues.
• Worked extensively with the security administrator and helped him understand the application and features.