PROFESSIONAL SUMMARY:

With over 16 years of total IT experience, 10 of which I spent in the automotive industry, I have a very diverse background. I have worked in positions as a programmer, architect, DB Engineer, DBA, ETL developer as well as Senior Level Technical Consultant. I have worked for two of the “big 5” IT consulting firms as well as all of the “big 3” automotive companies as well as suppliers. My most recent experience has been working as a Database Engineer. I have built, migrated and developed databases as well as maintained and administered them. I hold a Masters Degree in Software Engineering and Administration as well as a Bachelor Degree in Computer Information Systems and in addition, I am also a graduate of the EDS SED program. My professionalism, experience and ability to meet and exceed expectations make me a strong asset to your organization.

TECHNICAL SKILLS:

Databases: Microsoft SQL Server 2000/2005/2008, Microsoft Access, PostgreSQL

Reporting: Microsoft Reporting Services, MicroStrategy, ProClarity, Crystal Reports

Architectures: Client/Server

Languages: SQL, VB, VBA, VBScript, C++

Web Servers: IIS, Apache

Portals: Microsoft SharePoint, eRoom

Platforms: Microsoft Windows

Web Technologies: HTML, DHTML, ASP, Microsoft FrontPage, JavaScript, Ruby on Rails (ROR), JQuery, CoffeeCup

Source Control: Microsoft Visual Source Safe, PVCS, Git

Methodologies: System Development Life Cycle (SDLC), CMM

Regulations: SOX, HIPPA

MISC: VMWare, SpotLite, Visual Studio (BIDS), LiteSpeed, Wapt, JetBrains, RadRails

PROFESSIONAL EXPERIENCE:

Confidential

Sr. DBA

• Part - time consultant DBA supporting MS SQL Server .
• Design and development of database architecture, including database physical layout, develop queries, functions and stored procedures.
• Database administration including backup/restore, query optimization and overall database maintenance.
• Responsible for database migrations from SQL Server 2000 and .
• Creation of SSIS packages for DTS and application replacement and data movement.
• Creation of daily “morning reports” for database monitoring and overall health.
• Creation and maintenance of maintenance jobs for shrinking dbs, data cleanups and overall db support.
• Creation of real-time reports for SQL event logs and CPU monitoring.
• Technical Environment: Windows 7/Server 2003/2008, SQL Server

Confidential

Sr. Database Engineer and Web Developer

• Responsible for the definition, creation and development of the SmartSource Intelligence (SSI) application dashboard.
• Design and development of database architecture, including database physical layout, develop queries, functions and stored procedures used by the SmartSource Intelligence Application.
• Database administration including backup/restore, query optimization and overall database maintenance.
• Analyze, test and implement database designs.
• Participate as a team member in all phases of project development lifecycle.
• Design and development of the SSI user interface using Ruby on Rails, PostgreSQL and JavaScript, JQuery and Apache Web Server
• Creation of Technical Design Documents, Flow Diagrams, Admin Guides and Online user help.
• Run application performance tests using Wapt

Technical Environment: Windows XP/Server 2003/2008/Vista, Postgres, Visio, Ruby on Rails, Apache, Wapt, Git

Confidential

SQL Server Developer

• Responsible for the definition, creation and development of the 3PL Data System for the Rolls Royce ThyssenKrupp Account.
• Design and development of database architecture, including database physical layout.
• Analyze, test and implement database designs.
• Creation and modification of ETL processes using DTS, SSIS and Stored Procedures.
• Participate as a team member in all phases of project development lifecycle.
• Creation of Technical Design Documents, Flow Diagrams and Test Cases.

Technical Environment: Windows XP/2003 Server, MS SQL Server 2000/2005, Visio

Confidential

SQL Server DBA Independent Consultant

• Responsible for the definition, creation and maintenance of the enterprise data model within the computing environments.
• Design and configure database architecture, including hardware and physical layout.
• Plan, install and maintain SQL-Server databases on Windows operating system.
• Analyze, test and implement database designs supporting various business applications.
• Monitor/tune database resources using Profiler, logs, SpotLite, custom designed SSIS packages and jobs
• Create backup and maintenance jobs using SSIS and LiteSpeed for compressed backups
• Responsible for logical and physical database design, backup and recovery strategy including disaster recovery, load strategy design and implementation, security, and change management
• Provide first-level application support as DBA in Windows environment 24x7
• Facilitate application development and customer problem resolution with optimum speed and efficiency.
• Participate as a team member in all phases of project development lifecycle.

Technical Environment: Windows XP/2003 Server, MS SQL Server 2000/2005, VMWare, LiteSpeed

Confidential

Application Technology Management Senior / Database Engineer

• Engineer Microsoft SQL Server database solutions as per Ford requirements
• Worked with infrastructure owners to develop engineered solutions
• Engineered with team members SQL Server 2005 Shared Farm Environment
• Provided governance on the usage of DBMS as per defined strategy
• Developed run books and database usage guidelines for database environment
• Performed Failure Mode and Effects Analysis (FMEA) testing, testing and validation of critical patches, hot fixes and proof of concept of new releases for database environment
• Single point of contact for audit
• Designed solutions and coordinated efforts for the SQL Server 2000 to SQL Server 2005 migrations
• Conducted Engineering Reviews for new/existing applications going into SQL Server 2005 environment
• Designed FTP solution for legacy applications migrating to SQL Server 2005 from Oracle
• Engineered Password vault solution to protect Service Account and System Administrator passwords using PAR product
• Developed Team site using SharePoint Team Connects with custom forms with derived fields and calculations
• Managed large scale projects to ensure on time and within budget.

Technical Environment: Windows XP/2003 Server, MS SQL Server 2005

Confidential

Consultant / SQL Server DBA / ETL Developer

• Responsible for support, design and development of data warehouse solutions that use SQL Server 2000, Data Transformations Services (DTS) for ETL and ProClarity for reporting.
• Performed data modeling to document source systems.
• Scheduled/Created jobs to run DTS packages
• Created/Modified DTS packages, stored procedures and views to load data into tables via text files, ftp’d data, tables and flat files
• Ran and generated SQL scripts to correct/update data in tables (insert/update/delete/select)
• Reverse engineered code to create documentation
• Refreshed development and test server environments to synchronize with production and cleanse server environment
• Created Stored procedures, views, functions and SQL queries to perform data manipulation and imports
• Created ProClarity 6.1 reports for user verification of data

Technical Environment: Windows XP/2003 Server, MS SQL Server 2000, ProClarity 6.1, SharePoint

Confidential

Principal Consultant SQL Server

• Assigned to Taubman Company
• Modified the MRI/Intuit Leaseflow application.
• Modified web screens in Leaseflow application.
• Developed new workflows and updating existing workflows.
• Developed new reports and updating existing reports.
• Used SQL Server 2000 Enterprise Manager and tools to verify/modify tables, data, write queries, stored procedures, views and functions used by application.
• Assigned to Umicore Automotive Catalyst
• Implemented a database for logging test data using Access 2003.
• Developed database including tables, relationships and logical and physical data models.
• Developed front-end application including menus, forms, reports, queries and macros for general application usage and functionality.
• Designed and developed complex application functionality using VBA.
• Created technical documentation.

Technical Environment: Windows XP, Microsoft Access 2003, VB 6.3, MS SQL Server 2000, Intuit/MRI

Confidential

Architect / SQL Server DBA

• Responsible for support, design and development of data warehouse solutions that used SQL Server 2000, Data Transformations Services (DTS), ETL, Reporting Services and Sharepoint. DBA for SQL Server 2000 containing PeopleSoft 8.0 data.
• Plan, install and maintain SQL-Server databases on Windows operating system.
• Performing data modeling to document source systems.
• Monitor/tune database resources using Profiler, logs, BMC Patrol
• Used PeopleSoft DataMover to migrate data from multiple environments.
• Built web server for SQL Reporting Services and user portal using ASP, HTML, SharePoint and IIS
• Built user portal on SharePoint with links to reports on Reporting Services. Site features included web parts and SQL Server 2000 database connectivity
• Used FrontPage to integrate web changes
• Used SharePoint backup and restore to move site to new servers
• Support SQL Reporting Services
• Maintain reports
• Upload RDL files
• Administer web server and Reporting Services Server
• Run and generate SQL scripts to correct/update data in tables
• Support developers with release management, troubleshooting and overall database maintenance
• Install and configure SQL Server 2000 and services patches in both cluster and non clustered environments
• Designing & Implementing policies and processes related to: password security, configuration management, enhancements and SOX initiatives.
• Provided first-level application support as DBA in Windows environment 24x7

Technical Environment: Windows XP/2000/2003, MS SQL Server 2000

Confidential

Assigned to Delphi Automotive Systems

SQL Server DBA / SQL Developer

• Provided first-level application support as DBA on SQL Server 2000 and Sybase in a 24x7 environment.
• Monitor/tune database resources using Profiler and logs
• ETL Development using DTS packages and Agent Jobs for importing SAP data into Tax Department databases.
• Technical Project Lead for FDC system enhancements. Provide technical assistance to developers, gather requirements, create test plans, reporting, test and support application users.
• Administrator of MicroStrategy Data Warehouse.
• Develop reports using MicroStrategy
• Create meta-data, metrics, attributes and formulas
• Primary maintenance, administration and support of the Tax Department systems: CORPTax/CORPTax Int’l, eComply, eRoom and SharePoint.
• Design and code VB Scripts to be used to prepare data for upload into tax web applications.
• Create process flows of applications using Visio.
• Install tax software upgrades into client and server environments
• Website maintenance, design, and development using Microsoft FrontPage eRoom Administrator - Design and maintain databases, user access administration
• SharePoint Administrator - Design, maintenance, setup, user access administration
• Designed and Implemented policies and processes related to: password security, configuration management and enhancements as well as SOX initiatives.

Technical Environment: Windows XP/2000, MS SQL Server 2000, MicroStrategy, eRoom, Sharepoint

Strategic Staffing Solutions

SQL Server DBA / Web Developer

• SQL Server 2000 Administration: Installed and configured MS SQL Server 2000, migrated MS Access databases and MS SQL 6.5 databases, created databases, tables and queries. General DBA activities.
• Evaluated Disk Monitoring, Performance Monitoring and Security Applications to highlight features, cost and benefits for management evaluation and tool purchase.
• Project Management
• Coordinated efforts between the Engineering Department and project requests
• HIPPA Implementations
• Defined resource gaps for systems operations based on the implementation of HIPAA requirements.

Technical Environment: Windows 2000, MS SQL Server 2000

Confidential

Application Architect

• Provided technical assistance to DaimlerChrysler (DCX) with the deployment of security solutions and the integration of Netegrity SiteMinder.

Technical Environment: Windows 2000, UNIX, OS/390, Netegrity SiteMinder 4.5.1, NDS

Confidential

Advising IT Architect Specialist

• Provided technical assistance to General Motors, EDS and vendors, with the installation, customization and deployment of Confidential SecureWay Products.

Technical Environment: LDAP, Confidential SecureWay Product Suite, IBM/Transarc DCE, NDS, HTTP Web Server, Apache, Domino, Windows NT, Unix, RSA Security, GSO

Confidential

Senior Software Engineer

• Primary maintenance, development and customer support on a Client/Server system called CORPS.
• Designed and Developed CORPS application using MFC/Visual C++, Visual Basic Macros within MS Word for reporting.

Technical Environment: Windows 95/NT, MFC/Visual C++, Visual Basic, ODBC, Visual SourceSafe

Confidential

System Engineer

• Worked on multiple releases of a Client/Server Global Purchasing System (GPS) with development on both the client and server sides of the application using MFC/Visual C++.
• Graduate of EDS Technical Training - System Engineer Development Program.

Technical Environment: Windows 95/NT, MFC/Visual C++, Visual SourceSafe, PVCS, ODBC, SQL