Bill Brickman

Bill Brickman Email and Phone Number

Enterprise Architect @ Harvard University
Woburn, MA, US
Bill Brickman's Location
Boston, Massachusetts, United States, United States
Bill Brickman's Contact Details

Bill Brickman work email

Bill Brickman personal email

n/a
About Bill Brickman

• Concentrated in data warehouse and ODS reporting environments architecture and technical team leadership.• Over a decade of experience in the evolving DW space: including requirements gathering; DW data modeling; ETL design, development and operational/lifecycle support; SQL & PL/SQL coding/tuning• Experience with multiple ERP application & database environments, development tools. Experienced in creation of data model and development standards, and managing development teams using them. Also web application developer & technical lead.• Technical leadership skills enriched by business-side experience in functional specification development, education, training, support.• Over fourteen years of experience in multiple higher education computing and administrative departments.Specialties: ODS & Data Warehouse data modeling, Oracle 11g, Informatica 8.x, PL/SQL, Brio/Hyperion 8.3, Hyperion 9 Planning/Essbase, Oracle Apps 11i, PeopleSoft 8.9, BSR/Advance, J2EE development

Bill Brickman's Current Company Details
Harvard University

Harvard University

View
Enterprise Architect
Woburn, MA, US
Bill Brickman Work Experience Details
  • Harvard University
    Enterprise Architect
    Harvard University
    Woburn, Ma, Us
    View
  • Harvard University
    Enterprise Architect
    Harvard University Jun 2020 - Present
    Greater Boston
    View
  • Harvard University
    Principal Data Architect
    Harvard University Oct 2016 - Jun 2020
    Greater Boston Area
    View
  • Harvard University
    Lead Data Architect, Hdw
    Harvard University Feb 2006 - Oct 2016
    Greater Boston Area
    Manager of DW architect and DB/ETL developer team of six through hires, reviews, training. Lead architect providing standards, modeling signoff, functionality review, QA through many iterations of life cycle, release of new star schemas and other ODS data models. Operations manager for warehouses providing 24x7 on call support for nightly load team, production scheduling.Lead several security development initiatives reviewing, automating, and locking down Unix account, DB setup, ACL access, HRCI sequestering.Lent to two year OLTP ERP (Hyperion Planning) project as architect to develop Planning/Essbase ETL infrastructure:• developed Informatica framework: special Planning/Essbase plug-in setup, security, code templates, and standards, as well as Unix script framework and code templates.• developed server architecture design with DBA team, addressing security tier separation and failover requirements.• developed custom module integration code, for example, Unix script to extract Essbase security, parse w/ Perl, reload.
    View
  • Harvard University
    Data Architect, Hdw
    Harvard University Sep 2003 - Jan 2006
    Greater Boston Area
    Acted as technical lead for large, multiphase application development effort employing J2EE standard web view layer on top of Oracle Applications scheduler to create custom report scheduling and delivery system (“CREW”):• Designed complex multilayer architecture and abstract report parameter registration and request status data model to drive it• Led composite development team of department staff, shared in-house staff and consultants• Negotiated design with three separate functional teams through initial rollout and secondary releases. Lent to OLTP ERP (BSR Advance) project as reporting tech lead to develop report development infrastructure: • led tech team through development of PL/SQL report utility packages and report code template• led combined functional/tech team through reporting view layer design• designed specialty denormalized reporting table structures and loadOn-going Data Warehouse architecture refinement, support for Financial, HR, Grants reporting
    View
  • Harvard University
    Data Administrator, Hdw
    Harvard University Aug 1999 - Aug 2003
    Greater Boston Area
    Developed and maintained ETL processes of ODS, data warehouse, and data marts of Oracle Financials, PeopleSoft HR data. Developed standardized security layer, metadata for database user access, including views, grant processes, and row-level security mechanisms. Designed central warehouse architecture, standards, and metadata repository for managing loads, load history, and user security. Designed data models for diverse subject areas, from Financials GL to Student Information, from relational denormalizations to star/snowflake schemas.• Upgraded custom ODS and DW ETL processes, security objects through two Oracle Financials major version transition (10.7 NCA to 11.0.3, then to 11i) and database upgrades (8 to 8i, 8i to 9i)• Developed process for version control and release of data warehouse code as well as custom, modular Unix installation scripts for automated release• Acted as tech lead to developers doing database creation, ETL design and test, and load scheduling
    View
  • Harvard University
    Iu Support Specialist
    Harvard University Dec 1997 - Jul 1999
    Greater Boston Area
    Supported web application and client/server use of Sybase data warehouse (moved to Oracle based), including 2nd tier support, development and execution of application and query training, and troubleshooting of production server and applications.• Developed training materials for Sybase web reporting application (“AWS”), trained, supported 2000 users. Revised, maintained training materials for ad hoc query tool (InfoMaker) against Sybase data warehouse, trained, supported 150 advanced ad hoc/developer users.• Developed training materials for new Oracle web reporting applications, trained in large scale wave, supported 3000 users. Developed training materials for ad hoc query tool (InfoMaker) against new Oracle data models, trained, supported 200 advanced ad hoc/developer users.• Provided operational support to nightly load processes (“on call”), nightly load process Unix scripting design.
    View
  • University Of Pennsylvania
    Senior Computer Support Professional
    University Of Pennsylvania May 1997 - Dec 1997
    Greater Philadelphia Area
    Supported completely new student residential computing program as 1st and 2nd tier support. Trained and managed student technical support workers in residential houses. Supported residential computer network, lab computers, and provided technical leadership to junior IT support specials in same tier.• Developed custom web based problem tracking application for customer students and staff administrators. Designed in Sapphire/Web over Access, from data model to tables, views, to web data collection forms and reports.
    View
  • University Of Pennsylvania
    Office Systems Administrator/Gse
    University Of Pennsylvania Sep 1994 - May 1997
    Greater Philadelphia Area
    Supported approximately 900 administrative, student, and faculty desktop application users at 1st and 2nd tier. Managed and trained 5-8 help desk staff of part time students, temporary workers. Maintained production mail server, school ftp and web servers, Novell 3.12 server, student Unix accounts. Installed and configured end user Mac and PC desktops• Implemented complete renovation of public computer lab equipment, network, software• Developed official school web site, collecting, managing documents, site design, image design, forms
    View

Bill Brickman Skills

Data Warehousing Etl Databases Data Modeling Sql Database Design Unix Business Intelligence Requirements Gathering Integration Data Analysis Pl/sql Software Development Informatica Data Warehouse Architecture Perl Architecture Java Enterprise Edition Data Integration Obiee Java Master Data Management Olap Architectures Hyperion J2ee Oracle Sql Dimensional Modeling Essbase Weblogic Data Marts Uml Data Quality Business Intelligence Tools Eclipse Hyperion Planning Data Models

Bill Brickman Education Details

Frequently Asked Questions about Bill Brickman

What company does Bill Brickman work for?

Bill Brickman works for Harvard University

What is Bill Brickman's role at the current company?

Bill Brickman's current role is Enterprise Architect.

What is Bill Brickman's email address?

Bill Brickman's email address is bi****@****ard.edu

What is Bill Brickman's direct phone number?

Bill Brickman's direct phone number is +161731*****

What schools did Bill Brickman attend?

Bill Brickman attended University Of Chicago, Choate Rosemary Hall.

What skills is Bill Brickman known for?

Bill Brickman has skills like Data Warehousing, Etl, Databases, Data Modeling, Sql, Database Design, Unix, Business Intelligence, Requirements Gathering, Integration, Data Analysis, Pl/sql.

Not the Bill Brickman you were looking for?

View similar profiles

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.