Jennifer Varao

Currently, I support Microsoft Dynamics SL, and Business Central with technical issues and data analysis.  I love writing reports using Crystal, SSRS, and Power BI.  I love programming with Python, Visual Basic, and power apps.  My passion is data and GIS, though I am not currently employed in a GIS role, I do want to pursue a career using this technology that I learned and fell completely in love with while working as a Transportation Planner for the Osage Nation.

Plumbline Consulting
Support Analyst // Remote // August 2013 to Current
•Software and hardware installation, troubleshooting, support and training

•Diagnose, troubleshoot and resolve hardware, software, or other network and system problems, and replacing defective components when necessary

•Create and modify Reports based on client specifications using Crystal Reports, SSRS, and Power BI

•Perform database repairs, data backups, and disaster recovery operations via SQL server tools and TSQL language

•Creation of user stories for customizations/enhancements to products as the Functional consultant and Project Manager- Test end product- liaison between developer and customer

•Develop ChatGPT products and Power Apps based on client needs.

Osage Nation
Transportation Planner // Pawhuska, OK // June 2011 to August 2013
•Design, program, or model Geographic Information Systems (GIS) applications or procedures

•Produce and update overlay maps to show information boundaries, water locations, andtopographic features on various base maps and at different scales

•Analyze and interpret data from traffic modeling software, GIS, or database queryies.

•Produce data layers, maps, tables, or reports using spatial analysis procedures and GeographicInformation Systems (GIS) technology, equipment, or systems

•Participate in public meetings or hearings to explain planning proposals, to gather feedback from those affected by projects, or to achieve consensus on project designs

•Create, analyze, report, convert, or transfer data using specialized applications program software

•Familiarity of federal regulations revolving around Indian Reservation Roads (IRR) funding

•Compile, sort and verify the accuracy of data before it is entered into the Bureau of Indian Affairs'(BIA) Roads Inventory Field Data System (RIFDS) database

•Supervise 2 road crew and 1 junior GIS tech
•Review existing or incoming data for currency, accuracy, usefulness, quality, or completeness.

New Vision Consulting Group
Microsoft Dynamics Software Consultant // Edmond, United States, OK // April 2003 to June 2008
•Diagnose, troubleshoot, and resolve hardware, software, or other network and system problems,and replace defective components when necessary
•Develop training materials and procedures and train users in the proper use of hardware or software
•Install software such as SQL server, Windows 2000 server, SharePoint server, Project server, FRxfinancial reporting, and Microsoft Dynamics
•Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems such as the installation of new databases
•Plan, coordinate, and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification, or disclosure

Microsoft
Tier II Technical Support // Findlay, United States, OH // August 2000 to June 2002
•Responsible for software and hardware support
•Develop training materials and procedures
•Document software defects, using a bug-tracking system, and report defects to software developers
•Create/Modify/Fix reports in Crystal Reports
•Monitor bug resolution efforts and track successes
•Maintain databases of known test defects
•Update databases using T-SQL language

Sykes
Call Center Manager // Klamath Falls, United States, OR // May 1998 to August 2000
•Responsible for managing a call center•Duties included:•Design and develop training for staff

•Refer unresolved customer grievances to designated departments for further investigation•Analyze call volume and call time

•Manage staff of 27, preparing work schedules and assigning specific duties

•Determine staffing requirements, and interviewing, hiring, and training new employees, or oversee those personnel processes

Metric Equipment
Accounts Receivable Clerk // Hayward, United States, CA // January 1994 to May 1998
• Month-end reconciliation and reporting
•Locate and notify customers of delinquent accounts by mail, telephone, or personal visits to solicit payment
•Operate 10-key calculators, typewriters, and copy machines to perform calculations and produce documents
•Persuade customers to pay amounts due on credit accounts, damage claims, or non-payable checks, or to return merchandise
•Locate and monitor overdue accounts, using computers and a variety of automated systems
US Navy
Machinery Repairman MR3 // Alameda, United States, CA // August 1989 to May 1993
•Measure, examine, and test completed units to detect defects and ensure conformance to specifications, using precision instruments such as micrometers
•Clean and lubricate machines, tools, and equipment to remove grease, rust, stains, and foreign matter
•Machine parts to specifications using machine tools such as lathes, milling machines, shapers, or grinders
•Study sample parts, blueprints, drawings, and engineering information to determine methods and sequences of operations needed to fabricate products and determine product dimensions and tolerances

Computerized Accounting
Daly City Business College // Daly City, CA
GPA: 4.0

Some College (No Degree) – Clinical Science
San Francisco State University // Aurora, CO
GPA 3.5

Some College (No Degree) - Geographical Information Systems
American Sentinel University // Aurora, CO
GPA 4.0

Microsoft Certified Professional - Computer and Information Sciences
Techskills // Oklahoma City

CERTIFICATIONS
•Microsoft Certified Professional (MCP)

•Network +

•A+

•Security +

•ArcGIS Desktop Professional

•Top Secret clearance gained 2008

•ChatGPT Certification