Denise Oneto Email & Phone Number

United States

• Led Business Intelligence activities in stand up of independent company formed from portions of 2 companies' joint venture.
• Developed rules which identified data belonging to AB Sciex, ensuring reporting completeness and continuity and providing details used by ERP team's conversion programs in facilitating melding of 2 ERP systems.
• Validated load of AB Sciex data into data warehouse residing on new company hardware, satisfying separation agreement severing ties and financial commitments to parent companies.
• Designed, developed and implemented new functionality, avoiding need to migrate SAP's BI, another custom data warehouse and Cognos cubes for vendor and revenue analysis, driving estimated savings of $400K.
• Planned, designed and implemented major modification of Business Intelligence environment impacted by 90% change of source data when ERP application moved from SAP to Oracle, ensuring uninterrupted reporting during.

• Led Six Sigma project, improving BI environment which had grown to serve over 1200 users with projected soft savings of $1.5M.
• Collaborated with Customer Quality group in designing and implementing dw enhancements to bring company into compliance to operate in regulated marketplace, resulting in access to additional $5M in revenue.
• Achieved estimated business savings of over $100K per year by designing and implementing metrics in dw and developed Business Objects universe used to automatically generate monthly reporting package for field and.
• Wrote APEX apps with immediate validation, allowing business to maintain external data, freeing up IT resources.
• Analyzed, designed, and headed effort, integrating customer and sales data of acquired company into corporate dw while implementing standards to ensure SOX compliance.
• Facilitated divisive global group representing various disciplines to consensus on quantity measurements by understanding each perspective, presenting commonalities to group and holding sessions to dissect differences.

o Implemented Business Objects, supported 600+ user base, created universes and wrote reports.o Gathered requirements, designed, developed, implemented and supported all facets of ETL process as well designed dw data models resulting in the growth of the data warehouse housing both historical and current data.o SAP Core team member, learned abap code.

o Wrote extractions and load scripts for sales and order data feeds into newly created data warehouse.o Wrote COBOL apps for a new amortization system for Italy and currency revaluation for Switzerland.o Converted General Ledger to CA’s CODA application as company moved to an AS/400 platform.o Continued support for global Treasury, Accounting, and Finance.