Project Manager/Excel VBA Developer Resume

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:

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:

Confidential 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