SUMMARY:

• Accomplished IT professional with over 20 years of experience in large - scale technical architecture, end-to-end systems development and project management experience.
• Key contributor in m
• ulti-functional projects ensuring on-time, on-budget quality delivery - BI and OLTP systems alike.
• Broad range of expertise across various ERP/CRM systems, ETL tools, Reporting tools, computer platforms, database environments and tool sets.
• Demonstrated excellent leadership, interpersonal and communication skills across all levels of technical, business and management teams.
• Requirements across multiple projects working with functional owners, generating and presenting insights and strategic recommendations.
• Evaluated existing analytics environment to provide recommendations and a roadmap for improvements
• An ability to quickly understand and translate complex business requirements/issues into optimal technical solutions
• Functional specs for IT groups including MW, ETL, DBA, Operations, Reporting (Dashboard Reporting, Cubes, Operational)
• Coordinated successful ERP/CRM/SaaS implementations/conversions across multiple IT and Business groups
• Data Architecture; Functional Mapping; Data Mining; Master Data Management; Data Conversions
• Extremely efficient in problem solving
• Exceptional data analysis skills
• Strong business knowledge includes Higher Education, Marketing, Sales, Pharmaceutical (including Patient Matching and Clinical Analysis), Billing, Credit, Finance, Travel/Airline, e-Commerce, Telecom, Supply Chain

TECHNICAL SKILLS:

Operating Environments: Unix, Windows, Cloud Computing

RDBMS: Oracle, SQL Server, DB2, PostgreSQL

ERP/CRM: Salesforce.com, Banner, Oracle Enterprise Business

Suite, PeopleSoft, Cognos Planning, Lawson, SAP

Data Modeling Tools: Erwin, ER Studio(Embarcadero), Oracle DesignerSwagger

Data Warehouse Tools: Business Objects, Cognos, Informatica, AbInitioData Integrator, Oracle Warehouse BuilderAPEX Dataloader, SoqlXplorer, SSIS, AppWorx

Reporting Tools: Business Objects, Cognos, Tableau

Languages: PL/SQL, C, TSQL, Shell Scripting, SOQLSED, Perl, XML, EDI X12, HIPAA, HTML, XMLJSON, Java

BPM: Enterprise Service Bus, Business Rules Engine,Canonical Data Model

PROFESSIONAL EXPERIENCE:

Confidential, MD

Solution Data Architect

• As part of technology leadership group, spearheading the effort to replace PeopleSoft Custom Application For Admissions with cloud (SaaS) solution (Salesforce/TouchNet)
• Architecture and design for Custom PeopleSoft API for Salesforce integration
• Architecture and design for Custom Salesforce objects to support requested functionality
• Leading an effort to implement full cycle PeopleSoft to Salesforce integration (ETL)
• Provided guidance to team members resolving integration issues
• Analysis for Student State initiative - providing Applicant/Student classification on Salesforce platform
• Integrated additional info into UMUC BI cloud platform (AWS/Redshift/Tableau)

Confidential, Downers Grove, IL

Solution Data Architect

• Technical leadership in building major DW components:
• Enrollment Management (Student Cohort) sourced from Banner/ Salesforce.com
• Integrated new schools acquired by DeVry into existing CRM/Cohort Marts with data sourced from multiple instances of Salesforce and Student Systems
• CRM Mart (Marketing and Recruitment/Sales) sourced from multiple instances of Salesforce.com including auto dialer functionality
• Expense Tracking across Confidential ; Bank Charge reconciliation (10 vendors outside Confidential )
• Recruitment (Sales) Event Tracking sourced from Salesforce
• Recruitment staff performance evaluation sourced from Salesforce and multiple DeVry applications
• Budgets sourced from Cognos Planning/TM1
• Master Data Management
• Cohort Analysis
• Holistic view of a Student based on data from multiple Student Systems
• Single BI platform for multi-source data feeds
• Data conversion as part of Saleforce.com implementation
• Rewired DW components as part of ERP switch

Confidential, IL

Enterprise DW Data Architect

• Created Enterprise Data Warehouse Data Model as a basis for multiple Business Objects universes: Acquisition, Revenue, Service Assurance
• Logical/physical data modeling for multi-platform data sources include:
• Billing System Dise3g (JD Edwards)
• BMC Remedy Action Request
• NetCool network monitoring
• Infor EAM asset management
• Revenue Share application

Confidential, Deerfield, IL

Principal Data Architect

• Conceptual Data Model for Retrospective Drug Utilization Review (RDUR) and Medication Therapy Management (MTM) with subsequent mapping into existing PBM (2+ terabytes);
• Data Architecture for Utilization and Therapy Management (UTM) application;
• Patient Matching procedures to maintain Single Patient View;
• Conceptual/high level application design and Business Process design;
• List management;
• Data support for Rules Engine implementation (BlaseAdvisor);
• Functional specs for ETL, batch processes and reporting;
• Created multi source Clinical warehouse;
• Data analysis, synchronization and conversion;
• Defining UTM-related Canonical data models for ESB

Confidential, Highland Park, IL

Data Architect/BI

• Data model for consolidated reporting platform sourced from multiple ERPs
• Data warehouse dimensions unification after multi company merge
• Data extracting and consolidation to support BO reports
• Supply Chain reporting sourced from various systems

Confidential, Chicago, IL

Data Architect

• Created clearinghouse datamart (LUWare) to consolidate personal data related to students, faculty and staff including university affiliations.
• Consolidating data from PeopleSoft, Lawson and BlackBoard (Security Card) system.
• Data feeds into Library, Health and Wellness Center and SMS (security control system).
• Producing the phone directory and various mail lists.

Confidential, Schaumburg, IL

BI Data Architect

• Business Objects Reporting for United travel clubs (including creating and managing universes).
• Gap analysis for marketing campaign management.
• Data problems solving; data scrubbing.
• Marketing campaigns list management, cross-sell campaign data exchange
• Generic conceptual data model for travel clubs.

Confidential, Downers Grove, IL

Data Architect

• Resolved Multiple Path and other data integrity issues for DPTS system (Job Status Reporting reengineering).
• Logical/Physical Data Model for Business Process Reengineering Data Merge project - manufacturing data warehouse.
• Logical design for Customer Credit data warehouse.

Confidential, Rolling Meadows, IL

Technical Leader ( Data Architect/DBA)

• Overall technical leadership for World Wide Channel Inventory (CHIP) Project to gather Sales Out Data from multiple sources around the world to build a single reporting platform
• Full project cycle from collecting requirements through all analysis/design/development/implementation phases to reporting support
• ETL for multi-source B2B data feeds
• Web reporting
• Oracle and UNIX standards for error trapping and self-recovery in case of the failure. functional specs data cleansing (Trillium)

Confidential, Bannockburn, IL

Senior Systems Analyst/DBA

• Leading role in the analysis and design for Miscellaneous Charge and Late Charge subsystems of Billing System, Repossession System and Collection Agency Tracking System for Volkswagen Credit Inc
• Feasibility studies
• Requirement collection
• Data modeling and system design

Confidential, Chicago, IL

Programmer/Analyst

• Complete redesign for various parts of the Membership Registration Receivable System to accommodate CFTC Rules and Regulation changes
• System analysis and design for Laptop Firm Audit Project
• Clearinghouse System data analysis, design and development Designed and developed
• Firm Questionnaire Subsystem of Financial Analysis Compliance Tracking System