• Analyze, design, develop, implement, test, document, and operate large-scale, high-volume, high-performance data models, reports, dashboards, and other BI solutions for analytics based on business requirements and technical specifications using the Microsoft BI Platform (MS SQL Server, Power BI)• Gathering Business Requirements and Designing a Fact and dimensional Table to initialize a star schema for creating a physical KPI store database with MS SQL Server using the Erwin Data Modeling… Show more • Analyze, design, develop, implement, test, document, and operate large-scale, high-volume, high-performance data models, reports, dashboards, and other BI solutions for analytics based on business requirements and technical specifications using the Microsoft BI Platform (MS SQL Server, Power BI)• Gathering Business Requirements and Designing a Fact and dimensional Table to initialize a star schema for creating a physical KPI store database with MS SQL Server using the Erwin Data Modeling tool.• SQL Development - Writing SQL queries like CTE (Common Table Expression), Views, and Stored Procedure.• Created, modified, and troubleshoot paginated reports using both SSRS and Power BI Report Builder. • Design, build, and deploy Power BI solutions (e.g., datasets, reports and dashboards, visualizations) and Power Apps.• Assist with the enhancement of existing high-visibility dashboards and provide technical support and troubleshooting of Power BI reporting and Power App solutions.• Power BI Administration- Creating role-level security, subscribing users to the report page, giving access to users, and embedding reports in the Azure active directory app.• Developing KPI reports based on business requirements, creating intuitive dashboards using Power BI for quick reviews to be presented to Business and IT users for enhanced business decision-making.• Experience in the design and development of Reports and dashboards, Sub-Reports, drill-down reports, drill-through reports, Parameterized reports, and Chart reports using SSRS. • Used Power BI Gateways to keep the dashboards and reports up to date. Show less

• Developed customized reports and dashboards for different user groups, stakeholders, and management entities for full activity tracking within the organization.• Patched software and installed new versions to eliminate security problems while protecting data.• Collaborated with stakeholders to drive communication and coordination of toll activities while promoting accountability. • Monitored data quality, accuracy, and completeness. • Served as the department point of contact… Show more • Developed customized reports and dashboards for different user groups, stakeholders, and management entities for full activity tracking within the organization.• Patched software and installed new versions to eliminate security problems while protecting data.• Collaborated with stakeholders to drive communication and coordination of toll activities while promoting accountability. • Monitored data quality, accuracy, and completeness. • Served as the department point of contact for data requests and ad hoc reporting.• Developed and implemented data models and databases to support business requirements.• Worked with business users to gather requirements in different forms and documented data.• Used predictive modeling techniques and tools, such as linear regression, decision trees, and random forests, to develop models to help predict the likelihood of traffic conditions and identify trends.• Manipulated data using VLOOKUP and Pivot Table in Excel. • Analyzed business objectives in relationship with information systems to identify feasible solutions.• Developed and prepared financial business analysis and research related to the performance of Electronic Toll Systems. Show less