logo
Home     Photos     Movies     Audio     Presentations     Kim's Resume     Links     Email Kim     Email Rich    

Kim Sheehe

2673 North Upshur Street • Arlington, VA • Home Phone (703) 812 - 0860

• Mobile Phone (703) 585 - 9928 • Email KMSheehe@yahoo.com

  

  certifications

 

 

§          MCDBA, Microsoft Certified Database Developer  (SQL Server 2000)

§          MCSD, Microsoft Certified Solutions Developer (Visual Studio 6.0)

§         MCSE, Microsoft Certified Systems Engineer (NT 4.0)

  Technical Presentations/Courses

 

 

§          Using XML and Meta Data to Document Your Databases, SQL Server Pass Community Summit (SQL PASS), November 2002

§          ADO.Net, MSDN Roadshow (MSDN Roadshow), March 2003

§          SQL Server 2000 Distributed Transformation Services, SRA University, sole developer and instructor, 12 hour course (Course Website), Summer 2003:

§          Embrace XML, SQL Server Pass Community Summit (SQL PASS), November 2003

  Systems development Manager

 

 

Virginia Hospital Center (VHC); Arlington, VA                                                                                           Oct 2003 – current

·      Installed SharePoint Portal Server on a server farm with a 64-bit clustered SQL Server backend.  Implementing 3 distinct portals across the hospital – Employee Portal, Physician Portal, Patient Portal.   Present to committees and departments on SharePoint.  Developed custom web parts, InfoPath forms, and worked with Front Page 2003 to create data views.

·      Created over 15 custom DTS packages to migrate data from hospital systems into SQL Server. 

·      Setup custom interface for Juniper’s Instant Virtual Extranet (IVE) product.

·      Developed custom ASP.Net website for processing tuition reimbursements.

·      Developed custom ASP.Net website for pushing INI files to user workstations used to access the hospital’s patient information system.

·      Implemented Courion at the hospital for password resetting and transparent password synchronization across systems.  Developed custom email generator to send HTML emails (Courion only allowed text emails).

 

  Systems/Database Manager

 

 

SRA International (SRA); Fairfax, VA                                                                                                              Feb 2003 - Oct 2003

SRA provides call center support to the Internal Revenue Service’s 26 toll free call centers.  As part of this contract, SRA supports the IRS Enterprise Telephone Data Warehouse (ETD).  The ETD collects data from multiple data sources - including the call centers - and produces over 170 custom reports.  At ETD, the system/database manager is responsible for new development and operational stability on over 50 production SQL Server databases, consisting of more than a terabyte of data.  In addition to managing three direct reports, performed the following tasks:

·         Migrated all 50 plus databases from multiple locations and versions of SQL Server to a single server running SQL Server 2000, service pack 3a.

·         Created a database schema for managing database backups to tape while awaiting Veritas procurement.  Managed the development of stored procedures using the database scheme and HP Storageworks MRU to automating the swapping and archiving of tapes.

·         Designed, developed, and implemented a SQL Server DDL (Data Definition Language) archive utility.  The archive utility was created using Visual Studio .Net 2002 as a C# class library, referencing the Microsoft DTS Package Object Library, Microsoft SQLDMO Object Library, Microsoft SourceSafe 6.0 Type Library.  The archive utility    generates a fresh copy of scripts for each object in each user database every day as well as server-level objects like replication, DTS packages, and linked servers.  The archive utility stores the scripts in a SourceSafe database. 

·         Designed, developed, and implemented a C# application and database schema for the asynchronous execution of daily operations processes and system-wide alerts.  The application, which was required to run on a NT server, uses asynchronous delegate invocation to process a list of daily scheduled events from a processing queue table in a SQL Server 2000 database.  Events can be grouped together and the process flow of events can be controlled based on simple dependencies between event groups.

 

  Managing Associate

 

 

Dell Professional Services – formally Plural (Dell Professional Services; Bethesda, MD)                                  1999 - 2003

§          DBA and .NET developer on a portal web application developed solely in C# to allow participating financial institutions and home loan banks to share in the ownership of loan pools.  The site generates over 70 reports from various systems and data warehouses within the bank and allows users to perform credit enhancements, fund a loan, and submit a batch. 

§          Wrote a database replication requirements analysis for a nonprofit corporation dedicated to improving the quality of health for women and their families throughout the world.  The analysis included recommendations for creating a centralized SQL Server database that would be periodically updated with data from stand-alone MS Access applications located in Nepal, Kenya, Indonesia and Malawi.   Made additional recommendations in order to address the issue of rolling up data from applications using multiple languages.

§          Wrote a technology assessment for a leading provider of ‘eHealth’ decision support solutions.  Recommendations included a roadmap outlining a solution that optimized the Microsoft platform.  Built a prototype to demonstrate how Analysis Services could be leveraged to solve some of their tougher business problems.  This document was used as a marketing tool to demonstrate company-wide BI capabilities.

§          Technical manager, developer and DBA of a web development project for a third-party telecommunications company.  The site was primarily used for individuals to review, compare and order telecommunication services for their home or business.  The site was developed using the .Net framework, ASP.Net for the front-end, C# for the middle-tier and a SQL Server 2000 back-end.  This system supported over 100 partners, each with a different front-end look and feel.  Responsibilities included generation of page schematics, front-end development and back-end database design and development. 

§          Lead SQL Server developer for a Commerce Server 2000 website for a leading research-based Italian pharmaceutical company with subsidiaries worldwide.  Responsibilities included extending the Commerce Server data model and creating a separate administrative XML-based order processing system.   

§          Developed a SQL Server 2000 database for a work order management web site for a bandwidth trading.   Re-engineered the data model and all SQL Server 2000 views, stored procedures and functions (approximately 110 objects) in under a month.  Wrote complex stored procedures to determine the future state of the database on a particular date or date range.

§          Technical manager for a 6-person team which developed a credit card application/approval website utilizing real-time credit report analysis and online distribution of approved cards.  Responsible for the discovery phase to determine application requirements.  Designed and implemented the network architecture, message queues (MSMQ) and the corresponding scripting components that moved data from an exposed SQL Server database to a highly secure SQL Server database.  Site built on Windows 2000 Advanced Server with IIS5, ASP with VBScript and JavaScript, Active Directory integration, SQL Server 2000, XML and Microsoft Message Queue.

§          Wrote a SQL Server database site analysis for a well known financial data company.  Interviewed key personnel and analyzed the current SQL Server 6.5 database, stored procedures, indexes and batch processing.  Developed a migration plan for moving to SQL Server 2000.  Made recommendations for both short term and long term projects for winning new business.

§          Technical manager for a business to business exchange for the furniture industry.  Site built on Windows 2000 Advanced Server with IIS5 using ASP with VBScript and JavaScript.  Middle tier written using Windows Scripting Components utilizing a VB COM component that managed all database access.

§          Provided crisis technical assistance for an event planning and marketing web site for connecting professionals and marketers.  Wrote DTS packages and stored procedures needed to bulk load Outlook contact data into a normalized SQL Server 7.0 database. 

§          Sole developer and project manager for a portal site allowing customers to locate computer resellers and service providers worldwide utilizing proximity based search engine.  Designed an attribute/value database model that was reused in several different projects.  Wrote a search engine.

§          Other responsibilities included interviewing potential employee candidates, sales technical support, creating and maintaining a SQL Server reusable code library, and conducting learning sessions on SQL Server for fellow co-workers.

 

  Senior Applications Consultant

 

 

The Arlington Group (The Arlington Group;  McLean, VA)                                                                                          1997–1999

§          Lead developer for a SQL Server 7.0 competition archive and data warehouse.  Responsibilities included designing a SQL Server 7.0 archive database for institution and individual grant competitions and creating SQL Server 7.0 data marts from various sources including financial systems, competition archives and annual program reports.

§          Designed and developed a corporate project/time tracking system for The Arlington Group.  Employees entered project tasks and time using forms created in Microsoft Outlook which write to a SQL Server database.  Designed MS Access 7.0 reports for client billing and employee evaluation.

§          Created a master person database.  Merged data from four SQL Server 6.5 databases across multiple servers into one central SQL Server database. Registered remote servers and set up distributed transactions in stored procedures.  The Visual Basic 5.0 application assigned unique person identifications across different systems.

 

  project lead/senior developer

 

 

Avectra - formerly Ablaze Business Systems (Avectra; Falls Church, VA)                                                              1995–1997

§          Deployed a SQL Server 6.5 proprietary based association management enterprise system for a hospital association and a credit union. Responsibilities included conducting requirements analysis; analyzing business processes and implementing them into base software with minimal customization; data conversion; installing SQL Server and ABLAZE software; documentation; training and team management.  Created over 50 Crystal Reports using custom views and stored procedures.

§          Primary developer for two pieces of commercial software: ABLAZE Product Manager Pro and ABLAZE Education Manager Pro.  Both applications were built in Visual Basic 3.0 with a SQL Server 6.5 database backend.  Wrote over 100 SQL Server stored procedures and triggers.  Produced over 100 baseline Crystal Reports.

§          Primary custom software developer for a large health plan association.  Developed an ad hoc query report builder, drag-and-drop list manager and over 250 specific membership and meeting reports.  Applications were developed using Visual Basic 4.0, Crystal Reports 4.5, and SQL Server 6.0 stored procedures.

  peace corps volunteer (Gabon, Africa)

 

 

United States Peace Corps  (www.peacecorps.gov)                                                                                                     1991–1993

§          English teacher for over 500 students at four different levels.  Averaged 55 students per classroom. 

§         Completed seven secondary projects, including a series of maps for primary school classrooms.

  Education

 

 

University of Virginia                                                                                                                                                            1985–1989

BA, Economics and English Literature.

  Government Clearance

 

 

§          Minimum Background Investigation (MBI), passed June 2003

  Technical Skills

 

 

§          Operating Systems:  Windows 2000 Server and Advanced Server, Microsoft NT 4.0 Server, Microsoft NT 4.0 Workstation, Microsoft Windows 98 & 95.

§          Programming Languages: C#, VB.Net, Visual Basic, Transact SQL, ANSI SQL, Visual Basic Script, Visual Basic for Applications, JavaScript, HTML, DHTML, CSS, ADSI.

§          Databases:  SQL Server 4.5/6.x/7.0/2000, Microsoft Access 5.0/7.0/2000/2002.

§         Software Visual Studio .NET, Internet Information Server 5.0 & 4.0, Visual InterDev 6.0, Visual SourceSafe, Visual Basic 6.0, Professional Office Suite 2000, Microsoft Office Web Components, Visio 2000, Digital Dashboard 2.2, Internet Explorer 6.0 and below, Netscape Navigator 6 and below, Platinum ERwin, Rational Rose Modeler Edition, CSE HTML Validator, Microsoft Outlook, Crystal Reports 4.x/6.x/7.0/8.0.