SQL/Reporting Developer

Ryan A. Harris

Skills Summary

Key Skills

SSRS 2005/2008, MS SQL 2005/2008,2012 SSIS, SSAS, MDX, Toad, Oracle

Languages

C#/NET, SQL, PSQL, JAVA/ANDROID, VBSCRIPT

Professional Experience

ETL Developer

Bank of America - Charlotte,NC Oct 2016 – Mar 2018

Executed daily ETL automation tasks for the balance sheet management group. Utilize T-SQL, SSIS to extract, transform and load balance sheet source data from internal bank customers

Designed SSIS packages to extract,load text file data using Openrowset BULK command

Created format files, mapping text files with appropriate data types and table columns

Developed stored procedure scripts to perform data backtesting and data regression comparisons

Developed Powershell/F# scripts to automate code/scripts promotion from development to SIT/UAT environments.

Implemented TFS 2015 repository to manage source control

Oldcastle Materials - Charlotte,NC Jan 2016 – July 2016

Reports Developer

Developed and remediated organization's Crystal reports which supports company ERP system.. The role required updating and/or re-writing stored procedures use in the reports. Used SSRS to develop enhanced business scorecard solutions against organizational fact and dimensional tables.

Designed SSRS reports sourced by star-schema database

Wells Fargo – Charlotte, NC May 2015 – December 2015

SQL Developer

This developer role required 40% SQL Development, 30% SSIS design/integration and 30% SSRS Reporting

Contracted by Wells Fargo’s Residential Valuation Services (RVS) to develop and automation several manual departmental processes using SQL and SSIS integration tools.

Developed all required SQL Objects (tables, scalar-functions and stored procedures) in UAT before submitting to DBA for production loads

Coordinated with external vendors) to create daily data feeds used in automation projects

Created complex queries and stored procedures which produce scorecard reporting in SSRS and Excel outputs. Write queries which utilize left and full outer joins to capture data variances

Utilized C# script task within SSIS to provide customization data feed imports, reporting exports and email communication

SQL Cross apply, SQL WHILE looping and Rank are just a few DML syntax used daily to capture data for reporting purposes

Developed project-plan to convey projects milestones and flag potential stop-gaps in the development life-cycle

Bank of America – Charlotte, NC November 2013 – December 2014

Reporting Writer / SQL Developer

Gathered requirements and developed reporting solutions utilizing the Microsoft BI stack (SSAS, SSRS) for Bank America customer-based

Utilized Excel 2010 pivot-table feature to extract and report contract resource forecast data for business reporting users

Demonstrated high proficiency with designing summary-detail based SSRS reporting solutions using SSAS cube. Used BIDS 2008 R2 develop and manage MDX SQL queries for report generation. This role occasionally required integration of Vb scripts to accurately set up date dimension data for report parameter selections

Executed system or report demos to the business users, and managed any necessary training needs

Performed SSIS package conversion and testing for the bank's contract resource application and database migrations. Proficient with integrating data transformation techniques to map Excel tab-delimited data to SQL

Wells Fargo Bank, N.A. - Charlotte. NC Feb 2013 - November 2013

SSRS Reports Developer

Developed, managed and supported complex financial reports based upon SSRS and Microsoft Dynamics CRM 2011. Role requires working closely with business analysts, interpreting functional requirements and developing reports.

Integrated SSRS Charting tools within reports for banks Wholesale group.

Assisted QA team with assuring reports passed SIT and UAT environments prior to production deployment. Devised test scenarios in development\QA environment.

Piedmont Behavioral Health - Kannapolis, NC June 2012 to December 2012

Reporting Business Intelligence Developer

Analyzed, developed T-SQL report queries to be embedded with in SSRS reports behavioral health provider network

Performed report conversions from Crystals Reporting to SSRS

Performed weekly data extracts from data Cube using MS SQL server tools

Duke Energy Corporation - Charlotte, NC July 2008 to April 2012

Reporting Business Intelligence Developer

Developed and implemented SSRS reporting solutions for Duke Energy's Nuclear Division

Demonstrated proficiency with developing SSRS reports using techniques as embedded SQL, stored procedures, temporary tables and cursor functions

Was responsible for supporting over fifteen-hundred SSRS 2008 reports

Performed SSRS report conversion from 2005 to 2008 R2 release, assisting NIT Business Consultant devise NIT Workplace procedures / reporting standards and converting legacy Business Object reports to SSRS 2008R2

Charlotte-Mecklenburg Police - Charlotte, NC October, 2006 to July, 2008

GangNet Database Admin

Implemented and maintained statewide GangNet database for Charlotte-Mecklenburg Police Department

Performed maintenance on SQL server software including upgrades, general maintenance, security and performance tuning. Created and executed SQL SSIS packages to import user information into GangNet database

Set up replication to Central GangNet database in concert with Vendor, State, and Eastern Node resources

Successfully developed, implemented and maintained C#/NET application (GangNet User Management) to manage statewide user information

Mutual Service Corporation. - West Palm Beach, FL June, 2006 to September 2006

SQL Reports Developer

Developed, reviewed, evaluated, implemented and maintained financial/investment reports for Mutual Service Corporation using MS SQL Reporting Services 2000/2005

Ensured report designs adhered to company and departmental standards

Implemented SQL linked Server connection to DB2 database, converting existing legacy reports to SQL 2005 Reporting Server standards

Apptechbiz, Inc. - Charlotte, NC April, 2005 to April, 2006

System Analyst

Preformed various tasks using SQL 2005 for Survey and Engineering business client. Developed custom billing reports using reporting services

Reconfigured business client s HP NAS device to better utilize existing storage capacities. Implemented and supported multi-office Sonicwall VPN network. Troubleshoot and resolve connectivity issues

Developed VB /WMI scripts to automate event log archiving process for 2003 servers. Migrated Windows 2003 domain controller from physical to virtual using Virtual Server 2005

Summit Properties, Inc. - Charlotte, NC June, 2004 to November, 2004

Effectively implemented network testing environment to valid new applications prior to deploying in production

Implemented secondary Exchange server 2003 to overcome existing mail server storage and performance limitations

Planned and implemented Windows 2000/2003 test environment to assure infrastructure hardware and application software comply to Sarbanes - Oxley compliance framework

First Charter Bank - Corporate Center - Charlotte, NC July, 2002 to August, 2003

Network Engineer

Accurately applied database hot-fixes, indexed database tables, coordinated application downtime, and performed database backup/recovery

Setup Windows 2000 DHCP scopes and TCP/IP addressing for corporate workstations.

Corning, Incorporated - Midland, NC 1998 to June, 2002

Sr. Systems Engineer

Managed over 50 Compaq rack-mounted windows servers

Procured over a half-million dollars in computer infrastructure hardware for MES project, keeping cost under budget

Implemented 784GB Compaq/HP EMA/ESA 12000 fiber-channel SAN solution for MES project

Created RAID sets and LUNS for servers participating in SAN. Backed up and restored local server data to SAN array

First Data Corporation 1997 to 1998

Systems Administrator

Oversaw networking infrastructure hardware

Performed weekly data exports of pay-by-phone application, bulk-copying data into MS SQL tables

Mecklenburg County Government 1994 to 1997

Network Administrator

Administered eight Novell networks

Provided top-notch computer support to Mecklenburg County Commissioners Office, Internal Audit and Finance departments

Identified problems, defined solutions.

Education

Francis Marion University - Florence, SC

B.B.A, Computer Information Systems Management, 1994

Contact this candidate