Ritesh Sharma

930-***-**** / 997******* adihl2@r.postjobfree.com

Summary:

Has more than 7.5 years of experience including B2C,Backend,Client Engagement and

Data Analytics.

Has more than around 2 years of experience in Data engineering, Business Intelligence.

Good in using BI tools -Power BI, Advanced Excel etc.

Strong understanding in writing SQL queries.

Dashboards from various data sets(Excel,SQL Server etc)

Hands on experience in Data Engineering areas to perform Data modeling using different data sources. Extensive experience in developing BI solutions with large data sets.

Expect in choosing rights visuals for the creation of reports for the business use cases.

Developed effective dashboards as per the business requirements implementing best practices on visualizations for decision support system.

Gained significant exposure in interactive dashboard design & visual best practices

Effective in analyzing to develop analytics dashboards and reports, delivers well organized and error-free reports extensively at operational and client level.

Technical Skills:

BI Tools

Power BI Desktop

Excel

Advance Excel(Vlookup,Hlookup, Pivot Table)

Database

SQL, Microsoft SQLServer(Joins,Stored Procedures etc)

Current Experience:

ARIESPRO TECHNOLOGY SERVICES(Sep2020-Present)

Role: BI Developer

Previous Experience : IndiaMart Intermesh Limited(July 2012- May 2019)

Has performed different type of operations in a B2B company .i.e, checking product mapping, making buy leads(buy leads is a buy requirement of buyer) & checking the Emails of Indiamart Clients & locking their Complaints.

Have Experience in working on JIRA platform & working on company forums(tester) Knowledge of making catalogs, adding products, images, lead generation, sendgrid etc

Have 3.5 years of experience in Email communications process Back End Operations

Have worked upon Data Visualization Tool(Power BI)on monthly basis for around 1.5 year

Projects:

Project Title : Outage Cost Reports

Environment : Power BI Desktop

Description: The Project is basically to convert old Reports that were in SQL into Power BI for making it more interactive and user friendly.

Responsibilities:

Involved in Collect the Technical Specification Document and Analyzing the User requirement.

Connected data from SQL View datasets.

Designing, developing and implementing Business Intelligence reports.

Crafting and executing queries upon request of data.

Experience in creating various views like Line chart, Bar Charts, Pie Chart, Table, Matrix table, Area Charts, Line and Stacked column chart

Creating Relationship as a Star Schema Model

Adding a Bookmark Button for Tabular Data

Using Graph Selection instead of Drillup/Down

Showing the Data by Substation Slicer in a graph as well as in GIS.

Project Title : Sales Dashboards

Environment : Power BI Desktop

Description: The Project is basically to convert old Reports that were in Excel into Power BI for making it more interactive and user friendly.

Responsibilities:

Involved in Collect the Technical Specification Document and Analyzing the User requirement.

Connected data from excel datasets.

Designing, developing and implementing Business Intelligence reports.

Crafting and executing queries upon request of data.

Experience in creating various views like Line chart, Bar Charts, Pie Chart, Table, Matrix table, Area Charts, Line and Stacked column chart

Creating relationship between data sets by using relationships & Calculation on columns & measures using DAX functions

Creating Filters in Visual level, page level, Drill through and Report level.

Creating interactivity between the user and dashboards with the help of Slicer and Interactions to compare data against different views.

Creating dashboards and graphs.

IBM Global Services July 2011- April 2012

Back end operations as a claim processor(a US process in which claim was done & Cheque was automatically issued)

Taking Data from MS Excel and making the claim.

Education details:

BSCIT from HNBGU Srinagar Uttarakhand with an aggregate of 66%.

12th Standard from SGRR Public School with aggregate of 48%

10th Standard from SGRR Public School, with an aggregate of 52%

Contact this candidate