freiberufler Business Intelligence Consultant auf freelance.de

Business Intelligence Consultant

offline
  • 50€/Stunde
  • 65428 Rüsselsheim
  • auf Anfrage
  • hi  |  en  |  de
  • 11.10.2020

Kurzvorstellung

I am an experienced Business intelligence and Data Warehousing specialist. I have more than 10+ years of experience in building and delivering BI solutions using MicroStrategy. My experience covers all aspects of the BI project lifecycle.

Auszug Referenzen (5)

"S. must have provided the reference letter from Wirecard"
Solution Architect (Festanstellung)
Kundenname anonymisiert
Tätigkeitszeitraum

8/2016 – 10/2019

Tätigkeitsbeschreibung

 Work with clients and different stakeholders to understand requirements and sprint goals
 Document requirements and share high level design diagrams and mockups with clients
 Collaboration with data integration team to provide data model required for front end analysis
 Participate in design discussions and reviews, and manage work items in JIRA
 Analyze requirements to create task breakdowns and estimations
 Review unit test SQLs, reports and dashboards for MicroStrategy development
 Create attributes, facts and setup relationships for establishing MSTR model
 Create complex metrics and reports, and build POCs for challenging requirements

Eingesetzte Qualifikationen

MicroStrategy, SQL

"S. must have provided the experience letter provided by Infosys"
Senior Associate consultant (Festanstellung)
Kundenname anonymisiert
Tätigkeitszeitraum

7/2015 – 6/2020

Tätigkeitsbeschreibung

Worked as an onsite Business Intelligence and Analytics consultant for CRM project
Responsibilities:
 Understood the business processes and system, and analyzed pre-trip and post-trip data
 Leading and mentoring the reporting team
 Leading the client calls for the reporting part
 Understand client requirements and suggest them report and dashboard design
 Creating mock ups
 Designing reporting data model
 Building proof of concepts for certain new features asked by the clients
 Designing the schema layer or semantic layer for MSTR reporting and ad-hoc reporting
 Designing, implementation, testing and delivery of reports• Troubleshooting of issues if faced by reporting team
 Creating users and maintaining security using security filters and ACLs
 Migrating objects from DEV to PROD environment using object manager
 Created Test cases as a part of Unit Testing of the generated Reports

Eingesetzte Qualifikationen

Business Intelligence (BI), MicroStrategy, SQL, Confluence (Atlassian), Jira

"S. must have provided the experience letter provided by Infosys"
Senior Associate consultant (Festanstellung)
Kundenname anonymisiert
Tätigkeitszeitraum

12/2012 – 12/2015

Tätigkeitsbeschreibung

Worked as Consultant for different projects with Avon, Diageo and Adidas for developing reports, dashboards and mobile apps

Responsibilities:
 Understood the business processes and system, and analyzed pre-trip and post-trip data
 Leading and mentoring the reporting team
 Leading the client calls for the reporting part
 Understand client requirements and suggest them report and dashboard design
 Creating mock ups
 Designing reporting data model
 Building proof of concepts for certain new features asked by the clients
 Designing the schema layer or semantic layer for MSTR reporting and ad-hoc reporting
 Designing, implementation, testing and delivery of reports• Troubleshooting of issues if faced by reporting team
 Creating users and maintaining security using security filters and ACLs
 Migrating objects from DEV to PROD environment using object manager
 Created Test cases as a part of Unit Testing of the generated Reports

Eingesetzte Qualifikationen

Business Intelligence (BI), MicroStrategy, SQL

"S. must have attached the experience letter from ZS"
Business Technology Associate
Kundenname anonymisiert
Tätigkeitszeitraum

12/2010 – 12/2012

Tätigkeitsbeschreibung

Worked as MicroStrategy Expert for multiple customers like Eisai Pfizer, Abbott, Novartis, Allergan, Novo Nordisk etc. to provide reporting solutions.

Responsibilities:
 Analyzed the reports in Excel and rebuilt them in MicroStrategy
Redesigning report mock ups based on already existing excel reports
 Test the feasibility of the features beforehand
 Interact with clients to reviewing the mock ups and getting their feedback
 Providing the physical data model to the ETL team
 Creating the schema layer and semantic layer for reporting
 Creating application objects for normal and ad-hoc reporting
 Optimizing reports performance by tweaking SQL generated by MSTR
 Optimizing reports better excel and pdf exports
 Data testing using custom SQLs
 Maintaining users access and data security using security roles, ACLs and security filters
 Taking care of object migration between DEV and PROD

Eingesetzte Qualifikationen

Business Intelligence (BI), MicroStrategy, SQL

"S. must have provided the experience letter provided by InfoCepts"
Data Warehouse Associate
Kundenname anonymisiert
Tätigkeitszeitraum

12/2008 – 12/2010

Tätigkeitsbeschreibung

Worked as MicroStrategy Developer with SDI Health to create flash dashboards and ad hoc reports to help their management to take efficient decisions
Tools : MicroStrategy 9.x, Oracle
SDI is a healthcare analytics organization that provides innovative services that help the healthcare industry solve a wide range of business challenges. It is now acquired by IMS health.
Responsibilities:
 Worked as a MicroStrategy developer in the reporting team
 Creating schema objects like facts, attributes and Hierarchy
 Created all kinds of metrics, filters, reports, custom groups and consolidations
 Creating all kinds of prompts to support automated ad-hoc reporting
 Designed mockups and created mainly flash dashboards and iPad dashboards for Safari browsers
 Data testing using custom SQLs
 Attending client calls for report feedback

Eingesetzte Qualifikationen

Business Intelligence (BI), MicroStrategy, SQL

Qualifikationen

  • Business Intelligence (BI)
  • Data Modeling
  • Data Warehousing
  • MicroStrategy
  • Python
  • SQL

Projekt‐ & Berufserfahrung

IT Consultant (Festanstellung)
Lufthansa Industry Solutions, Frankfurt
12/2018 – offen (5 Jahre, 4 Monate)
IT & Entwicklung
Tätigkeitszeitraum

12/2018 – offen

Tätigkeitsbeschreibung

 Work with clients and different stakeholders to understand requirements and sprint goals
 Document requirements and share high level design diagrams and mockups with clients
 Collaboration with data integration team to provide data model required for front end analysis
 Participate in design discussions and reviews, and manage work items in JIRA
 Analyze requirements to create task breakdowns and estimations
 Review unit test SQLs, reports and dashboards for MicroStrategy development
 Create attributes, facts and setup relationships for establishing MSTR model
 Create complex metrics and reports, and build POCs for challenging requirements

Eingesetzte Qualifikationen

Business Intelligence (BI), MicroStrategy, SQL, Python

Solution Architect (Festanstellung)
Wirecard Technologies, Munich
8/2016 – 10/2019 (3 Jahre, 3 Monate)
Banken
Tätigkeitszeitraum

8/2016 – 10/2019

Tätigkeitsbeschreibung

 Work with clients and different stakeholders to understand requirements and sprint goals
 Document requirements and share high level design diagrams and mockups with clients
 Collaboration with data integration team to provide data model required for front end analysis
 Participate in design discussions and reviews, and manage work items in JIRA
 Analyze requirements to create task breakdowns and estimations
 Review unit test SQLs, reports and dashboards for MicroStrategy development
 Create attributes, facts and setup relationships for establishing MSTR model
 Create complex metrics and reports, and build POCs for challenging requirements

Eingesetzte Qualifikationen

MicroStrategy, SQL

Senior Associate consultant (Festanstellung)
Adidas, Herzogenaurach
7/2015 – 6/2020 (5 Jahre)
IT & Entwicklung
Tätigkeitszeitraum

7/2015 – 6/2020

Tätigkeitsbeschreibung

Worked as an onsite Business Intelligence and Analytics consultant for CRM project
Responsibilities:
 Understood the business processes and system, and analyzed pre-trip and post-trip data
 Leading and mentoring the reporting team
 Leading the client calls for the reporting part
 Understand client requirements and suggest them report and dashboard design
 Creating mock ups
 Designing reporting data model
 Building proof of concepts for certain new features asked by the clients
 Designing the schema layer or semantic layer for MSTR reporting and ad-hoc reporting
 Designing, implementation, testing and delivery of reports• Troubleshooting of issues if faced by reporting team
 Creating users and maintaining security using security filters and ACLs
 Migrating objects from DEV to PROD environment using object manager
 Created Test cases as a part of Unit Testing of the generated Reports

Eingesetzte Qualifikationen

Business Intelligence (BI), MicroStrategy, SQL, Confluence (Atlassian), Jira

Senior Associate consultant (Festanstellung)
Infosys Consulting, Hyderabad
12/2012 – 12/2015 (3 Jahre, 1 Monat)
IT & Entwicklung
Tätigkeitszeitraum

12/2012 – 12/2015

Tätigkeitsbeschreibung

Worked as Consultant for different projects with Avon, Diageo and Adidas for developing reports, dashboards and mobile apps

Responsibilities:
 Understood the business processes and system, and analyzed pre-trip and post-trip data
 Leading and mentoring the reporting team
 Leading the client calls for the reporting part
 Understand client requirements and suggest them report and dashboard design
 Creating mock ups
 Designing reporting data model
 Building proof of concepts for certain new features asked by the clients
 Designing the schema layer or semantic layer for MSTR reporting and ad-hoc reporting
 Designing, implementation, testing and delivery of reports• Troubleshooting of issues if faced by reporting team
 Creating users and maintaining security using security filters and ACLs
 Migrating objects from DEV to PROD environment using object manager
 Created Test cases as a part of Unit Testing of the generated Reports

Eingesetzte Qualifikationen

Business Intelligence (BI), MicroStrategy, SQL

Business Technology Associate
ZS Associate, Pune
12/2010 – 12/2012 (2 Jahre, 1 Monat)
IT & Entwicklung
Tätigkeitszeitraum

12/2010 – 12/2012

Tätigkeitsbeschreibung

Worked as MicroStrategy Expert for multiple customers like Eisai Pfizer, Abbott, Novartis, Allergan, Novo Nordisk etc. to provide reporting solutions.

Responsibilities:
 Analyzed the reports in Excel and rebuilt them in MicroStrategy
Redesigning report mock ups based on already existing excel reports
 Test the feasibility of the features beforehand
 Interact with clients to reviewing the mock ups and getting their feedback
 Providing the physical data model to the ETL team
 Creating the schema layer and semantic layer for reporting
 Creating application objects for normal and ad-hoc reporting
 Optimizing reports performance by tweaking SQL generated by MSTR
 Optimizing reports better excel and pdf exports
 Data testing using custom SQLs
 Maintaining users access and data security using security roles, ACLs and security filters
 Taking care of object migration between DEV and PROD

Eingesetzte Qualifikationen

Business Intelligence (BI), MicroStrategy, SQL

Data Warehouse Associate
Infocepts, Nagpur
12/2008 – 12/2010 (2 Jahre, 1 Monat)
IT & Entwicklung
Tätigkeitszeitraum

12/2008 – 12/2010

Tätigkeitsbeschreibung

Worked as MicroStrategy Developer with SDI Health to create flash dashboards and ad hoc reports to help their management to take efficient decisions
Tools : MicroStrategy 9.x, Oracle
SDI is a healthcare analytics organization that provides innovative services that help the healthcare industry solve a wide range of business challenges. It is now acquired by IMS health.
Responsibilities:
 Worked as a MicroStrategy developer in the reporting team
 Creating schema objects like facts, attributes and Hierarchy
 Created all kinds of metrics, filters, reports, custom groups and consolidations
 Creating all kinds of prompts to support automated ad-hoc reporting
 Designed mockups and created mainly flash dashboards and iPad dashboards for Safari browsers
 Data testing using custom SQLs
 Attending client calls for report feedback

Eingesetzte Qualifikationen

Business Intelligence (BI), MicroStrategy, SQL

Zertifikate

11.031 MicroStrategy Application Architect
2019
11.019 MicroStrategy Certified Specialist Administrator
2019
11.011 MicroStrategy Analyst Certification
2019
11.032 Analytics Architect (ANA) Qualification Exam
2019
11.413 MicroStrategy Advanced Documents
2019
11.032 MicroStrategy Analytics Architect (ANA)
2019

Weitere Kenntnisse

B.E. Mechanical from Nagpur University

Persönliche Daten

Sprache
  • Englisch (Fließend)
  • Deutsch (Grundkenntnisse)
  • Hindi (Muttersprache)
Reisebereitschaft
auf Anfrage
Arbeitserlaubnis
  • Europäische Union
Home-Office
bevorzugt
Profilaufrufe
705
Alter
36
Berufserfahrung
14 Jahre und 4 Monate (seit 11/2009)
Projektleitung
4 Jahre

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden