SUMMARY:

• MS degree in Computer Science Technology Management with extensive experience in systems analysis, database administration, data mining, and reporting.
• Experienced Database Administrator managing large/small scale databases, clustered, replicated, and Azure Cloud based ensuring high availability with 99% uptime and disaster recovery.
• IT designs, development, implementation, and maintenance roles in public safety, business integration, Telecommunications, Windows Phone Operations and gaming environments.
• Skilled troubleshooter, capable of analyzing problems, identifying, and implementing practical solutions to technology issues.
• Crystal reporting expert using PSQL to formulate complex queries to display and pivot data in custom developed Crystal reports.
• Developed SSRS reports publishing Disk Utilization, Build Machine delta counts and Database growth trends.
• Implemented SSIS packages for Database Maintenance tasks, data Migration, gather data for reporting.
• Managed large scale reporting, development, SQL Server both stand alone and clustered highly available systems, web servers and internal services environments on physical hardware, VMs on Hosted hardware and in the Cloud Azure.
• Proven provider of customer experience delivering service to developers, external facing customers, and cross - departmental customers.

TECHNICAL SKILLS:

Hardware: IBM RS6000, PC, IMac, HP, Dell, Solaris, Compaq, Linux

Operating Systems: MS DOS, Windows NT, XP, 2000 Server, 2003 Server, Windows 7 & 8, UNIX, Solaris, Linux, Mac OS X, MS Cluster, Windows 2008 & 2012 Server

Databases: Oracle, MS SQL Server 2005, 2008R2, 2012, MySQL, Sybase

Languages: Visual BASIC, SQL, PLSQL, PASCAL, C, FoxPro, Professional BASIC, DOS Batch, Unix Script, SQR, People Code, VB.Net, VBScript, VBA, Powershell

Programs: MS Office Professional, Visio, Q+E, Source Safe, Visual BASIC V3, V4, & V5, MS Enterprise Manager, SQL Plus, Oracle Server Manager, Crystal Reports 3-11, Crystal Enterprise Server, MS Exchange, MS Internet Explorer, MS Access, SQA Suite, Lotus CCMAIL, Oracle Enterprise Manager, DB General, SQLAB, Autosys, Crontab, ODBC, Peoplesoft 5.12 - 7.53, ADP HRIZON payroll application, BMC Patrol, Starteam, SQL-LAB, Designer, T.O.A.D, Discoverer and CNTRL-M, Oracle Parallel Server with VERITAS, VERITAS Clustering, Tritech Visicad, Zol FireRMS, Northup Grumman Command Point, Bio-Key Packet Cluster Server, Packet Mobile, Packet Rescue, Reverse 911, Dictaphone, Telestaff, Visual Studio 2005, Netmotion, Heat, Locution, Vsphere, NWS Corrections, Police Records, Merge Client, Mobile, Fire Records, Updater, CAD.NET, Logmein, Webex, ICE 8.1, Issue Tracker, 123together.com, MS Active Directory, MS Office Professional, FTP, SSIS, SSRS, ASP, .Net Framework, Visual Studio 2005, 2008, 2012, Hyper - V, Build Tracker, System Center Operations Manager, IIS, Source Depot, Product Studio, Octopus 64, System Center Service Manager, Virtual Machine Manager, Visual Studio Online, Team Foundation Services, Azure Infrastructure as a Service, APTIFY CRM, SharePoint, EPIC Risk Management System

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

DBA Consultant

Responsibilities:

• Used SSMS to create an Entity Relationship Diagram of the base tables used by EPIC Risk Management Software to allow Vigilant’s staff to know what tables, views and stored procedures they could utilize for producing custom reporting out of the ERIC that utilizes Crystal reports.
• Instructed Vigilant staff on how to use SSMS, Crystal Reports SAP BI tool, and EPIC back end Database structure.
• Created detailed documentation on how to Create Crystal Reports using SQL Expressions, sub-reports, linking tables/ views, creating formulas, grouping, and summarizations.
• Worked hands on with the Vigilant staff to create 3 ERIC Retro Claim information from Design, researching Tables and views that will be used in the reports, implementing them in Crystal, validating/testing validity of the data, custom report charts in report footer and how to connect them to ERIC Risk Management System to be used.

Confidential, Bellevue, WA

Data Analyst

• Designed and Implemented scripts to clean up membership data removing 75% of the unwanted records making views that utilized this data 75% more efficient.
• Produced a customized integrated Process flow in Aptify CRM using an event handler and VB Script language to create have a web user account created and assign Web Administrator rights to the Web User account when a company assigns a person as the primary contact to the company record.
• Provided customized Crystal Reports, SQL Views and SQL Scripts to provide Finance and Membership tools to help them get reliable information out of the Aptify CRM system.
• Automated weekly GRIP AMS file processing using power shell to check AMS GRIP data against the GRIP data in Aptify.

Confidential, Redmond, WA

Systems Analyst II

• Perform Database Administration Tasks Backups, produce maintenance plans, performance tune, manage disk space and fix issues reported in SCOM for large and small scale SQL Server environments for the Windows phone division.
• Develop SSIS packages, Stored procedures, power shell scripts to collect information to report on the health and integrity of the internal SQL Servers.
• Provide reports to Microsoft managers on the overall health and storage capacities of the SQL Servers for them to make decisions on future hardware requirements.
• Provide excellent customer service to the Software Engineer Developer’s to deploy new code revisions, provide technical feedback to improve the deployment process and diagnose deployment issues encountered of both external and internal systems.
• Provide technical assistance to Software Engineer Developers to diagnose issues with SQL Server performance issues, data retention policies for disk space requirements, software issues in SSIS packages and trouble shoot issues on processing servers.
• Provide technical Root Cause analysis of issues encountered in deployments.
• Adhere to patching of all servers according to Windows Phone Service Level agreements.
• Built and Configured VMs using Hyper-V to deploy Web Servers, SSRS Servers and SQL Servers by installing Server OS 2012 and installing SQL Server 2012 with all server patches.
• Increased SQL Server performance on a Data Warehouse Server by finding a miss configured disk array for temp logs was set to RAID 5 reconfigured to RAID 10 which had an increased processing gain of 60% so, key performance integrator data could be generated and delivered faster.
• Spun up and used a Virtual Machine Manager System 2012 R2 to manage a hyper-v Server Farm and SAN attached Clustered 3 node VM farm.
• Build out new physical servers for SQL Server, IIS Websites and custom services servers.
• Develop tracking system for build machines that shows machine history of what machine group associations they have been assigned.
• Built out over 250+ VMs on premises physical Host servers, Azure Nebula, Azure IAAS to handle Auto Daily Updates for testing cell phones features used by the developers during the testing phase of future products. Performed under a strict timeline to meet an immediate company need and was completed on time.
• Spun up in Azure an Always on High Available with load balancing clustered SCOM environment for PPE and Production server monitoring.
• Supported and created High Available Always On High Available systems in Azure for Mission Control.
• Managed High Available Always on premises Clustered server 3 servers on read only for BNS for Build Tracker.
• Created supporting technical documentation and published it in SharePoint document store for the Operating Systems Group to utilize.

Confidential, Bellevue, WA

Tech Team

• Performed data analysis, designed, developed, implemented custom Call for Service Crystal report from both SQLServers 2000 and 2005 databases which then migrated to SQL Server 2008 R2. Did data mining and analysis requiring extracting the appropriate data from Tritech, and New World schemas providing specific call volume stats to calculate Call for Service for all 20 agencies using multi table joins in stored procedures and Crystal reports to present the data. This allowed Confidential to bill the 20 agencies for calls in their coverage regions to collect revenue to cover the Communication Center costs.
• Gathered requirements, designed, developed and implemented custom reports using advanced SQL queries in stored procedures for monthly call response times for Police officers, Fire officers and Communication Center for the King County to review to make sure Confidential was in the 99% response rate to receive funding.
• Created Ad-Hoc Crystal reports with complex queries using stored procedures pulling out data for police and fire calls for trending purposes tracking false alarms etc. This information provided billing information of companies with multiple false alarms.
• Responsible for 7X24 two CAD systems New World and Tritech, police, Commcenter, and fire consisting of 20 agencies providing support on a rotation schedule with co-workers. Maintaining 99% system availability and providing proactive database monitoring to performance tune and make sure the database was performing optimally. Monitored nightly jobs to ensure database backups and replication of the database to the data warehouse completed properly. Used system stored procedures in SQL Server 2000 environment and Dynamic Managed Views in SQL Server 2008 to look at real time server statistics and database statistics to make sure the database are running optimally.
• Adhered to strict change control management that included the design and implementation of a detailed test plan to provide a check that the change was successful. Utilized MS Clustering to update the OS system on the idle node then failed over the group to the idle node then performed maintenance on the OS system maintenance on the remaining node. MS Clustering and RAID 0+1 ensured the highest availability of the system when one node failed the MS Cluster would fail to the idle node that was available and the system would send a page for us to fix the failed node but the system remained in a functioning state.
• Maintained a fleet of police and fire vehicles across agencies ensuring their software and hardware were current and functioning properly.
• Deployed all the hardware and systems to support Backup Communication Center for Confidential .
• Prepared systems documentation describing how systems interact with each and Visio system flow diagrams created to show inter dependencies of shared resources.
• Designed, developed, and implemented the Confidential 911 first company Website using VB.Net and Active Server Pages.
• Reviewed and checked database logs and schedule SQL Server jobs to make sure they ran correctly.
• Completed all assigned Confidential issues utilizing the web based issue tracker system.
• Entered all issues of software, hardware, and computer related system problems into the Confidential issue tracker system. This gave Confidential a knowledge base to lookup similar re-occurring issues as well as track New World issues that have been escalated to vendor for resolution.
• Performed all necessary upgrades and system patching necessary to keep the OS’s and software systems current and functioning properly.
• Monitored and Managed a High Available Always on Clustered environment for the Communication Center for Tritech and New World dispatching software that had an SLA of 99.9% uptime and had to be reported to the state of the availability of the systems stats so we could maintain eligibility of state funding.

Confidential, Bellevue, WA

Systems Analyst II

• Designed, developed, and implemented several public safety applications (Vehicle Inventory Control with vehicle issue tracking web database application, Fire Work Orders, Police Mug Shot Interface, Confidential Website, and Amanda Time Tracking) written in VB.Net and had embedded Crystal reports in the Web Application to query and display the data.
• Used SQL Server Integration Service to move data from Payroll CSV file from Telestaff into the Payroll Database in SQL server.
• Converted 5 legacy DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2005.
• Conducted reverse engineering of database schema for data mining purposes and ran queries to get at specific call stats and response times out of Tritech CAD System.
• Worked with the Police Telestaff administrator to develop a customized payroll over time report that accurately reported all over time accrued by the officers.
• Collected various cellular carriers’ coverage statistical data and presented findings in Excel format to the battalion chiefs to aid them in selecting their agency’s data coverage provider.
• Overall responsibilities included providing support for 7X24 CAD, police and fire mobile on a rotation schedule. Maintaining 99% system availability and providing proactive database monitoring to performance tune and make sure the database was performing optimally. Monitored nightly jobs to ensure database backups and replication of the database to the data warehouse completed properly.
• Worked collaboratively with team members to coordinate and deploy the wireless system to both police and fire agencies.
• Established a solid relationship with dispatchers, fire officers, police officers and all end user customers to ensure prompt response and qualitative services.
• Oversaw several upgrades and patching to all public safety systems by testing the upgrade in a test environment and through interaction with end users to coordinate update and follow through to the production environment.
• Skilled troubleshooter.
• Successfully identified and solved several complex Public Safety systems issues.
• Solved an issue with Packet Rescue’s big button mobile interface, which saved the City $32,000 in software enhancements costs.
• Generated a successful ICF (Infrastructure Change Form) and acquired all the proper notifications needed to perform the change that the City IT required to upgrade or patch to Public Safety systems.
• This allowed the City to keep a log for their change management system. The ICF process ensured that a rollback plan was in place.

Confidential, Renton, WA

Crystal Report Writing

• Responsible for migrating 40 reports written in Microsoft Access database to convert them to run under Crystal Reports 8.5 and running out of a SQL Server database.
• Created four new Crystal Reports from user specifications to facilitate Confidential to the successfully transition to the Crystal Reporting and SQL Server database environments.

Confidential, Kirkland, WA

Database Administrator / Data Mining / Data Reporting

• Developed several Crystal Reports for the financial people to report on Asset Management, budgets information, and advertiser revenue reports.
• Designed, developed, and implemented the following business integration components:
• The advertiser campaign tracking system that included a revenue calculation engine using application engine.
• The star schema entity relationship diagram. Created several Crystal Reports for displaying site growth statistics, the database creation scripts, the extract transform and load routines used to maintain the ITV Basic Data warehouse and MCC Data warehouse.
• Acted as lead of technical group assigned to provide technical specifications and work breakdowns for project tracking.
• Ensured 99% availability in a 24/7 mode of operation of all production Oracle databases.
• Responsibilities included keeping databases sized, performance tuned, recovery managed using Oracle exports/Oracle recovery manager tools, and utilizing BMC Patrol Oracle monitoring software.
• Production environments included Peoplesoft financials (AM, AP, GL), Starteam version control system, Data warehouse System, Remedy help desk, Primus help desk, OEM Server, Discoverer, Designer, FAS finance, and Equity edge finance.
• Provided technical analysis documentation and recommendations for new hardware for additional CPUs and disk space.
• Also produced technical work breakdown documentation as well as weekly project status reports to ensure projects where done on time.
• Managed change control, which involved maintaining change control documentation that should the impact to the system being changed.
• Utilized Crystal Reports to display Oracle usage reports and availability statistics.
• Assisted in the implementation of the Peoplesoft 7.53 Asset Management module and writing code to migrate legacy asset data into Peoplesoft.
• During the implementation of the Asset Management module assisted in an audit of all hardware asset tags had to be performed in order to validate data integrity that was then used to load into the accounting system.
• During the design phase, business requirements documents had to be reviewed, provided feedback, modified, agreed with and then the technical specifications documents produced to provide upper management with what resources and time frames are involved with the projects.
• Identified internal infrastructure systems utilizing Visio to show graphically how systems interrelate. Internal system documentation was required for ease of code maintenance to facilitate the Rapid Application Design life cycle.
• Database systems where designed and documented with ERWIN to prototype the system and designer to produce the Entity relationship diagram, which then was converted into physical database creation scripts.