We provide IT Staff Augmentation Services!

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:

  • Fixed Excel Spreadsheets for clients and Access databases
  • Continued study of Microsoft Dynamics CRM, Dynamics 365
  • Continued study of SQL Server, SSRS, SSIS, SSAS
  • Continued study of new Excel 2016 Array features

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

Hire Now