Data Analyst Payroll Coordinator

Chuka Maksim

*** ***** ***

West Covina, CA *****

909-***-**** ******@*******.***

OBJECTIVE: Excellent and dynamic data analyst seeking opportunity to work in a friendly and fast growing environment where my analytical and methodical skills will be of great value in achieving the company’s missions and goals.

RightsIn, Inc & Rightsledger. Inc 2016-present

HR/ Payroll Coordinator

Processed semi-monthly payroll for 20+ employees provided detailed plan analysis on payroll discrepancies and benefit plan and issues.

Manages company payroll administration including audits, calculations and reports.

Handles company all related new hire paperwork and I-9 to verify employment eligibilities.

Assists the CEO and CTO with various projects.

Analyze and recommends the database processes to increase effectiveness and efficiencies.

Didi Hirsch, Culver City, CA 2011-2013

Sr. Accountant/Analyst

Gave hands-on support to the accounting supervisor/controller and CFO with accounting entries, as well as with the preparation of monthly financial statements and other related tasks. Conducted through evaluation of monthly general ledger for accuracy and provided periodic updates, variance analysis, and performance reports to controller, and associate CFO.

Served as a collaborative member of a team in the month-end close to assure timely and accurate reporting

Supervised and streamlined the entire processes that assisted managers in preparing strategic and operational data-based decision

Displayed proactive involvement in the annual audit through development of audit schedules and distribution of information to the auditors, as requested

Diligently aided controller and associate chief financial officer with annual financial audits, contract audits, and any additional audits, as necessary

Produced operational and fiscal matrices and program performance indicators for new or expanded programs within LACDMH in collaboration with CFO and Director of Financial Reporting

Took the initiative in developing monthly “Revenue versus Cost and Annual YTD Budget Report” for the Executive Management Team and Program Operations Meeting

Immediately addressed all data requests to ensure timely achievement of daily, weekly, and monthly deadlines and goals

Extensively utilized proprietary tools (MS Access, Pivot Table and Charts) and third-party technology (CDT) to analyze data and create detailed reports; successfully identified and resolved quality issues that drove quality assurance and data quality initiatives.

Pacific Clinics, Arcadia, CA 2007-2011

Program /Revenue Data Analyst

Pacific Clinics provides leading-edge behavioral health-care services to diverse populations in Los Angeles, Orange, and Riverside, San Bernardino and Ventura counties.

Works with the Accounting Department and Executive Management Team to develop reports on key performance indicators of the organization’s LACDMH programs.

Assists in monitoring contract operational and fiscal performance of the LACDMH contract.

Works with CFO and Director of Financial Reporting in developing operational and fiscal matrices and program performance indicators for new or expanded programs within LACDMH.

Works with the CFO and Director of Financial Reporting in preparing operational and fiscal performance reports (e.g., weekly and monthly program outcome and client statistical reports; monthly fiscal operations reports, etc.).

Prepares and distributes weekly/monthly/quarterly staff productivity reports using Crystal, MS Access and Excel Pivot table, Charts. Power Point presentations for staff productivity reports monitor staff actual versus budgeted billable units of service.

Generates monthly “Revenue versus Cost and Annual YTD Budget Report” for the Executive Management Team and Program Operations Meeting.

Compares staff productivity reports with staffing matrix to ensure costs are coded to correct cost center where units of service are being generated. Review staff allocations and work with the HR Department to prepare supporting documents to reclassify the staff as needed to the correct cost center.

Provides analytical review (quantitative and qualitative).

Prepares monthly and quarterly revenue/cost forecasting and budgeting report and distribute to the Executive Management Team and the Program Directors, Managers and Supervisors.

Updates, reviews and distribute staffing matrices as needed for program Directors and Divisional Directors and Managers.

Prepares monthly program/divisional financial and operational performance reports including management dashboard reports and claims processing reports and provides analysis.

Performs database queries, data extrapolation and interpretation for statistical analysis, forecasting and trending, and report production including the development of professional-level graphs and charts.

Responds to data requests to ensure daily, weekly and monthly deadlines and goals are met in a timely manner.

Extracts data from databases and performs ad-hoc queries, data extrapolation and interpretation.

Analyzes data and creates detailed reports utilizing proprietary tools (MS Access, Pivot Table and Charts) and third party technology (Seginus/CDT) to identify and resolve quality issues to ensure quality assurance and drive data quality initiatives.

Performs analysis on existing data and identifies root causes for data inaccuracies. Communicates to Divisional Directors for resolution of errors.

Extracts data from county SIFT/EFT system and through FRX to pull costs from the MAS 500 system to integrate with various reports.

Presents various reports for management monthly as requested.

Develops, notates and maintains programming codes for various revenue management databases.

Analyzes, recommends, and implements changes to database processes to increase effectiveness and efficiencies.

Assists the Director of Financial Reporting with various tasks to support the monthly billings of government contracts and Budget preparation to support proposals for Los Angeles, Riverside, Orange, San Bernardino, and Ventura County.

Portals House Inc., Los Angeles, CA 2006-2007

Analyst, HR and Payroll (Portals House…merged with Pacific Clinics in 2007)

Processed semi-monthly payroll for 230+ employees provided detailed plan analysis on payroll discrepancies and benefit plan and issues.

Audited payroll deductions ensuring proper coding and design accurate and complete.

Developed error reports to be reviewed by executive management

Acted as government specialist ensuring processing of employee garnishments/withholding orders and EDD forms followed state and federal regulations

Processed and reports bi-monthly ADP payroll for 250 employees.

Millennium Alarm Systems, Inc., Los Angeles, CA 2004-2006

Credit Analyst (Distributer Bang & Olufsen)

Worked with multiple operational channels

Assisted in drafting and enforcing policies and procedures companywide for CEO and regulatory level complaints

Assisted management in creating online new accounts (up to 20-45 daily); monitored all accounts; credit card transactions, accounts receivable; prepared spreadsheets for daily and weekly reports;

Responded to customer inquiries and follow up, service scheduling;

Maintained vendor files; contracts in various vendor accounts;

Designed certificates, create banners and company flyers; conduct on-line research;

Assisted with presentation preparation; scheduled and prepared documents for meetings

Law Offices of Deepak Parwatikar, Los Angeles, CA 2001-2004

Administrative Assistant/Bookkeeping

Provided specialized administration services for Executive Management Team and Executive Staff such as reporting, budget analysis, travel arrangements and event coordination

Contributed to process improvements through revisions and implementation to company Policies and Procedures

Oversaw IT Human Resources issues such as new hires, terms and basic employee relations

Managed department payroll administration including audits, calculations and reports

Acted as a liaison with Corporate Accounting on reconciliation of contracts, invoices and purchase requisitions

Facilitated all department project administration and tracking

Provided a broad range of legal support to Senior Counsel

Research and Filing of INS documents

Provided high level analysis of issues regarding AR/AP in instated corrections

Maintained confidential files and records

Haight Brown & Bonesteel LLP Santa Monica, CA 2000-2001

Personal Assistant /AR/AP (attorney Phyllis Truby)

Maintained accounting books and handled general financial matters; performed special duties instructed and assisted in various confidential matters; maintained and organized files for over 500 cases; screened telephone calls; conducted general office duties and other special projects.

Tokyo Kaikan Restaurant, Los Angeles, CA 1997-1999

Assistant Manager/Bookkeeper

Coordinated employee schedules and trained new staff.

Responded to customer problems.

Responsible for numerous cash and credit card transactions

Reconciled cash register and handled employee disputes/grievances.

SKILLS: Languages: Mongolian, Russian and Korean

Computer Software: MS Office Suite (MS Access, Excel, Words, Outlook, Power Point) ADP, HRIS, HMS, MAS 90 & 500, Crystal Reports, FRX

Database: MS Access, MS Excel, Report Smith (ADP) SQL Server

EDUCATION: Bachelor of Arts, Business and Commerce 1992-1996

University of Mongolia

Contact this candidate