SUMMARY:

To obtain a position which utilizes my strengths as a team leader, or mentor in a Microsoft .NET application development environment using SQL Server 2000 - 2008 as back ends. I have developed custom tools and applications using the .NET framework for ASP Web forms and Windows Forms based platforms.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server DBA/SQL Developer

Responsibilities:

Perform all phases of Database Administration in a Multi-Database, Replicated Environment. Use .NET to automate SMO using C# to automate the movement of SQL objects and settings between environments and servers. Use C# to E-Mail reports formatted in and Excel spreadsheet. Published stored procedures according to guidelines put together by Plante & Moran. Build and tune stored procedures. Monitor SQL server statistics looking for negative trends. Built jobs, scripts and conducted T-SQL code reviews

Confidential

SQL Server DBA/SQL Developer 

Responsibilities:

Perform all phases of Database Administration in a Multi-Database, Replicated and Clustered Environment. Perform Partition Maintenance duties. Develop SQL Code to automate several Admin tasks like Index Maintenance and Foreign Key work. Develop various C# tools to work with foreign key maintenance. Participate on internal Confidential C# Framework and T-SQL Coding standards committees. Use .NET to automate SMO using C# to automate the movement of SQL objects and settings between Test, Development and Production SQL Server instances. Also created a stale data deletion project with both .NET and SQL server stored procedures. Member of company SQL Performance and T-SQL Standards Committees. Conducted several physical to virtual database server migrations as well migrations to an offsite disaster recovery location in Denver Colorado. Stood up Development/Testing/Productions tiers for multiple SQL Server Instances. This was all done in a clustered environment.

Confidential

SQL Server DBA/SQL Developer/ .Net Web and WN Client Development

Responsibilities:

Install, Monitor and re/configure 275+ SQL Server and SSRS Instances for High Availability, (clustering), 24/7. SQL Server versions and Editions would include anything from SQL Server Express to SQL Server Enterprise Edition. Develop SSIS packages to monitor disk space usage and job completion status from a given set of Critical Servers. I have addressed and improved several vendor database performance issues. I have also developed and deployed several SQLCLR assemblies as custom table triggers.

Confidential

SQL Server DBA/SQL Developer/ .Net Web Development

Responsibilities:

Primary DBA and SQL Developer for multiple SQL Server instances to build a Bonus program to incentivize Chrysler dealers and service line personnel to sell Chrysler approved products. Build C# .NET Windows Services and other applications to load a 500,000 line EDI file daily into the database as well as files in 6 other file types. Develop SSIS packages and convert and maintain existing DTS packages. Other accomplishments include the complete migration from SQL Server 2000 to SQL Server 2008 R2.

Confidential

SQL Server DBA/SQL Developer/ .Net Web Development

Responsibilities:

Developed an application to allow for the dynamic assembly of PDF documents to print vehicle brochures for every Ford automotive dealer in the world. The end integration tool is called XMPie. XMPie is controlled via web services all through the .NET Framework using C# and SQL Server 2000 and 2008. I am utilizing and administrating the SQL Server 2000 and 2008 R2 to collect all the data and make it available 24/7 as well as developing with ASP .NET 4.0 and ASP .NET 3.5 to develop custom server controls and web pages in C# as well as working with XMPie’s web services as a consumer using custom serialization/deserialization classes and methods.

Confidential

Senior SQL Server DBA

Responsibilities:

Primary DBA and SQL Server Developer for 6 SQL Server 2005 and 2008 servers and 100 Databases with thousands of connections. Assisted all developers in their T-SQL and stored procedure development. Analyzed databases for badly performing queries and rewrote them. Performed all DBA duties such as Backups and Restores as well as mirroring and replication and index tuning and DB Monitoring. Established and implemented T-SQL coding standards. Provided Classic ASP and ASP .Net code maintenance and new development projects to include ASP .NET web projects using. MVC, JSON, JQuery using both VB and C# as code-behind languages. Developed as WinForms projects as well. Wrote Web Service layers for various games and libraries as well as developed a completely new Data access layer for the .NET side of the house as well as re-working most of the access layer classes for existing core libraries in both VB .Net and C#.

Confidential

Lead Developer

Responsibilities:

Leading a project to produce a multi-threaded service to parse and store X12 HIPPA documents in a database as well to produce 270, and 835 HIPPA documents for the purposes of marshaling medicare billing on behalf of multiple school districts. Using c#, XML, XSLT and threading process models.

Confidential

Database Consultant Valassis

Responsibilities:

Developed a news paper pricing web service for spot advertisements, using with C# as the code behind. Created stored procedures for Microsoft SQL Server 2000 and Oracle 10G as well as web service Data Access Layer (DAO) used in serializing and de-serializing data. Assisted Junior developers in their Oracle Package design and T-SQL design for SQL Server Stored Procedures.

Confidential

Process Analyst

Responsibilities:

Troubleshoot production issues related to SQL Server, ASP.NET, or C# by solving the issue myself or getting other outside or outsourced parties involved in the solution so that production SLAs continue to be met. Testing of third party outsourced software in various environments by constructing test servers and scenarios. Developed several Windows Forms service application to store Event Logs to other locations on timer. Technologies used included SQL Server, .NET Framework 2.0 utilizing both Windows Forms, WMI and ASP .NET WebForms.

Confidential

Senior Application Developer

Responsibilities:

Created advanced custom high performance SQL Server T-SQL Scripts and procedures for our support team to assist them with specific customer requests. This was very well received and appreciated. I also localized VB6 clients as well as .NET ASPX web pages with using both C# and VB .NET framework 1.1 and 2.0. Localization was accomplished using XML, XSLT and SQL Server DB calls. Converted VB6 DCOM ETL and Windows Forms application to Web Forms and .NET Managed Code. Implemented 508 compliancy within some of the ASPX Web based custom controls.

Confidential

Senior Developer

Responsibilities:

Responsibilities included creation tables, stored procedures, views, triggers, DTS packages and cross tab reports for MS SQL Server for a worldwide organization for both J2EE Struts and C# .NET front ends as well as using T-SQL objects and scripts to interface with back end billing, provisioning and CRM systems in a very fast paced and demanding telecom environment. Extremely comfortable Performance tuning with SQL Query Analyzer, Enterprise Manager, DTS as well as Advanced Query Tool (AQT). I have also assisted in the development of best practices coding standards and code promotion for T-SQL developers which all developers are to follow. I have written DTS based object backup scripts for moving entire databases and data subsets for the purposes of building full functioning server and server instances for testing environments. I have participated in peer code review and code promotion exercises. I have also built several Excel based Macros in VBA to ease some repetition in query building when Excel is the data source for specialized data loads. Additional implementation details and information will be provided as is necessary.

Owner

Confidential

Responsibilities:

Partly while at Nextel I co-created a telecommunications commission tracking and customer retention and CRM system for the cellular industry. Responsibilities included were network design and deployment, database design and T-SQL stored procedure creation for SQL Server 2000, ASP .NET and VB .NET. This application was designed and deployed at a remote co-location (XO Communications, Livonia, MI ). I also created a development domain based on Windows Server 2003. Additional tools and equipment configured by me were Cisco PIX firewall, Dell 2650 servers, Verisign, .NET framework, IIS for Win 2003, Microsoft .ASP NET framework 1.0 and 1.1, with VB .NET implemented in a code-behind manner, SQL Server 2000 as the backend. I also implemented ASCX .NET custom controls for the web pages infused by way of reflection, I also designed CRM and cellular based financial tools for small and medium businesses sized organizations all based on commission statements. Automated Internet Explorer using COM, Additional implementation details and information will be provided as requested.

Confidential

Contractor / Sr. Developer

Responsibilities:

Charged with finishing the sales force automation and automated provisioning project begun in August of 1998. I finished job started the year prior and I acted as a project lead and DBA for several projects including the installation and management of MS SQL Server versions 7/2000, and IIS 4/5 for NT 4.0 and Windows 2000 domains to accept internet and intranet requests from the sales team using ASP and ASPX web pages. I designed these web pages to receive data and update MS SQL servers. I built additional automation tools to automate Attachmate telnet clients using COM for activating phones, selling phones and accessories, checking new customer credit and creating new customer accounts. Technologies I used incl. using Visual Basic 6 for automating Attachmate’s Extra Personal Client. I used Seagate’s Crystal Reports 8.5 for reporting in asp and ASPX web pages, VB Script, HTML. I also mentored 3 people on the team. Other projects included an ASP.NET Facilities management application as well as a .NET Service and repair application for the service center phones.

Confidential

Contractor General Motors Proving Grounds / Programmer

Responsibilities:

I deployed television set top boxes for a conferencing project, which were engineered to receive video broadcast over multicast IP using Cabletron switching equipment. I also produced a MS Access ’97 database to inventory all involved equipment. I created a Microsoft Word tool to automate the conversion of several documents containing embedded ABC flow chart objects to Visio 2000 objects. This benefited EMC Corporation (An onsite firm contracted by GM at this location).

Confidential

SysAdmin

Responsibilities:

Secure user permissions on several Windows NT 4.0 Enterprise Edition clusters. The clusters were running on Confidential server hardware. I also created process documentation to help transition new ABN-AMRO employees into their role. Assisted with supporting a server management a proprietary SQL server based mortgage application based SQL Server 7.

Confidential

SysAdmin

Responsibilities:

Deploy IBM Thinkpad and Desktop computers and enforce desktop standards for the Office. Configure and deploy Microsoft Windows ’98 as clients to a Windows NT 4.0 hosted environment. Maintain Microsoft Exchange client accounts as well as NT Server client accounts. I created documentation on current procedures for ISO 9000 compliance.

Confidential

SysAdmin

Responsibilities:

I was responsible for performing data recovery and storage of ADP Hourly Employee time tracking operations using Arcserve 6.5 hosted by Windows NT in a Netware 4.x environment. I created several reports of ADP data using Inprise Reportsmith report writer. I created and fixed several MS Access '97 databases. I also provided miscellaneous support to the plant, office and administrative staffs. I also created documentation for new and old procedures and processes.Tools Used:MS Access 97, Reportsmith, ARCServe, Windows NT, HP UX 3.0

Confidential

Independent Contractor / VB6 Programmer

Responsibilities:

I created an automated order entry process primarily using the strengths of Microsoft Access ’97 and Visual Basic. I developed the COM interface between Access ‘97, and Attachmate’s Extra Personal Client ActiveX control. This process helped to decrease phone activation times from two weeks to two days. Phone activation costs went down from $12 per phone activation to $1.50 per phone activation. This project was a 50-hour contract performed in the evenings and weekends and was primarily a proof of concept model that became the standard and later adopted by the Nextel at their corporate headquarters.Confidential Health System.I was directly responsible for several projects in the Cardiology department including the implementation and support of a Microsoft Windows NT 4.0 Workstations as clients in a Novell Netware 4.0 environment. I also provide daily helpdesk software support to doctors, nurses and secretaries. I also developed a patient tracking system and Computer Asset management system using Microsoft Access ‘97. Two co-op students reported to me on a daily basis.

Confidential

Programmer / System Administrator

Responsibilities:

I was responsible for the deployment and maintenance of a client server network hosted by Windows NT Server 4.0-network software for 1 local and 4 remote sites. The network topology is 100Mb Ethernet. My clients used Windows NT Workstation. The application of these tools was in the Banking Industry. All sites and clients are connected via WAN using the TCP/IP protocol. The customers for which I provided network hardware/software support were in five centers plus our on-site Systems Engineering team. The total client base was 500. I was also responsible for all aspects of system policy establishment, and maintenance including hardware and software acquisition/installation, troubleshooting, integration and upgrades. I was also responsible for keeping accurate system documentation and inventory records of all production and administrative computer equipment and software for all sites. Using Microsoft Access I was able to develop and maintain a Project Tracking System. Using the Project Tracking System each team member was able to account for their time applied toward any one project as well as the project status according to the EDS Systems Life Cycle 3.0 methodology. Using this information, customers were billed accordingly and future projects were estimated more accurately. I acted as a Microsoft Access 2.0/Novell 3.12 consultant, I was able to contribute to the completion of several projects. I also contributed to the effort of setting development standards for the UAW Microsoft Access 2.0/7.0 development teams.

Confidential

Novell System Administrator

Responsibilities:

Performed primary network administration for 6 Novell 3.12 file servers including remote and local client access to several IBM AS/400s and two Digital Vax servers. Connectivity applications included Digital's Pathworks and IBM's PC Support. I was also responsible for implementing backup procedures for the Novell servers as well as performing the backup and recovery operations. I assisted management with the capital purchases of microcomputer hardware and software. I trained senior management in the use of standardized software. Responsible for keeping accurate inventory records of all hardware and software used in the Novell server system.

Confidential

Data Technician

Responsibilities:

Assist in the maintenance, monitoring and operations of patient care terminals, printers and remote job entry configuration. Maintained accurate records of all related information system equipment for three sites. Acquired communication skills and the ability to interact with all levels of management. Responsible for the installation of various software applications designed for the Intel family of processors. I was responsible for the instruction of hospital staff and senior management in Personal Computer related tasks. I researched software/hardware and wrote relevant articles which were included in corporate publications.