We provide IT Staff Augmentation Services!

Sr. Data Architect Resume

Raleigh, NC

SUMMARY:

  • Information Architect who draws upon an in - depth background in Data Architecture, Business Analysis, Project Management, and enterprise Business Intelligence (BI) processes/tools to increase the quality, flow/distribution and availability of information for organizations in multiple industries including Healthcare/IT standards (HITSP) experience.
  • Notable history of project-completing leadership, planning, technical expertise and business acumen.
  • Provided BI used to reduce Cisco’s customer network outage times by approximately 18%.
  • Managed a National Account Project that designed, produced and deployed a new international material management system, significantly reducing inventory costs and order delivery times.
  • Developed data and process models for a mainframe-to-client server migration, reducing costs by over 20%
  • Superior communications and negotiation skills, with Stakeholders, across and with C Levels.
  • Excellent documentation and presentation skills. Presented Enterprise Information Management strategy with SOA Data Quality and Master Data Management plan to senior IT management of a fortune 50 company.
  • Managed four major enterprise cost reduction projects on time and under budget.
  • Direct management experience (10 Yrs) leading and mentoring experienced professional personnel.
  • Extensive hands on experience with multiple database languages and tools in various BI/IT environments.
  • An experienced professional with high integrity that can take a task and deliver on it.
  • Planned, managed, and led purposeful, structured innovative management technological solutions.
  • Generated project plans, monitored progress and completed projects in excess of $150 mil.
  • Analyzed requirements, created functional specifications and architectures, re-engineered business processes.
  • Experienced in enterprise Supplier Management, Business Intelligence (BI), metrics, Data Warehouses, Siebel CRM Call Center, Sales, Service, and Marketing applications and Siebel Analytics (now Oracle OBIEE)
  • Experienced in As is/To be business process modeling, Business Intelligence and OLTP and OLAP systems.
  • Developed operations plan, migration strategies and cost scenarios for a DoD-wide healthcare system.
  • 20 Years - Business/IT Analysis, Technical Team Leadership, System, Applications and Data Architectures; gathering, assimilating, organizing, categorization and analysis of business requirements, business process modeling, determination of metrics, and Key Performance Indicators (KPIs). Extensive communications skills
  • 20 Years -- Information Engineering/Metadata Management (Oracle Designer 2000, Visio, System Architect and ERwin) Process Modeling (BPwin), Work group Facilitation, JAD sessions, Canonical, Conceptual, Logical, and Physical modeling, Multi-Dimensional methodologies, reverse engineering, physical databases, IEW, ADW, IDEF, Data Base Examiner, Oracle, PL/SQL, SQL Plus, SQL Server, and Teradata, Utility industry Data Model.
  • 20 Years -- Hands-on Database, Data Warehouse Architecture/Modeling; Application/database design with Oracle (20yrs), Teradata (4yrs), SQL Server (4 yrs) ; database integration & design, implementation of Business Rules and Integrity Constraints, examination of data base structures and architecture, analysis and modification of Tool-generated SQL, PL/SQL, 3NF, using Data Base Examiner, SQL-Explain, TOAD, prior experience with IMS, IDMS, DB2
  • 15 Years -- ETL processes, XML; OLTP, OLAP, RDBMS, Multi-Dimensional, DataMart and Statistical Modeling, Analytical applications, and Management Information and Decision Support Systems (DSS), Rational, Business Intelligence (BI), reporting tools, Microstrategy, Cognos, Siebel Analytics, SQL, data quality and testing procedures
  • 9 Years -- System and Developer Standards and Documentation, Macroscope system documentation
  • 7 Years -- Project Management: Project Management tools, CMMI, four major projects (2, 1.5, 1.5 and .5 years), MS Project, Visio, Rational Rose, multiple PM Methodologies (Agile, RUP, RAD, JAD, SDLC)
  • 6 Years -- Instructor/Training: Undergraduate (IT+Business), project and customized training, APICS certification
  • 3 Years -- Enterprise Architecture design and planning, TOGAF, CIF, Data Integration, analytics, migration
  • 3 Years -- Data Quality, Analysis, Integration, Profiling and Mapping functions SLAs and SOA (Service Oriented Architecture) planning; SharePoint, Axio, Qualitystage, Auditstage, Datastage, Axio-FTM, DOORS
  • 3 Years -- Corporate Data Administrator; Data Sourcing, Governance, Security, Quality, Metadata Management
  • 3 Years -- Healthcare/IT, CRM, MRP, Gap Analysis, enterprise repository, eCommerce, Call Center, Sales, Service, Technology-Enabled Marketing, and Tools, Siebel Analytics (now Oracle OBIEE), CDC, click-stream analysis
  • 1 Year -- Object Oriented/UML Architecture and Design, Use-Case analysis; TriZetto's Facets enterprise-wide software solution for health plan administration; the Netezza Data Appliance; Cloud software. Kaizen participant
  • 5 Months -- Migration of SQL Server 7-based applications, databases and data to an Oracle-based system, use of Oracle Migration Workbench and SQL Server 7 tools; SQL Server 2008 T-SQL, SSIS SSRS & SSAS Tools

WORK EXPERIENCE:

Sr. DATA ARCHITECT

Confidential, Raleigh, NC

Responsibilities:

  • Participated in multiple meetings and presentations addressing Confidential actions/requirements.
  • Actions are primarily dependent on new organization and IT redirection to better support senior enterprise levels rather than previous sub-organizations.
  • Worked with multiple project managers to provide means to decrease required project time, target results to new requirements and improve usage of IT resources for Business Intelligence purposes.
  • Recommended metrics for tracking improved competitiveness.

Sr. DATA ARCHITECT

Confidential, CA

Responsibilities:

  • Reviewed existing corporate plans, systems and databases with owners and IT personnel.
  • Reviewed new Confidential meter feeds and staging databases to determine ETL processes and required data.
  • Developed plan for integration of Confidential data into enterprise systems and Data Warehouse Plan for ROI.
  • Developed new budget forecast for legally required years of storing meter data, which cancelled out BI funding.

Sr. DATA ARCHITECT

Confidential, Austin, TX

Responsibilities:

  • Worked with local and remote IT and engineering personnel to plan, design and integrate engineering, production, and production quality data into an existing Enterprise Information System Architecture.
  • Reviewed existing BI architecture and pending modifications to determine improvements to data integration and implementation of analytics using Hadoop system engineering imports of data.

Sr. DATA ARCHITECT

Confidential, Boise, ID

Responsibilities:

  • Reviewed existing corporate plans, systems and databases with owners and IT personnel.
  • Reviewed new Confidential meter feeds and staging databases to determine ETL processes and required data.
  • Architected existing enterprise data warehouse model for energy meter reading applications and BI analytics.
  • Produced the Data Architecture planning document for Confidential ’s 2 year enterprise energy project.
  • Modified new and existing Data Models to integrate into vendor provided Utility Industry Model.

Sr. DATA ARCHITECT

Confidential, Olympia, WA

Responsibilities:

  • Developed As/Is and To/Be Data Interface Specifications (100) for new State Unemployment System Data Warehouse for a major 4-year Confidential contract that was behind schedule. Scheduled, coordinated and hosted meetings with affected parties with uniquely developed agendas to produce new draft specifications.
  • Reviewed specifications and recommended changes with project departmental management to complete and document specifications for review with previously affected parties.
  • Upon completion of reviews, modified and updated various database (DB2 & SQL Server) structures for succeeding application development.

BUSINESS/TECHNICAL CONSULTANT

Confidential, Kent, WA

Responsibilities:

  • Assisted in the development of Cloud product and service technologies for customer data warehouse services.
  • Assisted in developed of a growth strategy that included virtual server considerations. Plan included capabilities to save customers configuration time, increase productivity, improve access to information via an internet connection and to ensure business continuity in the event of an unforeseen on-site disaster. (also see 2002)
  • Organized and led efforts associated with Data Quality, Data Integration, Data Governance/Data Stewardship, analysis and functional testing of SQL Server (BI) Data Warehouse enhancements and new DB2 CRM system.
  • Developed understanding of healthcare terms, data and enterprise warehouse with a focus on data analysis.
  • Designed, developed validation processes for transfers of data from source systems, including TriZetto's Facets SQL Server enterprise-wide software solution; assisted evaluation and selection of Netezza Appliance.

SR. DATA ARCHITECT

Confidential, Bellevue, WA

Responsibilities:

  • Helped design and build an Enterprise Supplier Management Warehouse (BI).
  • Improved quality and throughput, Datastage ETL processes for the Teradata warehouse and the supporting Oracle databases; expanded the OLAP Datamarts and multi-dimensional ad hoc Business Analytics and Cognos processes.
  • Provided the Application Analyses, Data Modeling, Metadata Management, Integration & testing functions for existing applications and the new Performance Assessment and Invoice Visibility applications.
  • Designed and assisted with development of portals for Suppliers and the Supply Chain Management System
  • Researched multiple Confidential divisions and prepared, presented and received approval from Senior Business and IT management for an EIM strategy using SOA architecture, providing for Data Quality, Data Integration and Master Data Management services.
  • PROJECT MANAGER for the requirements, design, development and deployment of Confidential ’s award winning Supplier Performance Management system. Used Confidential ’s CMMI, Clearcase, Clearquest, Rational, ERwin,
  • Datastage, Qualitystage, Macroscope tools; SOX, Configuration Management, SharePoint and LEAN quality and process improvement methodologies.

SR. FINANCIAL ANALYST

Confidential, Seattle, WA

Responsibilities:

  • Assisted with an enterprise financial Cost Management SOX transition project; using the Macroscope (P+) Project Management Methodology, the Metis Process modeling tool, and the Erwin Data Modeling tool suite.

SENIOR BUSINESS CONSULTANT

Confidential, San Jose, CA

Responsibilities:

  • Planned BI support for a corporate Quality Data Initiative to define and improve operational metrics.
  • Provided metrics used to reduce customer network outage times by approximately 18%.
  • Worked with Engineering, Networks, Lean/Six Sigma group and Customer Advocacy business units to define specific organizational and functional BI requirements using Siebel Analytics (now Oracle OBIEE) and Cognos.
  • Helped design an enterprise DB2 data warehouse for providing improved corporate Business Intelligence
  • Developed Livelink hierarchies, functional specifications, process and data models, data integration plans, swim-lane and context diagrams, metrics and analyses for corporate and functional dashboards.

BUSINESS/TECHNICAL CONSULTANT

Confidential, Kent, WA

Responsibilities:

  • Executed assigned tasks to assist new company with service offerings including designing, building, installing, testing, tuning, backup, recovery and hosting of new Oracle applications and databases.
  • Assisted with strategic planning, development of business plans, new offerings and products, proposals, database designs, documentation and presentation of deliverables.

BUSINESS/TECHNICAL PROJECT MANAGER

Confidential, Bellevue, WA

Responsibilities:

  • Managed implementations of Siebel’s CRM Call Center, Sales, Marketing, Service and Financial applications using the Pharmaceutical and Telecommunications Vertical applications. Conducted gap analysis sessions to identify business process issues requiring refinement of business requirements and/or necessary configuration changes to the Oracle based Confidential . Designed business analytics and metrics for new processes.
  • As Project Manager, Communicated requested, necessary, and planned information to management concerning organizational, process, and product shortcomings, support, training, and personnel issues resulting in necessary changes required for successful completion of projects.
  • Gained CRM experience in the telecommunications, manufacturing, energy management, and pharmaceutical industries, with a focus on eCommerce and click-stream analysis while developing marketing campaigns
  • Completed projects from start to finish, on time and under budget as the project manager from Siebel
  • Taught Siebel’s 5-day Requirements Analysis course to client personnel at the Siebel Education Center
  • Became Siebel Certified and Siebel Customer Certified through extensive training and experience.

BUSINESS/SYSTEMS ANALYST

Confidential, Seattle, WA

Responsibilities:

  • Provided business and technical consultation while planning a Case Management/CRM enterprise system.
  • Managed client teams for requirements analysis, strategy planning, and development of an RFP for vendor selection for the integration of field user needs and services.
  • Prepared CRM data models and crossover documents; improved existing SQL Server functions for deployment

DATA ARCHITECT

Confidential, Seattle, WA

Responsibilities:

  • Performed analysis of existing suite of eCommerce software products, architecture, databases and processes.
  • Used Oracle Migration Workbench to migrate SQL Server 7-based products, databases and PL/SQL stored procedures to DrugStore.com’s Oracle to enable support for both SQL Server and Oracle.
  • Assisted with Extract, Transform and Load (ETL) procedures, XML and click-stream analysis for new products.

DATA MODELER/DATA ARCHITECT

Confidential, Bellevue, WA

Responsibilities:

  • Conducted business requirement’s analysis for sales, order tracking and revenue reporting Oracle systems.
  • Developed enterprise data model to integrate and cleanse data from systems located at acquired companies.
  • Authored Corporate Charter Document establishing enterprise information management requirements.
  • As member of CIO Architecture Systems Group developed data warehouse and corporate process models.

CORPORATE DATA ADMINISTRATOR

Confidential, Reston, VA

Responsibilities:

  • Responsible for determining the corporate data integrity, quality and management requirements.
  • Designed and developed an Oracle web-based data/information management infrastructure.
  • Published Sources and Uses Model using Oracle eBusiness Projects and Financials systems
  • Developed top-down workflow and process models of major corporate processes and functions.
  • Completed examination and review of data model for a large financial data warehouse project (BI).
  • Directed preparation of the corporate Information Architecture and Strategic Information Systems Plan.

PROJECT MANAGER/DATA ARCHITECT

Confidential, Reston, VA

Responsibilities:

  • Managed the testing and integration of application within the existing mainframe-based applications, mapping the VSAM files to ORACLE tables, columns, triggers, constraints, indexes and conical modeling.
  • Used data modeling tools (Designer2000, ERwin) to develop logical and physical OLTP, OLAP, MOLAP models.

SENIOR ADVISOR

Confidential, Arlington, VA

Responsibilities:

  • Designed metrics and business analytics for an Agency-wide Decision Support System (DSS) (BI) to meet White House initiated Performance Measurement and Results Indicator requirements using Cognos and Microstrategy.
  • Developed data and process models (using ADW, ERwin, and BPwin) while assisting five Business Area Analysis Teams to re-engineer processes on a worldwide USAID business process improvement project.
  • Coordinated Oracle database examination activities to assist application development teams in using and complying with Naming and database Structure Standards.

PROJECT MANAGER

Confidential, Rockville, MD

Responsibilities:

  • Provided significant current and future cost reductions for the US Navy by building a Medical Executive Information System (BI). Project scope included planning, requirements analysis, and quality assurance.
  • Cost areas for improvement included management, quality of care and allocation of resources. Business functions included Finance, Managed Care, Planning, Human and Physical Resources, Contracting, Education and Training.
  • Designed system functionality to include OLAP drill-down to multiple levels of detailed data, embedded SQL queries, multi-dimensional modeling, and various decision support tools and forecasting.
  • Led Facilitated Workshops and Joint Application Development (JAD) sessions to refine requirements.

Hire Now