Passionate professional defining and aligning strategy, capabilities and capacity, and leading and motivating people and projects to “move the needle” with successful, high value/high impact outcomes. Combining business acumen with technical savvy as a thought leader, innovating and implementing highly integrated, scalable global information strategy and architecture, advanced analytics, “big data,” cloud platforms using proven and emerging technologies driving top line and bottom line impacts in insurance, banking, financial, real estate, health, utilities, energy and safety. Create high value and reduced investment/cost.
Leadership and Professional Services
Engage with client senior executives to identify strategic and tactical initiatives. Build practice, develop strong client relationships, sell, manage and deliver professional services in an engagement, portfolio or individual initiatives for enterprise, cross-functional and global business units. Assembled highly motivated professionals in skilled teams. Responsible for establishing, driving and socializing strategic vision. Manage teams quickly delivering high impact solutions that have improve business opportunities and drive out costs. Develop and mentor individuals, matching skill sets and personality traits with assignments to achieve the best possible results. Identify and resolve goal conflicts within the project team and organization. Develop investment justification for engagements and deliverables. Monitor the work with appropriate indicators in ways that identify and correct problems early and consistently deliver excellent results. Clear communication with clients on engagement success. Skilled negotiator with a track record of driving agreements to win-win.
Enterprise and Solutions Architecture
Assess current organizational capabilities, those required for achievement of goals and strategy and identify gaps in each of the enterprise architecture disciplines: business architecture, application architecture, security architecture, information architecture and technology architecture. Alignment and transformation of people, process, and technology solutions to establish or remediate identified foundational and operating capabilities. Drive out and map requirements to capabilities and create roadmap to achieve a fully functioning future state organization and supporting technology stack. In steady-state scenarios, perform technology portfolio analysis to identify redundancy and gaps and rationalize assets. Maximize flexibility, stability, consistency, operational effectiveness and governance. Develop appropriates models to support and verify understanding.
Information Management, Data Warehouse, Advanced Analytics
Identify business strategy, develop requirements and align data, technology, process, and people capabilities to build a data enablement/governance program and organization to achieve business strategic goals in an agile delivery model. Provide thought leadership around emerging technologies, including machine learning, optimization, data mining, analytics, quantitative analysis, etc., for all levels of audiences. Design Metadata Management/Data Catalog, Master Data Management, Data Integration, Data Warehousing, Business Intelligence/Advanced Analytics, Data Virtualization, and Big Data architecture using on-premises and cloud platforms. Perform tool and services RFIs, RFPs, evaluation, scoring, and selection. Achieve business transformations included business performance management, complex risk and financial analytics, key performance indicators, quality review systems, sales reporting, health care quality, inventory management, and other disciplines. Create management around metadata and lineage to verify end-to-end consistency. Optimize existing architecture to harmonize current assets, improve operational effectiveness, availability and maximize consumability.
Project and Engagement Management
Manage portfolio of Information Technology projects of varying sizes in strategic solutions with enterprise, data, security and enterprise architecture; data warehouse, business intelligence, analytics, and process management. Use PMI standards and Agile Scrum and hybrid methodologies to deliver business value quickly, manage on-shore and off-shore teams, track and mitigate risks and issues, and drive schedules to deliver projects on time and within budget. Use human skills in resolving issues, facilitating reaching consensus, defining “done” and obtaining acceptance of deliverables. Effective at communicating complex concepts in terms appropriate to the audience.
Roadmap Strategic Solutions
Develop the business case, cost/benefit valuation, hard and soft value proposition, proof of concept, and presentations at all levels of organization through the C-Suite. Define a technology strategy roadmap that enable clients with information-based decision making to identify and prioritize to achieve board level business strategy.
n Gallagher Bassett Services Inc, Rolling Meadows, IL 04/2016 – current
VP, Head of Information Architecture and Management for risk management and commercial lines claims processing company.
Responsible for defining the vision and strategy for the architecture, implementation, and management of all information activities and assets for on-premises and cloud platforms.
§ Create new Information Architecture practice
▫ Develop sustainable enterprise information principles, strategy, and roadmap to align data capabilities to business strategy as defined by board and officers.
▫ Focus on identifying or supporting business opportunities to increase top-line results through improved client satisfaction and revenue-enhanced services, and bottom-line results by putting information architecture that both improves our time-to-market and decreases our costs.
▫ Network with business and technology senior leadership to plan for future data needs and develop roadmaps.
▫ Create information management capabilities for data governance, standards, modeling, model management.
▫ Develop cloud computing and virtualization capabilities with necessary skill migration.
▫ Establish architectural principles to communicate expectations regarding designs and decisions.
▫ Maintain continuous assessment of technology and industry innovations to identify opportunities for GB’s information architecture direction and development.
▫ Optimize the time-to-market, risks, costs, strategic/tactical (and associated technology debt) solutions.
▫ Roll out program using an agile approach.
▫ Build out information architecture team, oversee development teams.
§ Create data-driven culture, promoting the importance of data, security, and privacy, as well as the business value and “self-service” data, using HIPAA requirements and practices.
§ Design modern data architecture strategy for implementing enterprise data hub in consort with API architecture; use AWS EMR with Spark, Redshift Spectrum, and S3, with Attunity Replicate to implement Big Data capabilities:
▫ Data lake on self-service platform for data science teams for Advanced Analytics and Machine Learning
§ Field case management, managed care outcome/vendor analysis, recommendation engine for choosing field case management based on claim factors
§ On-boarding new clients, use Machine Learning to create work plan and prioritize urgent, high impact claims
§ Advanced analytics platform for data science teams
▫ Build Data Hub for application-to-application (A2A) integration creating and using Web Services/APIs between ERP and SaaS vendor platform and trading partners (customers, vendors, third-party providers).
▫ Migrate existing relational data warehouse and business intelligence to data hub
§ Design program for “data enablement,” i.e. data governance, curation and metadata management using data catalog and data modeling tools for creating “citizen data” stewardship, business glossary, data lineage, analytics on data usage, profiling, security and privacy, compliance, and other uses.
§ Establish Advanced Analytics Community with GB and Arthur J Gallagher (AJG, parent company) to share best practices, architecture, and promote and support data science as a competitive weapon and internal improvement.
§ Create an Enterprise Architecture modeling capability and implement tools for infrastructure, data (conceptual, logical, and physical), data movement, business process and requirements, and object models, with end-user portal.
§ Define collaborative metadata management solution for end-to-end view of sources, transformations, target stores, and uses, with lineage diagrams, glossary, end-user portal, business rules, confidentiality, privacy, and security, et al; develop procedures and governance.
§ Build conceptual enterprise data model for business alignment.
§ Identify, evaluate and select Cloud Access Security Broker (CASB) to manage cloud data, align with Information Security team for integrated approach and increased effectiveness of best practices for Data Loss Prevention.
§ Create a Master Data Management strategy and roadmap for policy and party domains; modeled schema and interfaces.
§ Data asset catalog of applications and data in/outbound transfers.
§ Provide architectural oversight for Business Intelligence/Enterprise Data Warehouse.
§ Create a Carrier Technology Partner Program to engage clients’ senior IT leadership with our own in order to better service our carrier practice line of business and, where possible, enable architecture which supports long-term goal for our clients and our own strategic advancement.
n State Farm Bank, Bloomington, IL 03/2015 – 03/2016
Technology Strategy lead consultant for large retail bank.
§ Developed new Technology Strategy Office creating sustainable technology strategy and operational processes to align IT capabilities and capacities to 10-year business strategy defined by bank board and officers.
▫ Created virtuous cycle where business drives technology to improve operational effectiveness and efficiencies of bank resources while innovation and new technologies adoption enables business mission and develops new business opportunities.
▫ Reference Model based on various industry and OCC and FFIEC regulatory, COBIT, ITIL and other resources
▫ Developed Current State Model, lead sessions with line-of-business executives to identify misalignment of business goals with technology capabilities and capacities.
▫ Developed Integrated Capability Model based on Banking Industry Architecture Network (BIAN) Service Landscape and IBM Universal Banking Model.
▫ Created Readiness Assessment framework.
▫ Created roadmap of actionable initiatives to achieve short, medium and long term plans with classification of investment, effort, business impact, alignment to strategic programs, contribution to value stream, etc., in order to maximize investment choices; operationalize roadmap for ongoing change management, impact assessment, etc. Optimize portfolio management.
▫ Aligned line-of-business and horizontal enterprise technology strategies.
▫ Oversaw tactical planning and execution to achieve stop gap requirements while planning and executing strategic initiatives.
▫ Create statements of work for large initiatives.
▫ Presented to Executive Technology Committee (includes CEO, COO, CFO and CIO) on bank technology strategy development plan, build and execution.
§ Designed technology strategy governance to provide transparency, measures (KPIs), strategic oversight and prioritization to assure fact-based decision making, change management, relationship management, regulatory compliance, and maximize return on investment. Developed Balanced Scorecards to manage TSO.
§ Designed Information Platform strategy to integrate all operational and master data on multiple vendor and enterprise platforms to create an analytics platform using integration hub, virtualization, Enterprise Service Bus (ESB), private cloud Big Data technologies. Platform enables operational analytics, cross marketing, fraud detection, etc.
n Underwriters Laboratories, LLC, Northbrook, IL 05/2014 – 02/2015
Enterprise Information Architect consultant for global safety standards and certification company.
§ Developed Enterprise Information Architecture and provide the vision for:
▫ Safety engineers to mine and leverage historical customer product test results stored in various means of unstructured documents in Infosys Big Data Hub to unlock and maximize reuse in customer product and component library and analytics.
▫ Customers to realize new value streams from predictive analytics for product failure, supply chain disruption, early indicator test predictors.
▫ Discover relationships, business logic and rules, data quality and cleansing rules.
§ Collaborated with business transformation team to design architecture platform for engineers to evaluate and certify customer products, manufacturing facilities and process, and supply chains:
▫ Read in industry standards documents from IEC, ISO and proprietary UL standards, stage in Hadoop cluster, then load into an ontology in Neo4j graph database and Jena TDB database for customer product data.
▫ Designed a method to capture engineers’ evaluation processes and work with subject matter experts to develop process maps and standards interpretation maps.
▫ Designed a tiered architecture to use Jena TDB and Fuseki product data and Neo4j standards interpretation to generate and drive user interface navigation to use engineers’ answers to questions from the standards interpretation to traverse to test results and compare to standards thresholds. Each answer drives the process along the logic path to reach an outcome.
▫ In accomplishing this goal, the company succeeds in improving turnaround, customer collaboration and satisfaction while increasing employee.
▫ Defined data API requirements and JSON structures.
▫ Profiled source data, define cleansing rules and metadata information.
▫ Lead off-shore development team for construction of service oriented architecture solution.
§ Developed strategy for Big Data Hub and Oracle Master Data Management using reference architectures, models, patterns and industry best practices.
§ Develop conceptual and logical models, ontology and taxonomy for product management in Big Data Hub and MDM. Created a data dictionary/business glossary to standardize terminology.
§ Defined architectural principles to define differentiation of usage for Big Data, Data Warehouse and Data Marts.
§ Identified information capability gaps, define and align Information Architecture with other Enterprise Architecture disciplines, i.e. Integration Architecture, Application Architecture and Technical Architecture, and the management and governance.
§ Developed Roadmap to achieve architecture goals.
§ Prepared and presented communications briefings for executives and stakeholders.
n JLL (formerly Jones Lang LaSalle), Lombard, IL 06/2012-05/2014
Enterprise Information Architect consultant for multinational commercial real estate and property management services provider.
§ Developed information strategy and vision for aligning corporate business strategy for global enterprise with strategic and line-of-business applications, master data management (MDM), data integration, data virtualization, metadata management, data quality and profiling, data modeling and data governance. Working closely with CIO, define IT strategy, gap analysis, roadmap, business case development and investment decisions and support frequent mergers and acquisition.
§ For business-side Data Governance Organization
▫ Create taxonomy around property, organize and develop processes to collect business metadata from business units, industry and public sources and to create business glossary.
▫ Create Informatica Metadata Manager/Business Glossary, standardize and map business terms, metrics, related terms, synonyms, data quality rules, constituencies and data stewards/owners in metadata repository with end-to-end lineage diagrams.
▫ Profile source systems for validity of data and write cleansing and transformation rules for MDM system and various data warehouses and marts.
§ Created enterprise conceptual data model and line-of-business logical models. Vet business and technical requirements with business and technical stakeholders. Reverse engineer application databases. Manage tool implementation of ERwin and Mart Server and rolled out to all regions. Develop modeling expertise and mentor modelers.
§ Designed model and implement Master Data Management hub for property, client, service domains. Perform data profiling to expose relationships, data quality, misused/repurposed/mistyped columns, etc. Create source to target mappings and specifications for ETL development, web services to synchronize participating partner applications as well as data marts and data warehouse.
§ Designed architecture for MDM and Data Integration hub synchronizing major line-of-business and enterprise applications enabling and optimizing Customer Relationship Management (CRM), Property and Markets with multiple global mission critical applications.
§ Defined business and technical requirements, design Proof of Concept for evaluating vendor products, evaluation criteria and scoring and select data integration and information management tool-set.
§ Designed and built Kimball style, fact/dimensional star-schema near-real-time data warehouse model based on specifications from operational source system owners, master data (CRM/client, property, market) and Cognos developers. Create source to target mappings and specifications for ETL development. Use Change-Data-Capture and Data Integration Hub to keep up operational data stores and marts. Support Cognos Business Intelligence development for global, regional and client-level reporting.
§ Use Informatica Velocity methodology to identify and implement best practices for data integration architecture. Create naming and usage standards for data practices.
§ Used TOGAF process to guide data architecture deliverables.
§ Formed business-side Data Governance Organization, organize and develop processes to collect business metadata from business units, industry and public sources to create business glossary on Informatica Metadata Manager/Business Glossary. Led teams to map business terms, metrics, related terms, synonyms, data quality rules, constituencies and data stewards/owners in metadata repository with end-to-end lineage diagrams. Develop workflow for business term definitions. Developed organization design for Data Governance team.
n BP (British Petroleum) US Pipeline and Logistics, Naperville, IL 10/2011-06/2012
Data Architect consultant for division of multinational oil and gas energy producer.
§ Created transformational Enterprise Data Management program, staffed with a council of senior executives and operational team members.
§ Used IBM Data Governance Maturity Model to establish baseline and measure against goals, create a culture of data management and good stewardship; use DAMA DMBOK as reference for best practices.
§ Developed an Enterprise Data Strategy working with company leadership.
§ Created metadata management program with business and technical definitions, data lineage, life cycle, identify authoritative (golden) source, owner, etc., using Scrum Agile techniques. Design taxonomy for pipeline domain.
§ Implemented Informatica Business Glossary for metadata using ontology based on business requirements.
§ Established data quality program, profiling metrics, trend monitoring and defect tracking/management; create data security program granting user access and role-based model to provide proper access with respect to privacy and regulatory requirements. Use Informatica Data Quality and Informatica Data Explorer tool to automate data profiling and validation.
§ Defined and prioritize business needs and requirements for Enterprise Data Warehouse for pipeline and terminal assets, safety and operations and maintenance.
§ Established sustainable data architecture current state, future state and roadmap to define and prioritize key projects for solution realization and results.
§ Created data warehouse governance for financial, operational and derived data elements.
§ Used industry standard PODS (Pipeline Open Data Standards) and application enabling use of geospatial data.
§ Created single source, conformed semantic data model based on business intelligence and analytics needs using Embarcadero ER/Studio.
n Bank of the West, San Francisco, CA 02/2011-10/2011
Information Architect and Manager of Data Management consultant for a regional bank and financial services provider.
· Worked with line of business executives to define business strategies and objectives to enable development of a data strategy to enable regulatory and operational management and analytics requirements.
· Created and implemented an Enterprise Data Governance program, staff it with a council of senior executives and operational team.
· Used the IBM Data Governance Maturity Model to establish baseline and measure against goals, create a culture of data management and good stewardship.
· Defined Enterprise Data Strategy.
· Created gap analysis for Basel II compliance for required data and data management functions.
· Created metadata management capabilities business and technical definition, data lineage, identify authoritative (golden) source, owner, etc., using Scrum Agile techniques.
· Implemented Informatica Business Glossary for metadata.
· Established data quality program, profiling metrics, trend monitoring and defect tracking/management. Create data security program granting user access and role-based model to provide proper access with respect to privacy and Graham Leach Bliley Act (GLBA) regulations. Created process, procedure and staff program including management metrics.
· Profiled source system data for consumability in Enterprise Data Warehouse (EDW)
· Defined and prioritized business needs and requirements for EDW for credit risk and Basel II RWA.
· Used COBIT compliance framework for auditability, security, risk management and Governance, Risk and Compliance (GRC).
· Developed Master Data Management approach using a federated model, create proof-of-concept.
· Lead business and EDW team to put data governance around financial, operational and derived data elements.
· Created conformed semantic data model based on risk architecture and business intelligence and analytics needs based on Teradata Financial Services Logical Data Model (FSLDM) using ERwin.
· Consulted with Operational Risk Management on Governance, Risk and Compliance (GRC) tool and data warehouse integration.
· Consulted on dual grading (LGD and PD) and RAROC tool as foundations for IRB-A.
· Environment consists of Teradata platform with Informatica tools for data integration.
n Maven Wave Partners LLC, Chicago, IL Principal Consultant 08/2010-12/2010
§ Data Strategy for Nike, a leading consumer-products company. Co-lead in a business-driven strategic blueprint for technology-based services that provide deep insights to consumer preference and behaviors based on inferences, affinities and correlations. Based on business and marketing strategy, create conceptual architecture and roadmap for implementation using service oriented architecture with required integration architecture, operational data store, data warehouse and business intelligence/analytics environment. New architecture added change-data-capture on Enterprise Service Bus (ESB) for complex event driven processing for data services and acquisition and to synchronize data across multiple systems to achieve near real-time for both web operational use and analytics while coordinating with the Master Data Management platform.
§ Data Management Lead for CIT Bank, a commercial banking institution. Performed end-to-end assessment of the enterprise and business units' operational and reporting applications and data architecture. Involved deep dive into source and use of reporting data, data stores and management to develop a current state architecture which included an inventory of data stores and each point of data movement and their mappings on Oracle and Business Objects. Determine business and regulatory (FDIC and FRB) requirements to develop requirements and future state architecture to benefits and rationalization and alignment of technology platforms to the business drivers and relationship to expected benefits.
Created a Data Governance program with an executive council governing people, processes and tools to manage Metadata Management, Data Quality and Master Data Management. Enterprise data governance program assures data would be managed in a way that assured accuracy, timeliness and integrity. Created integration architecture, data warehouse and business intelligence strategy, architecture, tools and methods. Develop data governance using DAMA Data Management Book of Knowledge (DAMA-DMBOK).
n American Access Casualty Company, Oakbrook Terrace, IL 02/2010-07/2010
Enterprise Architect Consultant to assist the Chief Information Officer to develop strategic capabilities within the IT department, advance the maturity of the department to provide scalability in systems, improve software development methods to insure best practices in application and data architecture for future capabilities and growth. Architect new application server platform with failover and load-balancing as well as improve network and application security. Develop new application architecture using Service Oriented Architecture (SOA) via web services using Scrum Agile techniques. Develop new data model for application rationalizing to third normal form and master data management (MDM) architecture. Data development on Microsoft SQL Server. Build credit card payment public interface for web application for premium payments. Create new architecture for data warehouse for operational reporting in a dimensional model using PowerDesigner to create the data model. Use Universal Data Model (UDM) insurance industry reference model. A SaaS data warehouse and business intelligence solution is used for analytics.
n STA Group, Chicago, IL STA Group Leadership Team 11/2007 – 02/2010
§ Developed Business Architecture strategy, service offerings and product management for:
ú Enterprise business architecture development
ú Portfolio management and roadmap development
ú Business process modeling and management
ú Requirements definition and assessment
ú Business rules definition
§ Developed consulting strategy including:
ú Business and IT road mapping
ú Integration capability assessments and architecture
ú Data Warehouse design and development capabilities
ú Business Intelligence and analytics platform assessments and development
ú Agile method implementation, coaching and leadership
§ Enterprise Architecture
ú Assess and/or design current state and future state architectural assessments
ú Develop roadmaps to move from current state to desired future state
ú Business Intelligence/Data Warehouse architecture and enablement
ú Enterprise architect mentoring
ú Service Oriented Architecture (SOA), Enterprise Service Bus (ESB)
ú Data architecture
ú Create agile techniques for data architecture
§ STA Group recruiting screening and evaluation
Aetna Insurance, Hartford, CT, Enterprise Information Architect
As part of the Enterprise Architecture team, the enterprise information architect (EIA) is responsible for defining IT strategy and architecture in terms of the enterprise capabilities in full lifecycle of use of data, assessing the current state, developing a future state architecture. Identify and design data governance programs for lines of business
§ Created blueprints for Quote and Rating, Claims and auto-adjudication/auto-pay domains application refreshes.
§ Used MEGA enterprise architecture modeling tool to capture data architecture and relate to systems.
§ Used IBM InfoSphere Data Architect (IDA), ClearCase and ERwin to create conceptual and logical models.
§ Performed semantic, conceptual, logical modeling.
§ Used reference architectures such as Universal Data Model (UDM, Silverston), insurance industry reference model.
§ Designed new enterprise data architecture using mastered domains and Service Oriented Architecture (SOA) access, replacing individual applications databases with reducing/eliminating redundant, non-synchronized data.
§ Developed data model for informatics program.
State Farm Insurance, Bloomington, IL Data Architecture Team Lead
§ Enabled enterprise Data Model management for entity-relational diagrams for transactional systems as well and star schema models for data warehouses using Embarcadero ER/Studio
ú Define logical model standards
ú Define physical model standards
ú Define data warehouse model standards using Kimball and hybrid star schema approach
§ Delivered course to select Data Warehouse team members, Agile for Data Professionals to improve, evangelize Agile to data teams.
§ Member of Data Sector Technical Architecture Governance working committee determining policy and process of data architecture and governance.
§ Partnered with Information Quality, create data quality maturity model, self-assessment diagnostic and road map to improve maturity level area-by-area.
§ Enablement and governance of Business Intelligence Reference Architecture (BIRA).
§ Developed data governance policy using DAMA’s Data Management Book of Knowledge (DAMA-DMBOK).
§ Assessed data migration project for company’s largest IT initiative:
ú Data migration platform architecture
ú Data integrity assurance plan
ú Data movement approach
ú Data quality and cleansing approach
ú Verification and validation
ú Developed continuous migration plan that significantly reduces risk and assures timely, accurate conversion
n Informatica Corporation, Chicago, IL 02/2007-11/2007
Integration Architect in the Financial Services and Insurance Practice for the leading data integration software company providing platform solutions for data warehousing, data migration, data consolidation, data quality and governance, master data management, metadata management
§ Identified business and technical direction and requirements from strategic and operational management and knowledge workers.
§ Developed proof-of-concept business and technical solutions and present findings using Informatica tools.
§ Analyzed needs for Change-Data Capture in Real Time or batch application integration.
§ Provided “best practice” business process management advisement for data integration
§ Identified Integration Competency Centers (Center of Excellence) with the appropriate business model.
n ABN AMRO/Bank of America, Chicago, IL 11/2005-02/2007
Data Warehouse/Business Intelligence Architect consultant for a large, multinational bank and financial services provider. Conduct strategic and tactical system planning, including roadmaps and design to assigned business areas’ applications:
§ Finance and Risk Data Warehouse, provide overall architecture for data warehouse:
ú FRW is the repository for all bank data where finance or risk is associated; includes more than 30 source systems, definitive (“golden”) source of data for Basel II risk assessment for capital reserve reporting regulatory compliance
ú Risk Weighted Asset calculation
ú Created architecture for full software development life cycle including development, system test, integration test, pre-production and production
ú Created Master Data Management strategy
ú Conformed Data Layer Information Delivery Platform on star schema
ú Used IBM IFW Financial Services Data Model (FSDM) as a reference model
ú Determined functional and technical requirements for test cases and test plans
ú Coordinated activities with Testing Center of Excellence (TCOE) for integration testing
ú Consulted to Business Intelligence/Data Warehouse for metadata management, Master Data Management (MDM), data integration and data movement architecture
ú Data Quality Reporting for incident report creation, triage, resolution and workflows. Solution uses numerous data introspection queries and reports using Mercury TestDirector
ú Metadata Repository
Provided Data Governance solution to an integrated, comprehensive metadata repository, providing definitions, business rules, defaulting rules, data lineage, etc.
§ Customer Data Integration (CDI) project
▫ Identified and developed project proposal and architecture with enterprise view of customer using Master Data Management (MDM)
▫ Created roadmap from current state of “silo” applications to Customer Relationship Management (CRM) for providing valuation/profitability model for customers, cross-selling and marketing related products
Responsibilities and roles of Solutions Architect:
▫ Used The Open Group Architecture Foundation (TOGAF) framework for Enterprise Architecture process.
▫ Consulted to senior management to understand strategic plans of business and subsequently develop road maps and identify critical success factors
▫ Provided strategic technology planning and acceptance within business and Information Technology to support business
▫ Reviewed logical and physical data models created by data modelers
▫ Created dimensional data models with ERwin
▫ Assessed data requirements and business rules
▫ Created project implementation (logical/physical) data model to meet business requirements.
▫ Presented to senior business managers and executives current-state, future-state architectures and roadmaps to achieve alignment with Enterprise Strategy and Architecture
▫ Worked with vendors, service and product, to achieve above objectives
n Destiny Health Insurance, Oak Brook, IL 11/2004-11/2005
For multinational health/medical insurance, Manager of the Project Office consultant for all information technology activities.
§ Managed Project Office for local teams in Chicago and off-shore teams in South Africa.
§ Owner, developer and administrator of Capability Maturity Model Integration (CMMI) process and Software Development Lifecycle (SDLC) methodologies.
§ Introduced Agile Scrum in order to deliver business value solutions faster and improve quality
§ Worked with “C” level executives and line business managers, IT representative to committees for (Strategic) Business Process Team (BPT), US Operations Business Implementation Team (USBIT) and Infrastructure Technology Business Implementation Team (ITBIT).
§ Owner of master schedule and people allocation across all teams supporting each of the business areas.
§ Managed project close-out process evaluating budget and calendar estimates to actual utilization.
n State of Wisconsin/Accenture, Madison, WI 03/2003-11/2004
For State of Wisconsin Department of Workforce Development (employer tax, wage and unemployment insurance agency), Data Architect consultant for unemployment insurance project.
§ Used Agile method to model data requirements
§ Interviewed users and developers and gather requirements and write specifications
§ Use ERwin/ModelMart repository to model databases, the largest with approximately 650 tables, 6,500 columns and partitioning
ú Developed logical model for business analysts and design sessions
ú Transformed logical model to physical model and detail out implementation requirements
§ Performed object/relational mapping from Rational Rose UML models to ERwin entity relationship diagrams (ERDs)
§ Developed stored procedures, triggers and other database object on Oracle 9i relational database
§ Created and maintained database definition language (DDL) in PL/SQL for implementing and schema migration using Model Driven Development (MDD)
§ Used Rational ClearQuest to track change requests
§ Created and maintained data dictionary (metadata) of database objects and their use and meaning
§ Monitored and tuned complex SQL queries and stored procedures
§ Published subject area models, logical and physical, as artifacts for developers
§ Used Rational Rose to develop UML diagrams modeling business processes
n American Family Insurance Company, Madison, WI 11/2002-02/2003
For major health/medical insurance, DB2 Data Architect consultant for Health Insurance Portability and Accountability Act (HIPAA) health insurance workflow project.
§ Migrated application from Wang VS computer to WebSphere application server and DB2
§ Analysis, design, specifications of health claims workflow application.
§ Used PowerDesigner to model database for workflow schema and integration points.
§ Built schema to support workflow management.
§ Developed data object standards document for project, standards reviews.
§ Used Rational Rose to develop UML use cases, sequence diagrams and class diagrams.
n Wisconsin Physician Services (WPS) Insurance Company, Madison, WI 03/2002-10/2002
Project Manager and Architect for a leading health insurance provider and claims and payer processing service center for platform in a highly regulated environment under authority of the TRICARE Management Activity (TMA). Used Agile Scrum method to manage a team of 50 to quickly deliver new public web site on fixed delivery date. Coordinated client, infrastructure, graphics, Java and COBOL/CICS development and Quality Assurance teams and negotiate release management with all parties.
n Allstate Insurance Company, Northbrook, IL 01/2001-06/2001
Solutions Architect consultant for a leading property and casualty insurance commercial and personal lines company for enterprise application portal:
§ Architect for broker portal, project later became enterprise portal
§ Gathered and defined business and technical requirements for 13 business units.
§ Developed the technical logical and physical architecture models.
§ Technical representative in RFP core team as portal subject matter expert (SME) to define vendor list and create the technical requirements.
n Integrated Trade Systems, Inc., Lombard, IL 04/1993-12/1999
Product Manager for development and delivery of business-to-business international logistics supply chain management system. Application included mini-mart online analytics processing (OLAP) for marketing, operations and logistics support and Customer Relationship Management (CRM) Rebuilt original client server application on a Software-as-a-Service (SaaS) platform. Software is communications enabled, producing output directly to electronic mail, facsimile, and EDI server using the Internet. Total project responsibility for product definition, architecture, development, marketing and roll out. Redesigned product for web-based business model. Responsibilities for design and develop Internet based software part of a logistics portal.
§ Analytics Leader Network, member since 2017.
§ Basel II Compliance Professionals Association, member since 2011.
§ Scrum Alliance, member since 2010.
§ Data Management International, member since 2011
§ The Data Warehouse Institute (TDWI), member since 2008.
§ Chicago Agile Project Management Group, member since 2009.
§ The Open Group Architecture Foundation, member since 2007.
§ Data Science Certificate, (nine courses including Exploratory Data Analysis, Data Acquisition and Cleansing, Inferencing, et al) Johns-Hopkins University, expected completion, March, 2018.
§ Big Data Certificate, University of California, San Diego, expected completion, December, 2017.
§ AWS Solutions Architect training, toward Big Data Specialists, 2017.
§ TOGAF Enterprise Architect Certification, The Open Group Architecture Foundation, 2007.
§ Postgraduate studies in Database Management, Networks and Communications and Human-Computer Interaction at Nova University (Ft. Lauderdale, FL), 1993-1994.
§ Postgraduate studies in human computer interaction (human factors) and instructor in computer programming at DePaul University (Chicago, IL), 1991-1994.
§ Master in Business Administration from Florida International University (Miami, FL) with special emphasis in Management Information Systems, 1989.
§ Bachelor in Business Administration from Florida International University (Miami, FL), with major in Management Information Systems. Additional qualification in Finance and minor in Computer Sciences, 1984.