SUMMARY:

• Management/Supervisory experience - 7 years
• Call Center staff in Payroll Services department at Confidential, Help Desk staff for web support.
• Ability to improve and enable business processes, cut costs, and generate revenue.
• Creating/Maintaining a Budget
• Effective Decision Making, Leadership, Team-player, and Project Management experience
• Statistical Analysis Reporting, Report Writing (Crystal Reports, SSRS- SQL Server, MS Access)

TECHNICAL SKILLS:

Network Administration Experience: Windows NOS (NT, 2000, XP), Active Directory, UNIX, Novell Netware, Novell Zenworks, HP OpenView, Brightstor, Veritas, VPN, Citrix, Nortel Networks, RSA SecurID, Ghost, Cisco routers (telnet configurations), hubs, switches, TCP/IP, NetBEUI, cabling

Programming Skills:

Programming/Software Development: SQL, VBA, SAS, VB, .NET, Visual Studio, SharePoint, Office 365, MOSS 2007, Android Apps, Java, iOS Apps, WordPress

Database Administration: SQL, Oracle, SQL Server, SSRS, SSIS, Crystal Reports (10, 11, 2008), MySQL, and MS Access

Mobile/Web Design: HTML, XML, JavaScript, Cascading Style Sheets (CSS), ASP.Net, AJAX, JSON, PHP, JQuery, HTML5, Android Apps, iOS Apps, Blackberry Apps, Mobile Web Apps

MS Office Software 2003, 2007, 2010: Word, Access, Excel, PowerPoint, InfoPath, and Outlook using VBA and XML coding

Other Software: Visio, MS Project, MS SharePoint Designer, Visual Studio, Eclipse, WAMP, LAMP, Adobe Dreamweaver, XCode, PhoneGap

WORK HISTORY:

Application Developer

Confidential, Atlanta, GA

Responsibilities:

• Designed, developed, and created a MS Access database application to add company data, receive/report data from Bloomberg, FactSet and other on-demand investment reporting data sources using VBA, SQL XML, ODBC, and MS Excel.
• Automation was created generate data results, open new Excel file, format data on Excel spreadsheets, and generate/create pivot tables and charts.
• Integrated MS Access with Bloomberg, FactSet, and other investment data sources using VBA coding.
• Designed and developed WordPress site for company.
• MS Access, MS Excel, VBA, XML, SQL, Pivot charts/tables, ADO, DAO, SharePoint

Data Analyst

Confidential, Atlanta, Georgia

Responsibilities:

• Designed, developed, and created Scheduling database in Access 2010 using VBA and SQL code to import data from MS Excel spreadsheets and generating a report gathering additional data from MapPoint and Google Maps.(data received via VBA integrating MapPoint 2009 and Google Maps into the MS Access database application)
• MS Access, MS Excel, VBA, SQL, Pivot charts/tables, ADO, DAO, MapPoint 2009, and Google Maps

Database Administrator

Confidential, Warsaw, Indiana

Responsibilities:

• Designed, developed, and created Needs Assessment and TalentScope portal applications using PHP, WAMP, Apache server, and MySQL database.
• Developed new and redesigned existing MS Access applications used for entering data into linked Microsoft SQL Server and MS Access databases and generating reports from data into the various formats (MS Excel, HTML, MS Word, and XML files) using VBA, ADO, DAO, and SQL.
• SQL Server, MS Access, MS Excel, InfoPath, VBA, XML, VB, SQL, Pivot charts/tables, ADO, DAO, PHP, MySQL, WAMP, Apache server

Database Developer

Confidential, Atlanta, Georgia

Responsibilities:

• Design, develop, and create SharePoint sites, webparts, and workflows. Integrate MS Access application front ends to connect to Sharepoint.
• Developed and designed SharePoint site for the Wireline department including workflows and webparts.
• Create documents and files using MS Access, Word, and Excel and upload them using VBA code to Sharepoint documents folder.
• Setup user accounts, groups, and rights.
• Developed a MS Access application to store audit data, assign audits to auditors, store audit scores, allow QA to review audits, create feedback forms in MS Word, and gather audit scores from MS Excel files.
• The application create files and uploaded them to folders on the Sharepoint site as well as saving them to the Auditor’s local drive on their computer.
• SQL Server, SharePoint Designer 2007, Visual Studio 2010, MS Access, MS Excel, InfoPath, VBA, XML, VB, SQL, Pivot charts/tables

Excel/Access Analyst

Confidential, Atlanta, Georgia

Responsibilities:

• Design, develop, and create MS Access Database applications and MS Excel using VBA and SQL coding.
• Increase functionality and design applications that integrate MS Access with MS InfoPath, MS Excel, and MS Word using VBA and XML coding.
• Integrate MS Access application front ends to connect to IBM DB2 and Teradata databases.
• Develop reports and query/manipulate large amounts of data for regional and quarterly sales reports using SAS.
• Setup user accounts, groups, and rights. Used dynamic management views and functions to identify problem areas.
• Developed stored procedures, triggers, indexes, and views in support of application projects.
• Develop Inventory Planning and Performance reports for the Off - Shelve Merchandising department.
• Teradata, Microstrategy, IBM DB2, XML, SAS, SharePoint, MS Access, MS Excel, VBA, SQL, Pivot charts/tables

Database Developer

Confidential, Atlanta, Georgia

Responsibilities:

• Design, develop, and create MS Access Database applications using VBA and SQL coding.
• Increase functionality and design applications that integrate MS Access with MS InfoPath, MS Excel, and MS Word using VBA and XML coding. Integrate MS Access application front ends to connect to SQL Server database back-ends.
• Setup user accounts, groups, and rights.
• Used dynamic management views and functions to identify problem areas.
• Responsible for SQL Server management that included: data availability, backup, and fast performance.
• Developed stored procedures, triggers, indexes, and views in support of application projects.
• In addition to being the SQL Server DBA I took on a number of application development projects.
• SQL Server 2005, SSRS, SSIS, MDX, Visual Studio 2008, MS Access, VBA, SQL, T-SQL, Visio, MS Project

Data Analyst I /Reports Developer

Confidential, Lawrenceville, Georgia

Responsibilities:

• Statistical analysis and reporting.
• Develop databases, complex SQL queries, stored procedures, triggers, functions, and views.
• Database design. Design and implement database modules.
• Query large amounts of data using SAS.
• Create reports, forms, and queries.
• Create, repair and troubleshoot databases.
• Backup database production.
• Create VB applications (.NET, XML, SQL, VB)
• Oracle 10g, SAS, Crystal Reports, Visual Studio 2008, MS Access, SQL, MS Excel, VBA, VB, XML, .NET

SAP Technical Trainer- Instructional Design

Confidential, Malvern, Pennsylvania

Responsibilities:

• Technical training and creating training materials for global deployment. Instruct train the trainer class.
• SAP, Documentum, MS Access, MS Project, MS Excel, MS PowerPoint, SQL, VBA, Crystal Reports XI