PROFILE
Skilled and adaptable IT professional with a proven track record of delivering customized applications and reporting needs for various database-focused projects with a high level of client satisfaction. Great at building rapport and cultivating long-term relationships. Strong communication skills and adept at understanding customer needs and the ability to efficiently translate them into IT solutions. Ability to learn any and all tools necessary to complete various projects.
EDUCATION
Bachelor of Science in Information Systems and Technology GPA: 3.75
University of Phoenix
Database Administration Certificate GPA: 4.0
University of Phoenix
EXPERIENCE
Access Developer The Advertising Checking Bureau 2016 to Present
Database Design within Microsoft Access
Database Administration within Microsoft Access
VBA Development including the use of Object Oriented Programming standards to utilize functions, classes and other reusable objects.
SQL Development - Writing CTE’s, Functions, Triggers, Views and Stored Procedures within MS SQL Server
Database Design with MS SQL Server
Ad Hoc Data Requests for both internal and external customers
Report development
Data Analytics
Develops, monitors and maintains automated processes that utilize a combination of SSIS packages in MS SQL Server, Access VBA scripts and PowerShell scripts.
Create Documentation for various business objects and processes.
Interact with multiple departments and senior leadership to help facilitate operations and business goals
Database Admin/Development PF Chang’s (Corporate Office) Contract October 2017
Access Development (Tables, Reports, Queries) to help streamline inventory management across the country on a per location basis
Access VBA Development
Database Admin/Development HI Health (Corporate Office) Contract June 2016
Access Development. (Linked Tables, Reports, Interface with a .DBF file from a legacy database system)
VBA Development for data validation, data mining, outlook automation and automated excel functions
Excel VBA development for data mining across network drive to compile reports for weekly/monthly sales
Database Development & Application Development United States Navy (Maintenance Control Coordination NAS Oceana) Contract October 2016
Develop Access Database to be used for work logs and various information testing requirements
Develop Application to administer testing material to low level cadets. Original design was using VB.NET but newer requests was to host the application on a web site using ASP.NET and C#
Reporting feature to report test results to commanding staff.
Quality Control Operations Analyst Apollo Group 2016
Custom App Development
Ad Hoc Queries
Database Administration
Database Development
Data Analytics
SharePoint Administration & Development
JIRA Administration & Development
Regression Testing
User Acceptance Testing
QA Testing and QA analysis
Compiling, communication and analyzing various reports and large data sets
Monitoring trends in workflow
Defect Analysis in proprietary software
Managing Workflow for other departments
Meeting Organizer and communicating pertinent information to directors and department heads
Financial Aid Officer Apollo Group February 2011-2016
VBA Scripts for data collection and reporting automation.
Regression Testing
User Acceptance Testing
QA Testing and QA analysis
Creating/Managing/Updating Various Job aids/tools
Custom App Development
Works directly Analysts with various Projects
Compiling, communication and analyzing various reports and large data sets
Advanced Knowledge of Title VI procedures
Mentoring and Coaching Financial Aid Officers
Inventory Manager of Web Sales Gamers' Inn 2006-2011
Customer service and public relations in person and online
Trend Analysis in Secondary Market to promote buying and selling strategies to coincide with event planning and quarterly sales/release schedules
Store Public Liaison/Representative
Set up, Operation and Maintenance of E-Commerce database
Event Coordinator
Buying, selling, trading and appraising merchandise
Maintained and executed product logistics and merchandising
Hiring and training new employees
Cash handling
Data Collector A.C. Nielsen 2004-2006
Data Collection (Causal, Audit)
Calculating Sales and Trends of products based on a geographical location for clients
Uploading audit data
Public relations with the employees and business owners
Independent scheduling and time management
COMPUTER SKILLS
Microsoft Excel, Microsoft Access (.mdb and .accdb), Microsoft Visio, Microsoft Project, SQL Server, Visual Studio (2008 through 2015)
SQL (Development, Administration, Advanced TSQL including ETL, CTE’s, Stored Procedures, Triggers, UDF’s, SSIS and SSRS) MySQL, MS-SQL, Oracle SQL 5-6 years
Visual Basic Development 4 years
VBA 7 years
Junior C# Development
Junior ASP.NET/Classic ASP Development
Junior Development in Java
Junior CSS, HTML
Junior JavaScript
ACTIVITIES
March of Dimes Participant, Phoenix, AZ, March, 2009, 2010.
Food Drive MTG Tournament Host, Organizer and Emcee, Mesa, AZ, Fall 2008, 2009, 2010.
Magic: The Gathering State Champion, Phoenix, AZ, 2007. Constructed Rating: 1,850.
Operation: Secret Santa 2014