Sallah Ali Email & Phone Number

Seattle, Washington, United States

MicrosoftGDC Signal Flow Health Operations Reporting (SFHOR)

Seattle

Blue Cross Blue Sheild Association (BCBSA)Blue Distinction Program.

Greater Seattle Area

Bill & Melinda Gates FoundationData Science Services

Seattle, Washington, United States

• Evaluate business requirements and translate data into visually informative dashboards andcustomized reporting solutions.• Maintain existing BI reporting processes, and introduce new and innovative data visualization Techniques.• Maintain the integrity and performance of databases across all WMI projects.• Perform general maintenance and ETL support for data warehouse and BI data sources.• Design and deliver end-user training, materials, and project documentation.• Collaborate with project managers, engineers, and other members of the WMI team to deliverexceptional results

Bellevue, Washington, United States

• Develop Business Intelligence solutions for company-wide performance reporting needs• Build and manage Extraction, Loading, and Transformation (ELT) of data from varieties of databases and applications.• Design, develop and implement technical solutions for building data marts from specific applications.• Assist in defining business and technical requirements.• Actively participate in design sessions and work closely with data analysts, business analysts, and IT staff• Analyze data and identify gaps, data quality, and integrity issues.• Create and maintain system documentation, including a data dictionary.• Develop, execute and maintain test scripts.• Troubleshoot issues to ensure ETL jobs run as designed and meet customer needs.• Working closely with IT peers, ensure the needs and expectations of organizational stakeholders, business partners, external customers, and third-party organizations are met and/or exceeded.

(Microsoft Cloud & Infrastructure)

• Design: Design ETL solutions in a data warehouse environment using SQL tools and SSIS to gather data from multiple data sources.• Development: Develop reports and data visualization by utilizing Excel, SSRS and Power BI.• Business Requirements: Work with business and stockholders to identify and resolve outstanding issues, areas of improvement and gather requirements.• Functional Testing: Creating test cases to ensure data availability and quality.• Data Migration: Seamlessly migrate database objects and reports from old environments to a newly deployed server.• DBA Support: Provide basic DBA support for issues related to server performance and maintenance.• Program Management: Drive and self-manage multiple products and/or projects that range from new implementations to enhancements of current products and services (Main Focus is on Reporting Infrastructure).• Reporting Audience: Create and publish various types of reports (Spend, Cost efficiency, Forecast, Install Base, Risk Management...etc.) to multiple levels of management all the way up to the General Manager.

Greater Seattle Area

• Responsible for analysis, development, modification, implementation of major reporting services.• Develop business application reports in a client/server and data warehouse environment using SQL, SSRS, Power Pivot, and Excel with SharePoint integration.• Design and development SQL scripts and queries to implement ETL processes using SSIS and other SQL tools to crated reportable data from various types of data sources such data warehouses, excel or flat files and Analytics APIs.• Work closely with Business Stakeholders to gather requirements and translate them into effective reporting solutions.• Evaluate and prioritize Defect Reports and Change Requests.• Create and/or update Requirement, Process, Design and Technical Documentation.

Microsoft (Bing Finance)

This project is to help the Project Architect to designing and structure the V3 version of the Bing Search financial reporting platform.• Help redefine the new parameters for Monetized searches and adds for Bing.com• Implements design changes to the database, SSIS and SSAS packages to accommodate these changes.• Make recommendations and apply code and database changes to improve performance.• Test code and work flow of the process from A to Z to see if all the moving parts are working as intended.• Validate reporting data against V2 to insure reporting accuracy and a transparent transition.• Migrate the new Database and Solutions to production server.

Microsoft (Get2Modern Campaign)

• Help Get2Modern campaign better track partner performance.• Develop ETL Solutions to automate reporting using SQL 2012, SSIS/SSAS, Excel 2013 and SharePoint.• Optimize and restructure existing data sources for better project-specific reporting.• Design and Implement enhancements to new and existing reports and report’s logic and structure.• Utilize MS Sales (MSRA) as one of the data sources to produce Power View reports.• Engage stakeholders for fact finding and business requirements gathering.• Reduce 120 + hours/Month of billable hours to merely 3 - 4 hours/Month.• Create Training and Product Description documentation.

Auburn, Washington

• Work with DBA team to ensure proper data management and archiving.• Manage existing and develop new ETL (SSIS) solutions to establish solid data transformation methods.• Fine-tune existing SQL scripts, Store Procedures and ETL solutions to improve system performance and system resource management. • Manage existing and develop new SharePoint reports (SSRS) using SQL and SSAS data sources.• Insure data integrity with proper data validation for data moving between enterprise data sources.• Monitor overall data and develop solutions for existing data quality issues.• Develop a framework and implement security policies for SSAS cube.• Communicate with programming and BSA teams to provide details on the proper use of available data resources.• Increase the internal consistency of data and resolve existing data quality issues.• Create solutions to allow a relational/multi-dimensional OLAP environment to interact with existing OLTP database structures.

Microsoft (Xbox Reasearch And Bi Group)

• Manage and maintain all reporting Databases.• Recommend and deploy upgrades and enhancements.• Administer all standard and ad-hoc PowerPivot reporting.• Compile and process data source files from POS vendors.• Define and implement standardized file formats.• Validate then import data exceptions using MDS or SQL scripting.• Research and complete missing metadata associated with new data.• Investigate and review apparent anomalies in data and apply changes to reports or database.• Create and enhance ETL processes, SQL jobs and SSIS packages.• Facilitate communication with all cross-functional teams.Achievements:===========Program Management:---------------------------------• Successfully utilizing valuable features from decommissioned systems and passed them through to newer ones that were still being under development. • Created an alternative reporting solution that provided easier PowerPivot access to metrics for XboxLive “Click Stream Data” on consoles worldwide. Business Impact: -------------------------• Helped and was responsible for the transition and sign-off to a new system that is better automated and requires minimal human interaction and input which resulted in the elevation of two positions in addition to mine causing an annual cut in billable hours of about $160K.• Cut training coast by being reducing the time it takes and by providing it remotely to the new team in India instead of flying a person to provide it on location.

Vocational Degree, Computer Systems Networking And Telecommunications

Certificates MCSE, CNA, A+

Associate'S Degree, Business Management

Master Of Arts (Ma), Music Performance, General