Summary
Overview
Work History
Education
Skills
Certification
Awards
Training
Presentations
Timeline
Generic

Charles Walker

Mount Dora,FL

Summary

Over 25 years of experience delivering large, complex, projects in: Healthcare, Distribution, Chemicals, Manufacturing, Government, Life Sciences, Utilities, Travel, Financial Services, and Education. Technical Expertise: Business Intelligence, Data Modeling, Data Analysis, Data Mining, Data Engineering, Data Governance, Master Data Management, Metadata Management, Cloud, Big Data, and Agile Development. Innovative solution architect enthusiastically pursuing a professional role to contribute value to the team. Offering advanced knowledge of system design and software deployment support shown several years of related experience.

Overview

30
30
years of professional experience
1
1
Certification

Work History

Solution Architect Manager

Deloitte Consulting
05.2021 - Current
  • Provided Data Modeling and Performance Tuning for MariaDB and MySQL databases.
  • Trained subcontractors in Test procedures and Data Quality. Tested and diagnosed Mulesoft Anypoint interfaces.
  • Performed Data Profiling, Data Analysis, and Data Modeling of new and upgraded data sources.
  • Designed / enhanced DW Staging, Dimension, and Fact tables, indices, and views in Oracle 18c environment.
  • Created ETL mapping specifications for Informatica Power Center 10.4.
  • Validated ETL test results.
  • Developed PL/SQL procedures to automate DDL generation and updating of Staging, Dimension, and Fact tables using Generative AI (ChatGPT and Co-Pilot).

IT Manager – BI & Analytics

White Cap
02.2021 - 05.2021
  • Lead 3 onshore and 6 offshore team members. Hire, mentor, and train team members.
  • Facilitate planning for Oracle Exadata upgrade of OBIA Data Warehouse and Data Center move.
  • Integrate acquisition data feeds. Sunset Microstrategy platform.
  • Planning to stand up Microsoft Power BI Premium. Support 7X24 operations.

Software Development – IPPS-A

CACI
05.2020 - 10.2020
  • Designed and implemented Department and Business Unit security models, Oracle Exadata tables, indices, PL/SQL, and OBIEE 12.2.1.4 metadata.
  • Executed test cases for ODI Mapping, OBIEE Dashboards and Reports.
  • Verified OBIA Data Warehouse table data was consistent with PeopleSoft HCM.
  • Upgraded OBIEE Readiness and Manning Dashboards and Reports from IPPS-A R2 OBIA HCM 11.1.1.10 Data Warehouse schema to R3 schema.
  • Performed Qlikview troubleshooting.
  • Developed Linux shell scripts for OBIEE cutover to support 7X24 operations.

Senior Consultant

Informatica
07.2019 - 05.2020
  • Performed health check of Informatica Power Center 10.2 and B2B HIX/HIPAA adaptors for major state healthcare agency.
  • Improved throughput and scalability of Informatica Data Quality with Web Services and Address Doctor for major healthcare organization.
  • Provided architecture and design services to migrate Peoplesoft HCM to Workday cloud.
  • Installed Informatica Data Quality and Address Doctor on Amazon Web Services and Microsoft Azure Cloud.
  • Installed and configured Informatica Data Validation Option.
  • Upgraded Informatica Power Center, Power Exchange for SAP, and Data Quality from Version 9.6.1 to 10.2 for major clients.

Data Architect

DatAvail
12.2018 - 05.2019
  • Data Conversion Lead – Developed ETL strategy and high level Project planning for converting Shell Equiant and MSS data to Oracle Financial Services Lending and Leasing (OFSLL) cloud application.
  • Performed Data Modeling of Source Application tables, designed Change Data Capture process, Staging tables, and mapped data from source to target (Oracle Financial Services Lending and Leasing Cloud application).

Consulting Technical Director

Oracle Corporation
04.2015 - 11.2018
  • Remediated severe performance bottlenecks after migration from Oracle on Linux to Oracle on AIX.
  • Reviewed: Hardware Stack, Data Warehouse Data Model, OBIEE 12 Metadata, OBIEE Catalog, Dashboards and Reports, Query Logs, Query Plans, AWR Reports, Informatica Mappings.
  • Identified changes to: Data Model, OBIEE Metadata, and Report prompts to improve query plans, provided SQL scripts to populate new tables and columns, and performed benchmarking.
  • Assessed replacement options and strategies to migrate the Air Force APPFORMS, PRISM and WAPS applications from Oracle Discoverer to a FEDRAMP supported platform.
  • Analyzed Logical and Physical Data Models, security configuration, Discoverer EUL, and Reports.
  • Created resource plan, project plan, and SOW.
  • Developed an overall strategy, project roadmap, resource plan, and detailed Project Plan to implement Oracle Human Resources Analytics.
  • Led team that upgraded a large, complex, OBIEE11g environment with over 30,000 users to OBIEE 12c.
  • Stack: Oracle Exadata, Red Hat Enterprise Linux, Weblogic Server, OBIEE Clustering, F5 Load Balancer, CA Siteminder SSO, and SAML.
  • Navy NSIPS Consolidation. Provided Data Architecture and Data Modeling services.
  • Built complex shell scripts to convert 104 DB2 Data Loader control files to Oracle SQL
  • Loader control file syntax.
  • Created logical and physical data models for: Staging Database and Custom PeopleSoft tables to contain data migrated from: IMAPMIS, FORMAN, NEOPS, RHS, OPINS, NES, and other legacy systems.
  • Provided architecture services for a large, complex Oracle BI Financial Analytics 11.1.1.9.1 implementation including: Oracle Data Integrator 11G, Oracle Golden Gate, Oracle Exadata, Oracle Exalogic, Weblogic, and Oracle E-Business Suite R12.
  • Siebel Call Center Analytics Upgrade. Upgraded Data Warehouse schema from Version 7.8 to 7.9.6.4.
  • Shifted Data Warehouse platform from IBM DB2 to Teradata.
  • Upgraded Informatica mappings and workflows to Version 9.
  • Upgraded DAC Execution Plans and OBIEE Metadata.
  • Tuned ETL to reduce load time from over 18 hours to 45 minutes.

Business Intelligence Consultant

KPI Partners
11.2014 - 03.2015
  • Designed and implemented a Royalty Analytics application to automate diverse, complex calculations of Royalties Payable across three lines of business.

Consulting Solutions Director

Oracle Corporation
08.2013 - 10.2014
  • Provided Business Intelligence Solution Architecture, Consulting Pre-Sales, and Project Delivery for the Key Accounts in: Southeast, Texas, Oklahoma, and Arkansas.

Business Intelligence Consultant

American Partners
05.2013 - 07.2013
  • Oracle Financial Analytics data sourced from Oracle E-Business Suite, Oracle Data Relationship Management, and several legacy ERP systems.
  • Developed complex (OBIEE) Financial Analytics metadata, reports, and dashboards.

Senior Manager – Analytics Practice

Capgemini
08.2011 - 04.2013
  • Conducted Oracle HCM Analytics requirements workshops, analyzed 49 data sources, developed Enterprise Data Architecture, and ETL strategy.
  • Project Manager and Solution Architect for Ground breaking Regional Transit Analytics application to integrate data from dozens of internal systems including GIS data, and CUBIC for network capacity planning, monitoring, system performance, fare evasion, CRM, and co-marketing initiatives.
  • Oracle BI Applications Health check. Reviewed Global BI implementation.
  • Recommended BI Program Release Management and BI Project Design Review processes to improve quality of BI projects and increase team productivity.
  • Recommended over 100 specific improvements to OBIEE Metadata, Reports, Dashboards, Informatica ETL mappings, and Oracle RDMS tuning.

Senior Director, Professional Services

Shingle Creek Co.
02.2007 - 08.2011
  • Implemented Oracle Human Resources Analytics Applications on Red Hat Linux with data sourced from PeopleSoft HCM and Oracle E-Business Suite.
  • Created adapters to extract data from ADP Virtual Edge, Etrade Equity Edge, DRM and Hyperion.
  • Delivered BI solutions for: Operator Performance, Wealth Management, and Institutional Market Share with data from SunGard Power Image, OMNI, Peoplesoft HCM, McCamish, and other enterprise applications.
  • Migrated production applications from Oracle environment to Teradata.
  • Delivered training for OBIEE Advanced Reporting and Dashboards.
  • Advised customer regarding Best Practices and Performance Tuning of OBIEE, IBM Datastage, and Oracle environments.
  • Created custom metadata, reports, and dashboards for real time Payroll reporting against Peoplesoft HCM.and for Financial reporting against Oracle Fusion Intelligence for Peoplesoft Enterprise 9.0 Data Warehouse.
  • Ported environment from SQL Server / Windows Server to Oracle / Sun Solaris.
  • Designed and implemented Formulary Analytics and Adverse Event Analytics Dashboards and Reports.

Senior Principal Consultant

Oracle Corporation
05.2002 - 01.2007
  • Led and delivered over 25 large OBIA implementations in the USA, Canada, Germany, Norway, Netherlands, and UK.
  • Identified new License and Services Opportunities, brought new requirements from the field to Product Marketing, Developed Intellectual Capital and Training materials.
  • Turned around several “Red” Projects led by System Integrators.

Principal Consultant

Oracle Corporation
03.2001 - 02.2002
  • Migrated Sales and Marketing Data Mart from Oracle to SQL Server and Cognos Powerplay.

Manager, Technology Applications

Quest Diagnostics
05.1995 - 01.2001
  • Directed Systems Architecture, Data Modeling, Data Governance, and Software Engineering for Informatics unit.
  • Designed Quest Informatics Clinical Data Warehouse to support E-commerce, Disease Management, PBM, and Public Health products.
  • Led Technology Integration Team that planned integration of a major acquisition.
  • Presented to executive, medical, and technical audiences.

Education

Bachelor of Science - Business Administration

Thomas Edison State College
Trenton, NJ

High School Diploma -

Burlington County Institute of Technology
Westhampton, NJ

Skills

  • Informatica Data Quality
  • Informatica Power Center
  • Oracle
  • Teradata
  • SQL Server
  • DB2
  • JIRA
  • Oracle E-Business Suite R12
  • MS DevOps
  • PeopleSoft 9x
  • Python
  • Anaconda
  • Jupyter Notebook
  • SAP 6x
  • OBIEE
  • OBIA
  • ADP Payroll
  • Siebel CRM
  • Paychex
  • PL/SQL
  • Transact-SQL
  • Taleo
  • JD Edwards
  • Sales Force
  • Data Resource Manager

Certification

  • Informatica Big Data Developer, Specialist Certification
  • Informatica Data Quality 10: Administrator, Specialist Certification
  • CompTIA Security+
  • Oracle Engagement Management
  • Snowflake Cloud Analytics Academy - Cloud Analytics Master, Architect, & Practitioner
  • Oracle Cloud Ninja - White, Yellow, & Orange Belts
  • Oracle Unified Method Levels 1, 2, & 3
  • Health Level 7

Awards

Siebel Chairmen’s Circle Award

Training

  • Informatica Master Data Management
  • Informatica Axon Data Governance
  • Python for Data Science and Machine Learning
  • Mulesoft Anypoint
  • Amazon Web Services Cloud Practitioner
  • Oracle Data Visualization
  • Oracle Analytics Enterprise Edition 12c
  • Oracle Software Security Assurance (OSSA)
  • Oracle DBMS 12c Administration
  • Oracle Data Integrator 12c
  • Informatica Power Center

Presentations

Oracle Open World 2009 – Procurement and Spend Analytics at LANL

Timeline

Solution Architect Manager

Deloitte Consulting
05.2021 - Current

IT Manager – BI & Analytics

White Cap
02.2021 - 05.2021

Software Development – IPPS-A

CACI
05.2020 - 10.2020

Senior Consultant

Informatica
07.2019 - 05.2020

Data Architect

DatAvail
12.2018 - 05.2019

Consulting Technical Director

Oracle Corporation
04.2015 - 11.2018

Business Intelligence Consultant

KPI Partners
11.2014 - 03.2015

Consulting Solutions Director

Oracle Corporation
08.2013 - 10.2014

Business Intelligence Consultant

American Partners
05.2013 - 07.2013

Senior Manager – Analytics Practice

Capgemini
08.2011 - 04.2013

Senior Director, Professional Services

Shingle Creek Co.
02.2007 - 08.2011

Senior Principal Consultant

Oracle Corporation
05.2002 - 01.2007

Principal Consultant

Oracle Corporation
03.2001 - 02.2002

Manager, Technology Applications

Quest Diagnostics
05.1995 - 01.2001

Bachelor of Science - Business Administration

Thomas Edison State College

High School Diploma -

Burlington County Institute of Technology

Similar Profiles

CREATE PROFILE
Charles Walker
Want your own profile? Create for free at Resume-Now.com