Andrea Rector (Johnson) Email & Phone Number

Fargo, Nd, Us

Fargo, Nd, Us

Fargo, North Dakota, United States

• Championed business strategic objective to develop web-based tool for real-time program metrics and data, enhancing productivity and data-driven decisions across all levels.• Developed expertise in Ignition, SQL, and Python to provide technical guidance.• Translated user needs into concise requirements by collaborating with user to analyze existing tools and leveraging domain expertise.• Drove results by managing backlog and work sprints using Agile methodology and product owner best practices, ensuring progress and team alignment. • Maintained high-quality project data through relational model (RM) creation and SQL database management. • Guided developer team, encouraging collaboration and DevOps concepts to deliver a consistent UI/UX and leverage code reuse across the multi-module tool.• Leveraged secure AI tools to enhance script and SQL query development, accelerating project delivery.• Secured database and application data by using individual and role-based access control (RBAC) and integrating a secure identity and access management (IAM) cloud solution.• Fueled user engagement, driving 50% update rate for product improvement programs and 20% for new product programs in just two months, plus sparking feature requests from over 5 departments.• Leveraged Azure Databricks connections to create data models in Power BI, reducing load on Power BI clusters.

Remote

• Advocated for and created subcommittee to meet the unique needs of employees in compressed workweek, job share, part time, and time flex arrangements. • Led team to facilitate an inspiring and critical conversation with leaders and individual contributors about flexibility in operations roles.

Fargo, North Dakota, United States

• Created and managed project data pipelines, reducing accounting reconciliation from multiple days to one day. • Directed the transition to Power Query and Power BI, ensuring smooth migration from end-of-life reporting system.• Developed, tested, and automated new portfolio-level schedules and dashboard, providing real-time data for informed decisions.• Supported successful release and maintenance of Long Range Portfolio Planning for 70+ programs (millions in R&D budget), including user training and resolving issues.• Facilitated cross functional Project Lessons Learned team and creation of review process, initiating 13 process improvements and highlighting 20+ critical lessons for cross functional project teams.• Led a cross functional team of business leaders as they installed free drink dispensers and created collaborative working spaces, boosting employee engagement.

Remote

Fargo, North Dakota, United States

• Managed department tools, data, and continuous improvement.• Spearheaded adoption of automated Power BI reporting after evaluating cost and benefits, reducing pre-meeting prep time by 90% and training time for new analysts. • Provided subject matter expertise on data, KPIs, and reporting on impact of management-led changes.• Developed financial reconciliation Excel tool, enabling data-driven spending decisions (millions).• Created a single macro file to deploy macro fixes to dozens of project tracking files simultaneously.• Fostered team cohesion through virtual chats during COVID and conflict resolution discussions.• Increased work instruction documentation from 80 to 95% in a dynamic environment.• Led strategic initiatives project to improve configuration management, reducing overdue change approvals by 98%.• Mentored analysts, empowering them to tackle complex work, including Power BI report development.• Created knowledge sharing articles to enhance analyst autonomy in resolving technical issues.• Ensured data integrity through data review meetings, contributing to 80% error reduction over one year.

Fargo, North Dakota, United States

• Analyzed program metric outliers and presented to management, leading to a part-time city auditor job offer. Data was also shared with senior leadership. • Volunteered to write report requirements for ERP deployment, helping IT Business Analysts meet deadlines.• Implemented process improvements with PMCI (Program Management Continuous Improvement) team input. • Developed deadline management system, enabling analyst team to exceed expectations, completing 93% of program managers’ requests within 1-day.• Boosted task and report efficiency by 25% through automation and improved templates. • Leveraged advanced Excel features and future-proofed design to ensure long-term data integrity.• Trained underutilized admins in other departments, increasing resource utilization by up to 20%.• Increased work instruction documentation by 10%, enhancing support and reducing errors.• Developed system for managing personal & team deadlines and priorities.

Fargo, North Dakota Area

• First point of contact for customers' quality concerns.• Investigated and rectified warranty claims, boosting supplier score with a Deere partner and customer satisfaction with an OEM customer.• Supported a critical Deere corrective action and an OEM product quality issue, coordinating technical investigations and receiving praise for my customer service from both.

Fargo, North Dakota Area

• Analyzed and compiled data from several sources, discussed trends with quality engineers, and sorted materials.• Trained new data coordinator within 6 months of starting

North River, Nd

• Tracked budget and expenses, facilitated city council meetings, tracked minutes, and managed city's accounts payable transactions according to ND Century Code 40-16

West Fargo, Nd

• Worked face-to-face with customers on a daily basis• Practiced organizational skills, task prioritization, and time management• Worked as a team to complete tasks within time constraints

Fargo, North Dakota Area

• Tutored college students in math and engineering mechanics courses.

Superior, Wi

• Drafted registered land surveys with AutoCAD-based program (Carlson Survey)

Duluth, Mn

• Operated equipment at a research facility• Assisted engineers, including creating and reading drawings in AutoCAD

Superior, Wi

• Created and implemented filing system, assisted office manager, GIS analysts, and engineers.• Learned ArcGIS, gathered pipeline environmental data, and mapped environmental safety data.

Bachelor Of Science, Civil Engineering, Magna Cum Laude

Transfer, Pre-Engineering