Data Project
Resume:
Higgins Lizaso
**** ******* ***** **** **** *** Apt 306 Sunrise, FL 33322 Tel. 516-***-**** – cell; ac1ztv@r.postjobfree.com – email PROFESSIONAL
SUMMARY
Close to 20 years of Information Technology experience in Design and Implementation of Enterprise Data Strategies, Master Data Management programs in an ERP Initiative, OLTP Applications, Data Warehouses
(OLAP), Operational Data Stores and Data Marts in various companies under Insurance (P&C and Healthcare), Financial, Retail and Education.
Designed numerous Data Models at the Conceptual, Logical and Physical states.
If needed and in order to show behavioral changes of an object, designed OO Models such as State Transition Diagram.
Participated and led various Joint Application Development activities such as Business Requirements Gathering and Analysis, Gap Analysis and Model Walkthroughs.
Participated and led numerous projects such as a Legacy System Conversion from DB2 to Oracle using Informatica with over 900 GB of data.
Significant experience interfacing with Senior Management and the Business Community. Has worked with various project teams in parallel and has been involved in enterprise systems solutions and application specific solutions. Promotes a synergistic approach towards solving problems. CERTIFICATIONS Microsoft Dynamics 4.0 for CRM – Installation and Deployment
Microsoft Dynamics 4.0 for CRM – Customization and Configuration TECHNICAL
EXPERTISE
CASE (Data Modeling) Tools: CA Erwin 3.5.1/4.0, Sybase PowerDesigner 12/9/6.1, Embarcadero ER/Studio 7.6, Rational Rose 2001, Oracle Designer/Developer 2000
ETL Tools: Informatica PowerCenter 6.0/4.7, Microsoft DTS
Database Technology: Sybase, Teradata, Oracle 10g/9i/8i/7.3, MS SQL Server 6.5/2000/2005, DB2
Reporting/BI Tools: Business Objects, MicroStrategy, Crystal Reports, Oracle Forms, Oracle Reports
Programming Languages: Oracle PL/SQL, Transact SQL
CRM: Microsoft Dynamics 4.0
Operating Systems: Windows 98/95/NT 4.0 Workstation & Server/2000 Prof. & Server/XP, Unix
Hardware: IBM PC Compatibles, HP 9000 Server, IBM Mainframe Server INFORMATION
TECHNOLOGY
EXPERIENCE
Anthem, Inc. 6/2014 – present
Sr. Solutions Architect – Architecture and Data Governance
Led architectural solution efforts on the following initiatives and other projects: o HCA DW Migration Program (Decomm) – Planned migration of legacy warehouse capabilities into enterprise analytic assets with the overall mission or goal of decommissioning AEDW, L&D/Seniors, LGDW, CRDW, and VA PPR data warehouses o Program Integrity Initiative – With the overall objective of helping stem fraud, waste and abuse driven at the claims, provider and member levels, led and provided solutions for multiple PI projects, e.g., End To End Concept Mgmt Solution, PrePay Claims, Next Generation Big Data Analytics, GBD PI Pharmacy COB, GBD PI Data History 2-4 year, GBD PI Optimization. o Other projects I supported include RHI Care Gap Repository – CTK Project
Maintain active relationships with customers to determine business requirements, leads requirement and design review meetings.
Responsible for participating in all phases of the design and development life cycle of analytic applications and reporting tools, utilizing various BI technology platforms.
Collaborate with engineers for creative ideas for Web portals supporting interactive content, analyzes and classifies complex change request and reviews and evaluates possible enhancements.
Oversee issue resolution and implementation of alternatives across enterprise initiatives.
Accountable for delivery of technology solutions. Address risks and implements contingency plans.
Manage integration requirements and design.
Supervise the preparation of designs and technical and/or functional specifications.
Mentor others on coding standards and performs code reviews.
Supervise others on developing application internals for usability, reliability and scalability requirements.
Ensure system testing is complete, meets the test plan requirements and implemented according to plan.
Provide consultation for integration activities with other IT to ensure successful implementation and support of project efforts.
Assess current status and supports BI planning efforts.
Design and evaluate detailed design components with high-level architecture blue prints for multiple applications.
Higgins Lizaso
9420 Sunrise Lakes Blvd Bldg 121 Apt 306 Sunrise, FL 33322 Tel. 516-***-**** – cell; ac1ztv@r.postjobfree.com – email
Provide guidance on conducting vendor evaluation and provides strategic direction based on evaluations.
Develop Informatica mappings and workflows.
Document business rules and test scenarios.
DDL and DML database scripting for DB objects (tables and triggers) and Reference Data.
Mentor other members of the team.
ABC Disney and NBC Universal – New York City, NY 9/2013 – 6/2014 Sr. Data Architect (Consultant)
Deliver Conceptual, Logical and Physical Data Models for implementation in a Netezza database.
Document Processes in the form of BPM, DFD, Process Flow Diagram.
Document Data Mappings from Source to Landing to Staging to Core DB Layers.
Develop Informatica mappings and workflows.
Document business rules and test scenarios.
DDL and DML database scripting for DB objects (tables and triggers) and Reference Data.
Mentor other members of the team.
DoITT – City Of New York 2/2013 – 9/2013
Sr. Data Architect (Consultant)
Lead and participate in the Analysis, Design and Development for the DEEP (Data Element Exchange Program) project.
Design Data Strategy to allow various city agencies to exchange/share information.
Deliver Conceptual, Logical and Physical Data Models using Erwin.
Document Processes in the form of BPM, DFD, Process Flow Diagram.
Data Mapping of elements from Source to Staging to Target; from and to XML, flat files, relational
Develop Informatica mappings and workflows.
Document business rules and test scenarios.
DDL and DML database scripting for DB objects (tables and triggers) and Reference Data.
Migrate database objects and ETL mappings and workflows from Dev to Test to Stage then Production
Assist with troubleshooting production problems.
Mentor other members of the team.
Kohl’s – Milwaukee, WI 6/2012 – 1/2013
Sr. Data Architect / Project Team Leader (Consultant)
Design and architect enterprise-wide projects for the canonical ODS and EDW in a shared-nothing, MPP Teradata architecture proposing the most viable data architecture solutions and best practices.
Lead and mentor Data Architects and ETL developers on projects and enterprise solutions.
Promoted the use of Trillium to enable integration of Data Quality and MDM into all aspects of Enterprise Solutions especially in the Enterprise Data Warehouse.
Design the future state Data Architecture for the EDW in a shared-nothing, MPP Teradata architecture.
Lead and mentor Data Architects and ETL developers on projects and enterprise solutions.
Maintains and enforces data architecture/administration standards, maintains standardization of column name abbreviations, domains, and attributes, and assists in the evaluation of tools for the support of data modeling and database design.
Aligns data architecture strategy with enterprise architectural strategies and business domain roadmaps.
Performs analysis to identify and help prevent data redundancy across systems by designing canonical structures for data integration and designed for the capture of metadata.
Works with implementation team to ensure smooth implementation, understanding, and troubleshooting of software and ensure resolution of outstanding issues.
Interacts with team members, DBA, and Information Services to ensure accurate identification, definition, and interpretation of data requirements, data models, and database designs
The Hartford – Hartford, CT 1/2011 – 5/2012
Sr. Data Architect / Data Modeler / Project Team Leader (Consultant)
Design the future state Data Architecture for the Finance Transformation (FiT) project. Higgins Lizaso
9420 Sunrise Lakes Blvd Bldg 121 Apt 306 Sunrise, FL 33322 Tel. 516-***-**** – cell; ac1ztv@r.postjobfree.com – email
Define and Design the Best Fit Architectural Framework for the FiT’s Data Acquisition Canonical ODS.
Lead a team of 5 Data Architects in Rationalizing a Bus Matrix of Finance reporting facts/metrics and dimensions; then develop the Conceptual Dimensional Data Models that will drive the FDW design.
Mentor the Data Definitions and Chart of Accounts (Codeblock) workstreams.
Lead a team of Data Architects and Analysts in assessing Source Admin Systems and their capability to provide data to the Canonical ODS that will feed the Financial Data Warehouse and consilidated GL.
Design the Logical and Physical Data Model for the Telephony Architecture Re-engineering project.
Develop an Error Handling Framework for the ETL process around DW/BI.
Develop a Position Paper justifying the need of an Enterprise Data Model and Big Data solutions.
Rationalize redundant data repositories across the company and design for metadata capture.
Headed the Data Quality Track under the CTO to help define the Data Quality Strategy and support Data Governance and MDM.
Designed the Data Quality Framework to establish alignment between the Business and IT.
Promoted the use of Trillium for Data Profiling at various phases of SDLC: analysis, design and implementation.
Analyze Vendor RFPs for potential partnership in Defining the company's Data Strategy.
Mentor other team members in the Data Architecture group. UBS – Wealth Management – Weehawken, NJ 6/2010 – 11/2010 Sr. Data Architect / Data Modeler / Project Leader (Consultant)
Defined the Data Strategy for Wealth Management; components of which included an Operational Strategy, EDW Strategy, Data Quality Strategy, Enterprise Logical Data Model.
Lead a current state data assessment initiative to help define our Data Strategy.
Best-of-breed tool research and POC including DW Appliance (Netezza) and Data Virtualization
(Composite) to supplement a Sybase and Oracle RDBMS environment.
Define BI / Reporting Strategy; Evaluate whether to retire Actuate or expand the use of Cognos.
Assess the current state and define the target state of the Enterprise Data Warehoue.
Assess the completeness of the Enterprise Data Model; how much of it drives the business. Assess the gap between physical tables and the EDM.
Data Modeling (Conceptual, Logical and Physical Design); Maintining over 75 tables/entities.
Provide guidance and leadership to other team members. Emblem Health (formerly GHI & HIP) – New York City, NY 9/2008 – 5/2010 Sr. Data Modeler / Business Analyst / Project Leader (Consultant)
Responsible for Data Modeling and Database Design in SQL Server and Oracle environments.
Responsible for Documenting Business Requirements, managing and mentoring team members, managing schedules, priorities and communicating with upper management regarding status and concerns for the Varicent Sales Performance Management Project.
Provide guidance to technical team members, i.e., DBAs, QA Testers, Client Server Support.
As a result of the merger between GHI and HIP, my main responsibility is the overall architecture concerning the migration of Pharmacy Claims Services from one Pharmacy Claims Processing Vendor to another (PBM Project).
Produced a Data Flow Diagram for the PBM Project depicting: (a) All the various systems involved in this Project, (b) Pre-existing Data Feeds from and to these various systems, (c) PPO and HMO Data Feeds for Phase 1 and Phase 2 of this project, (d) Data Feeds that will be replaced and its corresponding replacement Data Feed.
I am also responsible for gathering, analyzing and documenting requirements for the PBM Project covering: (a) Data Feed conversions and migrations from one vendor to another, (b) Impact Analysis on downstream processes especially reports, and (c) HIPAA data standards are being met.
I work closely with various groups including Business Groups, Development and QA; I call and preside over meetings with members from different teams to facilitate activities or tasks related to the PBM Project.
Other projects in which I play Architect, Analyst and Project Leader roles are: o Varicent Sales Performance Management Project – Implementation of enhancements on a Vendor’s software based on business requirements. Facilitate efforts in the Capacity Study and Planning that will address not only data growth but also the inclusion of data from another business Higgins Lizaso
9420 Sunrise Lakes Blvd Bldg 121 Apt 306 Sunrise, FL 33322 Tel. 516-***-**** – cell; ac1ztv@r.postjobfree.com – email area. For this effort, I developed and provided test data that mimics said growth and data inclusion. I also suggested helpful statistics that need to be gathered and documented as part of the study. o ePrescribing – New web application allowing electronic prescriptions created and sent directly to the pharmacy. I am responsible for leading the effort towards the SureScripts’ certification of Emblem’s ePrescribing application. This includes analysis, issue resolution, organizing and leading meetings, managing and assigning tasks.
AXIS Capital Insurance Company, NYC, NY 4/2008 – 7/2008 Sr. Data Architect (Consultant)
Provided Conceptual, Logical and Physical data models using ER/Studio.
Re-designed an existing SQL Server Broker Database to persist correct Broker Hierarchy relationship.
Gathered requirements through user interviews and model walk-through in a JAD format.
Provided the ETL Team with data mappings, cleansing and transformation rules.
Facilitate and lead an Enterprise-wide Data Strategy and MDM which includes implementing an Insurance industry accepted Enterprise Data Model driven from conceptual and logical models (over 75 entities/tables).
Re-designed the Data Warehouse and implement it in MS SQL Server.
Documented Naming Standards and Best Practices for the Data Architecture Group. GalaxE Solutions - Somerset, NJ 1/2008 – 4/2008
Sr. Data Architect / Project Manager (Consultant)
Provide Conceptual, Logical and Physical data models using Erwin.
Responsible for Database Design and Data Architecture in both SQL Server and Oracle.
Responsible for both Transactional and Data Warehouse Design in both SQL Server and Oracle.
Leads and participates in JAD sessions and requirements gathering.
Manages project priorities according to the project plan.
Helps resolve project problems and conflicts; escalates concerns or issues when needed.
Ensures that the project plan is developed, maintained and is up-to-date.
Provide the necessary resources to support the project. Steve and Barry’s – Port Washington, NY 3/2007 – 12/2007 Sr. Data Architect
Conceptual, Logical and Physical Data Modeling using Sybase PowerDesigner 12 and Erwin.
Design and Lead a Customer Data Integration project sponsored by Sales and Marketing to combine various customer information from S&B’s various customer data capture points, i.e., websites, spreadsheets.
Key member of the TSO (Technical Support Organization) overseeing the SAP implementation.
Spearheaded SAP's POS implementation by providing Functional and Technical Specifications for the Development Team.
Assisted Developers in T-SQL code development to meet critical deadlines for SAP’s Point-Of-Sale implementation.
Spearheaded SAP MDM efforts; coordinate Legacy-to-SAP conversion activities; Profiling of Data for MDM definition and rollout.
Conduct research, analysis and selection of the latest and emerging best of breed tools and technologies that can boost productivity optimize cost effectiveness.
Responsible for Database Design in SQL Server 2000, 2005 and Oracle environments.
Document standards and best practices.
Mentored Business Systems Analysts especially on Analysis Use Cases.
Re-designed the existing Sales and Reporting DW starting with the identification of conforming dimensions.
Propose solutions for integrating applications that share common processes.
Map-out the company's Business Information Model that reflect the company’s business strategy and streamline the company’s enterprise systems and data architecture.
Produce technical specifications for code development. Higgins Lizaso
9420 Sunrise Lakes Blvd Bldg 121 Apt 306 Sunrise, FL 33322 Tel. 516-***-**** – cell; ac1ztv@r.postjobfree.com – email
T-SQL development and code review.
Universal Technologies – Department of Education (Client in Brooklyn, NY) 9/2006 – 3/2007 Sr. Data Modeler / Consultant
Logical Data Modeling and Physical Modeling using Erwin
Responsible for Database Design in an MS SQL Server 2000 environment.
Document standards and best practices.
SQL and T-SQL code review.
Re-architecting ODS and DW for Special Education Component project. CCH-LIS, Inc., NY, NY (div. of Wolters Kluwer) – ENTERPRISE DATABASE SYSTEMS Sr. Data Architect / Lead Informatica Developer and Administrator / DBA 9/2001 – 6/27/2006
Logical Data Modeling and Physical Modeling using Sybase PowerDesigner v.9.
Extract, Transform and Load data among various sources/targets for Data Migration and other ETL needs.
Install upgrades and patches for Informatica PowerCenter 7; Responsible for upgrade from ver. 5.2, 6.1, 7.0.
Responsible for data migration, data integration and other ETL process using Informatica versions 6 & 7.
Responsible for converting over 200GB of legacy data from DB2 to Oracle using Informatica’s PowerCenter.
Mentor or guide in-house Informatica PowerCenter users.
Author Object-Oriented Analysis Use Cases.
Responsible for Database Design, Administration and Tuning for Oracle 9i and MS SQL Server 2000.
Participated in the design and implementation of High-Availability System Architectures focusing on redundant system clustering and data replication.
Document standards and/or process guidelines for best practices.
Perform data and code migration between Oracle and SQL Server databases.
SQL, PL/SQL and T-SQL code review.
MARSH, INC. 1 WTC, NY – DATA ARCHITECTURE
Sr. Analyst / Data Modeler 6/2000 – 9/2001
Object-Oriented Analysis and Modeling using Rational Rose 2001.
Relational database design (logical and physical) in Oracle and SQL Server environments.
Facilitate a project's transition from OO analysis and design to relational database implementation.
Metadata Repository Administration using Informatica’s PowerMart. MERRILL LYNCH, NY, NY – PRIVATE CLIENT ARCHITECTURE Sr. Analyst / Data Modeler 6/1997 – 5/2000
Design Relational Databases from inception; Perform conceptual, logical and physical database design for new project development as well as reverse engineering. Projects include Mutual Fund Reimbursement Tracking System, Management Consolidation System, Application Inventory Management System, Retention Management System, Global Headcount Tracking System, Human Resources Data Warehouse, SMDB & FTI’s GFDM Gap Analysis, HRDB & PeopleSoft Gap Analysis.
Design Dimensional Data Models for Human Resources Data Mart Applications.
Integrate functions from H.R.’s Legacy Database and PeopleSoft into H.R.’s Decision Support Environment.
Facilitate and/or participate in H.R.’s Data Warehouse Joint Application Development sessions.
Use Function Hierarchy Diagrams and Data Flow Diagrams to model business functions and processes; Facilitate in generating CRUD matrixes.
Participated in evaluating CASE tools, Model Repository Management tools, ETL and OLAP tools.
Designed Human Resource Total Content Model (HR Enterprise Model).
Developed Architectural Framework for Information Asset Management Application Development in accordance with Merrill Lynch Project Process.
Responsible for Data Modeling and Database Design in SQL Server, Oracle and Sybase environments. NEWBRIDGE COMMUNICATIONS, Inc., NY, NY (currently known as Bookspan, formerly Doubleday Direct) Programmer/Analyst 2/1997 - 5/1997
Higgins Lizaso
9420 Sunrise Lakes Blvd Bldg 121 Apt 306 Sunrise, FL 33322 Tel. 516-***-**** – cell; ac1ztv@r.postjobfree.com – email
Designed relational databases from inception using Oracle Designer/2000. Use Entity Relational Diagramming methods to outline the Logical Data Model. Forward engineered to generate the physical database schema.
Reverse-engineered legacy metadata using Designer 2000’s Table to Entity Retrofit utility.
Programmed stored procedures using PL/SQL; Developed forms and reports using Developer 2000.
Organized and presided over JAD meetings; Create Business Process Models and Data Flow Diagrams.
Researched on Inventory Management software packages to replace the existing legacy system.
Developed applications using MS Access.
ANTARES ITI, Hauppauge, NY
Programmer/Analyst 9/1996 - 2/1997
Installed Windows NT 4.0 server; Set-up the server on a domain; Created user accounts and privileges.
Installed MS SQL Server on Windows NT 4.0 Operating System. Using Enterprise Manager, created database devices for data and log transactions. After creating databases, gave users permission to access databases and grant rights or privileges.
Designed relational databases from inception using the ERwin CASE tool. Used Entity Relational Diagramming methods to outline the Logical Data Model. Synchronized database schema with the physical design model.
Initiated Bulk Copy Procedures to populate database tables. Used MS Access also to export smaller data files to external files or database.
Helped maintain an Oracle RDBMS account; create stored procedures using PL/SQL. Maintained a SQL Server database; created stored procedures using Transact/SQL.
Generated front-end reports using Crystal Reports Professional 5.0 and MS Access.
Created ad hoc queries in Oracle SQL+, MS SQL Server, and MS Access. JONES LANG WOOTTON, NY, NY
Database Consultant 7/1996 - 8/1996
* Database design and maintenance using MS Access; Summary status reporting using Access and Excel. ADVANCED COLUMBIA UNIVERSITY, NY, NY
PROFESSIONAL Computer Technology & Applications Program 1/1996 - 8/1996 TRAINING Major in Relational Database & Structured Design
* Operating Systems Fundamentals * Oracle Server Technology
* Structured Programming and Introduction to UNIX * Database Specification & Design
* Oracle SQL, PL/SQL, & Stored Procedures * Oracle Developer 2000
* Systems Development and Structured Analysis
UNITEK EDUCATION, Fremont, CA
Microsoft Dynamics CRM 4.0 Readiness Boot Camp 4/2008
* Installation and Deployment
* Application
* Customization and Configuration
COMPUTER
COURSES/
SEMINARS/
WORKSHOPS
* PeopleSoft PeopleTools I release 7.5
* Ralph Kimball’s Data Warehousing In Depth
7/99
* Advanced Data Modeling and Business Rules
* Data Warehouse and Multi-Dimensional Design
* Advanced Dimensional Modeling Topics
* Business Intelligence Solutions - Financial
Services
* The Microsoft Repository – Intro. &
Overview
* Database Design (CBT)
* Relational Principles (CBT)
* Designer/2000: System Modeling and
Tools
* OO Analysis
* Informatica PowerCenter / PowerMart
ENGINEERING LIVERPOOL INDUSTRIES, INC., Brooklyn, NY EXPERIENCE Quality Assurance Manager 11/1994 - 9/1995
Supervised Quality Assurance and Shipping Departments.
Interfaced with customers and suppliers on quality-related issues.
Worked closely with other departments in providing production planning and support.
Established a Vendor Rating System for quality and on-time delivery performance using MS Access.
Gathered & analyzed Costs of Quality as a vehicle towards Total Quality Management utilizing MS Excel. Higgins Lizaso
9420 Sunrise Lakes Blvd Bldg 121 Apt 306 Sunrise, FL 33322 Tel. 516-***-**** – cell; ac1ztv@r.postjobfree.com – email
Installed an IBM/PC in the Shipping Department with Novell as backend and Fabritrack as front-end.
Improved inventory control of hardware items saving the company at least $50,000.00. ACCO USA (SWINGLINE), INC., Long Island City, NY
Quality Assurance Engineer 10/1991 - 11/1994
Programmed View Engineering’s Voyager 1000 video inspection equipment for automatic inspection of parts dramatically reducing inspection time by at least 90%.
Provided hands-on implementation of SPC and ISO 9001 standards towards certification.
Provided PC-based measurement systems for better analysis and control of product and process quality.
Coordinated and facilitated projects geared towards process improvement. Wire-EDM (CNC) Programmer 1/1990 - 10/1991
Developed machining process or sequence of operations; Created programs using SmartCAM and FAPT application software; Programmed and set-up wire Electrical Discharge Machines (EDM) using Fanuc and Mitsubishi controls.
INTEGRATED MICROELECTRONICS, INC. (a division of Advanced Microelectronics, California) Process Quality Engineer 1/1988 - 10/1989
Coordinated company-wide Statistical Process Control (SPC) training and implementation; Reviewed and updated quality methods, procedures and specifications; Conducted internal and external quality audits; Analyzed statistical data and generated quality reports. Process Junior Engineer 12/1986 - 1/1988
Programmed K&S 1470 auto-wirebonders; Analyzed and provided solutions to assembly line problems; Updated process engineering specifications; Provided hands-on technical support to assembly personnel. EDUCATION Bachelor of Science in Mechanical Engineering 11/1985
Contact this candidate