Kristopher Richardson
North Huntingdon,PA
Summary
Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills. Detail-focused Data Analyst capable of understanding customer requirements and translating them into ] actionable reporting solutions. Dedicated and hard-working with passion for Big Data. Looking for opportunities to continue to grow current skill set, as well as to develop new skills such as Python, Azure, Agile, SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS).
Overview
19
19
years of professional experience
Work History
Business Intelligence Analyst
Crown Castle
01.2021 - 09.2023
- Design and develop interactive Power BI reports and dashboards to meet needs of various business units
- Creating visually compelling and informative data visualizations for data analysis
- Extract, transform, and load (ETL) data from multiple sources into Power BI for analysis
- Define and implement data modeling techniques such as creating relationships, calculated columns, and measures
- Conduct in-depth data analysis to identify trends, anomalies, and actionable insights
- Collaborate with business stakeholders to understand data requirements and refine reporting solutions
- Optimize Power BI reports and dashboards for performance, ensuring quick load times and efficient data processing
- Monitor and tune queries to enhance report responsiveness
- Integrating Power BI with other tools and data sources, such as SQL Server, Excel, SharePoint, or cloud-based platforms
- Ensuring data integrity and accuracy throughout integration process
- Conduct training sessions for end-users to enable them to navigate and utilize Power BI reports effectively
- Provide ongoing support and troubleshooting for Power BI users
- Create comprehensive documentation for Power BI reports, data models, and data sources to facilitate knowledge sharing
- Maintain up-to-date documentation for report changes and enhancements
- Collaborate with data engineers, database administrators, and other stakeholders to ensure data availability and quality
- Work closely with business analysts to understand and refine reporting requirements.
Senior Financial Analyst
Crown Castle
08.2017 - 01.2021
- Early adopter of Power BI to present financial information
- Assisted Manager with yearly Budget Model
- Provided Service Gross Margin and Cash on Cash reporting to
- Area Directors
- Prepared monthly and quarterly financial reports for management
- Delivered ad hoc reporting as needed
- Analyzed financial data and explained variances in close collaboration with senior business and unit managers
- Prepared detailed financial reports and summaries for internal and external use
- Compiled accurate data with routine queries of financial information systems.
Senior Job Cost Accountant
Crown Castle
08.2016 - 08.2017
- Worked with assigned Areas on budget packets to ensure proper budget accounts were used and that all required documents were attached
- Analyze financial data and create reports to communicate cost variances and trends to management for decision-making purposes
- Enhanced accounting controls compliance by working well with both financial and operational staff
- Supported business decisions by preparing operational costing reports
- Prepare Monthly and Quarterly Journal Entries to true-up accounts or to post accruals
- Automated about 75% of journal entries and Month End Reports using WebFocus and Excel Macros/VBA
Staff Accountant
Crown Castle
05.2014 - 08.2016
- Responsible for billing customers in 3rd party billing portals for construction related activities
- Established and performed weekly/monthly audits of invoices against billing portals
- Work with Account Managers on any invoicing discrepancies
Accounts Receivable Staff Accountant
Intepros Consulting
07.2013 - 05.2014
- Worked as a contractor in the Accounts Receivable department at Crown Castle before getting hired on full time
- Apply cash received to their respective customer invoices
- Work with Customer Account Manager's to work through payment discrepancies
Staff Accountant
Online Stores
07.2010 - 07.2013
- Handled bank, balance sheet and fixed asset reconciliations
- Prepared journal entries in compliance with GAAP using proper documentation and approvals
- Completed monthly variance analysis on line-item spending to support sound budgeting practices
- Prepared journal entries and general ledger accounts before required deadlines
- Processed journal entries to complete monthly closing procedures
- Produced and distributed monthly, quarterly and annual financial reporting
- Run weekly vendor payments
Restaurant Manager
Pepperwood Grille | PA
11.2004 - 07.2010
- Inventory Management
- Payroll
- Accounts Payable (entering/paying invoices)
- Building Customer Relationships
- Hired and trained food service staff on policies and procedures of company
- Responded to guest concerns and complaints to achieve positive resolution
- Recruited, trained and mentored new staff to deliver top-quality customer service
- Reviewed staffing levels to meet operational needs and financial objectives
- Controlled costs with effective supply management and monitoring of food use
- Examined records to verify fast-selling items on menu.
Education
Bachelor of Science - Applied Mathematics
University of Pittsburgh
Greensburg, PA05.2006
Skills
- Power BI
- SQL
- DAX
- Data Visualization
- Snowflake
- Attention to Detail
- Adaptable
- Microsoft Excel
Timeline
Business Intelligence Analyst
Crown Castle
01.2021 - 09.2023
Senior Financial Analyst
Crown Castle
08.2017 - 01.2021
Senior Job Cost Accountant
Crown Castle
08.2016 - 08.2017
Staff Accountant
Crown Castle
05.2014 - 08.2016
Accounts Receivable Staff Accountant
Intepros Consulting
07.2013 - 05.2014
Staff Accountant
Online Stores
07.2010 - 07.2013
Restaurant Manager
Pepperwood Grille | PA
11.2004 - 07.2010
Bachelor of Science - Applied Mathematics
University of Pittsburgh
Similar Profiles
Kimberly BryjaKimberly Bryja
Permitting Specialist at Crown CastlePermitting Specialist at Crown Castle
JUSTIN DOBBSJUSTIN DOBBS
Contract Compliance Specialist at Crown CastleContract Compliance Specialist at Crown Castle
JASON CAMARENAJASON CAMARENA
Network Permitting Specialist at Crown CastleNetwork Permitting Specialist at Crown Castle
Allan GilongosAllan Gilongos
Lead Fiber Splicer / Construction Manager at Crown CastleLead Fiber Splicer / Construction Manager at Crown Castle
Zane R. MuoioZane R. Muoio
Digital Content Analyst | Part-Time at TELUS InternationalDigital Content Analyst | Part-Time at TELUS International