TECHNICAL SKILLS

Excel: Excel 97, 2000, 2003, 2007, 2010, 2013, 2016 including macros and VBA programming, Tableau 9.2, 9.3, 10.0, Power BI, Power Query

Access: 97, 2000, 2003, 2007, 2010,2013, 2016 including macros and VBA programming

Reporting Tools: SQL Server Reporting Services (SSRS)2005/2008/2010/2012/2016 Crystal Reports 8/9/Xi, XiR2, BOXI

.NET TECHNOLOGIES: ASP.NET, ADO.NET, Win Forms, Web forms, XML window services, Web Services, .NET Remoting

Languages: Excel VBA, Access VBA, C#, NET, VB.NET, Java, PL/SQL, T - SQL, SQL

Scripting Languages: Java Script, VB Script

Web Technologies: HTML, DHTML, CSS, XML, XSL, XSLT, XAML, XBAP IIS and FrontPage.

Operating Systems: Windows XP/2000/NT/ME/98/2003, Windows 7 Enterprise, UNIX, TomCat, WebSphere

Databases: SQL Server 2000/2005/2008,2008R2,2012,2016 Oracle 8i/9i/10g, MS-Access, DB2, Teradata, SAS, TOAD, Essbase

Middleware/Libs: COM, COM+, DCOM, ActiveX, SSIS, TM1

IDE: VS 2003/2005/2008/2010/2012/2016 IBM Rational-UML Visio.

Protocols: TCP/IP, HTTP, FTP

Web Services: XML

Database Access: ADO. Net, OLEDB, ADO, ODBC.

CRM’s: Salesforce.com, Oracle CRM, Microsoft Dynamics CRM, Microsoft Dynamics 365

PROFESSIONAL EXPERIENCE

Confidential

Project Manager/Excel VBA Developer

Responsibilities:

• Converted older Excel Versions of spreadsheets used for determining manufacturing costs.
• Took this program from taking over 14 seconds to run down to .2 (2/10) seconds to run. This spreadsheet tracked Floor, Drawing, Zones, Summary, LH (Labor Hours), MH (Man Hours), total costs linear feet, and Diameter/inches and customized the ribbon by creating a new Ribbon.
• Used XML to create the Buttons and the Callbacks for the buttons.
• Took data from older Access Databases and converted it to Excel.
• Used PowerShell
• Used SQL Server 2016 to Query Data as needed
• T-SQL
• .net
• Microsoft Dynamics CRM

Confidential

Project Manager/ Excel VBA Developer

Responsibilities:

• Cotivity is a managed health care system working with several different Health Care providers providing Audits and other Financial Information services.
• Provided support for web scraping different accounts to help account for overages not paid for by health providers.
• Used Excel VBA, Auto IT and some VBA.net scripting to automate these tasks.
• Access VBA, Created User Forms for Data Entry
• Started out as a Scrum team and then shifted to Agile.
• .net
• asp.net
• Microsoft Dynamics 365, CRM
• Used PowerShell
• SQL Server 2016 Queries, Stored Procedures, Views
• Worked on older Access databases
• T-SQL

Confidential

Project Manager/Excel VBA Developer, SQL Developer

Responsibilities:

• Confidential is a worldwide concrete provider. Confidential had just purchased 6 new concrete plants.
• Used Excel VBA to automate the drop-down menus in their reports to include these plants.
• Used Excel VBA, and SAP BEx Analyzer to produce these 40 reports. We held Agile Team meetings. I had to look at older Access databases and copy some tables to use in Excel.
• .net
• Implemented testing of Microsoft Dynamics 365, CRM
• Looked at using Tableau.
• SQL Server 2016 Queries
• T-SQL
• Stored Procedures, Views, Triggers

Confidential

Project Manager/SSRS Reports Developer

Responsibilities:

• RJ Reynolds is a worldwide provider of tobacco products including cigarettes, e cigarettes, and cigars.
• Assisted as a Project Manager and an Excel VBA Reports Developer.
• Made sure older Access databases were running as needed.
• Created Business Objects Universes and Crystal Reports as needed for one of the businesses entities that still ran these reports.
• SQL Server 2016 Queries
• T-SQL
• Stored Procedures, Views, Triggers
• .net
• Used PowerShell scripting on servers as needed

Confidential

Project Manager/SSRS Reports Developer

Responsibilities:

• On this short-term assignment I repaired 30 reports using Visual Studio and SQL Server 2008R2 to prepare the reports and database to be moved to SQL Server 2012.
• Modified/created Stored Procedures & Views as needed to ensure new Reports were working properly. These reports were to go live in a new database created for Accounts Payable & Accounts Receivables.
• Ran SQL Queries, views, stored procedures, T-SQL as needed.
• .net
• Microsoft Dynamics CRM
• Worked on a team of 3 using Agile methodology. Created some mockup dashboards using Power BI.
• On this short-term assignment I repaired 30 reports using Visual Studio and SQL Server 2008R2 to prepare the reports and database to be moved to SQL Server 2012.

Confidential

Project Manager/Financial Analyst, Reports Developer

Responsibilities:

• Created new reports and help fixed a Daily Debit Balance report that had been broken since March that the AP Trade group used to balance on a Weekly and Daily Balance. This program ran in Access 2010 and took 30 minutes to finish.
• Created a Pivot Table that gave the same information in a cleaner format and that took only 1 minute to run
• Created programs in Microsoft Access as needed.
• Assisted with several regular reports and created new Ad Hoc reports that were needed. I also
• Used Crystal Reports BOXI, WebEx, and Business Objects Universes to create reports.
• Looked at the possibility of using Microsoft Dynamics CRM and Microsoft Dynamics AX as a viable solution but decided to stay with the current solution.
• Worked with the BI Data Warehouses and ran SQL Queries, views, stored procedures, T-SQL as needed.
• Used SAS database as needed.
• SSRS, SSIS
• Stored Procedures, Views, Triggers, T-SQL
• .net
• Microsoft Dynamics CRM

Confidential

Project Manager/SSRS Report Developer

Responsibilities:

• On this short-term project, I helped the Team identify the Dimensions needed to define and build the correct cube for the BI Data Warehouse.
• Started daily meetings as needed and requested additional personnel to attend these meetings as needed and worked as an Agile team.
• Drove the requirements for the Data Cube that needed to be correctly built by determining the dimensions that needed to be added.
• Looked at some older Business Objects Universes and Crystal Reports that were migrated to SSRS.
• Microsoft Dynamics CRM

Confidential

Project Manager/Developer

Responsibilities:

• Gathered requirements and analyzed the current reporting needs for all 13 Service Centers.
• Created very complex Excel VBA Reporting tool to help Work Center Supervisors schedule their crews accounting for Weekends, and Holiday hours where no work was to be scheduled. This tool will save the Work Center Supervisors many hours of time where they had to do this in the past using paper and pencil.
• Helped with Office 365 and Microsoft Dynamics issues as needed.
• .net
• SSRS, SSIS
• SQL Queries
• Microsoft Dynamics CRM