Summary

Expert in Enterprise Information Management, specializing in Oracle. Expertise in Application and Data Integration, Master Data Management, Big Data, designing and developing large scale distributed data warehouse applications using Apache Hadoop framework, 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, HIT, HIE, HIX, 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 , Cloud Computing, 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. Over 15 years' experience in the IT field and ITIL Foundation Certified. Major clients includes and not limited to L.A. Times, Kaiser Permanente, Genband, BDM Federal, Mattel, FRB, Rockwell, GenesysLab, Sierra Atlantic, Infosys, United Health Group, Walgreen, City of Phoenix, IBM, Sysco, Oracle, Hughes Space and Communications, TRW, Boeing, EPA, City of Philadelphia, Baan, Ascension Health, Kohl's, American Airlines, JPMC, Orange County Transportation Authority.

SKILLS HIGHLIGHT

• Methodology: OracleAIM / RapidInstall, Siebel eRoadmap, Federal Enterprise Architecture Framework, Zachman Framework / TEAF.
• Operating Systems: UNIX, MS WINDOWS, IBM OS/390, LAMP, Open Solaris 2009.06, ComStar, IBM MVS/ESA, CICS/ESA, TSO, ISPF/SPUFI, DEC VAX/VMS, RED HAT LINUX, SUN Crossbow, KVM LINUX, VMware Fusion.
• Languages: SQL, PL/SQL, IIS, JSP, Servlets, HTML, XML, Java, XSLT, Ruby, Groovy, CGI, Semantic Web, Perl, RDF/XML, N3, Turtle, N-Triples, RDFS, OWL, R, SAS and WPS.
• Databases: Oracle 11g/10g/9i/8i,MS SQL 2000/2005, MS SQL 2008, SYBASE, DB2 Universal Database, NoSQL databases e.g. Apache Cassandra, MongoDB, HBase high performance databases e.g. Netezza, Vertica, VectorWise, Infobright .
• Data Modeling, Data Model Interchange Standards, BPM: Oracle Designer, Erwin Data Modeler, Rational Rose UML, IBM QMF, IBM ISQL and DB2I, SQL Impact, QUEST DB Tools, Pegasystems Smart BPM, Oracle Enterprise Manager, Lombardi Teamworks, C2IEDM, GJXDM, JC3IEDM, GFM, DDMS, NIEM, and NCES.
• Web Services Tools: SOAP, UDDI, AJAX, WSDL, WSIL, XML, BPEL, ECLIPSE JAVA IDE JST/WST Web services.
• Data Virtualization: JBoss MetaMatrix Enterprise Data Services, High-performance computing HPC Cloud Computing, Apache Hadoop, Map Reduce, GRID Computing, HDFS, Composite SW, Oracle Data Services, Hive, HBase, VMware, Cloudera Desktop.
• Cloud Computing: Jaspersoft, Vertica, RightScale, Cloudera, ElectricCloud, Amazon EC2/S3, AWS, 3tera, Appistry, Informatica Cloud, Pentaho, Jaspersoft, Joyent, Hadoop ecosystem, BICloud, CloudShare, GoodData, CohesiveFT, Talend, MPP, SMP, SAN, NAS.
• IT Software Configuration Tools: BMC, Tivoli, HP OpenView, IBM ClearCase, Visual SourceSafe.
• Call Center Solutions: GenesysLab, Rockwell FirstPoint Contact Call Center.
• Web Server: Oracle11g/9iAS/, Oracle WebLogic, IBM WebSphere.
• JAVA IDE: IBM VisualAge for Java, Oracle Jdeveloper, NetBeans, Visual Caf Java, JBuilder, Oracle TopLink.
• ETL-BI Tools: Cognos Impromptu / Powerplay, Crystal Reports, Ab Initio, Oracle Hyperion Essbase Server, MicroStrategy 8 BI, Oracle Business Analytics Warehouse OBAW , data science tools Tableau, Spotfire, Omniscope, QlikView, Netezza Business Objects Data Integrator 6.0/XI, Oracle BI Applications 7.9.5.1 Informatica PowerCenter, Teradata, Greenplum, ODI 10.1.3.5.0, Oracle Warehouse Builder OWB 11g/, OBIEE Plus 10.1.3.4, IBM InfoSphere DataStage and QualityStage, OBIEE 11g, Aster MapReduce DW, DW Administration Console DAC 10.1.3.4, SSIS, SAS ETL Studio.
• CRM: Siebel, Siebel EIM, Siebel eAI, Siebel eScript, Siebel Tools, BaaN SFA, SalesForce, SFDC Appexchange DataLoader EE , SFDC Import Wizard, Apex API, Cast Iron Studio.
• 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, Oracle Customer/Product MDM, SAP NetWeaver MDM, i2 MDM
• EAI: TIBCO, Oracle AQ / Oracle Fusion, IBM MQ, JBoss, Software-as-a-service SaaS integration.

PROJECT EXPERIENCE

Confidential

• Currently involved in designing, developing, and managing BI solutions to meet Communities of interest COI shared data assets services business needs. Provide technical leadership in architecture, design, and implementation to address the federal government's most challenging technology needs. Work closely with clients to identify information exchange needs, key issues, analyze and establish domains, define and model business vocabularies, taxonomies, ontology, semantic web, and schemas, and deliver optimal solution architecture approaches in a Service Oriented Architecture SOA environment. Providing consulting services to healthcare organizations and payers. Create touch points with the customer to ensure the project is going smoothly and expectations are being met. Effectively managing healthcare consulting projects and data sourcing needs for ADT patient demographics and Revenue Cycle Systems patient experience . Develop marketing collateral, case studies for prospects and customers. Source system expertise with EBS/PeopleSoft/JD Edwards. Defining the scope of the Executive Information System EIS to provide dashboards with appropriate. Work with users in defining business requirements for new analytical applications and parallel server databases running on HP Clusters with Massively Parallel Processing MPP . Define requirements for OBIA around Sales, Marketing, Finance, HR, and SCM domain. Responsible for identifying OBIEE dashboards, scorecards, reports, metrics and data sourcing Familiarity with Oracle EBS based BU tools, including and not limited to Daily Business Intelligence, Discoverer, and BI Publisher. Define OBIEE Common Enterprise Information Model for the presentation layer, semantic object layer and physical layer.
• Responsible for working with marketing, sales and delivery teams to further up sell/cross sell Oracle products and creating new opportunities to create new prospects and establish current pipelines. Responsible for Developing Common Enterprise Business Glossary, Designing data models including multi-dimensional data models and star schemas, and modify interfaces, data migration and data mappings. Developing BIG DATA best practices and generally accepted data center principles focusing on data center facility's, infrastructure, Hadoop Distributed File System HDFS , virtualization software and cloud computing.
• Technical Lead to work definition of Vendor Supplier/Oracle EBS R12 Strategy Product Item Master/Oracle EBS R12 and Customer Accounts Receivables/Oracle EBS R12 Hierarchy Definition Master MDM Library, Vendor, and Product Masters Implement Controls and Data Governance. Developed Master Data Management Strategy, Develop MDM Work plan, MDM Project Scope Prioritized Requirements, MDM Interfaces and Data Linkages. Coordinated working sessions w/ BSA's, SME's, and Workstream leads to gather requirements and complete BR030, BP040, MD050, and MD070 deliverables on time.
• Work with the customer, sales team, users, technical architect, and application designers to define the data requirements, conceptual data model, and structure for an integrated EMR/EHR Cloud solution. Created EMR data model to include Customer, Encounter, Insurance, Location, Medical History, Product Services Provider. Defined master data entities around Customer, Provider, Product, and Location.
• Develop data conversion requirements and design the conversion procedures and applications. Facilitate OBIA client workshops for Oracle Financial Analytics, and Oracle HR Analytics, , collaborate with 3rd party vendor and Oracle to develop interfaces. Manage vendor and client relationships. Manage to project schedule and milestones. Strategically designed the information architecture for the application database and data stores, while ensuring high levels of data availability. Created conceptual, logical and physical data base models for application database and data warehouses/marts. Worked closely with report developers and analysts interpreting reporting requirements and collaborating on reporting designs. Coordinated with other technical staff to develop database architectures, ETL standards, and quality assurance policies and processes. Designed and developed ETL processes using DataStage PX EE Server 7.5 under UNIX and Oracle 9i/10g on HP 9000 Enterprise Parallel Server Model 30 with symmetric multiprocessing SMP/NUMA nodes. Provided Consulting, Data Sourcing and Data Architect support for the overall Symphony healthcare data strategy project, including ERP, HR, FIN, MDM, CDM, and Clinical components. Defining the scope, and source data requirements for the Executive Information System EIS to provide dashboards with appropriate Key Performance Indicators KPIs for executive leaders to monitor/run their business. Defined dashboards for the following C-level executives: CEO, CFO, COO, CMO - Chief Medical Officer, CNO - Chief Nursing Officer, CHRO, CSCO. Identified Financial, HR, SCM, Safety, Metrics, Patient Encounter, Facility and Shared Service Data Sources, Data Type, Source Category, Available Level, and Frequency. Developed Data Sourcing Approach, to have all Data be sourced from the System of Record. Understanding of healthcare reimbursement, coding and claims payment methodologies ICD-9/10, CPT/ CPT-4, HCPCS, DRG etc. to identify sourcing needs for MedAssets/CDM Charge Description Master . Completed data sourcing needs for ADT patient demographics , Revenue Cycle Systems patient experience , Integrated Scorecards, Patient Accounting Systems, McKesson Pharmacy Supplier, Hyperion Planning Management metrics, Crowe KPIs. Built Data Dictionary and Source Extract Data Specifications for the above source systems. Developed data models for the current healthcare ERP and Clinical MDM Master Data Management Entities, Master Data Management Strategy, MDM Workplan, Defined Data Governance Process and Implemented Controls around Item, Vendor, Patient Master Data. Involved in the vendor selection process for their EII/EAI/ETL/MDM Enterprise Content Management tools such as WebMethods, Hyperion, JBoss, Oracle, IBM WebSphere MQ Series. Clients include Oracle, Ascension Health, Perot Systems, Infosys, CIGNA, WalGreens, UHG, JP Morgan Chase, FRB,

Confidential

Provided ETL design, architecture, 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. Responsible for implementing and supporting enterprise software products for customers. Created and maintained permissions, role, security for all OLAP, EIS, and ETL OWB3i servers, migrated Oracle Express objects to Oracle 9iOLAP. Development of Ad Hoc Query and OLAP using Oracle Discoverer and Oracle Reports on 9i. Managed BPM utilizing Pegasystems Smart BPM on BEA Liquid Data for WebLogic Server v8.1 in a J2EE environment. Assisted the Master Data Management team with the implementation of Hyperion's Data Relationship Management DRM architecture for the development of Master Data Management Project. 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. Exchanged metadata via CWM interface to Enterprise wide metadata repository. Worked with finance, various business unit representatives and other functional organizations to drive a solution to address managing master data and management reporting. 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.

Confidential

Provided Oracle 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. Clients includes: Cedars Sinai Medical Center, Kaiser Permanente, Countrywide, Dell/MDIS, Siebel CRM and eBusiness Professional services Group, Oracle Worldwide Support, Toyota Motor Sales, Cerner Corporation, PG E , GTE, AT T and Bank of America.

Cedars Sinai Medical Center:

Developed a patient record system to meet the requirements of insurance carriers and health care organizations. The system provides a prescription writer with personal formulary, attached medication instructions, and discharge instructions. The system captures all relevant ICD-9, E M codes, V-codes, and CPT codes. Responsible for managing the implementation of Clinical Support Systems - Medical Records, Central Supply, and Surgery. Developed Oracle reports on Performance by Physician, Physician Utilization, Service Line Profit/Loss Statement and Clinical Utilization. Developed a clinical portal prototype using Oracle9iAS and Oracle9iAS Portal. Developed EDI with NSF format for claims submission.

Kaiser Permanente:

Developed need functional requirement documentation and interfaces to comply with HIPPA Standards. Coordinated with Cerner to build a HIPAA Readiness Self-Assessment Recommended standardized interchange of electronic data for specified administrative and financial transactions. Developed interfaces using Informatica PowerCenter 5 for Oracle and Legacy systems to integrate and protect the security and confidentiality of electronic health information and built a departmental data. Developed HIPPA survey for Administrative Procedures, EDI, Physical Security and Technical Security. Developed a Clinical Data Repository CDR Data Warehousing project to provide a Star-Snowflake schema, detailed facts and dimension tables, creation of Surrogate keys for every join between a fact table and a dimension table, building aggregates, flexible and rapid retrospective view of health-care dimensional and hierarchical data within the KP Health Decision Support System. The objective was to enhance the quality of patient care based on clinical outcomes and longitudinal studies involving care regimens, procedures and practices and provide researchers with a foundation for future patient-care research. CDR DW Project required information from five independent databases to be linked together by medical-record number. In addition, a number of derived values were are also computed to provide summary information for selected data elements.

Confidential

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

• Provided Project Management, Baan Front Office and ERP Systems Integration Consulting, Application roll-out, Systems Integration, Sales and Oracle Data Base Administration and Maintenance Services to clients such as L.A. Times, Mattel, AirTouch, GenesysLab, PG E, GTE, AT T, BDM, Aspen, City of Philadelphia, Florida Power and Light and Meridian Bank. Provided training, coaching and mentoring to customers.
• Managed Baan Front office SFA and SCS Supply Chain Solutions install and DBSync customization modifying Oracle PL/SQL stored procedures and triggers on HP-UX at PG E and GTE and AT T. Performed Baan 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 BAAN 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. Extracted, Cleaned, conducted data profiling and loaded data from multiple sources into Oracle 8 cube on NT 4.0 for Mattel. Developed a datamart using Oracle Data mart Suite 2.6 on Oracle8i/Unix for Mattel. Developed adhoc query using Impromptu tool for Mattel. Used BCP/Unix to download data from VSAM file to Sybase tables for Mattel. Genesys CTI application Integration with Sybase for AirTouch. Designing, developing, supporting JAVA reusable component Applications, EJB Session beans, Entity beans, Message Driven beans . Integrated Genesys CTI Softphone with JAVA, ActiveX, DDE, OLE, OCX, CORBA, TAPI 3.0 for AirTouch. Provided CTI Solutions and Integration on Lucnet, Rockwell, and Nortel PBX/ACD switches. Developed Computer Telephony applications using VB 6.0 for Genesys.

Confidential

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.

Confidential

COBOL programming on IBM/MVS/XA/TSO/SDSF/VSAM, for EDS clients. Coordinated with DEC and IBM vendors for version updates and SCM. Wrote JCL using SYNCSORT for sort/merge programs.