Project & Program management, Application Development

SAM MOHANTY, MBA PMP Tel: 1-201-***-**** e-Mail: **********@*****.***

CERTIFIED PROJECT MANAGEMENT PROFESSIONAL ID: 1570677

EXPERIENCE SUMMARY:

• Information Technology & Business Management (Project & Program) professional with extensive (25+ years) experiences in project implementation and execution in Application development, Infrastructure Services, Testing Phases, Security & Business Process.

• Roles include Project & Program Manager, Partner, Director, Technical Architect, Business Analyst, Tester, Functional & Technical Subject matter expert and Developer.

• Responsibility covers full process and project life cycle, vendor & third party contract negotiations, procurement, strategy and support of Global development, implementation and operation.

• Expert Knowledge of Project & Program Management & Software Development Life Cycle methodologies, Internal IT standards and financial processes.

• Intermediate approach (2+yrs) to Cloud Computing (SaaS, PaaS & IaaS)

• Covers Transitioning, Transformation, Merger, Acquisition & Divestitures (2+).

• Phenomenal interpersonal, relationship & leadership skills with the ability to manage large geographical or functionality dispersed teams both on-site and offshore.

• Provide Technical and Functional guidance and knowledge including Change and Configuration Management.

• Well recognized outsourcing and offshoring capability. Experience involves both insourcing as well as transfer of technology and development from outsourcing partner to other overseas partners.

• Certified Project Management Professional (PMI) & ICE (Novartis), Cognos & PeopleSoft technical & functional expertise on HR & Financial modules

• Subject matter expertise in Data management, Data Integration, Data & Visual Analytics, Data Warehousing, Business Intelligence & Competitive Intelligence.

• Data Warehousing, Business Intelligence, & Web Application specializing in Cognos Impromptu and PowerPlay for 7+ years, Hyperion Performance Suite 8.,Essbase 7.1, Analyzer 7.2 for 3 years, Microstrategy for 2 years and ERP Consultant specializing PeopleSoft& Aeon both technically and Functionally on, Financial and HRMS Modules for 2 years

• Business Reporting, Business Analytics & Business Visualization Responsibilities.

• Industry experience includes Pharmaceutical (8+), HealthCare (5+) years, Manufacturing (2), Insurance (8), Education (2), Banking & Finance (5) & Food (6M)

• Key member of the IT PMO determining project impact analysis, priorities, mentoring, advisory services and framework for delivering new projects.

• Negotiated & Rewrite third party service level agreements and vendor contracts over 150 m USD.

• Several past years’ experience in logical and physical database design and implementation. In-depth knowledge of Oracle server and client tools.

• Strengths includes adaptability, resiliency, curiosity and leadership skills

• Excellent Communication, Problem solving, Troubleshooting, inter-personal skills and a team player.

TECHNOLOGY:

Project Management PMP- Project Management Professional (PMI certification), ICE – Novartis IT Project Management Methodology (Bronze & Silver Star), Schering Plough Microsoft Solutions Framework Manager, Kimball Data warehousing Methodology, CMMI, Summit Methodology and Information Mapping - policy, procedures, and documentation developing program. Agile Project Development with Scrum Process, PROJECTOR 4.3 Project Management Tool, IBM Rational ClearQuest for Workflow and Deliverables with Milestones.

Process Improvement. CMMI (Capability Maturity Model Integration) principles and approach,

Model TQM (Total Quality Management)

Six Sigma (Green Belt)

Lean Six Sigma & Minitab

Business Analytics: SAP Talent Insight, HR Analytics, Sales Force Analytics, Compensation Analytics, Learning Analytics among other modules

Business Intelligence SAP – Online Report Designer, XpressWriter with SQL 87 (HBOC) and SmartLink 2000 - product of Velox/Quadramed. Other Multidimensional reporting tools includes HR Reports, PeopleSoft Supported Reporting Tools nVision, Crystal Reports Pro for Windows, MITI’s Structured Query Report (SQR), SQL Talk and Cognos (Impromptu, Power Play, Visualizer, Metrics Manager and ReportNet) & Business Objects.

DataWarehousing: Hyperion Performance Suite 8.3 includes Intelligence and Dashboard Builder along with Essbase Analytic 7.1 and Analyzer 7.2

Microstrategy

Cognos – ReportNet 1.1, Impromptu 4.0,5.0,6.1,7.0 Power Play Web 5.0,6.0,6.5,6.6, 7.0, Power Play Enterprise Server 6.0,6.5,6.6, 7.0 Impromptu Web Query 2.1, Impromptu Web Reports 5.0,6.0, 7.0, Visualizer 7.0, Access Manager 7.0, Netscape Directory Server 2.1, Portfolio and Upfront 7.0.

ActaWorks - Extraction, Conversion, Transformation and Loading tool.

ERP Packages SAP HR SuccessFactors – Goal & Performance Management, PeopleSoft 7.0 - Introductory Course, PeopleTools 1 and 11, PeopleCode, Query, SQLTalk, Process Scheduler, ImportManager/DataMover and SQR on both Three-tier and Two-tier systems. Functional aspect includes Financial Modules- General Ledger, Accounts Receivable, and Accounts Payable. HRMS Modules include Human Resources, Payroll, and Time & Labor.

Web Application: IBM Portlet Factory & Spring Technology Framework

Defect Management: IBM Rational ClearQuest (Bug tracking & Workflow automation)

Languages SQL, SQL + and PL/SQL

DataBases Oracle7&8, DB2, MS Access, MS Excel and HBOC systems

GUI’s Developer 2000, MS PowerPoint and Application Designer - PeopleSoft

Billing Systems LaserArc - DataBase of Historical, Current Statistics & Trend Analysis.

Biller’s Workbench - Billing, Designing UB’s, Statistics, Input and Analysis of Per Diem Payments, Contracted Amounts, and DRG amounts.

Quadramed - Electronic Submission, Eligibility, coverage, Managed Care and Contract Analysis. Quadramed is the licensee holder to the databases of major Health Care Insurance Companies such as Medicare, Medicaid, and Blue Cross, Aetna etc.

MedeAmerica: Historical Data Base for all major Health care Insurance Companies including pre-admission certifications, pre-authorizations and eligibility.

Operating System Windows 95, Windows NT, Windows 2000, MS-DOS & CMOS

Software’s Lotus 1-2-3, Dbase IV, Professional Write, Act, Word Perfect MS Office Works 97- Word, Excel, Access, PowerPoint, OneNote, Outlook and MS Project.

Information Systems SMSnet, SAINT, KDS, MCIS and Gaffe - Medical Network Systems

K-Comp and KEAN - Both Dental and Medical Network systems

RUMBA - Merck Information A/R system

SHARP - Sharp electronic database management network system

BCBS, Medicare & Medicaid Terminal Processors and MedeAmerica

Data Design Tools MapInfo, BPWin, Erwin 3.5.2 and Visio 2010 Professional.

CERTIFICATIONS: Project Management Professional (Project Management Institute) 2013

Accounting (New Jersey Board of Accountancy) 1987

Evaluation of MBA credentials at Board of accountancy: 188 US credits

Application Development using Oracle 7 *.

Implementation, Panel Designing and Queries using PeopleSoft.

Cognos Certified Impromptu and PowerPlay Professional.

EDUCATION:

Bachelor of Commerce, Ravenshaw University 1984

Masters in Business Administration, Orissa State University. 1987

Pre-requisites program in Law and Computers at William Paterson Univ., NJ 1989

HBOC Systems - Both as an Administrator, Trainer and User Certification 1996

Oracle 7. * At Pinnacle Systems, Inc. NJ 1997

PeopleSoft: PeopleTools, SQR, PeopleCode, SQL, Nvison, Crystal Reports 1998

PeopleSoft: Functional knowledge of Financials and HRMS 1998

Cognos - Advance reporting and Designing of PowerPlay 6.0 1999

ActaWorks - SAP DataWarehousing extraction tool 1999

Data warehousing Lifecycle Toolkit – Kimball University 2003

Microsoft Solutions Framework Essentials @ Microsoft Corp 2004

CMMI process improvement training @ ACS 2006

Six Sigma Green Belt Training @ Avtech Institute of Technology 2011

Lean Six Sigma & Minitab @ Avtech Institute of Technology 2012

PMP – Project Management Professional Training @ Avtech Technology 2012

ICE – Novartis IT Project Management Methodology (Bronze & Silver Star) 2013

SAP HR SuccessFactors – Goal & Performance Management (Self) 2015

WORK EXPERIENCE:

Client: Mars Inc, 100 International Drive, Mt. Olive, NJ 07828

Role Sr. Project Manager

Duration Jun 2015- Present

Payor: eTeam, 100 International Drive, Mt. Olive, NJ 07828

Managing the re-launch and process-engineering initiative for all Agency Performance Reviews, Goals & Objectives Management Program – Includes Business Functions (Process), People & Technology (SAP HCM HR SuccessFactors). Lead Marketing (Business & IT), Media Planning & Advertisement (MediaCom) & Creative Agency Group (BBDO, DDO & others (675) establishing Project Management framework.

• Business Process: Re-launch goals & performance review of both creative Agency & Media Advertising Agencies and in reversal of Agencies Review of Mars as “Client of Choice”

• Technology: Introducing & Implementing ARMS (Agency Review Management Platform). Creation & Preparation of SOW to outsource the development of ARMS. Addressing contracts, licensing, legal, ownership and SLA with Mars (Operations) & Vendors (Hrizons).

• PMO: Laying down the framework and structure for all new projects.

Special Achievements:

• Design and Development of ARMS website using SharePoint Collaboration Tool and using “Yammer” as the communication tool of choice.

• Proof of Concept using Dashboard 2.0, SAP BW & Business Objects including Online Report Designer & Talent Insights for Analytics.

Client: Bristol-Myers Squibb, 777 Scudders Mill Road, Plainsboro, NJ 08536

Role Technology Manager (Program Manager with ISC)

Duration Mar 2015- Jun 2015

Payor: SCS Marketing, 1000 Wyckoff Ave, Mahwah, NJ 07430

Promotional Management, Event Management & Digital Marketing Business Process outsourced to HealthStar for Sales & Marketing Initiatives. Technology Lead for this Planning phase. Addressing all technology integration, procurement, development, testing, transition and transformation as well as the client interface between the business & technical teams (33 third party vendors).

• Joint Requirement Design & Development Session. (JAD & JRD)

• Infrastructure Services: Co-Ordination of all licensing agreements, SLA’s, vendors, architecture and procurements.

• Business Analysis: Framework on Requirement Documentation: BRD, FSD, Reporting, Analytics, Configuration & Software architectural document.

• Development: Prototype, Proof of Concept & Development.

• Testing: Strategy & Planning all phases of the testing cycle including performance.

• PMO: Setting up standards for all templates and technology processes for HealthStar including scoping, scheduling & project planning for all leads.

Special Achievements:

• Assisted BMS in running their Business Process Requirements gathering.

• Training: Contract extension to complete the training initiative and environment.

Client: Novartis Pharmaceuticals Corp, Bldg 105, 180 Park Ave, Florham Park NJ 07932

Role Sr. Project Manager III (Program Manager with ISC-DISYS)

Duration Apr 2014- Mar 2015

Payor: DISYS (Digital Information Systems) 1 Evertrust Plaza, Jersey City 07302

Gemini Program representing PMO on a merger & acquisition, transitioning & transformation execution with IBM replaced by Novartis (L3 & L4) and HCL Technologies (L1 & L2). Project Success measured on 1) Staffing 2) Training 3) Documentation 4) Applications 5) Tools & Technology 6) Reporting – Contractual and Operational 7) Hyper Care 8) Knowledge Transfer & 9) Process Engineering

Project I: Disaster Recovery, Business Continuity & Resilience Services: (Atlanta, GA)

• Application Development: Development & Implementation of a Content Management Tool (SunGard Assurance) to host Disaster Recovery and Technical Recovery Plans as well as Business continuity models .(500+ applications )

o Project Charter & SOW: Comprehensive preparation includes scope milestones, deliverables, schedule and budgets.

o Planning: Team Formation, Tool Selection and Project Guidelines.

o Includes SasS (software as a service & PaaS (DR Platform)

• Infrastructure Service: Completion of Transition and Transformation of Critical Applications only.

• Project Attributes: 1) Staffing & Recruitment (38 resources) 2) Training (80 docs) 3) Documentation (103) 4) Applications (1) 5) Reporting – Contractual and Operational 6) Hypercare 7) Knowledge Transfer

Project II: Unix/Linux Services: (Fort Worth, TX)

• Application Development: Development of a Monitoring Services & Capacity Planning Tool (LPAR2RRD)

o Project Charter & Scoping: Development & Execution completed. Working on Handover and Knowledge Transfer.

o Planning: Team Formation, Tool Selection and Project Guidelines.

• Infrastructure Services: Completion of Phase I transition and transformation.

Special Achievements:

• Complete Project Management responsibility and accountability from start-up to completion utilizing industry best practices and current Novartis methodologies and tools.

• Compliance to the ICE methodology and other relevant compliances like Customer Expectations, GxP, SoX, GIS/IGM/Novartis Processes and Procedures etc, where applicable.

• Collaborate with Security, Compliance and Legal, ensuring proper project governance and controls.

Client: Novartis Pharmaceuticals Corp, 1 Health Plaza, East Hanover, NJ

Role Sr. Project Manager III (Program Manager ISC-Redtoo Inc)

Duration Sept 2013- Mar 2014

Payor: RedToo Inc 26 Columbia Turnpike, Suite 102, Florham Park, NJ 07932

Representing GIS-PMO, at a multi-stream engagement, on a leadership and project management role as projected below:

Project I: Alcon Integration Project: Member of the Mergers, Acquisition & Divestitures team evaluating and moving of acquired IT infrastructure, human capital, and applications of acquired base to IT hub.

Project II: Catalyst Project: IT Security baseline Study: Lead a team of IT security experts (12) to conduct a GAP analysis, Impact statement, Feasibility Study and a Rough order-of-magnitude estimation for IT security baselines remediation and configuration to be mandated in 2016. (All Critical Service Lines hosting critical applications)

Project III: Prepared and presented new statement of work for Novartis to provide a confirmed order-of-magnitude, proof of concept and a final estimation. (Under review)

Project IV: Exploration of an additional SOW for conducting a study for the remaining baselines. (Awaiting approval from the steering committee)

Project V: Created SOW to execute and implement industry standard baselines based on the gap analysis, findings and feasibility. (Lead Member of the Bidders conference and project)

Special Achievements:

• Ensure compliance to the ICE methodology, GxP SoX and other GIS/Novartis Processes and procedures as applicable

• Novartis mandates extensive training (27) and competency tests (16) in Project Management, Risk Assessment, Document Management, Exceptions and Deviations, Business Impact Management, Data Privacy, Risks, Regulatory & Compliance as well as complex Standards operating Procedures.

• Member of the vendor selection committee for a new IT security configuration process, service and technology initiative.

• Big Data Project: Member of an exploratory committee for strategy and pre-planning initiative for Big Data, Predictive Modeling and Analytics.

• Additional Project(s) involves integration of potential acquisition to IT Hubs.

• Responsibility includes Approval authority for all Documentation, finalizing SOP, and Configuration Manuals. Knowledge Transfer (Training and Replacement) & Sign-off process.

Client: Royal Bank of Scotland “RBS Group”

Role Program Manager (Project Director with LinkISC)

Payor LinkISC, 245 Willesden Lane, Willesden Green, London NW2 5RY

Duration May 2013- Aug 2013

Led team for multiple project initiatives. Effort included costing and budgeting for Data Warehousing (DW), Business Intelligence (BI), data integration (DI) and analytics both tactical and strategic solutions. Functional area includes all data related to feed Customer Relationship Management Systems (CRM)

Special Achievements:

• Execution, design, development and deployment of DW/BI tactical solution across.

• Big Data: One of only 3 bidders invited to provide strategy, overall cost and presentation. (Predictive Analytics & Data Mining included) for Phase III and IV.

Client: BNP Paribas,

Role Program Manager (Project Director with LinkISC)

Payor LinkISC, Pinnacle House, A1 Barnet Way, Borehamwood, Herts WD6 2XX

Duration Sep’2012-May 2013

Technical, Project, & Process Management Advisory Services on securing project and client. Participation on the Bidding Process & RFP. Includes mentoring PMI methodology to both internal and contractors. Part of the pre-sales team awarded upgrade application development and infrastructure projects. Projects currently being worked on:

Special Achievements:

• CG Infrastructure Upgrade Project: Phase I valued at 125K GBP & Phase II at 750K GBP). Team consists of 1 project manager, 3 project leads, 2 onsite architect and 2 developer as well as 6 offshore resources

o Decomposition of the migration plan to include all environments and configuration.

o Operation manual and documenting all procedures and functions.

o Finalizing Backup strategy and disaster recovery documentation and configuration.

• FSA Landscape Application Development Project: Phase I T&M contract up to 100K GBP. Phase II of application development valued at 500K GBP.

o Finalizing functional specifications, project walk through, and signoffs.

o Addressing the change request with the steering committee and change management board.

Client: Horizon Blue Cross & Blue Shield NJ, 3 Penn Plaza, Newark, NJ 07503

Role Sr. Project Manager for Application Development

Payor IBM Corp (Prolifics) 114 W, 47th St, NY, NY 10014

Duration Feb’2012-Aug’2012

Initiated, Planned & Executed multiple turn-Key Solutions for Web Portal Application, Web Analytics, BI Reporting & Portal Projects in conjunction with IBM Product Integrators unit. Activities included SOW, RFP reviews, bidding, Estimations; Planning includes scope, cost, schedule and resource, and final proposal. Tasks include leading the project with onshore-offshore delivery model, SDLC development, Agile process methodology and profit and loss responsibility

Special Achievements:

• Group Admin Portal Development: (Phase I valued at 1.1 million USD & Phase II at 300K USD) member portal web and visibility application portlets. Team consists of 3 onsite architect and developer as well as 9 offshore resources

• National Cost Estimator Tool (450K USD) web application projects as well as operations and production support (Dec 2012). Team includes 2 onsite and 5 offshore resources)

• Patients Review of Physician Portal Application: (Valued at 550K USD): Team consists of 4 onsite and 3 offshore managing external vendor resources.

• PSE&G: (Valued at 335K USD) Additional contract awarded for customized web analytics and portal application tool.

• Out of Pocket Application (built but on hold): RFQ reviews, Planning, Resource Requirements and Proposal.

• Proof of Concept for implementing IBM Mobile Technology IBM Connections & IBM Security Solutions.

• RFP worked on Deloitte (EVMPD project Regulatory), Merck (Clinical Financial Services) and Halliburton projects (construction).

• Advisory Services: Contract with Horizon offering Best practices on Portal Development, Web Applications, Rapid development best practices, Documentation and Process Integration based on Lessons learned. (35K)

• Deployment & Build Strategy customized to Horizon processes and policies.

• Facilitate handover, knowledge transfer and project documentation to offshore primary vendor (Sept 2012)

Client: America Asia University

Role: Project Director

Payor International Systems Consulting, Inc – 30, Staverton Road, London NW2 5HL UK

Role Sr. Managing Consultant–IT Project Management and Business Development

Duration May’ 2008 – Jan’2012

Principle and key stakeholder in a distant e-learning Online Startup for America Asia University, SOA University and Georgia State University. Responsible for all Technology Initiation, Planning, Execution Implementation, Design, Strategy, Procurement, Contracts, Development, Testing, Operation and Support

Special Achievements:

• Transitioning Operational Development, Support & Maintenance to Maasys, India.

• Setup Development center in Tbilisi, Georgia and Orissa, India (closed and moved to Georgia)

o Roadmap, Strategy, Priorities, Phased Solutions including Cost, Schedule and Scope.

o Proof of concepts and tool selection with e-Learning solutions, course management systems, data warehousing, Business Intelligence, ERP and customized portal applications.

o Developed prototypes and showcase project and products for potential stakeholders.

• Responsible for Setting up 1000 sq ft data center, computer lab and hiring of key personnel for IT outsourcing project.

• Tasks include Outsourcing and off shoring of Infrastructure, Hardware, Software, Networks, Desktop Support, Databases, Call Center and Help Desk support.

• Project ran parallel with the Novartis projects, overlapped at most times during this period. Meeting stakeholder’s expectations and key objectives adding profits and new business to firm highlighted my career.

Client: Novartis Healthcare, Sandoz House, Dr. Annie Besant Rd, Worli, Mumbai 400018

Role: Program Manager

Payor International Systems Consulting, Inc – 30, Staverton Road, London NW2 5HL UK

Duration Oct’ 2008 – December’2011

Headed multi-streams subcontracted SOW in conjunction with primary contracted stakeholders for Clinical Trial Phase II-IV as below. Responsibility included contract negotiations, business development, and management for turn-key solution on a full project life cycle development. Key Deliverables included project scope, cost & schedule, procurement, quality, resources and priorities. Communication included single point of contact stakeholder’s expectations, status and progress report included work performance reviews for all JV.

Special Achievements:

• WebEDI Phase I: JV with Polaris Software Lab Ltd. (Valued at 292K). Design, develop, Test & deliver WebTop based components for Alert management and Content Management system with FDA as primary stakeholder. Team of 4 developers, additional resources included testers, designers, and architects.

• WebEDI & MPV Phase II: JV with Cognizant Technology Solutions (Valued at 545K). Provided training and skilled staffing to projects which included document management, clinical systems, web analytics, reporting and service delivery for moving to production.

• WebEDI: T&M contract for support and maintenance for Phase III and IV clinical trials. Support included Pre-OQ, OQ & PQ support and knowledge transfer.

• Managed and Directed project activities, planning, staffing, training, recruiting. Transitioning, Operations & Development at offshore center at Maasys, India.

Corporation Avtech Institute of Technology (PMI certified vendor) in New Jersey, US

Client: International Systems Consulting, Inc

Role Project Management Training

Duration Jan’ 2012 – Sept’ 2012

Completed a full time PMP (Project Management Professional) Training Program at the AVTECH Institute of Technology based in New Jersey. Avtech is an approved and certified vendor for Project Management Institute (PMI) Course work includes: All 9 knowledge areas as well as 5 Process groups.

Role: Six Sigma Green Belt Training

Duration: Sept 2011-Jan 2012

Completed training for Certification for Six Sigma Green Belt (CSSGB). Syllabus includes DFSS, Lean and Process management. Tool used: Minitab

The breadth and depth of the subject matter studied is aligned with ASQ’s Six Sigma Body of Knowledge (BOK) and is presented as such. For further information, http://www.asq.org

Client: Chubb Insurance Corporation – 15 Mountain view Rd, Warren, NJ 07059 USA

(Stakeholders include Chubb, PWC & ACS, Inc)

Role Senior Information Technology Manager – Data warehousing, Business Intelligence and all Reporting and Analytics solutions for other towers such as Workforce PlanSolutions, PeopleSoft, SumTotal etc

Provider AFFILIATED COMPUTER SERVICES, INC (Xerox Corp)

Duration Apr’ 05 – Apr’ 08

Responsibility of full management and delivery of a Global Data warehouse, Global Business & Competitive Intelligence Reporting, Predictive Modeling, Analytics System, Executives Decision Support System & Solutions for all major Functional systems such as Claims comprising of Health Insurance, Life Insurance, and Property & Casualty. Other DSS include Talent, Learning Management System (SumTotal), Performance Management, etc. Data warehouse includes Interfaces to corporate vendors such as Goldman Sachs for bonds etc.

Responsible for Assessment, Initiation, Requirements, Planning, and Developments of a Business and IT Strategy. Role includes Evaluation, Design of the Infrastructure, Architecture, System, Costing, Statement of Work, All Phases of Testing, Quality Assurance, Transition, Change Control, and Critical care, Operational Readiness, Post-Production Support and Production.

Deliveries include Disaster recovery, business continuity, configuration management, backups, high availability, Mainframe, Legacy decommissioning plans and deployment plans.

Special Achievement

Management Responsibility

• Overall Budgetary responsibility of 40 million USD and a team of 52 including 8 project managers globally reporting to me.

• Senior member of both the Chubb and ACS HR & IT Governance team.

• Responsibility includes timelines, scope and budget for all consulting companies.

• Business Intelligence consists of dashboards, score carding solutions with geographical mapping, scorecard, OLAP analytics and reporting solutions.

• Implementation using CMMI guidelines and MS project management methodology for the software development lifecycle cycle and Kimball Data warehousing principles.

Technical responsibility includes:

• Proposal, Review and Assessment of the deliverables for the Outsourcing partners.

• Project Planning & Deliverables for the onsite-off-shore Teams in US, India, Malaysia and China.

• Data warehousing Project consists of interfaces to 19 different point solutions for both External and Internal vendors.

• Capacity Planning and Execution for DW/BI/DI/Analytics and Predictive Modeling.

• Strategy for Disaster management, Backups and Change management.

Functional responsibility includes:

• Key member of Products and vendor selection committee for Chubb and ACS.

• Member of the Executive committee to identify key metrics for ROI for all aspects of a Human capital.

• Establishment of a Help Desk, Training center and Extension of the Call Center to include Data Management, Business and Competitive Intelligence.

Relationship responsibility includes:

• Single handedly responsible for building and stabilizing relationship between clients and vendors.

• Identifying and Initiating new and existing business.

• Proof of Concepts to 17 corporations and departments authorized by corporate leadership Chubb & Sons.

Corporation Schering-Plough Corporation (Merck Pharmaceuticals)–Kenilworth, NJ USA

Role Senior Project Manager – Business & Competitive Intelligence Applications

Duration Apr’ 03 – Apr’ 05

Project Manager for the creation of an EIS (Executive Information Systems) for supporting the Sales and Marketing executives using the Cognos Suite of Tools including Report Net 1.1. Various Phases involved rolling out to 600 senior executives in the US and Global market. Other Support includes Analytics for Pharmaceutical Business unit reporting to CIO and Sales & Marketing VP. Responsibility includes strategy, planning, architecture, sales reporting, data collection, and business analytics.

Special Achievement

• Developed data integration, analytics, data mining and reporting strategy for US Sales/Marketing data warehouse, supporting Data Mart analytics, Data Mining, feed to SFA, CRM using NDC and IMS as well as internal sources using AbInitio, Cognos Suite including Report Net 1.1 and MicroStrategy.

• Developed data marts for Performance metrics pull through analytics, Executive Information (EIS dashboard) and Managed Care analytics at the field force laptops.

• Integrated sales force automation and DSS system to support over 3500 sales reps, with managed care reporting driven by IMS/NDC data warehouse processes.

• Led the architecture, integration, development and implementation for corporate and multiple clients on the Data warehousing and Business Intelligence environment.

• Evaluated, negotiated, proof of concepts of various products for ETL, Performance Management, Metadata, LDAP servers, Web Portal Servers, common Interface security, Report usage, Telecoms, PDA’s and Database products.

• Managed and directed multi-disciplinary team of 12 people with an approved budget of 2 million USD and 6 million USD for capital expenses.

• Responsible for hiring, team building, performance evaluation, scheduling and mentoring resources.

• Led the division in strategic planning, leadership, PMO and line management.

• Designing and Implementing a Web Portal and Users interface for security and tools deployment.

• Steering committee member for Policy and Procedures, Work Review Log, Change Management, Project Initiation, and Training procedures.

• Business Development, Pre-Sales as well as Proof of Concept effort in Leading the group along with BI vendors in developing the prototypes on Cognos Suite, Business Objects, Information Builders, Micro strategy and MapInfo.

Corporation

Contact this candidate