SUMMARY:

• 5+ years combined experience as a MSSQL Developer With ETL
• 2+ years of programming experience with .NET Framework 3.0 - 4.6, C#3 - 6
• Strong experience writing complex queries, stored procedures, triggers, scalar functions and performing DBA duties in SQL 2008R2-2016
• 3 years combined experience developing with Dynamics CRM and Dynamics GP
• 2+ years experience developing ETL SSIS projects with MSSQL & Kingswaysoft
• SSIS, SSRS and SSAS Tabular with DAX and Oracle 12c
• Development experience with Crystal Reports with MSSQL Backend Queries
• Experience with TFS and Azure Devops Agile Tools and Scrum methodology

PROFESSIONAL EXPERIENCE:

Confidential, Moline, IL

MSSQL Server Administrator

Responsibilities:

• Primary role to work with John Deer staff in a standard MSSQL Audit Compliance Project
• Operated to detect and fix login credentials for users, service accounts and SA accounts
• Updated recovery models and backup locations for Disaster Recovery
• Identified and fixed outstanding updates, patches and decommissions
• Provide Tier III dealer hosting support that includes cyber security and dealer application support
• Audit query performance and overall server performance and query maintenance to reduce usage cost

Confidential, Moline, IL

MSSQL Developer

Responsibilities:

• ETL Project Development using KingswaySoft and SSIS within Visual Studio 2015
• Development with C#, SQL SP and JavaScript to customize forms, entities, workflows and dashboards
• Azure SQL Dynamics interregional development
• Mid Level Dev of C# 6 Projects with .NET 4.0-4.7 Framework to customize Dynamics 365
• Maintenance of IMM Workflows and Dynamics CRM Business Logic Workflows
• Source Control Best Practices with TFS and extensive Documentation
• Build FetchXml Queries within Dynamics 365
• SSIS Package Development for ETL, ODS and Staging for data migration and management
• SSRS with SSAS Report Development including MSSQLTabular Data Development
• SQL Queries, Views, Stored Procedure Development with DBA duties
• Development and Maintenance of REST APIs

Confidential, East Moline, IL

Legacy VB6 and SQL Developer

Responsibilities:

• Work with legacy Batch jobs, transaction files and master files in order to update data flow.
• Develop and update VB6 Case/Switch statements to work in SQL2014 SP, Jobs and Triggers.
• Study and understand VB6 software in order to rewrite to C#6 and SQL 2012.
• Understand and map out MS Access VB Macros and Modules in order to rewrite to C#6 and MSSQL 2012/2014 Stored Procedure, SSIS Jobs, Triggers and (scalar) Functions.
• Create and maintain SharePoint Online and 2013 Sites
• Work closely with upper management to follow strict and complex project direction.
• Document all work including software logic and data flow

Confidential, Peoria, IL

MSSQL Developer

Responsibilities:

• Programmed SQL imports, SQL Report with email jobs for automated report emails
• XAML GUI development including mocks, packaged styling with Bootstrap, Angular, LESS and SASS
• ASP.Net MVC 4, ASP.Net MVC 5 with C#6 and Entity Framework as desktop application development
• Use of C# classes, methods and statements to control the back-end of MVC projects
• SQL 2014 data management including table creations, index, queries, jobs and stored procedures
• Productivity Tracking software developing from concept to publication on multiple platforms
• Legacy program migration from Angular Web Apps to MVC Apps
• User manual research and creation including project and application documentation
• Power BI Reporting Set up and Staff that included setting up SQL Tabular Analysis Service
• Worked to move office staff from excel to Power Bi for improved reporting
• Trained staff on how to use Power Bi with Tabular Data Models to increase overall reporting
• Developed numerous Power Bi Templates to standardize meta-data, dashboards, corporate image, ease of use and performance when passing DAX, SQL, Power Query and MDX.
• Created inventory forecast reports to work in combination with inhouse MVC floor application (beta).

Confidential, North Dakota

MSSQL Developer and DBA

Responsibilities:

• Successfully consulted in the restructuring and rebuilding of the IT Software Department
• Developed and maintained over 50 production C#3-6 WinForms desktop applications
• Developed with .Net Framework 4.0 - 4.6, Visual Basic 6.0, C#3 and Access Databases
• Extensive experience writing stored procedures, triggers, complex views and queries, agent jobs in SQL 2008R2/2014
• ETL data warehousing with SSIS projects, complex date ranges and BOM inventory
• Microsoft Dynamics GP 2013/2015 backend development
• Introduce Project Panorama 1.2 to track software and bug development
• Proven track record of delivering complex, high-quality user-friendly applications
• User manuals and software documentation
• Developed Crystal Reports 11.5, 2008R2/2014 SQL Reports, SharePoint Server 2013 Web Report Portals, SSRS Pivot Reports
• DBA duties including deadlock investigation and repair, job maintenance, report building, stored procedure maintenance and development of production and development servers
• Table indexes management with third party tool Idera

Confidential, Los Angeles, CA

ASP.Net Developer

Responsibilities:

• Developed complete ASP.Net 4.0 websites and customer portals
• Work with Visual Studio 2010, C#4 with SQL 2008R2 back-end environment
• Frontend web developed with CSS3, HTML4, XML and JavaScript 1.8.5, XAML 2.0
• ADO.Net Web API dev with GET POST PUT DELETE SQL2008R2 data administration
• Coordinated large projects with outside programming teams
• Managed complete product development including marketing, distributing and outside-sales shopping cart programming