METHODOLOGIES, FRAMWORKS CONCEPTS

• Service Oriented Architecture SOA Business Process Management BPM
• Business Intelligence B1 Master Data Management MDM
• Data Quality Governance Entity Relationship Diagram ERD
• Reference Data Modeling RDM Object Relational Mapping ORM
• Dimensional Modeling DM Unified Modeling Language UML
• Rational Unified Process RUP TOGAF, ArchiMate, CMMI Level III
• NIEM GJXDM, AIXM, DoDAF Object Oriented Modeling OOM
• HIPAA, HL7, CDISC, CCD, CCR Role Base Access Control RBAC
• Cloud Computing, Big Data ICD 9, ICD 10, MISMO, ULDD

INDUSTRY / SECTOR

• Energy Utility, Retail, Commodity Trading, Generation, Green Energy
• Healthcare Clinical Payer, HMO/Managed Care, Clinical, Provider
• Financial Services Debt Management, Mortgage Loans, Securities, Collateral
• Government DHS, ICE, FAA, DoD/BTA
• Legal Corporate Law, Patent Law, etc
• Supply Chain Distribution CRM, Distribution Channel, Procurement, etc
• Software Product Development, Consulting, Integration, etc

SKILLS

DBMS Platforms

• RDMBS: SQL Server 7, Sybase SQLAnywhere 8 12x, MS Access, Oracle 9i 10g 11g, MySQL 5.0, DB2 UDB 7x 8.x 9.5, ProstgreSQL 8.4, Sybase IQ 15.x ASE 12.x, Teradata, SQLite
• Big Data/NoSQL/Cloud DBs: Apache Hadoop HDFS, MapReduce, HBASE, Flume, Sqoop, Oozie Cassandra, Solr, CouchBase, MongoDB, Hive, Pig, Cloudera CDH, DataStax M5, Amazon SimpleDB, Amazon DynamoDB, CouchBase

Modeling/CASE Tools

• Turbo XML, Erwin 8.x/9.x, Microsoft Visio, Visual Studio 2005, IBM System Architect, Tibco Designer, ER/Studio Data Architect, PowerDesigner 12.x/15.x, Sparx Enterprise Architect, IBM Rational, Altovia XML Spy, Altovia Mission Kit, Mega Suite 2009, Orbus

ETL Integration Platform

• ETL Tools: SQL Server SSIS, Data Junction 7.5.5, Pentaho Spoon/Kettle, Informatica PowerCenter, Tableau
• SOA BPM Tools: Tibco BusinessWorks, Tibco EMS, Tibco ESB, Microsoft SOA BizTalk, IBM Websphere, Appian PBM and Point to Point custom implementations.

Data Quality, Governance Stewardship

Tools: Infomatica Data Quality IDQ, Informatica Data Director IDD, IBM Initiate Inspector Workbench

Master Data Management

Tools: IBM Initiate MDM, Informatica Siperian MDM 9.5.1

Applications / Platforms

• Operating Systems: Windows, Mac OS X, UNIX Solaris, Red Hat Linux RHEL, CentOS, Ubantu
• Business Intelligence: SQL Server Reporting Services, SQL Server Analysis Services, ProClarity, SAP Business Objects Crystal Reports/InfoView/Web Intelligence, OBEE, Pentaho BI Suite
• Integration Connectivity Security: SOA over HTTP, SOA over JMS, ODBC, JDBC, ADO, DAO, OLE DB, MS Jet Engine, Active Directory, LDAP
• COTS Applications: Siebel 7.8 Energy, Lodestar Energy, Lawson Procurement Suite 8.x, Navision Attain 3.10a, Ecometry 6.1i, GoldMine 5.7, Oracle Financials 11i, IBM Maximo 6.2, Facets 4.5. Meditech,
• Programming Languages : J2EE, JEE, JSE, VB.Net, VB Script, VBA, XSLT, XQuery, SQL, Oracle PL/SQL, T - SQL, Python, Shell Scripting, etc.
• Development Tools: Tibco Business Studio 2.0, MS Report Designer Builder, Visual Studio, Websphere Studio, Eclipse Dev Studio, Microsoft FrontPage, SQLite Analyzer, SQLite Browser, Quest Toad, Altovia Mission Kit, etc
• Software : Quest Toad, Quest Central, Quest Spotlight, SQL Packager, SQL Backup, SQL Compare, SQL Data Compare, SQL DTS Compare, SQLLitespeed, WordPerfect 6, Microsoft Office 9.x/2K/XP/2003, Adobe PhotoShop, Acrobat Reader, Power Point, Lotus Notes, Experian Account Advisor, Task Scheduler, OminiRush 6.0, XML Cannon, MS Visual SourceSafe, MS Project Server, MS Sharepoint, Mercury, Serena Team Track, Jira, Subversion/Tortoise, Documentum, Oracle UCM, etc.

WORK EXPERIENCE

Confidential

Lead Solution Architect

Enterprise Data Repository Program MDM, SOA, DG, Data Integration, Data Quality

• MDM Solution design: data model, data quality, data stewardship workflow, ETL processes data exceptions mgt
• Development of architecture solution options and positions papers for leadership decision making
• Work with all teams SOA, ETL, Shared Svcs, Architects, PMO, etc in the firm to design the Enterprise Data Repository/Corporate Information Factory solution for Party Master, Securities Master and Loan ODS
• Worked with Chief Data Office to provide executive level direction and resolution of strategy execution issues
• Design documentation: Architecture Docs, Diagrams, Architecture Feasibility, etc
• Guided the program through firm's architecture reviews 4 and advice mgnt.
• Designed and developed all TOGAF architecture artifacts using MEGA Suite modeling tool: ISA Level 1, 2 3 diagrams, data security, system context, engineering diagrams, component diagrams, infrastructure diagrams, business process diagrams and other diagrams for Securitization Utility Project, Collateral Data Store CDS, EDR Program

SKAI Data Virtualization PoC

• Provide architecture information management strategy advisory consulting services to executive level leadership.
• Review of vendor SKAI Big Data solution architecture and implementation patterns
• Review and validation of the Hadoop, HBase SKAI cluster infrastructure for SKAI proof of concept project
• Big Data technology and vendor solution tradeoff comparative analysis between DataStax, Cloudera, HortonWorks and Coral Networks SKAI
• SKAI code review: Forms, Relations, MapReduce mappers and reducers
• Data source and target analysis mapping for Loan entity state change SIR CLDF

Collateral Data Store CDS Project: SOA Data Service Project

• Development lead team of developers, data modeler, DBA Testers, driving the design and implementation pattern of all collateral data services solution components using Tibco BusinessWorks, Tibco EMS and ESB platform.
• Review and gap analysis of collateral data model and enterprise logical data model
• Review and gap analysis of collateral XML schema with enterprise logical data model
• Conducted Tibco code reviews, Test reviews and other project documentation
• Responsible for development, review and oversight of all SDLC artifacts for CDS project
• Developed and wrote the solution architecture document, diagrams business process, Workflow, system, context, and infrastructure and review with business stakeholders

Confidential

Sr Data/Information Architect

• HP Cloud Services Integration Project ITSM Canonical Data Models Project A
• Logical Data modeling of ITIL Information objects: Change, Work Order, Incident, Interaction
• Reverse engineering of existing ITIL information objects: excel, schemas and data models
• Forwarding engineering of ITIL information objects defined with HP SMEs by conducting JAD sessions for requirements and validation of ITIL information objects with SMEs input
• Derived ITIL Canonical XML Schemas from the logical models for implementation of Cloud Services. Documentation of design patterns, naming standards and implementation approach.

Confidential

• Design of Watson training data repository: Hadoop DB2 based infrastructure for training Watson Supercomputer NLP to understand Clinical Diagnosis of Cancer illnesses.
• Designed the dimensional model OLAP for the IBM Watson performance trend, analysis, clinical analytics reporting.
• Designed and developed the utilization management UMA OLTP physical data model and DDL development for all agile iterations.
• Designed the IBM Watson clinical knowledge training data model for sending and evaluating IBM Watson training performance.
• Designed the WellPoint Care Assistant/Birch OLTP database: conceptual, logical, physical data models
• Designed the WellPoint Care Assistant /Birch Data Mart/OLAP database: conceptual, logical, physical data models. Conducted review of all data models with application development team and report development team.
• Data integration ETL design and solution architecture: data mapping, ETL logic documentation, data flow and transformation patterns.
• Business objects universe design and mapping to database for clinical analytics
• DB2 database development: store procs, functions, views and materialized views.
• Designed the business objects Universe for all reports, scorecards and charts
• Developed the business intelligence strategy and design document for the solution architecture.
• Develop business objects Web Intelligence reports matrix reports
• Universe to database objects mapping and reviews. Conducted reviews, meetings and design sessions.
• DB2 database development: views, materialized query tables, stored procs for reports

Facets Database Architect

• Derived Facets 4.7.1 logical data model from the physical data model through manual reverse engineering process.
• Designed the WellPoint Facets domains Member, Provider, Claim, Product, Billing, Group conceptual and logical model for categorizing and mapping automated business processes Jobs, user reports and application processes to the appropriate domain entities using PowerDesigner.
• Developed the data archiving strategy for Facets transaction history information.
• Researched the use of Sybase Replication Server for Facets data replication from Sybase ASE to Sybase IQ.
• Research and analysis of Sybase IQ indexes, security and role base access architecture for Facets data migration projects.
• Data analysis of Facets OLTP data store to identify domain model scope, data quality and mapping

Confidential

Sr Database Architect

• Consulting to the CIO and Executive leadership of clients by defining three to five year IT strategy around cloud computing and big data solutions to support decision support in healthcare.
• Developed cloud computing roadmaps and strategies for healthcare clients.
• Evaluation, analysis and selection of Big Data technologies for clinical analytics. Hadoop based solutions for clinical decision support and clinical data exploration for MU Stage 2.
• Cloudera CDH deployment, configuration and development Pig, Hive MapReduce jobs for clinical decision support proof of concept
• Developed the master data management strategy, SOW, project plan for implementing the master Patient Index EMPI strategy using IBM Initiate
• Design the overall EMPI/MDM solution architecture: data flows, data mappings, matching rules, data governance process around patient, data cleansing rules, profiling and transformation.
• Defined the Big Data strategy using Hadoop ecosystem technology across SJHS in support of all clinical and business analytics.
• Client's enterprise application infrastructure, big data, business intelligence and cloud assessment to determine maturity of client environment. Develop execute level C Level presentation and present assessment to clients.
• Responsible for defining client Common Domain Model HL7 Messages: Orders, ADT, LAB, etc, CCD, CCR for future state SOA and Cloud enablement projects. Responsible for ICD 10 transition strategy and remediation design.
• Business process documentation, analysis and mapping through JAR /JAD session in the following functional areas: Emergency Department ED, LAB, Clinical Documentation, Clinical Quality, Case Management, Facilities Management, Materials Management, Radiology, Revenue Cycle, Finance, Surgical Services.
• Data Mapping of Common Domain Model entities to the business processes in each functional area
• Business intelligence capabilities rationalization to develop BI strategy for the organization
• Conducted executive level interviews to understand the organizations' information gaps and silos
• Application portfolio rationalization exercises and information management strategy definition around Patient Perfect Care, Clinical Analytics and Meaningful Use.
• Information integration and exchanges analysis and strategy definition around Health Information Exchange HIE projects.
• Collaborate and consult with client executive level to define information management strategies and a transition plan.

Confidential

Sr. SOA Data Architect

• Analysis of CATS, JPAS and ACES data architecture to define TO BE state enterprise data architecture for future state of DISS Program.
• Designed and developed the business intelligence strategy and architecture solutions for DISS Program. Reverse engineered existing data stores for the legacy/ AS IS systems dbs Sybase, Oracle SQL Server into a logical model.
• Modeling and design of the integrated data store IDS layer of the data warehouse. Analysis of AS IS clearance and adjudication operational processes. Reviews and analysis of the TO BE state clearance and adjudication business processes.
• Review and analysis of the system architecture for the TO BE statement DISS Family of Systems.
• Reverse engineer the AS IS physical model from Sybase DDL to SQL Server and Oracle dbs.
• Defined data flow diagrams and the input output data elements for DFD processes across multiple systems.
• Define the DoDAF OV 7, SV 4, SV 11 for the DISS Program. Reviewed DoDAF OV 1, OV 5, OV - 2, SV -1, SV 2 for data related artifacts for DISS system integration.
• Canonical data modeling for Web Services message content and Data Mapping between Canonical Model and legacy Interfaces.
• Multiple XML Schemas/XSD data element mapping data consumers to Canonical data model for XSLT XQuery transformation logic.
• WSDL/Service contract reviews and operations mapping to core security entities.

Confidential

Data Architect

• Conducted detail analysis of firms business processes to categorize master business entities domains.
• Used ArchiMate architecture methodology notation to design the business architecture for: Business Development, Legal Practice, New Business Intake, Human Resources and Finance operational departments.
• Derived the enterprise conceptual model master business entities from the business architecture.
• Data flow analysis to define the master data entities information integration patterns.
• Defined the enterprise master data management MDM strategy and recommendation to leadership.
• Conducted JAR sessions on business processes for Finance, NB/C and HR business process documentation.

Confidential

Sr. Database Manager

• Mentoring of junior database administrators and developers 25 people, coaching, project management and project prioritization duties.
• Identified requirements, documented and design the data architecture layer for the Aeronautical Constrain Manager application.
• Logical physical data modeling of aeronautical static constraint information and requirements gathering of constraint data elements.
• Data Modeling: AIXM reverse engineering, conceptual, logical and physical data modeling of AIXM complaint databases on PostgreSQL 8.4.
• Data flow modeling, data analysis of multiple data sources for harmonization and conformance.
• Enterprise data flow architecture on the project level and conceptual data architecture for information integration.
• Wrote data architecture analysis documents, data architecture artifacts design and analysis and requirement gathering of data entities within FAA AIM organization.
• Object relation mapping between AIXM XML Schema and non-AIXM relation databases. Gap analysis of multiple data sources and AIXM schema.
• Design and development of XQueries for reading, transforming and loading Web Services Messages into relational table on PostgreSQL database.
• PostgreSQL database administration: backups, restores, DDL, DML, maintenance of indexes, partitioning and development.

Confidential

Data Architect

• Data modeling, business process re-engineering, data integration, data migration.
• Health benefits data analysis, gap analysis and harmonization across data sources and systems in support of multi-organization business processes execution.
• Provided consulting technical, process, and functional advise to client on process improvement through process automation.
• Data profiling of multiple data sources to harmonize health benefit data for data cleansing.
• Business process re-engineering: business process modeling of AS IS, TO BE, process efficiency analysis using business process modeling notation.
• Designed and implemented quality assurance QA process automation solution to improve EOC production data accuracy reduce cycle turn-around time, using Excel, Access 2007 and SQL Server 2008. ETL design, development and deployment.
• Cost benefits analysis of solution architecture, project plan for solution architecture and system analysis.
• Project planning, resource allocation analysis, customer interfacing services. Conducted JAD sessions for requirements and presentations of design solutions to leadership.

Confidential

Business Intelligence Developer / Architect

• Analysis and documentation of AS IS Crystal Reports and SQL Server 2005 DB Objects infrastructure for conversion to SQL Server 2008. Review and supervision of OLAP cube design and implementation.
• Requirement gathering, design and development of SSRS 2k8, SSIS 2k8 packages, tables, stored procs, views, function for conversion processes. Review of data process design and implementation.
• Analysis, design and identification of KPIs for Call Center Management Dashboard. Advisory to management on the approaches to migrating AS IS infrastructure from SQL Server 2000 to 2008.
• Project resource management: hours, project plan, statement of work, project schedule, scope and communication to leadership.
• Advisory to management on cost benefit, ROI and EVA for BI infrastructure conversion project.
• Data flow architecture design to support the BI data acquisition strategy and ETL processes.
• Reporting services design, development and deployment of reports. Presentation and training of reports to users.