Deliver focused analytic solutions to internal partners providing intuitive tools with insightful information to make data-driven business decisions. Provide leadership for Data movement and participate in development using QLIK Replicate, Informatica PowerCenter, Azure Data Factory, and Azure Databricks. Develop foundational Python notebooks to aid in adherence to standards across a global development team. Assist in rollout of devops platform using GitHub and Azure DevOps pipelines. Build partner facing tools using Tableau, PowerBI, and Excel PowerPivot. Participate in the full lifecycle of BI Development from requirements gathering, to solution design, to data movement development, to presentation development.

Develop ETL using Pentaho Kettle, including developing custom java plug-ins. Migrate DW database to PostgreSQL. Participate in design for new data marts and DW enhancements. Develop user front ends with SQL Server Analysis Services and SQL Server Reporting Services. Prototype new user front ends. Installation, Configuration, Administration of Cognos environment. Develop Cognos frameworks and reports to answer everyday business questions.

Responsibilities include: Oracle Warehouse Builder development and day-to-day monitoring for Data Warehouse project, Cognos administration including framework maintenance, report creation, PowerPlay cube creation and end-user support, create SQL Server and Oracle queries as necessary to supplement data available via mainstream reporting.

Responsible for Discoverer Relational end-user Administration for the Foodservice group. Integrate Oracle E-Business Suite data into user-friendly Discoverer reports. Conduct end-user training as necessary. Debug Oracle PL/SQL stored procedures and materialized views.

•Lead developer for Sales Reporting applications for Unilever Ice Cream (approx 2B in Sales). Assessed executive and field sales needs and developed a Discoverer OLAP application to replace the aging Oracle Sales Analyzer application. Developed training materials and led user training courses. Reviewed end-user needs and created reports using Discoverer OLAP web application and Microsoft Excel OracleBI plug-in as necessary.•Developed and maintained Sales reporting Data Marts sourced through a Data Warehouse environment using Oracle Warehouse Builder. Created End User Layers and reports using the Discoverer Relational application.•Created a web-based (ASP) report submission and creation process against an Oracle Database. Used a PowerBuilder application to create high-fidelity reports in PDF format and made the results available via the web for ease of access.

•Created SAP ABAP extracts, Oracle SQL Loader control files, SQL scripts and UNIX shell scripts to support the Oracle Sales Analyzer application. Fully automated the nightly update and quarterly rebuild processes via UNIX shell scripting. Responsibility for nightly update process.•Developed PL/SQL procedures for interfacing Trade Spend information from a proprietary Trade Spend application to SAP.•Maintained a proprietary PowerBuilder asset tracking system including troubleshooting transactional issues, developing new reports, adding functionality including repair tracking, billing and order processes. Developed warehouse asset tracking system on Percon Falcon hand-held scanners.

Assisted Credit department with filing and researching customer deductions for damaged goods. Deduction research involved working with various transport companies to acquire appropriate paperwork. Made collection calls on past due invoices. Maintained a ledger of accounts termed National Accounts researching deductions and cash applications.

Assisted the Microsystems Support Specialist in troubleshooting faculty member’s PC problems. Installed various software and extended existing C programs.

Assisted Credit department with filing and researching customer deductions for damaged goods. Deduction research involved working with various transport companies to acquire appropriate paperwork. Made collection calls on past due invoices. Maintained a ledger of accounts termed National Accounts researching deductions and cash applications.