Experience

IO Education powered by Illuminate Education

• United States
• Education Administration Programs
• 1 - 100 Employee

• Senior BI Report Analyst

  • Jul 2017 - Present

  • Review specifications from the Vice President of Product and build analytic reports using the Power BI analytics tool • Work in tandem with the data architect to identify any additional data needs necessary to satisfy client requests • Insure that all analytic reports follow the standardize template parameters governing acceptable fonts, colors and graph, chart and filter page orientations • Create needed formulas in the Data Analysis Expression layer of Power BI to derive additional calculations not included in the SQL query which includes, but is not limited to: o Create basic and complex calculated formulas o Add additional lookup tables to existing report schema o Binning (Grouping) various data values to categorize redundant values o General nomenclature updates for more intuitive data labeling o Calibrate and apply conditional font and background formatting to data values o Create table and matrix hyperlinks to external URLs • Assist with the identification and resolution of data issues to ensure that metrics make logical sense • Determine the best analytic representation for the type of data being represented • Publish reports to applicable Power BI workspace to be migrated to production by data architect • Monitor and promptly resolve report issue cases assigned in Salesforce to insure a continued positive client relationship • Administer all update maintenance to reporting as needed per client requests, data model changes and Power BI updates • Basic SQL report creation which includes, but is not limited to: o SQL calculated Custom Columns o Group By functions o Order by Functions o Concatenation o Where Clauses o Date Conversion o Table Joins Show less



N3 Results

• Atlanta, GA

• Senior Data Analyst

  • Apr 2015 - Jul 2017

  • Developed and maintained interactive dashboards using Power BI, Power Pivot and Excel for Sales & Operations to provide meaningful activity, sales metrics and insights for all Microsoft Corporation products, Epicor and Firehost in monthly/weekly meetings • Built standard reports in CRM Dynamics via the Advanced Find function to capture and export raw data to validate Microsoft dashboard metrics • Developed a standard product insights process to accurately capture and compartmentalize customer feedback for new product introductions to guide project managers on improvement focus which included the initial release of Power BI • Assisted SQL Developers with the creation of standard views connected to Power Pivot and Power BI Analytics to easily create standard and adhoc reports for Sales & Operations • Generated as well as created standard SQL reports • Regularly met with sales managers to get feedback on current reporting and insights on new reporting needs to efficiently manage their campaigns Show less



Verizon Connect

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Senior Report Analyst

  • Dec 2012 - Apr 2015

  • Responsible for developing and managing reports generated from Oracle Business Intelligence Enterprise Edition (OBIEE) release 10G/11G to support company reporting needs which includes, but is not limited to: o Met with customers to understand precise needs regarding reporting o Developed adhoc and standard reports as well as perform a series of quality assurance checks to insure result accuracy o Built interactive dashboards with tables and graphs within OBIEE for shared use of conventional data requests o Created custom case statements for custom calculations within reports o Cultivated a series of detailed bins to standardize multiple data values that should have the same universal value for more concise reporting • Built interactive modules using complex formulas and macros to create automated custom reports as well as helpful data tools that go beyond the scope of what our standard reporting tools can currently accommodate to meet precise internal and external customer needs without excessive delays • Generated monthly standard Executive Scorecards that provide a series of standard required data for OEMs to track business performance per requirements Show less



Sony Mobile Communications

• Japan
• Telecommunications
• 700 & Above Employee

• Customer Service Accounts Manager / Sr. Data Analyst

  • Sep 2010 - Dec 2012

  • Assist Head of Customer Service with escalated customer issues and data needs • Attend biweekly dashboard meetings with operators to address outstanding concerns and task lists • Work in tandem with Order Management Team to insure timely delivery of phone units, associated parts and timely payment credits for return material authorizations • Generate weekly/monthly reports per the contractual requirements of multiple phone operators like AT&T, Verizon and T-Mobile including, but not limited to: o Liquidated damages calculations per contractual agreements o Incremental Seed Stock calculations per contractual agreements o Production, Work in Progress (WIP) and Turn Around Time (TAT) reports based on tracked repair vendor data • Responsible for accessories order management for North America • Assist multiple departments with data needs upon request including audits, interactive spreadsheets utilizing complex formulas, pivot tables, v-lookups, macros, charts and graph, as well as Power Point presentations • Participate in live user testing for pre production phone units to be ranged with operators, providing critical feedback on general product design and hardware & software needs • Assist with physical phone repair and flashing software upon request of Repair Manager • Manage subsidy unlock codes for approved dealers (responsibility requires stringent security clearance) Show less



Verizon Connect

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Data Analyst

  • Mar 2009 - Oct 2010

  • Created and ran standard daily and monthly reports for various departments from Oracle Business Intelligence Enterprise Edition Data Warehouse (OBIEE) which includes, but is not limited to: o Gathering all necessary business requirements for report requests o Creating pivot tables and graphs utilizing the OBIEE reporting tool and Excel o Validating report data via a series of data checks and audit reports o Setting up Intelligent Bursting Output Tools (IBOTs) to automatically deliver reports to applicable recipients • Assisted with additional development of reports that cannot be created via standard database tools do to programmatic limitations • Identified and assisted with the correction of source data integrity issues • Developed interactive excel modules utilizing formulas, data links, pivot tables, charts and macros to assist technicians with comprehensively tracking data in the field Show less



Hodges Mace Benefits Group Inc

• Data Analyst

  • Jul 2007 - Jan 2009

  • Met with clients and their benefit providers to identify project scope and parameters (e.g., benefit structure, employee count, evidence of insurability requisites, unique data needs); defined data specifications and methodology; and produced applicable reports • Prepared employee demographic, benefits enrollment and dependent data import files, based upon case specifications, for migration into applicable benefits software platforms • Developed Crystal Reports and Microsoft Word mail merges for pre-/post-enrollment employee communications • Installed case-specific software for counselor use and provided technical support during client enrollment process • Conducted technical training segments to counselors and facilitate case data transfers • Provided installation and ongoing support to internal staff for technological resources, including Altigen telephony and reporting platforms, complete workstation setup, and general technical needs Show less



ARRIS

• United States
• Telecommunications
• 700 & Above Employee

• HRIS Manager

  • Mar 2003 - Jun 2007

  Human Resources Information Systems (HRIS) Manager • Created and ran public and private queries via PeopleSoft upon request for human resources and routine month end reports and audits for other internal departments • Generated comprehensive spreadsheets involving complex formulas, data links, vector arrays and macros for reports such as bonus plans, severance plans, and stock option distribution projections • Administered company stock option program via Transcentive Software which included, but was not limited to;  Performing monthly data importation of optionee personal and tax information updates  Generating various reports as needed from Transcentive canned reporting  Answering employee questions regarding stock and vesting schedules   Generating and maintaining all stock transaction records  Developed materials and conducted PeopleSoft training for the department Show less



Intercontinental Hotels Group

• Human Resource Administrator Level II/Trainer

  • Oct 2000 - Mar 2003

  • Maintained events and corrected complex system errors caused by data integrity issues • Maintained records from inception to completion of evidence of insurability for supplemental life insurance • Created formulated spreadsheets to test accuracy of the calculations set up in PeopleSoft (e.g., supplemental life, short term disability and long term disability) in preparation for plan year changes and open enrollment • Answered questions about all benefit plans and resolved insurance eligibility issues with carriers • Completed courses to attain group training certification to train employees of Intercontinental Hotels Group • Performed comprehensive training sessions on PeopleSoft and the benefits administration module • Developed materials and conducted comprehensive customer service training sessions • Created automated billing invoice to collect arrears premiums for employees on Family Medical Leave Act or otherwise still employed, but not on active payroll Show less



Spherion Corporation (formerly Interim/Norrell)

• Senior Benefits Administrator

  • Sep 1996 - Oct 2000

  • Investigated and resolved escalated deduction and eligibility issues • Researched complex carrier eligibility discrepancies, identifying problems in electronic tape transmissions and aiding systems analysts in their resolution • Monitored electronic transmittal of benefits data to ensure all critical information is passed to carriers • Created various forms and processes to enhance efficiency • Developed curricula for and conducted comprehensive customer service trainings • Interviewed potential candidates for benefits positions • Conducted new hire benefit presentations • Trained benefits associates to perform needed functions in five different payroll databases, answer benefits questions competently and resolve complex benefits and deduction issues • Managed the dependent care and health care reimbursement administration for 700+ participants • Assisted with planning and rollout of the annual open enrollment project for 21,000+ employees Show less