Sanjeev Kumar Awasthi

Contact # 404-***-**** SAP Certified Application Associate. Certificate No. 001*******

Mail id : acrru4@r.postjobfree.com

Overview

Over 8+ years of total experience as a SAP BOBJ consultant.

Working with KPIT Technologies previously known as Sparta Consulting Inc. for last 5 yrs.

SAP Certified as “SAP Certified Application Associate – Business Intelligence with SAP BW 7.3 and SAP BI 4.0”

Experience of working in SAP Business Objects XI 3.1, SBOP 4.0/4.1

Experience of Designing Universe, resolved loops and Traps for RDBMS data sources.

Experience of Creating Dashboard in Xcelsius 2008, Dashboard Designer 4.0/4.1

Experience of Creating Web Intelligence (WEBI) report using Rich Client and Launch Pad

Experience of Creating Crystal Report from SAP and Non SAP Source.

Experience of working in BOBJ MS Analysis for Excel & for OLAP.

Experience of Administration activity for BOBJ.

Hands-on exposure in Promotion of BO Objects using the Life Cycle Management Tool (LCM) / Promotion Management ( in BI 4.0 / 4.1 )

Good Knowledge of SAP Lumira, creating of Visualizations, creating of Story Boards

Well versed with various stages of Software Development Life Cycle (SDLC), including Requirement gathering, Analysis, Design, Development, Testing and Optimization

Exposure to SAP BW 3.5/ 7.0 /7.3

Experience of Creating Queries using BEx Query Designer.

Knowledge of SAP BW concepts like Info Cubes, Multi provider, Info Objects, DSO objects, Transformation, Data Transfer processes, BEX queries

Experience

Core-Mark Inc.

Dec 2014 – till Date

Working as onsite lead for Webi and Dashboard Designer for one of the largest and most valued marketers of fresh and broad-line supply solutions to the convenience retail industry.

Leading and managing this project for BOBJ, task estimates, project planning, tracking & management, on time deliveries, invoicing, etc.

BI 4.1 is used and Reports involved Webi, Dashboard, BOBJ MS Analysis for excel & OLAP and Lumira Desktop tools for different users.

Requirement Gathering from the client for various financial reports and dashboard.

Actively assisting off-shore team and responsible for the deliverables.

Suggesting best possible solutions and Designing layouts of various Dashboards.

Assisting User team to understanding of various BOBJ tool such as Webi, MS Analysis for Excel / OLAP.

Assisting training team to deciding and creating Course material for user Training.

Report Migration using Promotion management.

Loudoun Waters

Jul 2014 – Dec 2014

Worked as Webi and Dashboard Designer for this utility project which includes Webi reports and Dashboard for Land Development, Utility Dashboard, Finance P& L Dashboard

Lead the BOBJ team from the offshore.

Responsible for team development from the offshore

Actively assisting off-shore & on-site manager in resolving all kind of complexities.

Suggesting and Designing layouts of various Dashboards.

Creating and assisting team in creating Webi Reports for Finance, CRB Billing etc.

Report Migration using Promotion management.

Horiba May 2014 – Jun 2014

Worked as Dashboard Designer for Finance Dashboards which includes P&L and finance KPI`s.

Actively assisting off-shore & on-site manager in resolving all kind of complexities.

Requirement gathering from Client team.

Dashboard Development using Dashboard Designer 4.0.

Used the Query Browser / Web Services for the Dashboard Development on top of Bex Query.

Report Migration using Promotion management.

Ikaria Jun 2013 – Apr 2014

Web Intelligence report creation and Dashboard development for SD, MM, FI and Controlling.

Requirement gathering from onsite team.

Actively assisting off-shore & on-site manager in resolving all kind of complexities.

Mentoring off-shore resources to achieve a solution.

Created Bex Queries for the Webi Reports.

Created Webi Training documents for the Power User of Ikaria.

Created and assisting team in creating Webi Reports for Finance, SD, Controlling and CRM Modules.

Report Migration using Promotion management.

Times of India Dec 2012 – May 2013

CRM Dashboard development for the Adoption, Leads and Opportunity.

Requirement gathering from Client team.

Dashboard Development using Dashboard Designer 4.0.

Used the Query Browser for the Dashboard Development on top of Bex Query.

Dashboard Migration using Life Cycle Manager (LCM).

Quanex Jun 2012 – Nov 2012

Web Intelligence report creation and Dashboard development for the monthly and financial data, data validation for the reports against the BW.

Requirement gathering from onsite team.

Creation of Universe on top of BW Queries.

Creation of Web Intelligence reports on top of Bex Queries directly and on top of universe as well.

Creation of monthly and financial dashboard through Dashboard Designer using BI web services.

Report Migration using Life Cycle Manager (LCM).

Maines Paper and Food Services Jan 2011 – May 2012

Crystal Report and Dashboard Creation for the Sales Analysis, Weekly Financial Data and Purchasing Analysis.

Requirement gathering from onsite team.

Worked on SAP Business Objects XI 3.1

Creation of Crystal Reports using Crystal Report 2008.

Creation of Bex Queries as required for Dashboard.

Creation of Dashboard using SAP Netweaver Connection in Xcelsius 2008.

Creation of Web Intelligence report and linking them to Dashboard using Opendoc.

Report Migration using Life Cycle Manager (LCM).

Mahindra & Mahindra May 2010 – Dec 2010

Project Harmony will establish common processes on a common IT platform across the Mahindra Group; this is SAP R3 implementation of 40+ companies of Mahindra group. Dashboard are being created by our team such as Systech Operational Dashboard, Hinoday Dashboard etc

Requirement gathering from BW team.

Creation of Universe on Bex Queries.

Creation of Universe on relational Database.

Creation of objects and classes.

Creation of Web Intelligence reports.

Creation of Xcelsius Dashboard using Live office connection.

ICICI Prudential Mar 2009 – Apr 2010

Management Reports contains various dashboards such as Six Sigma dashboard, Business Dashboard, Risk Dashboard, EV Dashboard, Market share etc. to help the various department to take their decisions for their business.

Requirement gathering from business team of various department (such as Operations, MIS, Bizex and Risk )

Creation of Universe on SQL Server for Operation and MIS.

Creation of objects and classes.

Creation of web intelligence reports.

Creation of dashboard in XCelsius 2008, Xcelsius 4.5 using webi report through Live Office.

Dashboard Migration from XCelsius 4.5 to XCelsius 2008.

Reliance Industries Limited Sep 2008 – Feb 2009

Operational control dashboard reports in respect of, Accounts Payable, Accounts Receivables.

Information gathering from functional person.

Creation of Data sources, Info cubes, creation of transfer rules, update rules, datastores objects.

Creation of Universe on SQL Server for Finance.

Creation of objects and classes.

Reports creation using Report Designer and Crystal Report using BO.

Reliance Industries Limited Jul 2007 – Aug 2008

Providing daily / Month to date/ Year to date details of cash outflow / in flow showing details of collection and payments made by various sectors.

Information gathering from functional person.

Involved in System testing for new development.

Creation of Data sources, Info cubes, creation of transfer rules, update rules, datastores objects & designing queries

Data loading and monitoring.

Reports creation using Report Designer and Crystal Report using BO.

Publishing the designed reports to BI Portal

Reliance Industries Limited Apr 2007 – Jun 2007

The Human resource Net-Weaver based portal was created to cater the needs of HR department and directors by providing the reports related to Employee like Attrition, new joinee report, bond details, birthday report, and travel details up to director level like balance sheet, area wise & zone wise headcount etc.

Information gathering from functional person.

Data Extraction, Loading and monitoring of Data Processing

Process Chain creation, scheduling and monitoring, Aggregates, Direct & Flexible Updates.

Reliance Industries Limited Feb 2007 – Apr 2007

Live BI alerts as mail regarding Sales, Stock, and Debtors, using data extracted from BI through .Net using SAPLOGONNET to facilitate the decision making and thus incorporating necessary decisions based on the reports.

Information gathering from functional person.

Designing the standard process to send the alerts

Development of the alerts based on the business requirement.

Operational support.

Education

Bachelors of Science

Masters of Computer Applications

Trainings

SAP BW

SAP BOBJ

SAP Certified Application Associate. Certificate No. 001*******

Contact this candidate