SUMMARY

• 12 Years' experience creating quality, business user - focused solutions driving efficiency and bottom-line results
• Dynamic member of systems development software group; developing mission-critical projects. High-level attention to detail.
• Skilled in all phases of the software development lifecycle; expert at deciphering complex business rules producing straightforward logical requirements; and fanatical about quality, usability, security and scalability.

TECHNICAL SKILLS

Business(BI) Intelligence Tools: SSMS, SSIS, SSRS, SharePoint, Visual Studio, SSAS, Cozy Roc, Microsoft Office Suite - Excel, Word, PowerPoint, Access, Visio, Clarity, Jira, Confluence, Infor

Databases: SQL Servers 2005, 2008-R2, 2012, 2016

Operating Systems: Windows 7, 8, 10, Windows Server 2000, Server 2003, Server 2008/2008-R2, Server 2012 R2, UNIX/Linux Communication, Teamwork, Responsible, Leadership, Problem Solving, Flexible, adaptable, planning and prioritizing. Data Analysis, Development, Project Management, Database Management, Data Security

PROFESSIONAL EXPERIENCE

Senior Systems Analyst

Confidential, Orlando, FL

Responsibilities:

• Responsible for administrating Infor Epiphany application & campaign manager email system. Developed SSIS ETL's to feed data marketing files and national change of address records into Data warehouse. As a Senior, supporting team members in T-SQL queries and utilizing best practices as well as setting standards for development.
• Business(BI) Intelligence Tools & Database Design
• SQL Server 2016 - utilized new features such as column store index and temporal tables.
• Visual Studio 15 - Utilized load balancer and the backwards capability configuration settings for multiple SQL Server environments.

Data Warehouse Developer

Confidential, Waynesboro, VA

Responsibilities:

• Responsible for managing over 150 agent jobs running 24-7 while in an on-call rotation and trouble ticket system environment. Developed dozens of ETL processes. Administered
• SDLc integrity management system for information Technology department. Successfully developed business intelligence information by deciphering business requirements into logical requirements into highly efficient ETL processes utilizing BI tools and software.
• Experienced in trending analysis, data analysis, ad-hoc reporting, and subscription reports.
• Business(BI) Intelligence Tools Generated T-SQL query reports while maintaining generous annotation using SQL servers 2005, 2008 R2, and 2012. o SSIS to perform ETL (Extraction, Transform, Load) Integration services with flat files and OLE DB using visual studio 2005/2008/2010 SSRS / Excel / Ad-Hoc / Power BI / SharePoint o Dynamic source reporting rendering Developed dozens of SSRS tabular and matrix reports using single data set, multiple data sets, parameters, sub-reports, hyperlinks, report level calculations, charts & graphs.
• Database Design - Performance and Optimization Continuous improvement of ETL environment tuning SQL queries using logical query processing and proper index utilizations. o Validation of process to ensure data integrity in all systems. Error logging and monitoring using Activity monitor, SQL Analyzer, and reviewing execution plan. Sliding window partitioning and page compression to maximize space and faster query performance. Designed ETL processes for self-clean up efficiency
• Deployment Methodology MSDB Database SSIS Projects including packages in Integration Services Catalog within SSIS DB Catalog Reporting Services RDL Imports/Reporting Properties
• SDLC Software Development Lifecycle Design request workflows following Define, Design, Develop, Demonstrate, and Deploy model. o Waterfall and Agile methods Training business users and IT staff on workflow using Visio designs
• Data and Trending Analysis Excel data entry turned into Pivot tables, and Graphs for KPI reporting.
• Managed usage mapping using filtering sequences o Maintained high-level accuracy of billing data by invalids monitoring and daily, monthly, and yearly trending pattern analysis.
• Leader in analyzing information obtained from management to conceptualize and define operational problems. Developed new usage mappings and trending templates for new usage streams
• Developed reports, defining and evaluating problems and recommending solutions.
• Problem Solving and Troubleshooting
• Source system analysis using Excel validation tools and SQL queries
• ETL package logs to decipher error messages, codes, warnings. o SQL, .Net, windows, and reporting services debug logging, SQL coding to remove duplicates, code bugs, and resolving load failures.
• Administered Avaya Dialer systems creating dialer campaigns for collections, marketing, sales, and customer care center. Provided stellar customer care systems support of applications, tools, and phone systems.
• Technical Development and Support
• Developed internal HTML/PHP website for systems support. Developed automated dialer campaigns utilizing SQL Data transformation services.
• Automated dozens of manual operations for seamless customer and call center activities.
• Designed and Implemented monitoring tools and software. Maintained 96 percent success rate of dialer collection calls. Developed computer information resources, providing data security, control, strategic computing, and disaster recovery. Created dozens of Crystal reports
• Recognized for troubleshooting ability's, Expert at; Diagnosing, and resolving hardware, software, or other network and system problems, and replace defective components when necessary.

Billing/Internet Tech Support/Customer Data Support

Confidential, Waynesboro, VA

Responsibilities:

• Working leader in a group of technical support representatives. Exhibited excellent skills in one call resolution, technical troubleshooting, and os knowledge.
• Team work Develop training materials and procedures, or train users in the proper use of systems.
• Integrity, Teamwork, Customer First, Employee Growth, Ownership, Continuous improvement, Pride. o Lead the team in data entry records of daily data communication transactions, problems and remedial actions taken.
• Problem Solving Monitored system performance and provide security measures, troubleshooting and maintenance as needed. o Maintained high-level data ticket entry, reducing call backs. o Successful In troubleshooting and resolving internet connection issues, software, and hardware. o Maintained high success rate of resolving customer issues.