Professional Profile

• 34 years IT experience as Data Architect, Database Administrator, Technical Lead and Oracle Developer in such industries as Automotive, Advertising, eCommerce, Financial Services, Health Care, Manufacturing, Non-Profit Organization and Public Education.
• Strong technical expertise in database development, maintenance, testing and implementation with proven track record as a problem solver.
• Data Architect - Defined and designed database models as well as created, tuned and monitored databases and user activity. Developed data load interface documentation. Utilized Oracle SQL Loader to Transform and Load data for all data migration activities.
• Integration Architect - Collaborated with product development teams to facilitate review and approval of application architectures in accordance with enterprise governance processes.
• Database Administrator Performed database administration and monitoring activities in support of remote clients. Developed and supported Oracle databases on production and standby machines. Designed and developed backup/recovery procedures using a standby database.
• Industries
• Advertising
• Automotive
• Education
• Government
• Health Care
• Insurance
• IT Services
• Non-Profit
• Areas of Expertise
• Database Administration
• Data Analysis
• Data Modeling
• Database Performance tuning
• Database Design/Analysis
• Mentoring
• Experience and Skills
• Oracle 8i/9i/10g/11g
• Oracle SQL Plus
• Oracle SQL Developer
• Oracle SQL Developer Data Modeler
• Oracle SQL Loader
• Oracle PL/SQL
• CA - ERwin 7
• Microsoft Excel
• Windows Scripting
• Microsoft Word
• Toad for Oracle
• UNIX Shell scripting
• Talend ETL
• MySQL
• Microsoft SQL Server 7.0
• Actuate Business Intelligence and Reporting Tools BIRT

Experience Highlights

Data Architect Quality Data Management Created a data model for an existing MySQL database. Developed MySQL data loading processes. Analyzed data for inconsistency and determined the execution sequence of existing scripts

Data Architect

Confidential

data models and created scripts for migrating data from non-normalized legacy databases to a normalized database. Provided DBA support for Development, QA and Pre-Production environments.

Data Architect

Confidential

Corporation/OnStar - Supported Compuware's OnStar Team by performing a data. Supported the implementation team during product version.

Oracle Developer

Confidential

Analyzed existing PL/SQL scripts to produce user documentation.

Data Architect Compuware Corporation - Analyzed corporate client lists from multiple sources to determine data duplication.

Database Administrator/Data Modeler/Data Architect/Developer Compuware Corporation - Developed a software package to assist Compuware's Products Division assess client application complexity.

Database Administrator/Data Modeler / Data Architect

Confidential

Developed interface design documents for batch data load processes. Created a data model to support the development of a future global production environment. Created and maintained an Oracle database for the development of OnStar's global effort. Developed and executed data migration scripts.

Data Architect

Confidential

Worked with Business SME s to obtain data to support the Request to Pay RTP product. Identified rules and data required. Worked with the SME team to understand the specifics of the Legacy and Supplier interfaces for RTP solution.

Database Administrator

Confidential

Supported Oracle databases, PeopleSoft Financial and Human Resource applications.

Integration Architect

Confidential

Collaborated with product development teams to facilitate review and approval of application architectures in accordance with governance processes. Reviewed deployment architectural roadmaps. Evaluated emerging technologies in support of enterprise architecture initiatives.

Data Modeler

Confidential

Center Merged an existing General Clinical Research Center's Management Application, Lab Application and Nutrition Monitoring System into one normalized Database model.

Technical Lead

Confidential

Led a development team to develop a process for converting subscriber Social Security numbers to newly assigned identification numbers.

Database Administrator

Confidential

• Supported PeopleSoft Financial and Human Resource applications. Performed database administration activities. Performed new application stress testing.
• Database Administrator Compuware Corporation Supported all in-house Oracle projects, database administration and monitoring support to remote clients. Developed and supported databases in production and standby machines. Created SQL Server Databases for in-house development projects. Supported SQL Server web development and assisted in the development and maintenance of the data model.

Chronology of Experience

Confidential

• In between assignment:
• I have participated the creation of Request for Proposals RFP's .
• Developed a documentation, How to install Oracle 11gR2 on CentOS VMWare.
• Developed a documentation, How to install Oracle 11gR2 GoldenGate on two SUSE VMWare environments.
• Consulted Compuware's Professional Services staff with Data Modeling and Oracle queries issues.
• Research new ETL technologies like Talend and Pentaho .

Confidential

Position: Database Administrator/Data Architect

Environment: MS Windows, Linux, MySQL

• Tools: MS Office, MySQL Data Loader, SQL Developer, SQL, SQL Developer Data Modeler
• Utilized Oracle SQL Developer Data Modeler to create a data model from an existing MySQL database. Developed MySQL data Loader scripts to transform and load data into base tables text and excel files . Analyzed data for inconsistencies and determined the execution sequence of existing scripts for dashboard table creation and report generation.

Confidential

Position: Database Administrator/Data Architect

Environment: MS Windows, Linux, Oracle 11g

• Tools: MS Office, SQL Loader, SQL Developer, SQL Plus, SQL Developer Data Modeler
• Created Oracle SQL Loader scripts to transform and load data text and excel files into a normalized database. Analyzed data for inconsistencies and generated exception reports. Provided DBA support for Development, QA and Pre-Production environments.

Confidential

Position: Database Administrator

Environment: MS Windows, Linux, Oracle 11g,

• Tools: MS Office, SQL Developer, SQL Plus
• Supported Compuware's OnStar Team by performing a data migration from current environments to a new global environment. Supported the implementation team during product version.

Confidential

Position: Oracle Developer

Environment: MS Windows, Oracle 11g,

• Tools: MS Office, SQL Developer
• Analyzed existing PL/SQL scripts to produce user documentation.

Confidential

Position: Data Architect

Environment: MS Windows XP, Oracle 11g,

• Tools: Oracle SQL Plus, Oracle SQL Developer, Talend Open Source Data Integration Suite ETL .
• Analyzed corporate client lists from multiple sources to determine data duplication.

Confidential

Position: Database Administrator/Data Architect

Environment: MS Windows XP, UNIX, Oracle 11g,

• Tools: MS Office, Oracle SQL Plus, Oracle SQL Developer, Oracle SQL Loader, Oracle PL/SQL, Power Architect, Actuate BIRT Professional, Actuate BIRT Open Source.
• Assisted Compuware's Services Division on multiple project proposals. Developed Oracle PL/SQL scripts for a fixed cost GM Project. Supported Compuware's Products Field Enablement Center managers in their daily activities, Developed a software prototype to help Compuware's Products Division determine a client's most costly COBOL programs. Utilized Oracle, Eclipse and Actuate products to analyze and correlate data from Compuware's Mainframe products.

Confidential

Position: Database Administrator/Data Architect

Environment: MS Windows XP, UNIX, Oracle 9i, Oracle 10g,

• Tools: MS Office, SQL Plus, SQL Developer, SQL Loader, ERwin
• Developed interface design documents for batch loading of Vehicle and Cellular information. Created a data model for current production database schemas in support of development for a future global production environment. Maintained modification of data model changes to support the new global effort. Created and maintained an Oracle database for the development of the OnStar's global effort. Developed and executed data migration scripts from current production environment to the new global development environment.

Confidential

Position: Data Architect

Environment: MS Windows XP, Oracle 9i

• Tools: MS Office, GM IS S and Enterprise Architecture Governance, Standards, Technology and Related Processes
• Worked with GM Business SME's to obtain GM data to support the Request to Pay RTP application. Identified rules and data required including format, type how used, etc. Worked with SME team to understand the specific of the Legacy and Supplier interfaces for RTP solution. Worked with GM system owners and operational support resources to understand/analyze and translate the RTP inbound/outbound data requirements. Worked with the Global Interface Factory GIF in the architecture and design of interfaces as single point of contact. Developed detailed use case documents to build required interfaces. Created an Oracle database to analyze the RTP data.

Confidential

Position: Senior Database Administrator

Environment: UNIX, MS Windows NT

• Tools: UNIX Shell, Oracle SQL Plus, PeopleTools 8.4, Oracle 8i, Lotus QuickPlace
• Supported Oracle databases, PeopleSoft Financial and Human Resource applications. Administered, recovered, supported, and monitored production databases. Processed user change requests and migrated PeopleSoft projects from development to production environments.

Confidential

Position: Integration Architect

Environment: Sun Solaris Servers, MS Windows 95/NT/2000

• Tools: MS Office, QuickPlace, Lotus Notes
• Supported the Integration Architecture Team that established, developed, and implemented an Architecture Governance Process for all projects in the Global Retail Initiative GRI Program within Global Sales and Service Management GSSM organization. Planned, organized and initiated reviews for the Architecture Design Document ADD , System Design Document SDD , and Bill of Material BOM for the GME Exchange, Service and Parts Workbenches applications. Collaborated with GSSM architecture planning, and product management to identify and oversee application integration management for delivering dealer facing applications. Collaborated with product development teams to ensure conformance with the GRI architectural requirements. Created architectural deployment assessment and review of active and future release architectural standards/requirements. Evaluated emerging technologies in support of enterprise architecture initiatives including Service Oriented Architecture SOA and Enterprise Service Bus ESB .

Confidential

Position: Senior Database Administrator, Data Modeler

Environment: MS Windows 2000

• Tools: ERwin 3.5.2, Oracle 10G, Oracle SQL Plus
• Combined and redesigned three of the existing General Clinical Research Center's applications into one normalized Data model for Management Application, Lab Application and Nutrition Monitoring System.

Confidential

Position: Technical Lead

Environment: UNIX, MS Windows XP, Sybase

• Tools: T-SQL, SQL Advantage, UltraEdit, MS Word, MS Excel
• Led a team of three developers, one UNIX scriptwriter and two testers, to develop a process for converting BCN subscriber Social Security numbers to newly assigned identification numbers by Blue Cross Blue Shield. Converted over 200 million records in 46 tables that ran in three threads.
• Professional Education and Training
• Oracle Database Administrator
• Oracle SQL Plus
• PeopleTools I, Version 8.4
• Oracle SQL Loader
• SQL Server Data Management Tools, Version 7 Pentaho
• Power Piovet, Power View and SharePoint 2013 Business Intelligence Ceneter for Analysts.
• Implementing Data Models and Report withMicrosoft SQL Server 2012