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, MITA Framework, IBM UDMH, FHIM, NIEM, HL7, HIT, 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 clients product questions and prepare and perform detailed POC and product demonstrations.

SKILLS HIGHLIGHT:

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

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, IBM UDMH InfoSphere Data Architect, DAMA DMBOK

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, GitWeb 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, Confidential SFA, SalesForce, SFDC Appexchange DataLoader (EE), SFDC Import Wizard, Apex API.

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

SCM: Manugistics, Confidential 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: Agile - CA Agile Rally DE, Kanban boards, JIRA, 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

Confidential

Responsibilities:

• 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)
• 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 training 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 for Oracle Clients. Provided Oracle BI product pre-sales and post-sales, training, 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.
• Developed High Level Strategy Design utilizing IE methodologies with Need Functional Requirements Analysis, Business Area Analysis with Oracle Designer 2000 data modeling tool.
• Performed Oracle installs on NT/Unix/Solaris and SCO box. Oracle Performance tuning. Developed Systems Architecture for Bell Atlantics Enterprise wide Call Center Application. Developed Crystal Reports from Oracle RDBMS (PL/SQL) using Seagate Crystal Reports 6.0.
• Installation of Genesys CTI DB Oracle Server on UNIX.
• Performed database monitoring and performance tuning on of GENESYS CTI Data Warehouse.

Confidential

Responsibilities:

• Provided Project Management, Confidential Front Office and ERP Systems Integration Consulting, Application roll-out, Systems Integration, Sales and Oracle Data Base Administration and Maintenance Services. Provided training, coaching and mentoring to customers.
• Managed Confidential Front office SFA and SCS (Supply Chain Solutions) install and DBSync customization (modifying Oracle PL/SQL stored procedures and triggers) on HP-UX.
• Performed Confidential ERP 5.0 Implementation on NT Server. Created and maintained detailed work plan; communicated and reviewed work assignments with team; managed day-to-day project activities.
• Managed project scope, including project deliverables, timelines, client responsibilities and expectations, to pre-defined project financials. Work with Confidential software development and management to establish release guidelines and general project plans based on the scope of the release.
• Provided release information to all functional areas.
• Managed beta releases by defining scope of beta testing, preparing beta project plans, managing client expectations, monitoring outcomes, communicating outcomes to the appropriate functional areas and obtaining resources for the internal beta test teams.

Confidential

Responsibilities:

• Performed full life-cycle Implementation of Integral HR and Payroll systems on IBM DB2/ISQL/CICS/ MVS/ESA.
• Tuned performance of problem queries and database issues using TMON/DB2, SPUFI and FileAid-DB2.
• Converted and tested CICS, COBOL, DB2/ISQL, menus, functions, and screens Performed modifications and enhancements to financial systems.
• Created DFD diagrams, building of data repository, and ERD diagrams using ERwin Data Modeler. Programming in Oracle Forms 2.0, Oracle PL/SQL, Oracle SQLRPT, SPSS, SAS on VAX/VMS. Supervised a staff of 7 including Programmers and Operators. Performed Oracle RDBMS full and incremental backups.