Vipen G.

Vipen G.

Business/Data Analyst with Experience in Business Intelligence and Analytics

Bhopal , India

Experience: 5 Years

Vipen

Bhopal , India

Business/Data Analyst with Experience in Business Intelligence and Analytics

11520 USD / Year

  • Immediate: Available

5 Years

Now you can Instantly Chat with Vipen!

About Me

Evaluating business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing solutions. Leading ongoing reviews of business processes and developing optimization strategies. Staying up to-date on the ...

  • Data Visualization and Reporting - Good exposure to Data analysis & Visualization using

MS Excel (Power pivot), MS Access, Power BI & Tableau. Data Analysis, preparation, cleaning, using Talend Data profiler. Data modelling and data transformation capability in power query and power pivot using Microsoft power BI.

  • Data Analysis capabilities – Data Manipulation, Exploration, Visualization, Basic statistical analysis, linear, Multiple linear regression, clustering and text analysis using R, tableau & excel.
  • Database & Scripting language – Worked on MySQL, SQLite and HP Vertica database with hands on capability of SQL as scripting language. Handling and querying data sets in MS Access application.   
  • Business Data Worked on - Fair exposure in handling and understanding data of Telecom,  Spend, MRO Goods KPI, Inventory, campaign management, people management, public and   government data, and call center operations. Worked for more than 3+ years in Procurement, Inventory and supply chain domain.     
  • Dashboards – Hands on experience in working with executive dashboards, reporting, Dashboard proto-typing, delivering varied industry specific KPI’s on a visualization model using Tableau, Excel (Power Pivot) and D3.js library. Experienced in creating Executive and reporting dashboards in Tableau.   

Programming – Intermediate to transitional exposure to SQL and R programming for effective analysis of Data

Show More

Portfolio Projects

Spend Analytics

Company

Spend Analytics

Description

Designed and developed spend dashboards for an automotive client to help the procurement team to analyze the Indirect spend they are incurring over there production. To help and minimize the indirect spend.

1) Spend Analysis 2) Category Analysis 3) Payment Analysis 4) Executive Summary 5) Catalog Analysis 6) Leakage Analysis

Show More Show Less

Supply chain & procurement Analytics

Company

Supply chain & procurement Analytics

Description

  • Project Documents – Prepares project related documents at the point of project Initiation like SRS, FRD, BRD and Technical document.
  • Data Visualization and Reporting - Cretaed prototype and data vislualization model of project.
  • Data Analysis capabilities – Has done the initial analysis of data over excel usind Power pivot and power query
  • Database & Scripting language – Worked on MySQL, SQLite and HP Vertica database with hands on capability of SQL as scripting language. Handling and querying data sets in MS Access application

Show More Show Less

Skills

SQL Tableau

Telco business brain

Company

Telco business brain

Description

Designed and developed telecom dashboards for a telecom client to help them in understanding there revenue pattern and there account coverage. Created KPI and metrics to help them communicate efficiently to there business and executives.

1) Account coverage dashboard 2) Revenue Dashboard

Show More Show Less

Inbound/Outbound Contact Centre

Company

Inbound/Outbound Contact Centre

Description

Designed and developed dashboards for a contact centre client to help them in understanding the performance of there agents and work force in a contact centre.

1) Inbound Dashboard 2) Outbound dashboard 3) Disposition analysis

Show More Show Less

Skills

Pentaho

Human Resources/People Analysis

Company

Human Resources/People Analysis

Description

Designed and developed dashboards for a contact centre client to help them in understanding the performance and attrition of there employee and manage there manforce/ work force efficiently.

1) Attrition Analysis 2) Performance analysis 3) HR analysis

Show More Show Less

Skills

Pentaho SQL