DIPESH MEHTA

IT Project Manager (PMP) Certified Scrum Master (CSM)

Cell 972-***-**** Dallas, Texas acsisb@r.postjobfree.com

QUALIFICATIONS SUMMARY

An accomplished, adaptive Project Manager (Certified PMP, Certified Scrum Master) with experience in managing diverse IT projects including in Operations Environment. Analytical, Results-orientated and demonstrates excellent communication skills. An effective problem solver, a good listener and experienced in managing geographically distributed teams.

Experience working on many packaged application deployments (CRM, ERP) and managing IT Operations environment in Software-As-A-Service Cloud offerings. Strong foundation working as Solutions Architect for Business Intelligence (analytics/ reporting, OBIEE, DAC, Informatica) applications as well as Oracle database technologies in real-time OLTP, ODS and Data Warehouse (EDW) environments.

CERTIFICATIONS & HONORS

Certified Scrum Master (CSM)

Project Management Professional (PMP)

Achieved significant cost savings at a non-profit by Oracle license restructuring

Recipient of Time, Feeling and Focus award at American Heart Association

Recipient of TEAMwork award at American Heart Association

Recipient of Service Excellence award at CITIBANK

Siebel 7 Certified Consultant

Oracle Certified Database Administrator

TRAININGS

Project Management Professional boot camp workshop - PMTI

Certified Scrum Master workshop - Agile Dad

ITIL v3 (IT Infrastructure Library) training.

Data Warehouse Lifecycle in Depth training – by Ralph Kimball

Data Warehouse Dimensional Modeling in Depth training– by Ralph Kimball

Big Data Essentials training – Oracle University

Exadata and Database Machine Administration Workshop – Oracle University

Siebel Administration, ODI, OBIA, OBIEE, Informatica/DAC trainings – Oracle University.

Oracle Database 11g New Features for Administrators – Oracle University

SQL Server 2000 Database Administration training– ExecuTrain/Microsoft

TECHNICAL SKILLS

Microsoft Projects, Visio, JIRA, Oracle Business Intelligence tools (OBIEE), Oracle Database 11gR2, SQL*Server, Oracle Exadata, Oracle Big Data, Enterprise Manager, RAC, Data Guard, Oracle GoldenGate 11.2, EMC, Xiotech, HP High Availability, Oracle tuning packs, Capacity Planner, Quest tools, ERwin Data Modeler, PLSQL, SQL, Python, Perl, Pro*C, C, C++, Java, Unix shell scripting, Oracle Data Integrator (ODI), Siebel CRM Administration, HTTP Server, Oracle WebLogic Server, Tomcat 7.x, Oracle ERP Applications 11.x, PeopleSoft/JDE E1.

EDUCATION

Bachelor of Engineering with major in Computer Science– Top 10 rank holder

University of Bombay, Mumbai, India

PROFESSIONAL EXPERIENCE

Oracle Corporation Aug 2006 – Sep 2015

Project Manager, BI Solutions Architect

Worked in IT Operations group (Provisioning, Fleet Health Management, Change Management and Production Support) engaging with distributed geographic teams. Provided subject matter expertise for the Analytics (Business Intelligence) tier of CRM On-Demand applications running on Oracle database platform. Worked closely with customer care, engineering, performance tuning, automation & operations teams in resolving complex production issues and bugs.

Some of the key projects managed:

Automating the entire provisioning cycle for all tiers of the deployment (database, web, business and analytics). This cut down pod build out time from 4 days to 2 days, reduced human errors and improved consistency across the fleet and increased manageability.

Building ETL performance dashboards for tracking, pro-active monitoring, identifying trends, detecting performance issues in new patches/releases & meeting or exceeding SLA expectations

Building Fleet Health dashboards for monitoring KPIs for various tiers of the operational environment, pro-active monitoring of health of the environments, alerting on threshold breaches, generating fleet-wide reports on heath of individual components within the technology stack.

Building Production Support Corner for adding support related analytical capability on the Operations portal, creating a high level view of the entire fleet (of 200+ pods), with ability to drilldown into each pod and check out recent activity relating to production support, tracking bugs, root cause analysis, emergency change requests, outage tracking records, maintenance issues, maintenance windows/schedules etc.

Data center migration – moving 200+ pods from one data center to another data center, application software deployment and configuration, ensuring that databases were synchronized (utilized GoldenGate), cutover plan, etc.

JP Morgan Chase May 2006 – Aug 2006

Senior VP – Database Services

Oversaw projects relating to roll out of database monitoring suite of tools, database management, performance tuning and production support escalations. Large enterprise environment with RAC clusters, Standby databases and a very large and busy databases including 3TB data warehouse. Team size: 6 DBAs. The environment included best of the breed technology across diverse operating system platforms, database versions, RAC, storage area network.

American Heart Association Aug 2002 – May 2006

Database Manager

Worked full time as a Database Manager overseeing team of 4 DBAs managing all the Oracle and SQL Server database environments catering to applications consisting of intranet, extranet, internet, Siebel CRM, PeopleSoft HR/Financials and Analytics Data warehouse. Initiated, led, managed and completed several projects relating to database and business intelligence work.

Main contributions include: Vendor identification and evaluation for association’s Data Warehouse initiatives; key role in an association wide Data Architecture design initiative for the Enterprise Data Warehouse and MDM projects. I also played a lead role in evaluating/architecting a roadmap solution for integrating key enterprise applications into EDW. As part of the Steering Committee for a new Finance application, evaluated various ERP packages (Oracle vs. PeopleSoft vs. JDE) and conducted detail comparison of Oracle 9i vs. SQL Server 2000 for database platform selection. Worked with the committee to define scope, document requirements and select the ERP package. Led the team to select the implementation partner as well. Followed the process of RFP (Request for proposal), evaluation on proposals, lead the team in creating objective selection criteria. I also worked on data cleansing and deduping product evaluation project. Assessed functional, technical, user impact and cutover aspects of doing a major upgrade to Siebel application environment along with database upgrades. Provided leadership in formulating High Availability, Scalability and Disaster Recovery strategy for the Oracle environment and in AHA’s Business Continuity Plan. Also led the project involving planning and migration of all the Oracle databases to a SAN storage; Oracle installs and migrations; managing all Oracle databases in the Siebel CRM and Analytics Data Warehouse environment. I also managed several projects and DBA services provided by the 3rd party hosting company for entire suite of ecommerce applications, setting up reporting expectations and evaluating database performance weekly.

ERCOT, Cadence, XO Communications, Siebel Oct 2000-Jul 2002

Siebel CRM Consultant

Worked on various consulting assignments focusing on Siebel Admin, Oracle DBA work being a lead technical resource on projects involving Siebel implementation, Siebel upgrades (Siebel 2000), Integration, Application performance tuning on Oracle platform. Worked as part of Siebel Expert Services on Siebel sizing reviews, EIM mapping review, architecture work, performance issues and conducting production readiness reviews.

PageNet, Cap Gemini EY, EDS, Citibank Feb 1992 – Sep 2000

Database Administrator and Programmer Analyst

Doing database administration work as well as Apps DBA work in Oracle EBS environment with various clients. Worked on installs, upgrades, migrations and production support. Experience leading teams of varying sizes up to 5 members. Prior to that worked as a Programmer Analyst on design, modeling & development of global 3-tier client server banking applications.

Contact this candidate