BI Specialist - Technical Consultant
Sword Group
Total des années d'expérience :14 years, 11 Mois
Microsoft BI tool including Integration\Analysis\Reporting layers
•Outsourcing services including planning, installation and business analysis
•European Client like Migros Switzerland, UEFA, Orange…
•Implementation and support on clients site including development and analysis
•GIT repository for source code management system
•Visual Studio community 2013
•SQL Server 2014 Management Studio
, Professional Services, and Technical Consultant (Banking System Solution).
•Databases:
• PL/SQL - Oracle
• ASE SQL - Sybase
• T-SQL - SQL Server.
•Development using PowerBuilder.
•Follow up and support on UAT environment till live environment.
•Knowledge of data warehouse methodologies, analysis, design and data modeling.
•Managed/trained new employees and follow up/review with their tasks.
•Kimball methodology/Dimensional modeling
•Reporting tools:
•Microsoft BI products (SSIS, SSAS and SSRS).
•Report Builder, Report Designer
•Analysis services: Multi-dimensional Cubes design, tabular mode.
•Integration, Packaging, Staging…
•SharePoint 2013, SQL Server 2012
•SSRS© reporting services.
•Excel 2013 power pivot services.
•Power Query, Power Map, Power View, Power Pivot
•Performance point services on top of SharePoint
•SQL, MDX and DAX queries
•Visokio Omniscope© report for analysis, forecasting and decision makers. (Targeting the CEOs and executives)
•QlikView reporting tool
•Oracle Hyperion© Interactive Reports
•DataZen Mobile reporting tool.
•CMMI certification process improvement (BRS, SRS, TDD, DEE, TVRC).
•Experience in writing complex and database profiling techniques using SQL
•Follow the development standards and documentation in terms of specifications analyst.
•Experience in Banking/Financing Business.
•MCSE certified.
•Supervisor & distribution of tasks inside the team.
•Risk management business knowledge (B)
•Client support and follow up of the installation and bug fixing on UAT environment.
•Work with BI Architect and the end users to design and build the Business Components of a Business intelligence data warehouse
•Write relational and multidimensional database queries
•SQL performance tuning.
•Diagnosing and repairing Client and Performance issues and Modify existing solution to fix bugs
•Develop Microsoft BI solution proof of concepts (POC's)
•Provide Customer with BI Awareness Presentations/Sessions and fundamentals of BI Technologies
•Ensure design meets Business Requirements, Architecture specifications and Quality standards within Best Practices
•Recommends appropriate BI solutions design to improve implementation process efficiency
•POC and R&D tasks
•Basic knowledge: Java Scripts, C#, C++, Java and Oracle reports and forms.
•Agile software: (Target Process, Scrum meeting)
•Risk Management (Credit Risk, Market Risk and Operational Risk)
•Client Presentation and demonstration on application
- Soft Solutions Company - Jdeideh - Lebanon (2 years).
As Client/Application Support, Business Intelligence Analyst and Database Model (Modeling Business Intelligence - Retail System Solution).
•Development using PL/SQL tool for Oracle db and Power AMC design for the creation of the ERD diagrams representation and train new comers for the system usage.
•Experience in Retail Business.
•Client support and follow up of the installation
•Responsible for writing the specification book and technical document.
•Data modeling design and data warehouse architecture for BI reports.
•Diagnosing and repairing Client and Performance issues and Modify existing solution to fix bugs
•Application support and bug fixing for the missing scripts on the UAT environment.
•Writing Software Requirement Specification (SRS), Technical Design Document (TDD) and communicate with the client about the business requested.
As Client/Application Support, Business Intelligence Analyst and Database Model (Modeling Business Intelligence - Retail System Solution).
•Development using PL/SQL tool for Oracle db and Power AMC design for the creation of the ERD diagrams representation and train new comers for the system usage.
•Experience in Retail Business.
•Client support and follow up of the installation
•Responsible for writing the specification book and technical document.
•Data modeling design and data warehouse architecture for BI reports.
•Diagnosing and repairing Client and Performance issues and Modify existing solution to fix bugs
•Application support and bug fixing for the missing scripts on the UAT environment.
•Writing Software Requirement Specification (SRS), Technical Design Document (TDD) and communicate with the client about the business requested.
•POC and R&D tasks
Education
: