Bob Mcclellan Email & Phone Number

Philadelphia, PA, US

Mount Laurel, New Jersey, US

BI Developer: SQL, SSRS, PowerBI, SSIS/ETL. Very comfortable with Complex TSQL. Very comfortable with Complex Multi-Page Reporting and automating delivery.

Millville, NJ, US

Created Azure DB & Stored Procedures to support an Executive Reporting Front End. Used SSIS for the needed ETL to facilitate the sync of a production PostgreSQL DB with the Azure DB.Programmatically generated automated reports going to consumers, merchants and non-profits with HTML email body containing dynamically associating relevant metrics.

Created MS Access Front End to their SQL Data using pass through queries.Saved accounting Dept. 8+ hrs. per month by automating creation of QuickBooks upload files.Created Access Front end for Dept. Heads that allowed them to manage their team’s hours.Created a front end for the CFO, allowing him to generate payroll, manage PTO and other financial tasks.

BLR was a large 2000+ employee company. I was brought onboard to leverage a reporting tool used by their primary business software. Since the tool allowed the use of SQL, I was able to create the reports they were looking for.Facilitated decision making by providing analytical reports using SQL and their proprietary software.Built and deployed SSIS.

SSRS Report writer. Provided the bulk of their analytical reports.

Created a Central Dispatch Application in MS Access with SQL back end, used by 40+ people across 9 stores. This app was used to Schedule equipment rentals and handled all the related tasks needing attention before a rental could be dispatched. Service & Credit could see new rentals, do what was needed and flag orders when they were ready. Trucking was also.

I'm proud to be a Veteran. I served 4 years in the Marine Corp.I was part of Marine Helicopter Squadron One, which is The Presidential Squadron. This position required a top secret clearance. I thoroughly enjoyed all the experiences allowed me while serving in this role.