I am officially retired, but currently driving for Lyft & Uber. I felt having a small business would be beneficial in keeping my skills sharp as a Business Analyst.I have experience in Business Systems Analysis, with an emphasis on data bases; Access and SQL Server. Specialties include MS Access and Excel with Formulas, V-lookups, Pivot Tables, Power Pivot and Power Query. I have excellent communication, customer service, time management, problem-solving, and analytical skills. Dependable, detail-oriented team player, with the ability to remain calm in stressful situations.• MS Windows 7, 8, 8.1 and 10, Apple MAC OS • Production Support• Business Program Errors: Documentation and reporting, including resolution of procedural errors • Quality Assurance and documentation• Project Planning • Multi-tasking in fast-paced environments• Adobe Acrobat Pro’ DC and LiveCycle ES 4 • Data Analysis and Project Management• Procurement and Supply Chain • Organized, with strong analytical skills

The job entails bidding on available jobs, successfully completing accepted bids and advertising the successes.The system has some inherent flaws.

Consultant – Business / Data Base Analyst – Human Resources 11/2017 to 01/2018Bay Area Environmental Research Institute – NASA Ames, Mountain View, CA • Performed preliminary analysis on procedures for the Company’s HR Department, with a focus on Personnel Actions, resulting in a test Access Data Base.• Using Excel worksheets, began a design on an HR database in MS Access. The initial database module would contain select employee details, history and actions. Future modules would contain a detailed history, from employee on-boarding to departure and another module for employee travel expenses. A payroll module interface with ADP was also on the table to be addressed. Forms and Reports would be included. Operation was suspended with a new emphasis on G-Suites.• Re-wrote a PDF form (from paper) for Payroll Action Requests (PAR), which included documentation and maintenance. The resulting PAR form immediately saved time and money with its implementation.• Wrote some PDF forms for Employee Review (HR-ER), which included documentation and maintenance. Results are constantly saving employee time and company dollars.

Consultant – Analyst – Materials & Supply Chain 07/2017 to 10/2017Cornerstone Staffing Solutions, LLC | EYE-Fi, LLC – Las Vegas, NV • On MS Excel, keyed in back orders from key customers, IGT and BALLY and assisted in inputting the resulting counts of a full materials supply inventory.• Created a list of materials from supplied documentation needed to organize the Company’s use of supplies and progress in display manufacturing for the company’s lead customers (IGT, BALLY, AGS and Everi) participation in the 2017 Global Gaming Exposition (G2E).• On Access, created three reports and associated queries, showing part shortages for future work orders. The reports showed work orders, parts needed, location and on-hand, with an emphasis on those parts which would be in short supply.• Using VBA, reports were exported to MS Excel and printed in PDF format or on a printer, • Added Menu items to select the above reports to the EYE-Fi, LLC’s Access Main menu. • A lead to my release was a change coming soon in Inventory Control; QuickBooks and MiSys Manufacturing Software; both interacting with G-Suites. I have no experience in the former, though the latter is no problem.

Information Technology professional; with experience in the areas of 7x24 Customer Support, Technology Consulting, Quality Assurance, RDMS Table Design, Data Analysis and Programming. My current work includes Advanced Excel, using Pivot Tables, Lookups and VBA, along with MS Access table creation, queries and downloads/uploads to Excel. Highly experienced in using System Development Life Cycle (SDLC) controlled environments; at gathering, analyzing, verifying, and cleansing data pertaining to application requirements, design, usability and performances, in addition to a strict adherence to standards and design, with a comprehensive background in project and program management and familiar with database design and data management. Experienced in negotiations and acting as a liaison with business groups and clients to determine needs, and formulating effective solutions to ensure productivity and efficiency, in addition to remote problem determination and resolution. • Expert in Excel (recently certified in PowerPivot and Power Query), proficient Word, PowerPoint, Project, Access w/VBA, Visio and Outlook. Visual Studio, Visual Basic, Java, VB.Net, Adobe Acrobat Professional. • Perform Data Analysis and Management. Adherence to Development Principles; SDLC, Detail-Oriented and Organized with Strong Analytical Abilities. Experience in the troubleshooting, resolution and documentation of Programming and Procedural Errors. Time Management, Prioritizing

• Based upon a select group of KEY suppliers, maintained a clear picture, to contract mangers and AT&T executives, of dollars spent by the Company vs. supplier financial health by accurately doing select financial profiles• Updated quarterly, by query on Access, the Access Supplier Master file, using uploaded Excel worksheets (consisting of AT&T Core Vendor Master and Spend); for reconciliation showing new Supplier data and dollars spent from AT&T Core System Supplier and Dollar Spend files • Created new supplier assessment reports, as scheduled, using MS Excel (v-lookups and pivot tables) or as requested by management, showing supplier’s financial health and ability to fill contracts• Provided, according to schedule, detailed and formatted supplier company financial analysis, showing a dollars spent vs. supplier health reconciliation reporting, using Excel and PowerPoint for executive reporting• Uploaded new and completed supplier assessment data and confirmed data accuracy and completeness, before Access database updates• Setup and ran as scheduled, MS Access queries and updates, in multiple Access databases, to add and report new vendor and spend profile data on a dashboard• Created, tested and documented better methods of execution on all of the Excel and Access tasks under my responsibility• Setup and documented a new procedure to reconcile new key suppliers and their associated AT&T spend to the Access Supplier and Spend Master files

Working Online from home; Part Time for Ovalis Group as Study Group Administrator & Organizer• Lead Ovalis Group, LLC, ADM 201 Certification Study Group; using leadership and organization skills• Performed website administration, critiquing study group members’ site and modifying my own• Learned and exercised new marketing techniques from other study group members

• Sub-contracted to Compucom over numerous time periods; deployed at Salesforce, Inc. and Levi Strauss Co. For Levi Strauss, provided post hardware deployment support to resolve issues and document those outstanding for later resolution.

• Worked closely with developers to test a major new program which tested room lighting wireless control units• Documented the test application errors and failures along with Operating System restarts • Documented, using Excel, quality of the test units, i.e. “Pass,” and “Fail” • Successfully organized, on Excel, tested units and set them according to Pass, Fail and Indeterminable (Adura Technologies, Inc was purchased by Acuity Brands, Inc - AYI (NYSE))

Consulting for Manpower Professional Services . . .• Worked in a project to automate the first tier of Production Support for Hewlett-Packard’s many server products• Closed case analysis was done in regard to data outages on Hewlett Packard Company’s Proliant Server lines (including Blades), HP-UX Software and Enterprise Virtual Array (EVA), analyzing each case to confirm a data outage and if so, the commodity which caused the outage• Cases were re-evaluated to document the product quality, dependability and support, with the results entered into an ad-hoc database and compared with those of the automation program.• Outages were reconfirmed as well as the cause of the outage, i.e. power supply, memory, system board, etc., all of the instances of data loss, and the duration of the outage in hours

Consulting for Robert Half International• Short term project for the Project lab confirming and debugging existing complex Excel formulas and macros• Worked closely with management, corrected existing errors in Excel and created replacement formulas which classified various lab test results

As a consultant for Agneto Professional Services . . . • Reviewed information for processing and cleansing, planned and designed reports using techniques such as structured analysis, data modeling and information engineering• Utilized MS Excel, pivot tables and VBA, in preparing supplier expenditures for State, Federal and requested reporting • Analyzed and summarized reported expenditures, researched and confirmed supplier diversity certifications• Identified options for potential solutions and assessing them for both technical and business suitability• Created MS Access databases of key supplier details and certification data for ad-hoc information reporting• The Systems/Software Development Life Cycle (SDLC) was strictly adhered to as part of a controlled/validated environment• Worked closely with developers and end users to ensure technical compatibility and end-user satisfaction

As a consultant for Teksystems, Inc. . . .• Performed on-demand problem analysis and documentation• Worked with Clients to trouble-shoot problems to initiate or achieve a proper solution• Worked with Clients in regard to modifying or upgrading their networks• Directed those problems not within the scope of Tier II to their proper group for resolution

• In a final Team Project, for Fiat Travel, spearheaded a website improvement proto-type to simplify client registration, tour reservation and enabled prospective clients to register and pay fees online via PayPal• Utilized Visual Basic 6.0 and MS Access with SQL in designing and writing client input and reservation proto-type application• The Systems/Software Development Life Cycle (SDLC) was strictly adhered to as a point of project evaluation

As a consultant for K-force, Inc -• Performed file compression, reloading and updated files and databases in a timely manner• Learned new methodologies for data retention to accommodate specialized catalog structures

As a consultant for Data Systems Search Consultants -• Provided off–shift technical support including determination and resolution of errors in processing and/or procedures • Ticketed problems, errors and resolutions, for documentation, to be provided to PCSE Developers • Checked and confirmed critical systems tasks

As a consultant for EDS, Inc. . . . • Updated Del Monte’s Financial Invoicing System, using COBOL II, those batch and CICS programs with two byte date fields to four byte fields, i.e. date fields were modified, to add the century, from “99” to “1999,” in preparation for the millennia change (Y2K compliance)• Performed program analysis and programming tasks to maintain and ensure changed programs and systems functioned properly under the new 4-digit date scheme• Tested both CICS and batch applications, using standard testing methodologies, i.e. The Systems/Software Development Life Cycle (SDLC) was strictly adhered to as part of a controlled/validated environment

• Developed and maintained DB2 tables and CICS programs using COBOL II with SQL• The Distributed Relational Database Architecture (DRDA) relational database interoperability standard was used for interaction with AS/400 SQL/400 tables• Actively performed production support, quality assurance, and installation for all mainframe applications• The Systems/Software Development Life Cycle (SDLC) was strictly adhered to as part of a controlled/validated environment• Applied changes to job control language, JCL scripts and parameters• Assumed operational and troubleshooting responsibilities for the AS/400 operating system ensuring all AS/400 subsystems were active and responsive• Helped coordinate integration of Circle International Freight Forwarding systems to the systems at EGL Global Logistics• Provided 24/7 support in solving computer related problems, such as malfunctions and program problems

As a consultant.

• Developed and maintained distribution center, store inventory, general ledger, and merchandising applications in mainframe batch and online environments • Worked with AS/400 relational databases, using SQL/400 for data extraction, formatting and update• On AS/400 Test System, worked on the team, creating a Garment Production and Inventory system • Performed COBOL program conversion to OS/400 COBOL, inventory file definition and design, and utility panels• The Systems/Software Development Life Cycle (SDLC) was strictly adhered to as part of a controlled/validated environment• Provided 24/7 scheduled user support for assigned merchandise and inventory systems as a follow-up from Production Support• In a Production Support role, wrote system documentation for the development teams and installed associated JCL procedures and parameters