We provide IT Staff Augmentation Services!

Lead Reporting Analyst Resume

PROFESSIONAL EXPERIENCE

Confidential

Lead Reporting Analyst

Responsibilities:

  • Developed and modified VBA code in Microsoft Excel in order to improve efficiency for Finance users
  • Created Excel VBA code from scratch by inserting folder pickers, consolidating worksheets from those selected folders and dynamically creating more worksheets based on the consolidated master sheet
  • Utilized collections in Excel VBA to identify unique keys based on the concatenation and delimiters of wide ranges of specified columns within huge datasets to filter using count and sum while creating a new summary worksheet
  • Created Excel VBA code from scratch using if statements, for each loops, for next loops, find next loops and using Save As file saving methods based on specific user passwords
  • Created relationships through data models in PowerPivot while enhancing dashboards and creating reports in Power BI
  • Used DAX functions CALCULATE, RELATED, FILTER, ALL in Power BI to view filters requested by Finance users
  • Used CONTAINS DAX function in PowerPivot to create calculated columns and remove specific rows unnecessary for requested reports
  • Experience with using SQL statements such as SELECT, INSERT, WHERE, INNER JOIN, OUTER JOIN to query data in Microsoft Access databases
  • Extracted and consolidated data from multiple sources using Excel VBA into a usable format to help leadership understand key metrics and performance indicators
  • Prepared ad hoc requests by enhancing reporting capabilities and displayed a high level of work ethic in order to meet specified deadlines
  • Improved the efficiency and effectiveness of macros in order to produce deliverables

Confidential, Detroit MI

Mortgage Banker

Responsibilities:

  • Completed the S.A.F.E. Exam and additional state exams to become a licensed mortgage loan officer in 11 states
  • Guided clients to the best loan option by giving them expert advice in order to meet their overall goals

Hire Now