Customer Service Human Resources

RACHEL REYNA

**** * ***** ******, *** *S, Chicago, IL 60626 . 630-***-**** (cell)

. *******.****@*****.***

EDUCATION

Loyola University Chicago, Chicago, IL

B.B.A. in Business - Information Systems, with a minor in Computer Science,

May 2010

WORK EXPERIENCE

Human Resources Information Systems (HRIS) Intern

Metropolitan Pier & Exposition Authority (MPEA), Human Resources Department

February 2010 - August 2010

- Responsible for guided and on-going historical data clean-up within

production version of database

- Assisted in all activities of the historical data conversion phase

of system integration implementation, including

pre-conversion and post-conversion to Automatic Data Processing

(ADP)

- Scrubbed legacy data in efforts to increase data integrity and

reporting confidence before it was loaded into the new system

- Compared newly converted data against legacy HR database via

spreadsheets (Utilized Excel's V-Look-Up feature)

- Organized and resolved data inconsistencies between systems

utilizing the Excel Pivot Table and Filter features

- Developed efficient validation methodologies, which was ultimately

used to summarize and analyze the data

- Responsible for resolving explainable conversion errors for various

fields of data

- Attended regular project staff meetings, which lead to an increased

comprehension of project deliverables and database

management

- Responsible for the daily maintenance of electronic filing and

imaging system for inactive employee files

Teacher's Assistant

Loyola University Chicago, Information Systems Department

August 2008 - May 2009

- Hand-picked by my professor to conduct office hours for MS Excel and

MX Access projects

- Solved complex problems students would encounter while completing

their projects

- Ensured the students understood the logic and reasoning used to

solve the problems

- Write up weekly reports outlining the events of the office hours

Computer Lab Monitor

Loyola University Chicago, Law School Library

January 2009 - May 2009

- Ensured lab equipment was functional

- Conducted troubleshooting tests as problems arose with the equipment

- Write up shift reports explaining any issues that occurred

Desk Receptionist

Loyola University Chicago, Conference Services, At Your Service Desk

Department

June 2009 - August 2009

- Ensured guest information, room reservations and charges were up-to-

date on both Kinetix and the RIF cards

- Provided friendly and efficient customer service

COMPUTER SKILLS

Database Experience:

Methods: ER Modeling, Relational Modeling, Normalization, Dimensional

Modeling / Star Schemas

Software: - MS Access 2003/2007

- SQL (Oracle, Teradata)

- OLAP/BI (Oracle Discoverer, Microstrategy 8 BI, Automatic

Data Processing (ADP))

- Fat Free ERD (ER Modeling Software)

- Fat Free Star (Star Schema Modeling Software)

MS Excel 2003/2007 (including Pivot Tables, Macros, Scenario Manager, Goal

Seek, Solver, and Financial Functions)

Adobe Acrobat

MS Word 2003/2007

MS Powerpoint 2003/2007

HTML (including experience with CSS, and FileZilla)

Python Programming Language

Java Programming Language

Contact this candidate