John Marsh

610-***-**** adzehy@r.postjobfree.com

PROFESSIONAL SUMMARY

Skilled technology professional with over 18 years of overall IT experience developing solutions in Big Data, Hadoop, Data Lake, ERP, OLTP, OLAP systems, Master Data Management (MDM), metadata management, data service delivery, COTS implementation and legacy system retirement. Provided solutioning for wide enterprise integrations via Kafka. Experience with large and complex integrations in multiple business domains: big banking, retail, P&C insurance, health insurance, mortgage, credit card and government.

Experience include; Enterprise Data Architecture, transactional systems, Data Warehousing, Physical and logical database design, data modeling, reverse database engineering, business solutions development, Business process engineering, data sourcing, data mapping, task coordination, system integration planning, data cleans, data migration, data integration, data conversion and work on real-time event processing systems.

Created and defined enterprise standards and rules for defining data within the organization. This includes data models, Data flow diagrams, System Integration documents and metadata repositories.

Creating data models, concept models, logical models and physical models. Lead requirement sessions with businesses leaders, business analyst and other stakeholders.

Functioned in several roles solution architect including hands-on developer, data modeler, business analyst and requirements analyst, project team lead and project team member. Several years in a forward client facing and client interactive roles. Tactful experience in working with clients and senior stockholders in comprehending the business challenge, developing, presenting and reviewing business solution options.

Work Experience in Big Banking, commercial, Credit card and investment. Exposure to industry standardized financial data models from IBM, Oracle and Teradata FSLDM supporting Banking, Finance.

Work experience in Insurance (Healthcare and ‘Property and Casualty’ P/C), Guidewire (PolicyCenter, BillingCenter and ClaimsCenter), ADRM and ACCORD, Property and Casualty (P&C).

Developed and built an initial data concept (while at NJM) which later, was presented as a Guidewire implementation case study prior to the productization and roll out of the Guidewire data hub product.

EDUCATION:

Bachelor of Science - Accounting/Computer Science – Millersville University (PA)

SAP – FICO, SAP – BASIS, MM

Dale Carnegie Graduate.

Many Information Technology related training courses

EXPERIENCE:

LTI,Inc 07/2022 - 11/2022

Worked on a project under risk management

Worked on data data uploads and downloads from multiple business subject areas. Reviewed data formats to support data integration and export. Managed data models in ER Erwin. Exported data definitions and profiles in excel and3 CSV’s. Created ER Diagrams for publication. Reviewed data artifacts with data contributors, data consumers and other business and technical staff. Preformed QA for data change control. Updated data dictionaries.

CTS, Inc. November 2019 - December 2021

Project 4 Hospitality (Hotel/Resort)

Part of a senior Solution and Data architecture team to analyze and develop to develop future state following merger and acquisition. Analyze to discover data, data flows, data CRUD, business rules and persistence points within legacy systems and data stores. Created data models, conceptual, logical and physical.

Interface with business and other technology leads to define processing details of current and future state. Analyzed business process methodology and and artifacts to use process business and data flows . Worked with team to develop UML artifacts; Use Case, Sequence diagrams and Information models (BIM, Data Models and ERD’s)

Tools: Visual Studio, PlantUML, SQL Server, Erwin, UML

Project 2 Large Pharmaceutical Manufacturer

Lead an effort to design a data migration plan to move data from a outsourced cloud application and data store to an in-house local canonicalized ODS. Data access and movement was via Kafka and Kafka events. Created conceptual, logIcal data models with ERD’s to create a common data hub to consume and standardize OLTP data from multiple data sources internal and external. Created a canonical data framework and supporting data models. Created a presentation layer for downstream BI and sub processing support. Worked with all levels a of management. Created multiple presentation documents.

Created object data models to support data movement corresponding to the data hub canonical data model. Created kafka event data objects. Created data migration routines in VBA to migrate conforming data from MS Access to Oracle for inclusion in Kafka data movement and events.

Created documentation to support project for senior management, business managers, SME’s and developers.

Defined data items to include in documents posted to a mongo data base.

Tools: Kafka, ERwin, SQL SRVR8, MS Access, VBA, Jira, Visio, XML, XSD, Kafka event object,

Data Architect / Senior Data Modeler

Project 1 Capital Banking:

Performed a role as a senior Data Architect on a team of architects and data modelers. Worked on a large enterprise project to create a Data lake of multiple data sources. Worked with project owners, business owners, business analyst and developers to review and refine business requirements, create gaps analysis and created data models to move raw data from source SOR into Hadoop Hive conformed layer. Data was structured as denormalized and flat. Created and negotiated complex data structural solutions. Created data flow diagrams, data structures, transformations, mapping and load processing sequence and conditions. Created data standards and implemented best practices. Worked with other data modelers to develop a consistent approach to data modeling. Worked to define team processing from conceptual to logical to end with physical models. Created and delivered to developing teams a set of data artifacts which included ERD’s, mapping, data dictionary, DDL, other presentations and support. Lead data discussions, meeting sessions in and out of scrum sessions. Supported development teams on-shore and off-shore. Worked in agile methodology with JIRA as the management tool.

Tools: Hadoop, Power Designer, Teradata, Oracle, SQL Server, SQL, Jira,

Accenture June 2018 - Jan 2019

Data Architect / Data Modeler

Functioned as a data architect and lead data modeler for a large international fortune 50 corporation. My project is an MDM (Master Data Management) project to integrate customer, client, vendor and sales workforce data from multiple international company owned global and regionalize source data systems. The objective is to have one consolidated data repository providing a single source of true. This new data repository spans and provides data service to the entire enterprise.

In this role, I participated with the business principles and leads in requirements gathering and requirements review. I analyzed the current environments and proposed the best path forward. Identified source mapping. Worked with source teams on inbound data formats and language conversions and data definitions.

Created Postgres data model to support OLTP data integration into the Raw layer from multiple international data sources. Provided standardization around Customer (with Language) and locations, employees, Hierarchy and other master data subjects. Created logical and physical data models. Functioned as senior data modeler. Developer data modeling standards. Provided technical and logic support to junior modelers and business analyst. Created mapping of raw data into Hadoop. I created all DDL for tables and other database objects. Worked with project team on loading and migration plan from current/legacy MDM database to Postgres DB to run on AWS.

Managed metadata providing data types, definitions and data dictionary along with other data artifacts. Provided data flows, source to target mapping and data sequencing. I worked on and confirmed the initial data transformations. created a consolidated enterprise reference data domaine and created data model for reference tables. profiled source data and worked with business principles on acceptable reference values, transformation mappings and exception processing rules. Created transformation document, mapping document and ERD’s for ETL team and business review.

Tools: Oracle Postgres DB and Postgres SQL, CA Erwin and and Model Mart.

Veterans Sourcing Group June 2017 - March 2018

Data Architect

As an architect, I was charged to build out and implement technical and business solutions. These solutions wear in line with the strategic plan or drove out gaps or other opportunities. Worked closely with technical leads, business and product owners. Facilitates many meetings of various topics and issues. Provided guidance and produced architectural artifacts to align cross-functional and cross-LOB projects to Target State Architecture. Provided inter-project coordination on solutioning and data Provided a steady guidance to the Target State.

Worked with senior business stakeholders to build out the data environment to align with information strategy. Provided guidance as new data environment included an expanding role for big data (Hadoop, Cassandra, Oracle Exadata)

Created Conceptual Architectures, conceptual and logical data modeled. Lead compliance efforts for metadata.worked closely with junior data modeler and business analysts.

Provided support in upgrading legacy telephony infrastructures.

Worked on a team of architects to implement and event streaming architecture. Implementing a real-time architecture (Kafka). Incorporating and integrating data support for in-house developed, vendor solution platforms and micro services providing backend infrastructural support for a real-time event based model. The communications infrastructural backbone was enterprise wide. The project fully integrated voice, enterprise data, service data and multiple telephony services (component and micro service) within a real-time infrastructure.

Responsible for coaching and mentoring less experienced team members.

Provided guidance and support in application integration, data, and infrastructure architecture disciplines. Worked on architecture and designs which cross all systems of the LOB.

Develop and employ best practices in delivering architectural guidance and working within an agile development methodology.

Roles and Responsibilities:

Understand and promote Information Strategy.

Contributing and enforcing data governance across the organization.

Ensure metadata is captures and documented.

Work to incorporate high quality reference data into solutions.

Engaging peers across IT, Business, PMO, Data Management to ensure consistency and open communications.

Establishing data roadmaps / blueprints required to guide key aspects of data management for major functions.

Develop and document Information Architecture for modeling Big Data.

Participate and review proposed data model changes for adherence to data strategy and standards.

Skills used:

Data modeling (Conceptual, Logical, Physical)

Data integration, SOA, MDM, Metadata, Reporting and BI data layer development

Excellent planning, interpersonal, influencing, and problem solving skills.

Ability to drive out data requirements from the business with Business Analyst and developers. Ensure proper data model design and provide information architecture governance.

Event modeling to support Kafka, micro services implementations and real-time event processing

Review data models of junior data modeler.

Data modeling for big data technologies.

Ability to quickly assess situations to develop a roadmap from concept to execution accounting for both business, requirements and IT impacts.

Tools:

Erwin, SQL, Hadoop, Oracle Exadata, Cassandra, Kafka, event modeling, relational databases, NoSQL databases, SQL; JSON and XML

PBI November 2016 - April 2017

Healthcare Data Architect

Responsibility for architecture and design, of client healthcare data for integration and implementation into PBI’s custom Bi solution. Determines business information needs and identifies system requirements. Works with IT and business customers to develop requirements for designing the database model and architecture. Developed integration plan, scripts and testing. Created database models and ERD artifacts to support the solution migration and implementation plan. Built database objects and DDL scripts for testing and deployment to production. Worked on standardizations and delivery of models and processes. Build and maintain client data models. Provides support guidance to ensure architecture and framework are aligned with BI application needs.

Principal Solutions Group October 2015 - June 2016

Charlotte, NC

Data Architect

Contract consultant functioning as a Lead Data Architect initially charged to assess the data modeling team and increase their outreach, productivity and efficiency. Developed plans to implement and worked with senior management to transform the Data Modeling team into a higher functioning Data Architectural group to function at a more impacting enterprise level.

I redesigned the teams business process, renegotiated the groups interdepartmental handshakes, artifacts and deliverables. Set in place in enterprise level publications to increase the team exposure and transfer of information for standardized and open consumption. Produced library of updates production data models.

Developed and implemented a project plan to upgrade CA Erwin data modeling software tool from r7.3 to r9.6 (32 and 64 bit) for workgroups and Model Mart 9.6, with mid tier web server and software. Developed a plan and process to mass convert a large number of data models with thousands of entities, tables and attributes created in Erwin r7.3 to the new format of Erwin r9.6. Developed the process and program code to recreate the full library of production models by creating the PROD model via scripted code in VBA and the direct CA Erwin API access coding. This VBA application and code created converted data models from production DB metadata and recovered entity and attribute metadata definitions from non-production, non-current data models. VBA application manipulated the CA Erwin API interface. I developed all code and test plans.

Introduced common and best business practices to spur team productivity, responsiveness and work quality. Introduced a change control process with new team standardizations to maintain concurrent production data models.

Worked with infrastructure team to setup CA Erwin Model Mart 9.6 and Web server. Trained staff in use of Erwin Model Mart 9.6. And Introduced best practices.

Production DBMS: Oracle, Teradata, MS SQL Server, Sybase, DB2 and LUW

TOOLs: DDL SQL, DML SQL, CA Erwin 7.3, CA Erwin 9.6 (32bit and 64bit), large number of data models, Model Mart 9.6, VBA Erwin API, ADO / COM Object oriented development, VISIO

NJM Insurance March 2014 - August 2015

Property and Casualty (P&C)

Guidewire Data Architect

Joined this client as a Data Architect to help Data managers and the organization to implement a new level of data management support by migrating to an Enterprise Data Architecture built atop a multi module Guidewire ERP implementation.

I created extensive data modeling of OLTP data form the Guidewire modules; PolicyCenter, BillingCenter, ClaimsCenter, Contacts and Accounts. Created data models for fun Guidewire environment. developed integration of internal and external data feeds. Developed data structures and extensions for realtime, near-real time processing and batch processes to support business processes, required reporting, risk analysis, underwriting and external partnership.

Worked on multiple and simultaneous projects and program initiatives. Participated closely with Data Administration management, PMO and other business management leaders to build and maintain business relationships across the company with business units, technical, financial, reporting, and operational business units. As well as provide direct support to PMO as transactional processing migrated from Mainframe legacy to client server with normalized data and agile service delivery, build outs, support and data consistency across the enterprise.

Participated in developing and delivering new business solutions in an extremely fast developing and turning environment. Key participant in assisting Data administration management with reaching out to major key business units previously supported in a legacy centered environment. Established and maintained direct relationships through all levels of management.

Worked on a MDM framework and approach to integrate source contributions from multiple data sources applying our maturing MDM concepts. The MDM concept developed consolidated data from the transactional processing system, legacy mainframe system and multiple outside contributing systems from other business partners and data vendors. Created a BI data access layer to implement MDM and governance business rules on data extraction and consumption.

Provided architectural support and guidance in a multiple lines of business. Provided direct data support to key business units: Actuarial, Statistic, Pricing, underwriting, Marketing and PMO initiatives. Supported financial analyst, bUsiness analyst, ETL developers and report developers. Created the BI presentation layer following the initial roll out of the new enterprise business transactional application. Then developed the code and data objects for enterprise BI data consumption. Designed conceptual, logical and physical ERD diagrams to support data consumption and providing data consistency.

This was key to providing Decision Support Data to executive management and operational management. Functioned as the data expert for; Policy Administration, New Business Submissions, Policy Change, Renewals, Cancelations, Reinstatements, Enforced Policies and status at any point in time, Claims and Policy Events and Activities

Develop close interactive relationship with other peer IT technical units such as infrastructure, Database Administration, UI development and ETL.

Projects:

Participated in the mainframe legacy retirement initiative. Developed a data transition and mapping plan from legacy to the new RDBMS MS SQL Server to support BI access, reporting and the SAS environment. Performed direct hands on data discovery of legacy data items and mapped them to the new SQL Server database data elements. Developed the Data flow and data presentation schema for the new Business Intelligence capability. Developed data objects to build a BI presentation layer. Developed an ODS environment with support services while providing amble time to define and develop a new Enterprise Data warehouse (EDW) environment. Work closely with major business units, Underwriting, Actuarial, Statistics and Customer Servicing. Directly provided development and coding support to build a presentation layer between the business and a very large, complex and heavily modified and enhanced transactional data environment. This involved heavy, complex and difficult SQL development. Built many complex and impounded view objects. These views also trapped and vetted the most complex and complicated SQL joins. After, I provided direct Production support. I was a trusted senior resource with full data access to all enterprise data.

Documentation, discovery, analysis and data modeling for all major transactional data stores and other utility services such as persistence for transient data to and from our third party strategic partners providing digital integration support. Developed and created a large data store or the persistence of large amounts of transient second and third party data from any strategic data vender.

Reviewed ADRM and ACCORD industry data models to assist in the creation of an open DB framework to support data export and consumption from multiple vendors and external data providers. This was normalized, open database structure for flexible and agile data consumption. Several vendors and products exchanged data via XML. I am fully versed in reading and processing XML data and XSD files with enumerations. Created physical data models and databases to persist XML data exchanged. Created full database including logical and physical data models and DDL SQL. Created schematic and other DB objects. Lead multiple JAD sessions with ETL team in this project.

Created a repository of enterprise data models to cover all major production databases with CA ERWIN v9. Converted existing models to CA ERwin 9 from CA ERwin 7.x. Maintained enterprise production data models. Created numerous artifacts including ERD diagrams, data flow, data environment, other project planning and presentation material for team and management.

Developed data presentation layer for data access and data security. Created data objects to support Business Intelligence (BI) and provide constant data access and data reporting for enterprise data consumers.

Identified and maintained Subject area data concepts. Provided ERD's to ETL developers, report services developers, actuarial, statistics groups and BI user groups for SAS, Qlikview and Excel. Produced and published enterprise data presentation materials, data models, ERD's and

Tools used: MS SQL Server, CA Erwin, Informatica, XML/XSD, SQL-DDL, SQL-DML, Visio, XML Spy, SAS, Qlikview, Guidewire (PolicyCenter, BillingCenter and ClaimsCenter)

Argus Solutions. May 2013 - November 2013

Lead Data Architect for large enterprise providing Healthcare and Benefits administration. Primary project to reduce current claims backlog and build new business solutions and tools to assist the processing effectiveness of the nationwide workforce, improving the public image and reduce political pressures. As a lead Enterprise Data Architect, I function as a part of senior project management. I developed technical and detailed data plans to provide a technical solution for the business initiative.

Developed and presented a functional Master Data Management (MDM) plans and design. This was to efficiently tie Primary Insures individuals or beneficiaries to services and benefits entitled under a claim and track multiple instances of same person to multiple claims. Built and implemented core physical database table, other database objects, ETL load processing and sequencing. Prepared many presentations and materials to the client’s executive, senior business and technical management staff.

Partnered in the leadership of development teams (DBAs, ETL developers, UI developers and other junior Architects) in building and implementing the solution. I provided direct technical, hands on support and responsibilities for data deliverables.

I develop and maintain direct client interactions for developing concept solutions, identifying high level expectations and requirements. Conducted meetings to drive out and record requirements. Worked on documenting business processes and establishing working relationships with SME's and other business contacts.

Lead the data architecture and design efforts including data modeling effort. Developed architectural concepts that were new to the client and the environment. I presented the related business advantages and rationale to pursue a design and development approach I may have recommend or came from my team.

Presented and built database models and DB objects to develop a new User UI toolset to better manage, assign and report on the very large backlog of request to be progressed in the workflow, adjudicated, artifacts collected, correspondence tracked and processing to completed.

Technically, created data models, conceptual, logical and physical. Established a change control process to maintain data models thru all phases of discovery and development. Developed an ODS and data marts. Produced ERD data models and all DDL to crates table, constraints, indexes, Foreign Keys, business keys indexes, primary keys, constraints, drops and alter statements. Created naming standards, nomenclature and created and maintained standardized abbreviation via Erwin. Utilized Erwin Names (.nms) file. Created several metadata reports via Erwin.

Developed the initial MDM process to uniformly identify and track key subject areas and build conceptual and logical constructs at the enterprise level. Developed a data registration process around person/org, entitlement services and other master data entities. Created enterprise identifiers and roles. Created enterprise reference domain structure and implementation plan.

Maintained data architectural control throughout the project life cycles. Incorporating users requirements, development requirement and to future state requirements. Maintained close relationship between architecture and developers, ETL, BI and UI developers. Initiated a process to maintain a level of support for development teams as new items and change are sometimes required in the Database via the data model.

Maintained Sharepoint site for artifacts collected, produced, deliverables and centralized distribution and collaboration. Created and maintained data dictionary, source to target mapping data, ERD diagrams for many views: subject areas, ODS, Application databases, data mart, warehouse views and many other for presentations and concept development.

Functioned within an Agile development environment.

Tools used: Oracle 11g, CA Erwin, Informatica, TOAD, SAS, OBIEE

Nytro Systems. Sept 2012 - Jan 2013

Senior Data Architect/Data Modeler

Functioned as a senior data architect for a major Healthcare Insurance provider and Property & Casualty (P&C) in developing a data persistence solution for an integration and conversion enterprise project. This initiative included an iterative step down phasing to retire a legacy core processing system. Also, included was the phase up of a new core system to provide functional coverage of the retiring system of record and extended functionality beyond.

Created an Operational Data Store (ODS) to persist data movement from multiple source contributing systems of record for post business consumption, downstream support, post processing, integrated data exchanges with downstream business partners, analysis, BI reporting and AdHoc querying. Developed the ODS to identify enterprise subject areas to apply MDM business rules and align to general governance prior to integrating data to the EDW (Enterprise Data Warehouse).

Directly created and maintained data models, conceptual, logical and physical models. Conducted team and client reviews with principal stakeholders. Created presentation material of complex data schemas for business acceptance, metadata repositories and artifacts for input to other tasks within the project. This included ERD data models (physical and logical), data dictionary, ETL source/mapping documents requirements traceability documents and other material.

Produces all DDL SQL to create, drop and alter DB objects. Created all Primary keys, indexes and column constraints. Developed and maintained data models in Ewing 7 and Ewing 8. Converted CA Erwin metadata reports and extractions to Erwin 8 via direct SQL and crystal reports.

Functioned at various levels within development cycle from concept, requirements, DB design, integration, access planning, data flow, ETL source/targeting, staging area DDL. Other complex data issues which as data conversion, data transposition, reference data management, latency and cycles.

Tools: Ca Erwin 7 and Erwin 8, CA Erwin Model Mart, Oracle 11g

General Dynamics IT. December 2011 -- 6/2012

Sr. Data Architect.

I was tasked to develop a new data infrastructure including data access, transport and architecture. The client, a national health care system and care provider, had multiple core systems and several downstream dependent systems (internal and external). The initiative included the decoupling of functionality from closely related system in which they were co-embedded. This included developing new business applications, UI, Data Services and database.

I developed an architectural plan for development for the development of new applications, integrations (internal and external) and new data architecture, conceptual, logical data model, physical model and API plan for application data objects interfacing. I created presentation material for client management, team management and management of our partnering systems. I produced system supporting diagrams including data access diagram, details of the data environment, systems environment, logical data diagram, physical data diagram and application and Data services ERD diagrams. I created database DDL and deployments plans and scripts.

I developed project plan to implement data services support for MDM scheme. Developed a callable API interface for web services development. Develop backend data services to imbed MDM business logic and registration processes.

My solution was a paradigm shift to an enterprise solutions perspective supported by data services. My objective was to promote data development perspective which would yielded more flexibility, functionality with much increased ROI. Still, while delivering this architectural plan for systems, data and development. It was important to show a compliment to a code developers' only driving, development approach.

TOOLS: CA Erwin v7 and v8, Oracle, SQL, DDL, DML, PL/SQL.

General Dynamics August 2011 – December 2011

Senior Principle Analyst/Sr. Data Architect

Participated as a member of an enterprise architectural team.

Contact this candidate