Data Sql Server

Lana S. Kovacs

**** ***** *****

Freeburg, Il ***43

618-***-****, Cell 618-***-****

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

OBJECTIVE

Experienced Data Architect, Modeler, and business analyst with more than 16

years data centric experience defining, developing, implementing, and

maintaining enterprise architectures for commercial and Federal Customers,

extensive financial experience, seeking to leverage background.

EDUCATION Information Technology, B.S., September 2003

University of Phoenix, Phoenix, AZ

A.A.S. Information Technology,

Minor Accounting

Southwestern Illinois

College, Belleville, IL

2005: Certified Information System Auditor (CISA)

2005: Siebel Analytics Server Architect

2005: Siebel Analytics Overview

2005: JD Edward's One World

2005: Siebel Analytics Data Warehouse Developer

2004: Oracle 10G Administration

ADITIONAL INFORMATION - Top/Secret Security

Clearance

SUMMARY OF QUALIFICATIONS

. Business Technology Analyst for U.S. Bank, with 2 years experience

performing data architecture, application architecture lead, data

conversion, and business requirements lead roles for the compliance

and mortgage loan subject areas. I have proven track record of

tactical planning skills for achieving specified goals for U.S. Bank.

. 10 years Data conversion and system integration between cross platform

architectures, databases, and SAP, JD Edwards, Lawson ERP systems.

Includes midrange, desktop, and mainframe experience.

. IT consultant with 16 years experience consulting with companies such

as AT & T, Humana, Navisys, Maritz, Monsanto, Ralcorp, Magna Bank,

Wells Fargo Advisor's and the U.S. Government.

. Well rounded background in several business sectors including

Accounting, Finance, Investment Management, Trust, Insurance, Real

Estate, Consumer Products, Telecom, and Government.

. Excellent business analysis, requirements definition, and analytical

skills with a strong desire to achieve specified goals. JAD,

waterfall, iterative methodologies.

. 10 years data modeling and data architecture experience including

logical, physical, dimensional, transactional, IDEF1x, IE, and

Star/Snowflake schema definition. Allfusion ErWin, Rational XDE, and

Visio toolsets. Strong SQL skills.

. 16 years DataBase experience using Oracle, DB2, Microsoft SQL Server,

Sybase, MS Access, VSAM and associated toolsets.

. 6 years Data Warehouse experience using Oracle Warehouse Builder,

Siebel Analytics Data Warehouse Builder, PL/SQL, UNIX Shell Scripting

ETL toolsets

02/2010 - Present PROJECT HIRE FOR IT Consulting Companies, St. Louis,

MO

. Data Architect for Brokerage Data Warehouse (BDW) department of labor

(DOL) Project for 5500C compliance of brokerage fee and expense

reporting. Analyzed existing warehouse data structures, warehouse

data, Thompson BETA source system structures, business requirements,

and DOL specifications. Developed an ErWin 7.3 IDEF1x Star conceptual

model, logical model and (assigned) physical (DB2 UDB) data model

entities to meet the data reporting requirements of DOL and integrated

BDW design. Made recommendations for division of physical model work

between architecture team in order to meet aggressive project time

lines. Facilitated JAD sessions for data architecture team, data

analysts, ETL team, and reporting lead. Documented source system and

process loads and transformations for ETL load of tables. Provided

business use cases and examples of data to aid in understanding of

data and processes.

. Data Architect and business analyst for BDW Property/Lease conversion

to SAP interface.

08/2007 - 02/2010 U.S. Bank St. Louis, Mo

. Lead Architect for Acquired Asset Accounting (ALIAS) vendor fork lift

project and Long Term Solution replacement. Prepared Arch 1 review

material, Arch 2 Waiver, and Information Security Exception Request

and collaborated with U.S. Bank infrastructure technology groups and

Vendor technology groups to achieve aggressive project deadlines for

the vendor fork lift project. After the system was integrated into the

U.S. Bank infrastructure, performed a detailed analysis of SQL Server

2005 data structures, scripts, and SSIS packages to understand the

operational aspects of the ALIAS system. Documented the Alias data

base using ErWin 7.3. Made architectural recommendations for bringing

the system into compliance with U.S. Bank infrastructure standards.

. Data Architect for Mortgage Office of Controller of the Currency Data

Collection (OCC) Project for Loss Mitigation Loan-Level Data

Collection. Gathered requirements from business line and development

team to develop an ErWin 7.2 logical and physical (Oracle 9i) data

warehouse model to meet the data extraction requirements of McDash

Analytics, a third party service provider of U.S. Bank mortgage.

Generated the physical database DDL.

. Data architect responsible for upgrade of EIS data models from ErWin

4.5 to ErWin 7.2 and 7.3.

. Data architect assigned to Meta Data Management development project.

Participated in team walkthroughs of metadata flows for ATM, EDW, IDW,

data warehouses and CAR OLTP application. Implemented the use of

importing Cobol mainframe copybooks into Erwin for source data to

improve productivity by eliminating the need to redundantly code

entity definitions. Implemented the use of data definitions within the

ERwin model to streamline processes related to the use of multiple

spreadsheets for metadata. Used Erwin as the centralized data

repository for OCC metadata in preparation for Metadata enhancement

project and ODBC features in Erwin 7.3. Tested export of Erwin

metadata to spreadsheets for backup process in case the Metadata

project design required only spreadsheets. Developed the Glossary of

Terminology document which defined definitions for the team to use in

development of the Meta Data Management Application (defined business

rule, default value, edit rule, validation rule, transformation rule,

lookup rule, error rule, etc).

. Data Architect responsible for design of Centralized Application

Respository (CAR) for GLBA, PCI, and SOXS compliance project. Gathered

requirements and created application Functional and Non-Functional

requirements documents, Solution Architect, Business Rules and Use

Case documents. Responsible for development of ErWin 4.5 logical and

physical data model for Sql Server 2005 and facilitation of data model

walkthroughs. Generated the physical database DDL. Consultant for data

analyst team converting data from spreadsheets to CAR Sql Server 2005.

. As a member of the Business Architecture team, best practice

consultant in design meetings for the Integrated Data Warehouse (IDW)

DB2 and Informatica ETL implementation.

. Significant contributor to GLBA, PCI, and SOXS compliance project for

CAR and Archer applications. Requirements lead and data architect for

CAR, wrote architecture and design documents, communicated technical,

vision, and design objectives to management.

. Consultant responsible for analysis of source system repositories for

conversion into a consolidated centralized application inventory (CAR)

database. Analyzed OPAS (change management Oracle DB), LCM

(workstation configuration management SQL Server DB), SID(mid-tier

configuration management SQL Server DB), Risk Navigator(SOXS

compliance SQL Server DB), and Athens(GLBA and PCI compliance SQL

Server DB) databases. Created a source data findings document which

document the analysis of the source system repositories and provided

best practice recommendations for the conversion of the five databases

into a centralized database. Created data mapping documents to map

desperate sources to a uniform format. Converted data from source

systems to spreadsheet format so business units could analyze the

data.

SELECTED PROFESSIONAL ACCOMPLISHMENTS (Prior to U.S. Bank)

04/1993 - 08/2007 PROJECT HIRE FOR IT Consulting Companies, St. Louis,

MO

. Data Architect responsible for requirements, analysis, design,

development, and documentation of an Oracle 10g finance and sales data

warehouse (DW), the data standards, and the metadata repository.

o Gathered requirements by interviewing subject matter experts and

data analysis of JD Edward's, Siebel Analytics, CARS, IMS

subscription service, Sales Logic, EDI, and Microsoft (MS) Excel

program workflow, OLTP data structures, and interfaces. Utilized

Oracle 9i UNIX scripts, PL/SQL, SQL*Plus, TOAD, and MS SQL

Server 2000 DTS services to analyze existing data structures.

o Transformed financial and sales business requirements into ETL

and DW design specifications using Allfusion process models,

Rational business use cases, MS Visio data flow diagrams, ErWin

IDEF1x dimensional warehouse and ODS normalized logical and

physical data models.

o Developed the data naming standards for the ODS, warehouse, and

metadata data stores.

. Data Architect responsible for requirements, analysis, design,

development, documentation, and Web application prototype build of the

Oracle 9i inventory, productivity metrics, and resource utilization

data warehouse (DW) for IT infrastructure assets. Project goal was to

merge 4 separate applications maintained by the Database Services, MID

Range Server Infrastructure, Windows Server Infrastructure, and

Capacity Planning groups that would provide metrics and resource

utilization statistics to executive management.

o Determined business objectives and conducted interviews with

subject matter experts to develop and document business

processes and requirements using RUP- Rational XDE UML use cases

and activity diagrams. Analyzed existing OLTP source system

databases, interfaces, and data patterns utilizing UNIX scripts,

PL/SQL, SQL*Plus, TOAD, and MS EXCEL. Developed MS Word

requirements document that included requirements for inventory

asset types of databases (Oracle, SQL Server, DB2, DB2/UDB,

Sybase, Informix, and IMS) and Servers (SUN, AIX, IBM, Intel).

o Designed and implemented the logical and physical database model

and architecture using ErWin IDEF1x modeling and Oracle 9i & 10g

running under Red Hat Linux. Facilitated group data model

discussion (JAD) sessions with local and remote users thru the

use of NetMeeting.

o Designed ETL processes and data mappings for the load of the

data warehouse and the metadata repository.

o Designed and developed a thin client web based application

prototype using JAVA 1.4.2 and Websphere Application Developer

Studio (WSAD) 5.1.1.1. Interfaced to Business Objects 6.

Configured and customized WSAD with the STRUTS1.1 framework and

XML object-relational bridge. Developed the J2EE application

prototype based on STRUTS model-view-controller design pattern

using Java Server Pages (JSP's), dynamic forms, JavaBeans,

tiles, STRUTS validation framework, and Oracle triggers and

materialized views.

. Data Architect responsible for requirements, analysis, and design of

US Transportation system / supply chain commercial interface database

in support of US government GTN-21 contract. Gathered requirements,

analyzed, mapped, and normalized commercial interface data from EDI

214 and 315 transaction sets. Designed the logical and physical

Oracle database using ErWin IDEF1x modeling and Oracle 8i.

. Data Architect responsible for support of the finance OLTP logical

data model for the ACIFICS contract. Researched Oracle Developer/2000

forms, Oracle packages, and PL/SQL code to develop UML use cases to

support the financial requirements needed for the defense enterprise

accounting and management system (DEAMS) project. Represented the Air

Mobility Command for the ACIFICS contract in the government data

standardization project.

. SAP Data Warehouse Architect/Developer responsible for design,

development, and implementation of an Oracle 8i dimensional data

warehouse, data extraction from SAP, and propagation to world wide

data marts for FI and CO SAP financial subject areas. Primary

responsibilities included business area requirements definition, ErWin

IE model design, Oracle replication design, and coding of Oracle

snapshots, triggers, views, PL/SQL functions, and procedures using

SQL*Plus, SQL*Loader, and TOAD tools. Planned and executed unit,

system, and integration tests.

. Data Architect responsible for evaluation and implementation of

Sungard Enterprise Accounting System (EAS) configured with MS SQL

Server 7.0. Documented existing legacy AS400 and mainframe financial

systems. Modeled financial accounting, receivables, and payables

classes of data and business processes using Rational Rose UML use

cases, class, and object diagrams. Mapped legacy data elements to EAS

SQL Server data architecture. Designed reusable components for

standard import and export interfaces.

. Data Architect/ Developer for physician prescription

prescribing/patient usage decision support DB2 data warehouse (DW).

Performed logical and physical database design, designed and developed

conversion programs to transform, cleanse data from a Tandem CPU to

MVS DB2. Evaluated BI query tools to be used for the data warehouse,

implemented COGNOS Impromptu as the enterprise BI toolset.

. DBA responsible for new database development efforts for the

government commercial air flight contracting system (COINS).

o Generated the UNIX Oracle 8i physical database structure using

ErWin and established foreign key relationships, referential

integrity constraints, and primary keys in the logical and

physical data model.

o Wrote database triggers, stored procedures, views, and

additional Unix Shell scripts to support development efforts and

definition of database objects.

o Mentored junior DBA and developers and held data modeling

sessions on the new database structures for the JAVA J2EE

development efforts. Participated in development of JAVA

servlets and tuned all SQL used in the development of the

project.

. DBA responsible for data conversion of legacy unnormalized COINS

Oracle 8i database to the new normalized database structure. Wrote

testing plan and developed CVS code repository. Using SQL*Plus and

TOAD, wrote PL/SQL scripts to transform and convert the legacy

database.

. Developer responsible for data conversion of a Sybase 11 customer

relationship management (CRM) database to MS SQL Server 8.0. Developed

test plan and testing approach. Converted Sybase stored procedures

and scripts to Microsoft standards. Tested, conducted performance

analysis, tuning, and test results reporting.

. Developer responsible for migration and upgrade of Lawson 7.x UNIX

financials to Lawson 8.x. Developed design documents from

requirements provided by the business analyst. Designed and coded

159 Oracle 8i table enhancements using Lawson utilities, PL/SQL,

SQL*PLUS, and TOAD. Established Oracle database links between the

production and test Oracle instances. As part of a team, upgraded the

Lawson 7.x Microfocus Cobol programs to incorporate the Lawson 8.x

table and business logic changes.

. Converted and upgraded Oracle Warehouse Builder (OWB) 10g product and

metadata to version 10.2.3. Designed, constructed, converted, tested,

and implemented accounting and budget OWB ETL processes and data

mappings under 10.2.3.

. Developer responsible for data conversion of Lawson 8 account code

structure from the existing GAC account code structure to SAP FI for

integration with AB enterprise initiative. Created data mapping, data

flow, and code source trace specifications utilizing Microsoft Visio.

Converted the data utilized by the Lawson system and the interface to

SAP using PL/SQL functions, stored procedures, and Oracle SQL*Loader.

Coded UNIX scripts for execution of table conversion through the

Lawson job scheduler.

. Database developer/Analyst responsible for reengineering the database

design of a Sybase 11 investment management database configured with a

2-tier PowerBuilder 6.0 application running on Windows NT. Documented

existing database and application by reverse engineering the existing

data model and analyzing the PowerBuilder code, process flows, Sybase

tables and stored procedures, data relationships, and calculations.

Developed Rational Rose UML use cases and a data dictionary.

Redesigned the data structures to incorporate requirements for

multiple product fund management, flexible formula calculations, and

transaction tolerance checks. Planned and executed unit and system

tests.

. Database developer responsible for Oracle Consumer Products data

conversion and interface to Oracle Financials. Gathered requirements

by analyzing C code to determine embedded Oracle 7 referential

integrity constraints. Performed data analysis on customer, product,

price, promotion, broker, orders, and invoice data structures.

Developed data conversion document defining data transformations, data

cleansing, and data mapping for load of DB2 legacy tables to Oracle 7

tables. Performed product evaluation and selection of Seque QaPartner

regression testing tool to be used for loading legacy data ported to

UNIX platform via Information Builders EDA/SQL Enterprise Copy Manager

(Webfocus).

. Business Analyst/Developer for EDI X12 Standard transaction sets 810,

811, 820, 850, 856, 860, and 861.Gathered requirements by interviewing

subject matter experts from federal agencies and the TELCOM industry.

Conducted data SQL query analysis of Oracle, Supra V2, and DB2

databases. Developed transaction sets for invoicing, shipping,

receiving, purchasing, and payables. Wrote Visual Basic GUI's and

Oracle scripts to translate EDI transmission files and load Oracle 7

databases.

Contact this candidate