Resume

Sign in

Visual Basic Project Management

Location:
Henderson, Nevada, United States
Posted:
January 27, 2017

Contact this candidate

Resume For Ginger Hoffman

PROFESSIONAL SUMMARY

Over ten years experience as a Database Developer / Reporting Analyst with vast experience generating reports for management including forecasting, creating reports and forms, manipulating data for benchmarking, creating queries using SQL.

Report development experience includes data is pulled from a data warehouse or large database and summarized for reporting purposes. Also includes implementation experience where such a data report is implemented based on instructions and criteria provided to the analyst.

15 years plus experience with VBA, SQL.and Access development.

Extensive experience writing documentation and user manuals.

Demonstrated ability to assist with and performed detailed quantitative analysis with the ability to gather, document, analyze and draw conclusions on data and information.

Ability to handle sensitive data with integrity.

Over ten years of energy industry experience (SCE), 5 years as a senior developer and 5 years as a Systems Analyst

3 years in healthcare and medical insurance

5 years supporting project management, gathering requirements, document retention, budgets and forecasting, project cost analysis, change management, project tracking budget/costs/schedule and providing mock-ups.

TECHNICAL SUMMARY

Microsoft Office Suite 2010 (Access, Word, Excel, PowerPoint, Visio),

Access Total Statistics, VB, VBA,

Oracle, SQL, SAS

Crystal Reports, INFORMIX, HYPERION,

ESSBASE, Analytics, Business objects,

SAP, PPM, Enterprise, Peoplesoft, Irise,

IBM National Requisite Pro, ClearCase

Data Warehouses

PROFESSIONAL EXPERIENCE

Navient (Fahrenheit IT) 5/27/15 – 12/30/2016

11100 USA Parkway

Fishers, IN 46037

317-***-****

PCR Contingency & Debt-Systems Developer/Database Developer

Reverse engineering database processes using Access 2003/2007/2010

Making changes to database processes to automate/speed up existing and new processes

Coding with VBA in ACCESS databases

Report generation

Loan data and information management, data handling and reporting experience

Automated Month End reporting resulting in processing time being lowered from 5 days to 15 minutes

Key Benefit Administrators (Pinnacle Partners) 2/9/2015 – 5/5/2015

8330 Allison Pointe Trail, Indianapolis, IN 46250

800-***-****

Reporting and Audit Specialist

Auditing data, loading and processing files for health benefits company

Health insurance plan data and information management, data handling and reporting experience.

Southern California Edison 1/12/2009 - 11/14/2014

P.O. Box 800, Rosemead, CA 91770

(626) ***-**** or 800/***-**** option 3

Fax: 626/***-****

Email: acyik2@r.postjobfree.com

Sr. Systems Analyst (ASY3)

Used Crystal Reports, MS Excel and MS Access to develop reports, presentations and complex analyses. Also used Irise to present an interactive display of a potential tool to management.

Direct experience with SAP as a data mining and/or project management tool.

Experience with SAS has been utilized.

Defining, designing, and enabling tools, methodologies, models, and metrics, using advanced analytics.

Provide project support to the senior project manager, such as business requirements, refinement of performance metrics, and ad-hoc analytical support.

Experience with the application of project management tools and techniques to coordinate and support projects/assignments that include tracking and updating status for stakeholders.

IBM National Requisite Pro and ClearCase for requirement tracking.

Conducted analysis leveraging statistical tools (primarily SQL and SAS) on very large, complex, multi-dimensional datasets.

Provide data analysis support to identify, develop and track performance metrics that will measure project success. Assists in designing, developing, tracking, and reporting performance metrics and/or ad-hoc analysis, which includes the designing and development of reports.

Southern California Edison 4/2005 - 1/12/2009

P.O. Box 800, Rosemead, CA 91770

(626) ***-**** 3456 or 800/***-**** option 3

Fax: 626/***-****

Email: acyik2@r.postjobfree.com

Sr. Application Architect

Database Development, Data analysis, and Ad-hoc reporting

Worked on the Comp Review process every year. (company-wide compensation)

Demonstrated knowledge of regulatory requirements and Corporate Policies & Procedures.

Supported HR Systems including HR Data Warehouse applications

Assisted in designing innovative activities aimed at streamlining processes

Utilized Visual Basic, Microsoft Access, Microsoft Word, Microsoft Excel, Microsoft PowerPoint and SAS to do data extraction, cleansing and validation using specialized software and created reports.

Independent Consultant 01/2003 - 4/2005

Programmer/Analyst And Database Developer

Client list includes: Filenet, Amgen, Fidelity & Trust Mortgage, Capital Group, Warner Bros, St. Joseph Hospital, Children’s Hospital of Orange County (pediatrics intensive care unit) and Parkview Hospital

Was self-employed as a computer consultant, developing databases and programs for a variety of clients. I also contracted with employment agencies for some positions.

Report creation was necessary for each project.

Wrote program specifications according the client needs, verified the scope of the project with the client, provided the services necessary to complete the task in a timely manner, and provided time and billing to the customer.

Database development for Filenet.

Database development for metric reporting for Amgen.

Database/program development for Fidelity & Trust Mortgage Inc.

Database development for Capital Group.

Database programming and development for Volt.

Database programming for a major temporary agency.

Developed bar and catering program.

Database analysis for Warner Bros.

Inventory program for a motorcycle shop.

Hospitals (St. Joseph, Children’s Hospital of Orange County pediatrics intensive care unit and Parkview Hospital in Riverside). I repaired and maintained databases, VB programming.

Developed a program for automotive racing.

EDUCATION & CERTIFICATION

University of Phoenix

American Technical College, San Bernardino, CA, Computer Science Course (certificate program).

Chaffey College, Ontario CA, - Visual Basic 6 1999, Advanced Visual Basic 6, 2000, Visual Basic.NET 2007



Contact this candidate