VIKASH KUMAR

adncmh@r.postjobfree.com

+91-882*-****-**

SUMMARY:

10+ years of experience in IT Industry with experience in design, coding, development, implementation and maintenance of software applications for Data warehousing, Business Intelligence, web-based and client-server systems. Experience includes emphasis on software applications..

Experience in SAP Net Weaver BW on extended star schema, creating Info Cube, DSO, Info Object, Transformation, DTP, Info Package, Data Source, PSA, Data Extraction, Business Content and Process Chains.

Experience in Business Objects 4.0 on designing Universe, developing Dashboards, WEBI Reports and Crystal Reports Enterprise reports

Hands on experience in SAP HANA, SAP BO 4.0 and Net Weaver BW 7.0.

Experience in modeling Information Views using HANA Studio.

Good exposure in creating SQL based Calculation View using Procedures and CE functions.

Experience in extracting data from various data sources and from flat file using BODS and SLT.

Basic Knowledge in SAP ECC 6.0 functional modules SD, MM and FICO.

Experienced in Requirement analysis, Feasibility study, Impact analysis, Dimensional modeling, ETL process designing and BI Report designing

Worked with business and helped them to define and measure KPIs for business process improvement and effectiveness.

Worked as SAP BW & Business Object integration expert & was responsible as technical lead for offshore delivery team.

Experienced in Project planning & Management, Managing and Mentoring teams.

Having good Interpersonal and Communication skills with high degree of reliability towards projects deliverables to the client.

Certified as “SAP Certified Application Associate – BW4HANA 2.x”.

Key Result Areas:

Undertaking design & development, testing, debugging and troubleshooting of the application; overseeing smooth implementation of the application

Preparing work plan, design activities, use cases etc.

Extending relevant business information from productive SAP applications and all external data sources can be integrated, transformed, and consolidated in SAP BI with the toolset provided

Identifying data requirements data warehouse and business intelligence applications to satisfy client business objectives

Overseeing the on-going development and operations of a business intelligence architecture that enables fact-based decision making and ad hoc analysis and insight generation

Improving the processes regarding data flow and data quality to improve data accuracy, viability and value.

Good Experience in SAP Net Weaver BW on creating Info Cube, DSO, Info Object, Process Chains and extracting data from ECC.

Created information models like Attribute view, Analytical view and Calculation view.

Configured SLT Server in SAP ECC 6.0 using LTR transaction code and extracted data from standard master, header and item tables related to functional modules

Created SAP Business Objects 4.0 Universe using both IDT and UDT

Developed SAP Business Objects 4.0 Dashboards, WEBI Reports

Highlights:

Live Wire Winner for exemplary performance showcased for Client many times.

1st. Winner for Big Data Analytics Blogging(HCL Tech) .”https://www.hcltech.com/blogs/big-data-analytics-manufacturing”.

Travelled to Client Location-USA Ewing for Business requirements and Solutions.

USA - Business Visa Valid till May-2028.

Automation Anywhere Certified

Certified SAP BW4HANA Consultant(https://www.credly.com/badges/45d4dd45-ca4a-4ffc-8ba1-

TECHNICAL SKILLS:

ERP Packages SAP R/3 ECC 6.0

Reporting Tools SAP Business Explorer/BO Web Intelligence/ HANA Studio.

Operating Systems Windows Server

Database MS-SQL Server 2010 and MS Access

Other applications Microsoft Office,Outlook, BMC Remedy Action Request System (OPAS) Mercury Quality Center (SAP Change Management Tool),Service Now Ticketing Tool,Citrix.

WORK EXPERIOENCE

Presently working with HCL Technology as a SAP BW/BO/HANA Consultant (July’15 to Till Date)

Worked with Robert Bosch as a SAP BW/BI Consultant (2014 to 2015)

Worked with Wipro Ltd as a SAP BW/BI Consultant (2011 to 2014).

ACADEMIC QUALIFICATION:

B-Tech (Information Technology), Rajasthan Institute of engineering & technology(Rajasthan Technical University),Jaipur- 2010, with Honors

12th from Patna Central School, CBSE, 2005 with Distinction.

10th from G H School, JH Board, 2003 With 1st Div.

SAP Certification in June 2021 – Certified Associate Consultant BW4HANA 2.x

PROJECTS:

Organization : HCL Technologies

Client : Verso Corporation (USA)

Duration : Nov’17 to Till Now

Role : SAP BW/BO/HANA Sr. Consultant

Environment : SAP BW 7.4, SAP ECC 6.0, Bex,BO(4.2)

Background

VERSO CORPORATION is a leading North American producer of printing papers, specialty papers and pulp. Their printing papers are designed primarily for commercial printing, media and marketing applications, including magazines, catalogs, books, direct mail, corporate collateral and retail inserts. Their specialty papers are used primarily for label and converting, flexible packaging and technical paper applications.

Verso is headquartered in Miamisburg, Ohio, and operates a technical center in Biron, Wisconsin and seven manufacturing facilities in the United States: Maine, Maryland, Michigan, Minnesota and Wisconsin

Responsibilities

Taking care of incidents/Enhancements/Tasks/Problem Tickets/Value Ideas/Webi reports.

Resolution of Tickets using P1,P2,P3 & P4 as per SLA.

Worked on Problem Tikets(Reactive/Proactive),Value ideas for the Application.

Executing the jobs through Redwood BW/BODS.

Monitoring BW/BODS Jobs, Webi Reports 24/7.

Worked on IDT & UDT & Web reports creation.

Worked for System Migration for SAP BW.

Worked on enhancements Provide on-demand project level SAP application functional support ( Mapping new business processes, Addressing inter modular integration issues)

To ensure Configuration Changes to be transported in time to the production system that the users requested in the form of tickets to fulfil their business process requirements.

Created information models like Attribute view, Analytical view and Calculation view.

Configured SLT Server in SAP ECC 6.0 using LTR transaction code and extracted data from standard master, header and item tables related to functional modules from HANA Studio using SLT.

Created SAP Business Objects 4.0 Universe using both IDT and UDT and Webi Reports.

MODELING, DATA ACQUISITION and QUERY DESIGN

Preparing technical,test cases, test scenario and solution document for the issue.

Integrating testing with other module.

Organization : HCL Technologies

Client : Church & Dwight(USA)

Duration : July’15 to Till Nov’17

Role : SAP BI/BO/BODS/HANA Consultant (Support & Implementation)

Environment : SAP BI 7.1/7.3, SAP ECC 6.0, Bex,BO(4.2),BODS

Background

Church & Dwight Co Inc. is a major U.S. manufacturer of household products that is based in Ewing, New Jersey. While it manufactures many items, it is by far best known for its Arm & Hammer line which includes baking soda and many other items made with it. Church & Dwight was ranked 702 in the Fortune 500 listing of companies in 2010.

Responsibilities

Taking care incidents/Enhancements/Tasks/Problem Tickets/Value Ideas/Webi reports

Resolution of Tickets using P1,P2,P3 & P4 as per SLA.

Worked On Problem Tikets(Reactive/Proactive),Value ideas for the Application.

Executing the needed changes in Configuration.

Executing the jobs through Redwood BW/BODS.

Monitoring BW/BODS Jobs, Webi Reports 24/7.

Worked on IDT & UDT & Web reports creation.

Taken Care of monthly Outage.

Worked for System Migration.

Worked in enhancements Provide on-demand project level SAP application functional support (Mapping new business processes, Addressing inter modular integration issues)

To ensure Configuration Changes to be transported in time to the production system that the users requested in the form of tickets to fulfil their business process requirements.

Preparing test cases, test scenario and solution document for the issue.

Integrating testing with other module.

System were migrated and refreshed having HPQC Testing successfully.

HANA 1.0 SP6 Database, HANA Studio.

Created SAP Business Objects 4.0 Universe using both IDT and UDT and created many Webi reports.

Done the Auditing for the Project as PQA.

Organization : Robert Bosch

Client : Drive and Control (Germany),Bangaluru

Duration : Dec’14 to July’15

Role : SAP BW/BI Consultant (Implementation)

Environment : SAP BI 7.3, SAP ECC 6.0, Bex.

Roles and Responsibilities:

Design & development, testing, debugging and troubleshooting of the application; overseeing smooth implementation of the applications.

Actively interacted with clients to get their requirements and sign off the reports

Analyze the customer’s requirement and check if the requirements are clear and practical

Identified the gaps based on the new data model compared with the existing data model

Involved in data modeling, creation of info objects, DSOs, multi providers, info object

catalogs, transformations, DTPs, data sources and info packages

Transported the developed objects from Development to Quality.

Performed Integration Test and UAT Phases for newly developed BI objects

Originated Process Chains for the developed objects

Created queries using calculated & restricted key figures, free characteristics, filters,

structures, variables, conditions, formulas and exceptions

Actively involved in documentation of the estimated risk and error handling after going live

Validated data consistency in reporting, with data target against PSA after loading them to

data targets

Carrying out Unit testing and User acceptance testing in different server

Originated Process Chains for the developed objects

Created queries using calculated & restricted key figures, free characteristics, filters, structures, variables, conditions, formulas and exceptions

Organisation : Wipro Ltd

Client : Kone Corporation(Belgium)

Duration : Sept’13 to Jun’14

Role : SAPBW/ BI Consultant(Support)

Environment : SAP BW 7.0, SAP BI 7.0, ECC 6.0

Roles and Responsibilities:

Creating custom info cubes using business content sales overview info cube, sales order info cube, deliveries info cube, custom ODS for return orders and open request schedule item

Customizing business content info sources and info cubes and then, activating the business content in order to meet the business requirements

Working on LO-Cockpit Extractors (Sales, Billing, Delivery and Shipping Extractors) using V3 update.

Monitoring daily loads and sending the load status reports to business users

Extracting master and transaction data from flat files

Sketching info packages for scheduling the data load process with full and delta update modes

Automating deleting indexes in info cubes (processing of info packages, creating indexes, DSO activation & further updating, PSA request deletion and attribute change run, etc)

Improving the query response by performance tuning, like creation of aggregates, partitioning, indexes and compressing the Info Cube

Carrying out Unit testing and User acceptance testing in different server

Handling tickets raised by users and resolving those within SLAs

Client : British American Tobacco(Kwalalumpur)

Duration : Jan’13 to Aug’13

Role : SAP BI Consultant(Support)

Environ ment : SAP BI 7.0, ECC 6.0

Roles and Responsibilities:

Monitored the process chains daily by handling the respective job failures in the BI 7.0 System

Resolved various issues such as Time Stamp, duplicate data issues, attribute change run, job failures, long running jobs, etc

Performed unit testing for the relevant development objects

Resolved the data load errors residing in the “Error Stack” and transferred the modified data to “Data Targets” through an Error DTP

Reconciled the R/3 data with the BW data for time-sheet entries, headcount, work in progress, WBS data and the GL balances

Actively interacted with clients to get their requirements and sign off the reports

Analyze the customer’s requirement and check if the requirements are clear and practical

Preparation of the Design & Design documents as per the clients requirements

Identified the gaps based on the new data model compared with the existing data model

Involved in data modeling, creation of info objects, DSOs, multi providers, info object catalogs, transformations, DTPs, data sources and info packages

Involved in extracting data from flat files

Used DSO to stage the data and transfer the DSO content to the Info Cube

Responsible for loading the master and transaction data (texts and attributes) from Tealeaf Data sources and from flat files

Automated the data load using process chains for master data loads and transactions data loads

Created custom queries, free characteristics, restricted key figures and variables

Actively involved in the dress rehearsals and data load in various systems

Validated data consistency in reporting, with data target against PSA after loading them to data targets

Actively involved in documentation of the estimated risk and error handling after going live

Client : CHEP USA Account(USA)

Duration : Jan’12 to Dec’12

Role : SAP BI Consultant(Support)

Environment : SAP BI/BW 7.0, 7.3, ECC 6.0

Roles and Responsibilities:

Actively and regularly involved in monitoring daily, weekly and monthly data load process chains using RSPC, RSPCM and RSMO

Played an instrumental role in monitoring of about 109 process chains on a daily basis and rectification of load failure errors like Master Data Loads, Transaction data Loads

Analyzed and corrected the erroneous records and deleting those requests in ODS, Cubes; reloading the data into ODS, Cubes

Rectified job failures because of source system errors, duplicate records, change run failure, ODS activation problem, invalid character, etc.

Monitored the pre-calculation servers, recover failed and long running the Information Broadcast settings.

Performed support activities like remedy ticket document, Time-Sheet, resolution document and maintenance of weekly status documents of the support team

Executed weekend activities like load fix, weekly or monthly scheduled and emergency outages

Loaded master data and transactional data manually from ODS to Cubes, from Cube to Cube and from Flat Files to Cube as per users’ requirements

Resolved the tickets based on the priority (P1, P2 and P3 tickets) without any escalations

Maintained work history for all the Incidents, Request tasks, Tasks and Change Management Requests until their closure

Created custom queries, free characteristics, restricted key figures, variables as per BAS and user requests

Documented A90 (Process Chains), M30 & M31 documents for queries and APDs

Accomplished BI 7.3 pre-upgrade activities like clean-up, creation of new objects and testing

Client : Whirlpool(USA), Hyderabad

Duration : April’11 to Dec’11

Role : SAP BI Consultant(Implementation)

Environment : SAP BI/BW3.5, 7.0, ECC 6.0

Roles and Responsibilities:

Developed Info objects, Data Sources, Info Sources, DTP, Transformations, DSO, Info Cube and Multi Provider for the data models required for reports

Used Flat files provided by business to upload data for manual cost adjustments, product feature cost adjustments and profit center plant data

Involved in data extraction for material, plant, company code, and vendor & Product Hierarchies

Transported the developed objects from Development to Quality

Performed Integration Test and UAT Phases for newly developed BI objects

Originated Process Chains for the developed objects

Created queries using calculated & restricted key figures, free characteristics, filters, structures, variables, conditions, formulas and exceptions

Generated Bex queries such as Productivity Report, COP Crossover, Total Cost Material Conversion, Standard Cost Material Conversion, month rolling and published them in the Enterprise Portals

Actively and regularly involved in load monitoring of daily, weekly and monthly data loads using Process Chains

Handled the success/failure message to the users from the process chains

Planned, maintained and scheduled the process chains on frequent basis in a day rendering 24X7 support

PERSONAL DETAILS:

Date of Birth: 6th January, 1989

Current Address: JP Kosmos,Sector-134,NOIDA-201305

Passport No: Z6128364

Marital Status: Married

Contact this candidate