RAVEN SERNA
Gibsonia,PA
Summary
Detail-oriented and passionate Data Professional with 10+ years of experience in data quality, data management, and data analysis of various domains. Looking to leverage business acumen, data knowledge, and skills in a data governance position.
Overview
7
7
years of professional experience
1
1
Certification
Work History
PIM DATA STEWARD/MARKETING ANALYST II
PPG Architectural Coatings (via VertiSystem)
01.2024 - Current
- Reviewed AI generated (CoPilot) data quality issues for French translation for the Canadian Marketing catalog
- Maintained data and ensured data quality met expectations and prepared catalogs for New Product Launches.
- Streamlined data management processes for improved efficiency and accuracy.
- Supported establishment, adoption and application of data standards across systems and processes related to product master data.
- Enhanced data quality by implementing data governance policies and procedures.
- Maintained a master data repository, ensuring consistent access to accurate information throughout the organization.
- Monitored and managed data cleansing requirements and data conversion initiatives.
- Identified opportunities for process improvement, resulting in reduced manual effort and increased automation.
- Validated warehouse data structure and accuracy.
- Supported migration projects by cleansing and validating datasets prior to integration into new systems.
- Implemented data validation rules, significantly reducing the rate of errors in the database.
PIM DATA STEWARD/MARKETING ANALYST II
PPG Architectural Coatings (via VertiSystem)
01.2024 - Current
- Reviewed AI generated (CoPilot) data quality issues for French translation for the Canadian Marketing catalog
- Maintained data and ensured data quality met expectations and prepared catalogs for New Product Launches.
- Streamlined data management processes for improved efficiency and accuracy.
- Supported establishment, adoption and application of data standards across systems and processes related to product master data.
- Enhanced data quality by implementing data governance policies and procedures.
- Maintained a master data repository, ensuring consistent access to accurate information throughout the organization.
- Monitored and managed data cleansing requirements and data conversion initiatives.
- Identified opportunities for process improvement, resulting in reduced manual effort and increased automation.
PERFORMANCE ANALYST
Roadrunner Recycling
09.2021 - 03.2023
- Identify and document high severity self-identified financial data issues for escalation/awareness
- Prepare monthly time-series analysis presentations for CFO and finance team to address self-identified database issues and make recommendations
- Collaborate with the appropriate Subject Matter Experts to push Workflow along
- Maximized profitability and managed risk for over 2000 customer portfolios analyzing financial performance, identifying errors, sales trends, and areas for improvement to suggest business decisions which resulted in saving and gaining over $500,000 in margin
- Presented findings in Excel tables and Lucid charts to the finance and operations manager and suggested strategy for improvement to reach financial goals
- Used statistical analysis with financial data to Identify customer portfolios in the company-created CRM where the realized margin exceeded or fell short of expectations and presented the portfolios to upper management to recommend strategies for financial improvement on a case-by-case basis (i.e
- Renegotiating contracts, chasing overdue credits owed to us by suppliers, auditing transactions, etc.) Helped the sales team meet sales goals by issuing margin-correcting revenue adjustments
- Worked with suppliers to correct erroneous bills & ensure contract agreements are honored
- Designed company-tailored API (Annual Price Increase) calculation tool for dynamically priced rate-based services which offered continuous improvement in price auditing.
- Compiled research data and gave professional presentations highlighting finds and recommended optimizations.
- Evaluated program effectiveness using a variety of quantitative methods, leading to data-driven recommendations for optimization.
- Streamlined reporting processes for increased efficiency and improved decision-making capabilities.
- Informed strategic planning through the provision of timely, accurate, and actionable insights derived from performance data analyses.
- Implemented automated reporting systems, significantly reducing manual effort while ensuring data integrity and consistency across the organization.
SENIOR CATEGORY SPECIALIST
Topco Associates LLC
12.2017 - 01.2019
- Optimized inventory management by implementing just-in-time purchasing strategies, reducing stock holding costs without compromising on availability.
- Evaluated vendor performance using key performance indicators to ensure continuous improvement in service delivery.
- Developed and maintained detailed records of all procurement activities for accurate tracking and reporting purposes.
- Maintained up-to-date database of suppliers, vendors and contracts to support accurate recordkeeping.
- Managed database of vendor details and pricing information to maintain organization.
- Monitored pricing trends and negotiated pricing to optimize profitability.
- Input, analyzed and reported on data covering all aspects of procurement operations.
- Analyzed market trends and identified optimal sources of supply to maximize cost savings.
PRICING SPECIALIST
Topco Associates LLC (via HireExcellence)
07.2017 - 12.2017
- Carefully monitored market trends to ascertain best pricing for company's products.
- Contributed to the development of pricing policies and guidelines, ensuring consistency and compliance across all business units.
- Reviewed and approved invoices and payments, verifying accuracy of expenses.
- Developed and maintained database of cost information to use most up-to-date and relevant data in estimates.
- Spearheaded initiatives to improve data collection methods, enhancing the overall quality of information used for decision-making purposes.
- Reduced discrepancies in financial reporting by implementing strict quality control measures for pricing data.
- Adjusted prices via pre-set schedules, supply management department costs and other factors on regular basis.
SUPPLY CHAIN ANALYST
Topco Associates LLC (via HireExcellence)
05.2017 - 07.2017
- Assisted in packaging transition project.
- Streamlined procurement processes, enhancing supplier relationships and reducing lead times for critical materials.
- Led process improvement projects that resulted in increased efficiency, reduced waste, and lower operational costs across the supply chain network.
- Conducted data analysis to identify bottlenecks in supply chain and develop solutions to optimize operations.
- Streamlined office operations using automation, oversaw client communications, managed record tracking and data communication activities.
- Analyzed transportation costs to identify opportunities for optimization through carrier consolidation or route adjustments.
- Studied movement of goods to identify gaps in efficiency and other areas needing improvement.
Education
Bachelor of Arts - Economics
Northeastern Illinois University
Chicago, IL05.2017
Skills
- SQL (SQL Server, MySQL, PostgreSQL)
- AI (CoPilot, ChatGTP)
- IBM db2 cloud and Watson Studio
- Python (Pandas, NumPy, SciPy, MatPlotLib)
- ETL Tools (SAP)
- Informatica MDM
- Collibra
- Tableau
- Excel (VLookup, Conditional Formatting, Pivot Tables)
- Data Cleansing
- Query Tools
- ETL processes
Certification
- IBM DATA SCIENCE PROFESSSIONAL CERTIFICATION, 07/2023
- CollibraRanger Certification, 01/2024 - In Progress
Projects
DATA SCIENCE CHICAGO CENSUS ANALYSIS, Pittsburgh, PA, 07/2023, Invoked SQL queries using Python and pandas to analyze Chicago census, public school, and crime data to identify causes that impact the enrollment, safety, health, environment ratings of schools. Utilized the cloud from IBM db2 to load and aggregate data.
HISTORICAL STOCK MARKET EDA, Pittsburgh, PA, 07/2023, Created visualization and dashboard with Plotly to help compare between different Tesla, AMD, Amazon, and GameStop stocks and identify patterns and trends. Extracted stock data by web scraping and using y-finance API to obtain ticker.
Additional Information
I have the ability to work with various types or people and cultures from being well-traveling from a study abroad program and a variety of personal projects.
Languages
French
Native or Bilingual
Spanish
Limited Working
Timeline
PIM DATA STEWARD/MARKETING ANALYST II
PPG Architectural Coatings (via VertiSystem)
01.2024 - Current
PIM DATA STEWARD/MARKETING ANALYST II
PPG Architectural Coatings (via VertiSystem)
01.2024 - Current
PERFORMANCE ANALYST
Roadrunner Recycling
09.2021 - 03.2023
SENIOR CATEGORY SPECIALIST
Topco Associates LLC
12.2017 - 01.2019
PRICING SPECIALIST
Topco Associates LLC (via HireExcellence)
07.2017 - 12.2017
SUPPLY CHAIN ANALYST
Topco Associates LLC (via HireExcellence)
05.2017 - 07.2017
Bachelor of Arts - Economics
Northeastern Illinois University
- IBM DATA SCIENCE PROFESSSIONAL CERTIFICATION, 07/2023
- CollibraRanger Certification, 01/2024 - In Progress
Similar Profiles
Isaac M. Ortiz VelezIsaac M. Ortiz Velez
Sales Agent at PPG ARCHITECTURAL COATINGSSales Agent at PPG ARCHITECTURAL COATINGS
Ben MakerBen Maker
General Warehouse Associate at PPG Architectural CoatingsGeneral Warehouse Associate at PPG Architectural Coatings
Lee BerryLee Berry
Paint Processor at PPG Architectural CoatingsPaint Processor at PPG Architectural Coatings