Audrey A. Email & Phone Number

Hillsboro, Or, Us

Delivering data warehousing and BI as a service to small and medium sized businesses.

Lake Oswego, Or

Portland, Oregon Area

New Season's Market - Senior SQL/BI Reports Developer• Build SQL Server based data mart to streamline and expand reporting capabilities, and prep for EDW project • Design star schema for Power BI tabular models• Develop SSRS reports • Develop Power BI data models, reports, and dashboards• Train users on Power BI

Hillsboro, Or

• Report development and delivery in SSRS (2008-2016) • Database development in SQL Server (2008-2016) for internal application projects • Commission processing and GAAP calculation automation and migration from Excel to SQL Server• Project coordination, process mapping, requirements gathering for reporting and automation projects• Design/build/implement/administer data warehouse for finance and operations• Design/build/maintain ETL pipelines for data warehouse• Design/implement/ administer Power BI gateway, data models, reports, dashboards, etc.• Train analysts in SQL and Power BI• Develop data audit procedures for SOX compliance

Portland, Oregon Area

• Data! Map it, import it, analyze it, scrub it, transform it, migrate it, synchronize it, deliver it.• Develop stored procedures for custom reports• Work with account managers and clients to define requirements for migration and reports• Coach coworkers in advanced SQL functions and best practices to improve data delivery• SQL Server 2008/Access platform

Portland, Or

• Map and migrate client data from existing system to Ajera software in a SQL Server 2008 environment• Participate in internal development efforts to standardize and automate conversion and QA processes. • Team with implementation consultants and clients to gather requirements for data migration

Riverton, Wy

-Operational accounting including, A/P, Credit Card reconciliation, Fleet account reconciliation, payroll preparation -Project Cost Accounting (time, materials and expense activity based system)-Project support and admin; assist Billing with project time and expense accrual questions-Support Executive team and assist with ad hoc projects and IT infrastructure upgrade -Mined Access database that was collecting data but not returning information. -Developed set of reports and KPI to show current trends vs profitability threshold and measure the rate of proposals vs bid wins.*Special project for O&G client. Developed Access database to track equipment/process downtime at natural gas plant. Designed data input forms for non-technical staff, data outputs in the form of reports and graphs for process engineers and documentation for the sys admin.

Riverton, Wy

-Train, support and supervise staff of 2 accounting clerks; Assist Controller with ad hoc projects-Assist controller and other Sr. Accountant with month end close activities and reporting-Process, reconcile and analyze sales commissions-Analyze and prepare plant payroll-Manage customer credit. Devised a “credit builder” program for small, struggling or brand new companies that would otherwise not have the opportunity to sell our products. -Streamline billing and collections process to reduce overdue invoices to < 1% of total AR -Analyze and improve EDI process to reduce errors resulting in chargebacks and increase successful challenges to chargebacks. -Manage online transactions for retail websites. Implemented daily monitoring and reconciliation to prevent revenue loss and reduce chargebacks from online processing company.

Riverton Wy

-Operational accounting including, A/P, Credit Card reconciliation, Fleet account reconciliation, payroll preparation -Project Cost Accounting (time, materials and expense activity based system)-Project support and admin; assist Billing with project time and expense accrual questions-Support Executive team and assist with ad hoc projects and IT infrastructure upgrade -Mined Access database that was collecting data but not returning information. -Developed set of reports and KPI to show current trends vs profitability threshold and measure the rate of proposals vs bid wins.*Special project for O&G client. Developed Access database to track equipment/process downtime at natural gas plant. Designed data input forms for non-technical staff, data outputs in the form of reports and graphs for process engineers and documentation for the sys admin.

Trevose, Pa

-Train, support and supervise staff of 4-Develop and produce monthly/quarterly financial statements, royalty and commission reports, and management fee calculations; ad hoc analysis for CPA as needed-Managed inventory, remote warehouse and EDI processes-Analyze EDI process; Implemented 2 solutions to reduce chargebacks.-Restructured general ledger to ensure more accurate reporting and made recommendations for future software needs

Nj/Pa

-Analyzed boxes of shipping documents to ferret out missed revenue for short term project.-Subsequently hired to build and manage accounting system for affiliate-Set-up new accounting system procedures and software, train warehouse staff, manage all accounting functions from data entry to consolidated financial statements and account reconciliations; -Manage asset based lending and external audits-Assisted CFO of sister company with a GL restructure and clean-up project to improve GL reporting accuracy -Brought to parent company as controller and to assist new CEO brought in for turnaround project. -Managed staff of 4 while focusing on heavy cash management, asset-based lending management, analysis and due diligence activities for the turnaround/sale of the parent and a sister company.