Charles (Chuck) Roller Email & Phone Number

San Francisco Bay Area

Awarded an Executive Degree in Blockchain/DLT Technology

Oakland, Ca

San Francisco Bay Area

Developing Business Requirements, Technical Specifications, and Code for the Treasury Data Warehouse Team: o Scrum Master, formulating user stories and managing team deliverables o Database design and reviewo Managing Server migrations o Developing Presentations and Flow Diagrams for both data warehouse and Big Data projects

San Francisco, Ca

Provided project management and technical expertise for a key IT initiative.

Stanford, Ca

Responsible for DBA duties and DB design related to the MS SQL Server Farm at Stanford Management Company. Developed, reviewed overall architecture and coding practices. Designed and developed Webfocus applications.

Responsible for the design and maintenance of All Transaction and Reporting applications related to the Stanford endowment. Delivered all required business and system analysis for BI applications.

Palo Alto, Ca

• Implementation of code to capture and load graphics and document blobs into the Global Data Repository (Oracle 11). Roche Pharma data warehouse was approx. 6 TB• Developed and designed ETL processes using Informatica. • Ongoing maintenance and improvements to the Abase data capture process. Abase collected all automated experiment data for Roche in 5 research centers around the world on a 7x24 basis.• Development and implementation of test plans and scripts for production releases. Team used Agile Methodology (Sprints and Project Sizing)• Coding of UNIX/Linux scripts.

Palo Alto, Ca

• Implementation of code to capture and load graphics and document blobs into the Global Data Repository (Oracle 11). Roche Pharma data warehouse was approx. 6 TB• Developed and designed ETL processes using Informatica. • Ongoing maintenance and improvements to the Abase data capture process. Abase collected all automated experiment data for Roche in 5 research centers around the world on a 7x24 basis.• Development and implementation of test plans and scripts for production releases. Team used Agile Methodology (Sprints and Project Sizing)• Coding of UNIX/Linux scripts.

San Francisco, Ca

Wells Fargo Wholsale View project was a major bank wide initiative to provide a complete, 360-degree view of the WFB Business services customer. The application consolidates data from over 50 wholesale systems of record and presented personalized data to individual Wells Fargo business users. • Gathering and formulation of Business Requirements in combination with Business users.• Coded HR models in PL/SQL • Scheduling of project resources for production installations. • Design of overall Logical and Physical data model.• Developed technical specifications for over 80 individual data feeds. • Code review and technical mentoring of Onshore/Offshore staff. • Development of project presentations.

San Francisco Bay Area

• Managed project staff that developed analytical workbenches (datamarts) in the areas of budgeting, financial reporting, supply-chain, and retail. Workbenches were developed in conjunction with Peoplesoft’s EPM team. Extensive use of MS SQL Server, Micro Strategy, and Information Advantage (Acquired by CA). • Established project milestones and deliverables.• Successfully delivered turnkey data warehouse & portal applications including for accounts such as The Gap, Longs Drug, Cadence Design, University of California-Berkeley, Escalate, and Telus (Canada).• Authored and delivered technical training programs in data warehouse and portal design.• Delivered business intelligence applications using MicroStrategy, and Crystal Reports

Bachelor Of Arts - Ba, Economics, Bus Ad-Finance, 3.4

Earned an additional Major -- Bus Ad-Finance

Executive, Blockchain/Dlt, Completed