SUMMARY:

• Conceived, developed and taught technical classes in Data Analysis, gathering and techniques; Business Requirements, recognizing and gathering; and Systems Development Methodologies.
• Used logical data analysis and Analyzed business processes to design databases for Logistics, Purchasing, International banking, Personal Lines Insurance Underwriting, Utility Billing (Customer Account), Mutual Funds, Marketing and Sales Analysis, Payment Processing, and Customer for both OLTP and OLAP systems. Also analyzed and designed DW Databases using Star Schema and Snowflake disciplines.
• Managed Vendor Relationships for Data analysis, Data Profiling, and Metadata Repository Tools.
• Managed eight (8) FTE’s in a DA Organization: Rated performance, assigned work tasks, accessed merit increases, monitored progress, and managed departmental budget.
• Accepted the challenge to setup and organize a Data Administration function for a credit card payment processing concern. Developed the charter, defined the roles and responsibilities, Handled Staffing concerns, and selected tools to support the department. Mentored employees on techniques.
• Functioned as a Team Lead for a group of programmer analysts working on a message handling system for International Banking.
• Functioned as Lead to develop an on - line claims gathering and adjudication for Health Insurance Company.
• Functioned as a lead to conceive, analyze, develop and implement a data Warehouse for a large Manufacturing Company.
• Lead, organized and conducted a steering committee to determine an OLAP tool as standard.
• Researched, analyzed and wrote a BI architecture strategy and plan for an insurance concern.
• Functioned as an individual contributor and team player in various application Development projects.
• Developed enterprise architecture for Personal Lines Insurance, Discount Brokerage Company, Credit Card Processing, and Retailer.
• Performed research and analysis to recommend tools, such as ETL, Data Analysis and DBMS’s.
• Performed an analysis of existing data architecture and made recommendations for some quick easy fixes, and then developed a long term strategy along with new data architecture.
• Planned, organized, and conducted JAD meetings to gather business requirements, process analysis and Logical Data Models.
• Performed research for ‘governance’ and applied that research to compile a data governance strategy for a financial institution.
• Compiled, tested and implemented a governance strategy for an XML interfacing model for a mortgage company.

TECHNICAL SKILLS:

Hardware: IBM MainFrames; IBM PC; Amdahl MainFrames; PC compatibles; MAC s, SunSolaris.

Software: COBOL, IMS DB/DC, CICS, TSO/SPF, VM/CMS, MVS, NT, .NET, UNIX, SAS, DB2, UDB, ORACLE (9I, 10G), Teradata DBC, Windows, MS Office tools (project manager product), VISIO, MS Access, SQL SERVER. ABT Project Work Bench, XML (academic knowledge), NIKU, Hyperion EssBase, ALLFusion Erwin, Embarcadero ER Studio, EVOKE, Rational Rose 98, Platinum Repository MVS and CA ALLFUSION Repository, ETI, Informatica, Crystal Reports, Hyperion Brio, SDP, IDEF Methodology, TOAD, SQL, SDLC, Rational Unified Process (academic knowledge) Business Objects (academic knowledge), Informatica (academic knowledge).

PROFESSIONAL EXPERIENCE:

Confidential

Enterprise DB Architect / DB Change Manager

Responsibilities:

• Review and learn the ‘as is’ architecture
• Make recommendations to improve architecture
• Review and approve all DB changes and additions
• Manage the change process for DB changes
• Approve all data corrections or additions of data values
• An active member of DB Switch process
• Coordinate all DB changes, additions with DW partners
• Responsible for DB pages in Confluence (Wiki) documentation
• Work with Data Security to ensure integrity and safety of sensitive data
• Downsized and Outsourced
• Teaching computer skills to seniors
• Reading, studying Data Warehousing Practices and Techniques
• Searching for employment

Confidential

Sr. Data Architect

Responsibilities:

• Responsible for Star Schema Data Model and requirements
• Physical Design of DataBase Schemas
• Mapping requirements
• Review and critique and refine Data Models
• Review, Develop Data Administration Standards and Governance
• Compile data Management Governance Strategy
• Market and Promote Data Administration and Governance
• Plan Governance Implementation
• Set-up the Data Administration and Governance Functions
• Function as a lead and mentor to other DA’s
• Created Logical Data Model for Corporate Action System; evaluated package software; determined architecture of package within environment; made recommendation to purchase; planned transition and implementation of software
• Countrywide Home Loans, VP Data Architecture (FTE)
• Managed Data Architecture group supporting the development of a Loan Organization and Fulfillment system in .NET, ORACLE 11G, XML
• Managed three FTE’s with various skills for assignments, reviews, etc.
• Designed and implemented a metadata repository to support the management of the metadata for the application
• Compiled a governance strategy for data within and XML Loanfile model
• Implemented the governance strategy
• Managing an XML file structure that is the communication mechanism between applications and services for an SOA system development
• Developing, refining and managing the logical model in ER Studio
• In charge of creating first cut physical schema.
• Reviewed Informatica against business needs and recommended to purchase
• High level project planning and coordination for the entire project
• Developing strategy for Data Warehouse once OLTP system is implemented.

Genentech

Sr. Consulting Architect

Responsibilities:

• Functioning as Enterprise Data Architect for Business Intelligence.(Independent Consultant)
• Conducting DW reviews and assessing current architecture.
• Writing and recommending future architecture and migration plans for BI.
• Working with team to create charter for the BI organization.
• Functioning as Data Architect for the financial and sales/ marketing data warehouses. (UNIX/ Sun Solaris, HP9000)
• Functioning as a working member of a corporate data standardization and data governance project.
• Consulting with team to compile, agree and enforce data standards and procedures.

Confidential

Senior Manager (FTE)

Responsibilities:

• Analyzed, developed and implemented a metadata solution for Confidential insurance systems development.
• Functioned as an Enterprise Data Architect for OLTP and OLAP systems development and enhancements.
• Research, analyze, business requirements for ETL, Data Analysis and DBMS Tools and recommend a set for purchase.
• Planned the rollout of the ETL Tool and the Data Analysis Tools.
• Architected and designed a solution from MVS to Middleware WBI to Open Systems for data movement and storage for messages and system integration.
• Functioned as a data architect consultant for Data Warehouse development and the creation and acceptance of DW Charter. (UNIX/ Sun Solaris)
• Created, marketed and implemented a Data Management Charter for the organization.
• Began to research the topic of ‘governance’ and its place within a Data organization.
• Created, marketed and implemented guiding principles and data standards for the Data Management organization.
• Reviewed Informatica against business needs and recommended to purchase.
• Functioned as an Enterprise Data Architect; performing analysis to understand the present data architecture of an old established insurance concern. Developed a graphic of that architecture along with a current assessment. Proposed future data architecture. Created a migration plan from old to new architecture.
• Evaluated DBMS’s, data analysis tools, ETL’s, data cleansing tools and others and making a recommendation for the best tools for Confidential to purchase and implement.
• Evaluated the current data warehouse architecture; identifying design issues, concerns, etc. Made a recommendation for future Data Warehouse/ Data Mart architecture.
• Assessed the CRM issues in current state and evaluating the SIEBEL package and how to work that product into the architecture.
• Assessed the Claims system and created Logical and Physical Model.
• Recommended the creation of an ODS for customer database in order to move to CRM on SIEBEL package.
• Planned, architected, designed, and implemented a central metadata repository (Platinum Open Enterprise Edition) for the corporation. Developed the metadata strategy, vision, and project plan for repository.
• Manage a staff of eight Data Architects and OLAP professionals. Set priorities and assign tasks for each architect. Conduct performance reviews; career planning and salary increases for staff. Manage and produce cost center budget.
• Coordinate work and project assignments between various development functions and groups. Partner with DBA Managers to coordinate DA tasks with DBA tasks.
• Develop charter, standards and train staff and other departments with data analysis and architecture philosophies using EVOKE tools, Platinum Repository (MVS and OEE), ERWIN data modeling tool, and OLAP MicroStrategy tools and COGNOS.
• Lead the effort to install COGNOS (function used was to create cubes from database that was being reported against from the MicroStrategy reports and distribute cubes to COGNOS users at the desktop level)
• Participated as a lead architect and a management consultant in the re-design and development of a Risk Management Data Warehouse. Played a major part in the DW architecture, testing and implementation. Created, developed, marketed, and implemented a testing process for the DW project. Managed the migration of MicroStrategy upgrade.
• Manage the corporate repository, Platinum MVS and OEE. Developed a GUI user friendly interface to the corporate repository using Visual Basic Client Server on SQL Server platform. Converting to web enabled platform-using JAVA. Successfully deployed the repository interface.
• Responsible for applications development in the use of ERWIN and other data management tools.
• Implement the Migration Architect Tool from Evoke Software. Develop and mentoring to roll-out the tool for application support.
• Participated in design of Risk Management Data Warehouse.
• Helped conceive and create an international information council to address, communicate and resolve data issues and concerns for the whole of Visa International.