Oxana Petrova
Buffalo Grove, IL 60089
**************@*****.***
Objective:
Seeking a position utilizing my data management and client support skills and experience. Summary:
Over 5 years of experience in data management with different software applications
Performed data query, extraction, compilation, and reporting tasks.
Managed, updated and manipulated data structures with using of advanced Excel functions, dashboards and slicers, Power Query, SharePoint and SQL.
Communicated with clients and entered new client information in database.
Generated weekly, monthly, and quarterly reports necessary in maintaining a good and balanced generation of accounting entries.
Handled data collection, analysis.
Education:
Oakton Community College - Des Plaines, IL
Certification program for PHP and MySQL (Aug 2015)
Ufa State University of Aviation Engineering - Ufa, Russia (Sept 1991 – Jun 1996) Bachelor's Degree in Automated Management Systems (awarded a qualification of Systems Engineer) Technical Skills:
Languages: PHP, SQL, FoxPro, Visual Basic
Applications: SAP, IBP, Power Query, Query Builder, MS Word, Excel, PowerPoint, Access, Outlook, SharePoint, Skype for Business
Operating Systems: Windows
Professional Experience:
MAT Holdings, Inc. – Long Grove, IL
Feb 2019 – Oct 2024
IBP Demand Planner/Analyst
Responsibilities:
Preparing Weekly Inventory reports for leadership using data from SAP and vendor portals
Maintaining weekly POS reports for the largest customers and weekly tracking of OTIF (On Time and in Full) performance
Monthly comparisons to performance of sales to budgets
Monthly preparation for Pre SOP process and disaggregation of forecasts for Purchasing department
Yearly preparation of Budget files
Maintaining a database of all of the items that are sold in the division (about 2,750 different items)
Performing numerous Ad Hoc reporting requests for analysis Allstate Insurance Company – Northbrook, IL
Contract, Oct 2018 – Dec 2018 (through staffing agency: Lancesoft, Inc.) Data Entry Operator
Responsibilities:
Worked at Investments Technology Department in a Vendor Management Office to assist with contract renewals management process for Investment contracts coming due in the 4th quarter of 2018 and 1st quarter of 2019. The contract project included:
Following contract checklist and on-boarding process already documented
Creating templates with requests in Outlook and sending e-mails to internal stakeholders and external suppliers
Updating new Vendor contact information in a Vendor Product database in SharePoint
Creating Vendor folders in SharePoint and saving e-mails with approved contract renewals in appropriate folders for Compliance Department
Analysis of completeness and reporting about contract renewals in Excel
Communicating within the team using Outlook and Skype for Business Accuity, Inc. (RELX Group) – Evanston, IL
Contract, Sept 2017 – May 2018 (through staffing agency: Spectraforce Technologies Inc.) Data Entry Specialist, Risk Data Operations Department Responsibilities:
Worked on Compliance Data Project to strengthen Risk Data Content team within the Data Strategy and Operations group. The role involved updating watch list data sets while complying with high standards of data quality and accuracy. The focus was on reviewing and modifying “Stop Descriptors” associated with watch list data maintained in a proprietary web-based data management application. Stop Descriptors are matching phrases used by matching software when comparing name data on watch lists to a customer’s input data. Within Client’s priority data management system:
Build knowledge on Accuity’s Stop Descriptor creation practices and methodologies
Run searches to identify groups of watch list records to review
Review the names in each watch list record and the stop descriptors the system generated for the names
Identify system generated stop descriptors that need to be removed or updated and apply the changes within the system
Identify and add additional stop descriptor that were not generated by the system when applicable
Coordinate activities and report progress to other team members assisting with the project
Report data content questions/issues to direct reports in real time Electric Power Company - Ufa, Russia
Aug 1996 – Dec 2011
Software Engineer, Information Technology Service
Responsibilities:
Developed, wrote and deployed software for accounting and tax systems utilizing FoxPro and Visual Basic with embedded SQL environment:
Developed software for accounting by creating data entry forms, documents and registers of incoming and outgoing invoices with automatic generation of accounting entries
Developed writing tools for data processing in the software environment, using SQL queries to the database for sold electric energy and reports for analysis and control of payments and receivables
Developed lease contracts registration units and templates for automatic filling in of forms and contracts
Utilized business process design concepts in creating a new module on claim work with clients on accrual and collection of fines and penalties for accounts receivable
Installed and updated software versions and conducted regular system backups
Developed optimal data structures
Conducted testing and trouble shooting of software developed in-house
Interacted with users and provided user systems support
Created new software modules based on new requirements and user feedback
Wrote user manuals and provided training for users