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
2022.10 - 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
2021.07 - 2022.09
- 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
2019.05 - 2021.06
- 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 2015.08 - 2019.03
Intermediate - Science
St. John’s School
Varanasi 2014.04 - 2015.03
High School - Science
St. John’s School
Varanasi 2012.04 - 2013.03
Skills
Qlik-sense
undefinedCertification
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
2022.10 - Current
DSM (QLIKSENSE DEVELOPER)
INFOGAIN INDIA PVT LTD
2021.07 - 2022.09
Trilogy Project (QlikView Developer)
INFOGAIN INDIA PVT LTD
2019.05 - 2021.06
Bachelor of Technology - Computer Science
GLA University, Mathura
2015.08 - 2019.03
Intermediate - Science
St. John’s School
2014.04 - 2015.03
High School - Science
St. John’s School
2012.04 - 2013.03
PL-300: Power BI data analyst certified
Similar Profiles
Shani Kumar SarojShani Kumar Saroj
SONSULTANT DEVELOPMENT at infogain india pvt ltdSONSULTANT DEVELOPMENT at infogain india pvt ltd
Rohan ChettriRohan Chettri
Business Development Executive at Infogain India Pvt. Ltd.Business Development Executive at Infogain India Pvt. Ltd.
Abhishek GuptaAbhishek Gupta
Development Consultant at INFOGAIN INDIA PVT. LTD.(FTC CostCo Travels)Development Consultant at INFOGAIN INDIA PVT. LTD.(FTC CostCo Travels)