SUMMARY

• Experienced at cross domain architecture and business intelligence management, systems integration and database administration, driving organizational communications for application reengineering and platform/package replacement including master data management, systems and applications requirements, data governance, data quality, data integration, software requirements, data presentation, package and hardware replacement, application functionality, quality assurance, SaaS, and data interchange.
• Created data warehouse departmental operating procedures including data management, new subject area implementation procedures, request handling standards, data governance charter, data quality governance and artifact design, data warehouse staffing, software selection and communications to other departments serviced by the business intelligence function.
• Hands on full project lifecycle analysis including production of requirements documents, database specifications, user interface specifications, technical specifications, testing plans, documentation, and implementation plans.
• Oracle, DB2, SQL Server, PL/SQL, TSQL experience

PROFESSIONAL EXPERIENCE

Confidential

Data Management Application Architect

• Business process analysis, data application design, search facilities design and optimization, provider network analysis, geospatial feature design, SSRS, SSIS, SSAS, SQL Server. Business requirements gathering, business requirements specification production, technical design production, user interface design and specification, and dashboard design. Development of advanced SSRS objects including geospatial, multi-aspect search, database and query tuning, data warehouse ETL specification development and database object design.

Confidential

Enterprise Information Architect Data Management Solutions

• Data Management architecture, data warehouse design, cloud services and analytics warehouse implementation, data architecture for predictive analytics, data quality, etl, columnar databases, health care data operations data integration, infrastructure internal, SaaS, IaaS , master data management, enterprise metadata management procedures, information architecture projects and procedures implementation. This includes Data Governance, data stewardship definitions and implementation, metadata requirements, data strategy creation and specification. Warehouse initiation development SDLC systems and procedures design, governance charter development, workflow design, modeling and etl and specification document standards development. Multi-vendor services coordination.

Confidential

Lead Informatics Application Architect Data Warehouse

• Responsibility for applications architecture for large scale software integration for Medical Management, Claims, Enrollment, MDM, UML, and data warehouse/operational data store systems. Requirements analysis, architecture specifications databases, operational datastores, data warehouse, API components, SOA components, stored procedure components , including interaction specification development. Medicare, Medicaid regulatory requirements analysis and data architecture design, Medicaid data warehouse, data management, metadata management, standards and query reusability, data dictionaries, user interfaces and user interactions for reporting and data delivery. Information Life Cycle Management, ETL planning and Data mart management, Content Management systems, requirements, database design, security design, user interface design, testing, and deployment. Agile and Waterfall project based architecture. SDLC management.

Confidential

Senior Application Architect

• Process re-engineering, planning and business analysis. Master Data Management evaluation, architecture, setup and testing. Technology review and planning for technology replacement and business process re-modeling including Master Data Management. Healthcare including enrollment, claims, financial, provider networks, master data management implementation planning and analysis. SOA Architecture, software design and modernization design, and planning, BPM/BPEL development and implementation. Geocoding and Address Management design using OptumInsight. Legacy integration tools implementation design. Data analysis, technical writing, systems architecture planning, as is/future state analysis, infrastructure and new technology implementations master data management . Testing planning and strategy. ACO, CMS, Medicaid, Medicare, PCP, enrollment processing, data architecture, EDI 834, 4010/5010 , IDX, Ensemble. Technology roadmaps, project management of technology replacement projects, Change Advisory Board participation. Management of advanced technical projects in performance tuning, address standardization, web services servers, disaster recovery, and master data management. Hadoop investigation for application/analysis applicability.

Confidential

Senior Business Architect and Data Architect Financial Application Software

• Hands on and lead of Business Analysis, Testing and Quality Assurance Analysis, Documentation/Technical Writing Lead.
• Interpretation of FASB statements, requirements gathering, requirements and use case production, management of analysts and graphic artists, database modeling, database analysis, database tuning and database changes specifications, offshore software production planning and management, backup and archive planning, security planning, design of processes and process requirements, web page design management, applications database design, specification of programming requirements for Java, Windows, HTML, SQL Server data architecture, security domains, .net, ITIL, reporting systems implementation, long term product architecture planning. Project Management and Change Management for major organizational combination financial integration projects. Management and directional lead on Securities Accounting, Requirements Analysis, User Interface Design, Specifications production, documentation and data dictionary production, Data Modeling and Data Integration. Operations Combination Project Management, design of interfaces for ASP hosting operations. Produced long term roadmaps of data requirements including data load from customers and partners. SSRS Architecture, virtualization planning and security.

Confidential

Senior ETL Data Architect Healthcare

• Eligibility transfer and load analysis, claims data analysis, and data mapping to internal systems, Oracle, SQL Server, Access, and Excel usage standards development and implementation. Eligibility, Medical Claims, RX Claims. Standards and procedures development. Pervasive Data Integrator ETL tool, PL/SQL, T-SQL Server Procedures. Management of Offshore resources. ER Studio data models, programming and data analysis procedures development for offshore ETL analysts. Planned SharePoint collaboration procedures for internally and externally produced documents. Produced data analysis, data quality and data relationship communications standards documents.

Confidential

Manager Business Intelligence - Insurance

• Strategic planning, budgeting, management of ETL staff and reporting staff. Model development management, management of DBA's, storage analysis and management, model design and model management, senior management planning sessions, hiring, employee evaluations, formalization of procedures, production of Business Intelligence Procedures Manual, database tuning management, management of quality assurance of data flow from source to staging to presentation, efficiency evaluation and planning. Internal data quality initiatives, testing and compliance for medical claims, prescription and premium accounting. ER/Studio, Microsoft Foundation Framework ITIL implementation.
• Business Intelligence Procedures manual and standards development which included standards for model design, requirements gathering techniques and procedures, dimensional testing and analysis of data sources, managed the production of user manuals and user communication standards
• Management of DBA staff, Lead on SAN/storage array reorganization and disaster recovery planning.
• Loading multi-tier databases using ETL data transformations, tracking data from mid-tier staging systems to operational /warehouse data stores terabyte size databases , metadata management, data quality program development, governance and stewardship procedures development.
• Managed reporting, ETL staff, new model production, reporting requirements, and schema design for insurance staging and presentation data warehouse layers. Worked with DBA,s software vendors, systems support, accounting, and other operations personnel in planning data warehouse priorities.
• Software contracts, software procurement.

Confidential

President, Systems Design Architect Insurance Data Warehouse Design

• Technology research and consulting firm basing products in Oracle, Microstrategy, Portals, MapInfo, Linux, Solaris, E/R Studio, Informatica, SOA, and PL/SQL. Includes data warehouses, staging systems for ETL/data warehouse dimensional loads, geospatial, and advanced reporting.
• Produced technical and user documentation.
• Software vendor agreements reseller and usage negotiation.

Confidential

Vice President Product Development Consulting, Custom Software and Insurance Systems

• Management of DBA's and database tuning, modeling/development and deployment, user documentation production, Business Analysts manager, Executive Manager of Direct Sales Staff, RFI/RFP responses to large companies.
• Directed operational auditing to determine software requirements and user procedures for new software functionality and functional enhancements including dashboards, data warehouse, SOA, and ETL.
• Designed and produced general ledger, and financial reporting systems for the automatic and integrated posting of the general ledger and generation of financial statements. Worked with customers to handle automation of complex general ledger postings, multi-company and multi-departmental allocations, taxation calculation, insurance regulatory compliance, consolidation, revenue recognition and other advanced accounting related software implementations using iterative processes.
• Packaged software, custom software and consulting services contract development and contract negotiations.

• Determined technical direction for programming languages, programming standards, system integration of servers and databases, email integration and business intelligence direction. Worked with management of billion dollar companies to specify custom software requirements

• Managed a 26 person operation
• Worked with Fortune 100 companies to evaluate current systems for integration into the insurance product
  • This included integration into large and existing corporate systems and operating databases for cross marketing of insurance and financial products and evaluation of current in place systems for integration or replacement of function

Confidential

Director of Product Development Consulting, Custom Software and Insurance Systems

• Created internal training programs and programming standards, allowing the growth of the company to efficient move from 13 to 200 employees, increasing revenue from under one million to 20 million.
• Responsibility for projects through entire life cycle
• Director Level Management and technical definition of system requirements, operational/procedural audits, database design, accounting systems integration, programming and programming management, user documentation, user training, database conversion, conversion and installation planning, software support, software modification, software testing management, quality assurance standards and management of QA staff, design of enhancements, and customer management consultation. Premium accounting, TPA, workers comp, multi-employer trust health and other property casualty and health insurance processing systems.
• Managed 35 person technical consulting, design, and development staff.
• Other responsibilities include, project management, consulting staff training, programming standards development, primary client contact, personnel consulting, UI forms design, and systems design.
• Customer training program development and data quality assurance management.
• These projects included government, insurance, energy, engineering, distribution, retail, medical, financial consolidation, mortgage broker, payroll and other systems