Daniel Schroeder Email & Phone Number

San Francisco, California, Us

San Francisco, California, Us

Senior Business Systems Analyst for Financial Crimes application data team. • Leading cross-functional technology team in the development, documentation and delivery of business and regulatory data program supporting business stakeholders for compliance analytics.• Business driven role involves partnering with stakeholders, defining requirements, providing analysis/reporting and collaborating on implementation via Agile and Waterfall methodologies.• Developed Financial Crimes reporting and analytics toolset to automate daily tracking, reporting and communications of our related applications including ETL metrics, project resource and timeline planning. Created transparency for both technology partners and business stakeholders for bolstering working relationship. Automation and quality controls resulted in approximately 12% efficiency improvement.

San Francisco, California, Us

Senior Business Systems Analyst supporting analytics of brokerage data strategy and business intelligence reporting.• Successfully strategized with business partners to develop MicroStrategy focused reporting products that surpassed business needs including data design, critical reporting and stringent security conventions.• Subject matter expert on data sourcing including integration of dimensional and relational models leveraged for SQL and Business Intelligence reporting including downstream operational and analytics support.• Initiated best practice policies and provided recommendations to maximize efficiency and scalability around new MicroStrategy project data models or when integrating existing non-structured platforms.• Developed a meta-data analytics tool designed to map and compare complex data models against MicroStrategy schema which resulted in significantly improved response times for impact analysis with 100% accuracy.

San Francisco, California, Us

Marketing Database Analyst / BI Developer• Coordinated with business leaders from various Wells Fargo & Co divisions including Mortgage, Banking, Finance, Home Equity, Marketing, Security and more for developing comprehensive personalized reporting ranging from basic spreadsheets to Advanced Documents or Dashboards• Created and maintained SQL server data models; tables / views utilized for MicroStrategy BI Application and downstream analytics including metadata definitions.• Designed, developed and maintained all supporting data ETL process flows and cascade dependencies for daily loads steps including automating failure protocols and notifications.• Performed data analysis and validation for developing solutions using SQL Server client tools.• Effectively collaborated with executive partners• Primary contact for all project troubleshooting including working directly with MicroStrategy and third party vendors technical support and keeping up-to-date on all tech notes and releases• Project administration: Create and maintain Schema, Public and System Objects including cubes, complex system hierarchies, cache, Narrowcast report delivery tool, etc.• MicroStrategy administration: Successfully developed and maintained all security group profiles, users, database instances, project objects, query execution settings (VLDB settings).• Integrating standalone Access databases into SQL server based tables for use in MicroStrategy