NEBYOU ADANE
Seattle
Summary
Accomplished Senior Business Intelligence Developer with expertise in Azure SQL and ETL processes at Parametric Portfolio. Proven track record in delivering executive-level reporting and enhancing data workflows, driving significant improvements in data quality and governance. Strong analytical skills combined with effective collaboration ensure impactful business intelligence solutions.
Overview
10
10
years of professional experience
Work History
Sr. Business Intelligence Analyst
Virtuosity Consulting Group
Redmond
04.2019 - Current
- Created/Analyzed multiple audit mail alert using Audit Framework in SQL Server and setup SQL Server Jobs.
- Monitor daily jobs, trouble shoot and debug any job failure.
- Wrote dynamic Stored Procedures, new stored procedures, T-SQL and modifying existing ones and tune them such they perform well.
- Gathered requirements from Program Manager to pull data from various systems to create Power BI reports.
- Created Power BI Report/dashboard to monitor SQL Server Job for all environment for MS Sales Team.
- Microsoft
Senior Business Intelligence Developer
Parametric Portfolio
03.2020 - 03.2025
- Designed and created an Azure SQL database to support paginated reports for Custom Core, Fixed Income, and other products.
- Designed and implemented data workflows using Alteryx to bring in flat files for index data from multiple systems to be used by Portfolio Managers on a daily basis; enabling complex data blending and advanced analytics.
- Developed executive-level reporting for the documentation and trade team using Tableau, leveraging data from Snowflake and multiple in-house data sources (e.g., trade, positions, and account/client data).
- Built multiple external client-facing paginated reports using Seismic for the Marketing and Sales team.
- Managed multiple projects for Data Governance and the Service Team, focusing on data quality rules, data masking, and data cataloging. These projects were a top priority for Parametric Portfolio following the acquisition by Morgan Stanley, requiring that all data provided to Morgan Stanley be thoroughly tested, documented, and defined.
- Acted as the Subject Matter Expert (SME) between the Data Service Team and the Site Reliability Team to maintain all Azure services, including deploying new services and supporting existing services.
- Responsible for deploying Azure SQL databases to production, adhering to the full software development lifecycle (SDLC) and utilizing DevOps, Octopus, and/or TeamCity.
- Collaborated with various teams, including Release Team, QA, Business Users, and Technology Owners.
- Designed and implemented data analysis workflows using Azure Data Explorer and Kusto query language, enabling efficient querying and visualization of complex datasets to support business intelligence initiatives.
- Morgan Stanley
Senior Business Intelligence Developer
AIM Consulting
08.2019 - 03.2020
- Designed, developed, and implemented SSIS packages, store procedures, configuration files, tables, views, and functions.
- Worked on all phases of data warehouse development lifecycle, from requirements to testing, implementation, and support.
- Designed and implemented automated application system to capture worldwide SAP Sales data into list flat files, loading the data into data warehouse using SSIS for reporting purpose and audit purposes on top of Microsoft SQL Server 2017/SSIS/Tabular model data warehouse and PowerBI.
- Analyzed existing ETL processes, writing ETL SSIS standard documentation.
- Rewrote existing ETL process from store procedure to SSIS focusing flat file dataset.
- Responsible for requirements gathering, changing business logic into technical requirements and development.
- Designed, developed, and delivered high-level ETL design documents, detail design documents including back-end development of SSIS, and delivery of automated jobs, reports customization via Power BI.
- Conducted code walkthroughs and peer review for code and documentation.
- Built efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
- Wrote dynamic stored procedures, new stored procedures, T-SQL and modified existing ones.
- Created multiple audit mail alerts using audit framework in SQL Server, configuring the job to trigger them.
- Gathered report requirements and designed and deployed Power BI reports using SQL and Kusto Query.
- Responsible for writing Kusto queries for larger dataset to develop Power BI reports.
Sr. Business Intelligence Developer
AIM Consulting Group
Redmond/Seattle
06.2017 - 04.2019
- Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement.
- Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
- Designing and Implementing automated application system to capture worldwide SAP Sales data into list Flat files and load the data into data warehouse using SSIS for reporting purpose and audit purposes on top of Microsoft SQL Server 2017/SSIS/Tabular Model Datawarehouse and PowerBI.
- Analyze overall existing ETL processes and write ETL SSIS standard documentation.
- Re-write the existing ETL process from store procedure to SSIS focusing FlatFile dataset.
- Requirements gathering, changing business logic into technical requirements and development.
- Design, develop and deliver High level ETL design document, detail design documents including back-end development of SSIS, and delivery of automated jobs, reports customization via Power BI.
- Conduct code walkthroughs and peer review for code and documentation.
- Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
- Wrote dynamic Stored Procedures, new stored procedures, T-SQL and modifying existing ones and tune them such they perform well.
- Gather report requirements, design and deploy Power BI Reports using SQL and Kusto Query.
- Responsible for writing Kusto Queries for Larger dataset to develop Power BI Reports.
- Automate ETL and Cube refresh process using SQL Agent Job.
- Monitor daily jobs, trouble shoot and debug any job failure.
- Microsoft/Marcus & Millichap Real Estate Clients
Sr. Business Intelligence/Tableau Developer
Rylem Consulting
Seattle
10.2016 - 06.2017
- Worked on Product, Sales and Marketing Team Tutoring platform called Varsity, designed to help students connect OnDemand with tutors 24/7. Tasked to reduce Sales Packages refund rate from 12% to under 5%.
- Supporting internal stakeholders by providing business reporting, analysis of results, identification of opportunities & successes and updates on progress toward goals and strategies.
- Analyze & validate data in partnership with the business owners to identify trends, problems areas, and opportunities for improving customer experience.
- Helped the team Re-engineered various features to improve product reliability and compatibility for better use of our customers.
- Collected Datasets and Reports feedback from internal partner team members (test, development, and program management) as early as possible and looped back the feedback.
- Gathered requirements from Product Owners and C-Level Executives to pull data from various systems to make Executive level End to End System view Dashboard using Tableau 10.1.
- Prepared Complex datasets using Toad on Amazon Redshift.
- Expertise on bringing data from internal/external source system into Tableau, create relationship and build reports.
- Expertise on creating calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
- Extensively used data blending, embed functionalities in Tableau.
- Deployed various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
- Prepared optimized Stored Procedure with 100+ columns for Regression analysis.
- Prepared 20+ Stored Procedure and Views for Self Service Looker Reports.
- Worked with web developers to add new features (fields) into Databases using SSIS.
- Created documentations for all Datasets as well as reports.
- Varsity Tutor
Sr. Business Intelligence Developer
Populus Group
Redmond
05.2016 - 10.2016
BI Developerand/ Data Analyst Microsoft, Premera Blue Cross, T-Mobile USA
- Built ETL pipelines, reporting databases, and dashboards using SQL Server, SSIS, SSRS, Excel, and Power BI.
- Supported enterprise analytics, operational reporting, and data migrations across multiple business domains.
Education
Bachelor of Arts - Business Administration, Management Information Systems
Washington State University College of Business
Pullman, WA05.2013
Associate - Information Technology in Networking
North Seattle Community College
Seattle, WA06.2010
Skills
- Data Warehouse Tools
- MS SQL Server
- Azure SQL Cloud Database
- Analysis Services
- ETL SSIS
- MS-Access
- Snowflake
- Azure Synapse
- Databricks
- Azure Data Factory
- Development Support Tools
- Requirements Management
- Visual Studio Online
- Configuration Management
- Change Management
- TFS
- Build
- MSBuild
- Azure DevOps
- Octopus
- Team City
- Peer Review Tools
- Code Review
- Defect Tracking
- Programming Languages
- T-SQL
- PL/SQL
- SSMS
- Teradata
- Oracle
- TOAD clients
- Kusto
- Reporting Tools
- SQL Server Reporting Services
- Excel
- Tableau
- Power BI
- Looker
- BOE
- Cache
- Seismic
- System Development Life Cycles Exposure
- Agile
- Scrum
- RDA
- Operating Systems
- Win 7
- Win 10
- Mac OS
- Windows 2012 server
- Win 3x
- Win 95
- Win 98
- Vista
- Unix
- Data governance
Core Competencies
MS SQL Server on-prem and Azure SQL Cloud Database, Analysis Services, ETL SSIS, MS-Access, Snowflake, Azure Synapse, Databricks, Azure Data Factory, Visual Studio Online (VSO), TFS, MSBuild, Azure DevOps, Octopus, Team City, Code Review feature in Visual Studio 2012, TFS, T-SQL, PL/SQL (SSMS, Teradata, Oracle, TOAD clients), Kusto, SQL Server 2005/2008 Reporting Services, Excel, Tableau, Power BI, Looker, BOE, Cache, Kusto, Seismic, Agile (using Azure DevOps & GitHub for version control and CI/CD), Scrum, RDA, Win 7, Win 10, Mac OS, Windows 2012 server, Win 3.x/95/98, Vista, Unix
Qualifications Summary
10+ years of experience in analysis, reporting, design, development of Business Intelligence solutions. Expert in developing ETL Packages using Microsoft SSIS, Data Factory, Alteryx to Extract Transfer and Load Data between databases or file system to an external data sources using T-SQL and Any ETL Tools. Creating reports and dashboards using Power BI, Tableau, Excel, BOE, Seismic, and SQL Server Reporting Services (SSRS). Database development with On-prem SQL Server (2008-2019), Azure SQL Database, Snowflake, including T-SQL scripting, stored procedures, triggers, views, and security. Working with Azure Data Explorer and Kusto, Azure Synapse, and Databricks. Data transformation and automation using Alteryx. Software/Database Release Tool – Github, Azure DevOps, Octopus, and Team City for CI/CD. Azure Batch Tool for batch processing. Expertise with Confluence and Jira for Project management and documentation.
Timeline
Senior Business Intelligence Developer
Parametric Portfolio
03.2020 - 03.2025
Senior Business Intelligence Developer
AIM Consulting
08.2019 - 03.2020
Sr. Business Intelligence Analyst
Virtuosity Consulting Group
04.2019 - Current
Sr. Business Intelligence Developer
AIM Consulting Group
06.2017 - 04.2019
Sr. Business Intelligence/Tableau Developer
Rylem Consulting
10.2016 - 06.2017
Sr. Business Intelligence Developer
Populus Group
05.2016 - 10.2016
Bachelor of Arts - Business Administration, Management Information Systems
Washington State University College of Business
Associate - Information Technology in Networking
North Seattle Community College