Oracle Applications, Analyst, PL/SQL, Oracle Reports, Discoverer

Tripti Singh

(***) ***–**** • acbahx@r.postjobfree.com

ERP professional with in-depth experience of implementing and supporting Oracle Financials based customized business systems. Strong analytical skills, able to successfully map business practices to the IT system. Uniquely combines Management and Business skills with Technical and BI expertise. Reputation for strong work ethic, high energy level, approachability, and consistent commitment to corporate success.

Oracle Applications • Order Management • Purchasing • Inventory • Shipping

Receivables • Payables • iExpense • General Ledger • e-Commerce

System Administration • Performance Engineering • Data Quality • Analyst

Oracle • PL/SQL • Discoverer • Oracle Reports • Oracle Forms • Unix • CRM

PROFESSIONAL EXPERIENCE

Panasonic Electric Works of America (PEWA), New Providence, NJ • 2007–2012

Senior Business Systems Project Leader

• SME interface between the business and technology. Complete business knowledge, adept in mapping the business requirements to Oracle Applications. Order Management module was customized in order to provide solutions to the users based on business requirements. Managed the Oracle service requests to ensure optimal solution for user needs.

• Led the upgrade Release 11 to Release 12 – Responsible for documenting current procedures, working with consultants as a “gap provider” between PEWA business and Oracle Apps for a successful upgrade. Responsible for complete UAT – end to end cycle with all modules. Coordinated and validated all setups, flows in system. Provided training to key staff for new release. Provided post production SME support.

• Designed and implemented Oracle CRM On Demand for the Sales Team in order to consolidate the “customer data” and provide transparency and visualization of performance data. Managed team of 3 CRM consultants for gathering business requirements from users, documenting and providing technical details on Oracle CRM. The sales data was monthly uploaded to CRM by customized process.

• Designed and implemented Oracle iExpense for automation of the expense workflow – Responsible for all setups, flows implementation, complete testing, training and detailed monitoring at time of go-live. Customized the mileage expense based on the company rules.

• Designed and implemented Customized Order in process – The “Order In” is a very specific requirement for PEWA business, which gives the management visibility of future sales, based on current shipment and open orders. The entire process was single-handedly driven to completion with very effective results. The analysis, design, writing code, testing, debugging, and implementation were all carried out with great effectiveness. The management was very much satisfied with the detailed level reporting.

• BI reporting for C level management – Oracle discoverer, oracle reports and PL/SQL scripts have been exploited for BI reporting for senior executives. The summarized as well as detailed level reporting has been very effectively used for analysis and forecasting by managers.

• Mentored developers and non technical resources to provide analytics and data management knowledge and best practices.

• Customized the Oracle Webstore for management reporting. Responsible for maintenance and setups for the web portal.

• Support the business functions and users – Responsible for training business users. Daily/weekly/monthly scripts set up to send email alerts. Accordingly users were contacted to make the appropriate corrections.

• Responsible for the month-end business process flow. Coordination with respective departments for completing the month end and providing monthly reports to management.

Aromat Corporation, New Providence, NJ • 1999–2007

Helpdesk Analyst – promoted to Project Leader

• Lead Upgrade Release 10.7 to Release 11 - Responsible for leading the upgrade for Order Management satisfying all business needs. Responsible for support for all other modules. Documented the current process flow, gathered requirements, worked with the consultants in setting up the system. Completed testing, coordinated UAT with all departments, provided post-implementation support. Documented the changes and created training manual for users.

• Batch process customization – Customized “PEWA sequencing of demanding orders based on supply”. Provide business requirements to team for implementation of the process. Testing the process with all detailed combinations, implementing and providing daily support.

• Customize EDI – The Sales Order EDI and Purchasing EDI was customized based on requirements. The PL/SQL procedures and shell scripts written for implementing EDI with factories (PO requisition) and customers (sales orders)

• Gathered business requirements for enhancements and worked with Oracle to implement the same. The forecast/consignment workflow is one of the enhancements implemented. Others include emailing order acknowledgements, invoices, statements to customers

• Root cause analysis of business process issues. Proactively resolved issues with current setups and provided changes/corrections as needed.

• Provided business guidance and subject matter expertise to the technology team. Shared deep understanding of the functional process to enable seal the “gap”.

Rosy Blue Diamond, Indore, (formerly B.Arunkumar) India • 1994 - 1998

C++ programmer - Systems Analyst

• Automated the company’s business transactions to go “paperless”. Responsible for understanding business, programming and reporting. Was responsible for training of entire staff at the company.

Was the first programmer to join and led the company from 3 computers to 50 computers, also established a “network team” for setting up the “LAN” in company.

EDUCATION AND CREDENTIALS

Post Graduate Diploma in Operations Management

Indira Gandhi National Open University, Delhi

BS Computer Engineering

University of Pune, India

AWARDS AND RECOGNITIONS

Certificate of Recognition – For “Customer Focus” by Panasonic Electric Works of America. Have been repeatedly applauded by management for having positive attitude and as said in certificate- “Tripti makes things happen and dives deep every day to help solve problems and provide service to our employees”

Letter of Appreciation – For “Dedication at Work” by CEO, Rosy Blue Diamond, Indore. Had been repeatedly applauded by entire staff for “automating the systems” and received a personal letter of appreciation from CEO stating - “I wish to complement you for your total dedication, commitment and the efficient manner in which you have lead your team in developing the tailor-made software for all the departments of the unit”.

Contact this candidate