Amy Lehman

Experience

• 

  California Resources Corporation

  Nov 2008 - Jul 2016

  Provided comprehensive data and support to engineering and operations teams, leveraging SQL, Spotfire, Access, and Excel to extract, manipulate, query, and analyze production data. Responsibilities included identifying variations, deviations, outliers, and opportunities within datasets, performing cost analysis and ROI forecasting, and presenting up-to-date progress through visual aids such as charts, graphs, and analytical software. Designed Excel spreadsheets and Access databases to analyze data and meet KPIs, utilizing tools like Make Table Queries, Pivot Tables, and various conditional formatting techniques. Additionally, co-led the data migration of historical well lists to establish and enhance a new "Refer to Engineering" process, utilizing SQL to automate scripts that updated large data sets overnight and generated new tables in Access. As leader of a team of 15 Data Analysts, integrated the Community of Practice to standardize processes and address inefficiencies. Initiated the creation of a SharePoint site to streamline documentation, guidelines, SME contact information, knowledge sharing, and quick reference tools. Show less Supported reservoir and production engineers through the use of ValNav/PEEP, Lowis, XSPOC, and Access, managing and preparing AFEs for regulatory reporting, constructing wellbore diagrams/schematics, and estimating project costs. Developed and maintained project databases and created presentation materials using Spotfire, PowerPoint, and Excel. As project lead, oversaw a team performing data migration and quality assurance, ensuring successful project completion and meeting all deadlines. Additionally, supplied documentation concerning legalities and job proposals for permitting and regulatory processes. Show less Utilized Maximo software to efficiently plan and oversee daily maintenance operations for surface facilities and equipment. Responsibilities included creating EDIs and exporting data to generate detailed reports. Handled dispatch calls, verified invoices, managed parts and material orders, ran Backlog reports, and generated work orders to streamline maintenance workflows. Actively participated in the development and tracking of maintenance projects, ensuring adherence to timelines and budgets. Additionally, validated monthly reports to ensure cost actuals aligned with bid proposals, exercising keen analytical skills to evaluate and determine appropriate actions based on thorough analysis and interpretation of extensive data sets. Show less Meticulously recorded daily rig operation reports and associated costs using Open Wells, ensuring accurate and timely data entry. Proficiently imported data into the system and generated comprehensive reports encompassing various aspects such as Conventional Rod, Wellbore Equipment, and Production Equipment Failure. Attention to detail and organizational skills enabled maintenance of precise records and delivery of insightful reports that supported operational decision-making and efficiency improvements. Show less

  • Data Analyst - Operations

    Jul 2013 - Jul 2016

  • Reporting Analyst

    Jul 2011 - Jun 2013

  • Project Analyst

    Mar 2010 - Jul 2011

  • Data Entry Specialist

    Nov 2008 - Mar 2010
• 

  Global Knowledge

  Dec 2016 - Aug 2019

  Developed and executed analytics for senior management and board, enhancing global performance and meeting objectives. • Led the initiative to transition all manually created Excel reports into an automated visualization suite utilizingPowerBI.• Produced actionable reports and dashboards to drive improvements and communicated KPIs effectively across departments.• Led analytic projects, overseeing data workflows and supervising migration efforts. • Managed a team of analysts specializing in data mining and reporting.• Presented critical insights to management and the board to inform decision-making and support strategic planning initiatives. Show less Managed product development and overall capacity by closely monitoring KPI’s to ensure alignment with plan objectives.• Thoroughly analyzed gaps between the company's current and desired future states, identifying opportunities for improvement, anomalies, and successes in collaboration with stakeholders. • Analyzed, tracked, and reported on changes aimed at enhancing operational efficiency and mitigating risks. • Prioritized the investment pipeline through detailed reporting, overseeing budget allocations and timelines to facilitate informed executive evaluations and decision-making. • A proactive approach and analytical rigor contributed to achieving strategic goals and maintaining organizational alignment with overarching objectives. Show less

  • Portfolio Lifecycle Analytics Manager

    Nov 2018 - Aug 2019

  • Product Development Portfolio Analyst

    Dec 2016 - Nov 2018
• 

  Lincoln Financial Group

  Sept 2019 - Aug 2024

  Offered specialized expertise and thought leadership to strategically achieve key data management business objectives and advance data analytics practices. Responsible for the Business Reporting, Business Intelligence and Data Governance Teams.•Led the development of data solutions for internal stakeholders and implementing measurement protocols to assess performance and drive future initiatives through dashboards and reports. •Established an enterprise-wide data governance framework, data access policies, standards, and scalable practices. •Provided senior management and stakeholders with specialized guidance on data management strategies in response to new or emerging trends by evaluating software and tools for enterprise implementation. •Developed a portfolio of automated dashboards and reports, facilitating the retirement of outdated reports and successfully transitioning from an antiquated system to new, emerging software solutions•Implemented QA/QC process that reduced errors found in dashboards by 25%. Show less Led a diverse team of full-time employees and consultants, both onshore and offshore, through strategic leadership to achieve critical business objectives in business reporting and business intelligence. • Implemented streamlined processes across teams using Dataiku for code sharing and template creation in Tableau which resulted in effort reduction and improved user experience.• Established and maintained cutting-edge analytic capabilities within the Life Solutions and Annuity sectors, employing a Center of Excellence (COE) organizational model by utilizing a formalized intake process and project management approach.• Delivered substantial business value and actionable insights to cross-functional executive and senior leadership teams through the analysis and implementation of new/updated software.• Successfully lead the transition of antiquated reports into refined and automated dashboards that reduced manual efforts by 50%.• Led predictive analytics project in partnership with Deloitte and our internal Data Science Team to forecast the impacts of claims based on medical markers. Show less Provided leadership, direction, and functional expertise to ensure departmental results for the business intelligence space. • Directed and provided expertise on the strategic design, development, and delivery of advanced analytics on complex projects/initiatives, resulting in a streamlined and reliable process.• Led the business intelligence team to mature the portfolio through the use of project management tools, cross team collaboration, automated portfolio tracking and peer review processes.• Supervised consultants across multiple locations, including onshore and offshore teams, ensuring alignment with project goals and objectives within Retail Solutions. Show less Led the establishment of a BI team comprising full-time employees, onshore and offshore consultants, and orchestrated the implementation of a scalable process to enhance business operations. • Provided strategic leadership to drive the design and implementation of comprehensive business metrics, analytics, and reporting aligned with organizational goals and objectives. • Directed the team in collaboration with stakeholders to transform data into actionable insights, advancing growth, profitability initiatives, and delivering impactful business outcomes through Tableau, MicroStrategy and Dataiku.• Championed and cultivated a data-driven culture initiative within the organization by hosting a hackathon to showcase the tools and capabilities available to the enterprise. Show less Led innovation in business analytics, visualization/dashboarding, and data storytelling. • Collaborated closely with business partners to gather requirements, develop dashboards, and perform analysis to derive actionable insights that enhanced business decisions. • Guided user growth in self-service environments and purpose-driven dashboard design to ensure effective utilization and adoption across the organization.• Created the “white glove approach” by consistently refining our workflow to make it the premiere service for stakeholders to manifest their ideas through visualization. Show less

  • VP, Data Analytics & Governance

    Nov 2023 - Aug 2024

  • VP, Business Analytics

    Aug 2023 - Nov 2023

  • Assistant Vice President, Business Intelligence

    Nov 2021 - Aug 2023

  • Director, Business Intelligence

    May 2021 - Nov 2021

  • Sr. BI Analyst

    Sept 2019 - May 2021