SUMMARY:

• I always hit the ground running.
• I will be your SME, focusing primarily on my VBA expertise, front end Office Applications, database efficiencies, knowledge of multiple programming languages, problem solving, and innovative design techniques to create, replace, or streamline any processes presented to me.
• I have the ability to adapt within any group and have always delivered above expectations to all teams.
• Specializing in streamline automation solutions Front End Office Applications VBA.
• Delivering innovative automated solutions for Analysts, Managers, and Senior Leadership Teams for 16 years.

TECHNICAL SKILLS:

Computer Hands On Experience: VBA (core expert), OMPM, OCCI, Office Converter, Microsoft Office365, Office Suite 2016 and all previous versions, VB scripting, HTA scripting, html, asp, Teradata, Salesforce, VB.Net, SharePoint and Sharepoint Designer, Peoplesoft, Kronos, Remedy, Windows 7/Vista/XP/NT, AFS, Foxtrot, SQL, ODBC, OLE, APIs,. Strong knowledge of computer hardware and software troubleshooting.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Application Developer

Responsibilities:

• Front End Office Applications development (VBA/SQL Teradata backend)
• Automated solutions (Reporting/Metrics)
• Metrics creation and existing maintenance
• Server administration (general)

Confidential, Richmond, Va

Application Developer

Responsibilities:

• Multiple Office Front End Office Applications development (VBA/SQL Teradata backend)
• Office2016 Remediation
• OS/Software troubleshooting

Confidential, Erlanger, Ky

Powertrain Engineering Developer

Responsibilities:

• Multiple Office 2010 Front End Applications development (VBA/SQL backend)
• Application support /SME for Erlanger Kentucky, Georgetown Kentucky, West Virginia, Alabama
• SQL server build (some Administration) Table maintenance/creation
• Automated Metrics/Reports for Senior Mgt
• Decommissioning of Web based apps - replaced with Office Apps (VBA/SQL backend)
• Patent Pending thru Confidential Legal Creation/Development PEPS2020 (for Powertrain)

Confidential, Burlington, Ky

MS Office Remediation Expert

Responsibilities:

• Remediation of Office 2003 Access databases to Office 2010
• Code re-writes in VB6 for depreciated earlier version VBA code
• Migration of multiple 2003 Access databases to MSAccess 2010

Confidential, Mason, Ohio

Technical Analyst

Responsibilities:

• Streamline Automated Reporting using VBA, APIs, SQL queries, and other methods
• Some Salesforce administration/ Sandbox Development
• Automated Front End Office Application projects for Senior Leadership and Analysts

Confidential, Erlanger/Georgetown Ky

Remediation/Support/Programmer

Responsibilities:

• L2 Support MS Office2010 Migration, Windows 7, and Internet Explorer 8
• MS Office Migration support across all US sites
• This project is a work stream within the company Workplace Of The Future (WOF) initiative.
• Remediate compatibility issues that result in migrating to Microsoft Office 2010 from Office 2007, 2003, and previous versions.
• Diagnose and resolve issues arising from Windows XP to upgraded Windows 7 when conflicts occur due to Office 2010 upgrades
• Demonstrate problem solving for all phases and impacts of the Office 2010 upgrade.
• Utilize strong technical, communications, and business skills.
• Utilize Microsoft Office Migration Planning Manager (OMPM) and comparable tools
• Utilize Office Compatibility Code Inspector (OCCI) and comparable tools
• Create new code for depreciated VBA
• Analyze, convert, and remediate all previous Office version files to Office 2010
• Analyze, convert, and remediate all previous Access databases to Access 2010
• Created SQRT Remediation tool for Mission Critical files reducing manual processes by 100%
• Created daily automated KPI reports relieving Project Manager from 1.5 hour daily scrubbing of data, reported to Senior Leadership Team
• Created daily automated Remedy reports and charting, relieving Project Manager from 1.5 hour daily scrubbing of data, reported to Senior Leadership Team
• Created daily automated Remedy IE8 reports, relieving Project Manager from 1 hour daily scrubbing of data, reported to Senior Leadership Team
• Work with confidentiality on corporate information.

Confidential, Cincinnati, OH

Programmer/Analyst/DBA

Responsibilities:

• Reduced manual reporting time by 100% (VBA automations/Front End Office Apps).
• Automated dashboards and multiple metrics
• Created NEW metrics via automated reporting
• Create ad hoc reports using ODBC and OLE through Excel from Access databases
• Maintain and create backup recoveries for 30+ MS Access databases.
• Created daily automated KPIs via emails for senior leadership and managers
• Introduced team to multiple automated solutions and Sharepoint Workflow tracking
• Analyze problems, determine approaches, compile and analyze data and prepare reports.

Confidential, Nashville, Tn.

Inventory Control Senior Analyst/Programmer

Responsibilities:

• Reduced manual reporting time by 100% (VBA automation/ Excel Front End Applications)
• Analyze problems, determine approaches, compile and analyze data, prepare reports
• SharePoint (develop/deploy/maintain)- Created a one-stop shop for reports, discussions, announcements, and links
• Analyze problems, determine approaches, compile and analyze data, prepare reports
• Streamline Daily Reporting (adhoc and standard) for Dell Inventory Control, Materials, and Operations Teams
• Work with confidentiality on corporate information

Confidential, Nashville, TN

Call Center Analyst/Programmer

Responsibilities:

• Reduced manual reporting time by 90% (SQL, VBA automations).
• Customize existing DTS packages for reporting accuracy.
• Create queries using SQL Management Studio
• Generate charts and metrics via Excel (VBA Automations).
• Create automated emails for Senior Leadership and key employees
• Created Excel03 custom toolbars and Excel07 custom ribbons
• Analyze problems, determine approaches, compile and analyze data, prepare reports.
• SharePoint launch (develop/deploy/maintain)- introduced SharePoint to Business. Create, design, deploy SharePoint sites and pages using SharePoint Designer
• SharePoint Design: Web Parts, Windows Services, Excel Services
• Streamline Daily Reporting (adhoc and canned) for Dell Small and Medium Business Call Center Nashville, TN. using ODBC via Excel VBA
• Implementation of a variety of projects with minimal guidance.
• Monitoring of accuracy in data records, log files, and reports.
• Work with confidentiality on corporate information.

Confidential, Nashville, TN

Data Analyst/Programmer

Responsibilities:

• Reduced manual reporting time by 90%.
• Create ad hoc reports using ODBC through Excel to SQL databases
• Automated slide creations in PowerPoint
• Develop non existing Engineering group metrics with minimal guidance.
• Created automated emails for key employees invoking real time pro-active response
• Analyze problems, determine approaches, compile and analyze data and prepare reports.
• Implementation of a variety of projects with minimal guidance..
• Generate charts and metrics via Excel to PowerPoint (VBA Automations).
• Compile and create new information gathered through metrics with minimal guidance.
• Facility Downtime’ reconciliation and reporting.
• Streamline “downtime” reporting process (VBA Automations) for Tennessee.
• Work with confidentiality on corporate information.

Confidential, Nashville, TN

Engineering Data Analyst/Programmer

Responsibilities:

• Reduced manual reporting time by 90% (VBA automations).
• Create automated adhoc reports using ODBC through Excel to SQL databases
• Automated slide creations in PowerPoint
• Created automated emails for key employees
• Develop non existing Engineering group metrics with minimal guidance.
• Manufacturing Facility Downtime’ reconciliation and reporting.
• Analyze problems, determine approaches, compile and analyze data and prepare reports.
• Carry out special projects for Tennessee facilities
• Compile and create new information gathered through metrics with minimal guidance.
• Implementation of a variety of projects with minimal guidance.
• Monitoring of accuracy in data records, log files, and reports.
• Work with confidentiality on corporate information.

Confidential, Nashville, TN

Quality Data Analyst/Programmer

• Created “The HUB”- completed and received Green Belt by following Six Sigma methodologies.
• Dell savings of $399,000 per year through the use of the HUB reporting and notification tool.
• Reduced manual reporting time by 75% (VBA automations).
• Create automated adhoc reports using ODBC through Excel to SQL databases
• Created multiple Access Databases
• Created Access forms for user input
• Automated slide creations in PowerPoint
• Created automated emails for key employees invoking real time pro-active response
• Analyze problems, determine approaches, compile and analyze data and prepare reports.
• SERVER Administrator (BNAEG1QESQL01)·
• Quality: Database Administrator (Dropped Systems, BQM, CQM, EFT, DocBox)·
• Quality: BPI Ideas Database Admin/Cold Fusion Development· inside.us.dell.com- Web/HTML Author/Editor Dell Intranet
• Implementation of a variety of projects with minimal guidance.
• Monitoring of accuracy in data records, log files, and reports.

Confidential, Nashville, TN

Metrics Tracking Specialist (Data Analyst)

Responsibilities:

• Track shipping metrics
• Report personnel updates to Senior Leadership
• Create and maintain MS Access databases covering a variety of metrics.
• Generate graphs and metrics via Excel VBA automations.
• Analyze problems, determine approaches, compile and analyze data and prepare reports.
• Work with confidentiality on corporate information.
• Carry out special projects
• Create new information gathered through metrics, to assist in advancing the efficiency of all Direct Shipping Department Records.
• Implementation of a variety of projects with minimal guidance.
• Develop & implement metrics on Employee Attendance tracking activities.
• Track shipping metrics throughout shift.
• Improve on existing department records and create new reports with minimal guidance.
• Monitoring of accuracy in Personnel records