Esther Frick Email & Phone Number

Tacoma, WA, US

• Manages the day-to-day operations of the Master Data Management team
• Mentors junior team members and works with each person to identify strengths and weaknesses to distribute existing work for optimal resolution as well as provide guidance and training in areas identified for improvement.
• Works alongside team and with SMEs to solicit input and get resolution to questions
• Maintain and promote a professional leadership relationship with all departments within the company’s organization to achieve optimal performance, compliance, and problem resolution
• Coordinate urgent requests, acting as an escalation point within the technology team for issues when necessary
• Leads Data Analysis activities and directs team members performing the activities

Tacoma, WA, US

• Utilize Informatica MDM (Master Data Management) toolset, Salesforce tools, AWS, SQL, to perform data quality methodologies, while supporting the MDM Center of Excellence.
• Contribute to the creation and maintenance MDM processes and procedures.
• Work with Customer Data Steward and SMEs to solicit input and get resolution to questions.
• Analyze the requirements of master data and the relationship with Information Technology (IT) systems, Quality requirements, and broader business processes.
• Monitor and facilitate the workflow processes for new data requests, changes, and deletions.
• Identify, analyze, report, and resolve data issues related to uniqueness, integrity, accuracy, consistency, and completeness.

Redmond, Washington, US

• Senior Data Analyst, Microsoft Surface Distribution Sales teamWorking closely with the Microsoft Surface Distribution Sales team (sales, marketing, product distribution and supply chain) to develop, transform and.
• As a consultant in this role, I played a part that is critical to the success of the Microsoft Surface Sales Distribution organization, by delivering routine or ad hoc reports, tools, and analyses to leaders across the.
• I collaborated with business users, PDMs, and Supply Chain teams and departments such as OCP Surface Finance and Marketing to bridge the gap in terms of data needs and business term/logic understanding.
• Provided Partner and Channel sales performance scorecards and distributor inventory analysis and visibility reporting to Surface OCP leadership.
• I partnered closely with team leaders and PDMs on the development, validation, deployment and on-going operations of new reports and toolsets that provide vital key performance indicators on measuring the impact of.
• Created and maintained operational processes of existing and new reports, using Microsoft Excel, Power Pivot, Power BI, and MS technologies.

• As a consultant in this role, I supported the Business Operations & Strategy team in a large data storage optimization project by performing data modeling, using Excel power query development tools.
• Developed complex Excel analysis integrated workbooks, data modeling integration, and project tracking
• Researched alternative tools and methods for business and cost analysis for large data storage practices (AWS and AZURE, mainly).
• The impact of the project will save the WK company potentially millions per year on data storage expenses by eliminating waste and optimizing the size and service tiers used.

Tacoma, WA, US

• Drove analytics and data-driven insights for the PeopleReady organization, empowering data-driven decision making for all levels of management from branch managers up to the C-suite through role specific dashboards.
• Established KPIs for nation-wide PeopleReady operational metrics, provided perspective and establish reporting on key performance indicators such as: supply vs. demand ratios, active customer month over month and YOY.
• Performance metric reporting projects resulted in operational cost reduction, increased order fill rates and associate engagement, and longer worker and customer tenure
• Designed and implemented high-quality business intelligence visualizations that summarize and streamline complex data into useful information, enabling data-driven management decisions to be made.
• Designed and developed metrics standards to measure operational processes and service, operational excellence that provided meaningful insights from field data to drive best practices across branches and service lines.
• Special Projects: Took on ad-hoc projects with minimal supervision. Such projects included data engineering, financial data modeling, providing statistical data analysis support around legal or compliance requests.

Seattle, WA, US

• Acted as a liaison between the end users and developers; Assessed and prioritized program needs based on business requirements, developed business case for new initiatives and obtain project approvals
• Developed and documented business processes and requirements for project engineers, technical project managers, and construction managers.
• Innovated within the procurement and purchasing reporting space creating SQL data tables and reports, budget planning tools, automating or improving processes that supported vendor procurement and that recognized and.
• Coordinated and supervised UAT by automation trainers, design team members, testers and piloto Defined existing processes and the new processes – mapping process flowso Provided training materials defining process for.
• Developed and managed the financial metrics and cost/budgeting analysis for project engineers, technical project managers, and construction managers in MySQL databases and Tableau reporting tools.
• Created Budget-to-Actual cost tracking reports, dashboards, data visualizations and documentation that enabled business partners to understand and manage their vendor/supplier procurement and manage data center.

Seattle, WA, US

• Drove cross-business analytic projects for management, with business modeling, data mining and presentation support.
• Delivered actionable, accurate, and timely financial and business metrics, using tools such as Oracle SQL, Excel VBA and macros, Pivot Charts, Access database custom forms and reports (GUI), and Oracle BI-Tools.
• Developed and published visual management aids based on underlying data, distribution via Twiki page publishing tools.
• Designed and coordinated the development of systems and tools to keep pace with the group's growing and rapidly evolving businesses. o Projects included design of an Access database for SharePoint –a GUI /data entry.

Lake Success, New York, US

• Assisted a team of class action settlement attorneys, directors and litigation project managers on all phases of Quality Control for electronic records process and legal claims data analysis.
• Pulled electronic data records from Excel, SQL, and various sources to provide supporting documentation to project managers and counsel for litigation case support.
• Analyzed and reviewed the loading and de-duping of client supplied class data lists in Excel, SQL databases and various source files.
• Verified weekly statistical reporting to clients and the verification of statistics in GCG court filings including declaration and affidavits in the administration of settlements.
• Reviewed design specifications of claim processing screens for the accurate collection of information based on client requested data.
• Reviewed and validated class action settlement distribution calculations and settlement entitlement (claims payout) activities in SQL databases.

Denver, CO, US

• Designed, coordinated and tracked financial/systems reporting projects, partnering with Revenue Operations and other departments, to provide complex and ad-hoc reporting solutions by data mining with SQL queries and.
• Developed and documented business processes and requirements for revenue managers, translating them into management report design documents that adhere to SOX requirements (Sarbanes-Oxley) and HIPPA laws
• Acted as a liaison between the business partners and revenue analytics developers
• Provided accurate, timely reporting, data integrity, and data analysis to internal cross-departmental customers. Maintained, supported and troubleshoot legacy-built tools, such as Access and Oracle Databases, Excel.
• Educated partners with report functions, usability testing; o Provided analyst – developer testing and end-user-testingo Provided report documentation and end-user education

Kent, WA, US

• In my last year with this company, I focused on the systems development side of Door To Door. I was an IT /Business Systems Support Analyst (from October, 2005 through November, 2006).
• Developed and documented business processes and requirements for Sales, Operations and Finance business partners, translating them into systems change requests, management report design documents and work flow diagrams
• Acted as a liaison between the sales, operations and finance business partners and IT developers
• Documented business process workflows, advised department leaders on software issues, business processes and reporting. Researched, problem-solved databases and software program errors, network communication issues.
• Worked with business partners to implement a large scale systems rollout to Sales and Operations teams
• Coordinated and supervised UAT by automation trainers, design team members, testers and piloto Defined existing processes and the new processes – mapping process flows o Provided training materials defining process for.

Kent, WA, US

• Managed the dispatch operations department in a national call-center environment –for household goods moving/shipping division. Supervisor of all operational functions of this division, including dispatchers, customer.
• Developed and documented business processes and requirements for Sales, Operations and Finance business partners, translating them into sales and operations management documents, procedures and work flow diagrams
• Worked with business partners to add functionality to existing legacy systems for Sales and Operations teams
• Coordinated and supervised UAT by sales trainers, IT members, and customer service staffo Defined existing processes and the new processes – mapping process flows o Provided training materials defining process for.
• Negotiated vendor relationships and contracts: Developed and maintained strong freight carrier service provider relationships (regional and national) with negotiation of contracts for transportation /shipping services
• Oversaw Purchasing and A/P functions for the moving/shipping division, including establishing procedures, training staff, researching and problem-solving shipment billing errors.

• Coordinated business Enterprise Resource Planning (ERP) software implementations for an IT technology consulting company. Managed scheduling of hardware and software installations on clients' systems. Updated project.
• Streamlined the post-sales process – handoff to project teams; developed implementation processes and developed the automation of project forms, statements of work (SOW), and work orders.
• Coordinated corporate training events for Microsoft Great Plains Accounting software classes. Managed software inventory and client software licenses, coordinating items needed for installations.
• Skills acquired: Used Crystal Reports software, MS Project 2000/2002 to manage project timelines, resources; created workload pipeline reports; resource usage and task-tracking reports. CRM software

Master Of Business Administration - Mba (In Progress), Business, Information Technology

Bachelor’S Degree, Business, It Management

Education record