Makarand Vidwans

**** ********* *****

Mason, Ohio – 45040

acqfjy@r.postjobfree.com

Cell: 1-678-***-****

Summary:

I have a total 24 years of experience out of which more 15 years’ experience as a ERP Enterprise Solution Architect Manager, Performance Tuning Specialist covering Oracle e-Business Suite, Fusion Middleware and Non-ERP technologies spanning a wide range of financial & manufacturing industries. I have hands on experience in areas of Product Installations, Upgrades, Performance Tuning, Troubleshooting, Security of Oracle Databases and Applications.

As an ERP Solution Architect I have architected solutions for multiple Global ERP / FMW / SOA Implementations. Created Technical Architect document, Infrastructure Diagrams, Systems Integration Diagrams, Supported critical go-lives, production systems upgrade etc. while providing solutions for critical infrastructure, security, capacity related issues.

I have proven experience of managing multi-million dollars engagement with a team of 80+ resources spread across the globe covering design and operations areas of Oracle ERP, Database, Middleware, Web technologies.

As a program Manager I also have experience of working with vendor management, building solutions in response to RFPs, effort estimation, resource pricing, developing program schedules and tracking them to completion.

PROFESSIONAL EXPERIENCE :

ORGANIZATION : Genpact LLC

POSITION : Program Manager

DURATION : September 2006 till Date (USA)

December 2004 – September 2006 (INDIA)

Client : GE Oil and Gas

Projects Undertaken And Responsibilities

Current Role

Currently working in a dual role of Performance Tuning Specialist as well as a Program Manager for fast growing GE Oil and Gas business providing thought leadership, strategic planning, and overall business acumen, working closely with the operations team

Performance Tuning Specialist role include but is not limited to:

Identify bottlenecks in existing ERP & Non-ERP Environment using various tools like OEM12c, AWR Reports and User Experiences etc.

Impact Analysis of identified bottlenecks

Take appropriate corrective actions such as custom query tuning, working with Oracle in case standard code is a problem, Concurrent Manager redesign, User training.

Program Manager Role includes but is not limited to

Driving operational excellence across the respective Program Services Line.

Defining and maintaining governance framework for managing operations delivery.

End-to-End benchmarking and standardization.

Continuous improvement projects.

Overseeing day-to-day operations, client interactions, improvement actions, Lean and Partner Interaction

Previous Role

Project Manager- ERP Design Team leading a team of ERP Enterprise Solution Architects, supporting area of Oracle ERP Applications and Non ERP Databases, responsible for architecting and designing critical applications required by various GE Businesses using robust software design methodologies backed by data, thus facilitating creation of an environment with stable / scalable infrastructure, standardized platform architecture. Technologies covered included but not limited to Oracle eBusiness Suite, Oracle Fusion Middleware & Oracle Transportation Management

Past projects Handled are spread across following categories

Implementations

Fresh Implementation of Oracle EBS, Oracle SOA / FMW, OTM

ERP Upgrades:

Multiple ERP upgrades ranging from R10.7 to R11i and R11i to R12 & R12.2

Performance Tuning:

SQL Query Tuning, Tuning long running SQL’s occurring during Upgrades, Database Tuning, Establishing ERP Performance Guidelines

ERP Installations:

Building Fresh ERP Environments as and when required.

ERP Security:

Analysis of Security fixes released by Oracle, Application of Security Fixes to Oracle ERP Environments

ERP Capacity Planning:

Forecasting Resource Requirements on an annual basis for existing ERP Environments, Sizing for Upcoming Oracle ERP Environments

ERP Quality:

Discuss Load Characteristics with QC Team, Setting up of Statspack, Analysis of Load Test Statistics, Tuning of Database Parameters, Provide Consolidated results to QC Team

Technical Trainings & Presentations:

Oracle Applications Architecture, Oracle Database Concepts, Oracle Database Performance Tuning, Advanced Oracle Applications Technologies like Extranet. Oracle ERP Sizing

ORGANIZATION : ICICI Infotech Ltd - India

POSITION : Senior Executive

DURATION : October 2003 to December 2004.

Projects Undertaken And Responsibilities

Project

Maintenance of Production Databases and implementation support for Oracle HRMS and OFSA.

Period

October 2003 – December 2004

Environment

Oracle Applications 11.5.9 Financials, HRMS & OFSA

Client

Development Credit Bank Ltd. Mumbai.

I have also done Performance Tuning projects at Federal Bank, JP Industries, Union Bank Of India. These projects were of time bound having duration of 2 weeks each.

ORGANIZATION : Clover Technologies Pvt. Ltd - India

POSITION : Database Specialist

DURATION : November 1999 to October 2003

Projects Undertaken and Responsibilities

I worked as Database Specialist, Consulting for implementation of Oracle Applications solutions in a hosted environment. I was involved with solution implementation and project management. During my tenure with Clover Technologies Makarand was involved with the following projects:

Project

Implementation & Maintenance of Oracle Financials and other Production Databases.

Period

June 2002 to October 2002 and April 2003 to October 2003

Environment

IBM AIX 4.3, Solaris 5.8, Red Hat Linux, Windows NT & 2000.

Oracle 8i, 9i and Oracle Apps 11i (11.5.5).

Client

Kotak Mahindra Bank. Mumbai.

Project

Database administration of Finacle

Period

May 2001 to May 2002 and November 2002 to March 2003

Environment

Sun Solaris 2.8, Windows NT (SP 6), Oracle 8i.

Client

ABN AMRO Bank, Mumbai.

Project

Database Maintenance

Period

January 2001 to April 2001.

Environment

Windows Nt 4.0 (SP 4), Oracle 8.1.5

Client

Hindustan Antibiotics Ltd.

Project

Oracle Application Tuning

Period

August 2000 To December 2000

Environment

Windows NT 4.0 (SP 5), Oracle Application 11.0.3, Oracle 8.0.4.1.3

Client

Forbes Marshall Ltd.

Project

Database Maintenance

Period

August 2000 to April 2001

Environment

Vax VMS, Oracle 7.1

Client

Bharat Forge Ltd.

Project

Database Maintenance

Period

January 2000 to September 2000

Environment

HP Unix, Oracle 7.3

Client

Kalyani Steels Ltd

I have also done performance tuning projects at Sona Koyo Stearings and Tata Teleservices, which typically were of short duration of 3-4 days each.

ORGANIZATION : Lloyds Finance - India

POSITION : Senior Executive

DURATION : August 1995 to November 1998

Lloyds Finance was a leading high profile Non-Banking Finance Company in India with an asset base of over 1600 Crores. My areas of operations included establishing network of brokers in Mumbai and surrounding suburbs and then in Pune, improving the Fixed Deposit Collections and assisting the Prime Net Department to market their issues successfully.

Significant Achievements

Developed an intensive network of brokers in Mumbai, which covers area along the central suburbs upto New Mumbai and Panvel.

Initiated the idea of opening satellite offices in Mumbai for improving collections, which later on followed by other leading NBFC’s in Mumbai.

In September 1997 was transferred to Pune Office. Areas of operations included improving renewal ratio. Assisting Consumer Finance Department in Collections and Marketing.

Improved the renewal ratio of the company significantly.

Successfully implemented various direct marketing tools with good results.

Was promoted to Senior Executive Marketing in May 1998.

ORGANIZATION : 20th Century Finance Corporation Ltd - India

POSITION : Junior Manager

DURATION : June 1990 to July 1995

20Th Century was one of the leading companies in the NBFC sector having wide branch network across India. My areas of operations included Share, Debenture and Mutual Fund Back Office, Fixed Deposit Back Office including processing, Brokerage, Repayment, Loans, Premature Repayments, Branch Co-ordination, Correspondence and Complaint Handling.

Significant Achievements

Mastered all operational areas of Shares, Debentures and Mutual Fund in very short period of time.Identified the job profile for the entire FD Department.

Played a major role in developing ATC Services offered by the company.

Successfully handled the responsibility of supervising entire Fixed Deposit Department activities.

Assisted accounts departments in audits and finalization of Fixed Deposit related matters for Balance Sheet purpose.

Successfully decentralized six branches for fixed deposit processing & developed instruction manual for the operation of entire FD Department.

Was promoted to Junior Manager in April 1993.

SOFTWARE SKILLS:

Oracle ERP Rel 10.7,11,11i, R12.1, R12.2

Oracle Financials, Manufacturing, HRMS & OFSA

Oracle Products

Oracle Fusion Middleware, Oracle Transportation Management, Oracle Enterprise Manager

Oracle Databases

Version 7.1 – 11g R2

LANGUAGES

SQL

OS

All flavors of UNIX, OEL, Red Hat, Vmware, DOS, Windows 95, and Windows NT.

Reporting Tools

Cognos

ETL

Informatica / JAROS

TRAININGS ATTENDED:

Oracle 10G New Features for DBAs from Oracle- India

Oracle Weblogic / SOA from Oracle - US

Green Belt trained and tested.

PERSONAL DETAILS:

Name Makarand Vidyadhar Vidwans

Address 3697 Thorngate Drive

Mason, OH – 45040

Cell: 678-***-****

Email: acqfjy@r.postjobfree.com

Marital Status Married

Date of Birth July 14, 1970.

Passport No H5978550, Expires on July 28th, 2019 and hold a

Green Card valid till 2024

Contact this candidate