freiberufler Senior Business Intelligence Consultant Microstrategy auf freelance.de

Senior Business Intelligence Consultant Microstrategy

offline
  • auf Anfrage
  • 300254 timisoara
  • Europa
  • en
  • 24.02.2022

Kurzvorstellung

11 years of experience in BI using Microstrategy, Informatica, Power BI, Oracle & Teradata

Qualifikationen

  • Informatica3 J.
  • Microstrategy3 J.
  • Oracle
  • Oracle Business Intelligence (BI)3 J.
  • Power Bi3 J.
  • redshift
  • Teradata Sql3 J.

Projekt‐ & Berufserfahrung

Senior BI Consultant
Emirates Airlines, Dubai
1/2016 – 8/2019 (3 Jahre, 8 Monate)
Luft- und Raumfahrtindustrie
Tätigkeitszeitraum

1/2016 – 8/2019

Tätigkeitsbeschreibung

• Involved in preparing the data modelling
• Involved in Requirements gathering with the business.
• Worked with BA’s team to understand their requirements
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Developed mappings to load into staging tables and then to Dimensions and Facts
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Working in creating Visual Analysis Dashboards
• Created different application objects
• Worked on Architect Graphical Interface to develop Schema objects
• Expertise in Transaction Services and Freeform SQL reports
• Involved in Business meetings and prepared requirement documents
• Created Intelligent cubes to optimize the report performance

Eingesetzte Qualifikationen

Power Bi, Microstrategy, Oracle Business Intelligence (BI), Informatica, Teradata Sql

Ausbildung

Bachelor of Technology in Engineering
Btech
2009
India

Über mich

• Having 9+ years of Data warehousing experience in MicroStrategy, Informatica & Power BI
• Strong Data Warehousing ETL experience of using Informatica 9X/10X Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor
• Knowledge on creating Data Model
• Strong experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes in Teradata and Oracle
• Having Knowledge on universe design of BO XIR3
• Well versed and experienced in Dimensional Data Modeling Star Schema, Snow-Flake Schema Data Architecture
• Experience in creation on Schema Objects like Facts, Attributes, Hierarchies, Transformations
• Well versed experienced in creation of public objects like Metrics, Filters, Prompts, Custom Groups, Consolidations and Documents
• Experience in using MicroStrategy Desktop, Intelligence Server, and Web
• Experience in using Object Manager, Integrity Manager & Project Configuration
• Experience in creation of Dashboards, scorecards and documents
• Experience in RDBMS, database Normalization and Denormalization concepts and principles
• Created tables and views based on the layout sent by Clients
• Create Reports with formatting or standard templates, Applying sorts sharing existing reports
• Analysis, Design and Development on Adhoc Reporting to provide quick resolution
• Knowledge in creating Dashboard Reports to view personalized reports based on user requirements
• Well versed experience of Intelligent cubes and Knowledge on VLDB properties
• Created Various Transformations like Expression, Table
• Created web intelligence reports in Business objects
• Proficient in the Integration of various data sources with multiple relational databases like Oracle12c/Oracle 11g, MS SQL Server, DB2, Teradata and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.

Weitere Kenntnisse

Database : Oracle 10g, Teradata, Postgres
Programming Languages : SQL
OLAP Tools : MicroStrategy 9X, 10X, Microsoft Power BI
ETL Tools : Informatica Power Center 9X, 10X
Operating Systems : Windows 2000/XP

Persönliche Daten

Sprache
  • Englisch (Muttersprache)
Reisebereitschaft
Europa
Profilaufrufe
1067
Alter
36
Berufserfahrung
14 Jahre und 10 Monate (seit 01/2010)
Projektleitung
3 Jahre

Kontaktdaten

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

Jetzt Mitglied werden