Sandip Ghosh

Product Manager

Kolkata, West Bengal, India18 yrs 10 mos experience
Most Likely To SwitchHighly Stable

Key Highlights

  • Over 11 years in Business Intelligence and Analysis.
  • Expert in Power BI and Qlik Sense reporting.
  • Proven track record in performance improvement of BI reports.
Stackforce AI infers this person is a Business Intelligence Architect with expertise in data visualization and reporting.

Contact

Skills

Core Skills

Power BiQlik SensePower QuerySharepoint

Other Skills

Azure Data FactoryAzure Data LakeAzure DatabricksBusiness ProcessCode ReviewCognosCommunicationDAXData ModellingOraclePower AppPower AppsPower BI Paginated ReportProblem SolvingPython (Programming Language)

About

Technical Skills: - Power BI, Power BI Paginated Report, DAX, Power Query, Qlik Sense, Qlik N-Printing, SQL Server, Oracle, Snowflake. Experience Summary: • I have 11 years of professional experience in the field of Business Intelligence and Analysis and as a technical consultant for Power BI, Power Bi Paginated Report, SharePoint Lists, Qlik Sense, Qlik N Printing 19. • I have 4 years of exp in Power BI, DAX and Power Query and 9 years of exp in Qlik Sense and Qlik N Printing reporting and 11 years of exp in Data Modelling and Data warehousing. . I have converted more than 40/50 Cognos reports to Power BI Paginated Report (RDL). • I have used Power Query to fetch data from Service Now system using REST API and have created reports on different charts using that data. • I have created many SharePoint Lists which are inter-connected through lookup column and also have created Share Point Apps on those Lists. Business Users save data into Share Point Lists through using Power App and in Power BI report I have used Share Point Lists as a data source. • I have used SQL Server as a backend database for Power Apps and Business users put data through Power App UI and those tables used in the Power BI report as a data source. • I have involved in Performance improvement works in Power BI reports. • I have worked with many Time Intelligence DAX functions for YTD, QTD and MTD calculations. • I have used Direct Query to fetch data from Oracle On-premise system and schedule refresh on 5 minutes intervals. • Converting all operational excel report into Power BI Reports. • Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions. • I have developed ad-hoc reports using Qlik N Printing 19 Designer in a range of standard formats such as PDF, Excel, Word and PowerPoint from my existing Qlik Sense documents and Qlik Sense apps. • I have worked on to improve the performance of the dashboards with analytical capabilities to limit the response time to load under 10 seconds in Qlik Sense applications. • I have an active role in the design, architecture and development of user interface objects in Qlik Sense and Power BI applications. • I have worked on Qlik Sense QMC on the publishing Apps, Deploying Apps from one to another environment, scheduling the event base and dependent task, adding and assigning the tags at task and apps, creating streams and applying security rules at streams to restrict the user access etc. • I have converted more than 100 Qlik View reports to Qlik Sense.

Experience

Cognizant

Power BI, Power BI Paginated Report (RDL), Snowflake, Qlik Sense Architect and Lead

Nov 2021Present · 4 yrs 4 mos · Kolkata, West Bengal, India · Hybrid

  • I have 17 years of professional experience in the field of Business Intelligence and Analysis and as a technical consultant and design, architecture and development role for Power BI, Power BI Paginated Report, Snowflake, Qlik Sense, Qlik N Printing 19 and also, have used Oracle, SQL Server, MYSQL, Azure Data Lake as a data source of the reporting tools.
  • I have 5 y ears of exp in Power BI, DAX , Power Query and 9 years of exp in Qlik Sense and Qlik N Printing reporting and 11 years of exp in Data Modelling and Data warehousing.
  • . I have converted more than 40/50 Cognos reports to Power BI Paginated Report (RDL).
  • I have used Power Query to fetch data from Service Now system using REST API and have created reports on different charts using that data. Also, I have used SOAP API and Share Point Excels to fetch data using Power Query.
  • I have created Project Management System using Power App and have used SharePoint Lists and SQL Server as backend data source. I have used those data source at Power BI reporting.
  • I have involved in Performance improvement works in Power BI reports and have worked with many Time Intelligence DAX functions for YTD, QTD and MTD calculations.
  • I have used Aure Data Lake storage as data source and create live connection to connect the data source with Power Bi report. Also, I have use d D ir ect Query to fetch data from Oracle On premise system and sc h edule ref resh on 5 m inu tes
  • intervals.
  • Utilized in Power Query in Power BI to Pivot and Un-Pivot the Data Model for Data Cleansing and Data massaging.
  • Explored data in variety of ways and across multiple visualizations using Power BI. Strategic expertise in design of experiments, data collection, analysis and visualization.
  • Involved in creating Data visualizations like Clustered Column Chart, Bar Chart, Donut Chart, Line Chart, Scatter Plot, Slicer, Gauge Visualization etc. with Power BI.
Power BIPower BI Paginated ReportDAXPower QueryQlik SenseQlik N-Printing+3

Wipro

Power BI, Qlik Sense Architect

Jun 2021Nov 2021 · 5 mos · Greater Kolkata Area

  • I have 11 years of professional experience in the field of Business Intelligence and Analysis and as a technical consultant and design, architecture and development role for Power BI, Power App, Azure Data Factory, Qlik Sense, Qlik N Printing 19 and have used Oracle, SQL Server, MYSQL, Azure Data Lake as a data source of the reporting tools.
  • I have 5 years of exp in Power BI, DAX, Power App, Power Query and 9 years of exp in Qlik Sense and Qlik N Printing reporting and 11 years of exp in Data Modelling and Data warehousing.
Power BIQlik SensePower AppAzure Data FactorySQL ServerOracle

Tata consultancy services

Data Visualization Architect

Jan 2021Jun 2021 · 5 mos · Kolkata, West Bengal, India

  • o Currently working as a Business Analyst and Reporting Architect on Power Bi and Qlik Sense for a client
  • o Previously working as a Business Intelligence Analyst and Visualization Tech Lead for Global Data and Analytics
  • o As a part of Data Visualization CoE, I provide technical training across domain
  • o SME participating in project acquisition activities, handling SME queries for multiple accounts for visualization activities across units and R&D for Analytics & Insights - Data Services
  • o Supporting as a technical panelist for organizational recruitment.

Ibm pvt india limited

Senior Power BI, Qlik Sense, Qlik N-Printing, SQL, Data Modelling developer at IBM India Pvt Ltd

Sep 2017Jan 2021 · 3 yrs 4 mos · Kolkata, West Bengal, India

  • I am proficient in Power BI, QlikSense, Qlik NPrinting, SQL, Data Modelling and working as an architect of Business intelligence filed.
Power BIQlik SenseQlik N-PrintingSQLData Modelling

Cognizant technology solutions india private limited

Business Intelligence Consultant on Power BI, QlikSense, Qlik NPrinting, SQL, Data Modelling

Oct 2011Sep 2017 · 5 yrs 11 mos · Kolkata Area, India

  • I am proficient in Power BI, QlikSense, Qlik NPrintinga and SQL
Power BIQlik SenseQlik N-PrintingSQL

Indus net technologies

Senior Data Modelling and SQL Developer

Apr 2007Aug 2011 · 4 yrs 4 mos · Kolkata Area, India

Education

West Bengal University of Technology, Kolkata

B.Tech In Computer Science & Technology

Jan 2003Jan 2006

Stackforce found 100+ more professionals with Power Bi & Qlik Sense

Explore similar profiles based on matching skills and experience