Summary
Overview
Work History
Education
Skills
Certification
Skills
Timeline
Generic

Sanjeev Awasthi

Jacksonville,FL

Summary

Results-driven IT professional with 14 years of experience in business intelligence, specializing in data visualization. Proficient in Tableau and SAP Business Objects, consistently delivering enhanced network performance and providing insightful data analysis. Skilled in troubleshooting complex network issues and creating interactive dashboards to support effective decision-making.

Overview

14
14
years of professional experience
1
1
Certification

Work History

BI Analyst / Tableau Developer

Scotts-Miracle Gro
01.2020 - 12.2020
  • Requirement Gathering for Supply Chain team
  • Created more than 15 Dashboard Visualization in Tableau
  • Combined visualizations into Interactive Dashboards and publish them to the web
  • Scheduled data extracts on a daily/Weekly basis
  • Resolved end user reporting problems through collaboration with IT and Operations
  • Led the training for internal team for Tableau
  • Used Google sheets and third-party tool Xtract Universal for SAP BW HANA to get data and create visualization on combined data.

BO Team Lead

Sony Pictures
06.2019 - 12.2019
  • Understand logic created behind SAP Ariba reports and replicate to achieve in BOBJ report
  • Created SAP Ariba portal reports in BOBJ 4.2 environment using IDT universe and Webi report
  • Agile Methodology used for delivering the forms in BOBJ.

BI Lead Consultant

Sparta (KPIT) US
12.2014 - 09.2018
  • Designed and executed data extraction, transformation, and loading (ETL) processes to support business intelligence initiatives
  • Created more than 100 Dashboard Visualization in SAP Dashboards and in Tableau
  • Requirement Gathering from the client for sales, Inventory, financial and Repair Management reports and Incident Tableau dashboard
  • Developed and maintained Tableau dashboards to monitor network performance, track incidents, and analyze trends
  • Delivered Dashboard to stakeholder which supported 30 % faster data-driven decision
  • Daily Dashboard data updating based on Python script.

Consultant / Lead Consultant BI

Sparta (KPIT) India
12.2010 - 12.2014
  • Led the BOBJ team from offshore
  • Created over 100 Data visualization/dashboards using Xcelsius, Design Studio with various Analytic, Basic and Container components
  • Created more than 300 Webi reports during this period
  • Created Universe using UDT and IDT on BW, SQL and Oracle Databases
  • Report Migration using Promotion management
  • Created Webi training documents for the Power User.

Developer BI

iTree Consulting Pvt ltd
03.2009 - 12.2010
  • Created more than 10 Universe , 50 WEBI reports and 10 Xcelsius Dashboard during this time. Used Dev>QA>Prod landscape for transporting reports using Life Cycle Management.

Developer BW

Reliance Industries Limited
11.2006 - 02.2009
  • Created more than 20 SAP Data flow and loaded data in that manually and via process chain .Monitored process chain and resolved issues arises in data loading.
  • Created 4 Universe and 40 Crystal Report for profit center stakeholders
  • Dashboard Creation using Charts with SAP .Net Connector mechanism
  • Worked on SAP FICO, MM, SD and HR modules.

Education

Master of Computer Applications -

UP Technical University
01.2006

Bachelor of Science -

CSJM University
01.2002

Skills

  • Advanced Excel
  • Python Programming
  • ETL development
  • SQL Programming
  • Business intelligence tools
  • Business Analysis
  • Data Analysis
  • Data Visualization
  • Data and Analytics

Certification

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

Skills

Tableau Desktop: Dashboard Design, Data Visualization, Calculated Fields, Parameters, Filters and Actions, 

Tableau Server/Online: Publishing and Sharing, User Management, Data Refresh, Performance Optimization

Data Connection and Integration: Connecting to Databases, Live and Extract Data

Advanced Analytics: Table Calculations, Forecasting, Statistical Analysis, Visualization Best Practices: Design Principles, Storytelling, 


Web Intelligence (WebI): Report Creation, Formatting, Interactive and Advance Reporting, 

Dashboard Design: SAP Design Studio, SAP Lumira,

Universe Design: Universe Design Tool (UDT), Information Design Tool (IDT)

Data Connectivity: SQL Server, MySQL, SAP HANA,

BOBJ Administration: User and Group Management


SAP Integration: SAP BW, SAP ERP, SAP HANA, Experience to SAP BW 3.5/ 7.0 /7.3, SAP BW Data Flow,Analytics Modeling, DTP, BEX queries.

Timeline

BI Analyst / Tableau Developer

Scotts-Miracle Gro
01.2020 - 12.2020

BO Team Lead

Sony Pictures
06.2019 - 12.2019

BI Lead Consultant

Sparta (KPIT) US
12.2014 - 09.2018

Consultant / Lead Consultant BI

Sparta (KPIT) India
12.2010 - 12.2014

Developer BI

iTree Consulting Pvt ltd
03.2009 - 12.2010

Developer BW

Reliance Industries Limited
11.2006 - 02.2009

Master of Computer Applications -

UP Technical University

Bachelor of Science -

CSJM University

Similar Profiles

CREATE PROFILE
Sanjeev Awasthi