Employment History 

• Power BI Developer

  Colaberry

  February 2022 - Present

  Power BI
  Developed and deployed executive level Power BI dashboards, aligning with the firm's data management principles and best practices.
  Created analytical dashboards in Power BI, highlighting KPIs (PTI ratio, Income, YoY percent change), enabling stakeholders to analyze, forecast, and pinpoint improvement areas.
  Showcased critical thinking and robust quantitative and qualitative development skills, leveraging logic and reasoning to evaluate alternative solutions and approaches.
  Developed interactive, visually appealing dashboards using complex DAX measures, parameters, and data transformations.
  Implemented a scheduled Power Automate flow to export and email Power BI reports with row level security to stakeholders and team members.
  Ensured update dashboards by refreshing reports with on premise data sources via Power BI gateway.
  
  SSRS
  Developed dashboards and various reports (Drill through, Drill down, Parameterized, Sub, Ad hoc, Table and Matrix, Interactive, Chart) using SSRS.
  Utilized SQL Server to create complex Stored Procedures, Views, user defined functions, and Triggers to optimize SSRS report queries performance.
  
  SSIS
  Created and maintained SSIS ETL packages using various tasks and transformations in control flow and Data flow.
  Ensured efficient package execution by implementing various Error and Event handling techniques.
  
  SQL
  Used TSQL to develop stored procedures, triggers, tables, user defined functions, joins, and other query writing to optimize data loading into Power BI.

• Contracts Administrative Assistant

  Omnitracs (Contract)

  March 2015 - July 2016

  Provided support to the legal department by preparing legal correspondence, including termination letters, extensions, and amendments. Entered, validated, and updated contracts, such as Statements of Work, Amendments, Pricing Schedules, and Master Agreements, ensuring compliance with all legal terms and conditions. Participated in weekly risk management meetings to address potential issues and discuss process improvements aimed at enhancing compliance throughout the organization. Prepared and drafted purchasing and sales contracts with precise and accurate terms. Updated and amended existing contracts to incorporate new terms, conditions, and agreements, ensuring all modifications aligned with organizational objectives. Reviewed contracts before execution, identifying and resolving potential issues to mitigate risks.

• Revenue Management Analyst

  Oncor (Contract)

  August 2016 - March 2017

  Managed utility accounts for various cities in Texas, ensuring strict compliance with ERCOT and other billing territory regulations.
  Performed daily duties that warranted the reconciliation of an account and re-billing the client; updated rates, corrected in/out and demanded reads, submitted service orders, smoothed and prorated usage when applicable, resolved inadvertent gains and crossed meter issues.
  Addressed billing exceptions and issue resolution, revenue tracking and other analytical reviews of the meter-to-cash work stream through ongoing performance and monitoring of key Revenue Management business processes.
  Conducted analytical reviews of the meter to cash workstream, contributing to the ongoing performance and monitoring of key Revenue Management business processes.

• Billing Analyst

  RealPage

  June 2017 - December 2021

  Multifamily Property Management analysis; consisting of revenue management, problem identification and resolving large
  scale billing problems, monthly preparation of client bills, invoice processing, etc.
  Perform cost recovery analysis of multifamily property billing; involves researching and verifying charge rates, cost of
  services, consumption, base/flat fees, meter issues, conversion factors, etc.
  Coordinate the monthly distribution of pre-bills to property management contacts for review and approval
  Open Tickets as needed using the Salesforce application
  Data Reporting; collect data to interpret into a report using Microsoft excel which is sent to the entire billing department,
  operations, and management for review daily.
  Work on a monthly list of sites that require special handling and or at risk by performing required special duties
  Serve as a leader and mentor to billing coordinators; assist with training, resolving issues and responding to questions.