SUMMARY

• Internally motivated, highly experienced deadline driven individual, that is often viewed as a Swiss army knife that can easily bounce between roles and project types
• Knows several programming languages well and can pick up new ones pretty quickly when given a reason to know them with strong C#/VB.Net/T - SQL/PowerShell with some exposure at varying levels to Java/Javascript/CSS/HTML/Python/CSS/C++ and with extremely good data skills especially with SQL Server and query/stored proc optimization mainly with the desktop experience but a small handful of corporate web project exposure.
• Very Strong Debugging skills, generally if repeatable steps are known then can find the problem location and can brainstorm potential fix(es)
• Strong Customer/Communication Interaction skillets due to multiple years in call centers

TECHNICAL SKILLS

• SQL Server Management Studio(SSMS)
• Visual Studio (with .Net)
• Confidential Web Services)
• EC2(Elastic Cloud Compute)
• EBS(Elastic Block Service)
• Route 53 DNS
• Confidential CLI(Command Line Interface)
• PowerShell
• Code Commit
• Elastic IP’s
• Launch Templates
• Lambda
• SQS(Simple Queue Service)
• Linux
• Python
• CIDR
• SQS(Simple Queue Service)
• Confidential Workspaces
• S3(Simple Storage Service)
• Confidential Polly
• Cloud Watch

PROFESSIONAL EXPERIENCE

Confidential

Personal Development/Projects

Responsibilities:

• Experimented heavily with Confidential Familiarized with launching several types of EC2 instances and have a strong understanding of costs running those EC2 instances.
• Launched and utilized several types including Linux with SQL, and Windows.
• Utilized basic Linux commands and how to SSH into those terminals using Putty and then using Confidential CLI to send files to S3 Utilized Route 53 tables to setup both external and internal routing tables so that the same DNS would resolve to different IPs based on where it was coming from so that the same friendly name can be used externally and internally and have security groups work(where as internal IP’s are easily know, but external public IP are seemingly random) Utilized Python to use lambda and Cloud Watch and EC2 tags to interact with Route 53 DNS to give a friendly DNS name to more easily connect from external locations without using Elastic IPs so that occasionally launched resources could easily be connected to using those friendly names and so that charges wouldn’t be incurred when EC2 instances weren’t live.
• Familiarized with CIDR notations to simplify Security group rules Utilized SQS(Simple Queue Service) in conjunction with Powershell to process messages Created Launch templates and using a single image with using User Data so that a single base image can be used and when launched have different functionality Established Code Commit and learned how to connect from .Net Visual Studio via setting up Profiles Created and Restored Snapshots Administered and utilized Confidential Workspaces Comfortable putting files into and out of S3 and changing their storage classifications and usage in conjunction with SQS so as to create low cost pointers to files for processing Utilized Confidential Polly for Text to Speech MP3 file creation

Environment: SQL Server Management Studio(SSMS), Visual Studio (with .Net), Confidential Web Services), EC2(Elastic Cloud Compute), EBS(Elastic Block Service), Route 53 DNS, Confidential CLI(Command Line Interface),PowerShell,Code Commit,Elastic IP’s, Launch Templates, Lambda, SQS(Simple Queue Service), Linux, Python, CIDR, SQS(Simple Queue Service), Confidential Workspaces,S3(Simple Storage Service), Confidential Polly, Cloud Watch

Confidential, Houston, TX

Software developer

Responsibilities:

• Specializing in .Net and SQL Server
• Assisted Several teams with key project initiatives
• Used SQL Server and an Audit database to determine the parameters used on the slow running queries.
• From there, used those parameters to run the query and using view actual execution plan find the areas of the query that were in the biggest need for improvement.
• Solutions ranged from elimination of cursors to creation of new indexes to better use of temp tables.

Confidential, Marshalltown, IA

Software developer

Responsibilities:

• Wrote a .Net project to analyze the spreadsheet and extract key information.
• This included translation of excel formulas into formulas that contained column names.
• Then expanded on this so that it was converted directly into the format that SQL Server could use.
• Once this phase was complete, the same application was used to create the SQL Scripts that could calculate every calculation on the spreadsheet and make it available for consumption anywhere in the program it was later determined necessary.
• Pivot tables within SQL Server were used to accomplish this since changes over time were being calculated.
• After additional data was provided, generated the scripts to insert required data for the application to allow for the new pipelines to be visible.
• Also wrote code to extract all data from the spreadsheet so that an entire day’s of sample data could easily be viewed within the application for testing purposes.

Confidential, Marshalltown, IA

Software developer

Responsibilities:

• Also spent about 2 years as SQL Server Database Administrator
• Utilized SQL Server on the back end creating all tables, views, stored procedures, SQL Login ID’s, views, etc. to facilitate this process.
• Also, utilized SQL Server Integration Services (SSIS packages) for the data import utilizing file pattern matching to dynamically retrieve files and determine which carrier it belong to as to know how to properly import.
• Then setup and used SQL Server Reporting Services to write reports visible to users.

Environment: SQL Server Management Studio(SSMS), SQL Server Reporting Services(SSRS), SQL Server Integration Services(SSIS), some .Net inside of SSIS, SQL Server admin functionality including permissions, ID creation, view creation, stored procedure creation, FTP, Data Import

Confidential, Marshalltown, IA

Software developer

Responsibilities:

• Utilized SQL Server, .Net using C#, and PowerShell to complete this project.
• A push/pull model was utilized where replication was used to send the data out to everyone after pulling it using Linked Server from the sales offices where it was merged and cleaned up.
• An executable using C# was created that separated the import and export processes to be ran at their convenience. C# utilized the command shell utility CSVDE to export Active Directory information to a csv file that was then parsed and uploaded to tables to be pulled/merged.
• Then PowerShell was utilized to mail enable the contact objects by using cmdlet’s found when Exchange Management Tools were installed.
• Once mail enabled then it would eventually appear in Global Address List and Outlook Address Book.
• Also, learned how to setup a test environment with virtual machines running Windows Server to setup a location to facilitate testing for Active Directory manipulations of this project prior to it being live.
• Afterwards, became de facto support channel for this program. Also, became familiar with DSQuery, ADSI, PowerGUI, and Active Directory Users and Computers(ADUC) for this project.

Environment: SQL Server Management Studio(SSMS), PowerShell, PowerGUI, CSVDE, DSQuery, Exchange Management Tools cmdlet’s, SQL Server admin functionality, Active Directory Users and Computers(ADUC), ADSI, Global Address List(GAL), Outlook Address Book(OAB), Visual Studio 2012 with C#.Net

Confidential, Marshalltown, IA

Software developer

Responsibilities:

• Worked with a team to redesign the database that allowed us to control loading and saving to the database.
• My role was to analyze various save methods from within .Net to determine which would be best for our data (stored procedures with .Net Data Tables, views, and user defined table types was the fastest).
• I then wrote the code that saved the data from .Net Data Tables to the database and then put them back into .Net Data Tables on Load. Another developer handled the iteration and loading of the third-party objects.
• I was then able to allow database foreign keys to be used by controlling the order in which tables were saved to the database.
• I then also wrote an admin utility that could be used for future deployments to dynamically generate the view, stored proc, and user defined table types when changes occurred.

Environment: SQL Server Management Studio(SSMS),.SQL Server Admin functionality including creation of views, stored procedures, tables, user defined table types. Also, used Visual Studio 2008 with VB.Net and VB6

Confidential, Marshalltown, IA

Software developer

Responsibilities:

• Worked with operations team to work with users for when the issue occurred to have them take a crash dump of the application.
• I then utilized rudimentary WinDbg functionality to analyze the crash file (both for .Net and VB6 code as each requires different commands and analysis) and was often able to make good educated guesses as to the cause of the problem that could be deployed and often fixed the issue but in other cases a few iterations were required.
• This of course requires the pdb files(Program Debug files created when compiled) to have been made available initially for all program DLL’s and access to all source code files.

Environment: WinDbg

Confidential, Des Moines, IA

Responsibilities:

• Created a VB6 program that interfaced with Internet Explorer, a Microsoft Access Database and Microsoft Word.
• This program parsed through the existing web based HTML interface for accessing customer information to query the records that needed the specialized mailings and saved that list of accounts to a Microsoft Access database. It then looped through each account needing the mailing and updated the account to reflect that the mailing was sent and populated the Microsoft Word envelope template with the additional address.
• At its completion, it prompted the user to print the created documents automatically.

Environment: VB6, automation of Microsoft Word and Internet Explorer. Also, used Microsoft Access

Confidential, Des Moines, IA

Responsibilities:

• Created a VB6 program that interfaced with Microsoft Access database, Microsoft Word, and Microsoft PowerPoint.
• Specialized HTML like syntax was developed to tag each PowerPoint slide in the Speakers Notes field to specify what type of content was on the slide and the level of competency required by the end user who would be using that information.
• A list of presentations paths that were to be used was stored in the Access database, as well as the content tag information that described each presentation.
• The application gave a list of key topics that the speaker could cover.
• This allowed PowerPoint presentations to be dynamically created based off of that selection.
• The program also dynamically created workbooks for students in Microsoft Word that had a picture of the slide, as well as the speaker’s notes

Environment: VB6, automation of PowerPoint and Microsoft Word. Also used Microsoft Access