Sql Server Management
Resume:
Steven R. Davisson
Randolph, NJ 07689
********@*********.***
SUMMARY: Experienced in full project life cycle development of business software systems in Windows and Web environments.
Databases: SQL Server 2000/2005/2008/2008-R2/2012, Oracle, Access.
Programming languages and packages: ASP.NET, C#, VB.Net, JavaScript, ADO.NET, T-SQL, SSIS, SSRS, VS-2003/2005, TFS-2005/2008/2010/2012, Infragistics, Telerik, SpotLight, LiteSpeed, Redgate
Platforms: Windows XP, 2003, 2000, 7, 2008 Server, 2012 Server
Other: Able to identify, understand, and resolve complex technical and business issues quickly. Proven ability to thrive in dynamic results orientated environments. Can work independently or as part of a team. Strong team building and leadership skills.
PROFESSIONAL EXPERIENCE:
08/15 to Independent Consulting
Present
Environment: SQL Server 2008 R2/2014 Compact, T-SQL, TFS-2010/2012, C#, ASP.Net, SSIS
Dean of Chess Academy suffered a hard drive crash and did not have access to the source or licenses that would be needed to rebuild the system.
-I suggested replacement hardware
-Installed SQL 2014 Compact, Visual Studio Community and assorted other components
-‘Disassembled’ existing DLLs in-order to identify what modules were actually part of the app
-Setup IIS to host the app
-I still provide DB services and have made several enhancements to the system
Arna Marketing
-I provided database services for ETL, maintenance, and system automation
03/14 to Ellie Mae Inc. – Software Developer
08/15
Environment: SQL Server 2008 R2/2012, T-SQL, TFS-2010/2012, Framework 4.5, C#, ASP.Net, Perl, Excel VBA, Agile, Entity Framework, WCF
Ellie Mae’s mortgage pricing engine had been designed to provide only the most current loan pricing and qualification information to loan originators. The industry was pushing to have historical pricing and qualification information be available.
-Designed and implemented database design changes to support the temporal requirements. Tables, Indexes, Procedures and Functions
-Used Query Analyzer, Profiler, and DTA to optimize indexes, procedures, and functions, identify missing indexes and statistics, as well as, identify and remove un-needed indexes
-Provided training to other team members on the usage of SQL Server performance analysis tools
-Used C# and ASP.Net to developed the screen flow and processing pattern for the first group of qualification objects that needed to be made temporally aware. This pattern was used by the other developers on the team for the development of the other qualification related objects
-Redesigned the loan pricing batch import process, improving throughput by 30% using VBA and Perl
05/10 to Ricoh Americas Corp. – Principal Engineer
11/13
Environment: SQL Server 2008 R2, T-SQL, TFS-2005/2008/2010, Framework 2.0/3.5/4.0, ASP.NET, Webform, Winform and Console applications, VB, C#, ADO.NET, JavaScript, WCF, SSIS, SSRS, SpotLight, LiteSpeed, RedGate, Infragistics, Telerik, TortioseSVN
The AtRemote system, an outward facing collection of 43 regional web sites (combining Webforms and WCF web services), a handful of Windows based process control apps using Winforms, and a Console app for importing CSV data feeds, is a data import and reporting system to provide customers with information about how their image processing systems, printers, copier, faxes, etc., are being used. When managing a large fleet of such devices getting reliable, timely information is valuable. As the application grew in strategic and marketing importance, I was brought on board help bring the development in-house.
During the initial phase my focus was on:
-Web development in C# and ASP.Net, of new required features for the web sites.
-Implemented technics to improve data movement between the client and the server
-Windows development required for the process control apps as new sites where introduced.
-Developing and implementing a plan to re-factor the existing code into a proper OOP architecture.
-Replacing the dynamic SQL that ran throughout the application with stored procedures.
-Trained junior developers in .Net OOP techniques, C#, ASP.Net, and SQL Server.
-Standardizing our use of the 3rd party control sets from Infragistics and Telerik.
In the second phase I focused on the databases. We had 17 regional reporting databases, a staging/consolidated database and a few other ‘shared’ databases on the SQL Server instance using Spotlight to monitor SQL Server’s overall health. The combined size of the databases was over 4TB containing 1.5 billion records, with 1.5 million new records, approx. 1.5GB, arriving daily. Reports were running slowly and the daily importing and calculation processes were not always keeping-up.
Based on analysis of the database issues I:
-Used Redgate’s tools to identify and resolve structural differences between the regional databases
-Partitioned key large tables by accounting period.
-Used Query Analyzer, Profiler, and DTA to identify opportunities for performance improvement
oModified certain indexes;
Changing the order of the columns in the index.
Added ‘covering’ columns.
Replacing, where appropriate, ‘unintelligent’ clustered indexes with other unique indexes that were already defined on those tables.
oRemoved, as appropriate, indexes that were never used in any queries execution plan.
-Created/Modified T-SQL procedures and functions s needed to accommodate new table structures or for performance reasons
-Implemented a process to intelligently manage index fragmentation and statistics on all tables.
-Modified LiteSpeed execution plans to be sensitive to accounting cycles and only execute as needed.
-Optimized the ‘batch import’ process, reducing execution time from 14 hours to 6 hours.
oThis step led to plans to rewrite the ‘batch import’ either as a self-scaling multi-threaded C# application or an SSIS package. I was responsible for the creation of the C# application in VS-2010/Framework 4.0, and the knowledge transfer to the SSIS developer. Ultimately, a combination of the C# and the SSIS was chosen.
I helped plan and execute the migration of our data center from physical servers to VSphere based VMs and the SQL data store from a 4 logical drive SAN environment to a 3 logical drive NAS with minimal down time. The NAS proved, as we predicted, to slow. A second migration for the data stores to a new 4 logical drive SAN was required
11/04 to Tiffany & Co. – Lead Applications Developer
04/10
Environment: SQL Server 2000/2005, T-SQL, VS-2003/2005/2008, Framework 1.1/2.0/3.0/3.5, ASP.NET, C#, Web Services, ADO.NET, JavaScript, RSA Clear-Trust, JD Edwards, Data Mirror, MQ-Series.
The Vendor Resource Management (VRM) application which allowed the suppliers and Tiffany’s engineers to exchange bill of materials and routing information. This was written in classic ASP. They wanted to migrate it to .Net.
To port the ASP code, I:
-Trained developers in OOP concepts
-Created the architecture for the UI, BO, IO, and Data Access layers
I then moved to the database
-Modified database structure to accommodate new application features
-Optimized database objects using Query Analyzer, Profiler, and DTA
The Diamond Division had been emailing Excel sheets to track diamonds being processed by outside contractors. This was somewhat error prone as multiple parties would attempt to update a given Excel sheet without knowing if theirs is the most current one.
To address this, I:
-Created the application architecture, as above
-Designed the screens
-Designed and created the database and performed database optimizations using Query Analyzer, Profiler, and DTA
This application allowed the contractors to enter their data directly into a database eliminating the data entry conflicts and providing Supply Chain Management with an accurate view of the product pipeline.
The Quality Management Publications (QMP) system allowed the suppliers access to technical documents being provided by Tiffany’s internal departments. I created a Content Management System (CMS) that allowed content providers control over their portion of the portal.
In addition to my work on the portals and their applications;
-I was my team’s representative to groups evaluating the cost/benefit of adopting new development environments/technologies from Microsoft, ie: VS-2005/2008/2010, TFS, WCF.
-I coordinated with IT infrastructure groups on OS and IIS Platform changes, the migration from SQL Server 2000 to 2005, and changes to the RSA security infrastructure.
-Developed proof-of-concept applications to evaluate new technologies: Usage of MQ-Series messaging from a .Net web service, exposing our portals through SharePoint.
11/03 to FYI Systems Inc. – Staff Consultant
11/04
Matheson Tri-Gas – 11/03 to 11/04
Environment: VS-2003, Framework 1.1, ASP.NET, C#, XML Web Services, ADO.NET, JavaScript, SQL Server 2000, Crystal Reports.
From a business perspective the big issue was quality control. From a technical perspective the big issue was an IT staff mired in legacy technologies. My role was to train them in web and object oriented technologies and then help them design a system to: a) Capture product specifications, standard and custom; b) Capture and track post manufacturing analytical data; c) Make the specifications and analytical actuals available internally and to the customers through a responsive and attractive UI in a very low bandwidth environment.
-Trained existing IT staff in web development technologies and specifically the .NET tools.
-Designed and created base classes to provide the framework for ongoing development.
-Worked with users to refine requirements, documents, and design the UI layer.
-Worked with Matheson IT staffers on the design of the database, IO, BO, and UI layers.
-Developed several modules for each layer.
-Managed developer workloads and provided management with project status.
02/03 to Wyndermere Enterprises Inc. – Staff Consultant
11/03
Pinnacle Foods Corp – 02/03 to 11/03
Environment: Framework 1.1, ASP.NET, XML Web Services, ADO.NET, Oracle 8i, Windows 2000, Design Patterns.
Due to Signiant increases in the number of product lines, and the diversity in how forecasting and marketing promotions were reported, upper management wanted a new system that would allow product managers see their information in a familiar fashion, but report t in a standard fashion. All items needed to meeting phase 1 requirements and several phase 2 items were included in the initial planned timeframe.
-Worked with analysts to identify and resolve requirements issues.
-Designed the application’s architecture.
-Helped design a flexible, customizable, UI layer.
-Was responsible for the development of the BO and IO layers.
-Moved the calculation module to a series of data driven web services.
-Provided production support and made performance tuning adjustments as needed.
04/93 to Independent Professional Services, Inc. - Senior Technical Specialist
01/02
As a member of the applications development staff I held key positions on several projects for the company’s major clients.
United Parcel Service – Senior Programmer Analyst / Team Lead - 8/98 to 5/02
Environment: VB.NET, ASP.NET, Framework 1.0 Beta, VB 6.0, SQL Server, Access, COM, DCOM, NT 4.0 Windows 2000.
The Global Sales Compensation System (GSCS) reduced the average time needed to calculate sales commissions from 10 to 3 weeks for all business units. The new hierarchy allows each business unit to define compensation plans with the features they need while providing corporate analysts with a homogeneous view of the data across all business units.
-Worked with the user representatives on application requirements.
-Designed object hierarchies, logical and physical databases, and several key components.
-Directed, tracked, and reviewed the development efforts of 3 to 5 junior developers.
-Produced project plans and status reports for project management.
-Participated in performance reviews of UPS employees.
-Provided 3rd tier production support.
-Trained other developers on; GSCS internals, data modeling, and object oriented development.
Yasuda Fire and Marine Insurance Company - Lead Developer / Project Leader - 6/97 to 6/98
Environment: VB 5.0, Access 97, Windows 95, COM, DCOM, Excel VBA, Word VBA, SQL-Server, NT 3.51.
Yasuda would have been forced to halt operations in Mexico if it couldn’t transform its’ insurance brokerage there into a fully licensed insurance company by the end of 1998. Underwriting, Re-insurance, Claims, and Accounting modules were required as a minimum. Working closely with user reps and project management, I led teams in the US and Mexico through an aggressive, successful, development effort.
-Worked with users to develop business requirements and screen designs.
-Designed the application architecture, object hierarchies, client and server side databases.
-Developed and demonstrated a prototype to Yasuda management in the US and in Mexico.
-Coordinated the efforts of the 2 development teams. Five developers in New York and 10 in Mexico.
-Produced project plans and tracked progress against those plans for reporting to upper management.
-Developed and implemented plans transitioning all future development to the Mexico team.
New York Life - Technical Specialist - 1/97 to 6/97
Environment: VB 5.0, Access 97, Windows 95, COM, DCOM, SQL-Server 6.5, NT 3.51.
In order to simplify maintenance and reduce future development costs, New York Life’s customer service organizations wanted port all existing desktop applications from C under OS/2 to VB under Windows 95.
-Taught NYL developers VB 4.0, Windows 95, and Object Oriented methodologies and techniques.
-Developed templates for base applications, as well as, In-Process and Out-of-Process OLE servers.
-Converted application modules, providing detailed explanations of the techniques used and why.
United Parcel Service – Sales Applications - Technical Lead - 1/96 to 1/97
Environment: VB 4.0, Access 2.0, NT 3.51, Oracle 7, UNIX, DB2 on IBM mainframes
The new Bid Management System had two main goals; it had to combine the data from these systems in a way that the users saw it all as being from a single source, the users needed to be able to work in a language and currency of their choice. With a large developer it was essential to hide the complexities of the data layer from the developers of the business rules and presentation layers.
-Helped design and develop a robust multi-tier middle-ware layer.
-Worked with outside vendors to evaluate database connectivity tools.
-Selected database connectivity tools for use by client side developers.
-Helped design and develop an ‘Internationalization engine’ to perform on the fly language and currency conversion so that developers only needed to code to US English standards.
Allied Signal – Performance Materials Division – Programmer Analyst - 4/93 to 1/96
Environment: VB 3.0, Access 2.0, Windows 3.1.
Working directly with the Financial Controllers Office, I designed and developed applications that reduced the month-end closing process from 7 days to 2, freeing 2 of their analysts to focus on other issues.
-Worked with analysts to develop requirements.
-Performed all development tasks; database design, UI, reports, and processing logic.
-Worked with technical writers to develop User Guide and On-line Help.
-Trained business area managers to effectively use the new applications
EDUCATION:
Manhasset High School, Manhasset, NY – New York State GED 1979
Contact this candidate