MANDAR D. TAWDE

****, ** ***** * **, Apt ****, Topeka, KS - 66614

e-mails : ac10yk@r.postjobfree.com, ac10yk@r.postjobfree.com

Phone No : 508-***-****

PROFILE SUMMARY:

Over 15 years of total experience with 14 years on client/server applications under Oracle platform. 9+ Yrs of experience in Oracle Apps include leading and implementing SI & AM projects.

Over 7+ years of Team\Project leading experience with excellent people management, analytical & problem solving skills.

Well versed with 11i\R12 data conversions & Interfaces. Worked & supported interfaces between different Applications like Oracle 11i - Oracle R12, Oracle 11i - SAP, Oracle – SFDC, Oracle 11i – MDM(Informatica) through fusion middleware \ AIC.

Good knowledge & experience on Oracle 11i\R12 trading community architecture, CRM, Sales\Quoting, i-store, OCO, MDM, Advanced Pricing, inventory, Service Contracts, AR, OM modules, workflows.

Worked on the cloud apps like Callidus & Salesforce cloud.

Good knowledge on Health & public sector processes along with the Accenture Benefits Management System portal and developing data warehouse interactive reports & dashboards using Oracle BIP/OBIEE.

Good production support experience which includes SLA & Incident management, ticket reduction CIs implementation, adoption of new scope, Business Continuity support during quarter ends.

Excellent design and development skills with good understanding of Oracle database technology and concepts.

Experience in the entire project life cycle, from inception to implementation including analysis, design, development, testing and Release management.

OBJECTIVE:

To be associated with a growing organization, offering a challenging position that would best utilize my expertise towards the persuasion of its goals and to work with leading edge of technologies.

EDUCATIONAL QUALIFICATION:

Bachelor’s Degree in Mechanical Engineering from Mumbai University, 1999.

Post Graduation (Corrs.) in Business Administration (MDBA) from Symbiosis Institute of Management Studies, Poona.

Diploma in Production Technology from Board of Technical Examination Maharashtra, 1995.

PROFESSIONAL CERTIFICATIONS:

OCA (Oracle Certified Associate): Oracle Corporation.

ITIL v3 Foundation

PPSM (Program, Project & service management): Accenture Services Pvt Ltd.

TECHNICAL COMPETENCIES:

Oracle Apps - E-Bus Suite : 11i/R12 - TCA, CRM, Sales/Quoting, i-store, OCO, MDM, Advanced

pricing, AR, OM, Inventory, SR, IB.

DATABASE : Oracle versions 8i / 9i, 10g, 11g

DB LANGUAGES : SQL, PL/SQL, OAF, XML, Java, C

Cloud Apps : Callidus, Salesforce.com, Apex Loader

Oracle DB Tools : Oracle BI publisher, TOAD, SQL Developer, SQL Loader, SQL*Plus

OPERATING SYSTEM : Windows 2000/NT/XP/07/08, Unix

SOFTWARE/TOOLS : Clear quest, Quality Center, Citrix-Harvest, VSS

CAD/GIS PACKAGES : Auto-Cad, FRAMME, ARC-GIS, G-Tech, Microstation-SE –JAVA

PROFESSIONAL EXPERIENCE & MAJOR ASSIGNMENTS:

1) EMPLOYER : ACCENTURE SERVICES PVT LTD. (Jul 2005 – Till Date)

Current Position : Associate Manager

I.Project Title : State of Kansas

Client : KEES (Kansas Eligibility Enforcement System)

Duration : Aug 2016 – Till Date (Onsite USA)

Project Description : The project goal is to support the state Eligibility Enforcement System through Accenture Benefits Management System (ABMS), which is an application for public sector agencies to manage public assistance and social welfare programs. It allows streamlined case management and an automated eligibility determination.

Role & Responsibilities :

Responsible to support the reports implemented in Accenture Benefits Management System (ABMS) & Develop new reports as per the client requirements using BI publisher/OBIEE.

Co-ordinate with client policy team to understand the requirements & report structure for change request/new report & ad-hoc reports.

Work with client team for the UAT issues resolutions/fixes & ensure to capture any new requirements as a new change request.

Estimate & create a delivery plan for different reports for system test, UAT & production deployment.

Coordinate with onshore & offshore teams to execute the delivery plan for different testing phases.

Co-ordinate with Operation team to maintain scheduled reports.

Perform the peer reviews for Technical designs, report structure & output.

Responsible for status report & presenting it to management on weekly basis.

Responsible for highlighting a risk/blocker (if any) to management so that there won’t be any impact on delivery.

II.Project Title : EMC – Service 360.

Client : EMC

Duration : Feb 2016 – Jun 2016 (Onsite USA)

Project Description : The project goal is to transfer the existing service requests & related functionalities from Oracle 11i to Salesforce cloud. This includes multiple data conversions (15+ conversions) for the historical data which support these functionalities from different systems.

Role & Responsibilities :

Co-ordinate with business to understand & design the data structure which needs to be moved to Salesforce cloud as a part of SR implementations in SFDC.

Work with business analysts to understand the new integrations & prepare technical designs for the conversions.

Coordinate with business & solution implementation experts to create a functional design for Historical SR conversion.

Estimate & create a data deployment plan for different conversions for multiple Test Fires, Mock test & production deployment.

Coordinate with onshore & offshore teams to execute the data deployment plan for different conversion phases (Test Fires, Mock test & production deployment).

Coordinate with different application leads to get the historical data which needs to be moved to SFDC.

Perform the peer reviews for Technical designs & converted data.

Responsible for preparing a conversion plan during cutover based on the inputs from Dev, middleware & conversion teams.

Responsible for conversion status report & presenting it to management bi-weekly.

Responsible for highlighting a risk/blocker (if any) related to conversions to management so that there won’t be any impact on delivery.

III.Project Title : EMC - Sales support.

Client : EMC

Duration : Jan 2014 – Jan 2016 (Onsite USA)

Project Description : The project goal is to provide production support to client’s sales applications (Oracle 11i/R12 quoting, synergy sales, MDM, SFDC, infolease) through ticket solving & enhancement of the existing programs as per the requirement. Client use these applications for configure, price, quote and submit orders.

Role & Responsibilities :

Co-ordinate with business support group as subject matter expert, providing insight into Potential IT solutions to business problems.

Responsible for SLAs laid by end client for different modules for incident solving & work request delivery.

Responsible for successful adoption of the new scopes added to the project by setting & streamline the issues resolving process for offshore & on site teams.

Co-ordinate with business & solution implementation experts to understand issue resolutions during stabilization process. Update the knowledge repository and equip teams with future production support.

Responsible for impact analysis and estimations for the new enhancements or functionalities added to Sales applications.

Technical architect for short term projects related to Sales applications.

Responsible for end of quarter WAR room support for the Sales applications to ensure Business Continuity.

Plan & execute ticket reduction CIs to meet 10% ticket reduction per quarter.

Plan & execute process CIs to save efforts at user end.

Build Technical design, code, and test cases for sales quarterly break fix and enhancement releases along with short term projects.

Perform the peer reviews & testing.

IV.Project Title : EMC iMAP implementation.

Client : EMC

Duration : Oct 2012 – Dec 2013

Project Description : The project goal is to extend current MAP (Master Account Profile) data model & Transition 11i customer creation process to the customer HUB (Informatica MDM). Enhance the customer creation process by adding account, sites & usages details in 11i. Hub & 11i would be in sync through real-time interface.

Role & Responsibilities :

Analyze the business requirement & perform the impact analysis for the existing system.

Design technical architecture for real-time interface between 11i & Customer HUB.

Build Technical design documents & code programs for real time interface, Unit testing plans & test data, Install documents and incorporate review feedbacks for the objects assigned.

Complying with the development standards and processes in the project. Create new OCO responsibilities for new users.

Personalize existing OA pages to disable the create and update customer functionality for all OCO responsibilities.

Co-ordinate with onsite & process team for issue resolution for different objects assigned through e-mails and calls.

Perform peer review.

Work request fixes and raising migration requests in planIT tool after the fix.

SWAT testing of Migrations.

Identify the technical cause and potential impact of QC errors and implement coding or configuration changes.

Post go live, transfer the support to managed delivery team.

V.Project Title : EMC - Maintenance Pricing & RQF-SFDC integration.

Client : EMC

Duration : Feb 2012 - August 2012

Project Description : EMC - Maintenance Pricing - The project goal is to transition to a new maintenance 11i pricing methodology that enables EMC to meet all maintenance pricing strategies and successfully compete in all desired deals.

RQF-SFDC integration - The project goal is integration between RQF quote\opportunities and SFDC system through Oracle 11i.

Role & Responsibilities :

Co-ordinate with onsite & process team for issue resolution for different objects assigned through e-mails and calls.

Build Technical documents & code programs, Unit testing plans & test data, Install documents and incorporate review feedbacks for the objects assigned. Complying with the development standards and processes in the project.

Perform peer review.

Work request fixes and raising migration requests in planIT tool after the fix.

SWAT testing of Migrations.

Identify the technical cause and potential impact of QC errors and implement coding or configuration changes.

Maintain & analyze the time entries made by resources and take corrective action if required.

VI.Project Title : EMC - Sales support.

Client : EMC

Duration : Jan 2009 - Jan 2012

Project Description : The project goal is to provide production support to client’s sales applications (Oracle 11i/R12 quoting, synergy sales, MDM, SFDC, infolease) through ticket solving & enhancement of the existing programs as per the requirement. Client use these applications for configure, price, quote and submit orders.

Role & Responsibilities :

Leading a managed delivery team of 15 members along with 3 other surge projects.

Co-Ordinate with onshore manager & account lead on weekly basis to provide the overall status of the project.

Responsible for SLAs laid by end client for different modules for incident solving & work request delivery.

Plan & execute ticket reduction CIs to meet 10% ticket reduction per quarter.

Plan & execute process CIs to save efforts at user end.

Forecasting & plan 24x7 coverage to support production.

Capacity planning & managed quarterly bucket release for enhancements & break fix.

Publishing & presenting weekly, monthly & quarterly status report to client.

Responsible to maintain the project quality standards as per Accenture quality guidelines & responsible for Quality audits.

Maintain the project cost curve through re-staffing of the resources.

Staffing new resources for managed service team & surge projects in Sales space.

Maintain & analyze the time entries made by resources and take corrective action if required.

VII.Project Title : EMC – 11i – SFDC Integration.

Client : EMC

Duration : Jun 2008 - Dec 2008

Project Description : The project goal is to integrate the SalesForce.com portal into the Oracle 11i Synergy platform of EMC using fusion middleware & make SalesForce.com and Oracle 11i in sync with each other. This included development of program on Oracle 11i side to make smooth flow of data from\to the Oracle 11i using business events & Triggers. This also included conversion of existing customer accounts & user Ids.

Role & Responsibilities :

Lead offshore team. Prioritize the work, assign tasks to appropriate resources & get it done on time with quality.

Co-ordinate with onsite & process team for issue resolution for different objects assigned through e-mails and calls.

Build Technical documents & code programs, Unit testing plans & test data, Install documents and incorporate review feedbacks for the objects assigned.

Complying with the development standards and processes in the project.

Perform peer review.

Work request fixes and raising migration requests in planIT tool after the fix.

SWAT testing of Migrations and Production Support as required.

Tracking work requests.

Identify the technical cause and potential impact of errors and implement coding or configuration changes.

Taken KT for the EMC resources for the object delivered as a part of this project.

Maintain & analyze the time entries made by resources and take corrective action if required.

VIII.Project Title : EMC – TCA support & CSI Extension.

Client : EMC

Duration : Oct 2007 - May 2008

Project Description : The project goal is to provide support to the TCA module and its data in Oracle applications 11i for EMC & provide production support to Synergy Customer Service Integration Project in Oracle applications 11i.. This included development of program \ scripts, modifications of existing scripts \ interfaces to maintain TCA data as per the client's requirements.

Role & Responsibilities :

Lead offshore team. Prioritize the work, assign tasks to appropriate resources & get it done on time with quality.

Co-ordinate with onsite & process team for issue resolution for different objects assigned through e-mails and calls.

Build Technical docs & program code, Unit testing plans, Install docs and incorporate review feedbacks for the objects assigned.

Complying with the development standards and processes in the project.

Perform peer review.

Work request fixes and raising migration requests in Plan IT after the fix.

SWAT testing of Migrations and Production Support as required.

Tracking work requests.

IX.Project Title : EMC – Captiva Implementation.

Client : EMC

Duration : Apr 2007 – Sept 2007

Project Description : The project goal is to incorporate the Captiva Service processes and data into the Synergy platform. Transition Captiva onto

CSI integrated processes across all Captiva geographies. This included Conversion of key customer service master data & source system transactional data. Conversion included loading the key customer data from legacy or other external systems in bulk into the TCA Registry using oracle standard TCA API. Development of new oracle forms and Customization of existing forms & reports.

Role & Responsibilities :

Lead offshore team. Prioritize the work, assign tasks to appropriate resources & get it done on time with quality

Co-ordinate with onsite & process team for issue resolution for different objects assigned through e-mails and calls.

Build Technical documents, Unit testing plans & test data, Install documents and incorporate review feedbacks for the objects assigned. Complying with the development standards and processes in the project.

Perform peer review.

SIR\work request fixes and raising migration requests in Clearquest\planIT tool after the fix.

SWAT testing of Migrations and Production Support as required.

Tracking SIR\work requests.

Identify the technical cause and potential impact of errors and implement coding or configuration changes.

X.Project Title : EMC – CSI data clean up.

Client : EMC

Duration : Jan 2007 – Apr 2007

Project Description : The project goal is to clean up converted/user entered data in customer master (TCA) in Oracle applications 11i and to developed utilities to get rid of future data issues & to automate the current time consuming and error prone processes.

Role & Responsibilities :

Analyze and resolve the data issues.

Develop automated scripts in PLSQL to fix invalid data.

Develop utilities/automated programs to get rid of future data issues.

Perform code reviews.

Coordinate with onsite team for issue resolutions and requirements collection.

Maintain the data scripts from development to execution on production.

Creation of set up docs & Execution guides for different conversion objects.

XI.Project Title : EMC – CSI Implementation.

Client : EMC

Duration : Dec 2005 – Oct 2006

Project Description : The project goal is to incorporate the EMC's Service processes and data into the Synergy platform. Create one face to the customer for Service and Provide a common & integrated platform across Enterprise. This included Conversion of key customer service master data & source system transactional data. Development of new oracle forms and Customization of existing forms & reports. Conversion included loading the key customer data from legacy or other external systems in bulk into the TCA Registry using oracle standard TCA API.

Role & Responsibilities :

Development of various conversion & data loading programs using pl-sql and sql loader.

Co-ordinate with onsite & process team for issue resolution for different objects assigned through e-mails and calls.

Build Technical documents & code programs, Unit testing plans & test data, Install documents and incorporate review feedbacks for the objects assigned.

Complying with the development standards and processes in the project.

Issue resolution for objects assigned through e-mails and calls.

Fix up the changes required & get it migrate to appropriate environment.

Perform peer reviews.

XII.Project Title : Cendant Phobos

Client : Cendant

Duration : Sep 2005 – Nov 2005

Project Description : The Project is a Custom Development in Oracle Applications 11i (HRMS) for the Client Cendant. Presently Client is using a system called Lawson. This project deals with changing the processes from Lawson to Oracle Apps. This would involve Conversions, Creation/Customization work in Reports, Interfaces and Extensions.

Role & Responsibilities :

Development of Plsql program which will generate a reconciliation report for oracle application object.

Creation of database objects & Creation of script for loading customer data into oracle using SQL loader.

Analysis of objects for mapping and implementing business rules.

Modification of existing program as per customer requirements.

Creation of technical document for a reconciliation program.

Accreditations in Accenture :

Promoted to ‘Associate Manager’ in recognition for best performance & consistently achieving laid objectives.

Awarded with high performance delivery awards.

2) EMPLOYER : Rolta India PVT LTD. (Feb 2001 – Jun 2005 )

I.Project Title : GUC

Client : Greenville Utilities Commission (USA)

Duration : Jun 2004 – Jun 2005

Project Description : The project involves conversion of gas maps into intelligent graphics that have database connectivity to various other features.

Role & Responsibilities :

Creation of User/schema objects.

Development of PL/SQL scripts for database updation as per business rules, Data Transfer, QC.

Perform structured application code reviews and walkthroughs as needed

Participate in defining the technical architecture and coding standards

Translate functional design into technical specifications such as program flow diagrams, and translate technical specifications into program code

Part of the 5 member special task force for analysis and improvement of process, software, automation routines to achieve maximum productivity, better quality and faster deliveries.

II.Project Title : BTEL

Client : British telecom (UK)

Duration : Aug 2003 – May 2004

Project Description : The project involves conversion of telecom maps into intelligent graphics that have database connectivity to various other features.

Role & Responsibilities :

Creation of User/schema objects.

Development of PL/SQL scripts for database updation as per business rules, Data Transfer, QC.

Perform structured application code reviews and walkthroughs as needed

Participate in defining the technical architecture and coding standards

Translate functional design into technical specifications such as program flow diagrams, and translate technical specifications into program code.

III.Project Title : Tel-US

Client : Tel-US (USA)

Duration : Nov 2002 – Jun 2003

Project Description : The project involves conversion of telecom maps into intelligent graphics that have database connectivity to various other features.We delivered approx.100 exchanges.

Role & Responsibilities :

Development of PL/SQL scripts for database updation as per business rules, Data Transfer, QC.

Translate functional design into technical specifications such as program flow diagrams, and translate technical specifications into program code.

Coordination with the client and corresponding modification of the software and process as and when there were any changes in the project specifications.

IV.Project Title : OMAN-TEL

Client : OMAN-TEL (SOUDI AREBIA)

Duration : Feb 2001 – Oct 2002

Project Description : The project involves conversion of telecom maps into intelligent graphics that have database connectivity to various other features. We delivered approx.150 exchanges.

Role & Responsibilities :

Development of PL/SQL scripts for database updation as per business rules, Data Transfer, QC.

Translate functional design into technical specifications such as program flow diagrams, and translate technical specifications into program code.

Coordination with the client and corresponding modification of the software and process as and when there were any changes in the project specifications.

3) EMPLOYER : MALHAR INDUSTRIAL ASSOCIATES (Nov 1999 - JUNE 2000)

Position : Production Engineer

Job Description : Job involves supervision of overall production work & manpower management of a Production unit. It is a Food Processing equipment manufacturing company. Two-pronged strategy was to modernized existing designs & simultaneously develop new designs for new applications.

Role & Responsibilities :

To design & manufacture special purposed machines for Indian food processing industry.

Supervision & development of all subordinates.

Handle a team of 15 subordinates & maintain smooth flow of production, provide optimize solution to solve the problems raised.

Make weekly plan for deliveries & inventory management to meet the deliveries ahead.

Maintain daily record of work done by each subordinates.

4) EMPLOYER : LIPAP SYSTEM PVT. LTD. (Nov 1995 - May 1996)

Position : Production Engineer

Job Description : Job involves overall work & manpower management of a Production unit, which is a producer of the Ribbons of the computer printers with brand name ‘PICA’. All products get distributed to various dealers all over the India & abroad. Some of the foreign customers include DCI UK,TURBON,ULTIMAX etc.

Role & Responsibilities :

To achieve Value & Volume Sales through efficient control of subordinates.

Training, Supervision & development of all subordinates.

Handle a team of 25 subordinates & maintain smooth flow of production, provide optimize solution to solve the problems raised.

Make weekly plan for deliveries & inventory management to meet the deliveries ahead. Maintain daily record of work done by each subordinates & forecast requirement of manpower on basis of growth.

PERSONAL INFORMATION:

Name : Mandar Tawde

Permanent Res. Add. : 1,Kshir-Sudha CHS., Hanuman Road,

Vile-Parle (E), Mumbai : 400 057, India.

Date of Birth : 22nd June 1977.

Telephone : 001 508-***-****, 91-022-********,

Email id’s : ac10yk@r.postjobfree.com; ac10yk@r.postjobfree.com

Visa : H1B

Marital Status : Married.

Gender : Male

Nationality : Indian

Language Known : English, Hindi, and Marathi.

Contact this candidate