Jim Killian Email & Phone Number

Remote

Burbank, Ca

Create/Maintain SQL reports in support of department users. Work with department personnel to gather reporting requirements. Monitor ticketing queue for relevant user issues.

SQL Server 2008 Master's ProgramThe SetFocus SQL Server Master's Program is an intensive, hands-on, project-oriented program where participants gain knowledge and valuable experience putting the SQL Server skill set to use in a simulated work environment.Highlights include using these technologies:• SSMS to create tables, queries involving joins, subqueries and CTEs, functions, and stored procedures.• BIDS to create SSIS packages to move data between SQL and external sources/destinations.• BIDS to create SSRS reports, uploading them to the server and setting up snapshot and email subscriptions.Projects: ○ PiggyBank - Banking account and customer tables, triggers, procedures and functions using SSMS. ○ SSIS/SSRS - Use CSV data to populate a SQL database and make future updates, and create reports using BIDS. ○ BlockFlix - Final team project to create an entire SQL database setup for a DVD rental company with online queue building, stores, and kiosks using everything learned in the class.

Promoted to positions of increasing responsibility while working on Dell client accounts: Catholic Healthcare West and Stanford Hospital. Member of applications team supporting multiple systems. Designed applications and reports for customers and teams.

Liaised between MIS and Baseball Medicine, Baseball Business and multiple front-office departments. Managed PC platform using MS Access and Java. Coordinated with trainers in LA and worldwide. Co-created medical inventory system using Java.

San Fernando, Ca

Supervised warehouse inventory personnel. Provided guidance to warehouse management regarding computer-related issues. Local administrator of NetWare 3.11 LAN, spanning five buildings in four cities.Key Results:• Rewrote and maintained "warehouse locator system" database utilizing Clipper 5.1, which created work orders for moving merchandise based on daily order fulfillment.• Implemented barcode printing and scanning within the warehouses.• Designed wholesale shipping labels and utility for printing them as needed.• Created several utilities for the admin group, including time tracking, container tracking, and utilities for filling out pre-printed, multi-part forms.

Certification, Sql Server 2008 Master'S Program

Extension, Java Programming

Associate Degree, General Studies