SUMMARY

• As a seasoned multi - faceted hands-on health care Sr. Technical Architect at Confidential, Edward engineered from ground up an analytical claim submission platform called Cornerstone by leveraging Data Warehouse architecture, which houses Payer, Provider, Patient, Eligibility, and Claims data domains.
• He engineered a multi-tenant claim submission platform called Encounter Data Processing System by leveraging Operational Data Store architecture, to submit claims on behalf of Payers to CMS (Center for Medicare and Medicaid Services) for reimbursement of claim payments based on Risk Adjustment metrics.
• He integrated ASM-Alternate Submission Method (Medical Chart based patient information) domain with Claim domain. He structured data entities to align with x12 EDI formats such as 837I, 837P, 837D to support inbound /outbound claim data.
• As an abstract thinker and diverse data pattern driven Data Engineer, Edward directed, initiated, assessed, road mapped, guided, architected, modeled, reviewed, implemented and operationalized Data Warehouse, Operational Data platforms, Data Marts and Master Data Repositories for UnitedHealth Group ( Confidential, Confidential Bank, Confidential Insights), BCBS, Confidential, USBank (Syncada), Target, Delta (Northwest Airlines), Abbott (St.Jude), Medtronic, Willis Re, Jostens, RedBrick Health, Peozzle and Marcole Interactive.
• He inspired and configured a business-friendly data delivery pattern for WellsFargo. He has led business, technical and management stakeholder personnel through Data Warehouse assessment interviews. He has been instrumental in jointly creating Business Intelligence Roadmap for multiple organizations.
• He has engineered multi-TeraByte Data Warehouses, Data Marts (including 75,000 element datamart), Operational Data Stores and Business Intelligence solutions, and Data Model Repository.
• Over the course of 26 IT years, he augmented management/business/technical Leaders in meeting enterprise data delivery goals. He has leveraged Micro Services Architecture, Service Oriented Architecture (SOA), Multi-tier web architecture to meet business goals. He is well versed in API design and OAuth security patterns.
• He is experienced in diverse spectrum of disciplines - strategic/tactical initiatives, operational/analytical systems, real-time/batch processes, application/infrastructure projects,
• He fulfilled 3 data consulting engagements (12+18+18 months) for Confidential, and 2 data/application consulting engagements (22+33 months) for UnitedHealth Group family of companies. He got certified as CBIP (Certified Business Intelligence Professional) and CDMP (Certified Data Management Professional), and SCJP (Sun Certified Java Programmer).

TECHNICAL SKILLS

Vertical: Insurance (Health Care, Consumer Driven Health Care, Life and Re-Insurance), Retail (Departmental and Discount), Financial (Home Mortgage, Credit, Retail Banking), Manufacturing (Medical Device, Memorabilia, Steel and Fine Food), Transportation (Airline), and Utilities (Water Supply).

Horizontal: Digital Security Authentication, Claims/Provider/Member/Plan/Eligibility, Financial/Retail Supply Chain, Merchandising, Customer Relationship Management, Direct Marketing, Human Resource, Fraud Prevention, Loss Prevention, Loss Mitigation, Credit Risk, Government Regulatory Compliance, Ground Operations.

Organizations: Edward was accountable for key deliverables at UnitedHealth Group ( Confidential, Confidential Bank, Confidential Insights), BCBS, Confidential, USBank (Syncada), Target, Delta (Northwest Airlines), Abbott (St.Jude), Medtronic, Willis Re, Jostens, RedBrick Health, Peozzle and Marcole Interactive

Decision Support Systems: Built 30 plus ETL based enterprise data warehousing applications (Data Warehouse, Data Mart, and ODS) over a period of 15 years by leveraging software products such as DataStage, SSIS, Pentaho Kettle, Cognos, Oracle, Teradata, Non-Stop SQL, UDB, DB2, SQLServer, Sybase, ShellScript, Windows Batch Script, Power BI, Tableau

Interactive Systems: Architected 12 web based applications over a period of 14 years using Angular JS, Node JS, PHP, Ruby on Rails, WebSphere, IIS, Java, .NET, Visual Basic, C#, C++, ODBC, CORBA, and AWS Cloud

Legacy Batch Systems: Engineered several batch applications using COBOL, DB2, JCL

Legacy Interactive Systems: Built several client/server applications using COOL Gen

ETL, Business Intelligence and ERP: DataStage 8.5, WTX (HIPAA package), WESB, Informatica v8.0, SSIS 2012, Pentaho Kettle, Pentaho Reports Designer, WhereScape (ELT), Cognos, Brio/Hiperion 8.0, Peoplesoft EPM/HCM, PragmaticWorks

Databases: Oracle 9i/10g/11g, Teradata 14, UDB EEE v9.5 (Federated), DB2, SQL Server 2000/03/05/08/12 , MySQL v4.1, Sybase 9.0, Non-Stop SQL, and Hadoop

Scripting: Angular JS, Node JS, VBScript, JavaScript, Shell Script, AWK, SED, Batch Script, PL/SQL

Standards/Tools: WebStorm, X12, EDI 837/999/277CA, Power Designer 16.1, Embarcadero, ER/Studio (Data Architect), ERWIN 4.0, TOAD, Control Center, Command Center, Visio, Control-M, AUTOSYS, PVCS, ClearCase, SVN, TWS (Tivoli Scheduler), Rally (Scrum), JIRA

Flexibility: Is quick to digest business processes, technical tools and techniques. Responds quickly to changing demands.

Innovation: Originates and develops constructive ideas. Makes effective use of graphics to present highly technical information. Strives for continuous improvement .

Reliability: Provides the highest level of customer service. Excels in inter personal communications.

Execution: Demonstrates systematic approach in carrying out assignments. Takes decisive action based on well documented facts. Uses the synergistic power of teamwork to achieve results.

PROFESSIONAL EXPERIENCE

Confidential - Eden Prairie, MN

Technical Architect, Technical Lead and Data Architect

Responsibilities:

• Architected a Micro Services API based Rule Engine framework leveraging Java 8 and Antlr Rule Engine
• Architected Logical Data Model and Physical Data Model for Relational Data platform
• Architected Logical Data Model and Physical Data Model for Big Data platform
• Modeled Data Structures to house the Rules (Processing Rules and Validation Rules)
• Produced Roadmap, Conceptual Diagram, Process Diagram, and Deployment Diagrams
• Designed Java Project Structure for SpringBoot based Micro Services Application
• Generated DDLs and DMLs for Rule Engine configuration and Reporting application
• Deployed DDLs and DMLs against Oracle and MongoDB (NoSQL)
• Automated deployment of Java 8 based Micro Services application using Jenkins pipeline
• Built JSON driven Micro Services based Rule Engine application using Spring Tool Suite
• Enhanced Information Transformation Extended (ITX) components related to Pharmacy Claims
• Re-Wrote Service Oriented Architecture based WESB mediation components that invoke Pega Services into a JSON driven Micro Services and integrated into EDPS Gateway application, and deployed on Hybrid Cloud platform
• As part of sweep related DevOps effort, studied data configuration, Java components, Hibernate Trace components, then re-configured the client configuration, so that Alternate Submission Method (ASM) claims will be processed as Unlinked claims, so that these can be submitted to CMS for Risk Adjustment
• Analyzed 277CA responses from CMS, and recovered and resolved by analyzing data and PL/SQL packages and stored procedures

Confidential - Eagan, MN

Sr. Data Architect and Solution Engineer

Responsibilities:

• Produced BCBS Association Handshake Diagrams, Conceptual Data Flow Diagrams, and Swim Lane Diagrams
• Collaborated with Enterprise Architecture team to create Medicaid Partners Data Flow Steady State Diagram
• Produced Dimensional Data Modeling for Common Mart, which integrates Commercial, Medicare and Medicaid subject areas and holds Client, Member, Provider, Product, Claim domains. This includes data related to Institutional claims, Professional claims, Dental claims, Pharmacy claims, Durable Medical Equipment (DME) claims, Federally Qualified Health Center (FQHC) claims, and Elderly Waiver (EW) claims
• Performed data profiling and data analysis of Enterprise Data and Information Management (EDIM) Data Warehouse Base Layer, Government Neighborhood, and Common Mart data repositories
• Designed Data Models, Data Mapping and Data Extracts for HEDIS/NISUS (Wherescape RED), Concert Genetics (SAS extract), Minnesota Department of Health (Informatica), Resume (SAS/Business Reporting Center), Symmetric Grouper (SAS), Talix (Wherescape) and MedeAnalytics(Wherescape).
• Designed physical data structures for Teradata database
• Designed ETL patterns for Informatica (ETL) and WhereScape (ELT) processes
• Built Informatica components to stage the legacy claim data into Teradata IDW (Integrated Data Warehouse) Staging layer, then applied transformation rules and loaded the data into Base layer. Unit Tested the data components. Collaborated with QA team to complete System and Integration Testing (SIT). Collaborated with Business users to complete Business Acceptance Testing (BAT). Deployed and Monitored components in production.
• Built WhereScape components to stage the claim data into Teradata AIW (Analytical Integrated Warehouse) landing layer, then applied transformation rules and loaded the data into Base layer. Unit Tested the data components. Collaborated with QA team to complete System and Integration Testing (SIT). Collaborated with Business users to complete Business Acceptance Testing (BAT). Deployed and Monitored components in production.
• Built WhereScape components to extract data from IDW and AIW, then aggregated and loaded the claim data into Teradata Common Mart Merge layer. Unit Tested the data components. Collaborated with QA team to complete System and Integration Testing (SIT). Collaborated with Business users to complete Business Acceptance Testing (BAT). Deployed and Monitored components in production.

Confidential - Minnetonka, MN

Salesforce Cloud Solution Consultant

Responsibilities:

• Produced Cloud Application Architecture, Cloud Network Architecture and Data Lake Architecture
• Performed data profiling and data analysis of SAP BW and Salesforce
• Produced Source to Target mapping for bi-directional data flow between SAP BW and Sales force
• Designed ETL patterns for improving supportability and maintainability
• Designed data ingestion approach to store raw device data files on Hadoop
• Designed and built MapReduce components to process the device data
• Performed proof of concept to integrate DataStage and Salesforce using SoQL (Salesforce Object Query Language) and InfoSphere Information Server pack.
• Designed and built extract jobs to process Account, Account Address, Sales Rep RIO data against SAP BW using BW Open Hub Extract stage and loaded Oracle tables.
• Loaded Nuero Modulation customer and physician data into Salesforce objects.
• Extracted Implant Flash sales data from Salesforce objects, transformed and loaded data into SAP BW data warehouse

Confidential - Plymouth, MN

Cloud Solution Consultant

Responsibilities:

• The objective of this project is to create a cloud security wrapped, integrated, high tech consulting supply chain market place to facilitate interactions between hiring managers, candidates, and stakeholders in the supply chain of consulting
• Produced Elastic Cloud Application Architecture, Elastic Peozzle Hub Architecture, and AWS Network Architecture
• Produced Data Models, Data Dictionary and Data Structures
• Designed entities for Organization, People, Role, Asset, Candidate Profile, Hiring Hub and Staffing Hub domains
• Designed data ingestion approach to store inbound multi-media files on Hadoop, EMR, EC2
• Designed AWS EMR (Elastic MapReduce) components to scan the files for malware
• Led the team and identified tasks to deliver the User Stories in Agile environment

Confidential - Eden Prairie, MN

Data Modeler, Capacity/Performance Management Consultant

Responsibilities:

• Created working prototype using real infrastructure data of desired solution in first 2 weeks using Microsoft Access capabilities, including data structures, queries and reports. Demonstrated potential of the solution to Application stakeholders for buy-in
• Harvested infrastructure configurations of Application technology stack, which included WTX, WESB, Websphere, Java, IHS (IBM HTTP Server), DataStage, DB2, EPS Application, Linux and AIX by handshaking with 70+ servers across development lifecyle environments.
• Identified ETL processing patterns and developed ETL jobs leveraging the patterns
• Produced Data Models and Data Dictionary
• Designed data structures based on Data Warehousing patterns
• Partnered with Application stakeholders and Leadership team to define and set vision for Catalog of EPS infrastructure end state
• Identified additional resource needs such as QA effort and configuration management
• Played one person team, varying the roles from Capacity Analyst, ETL Designer, Data Designer, and ETL Developer, while periodically consulting with Application stakeholders and Leadership team.

Confidential - Minneapolis, MN

Business Systems Consultant, Data Architect, Data Modeler and Data Designer

Responsibilities:

• Produced Relational data Models for Data Warehouse using PowerDesigner
• Produced Dimensional data Models for Data Mart using PowerDesigner
• Produced Source to Target mapping for the ETL team
• Dynamically generated data models using VBScript macros
• Dynamically generated Teradata DDL scripts using VBScript macros
• Defined Table structures and manually generated DDLs for Teradata database
• Architected Data structure patterns
• Defined Architecture standards
• Designed and configured a Data Model Repository
• Reviewed ETL scripts and provided feedback
• Recommended ETL patterns
• Defined ETL reconciliation rules
• Provided technical leadership and guidance to ETL team and QA team
• Performed data profiling against Oracle and Teradata databases
• Produced High Level Design and presented to project stakeholders
• Played data ownership role in building simple and complex SQLs, views and macros
• Performed data profiling against MSP BI data warehouse
• Performed data profiling against CSC Early Resolution data files
• Established business data strategy for Residential Mortgage Servicing data, which is sourced from MSP BI (Mortgage Servicing Platform Business Intelligence) data source.
• Interacted and managed communications between leadership, business and technical teams
• Interviewed and recommended candidates for positions such as Data Architect, Data Modeler, Database Administrator
• Defined project tasks and time estimates