Sql Server Software Developer

Nick Hankins

405-***-**** • Oklahoma City, OK • n ***.*******@*******.***

IT Software Developer and Business Intelligence Analyst TECHNICAL EXPERIENCE AND EXPERTISE

Languages: VB.Net, Java 8, Python 3, SQL/T-SQL, Excel VBA, ASP.Net Web: HTML5, CSS, JavaScript OOP, Angular.JS 2, PHP, WordPress, Web API Web/App Server: IIS, Amazon EC2 Server, Microsoft Azure, LAMP, Apache Databases: SQL Server, MySQL, Amazon Relational Database Service (RDS), MongoDB Design Patterns: MVP, MVVM, MVC, JavaScript MV, Singleton, Façade, Factory Method, Prototype SDLC: Agile, Scrum

Cloud: Amazon EC2, Salesforce.com

IDE: Visual Studio, Eclipse, Netbeans, SQL Server Management Studio, Pycharm, IntelliJ IDEA Source Controls: Team Foundation Server (TFS), Git Platforms: Windows 7 / 10, Linux, Ubuntu

Tools & Apps: PowerShell, Active Directory, Salesforce, SSIS, SSAS, SSRS, MS Power BI, SAP GitHub: https://github.com/indless

PROFESSIONAL EXPERIENCE

Johnson Controls, Inc. (JCI) Sept. 2005 - May 2017 Business Process Manager, JCI, 5005 York Dr, Norman, OK 73069 May 2013 to May 2017 Technologies: VB.Net, ASP.Net, SQL/T-SQL, Java 8, Python 3, Agile, Scrum, SQL Server, SQL Server Management Studio, Visual Studio, Team Foundation Server (TFS), SSIS, SSAS, SSRS, MS Power BI, Microsoft Azure

● Extensive use of VB.Net, Java 8, and Python 3 to create, enhance, modify and repair applications

● Gather technical requirements and design specifications

● Debug, refactor, and optimize VB.Net, Java 8, and Python 3 code

● Capture, report and track bugs using TFS, Mantis

● Integrate VB.Net, Java 8, and Python 3 applications with SQL databases

● Program SQL data load solution (1,000+ lines), based on abandoned Access DB process, that eliminated the need for lengthy, complex training to execute and extend source data to three dependent databases

● Design, build and modify SSIS packages, SSAS cubes

● Analyze SQL code, SSIS, SSAS for root cause analysis

● Write SQL/T-SQL stored procedures and functions utilizing temporary tables, subqueries and variables

● Performance tuning and optimization of new and existing SQL queries, stored procedures and functions

● Design SQL database and table schema, backup, recover and replicate SQL databases, use 3rd party DB tools

● Incorporate latest information technology tools and practices to solve business problems Inventory Analyst, JCI, 5005 York Dr, Norman, OK 73069 Sept. 2011 to May 2013

● Create custom business intelligence reports for all levels of management

● Work with all levels of management and demonstrate excellent written and verbal communication skills

● Analyze inventory levels, identify trends and slow-moving product, and propose target inventory levels Transportation Analyst, JCI - 5005 York Dr, Norman, OK 73069 Feb. 2010 to Aug. 2011

● Reduce outbound freight spend by $7M ~ 25% annually by analyzing freight spend and identifying necessary policy changes

● Streamline production Quality Control reporting process and communication throughout the business

● Forecast production and logistics volumes and monitor lowest cost carrier compliance EDUCATION

Bachelor of Science in Accounting (2 courses remaining), Western Governors University

Contact this candidate