Roopak Mishra 8130362906 Objective

Download as doc, pdf, or txt
Download as doc, pdf, or txt
You are on page 1of 2

Roopak Mishra

8130362906
[email protected]
Objective
To serve an organization which offers scope for self-improvement and enhancement of knowledge to strive for
betterment of the organization which provides me opportunities to reach and exhibit best of my abilities.

Summary
SAP BW/BI implementation & development experience, which includes Data-Modelling, Data Extraction, Data
Loading, Scheduling, Monitoring, Reporting and Performance Tuning.
Extensively worked on designing/creating InfoObjects, InfoSources, Transfer structures, Communication
structures, Standard and Custom InfoCubes, Data Store Object (DSO).
Having precise expertise in understanding the R/3 and ECC 6.0 System and considerable experience in SAP
BW/BI, documenting, design and analysis of reports Using BEx Analyzer.
Performed LO Cockpit extraction, Knowledgeable in LIS, Generic and CO-PA extraction.
Expertise in Report Generation. Worked extensively on BEx Analyzer in building Queries using Filters, Variables,
Structures, Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions and created aggregates for
frequently used queries.
Knowledge On WEB Reporting, Reporting Agent, Open Hub Concept.
Experience in Data loading, Monitoring and Scheduling using Process Chain.
Having ability to communicate effectively at all levels of Application Development phases in the Company.
An excellent team player as well as an individual contributor with good communication and interpersonal skills.
Quick learner and stronger desire to master in new Technologies.

Consultant @ IDC Technologies, Inc., Noida 19 Aug 2015 8 Dec 2016


Worked Extensively on Data Warehouse Modelling Workbench and customized info objects, info cubes, DSOs, Data
Sources, DTPs, Transformations and Multiproviders.
Responsible for validation and verification of Data.
Creating the Data Models according to the Business requirement.
Analyze the data and help the business use the same for decision making.
Understand requirements, design formats, deploy formats, follow up with Business development Team and validate
data.
Modeled and built InfoCubes, DSO, Infosets, and Multiprovider according to reporting requirements.
Loading of master/transactional data from flat file as well as from R/3 system.
Installed, modified and managed Business Content DATASOURCES (Extract Structures) using RSA5 and RSA6
transactions.
Prepared Technical Specifications from Functional Specifications.
Involved in managing of Info Cubes, Info Object maintenance, DSO Objects, PSA, Data source, Transformation, and
DTP.
Extensive usage of Administration Workbench (RSA1).
Daily monitoring of Info Cubes, DS objects requests, and back ground Batch Jobs (SM37)
Exported reports into XL, PDF, CSV and XML formats as per the client requirement.
Set up periodic Data loads from legacy system (flat files)
Involved in extracting the data from Flat-file.
Installing and creating BI objects like info objects, DSOs, Info cubes.
Creating and managing dataflow using DTP, transformations and info packages.
Data Source Enhancement according to customer requirement.
Designed and developed queries to generate reports in BEx Analyzer.
Worked extensively on query designer.
Extensively Worked on Lo Cockpit and performing necessary procedures like setting up of update Mode, deleting set
up tables, filling up of set up tables and loaded data from ECC to BI system.
Worked with SAP R/3 Logistics (LO) in loading Sales and Distribution data into BI.
Created ODS, Infocubes, Multi-providers and Infosets and extracted SD data (Data sources Like 2LIS_11_VAHDR,
2LIS_11_VAITM, 2LIS_11_VASCL) of SAP R3 into SAP BW using Generic Extraction, Standard, LO Cockpit(LBWE)
extraction. Extensively worked for Sales Order Review.
Setup and monitored collective run jobs for SD module in LO Cockpit.
Monitored loads for SD module from R/3 source system.
Corrected delta load failure for SD module.
Schedules DTP for loading Transactional Data from PSA to Info Provider using process chains.
Extensively used Structures, cell definition, calculated key figures, restricted key figures, new selection, new formula,
exceptions and conditions.

Data Warehousing Tools - SAP BI 7.0, BW 3.5


Reporting Tools- Business Explorer (BEx Analyzer, Query Designer, WAD)
ERP Packages - SAP R/3 ECC 6.0
OS- Windows Server 2008 R2/7/8
Database- SQL Server

Education Qualifications
B. Tech. in Computer Science & Engineering in 2014 from IET Bundelkhand University, Jhansi U.P.
(First Division)
Intermediate from UP Board in 2009 from PDDUSDV Kanpur (First Division)
High school from UP Board in 2007 from PDDUSDV Kanpur (First Division)

Interests
J2EE
OOPS based Programming
C, C++ Programming
Operating System (Mac OS X, Windows XP/Vista/7/8, Linux Ubuntu) etc. HTML, CSS,

Projects Undertaken
Mini Project on Dead lock causing Process.
Project on Online Village Development & Monitoring agency
JAVA, JSP (Java Server Pages)

Training & Certification


J2EE, Core Java from June 27 to July 24, 2013 @ CETPA INFOTECH PVT. LTD. NOIDA

Achievements & Extra Curricular Activities


1. Attended various exhibitions of Social Sciences & activities like RSS.
2. Participated in Debate Competition and Cultural Fest.
3. Participated in Dainik Jagaran Marathon in Kanpur.
4. Winner of Inter University Cricket Tournament.

Interpersonal Skills
Believe in a quality work.
Working within a team-based culture involving planning, organizing, Coordination and Commitment.
Self-motivated towards work.
Positive attitude towards Goal achievement.

Personal Dossier
Date of Birth: 13/03/1994
Marital Status: Single

You might also like