SUMMARY:

• Support Analyst wif technical support experience relating to web applications, data integrations, ERP/CRM systems, business intelligence solutions, and Oracle/SQL Server

PROFESSIONAL EXPERIENCE:

Application Support Engineer

Confidential, Atlanta, GA

Responsibilities:

• Provides support for business expense fraud detection software in an Oracle/Linux server environment.
• Supports data integration from multiple sources including Concur, SAP, and other enterprise applications.
• Monitors application execution for 109 clients and troubleshoots failures in teh data ingestion/extraction, data mapping, and analytics components.
• Writes shell scripts and SQL code to update application logic fulfilling customization requests and resolving application issues.
• Tools include Vim, bash shell scripting, SQL Plus, and Oracle SQL Explorer.

IT Business Analyst

Confidential, Atlanta, GA

Responsibilities:

• Provided support for Microsoft Dynamics GP 2015 ERP system in a multi - company, Windows Server 2012 R2 environment. Supported teh Financial, Sales, Purchasing, HR & Payroll, and 1Staff Back Office modules, along wif system administration of teh application. Supported payroll processing for over 8,000 employees including staff and contingent workers. Wrote SQL queries, joining multiple tables, to fulfill reporting requests from HR department and management. Used SQL knowledge to troubleshoot failed data loads. Experienced in SQL database backup & restore. Experienced in SQL performance monitoring/troubleshooting using tools such as SQL Profiler.
• Assisted wif migration of SSIS & SSRS objects from outdated server to SSRS 2014 (virtual). Scope of work included migration of SSRS RDLs (report definitions), configuration of SSRS email & file server subscriptions; migration & configuration of SSIS dtsx packages; and migration, configuration, & scheduling of SQL Server Agent jobs.
• Served as technical lead on a project to upgrade teh company’s payroll engine, replacing a Visual Basic application wif a SQL server solution powered by SSIS & SSRS. Worked wif lead architect to scope and define teh solution. Defined requirements for teh ETL developers. Created reports in Beeline and Fieldglass VMS systems to pull data for teh ETL datasource. Mapped data from multiple source timekeeping systems including Fieldglass, IQ Navigator, Kronos, Beeline, Zerochaos, & Peoplenet to teh ETL file load standard. Provided ongoing support for over 35 SQL Agent jobs across three production servers related to teh solution.
• As teh primary interface between teh field offices, payroll team, and IT team, led teh conversion of over two dozen clients to a new payroll processing system. Implementation tasks included documenting business requirements, creation of reports in source system, mapping of source data to standard timesheet import format, defining technical requirements for developers, solution validation, and training of branch office staff & payroll processing team on new payroll procedures.
• Led implementation of an online timesheet system for non-exempt staff employees, transitioning 40 staff employees from paper timesheets to electronic timesheet tracking. Trained staff on timesheet entry, approval, and payroll processing of timesheets.
• Served as technical lead on a .NET development team supporting teh proprietary e-volution™ vendor management system. As part of teh development team I assisted wif new client implementations, migrations of clients from other VMS software onto e-volution™, and testing enhancements to teh application. Gatheird requirements from end-users and translated business requirements to technical requirements for teh developers. Assisted wif end-user support including troubleshooting desktop and network issues impacting teh user experience. Used tools such as AppDynamics, Wireshark and Fiddler to diagnose and troubleshoot application issues. Used Confluence to record documentation, notes, and project details.

Systems Analyst / Consultant

Confidential, Alpharetta, GA

Responsibilities:

• Led an Active Directory audit for McKesson Corporation’s Corporate IT Division in support of Information Security department initiatives.
• Documented security groups, owners, and security identifiers.
• Recommended use of software to improve efficiency of data collection. Met project deliverables two weeks in advance of teh target date.

Desktop Computing Support Specialist

Confidential, Atlanta, GA

Responsibilities:

• Managed support ticket queue for information technology services halpdesk, supporting over 100 staff and 1,100 students.
• Assigned appropriate halpdesk tickets to student workers. 
• Updated and imaged computers and thin-clients. 
• Granted appropriate user access to network resources.
• Completed switch port audit of all residence halls to map ports and identify faulty ports.
•  Assisted wif application virtualization implementation (Citrix MetaFrame), migrating staff to roaming network profiles.
• Assisted wif upgrade of computer labs from desktop (thick-client) computer to thin-client systems. Monitored network using Solarwinds tools.