SUMMARY:

Candidate is a results oriented Software Consultant with significant experience in the areas of Business Intelligence, Data Analytics and Data Warehouse Design. With more than 25 years of focused, practical experience, Candidate has a proven record of accomplishment of delivering relevant solutions from a variety of development and technology perspectives - from Requirements Analysis and ETL Framework construction, to Data Administration and Warehouse Architecture Design. Focused and independently motivated, Candidate has repeatedly demonstrated an affinity for working across multiple levels of abstraction to address technology challenges based on real-world solutions - on time, within budget, and according to the scope and requirements prescribed by James’ clients.

AREAS OF SPECIALIZATION:

Dimensional Modeling and Data Warehouse Design

IA-Data Administration (employing the use of Conceptual, Logical and Physical Schemas)

Big Data: Issues, Concepts, and Implementation

Query Analysis, Mapping Specification, and Data Lineage

Requirements Gathering, Curation and Presentation of Documentation Artifacts

Fit Gap Analysis

Use Case Definition and Test Plan Implementation

SKILLS SUMMARY:

ERwin

ANSI SQL/PL/SQL

MS Stored Procedures

JavaScript/HTML/XML

Teradata

DTS/SSIS

SSAS

Adobe Dreamweaver

Informatica PowerMart

PeopleTools/PeopleCode

PS Application Engine

PS Query

PS Data Loader/Mover

VB Script/ASP

PS Data Loader

Business/Functional Capabilities

Healthcare/Claims Management

Workforce Management/Human Resources Operations

Distribution/Transportation Networking

Campaign Management

Basel Compliance and Regulatory Reporting

Customer Relationship Management

PROFESSIONAL EXPERIENCE:

Confidential

Data Warehouse Functional Lead

Responsibilities:

• I m responsible for creating and implementing all data modeling standards, as well as deployment of the ERwin model management framework for each Campaign Management Line of Business
• Responsible for all data modeling workstreams.
• Identifies tasks, timelines, and priorities per the governing plan
• Facilitates integration of Analysis/Design objectives with Development actualization.
• Responsible for selecting creative design solutions to meet business/project needs
• As DA Lead for Customer and Member/Benefits domains, I m currently responsible for architecting Enterprise, compliant solutions that support UHG s consolidation, growth, and industry compliance initiatives.
• Provides direct support to Business Analyst and Software Development teams
• First point of contact regarding Data Modeling enhancements and standards
• Data Architecture Lead responsible for assessment and implementation of proposed data model changes.
• Responsible for evaluating and facilitating data integration approaches and their impact across the enterprise.
• Participates in cross/inter - team collaboration regarding design standards and solution options
• Provided Design and Implementation support for project-developed data models in support of Confidential Minneapolis-based, Enterprise Data Architecture Team.
• This is a client-facing position requiring an in-depth understanding (of), and ability to manipulate data concepts across multiple levels of detail. Model & Metadata Management, Naming & Process Standardization and enforcement of Data Governance policies and procedures have been central to this role. the position requires manipulation of diverse modeling methodologies, and an extensive use of ERwin Model Manager.
• Responsible for Review and Approval of Data Model enhancements
• Provides direction to Development Staff concerning Data Modeling standards
• IA Contact regarding Data Model assessment and improvement to ensure that proposed enhancements simultaneously support detailed business requirementswhile achieving successful alignment with Confidential 's Enterprise framework
• Technical Resource for HR, Vendor, and Transportation Subject Areas
• Managed the Requirements Definition, Architectural Design, and Software Test Plan deployment phases for one of Confidential s key Basel II compliance initiatives. The Credit Risk Publication Layer is a Software/Metadata-based component of the Bank s Data Warehouse that enables external access of Credit Risk Exposures and their Mitigants.
• Responsible for Business and Functional Requirements Definition
• Knowledge Sharing and Mentoring to Business Users on Technical Issues relating to the definition, creation and use of related Business Processes and Data
• SQL/Query Analysis and Report Writing Support
• Knowledge Sharing and Mentoring to Technical Staff on Functional Issues relating to Capital Adequacy Requirements, Credit Risk Analysis, and Basel II Compliance.
• Developed, Executed, and Managed the results of project related Software Test
• Plans, User Test Cases, and SQL Script validation

Confidential

Software Solutions Architect

Responsibilities:

• Architected a Business Intelligence Solution SQL Server 2005 BI Reporting working as a direct report to Confidential Architecture & Internal Systems and Analysis Framework Manager.
• Conducting a review of existing reporting platforms to provide suggestions on how/where improvements could be made; performing a data and technology assessment focused on standardization and data quality improvement; and lastly, to architect a comprehensive solution employing Business Intelligence technologies and best practices, that would bring Confidential ’s data analysis platform(s) in line with prevailing methodologies currently used within the Software/IT Marketplace.

Confidential

Data Warehouse Technical Lead

Responsibilities:

• Implemented a custom (DTS) package solution in support of the Regulatory Reporting function for Confidential ’s UK and Luxembourg Branches.
• Additional responsibilities included the setup of a Dimensional Model and Data Mart to manage Asset Exposures for Regulatory Capital and Basel II Compliance

Confidential

EPM Technical Lead

Responsibilities:

• Implemented the Enterprise Warehouse layer of PeopleSoft’s EPM Architecture, ensuring successful integration with ODS Source elements as well as related Data Mart Builder interfaces and input requirements.

Confidential

ETL Designer

Responsibilities:

• Installed a Rapid Deployment Data Mart solution to support UNT’s Student Administration, Financials, Campus Community and HCM ERP modules.

Confidential

EPM Data Mart Specialist

Responsibilities:

• Provided technical support for a Proof of Concept install at CSFB.
• The team deployed an EPM solution that demonstrated the viability of implementing EPM’s three architectural layers to process millions of FNI Source Ledger transactions.

Confidential

EPM Technical Lead

Responsibilities:

• Installed and configured Informatica PowerMart in support of a CRM/EPM deployment .
• Additional responsibilities included Fit/Gap Analysis and Project Plan estimates, as well as directing the rollout and technical configuration of the client's EPM environment.