$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Certified Azure Data Engineer | Power BI Expert | SQL Expert | Trainer
Jeetendra Gour
,
Staines, United Kingdom
Experience
Other titles
Skills
I'm offering
Diverse background in writing, business intelligence, training, technical support, customer service, database development, and customised end-to-end report development. A polished communicator able to bridge the gap between technical and non-technical resources.
With over 8 years in data and analytics including the past several years with data visualisation I can effectively help you gain valuable insight from your data with data exploration and visualisation solutions. My approach is to first clearly understand the requirement and than analysing the technical solution.
My core competencies include data strategy, business intelligence, data audits, data modelling, data analysis and data visualisations.
I'm offering the services:
1. Full-stack Power BI solution development
2. Power BI solutions audit
3. Power BI Data models performance optimisation
4. SSAS and Azure Analysis Services
5. SQL development and query Optimisation
6. Excel Reporting.
7. Power BI and SQL remote and on-site training
I would be happy to have a call with you to discuss your goals for your visualisation and I look forward to working with you and helping you achieve success with your data.
With over 8 years in data and analytics including the past several years with data visualisation I can effectively help you gain valuable insight from your data with data exploration and visualisation solutions. My approach is to first clearly understand the requirement and than analysing the technical solution.
My core competencies include data strategy, business intelligence, data audits, data modelling, data analysis and data visualisations.
I'm offering the services:
1. Full-stack Power BI solution development
2. Power BI solutions audit
3. Power BI Data models performance optimisation
4. SSAS and Azure Analysis Services
5. SQL development and query Optimisation
6. Excel Reporting.
7. Power BI and SQL remote and on-site training
I would be happy to have a call with you to discuss your goals for your visualisation and I look forward to working with you and helping you achieve success with your data.
Markets
United Kingdom
Links for more
Once you have created a company account and a job, you can access the profiles links.
Industries
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Available
My experience
2016 - ?
freelance
BI Developer & DWBI Consultant (Big Data)
Centrica.
Project Location - Staines upon Thames, United Kingdom
SMART: The OFGEM has passed a mandate to all the energy supplier to install smart meters to their customer premises, requires energy suppliers to offer smart meters to all homes and small businesses across Great Britain by 2020. To accomplish this Centrica must analyze their progress and performance, so that they could take necessary measure to complete the mandate.
This is a Big Data + MSBI Development Project for tracking the SMART Meter Installation Data such as Agent Performance, Field Engineer performance and other key aspect to identify the target and completion, sales etc.
This is an end to end Development project which involved requirement gathering, Design, ETL, Cube, Report and Dashboards.
We have created data ware house in Hadoop and Data Mart using the SSAS MDDM and SSAS Tabular Model. Reporting is being done in Power BI, SSRS and Self serv in excel.
Project Environment: Big Data Hadoop, HDFS, Hive, Hue, Ambari, Unix, HQL, SQL Server 2012, Excel Reporting, Power BI, Power Pivot, Power View, SSRS, SSIS, SSAS Multi-Dimensional Model, SSAS Tabular Model, Share Point Server, TFS, SAP CRM, SAP ISU.
Key Responsibilities:
● Working closely with the Stakeholders and business Partners on regular basis for requirement gathering and requirement analysis and presenting them with possible technical solutions.
● Estimating the development effort and planning, assigning the task for the team and status tracking.
● Analyzing the source data in SAP CRM and SAP ISU to get the clear view of business logic.
● Creating the ETL architecture and planning the strategy related to data cleansing, data quality and data consolidation.
● Developing ETL layer in Hadoop and creating dimension and fact by handing the slowly changing dimension feature using HQL.
● Creating multi-dimensional data model and working on enhancement requests to modify the existing reports and cubes.
● Creating SSIS package for reference data system.
● Creating the Multidimensional and tabular Model Cube using SSAS.
● Developing Reports and Dashboards using Power BI, SSRS, Excel and Power View.
● Creating the Documentation for each delivery such Unit Test document, Deployment, SOP and Shaping Doc, Design Doc and Requirement Traceability etc.
SMART: The OFGEM has passed a mandate to all the energy supplier to install smart meters to their customer premises, requires energy suppliers to offer smart meters to all homes and small businesses across Great Britain by 2020. To accomplish this Centrica must analyze their progress and performance, so that they could take necessary measure to complete the mandate.
This is a Big Data + MSBI Development Project for tracking the SMART Meter Installation Data such as Agent Performance, Field Engineer performance and other key aspect to identify the target and completion, sales etc.
This is an end to end Development project which involved requirement gathering, Design, ETL, Cube, Report and Dashboards.
We have created data ware house in Hadoop and Data Mart using the SSAS MDDM and SSAS Tabular Model. Reporting is being done in Power BI, SSRS and Self serv in excel.
Project Environment: Big Data Hadoop, HDFS, Hive, Hue, Ambari, Unix, HQL, SQL Server 2012, Excel Reporting, Power BI, Power Pivot, Power View, SSRS, SSIS, SSAS Multi-Dimensional Model, SSAS Tabular Model, Share Point Server, TFS, SAP CRM, SAP ISU.
Key Responsibilities:
● Working closely with the Stakeholders and business Partners on regular basis for requirement gathering and requirement analysis and presenting them with possible technical solutions.
● Estimating the development effort and planning, assigning the task for the team and status tracking.
● Analyzing the source data in SAP CRM and SAP ISU to get the clear view of business logic.
● Creating the ETL architecture and planning the strategy related to data cleansing, data quality and data consolidation.
● Developing ETL layer in Hadoop and creating dimension and fact by handing the slowly changing dimension feature using HQL.
● Creating multi-dimensional data model and working on enhancement requests to modify the existing reports and cubes.
● Creating SSIS package for reference data system.
● Creating the Multidimensional and tabular Model Cube using SSAS.
● Developing Reports and Dashboards using Power BI, SSRS, Excel and Power View.
● Creating the Documentation for each delivery such Unit Test document, Deployment, SOP and Shaping Doc, Design Doc and Requirement Traceability etc.
Server, SSRS, TFS, Developer, Hive, Presenting, SSAS, Development, Feature, Data quality, BEE, Power, Energy, Logic, Sql server 2012, Energy, Agent, Power Pivot, Unix, Sql, Excel, CRM, SQL Server, SAP, Big Data, Power BI, Deployment, Design, ETL, Hadoop, Unit test, Sales, Test, Architecture, Ssis
2014 - 2016
job
BI Developer (Report Developer)
Florida Power and Light.
Project Location - Pune, India
iResolve: Florida Power & Light Company is the third-largest electric utility in the United States, serving approximately 4.7 million customer accounts across nearly half of the state of Florida.
iResolve is the support application through which all the support activities are handled by the venders. The reporting part of this application is to provide information about the support performance and creating dashboards.
Project Environment: Oracle 11g, SQL Server 2012, SSRS, Power Pivot, Power View, SSAS Tabular Model, MS Power BI, Share Point Server.
Responsibilities:
● Involved in the requirement gathering for the reports and Dashboards.
● Involved in development and enhancement for the SSRS reports.
● Creating and Supporting SSAS Cubes.
● Creating Data Model using Excel and Develop excel report using Power View.
● Creating Dashboards using MS power BI.
● Performance testing of the reports and dashboards.
● Deployment and Scheduling of the developed reports.
● Unit testing and deploying the code for System Testing
iResolve: Florida Power & Light Company is the third-largest electric utility in the United States, serving approximately 4.7 million customer accounts across nearly half of the state of Florida.
iResolve is the support application through which all the support activities are handled by the venders. The reporting part of this application is to provide information about the support performance and creating dashboards.
Project Environment: Oracle 11g, SQL Server 2012, SSRS, Power Pivot, Power View, SSAS Tabular Model, MS Power BI, Share Point Server.
Responsibilities:
● Involved in the requirement gathering for the reports and Dashboards.
● Involved in development and enhancement for the SSRS reports.
● Creating and Supporting SSAS Cubes.
● Creating Data Model using Excel and Develop excel report using Power View.
● Creating Dashboards using MS power BI.
● Performance testing of the reports and dashboards.
● Deployment and Scheduling of the developed reports.
● Unit testing and deploying the code for System Testing
Support, Power Pivot, Sql server 2012, Power, BEE, Server, Development, Testing, SSAS, Sql, Developer, SSRS, Deployment, Power BI, Oracle, SQL Server, Excel
2012 - 2014
job
BI Developer (Report Developer)
Baker Hughes.
USA Duration: Jan'12-Oct '14
Project Name: MaPS (Maintenance & Production Support)
Designation: BI Developer (Report Developer)
Project Location - Pune, India
MaPS: An application used by Baker Hughes Corporation to provide them a better visibility and understanding about the organisation various projects at various location. MaPS also track all the jobs and drilling activities performed on various locations.
MaPS is one stage solution developed where defect management, Defect reporting, Job reporting, and BI reporting are integrated together.
The project was following agile delivery model which comprises development, Maintenance and Support activities and the BI part includes development of BI report using MSBI suites and ETL using SSIS and analysis using SSAS.
Responsibilities:
● Involved in the requirement gathering for the Report creation.
● Being only BI developer in project, handled end to end delivery.
● Query performance tuning and report performance optimizantion.
● Providing effort estimations for the user stories.
● Developing the reports, Dashboards, Cubes also creating and handling existing SSIS packages.
● Defining test approach for unit testing of the Report, Cube and ETL.
● Deployment, creating report subscription and scheduling the report for users and defining user roles.
● Assisting client developers who are working on SSRS and SSIS.
Project Name: MaPS (Maintenance & Production Support)
Designation: BI Developer (Report Developer)
Project Location - Pune, India
MaPS: An application used by Baker Hughes Corporation to provide them a better visibility and understanding about the organisation various projects at various location. MaPS also track all the jobs and drilling activities performed on various locations.
MaPS is one stage solution developed where defect management, Defect reporting, Job reporting, and BI reporting are integrated together.
The project was following agile delivery model which comprises development, Maintenance and Support activities and the BI part includes development of BI report using MSBI suites and ETL using SSIS and analysis using SSAS.
Responsibilities:
● Involved in the requirement gathering for the Report creation.
● Being only BI developer in project, handled end to end delivery.
● Query performance tuning and report performance optimizantion.
● Providing effort estimations for the user stories.
● Developing the reports, Dashboards, Cubes also creating and handling existing SSIS packages.
● Defining test approach for unit testing of the Report, Cube and ETL.
● Deployment, creating report subscription and scheduling the report for users and defining user roles.
● Assisting client developers who are working on SSRS and SSIS.
Agile, ETL, Management, Ssis, Developer, Support, SSAS, Development, BEE, Production, USA, Drilling
Jeetendra's reviews
Jeetendra has not received any reviews on Worksome.
Contact Jeetendra Gour
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Jeetendra directly in Worksome.
38000+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark