Senior Business Intelligence Consultant Microstrategy
- Verfügbarkeit einsehen
- 0 Referenzen
- auf Anfrage
- 300254 timisoara
- Europa
- en
- 24.02.2022
Kurzvorstellung
Qualifikationen
Projekt‐ & Berufserfahrung
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
Power Bi, Microstrategy, Oracle Business Intelligence (BI), Informatica, Teradata Sql
Ausbildung
India
Über mich
• 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
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
- Englisch (Muttersprache)
Kontaktdaten
Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.
Jetzt Mitglied werden