Project Manager

AKHIL MEHROTRA

ADDRESS: * ***** ***** *****: 908-***-****

Bridgewater NJ 08807 Email: **************@*****.***

SENIOR TECHNICAL MANAGER

STRATEGY LEADERSHIP PERFORMANCE

Senior Project Manager with more than 15 years of extensive experience in the Information Technology

field with a deep technical as well as project management background. Possess domain expertise in

business processes in verticals such as; Pharmaceutical, Healthcare, Insurance, Manufacturing, and

Construction as well as extensive experience in application/data mitigation in insurance (Property,

Casualty, ReInsurance). Innate ability to manage off-shore, near-shore, and on-shore teams while

providing support as a solution architect for complex client implementation.

AREAS OF EXPERTISE

Cost Containment Budgeting Experience Process Improvements

Strategic Planning/Visioning Project Management Quality Assurance

Issue Mitigation Operations Management Analytical Thinking

Customer Relationships Innovative Solutions Consulting & Mentoring

KEY SKILLS A SSESSMENT

PROJECT MANAGEMENT – Results driven and proven ability to successfully manage multiple projects from

inception to completion while developing project plans for the management of multiple large/complex

projects and coordinated various areas to ensure projects are completed on time and within budget.

TEAM DEVELOPMENT – Outstanding leadership skills combined with the ability to motivate and train team

members while encompassing an innate ability to communicate effectively leading to the development of

client relationships, business partners, as well as team members.

P ROFESSIONAL EXPERIENCE

CEGEDIM-DENDRITE, BEDMINSTER, NJ 2005 TO PRESENT

SENIOR TECHNICAL MANAGER, IMPLEMENTATION SERVICES

Cegedim-Dendrite is a global market leader in Sales Force Automation (SFA) software specializing in

Life Sciences and Pharmaceutical companies. The company’s flagship product Mobile Intelligence®,

Organization Manager® and OneKey® support sales and marketing efforts. The solution includes a

customer database, customer master solution, CRM/SFA system built using .NET, SQL Server, Oracle,

regulatory compliance solutions, patient persistency programs, relationship marketing programs,

key account management and thought leader identification.

Manage technical and functional project implementation for Cegedim-Dendrite CRM applications for

Bristol Myers Squibb, UCB Pharma, ICOS Pharma, Nabi BioPharma, Savient Pharma, and Altana

Pharma on various projects.

Create and implement SFA solution for Commercial Operations division.

Provide pre-sales support and client product demo for marketing team.

Provide critical technical and product capabilities input to RFP responses.

Manage both offshore and US based team including development, system test and production

support.

AKHIL MEHROTRA – PAGE 1

Oversee several enterprise program initiatives and provide guidance to effective project

management such as timely delivery, risk management, commitment, resource utilization and

budget creation.

Achieved significant increase in client satisfaction in all functional areas as measured in bi-annual

survey.

Help perform major territory realignment and adherence to call plan.

Plan and design data migration on version upgrade for over 2300 tables and 1 billion rows of data.

Design and provide a complete data migration qualification report.

Designed process for regular exchange of customer interactions with multiple joint venture partners

Designed a process for a workflow to interact with a third party eDetailing/presentation partner

Designed a process to compute and display daily call adherence score of user based on call plan

Increased First Call Resolution on help desk calls by over 40% by creating knowledge based and

data portal

Plan, coordinate and execute hardware replacement to field users using cross functional teams

Provide support to sales engineering team during product roadmap, upgrade demo and RFP process

Introduced several improvement projects which standardized processes and reduced error rate by

over 90% and hence achieve greater productivity.

Improved productivity which allowed to provide 25% additional value to Service Level Agreements

(SLA)

Technology: MS Project, Oracle, SQL Server, Sybase, C#, ASP.NET, JavaScript, HTML, XML, DataStage,

Tibco, Sharepoint

AMERICAN REINSURANCE, PRINCETON, NJ 1994 – 2005

SENIOR IT MANAGER (2002 – 2005)

IT CONSULTANT (1994 – 1999)

American Re is part of the global Munich Re group, which specializes in all-lines of Insurance

throughout the world. Its property/casualty Reinsurance division provides treaty and facultative

reinsurance products and services on both a broker and direct basis. AutoFac is an exclusive

quotation, bordereau, and management information systems allow you to manage your entire book

of facultative property and casualty program business and track your exposures online

Project Manager for the data migration phase of a big IT effort ($9 million) to replace the legacy

system with a new state of the art application using .NET, Oracle, XML, ACORD and Web services.

Managed US based and near-shore team on customizing a primary insurance and reinsurance

package which includes ISO reporting, ALIR reporting to various state DMV, annual statements

reporting.

Created a monthly process to send auto insurance coverage detail electronically to 50 state DMV and

receive acknowledgement.

Re-engineering the monthly close process to improve the run time by over 70%.

Designed and implemented an automated process which eliminated 22 manual steps and reduce 2.5

FTE.

Evaluated technologies to decide on Web Services like ESB, XML accelerator, WSDL publisher

Conducted multiple functional JAD sessions to gather requirements and define scope of the project

Designed solution to reduce the data migration timeline by over 40%

Introduced an On-Demand conversion process to reduce overall migration by 57%

Created and managed project plan, timelines, cost and resources

Led logical and physical design sessions and get user signoff and implementation

Technology: MS Project, Oracle, C#, ASP, JavaScript, HTML, XML, DataStage. AS/400, DB2/400, ILE C

HEXAWARE TECHNOLOGIES, PRINCETON, NJ 2001 – 2002

PROJECT MANAGER

Offshore Project Manager for eWise, a proprietary knowledge management and enterprise

collaboration tool. eWise provides integrated functionality of Expertise Management, Team based

Collaboration and Knowledge Document Management within a configurable Knowledge Portal. It is

completely customizable to client requirements. Worked on a business process reengineering (BPR)

for an office supplies manufacturing company to reduce the sales-to-cash cycle time.

AKHIL MEHROTRA – PAGE 2

Technology: MS Project, Oracle, C++, ASP, JavaScript, HTML, MS Access

MORSE DIESEL INTERNATIONAL (AMEC), NEW YORK CITY, NY 1999 – 2001

PROJECT LEADER/SOLUTION ARCHITECT

JD Edwards OneWorld implementation and migration from HP3000. Managed a team of 3

developers and 1 support staff to architect and design a real-time data transfer system to/from

HP3000 and OneWorld. This project used the Business Integration Suite (BIS) by Vignette

extensively

Analyzed, designed and implemented a real-time data transfer solution through various phases

Led and managed a team of developers

Designed and developed a lead tracking database system to capture the detail of proposed projects

Designed an intranet based helpdesk tool for IT admin.

Developed a check printing interface from OneWorld for Accounts Payable department.

Designed a solution to extract payroll information for project job costing.

Coordinated direct vendor contact for troubleshooting, feedback and response

Designed and created job costing and GL feed from GEAC payroll to Cheetah StreetSmart.

Technology: MS Project, JD Edwards OneWorld, Vignette (BIS), ASP, AS400, SQL, MS Access, HP3000,

ILE C, Cheetah StreetSmart

TATA CONSULTANCY SERVICES (TCS), 1989 – 1994

CONTINENTAL INSURANCE, SR. PROGRAMMER ANALYST, NEPTUNE, NJ 1993 – 1994

HOFFMAN LA-R OCHE, MODULE LEADER/SR. SYSTEMS A NALYST, DELHI INDIA, 1991 – 1993

SCOTTISH LIFE ASSURANCE, PROGRAMMER ANALYST, EDINBURGH, SCOTLAND 1990 – 1991

EDUCATION, CERTIFICATIONS, & TECHNICAL SKILL

MASTER OF TECHNOLOGY, Computer Science, University of Roorkee, India

MASTER OF SCIENCE, Physics (Special Electronics), University of Delhi, India

BACHELOR OF SCIENCE, (Hons.) Physics, University of Delhi, India

CERTIFICATIONS

ITIL Foundation 2012;

Project Management Professional (PMP) 2008;

Oracle 9i Fundamentals PL/SQL, Princeton, NJ 2004;

Ascential DataStage Server Programming, Princeton, NJ, 2003;

Ascential DataStage Best Practices, Princeton, NJ, 2003;

XML and Quality of Business Workshop, Swingtide, NH, 2003;

Object Oriented Analysis and Design, ValTech, NJ, 2003;

Introduction to Data Warehouse and Microstratgy, Aptech Worldwide, NJ, 2001

TECHNICAL SKILLS

Language: Visual Basic, .NET, HTML, Java Script, ASP, VBScript, C, SQL

Package: MS Project, Oracle8.0/9i, Visio, Ascential DataStage, Business Integration Suite (BIS) by Vignette,

Web Focus, ERP-JDE, MS Access, DB2/400, Flash, Photoshop, MKS Toolkit, Remedy, ClearQuest

Hardware: Windows, AS/400, HP (UNIX)

Data Warehouse: Multidimensional Modeling, Star and Snow Flake Schema generation

Project Management: Familiar with formal project methodologies – PMI, Agile

AKHIL MEHROTRA – PAGE 3

Contact this candidate