Russ Karlberg

Current

• President at Mobile Software, Inc.

Past

• Consultant at Bain Capital
• Consultant at Bristol-Myers Squibb
• Consultant at Jordan’s Furniture

• Consultant at Cadbury Schweppes
• Consultant at Fatum Caribbean
• Consultant at Bayer Pharmaceuticals
• Consultant at Toys R Us
• Consultant at Bank of America
• Consultant at Northeast Utilities
• Consultant at Scudder Kemper Investments
• Tech Support at Pilot Software
• Consultant at Synetics

see less...

9 more...

Education

• Massachusetts Institute of Technology
• Clarkson University

Connections

66 connections

Industry

Information Technology and Services

Russ Karlberg’s Summary

Project Manager, System Architect and senior developer in a wide variety of business applications. Particularly interested in Business Intelligence systems using Applix TM1 or Hyperion Essbase. Also interested in using our web based BI and dashboard software to create interactive user interfaces for customers, partners and other software companies. Advanced knowledge of Business Intelligence, Multidimensional databases, data warehousing, Portals and Dashboards.

Russ Karlberg’s Specialties:

16 years SQL databases (Oracle, SQL Server, DB/2, Access)
16 years OLAP Databases (Hyperion Essbase, TM1, Analysis Services)
10 years BI Reporting (Hyperion, SAS, MicroStrategy, Reporting Services)
10 years programming (Visual Basic for Applications (VBA), C++, Java, .NET)
16 years Business Analysis - Translating high level needs into viable solutions

Russ Karlberg’s Experience

• President

  Mobile Software, Inc.

  (Information Technology and Services industry)

  Currently holds this position

• Consultant

  Bain Capital

  (Information Technology and Services industry)

  January 2006 — December 2007 (2 years)

  Developed a Cognos/Applix TM1 application for analysts to make up-to-date recommendations that provide an evaluation of securities currently held, historical views and anticipated market trends. This project required above average expertise due to the large number of TM1 processes, rules and attributes applied to a large scale daily SQL Server data warehouse using ETL programs built in Microsoft SSIS. The completed system consisted of a customized web interface, public and private report creation, extensive analytical capabilities and fully automated TM1 data loading and dimension creation.

• Consultant

  Bristol-Myers Squibb

  (Public Company; 10,001 or more employees; BMY; Pharmaceuticals industry)

  May 2005 — December 2005 (8 months)

  Worked in a support role to assist users and developers with TM1 issues. Created new programs, processes, cubes and reports based on user requests. Revised and upgraded Arcplan reports. Automated and documented numerous production tasks.

• Consultant

  Jordan’s Furniture

  (Privately Held; Furniture industry)

  December 2004 — May 2005 (6 months)

  Conducted user requirement interviews. Composed detailed functional and technical specifications as well as project plan for Accounting Department. Wrote ETL scripts to extract data from Oracle for 3 TM1 cubes (Sales, Inventory and Expense). Created Phase 1 Reporting according to user requirements. Delivered scope document for Phase 2 project (additional reporting and data extraction). Wrote Excel VBA macros to automate reporting.

• Consultant

  Cadbury Schweppes

  (Public Company; 10,001 or more employees; CSG; Consumer Goods industry)

  April 2002 — November 2004 (2 years 8 months)

  Worked with the Financial Reporting and Planning Groups to create TM1 cubes and reports. Helped build the new finance systems structure for the combined Cadbury Schweppes Americas Beverages Unit. Instructor for end-user training sessions. Wrote Excel VBA macros for an automated menu system for end users.

• Consultant

  Fatum Caribbean

  (Privately Held; 10,001 or more employees; Insurance industry)

  June 2004 — August 2004 (3 months)

  Installed Hyperion Analyzer, EIS, Reports and Essbase. Worked with the Finance department to automate all accounting reports in Hyperion Essbase. Built several cubes containing data from the mainframe general ledger system. Also created automated reporting system with Excel VBA and TM1 functions. Performed knowledge transfer with IT dept. so they could maintain the cubes.

• Consultant

  Bayer Pharmaceuticals

  (Public Company; 10,001 or more employees; BAY; Pharmaceuticals industry)

  January 2004 — May 2004 (5 months)

  Worked with the Marketing department to automate all sales reports using TM1. Built several cubes containing data from the 3rd party data supplier. Created an automated reporting system with Visual Basic which extracts TM1 data and emails customized reports to 1600 users. Performed knowledge transfer with IT dept. so they could maintain the cubes.

• Consultant

  Toys R Us

  (Public Company; 10,001 or more employees; TOY; Retail industry)

  January 2000 — December 2003 (4 years)

  Worked with Intranet sales reporting team, as well as designing the subsequent reports. Created brand new Web front end using Analyzer and Mobility, incorporating additional functionality not publicly available through other reporting vendors. Optimized Hyperion Essbase cube structure, dimensions and configuration. Extracted data from DB/2 into a data warehouse.

• Consultant

  Bank of America

  (Public Company; 10,001 or more employees; BAC; Banking industry)

  January 1999 — December 2002 (4 years)

  Worked with the Finance group to optimize their MicroStrategy and Hyperion Essbase applications. Also created new cubes to offer Account Planning information. Optimized outlines, data storage, calculations and created data loading scripts. Created new Web based reporting system for both the Finance and Account Planning applications. Wrote a Visual Basic program to extract data from emails and move it into a database.

• Consultant

  Northeast Utilities

  (Public Company; 5001-10,000 employees; NU; Utilities industry)

  January 1998 — December 2001 (4 years)

  Worked on a team to design executive information system (EIS), incorporating a link between Hyperion Essbase and the Pilot Lightship front end. Created and developed the front end EIS. Designed all aspects of multiple Essbase cubes, including scripting, outline design, calculations and load rules.

• Consultant

  Scudder Kemper Investments

  (Public Company; Information Technology and Services industry)

  1998 — 2000 (2 years)

  Responsible for Cognos and Brio project management of EIS/DSS and Client/Server systems. This includes setting user expectations, establishing the business requirements and designing all aspects of client/server implementations for OLAP products. Responsible for assisting the VP/project leader with all aspects of data analysis, data transformation, database design, multidimensional database creation, front end software configuration and report creation.

• Tech Support

  Pilot Software

  (Information Technology and Services industry)

  1990 — 1992 (2 years)

  Provided technical support for Pilot's LightShip product. Assisted customers in resolving various technical issues. Visited customer sites to address critical problems. Worked with developers to identify software defects.

• Consultant

  Synetics

  (Information Technology and Services industry)

  1988 — 1990 (2 years)

  Member of the techincal staff; worked on various company contracts for customers such as the State Department in Washington, D.C.

Russ Karlberg’s Education

• Massachusetts Institute of Technology

  B.S., Cognitive Science, 1983 — 1988

• Clarkson University

  1982 — 1983

Russ Karlberg’s Contact Settings

Interested In:

• career opportunities
• consulting offers
• new ventures
• job inquiries
• expertise requests
• business deals
• reference requests
• getting back in touch