Sean Heinle Email & Phone Number

Pittsburgh, Pa, Us

Pittsburgh, Pennsylvania, United States

Pittsburgh, Pa

For a Fortune 500 CPG company, I am the Senior Business Analyst and Data Warehouse Architect for analytics on a project to replace a trade promotion management application (Oracle Siebel TPM to Accenture CAS).

Pittsburgh, Pa

Manage a team of 3 BI developers. The team leads the development of reporting data models in the EDW/data marts. These models are presented in Cognos and Tableau. The team also supports daily operations and administration of Cognos, Tableau and SAS tools.- Prioritize BI requests based on value delivered to the organization- Star/snowflake schema reporting model architecture and design- Provide guidance for delivering self-service BI capabilities

Greater Pittsburgh Area

ERP replacement project that made it necessary to completely redevelop the data warehouse from scratch. I had the opportunity to participate. The new BI environment used Oracle 11g and Cognos 10.2.1. I also managed an OBIEE 11g environment for Trade Promotion reporting that sourced from Oracle Siebel.- Develop Framework models for business groups including Sales, Demand Planning, Production Planning and Inventory Control, Customer Service and Trade Spend Management among others. Most Framework models used DMR to mimic OLAP functionality.- Participate in star/snowflake schema reporting model architecture and design- Act as a Business Analyst to gather requirements from all different business groups- Reverse engineer legacy Informatica ETL and PL/SQL packages to gather requirements- Support OBIEE 11g reports, reporting models and environment.- Train business groups on Cognos models and tools- Developed static reports using Report Studio

Greater Pittsburgh Area

- Designed data warehouse star and snowflake reporting models on SQL Server 2005 database- Used Informatica to develop ETL process to load ODS tables, archive application data and maintain reporting models- Maintain statistics, index rebuilds and database settings to ensure optimal query performance- Responsible for data warehouse batch maintenance and support- SQL and Database tuning to improve batch and report query performance- Developed BI models and reports using all Cognos tools

Pittsburgh, Pa

- Designed data warehouse star and snowflake reporting models on an Oracle 10g/11g database- Developed BI models using Cognos Framework Manager (ROLAP) and Transformer (OLAP)- Developed BI reports using Cognos Report Studio and Business Insight Advanced- Used Informatica to develop ETL processes to load data warehouse models- Worked directly with Customer Service, Sales and Sales Finance business customers to gather requirements and develop excellent solutions as a team.- System administrator for Cognos including server configuration, upgrades, maintenance, security.

Pittsburgh

- System administrator for Mobius document archiving software (Windows, SQL Server)- System administrator for Kofax scanning OCR software (Windows, SQL Server)- Upgraded both the Mobius and Kofax systems without bringing in consultants for each, which was the previous standard, saving Del Monte Foods over $70,000- Support Order Entry module in BPCS ERP (AS400, RPG)- VB.NET application development

- Attended quarterly ITIL seminars with the Pittsburgh itSMF USA group

-Migrated applications and data from VAX OpenVMS to ALPHA OpenVMS servers.-Performed analysis, planning, testing and implementation of migration project.-Configured newly implemented Cisco Aeronet wireless network across campus.-Documented new HR service via Visio diagrams for IT Service Operations.