Andrea Rector (Johnson) Email and Phone Number
In my career, my roles blended data analysis skills with a penchant for utilizing Agile methodologies. My team has successfully launched a user-friendly interface for real-time program metrics, significantly boosting productivity and enabling informed decisions.Championing innovation and collaboration, I've guided developers and analysts in creating outstanding UI/UX experiences for various tools and reporting. My commitment to maintaining data integrity and aligning business needs with our capabilities underpins every project we undertake.I've become skilled in many tools and programming languages, including Python, SQL, Ignition, Power BI, DAX, SQL Server, Excel, VBA, etc. My love of learning technical skills combines well with my passion for sharing knowledge, resulting in mentorship on teams that I have led.
-
Data AnalystState Of North DakotaFargo, Nd, Us -
Epdp Process Coordinator (Technical Owner Responsibilities)John Deere Nov 2022 - Jun 2024Fargo, 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. -
Flex Erg Time Flexibility Subcommittee ChairJohn Deere Nov 2022 - Dec 2023Remote• 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. -
Epdp Process Coordinator (Business Intelligence Analyst Responsibilities)John Deere Sep 2020 - Nov 2022Fargo, 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. -
Flex Erg Employee And Career Development Subcommittee ChairJohn Deere Nov 2021 - Jun 2022Remote -
Project Support EngineerJohn Deere Electronic Solutions May 2017 - Sep 2020Fargo, 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. -
Program Management AnalystJohn Deere Dec 2013 - May 2017Fargo, 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. -
Customer Support RepresentativeJohn Deere Nov 2012 - Dec 2013Fargo, 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. -
Data Coordinator, Employed Through Volt Workfore SolutionsPhoenix International - A John Deere Company Jun 2012 - Nov 2012Fargo, 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 -
City (Financial) AuditorCity Of North River Apr 2015 - Mar 2018North 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
-
ClerkSunmart Jun 2010 - Jun 2012West 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
-
TutorNorth Dakota State University Oct 2009 - May 2010Fargo, North Dakota Area• Tutored college students in math and engineering mechanics courses.
-
Temporary DrafterLivgard Surveying May 2009 - Aug 2009Superior, Wi• Drafted registered land surveys with AutoCAD-based program (Carlson Survey)
-
Summer InternAmi Consulting Engineers.P.A. May 2008 - Aug 2008Duluth, Mn• Operated equipment at a research facility• Assisted engineers, including creating and reading drawings in AutoCAD
-
Office AssistantNatural Resources Engineering Company Jun 2007 - Dec 2007Superior, Wi• Created and implemented filing system, assisted office manager, GIS analysts, and engineers.• Learned ArcGIS, gathered pipeline environmental data, and mapped environmental safety data.
Andrea Rector (Johnson) Education Details
-
Magna Cum Laude -
Pre-Engineering
Frequently Asked Questions about Andrea Rector (Johnson)
What company does Andrea Rector (Johnson) work for?
Andrea Rector (Johnson) works for State Of North Dakota
What is Andrea Rector (Johnson)'s role at the current company?
Andrea Rector (Johnson)'s current role is Data Analyst.
What schools did Andrea Rector (Johnson) attend?
Andrea Rector (Johnson) attended North Dakota State University, The College Of St. Scholastica.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial