Business Intelligence Consultant
- Verfügbarkeit einsehen
- 5 Referenzen
- 50€/Stunde
- 65428 Rüsselsheim
- auf Anfrage
- hi | en | de
- 11.10.2020
Kurzvorstellung
Auszug Referenzen (5)
"S. must have provided the reference letter from Wirecard"
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
Microstrategy, SQL
"S. must have provided the experience letter provided by Infosys"
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
Business Intelligence (BI), Microstrategy, SQL, Confluence, Jira
"S. must have provided the experience letter provided by Infosys"
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
Business Intelligence (BI), Microstrategy, SQL
"S. must have attached the experience letter from ZS"
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
Business Intelligence (BI), Microstrategy, SQL
"S. must have provided the experience letter provided by InfoCepts"
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
Business Intelligence (BI), Microstrategy, SQL
Qualifikationen
Projekt‐ & Berufserfahrung
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
Business Intelligence (BI), Microstrategy, SQL, Python
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
Microstrategy, SQL
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
Business Intelligence (BI), Microstrategy, SQL, Confluence, Jira
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
Business Intelligence (BI), Microstrategy, SQL
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
Business Intelligence (BI), Microstrategy, SQL
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
Business Intelligence (BI), Microstrategy, SQL
Zertifikate
Weitere Kenntnisse
Persönliche Daten
- Englisch (Fließend)
- Deutsch (Grundkenntnisse)
- Hindi (Muttersprache)
- Europäische Union
Kontaktdaten
Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.
Jetzt Mitglied werden