David W.

About David W.

Solution Architect focusing on Financial Planning systems. I work closely with finance teams to understand business needs and design solutions that increase efficiency.Fifteen years experience with Enterprise Performance Management Systems: system architecture, development and system administration. Equally strong with dimensional and relational data modeling. Extensive experience with systems integration and Datawarehousing.Twelve years experience in commercial real estate. Deep knowledge of property management. Additional experience in Investment Banking and manufacturingExperience with all stages of the software development life cycle: scoping, design, coding, testing, deployment, and administration. Equally adept at analyzing/debugging existing systems as well as building new applications.Hands-on coding experience: Planning Analytics from TM1 9.4 to PA 2, Cognos BI 8 to CA 11. Hyperion & Essbase 9 to 11. Data integrations experience: Yardi 7, Argus Enterprise 11, Oracle 11, JDE E1, Microsoft SSIS, SSRS, Salesforce, and various custom databases. Completely fluent writing SQL in any environment: Oracle PL-SQL, Microsoft T-SQL, as well as standard SQL. Experience working as a Developer building software in C/C++.

Experience

1. System Architect

   Bedrock Detroit

   Jan 2023 — Present · Los Angeles, CA, US

   Move existing AWS cloud infrastructure to Azure. Design and develop new features- Build data integrations between ERP, CRM, Helpdesk, and cloud platforms (Yardi, Salesforce, JIRA, others)- Analyze legacy system implementations- Serve as Analytics subject matter expert.

Education

• University of Colorado Boulder

  Bachelor's degree

• The University of Texas at Austin

  Doctor of Philosophy - PhD

• The University of Texas at Austin

  Master's degree