Business Intelligence Data Governance

CELIA KALCHTHALER

Streetsboro, Ohio 440-***-**** *****.*****@*****.***

DATA AND BUSINESS INTELLIGENCE PROFESSIONAL

Extensive experience in data analytics, reporting, and data strategy, primarily within private equity environments. Expertise in unifying analytics environments, managing BI teams, and leading projects to enhance data integration and reporting. Proven success in system migrations, report automation, and operational efficiency. Proficient in data warehouse management, data governance, and delivering strategic insights for executive decision-making. AREAS OF EXPERTISE

Data Analysis Business Intelligence Data Visualization SQL Programming Dashboard Development Data Warehousing ETL Processes Predictive Analytics Data Governance Reporting Automation PROFESSIONAL EXPERIENCE

PARTSSOURCE, Aurora, OH September 2008 - June 2024 Lead Data Analyst, July 2023 - June 2024 (Remote)

Collaborated with BI, Data Engineering, and Product teams on data management best practices. Provided guidance on optimizing the data repository, data availability, and high-level planning. Mentored new hires, managed contractor workloads, and coordinated two offshore consultants. Addressed ad hoc requests for tailored data solutions.

• Data Transformation Project Leadership: Co-led a data transformation project with a consulting firm to create an enterprise data warehouse, consolidating the technology stack, implementing MDM tool Symarchy, establishing a Data Governance Committee, and redefining roles and responsibilities.

• SAS Environment Migration: Managed the migration of the SAS environment to a new server, ensuring minimal disruption from planning through user testing.

• Usage Analytics Reporting: Developed reports, dashboards, and other outputs to monitor and manage data product usage. Helped reduce data debt by 20% and identified duplications, leading to automation that eliminated 10 hours of analysis work per week.

Manager, Reporting & Business Intelligence, January 2020 - July 2023 (Remote) Managed daily workloads, coached analysts, and ensured the operation of Power BI, Sisense, and SAS. Monitored ELT processes and managed data loads into DB2.

• Consolidated Analytics Teams: Unified data analysts, BI analysts, and data engineers into a centralized group through two acquisitions.

• BI Platform Support & Ticketing System Implementation: Led the implementation of Fresh service for centralizing data requests, developing workflows and SLAs, and improving collaboration.

• Customer Reporting & Visual Analytics: Created a reporting package with visual analytics, resulting in 6 external and 12 internal dashboards.

• Led Pricing Strategy and Execution: Directed a pricing team in developing and maintaining pricing algorithms that optimized price points for new and existing items across a million-plus product catalog. Oversaw variable pricing strategies, ensuring market competitiveness and alignment with business goals. Conducted regular reviews and updates to pricing structures to maximize profitability and streamline pricing operations. Sr. Business Intelligence Reporting Analyst, January 2015 - January 2020 Collaborated with stakeholders to gather requirements, establish data governance frameworks, and create data dictionaries. Administered BI tools like SAS Web Studio and Sisense, provided customer data analysis, and trained junior analysts.

• Data Warehouse Leadership: Led the design and management of the DB2 Data Warehouse, integrating multiple databases.

• Customer Data Analysis: Improved client engagement by standardizing data import templates and enhancing data accuracy.

• Customer Attractiveness Index: Developed a SAS algorithm to identify high-opportunity markets.

• Visualization Platform Implementation: Implemented Sisense, supporting 100+ dashboards and enhancing decision-making.

Celia Kalchthaler *****.****@*****.*** Page 2

Business Intelligence Reporting Analyst, March 2014 - January 2015 Migrated commercial budget dashboards from Excel to SAS, centralized reporting, and automated processes.

● Provided support to junior analysts, managed BI platforms, and contributed to DB2 development.

● Led sales support initiatives including market basket analyses and training. Business Development – Analytics, September 2013 - March 2014 Supported business development by expanding reporting capabilities, gathering requirements, and creating internal and external reports.

● Collaborated with BI to develop SAS Information Maps. Operations Business Support – Analytics, January 2012 - September 2013 Developed a DB2 Data Warehouse for transactional data, standardized data points.

● Created data dictionaries, and managed reporting on supply chain and operational metrics. Executive Administrative Assistant, March 2009 - January 2012 Developed sales reports, ensured data accuracy in collaboration with IT, Finance, and Sales teams, and drafted financial reports for executives and board members.

Purchasing Administrator, September 2008 - March 2009 Managed SRM user hierarchy, collaborated on system updates, and led efficiency projects.

● Addressed supplier queries and ensured timely order fulfillment. TECHNICAL SKILLS

• Programming Languages & Tools: SQL, SAS Base, SAS SQL, DAX, R.

• Business Intelligence & Reporting: Sisense, Power BI, SAS.

• Data Management & Integration: Talend, DB2 (toad), SSMS SQL Server.

• Microsoft Office Suite: Excel, Word, PowerPoint, Access, SharePoint, Teams, Project, Visio. EDUCATION & PROFESSIONAL DEVELOPMENT

• Relevant Coursework & Certifications: SAS Programming Classes, Sisense Learning Academy Certificate of Completion.

• Conferences & Workshops: Attended industry conferences and workshops focused on data analytics, BI tools, and advanced analytics.

• On-the-Job Learning: Advanced through various roles in data analytics and BI, gaining hands-on experience and expertise.

Contact this candidate