Data Management

R. Michael Levin

**** ********* **.

240-***-**** (cell)

Rockville, MD 20850

*******@*****.***

OBJECTIVE

A challenging full-time position in enterprise systems architecture and project management environments in roles, such as data architect, solution architect, technical lead or development manager in the Washington, DC metropolitan area.

CLEARANCE

Public Trust - active

DoD Secret –inactive (2011)

TECHNICAL SKILLS

Enterprise Architecture

Zachman Framework

DoDAF, TEAF, FEA

Enterprise Architecture Planning

Systems migration, Refurbishment and Replacement (includes systems and database redesign as needed)

Data Strategy

Information Flows

EA Repository

Metadata Repositories

Data Architecture

Implementing a data architecture

Data Analytics

Data Modeling (both enterprise wide and project specific)

oBusiness (conceptual) data modeling

oLogical data modeling

oPhysical data modeling

oTemporal modeling techniques

oModel Management

oCanonical Data Models

oData Model Patterns

oData Warehouse & Data Marts

Data Quality

oData discovery

oData quality assessment and improvement

oSPC for Data Quality

Metadata

Master Data Management

Types of databases

oTransactional

oData Warehouse

oData Mart

oOperational Data Store

oDocument Management

Use of Universal Data Models and Data Model Patterns

DB2, Oracle, SQL-Server

Systems Architecture

Systems Migration

Business Workflow

Business Rules

Process Modeling

Metadata

Situation Analysis

General

JAD Facilitation

Requirements Gathering /Analysis

Project planning

Presentations to executives, and technical staff

Presentations at Professional society meetings and conferences

Coaching and mentoring both management and technical staff

Training

oConceptual and Logical Data Modeling

oTime Varying (Temporal) Database Design & Implementation

oSPC for Data Quality

oInformation Flows

oDimensional Modeling

Tools and Languages

oIBM Rational (Popkin) System Architect

oERwin / BPwin

oER Studio

oPL/SQL

oSAP Business Objects, SAP BW Data Warehousing 3.5

oInformatica 9

PROFESSIONAL SUMMARY

Mr. Levin has over 20 years of experience in many of the significant areas of information technology. He has expertise in Project Management, Technical Leadership, Enterprise Architecture, Data Architecture, Data Administration, Data Quality, Data Modeling, Data Analysis, Process Modeling, Business Rules, Systems Integration, and Systems Migration, Refurbishment, and replacement, ETL development, and SQL tuning and optimization.

He has solid business and technology skills that allow him to work with all levels of management to identify, analyze, and provide IT solutions to business problems.

PROFESSIONAL EXPERIENCE

Principal Solution Architect

CCSi, Rockville, MD

May 2014 to Present

Develop data and reporting requirements for New Core enterprise financial data warehouse, leveraging Oracle database and MicroStrategy BI tool. Develop SOA implementation approach. Evaluate major customer system migration and recommend alternative migration options. Modify and maintain the Data Roadmap. Make recommendations to establish Design Review Board. Develop customer Data Management Plan. Make recommendations to establish Design Review Board. Develop enterprise Data Flow diagrams. Review and recommend improvements of Data Management policies and procedures. Model customer enterprise Data Architecture. Develop Enterprise Architecture Data Path. Develop Data Quality Management Plan. Develop Metadata Management Plan. Develop Data Strategy.

Sr. Data Architect

Citibank, Baltimore, MD

January 2014 to May 2014

Developed an Enterprise Data Strategy. Developed Enterprise data analytics (data warehouse) for personal loans management systems, based on Oracle database. Established Data Governance Council. Developed standard engineering templates for systems integration documentation. Modified and maintained the Data Roadmap. Made recommendations to improve Software Development Lifecycle Process (SDLP). Made recommendations to establish Design Review Board. Started Metadata Management initiative, leveraging AbInitio Metadata Hub tool. Initialized corporate Data Management policies and procedures. Evaluated LoanServe account management and InformEnt data warehousing solutions. Defined data migration and data mapping strategies. Lead data modeling team.

Sr. Data Architect

Lockheed Martin Corporation, Rockville, MD January 2001 to December 2013

Developed an Enterprise Data Strategy. Designed, modeled, and implemented Business Analytics for Supply Chain management, Labor, and AP data marts (Oracle RDBMS and SAP ERP). Designed and developed more than 50 Business Object universes for SWIFT and MARS Ledger financial systems.

Developed a database section of a winning proposal for the Secret Service.

Sr. Database Architect/Data Modeler for COMPASS and Einstein Data Warehouses

Managed design, data modeling and implementation for Data Warehouse program, using SWIFT Ledger system data for 1,200 active users (Oracle RDBMS and COGNOS, Business Objects BI). I played a major part in major re-development of Einstein Project, PO, HR, and other data marts. I designed and implemented complex interfaces with Horizon (EHP), pmLIVE, and other applications, solving very complex data issues relevant to conversion of hierarchical data structures. (Einstein Data Warehouse has 2.5 terabytes of data) Performed data warehouse performance tuning.

This resulted in significant improvement of user analytical capabilities and saved $300,000 in software licensing costs.

ETL Developer. I designed, developed and implemented ETL interfaces for Horizon (EHP) budget and financial forecasting application, using Informatica ETL tool. I provided an operational production support of all loading processes and maintained applicable SEP documentation.

It allowed a timely project delivery and with cost savings.

Sr. System Architect/Team Leader for corporate Enterprise Master Data Management (EMDM). Leading the first production implementation of EMDM for Owego/TSS GEM Phase 1 project. Leaded a team of developers and Hyperion MDM consultant for the Phase 1 implementation.

Leaded a Data Quality RFP effort for the corporate Data Quality service offering. Leaded a team of system engineers, application administrators to evaluate and select a Data Quality vendor as a component of the EMDM as well as a standalone corporate Data Quality service offering. Developed a comprehensive set of Data Profiling/Data Quality requirements. Developed test strategy and case scenarios for the Data Quality testing.

Sr. Data Architect for Corporate Headquarters Data Warehouse – LM Finance. Responsible for technical solution and integration interface between LM Manual Entry application and LM Finance Data Warehouse, utilizing Oracle Application Express and SAP BW tools. Supported development, system integration testing. Responsible for deployment and production support of SAP BW application for corporate financial users.

Sr. Data Architect for corporate Enterprise Master Data Management and Data Quality services.

Implemented and supported corporate Enterprise Master Data Management (EMDM) service offering. Was responsible for successful delivery of a corporate Data Quality service and operational capabilities. Supported business units master data management and data quality implementations for GEM (TSS & SI) and OneAero (LM Aero).

Sr. Data Architect for LM IS&S FCS LDMS proposal. Responsible for architectural approach and technical solution in areas of Business Intelligence (BI) and Reporting, Data Management, Data Quality and Enterprise Metadata Management. I have conducted BI tools, database platform and Data Quality tools trade studies and CAIV analysis. In addition, I provided BOE support for the technical solution.

Sr. Oracle Database Administrator for LM Aero PCMS Dimensions. Responsibilities included, but not limited to Oracle database administration of multiple databases in multi-server UNIX environment. Daily activities consisted of database monitoring. Created multi-database monitoring scripts and status reports that provide comprehensive statistical database health data, applied security patches to multiple databases. Assisted development team in identifying a set of new application development tools, including research of toll capabilities and working combinations. Prepared and submitted to the project management weekly activities status report.

Sr. Data Architect for MS2 CFS Data Warehouse. Responsible for development and implementation of the CFS Data Warehouse data architecture, using data sources from multiple legacy systems and SAP Financials implementation. Assisted in development of strategy for the multiple legacy source systems migration/re-hosting. Developed a long-term DW implementation strategy document for CFS Data Warehouse. Designed a multidimensional data schema for CFS Data Warehouse prototype. Developed an ETL strategy for the CFS Data Warehouse prototype implementation. Assist CFS Data Warehousing prototype team in development tasks.

Sr. Data Architect for TSS SWIM proposal and IRAD. Responsible for database trade study. Developed database trade study requirement document, coordinate vendor presentations and follow up responses to the Database Selection Criteria Requirements document. Assisted with system integration tools trade study. Assisted project management with system integration tool trade study. Developed XML data glossary document to facilitate team understanding of XML technology discussions. Assisted project management in systems integration tools vendor evaluation discussions and assessments.

Sr. Data Architect for US VISIT proposal. Sr. Data Architect on US VISIT proposal for the Department of Homeland Security (former INS division).

Designed and developed conceptual and logical data models, data architecture for a future system. In addition, assisted chief architect with data transition/migration design. Managed multi-vendor Virtual Watch List proof of concept IRAD, leveraging multi-vendor system integration environment. Lead Virtual Watch List (VWL) POC work. Established and maintained multi-vendor environment, including Siebel Systems, IBM and TIBCO delivering a proof of concept system integration solution.

Sr. Data Architect for the Customs eCP (customs modernization) program. Developed the ACE ITDS Conceptual Data Model. Provided data harmonization throughout data requirements of Customs and eight other Participating Government Agencies (PGAs) to optimize data collection and distribution. Mapped consolidated data requirements to the Enterprise Logical Data model. Integrated data findings into metadata repository (logical and physical). Mapped consolidated data requirements to the international data standards and OMB data repositories. Participated in the Database Working Group (DBWG) work to analyze and enhance other tasks deliverables and work products.

Data Architect for LM Aero APMS Dashboard project. Responsible for data modeling task encompassing creation of data models and data dictionaries for multiple schemas in the LM Aero Enterprise Data Warehouse (EDW). Documenting Interface Control Documents (ICDs) for EDW interfaces from multiple source systems. Discovered data model inconsistencies and suggesting schema improvements.

Sr. Database Administrator for the Internal Revenue Service EMS Tier 2 consolidation project. Conducted database system engineering analysis. Developed a database/system migration strategy from a legacy system, based on Informix database into replenished Oracle 9I environment, using advanced data recovery tools, such as Oracle Real Application Cluster (RAC). Administered Oracle database development environment in Oracle 8I/Sun Solaris System 8 combination.

System Architect on U.S. Census systems architecture for the decennial census systems. Collected and gathered information on the census geographical and geo-spatial systems. Utilized enterprise architecture framework techniques for the classification of informational data flows.

Sr. Data Architect (team leader) in GTN21 data mapping project for a transportation logistic system. Mastered logical data model evaluation of three data models. Provided management with data model, data transformation, and validation process improvement recommendations. A successful and timely deliverables led to a multiple extension of a task.

A follow up was a successful win for Lockheed GTN21 Data Warehousing program.

PricewaterhouseCoopers LLP, Rosslyn, VA

November 1998-January 2001

Sr. Oracle database administrator (Aer Lingus Airline, Dublin, Ireland) Designed and implemented physical data models for airline on-line booking and frequent flyer management system (initial rollout for 268,000 users). Provide database administration support and application development utilizing Oracle 8i and Sun Solaris 4.5 environment. Provide significant effort in data migration from a legacy system. Master data encryption using Oracle 8i built-in package. Develop scripts and administer standard BroadVision utilities.

Sr. Oracle database administrator (KPN.com, Nederland) Designed and implemented physical data models for a large e-commerce project (126,000 registered users). Provide database administration support for a project, utilizing Oracle 8i and Sun Solaris environment. Utilize BroadVision tools and utilities in project development.

Data Presentation Team leader. Conducted business and system requirement analysis. Developed a Data Warehouse implementation strategy for the Department of the Treasury and the Department of Veteran Affairs. Developed Data Warehousing tools evaluation/selection deliverable documents for two projects, which later was leveraged in other data warehousing projects. Advised management in technical and organizational aspects of the project.

Sr. Programmer/Analyst. Developed Technical Architecture for the HR Data Warehouse implementation in the IRS (PeopleSoft HRMS environment). Mastered a system architecture configuration for 25,000 system users (140,000 IRS employees).

Qwest Communications International, Arlington, VA

July 1998 to November 1998

Oracle Developer/Application DBA. Developed Data Warehousing for the Billing Management system for the large multi-system long-distance telecommunication company. Developed system requirements for the Data Warehouse component. Designed data models, developed data marts and reports to satisfy customer requirements. Utilized PL/SQL procedures, SQL * Loader, snapshots, and COGNOS (OLAP tool) to migrate data into Oracle 8 environment.

Abacus Technology Corporation, Chevy Chase, MD

December 1997 to July 1998

Sr. Oracle Developer/Lead Programmer. Developed five user interfaces using as a development tool PL/SQL stored procedures, packages, SQL*PLUS scripts, applying built-in packages and Oracle utilities. This system was developed by using Oracle 7.3.3. as an underlying database management system under Windows 95 and Windows NT environment. Oracle Transparent Gateway with SQL Server 6.5, Sybase 11.2, and Oracle 7.3.3. was used as a main tool for data exchange between various systems. The primary development activities involved following: Analysis of system requirements and logical design; Generation of database tables, views, indexes, sequences, clusters, and hash clusters; Test the database tables using SQL data definition statements and data manipulation statements; Design and coding of stored procedures, packages, and triggers, using features such as sub-query, join-query, cursors, and exception handling. Assisted junior programmers in database design and development.

Additional Work Experience

March 1979 to June 1989

Information is available upon request.

EDUCATION AND TRAINING

SAP Business Objects, SAP BW, Ralph Kimball Data Warehousing boot camp, PwC Data Warehousing boot camp, Oracle Advanced Development

Masters (1995) Southeastern University, Washington, DC, Bachelors (1979) State University, Odessa, Ukraine.

PERSONAL

U.S. citizen

References available upon request

Contact this candidate