Sql Server Systems Analyst

Gregory A. Perry 773-***-**** cell

**** ****** ***** ** ***********@*****.***

Decatur, GA 30034

SUMMARY

Systems Analyst with expertise in customer service, database and spreadsheet analysis. Worked in Financial Markets, Telecommunications and Healthcare, coding solutions in VBA with Microsoft Excel, Writing Stored Procedures and managing indexes with SQL Server

PROFESSIONAL SKILLS

SQL Server, Oracle, Excel VBA, Access VBA, SSIS, Apache Airflow, SSRS, Tableau, Power BI

PROFESSIONAL EXPERIENCE

Halo Branded Solutions 2/2022-Present

Business Intelligence – Data Warehouse Manager

Facilitated ETL data movement from proprietary system into SQL Server using Ssis

Administered the system and all users with Tableau

Managed the entire Reporting system and reporting database with SSRS

Facilitaded ETL data movement from SQL Server Data into Snowflake Data Warehouse using Apache Airflow

Created reports for executive management using Power BI

Created front end data view of several disparate databased using Microsoft Access for reporting to executives and management end users

Created dashboards and Pivot tables using Microsoft Excel

CompuCredit/Atlanticus Holdings Corp 4/2011- 10/2021

Database Administrator-BI Developer

Provided SQL Server DBA support for a production database that fed a custom app (Loanbook), a web based lending application.

Worked extensively with SSIS to move data to and from SQL Server to spreadsheets for regression and projection analysis, & to supply data to reports housed in SSRS.

Configured & maintained replication between two SQL Server databases for production and reporting instances of a real time data driven loan application portal.

Maintained and setup all subscriptions for reports administered to management from SSRS.

Created stored procedures to complete a progam for management called Circle of Excellence. Sprocs used business logic to determine which sales teams performed the best based on given criteria from the business units.

Used T-Sql to create aggregation reports containing performance and position reporting logic from normalized tables within the SQL Server

oIe: Joining many tables together to create customer balances and calculate payments.

Created advanced stored procedures that were used to populate reports within SSRS to supply flattened and streamlined results to management.

AT&T, Atlanta, Georgia 8/2007-4/2011

Database Analyst – Database Administrator

Provided Support for production data on AT&T Telecommunications Systems

Worked extensively with SQL Server 2005 stored procedures, SSIS to (ETL) Extract Transform and load data, Access 2007, Excel 2007 and VBA. Created full relational database for use in tracking and monitoring production data utilizing pivot tables and SSAS data cubes.

Setup full IIS Web Server (Version 7.0) to house intranet web sites used within Consumer Sales Reporting group.

Responsible for managing all data supplied to the internal consumer sales web site via SQL Server stored procedures & Visual Studio ASP.NET.

Responsible for all changes to the web site and development of custom ETL imports into the SQL Server database to apply business logic to the sales data using DTS & SSIS.

Interfaced with data from Oracle database (source system) to extract data into SQL Server database (destination system) using SSIS .

Created VB.Net application to allow users to enter adjustment data into SQL server tables that is used by 100+ users to update rep sales figures.

Robert Half and Associates, Atlanta, Georgia 4/2007-8/2007

Help Desk Support Analyst (Contractor, Woodruff Arts Center)

Provided 1st and 2nd level support for all internal network users. Created and sorted Excel spreadsheets for user documentation using Visual Basic for Applications macro features.

Robert Half and Associates, Chicago, Illinois 6/2006-4/2007

Systems Analyst & Administrator (Contractor, Newarkinone)

Assisted with the import of Excel spreadsheet data from BPCS mainframe database application for analysis and reconciliation with their external accounting system. Setup and troubleshoot issues with Excel spreadsheets using VBA and formulas to provide business analysis for multiple users.

PERITECH CONSULTING GROUP 10/2002-11/2021

Systems Analyst, Development Contract with Automation Plus

Created forms in MS Access that allowed users that were unfamiliar with database to easily run import query and populate MS Access tables. (See Details Below)

Worked as a developer for an application designed to assist Title Loan and Payday Loan businesses. This application was called the Autocash POS system, and it was designed in Microsoft Access, the front end was the cash register for the business. The tables we designed were used to track customer payments on loans and to provide reporting and accounting data that was then periodically uploaded to a Peachtree Accounting system.

Increased efficiency and profitability using Tableau reporting engine to create custom dashboards for clients to assist them in managing their monthly projections. This allowed their businesses to be more profitable in seeing past performances with customers and patterns of customer behavior.

Improved performance visibility using Tableau to create charts and graphs to show year to date profits and losses for small to mid-sized businesses consulting with Automation Plus.

ING US FINANCIAL HOLDINGS, New York, NY 8/1998-9/2002

Systems Analyst/ Programmer

ATS Application Administrator and Support Person

Provided powerful segmentation analysis support for Asset Trading System (ATS32)

Increased efficiency of the Accounts Payable Department by creating Inventory Cost Expense System (ICES) for tracking invoices, cost centers and IT budgets using Access VB.

Reduced trade-processing time needed by Operations Control Department by developing graphical add-on module to display data taken from ORACLE database using Visual Basic.

Increased efficiency for Margin Finance group by providing data extracted with Pearl scripts on Unix OS.

Developed Excel Spreadsheet for Internal Audit that automatically recorded any changes to assets listed on the Spreadsheet using Excel VB and allowed auditors and management to track daily changes to asset prices and reduced errors made by clerks.

Enhanced system security by monitoring and making changes to cron jobs that launched backups to Autosys database on (Sybase).

Reduced Asset processing time by 2 hrs per day by developing pricing module for use in importing Asset prices into ATS32 using FoxPro

Installed physical pre-configured routers that established connectivity to JP Morgan Chase Broker Dealer Access System application.

Provided 24 hr 7 day support for all IT Financial Market Autosys Jobs

Extracted data from Sybase database using Visual Basic, ODBC that facilitated relocation of business unit.

EDUCATION

Computer Information Systems, DeVry Institute of Technology, Decatur, GA 1997

Contact this candidate