Robert Orlowski Email & Phone Number

Englewood, Co, Us

San Antonio, Texas, Us

Data Architecture Schema Governance Board1. Led effort to review competing Pearson data architecture practices (including getting engineering input as to what helps and what hinders their efforts) to identify those which will create most efficient engineering practices for long term growth. 2. Developed / documented a comprehensive set of Pearson data architecture standards and practices that drives all schema development for next generation products. Master Data Management Project1. Led data architect on all aspects of data design for Pearson-wide MDM project. Initial focus on Product and Customer areas for major educational publisher as company transitions from traditional textbooks to electronic courseware. Online Learning Application with integrated Data Analytics and Adaptive Learning1. Lead architect on all aspects of data design in big data environment. 2. Designed all JSON schemas for capturing Actor/Verb/Object activity data (ex: Student Answered Question, Student viewed content, etc.) and for capturing contextual data (ex: Courses, Learning Resources, Enrollment, Assignments, Assessments, etc.)3. Designed all aspects of Near Real Time process flows for using a diverse set of application activity data delivered as JSON messages to analyze: a) student usage of Pearson’s next generation educational platform, b) student performance on assessments, c) student “time on task” compared to assessment scores.4. Provided coaching / guidance to engineers on all aspects of data usage.5. Designed many REST Endpoints for use by user interface exposing analytic data to students and instructors. 6. Consistently evaluated as a great team player who patiently and skillfully shares knowledge.

Philadelphia, Pa, Us

Principal Data Architect on Master Data Management / Data Modeling ProjectsData Road Map. Led the efforts of 10 architects in MDM project to update a master road map for data across Comcast’s major ecosystems involving 200+ databases.TeleManagement Forum App Mapping. As MDM project, created a comprehensive map of corporate applications by mapping 100+ applications into TM Forum Applications Framework. Identified areas where multiple systems perform the same business function with end goal of reducing application/data duplication and consolidating redundant data stores.Viewership Measurement. Primary data modeler / database designer on Cable Industry Media Measurement Data Model - a common framework for cable industry efforts to organize viewership data in preparation for creating standardized TV viewing analytics across the industry. Published as a formal specification by CableLabs™ - see Audience Measurement Data Specification (see: www.cablelabs.com/specifications/OC-SP-AMD-I01-130502.pdf)Video Analytics. Created a video analytics reporting application built on dynamic wiki pages.MetroEthernet. Designed Logical Data Model for MetroEthernet Cell Backhaul for this rapidly growing $2b business area.Application and Hardware Tracking. Designed comprehensive logical and physical data models for tracking hundreds of applications and thousands of servers to accurately manage capital resources.PowerDesigner Administrator - manage PD repository and user access for 100+ PD users.Data Modeling Standard. Joint author of comprehensive standard covering conceptual, logical, and physical db modeling.

Philadelphia, Pa, Us

Developed logical and physical data models for multiple projects including: Spam Mitigation. Designed data model and reporting app for tracking email spam and assisting customers in preventing spam thus reducing email traffic and costs.DMCA. Designed data model and reporting app for detecting and mitigating violations of Digital Millennium Copyright Act to ensure compliance with Act. Data model includes a workflow component that supports multiple interactions with customers to ensure that only purposeful, repeat offenders would be targeted for service disconnect. Switched Digital Video. Designed data model, source to target mapping, and reporting specs for tracking customer viewing behavior in support of switched digital video rollout. Database provided engineering with viewing patterns to assist in right-sizing the SDV backend hardware environment.Acceptable Use. Designed data model for tracking exceptionally high internet use in preparation for implementing tiered pricing to increase revenue and reduce traffic costs.

Client: William Clift and Company: June 2006 to Apr 2007Accomplishments: Developed business plan, project plan, budget, and community operations procedures for building economically sustainable communities in low income areas overseas. Required great attention to the “process / people” side of how to make the community functional and how to account for funds spent. Client: InterTrade and Commerce, Ltd: Mar 2005 to Sep 2006Accomplishments: Designed and managed process flow for tracking contracts, property owners, properties and payment information for a property application. Client: Global Trust Services: Sep 2004 to Mar 2005Accomplishments: Designed and documented business process flow, developed system documentation, tested software applications and submitted change requests for client that helped homeowners to reduce their mortgage indebtedness.Team: Denver Trading Group – Investor Team: Jan 2002 to Jun 2004Accomplishments: Designed, developed and tested software applications for backtesting currency trading, futures trading and stock trading systems.

Atlanta, Ga, Us

Load Siebel CRM Sales Force Automation system with mutual fund sales analysis data.Leading a team of 2 developers: Designed and developed all software for loading Siebel CRM data base using Siebel EIM interface. Responsible for extensive data conversion and data loading efforts.Tools: Oracle 8i, PL/SQL, SQL*Loader, UNIX, ksh, Autosys job scheduling, Remedy, and SCM.Also, at INVESCO: Manager Portfolio Accounting and Investment Division SystemsSupport mission critical securities trading and accounting operations.Leading a team of 10 developers: (1) Reduced work load by 90% by automating data exchange between two packaged software applications. (2) Created compliance checking software which ensured that company avoided investments which would violate regulatory guidelines. (3) Developed a WEB based application for research analysts to share research. Application interfaced with Landmark and PAM systems (securities industry software packages).

Create programs to increase revenue per subscriber; reduce operating costs; support decision making.Responsibilities: Leading a team of 5 developers: (1) Created a fully automated Oracle/UNIX production reporting environment including electronic report distribution resulting in 80% savings over previous methods. (2) Loaded the Data Warehouse and then created Data Marts from the Warehouse to support executive decision making and business intelligence. Worked under Ryan Sousa, a co-author of the book Data Warehouse Performance. (3) Created targeted direct mail and telemarketing campaign lists with take-rates up to 20% resulting in more sales at far less cost. (4) Assisted in profitability analysis of customer base and of various marketing campaigns. (5) Prepared numerous reports for top executives. Tools: Oracle v7.3 and 8.0, HP UNIX, ksh, FTP, Exceed, SQRiBE/SQR, Autosys, MS Access, Excel.

Ms Management Information Systems, Database

Bs Business Administration, Management Information Systems