Analyst Accounting
Resume:
LaVette M. Velasquez
adhvlq@r.postjobfree.com
EXPERIENCE
The Inland Group of Real Estate Companies
Business Systems Analyst
●Support and develop complex enterprise software systems
●Collaborate with developers, internal personnel, and system administrators in supporting ongoing operations of the system applications team
●Document and communicate all progress and changes in a clear and professional manner
●Utilize my software development, operational oversight and my project management skills as well as my background in Accounting & Finance to respond appropriately to both project and operational issues.
●Develop relationships with the business or function to assist in the discussion of proposed solutions and define user requirements.
● Perform short-term Project Management, Project Lead and Business Analysis
●Work with Hubble, JDE, Spend Dynamics, Avid & in-house system tools
●Interpret business requirements and functional design documents
●Document and review technical specification
●Develop systems enhancements in accordance with technical specification documentation and ensures system changes are unit test properly
●Develop business or functional knowledge by responding to and resolving user questions, problems and inquiries.
●Provide Tier I, II and Tier III support per request from various constituencies.
Sinai Health Systems
Senior Accountant (Contract)
06/2017-09/2017
●Managing accounting functions across the entire 8 Entities of Sinai Health Systems
●Utilizing the Meditech financial system
●Performing account and bank reconciliations
●Responsible for the input of journal entries
●Carrying out the preparation of 10-Q and 10-K reports for SEC filing
●Currently owning the process of analyzing various financial statements
●Conducting month-end and quarter-end closes
●Maintaining SOX compliance documentation
●Coordinating with external auditors on all audit related requests & inquiries
●Currently in charge of documenting and communicated new processes
CCC Information Systems
Data & Integration Accounting Analyst (Contract)
01/2017-06/2017
●In charge of interacting with prior servicers and suppliers regarding system conversion requirements and all data discrepancies, missing data, files/images and timelines for data transfers.
●Accountable for communicating and coordinating with other business units to resolve these discrepancies and loan level reviews within deadlines.
●Following-up on outstanding items through resolution.
●Performing data analysis by using specific tools to identify discrepancies which need further review or explanation.
●In charge of determining the best course of action to resolve the discrepancy dependent on the severity of the issue, loan product, lien position and loan status.
●Analyzing data so that it can be accurately mapped into a pre-boarding system utilizing proprietary programs, Oracle, Workday, Microsoft Excel and Microsoft Access.
●In charge of uploading data into the Workday supplier platform by using specific tools.
●Proactively problem solving to improve Accounts Payable processes.
●Implementing procedural changes necessary to minimize financial risks, improve service delivery and/or reduce expenses.
●Responsible for drafting project requirements and testing plans.
●In charge of completing user acceptance testing as assigned
MA Rebar Services
Project Accountant (Contract)
10/2016-01/2017
Compliance
●Accountable for the City of Chicago’s Contract Audit Management system. Validating payments received for all city contracted jobs and corresponding with subcontractors to resolve discrepancies
●Responsible for the LCP (Labor Compliance Program) Tracker process
●Managing the process of entering all Certified Payroll in to the system on a weekly basis
●Mastered the Canvass Reporting process
●Tracking and reporting on all Equal Employment Opportunity matters
●Handling the Workforce Data Management process
●Managing the Fair Labor Compliance process for all corresponding government jobs
Job Costing
●Utilizing the TCM program for over 80 projects
●Processing a variety of T&M invoices
●Making sure all jobs are up to compliance with a variety of commercial and government requirements
●Entering/uploading of invoices into various commercial and government applications.
●Maintaining of historical electronic billing files/records (paperless processing).
●Reconciling of labor between DEI and customer timekeeping systems
●Responsible for the Collection procedures based on a predetermined time line.
●Process invoices from procurement, including a review of: - Purchase Orders and Requests - Vendor Quotes - Government Acceptance documentation.
●Financial management of Subcontractor costs and validation of Subcontractor invoices.
●Entering Subcontractor invoices in the accounting system.
●Communicating with Subcontractors on a variety of topics, including invoice status requests
●Reviewing of Job Summary Reports to ensure completeness and accuracy of direct costs.
●Reconciliation of G/L accounts (unbilled receivables, cost accruals, etc.)
●Payroll
●Utilizing the TCM program to track, enter hours, report and process payroll for over 200 Ironworker Journeymen & Apprentices wkly
Morton Salt Inc.
Sr. Accounts Payable Analyst (Contract)
08/2016-10/2016
●Orchestrating the Full cycle Accounts Payable process utilizing SAP
●Processing Invoices for the large and complex accounts
●Currently identifying and reducing discrepancies found in process
●Involved with the conversion and implementation of AP invoicing and documentation retention program
●In charge of the processing of monthly bank account reconciliations
●Responsible for maintaining up to date cash sheets for multiple clients and accounts
●Assisting with Profit and Loss statements
Baker & McKenzie
AR Analyst (Contract)
03/2016-08/2016
●In charge of the Cash Reconciliation team
●Accountable for reducing unapplied aged cash
●Responsible for reducing AR exceptions, automating manual processes, and helping to ensure compliance to all federal/state requirements
●Utilized SAP 4.0 & ERP Systems
●Responsible for immediate identification of any exceptions to normal remittance and outstanding deposit patterns
●Responsible for performing trend analysis on Remittance Processor and Payer exceptions
●Focus was on analyzing unapplied cash, Processor and Payer exceptions,
●In charge of determining root cause and making recommendations for and implementing process improvements with payers, systems and processes.
●Reviewed reports and current procedures, identifying issues, recommending/ implementing process improvements, and ensuring compliance.
●Performed outreach to payers with the intention of converting them to use electronic remittance files and then working with the Cash Remittance Specialist and implementation efforts.
●In addition to supporting the Cash Reconciliation Team, I managed the bulk of action requests and worked closely with the system partners by attending required meetings, reporting defects and following up on the resolution by implementing a short-term solution.
●In charge of controlling bad debt and compliance risks through process enhancements and focused efforts in the timely resolution of
Seyfarth Shaw LLP
Reconciliation Accountant (Contract)
06/2015 – 03/2016
●Utilizing Elite accounting system for reporting and validation
●Corresponding with all levels of the Accounting team to research transactions
●Prepared & submitted Journal Entry requests
●Completed balance sheet reconciliations and looked after the maintenance of fixed asset register
●Handling tasks such as processing general ledger, calculating revenues, and performing reconciliation of balance sheets
●Handling the job of preparing and maintaining statement balances and settlement information
●Shouldering the responsibility of checking and settling accounts in the systems as well as preparing reconciled accounts to pay off
●Handling the work of reconciling company ledger and discharging the management of account files
●Checking and ensuring that the balance cash amounts in accounting ledgers agree with bank balances
HUB International
Research Analyst (Contract)
01/2015 - 06/2015
●In charge of researching payments to be issued for Insurance Industry accounts payable (Premium Payables)
●Utilized SAP & other ERP systems
●Compiled & verified appropriate documents
●Investigated questionable data
●Discovered & adjusted discrepancies
●Documented and Communicated New processes for a more efficient workflow system
●Responsible for obtaining approvals
●Adjusted entries as necessary
●Prepared payment for processing
●Reconciled accounts
Barilla America
Category Analyst (Contract)
12/2013-01/2015
●Participated in an International project
●Coordinated with the America's, Italy & Brazil on various aspects of the project
●Led the Category Management process
●Collaborated with Nielsen to complete
●Utilized SAP
●Gathered uploaded information to generate unique scorecards on a quarterly basis
●Responsible for providing, pulling, generating and publishing results as requested and quarterly
●Monitored TPM's TPO’s, Assortment, Pricing, Share of shelf, Extra Displays and other KPI's
●Mined and synthesized data to assist in driving retailer and companies’ initiatives
●Created syndicated data reports that were utilized on an ongoing basis to analyze and improve business
●Assisted in development of account plans, strategies & priorities to the team
●Provided category development training to others within the organization as needed
●Determined promotional effectiveness through post analysis and made recommendations for core accounts
●Maintained distribution and new item tracking for targeted accounts
●Performed administrative maintenance for syndicated data: refreshing, posting to internal site
●Communicated accomplishments with broader organization through best practice sharing
●Syndicated data utilizing Nielsen Nitro & JDE
Barilla America
Forecasting Analyst (Contract)
12/2013-01/2015
●Utilized Manugistics forecasting software to enter and maintain forecast
●Utilized SAP to run BI reports for comparison and Ad-hoc reporting
●Ran and distributed daily open order reports
●Updated Volume trackers on a daily basis as a reporting tool for the field to stay on target to budget and projections
●Responsible for managing the forecast for the Foodservice business channel
●Ran 6x6 report to fine tune forecast as necessary
●Developed an accurate forecast
●Updated forecast as needed
●Measured their accuracy against actual sales
●Maintained a 10% MAPE & a 3% MPE
Barilla America
Trade Promotion & Deduction Analyst (Contract)
12/2013-01/2015
●Utilized Promo Assist software to manage and track deductions & promotions
●Utilized SAP to clear valid deductions
●·Identified, researched and processed assigned deductions
●Prepare Deduction repay letters against invalid chargebacks
●Maintained deduction management information in Oracle EBS
●Communicated daily with Consumer Division brokers regarding deductions
●Responsible for Weekly and Monthly Deduction Reports
●Responsible to measure, track and communicate data on a regular basis to manager
●Responsible for recommendations of Process Improvements
●Researched and resolve chargebacks
●Performed other related duties as assigned
VCNA-Prairie Materials, Bridgeview, IL
SR. Accounts Payable Analyst (Contract)
06/2013-12/2013
●Processed a high volume of invoices (200 + invoices daily ranging from $5.00-$500,000.00)
●Primary Contact for vendor resolution US & Canadian Accounts
●Managed the Corporate email box
●Ad Hoc reporting provided daily
●Built and maintained relationships between plants and vendors
●Analyzed vendor invoices
●Analyzed PO set up
●Analyzed the integration of the document retention program
●Performed necessary account adjustments as needed
●Applied associated information to the invoice for document retention purposes
●In charge of troubleshooting issues preventing the halt in the payment process
●Implemented and communicated improvements to existing process to ensure a more efficient flow
●Conducted reconciliation of vendor accounts monthly and as requested
Assigned to and completed projects as process
McDonald's Corporation, Oak Brook, IL
Accounting Technician (Contract)
12/2012-06/2013
●In charge of determining proper account codes and keypunching of vendor invoices in a timely and accurate
●manner
●Accountable for the auditing of invoices to ensure that the GAAP was followed and the accuracy of keypunching also making the necessary journal entries/corrections/deletions
●Researched vendor statements to ensure all open items were paid
●Examined voided checks to determine reason for the void
●Frequently contacted Vendors, Presidents, Directors, CEO's, VP's CO's and IT management
●Managed/Maintained the IT Department Authorized Signers List
●Created, updated, added, deleted and distributed personnel from the Authorized Signers Lists for Field, Home Office and Divisional departments
●Responsible for troubleshooting and advising inquirers about the iExpense system process
●Responsible for providing a detailed breakdown of Capital and Expense for Travel and Labor
●Owned and processed the project accounting system & reporting for IT Business, and Restaurants
●Streamlined and improved on existing process
●Controlled the Corporate IT email box
●Accountable for completing the EOM procedures
The Strive Group, Chicago, IL
Core Thematic Accounts Receivable Coordinator (Contract)
12/2011-12/2012
●Managed all aspects of Billing, Pricing and Reporting for Core-Core Thematic-and Straight Thematic jobs which included these specific accounts: Frito-Lay, Nestle and Lava
●Billed/Invoiced & Researched approximately 100-200 invoices daily
●Posted monies that came through for manually billed clients and clients that were on an auto payment plan
●Monitored project shipments to accurately bill clients and report unearned revenue
●Responsible for providing accruals upon request and E.O.M closing
●Researched and resolved billing and pricing issues
Grecian Delight, Elk Grove Village, IL.
Trade Promotion Deduction Analyst (Contract)
12/2010-12/2011
●Responsible for reviewing all promotion requests from the field & Broker Network and enter into Promo Assist.
●Researched and resolved any and all discrepancies/issues surrounding promotions and deductions
●In charge of documenting all programs that highlights all types of exclusions and to follow strict policy.
●Reviewed existing promotions and adjusted in order to keep the system accurate.
●Reviewed and organized customer bill back invoices on a daily basis. Matched the invoices to approved promotions in the system before the deduction is taken. Then followed up with the customer for all unauthorized bill-back and deductions.
●Processed, validated and cleared deductions on a daily basis. Unmatched or unauthorized deductions were immediately re-billed to the customer if appropriate.
●Maintained customer files of promotions, bill-backs and other documentation to provide necessary ready reference.
Dr. Pepper Snapple Group, Northlake, IL
Pricing Analyst-Manager (Contract)
12/2009 – 12/2010
●Pricing Management portfolio included Central U.S
●Vendors in portfolio included Wal-Mart, Kroger, Speedway, Dollar General
●Analyzed all invoices, deductions and customers' claims thoroughly to validate pricing issues and ensure that all data provided were in agreement with the original contract before allowing deduction
●Utilized SAP 6.0 systems along with ABT and Share point portal to research, track and enter invoices in for payment or to clear valid deductions
Kellogg Company, Elmhurst, IL
Deductions Analyst (Contract)
12/2008 – 12/2009
●Deduction Management portfolio included Western Zone of the U.S consisting of 11 states
●Vendors in portfolio included Sysco, Subway and Public Schools, High schools and Colleges.
●Analyzed all invoices, customers claim and deductions thoroughly to validate pricing issues and ensure that all data provided agreed with the original contract before issuing payment or allowing deduction
●Utilized SAP 4.6 system along with Kellogg portal to research and enter invoices in for payment and clear valid deductions
●Generated a correspondence letter to send to vendors/customers as to inform of a short payment of an invoice or a re-bill letter was sent if a deduction was not valid
●Responsible for reconciling, creating, updating and providing account reports along with a status on all assigned accounts
Zurich American Insurance, Schaumburg, IL
Corporate Tax Accountant (Contract)
1/2008-12/2008
●In charge of paying (payables) premium taxes, assessment fees, license renewals and insurance cost stabilizations for eighteen insurance companies in the Eastern Zone of the U.S.
●Gathered all needed documentation before entering invoice information for payment (invoices, previous years filing, state pages, licensing charts etc.)
●Analyzed state licensing requirements
●Responsible for updating and producing trend analysis reports, adjustment tables, account reconciliation and generating a spreadsheet that reflected all the current year's direct written premium information
●Entered all invoices into the system for payment and performed check run
Insurance Auto Auctions, Westchester, IL
Accounts Payable Lead (Contract) 12/2006-12/2007
●Supervised a team of four and in charge of evaluating the work performance of the individuals on my team as well as interviewed and made recommendations for new hires
●Was accountable for full cycle accounts payable for sixteen branches
●Reconciled inner - company billings and balances
●Created a monthly spreadsheet to account for transactions
●Applied the correct branch codes to the invoice then scanned to the branch to obtain a signature of approval
●Coordinated new vendor setup and reconciled statements, complaints and discrepancies
●Applied accurate Cost and GL codes to invoices before entering the system (100+invoices) daily
●Completed check run twice weekly, mailed/FedEx all checks and filed paid invoices
Empire Today LLC, Northlake, IL
Receivable & Reconciliation Expert/Collection Lead Accounts 1/2004 – 12/2006
In charge of a team of six ran/distributed open balance reports and assigned work to the team as well as resolved any issues that could not be handled by the clerks
●Receivable portfolio consisted of 14 markets and two product lines
●Responsible for managing all aspects of the open balance and collection process
●Authorized to charge credit cards, process financing accounts and post checks
●In charge of the research & resolution of errors ranging from data entry to miscommunications on the salespersons or installers part
Contact this candidate