Summary
Overview
Work History
Education
Skills
Certification
Personal Information
Certificate
Timeline
Generic

Shivam Shah

Consultant Developer
Varanasi

Summary

  • I am seeking a role in a company where I can contribute technical skills, professional skills, ideas and be mentored towards a successful career goal.
  • IT professional with total 4+ years of experience working with clients in Automobile Auto data Solutions (BMW, HYUNDAI, GENESIS) and Leslie’s Pool.
  • Worked for 4+ years on BI Technology like Power BI/DQ Development, Data Visualization and reporting using QlikView (12.10.20700 SR9), Qlik Sense, Nprinting (16.9.0.0) and MS SQL Server Management Studio 18.0.and Snowflakes.
  • Conducted Software Development Lifecycle (SDLC) right from requirement analysis, documentation (functional specifications, technical design), coding and testing to maintain proposed applications.
  • Drove enhancements by developing tools & reports that helped user access and analyse data resulting in higher revenues & margins and a better customer experience; analyses large data sets to make conclusions for decision-making.
  • BI Expertise: planning, designing & building BI Dashboard and Analytics Reporting solutions, utilizing BI tools (QlikView/ Qlik sense), Databases (Microsoft SQL), dashboard visualization.
  • Configured & deployed the application on QlikView server & imported data from different sources like SQL Server, QVDs and flat files using OLE DB/ODBC
  • Worked on QlikView Management Console (QMC).
  • Exceptionally well organized that demonstrates self-motivation, creativity & initiative to achieve personal & corporate goals; possess excellent team building, communication, relationship management & analytical skills

Overview

5
5
years of professional experience
5
5
years of post-secondary education
1
1
Certification
3
3
Languages

Work History

Leslie Pool (POWER BI DEVELOPER)

INFOGAIN INDIA PVT LTD
Mumbai
10.2022 - Current
  • Understanding te SSRS Reports Analyzing SQL in SSRS Reports and creating analysis document
  • Converting SQL Queries in SSRS Reports in Snowflake for further usage in Power BI Building Data Model in Power BI Migrating SSRS Reports into Power BI Reports Debugging on data issues

DSM (QLIKSENSE DEVELOPER)

INFOGAIN INDIA PVT LTD
Mumbai
07.2021 - 09.2022
  • Smart Leads is Enterprise Lead Management System which provides Dynamic Dashboard and Key metric reports to different users like National, Regional, District, Dealer level
  • Business Intelligence centre module takes data from SQL-Server, and created Interactive dashboard (Lead Performance Dashboard) which shows monthly Leads Vs
  • Sales performance for both 3PL and OEM in real time
  • Understanding customer requirements Working on 3-tier architecture and creating data model for application with best practices in Qlik-Sense Used extensions like Qlik-Sense-Sheet-Styler, xGridResizer-master, HorizList (Horizontal Listbox), Funnel Chart, BarsPlus Created Ad-Hoc Reporting and applied Dynamic Visibility for Charts based on user Selection as per Client requirement
  • Created Dashboards style of reports using Qlik Sense components like List Box, Slider, Buttons, Charts, and Bookmarks Created reports using charts like Pie, Bar, Line, TreeMap, Scatter chart etc
  • Developed Qlik sense Dashboard using (Drill Down), Containers, Master Items Conducting meetings with QA team to ensure complete understanding of requirements, building innovative products, solutions for business based on requirements and generating new ideas & prototypes
  • Some basics functions were also used in set analysis
  • Logi export extension used for excel export
  • Using SQL queries to verify data in application
  • Using Platform manager as version control tool in project and JIRA to keep track of various releases.

Trilogy Project (QlikView Developer)

INFOGAIN INDIA PVT LTD
Mumbai
05.2019 - 06.2021
  • Smart Leads is an Enterprise Lead Management System which provides Dynamic Dashboard and Key metric reports to different users like National, Regional, District, Dealer level
  • Business Intelligence centre module takes data from SQL-Server, and created Interactive dashboard (Lead Performance Dashboard) which shows monthly Leads Vs Sales performance for both 3PL and OEM in real time
  • Tasks: Taking and understanding the requirements from client and having daily touch base call with them for updates Working on 3-tier architecture and creating a data model for the application with the best practices in QlikView
  • Used different functions like Peek, AutoNumber, Apply map etc
  • Also worked on different types of loads like Inline Load, Bundle Info load, Resident load, Preceding Load, Mapping Load etc
  • Moving onto the front-end changes i.e., designing the reports according to the mock-up given to us
  • Worked with different chart objects like bar, line, pie chart, scatter chart, Gauge chart etc
  • Also used functions like Aggr, Pick and Match, Rank etc
  • Designing Nprinting, ad-hoc reports based on the request and the requirement of the customers across regions for the purpose of management decision-making
  • Deploying the application on the test server
  • Scheduling the tasks in QMC (QlikView Management Console) Conducting meetings with QA team to ensure complete understanding of requirements, building innovative products, solutions for business based on requirements and generating new ideas & prototypes
  • Giving demos to the client on the application Using GIT as a version control tool in the project and JIRA to keep track of the various releases.

Education

Bachelor of Technology - Computer Science

GLA University, Mathura
Mathura
08.2015 - 03.2019

Intermediate - Science

St. John’s School
Varanasi
04.2014 - 03.2015

High School - Science

St. John’s School
Varanasi
04.2012 - 03.2013

Skills

Qlik-sense

undefined

Certification

PL-300: Power BI data analyst certified

Personal Information

  • Date of Birth: 03/07/97
  • Gender: Male
  • Nationality: Indian
  • Marital Status: Unmarried

Certificate

PL-300 : Power BI Data Analyst Associate certified

Timeline

Leslie Pool (POWER BI DEVELOPER)

INFOGAIN INDIA PVT LTD
10.2022 - Current

DSM (QLIKSENSE DEVELOPER)

INFOGAIN INDIA PVT LTD
07.2021 - 09.2022

Trilogy Project (QlikView Developer)

INFOGAIN INDIA PVT LTD
05.2019 - 06.2021

Bachelor of Technology - Computer Science

GLA University, Mathura
08.2015 - 03.2019

Intermediate - Science

St. John’s School
04.2014 - 03.2015

High School - Science

St. John’s School
04.2012 - 03.2013

Similar Profiles

CREATE PROFILE
Shivam ShahConsultant Developer