- Outdoor Recreation
- Music
- Volunteer Work
- Interior Design
- Health Advocate
- DJ - Entrepreneurship
- Jazz - Live Music
Liana Lopez
New York,NY
Summary
Accomplished Senior Analyst with over 10 years of experience at National Grid, specializing in Global IT & Digital, Vendor Management, and Technology Business Management (TBM). Demonstrated expertise in contract management, data analysis, and vendor relations, with a proven ability to optimize data management systems and drive large-scale process improvements. Proficient in utilizing Power BI, SAP, and Apptio to enhance reporting capabilities, streamline data integration, and ensure financial transparency. Deep knowledge of TBM methodologies, cost allocation, and contract negotiations, providing actionable insights to senior leadership and facilitating cross-functional collaboration. A results-driven professional with a comprehensive understanding of cost models, KPIs, and improving operational efficiency to meet organizational objectives.
Overview
14
14
years of professional experience
Work History
Senior Data Analyst - Technology Business Mgmt
National Grid USA
03.2023 - Current
- Led the gathering of contract details from internal and external stakeholders to ensure comprehensive data integration into the TBM model, ensuring alignment with cost allocation rules to support accurate financial reporting.
- Extracted and integrated data from SAP systems into the TBM tool, ensuring seamless alignment with cost allocation models and delivering comprehensive insights into global IT expenditures, application costs, and resource utilization.
- Managed the mapping, loading, and integration of financial and application data into Apptio, ensuring cost transparency and alignment with organizational goals. Worked cross-functionally with business and finance teams to validate data and improve accuracy.
- Applied TBM cost allocation rules to accurately distribute costs across IT applications and services, enabling stakeholders to gain visibility into IT financials and ensuring alignment with IT financial management best practices.
- Collaborated with business leaders, finance teams, and IT stakeholders to ensure cost transparency, providing data-driven insights that facilitated informed decision-making on application portfolio management and technology investments.
- Led efforts to continuously monitor and improve the quality of financial data within TBM systems, ensuring consistency and reliability for reporting and decision-making.
- Supported ongoing maintenance and optimization of the Apptio TBM model, ensuring accurate capture and reflection of financial data across all business units, enhancing operational and financial efficiency.
- Utilized Power BI and SAP to extract and analyze key contractual data, including invoice-level details, to ensure accurate application tie-back to individual contracts. This process facilitated a comprehensive view of contract-related costs, enabling precise financial tracking and transparency across business units.
- Validated and ensured the accuracy of financial data by cross-referencing General Ledger (GL) entries with TBM cost allocation models, ensuring proper reflection of costs within each business unit's dashboard and alignment with organizational standards.
- Developed and maintained a comprehensive understanding of TBM rules, ensuring accurate data mapping and cost allocations for IT applications, fostering financial transparency and supporting accurate budgeting, forecasting, and financial decision-making.
Senior Analyst - Global IT & Digital - Vendor Management
National Grid USA
06.2014 - 03.2023
- Ariba Global Contracts Repository Implementation: Spearheaded the design, development, and implementation of the Ariba Global Contracts Repository, optimizing data management and reporting capabilities across the global enterprise.
- Reporting & Metrics Enhancement: Determined required fields in the tool to enhance reporting and metrics capabilities, ensuring comprehensive insights into global spends, vital contractual information, and KPI targets.
- Power BI Data Analysis: Leveraged Power BI to run reporting, identifying key financial metrics, global spends, and key performance indicators (KPIs) to inform executive decision-making and ensure financial goals were met.
- Data Accuracy & Efficiency: Led efforts to update missing data, significantly improving tool accuracy and efficiency, resulting in a more reliable repository for contract management and reporting.
- Data Integration & Global Coordination: Coordinated the integration of US and UK data into the system, ensuring a unified database that supported consistent reporting and contract tracking globally.
- Tool Testing & Rollout: Played a pivotal role in the finalization, testing, and rollout of the Ariba tool, ensuring data accuracy and functionality were thoroughly tested before implementation.
- Process Standardization & Documentation: Authored formal procedures for uploading, monitoring, and reporting on contracts within Ariba, streamlining processes and facilitating team adherence to standardized practices.
- Vendor Management & Relationship Building: Fostered and maintained strong relationships with vendors, resolving issues promptly and negotiating favorable terms and cost savings for contracts ranging from single-user licenses to multi-million-dollar agreements.
- Contract Negotiations & Cost Savings: Led successful negotiations of contractual costs, securing significant savings on a variety of contracts and optimizing terms to benefit the organization.
- KPI Monitoring & Contract Renewals: Monitored and measured performance against KPIs for contract renewals, ensuring alignment with organizational goals and driving efficiency in the renewal process.
- SAP Procurement Support: Created shopping cart requests within the SAP system, streamlining procurement processes and reducing administrative overhead.
- Software License Knowledge Base: Developed a comprehensive Software License Knowledge Base, improving the identification and management of license and RTB costs, and ensuring accurate license tracking.
- Commercial Team Support: Designed formal procedures to help the Commercial Team identify license and RTB costs for new requests, ensuring seamless operations and collaboration across departments.
- ServiceNow & Workflow Efficiency: Assisted in resolving the ServiceNow Ticket backlog, contributing to enhanced team efficiency and quicker resolution times, while ensuring that team SLAs were consistently met.
- Cross-Functional Collaboration: Collaborated with Micro Focus Group to improve customer care effectiveness and customer relationship management, optimizing cross-functional workflows and enhancing service delivery.
IT Consultant Training
FDM Group
10.2013 - 02.2014
- Company Overview: The FDM Group offers recent graduates an opportunity to enhance their technical skills by going through an intensive three month training
- The stream I chose was Project Management/APP support where I gained a strong background in areas that span from UNIX shell scripting to Business Analysis
- The FDM Group offers recent graduates an opportunity to enhance their technical skills by going through an intensive three month training
VP of Marketing
Sigma Lambda Gamma National Sorority Inc.
04.2012 - 03.2013
- Designed all promotional signs for upcoming events
- Advertising events through social media/ Social Networks and Direct Marketing
- Maintaining and updating all information on website
Tech Instructor
iD Tech Camps - Columbia University
06.2011 - 08.2012
- Monitored children from ages 8-15 on a daily bases
- Instructor teaching programming
- Taught children 2D game design using Multimedia Fusion Developer 2
- Provided a safe and educational environment for all campers
Education
Bachelor of Science - Information Technology
Pennsylvania State University
University Park, PA05-2013
Skills
- Apptio: Data integration, cost transparency, modeling
- Power BI: Data analysis, report generation, dashboards
- SAP: Data extraction, financial reporting, integration
- Cost Allocation: TBM cost models, transparency
- Data Mapping: Apptio integration, data validation
- Financial Reporting: IT budgeting, cost tracking
- TBM: Apptio, ServiceNow, financial modeling
- Financial Management: Budgeting, cost allocation, expenses
- Regulatory Knowledge: Compliance, capital markets expertise
- Contract Management: Negotiation, vendor relationships, procurement
- Procurement & Licensing: Software license, RTB cost tracking
- Process Optimization: Workflow efficiency, procedure standardization
- Collaboration: Stakeholder management, cross-functional coordination
- CRM Systems: Customer management, service processes
- Tools & Technologies: Ariba, SAP, ServiceNow, Power BI, Apptio
Interests
Timeline
Senior Data Analyst - Technology Business Mgmt
National Grid USA
03.2023 - Current
Senior Analyst - Global IT & Digital - Vendor Management
National Grid USA
06.2014 - 03.2023
IT Consultant Training
FDM Group
10.2013 - 02.2014
VP of Marketing
Sigma Lambda Gamma National Sorority Inc.
04.2012 - 03.2013
Tech Instructor
iD Tech Camps - Columbia University
06.2011 - 08.2012
Bachelor of Science - Information Technology
Pennsylvania State University
Similar Profiles
Todd TitchenTodd Titchen
Substation Operations and Maintenance at National Grid USASubstation Operations and Maintenance at National Grid USA
Jon HillJon Hill
Senior Relay Technician at National Grid Usa Service CompanySenior Relay Technician at National Grid Usa Service Company
Conor ByrneConor Byrne
DER Specialist at National Grid Usa Service CompanyDER Specialist at National Grid Usa Service Company
Babu InturiBabu Inturi
Lead DataOps | DevOps Engineer at National Grid USALead DataOps | DevOps Engineer at National Grid USA
Natali SharipashviliNatali Sharipashvili
Server / Food Expeditor at Rhubarb Hospitality Collection (RHC)Server / Food Expeditor at Rhubarb Hospitality Collection (RHC)