Alex Carmichael Email & Phone Number

Portland, Or, Us

Portland, Or, Us

Same position as Marquam (below). New name, same position.

Portland, Oregon, Us

Collaborates with Microsoft clients to provide business intelligence design expertise for PowerBI and Azure Machine Learning implementations. Leads data and analytics teams in specialty applications across 3-5 concurrent client design and implementation projects. Builds, improves and maintains PowerBI reports, data sources and dashboards to optimize reporting performance, accuracy and data security. Data engineer designing and implementing data sources, ETL/ELT pipelines, data marts and data warehouses. Top-billing Data and Analytics Consultant bringing in $1.25M in revenue.• Trains clients and coworkers in PowerBI technology including designing data models. • Builds data sets to client requirements, creating and enhancing enterprise PowerBI solutions.• Develops complex SQL, PowerQuery and DAX queries, procedures and transformations.• Creates data pipelines using MS Fabric, SSIS and Azure Data Factory software.• Establishes and documents BI, data warehousing and reporting best practices.• Founded a machine learning consulting practice within the organization to educate clients.• Creates Machine Learning, optimization, and predictive analytics models within Azure Machine Learning Studio, R, and Power BI AutoML.• Trains clients on data security, QA testing, and Software Development Life Cycle best practices or seamlessly integrates with clients’ existing processes.• Cross-trains and leads other consultants in data engineering, modeling, and visualization skills.

Pioneered analysis of student data to drive graduation statistics and improve pre-dropout intervention practices. Implemented a machine learning model (R and Alteryx) to evaluate student performance, resulting in strategies to increase student test scores and graduation rates. • Developed expertise in Tableau, qGIS, Alteryx, SSRS/SSIS, R and PowerBI.• Designed, created and deployed Tableau dashboards with student analytics for district leaders.• Established complex data manipulation and visualization best practices.• Collaborated on Kimball-method modeling and design of MS SQL Server Data Warehouse.

Salem, Oregon, Us

Managed a team of Business Intelligence and Analytics engineers creating ad-hoc and periodic data analysis for sales statistics. Responsible for leading department vision and planning process as well as the budget. Collaborated with the board of directors and executive team members to envision and implement strategic plans, initiatives and develop companywide KPIs. Served as chair of the Deposit Committee, overseeing rates and general strategies for customer financial portfolios.• Developed expertise in PL-SQL, t-SQL, Crystal Reports, Oracle Microsoft SQL and PowerBI.• Maintained enterprise wide BusinessObjects reporting framework of 1,000+ scheduled outputs.• Managed proprietary customer information SQL database.• Built a SQL server data warehouse from scratch to simplify enterprise reporting.• Created new banking products from idea stage through research and development to market.

Salem, Or, Us

Utilized machine learning including Neural Nets, C5.0/C&RT, K-Means, GRI, Factor Analysis and Regression to collaborate with clients in developing custom data analytics solutions. Created, refined and updated enrollment prediction model using SPSS-Clementine Data Mining Software.• Modeled admissions data more precisely than contractor resulting in $35K per year savings.• Identified 8 main drivers of student admissions to create a statistical analysis model.

Minneapolis, Mn, Us

Mined commercial loan database to identify emerging risks in industries, geographies, and loan structuresEmployed advanced statistical modeling to identify pools of unidentified risks in commercial loan portfolioTracked employee and overall portfolio performance by asset class, risk rating, and product typeCreated, developed, and implemented quarterly management report and credit risk publicationProvided independent statistical oversight to the bank’s Basel II Compliance process

Salem, Oregon, Us

Performed routine and ad-hoc statistical reportingGathered and reported data used to inform top-level business decisionsCreated and developed new products from idea stage through research, development, and to marketManaged SQL-based customer information databaseCo-chaired Deposit Committee, overseeing general strategies for the deposit portfolioSupervised and directed monthly direct mailing campaignsLed process improvement team, freeing 50+ work hours per day in six departments

Master Of Business Administration (M.B.A.), Management Sciences And Quantitative Methods

Bachelor’S Degree, Chemical Engineering

Associate’S Degree, Mathematics