SUMMARY:

• Professional with extensive experience in 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. Additional experience in data warehousing, database administration, data architecture
• EDW, ADW, roadmaps, KPIs, analytics, metrics, dashboards, data mining, data governance, performance management, systems acquisition and integrations, conversions, ETL, data mapping, PL/SQL, stored procedures, packages, triggers, business process re - engineering, database re-engineering, software re-engineering, ground-up custom software development, software engineering methodologies, SDLC, Agile, Stone Soup, and best practices. Additional experience with data marts, materialized views, star schema modeling, Erwin,ER/Studio, Confidential BI method, conical data warehouse models including UDMH and PPDM, practices and procedures.

TECHNICAL SKILLS:

Technology and Tools: ERwin, ER/Studio, Embarcadero, InfoSphere Data Architect, PL/SQL, TOAD, ETL, Oracle, DB2, data architecture, dimensional modeling, third normal form modeling, MDM, process, Spewak, IDEF0, IDEF1x, IDEF3, use cases, business analysis, metrics, dashboards

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Data Architect

Responsibilities:

• For a Greenfield project I designed and created logical and physical 3nf and dimensional data models and deployed them on relational and MPP databases.

Confidential, Denver, CO

Data Architect

Responsibilities:

• Magellan Medicaid Administration, PBMS and Services, COSDAC, SDAC, POBMA, PPA, NCPDP, T-MSIS, Claims, Provider, Contract. 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, Hoover Alabama

Data Architect

Responsibilities:

• Greenfield Project where I created scalable and extensible analytical data warehouse data architecture. Architected the Federated Data Warehouse BI/DW solution including acquisition layer, base layer, dimensional layer, and data marts. Applied Confidential 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 Confidential InfoSphere Information Server 11.3, data profiling with Confidential 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, CO

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. Apply Boyce - 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, CO

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, Washington DC

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. The work 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, San Francisco

Data Architect

Responsibilities:

• Deployed the data warehouse, installed software, configured and managed MySQL servers for AWS Cloud and Confidential 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. Lead 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. Lead 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, Washington DC

Data Architect

Responsibilities:

• For a Confidential client created the analytical data model and implemented the architecture in Oracle with a Cognos user interface for a Transportation Management application. Designed and developed the ETL using Oracle stored procedures. Applied Kimball dimensional ER modeling using star schema design for the enterprise data warehouse.

Confidential, NY, NY

Data Architect

Responsibilities:

• 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, Madison, WI

Data Architect

Responsibilities:

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

Confidential, Dallas, TX

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, Peoria, IL

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, State of 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. Lead 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, Detroit, MI

Data Architect

Responsibilities:

• Lead the development of an Endeca warranty parts management system for claims and work orders. Lead IBMers and contractors. Using 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, Hartford, CT

Data Architect

Responsibilities:

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

Confidential, San Francisco, CA

Data Architect

Responsibilities:

• Using agile development 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, Washington DC

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, NY, NY

Data Architect

Responsibilities:

• For global wide workforce lead the development of a business intelligence application. Lead 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. For this project, I also led the DataStage team. For the DataStage team I wrote the technical requirements and lead the implementation.
• On 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 Confidential InfoSphere Data Architect.

Confidential, NY, NY

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, Harrisburg, PA

Business Intelligence/Lead Architect

Responsibilities:

• Lead legacy data conversion phase of a multi-phased project. Created data mapping strategy, data analysis, and tabular work products to support conversion approach. 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, Denver, CO

Enterprise Architect

Responsibilities:

• Led cross-functional team to provide IT alignment from findings, develop business requirements, and create IT recommendations to support core mission. 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. To lead and execute on the objectives on various enterprise architecture programs.
• Lead key initiatives. Provide strategic planning and strategic thinking. Establish business direction that is in alignment with the President's Management Agenda. Provide 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.

Confidential, Fairfax, VA

Data Architect

Responsibilities:

• Designed the data architecture for new data warehouse cubes. Implemented the data architecture from logical design to physical implementation. Created staging, dimension and fact tables. Using TOAD, developed ETL using PL/SQL for Oracle10g and Cognos reporting. Created as-is and to-be in-formation models. Created source to target mappings.

Confidential, Lakewood, CO

Enterprise Architect

Responsibilities:

• Enterprise Architect, Information Technology Project Manager and Team Lead, to lead and execute on the objectives on various enterprise architecture programs. Lead key initiatives. Provide strategic planning and strategic thinking. Establish business direction that is in alignment with the President's Management Agenda. Provide on-site expertise on governance, best practices, guiding principles, business process, and project management. Advise and represent the client at various forums and speaking engagements.

Confidential, Boulder, CO

Data Architect/Oracle DBA

Responsibilities:

• Responded to data architecture, data access methods, BI reporting requirements, WBS, sizing estimates, best practices, standards, and metrics, analytics, and performance management

Confidential, Cincinnati, OH

Data Architect

Responsibilities:

• Created the roadmap for the BI/DW strategy phase.

Confidential, Boulder, CO

Data Architect/Oracle DBA

Responsibilities:

• Development Team Lead and Business Intelligence Architect. Facilitated and led the requirements, analysis, design, and architecture for a metrics data mart for performance management.

Confidential, Raritan, NJ

Data Architect

Responsibilities:

• Led the analysis, design, architecture and process re-engineering of a phamacogenomics data warehouse using Confidential InfoSphere Data Architect.

Confidential, Charlotte, NC

Oracle DBA

Responsibilities:

• Extended the Confidential UDMH for a BI/DW implementation for health care.

Confidential, Baltimore, MD

Architect

Responsibilities:

• Client is sunsetting a 30 year old legacy system and over 200 surrounding applications. Lead the phase I of the assessment impact of the migration and plan the approach for the elimination of their Maryland Confidential legacy system and create analytics using Confidential UDMH.

Confidential, Boulder, co

Data Architect/Oracle DBA

Responsibilities:

• Assisted in the RFP to create an application for teacher credentialing using SOA.

Confidential, Denver, CO

Oracle DBA

Responsibilities:

• Drove detailed business requirements to develop software specification for KPIs, metrics, analytics, storyboards that would be used for performance management. Led the Technical Design and development phases for the conversion of a manual trading system to an automated web application. Performed source to target mapping, technical decisions, architectural model, system context model, use cases, technical design, business requirement, and team leadership.
• Designed and developed the overall user experience for interactive applications; analyzed client requirements and content organizing content into logical groupings and formed the foundation of information access; organizing the overall functional flow of the application and developing relationships between functional elements; creating functional layout of information and navigational design in the form of flow charts, branching documents, annotated wireframes, prototyping and functional templates with descriptions.

Confidential, Denver, CO

Production Support Manager/SWAT Team Lead

Responsibilities:

• Lead cross-functional and inter-department activities. Met with project stakeholders and owners and defined scope of responsibilities for task force teams; assembled and lead task force. Responsible for the Service Level Agreement and obligation of 99.9% uptime. Lead alarming and implementation strategy team. This team consisted of WBI Architects, WPS Architects, DBAs, developers, and client staff.

Confidential, Cincinnati, OH

Data Architect/Oracle DBA

Responsibilities:

• Responsible for the deliverables, milestones and dependencies on the project. Responsible for leading the overall solution, managing tasks and priorities of the modeling team, and coordinating with ETL programmers and Architects. Created data conversion strategy.

Confidential, Helena, MN

Business Analyst

Responsibilities:

• Developed use cases from the Future Process Model; facilitated use cases review sessions; and wrote the Non-Functional Requirements deliverable. Con-ducted joint application design sessions with customers and Information Technology staff to define and document business requirements for use cases; communicated with users to determine non-functional requirements; gathered, documented and published non-functional requirements

Confidential, Boulder, CO

Data Architect/Oracle DBA

Responsibilities:

• For a State client developed BI components of the RFP. Created the BI project plan, effort estimate, and project costs. Conducted COTS reviews and negotiated vendor pricing.

Confidential, Sacramento, CA

Data Architect/Oracle DBA

Responsibilities:

• Lead the client’s staff for the development of ETL scripts, SQL, and Oracle PL/SQL stored procedures, packages, and triggers for multi-terabyte Ora-cle10i RAC database on Linux. This work included developing the requirements, soft-ware design, development, and testing phases of the SDLC.

Confidential, Denver, CO

Executive Architect

Responsibilities:

• BI Architect, Data Architect, Data Modeler, Enterprise Architecture, Process Consulting, Oracle DBA, PL/SQL

Confidential, Denver, CO

Executive Architect

Responsibilities:

• Partnered with business owners and IT executives and Directors to champion IT initiatives in support of business strategic mission and corporate direction. Drove to functionally align IT products and deliverables to functional business areas.

Confidential, Broomfield, CO

Data Architect/Oracle DBA

Responsibilities:

• BI Architect, Data Architect, Data Modeler, Enterprise Architecture, Oracle DBA, PL/SQL. Created and maintained data modes, implemented data architecture, and performed data conversions. Conducted post mortems and lessons learned.

Confidential, Denver, CO

Data Architect/Oracle DBA

Responsibilities:

• Developed PL/SQL stored procedures, triggers, packages SQL*PLUS scripts, UNIX scripts for Oracle databases which use PowerBuilder as the client application in a very large-scale high volume client/server environment.

Confidential, Denver, CO

Sr. Systems Analyst

Responsibilities:

• Debugged Pro*C, PL/SQL, SQL, SQR, Visual Basic, and Access code. Enforced business rules for Oracle 7.x production databases and ensured data integrity. Provided source data quality analysis. Created project plans using MS Project

Confidential, Denver, CO

BI Architect/ Data Warehouse Architect/Developer

Responsibilities:

• Directed and managed a large operating group, then moved into I.T. to man-age projects in all stages of the software acquisition and development life-cycle. Directed and managed development, technological change, change control, implementation,, support, Quality Assurance for advanced technological systems. Developed very large high scale client/server CRM/BI solutions using Visual Basic, Visual FoxPro and
• Access GUI’s with Oracle, IN-FORMIX, SQLbase, Sybase and Access databases. Included in the design were audit trails and fraud detection. Built dimensional and relational data warehouses, and created the ODS, EDW, AND ADW. Created and maintained data modes, lead and performed data migration and data integration, implemented data architecture, data mapping, data analysis, and performed data conversions. The applications and data were built to conform to enterprise architecture and have security measures and matrices in applications and data built-in and bolted-on.
• Designed and developed the overall user experience for interactive applications, analytics, executive dashboards; analyzed client requirements and con-tent organizing content into logical groupings and formed the foundation of information access; organizing the overall functional flow of the application and developing relationships between functional elements; creating functional layout of information and navigational design in the form of flow charts, branching documents, annotated wireframes, prototype, and functional templates with descriptions.