Responsibilities• Technical Analyst/Consultant for Client-based MS SQL Programming Health Checkso MS SQL SSIS / SSRS / – advanced T-SQL coding and ETL processeso Gather detailed information about SQL Servers (document and create a baseline of data for future comparison)o Compare collected data to an established set of best practices to identify potential changes to the SQL Servers so that they meet the SQL best practice standards. • SSRS Reporting (SSRS versions 2000/2005/2012/2014/2016)o Create custom reports for Billing and Time Card solutionso Data driven subscription designo Over 500 reports built for various clientso Report Migrations for SSRS for 10+ clients • Large SSIS projects - Data Migrations from disparate software systems into TCSC Forensic Analysis Softwareo Multiple client migrations from large scale systems utilizing Visual Studio 2010 / SQL SSIS • Data mapping• Data Restructuring• Data Cleansing• Data Testing Phases including Client UAT processes• Production Rollout• Coaching on SQL/SSRS/SSIS software to new TCSC consultants • Large Reporting Applications for various clients.

• Lead ETL Administrator, SharePoint administrator and lead SQL/SSRS developer for vast array of SQL servers including, SQL2000, SQL2005, and SQL2008• Creating custom ad-hoc reports against Microsoft Dynamics AX datamarts, production and reporting databases utilizing T-SQL queries and stored procedures.• Designing, coding, testing, deploying, troubleshooting, and debugging SharePoint Web Parts for use on the company web site.• Create custom and ad-hoc reports and data extracts on SQL Server databases using SQL Server Reporting Services (SSRS). Extreme profiling and tuning for large databases / tables. • Custom Excel Tools created to create ad-hoc reporting from excel spreadsheets. • Custom stored procedures and T-SQL queries to obtain data needed from several different SQL servers for reporting.• Start of SharePoint implementation – Full implementation for 2500 users. o SharePoint custom web parts and branding. o Custom site pageso ODBC/SOAP setup

Data Consulting Services utilizing SQL ServerResponsibilities• Costpoint data migrations/conversions and Accounting restructurings utilizing MS SQL 2005 / 2008• Large scale Government implementations included data conversions of GL, Project, Accounts Receivable, Accounts Payable and most other sub-ledger data. • Large Scale predictor models using ETL data to submit to City/Counties/States for review.• Various other duties include creating custom stored procedures, designing and deploying minor interfaces for various 3rd party vendors such as PAYCHEX, ADP and Organization Charting software, and light estimating for the sales organization

CMSBusiness Analyst / SharePoint Consultant: January 2008 – August 2008Served as a Business Analyst and Technical Consultant for SharePoint/MOSS Pilot - Completion of a 90 person SharePoint pilot utilizing tools such as Visual Studio, SSRS and SharePoint Designer for custom departmental portal pages. This pilot was based around the SharePoint Records Management and Document modules.KPMG – www.KPMG.comReporting / Business Analyst Consultant: July 2007 – December 2007Using MS SQL Server 2005, SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS), I was the Lead Business Analyst and SQL Developer working with the firm’s financial and IT staff to create and architect a data warehouse in SQL Server 2005 to combine data from CRM, Outlook, Marketing and other in-house systems. I created reports from the data warehouse tables in SQL Server Reporting Services to show summary and detail data by sales person, office, region, and by project, which provided detailed revenue and expense information for presentation to senior management. Performance Point Pilot designed as a second project with this team.Ernst and YoungInstitute for Healthcare Improvement – www.IHI.org

IP Solutions / TJXThe primary role of this contract project was to independently update reporting system for the client. After detailed and careful departmental analysis, SQL Server Reporting 2000 fulfilled the needs of the company. Reports were migrated from Crystal Reports / (Access database) to SSRS 2005 rdls (MS SQL database)

The primary role of this position is to install Great Plains for new customers and upgrade existing customers to Microsoft Great Plains 7.5 and 8.0. Additional tasks include data migration, data conversions, report writing, importing of data, discovery process, needs analysis, support.

The primary role of this senior position was to develop client business requirements, as well as coordinate and manage projects for client firms. Additional tasks included pre-sales meetings, overseeing and implementing software installations, modifications, and integration to existing systems. Post-sales tasks included interfacing with all client internal departments, training, follow-up support.