Power Bi Data Entry

Greg O’Connor

*** ******* ***** *** ** Bensalem, PA 19020 267-***-**** *********@*****.***

Business Intelligence professional with 20+ years of experience transforming complex data into actionable insights across healthcare, finance, legal, and media sectors. Expert in SQL, Power BI, Crystal Reports, Access, and Excel-based analytics. Proven track record of driving operational efficiency, mentoring teams, and delivering executive-level dashboards. Adept at bridging technical and business needs to support strategic decision-making.

Core Competencies

Technical Tools Reporting & Analytics Business Impact

SQL Server, Oracle, SSRS, SSIS Crystal Reports, Power BI, Excel, Access KPI Dashboards, Process Automation

T-SQL, PL/SQL, DAX Data Visualization, ETL, Data Governance Stakeholder Engagement, ROI Analysis

SSRS/SSIS Packages Ad-Hoc & Production Reporting, Dashboard Design Team Leadership, Cross-Functional Alignment

Professional Experience

SQL Reporting Analyst

Cozen O’Connor (Contract) Philadelphia, PA

September 2024 – February 2025

- Developed and automated daily, weekly, and monthly SSRS reports; reduced manual distribution effort by 80%.

- Converted legacy Excel reports into interactive Power BI dashboards, improving user adoption and decision speed.

- Authored process documentation and trained stakeholders on new reporting workflows.

- Participated in Agile sprint planning to define requirements and prioritize reporting tasks.

Analyst, Incentive Compensation

Canon Solutions America (Temp) Burlington, NJ

March 2024 – July 2024

- Designed and maintained sales compensation databases in MS Access; created queries, macros, and user forms.

- Generated Oracle/SQL-driven Excel reports with advanced charts and formulas to support sales leadership.

- Built and enhanced Power BI dashboards for monthly incentive compensation tracking.

- Provided hands-on technical support to management and sales teams; documented new processes.

Senior Operational Technical Analyst

Cenlar FSB Ewing, NJ

July 2020 – October 2022

- Recommended and implemented data quality and efficiency improvements, yielding a 25% reduction in report cycle time.

- Led cross-unit projects using SQL, SSRS, SSIS, Access, and Visio to streamline data flows and reporting.

- Prepared executive-level technical reports by analyzing key trends and metrics.

- Mentored junior analysts on reporting best practices, ETL processes, and stakeholder communications.

Senior Data Analyst

Ally Bank (Contract) Fort Washington, PA

July 2019 – November 2019

- Authored Crystal Reports and Power BI dashboards to deliver key risk and performance indicators.

- Developed T-SQL stored procedures for automated data extraction in MS SQL Server and Oracle.

- Presented insights to C-level executives and multiple business units via PowerPoint and interactive dashboards.

Senior Analyst, Business Intelligence

UnitedHealthcare Philadelphia, PA

February 2018 – March 2019

- Built Crystal Reports and Oracle-based stored procedures for state-run healthcare plan analysis.

- Created sustainable Power BI dashboards with DAX formulas, improving KPI visibility for senior management.

- Documented data mappings across three systems, ensuring consistency for all reporting outputs.

SQL Data Analyst

Philadelphia Media Network Philadelphia, PA

April 2015 – February 2018

- Authored PL/SQL and T-SQL stored procedures for SSRS and Crystal Reports supporting circulation, sales, and finance.

- Developed SSIS packages to populate a SQL Server data warehouse and predictive distribution models for 8,000+ outlets.

- Managed report distribution, troubleshooting, and third-party software administration.

Earlier Experience (2014 – 2003)

• Crystal Reports/SQL Developer, InvestEdge, Inc. (2014–2015)

• Senior Systems Analyst (Lead), UST Global / Independence Blue Cross (2013–2014)

• Crystal Reports Developer, On Time Staffing (Contract) (2012–2013)

• Reporting Analyst, Freedom Mortgage (2011–2012)

• Media Reporting Analyst, TelAmerica Media (2010–2011)

• HRIS Analyst, Albert Einstein Healthcare Network (Temp) (2008–2009)

• Servicing Systems Analyst, PHH Mortgage (2006–2008)

• Business Analyst, Keystone Mercy Health Plan (Contract) (2005–2006)

• Programmer/Analyst, Clement Communications (Contract) (2004–2005)

• Operations Technician, GMAC Mortgage (Contract) (2003–2004)

Education & Certifications

Computer Learning Center, Philadelphia, PA

• Client Server Programming, August 1999

Professional Development

• Microsoft Certified: Data Analyst Associate (Power BI) – In Progress

Contact this candidate