We provide IT Staff Augmentation Services!

Business Analyst Resume

Chicago, IL

SUMMARY

  • Seeking new roles (contract) as business or data analyst, preferably with Microsoft Data Platform & Power BI .
  • Past experience in financial, tech, health, professional services, & CPG sectors.
  • 7+ yrs., business intelligence implementation consulting, 3+ of financial reporting/analysis experience.
  • Microsoft Certified Professional - SQL Server 2016 Implementing Data Warehouses
  • Certified as Qlik Sense Data Architect
  • Microsoft MOS Office 2013 Master (Access + Word + Excel Expert-Level)
  • Analyzing Data with Power BI - Confidential / Microsoft

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Business Analyst & Software Trainer

Responsibilities:

  • have gone "back to school" and have focused mostly full-time on learning latest tools and software for business intelligence. Have studied and completed multiple online classes for Tableau, QlikView/Qlik Sense, SQL Server, & Power BI have taught part-time at St. Augustine College, at several Chicago, IL locations. Have conducted over 150 hrs. of classes to date (Accounting & QuickBooks).
  • In recent months, have studied to update skills (e.g. MOS Excel 2013 Expert, Qlik, & SQL Server, SSMS/SSIS/SSRS/SSAS), and now focusing on search for Power BI or DAX -related opportunities. as private investor in downtown Chicago, currently own & manage some rental luxury apartments, all in the same high-rise building. However, during previous travel while consulting, had difficulty doing upgrade work (plumbing & electrical required permits, etc.) So, after extensive planning & re-design, during this period, was finally able to use this time to complete two gut renovations and most of a third on primary residence condo unit. These major upgrades effectively doubled the market value of the units, both for rent and current equity.

Confidential, Chicago, IL

Sr. Associate

Responsibilities:

  • Completed a full-cycle implementation using SAP BusinessObjects Planning & Consolidation ("SAP BPC").
  • Performed a wide variety of assignments from data export/import, filtering & formatting, dimension configuration.
  • Customized Excel-based dashboards & reports, pivot tables, formulas, error troubleshooting.
  • Scripting/coding (SQL Server/MDX) & implementation testing.
  • Conducted in-person training and user acceptance testing (UAT), on completed applications.

Confidential, Chicago, IL

Managing Consultant

Responsibilities:

  • Completed several full-cycle implementations using SAP BPC on both SAP Netweaver and MS SQL Server platforms.
  • Assignments included client-facing design sessions, preparing & reviewing design documents and Statements of Work.
  • ETL configuration for data export/import, SQL Server (T-SQL) & MDX scripting, dimension configuration.
  • Customized Excel-based dashboards & reports, sync'ing between SAP BI/BEx and SQL Server Report Services (SSRS).
  • Custom formulas, error troubleshooting, implementation and user acceptance testing.
  • Conducted in-person training and user acceptance testing (UAT), on completed applications.
  • Configured inter-company eliminations application (SQL/MDX), for large, NYSE-traded corporation using BPC 7.5 Netweaver.

Confidential Chicago, IL

Lead Consultant

Responsibilities:

  • Led two (2) implementations through Phase me roll-outs & data validation with BPC 7 MS product (one in Ft. Collins, CO, the other in W. Palm Beach, FL).
  • Participated in design sessions and prepared design documents. Configured dimensions and applications.
  • Worked with IT to configure and validate servers for install & setup of initial cubes and applications.
  • ETL with SQL Server SSIS/SSRS packages, prepared reports, input schedules.
  • Conducted training sessions for users on budgeting, forecasting & security processes.

Confidential, Northbrook, IL

Senior Consultant

Responsibilities:

  • Completed several full-cycle implementations using SAP BPC on both SAP Netweaver and MS SQL Server platforms.
  • Assignments included data export/import, filtering & formatting, dimension configuration, customized Excel-based dashboards & reports, pivot tables, formulas, ETL error troubleshooting, BPC script logic (SQL/MDX), implementation and testing, as well as having conducted in-person training on completed applications.
  • Also have significant experience in installation of SAP BPC including: Configuring SQL Server 2000/2005, RAM and hardware, backups and restores, security w/ Active Directory, migrations and upgrades.
  • Lead analyst in developing and implementing a SQL query process using Hyperion Intelligence Analyzer (formerly Brio Query), to store, and analyze large amounts of data corresponding to billing control signals for MCl's wholesale customers (100's of millions of records). Summarized resultant billing data using MS-Access and MS-Excel to assemble, clean, correct and submit it for an estimated new collection of approx. $5 million per annum. These records were not previously being captured.

Hire Now