cyberstrike

Skills Languages C#, VB.NET, SQL, T-SQL, SQLCLR, PL/SQL, ASP.NET, XML, Perl, Python, C++, JavaScript, VBScript, HTML, VB 6, and Visual Test 6 Technologies SSRS, SSIS, EMC Centera, Web Services, XML, SMTP, FTP, COM, XML, ActiveX, API Development, Enterprise Library, Composite UI, Updater Application (for providing update capabilities to application), Data Access, Configuration Blocks Tools SQL Server 2008, SQL Server 2005, SQL Server 2000, SQL Server 7, Oracle 9.2, Marathon everRun, Visual [login to view URL] 2005, Visual [login to view URL] 2003, MySQL 5, Crystal Reports 9, Crystal Reports 8.5, Crystal Reports 7, Movable Type, VSS, Citrix, IIS, VMWare, Infragistics, TrueDBGrid, Pegasus ImagXpress, Toad, Ascent 7.0 (Kofax Extension), and Regular Expressions (regex), Litespeed Certifications MCITP: Database Developer (SQL Server 2005), MCTS: SQL Server 2005 Experience 12/2007-Present Station Casinos Las Vegas, NV Database Systems Manager * Managed one DBA and supervised his efforts on various projects. Responsible for performing performance reviews, hiring, and interviews. * Developed capital expenditure requests, maintenance expense requests, and Gantt charts for major projects. * Provide maintenance, performance tuning, and high-availability support for 100+ SQL Servers over both 2000/2005 comprising 180+ production databases. Developing high-availability, no downtime systems utilizing a combination of SQL Server replication, clustering, database mirroring, and virtualization. * Managed the conversion of 26 SQL Server 2000/Windows Server 2000 clusters to SQL Server 2005/Windows Server 2003 without any downtime on the database side utilizing replication and database mirroring. * Provide performance tuning advice to development teams on: horizontally partitioned views, partitioned tables with aligned partitioned indexes, indexed views, splitting IO across filegroups, configuring statistics nightly, setting allocation units on NTFS to the recommended 64k for extent writing, and tweaking max DOP settings. Eliminating hash joins, forwarded records, cursors, correcting locking/blocking issues, designing/implementing queuing systems, and correcting index usage. * C# development on various applications using [login to view URL] 2005 Team Systems, SQL Server Reporting Services, SQL Server 2005 and CR 8. * SSIS package development for data loads, extractions, and OLAP to both Oracle/DB2 DBMS systems. * Installed/Administered 25+ SSRS deployments for various systems utilizing n-tier architecture to separate database/app layers. 6/2006-12/2007 International Gaming Technology (IGT) Las Vegas, NV Software Engineer III * Mentored three software engineers and supervised their efforts on various projects. * T-SQL development on SQL Server 2000/2005 for 75% of the casinos in the world. Development and troubleshooting on various casino databases that the slot machines connect to (I.E. High transaction environments/high up-time). Database sizes ranging from 40gig to 2TB (30+k trans/sec). Heavy emphasis on high performance code, database performance optimization, database maintenance procedures, and Marathon everRun FT/HA configurations. Provide guidance to casinos on proper maintenance and performance turning. * Championed various database architecture projects to reduce database load by 40% or more on the largest casino player management system in the world such as: horizontally partitioned views, partitioned tables with aligned partitioned indexes, indexed views, splitting IO across filegroups, configuring statistics nightly, setting allocation units on NTFS to the recommended 64k for extent writing, and tweaking max DOP settings. Eliminating hash joins, forwarded records, cursors, correcting locking/blocking issues, designing/implementing queuing systems, and correcting index usage. * Reviewed RFPs, specifications, and completed outsourced projects to ensure compliance with specifications, then assumed control of outsourced code providing further maintenance/expanded features. * C# development on various applications using [login to view URL] 2005 Team Systems, SQL Server Reporting Services, SQL Server 2005 and CR 8. * SSIS package development for data loads, extractions, and OLAP. * Managing interfaces with products such as machine/cage accounting, concentrators, translators, CWS, CommHub, ADI, LMS (reservations), Infogenesis/Agilysys, Mariposa (data warehouse), Micros, Stratus, Opera, CMS, and Tandem. 10/2005-6/2006 Clearview Software Auburn Hills, MI Programmer IV * Mentor and provide advice to two programmers. * Development/maintenance of N-Tier systems that included security, common, data, and UI layers as well as web service APIs. Including an application that automatically installs, updates its’ application files, and accesses web services APIs. Composite UI block functionality allowed components to share state, events, and dependency information across components. Data access layer allowed the backend system to be Oracle, SQL Server, Informix, MySQL, or any other DBMS. Configuration layer allowed configuration information to be stored in registry, database, and config files as well as allowing easy addiction of new configuration sources in the future. * Content management development using C#, XML, SQL Server 2005, SQLCLR, Infragistics, Enterprise Library, Composite UI, Updater Application, Data Access, Configuration Blocks (Microsoft Patterns and Practices) and Kofax Ascent 7.0 with COM-Interop. 1/2005-10/2005 Edmond Scientific Detroit, MI Senior Software Developer * Coordinate/supervise project efforts of three diversified team members within a sixteen member team. * Subcontractor for GM and Xerox. Content Management development on GM Legal software with VB 6, Oracle 9.2, Centera, CR 8.5, MS SQL Server 2000, Toad, Infragistics Toolbars, TrueDBGrid, and Pegasus ImagXpress. Connected GM Legal software to EMC Centera system via Centera SDK, buffered streams, and COM Server. * Assumed control of outsourced code providing maintenance and expansion of outsourced code to include new features. 6/2001-1/2005 PMAI Jackson, MI Software Developer * Developer of an automated batch reporting system using MS SQL Server 2000, Visual [login to view URL], Crystal Report 9 Namespaces, and SMTP engine. * Visual Source Safe (VSS) Administrator. * Developer of applications and reports using Visual Basic 6, Crystal Reports 7, Crystal Reports 8, Crystal Reports 8.5 RDC, Crystal Reports 9, VMWare (virtual machines), Microsoft SQL Server 7, Microsoft SQL Server 2000, ASP 3.0, ASP.NET, Regex, C# (CSharp), Cold Fusion, COM and .NET FTP engines, Microsoft SQL Server Report Services, Perl, IIS, CGI, Citrix, iMIS, and integration of EXPOCad with another application. 9/1999-6/2001 Creative Solutions Inc. Dexter, MI Software Developer * Modular programming in Rational Visual Test 6 (a hybrid of Visual Basic and Visual C++), including use of advanced OLE functionality. Performed automated regression testing for QA. * Used PERL, Python, C++, OLE, SQL, regular expressions (regex), and ADO for maintaining automated build programs, development of new tools, and accounting application development. * Writing reports using Crystal Reports 8. 9/1996-6/1999 Baker College Flint, MI Head CIS Tutor * Manage approximately sixteen CIS tutors. * Tutored RPG IV, COBOL, Visual Basic 5, C, and C++. Education 2001 Baker College Graduate Studies Flint, MI MBA, Master of Business Administration GPA: 3.93 Major: Computer Information Systems Management 2000 Baker College Flint, MI BBA, Bachelor of Business Administration. Major: Computer Information Systems, Minor: Management. Overall GPA: 3.92, Major GPA: 3.97, Minor GPA: 4.00. 1999 Baker College Flint, MI AB, Associate of Business. Major: Computer Information Systems/Programming. GPA: 3.9, Faculty Honors (student with most potential in the technology field).