SUMMARY:

Senior DBA/Data Architect/Data Modeler

SKILLS:

• DB2 UDB V10.5 SQL
• Oracle 11g UNIX Shell Scripting
• Microsoft SQL Server 2014 Visual Basic, VBA
• Sybase SAS
• Access HTML
• ERwin AIX
• PowerDesigner UNIX (Solaris)
• AQT, RapidSQL Windows
• BusinessObjects/Crystal Report
• Cognos

EXPERIENCES:

Confidential

Senior Data Architect/DBA

Responsibilities:

• Provide database administration and database design on 30+ projects and databases for Powertrain, Emission, Stress Labs and Fasteners Labs, E/E Labs, Climatic and Electrical Magnetic Compatibility departments, HIL Lab, Garage Service Departments in the Scientific Labs and Proving Grounds organization. These databases interact with Confidential Product Development Product Lifecycle Management, EBOM, Resource Planning systems, Product Design Office system through automated extraction/loading processes or federation.
• Design logical and physical database model through the entire project life cycle: Work closely with business partners and developers to gather and refine business requirements and translate into design.
• Plan and implement DB2 UDB Databases: Propagate DDL changes to development, staging, test and production databases. Develop and maintain SPs, Functions, Views, MQT and Triggers. Design and implement automated data extraction/loading processes.
• Plan and implement data migration and Sybase to DB2 database conversions.
• Configure/Maintain/Administer Production/Dev/Test UDB, MSSQL Server and Sybase databases: Security, Maintenance, Performance Monitoring/Tuning, and Troubleshooting.
• Install/Upgrade/Configure Software: DB2 UDB Server/Clients, DB2 UDB FixPaks, PowerDesigner, MSSQL Server.
• UNIX Scripting: Automate numerous database administration processes and DDL deployment process.
• Work closely with Confidential Architecture & Infrastructure group for server migration and database migration.

Confidential

Senior Application DBA

Responsibilities:

• Install/Configure/Maintain/Administer enterprise warehouse databases (DB2 UDB V9), Informatica Repositories (DB2 UDB V9), and Entity Analytics databases (DB2 UDB V9).
• Design logical model for the enterprise data warehouse (EDW) based on IBM Banking Data Warehouse Model (BDWM).
• Design and implement physical model for EDW in DB2 UDB V9 environment.
• Optimize database performance through MQT, index design, and hash partitioning.
• Develop extraction scripts and reporting queries.
• Design and implement database security.
• Design and implement database backup/restore.
• Monitor and troubleshoot database environments.
• Develop prototype for Entity Analytics process from ETL to reports.
• Participate in data warehouse ETL process design and implementation.
• Participate in data mapping and data profiling activities.

Confidential

Senior DBA/Data Modeler

Responsibilities:

• Provide database administration and database design on 30+ projects and databases for the Powertrain, Emission, Stress Labs, E/E Labs, Climatic and Electrical Magnetic Compatibility departments, Garage Service Departments in the Scientific Labs and Proving Grounds organization.
• Design logical and physical database model through the entire project life cycle: Work closely with customers and developers to further refine requirements and translate into design.
• Plan and implement DB2 UDB Databases: Propagate DDL changes to development, test and production databases. Develop and maintain SPs, Views and Triggers.
• Plan and implement data migration and Sybase to DB2 database conversions.
• Configure/Maintain/Administer Production/Dev/Test UDB and Sybase databases: Security, Maintenance, Performance Monitoring/Tuning, and Troubleshooting.
• Install/Upgrade/Configure Software: DB2 UDB Server/Clients, DB2 UDB FixPaks, PowerDesigner
• UNIX Scripting: Automate numerous database administration processes and DDL deployment process.

Confidential

Application DBA

Responsibilities:

• Design logical and physical database models for DB2 UDB and Sybase databases using PowerDesigner, including 15 MPI databases and UPIC database.
• Plan and implement DB2 UDB Databases - DDLs, Security, and Extraction/Loading Processes.
• Maintain/Administer databases on Sybase and UDB: Security, Maintenance, and Performance Monitoring/Tuning.
• Code UNIX shell scripts, DB2 scripts, ISQL, stored procedures/triggers (UDB and Sybase) for data extraction/loading/processing and manipulation (Postal Codinator data, Dealer Connect data, MPI data, CodeGuide data, STV data, UPIC data, VWRS data, PWH data, USPS data, and AIC data).
• Design/Code Access databases to upload to Sybase databases.
• Document database processes and create/maintain data dictionary.
• Plan and coordinate Sybase to UDB Migration Activities.
• Provide production support.

Confidential

DBA and Data Modeler

Responsibilities:

• Design logical and physical enterprise warehouse database models (Global Reporting System Project) using ERwin.
• Code UNIX scripts, DB2 scripts, and stored procedures for data loading/processing and manipulation.
• Implement enterprise warehouse database on DB2 UDB 7.2 and 8.1 and administer the warehouse database, including installation, administration (security, backup/restore), development and implementation, monitoring, performance tuning, and troubleshooting.
• Configure BusinessObjects Repository databases.
• Develop queries for BusinessObjects reports.
• Code UNIX scripts to automate UDB installation and database implementation.
• Administer/develop/implement SQL Servers (7.0 and 2000) databases - installation, administration (security, backup/restore), development and implementation, monitoring, performance tuning, and troubleshooting.

Confidential

SQL Server Specialist/DBA

Responsibilities:

• Develop SQL Server stored procedures and batch jobs to extract, load and process warehouse data.
• Develop process and stored procedures to generate report tables on SQL server and develop Sales Result reports using Crystal Report.
• Set up and administer SQL Server.
• Develop and implement server and database migration plan from SQL 6.5 to SQL 7.0.

Confidential

System Administrator, DBA

Responsibilities:

• Administer SQL Server and other back-end NT 4.0 Servers
• Install and configure SQL and other NT 4.0 Servers
• Maintain Users, groups, and security
• Monitor SQL and other NT 4.0 Servers
• Troubleshoot SQL and other NT 4.0 Servers
• Design Domain Security model and Audit Policy
• Develop tools to audit Event Log
• DFS Configuration, ERD project, Backup/Restore, etc
• Develop databases on Microsoft SQL Server
• Service Level Agreement Reporting database
• Develop and maintain several Access 97 applications
• Electronic GM Access Dealership Support database
• Event Log Database
• Vantive Reporting Database
• PCAudit Database
• Vendor Certification Tracking Database
• Migrate Access database to SQL-backend and web-front-end application
• Electronic GM Access Dealership Support database

Confidential

Programmer Analyst

Responsibilities:

• Design a “Job Tracking” database and develop application with 60 forms and 20 reports using Visual Fox Pro
• Customize Sales Order Module in “Visual Account Mate” using Visual Fox Pro
• Develop corporate sales trend reports, variance reports, and YTD sales report using Cognos

Confidential

Programmer

Responsibilities:

• Develop Inventory Tracking System Project using PowerBuilder and SQL Anywhere
• Develop Video Rental System Project utilizing Visual Basic and MS Access
• Develop Catalog Ordering Project using Oracle database