SUMMARY:

• Over 19 years experience in many facets of business intelligence, data warehousing, and technology serving both Higher Education and commercial industries.
• Proven ability to gather requirements, conduct business and technical design, organize and facilitate workshops, and develop and conduct end - user training.
• Aptitude in estimating, scoping, planning and implementing various projects as well as conducting fit/gap analysis.
• Solutions architect, project manager and team lead roles included management experience in creating and actively updating project plans, utilizing the team efficiently, leading team presentations and designing warehousing, infrastructure, and high availability solutions.
• Solid client and 3rd party management experience with understanding needs, managing expectations, effectively communicating issues and showing clear progress with milestones while staying within budget.

PROFESSIONAL SKILLS:

Software as a Service (SaaS): Confidential HR SaaS, Slate.org Admissions

Computer Languages: SQL, PL/SQL, HTML

Database Packages: SQL Server 2016, 2014; Confidential 11g, 10g, 9i

Database Warehouse: Data warehouse architecture, design and development, performance tuning, data modeling. Confidential Enterprise Performance Management (EPM) 9.1 Warehouse (CS); 9.0, 8.9 Warehouses (HRMS, CS, CRM, FSCM); EPM 8.9, 8.8 SP2 Jumpstart Warehouses (HRMS, FSCM, CS)

Reporting Tools: Confidential Business Intelligence Enterprise Edition (OBIEE 11g, and 10g), Hyperion Interactive Reporting (BRIO)

Development Tools: IBM Information Server DataStage Enterprise Edition 11.5, 9.1; Server Edition 8.1; Ascential DataStage 7.5.x, 7.1; SQL Server Integration Services (SSIS) 2016, 2014; PeopleTools 8.5x - 8.0x; Confidential Data Integrator (ODI); Visio

PROFESSIONAL EXPERIENCE:

Confidential, Gainesville, FL

Responsibilities:

• Created a custom Applications model to integrate Admissions data extracted from Slate.org with dimensions built from the Confidential ERP source to allow for cross functional reporting
• Architected Change Data Capture ( Confidential ) jobs from daily snapshot data to build history into the Application data for year over year analysis.
• Built new DataStage jobs to reverse convert Confidential data into legacy reporting objects to stabilize legacy historical and retention based reporting needs.
• Identified and documented inconsistencies and incorrect assumptions made during the conversion of mainframe Student data to the Confidential ERP. Addressed changes needed to the Academic Structure for future and historical reporting use.

Confidential, PA

Project Manager and Team Lead

Responsibilities:

• Architected ETL Load process for data cleansing and staging from Confidential using Integration Services and building Custom Reports
• Standardized data warehousing practices and naming conventions to allow for future conformity in the Confidential HR Warehouse to other warehouses
• Documented and analyzed Confidential business processes and redefined the logic in the Confidential HR Data Warehouse using SSIS ETL
• Created the Project Charter and scope for the first phase of the Confidential HR Data Warehouse
• Identified deficiencies in proposed strategies which saved the university over 600k over a 4 year term

Confidential, New York NY

Solutions Architect and Team Lead

Responsibilities:

• Designed High Availability Solution for multiple warehouses with consistent data throughout
• Upgraded original EPM 9.1 Confidential warehouse code to DataStage 9.1 Enterprise Edition
• Redesigned Staging tables to use the Enterprise Edition Confidential stages over the CRC (Cyclical Redundancy Check) logic
• Defined site level Disaster Recovery process and configured the build and test of the DR site

Confidential

Solutions Architect

Responsibilities:

• Designed a High Availability Solution for the Financials Data Warehouse with existing software licenses
• The High Availability Financials Data Warehouse has successfully produced reporting data for the New York and Global community with 99.9% data availability and uptime since go live.
• Designed and implemented the ability to revert back to the prior load in the case where Source Financial data was invalid
• Designed a process to reconcile metrics from the source table to the error and fact tables down to the unique chartfield string per load.

Confidential

Project Manager and Team Lead

Responsibilities:

• Created a custom Institutional Research data mart to address Confidential ’s federal and state reporting requirements
• Configured the IR Snapshot data mart to run as a Type 1 SCD and maintain history at the time of the snapshot as required by Federal and State reporting
• Integrated 16 years worth of historical Census snapshots from legacy warehouse into conformed CSW dimensions
• Enabled Registrar to control the classification of students based on primary Academic Plans for a term

Confidential

Project Manager and Team Lead

Responsibilities:

• Implemented the EPM 9.1 CS warehouse for Confidential, Student Financials, and Student Records from CS 9.0 with DataStage 8.1 Server Edition
• Built enhancements to the warehouse that create Operational Metadata for daily statistics
• Created a process to reprocess rows in error for the MDW incremental loads
• Customized the Student Records mart to allow for efficient fact-to-fact reporting joins
• Developed an efficient 1-click destructive reload process for the entire warehouse for DR
• Created utilities to help assist Confidential with post production support activities

Confidential, Arlington, TX

Project Manager and Team Lead

Responsibilities:

• Implemented the EPM 9.0 CS warehouse for Admissions and Recruiting, Confidential, Student Financials with Financial Aid, and Student Records from CS 9.0 and CS 8.9 ERP sources
• Led functional and technical mentoring sessions for the UTS BI team to help with the EPM knowledge transfer
• Created and maintained a project plan to facilitate a phased implementation of 4 data marts to the three campuses simultaneously
• Analyzed and integrated EPM bundles 11 and 12 during implementation to leverage Student Finance mart and multi-threading enhancements
• Incorporated CS and HR integration updates (IU) for Confidential 9.0 to support source schema changes from the delivered CS 8.9 GA DataStage maps
• Developed a UTS baseline of DataStage maps to document common practices used by the three campuses

Confidential, Teaneck, NJ

Senior Consultant

Responsibilities:

• Configured the first Rapid Start implementation of the CS and FSCM warehouse for EPM and OBIEE.
• Merged the delivered OBIEE web catalogue and repository with a pre-existing repository to view delivered reporting analytics against Confidential data.
• Authored a work processes document to apply delivered bundles and enhancements against customizations made in the DataStage project.
• Performance tuned complex ETL jobs to successfully process Confidential ’s ledger data using 64-bit hashed files and validate delivered ETL logic against the data.

Confidential

Technical Lead

Responsibilities:

• Modeled dashboards for global headcounts and additional metrics using OBIEE and validated the Presentation layer against reports built in the source HRMS ERP system.
• Customized the Workforce Analytics fact to properly aggregate the metrics based on Confidential ’s global requirements of conforming the source ERP systems in 26 countries.
• Configured the ability to properly reload the warehouse and reprocess rolling snapshots of the Workforce Analytics fact.

Confidential

Team Lead

Responsibilities:

• Integrated a data integrity strategy to address ETL performance tuning and data accuracy issues caused by hard and soft deletes in the transactional system.
• Created extensions to the delivered dimensions and facts as well as a Run Time statistics utility to track metrics on the performance of the warehouse loads.
• Collaborated with the BI and Operations team to schedule the loading and monitoring of the daily warehouse population via the Appworx scheduling tool.

Confidential

Project Manager and Technical Lead

Responsibilities:

• Performed gap analysis and cost/benefit assessments on delivered Student Records, Admissions, and Student Financials marts and their legacy Operational Data Store warehouse.
• Led functional overview sessions and facilitated knowledge transfer of the delivered products through mentoring sessions.
• Worked with Confidential to define and deliver reports using the Hyperion BI tool.
• Built and customized ETL maps to extend the warehouse with the Confidential specific requirements.

Confidential

Technical Lead

Responsibilities:

• Designed and built custom EPM 8.9 data mart solutions for Profitability from the CRM 8.9 sales module.
• Conducted DataStage administration mentoring sessions for knowledge transfer to ensure the success of the data warehouse.
• Administered quality assurance testing of Ascential maps for data accuracy and integrity.

Confidential

Team Lead

Responsibilities:

• Architected and implemented custom EPM 8.9 warehouse solutions for Confidential, Student Financials, Student Records, Administration, and Financial Aid modules.
• Developed and managed data warehouse training sessions and roll-out strategy to Confidential ’s 23 campuses.
• Conducted mentoring sessions and developed customized documentation to ensure the client’s success with the data warehouse after go-live.

Confidential

Technical Lead

Responsibilities:

• Designed and built a customized Payroll mart from legacy systems and conformed the mart to the delivered Jumpstart HR 8.0 warehouse.
• Created training manuals for Ascential DataStage and EPM Jumpstart data warehouse methodology.
• Conducted Ascential DataStage and EPM Jumpstart data warehouse methodology training.

Confidential, Conshohocken, PA

Senior Network Administrator

Responsibilities:

• Managed daily system administration including monitoring servers by utilizing Compaq Insight Manager and installing new server equipment and software.
• Effectively maintained the Confidential Windows NT/2000 training environment refreshes which included Confidential server administration and builds.
• Implemented network infrastructure as lead network engineer for Northeast regional conferences.