SUMMARY:

Expert in Enterprise Information Management, specializing in Oracle. Expertise in Application and Data Integration, Master Data Management, Data Governance, Big Data, designing and developing large scale distributed data warehouse applications using Apache Hadoop framework, AWS, Data Virtualization, Data Modeling, Data Administration, Data Profiling, Data Quality, Data Extraction, Data Transformation, Data Conversion, Data Migration, Data - as-a-Service (DaaS), Metadata Management, Unstructured Data Management, Business Intelligence, building EII, Enterprise Data Warehouse, Data Mart & EIS/DSS solutions, Healthcare Revenue Cycle Management, EMR/EHR, MMIS, CMS MITA Framework, IBM UDMH, FHIM, FHIR, NIEM, HL7, CMS Code Sets, NIST, NCPDP, HIE, HIX, ICD 9/10, CPT-4, Oracle BI Applications, Oracle Business Analytics Warehouse, Siebel Analytics, Enterprise Performance Management, and Project Management. Proficient in Rational Unified Process, UML, OBIEE Plus Administration, Answers/Dashboard/iBots/Reports, Enterprise Performance Management (Hyperion), VMware Virtualization, Storage, Cloud Computing solutions, Apache Cassandra, Web Services Technologies, Enterprise Content Management, and E-Commerce. Resolve complex sales support technical issues, respond to client’s product questions and prepare and perform detailed POC and product demonstrations. Over 15 years’ experience in the IT field and ITIL Foundation Certified.

SKILLS HIGHLIGHT:

Methodology: OracleAIM, TOGAF, Federal Enterprise Architecture Framework, Zachman Framework / TEAF, Scaled Agile Framework.

Operating Systems: UNIX, IBM OS/390, CentOS, IBM MVS/ESA, CICS/ESA, TSO, RED HAT LINUX, Fedora, Ubuntu.

Languages: SQL, PL/SQL, IIS, JSP, Servlets, HTML, XML, Java, CGI, Perl, RDF/XML.

Databases: IBM Aginity Workbench for PureData System for Analytics IBM Netezza, IBM Aginity Workbench for dashDB, Oracle 11g, MS SQL Server, DB2 Universal Database, NoSQL dynamic schemas (e.g. Apache Cassandra, MongoDB, CouchDB), HP Vertica SQL Workbench, high performance databases (e.g. IBM Netezza, Vertica, EMC Greenplum).

Data Modeling: Erwin Data Modeler, Teradata Healthcare data model, Oracle Healtcare Data Model, IBM UDMH InfoSphere Data Architect, Sparx Systems Enterprise Architect, ER / Studio Data Architect , DAMA DMBOK

Data Standards: NIEM, FHIM, FHIR, NIST, CMS Code Sets, HIPAA

Web Services Tools: SOAP, UDDI, AJAX, WSDL, WSIL, XML, JSON, BPEL, ECLIPSE JAVA IDE JST/WST Web services.

Data Virtualization: MapR, High-performance computing (HPC) Cloud Computing, Apache Hadoop, Map Reduce, HDFS, Hive, HBase, Hortonworks HDP 2.0 / Ambari, VMware, MongoDB JSON Schema Document Data Modeling, Cloudera Manager.

Cloud Computing: Amazon Web Services, EC2, IBM Bluemix, IBM Watson Analytics, DynamoDB, Athenahealth.

IT & Software Configuration Tools: BMC, Tivoli, HP ALM, IBM ClearCase, Visual SourceSafe, TSF, Git

Web Server: Oracle11g/9iAS/, Oracle WebLogic, JBoss, IBM WebSphere.

JAVA IDE: IBM VisualAge for Java, Oracle Jdeveloper, Eclipse, Visual Café Java, JBuilder, Oracle TopLink.

ETL-BI Tools: Cognos Impromptu / Powerplay, Oracle Hyperion Essbase Server, MicroStrategy 8 BI, Oracle BI Applications 7.9.5.1 Informatica PowerCenter, Teradata, ODI, OBIEE Plus 10.1.3.4.

CRM: Siebel, BaaN SFA, SalesForce, SFDC Appexchange DataLoader (EE), SFDC Import Wizard, Apex API.

ERP: PeopleSoft, and Oracle Applications 11i / Oracle E-Business Suite R12.

SCM: Manugistics, Baan SCS, Oracle Order Fulfillment 11i.

ECM: IBM FileNet P8 Content Manager, SharePoint, Oracle ECM Suite, Open Text eDOCS.

MDM: IBM WebSphereCustomerCenter, SAP NetWeaver MDM, Oracle Siebel UCM Customer/Product MDM, Informatica MDM.

EAI: TIBCO, Oracle AQ / Oracle Fusion, IBM MQ, JBoss, Software-as-a-service (SaaS) integration.

Project Tracking (PPM): CA Agile Rally DE, Kanban boards, SAFe Portoflio Kanban System, JIRA, CA Clarity, Confluence, Trello boards.

Data Governance: InfoSphere Information Governance Catalog, Informatica Axon Enterprise Data Governance, Oracle Data Governance Manager

PROFESSIONAL EXPERIENCE:

Senior Data Architect, ERWin Data Modeler- Infosphere Data Architect

Confidential

Responsibilities:

• Establishing the MITA compliant information architecture for the Medicaid Management Information System Replacement (MMISR) Project.
• Responsible for implementing MDM for Client and Provider data domains.
• Responsible to create, implement, and support data management strategy by developing conceptual, logical, physical, and canonical data models and establishing data standards (NIEM, FHIM, FHIR, NIST, EDI X12, HIPAA compliant standards, CMS Code Sets) that will be used by the enterprise for producing these artifacts.
• Responsible for aligning and implementing MMISR data domain information exchange models with MITA 3.0, the CMS Condition and standards, the MECT checklist, and the IV&V teams
• Provide Data Management services for Healthcare Enterprise Systems modernization projects.
• Responsible for modeling Clinical Administration (Encounter, Admission, Inpatient, Service Delivery, Clinical Service Procedure), Pharmacy FDB (NDC codes, Therapeutic Classification, etc.), Pharmacy McKesson Spend (Price, Product, Cost, AWP, AR/AP, FDB GCNSEQNO, HL7, X12, NIEM, Thera Class, Vendor, Invoicing, Purchases), Meditech Formulary and Revenue Cycle Logical Model. IBM Bluemix dashDB, IBM Watson Analytics, Metrics, KPI's, MDM domains, model business vocabularies, taxonomies, ontologies, semantic web.
• Utilizing DAMA DMBOK.
• Integrating healthcare data from multiple sources and present in atomic level detail (Inmon model) and in conformed dimensional layer (Kimball model) utilizing IBM Unified Data Model for Healthcare (UDMH- AWM/DWM). Teradata Healthcare Data Modeler- IBM UDMH.
• Design BI Data Integration Architecture CMS MITA 3.0/MMIS, CMS ACO Population Health Management, KLAS framework, CMS/CMMI. Collaborate with Technical and Business SMEs to design the logical data model and physical model Utilize IBM Unified Data Model for Healthcare, IBM InfoSphere Installed ERwin Mart Server/ ERwin Data Modeler Workgroup Edition Estimate Data Integration Project & Support Efforts Manage Offshore team of OBIEE, ODI, Informatica. Utilize DATA VAULT MODELER -HUBS, LINKS, SATELLITES.
• Technical Consulting, Data Integration, Respond to RFIs and prepare Statement of Work for customers. Data Virtualization, (OBIEE) and IBM InfoSphere FastTrack, IBM UDMH data source to AWM/DWM mapping, Data Integration, Oracle MDM, Agile - Kanban boards, JIRA, Trello,Business Intelligence, Enterprise Data Warehouse, Data Mart & EIS/DSS solutions, Oracle 11AS,Oracle 11g, Oracle AIM, Oracle SOA suite, Oracle BPEL, SOAP, UDDI, WSDL, XML, JSON,Teradata, IBM Aginity PureData System for Analytics (Netezza), IBM Aginity for dashDB, IBM Infosphere data architect.

Sr. Principal Consultant

Confidential

Responsibilities:

• Provided ETL design, enterprise architecture, EIM technology recommendations and transition strategies that support the development and implementation of the enterprise data warehouse and associated data marts. Responsible for providing post sales and pre sales to channel partners across EMEA, understand customer requirements and their technical/network infrastructure, customize deployments to meet customer requirements and participate in onsite installation and configuration of End point Data Integration solutions.
• Utilized Requirements Traceability Matrix.
• Design ETL solutions that will resolve client's data integration and business issues, removing all technical objections in the sales cycle, present and demonstrate next generation Data Integration software at all levels from CIO to Technical Administrators, and manage and facilitate. Proof of Concepts.
• Defined and managed project scope, developing project plans, preparing and managing project budgets, determining and assigning resource requirements and identifying and managing project risks. Responsible for Managing, Developing and Implementing Oracle Business Analytic Warehouse, Utilized Data Warehousing Administration Console (DAC) to create DAC repository, Installed Informatic Power Center Client, Informatica Power Center Integration Services.
• Defined database Data Stores and File Formats to allow Business Objects Data Integrator (BODI) 6.0 to connect to the source or target database and files.
• Developed data conversion routines and processes by creating SQL scripts and SQL Server Data Transformation Services (DTS) in SQL Server Integration Services (SSIS).
• Developed data lineage reports showing source systems, when updated, how metrics were calculated, filters applied, etc.
• Responsible for Identifying sources of master data, and the producers and consumers of the master data, collecting and analyzing metadata for the master data, appoint data stewards, implementing a data-governance program, and documenting requirements, process flows, system flows.

Technical Consulting Manager

Confidential

Responsibilities:

• Lead implementation of the Oracle Data Governance / Siebel UCM policies, design master data, metadata, MDM strategy and Data Quality Standard.
• Provided Oracle BI product pre - sales and post-sales,, mentoring and consulting services to clients for our Practice Managers as part of the Oracle Consulting Core Technology Business Intelligence and Oracle Applications 11i group.
• Responsible for OBIEE BI Server, OBIEE Answers, OBIEE Dashboards, and OBIEE Delivers pre-sales technical support for the Oracle Sales Teams, enterprise integration solutions identification, design, performing Proof of Concepts (POC), developing Oracle data integration solutions in multiple technological platform, conducting project planning and JAD sessions, track project plans, engagement closing, high-level project management, staffing, managing multiple projects, practice leadership, and individual management. Logical and Physical Data Modeling using Designer 2000, Identify key resources and skillsets for OBIEE implementation project.
• Performing ETL functions on data stores to Oracle OLAP Server.