Experience

• 

  Time Warner Cable/Meridian

  • 6550 Winchester Ave,Kansas City · MO · 64133

  • SQL Reporting Analyst

    • Mar 2015 - Present
    • 6550 Winchester Ave,Kansas City · MO · 64133

    • Create and debug ETL code in Microsoft SQL server 2008/2012• Build SSRS reports for the residential business in Microsoft SQL server 2008/2012• Create SSIS packages and stored procedures as well as write SQL scripts to pull and transform data from multiple sources into enterprise Microsoft SQL server 2012 database• Identifies, researches, and analyzes data / reporting issues in order to develop solutions

• 

  H&R Block

  • DownTown HD

  • SQL Reporting Analyst

    • Oct 2014 - Oct 2014
    • DownTown HD

    • Created Ad-hoc and scheduled reports for all levels of management.• Responsible for creating data analytics for scorecards and dashboards.• Ran daily SQL/TOAD reports• Managed report schedules• Conducted analysis in a systems and reporting capacity. • Responsible for writing and troubleshooting SQL code• Assisted in the coordination of various research initiatives.• identified opportunities to improve decision making through the application of analytical concepts and techniques.

• 

  Deffenbaugh Inc

  • Kc ks

  • Reporting Analyst

    • Jul 2014 - Oct 2014
    • Kc ks

    • Using SQL 2012, created down vehicle report, • Created Residential Service Call Route Report• Created RollOffServiceEvents Report• Created SQL Trigger to update Sales History when price increase is applied.• Using AS400 via dbvisualizer wrote a Script and analyzed the data to find All price increased that had been applied but not written to History table.• Then Insert those missing records into the history tables.

• 

  Blue Cross Blue Shield

  • DownTown

  • Reporting Analyst

    • Mar 2014 - Jul 2014
    • DownTown

    • Analyzed the current HRA Import Error handling process.• Created project plan to automate the Error handling process by creating Error codes table.Documented all the validations added those to Error codes table. Had programmer add those codes to the Validation Process and write to error table then send emails.

• 

  Examinetics

  • 10561 Barkley #400, Overland Park, KS 66212

  • Data Management

    • Dec 2010 - Dec 2013
    • 10561 Barkley #400, Overland Park, KS 66212

    • Data Management Services (DMS). • Using SQL 2005, SSIS, Microsoft Access to Import and Export Client Historical Audiometric data. Receive client’s data in various formats DMS would clean and validate data integrity prior to importing. Checking for duplicates records, Validating DOBS and other validations. • Using SSRS to created several reports example to supply Clients with a current Employee Roster. The client would export the report to Microsoft Excel and make updates and return for current data updates.

• 

  Valutrust

  • Reporting

    • 1900 - 1900