Data analysis, administrative, Excel, databases

Daniya Chedekel

Phone: 443-***-****

Email: **********@*****.***

Education: BA in Psychology - Towson University

Summary of Career

6+ years as a Data/Reports/Business Analyst

6+ years as an Administrative/Executive Assistant

2 years of telemarketing and supervisor experience

2 years of in-home sales experience

2 years working with medical claims and billing

Skills:

MS Office 2003-2015: expert level in all applications

Administrative: answering phones, customer service, reception, meeting minutes, correspondence, spreadsheets, PowerPoint presentations, travel arrangements, maintain management calendars and schedules

Databases: relational databases, data structures, database design, and methods for

efficiently retrieving data

Actuate, Toad, Oracle, basic SQL knowledge/SQL Server and Oracle, Crystal Reports,

customized reports in MS Access

Business Analyst: Gathering functional specifications and business requirements

Accurate typing of 65 WPM

Human Resources: hiring, training, interviewing, recruiting

Ability to learn new software unique to the business

Work Experience:

12/2014-12/2015: Regional Administrative Assistant - Pennrose

Supported four Regional Property Managers for a property management company

Tracked data for 40 apartment complexes in Baltimore, Pennsylvania and New Jersey

Produced daily and weekly reports in Yardi

Reconciled American Express expenses for the VP

Helped 20 Property Managers stay on track with regional deadlines

09/2013-07/2014: Business Systems Analyst II (Contractor) – BGE via The Judge Group – Baltimore, MD

Worked in an administrative role assisting managers with spreadsheets, meeting minutes and weekly production reports

Run daily, weekly and monthly reports using SQL, Excel, Access to track metrics for SmartGrid implementation

Track SmartGrid meters installed in homes by BGE and other vendors

02/2013-7/2013: Jr. Database Analyst (Contractor) - American Urological Association via Anchor Technical Services – Linthicum, MD

Queried the company database using SQL and Crystal Reports

Modified and updated the company database (Personify) using SQL

Maintain and ensure accuracy of customer information and data

07/2011-2/2013: Business Data Analyst – Maximus/Balt City Office of Child Support

Enforcement – Baltimore, MD

Create and execute mail merges (for caseworkers) to generate letters to clients

Run daily production reports for managers to showcase caseworker statistics,

which includes pivot tables, graphs and other summarized data

Create ad hoc reports in SQL and MS Access showing statistics such as cases that

haven’t made arrears payments on their child support

Manage auto-dialer campaigns for various departments – consent hearing

reminders, deadlines for enrolling

Handle all requests for assistance with Excel documents

Helped with developing a SharePoint reporting tool for case management

Create AutoHotkey scripts to help minimize repetitive tasks and keystrokes for

the caseworkers

Create and manage databases for customer service escalation tracking and hospital paternity statistics

02/2009-6/2009: Data Administrative Analyst - Resolution Health – Columbia, MD

Run daily and monthly Rx claim analysis reports

QA daily and monthly reports for accuracy and deliver product to clients

Compile data to create PCN (Personal Care Notes) for health insurance recipients

Programs used to compile data consist of .bat files, SQL Server and Crystal Reports

Operate stored procedures and scripts to load and process client data

Analyze results of system audits

Create ad-hoc SQL queries

Create client deliverable files, reports and databases

02/2007-12/2008: Business Data Analyst (Contractor) - Verizon via CDI Bus.Solutions– Silver Spring, MD

Administrative - prepare weekly and monthly sales analysis reports for Verizon external business sales

Develop and maintain a comprehensive tracking system/Access database of all vendor telemarketing sales, units, revenue, sales per hour, and dispositions

Receive raw data from vendors and compile all information in Access to produce queries from the Access database, narrow down report requests from managers, regions and vendors

Fulfill ad-hoc report requests on a daily and weekly basis, customized reports using SQL and VBA

Verify and test reports and data to ensure accuracy

Make changes to existing reports in order to satisfy current requirements

Contact this candidate