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 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 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

PROFESSIONAL EXPERIENCE:

Confidential, Houston, Texas

Excel VBA Developer

Responsibilities:

• I created an Excel 2016 application that grouped pipe sizes, pipe fittings, pipe flanges, orifices, check valves, butterfly valves, plugs, etc. onto a worksheet that will be used to create notes for Stationary Equipment Process Engineers to be used in several plants world- wide.
• The Engineers will print this info out on 11 x 17 paper to carry with them to the different plants so they can see what parts they might need.
• This program involved complicated formulas, macros and pivot tables.
• I completed this project on time and on budget.

Confidential, McKinney, Texas

Excel VBA Developer / SQL Developer/Project Manager

Responsibilities:

• I provided support for web scraping different accounts to help account for overages not paid for by health providers.
• I used Excel VBA, Auto IT and some VBA.net scripting to automate these tasks.

Confidential, Irving, Texas

Excel VBA Developer / SQL Developer

Responsibilities:

• Confidential had just purchased 6 new concrete plants.
• I used Excel VBA to automate the drop down menus in their reports to include these plants.
• I used Excel VBA, and SAP BEx Analyzer to produce these 40 reports.

Confidential, Winston-Salem, North Carolina

SSRS Reports Developer/Project Manager

Responsibilities:

• I repaired 30 reports using Visual Studio and SQL Server 2008R2 to prepare the reports and database to be moved to SQL Server 2012.
• I modified and created Stored Procedures and Views as needed to ensure the new Reports were working properly.
• These reports were to go live in a new database created for Accounts Payable and Accounts Receivables. Ran SQL Queries, views, stored procedures, T-SQL as needed.
• Created some mock up dashboards using Power BI.

Confidential, Dallas, TX

Financial Analyst/Reports Developer

Responsibilities:

• I created a Pivot Table that gave the same information in a cleaner format and that took only 1 minute to run I assisted with several regular reports and created new Ad Hoc reports that were needed.
• I also used Crystal Reports BOXI, WebEx 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.
• I also worked with the BI Data Warehouses. Ran SQL Queries, views, stored procedures, T-SQL as needed. I used SAS database as needed.

Confidential, Dallas, TX

SSRS Report Developer

Responsibilities:

• I helped the Team identify the Dimensions needed to define and build the correct cube for the BI Data Warehouse.
• I started daily meetings as needed and requested additional personnel to attend these meetings as needed.
• I also drove the requirements for the Data Cube that needed to be correctly built by determining the dimensions that needed to be added.

Confidential

Developer

Responsibilities:

• I gathered requirements, analyzed and created Reports and AdHoc Reports in Excel and for a Compliance Company.

Confidential, Houston, TX

Developer

Responsibilities:

• I gathered requirements and analyzed the current reporting needs for all 13 Service Centers.
• I 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.

Confidential, Austin, TX

Developer/PM

Responsibilities:

• I worked on the Treasury Solutions Division Business Objects Database for the eIRS Project.
• I also attended meetings, conference calls and in person to determine the best solutions for the end users of the IRS database.

Confidential, Frisco, TX

Project Manager/Visual Basic 6 Developer and VBA Developer

Responsibilities:

• SQL Developer, SharePoint Workflow
• I converted legacy reports from VB6 to SSRS. Ran SQL Queries as needed.
• I also used Excel VBA and Access VBA to create and run reports as needed.