Audit Clerk Services Specialist

Rachel Sieczka 405-***-**** adnreh@r.postjobfree.com

**** ********* ** ******, ** 73012

Career Summary

While working at the State of Oklahoma, as the Hyperion Tech, I was the strategic planner in moving the Oracle Hyperion budgeting system from one service provider to another service provider. As the System Analyst, I was the scum master during the implementation of scrum for the PeopleSoft Financials upgrade and ongoing enhancements while working in conjunction with the Oracle development team to provide specification documents, also created several Standard Operating Procedure Documents. While at LexisNexis, as the Sr. Data Analysts, I had a major roll on the scrum team creating testing documentation and testing the improvements. In addition documented, improved and planned to implement in each “sprint” on the scrum team.

Skills and Abilities

Accurate Data Entry

Strong research Skills

Thrive with deadline

Analyze detailed data

Knowledge of Excel, Word, Outlook, Access and Windows

Create SQL Queries to access raw data

Create BI publisher Reports from Excel, SQL, CSV file data.

Import raw data into excel from SQL

Create pivot tables and OLAP cubes

Manage Independent Collectors/Vendors

Knowledge of legal terminology and court terminology and processes

Ability to self-motive

Create documentation for training

Education

Bachelors Science of Business–Human Resource Management University of Phoenix February 28, 2011

Experience

State of Oklahoma – 11/2015- current

System Analysts – 01/2018-current

Create data validation SQL scripts.

Test data moved from PeopleSoft to Oracle Cloud HCM.

Create testing documentation for data validation from PeopleSoft to Oracle Cloud HCM.

Create test scripts documentation for testers, end users, and SMEs.

Create instructional documentation for end users.

Create Standard Operation Procedure documentation for the PeopleSoft Financial users.

Scrum Master for the PeopleSoft Financials Scrum team.

Identify and create system/program recommendations for improved processes within the State of Oklahoma.

Budget Analysts/Hyperion Tech – 11/2015- 01/2018

Create reporting tools for Hyperion workspace.

Run ODIs and calculation scripts in Essbase.

Research issues as provided by state agencies to determine budget issues within the Hyperion and PeopleSoft environment.

Work with 3rd party developers on improvements to the Hyperion structure.

Work with 3rd party server group to ensure the end users are able to access the Hyperion workspace.

Assisted in the migration of Hyperion services from one service provider to the Oracle Cloud.

Created how-to documentation on processes in Hyperion.

Worked with the budget analysts and state agencies to resolve issues within Hyperion.

Telecom Professional Inc –03/2015 – 11/2015

Tax Agent – 03/2015 – 11/2015

Prepared Telecom monthly, quarterly, and annual Taxes in 50 states and counties.

Researched Tax laws and procedures in 50 states and counties.

Improved and streamlined processes to ensure deadlines were met.

LexisNexis – 09/2002-02/2015

Sr. Data Analysts – 03/2013 – 02/2015

SME and UAT on the “Team Charlie” agile scrum team.

Analyze, research and provide resolution to ensure data quality

Created specialized collector and internal certification documentation in high risk areas

Created territory specific collection monitor tools to assist in collection volumes.

Strategize with multiple departments to resolve quality and collection deficiencies within a given territory

Create tools to help with Territory Coordinator’s analyze and locate gaps in collection.

Territory Coordinator – 05/2011 – 03/2013

Manage independent contractors/vendors to ensure data is collected.

Analyze excel Olap cubes to locate possible missing data.

Research judgments to ensure the quality of data.

Manage the workflow of independent contractors to ensure customer’s needs are met.

Analyze raw data to locate possible areas of risk.

Provide managers with detailed risk analysis with possible solutions.

Recruiting and contracting independent contractors/vendors for piece work.

Client Services Specialist –1/2008-05/2011

Analyze the rejected records from a major customer and dropped the volume by 30%.

Research customer’s file investigations and concerns.

Communicate results to customers.

Work internally with programmers and data processing departments to resolve customer issues.

Advise Manager of in-depth customer issues to find a resolution.

Created internal training documentation for the Real Estate process for the Client Services department.

Work with all internal departments to resolve customer issues.

Audit Clerk – 7/2003-1/2008

Communicated audit results to Customers, Independent Contractors, Managers, Territory Coordinators and Data Analysts.

Reviewed, updated, and maintained the open audit spreadsheet ensuring timely processing of outstanding audits

Worked with LexisNexis’ largest client to guarantee the quality of records.

Used proprietary software to review incoming and outgoing audits.

Consumer Dispute Verification Representatives (CDV Representatives) – 9/2002-7/2003

Received recognition for being the only Consumer Dispute Verification Clerk to be able to meet and exceed the goal while covering the entire Texas territory.

Reviewed the open customer dispute verification report on a daily basis.

Contacted court clerks to verify case information

Trained new CDV Representatives.

Contacted collectors about open records and worked with the contractors to complete outstanding CDVs.

Contact this candidate