TECHNICAL SKILLS

• Development Languages - T-SQL C VB .NET Objective-C JavaScript VBA
• Databases and Data Frameworks - Microsoft SQL Server Microsoft Access SQLite Core Data
• Development Tools - Business Intelligence Development Studio BIDS SSIS/DTS SSRS SSAS SQL Server Query Analyzer Visual Studio Crystal Reports Adobe Forms XCode Interface Builder
• Development Frameworks/Libraries - .NET ASP .NET ADO .NET CocoaTouch HTML5 CSS3 jQuery jQuery Mobile NUnit OCUnit
• Operating Systems - Windows Windows 8.1 iOS iOS7 OS X Android, Windows Phone 8
• Version Control and Code Repository Systems Git GitHub Team Foundation Server Subversion Visual Source Safe
• Cloud Storage - Evernote Dropbox iCloud SkyDrive OneDrive Google Apps
• Applications - Microsoft Office Apple iWork Apple iLife iThoughts FreeMind NovaMind

PROFESSIONAL EXPERIENCE

Confidential

SQL Developer and Specialist

• Worked as part of a team creating enhancements to the proprietary database created extensive
• documentation of the database structure, relationships and contents corrected mistakes made by the
• front end users assisted in the training of new employees.
• Created the database enhancements using Microsoft SQL Server 2012
• Created the documentation using a combination of of Microsoft SQL Server 2012 and Microsoft Office 2013

Confidential

• Created a Business Intelligence solution for the Intraocular Lens Franchise global information in all of its stages created a Data Dictionary to document all functionality and purpose of the newly created database elements implemented a standard naming convention to insure consistency across all database and reporting elements extracted, transformed and loaded data into the database from multiple international, regional and local sources performed further data scrubbing, validation and updating of historical data and calculations for inventory forecasting for both corporate affiliates and third-party vendors created reporting tables to store derived information for speed of reporting created reports to present and visualize global data adjacent to parameterized granular data based on user-selected parameter combinations to track inventory by vendor, brand, style, storage-location, provider, build-plan and planning-family created a monthly archival process for data-tracking and rotation collaborated with the Franchise Manager to assess focus and direction of the project on a weekly basis
• Designed and created the new database using Microsoft SQL Server 2008 R2 based on pre-existing Microsoft Access and SQL Server databases
• Created the Data Dictionary using SQL Server 2008 R2 and Microsoft Excel
• Extracted, transformed and loaded pre-existing and new data using Microsoft SQL Server Integration Services SSIS packages created with SQL Server Business Intelligence Development Studio BIDS
• Scrubbed, validated and updated imported data and forecasting calculations using T-SQL scripting and stored procedures
• Created the datasets for the SQL Server Reporting Services SSRS reports using T-SQL and stored procedures
• Created scheduled tasks to automate the importing, scrubbing, validating, updating, calculation and archiving processes using SQL Server Agent

Confidential

• Created a report-tracking system using Microsoft Excel 2010 to manage report information and recreation progress
• Created the Data Dictionary using SQL Server 2008 R2 and Microsoft Excel
• Extracted stored procedures for the existing reports from legacy SQL Server, Oracle and PeopleSoft systems
• Recreated stored procedures using SQL Server 2008 R2
• Recreated reports using Business Intelligence Development Studio and SQL Server Reporting Services
• Used their internal CRM system to report annomolies to the Data Warehouse Architect
• Created technical documentation of the recreated reports using Microsoft Word 2010
• Used Microsoft Team Foundation Server for report repository
• Documented new report availability in a report catalog in Share Point

Confidential

• Upgraded the database and stored procedures using SQL Server 2000
• Tested the additions and modifications using VB 6, ASP and HTML

Confidential

• SQL Server Modified all existing report projects to use embedded images after they had been migrated to a new file server to improve querying, response time and improve server backup capabilities worked with a remote office to perform requirements gathering, create a new set of stored procedures and reports specific to their location's needs and automate their report generation process participated in weekly code review meetings with the development team created a Data Dictionary of the existing database researched usage patterns of their proprietary web application by end users to gather information for application maintenance and updates to insure uniformity of performance across all web browser platforms performed research on a redesign of the main proprietary website to develop a more modern, less awkward mobile website version
• Report modifications were all made using SQL Server 2008 R2 and SQL Server Business Intelligence Development Studio
• Code reviews involved C 2008, .NET 3.5, MVC 2, SQL Server 2008 R2, JavaScript, HTML 4 and CSS
• Data Dictionary was created using SQL Server 2008 R2 and Microsoft Excel
• Browser research was all performed using Google Analytics
• Mobile website version was created using HTML5, CSS3, JavaScript and jQuery Mobile

Confidential

• on a team whose focus was upgrading a proprietary database application spread across 14 national markets into a unified, single-location web application and database to provide uniformity of information across the company as a whole designed and created a new database to house all market data performed data extraction, transformation and loading of individual market data into the unified data solution created a Data Dictionary and a Data Map to document purpose and flow of data from each market to its location in the unified solution created Business Intelligence reporting on existing information and as part of a recent project documenting the company's recently acquired abundance of Dark Fiber participated in twice weekly meetings with other developers, project managers and upper management
• Database creation was performed using SQL Server 2008 R2
• Data extraction, transformation and loading was performed with SQL Server Integration Services SSIS packages from proprietary Microsoft Access 2003 and 2007 databases into a single SQL Server 2008 R2 database
• Data Dictionary and Data Map were created using SQL Server 2008 R2 and Microsoft Excel
• Business Intelligence report creation was performed using SQL Server Reporting Services

Confidential

• Worked as part of a team performing maintenance of an application which tracked inventory in the following areas: equipment, equipment readiness and repair states, equipment transfers, personnel, personnel readiness, personnel certifications and qualifications and personnel transfers the application tracked multiple groups globally with the purpose of assessing and reporting on each group, their current state of readiness for deployment and implementation purposes should that become necessary worked with my supervisor on a specific project to identify and document all instances of in-line SQL within the above application to access the impact of attempting of removing them and replacing them with more secure stored procedures and improve overall application security this resulted in the identification 11,000 instances this documentation was then rolled up into a formalized proposal to upper/project management for future development worked on a team to create a proof-of-concept web-based application to present as an upgrade and alternative solution for the above application to demonstrate a better solution that would earn McLane the rights to a production contract for development and continued maintenance they decided to switch to Microsoft SQL Server 2008 R2 on the back-end of the application instead of Oracle I was charged with assisting in the development of a sample database based on the above application for demonstration purposes of the proof-of-concept application the application made extensive use of Test-Driven Development TDD and the NUnit testing framework for C applications, as well as .NET 4, HTML5, CSS3, JavaScript, jQuery and MVC 2
• Used Microsoft Visual C 2008, Oracle SQL Developer, Oracle VM Virtual Box, Resharper and NUnit to research, diagnose, redesign/refactor and test application maintenance solutions
• Used Agile group development practices
• Used Microsoft Excel as a filtering tool to isolate specific instances of in-line SQL, including code procedure locations and grouped by SQL functionality SELECT, INSERT, UPDATE and DELETE
• Used Microsoft Word to create the formalized proposal
• Used Microsoft SQL Server 2008 R2 to create the sample database
• Assisted other team members as needed using .NET 4, HTML5, CSS3, JavaScript, jQuery and MVC 2

Confidential

• Worked with the team of developers to upgrade a proprietary database application to implement a new web application performed requirements gathering from Early Childhood Intervention Agencies around the state of Texas to design and create a database to house their information in a unified location created, tested and implemented data extraction, transformation and loading processes for each agency's data to migrate it into the new database created a standard reporting system to be included with the implementation of the application created additional agency-specific optional reports at each agency's request created a Data Warehouse project as an optional item to provide Business Intelligence Reports based on each agency's specific information and needs provided application support and maintenance to all agencies during the development phase participated in daily meetings with developers and the project manager to assess progress of the project
• Database was created using SQL Server 2008 R2
• Web application was created using C 2008, HTML, CSS, JavaScript and JQuery
• Data extraction, transformation and loading processes were created using SQL Server Integration Services from Microsoft Access 2000 and 2003 into SQL Server 2008 R2
• Data Warehouse project was created using SQL Server Analysis Services
• Business Intelligence reports were created using SQL Server Reporting Services
• Application support and maintenance Microsoft Excel, Microsoft Access and VBA

Confidential

• Worked as part of a team to build and implement a custom web application for a local hospital to determine eligibility of government-assisted financial programs for hospital patients designed, created, tested and implemented the data extraction, transformation and loading from the old system to the new system assisted in the deployment of the application provided data and application maintenance, upgrades and additions after deployment of the application created Business Intelligence reports for the hospital to determine patient duplicates and statistics among area hospitals created a separate addition to the web application for the hospital's Finance Department to perform quality assurance and security checking, performed requirements gathering, design, testing, implementation and training for the new web application addition, oversaw the implementation through beta testing to production rollout created a console application to perform scheduled data transfers between the hospital and our office created an application to perform synchronization between one of the hospital's other department's legacy systems and our new system migrated the billing system for another area hospital from an older system into a more modern system to provide more detailed and accurate billing performed requirements gathering, design, development, testing, training and implementation of a web application for the training program for the company to train our employees on HIPAA requirements, company policies and procedures, and personal growth and development topics, involving material presentation, assessment and progress tracking
• All web applications were created using VB .NET, ASP .NET, HTML, CSS and JavaScript
• All upgrades to database systems were implemented using SQL Server 2005
• Migrations of data were performed using SSIS
• Reporting was performed with Crystal Reports and SSRS
• Console application development was created in VB .NET
• Job scheduling was performed using SQL Server Agent

Confidential

Corporate Support Analyst/Special Projects Coordinator

• Designed, developed and maintained applications for the Store Support Center, Corporate Support Center, and Maggiano's Catering Division using VB .NET, VB 6, SQL Server 2000 and 7, VBA, ActiveX, COM and Microsoft Office technologies
• Store Support Analyst
• Technical support and troubleshooting for Brinker restaurant managers