| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
PHONE NUMBER AVAILABLE Fort Worth, Tx
EMAIL AVAILABLE
Process Improvement Engineer
Excel Application Programmer, VBA Professional
Data Analyst
Report Writer / Creator
Education:
DeVry University, Irving, Texas -- Major: Telecommunications Mgmt.
Johnson & Wales University, Virginia Beach, Virginia -- Major: Culinary Arts
Christopher Newport University, Newport News, Virginia -- Major: Management
Computer Applications:
MS Excel V and H-Lookups, Power Pivot (and Pivot Tables), Extensive VBA skills,
Power Query (for BI and SQL work), complex formulas, see remainder at bottom of
document
SQL Server Manager Writing queries to extract data with great accuracy, Oracle SQL
MS Access (Advanced) Using Access as the front end for SQL data manipulations and
User Tools. Publishing forms to Internet for data collection and dynamic reporting.
Integration with Access, Excel and Outlook. Creation of web pages.
MS Word (advanced) Mail Merge for both print and email use. Integration with
Access, Excel and Outlook
MS PowerPoint, MS Visio, Microsoft Query, MS Macros (VBA - Power User), Aspect,
SAP, Big Query, Double Helix, Fiserv, DebtMaster (collections software system), Jiva
(patient records) and MEDai (medical predictive software an SAP service), Active
Directory, Altiris, SalesForce
Summary:
A self-taught analyst/programmer adding value to corporate projects through creative
and stress-tested solutions.
Industry Experience:
8/2017 9/2017
Alcoa/Novartis
Sr. Technical Support Specialist
Database management
Candidate's Name - EMAIL AVAILABLE 1|Page
Membership management
Regulatory reporting
3/2017 8/2017
CBRE (Contractor)
Collaborated with the Global Rollout team for the transition from office to O365.
Redesigned processes for BI Reporting.
Analyzed and corrected data for integrity issues (ETL).
Collaborated extensively with teams in APAC and EMEA
7/2016 2/2017
AIG (Contractor)
Engineer - Project Management team
Streamlined the internal Project Management process for continuity.
Created a MS Access Front End / SharePoint, Excel, Project and Oracle Back-
End system.
Advanced Dashboards
Power Query and Power Pivot manipulation
Advanced array manipulation
Project Documentation
10/2015 6/2016
Cash America International Contract to Perm (1/2016)
Data Analyst HelpDesk
Created and provided regular reporting on:
Help Desk for 821 Shops and all Corporate tickets
Customer Complaints and assisting with Compliance expectations.
POS and Network upgrades
5/2015 - 9/2015 Excel Applications Engineer
Pier 1 Contractor
Hired to convert tools made in Excel 2003 and Access 2007 into Excel 2013
Microsoft SQL Server 2014
Stored Procedures
Excel VBA
Turning Business goals into VBA/Excel procedures
Using Power Query and Power Pivot to access SQL Databases for repeatable
functionality
Used System Batch files for processes
Excel, VLookup, HLookup, Pivot Tables, SQL, PowerPoint, VBA, PowerPivot, Power
Query, JAVA, HTML-5
8/2014 - 4/2015 Telecom Data Analyst
Google - Contractor
Candidate's Name - EMAIL AVAILABLE 2|Page
Data Design Team, Large Scale Design Team, Operation Clean Sweep
Cleaned the database and created standards for nomenclature.
Mapped Hardware/Fiber for United States network.
BI operations using Pipewrench, #PLX and Google Dashboards
Created Process documents
Worked with datasets of over 5 million records
5/2014 - 8/2014 Caliber Home Loans IT Analyst III
Contractor 60-Day Contract
Managed the customer letter campaign while principal was on maternity leave.
11/2013 - 5/2014 McKesson Contractor
120-Day Contractor
In three months, saved the company over $100,000 in staffing (2.25 FTE x $40,000, as
per internal numbers) through Process Improvement and Automation
1/2012 -11/2013 HealthSmart Holdings
Predictive Modeling
Operations Supervisor
2008 - 2009 RiverWalk Holdings
Analytics Department
1999 2001 WorldCom
Broadband Circuit Design Engineer
Excel Super User.
Single & multi-conditional counting and summing
Advanced look ups (VLookup, HLookup/HLookup) as well as the more dynamic
Index/Match function-combination and Pivot Tables.
Power Query and Power Pivot for BI Data Work.
The programmatic creation of dynamic ranges that adjust automatically for
growing/shrinking data sets.
Integration with Outlook (Email & Scheduling), PowerPoint (presentations) and Word
(Mail Merge), SharePoint, Microsoft Project
MACRO and VBA programming for elaborate automated functions & Windows File
manipulation and SQL for hardcore Data Mining.
Candidate's Name - EMAIL AVAILABLE 3|Page
|
