Kirsten (Kt) Smith Email & Phone Number

Seattle, Wa

Provide technical consulting services for numerous regional clients in both the non-profit and for-profit sectors.Implemented source control, development standards and report documentation framework for numerous clients.Converted over 200 Crystal reports to a consolidated number of SSRS reports with corresponding end user and technical documentation.Built complex, robust ETL system per Optum File Import Specification to upload mental health data for processing and payment.Created SSIS and SSRS solutions to support large wholesale HVAC distributor’s conversion to Epicor Prophet 21 ERP software.Designed, developed, and documented robust ETL framework to import K - 12 school data into SQL 2012 reporting database.Helped numerous companies develop, document, and implement coding standards and version control.Wrote scripts to pull data set from ClientTrack human service database for Public Health for King Co. PH Health Care for the Homeless Network (HCHN) Database Project.

Seattle, Wa

Automated change and validation process for highly volatile, complex domain data hierarchies, thereby drastically reducing QA costs and downstream impacts.Active member of onshore/offshore Sustainment team using formal Agile methodologies.

Seattle, Wa

Technical resource on enterprise data warehouse, including design, development, testing, implementation, and documentation of database, ETL, cubes, SSRS, and PerformancePoint.Developer on project to migrate multiple source systems to SQL Server 2008 iVantage HRIS system, including data mapping, conversion, and migration as well as SQL Server installation and configuration.Lead developer on complex integration project consolidating key business data into master record database.Initiated version control and database administration and development standards, process, and procedures.Designed, developed, and unit tested contracts / agreements database using agile development methodology.

Seattle, Wa

Created complex Crystal Reports that pulled data from Adonix ERP X3V5, a software solution that addresses mid-sized enterprise's needs in finance, sales, inventory, CRM, purchasing and manufacturing operations.Wrote SQL views and stored procedures to support efficient report execution and ease of code maintenance.Wrote stored procedures and batch file to pull data from Cheftec database and format the data for proper import into Adonix database.Initiated version control, development standards, and report documentation processes and procedures.Performed security, disaster/recovery, and configuration best practices audit on all company SQL Servers.

Redmond, Wa

Built and configured components of Amalga, Microsoft’s unified health enterprise informatics platform, for customer-specific data using both SQL Server and tools inherent in the Amalga system.Used SQL Server tools and applied technical knowledge to troubleshoot configuration issues.

Renton, Wa

Primary DBA for HealthServicesNW, a joint venture between Providence and Swedish Medical Center that provides patient billing, insurance billing and collection, and account maintenance.Installed, configured, secured, administered, and supported numerous clustered and non-clustered SQL Servers.Performed rotating, 24x7 on-call support for over 50 SQL and Oracle servers hosting hundreds of critical healthcare databases.Worked with customers and web developers to define and document user requirements and system architecture.Modeled, designed, developed, and unit tested multiple SQL Server 2000 and 2005 databases.

Solely responsible for multiple mission-critical SQL Server databases and server.Developed new software application for room scheduling using SQL Server / Visual Basic.Accountable for all aspects of health data transfer from agency to Pierce County Regional Support Network.

Lakewood, Wa

Wrote stored procedures, triggers, and custom data windows to enhance functionality of PsychConsult.Created numerous complex Crystal Reports and enhanced existing reports.

Issaquah, Wa

Initiated structured test effort for Litigation Support database systems.Constructed test tool in Visual Basic that lead to improved quality of Litigation Support production data.Wrote stored procedures and T-SQL scripts to test database components.Completed test plan preparation and execution of database, COM objects, and UI.

Bs, Genetics

Aa, Information Technology - Client / Server Programming