09/06/2022 updated
100 % available
Enterprise Architect -TOGAF, ERP implementation,GIS,Business Intelligence,Database,IT Projects
India
India
MBA Information Technology, Operational Research, BSC (Hons) Chemistry,Enteprise ArchitectureGeographic Information SystemsArcGIS (Software)Backup DevicesBusiness IntelligenceCollaborative SoftwaresComputer SecurityInformation SystemsDatabasesContent ManagementExtract Transform Load (ETL)Data ManagementData ModelingEnterprise Resource PlanningEnterprise ArchitectureMicrosoft Office
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
Languages
EnglishGood
Project history
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.
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
(IT Infrastructure and ERP(SAP) Planning and execution)
IT Infrastructure and Marketing Systems (In-house ERP)
IT Infrastructure and Marketing Systems (In-house ERP)