Visual Basic Project Management
Resume:
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
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
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/500-4723 option 3
Fax: 626/302-2670
Email: ********@***.***
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/500-4723 option 3
Fax: 626/302-2670
Email: ********@***.***
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