Data Entry Power Bi
Resume:
Amy Schalla Experienced IT and project support
specialist with extensive knowledge in
Power Platform/SharePoint
development, data management
systems, and organizational workflow
improvements. Seeking to leverage my
expertise in enhancing operational
efficiency for the Department of Energy.
Experience Education
2024 – Current
SharePoint Developer/System Analyst
Department of Energy Contractor
Development and Implementation of SharePoint and AMB/WFM Webpage. Maintenance and Developer for AMB SharePoint page, Assist AMB divisions in development of SharePoint sites, Coordinate and synchronize AMB SharePoint sites,
Maintain AMB SharePoint page and assist AMB divisions with SharePoint pages, Maintain and update WFM intranet webpage as needed, perform quarterly review of WFM intranet webpage for accuracy, including but not limited to weblink maintenance, information updates, and program timelines, etc.
Hanford People Core (HPC), PopFon, Organizational Charts, HRRA. Data entry of new Federal staff members into HPC for temporary display in PopFon until their ESS profile becomes available. Notification to DOE Visitor Control when staff move between the offices in reorganizations or transfers based on promotions, Requesting the addition of new office locations in ESS (where a building is not listed in the drop-down menu. Review HPC Nightly Load Errors Report and resolve anomalies, Review of HPC Monthly Multiple Profiles Report Federal Employee data and resolve conflicts, assist new employees with population their ESS profile once they have access to ESS AND notify HPC Administration to delete hardcoded entry.
Perform periodic review of PopFon to ensure employees have correctly populated all ESS fields and assisted employees in processing updates needed as anomalies are found (i.e. missing information such as room #, phone #, MSIN) (suggest quarterly at a minimum), Data entry of GSSC staff as they are onboarding and as they terminate their contractual relationship with DOE. Review of Monthly HPC Multiple Profiles Report GSSC Employee data and resolve conflicts, End-of-Year HPC validation of GSSC staff which contracts being renewed in the next FY. Create and manage reports in Human Resources Reporting Application (HRRA), Finalize new employee profiles in HRRA. Manages awards program ESP updates and modifications requirements. Coordinate with AMP to update the GSSC ORG charts monthly. Provide updated GSSC ORG Charts to EM monthly. Assist with Power BI and Adobe documents as needed. Built infrastructure for onboarding the GSSC process, to improve efficiency in communications between departments. Built instruction B.A., Digital Technology &
Culture
Washington State University
Richland, WA.
Université de Nice Sophia
Antipolis / Media Language &
Culture
Nice, France
Certifications/Skills
Certified Power BI Developer
Certified AI Solution Architect
Certified Scrum Master
Power Platform developer
Power Automation architect
Power Apps developer
SharePoint Developer
Database Administrator
Power BI/SharePoint/Teams trainer
Report/dashboard Builder
Data integration
Communication
Technical Documentation
Contact
1833 Peachtree Lane, Unit 2
Richland, WA. 99352
********@*****.***
manuals for both a PopFon administrator and a new hire in HWFM division.
2020 – 2024
Budget Support Developer
Department of Energy Contractor
Functioned as the chief organizer for gathering and reporting budgetary data analytics requirements to DOE. Utilized multiple software platforms and DOE-approved systems to provide effective communication. This included but was not limited to, Microsoft Office 365, Power Platform, Power BI Service, and Power BI Desktop. Maintained repository of historical budget data and improved the process for budget analysts to access information. Facilitated usage and provided training to all budget analysts for Power BI and Microsoft Office 365. Wrote a Power BI instruction manual every six months to help the budget division create better reports. Retrieved data from various sources including DOE – approved systems, Excel, and SharePoint. Built data models for budget division that was also being used for other DOE divisions to assist all of DOE with reporting. Maintained fact and dimension tables. Defined relationships between tables and built time intelligence functions using DAX. Built a Key Measures table to house all measures for ease of use by budget analysts. Built and maintained queries for data retrieval to easily extract, transform, and load using Power Query. Adjusted the model using the advanced editor and M code. Designed, developed, and tested (DEV – TEST – PROD) data sets in reports/dashboards. Sole developer in the budget division required me to be self-actuating and have an ability to pivot. Not one day was the same and I needed to prioritize and be decisive. Learned to triage to save time and effort. Developed database in Access and used SQL for queries. Built automations using Power Automate and used JSON expressions and HTML
2019 - 2020
Project Document Control Specialist
Bechtel Contractor
Front desk administrator and processor for incoming hard copy documents. Worked with confidential material and maintained strict confidences. Followed document control procedures in transmitting and receiving documents. Performed as Front desk administrator and processor for incoming hard copy documents. Demonstrated administrative capability to multitask while maintaining attention to detail and accuracy. Prepared and distributed folders/documents for document control processor groups. Followed document control procedures in transmitting and receiving documents. Collaborated closely with other departments to ensure timely delivery of documents. Used digital platforms to generate codes for incoming design documents and drawings. Performed data entry to maintain logs and track documentation. Collected documents in preparation for indexing, shredding, and digitizing. Anticipated changing priorities and projects as needed. Worked with confidential material and maintained strict confidences. Organized physical archives in accordance with company standards. Verified that all archived documents were properly labeled, indexed, and stored securely. Maintained confidentiality and provided secure access to documents as required. Utilized database systems to organize, store, and track documents in accordance with established standards. Coordinated with other departments regarding the collection, storage, retrieval, and destruction of documents. Maintained up-to-date knowledge on applicable laws and regulations governing document management. 2015 – 2018
Customer and Sales Support Specialist
LiveTiles
SharePoint online administrator for customers, partners, and trial users. Recreated software bugs and documented all steps to clearly communicate to the development team. Implemented, configured, and managed customer support system for tickets. Performed software testing using Visual Studio for product development team. Recreated software bugs and documented all steps to clearly communicate to the development team. Software installation expert for LiveTiles Design Manager, LiveTiles Blueprint, and LiveTiles Build. Onboarded new customers and partners using Licensing portal through Azure. Designed and sent a welcome package to all new customers. Salesforce CRM administrator for all customers, partners, and leads tracking. Provided Sales support for all LiveTiles pre- and post-sales sales personnel. SharePoint online administrator for customers, partners, and trial users. Yammer administrator to capture support questions and post help topics for customers. Marketo Administrator to generate license keys for educational institutions and assist with LiveTiles Mosaic installation. Intercom Live Chat agent for all incoming customer questions and converted to support tickets in Freshdesk when necessary.
2014 – 2015
IT Support Technician
Elevate
Responding to customers need assistance and communicate effectively to determine the nature of their problems. Provided technical assistance and support. Provided technical assistance and support related to computer systems, hardware, and software. Ran diagnostic programs to isolate problems and determine solutions to implement. Responded to customers needing immediate assistance and communicated effectively to determine the nature of their problems. Performed software installation and repairs as well as trouble shooting computer peripherals for users. 2013 – 2014
Engineering Support Specialist CSM
Cypherpath
Provided product feedback to the development team using heuristic evaluation practices to contribute suggestions and assist with software testing. Coached Agile methodologies to the development team. Assisted the IT department with IT related tasks, migrations, change management, etc. as needed. Wrote software product manuals.
2013 – 2013
Scrum Master
Droctel, Inc.
Scrum Master for a Lean Start up Mobile App development company. Conducted and managed Agile scrum activities for the development team. Gathered scrum metrics using story points and velocity charts to track team's progress. Enforced sprint priorities and rapid release delivery deadlines. Facilitated release planning, daily stand-up meetings, reviews, retrospectives, sprint planning, and demos. Ensured development teams are practicing core Agile principles of collaboration, prioritization, team accountability, and visibility. Continuously updated Agile tracking systems to provide transparency on Product and Sprint Backlogs. Identified and removed impediments that could interfere with the ability of the team to deliver the Sprint goal. Worked with minimal supervision in a very dynamic, geographically distributed and timeline sensitive work environment.
2010 - 2012
Project Support Specialist
ZanttZ, Inc.
Organized and led scheduled Scrum meetings in an Agile environment to identify impediments blocking progress of projects for the development teams. Built reports/dashboards for tracking team velocity and sprint release progress. Assisted with internal/external communication, improving transparency, and radiating information to the larger organization. Coordinated all office operations including travel for executive management and wrote procedures to ensure organizational effectiveness. Acquired extensive experience with handling procurements, contracts and invoicing.
Created, modified, and implemented policies for the office. Used QuickBooks for bookkeeping, vacation accrual, amortization and depreciation. Worked as HR for the office handling all onboarding and scheduling interviews. Assisted with the preparation of presentation materials using various software applications. Reviewed, edited and proofread technical documents. Prioritized and managed multiple projects creating relevant documents.
Contact this candidate