SUZANNE M. BIGGIE

• As well as continuing my duties as a business intelligence specialist (below), I completed a 60-day detail as a technical lead.
• Mentored junior developers by providing guidance on best practices, coding standards, and career growth opportunities.
• Maintained close communication with sites throughout project life cycles for accurate progress reporting and prompt issue resolution.
• Assisted Data Modelers with design questions and technical needs through regular, weekly meetings.
• Ensured timely project delivery by prioritizing requirements based on enterprise value and user feedback.
• Resolved ambiguities in user requirements, promoting clarity with data modelers, and reducing rework efforts.

• Updated and developed mapping scripts and queries to extract and analyze data from multiple sources.
• Developed and generated ad-hoc and customized reports in BOE/IDT to evaluate specific business requirements for the COMFRC enterprise.
• Analyzed data in the datamart and in BOE reports to identify root causes of problems and recommend corrective actions.
• Collaborated with system architects, data modelers and others to understand COMFRC and industry requirements.
• Identified and described relationships between data fields in enterprise databases.
• Employed vast knowledge of relational database concepts and Oracle PL/SQL coding to produce data marts and BOE reports.
• Mapped data between source systems and warehouses using Erwin and Excel.
• Assessed business analytics and functions, devising targeted data storage solutions using Oracle SQL to design efficient systems for BOE reporting.
• Monitored resolution of bugs, tested fixes and helped report developers tackle ongoing problems.
• Advised DBAs/ETL team on problems with databases, performance and other issues.
• Converted and Migrated Reports/BO Universes to support NERP effort
• Improved business direction by prioritizing customers and implementing changes based on collected requirements.
• Worked with Scrum team to test and certify BOE reports and data modeling changes before deploying to production.
• Operated under Agile and Scrum frameworks to complete releases and well-organized sprints.
• Cultivated interpersonal skills by building positive relationships with others.

Maintained 24 Hour Fitness Team Member Profiles by:

• Auditing all current employees to ensure they had the correct profile within the payroll department
• Automated maintenance process and cut daily work from 4 hours to a few minutes in an Access database
• Uploaded all new hires and profile changes into ADP each day
• Ran reports in ADP to obtain the current status and profile of each Team Member
• Assisted with testing advanced scheduler in ADP by ensuring that all time was correctly entered by state
• Looked at identifying issues in regards to sick time, overtime, split shift and vacations then documenting them
• Researched Team Member issues in regards to accruals, job effective dates, and profiles within the ADP system.

• Continually improving on relationships with the business
• Working with finance and accounting on gathering and creating report requirements in line with industry best practices
• Managed and organized reporting team’s projects by employing Agile Methodology (Jira)
• Designed and developed customized extract, transform and load (ETL) applications per client specifications for Qlik reporting.
• Assisted in migrating financial reporting an upgraded version of Oracle
• Proposed and assisted a new data mart for financial reporting out of our billing system
• Delivered agreed upon enhancements for billing Data and Reporting as part of the release process.
• Managed product backlog and supported Scrum framework for monthly sprint releases.
• Monitored program compliance by following up on assignments to drive execution.
• Utilized data visualization tools to effectively communicate business insights.
• Worked with business intelligence software (Business Objects and Universe Designer) and various reports to glean insights into trends and prospects.
• Analyzed transactions to build logical business intelligence model for real-time reporting needs.
• Collaborated with business-unit leaders to identify and prioritize problems.
• Created tables, materialized views, views, stored procedures and functions using Oracle SQL for accurate reporting and automated reporting used to make strategic decisions.

• Performed daily reconciliations for all system hand-offs throughout Order to Cash system environments
• Responsible for reporting and communication of critical order statistics and issues to key finance stakeholders
• Handled troubleshooting order flow issues to resolution
• Assisted in the testing of Accounts Receivable converted data and functionality in Oracle prior to implementation
• Was trained in order management, accounts receivable and general ledger responsibilities within Oracle
• Created reporting that shows orders that did not transfer from one system to the next for Intuit’s business units
• Also developed reports that show the flow of units and dollars at the time the order was taken all the way to time the invoice was posted to the general ledger
• Developed ad hoc reports as needed for accounts receivable, sales taxes, SOX and GL
• Developed several Business Objects universes for call center analytics and SIEBEL order exceptions
• Automated various reporting functions for accounts receivable, GL, and Order Management
• Responsible for universe modifications and report development.

• Responsible for posting journal entries and for reconciling Revenue at month end.
• In charge of the posting of the cash receipts journal entries and application of cash to the accounts receivable accounts.
• Handled the reconciliation of fixed assets. Entered new assets as they were bought throughout the month. Posted depreciation during month end close. Accounted for the sale or disposal of assets.
• Reconciled the accounts receivable accounts for both Local Exchange Carriers and Direct Customers.
• Accurately booked journal entries for bad debt and USF cost credits.
• Posted state and federal tax liabilities at month end.

• Supervised five employees that claim approximately $50 million per year to the company’s four largest vendors for discounts given and passed on to resellers
• Duties included creating and updating internal reporting for senior management on rebate programs that Ingram participates in
• Responsible for the reconciliation of vendor statements and obtaining payment for vendor rebate programs
• Reconciliation of vendor funded general ledger accounts used for each vendor program and prepared journal entries for month end closing
• Posting and accurate application of vendor payments in the Ingram’s system
• In charge or participated in about twenty five inventory audits throughout career with the company.

• Responsible for posting journal entries and for reconciling Revenue at month end
• In charge of the posting of the cash receipts journal entries and application of cash to the accounts receivable accounts
• Handled the reconciliation of fixed assets
• Entered new assets as they were bought throughout the month
• Posted depreciation during month end close
• Accounted for the sale or disposal of assets
• Reconciled the accounts receivable accounts for both Local Exchange Carriers and Direct Customers
• Accurately booked journal entries for bad debt and USF cost credits
• Posted state and federal tax liabilities at month end.

• Worked in conjunction with the Product Management department to ensure that purchase rebates and discounts were accurately booked in accordance with General Accepted Accounting Principles (GAAP)
• Responsible for booking rebate receivables, collecting and applying credit when received from the vendor
• Used models to accurately book rebate income on a quarterly basis and prepared journal entries for month end closing
• Performed the reconciliation of rebate receivables and unearned rebates/discounts
• Assisted in year end audits to show proof of proper income recognition and accurate booking of rebate receivables in compliance with General Accepted Accounting Principles.

• Responsible for claiming price protections reducing the cost of inventory to, for payment
• In charge of matching/posting IBM’s credits with Ingram’s debits and reconciling the various IBM general ledger accounts
• Prepared journal entries for month end closing
• Improved relations and increased communications with IBM by learning their credit issuing policies and procedures.

• Billed some vendors for these marketing activities on an Oracle based program
• Posted debit memos to the vendors if necessary
• Prepared journal entries for month end closing
• While in this position, saved the company over one million dollars by discovering a systems problem
• Improved the efficiency of the reconciliation process by the creation of several Access databases containing general ledger account data
• Worked together with the Information Technology Department in the development and implementation of a newly created automated billing system.