DATA SCIENTIST Resume Houston, TX - Hire IT People (2024)

SUMMARY:

• I am a results - oriented Information Technology professional with over 20 years of wide-ranging and specialized technical IT experience. I have a Master’s degree in Systems Engineering and Electronic Engineering. I have extensive global experience in the following:
• Enterprise Architecture experience provides a guideline for the development of Data, Application, Business and Technical architectures involving Frameworks, Methodologies, roadmaps, and the preparation of Architectural Decision Rules (TOGAF, Zachman, FEA, Gartner EA, DMR Phoenix EA).
• Major strengths in Enterprise Information/Data Architecture, BI/Data Warehouse Architecture (EDW)
• Extensive OLTP ERD Data Modeling, OLAP Dimensional Data Modeling, and Object-Oriented (UML, RUP) Class/Domain Modeling, Canonical Data Modeling - used 9 Data Modeling Tools

PROFESSIONAL EXPERIENCE:

Confidential

DATA SCIENTIST

Responsibilities:

• Worked in a Data Scientist capacity on Data Analytics, Machine/Deep Learning/Data Mining projects privately.

Confidential

DATA ARCHITECT/DATA MODELER

Responsibilities:

• Data mapping
• Design and development of normalized data models
• Design and development of Multi-Dimensional data models.

Technologies include IBM DB2, Ionosphere Data Architect.

Confidential

DATA SCIENTIST

Responsibilities:

• Worked in a Data Scientist capacity on Data Analytics, Machine/Deep Learning/Data Mining projects privately.

Confidential

SENIOR CONSULTANT

Responsibilities:

• Worked on the following projects:
• Design, Data Architecture, Data Warehousing, Data Modeling (OLTP, OLAP), Technical Support and Project Management
• BI Custom solution for many blue chip customers in the areas of financial services, technology, academia, government, and industry associations using a wide range of company BI products.
• Project Implementation
• Providing auditing services on Data Architecture and Data Modeling issues for the product development area for this consulting/software development company for OLAP4YOU, IT Department Management Framework, and Time Entry Systems applications. Implemented data modeling methodologies and standards. Providing reviews and input for current systems.
• Participating and contributing on Data Science projects in the area of Artificial Intelligence, Machine Learning, Deep Learning, Data Mining etc.
• Providing Architecture consulting and guidance for speciality Data/Information/BI/EDW Architectures and Data Modeling (OLTP/OLAP) documentation and reports for many blue chip customers in the following sectors: financial services, technology, academia, government, and industry associations.

Confidential

DATA ARCHITECT/DATA MODELER

Responsibilities:

• Configuration and Asset Management Project of the corporation’s IT Infrastructure Domain using Remedy/ITIL
• Configuration Management Database (CMDB) Conceptual Data Model
• Data Modeling, Data Architecture and Data Governance in an Agile environment.
• Developed a Configuration Management Database (CMDB) Conceptual Data Model and reports.
• Created about a dozen Subject Area Logical Data Models and about 10 Assets Logical Data Models.
• Created Configuration Item (CI) Relationship and Data Federation Conceptual Data Models and reports.
• Technologies include BMC Remedy V9.1, Optimus, Erwin V 9, Oracle DBMS, MS SQL Server DBMS, AS/400, Agile Methodologies.

Confidential, Houston, TX

EIM SOLUTION ARCHITECT/DATA MODELER/DATA MIGRATION ARCHITECT

Responsibilities:

• Within the Enterprise Architecture domain, I did the strategic Planning for Enterprise Architecture component so that MDM/Data Design Frameworks could be used across the entire enterprise.
• Worked on Creating 3NF(3rd Normal Form) and Multi-dimensional (Star/Snowflake Schema) Data Models (Conceptual Data Models (CDM), Logical Data Models (LDM), Physical Data Models (PDM)) for about a dozen subject areas for I3 Domain Models on the Oracle platform and in the ODS Environment including the following modules: Competency, Sales & Marketing, Job, Operations, HR, and Equipment etc. Generated DDLs to create physical database designs. Produced data dictionary for all the metadata and various other reports.
• Created Master Data Models for domain areas in the MDM Hub arena such as Party, Facility/Asset, Jobs, Well, Rig, Vessel etc., using Sparx Enterprise Architect and ERwin modeling tools.
• Produced a Guideline document for converting UML Class models to ER data models as well for data quality.
• Worked on Data Migration projects from legacy systems to new ERP systems. Created Canonical Data Models to facilitate data integration using SOA *ESB) technologies.
• Technologies included Tibco, ERwin 9.5, Sparx Enterprise Architect, Power Designer, Teradata, SQL Server, Oracle 11, MS SQL Server MDS, MS SQL Server, AS/400, Data Lake, Ab Initio, Hadoop, Datastage, Analytix, IBM Infosphere Information Analyzer, Essbase, SAP PowerDesigner, Toad, SharePoint, SAP, Lawson etc.

Confidential

INFORMATION ARCHITECT

Responsibilities:

• Authoritative Data Sources Framework
• Data Management (EIM)/Data Governance (DG) Framework
• Data Quality (DQ)
• Worked on a Data Management/Data Governance project on Authoritative Data Sources and on their definition, identification, designation, data policies, data standards, and data governance for the subject areas within the Confidential domain. Also developed Conceptual and Logical Data Models for subject areas such as Organization, Services, Assets, etc. using ERwin data modeling tool, while producing many enterprise reports.
• I developed an Authoritative Data Source Management Architecture and a Process Model. Data Quality and Data Governance were the key and essential components of the data management and architecture utilizing data analysis, data profiling and data cleansing functions. Also worked on the Authoritative Data Source Framework, Strategy and Maturity Model. Developed a Data Quality Governance methodology and strategy for the enterprise - produced documentation and reports.
• For the data quality, identified the principles in the Data Quality Lifecycle, developed guidelines for Qualitative Analysis Matrix, identified the Data Quality Dimensions, and Developed structure for capturing data quality metrics and assessment process. For Data Privacy, identified data privacy lifecycle.

Confidential, Houston

ENTERPRISE DATA/INFORMATION ARCHITECT/DATA MODELER/ DTA MIGRATION SPECIALIST

Responsibilities:

• EDW/Business Intelligence (BI) Architectural Methodology/Framework
• Architecture Patterns and Architecture Artifacts, Service Oriented Architecture (SOA)
• MDM Architecture, Data Models, UML, Data Marts, Analytics, Enterprise Content
• Management, Data Mining
• Data Migration Project (Siebel to Informatica MDM (Siperian) using ODS Envoronment
• Data Integration using ESB with Canonical Data Models
• Cloud-based delivery models and capabilities (i.e. IaaS, PaaS, SaaS)
• Data Quality/Data Governance Methodology/Framework, Big Data, Data Lakes
• Worked as Enterprise Data/Information/BI Architect on a suite of global projects in a number of countries. Implemented Information/Data Architecture, Data Architecture, MDM and Integration Architecture (using SOA, Oracle ESB, and Canonical Modeling Technologies). Designed and implemented EDW Architecture based on hybrid Inmon CIF and Kimball Bus Matrix architecture and methodology including designing Data Staging, 3NF Staging, and Data Mart with ETL strategy including data quality, data transformation and cleansing. Designed and created 3NF (3rd Normal Form) logical and physical and multi-dimensional (Star/Snowflake Schemas) logical/physical data models and XML Schemas. Generated DDL to create physical database design. Worked with Micro strategy resource on reporting and analytic delivery. Metadata strategy for business and technical metadata for data modeling, ETL processes and other stages was developed.
• Designed and created Enterprise Conceptual, Logical and Physical 3NF Data Models in conjunction with universal data model patterns for more than a dozen Subject Areas (such as Customer, Product, Agreement etc.) for the entire enterprise and developed Canonical Data Models and database structures for integration of operational, downstream and BI applications leveraging Oracle SOA and OSB ESB, MEGA Suite environment and Informatica MDM (Siperian).
• Worked on a Data Migration project to replace Siebel with Informatica MDM (Siperian)> to replace Siebel. . Designed Data Migration plan, strategy and road-map. Generated XML (XSD). Created Canonical Data Models to facilitate data integration
• Followed Agile Software Development Methodology (Kanban, SCRUM) and Project Methodology (Rally) to make sure that SLA (Service Level Agreement) is met
• Technologies included Agile Project Management, Oracle 10-11g, Informatica for ETL, MicroStrategy for reporting, ERwin and MEGA Database Builder 2009-5-2 ( ) for data/process modeling, Power Designer, Informatica IDQ-IIR for data profiling, Oracle OSB & SQL Developer, Informatica MDM IDD (Siperian), IBM Netezza 6.0.3, DB2 v.10, IBM Infosphere, SQL, Siebel, SFDC, MS Dynamics CRM, AS/400, Hadoop, Data Lake, SharePoint, C/C++, Rally, OE+, Ab Initio, One3, Aloqua, CPQ, CMA, Agile Environment (Rally, Scrum), SAP PowerDesigner

Confidential, New York

EDW ARCHITECT/DATA MODELER

Responsibilities:

• EDW Architecture, BI Framework, Multi-Dimensional Data Modeling
• Catalog Management, Supply Management, Pricing Rebates
• Data Mapping for ETL, BI Reporting(Hyperion Intelligent Designer)
• UML Business Process Modeling, Analytics, Enterprise Content Management
• Worked as an EDW Architect in the BI Division of the company which provided global solutions to projects in countries such as USA, Europe etc., in the areas of BI Framework and EDW Architecture.
• The Operational Systems (Applications) Environment consisted of key ERPs such as Ariba, Carma and SAP mainly for Supply Management, Master Data Management, Pricing, Rebates (VDA), Invoicing and Financial activities in an Agile Environment
• Kimball’s Bus Matrix EDW environment was used not only for Data Marts and BI Reporting, but also heavily used for Data Integration, Master Data management, Catalog Management, Product Hierarchies, Pricing etc.
• Designed and developed processes for source data ingestion, transformation, and database loading.
• Technologies included Informatica, PowerCenter Designer (V 8.1), Sybase Power Designer(V15.2), Hyperion Intelligent Designer (BRIO) (V8.5), Oracle Hyperion Essbase MDBMS, SQL, Tableau, Cognos, Business Object (BOBJ), UML, C/C++, Toad for Oracle (V10.5), Oracle 9, 10g, 11g, SQL Server, AS/400, ARIBA, CARMA, SAP, Ab Initio, Teradata

Confidential

GIS DATA ARCHITECT/DATA MODELER

Responsibilities:

• Data Migration Architecture, Strategy and Planning
• Analyzed the Section’s current (As-Is) Data Architecture, Infrastructure, Data Quality, Practices and Resources for Data Management throughout the data life cycle
• Developed a robust data management strategy that reflected the Section’s workflow
• Created Data Subject Areas, high-level Conceptual and Logical 3NF Data Models and high-level To-Be Enterprise Data Architecture using GO-ITS standards for the Spatial Data
• Technologies included ESRI ArcGIS suite of products, Oracle 10g, MS SQL Server 2005, PowerDesigner, Zachman Framework

Confidential

INFORMATION ARCHITECT/DATA MODELER

Responsibilities:

• BI Strategic Information Management System (SIMS)
• Zachman Framework, information architecture artefacts
• Data Modeling (OLTP, OLAP), SQL Reporting
• BI (Business Intelligence)/Enterprise Data Warehouse (EDW)
• ODS Enhancement project
• Worked on Strategic Information Management System (SIMS) project - phase 2 of the data warehouse system to add further enhancements with new Data Marts for college and university information on Unix and Oracle platforms incorporating public safety measures.
• Worked on BI (Business Intelligence)/Enterprise Data Warehouse (EDW) project - another data warehouse for Ontario school information (OnSYS) to lower the granularity of metrics on Unix and Window and DB2 platforms.
• ODS Enhancement project - normalized data storage with aggregated data on UNIX and Oracle platforms for reporting and later on to be tailored to feed the EDW.
• Technologies included Sun Solaris, AIX 5.3, Windows, Oracle 10g, DB2 UDB EEE for AIX, DB2 UDB WSE v8.2 for NT, DB2, ERwin 7.2.5, Informatica Power Center 7.1.2, SQL, Cognos 7.3, Toad for Oracle & DB2.

Confidential

DATA MODELER/INFORMATION ARCHITECT

Responsibilities:

• Replacement of legacy system (ONBIS)
• Zachman Framework, information architecture artefacts
• Government Services Delivery Cluster ( Confidential ) initiated a project to replace its legacy system (ONBIS) used for registration of businesses and corporations using Zachman Enterprise Architecture Framework. The project included the assessment of the existing systems and evaluation of alternative solutions.
• I created and produced the ‘as-is’ Data Architecture and 3NF (3rd Normal Form) Logical Data Models, ‘to-be’ Conceptual/Logical Data Model, Data Migration Architecture and Guidelines, and Data Cleansing Strategy aligning with OPS Information Architecture and GO-ITS standards. I also worked on the process of assessment and evaluation of alternative solutions by using Decision Analysis technique.
• Technologies included AS/400, DB2, IBM Rational Data Architect, Zachman Enterprise Architecture Framework, Toad etc.

Confidential

BI/EDW SOLUTIONS ARCHITECT/DATA MODELER

Responsibilities:

• BI - Data Warehouse Projects, Analytics
• EDW - Data feeds from Enterprise Data Warehouse (EDW) to downstream applications
• EDW - Data Harmonization/De-harmonization, ETL Mapping
• Architecture
• Worked on a number of P&C projects, including data feeds from Enterprise Data Warehouse (EDW) to downstream applications, from new ERP to EDW and from EDW to old ERPs. EDW was based on Kimball’s Methodology.
• Contributed to Information Architecture, Architecture, Data Modeling (Conceptual, Logical, Physical Design) Patterns and Data Standards, as well as BI Framework and EDW Architecture.
• Existing technologies were OPUS, HALCION, CLASSIQUE, ErWin ERX 7.x, I Power Designer, nformatica, SQL, Toad, WebMethods, Ab Initio, BOBJ, Oracle 10g and Oracle Essbase.

Confidential

SR. EDW/BI/DATAWAREHOUSE ARCHITECT/DATA MODELER

Responsibilities:

• New BI/Data Warehousing Architecture, Design
• Implementation of Project
• Designed a new Data Warehouse, BI Framework and Data Marts for Confidential with LAWSON Financials as the source system using Kimball’s methodology based on business requirements.
• Developed Data/Information Architecture, Architecture, Data Standards and Data Models (Conceptual, Logical, Physical Design).
• Created multi-dimensional star-schemas for 3 data marts (Expense, G/L Balance, SL Transaction) for financial analytics from Lawson applying Kimball’s Bus-Matrix methodology, SQL Reporting
• The technologies were Lawson Financials, SQL, ErWin/ERX, Informatica, Oracle 10g.

Confidential, Boston

SR.ENTERPRISE DATA WAREHOUSE ARCHITECT, DATA MODELER

Responsibilities:

• New Data Warehouse Architecture and Design using the Kimball’s Bus Matrix methodology
• Analyzed the current architecture and infrastructure of the staging and data warehouse environments. Data requirements were determined for Ad-hoc reports, Reporting Services reports, and Pro-Clarity reports. Worked on data migration from SQL 2000 to SQL 2005 using an ETL tool MS SSIS.
• Developed a Roadmap and a new Data Warehouse Architecture and Design using the Kimball’s Bus Matrix methodology for the current and future data marts (Revenue, Inventory) with conformed dimensions. Slowly Changing Dimensions were introduced to capture data history. A Star Schema model for Revenue and subsequently a revenue cube were designed and implemented using Silverrun RDM and MS Analysis Services (SSAS) for reporting. Used MS SSIS as an ETL tool
• Technology involved was Microsoft SQL Server 2005, using MS SQL Server Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), Informatica, Biz-Talk, C/C++, .NET Framework and Pro-Clarity. Power Designer was used for data modeling and Hyperion Essbase was used as MDBMS.

Confidential

SR. ENTERPRISE DATA ARCHITECT

Responsibilities:

• ERP Integration/Data Migration Project using Service Oriented Architecture (SOA) technologies, Reverse Engineering Database
• Marketing Automation Project (Aprimo) - Data Architecture and Data Modeling, UML
• Enterprise CDM, LDM, PDM based on Conceptual, Logical, Physical Architecture Design), Analytics, Data Governance (DG)
• Identity Management’ project, Marketing Automation Project (Aprimo), Performance Monitoring
• Business Intelligence (BI) Reporting (using MSAS), Analytics, Enterprise Content Management
• Implemented a Proof of Concept project using Microsoft SSIS, SSAS, SSRS.
• Worked on the implementation of a multimillion dollar ERP Integration Project using SOA technologies for this company which works on global projects across many countries, performing the following functions:
• Worked as an Enterprise Data Architect in the Enterprise Data Architecture domain to facilitate data migration, data integration, and data synchronization of multiple ERP systems and peripheral applications to ensure that SLA (Service Level Agreements) are met.
• Developed Canonical Data Models and XML (XSD Schemas) for the data integration using BOD (OAGIS) models for data integration using ESB Sonic with Service Oriented Architecture (SOA).
• Managed a Proof of Concept project and its application later for MS SQL Server SSIS as an ETL tool.
• Designed Data Migration Framework, Strategy and Road-map and implemented a Data Migration/ Conversion Project with Data Quality (DQX1 - First Logic) from existing ERP (MFG/Pro) to new ERP (Softrax & OpenAccounts) as a Lead Architect and PM using MS Integration Service for ETL. Data governance Framework was used for Data Management. Designed and developed processes for source data ingestion, transformation, and database loading.
• Technologies/ERP involved included UNIX Sun Solaris, PROGRESS DBMS, Oracle 9, 4GL, MFG/Pro, Softrax, OpenAccounts, Lawson, PeopleSoft, SAP, SONIC ESB, OpenEdge, DataDirect, SSIS, CorVu, DQX1(First Logic), ER/Studio, Power Designer, MS Dynamics CRM, MS SQL Serever 2005 (SSIS), Informatica, SQL.

Confidential, Chicago

SR. BI/DATA WAREHOUSE ARCHITECT, DATA MODELER

Responsibilities:

• BI Maturity Assessment and BI Framework project for an Enterprise Data Warehouse.
• Gap Analysis, and Framework and Roadmap
• Providing a Roadmap successfully completed a BI/EDW Maturity Assessment and BI Framework project for Confidential Inc., who was managing several fleets with thousands of vehicles for their clients.
• Main areas of assessment were BI/EDW Requirements, Information Architecture, Technical Architecture, Gap Analysis, and Framework and Roadmap Recommendations.
• Used tools such as Embarcadero ER/Studio for data modeling, Informatica, MS Integration Services (SSIS), Analysis Services (SSAS), Reporting Services SSRS), Panorama and Business Object (BO), MS SQL Server 2005, C/C++, .NET Framework, SQL.

Confidential, Kansas

DATA ARCHITECT, DATA MODELER

Responsibilities:

• Application Integration
• Data Modeling and Database Design
• Data Migration, Data Synchronization, and Data Modeling
• Worked as Data Architect/Data Modeller on an IBM driven global project for the integration of operational applications using Siebel, P2K (Convergys) and other products for Confidential . The activities involved data mapping, data migration, data synchronization, and data modeling.
• Reviewed data models with team for validation of requirements and identify appropriate data sources for database loads and metadata.

Confidential, North Carolina

SR. ENTERPRISE BI/DATA WAREHOUSE ARCHITECT, DATA MODELER

Responsibilities:

• Design, Dimensional Data Modeling Agency Reporting Project Implementation
• Data Architecture and BI Framework Design
• Architectural Decision Rules and Architecture Artifacts
• Data Governance Framework, Policies and procedures and best practices
• Worked in the Enterprise Data Management Group of IS & S division for property and casualty insurance business. Designed, created and implemented Data Architecture, Logical/Physical/Dimensional (Star Schema) and Relational data models for Operational Data Store (ODS), Staging, Data Warehousing, and Data Mart based on Kimball’s Bus Matrix environment using Power Designer and ErWin 4.1.4 on Oracle and DB2 platforms. Hyperion Essbase was used as MDBMS and Informatica was used as an ETL tool.
• Worked on the Design, Dimensional Modeling and Data Mapping of Agency Reporting Data Mart that would provide more than 50 reports using Cognos leveraging the BI Framework. This also included Financial Reporting, Claims Reporting and Internal Agency Reporting projects.

Confidential

DATA ARCHITECT, DATA MODELER

Responsibilities:

• Customer Value Management, Fraud Control, Credit card Marketing Campaign,
• EDW, BI Framework, Architecture Artifacts
• Data Standardization and Centralization
• Worked as a Data Architect/Data Modeller for staging area, data warehouse, and data marts in the Data Management Services Group of this major bank. The subject areas and data marts covered were Credit and Loans, Mortgage, Mechanization, GlobalPlus, Basel Accord Datamart, CorpDB, and others. Kimball Bus Matrix Methodology was employed.
• Created the data model for the Customer Value Management data mart (up and cross selling) and the Customer Knowledge Data Mart (demographics) (3 terabytes).
• Led a project on standardization and centralization of code tables for currencies across DW and DMs.
• The environment was Erwin 4.1.4, Model Manager 4.1.4, IBM UDB EEE Release 7.2 as data warehouse platform on IBM P690 UNIX AIX platform, Ab Initio V2-9-7-17 as the ETL tool, Microstrategy/WebFocus as Reporting tool, SQL.

Confidential, New York

DATA ARCHITECT, DATA MODELER

Responsibilities:

• Confidential .com Project
• Meter Read System
• Requirements, Systems Analysis and Design
• Process models (DFD)
• Performed data architecture/data modeling for the Meter Reads System, for monitoring and accessing the usage on serialized office equipment via the Internet. Translated the business requirements into Process Models, Data Flow Diagrams, State Transition Diagrams and Decomposition diagrams for enabling the preparation of the technical specifications for the development team.
• Provided Data Architecture services for the entire Confidential .Com division and created and maintained the BroadVision Data Models for the various Web Applications using ERwin/ERX 3.5. Maintained the BroadVision repository for source files and schemas. Worked on using a data dictionary for the BroadVision database. Created SQL queries to generate reports for users.

Confidential, New York

SENIOR SOLUTIONS ARCHITECT, PROJECT MANAGER

Responsibilities:

• Data Layer, Service Layer, Business Layer, and the User Interface Layers, Architecture Artifacts
• Worked on an eCommerce project for this chemical manufacturing organization. Assessed the existing Data Layer, Service Layer, Business Layer, and the User Interface Layers. Collected requirements from interviews with Senior Managers. Designed a secured architecture, infrastructure, and environment for intranet and internet access for the deployment of Web Portals on Sun Solaris.
• Delivered the Network Infrastructure Topology, Network Security and Application/Data Architectures. Evaluated Web Portal software from Oracle, Viador, Plumtree, and Top-Tier and the interface with Oracle ERP and other custom applications. Recommended Viador because of its greater security and higher level of customer service.

Confidential

DIRECTOR - APPLICATION DEVELOPMENT/ARCHITECTURE/INTEGRATION, PROJECT MANAGER

Responsibilities:

• Played a Leadership role web based Order Entry application
• Enterprise Architecture
• EDI project
• People Resource Management
• New Release Process Model
• Business Continuity Plan (BCP) project
• Led a team of 30, including Project Managers, Team Leaders, Developers, Business Analysts, QA team, and Data Architects in the delivery of software development with C, PowerBuilder, JAVA, Oracle, AS/400, AIX, Cognos environments for this manufacturer and distributor of financial print products (checks, credit cards) to the banking industry. Specific s included:
• Successfully completed the development of a web based Order Entry application. Participated in the application and data architecture of the system and managed the third party developer. Designed and developed processes for source data ingestion, transformation, and database loading.
• Championed and introduced EDI. Selected EDI*Asset software and streamlined processes with a resulting saving of $120k per year per bank for several major banking clients. Requirements for procurement via RFI then RFP, RFP evaluation
• Sponsored and acted as the Project Manager for the development of a Business Continuity Plan (BCP) project for disaster recovery in collaboration with Ernest & Young.

Confidential

ENTERPRISE DATA/BI ARCHITECT, PROJECT MANAGER

Responsibilities:

• Contributed with third party vendors in the multi-million $ Ontario Government ( Confidential Health) initiative for the development of a unified Information and Technology Architecture based on the Zachman Enterprise Architecture Framework. Completed the logical design phase.
• Provided Technical Support to Sales/Marketing staff for this consulting firm. Introduced a process to manage the response to Request For Proposal (RFP) and eliminated the chances of missing deadlines.

Confidential, Boston

DIRECTOR, ENTERPRISE DATA/BI ARCHITECTURE, PROJECT MANAGER

Responsibilities:

• Played a Leadership Role
• Enterprise Data Architecture/Data Modeling
• Architecture Patterns and Architecture Artifacts
• Data Analysis, Data Quality Data Governance, Internal/External Audit practices.
• Internal/External Audits
• Data Governance, Data Quality Metrics
• Enterprise Data Warehouse (EDW), Enterprise Content Management
• Project Management
• People Management
• Directed a team of 22 employees, including a Data Architect, Data Modelers, Data Administrator, Data Base Administrators, and a Data Warehousing tools expert in the successful delivery of Data Architecture for this major insurance/mutual fund organization. Supported the full technology platform: C/S (VAX/VMS servers with ‘UNIX SUN Solaris’ OS), IBM Mainframe (MVS). The development environment was based on Net-Centric C/S Architecture using ‘Web Server’, Application Server, software, ‘Crystal Reports’, ‘Business Object’, and back-end DBMSs ‘Sybase 11.x’, ‘Oracle 8’, ‘MS SQL Server 7.x’, AS/400, SQL, ‘Informix’. ERwin/ERX was used for data modeling and database design, and Informatica’s ‘PowerMart 4.5’and ‘PowerCenter 1.5’ were used for Data Marts and Data warehousing.

Confidential, Boston

ARCHITECT/DATA MODELER/DATA MANAGEMENT, PROJECT MANAGER

Responsibilities:

• Key Projects:
• Development of Enterprise Architecture (Phoenix) for Property Casualty Insurance, standards and guidelines, best practices, methods, policies and processes.
• Acquisition and installation of hardware and software and Performance Monitoring
• Configuration management
• Data Analysis, Data Quality, Data Modeling, Data Management, and Data Base Administration
• Capability Maturity Model (CMM) project
• Project Management, Tools Evaluation
• Leadership Role, People Management, Vendor Negotiation
• Led a team of up to 12 specialists undertaking a technology evolution for Software Configuration Management, Systems Performance Analysis and Measurement, Data Architecture/Modeling, Database Administration, System Administration for this global software and service company to the Property and Casualty Insurance industry. Specific s included:
• Acquisition and installation of hardware and software for the R&D Division (‘Software Factory’) having requirements for procurement via RFI then RFP, RFP evaluation. Coordinated with other departments.
• Worked on the design and development of a comprehensive Enterprise Architecture (Phoenix Enterprise Architecture) - a two-year project in collaboration with DMR for building software for the Property and Casualty (P&C) insurance industry lifecycle (underwriting, policy, billing, claims & reinsurance). This architecture was based on the Application, Business and Data Architectures key components and the Key subject areas were, Clients, Distributions, Markets, Products, Resources & Risks. Created Conceptual, Logical and Physical Architectural Models. I particpated in the Enterprise Architecture emgagement process.

Confidential

DATA MODELER, DATA ARCHITECT, DBA

Responsibilities:

• ODPP-Ontario Drug Plan Project
• Data Architecture/Data Modeling/DBA
• Worked on a multi-million dollar client/server projects (ODPP-Ontario Drug Plan Project) for the Confidential Health, Ontario. Developed Data Architecture, Logical Data Models and Physical Database Design, and created and maintained Databases on ‘Non-Stop SQL Server’ using ‘ERwin/ERX’ and ‘Excellerator’ CASE tools, incorporating HL7 standards. Made decisions with respect to Databases and resolved any problems relating to data access, performance and security.

Confidential

DATA ARCHITECT/MODELER

Responsibilities:

• Played a leadership role in mentoring Programmers and Business/Systems Analysts to deliver cost-effective systems within AS400 environment to deliver new systems/applications, enhance existing systems/applications and solve problems related to various applications.
• I was responsible administratively for managing, hiring, promoting and career/performance assessment of the group. On some data migration projects I managed a project team of about 20 staff.
• Implemented a number of software applications projects from inception, Analysis, Design, Development to implementation such as Customer Information Management System (CRM), Project Accounting Systems and many others applying structured methodology and techniques.
• Gathered business requirements, performed business and data analysis to produce functional and technical design. Created Data Models and corresponding Process Models (DFD) using Systems Architect tool.
• Also managed leadership of 6 groups of about five staff in each group on Business Process Reengineering of IRG products. Identified bottlenecks, recommended solutions to re-engineer and streamline the business processes, leading towards the attainment of ISO 9001 .
• Technologies included Lansa, System Architect, AS/400 platform, Sybase, SQL, RPG etc.