SUMMARY

Having 8 years of experience in IT Industry.
To grow and evolve as a Software Developer with multifaceted skill and to be an invaluable asset to your organization.
Experience in Client / server.
Business Intelligence and Analysis. Experience in Tableau.
I understand Tableau concepts like (connect tableau with different database).

EDUCATION

B.Sc. from Bhopal MC University with 70.50 %
Mass Com. from Bhopal MC University with 71 %
PG Diploma in Banking Operations from NIIT-Institute of Finance, Banking Insurance.

WORK EXPERIENCE

Project 1:

Industry: Banking Industry Duration: 1.8 Years Responsibilities:

Design and development Description Taking care day to day reporting on Tableau.
Creating Procedures, views and custom SQL Quires to fetch data.
Responsible for data extraction from SQL Server and Excel and put all together in Tableau.
Importing data in Tableau with Live or Extract connection per need.
Using data source joining to create single data source in Tableau.
Analysed user and business requirements for changes in the application requirements.

Project 2:

Industry: Banking Industry Duration: 2.5 Years Responsibilities:

Description: Usage of Lookup, Sumifs, Sum product, Pivot tables, Conditional formatting, Reports, Validation, Forms, Hyperlinks in and out of the excel workbook, sharing the excel workbook over the network server, exporting and importing data from various data sources and other functions of MS Excel.
Planning and controlling all Management Information activities for respective campaigns, in order to meet the requirements of external clients
Preparing Monthly Stacks (Associates, Team Leaders & Managers Evaluation Scores) to measure performance & also used at time of annual appraisal.
Design reporting formats to provide accurate information in a clear and concise manner using MS-Excel.

Project 3:

Industry: Telecom Industry (NZ) Duration: 2.5Year Responsibilities:

Interacted with business users for gathering requirements.
Involved in creating and visualizing dashboards using Power BI Desktop.
Generated Power BI dashboards with SQL Server.
Used SQL Server files to generated Power BI reports.
Worked on connecting data to join the multiple tables.
Built calculation, measures, and hierarchies to create detail level summary reports and dashboards using Power BI.
Created new hierarchies and managed relationships (active and inactive) in Power BI data models.
Performed data messaging operations using Power Query editor in Power Bi desktop to clean data per requirements.
Developed packages to cleanse data with fuzzy lookups/groupings, derived columns, and condition splits.

Project 4:

Industry: Food and Beverages Industry Team Size: 2

Duration: 2.5 Year

ROLES AND RESPONSIBILITIES

Interacted with business users for gathering requirements.
Involved in creating and visualizing dashboards using Power BI Desktop.
Generated Power BI dashboards with SQL Server.
Used SQL Server files to generated Power BI reports.
Worked on connecting data to join the multiple tables.
Created new hierarchies and managed relationships (active and inactive) in Power BI data models.
Performed data messaging operations using Power Query editor in Power Bi desktop to clean data per requirements.
Developed packages to cleanse data with fuzzy lookups/groupings, derived columns, and condition splits

TECHNICAL SKILLS