Dy General Manager (Marketing Services )
Skills
TOGAF, GIS, SAP Business Intelligence, ERP, SAP, Oracle Database, SAP BI, Web Technologies, Microsoft platform, Windows Server Internet Information System, ASP, net, Enterprise Architecture, collaboration tools, LinkedIn, Master Data Management, Optimiser modelling Enterprise Architecture, Alfresco Enterprise, Geographical Information, ARCGIS, ESRI, ARCGIS Maps, Data modeling, content management, ETL, SAP ERP, Server/Network Architecture, secure transaction, firewall, backup, Software development, MS Office, Oracle
Project history
04/2018
-
12/2019
Nature of Work: Data Architecture /Network optimizer model for Supply allocation based on 5
Regions,12 States,6000 Unloading and 20 cement and grinding Plants. Consolidating monthly demand
product wise/district/taluka wise through Optimiser modelling Enterprise Architecture
Year: April 2018 - Dec 2019
Location: Delhi
Client: JK Lakshmi Cement Ltd, Logistic/Business excellence team
Position Held: Dy General Manager (Marketing Services )
Main features:
Enhancing customer facing capabilities by building mobility applications for agents who deal with
about 2.5 million customers.
Activities Performed:
* Master Data Management (Plants, Warehouse, Districts, Transportation routes)
* Extraction and Integration with SAP Data
* Constraints modeling, LP model input run
* Allocation Report preparation
* Dashboard management /monitoring with different scenarios
* Defining baseline and target architecture for Optimizer Model based on the monthly market
requirements location wise (Unloading points approx. 6000)
* Collecting Sales Demand, Production data and Transportation rates to support the optimizer
* Coordinating with development team and testing teams to ensure that all the requirements are
being covered
* Documentation in ensuring documentation in Alfresco Enterprise Documentation Server
* Preparing various demand scenarios and generating allocation /result from the application
Nature of Work: Geographical Information System Architecture tomap entire cement dealer locations,
plants and warehouses to find distance and visualise markets demand and supply allocation
/feasibility.
Regions,12 States,6000 Unloading and 20 cement and grinding Plants. Consolidating monthly demand
product wise/district/taluka wise through Optimiser modelling Enterprise Architecture
Year: April 2018 - Dec 2019
Location: Delhi
Client: JK Lakshmi Cement Ltd, Logistic/Business excellence team
Position Held: Dy General Manager (Marketing Services )
Main features:
Enhancing customer facing capabilities by building mobility applications for agents who deal with
about 2.5 million customers.
Activities Performed:
* Master Data Management (Plants, Warehouse, Districts, Transportation routes)
* Extraction and Integration with SAP Data
* Constraints modeling, LP model input run
* Allocation Report preparation
* Dashboard management /monitoring with different scenarios
* Defining baseline and target architecture for Optimizer Model based on the monthly market
requirements location wise (Unloading points approx. 6000)
* Collecting Sales Demand, Production data and Transportation rates to support the optimizer
* Coordinating with development team and testing teams to ensure that all the requirements are
being covered
* Documentation in ensuring documentation in Alfresco Enterprise Documentation Server
* Preparing various demand scenarios and generating allocation /result from the application
Nature of Work: Geographical Information System Architecture tomap entire cement dealer locations,
plants and warehouses to find distance and visualise markets demand and supply allocation
/feasibility.
01/2014
-
04/2017
Dy General Manager (Marketing Digital Services)
JK Lakshmi Cement Ltd.
Main features:
As is analysis and understanding where dealers (5000 Dealers across pan India) are clustered viz
demand using Geographic information system (GIS) technology. To visualize where your dealers are
located by analyzing demographic, market potential, and lifting characteristics fand net sales
realization for accurate dealer segmentation in Green, Yellow and red.
Activities Performed:
* Master Data Management (Dealers location, Plants, market location)
* Extraction and Integration with SAP Data
* Develop app using ARCGIS from ESRI for geo location for Dealers
* Dealers Geo data plot on ARCGIS Maps
* Plants /Grinding unit geo locations and network route and buffers distance
* Districts /Clusters data plot MAPS
* All India /Region wise /District wise MAP ARCGIS maps
As is analysis and understanding where dealers (5000 Dealers across pan India) are clustered viz
demand using Geographic information system (GIS) technology. To visualize where your dealers are
located by analyzing demographic, market potential, and lifting characteristics fand net sales
realization for accurate dealer segmentation in Green, Yellow and red.
Activities Performed:
* Master Data Management (Dealers location, Plants, market location)
* Extraction and Integration with SAP Data
* Develop app using ARCGIS from ESRI for geo location for Dealers
* Dealers Geo data plot on ARCGIS Maps
* Plants /Grinding unit geo locations and network route and buffers distance
* Districts /Clusters data plot MAPS
* All India /Region wise /District wise MAP ARCGIS maps
07/2011
-
01/2015
Dy General Manager Systems (SAP Business Intelligence and ERP)
JK Lakshmi Cement Ltd.
(IT Infrastructure and ERP(SAP) Planning and execution)
IT Infrastructure and Marketing Systems (In-house ERP)
IT Infrastructure and Marketing Systems (In-house ERP)
11/2010
-
07/2011
Senior Manager Systems
Nature of Work: SAP Business Intelligence, ERP implementation.
Year: November 2010 - July 2011
Location: Delhi, Rajasthan, Gujarat
Client: JK Lakshmi Cement Ltd
Position Held: Senior Manager Systems
Main features: Design and Architect Queries /Reports /DASHBOARDS to monitor Business based on KPI's
such as Net sales realization and outstanding number of days
Activities Performed:
* Business requirement study and scope establishment
* Data modeling, BI content management/enhancement
* ETL design and Process chains
* Multi cube and Query development
* Gathering functional requirements in coordination with SAP BI, TCS teams along with SAP
functional consultants
* Trainings Senior executives
Nature of Work: IT Infrastructure solution setup and monitoring for SAP ERP implementation., Project
initiation, execution and monitoring
Year: November 2007 - Apr 2011
Location: Delhi, Chhattisgarh, Haryana, Rajasthan, Gujarat
Client: JK Lakshmi Cement Ltd
Position Held: Senior Manager Systems
Main features: Solution /Server/Network Architecture
Multi Plants, Marketing Offices, Dealers for conducting secure transaction in SAP ERP
Activities Performed:
* Plan and Implement the complete Hardware and Infrastructure requirement for SAP Implementation
and prepare Technology Architect for server and network setup
* To connect All manufacturing Plants and Regional Offices 2 Mbps and 512/256/128 Kbps MPLSVPN
Network.
* 100 other locations are n 64 Kbps MPLSVPN Network.
* To create firewall and backup policies through alternate network for plant, HO & Regional
offices.
* RF wireless link at Ready-mix concrete plant
* Networking works/ Depots/ Branches/ HO for online sharing of Data/ reports on dispatch /
stock/ invoicing/ collection through across 100-Depots, 6-Regional offices, Head-office and
Work-office consisting of approximately 200-Marketing and Accounting professionals.
Year: November 2010 - July 2011
Location: Delhi, Rajasthan, Gujarat
Client: JK Lakshmi Cement Ltd
Position Held: Senior Manager Systems
Main features: Design and Architect Queries /Reports /DASHBOARDS to monitor Business based on KPI's
such as Net sales realization and outstanding number of days
Activities Performed:
* Business requirement study and scope establishment
* Data modeling, BI content management/enhancement
* ETL design and Process chains
* Multi cube and Query development
* Gathering functional requirements in coordination with SAP BI, TCS teams along with SAP
functional consultants
* Trainings Senior executives
Nature of Work: IT Infrastructure solution setup and monitoring for SAP ERP implementation., Project
initiation, execution and monitoring
Year: November 2007 - Apr 2011
Location: Delhi, Chhattisgarh, Haryana, Rajasthan, Gujarat
Client: JK Lakshmi Cement Ltd
Position Held: Senior Manager Systems
Main features: Solution /Server/Network Architecture
Multi Plants, Marketing Offices, Dealers for conducting secure transaction in SAP ERP
Activities Performed:
* Plan and Implement the complete Hardware and Infrastructure requirement for SAP Implementation
and prepare Technology Architect for server and network setup
* To connect All manufacturing Plants and Regional Offices 2 Mbps and 512/256/128 Kbps MPLSVPN
Network.
* 100 other locations are n 64 Kbps MPLSVPN Network.
* To create firewall and backup policies through alternate network for plant, HO & Regional
offices.
* RF wireless link at Ready-mix concrete plant
* Networking works/ Depots/ Branches/ HO for online sharing of Data/ reports on dispatch /
stock/ invoicing/ collection through across 100-Depots, 6-Regional offices, Head-office and
Work-office consisting of approximately 200-Marketing and Accounting professionals.
01/1997
-
01/1998
Assistant Manager
Siel Chemical Complex; AEA Delhi Chapter of Global Association of Enterprise Architects
5. Brief Profile
Experienced senior IT professional/Enterprise Architect with 34 years of experience in IT
Infrastructure management, IT Projects, Digital Transformation, Digital Marketing, Software
Development, Oracle Database, and ERP/EA Implementation. Proven ability to bring the benefits of
Information Technology to solve business issues while delivering applications, IT infrastructure.
Provide strategic direction to senior leadership on technology and Business Intelligence.
* TOGAF 9.1 Certified (The Open Group)
* MBA (IT),
* PMP (Project Management Professional),
* Industry Exposure: Manufacturing, Cement, Vanaspati, Edible Oil, Chemicals, Sugar and Exports
* SAP /SAP BI project-coordinator at national level; Project-preparation
* Key Areas: Sales Distribution Function and Materials, Logistics Management and Financial
Management
* Successful deployment and implementation of Web Technologies on Microsoft platform i.e. Windows
Server Internet Information System and ASP.net.
6. Languages English, Hindi
7. Work Undertaken that Best Illustrates Capability to Handle the Task Assigned
Nature of Work: Enterprise Architecture for Association of Enterprise Architecture Delhi Chapter of
Global AEA: Oct 2014 - Present
Location: India, Delhi
Company: AEA Delhi Chapter of Global Association of Enterprise Architects
Position Held: Chairperson
Main features: To strengthen the practice and professionalism of Enterprise Architecture and
increase Status of EA in Delhi/NCR , enable and encourage the highest standard of enterprise
architecture practice by Members and advance the professional excellence and status of Enterprise
Architecture and at the Delhi/NCR.
Activities Performed:
* Prepared EA Case studies for Enterprise Architecture for Manufacturing domain and presented,
taught at IIT Delhi for MBA and Engr Students
* Created and strength networking forum for EAs with multiple collaboration tools ie Delhi NCR
WhatsApp group, AEA All India Connect group and AEA Delhi Chapter LinkedIn Group
#AEADELHICHAPTER
Uses and align on Digital Marketing tools and methods to reach out to new EA members .
Managing monthly activities eg dedicated Webinar and meetings among members.
* Enhanced WebPages in Global AEA website to give a new look and updated meeting documents were
uploaded with easy navigation
* Conducting Monthly Meetings / workshops with various AEA Member(Delhi and All India) calling
senior guest speakers and align Knowledge session in area of Enterprise Architecture, Digital
Transformation, Digital India, IndEA and emerging technologies to increase awareness for the
vision of Enterprise Architecture
* Created awareness, understanding and education for MBA and Technologies Students in Premier
Institutes Delhi/India with voluntary conducting workshops on the subject Enterprise
Architecture. Part of 14 hours course for IIT Delhi. In this regards prepared a compact EA
Course material with Industry focus case studies. and conducted training session for 5 hours
* Published articles best practices of Enterprise Architecture in LinkedIn and global AEA
websites
Nature of Work: Project Coordination for Cross functional Team. Enterprise architecture for
connecting Dealers, retailers, masons, and other stake holders and integration with Core ERP (SAP
Systems) and Customer Locality management
Experienced senior IT professional/Enterprise Architect with 34 years of experience in IT
Infrastructure management, IT Projects, Digital Transformation, Digital Marketing, Software
Development, Oracle Database, and ERP/EA Implementation. Proven ability to bring the benefits of
Information Technology to solve business issues while delivering applications, IT infrastructure.
Provide strategic direction to senior leadership on technology and Business Intelligence.
* TOGAF 9.1 Certified (The Open Group)
* MBA (IT),
* PMP (Project Management Professional),
* Industry Exposure: Manufacturing, Cement, Vanaspati, Edible Oil, Chemicals, Sugar and Exports
* SAP /SAP BI project-coordinator at national level; Project-preparation
* Key Areas: Sales Distribution Function and Materials, Logistics Management and Financial
Management
* Successful deployment and implementation of Web Technologies on Microsoft platform i.e. Windows
Server Internet Information System and ASP.net.
6. Languages English, Hindi
7. Work Undertaken that Best Illustrates Capability to Handle the Task Assigned
Nature of Work: Enterprise Architecture for Association of Enterprise Architecture Delhi Chapter of
Global AEA: Oct 2014 - Present
Location: India, Delhi
Company: AEA Delhi Chapter of Global Association of Enterprise Architects
Position Held: Chairperson
Main features: To strengthen the practice and professionalism of Enterprise Architecture and
increase Status of EA in Delhi/NCR , enable and encourage the highest standard of enterprise
architecture practice by Members and advance the professional excellence and status of Enterprise
Architecture and at the Delhi/NCR.
Activities Performed:
* Prepared EA Case studies for Enterprise Architecture for Manufacturing domain and presented,
taught at IIT Delhi for MBA and Engr Students
* Created and strength networking forum for EAs with multiple collaboration tools ie Delhi NCR
WhatsApp group, AEA All India Connect group and AEA Delhi Chapter LinkedIn Group
#AEADELHICHAPTER
Uses and align on Digital Marketing tools and methods to reach out to new EA members .
Managing monthly activities eg dedicated Webinar and meetings among members.
* Enhanced WebPages in Global AEA website to give a new look and updated meeting documents were
uploaded with easy navigation
* Conducting Monthly Meetings / workshops with various AEA Member(Delhi and All India) calling
senior guest speakers and align Knowledge session in area of Enterprise Architecture, Digital
Transformation, Digital India, IndEA and emerging technologies to increase awareness for the
vision of Enterprise Architecture
* Created awareness, understanding and education for MBA and Technologies Students in Premier
Institutes Delhi/India with voluntary conducting workshops on the subject Enterprise
Architecture. Part of 14 hours course for IIT Delhi. In this regards prepared a compact EA
Course material with Industry focus case studies. and conducted training session for 5 hours
* Published articles best practices of Enterprise Architecture in LinkedIn and global AEA
websites
Nature of Work: Project Coordination for Cross functional Team. Enterprise architecture for
connecting Dealers, retailers, masons, and other stake holders and integration with Core ERP (SAP
Systems) and Customer Locality management
05/1989
-
01/1998
Sr Executive Systems/Asst Manager
Nature of Work: In-house Software development
Part of in-house IT team to support business users e.g. Finance, Marketing, production, and HR
Year: May 1989 - Jan 1998
Location: Delhi
Client: Shriram Foods and Fertilisers ,Siel Chemical Complex,Mawana Sugars Ltd.
Position Held: Sr Executive Systems/Asst Manager
Main features: Desktop /Main Server based software solution for HR, Despatch, Sales,Finance
Department
Activities Performed: System study/Design and Software /Portal development
1. Siel Chemical Complex, Rajpura, Punjab state.
Prepared the entire computerization plan and developed online systems for the Siel Chemical
Complex plant at Rajpura, Punjab state as project head
2. Cane Indenting System at Mawana Sugar Works
* Online System for Oil procurement
* Materials Management System
* Preventive Maintenance System- Plant maintenance
* Chemical Sales Information System for material dispatches and Sales Orders
* MIS System for 3rd party/Trading operations.
* Vanaspati Sales Management System.
* Commodity Trading & Accounting System
* Attendance & Leave Management System
* Employee Shop System for Goods Sale & Purchase
* Export Monitoring System at Siel International Division
Part of in-house IT team to support business users e.g. Finance, Marketing, production, and HR
Year: May 1989 - Jan 1998
Location: Delhi
Client: Shriram Foods and Fertilisers ,Siel Chemical Complex,Mawana Sugars Ltd.
Position Held: Sr Executive Systems/Asst Manager
Main features: Desktop /Main Server based software solution for HR, Despatch, Sales,Finance
Department
Activities Performed: System study/Design and Software /Portal development
1. Siel Chemical Complex, Rajpura, Punjab state.
Prepared the entire computerization plan and developed online systems for the Siel Chemical
Complex plant at Rajpura, Punjab state as project head
2. Cane Indenting System at Mawana Sugar Works
* Online System for Oil procurement
* Materials Management System
* Preventive Maintenance System- Plant maintenance
* Chemical Sales Information System for material dispatches and Sales Orders
* MIS System for 3rd party/Trading operations.
* Vanaspati Sales Management System.
* Commodity Trading & Accounting System
* Attendance & Leave Management System
* Employee Shop System for Goods Sale & Purchase
* Export Monitoring System at Siel International Division
Local Availability
Only available in these countries:
India
Avaliable
Other
I had word as Deputy General Manager (Information Technology), with J K Lakshmi Cement Limited, in New Delhi.
JKLC is a 36,00 Crores company and a group company of the JK Organization.
Presently, I am managing Digital Marketing, Logistics, Customer Loyalty Management related IT Projects and GIS based geo solutions.
Earlier I had managed group IT Strategy, IT Infrastructure, Database Administration and SAP ERP/ BI implementation
JK Lakshmi Cement has gone live with SAP / SAP BI in April 2010 and July 2010 respectively.
Presently we are also using CRM Salesforce and Analytic Tools QlickView/QlickSense
I have around 34 years of experience in Enterprise IT Strategy, Business alignment that includes IT Projects , SAP implementation, Project management, Data-warehousing and Business Intelligence and Database management.
Chairperson and active member of Delhi AEA Chapter (TOGAF Certified Global Association of Enterprise Architects , it is Open Group forum Since 2014) making presentations and having discussion on Enterprise Architect domain including IndEA and other new initiatives
My qualifications include;
1. TOGAF 9.1 ( Enterprise Architect) : The open group Architect Framework
2. MBA in IT,
3. PMP (Project Management Professional) from Project Management Institute,
4. OCP (Oracle Certified Professional) DBA.
Regards
Chander Shekher
9811519557
chander.shekher62@gmail.com
https://www.linkedin.com/in/chander-shekher-reddy-pmp-mba-it-togaf-9-1-92a07422/
