Terron M Johnson

Increased Code Efficiency by 30% which allowed department to consistently meet deadlines and increase revenue by 4% Created Automated Processes by utilizing knowledge of SSIS, Python, Azure web jobs, and Powershell Leveraged knowledge of Node.js and React.js to create user interfaces which increased time to market by 20% Implemented Reporting Interfaces to assist data science with data analysis projects Trained staff on how to write basic sql Queries Utilized ETL development strategies in order to automate data cleansing processes Helped architect and transition a flat data structure to a db which adhered to 3rd Normal form standards. Implemented DB optimization strategies which increased db performance by 40% Developed SSRS reports and Power BI reports for the internal reporting dashboard. Provided ad-hoc support and analysis for existing processes and new business opportunities Integrated data into Salesforce applications.

Oversaw full lifecycle of software development with 100% on time delivery while staying 10% under budget Ensured database backup strategy including database rollback operates accurately and reliably Handled day to day monitoring and maintenance of database Managed user access and security issues such as roles and privileges Utilized extensive knowledge of T-SQL to analyze company data, write dynamic-queries, sub-queries and complex joins. Created complex Stored Procedures, Triggers, User-defined Functions, and Views. Designed SSIS Packages to transfer data from flat files & Excel Files to SQL Server using Business Intelligence Development Studio Analyzed, interpreted, and synthesized learnings from research sources, and drew actionable and executable conclusions for board members. Developed and tested storage strategies and disaster-recovery plan for large manufacturing company’s operational database, delivering solution that guaranteed recovery performance and high availability.

Developed dynamic and interactive website that ensured high traffic, page views, and User Experience, resulting in 40% increase in sales revenue Created innovative marketing campaigns to help build and launch new brands; most notably KeepAmerica.com and True Eagle USA. Implemented SEO practices that increased traffic 20% Designed macro processes for cleanup, data entry, and performance improvement, that minimized downtime by 13% Developed, implemented, and tested backups and recovery plans Gathered data on consumers, competitors, and market conditions Analyzed data using SSIS, Sql, Access & Excel