Human Resources Manager
Resume:
N.David Gross
West Hollywood, CA 90069
**********@*******.***
sKILLS
Database Design and Maintenance Extensive experience integrating MS
Advanced Microsoft (MS) Access Access with MS Excel
Skills; creation of complex queries Development of financial and other
and reports models in MS Excel
User-Friendly Interface Design Automating Reporting Processes
Data Mining, Analysis and using VBA
Documentation Office and Personnel Management
Significant Health Care, Telecomm,
and Financial Industry Experience
MS Access, MS Excel, MS Office, MS Report writer, VBA, Brio Query
Experience
12/2006 - 2/2011 CITY NATIONAL BANK
Reporting / Systems Analyst
Created PCS Credit Tracking application using MS Access. System for
tracking Private credit portfolio and current status of each credit.
Automated the generation of reports in MS Excel. Worked with IS
department to migrate system to company intranet. Created and designed
reports for Intranet system using MS Report Writer.
Conducted formal classes instructing supervisors and staff in using
advanced skills of MS Excel such as pivot tables, filters, scenarios,
and creating macros.
Created File Tracking system for tracking inventory and current location
of all files on site along with those that have been archived off site.
Mined data from City Data II and Infoshare Web interface and then
automated distribution of reports created in MS Access and MS Excel.
Designed automated Excel workbooks for underwriting teams that would
easily upload information from Tax Analysis exports.
Designed system for automatically calculating employee efficiency by
gathering data from multiple sources. Designed interface for user to
enter criteria to assign value to tasks and responsibilities that would
translate into hour values.
Automated local REACT Reporting system
Simplified and automated the data mining from Reports 2000 data exports
for Operations team.
2/2004 - 11/2006 COUNTRYWIDE MORTGAGE/SELECT PERSONNEL
Systems Analyst assigned to Wholesale Division.
Interviewed end users to assess their specific reporting needs
Wrote custom functions to implement business rules on reporting
calculations
Cleansing data for more accurate reporting results
Taught staff in the use of Pivot tables and charts to enhance their own
ability to create reports
Created and maintained MS Access applications that linked data using
ODBC; performed required calculations and then automated the exporting
and creation of over 35 separate daily reports using MS Excel
Created and maintained an MS Access application to automate data entry
and reporting for numerous processes supporting Loss Mitigation, OTC
Sales, Human Resources and WLD Reporting.
Maintained, modified, enhanced and supported inherited MS Access
databases that were created by other developers that had left the
company
Improved inherited applications by converting Macros into VB Modules,
re-coding forms and objects, redesigning queries for more efficiency and
better performance
Automated existing monthly and weekly reports
Coded forms for more efficient use and the limiting of data entry errors
Designed reports using MS Access's reporting platform
11/2003 - 1/2004 IndyMac Bank/Spherion, Pasadena
Report Analyst assigned to PPQC
Salvaged Watchlist data that was corrupted while being stored in Excel.
Migrated the data into an MS Access database in order to maintain the
Watchlist.
Created a database in MS Access for use by auditors who downloaded loan
information and manually entered data.
Automated the reporting function, while separately logging user
information and archiving information entered.
Created database in MS Access to automate tracking and verify invoices.
Designed switchboards and forms to display information, simplify data
entry and insure data integrity.
1/2003 - June/2003 AMGEN INC. / ACT 1 STAFFING, THOUSAND OAKS
Support Analyst with OIS, Project Coordinator with HR Metrics Analysis
Redesigned existing Excel tools for tracking performance ratings,
greatly improving efficiency and reducing file size.
Designed Excel application to automate the reporting of recruiting and
staffing statistics.
Created Pivot Tables and wrote VBA code to reformat Pivot charts to
client's style preference upon refreshing of data.
Designed switchboards and menus for easy navigation between worksheets
and applications
Designed reports and screens to document the mapping of relationships
between tables and to quickly display the attributes of those tables.
Assisted in designing tools using MS Access to facilitate data migration
between existing LIMS database and Sample Manager - Oracle database
2000 - 2001 NETWORK TEMPORARY/MAXICARE, Los ANGELES, CA
Special Projects assigned to Priority Affairs/ Spreadsheet Specialist
Supported Claims Supervisors, Operations Manager and Priority Affairs
Manager
Created and maintained MS Access database to audit claims examiners.
Created and maintained MS Access database to enable monitoring and
auditing of member services representatives.
Designed MS Access database for isolating, logging and reporting all
overdue claims for the processing of penalty interest payments.
Converted templates and forms from Word Perfect 5.1 into MS Word for
County Claims Legal Department.
Produced all Excel spreadsheets for legal settlement with LA County.
Conducted classes instructing supervisors in advanced skills using MS
Office.
1996 - 2000 MARCUS CABLE / Charter Communications, Glendale,
CA
Human Resources Representative
Supported District General Manager while reporting directly to Southern
California Vice president of Human Resources.
Created and maintained MS Access database for Human Resources
Department.
Performed data analysis and reporting regarding wages, overtime, and
benefits.
Responsible for all Payroll reporting in the Glendale/Burbank system
offices.
Mediated conflicts between supervisors and employees.
Conducted all New Hire orientations, background and reference checks.
Performed recruiting function, including initial interviewing and
representing company at job fairs.
Composed and placed recruitment ads and job postings.
Interpreted and oversaw employee union contract compliance.
Maintained Workers Compensation reporting and maintenance of logs
Responsible for all temporary staffing.
Education
SANTA MONICA COLLEGE - COMPUTER SCIENCE AND COMPUTER APPLICATIONS
UCLA - Political Science and Life Sciences
A.A. Santa Monica College - General Studies
Contact this candidate