Kimberly Killian
55256 Lee Rd. ~ New Hudson, MI 48165
[Send email to request phone number] 60-7030
[Send email using form at bottom]
Professional Summary
With over 15 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, 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 DBA and database engineer consultant. I have
built MS SQL Server 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, 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 Summary
Databases: Microsoft SQL Server 2000/2005/2008, SSIS, DTS, Microsoft Access
Reporting: Microsoft Reporting Services, MicroStrategy, ProClarity, Crystal
Reports
Architectures: Client server
Languages: PL/SQL, VB, VBA, VBScript, SQL, C++
Web Servers: IIS
Portals: Microsoft SharePoint, eRoom
Platforms: Microsoft Windows
Web Technologies: HTML, DHTML, ASP, Microsoft FrontPage, JavaScript
Source Control: PVCS, Microsoft Visual Source Safe
Methodologies: System Development Life Cycle (SDLC), CMM
Regulations: SOX, HIPPA
MISC: VMWare, SpotLite, Visual Studio, LiteSpeed
Education
Central Michigan University 1999
Master of Science & Administration
Software Engineering & Administration Eastern Michigan University 1994
Bachelor of Business Administration
Major: Computer Information Systems Minor: Communications
Professional Experience
La-Z-Boy Corporate
October 08 - Present
Consultant through Pomeroy May 07- August 07
Consultant / SQL Server DBA
Responsible for the definition, creation and maintenance of the enterprise
data model within the computing environments.
o Design and configure database architecture, including hardware and physical
layout.
o Plan, install and maintain SQL-Server databases on Windows operating system.
o Analyze, test and implement database designs supporting various business
applications.
o Monitor/tune database resources using Profiler, logs, SpotLite, custom
designed SSIS packages and jobs
o Create backup and maintenance jobs using SSIS and LiteSpeed for compressed
backups
o Responsible for logical and physical database design, backup and recovery
strategy including disaster recovery, load strategy design and implementation,
security, and change management
o Provide first-level application support as DBA in Windows environment 24x7
o Facilitate application development and customer problem resolution with
optimum speed and efficiency.
o 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
DPM Consulting
Assigned to Ford Motor Company
August 07- September 08
Application Technology Management Senior / Database Engineer
Engineer Microsoft SQL Server database solutions as per Ford requirements
o Worked with infrastructure owners to develop engineered solutions
o Engineered with team members SQL Server 2005 Shared Farm Environment
o Provided governance on the usage of DBMS as per defined strategy
o Developed run books and database usage guidelines for database environment
o 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
o Single point of contact for audit
o Coordinated SQL Server 2000 to SQL Server 2005 migrations
o Conducted Engineering Reviews for new/existing applications going into SQL
Server 2005 environment
o Designed FTP solution for legacy applications migrating to SQL Server 2005
from Oracle
o Engineered Password vault solution to protect Service Account and System
Administrator passwords using PAR product
o Developed Team site using SharePoint Team Connects with custom forms with
derived fields and calculations
o Managed large scale projects to ensure on time and within budget.
Technical Environment: Windows XP/2003 Server, MS SQL Server 2005
HTC Global Services
Assigned to Cooper-Standard Automotive
September 06 May 07
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.
o Performed data modeling to document source systems.
o Scheduled/Created jobs to run DTS packages
o Created/Modified DTS packages, stored procedures and views to load data into
tables via text files, ftpd data, tables and flat files
o Ran and generated SQL scripts to correct/update data in tables
(insert/update/delete/select)
o Reverse engineered code to create documentation
o Refreshed development and test server environments to synchronize with
production and cleanse server environment
o Created Stored procedures, views, functions and SQL queries to perform data
manipulation and imports
o Created ProClarity 6.1 reports for user verification of data
Technical Environment: Windows XP/2003 Server, MS SQL Server 2000, ProClarity
6.1, SharePoint
Sogeti USA, LLC - Microsoft Practice
December 05 September 06
Principal Consultant SQL Server
Assigned to Taubman Company
o Modified the MRI/Intuit Leaseflow application.
o Modified web screens in Leaseflow application.
o Developed new workflows and updating existing workflows.
o Developed new reports and updating existing reports.
o 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
o Implemented a database for logging test data using Access 2003.
o Developed database including tables, relationships and logical and physical
data models.
o Developed front-end application including menus, forms, reports, queries and
macros for general application usage and functionality.
o Designed and developed complex application functionality using VBA.
o Created technical documentation.
Technical Environment: Windows XP, Microsoft Access 2003, VB 6.3, MS SQL Server
2000, Intuit/MRI
Publicis
June 04 - November 05
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.
o Plan, install and maintain SQL-Server databases on Windows operating system.
o Performing data modeling to document source systems.
o Monitor/tune database resources using Profiler, logs, BMC Patrol
o Used PeopleSoft DataMover to migrate data from multiple environments.
o 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
o Support SQL Reporting Services
Maintain reports
Upload RDL files
Administer web server and Reporting Services Server
o Run and generate SQL scripts to correct/update data in tables
o Support developers with release management, troubleshooting and overall
database maintenance
o Install and configure SQL Server 2000 and services patches in both cluster and
non clustered environments
o Designing & Implementing policies and processes related to: password security,
configuration management, enhancements and SOX initiatives.
o Provided first-level application support as DBA in Windows environment 24x7
Technical Environment: Windows XP/2000/2003, MS SQL Server 2000
GDI Info Systems
Assigned to Delphi Automotive Systems
October 02 June 04
Technical Consultant / SQL Server DBA / SQL Developer
Provided first-level application support as DBA on SQL Server 2000 and Sybase
in a 24x7 environment.
o Monitor/tune database resources using Profiler and logs
o 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.
o 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 Intl, eComply, eRoom and SharePoint.
o Design and code VB Scripts to be used to prepare data for upload into tax web
applications.
o Create process flows of applications using Visio.
o Install tax software upgrades into client and server environments
o Website maintenance, design, and development using Microsoft FrontPage
o eRoom Administrator Design and maintain databases, user access
administration
o SharePoint Administrator Design, maintenance, setup, user access
administration
o 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
Assigned to Blue Cross Blue Shield of Michigan
September 01 October 02
Technical Consultant / SQL Server DBA / Web Developer
Designed, developed and implemented inter-department web sites using Microsoft
FrontPage 2000, HTML, DHTML, JavaScript, ASP, IIS and imbedded database queries
connecting to MS SQL Server 2000 and MS Access.
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
o Coordinated efforts between the Engineering Department and project requests
o HIPPA Implementations
o Defined resource gaps for systems operations based on the implementation of
HIPAA requirements.
Technical Environment: Windows 2000, MS SQL Server 2000
EBSG/Conects
Assigned to DaimlerChrysler Corporation
February 01 - June 01
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
Tivoli / IBM
January 00 to January 01
Advising IT Architect Specialist
Provided technical assistance to General Motors, EDS and vendors, with the
installation, customization and deployment of Tivoli SecureWay Products.
Technical Environment: LDAP, Tivoli SecureWay Product Suite, IBM/Transarc DCE,
NDS, HTTP Web Server, Apache, Domino, Windows NT, Unix, RSA Security, GSO
CDI Information Services
Assigned to DaimlerChrysler Corporation
August 98 - December 99
Senior Software Engineer
Primary maintenance, development and customer support on a Client/Server
system called CORPS.
o 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
Electronic Data Systems
Assigned to General Motors Corporation
January 95 - August 98
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++.
o Graduate of EDS Technical Training - System Engineer Development Program.
Technical Environment: Windows 95/NT, MFC/Visual C++, Visual SourceSafe, PVCS,
ODBC, SQL
|
