Sql Server Data
Resume:
Clint Miller
Salt Lake City, Utah 84104
************@***.***
Objective
Obtain a programming related job which utilizes my current skill-set and challenges me to
continue providing cutting edge technologies to a progressive company.
SUMMARY OF QUALIFICATIONS
• 6 yrs professional experience working with MSSQL server 2008/R2, 2005, & 2000
• 2 yrs professional experience with C#, ASP.Net/ADO.Net 1.x - 4.5
• 4.5 yrs professional experience working with HTML and CSS
• 2.5 yrs professional experience working with SQL Reporting Services (SSRS)
• 2 yrs professional experience working with XML files/documents
• 1 yr professional experience working with/building XSLT transform scripts
• 6 months professional experience working with SQL Integration Services (SSIS)
• 9 months professional experience working with JavaScript/AJAX/Jquery
HealthCare Partners
4525 S. Wasatch Blvd 150
Salt Lake City, Ut. 84124
August 2012 – November 2013
Programmer Analyst 1
• Developed a web based Windows Authenticated User Login application used by field
offices to track financial activities at the site. Required some research into “LDAP”
queries to expose various properties of the user object.
• Created and built a survey application intended for mobile devices that is highly reliant
on AJAX for a lighter wireless network footprint and quicker response for the user.
Middle tier is C#.Net, with heavy use of stored procedures on the back end.
• Currently investigating migrating JavaScript logic to a C# linked list and dynamic C#
classes/methods built on the fly from an XML based rules collection for handling more
complex survey rules. The jury is currently out on the effectiveness and efficiency of this
approach.
• Created / modified a half dozen or so SSRS reports to fill an immediate need. Advanced
graphing techniques were required due to complex data relations that needed to be
displayed.
• Envisioned and created an enhanced SSRS security feature using the SQL Server XML
datatype, by creating a type of “config” file that lives in a database table, but that isn’t
tied down to a specific database schema allowing for absolute flexibility and the ability to
maintain and execute dynamic sql on a per user basis. A UI is required however to
maintain this “config” file, due to the somewhat abstract syntax of XML XQuery/DML.
All Create, Read, Update, and Delete statements would be supported by the UI.
Echopass
6415 South 3000 East Suite 300
Salt Lake City,
Ut. 84121
December 2011 – August 2012
Report Development Consultant
• Develop and deploy client specified reports using Report Builder 1.0 and 2.0
• Develop and deploy client specified reports using Report Developer where the required
SQL is too complex for the Report Builder suite. This requires writing the SQL by hand
and deploying the report with hand coded SQL.
• Responsible for Report Model source code and the routine update of the code base as
client requirements change.
• Some projects required working with the DBA to get reports to access data warehouse
tables through table partitions and other optimizations that were built into the data
warehouse.
Rastar/Thindata 1:1
1600 West 2200 South,
Salt Lake City, Ut. 84119
July 2011 – November 2011
SQL Report Writer
• Develop and deploy reports using SQL Server Reporting Services.
• Modify existing or create new stored procedures for reports in the development phase.
• Research the correct methods of implementing advanced features like drill-through and
sub-reports in a new dynamic system schema where there is no conclusive
documentation.
• Some debugging of C#.Net was required when a report wasn’t working. The report
viewer object required custom ADO.Net and sometimes when a report wasn’t configured
correctly in the database, the only way to figure out the problem was to walk through the
C# code to see where and why an error was being thrown.
HealthCare Partners
4525 S. Wasatch Blvd 150
Salt Lake City, Ut. 84124
March 2010 – July 2011
Reporting Analyst
• Developed a series of operational reports within the SSRS framework that provided a
more appealing look and increased functionality.
• Successfully designed and scheduled several SSIS packages that extracted and stored
data supporting the new SSRS reports. Stored procedures where used where ever
possible to increase control over most production related issues and avoid the most
common business related RDBMS data bottlenecks.
• Modify / Create SSIS workflow items to meet new requirements for data migration and
transformation.
• Successfully devised and implemented a delivery system for a large number of Crystal
Reports.
AsapPrinting
643 West Billinis Rd.
Salt Lake City, Ut. 84119
May 2009 – February 2010
Software Developer
• Developed and pushed into production multiple intranet web based user tools for
managing customer relations and production of company product. These tools were c#
aspx.net web pages designed with a presentation layer, business logic layer, and data
access classes. Traditional JavaScript and jquery was used for more appealing
presentation as the need arose as well Ajax support to make users browsing experience
seem more responsive without the post backs. These projects were typically designed,
coded, tested, and rolled out into production ahead of schedule with almost no follow-up
support due to bugs or other unforeseen complications.
• Customer support oriented to IT issues which could be Macromedia/Flash related, legacy
ASP related, or other issues on the backend (SQLServer 2005, Microsoft Access)
depending on what types of issues the user was having.
ACS
12453 South 265 West
Draper, Utah 84020
October 2003 – March 2009
Transaction Processor Specialist
After graduation, I started this position as a mail sorter. My newly acquired skills quickly
propelled me through roles that were increasingly technically oriented. Ultimately I was
employed as a telecommuting employee who was responsible for ad-hoc querying, report
generation/modification as project management or the client required. I developed my first
useful tool while physically working at this location. The tool was based on T-SQL, and used
this platform to serialize my dataset into XML, thus giving me power to pull data from the
database in a data/metadata mix by using both element content as well as element attributes, and
then used XSLT to re-query the XML dataset and present the resulting data in a rich HTML
document styled with CSS.
EDUCATION
Mountain West College
West Valley City, Utah 84104
Associate of Science in Computer Information Systems
Graduated 2nd highest in my class in July 2003 with a G.P.A. of 3.9+ overall
Related course work: Systems Analysis and Design, SQL Database Programming, C++
Programming, Java Programming, Visual Basic 6.0 Programming, HTML coding, Networking.
OTHER TECHNOLOGIES USED (non-professional)
• 1 year ASP.Net 1.x
• 2 yrs C# (on .Net 1.1 & .Net 4.5 frameworks)
• 3 months SQL server ’05 with management studio
• 6 months C++ (Borland compiler)
• 3 months Java
• 3 months XSD schemas
• 3 months OLAP design on MSSQL 2008 Standard (ongoing concurrent study of this
technology for personal project I’m working on)
• 1 year ASP.Net 2.0-3.5/JavaScript on personal website (ongoing and always in some form
of development) see www.roughhead.com for an example of this. The site is not cross-
browser compliant, but performs as required in IE.
• 3 months SSIS development to fill the need for an ETL from a home database to a public
facing database for SSRS reporting and other miscellaneous data needs as I progress in
my technical skill sets.
• 6 months design / deploy enhanced ETL platform with the following techniques
/technologies:
o Windows.Forms application
o Linq to Objects used to query computer directories, and locate latest target
directory for a list of files to process on demand.
o Linq to Xml used to read preconfigured flat file schema info persisted into an
application configuration file in preparation for loading / validating flat files.
o Use of C#.Net classes to separate out logic for *.csv or *.xls flat files.
o Use of .Net Regex classes to ensure this platform is robust in managing data
quality and appropriate error handling or swapping out bad data for default values
as necessary when loading files into data table for imminent data loading.
Pinpointing substandard data is done quickly and efficiently, thus eliminating
vague errors that an SSIS package provides. Also built a small class dedicated to
validating data-types, and is used throughout the project to homogenize the data
validation in the various phases.
o Use of C# Linq to Entities to load data from memory tables to the database after
validation is completed.
o Use of C# ADO.Net to programmatically communicate with and execute a
collection of SSIS packages by manipulating the SQL Server Agent with a
collection of system stored procedures that are baked into the SQL Server 2008
engine. Due to the various phases of how the data is laid into the database, this
has to be done in a precise manner, due to certain data being dependent on other
data.
o Careful use of an Error Logging class. Ensuring that a channel of communication
is available from the use of the Try/Catch statements in SQL, up through the data
access classes and business logic classes and finally into the presentation layer
and getting appropriate or unexpected message out to the user for any required
intervention. Also had to log chatter from the Sql Server agent on job scheduling
details, in the event that something goes awry with this final stage of the file
loading.
• 3 months AJAX/Javascript experience exploring HTML and integrating Javascript with
the various input controls. Also currently exploring the XMLHTTPRequest object and
the various things that can be done with this.
Contact this candidate