Chad Hult

Experience

• 

  Prior Experience - Multiple

  Jan 1999 - May 2001

  Business Intelligence Consultant

  Additional Cognos Professional Service and BI Experience: • Cognos Corporation/Johnson & Michaels - Schaumburg, IL • ARIS Corporation - Bellevue, WA • Oracle Corporation - Atlanta, GA

• 

  TEK Systems/Blistex Inc. || Sapphire Technologies/Duff & Phelps

  May 2001 - Oct 2004

  Cognos Consultant

  COGNOS CONSULTANT May 2001 – October 2004TEK Systems/Blistex Inc., Downers Grove, IL • Member of Strategic Development Group that created reports for Finance, Sales, Marketing, and Demand Planning.• Administered Cognos 7 Impromptu Web Reports, PowerPlay Enterprise Server, Upfront, Access Manager.• Upgraded Impromptu Reports from Impromptu 7.0 to 7.1.• Created, tested and tuned Cognos Impromptu Reports for Impromptu Web Reports.• Performed data validation, catalog development, formatting and tuning using Cognos Impromptu.• Recommended regarding ETL and data architecture for the SQL Server database.Sapphire Technologies/Duff & Phelps, Chicago, IL• Replaced and improved existing reporting system.• Helped with the transition from in-house accounting/reporting system to Princeton Financial Systems.• Epam accounting software and Cognos Impromptu/SQL Server reporting environment.• Created daily/monthly/quarterly client portfolio reports and internal management reports.• Created and Administered SQL Server DTS procedures to receive data via ftp and extract data into SQL Server for reporting.• Trained end users on Cognos Reporting System. Show less

• 

  ServiceMaster

  Jan 2005 - Jan 2007

  Business Intelligence Administrator - Cognos

  • Installed/Administrated/Upgraded versions - Cognos 7(C7), ReportNet, Cognos 8(C8).• Report/Query Studio, Transformer, PowerPlay, Access Manager, Sun One LDAP.• Created installation, security, architecture. administration and development standards documentation.• Used Framework Manager and Report Studio to design custom Cognos user and audit reports.• Supported Windows Admin, Networking, Server Engineers, BI Developers, DBAs, and end user community

• 

  Aetna, a CVS Health Company

  Jan 2007 - Apr 2020

  App Software Delivery Advisor - Business Intelligence Administrator - IBM Cognos Administrator

  Cognos• Installed / Administrated / Upgraded Enterprise IBM Cognos Business Intelligence 7, 8, 10.2.x BI and Cognos Analytics 11.x.• Designed and implemented multi-instance/server/layer, load balanced, fail-over architecture with Disaster Recovery in place.• Created detailed installation, security, architecture, administration, development and deployment standards and documentation.• Provided support, troubleshooting, issue research and problem solutions to Internal Customers as well as External Customer facing applications including Cognos Framework Models/Packages and Reports.• Worked with data warehouse and Cognos developers, DBAs, Users on Cognos best practices.• Supported database and Cognos performance tuning.• Used Framework Manager Models and Packages and Report Studio to develop and tune reports. • Cognos user and system auditing reports.• Used Cognos Java SDK to trigger Cognos Reports.• Used BSP Meta Manager for deployments, documentation and administration.• Developed and tested reports deployed through SDLC (dev/uat/prod).• Environment databases: Oracle, SQL Server, Netezza.• Provided Windows Server architecture and administration.Datameer• Developed Datameer templates for end users sourced from Hive and Hadoop databases• Designed security solution for the Datameer interface.• Tested and promoted templates through dev/uat/prod. Show less

• 

  Magellan Rx Management

  Feb 2022 - Dec 2022

  Lead Infrastructure Engineer
• 

  Prime Therapeutics

  Dec 2022 - now

  Lead Infrastructure Engineer

  Prime Therapeutics and Magellan Rx Management are joining forces to create a brighter future for pharmacy management.