Mohan Chandra Email & Phone Number

Plainsboro

• Worked as a System Manager and a Solution Architect for three separate systems
• led the team in designing ETL and dashboards for ORION and Connex BI application.
• Expertise in analysis, design, development, customization, and implementation and testing of software applications and products.
• Demonstrated expertise in utilizing ETL tools, including Data Transformation Services (DTS), Informatica, DataStage and ETL package design, and RDBM systems like Oracle.
• Strong… Show more
• Strong leader in coaching and developing talents

Princeton, NJ

Support for CRM application used by 3000 salesreps on the fieldSME for application support and enhancements, liason with business stakeholders, Re-engineeting and analysis of the current processes, recommendations for process improvements and automation, performance tuning of the application, business analysis, GxP system validationManaging chanage.

Morristown, NJ

Client: Warner Chilcott Pharmaceuticals, Rockaway, NJGoal: Application migration from Dendrite CRM to SiebelResponsibilities:Led the Data migration team (onsite + offshore)Responsible for designing data migration activities and interafacesResponsible for Product setup, Siebel Administration tasks and automationResponsible for system analysis, fuctional gap.

Morristown, NJ

Client: Connectics-Stiefel Pharmaceticals, Palo Alto, CA.Goal: Integration of Connectics and Stiefel Pharma Siebel Life Sciences applications into prevailing applicationResponsibilities:Analysis of short term and long term solutions to support the new organizationResponsible for Data migration strategy and implementation.Designed and developed EIM.

Titusville, NJ

Goal: Support Johnson & Johson Siebel Life Scienes applicationResponsibilities:Siebel Adminstrator for 26 Application servers in Production supporting over 7000 remote users of multiple companies under J&J umbrella.Support for OS upgrade of the application servers with minimal downtime and impact to the field usersInstallation and patches for Siebel.

Lincolnshire, IL

Goal: Siebel Architect for upgrade and enhancementsResponsibilities:SME for Siebel enviroments Installed and configured high availability environments for Siebel applicationInstalled and created Production, Stage, Test, development and training environmentsResposible for suporting 1800 remote usersDesigned and Administered Workflows, Assisgnment manager.

San Francisco, CA

Goal: Support JP Morgan H&Q Siebel financials applicationResponsibilities:Data Migration from Legacy systems to Siebel base tables using EIM.Siebel application configuration using Siebel Tools to create applets, views and screensCreated VB Scripts for data validation and custom functionsData transformation between Siebel base tables and external systems.

Emeryville, CA

Goal: Implementation of Siebel CommunicationsResponsibilities:Data migration from Remedy systems (BOSS) to Siebel base tablesMapping and idenfying gaps and resolutionsConfigured to enhance the functionalities using Siebel ToolsInterafaced with middleware (Vitria) for data exchangesCreated workflow policies and assignmentApplication tuning for.

Dallas, TX

Goal: Powerbuilder front-end and Oracle bakend developmentResponsibilities:Oracle Schema creation with front-end screen developmentPowerbuilder screen development for point-of-sale and invetory management applications

Mumbai, India

Client: GE Chemcial & Polymer Group, Charlotte, NC (Sept 1997 - Dec 1997)Goal: Implement Order Management system (System ESS)Responsibilities:Data migration from Legacy mainframe systems to Client server systemCreated COBOL, JCL scripts to extract the dataData cleansing and validationGap analysis and resolutionsCreate scripts to push data into System.