Kimberly Ann K. Alberts

About Kimberly Ann K. Alberts

I am constantly improving myself and look forward to see what else 2025 brings!…

Experience

1. Business Analytics Consultant, Senior - Portfolio Analytics Investment Data Innovations

   PNC

   Nov 2021 — Present

   Delivering client-centric investment data solutions that help our clients achieve their financial goals by providing market-leading investment data management standards and well-crafted solutions to enable best in class client service and reporting. • Business Analyst (BA) within PNC’s Investment Office tasked with collecting business requirements for high impact strategic priorities • Present business priorities and requirements to it technology partners and Agile crews assigned to build the technical solutions • Participate in regular Agile ceremonies to answer questions and guide the Data Analysts and Developers through the story details • Delivered an automated client account tax analysis solution to the UMA Management team reducing process time from 3 days to 1 hour • Optimized the Investment Office’s DEI data aggregation and distribution process for internal and client facing reporting • Maintained the Investment Office’s ESG data product, including vendor relationship management with Sustainalytics • Built process standardizing the ingestion of 50+ vendor and internal files that contributed to fixed income monthly/quarterly reporting • Continually supported team members with technology connection issues and advised on Python coding best practices • Maintained internal Equity and Fixed Income UMA Model Exposure tools powered by VBA and python • Used SQL queries to mine databases and create tables. Also used SQL queries for quality control • Regular interactions with Hadoop, Oracle, SQL, ETL, Pyspark and Oozie workflow resources for data mining and solution design • Used Python and VBA scripts to transmit financial data between platforms

Education

• Self Study

  Various

• Georgia Institute of Technology

  BS, Mechanical Engineering

  2001 — 2005

• Penn State University

  DEng, AI Engineering w/ Financial Focus

  2024 — 2028

• Georgia Institute of Technology

  Master of Science - MS, Analytics (Engineering)

  2020 — 2023

• Duquesne University

  MBA, Sustainability

  2011 — 2012

Skills

• Alphacam
• Agile & Waterfall Methodologies
• Operations Improvement
• Product Development
• Strategic Planning
• Renewable Energy
• Public Speaking
• Dmaic
• Engineering
• Energy Audits
• Innovation
• Leed
• Environmental Awareness
• Business Process Improvement
• Analysis
• Leed Projects
• Microsoft Excel
• Process Engineering
• Vba
• Sustainable Product Development
• Continuous Improvement
• Sustainability
• Process Improvement
• Sustainability Consulting
• Sustainability Metrics
• Design for Manufacturing
• Kaizen
• Data Analysis
• Product Design
• Energy Star
• Idea Generation
• Life Cycle Assessment
• Sustainable Design
• Autodesk
• Energy Efficiency
• Word
• Solidworks
• Lean Manufacturing
• Mechanical Engineering
• Sustainable Development