SUMMARY:

• Data warehouse and data architect/developer with 20+ years of experience.
• Strong logical and physical modeling for both relational and dimensional systems.
• Broad experience in the design, development and deployment of transactional and business intelligence systems on cloud and network infrastructures.
• Extensive experience designing and modeling SCD, CDC capabilities.
• In depth knowledge of normalization/denormalization techniques.
• Strong design skills with both Inmon and Kimball architectures.
• Experienced migrating OLTP’s and data warehouses to the AWS clould.

TECHNICAL SKILLS:

Data Warehousing

Database Administration

Data ArchitectureEDW / ADW

Roadmaps

KPIs

Analytics

Metrics

Performance management

Dashboards

Data Governance

Systems Acquisition & Integrations

Legacy system conversions

Stored Procedures

Packages

Triggers

Business Process Re - engineering

Database Re-engineering

Software Re-engineering

Custom Software Development

Software Engineering methodologies

SDLC

Agile Practices, Processes

Stone Soup

Best practices

Data marts

Materialized views

Star schema modeling

Erwin

ER/Studio

Embarcadero

InfoSphere Data Architect

SQL

PL/SQL

TOAD

ETL

Oracle, Informix, Sybase, SQL Server, DB2, SQLBase, Exadata, Teradata

Dimensional modeling

Third normal form modeling

IBM BI method

SCD

CDC

MDM process

PROFESSIONAL EXPERIENCE:

Confidential, Denver

Data Architect

Responsibilities:

• For a global transportation company re-engineered a enterprise wide integrated data warehouse for deployment on Redshift. Architected the ODS using Inmon methodology. Architected the data lake, integration layer, ETL, and reporting platform for AWS.
• Translated business needs into data models supporting long-term solutions.
• Worked with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Created logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Created Star and snowflake schema data models.
• Optimized and updated logical and physical data models to support new and existing projects.
• Maintained conceptual, logical and physical data models along with corresponding metadata.
• Developed best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Recommend opportunities for reuse of data models in new environments.
• Evaluated data models and physical databases for variances and discrepancies.
• Validated business data objects for accuracy and completeness.
• Analyze data-related system integration challenges and propose appropriate solutions.
• Developed data models according to company standards.
• Guided System Analysts, Engineers, Programmers and others on project limitations and capabilities, performance requirements and interfaces planning.

Confidential, Denver

Data Architect

Responsibilities:

• Greenfield project: Rehosting to Oracle from Teradata, applied data modeling / data warehouse / BI concepts/ ETL methodologies, using Erwin created data model (conceptual/logical /physical) for Teradata. Created source target mapping document, created DDL and Oracle table development.
• Used data modeling tool such as Erwin, performed data profiling and data standardization. Performed requirements gathering and data analysis.
• Interacted and collaborated with business users and ETL development team. Application data integration best practices in data warehouse environment.
• Served as a key point of contact within IT when working with customers, managed customer expectations and ensured prompt and complete customer service, customized presentations to the interests of the audience.
• Identified problems and risks and raised them to the appropriate level.
• Created BUS matrix and FQM matrix from business processes and specifications, performed data discovery, attribute identification, source to target mapping, data profiling.

Confidential, Denver

Data Architect

Responsibilities:

• Designed enterprise data warehouse using Inmon’s data warehouse architecture.
• Created an enterprise data warehouse in an integrated repository of atomic data. Designed the enterprise data warehouse to capture data at a very lowest level of detail.
• Designed the enterprise data warehouse in a relational database and used third normal database design for Exadata.

Confidential, Maryland

Data Architect

Responsibilities:

• Architected the Federated Data Warehouse BI/DW solution including acquisition layer, base layer, dimensional layer, and data marts.
• Applied IBM UDMH, created naming conventions, revised DB schemas for consistent use of terminology, naming, update history, ETL Meta data, logging, HIPAA compliance, security and access control, data exchange protocols, impact assessment of model changes and flow of data to ODS and data marts to help build daily process, performance monitoring, architectural assessment, technical/design and alternative options, conceptual, logical and physical data model for RDBMS, data model standards, created data flow diagrams, steward/protect NPPI/PII.
• Data architecture roadmap, data architecture strategy, cross platform integration with DB2 IBM InfoSphere Information Server 11.3, data profiling with IBM InfoSphere Information Analyzer 11.3, Erwin 9.6.4, WinSQL Professional 9.0.7
• Applied Kimball dimensional ER modeling using star schema design for the enterprise data warehouse.

Confidential, Denver

Data Architect

Responsibilities:

• Designed, deploying, and maintaining conceptual, logical, physical data architectures for both relational and dimensional data models for data warehouse and business intelligence systems on Teradata, and integrating disparate systems into conformed dimensions using Kimball and Inman methods.
• Codd 3rd normal form, Inmon or Kimball data warehouse techniques such as star schema or snowflake schema modeling as appropriate to the business requirements for base, integration, dim, and presentation layers for Teradata.

Confidential, Denver

Data Architect

Responsibilities:

• Created conceptual, logical and physical relational models for integration and base layer; created logical and physical dimensional models for presentation layer and dim layer for a dimensional data warehouse in ERwin.
• Wrote DDL including indexes, grants, synonyms, sequences, applied DDL, and created physical objects for SQL Server 2014.
• Built process models, created mapping specifications, created data flow diagrams, scheduled interviews and interviewed stakeholders for requirements and created BRD, HLD and LLD.
• JIRA and Trello were used to track Agile sprints, and daily activities.

Confidential

Data Architect

Responsibilities:

• Drove requirement sessions with the client to the degree ER/Studio analytical logical and physical star schema data models could be designed from three source systems.
• Generated the DDL for deployment on Netezza and Oracle data warehouse.
• Built-out staging layer and EDW for source systems.
• Created source to target mapping from Sybase and Oracle source systems to Netezza and Oracle.
• Used SQL Developer to write SQL queries to perform data mining to validate business rules.
• Created analytical data models using Erwin for Oracle and Netezza.
• Designed OLAP layer for four subject areas from the four OLTP systems.
• Included dimensional modeling, data profiling, Oracle 11g, and Oracle PL/SQL skills. Created the dimensional model for the reporting system by identifying required dimensions and facts.
• Created mapping spreadsheets with source to target data mapping with physical naming standards, datatypes, domain definitions, documented and maintained logical and physical database models in compliance with enterprise standards.
• Created ETL detailed design and development ETL specifications document including business transformation rules.
• Applied Kimball dimensional ER modeling using star schema design for the enterprise data warehouse.

Confidential

Data Architect

Responsibilities:

• Deployed the data warehouse, installed software, configured and managed MySQL servers for AWS Cloud (Redshift) and IBM Azure SoftLayer cloud.
• Maintained, built, supported, tuned, and monitored production in MySQL database servers.
• Created the architecture for strategy, macro design, micro design phases, including but not limited to ETL Specification, data mapping, Database Specification, all data models, DDL, server configuration, sftp, Security, and hosting.
• Led the installation of DataStage, SQL Server, MySQL, and Tableau.
• Led requirements, design, development, and implementation of BI/DW application.
• Created specifications for: SQL Server database, ETL, HADR, server configuration, environment configuration, pgp data encryption, ftp, and security. Designed and implemented analytical data model for multiple releases and staged delivery, and subject areas with confirming dimensions.
• Applied industry best practices to create an extensible and scalable application. Lead the installation of DataStage, SQL Server, MySQL, and Tableau on Cloud servers.
• Led off-shore development ETL and DBA team.
• Created ETL design specifications including transformation rules, data mapping, and business rules.
• Created source to target mapping. Lead implementation of data collection, data transformation and integration with reporting framework.
• Applied Kimball dimensional ER modeling using star schema design for the enterprise data warehouse.

Confidential

Data Architect

Responsibilities:

• Designed and developed the ETL using Oracle stored procedures.
• Applied Kimball dimensional ER modeling using star schema design for the enterprise data warehouse.

Confidential

Data Architect

Responsibilities:

• Architected AWS (Redshift) DW implementation for digital marketing for a pharmaceutical global enterprise.
• Created analytical data architecture and data models for executive dashboards. Performed source to target mapping from to-be systems to as-is legacy DB2 systems.

Confidential

Data Architect

Responsibilities:

• Reversed engineered c code for business rules and mapping source to target Oracle database for Informatica ETL.
• Created MDM infrastructure.

Confidential

Data Architect

Responsibilities:

• Created system context diagrams, data flow diagrams, and application profiles for legacy systems targeted for migration and conversion integration into Oracle.

Confidential

Data Architect

Responsibilities:

• Created the ETL architecture, data modeling, data mapping, data definitions, view definitions, master data management, MDM, and data profiling for analytical Automated Condition Monitoring for claims and work orders metrics and KPIs for an Oracle database and SSPS user interface.

Confidential, Washington

Data Architect

Responsibilities:

• Created the roadmap and lead the development of a DB2, DataStage, and Cognos, business intelligence analytic data warehouse application.
• Created surveys, conducted interviews of the business to determine strategic and tactical direction.
• Led team to create and implement business intelligence solution for an analytical data warehouse and reporting implementation.
• Architected the overall BI/DW solution.
• Created MDM, OLAP data architecture, analytical data marts, and cubes optimized for reporting.
• Performed requirements gathering, wireframes, proto-typing, source to target mapping, metric requirements, analytical data modeling, DDL, best practices, architectural guidance, ETL logic, guidance, data analysis, data map-ping, and performance tuning.
• Additional experience designing warehouse solutions off existing applications, specifically around the warehouse, ETL and reporting layer design.
• Designed the OLAP cubes and dimensional models. Designed using and deploying canonical data models and design patterns.

Confidential

Data Architect

Responsibilities:

• Led the development of an Endeca warranty parts management system for claims and work orders. Led IBMers and contractors.
• Used PL/SQL, created, modified stored procedures, triggers, packages, ETL, and SQL scripts for Oracle. Performed data mapping and data analysis.
• Managed table space, created indexes, tables, views, imported and exported data. Reversed engineered and modeled code to extract business rules.
• Worked with client POC to drive detailed design specifications from high level business requirements and implement.

Confidential

Data Architect

Responsibilities:

• Led the development of a analytical application.
• Used Stone Soup methods created logical data model from IBM UDMH for payer on Oracle using IBM InfoSphere Data Architect.

Confidential

Data Architect

Responsibilities:

• Utilized agile development practices, created the data model for an analytical data mart that supports metrics, KPI’s, Business Objects, and reporting requirements for a gas and electric utility company.

Confidential

Data Architect

Responsibilities:

• Created the logical and physical data models of this government wide application that supports travel booking, authorization, and expense reporting for all the agencies of the government.
• Created interface file specifications to load all tables and designed the ODS. Included in the design were audit trails and fraud detection.

Confidential

Data Architect

Responsibilities:

• Led team to develop and implement metrics and analytics that report on performance.
• Analyzed metrics and created a dimensional data model, analytic data marts, cubes, and I implemented on DB2, and provided DB2 DBA support.
• Led the DataStage team. For the DataStage team, wrote the technical requirements and led the implementation.
• Other projects: created the as-built data model for rich client applications into a fully attributed logical and physical data models for DB2.
• Provided production and pre-prod DB2 support.
• Examined requirements for analytics and documented business rules.
• Re-engineered BRIO queries into requirements for DataStage jobs including data mapping, and data analysis.
• Created analytical cubes for Cognos reporting.
• Functional areas included deal workflow, pipeline, and contract erosion.
• Created analytical data models using IBM Infosphere Data Architect.

Confidential

Data Modeler

Responsibilities:

• Developed executive level and ownership level surveys, con-ducted the surveys, and developed BI business requirements from them.
• Created the BI roadmap from business requirements and developed recommendations from analytics for establishing BI tactical and strategic direction.

Confidential

Business Intelligence/Lead Architect

Responsibilities:

• Facilitated JAD sessions and coordinated DataStage, DB2 and migration and integration work effort with the client.
• Evaluated MDM, PL/SQL code and performed code reviews.
• Leveraged use cases and object models for source of record for business process, data, and business rules.

Confidential

Enterprise Architect

Responsibilities:

• Created blueprints and recommendations in support of Managing 4 Excellence, Managing Business Transformation-an organization structure for efficiency and effectiveness; server, physical plant, and data consolidation; Master Data Management (MDM), impacts of external initiatives on IT services (BPR), Information Technology Service Management (ITSM), Information Technology Information Library (ITIL), Federal Enterprise Architecture (FEA), COBIT, governance, best practices, and leadership.
• Enterprise Architect, Information Technology Project Manager and Team Lead. Led and executed objectives on various enterprise architecture programs.
• Led key initiatives. Provided strategic planning and strategic thinking. Established business direction in alignment with the President's Management Agenda.
• Provided on-site expertise on governance, best practices, guiding principles, and business process.
• Applied Zachman, PDAT, and IDEF0 to create component business models and business architectures.