Data Scientist Power Bi

Alexander James Kriete

Data Analytics Data Automation and Visualization Developer VBA & Python Developer Records & Information Governance 443-***-**** ****.******.**@*****.*** Raleigh, NC P R O F E S S I ONAL P ROFILE

Analytical and programming-focused data professional with deep expertise in Excel, Power BI, SharePoint, and automation tools including Python, SQL, and VBA. Experienced in developing reporting frameworks, building visual metrics, and maintaining structured documentation systems that support compliance, records management, and strategic decision-making. Skilled at designing scalable, automated solutions for data capture, retention, and risk monitoring across regulated financial environments. Proven ability to synthesize complex data into actionable insights, build training and documentation protocols, and collaborate across IT, compliance, and business teams to drive process improvement and ensure adherence to policy and regulatory standards. E D U CATION

Master of Arts in Economic History; Salisbury University, Fulton School of Liberal Arts; Phi Alpha Theta Honor Society, 2017

Concentration in US Twentieth Century Economic History & International Economics Bachelor of Arts in Political Science, Economics; Salisbury University, 2014 WORK H I S T O R Y

Lead Financial Data Scientist, Discover Financial Services, Chicago IL August 2024 –Present Operated as Lead Financial Data Scientist in the Financial Crimes Risk Team of DFS, utilizing programing and quantitative analytics.

Automated key financial assessment and business workflows through VBA, SQL and Python to enhance operational efficiency and control variables, thus reducing workloads and minimalizing risk of human error.

Led training sessions for analysts and compliance staff on the use of data tools, documentation practices, and workflow automation using VBA and SharePoint.

Developed and operationalized metrics and interactive dashboards in Power BI and Tableau to reliably measure KPIs aligned with strategic business priorities and data-driven decision making.

Supported governance and records tracking through automated workflows that aligned with federal regulatory frameworks and internal policy guidelines.

Developed and maintained advanced analytical models via A/B testing to assess LOB performance, forecast financial outcomes, and support budgeting processes, with a focus on identifying risk drivers and improving profitability.

Responded to ad hoc requests from the risk team by developing VBA-powered dashboards that automated data cleansing and analysis workflows. Built user-friendly tools with one-click functionality that transformed raw files into structured, actionable risk reports, saving teams hours of manual processing per request.

Designed, developed and deployed Python automation using python-docx and pandas to extract risk statements from Word documentation and populate a combined shareholder-facing quarterly report. The solution enabled dynamic updates whenever source documents changed, saving hours of manual work and eliminating the risk of human error in compliance reporting. Senior Financial Data Associate, Fannie Mae, Washington D.C. December 2021 – August 2024 Led Financial Associates, promoting organizational goals in risk management and records management via advanced data analytics.

Built Excel-based reporting tools and Power BI dashboards to monitor risk metrics, records retention, and compliance documentation tied to mortgage servicing and loan-level transactions.

Streamlined internal workflows by optimizing Salesforce data entry and reporting processes, reducing redundancies and improving data accuracy for actionable teams. Collaborated with cross-functional stakeholders to ensure consistent, actionable insights from pipeline and performance metrics.

Analyzed large-scale loan and security-level datasets with advanced Excel Macro and VLOOKUP implementation, identify performance trends, segment risk by product type and borrower profile, and forecast exposure under various economic scenarios.

Designed and maintained dashboards in Power BI and SharePoint to track key compliance KPIs and operational performance, improving visibility for senior stakeholders and regulatory reporting teams.

Utilized SQL to extract and transform data, and built dynamic Excel models to support scenario planning, portfolio strategy, and senior-level reporting.

Automated risk assessment and records management compliance in conjunction with SEC, Federal Reserve and FHFA regulatory and compliance parameters.

Designed and deployed SQL automation scripts to support operational risk monitoring by generating ad hoc reports as well as scheduled reports on key risk indicators (KRIs), control testing outcomes, and incident trends.

Developed, deployed and maintain data visualizations in Tableau and Power BI to communicate data insights at the analyst, management and C level.

Trained and led associates in VBA, SQL, Python, Power BI, Tableau etc. to augment current control and efficiency variables as well as effectiveness testing of key operational, SOX controls and BSA/AML compliance. Senior Data Analyst; Securities and Exchange Commission (SEC), Washington D.C. July 2021 – December 2021 Operated as the Senior Data Analyst to support analysis of criminal financial activity in the Enforcement Division of the SEC.

Excel expert with advanced proficiency in VLOOKUPs, pivot tables, VBA, and macros, consistently leveraging complex formulas and automation to streamline data analysis and reporting.

Preformed data analysis, modeling and forecasting financial transactions to undercover activity tied to criminal investigations.

Reviewed financial disclosures and trading patterns to identify anomalies and assess potential risks, assisting in the development of rulemaking and enforcement strategies.

Investigated financial transactions and money movement through quantitative analytics in coordination with internal counsel. Securities Administrative Services Analyst II; Wells Fargo, Corporate Trust Services, Columbia MD January 2018 – July 2021 Led housing market analysis and forecasting while developing internal automated controls over auditing processes.

Performed financial analysis on the primary and secondary housing markets with an emphasis on the effects of interest rates, purchase rates, portfolio rate of reinstatement probability, default risk and ongoing delinquency rates.

Developed a VBA-driven dashboard that automated key components of the month-end reporting process, significantly improving operational efficiency and reducing manual processing time by hours per cycle. The tool streamlined data consolidation and enabled faster, more accurate performance insights for servicing operations.

Mentored, trained and led a team of 10+ MBS analysts and developed and led internal financial engineering team designated to implement efficiency and control gains in adherence with Generally Accepted Accounting Principle. P U B L I CATIONS

Kriete, Alexander. The Great Schism in American Economics: An Interdisciplinary Analysis of 20th Century U.S. Economics, 1929-1955. Salisbury: Salisbury University, 2017.

Professional Experience with Bloomberg, VBA, Power BI, Tableau, SQL, R, Python, MS Excel / Access, Salesforce, GAAP and FP&A. Professional Mandarin Chinese language skills.

Contact this candidate