| Director, Business Intelligence Solutions Confidential - Recruited to upgrade and replace obsolete technologies and systems, to implement a PeopleSoft custom reporting solution, and to mentor and develop team of 14 in data warehouse best practices, architecture, tools and technology.
- Planned, architected, and implemented a financial data warehouse and BI solution sourced from PeopleSoft Financials data. Solution was implemented with Oracle 11g, SAP's Data Services, and Business Objects using Crystal Reports, WEBI, Dashboard, and OpenDoc technology.
- Organized the University's data into the University Data Store UDS , consisting of data stores of Financial, HR, Payroll, Student Service, Compliance, Project, and legacy data.
- Turned around a failed project and investment of over 500k to implement Business Objects Enterprise XI as the University's standard reporting platform. The enterprise platform supports over 3000 users of standard and self-service reporting, implementing customized security for authentication and row-level security.
- Implemented the Data Validator system to validate financial data.
- Leader of the University Senate sub-committee on Data Governance, providing recommendations to initiate a Data Stewardship Program and Data Quality Program. Implemented a WEB Site for the distribution of metadata i.e. data models and data dictionary . Implemented Embarcadero's ER/Studio and Repository.
- Created a role based organization of 14 staff members for Data Management, Reporting and Data Architecture implementing ITIL best practices.
Director, Front Office Systems Confidential - Responsible for ITIL based support for 70 Front Office applications during the planning and implementation of SAP's Sales Distribution SD , Materials Management MM , and Financial Accounting FI modules. Applications supported sales administration, sales promotions, marketing, customer service, and finance. Technical environment includes Oracle 10, SQL Server Reporting Services, VB, .NET, Java, SQL Server 2005 and Crystal Reports.
- Retrofit Front Office Systems during the implementation of SAP, managing the cut-over from legacy back office systems. This included the implementation of a data services system to manage the SAP data exchange, and master data for Front Office applications.
- Managed Edifice's point of sale POS weekly data feeds and retailer reports with data from major department stores.
- Designed a data warehouse integrating syndicated POS retail sales metrics with SAP master data supporting reporting and forecasting. Responsible for requirements analysis for Business Warehouse BW reporting solution.
- Responsible for 5 FTE's and 6 consultants. Also managed an off shore team.
Managing Director, B2B Data Services Confidential - Hired to build a new strategic B2B service offering, partnering with IBM, to implement UCCnet in the small business marketplace. Service offerings included implementing UCCnet B2B Item Data Synchronization and Sarbanes Oxley Compliance through IBM's Document Management software .
- Established Dynax as a certified UCCnet Solution Partner. UCCnet is a B2B data registry service between retailers and distributors providing an efficient means to communicate product data.
- Provided data analysis and consultation for projects implementing IBM hardware and WebSphere for their Item Synchronization UCCnet solution.
- Consultant, Project Manager - PeopleSoft Reporting
Confidential - As a project manager for United Water, a utility company, as part of a PMO implementing PeopleSoft Financials v8.4 G/L, T E, Procurement, Project Costing, A/P, Contract Management, and Billing .
- Provided recommendations for module acquisition and the reporting solution.
- Responsible for requirements and design for PeopleSoft SQR and nVision report infrastructure. Identified, modeled, and implemented report dimensions and hierarchies.
- Recommended and implemented a data cleansing processes for vendor files.
- Created Enterprise Data Models.
Project Manager / Data Architect Confidential - As Manager of the Data Services Group, developed service offerings and provided Management Consultant on strategic projects.
- For SEIU 32BJ, a Union and Benefit Fund Administrator, performed an audit of the IT organization, application portfolio, and databases. Facilitated and provided recommendations to senior level management in their ERP selection.
- For SEIU 32BJ, as Project Manager of the data migration the ERP ISSI , identifying data sources, building source-to-target maps, and performing data profiling and cleansing. Managed 12 IT and functional employees.
- Associate Director, North American Data Warehousing Practice
Confidential A leader of the North American Competency Center for Data Warehousing, which was responsible for 30M in annual sales. Created and supported the sales and implementation of services enabling project teams to implement Data Warehouse solutions Associate Director - Provided centralized support by creating the Data Warehouse methodology and best practices for project teams. Developed boilerplate project plans and deliverables. Created a series of ETL and data quality services for assessment, metadata management and data governance.
- Managed vendor selection and strategic partnerships.
- Provided services to Regional Sales: Solution Architect, and creating customer proposals and presentations.
- Participated as a career advisor to staff.
Data Warehouse Architect - Data Warehouse Architect during the Discovery Phase of a Global Data Warehouse for Becton Dickinson, a Health Products manufacturer. Responsibilities included both data and application architecture and assistance with infrastructure sizing. Performed BI tool selection and procured Cognos PowerPlay. Assisted in the collection of KPIs for EPM. Developed dimensions and metrics for a Kimball Bus architecture.
- For Merial Pharmaceuticals, as the Data Warehouse Architect of a Sales Marketing Data Warehouse. Performed the engagement's Discovery phase preparing the requirements, gap analysis, recommendations and budget for the architecture and implementation. Oversaw subsequent phases as the project's Engagement Director implementing Oracle-8i, Business Objects and DataStage.
- For UPS, as the Data Warehouse Architect of a Marketing Analytics Data Mart implementing CRM, Campaign Management and Marketing Analytics with Prime Vantage, Brio, Essbase, SPSS, ETI and Trillium. Later provided oversight as the project's Engagement Director providing quality control, risk assessment and oversight of project management.
Project Manager - As the Project Manager and Lead Analyst for Prudential Insurance, performing a data quality assessment in support of a Sales Data Warehouse using Ascential's Quality Manager. Trained and mentored the staff to use the methodology and tool for the assessment.
- Project Manager for the development of an Order Tracking Data Mart for Verizon using DB2 and Business Objects. Was brought in to manage project to completion after it was reported to be 3 months behind schedule.
|
| Technical Director, Data Architect Confidential - One of the first employees of a startup business, was the Director of the consulting staff, a project manager, and participant of strategic projects
- For AT T as a Data Warehouse Architect for their Marketing Forecasting organization. Responsibilities included Data Modeling, ETL design, data quality assessment and cleanup, and the development of a Decision Support System using PowerBuilder.
- Project Manager for AT T for a system to simulate their billing system in order to train Customer Service. After performing systems analysis, was asked to manage the development and implementation team that grew to 26 people and had a budget of 2 million.
- Business Analyst for AT T's DOMIS system collecting Point-of-sale data from its retail stores and disseminating data to its sales, marketing and financial systems.
Programmer Analyst Confidential - Developed in UNIX/C, Assembler and COBOL/IMS. Clients included AT T-Communications, AT T- Consumer Products, Bell Labs, EF Hutton, Hartz Mountain and Witco Chemicals.
|
Privacy Policy
