Aaron Watsky

Experience

• 

  T-Mobile

  Nov 2003 - Oct 2011

  Retail Associate Manager

  • Performed all management and operational functions for a retail store, including but not limited to: Training and coaching new and existing associates in sales techniques, daily job responsibilities and all policy and procedures. Maintain sales team statistics and work schedules for seven employees. Monitor employee performance evaluations, incentive programs to increase employee productivity, and troubleshoot issues.• Managed a budget through PNL’s (Profits and Losses). • Created and nurture a well-balanced, diverse, and focused team through motivation, leadership, training, and establishment of sales processes as the foundation for business success. • Merchandise the store based on company standards while maximizing the customers’ unique experience.• Conducted a successful Senior Leadership Visit (including Retail Vice President for the South Division). Show less

• 

  Housing Authority of New Orleans

  Nov 2011 - Dec 2018

   Research program’s relational databases in SQL by writing queries to discover new opportunities to increase the program’s effectiveness. Extracts and interpret data. Certify the reporting of over 18,000 vouchers to the voucher management system to increase the retention of program funding.  Organize formal staff training using Power Point and hands-on experience to increase awareness of program regulations and design and implement training on newly created tools to maximize performance.  Creates maps using GIS software to map the program’s jurisdiction, neighboring jurisdictions, Census tract data, and area amenities.  Scrutinize agency active written and software policy, establish proven basses for the need of new policies, and evaluate program compliance with federal regulations. Show less • Supported investigators by analyzing the complexities of uncovering fraud. • Developed departmental policy and procedures. • Investigated evidence of financial misconduct in government programs.• Oversaw compliance of program requirements.• Streamlined staff effectiveness by creating the Repayment Agreement Calculator (Calculates repayment amounts and participant rents for up to 10 periods), and Rent Affordability Calculator (Calculates participants’ portion of rent by zip code). Increased efficiency of work process by automating redundant tasks and reducing staffs’ means of creating errors. • Redeveloped reporting for the Fraud Hotline System. Converted the reporting from a basic spreadsheet to a statistical summary dashboard and map of jurisdiction. Resulted in more accurate reporting of department, police officers, offenses, dispositions, decisions, and results for over 1,600 reported cases. • Designed a tracking database using VBA, MS Excel, and MS Query to track fraud committed by Section 8 participants and owners. Uncovered $1.2 million dollars of fraudulent activity, recovered $124,896.43 through repayment agreements and terminated 102 fraudulent participants. • Oversaw operations over the Fraud Department’s special projects. Provided data expertise, drafted procedures, and offered guidance to fraud investigators during the special projects’ lifecycle. Show less

  • Analyst

    Jan 2017 - Dec 2018

  • Fraud Investigator

    Apr 2015 - Jan 2017

  • Policy & Utilization Analyst

    Nov 2011 - Apr 2016
• 

  Entergy

  Dec 2018 - now

  • Subject matter expert (SME) in Power BI. Leads meetings and trainings for the Entergy Power BI user group with 400 members.• Administrator over the Power BI service and the three (3) on-premises gateway cluster.• Monitors two (2) Power BI premium capacities (P3 and P2 SKUs) utilization rate <100%.• On-premises three (3) gateway cluster servers and data source connections.• Maintains Active Directory (AD) groups for access to the Enterprise Data Lake and Power BI.• Power BI service workspace utilization.• Utilizes Power BI REST API for reporting and analyzing of the entire scope of the product.• Leads Power BI Projects involving intricate tabular modeling and complex DAX expressions.• Analyzes published Power BI reports for performance gaps and makes recommendations to increase performance.• Recognition from Microsoft as a Super User within the Power BI community.• Designs and implements the Enterprise Data Lake solution architecture, working closely with the IT Enterprise Architecture team plus other Data Lake and Analytics teams.• Provides primary advisory and consulting services for technical aspects of Power BI and Enterprise Data Lake technology stack. Show less • Work with business partners, vendors, and cross functionally to understand business objectives and develop value-added reporting and provide ad-hoc data extracts and analysis.• Analyze data from reports and databases to uncover data integrity issues.• Import data from SQL Server DB, Oracle DB, ODBC, OData, web, flat files (xlsx, csv, txt, tsv) to generate visualizations.• Create DAX queries to granularize and aggregate data.• Publish Power BI reports daily to keep management informed.• Prepare data for gateway passthrough.• Evaluate relational databases and dictionaries to best utilize available data.• Key contributor of Entergy’s Power BI User Group. • Facilitate ad hoc training sessions for employees across Entergy. • Construct and publish maps using ArcGIS.• Lead the design and development of BI reporting for the Advanced Metering Operations Center (AMOC).• Analyze, design, and continuously improve reporting for Grid Modernization under the AMI (Advanced Metering Infrastructure). • Examples of past projects include:• Deployment Dashboard: An executive level progress report of the deployment of smart meters for three million customers; • Inventory Asset Creation Report: A system monitoring tool used to measure the integrity of data flowing through three separate databases;• Analysis has resulted in the correction of data discrepancies affecting 100k meters over a five-month span.• Route Cutover: A detailed report catered to midlevel management to analyze the progress of cutting over metering routes; and• Resulting in accurate reporting of completed routes.• OTAP Report: Streamlining tool used for Over the Air Programming (OTAP) of meters. • Reduced the amount of time needed for the AMOC to OTAP meters from two hours down to 15 minutes. Show less

  • Senior Solutions Architect

    Jul 2020 - now

  • Data Integrity Analyst

    Dec 2018 - Jul 2020