Developer Information Technology

**** *********** ****, *** *

Charlotte NC *****

Shreekant Mandvikar

704-***-****

*********.*********@*****.***

Linkedin

Employment

Oracle Technical Developer

TCS - Ingersoll Rand, Charlotte

Oct 2012 - Current

SMART Oracle R12 Apps Implementation

Implemented Global interfaces for Oracle OM (Order management) for Order import, Order Updates, order extract, order to TA, customizing order configurator.

Designed and deployed Global interfaces for Oracle QP (Advanced Pricing) for Pricelist Sync, Dynamic pricing and Dynamic Batch Pricing, extended to be used within IR as API’s, importing Modifier, Pricelist conversion.

Simplified Architecture by bringing common design and flexibility of features for OM CFD’s - SOA (Sales Order Acknowledgement), COA (Change order Acknowledgement), Proforma Invoice, Quote, RMA and ASN.

Designed and Built Custom utilities like Oracle TCA(Trading Community Architecture) Ship-to-on-the-fly, Event \Object Locking mechanism, Email whitelisting in non-prod, Fax solution for multi companies, Smart SSD\CRD

Built custom FORM -Item inquiry, customized SO form for External users, customized seeded forms.

Performance tuning on SQL’s using Trace, TKPROF and AWR reports.

Design and deployed interface from FirstCall to Click to create\update Service call, appointments and sync back to FirstCall using Micro Services.

Prepared MD70-MD120 (Technical design document), technical flow diagram using MS-Visio and Prepared check script for supporting development.

Sr. Oracle Developer

TCS - GE Wind, India

Jul-2012-Oct-2012

GE Wind R12 implementation

First R12 implementation for GE.

Built Project history report, PO (Purchase order) report.

Performed POC (Proof of Concepts) on existing code built for GE by TCS and leverage same for GE R12 implementation.

Prepared MD70-MD120 (Technical design document

Oracle Developer

TCS - GE CS, India

May 2011 – Jun-2012

ERP MGPP 2012 Release

Built Custom reports for Oracle Field Services (OFS), Purchasing (PO).

Built custom OAF pages for OFS module.

Performance Tuning of Complex SQL’s using TKPROF and working with DBA’s.

Oracle Developer

TCS

Dec 2009 – Apr 2011

Ultimatix

Preliminary worked on Support for Oracle project costing and billing.

Worked on Oracle extensions for extending various process for business.

Supported integrations with Account receivables and Revenue Recognition

Languages and Technologies

Oracle EBS 11i and R12 - Order Management (OM),Trading Community Architecture(TCA), Oracle advanced Pricing (QP), Oracle SQL, PL\SQL and advanced PL\SQL, Oracle Reports, XML publisher, Oracle Forms, Workflow, XML parsing and processing.

TOAD, PL\SQL developer, SQL developer, HP Migration tool (Kintana-PPM), Sarena Dimension Express, Jdeveloper, Jmeter and custom tool Partner simulator.

Education and Certifications

Bachelor of Engineering, Information Technology, India

Certified Scrum Master

Oracle Certification- EBS R12.1 Order Management(1Z0-521),Program with PL/SQL(1Z0-147-OTC) and Database 11g: SQL Fundamentals I(1Z0-051-OTC)

Six Sigma Certified

Technical Experience

Image to voice (2008-2009).College major project – convert image to text (tried to mimic Optical Character recognition) and text to voice using java.

Cyber Security management System (2008). Using Java and MySQL built Cyber security management system.

Contact this candidate