DEBASHISH SARKAR
13199 Sunstone Pointe. San  Diego, CA 92130
Phone: (949) 246 4195 (cell); 
email: [Send email using form at bottom]

Summary

Over 16 years of work experience in multiple environments (Big 5 consulting,
Software development organizations, IT department/Data Center and Outsourcing).
Also have eleven years of prior experience in marketing, manufacturing and Profit
Center Head roles.
=> Expertise in Strategic IT -  Business Alignment, Governance, Enterprise
Architecture, Business Intelligence/ Data Warehousing, Data Management
strategies, Managing Enterprise- wide IT programs to meet Key Business
Initiatives, Adopting and planning for technology trends and innovations,
managing diverse IT teams, Operational & Strategic budget management.
=> Expertise in Tactical IT – SDLC, Business & Information/Data Architecture ,
Infrastructure planning, Business Analysis, Application Design & Integration,
Vendor Management.
=> Project & Program Management – ranging from focused critical initiatives to
global programs for large enterprises.
=> Business/Customer Partnership - Adept at translating Business Goals to
prioritized IT goals with appropriate technology innovation and resourcing,
Business Process Modeling.
=> Previous experience in Manufacturing, Marketing & SGA


Education
Indian Institute of Technology (IIT)
=> 1981 - Master of Technology (Industrial Management);  
=> 1979 - Bachelor of Technology (Engineering)

Technology & Functional Skills 
IT strategy for the enterprise: 
* IT governance - Align & prioritize Strategic Business Goals (Core
capabilities, Enterprise Architecture, Compliance)
* Long term technology strategy & roadmap for transformation of As-Is to a
Business driven To-Be Enterprise Architecture (Oracle ERP, SIEBEL, HCM/HRMS,
SharePoint/ECM etc.)
* Lead strategic Technology Changes ( SOA, Web strategy, SaaS, PaaS, ECM & BI,
ITIL & Global Infrastructure)
* Strategy mapping of enterprise goals & balanced score card to establish
measurable Business driven initiatives.
* Strategic Technology and Solutions presentations for all levels of business
audiences.
Program/ Project Management in diverse industries and scope:
* Hybrid environment (offshore and on-site; contractor & FTE resourcing)
* Various methodologies (SDLC, IBM, PwC, Rapid execution etc.)
* Change management
Data Warehousing/Business Intelligence applications:  
* Financials, Materials (source – Oracle eBusiness), CRM/Operational Knowledge
Management (source- JD Edwards)
* CRM/Pharmaceuticals (SIEBEL as major source)
* Call Center/Contact Center (Genesys, Aspect, Avaya, Intecom)
* Utilities – Financial system. (Codaptix – a multi terabyte environment)
* Energy – E Procurement (SAP EBP) & Financial Consolidations(SAP) 
* Global HRMS data warehouse (Peoplesoft 8; Recruitsoft); Automobile Insurance
data warehouse (Legacy)
Business Analysis & Architecture: 
* Several functional areas in multiple industries 
* Various scenarios - Development as well as Business Transformation Outsourcing
scenarios
Information/Data Architecture:  
* Dimensional Modeling for Analytics & Relational Modeling for OLTP
Applications
* Data integration & ETL Design
* Data governance & Data Management
Leading development of various types of applications 
* transactional, analytical, BI
* relational, object oriented, component oriented, workflow driven, service
oriented, integrations etc.
OLTP applications:
* Supply chain planning, optimization & execution (WMS), ERP, Talent Management,
Finance
* Health Insurance; Process manufacturing 

Technology experience:  
* TOGAF Enterprise / Zachman architecture frameworks; Architecting SOA, mashups
and SaaS solutions(SalesForce, Taleo, Sharepoint platform), Telelogic System
Architect, UML modeling
* Informatica, Brio, Business Objects, Custom OLAP tools, Microstrategy
(trained), Cognos (Trained), Siebel Analytics (Trained), DB2CubeViews(Trained),
MS Analysis Services
* Oracle ERP, Siebel CRM, Agile PDM, ERwin, Designer 2000; HP-UX, AIX, Solaris,
WINDOWS; ORACLE , DB2 UDB, SQL Server 2005, .NET, J2EE; SQL, PL/SQL, Pro*C,
Stored Procedures, Database Triggers, Shell Scripts, Perl, ORACLE Dev Tools
Management/Executive Experience:
* Profit Center Head, Marketing management & Sales ; Personnel management;
Manufacturing, Materials & QA management in subject areas of:
o Hi-Tech(computer systems)
o Engineering ( Electrical Equipments, Arc Welding Equipments)
o Chemicals (Unsaturated Polyesters for electrical engineering applications)


Experience:Independent Consultant – Strategic IT
October 2008 to present
* Design solutions and consulting services on strategic IT initiatives:
* Business Intelligence/Data Warehousing;
* Enterprise Architecture
* IT Governance & Continuous Improvement
* Infrastructure rationalization


Cymer Inc, CA
September 2005 to October 2008* IT governance  – Implement an Enterprise
Architecture framework; develop a long term strategy & roadmap for transformation
of As-Is to a Business driven To-Be Enterprise Architecture
* Work with a cross functional Business, IT and Senior Executive team to align
the IT strategy to a portfolio of strategic business initiatives.
* Lead an enterprise wide Analytics program to assist in meeting the enterprise
goals.


PwC/IBM, CA (clients include Allergan, Aventis, Gateway, HP, Informatica,
Marathon Oil, PG&E, Qualcomm & Sprint)
June 2000 to August 2005

* Project Management (including Program Management)
* Design & Lead  Data Warehousing, ETL, Integration
* Data Modeling & Data Architecture; Application Architecture
* Business Analysis & Strategy development
* Strategy mapping and Balanced scorecard
* Technical Support for Sales and Recruitment 
KPMG, CA 

KPMG
July 1999
to June 2000

Professional Services “DEMAND CENTER” Supply Chain Execution application 
* Lead a re-engineering project for the distribution center of a large engine
manufacturer.  
* Re-architecting the supply chain process, application and integration
* Managed the implementation life cycle
* Lead the change management process ( including training)
* Env: ORACLE/UNIX, ORACLE Forms4.5, Shell scripting, PL/SQL, and Database
Triggers, CCC/Harvest.

OPTUM Software, CA
Aug. 1997
to July 1999
DEMAND CENTER SUPPLY CHAIN EXECUTION SOFTWARE  - a configurable system  and
interfaces with Legacy systems and RF Terminals
* Project & Technical Management for projects consisting implementation &
integration.
* Business Analysis across Retail and Consumer Products industries 
* Configuration of a warehouse for the functions of: Appointments, Receiving,
Cross-Docking, Order Management, Putaway, Picking & Replenishment, Kitting,
Consolidation, Packing, Manifestation, Shipping, Host Interface.
* Analysis, Design, Data Architecture and Development of specific components as
follows: Outbound profile:  a customized enhancement to achieve high volume flow
through a warehouse with a large number of products and order lines by
predetermining a profile designating a 'route' inside the warehouse on the basis
of shipping attributes, delivery time attributes, product attributes, order
delivery destination attributes
* Design interfaces with ERPs (SAP), Legacy Systems and Manifesting systems. 
* Led revision control management using CCC/Harvest.
* Special Techniques: Extensive use of PL/SQL tables.
* Env: ORACLE/UNIX, Dynamic SQL, ERwin, ORACLE Forms4.5, Pro*C (Embedded SQL),
C, Shell scripting, Perl,  PL/SQL packages & procedures, , Database Triggers,
Developer 2000 (Forms 4.5) user interfaces.


Oxford Health Plans, CT 
Oct. 1996 
to Aug. 1997PULSE SYSTEM – a Member Enrollment subsystem:
* Data Architecture – Physical and Logical data modeling, functional
specifications, DFD. 
* Design & Development of User Interface (in the FORMS 4.5 environment). 
* Design & Integration of Enrollment from acquired businesses (Pro*C interface;
UNIX files). 
* Special Techniques: Dynamic SQL (Method 4).
* Environment: ORACLE/AIX, Developer 20000 (FORMS4.5), PRO*C, DESIGNER 2000.

Blue Cross, Canada 
May 1996 
to Aug. 1996

MEDICARE SYSTEM - Subsystems/modules (Invoices & Service catalog) of Medicare
(MATS) 
* Design & Development of User Interface (in the FORMS 4.5 environment). 
* Data Architecture 
* Implementation of various modules. 
* Quality assurance for various modules. 
* Special Techniques: Resolvers: a standardized called form for resolving
complex selection for an attribute in a form. Versioned tables: timed objects.
* Environment: ORACLE/HP-UX/WINDOWS NT Developer 2000(FORMS 4.5)/Designer 2000.

Rotomac Electricals Pvt. Ltd., India 
May 1991
to May 1996
FACTORY MANAGEMENT SYSTEM (In house application development)
 The factory management system consisted of five basic modules: A Production
module consisting of logging process parameters and events of a production batch,
analysis of batch performance, production planning. An Inventory module consists
of receipts, issues, stock, raw material planning. A Dispatch module consists of
dispatch documentation and billing. A Purchase module consists of purchase orders
and monitoring deliveries. A Quality Control module consists of quality approval
of incoming materials, products & intermediates and new vendors.  Interaction
with users - Data modeling along with E-R models and Function modeling requiring
approval by the users. 
Data Architecture – Logical and Physical data modeling
* Data Architecture – Logical and Physical data modeling.
* Database building - built the tables along with the data integrity
constraints, views, indexes and sequences. 
* Application building – GUI screens and Reports

PRODUCT COSTING/MATERIAL PLANNING (In house application development)
Three independent modules to address urgent requirements as follows: 
* Product costing - Computing product costs on the basis of raw materials cost
and overheads on a monthly basis. 
* Raw materials planning - Raw material quantity planning and budgeting for the
coming 6 months.
* Debtor's analysis - Debtor's statements along with age.