Nityanand Sharma Cont...

Solution Architect
Profile Summary Areas of Expertise:
▪ Total 17 + Years Experience in IT Industry (12 + Years for IKEA) as well as in Supply Chain planning functional Domain.
✓ Solution Analysis, Solution Design,
▪ Worked as HCL Consultant from 2010 till 2019 for IKEA, Joined INTER IKEA as Solution Architect in 2020, Currently working on “S&OP” Development, Process Adherence, Technical
Implementation Project. Lead, Technical Manager, Solution Architect.
▪ The key responsibilities / Roles played are Developer, Technical Lead, Project Lead, IT Solution Analyst, IT Project Manager, Solution ✓ Techno functional Supply Chain Consultant
Architect. Managing or supporting development team in deriving Technical requirements from business requirements, Leading with good exposure to Market Standard Tool
Development Projects as per IKEA Ways of Working, Supporting IKEA Processes Like DPs, ORTs, PRAs, STQs, CCBs etc.. during Delivery of (Blue Yonder – Demand, Fulfilment and ESP)
Projects for IKEA.
✓ Team Leading & Managing
▪ Previous to current assignment, was working as Solution Architect for “Discontinued Execution Project” and Vendor IT Project Manager
Technical skills:
for enhancements in PBSS for couple of IKEA Applications (DSP, SCM, ESP, SCPIX, SCPODS etc..), was managing Team of 10 people, taking
care of CCBs, Contracts (PDI, POD, SOW), Budget, Profit and Loss, Resourcing, in short overall “minor enhancement” releases planning and • Database: Oracle PL/SQL, MS SQL Server
management from Vendor side. • SCP Products: Extensive experience on Blue
▪ Technical expertise in IKEA integration applications and tools, have worked closely with EBBA and HIP System for setting up integrations. Yonder Demand, Fulfillment & ESP (formerly
JDA), hands on Trainings on SAC (SAP Over
▪ Experience in working and Implementing Agile Practices in INTER IKEA.
Analytical Cloud)
▪ Experience in coordinating with IKEA business teams and IT teams across all phases of software development life cycle, like Requirements
• Tools: Power BI, SSAS (SQL Server Analyses
Analysis, Designing, Demos, ORT, SIT, BAT, UAT, Deployment and Post Go Live Support (As we used to follow Water fall Model earlier).
Services), JIRA, GIT
▪ Tools / Technology : Blue Yonder (formerly JDA), Oracle PL/SQL, MS SQL Server, Power BI, SSAS (SQL Server Analyses Services), JIRA, GIT,
Business Analysis skills:
SAC (SAP Over Analytical Cloud)
• Requirement Gathering and Analysis
Professional/Major Project Summary- IKEA (As IKEA Employee) • Business Process Analysis & Integration
request.
▪ IKEA Sales and Operational Planning (S&OP): As Solution Architect
• Excellent communication and presentation
✓ Scope: Scope of the Project is to develop process/system/tool for S&OP Implementation for IKEA to enable Demand and skills.
Supply Planning at Tactical Level (i.e. higher level, example: Family-PA at Yearly granularity).
• Root Cause Analysis (RCA) & Risk Analysis
✓ Responsibility Interaction/co-ordination with interfacing systems, Integration contract and immediate related discussions (PRA)
with Integration Teams (HIP/EBBA), Documenting and maintaining “High Level Solution Design”, to Participate/Contribute
• Good Knowledge of BI Tools, like Power BI,
in Design Board meetings with other IKEA Architects, to Support Development Team in Implementing the Solutions/Tools
Tableau, Qlik
(Like Power BI), to participate and Contribute in Sprint Planning, Prioritisation, Daily Scrum, Retrospection meetings, to
Lead Security assessments and Penetration Testing. Nationality:
✓ Additional Responsibility: Supporting Development Team in writing MS SQL Server batch Scripts and creating Power BI • Swedish
Analytical Reports whenever team has bandwidth issues and they need support.
Contact Info:
✓ Involved in SAC (SAP Over Analytical Cloud) Implementation Assessments, Workshops and hands on Trainings with/from
Implementation Vendor, have not worked on SAP in past, Exposure to SAP is limited to Trainings/Implementations. • +46723747858, Nityanand_cdac@yahoo.com
Internal
 Nityanand Sharma Cont...
Solution Architect

Professional/Major Project Summary- IKEA (As HCL Consultant)

▪ IKEA Discontinued Execution Project: As Solution Architect
✓ Scope: Scope of the Project is to develop process/system/tool for better planning of Discontinued Article range that will enable to consume the remaining assets at
Supplier/DCG more efficiently and in turn minimize the losses to IKEA .
✓ Responsibility The key responsibility is to To Analyse the Requirements and get clarifications from different users groups (Need Planners, Demand Planners, Supply Planners,
Regional Supply Team, RSI etc…), Interaction/co-ordination with interfacing systems, Integration contract and immediate related discussions with ISC (IIP), Estimation of efforts
to develop solution, Documenting “High Level Requirements” & “High Level Design”, to Provides inputs to various stake holders like SA, IT Architect, Integration council
meetings, Business team.
▪ IKEA DSP(Demand and Supply Planning), SCM (Supply Chain Matrix), ESP( Enterprise Supply Planning) : As IT Project Manager
✓ Scope: Minor Enhancement Releases (Week09, Week22 and Week42).
✓ Responsibility The key responsibilities are being Part of IKEA CCBs, To bridge the GAP
between IKEA business team and vendor Development Team, Leading the Development of Enhancements as per IKEA Processes and standards, ensuring smooth SIT with
Other Applications in IKEA, Responsible for successful Deployment of Solution to the Production and Post Go Live Support. Also, to take care of Contracts, Resourcing and
Quality.
▪ IKEA ESP ( Enterprise Supply Planning) : As IT Solution Architect & Technical Lead
✓ Scope: Delivering and Establishing new Service ESP in IKEA.
✓ Responsibility The key responsibilities were to Deploy the enhanced version of third Party Product (JDA), as per IKEA business requirements in IKEA for “Supplier Capacity
Planning” and thereby replacing the existing excel based CCART tool for Suppliers. Was responsible for all Integrations establishment with other IKEA systems, Arranging pre-
requisite third party Software in IKEA, Coordinating with JDA (Vendor) for Designing the product enhancements, Validating the solution based on Prototype along with IKEA
business team, enabling the New Service on Web, getting done the security test for Application, providing IKEA users Access to Application through Web, Adhering IKEA
Quality Processes and preparing documents to establish new Applications in IKEA like OLA (Operation Level Agreements) and SLA (Service Level Agreements) educating IKEA
Helpdesk and users new Application and setting up user management process for Helpdesk

Internal
 Nityanand Sharma
Solution Architect

Professional/Major Project Summary- IKEA (As HCL Consultant)

▪ IKEA DSP-SC Transformation: As Technical Lead
✓ Scope: Decommissioning of DSP-SC (Satellite Application of DSP) and moving the functionality to different Applications.
✓ Responsibility The key responsibilities were to work across multiple Applications and users to Accommodate the functionalities of DSP-SC in different IKEA Applications while it
is being Decommissioned so that underutilized IKEA infrastructure can be freed up to benefit IKEA. Was responsible to set up New Service MDQ, to get new reports created in
Qlik View, setting up user administration for user Access through Helpdesk, to get the performance test conducted to assess the Hardware need as per Real Production user
load. To work closely with IKEA Architects and IIP Team regarding decommissioning of old Integrations and setting up new Integrations.
▪ IKEA Safety Stock Optimization: As IT Solution Analyst
✓ Scope: To Stabilize Volatile Safety Stock in DSP Application to improve quality of Orders.
✓ Responsibility The key responsibilities were to Analyze the root cause of Volatile nature of Safety Stock in DSP, to propose the solutions/approaches around stabilizing the
Safety Stock, to prepare the “Simulation Tool” to try different permutation of Safety Stock Parameters along with IKEA business team to come up with appropriate
combinations of parameters values to stabilize Safety Stock hence Orders from DSP Systems.
▪ IKEA AVIN (Availability Information): As IT Solution Analyst and Lead Developer
✓ Scope: To Implement AVIN (Availability Information) functionality in DSP Application .
✓ Responsibility The key responsibilities were to Analyze the changes required at different Applications to Alert Stores around potential Stock Out Situations and enable them to
take preventive Actions to avoid Stock Out Situation at Stores, To co ordinate with different teams during roll outs, to get development done at DSP System to enable IKEA
users (Ikea Trading users, Regional Supply team, RSI users etc..) to generate and view AVIN messages and to get the integration established till Stores Systems to Alert them.
▪ IKEA CDR & SRP: As Lead Developer
✓ Scope: To Design and Develop the Code for CDR Application and various modules of SRP Applications based on business requirements.
✓ Responsibility The key responsibilities were to gather the requirements from users, conducting clarifications Demo, preparing Designs, Development of Code, taking care of
configuration management of Code, doing Unit testing of Code, getting involved/support in various test phases like SIT, PT, ORT, BAT, UAT and to get the code deployed to
production (from Deployment team ) adhering to IKEA Processes and Ways of Working.

Internal
 Nityanand Sharma
Solution Architect

Employment Summary

Organisation From To Role/s Short Summary

IKEA of Sweden AB Jan, 2020 Till Date Solution Architect Working as Solution Architect for Developing/Implementing In-House S&OP Product as per
IKEA Requirements.
HCL Technologies Jan, 2016 Dec, 2019 Technical Lead, Business
Sweden AB Analysts, Technical Manager Worked on Different Assignments for IKEA client on different Roles around Supply Chain
Planning Domain, gain hands on experience with JDA SCP Products.
HCL Technologies Ltd Nov, 2010 Dec, 2015 Developer, Technical Lead
Agilis International Feb, 2008 Nov, 2010 Developer Worked as Backend (Oracle PLSQL) Developer on FMS (Fraud Management System) for US
Clients (Like TWC, T-Mobile…)
Synergy Softwares Ltd Mar, 2007 Feb, 2008 Developer Worked as Backend (Oracle PLSQL) Developer on E-Stock Products for Brokers (Like India
Bulls…)
CDAC Noida Dec, 2005 Mar, 2007 Developer Worked as Project Trainee on Accounting System for Indian Railways.

Internal