Business Analyst

Hourly rate: members only

Availability: members only

Willingness to travel: Worldwide

Professional status: Freelancer

Last updated: Nov 10, 2024

Total work experience:

Language skills: English,

Personal summary

Project: Creation of Operational Data Store and Analytic Environment Responsibilities: • Data Modeling - Designing high-level conceptual, logical, and physical models based on business requirements. • Data Architect - Designing and implementing Ralph Kimball Dimensional Modeling approaches (Star Schema, Snowflake). Working with OLAP and OLTP tools such as ETL, data warehousing, and modeling. • Data Pipeline – Moving data through the ETL process, defining data mapping and transformation rules, and documenting data quality for projects. • Data Documentation – Producing Bus Matrix and various templates such as Stakeholder Matrix, Source to Target, Process Flow, Test Plan, and Test Case for the Data Warehouse. • Data Migration - Loading data from different source systems into SQL Server Database Environments (Prestaging, Staging, Development, Testing, and Production). • Data Querying - Building, testing, and deploying multidimensional analytic databases (CUBE), calculating measures and dimensions using SSAS, MDX, and T-SQL. • Data Extraction and Integration - Conducted data validation and cleansing to ensure high-quality data for analysis and reporting. • Data Visualization - Developed and deployed complex, interactive dashboards and reports using Power BI ad Tableau to provide actionable insights and support data-driven decision-making. • SQL Scripting - Writing complex SQL queries using advanced SQL concepts like aggregate functions, Group By, and OLAP (Online Analytical Functions). Writing queries to fetch data from different tables by using JOINs, sub-queries, correlated sub-queries, and derived tables on the SQL Server platform. • Business requirement documentation (BRD) - Converting user requirements into business requirements, analyzing them, and segregating them into high-level and low-level business requirements.

Skills