We provide IT Staff Augmentation Services!

Business Intelligence Manager Resume Profile

5.00/5 (Submit Your Rating)

SUMMARY

Business Intelligence Professional with extensive experience in IBM Cognos and Microsoft BI Suite. Experienced in creating end-to-end Data Warehouse and Business Intelligence Solutions. Unique combination of Hands-on experience, Professional Certifications and the ability to adapt to new situations and software.

  • Cognos
  • Report Studio
  • PowerPlay
  • Framework Manager
  • Data Manager
  • ETL
  • Informatica
  • DTS
  • Data Manger/DecisionStream
  • SSIS

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Architect

  • Extracting, Transforming and Loading ETL data using SSIS creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities Data Warehouse, Data mart .
  • Designed many Data Marts as a Business Intelligence Architect
  • Managed School district user requirements
  • Installed and administrated Cognos BI Suite , SQL server 2008
  • Set up permissions to maintain security of the applications using Single Sign-on
  • Developed modules to capture and generate rejected data reports using Cognos.
  • Enhanced my ETL skills by using Cognos Data Manager, Cognos Decision Stream and Microsoft SSIS

Confidential

Business Intelligence Manager

  • Develop Data Mart and Business Intelligence Solutions using Cognos BI Suite for various clients including US School districts, Los Angeles County, Altec Lansing etc. As a BI Manager, my responsibility was to mentor 5 developers. Other tasks included, generating Reports using Cognos Report Studio 8.4 and 10, and Transformer 8.4
  • Created 10 Data Marts at Springfield School District, Missouri
  • Played the role of a Key resource in many Projects for project success
  • Built 28 PowerPlay Multidimensional Cubes at Los Angeles County
  • Designed Cognos Framework Manager models in Cognos 8.4 and 10

Confidential

Cognos Team Lead

  • Lead Cognos development teams to deliver Business Intelligence solutions.
  • Performed Lead role in Projects involving resources spread across continents
  • Led the team to build 20 PowerPlay OLAP cubes in 2 months
  • Designed 12 Cognos PowerPlay cubes and Reports for Micron Technologies

Confidential

Cognos BI Consultant

  • Perform the roles of a Cognos Consultant for various clients in USA. This involved creating end-to-end Data Warehousing and Business Intelligence Solutions for the clients.
  • Saved Cognos Project at Ferguson, Newport News
  • Designed 5 Data Marts for customers using SQL Server DTS at Altec Lansing,Milford,PA
  • Managed the Year-end Process at Fisher Price in Buffalo,NY
  • Developed and Deployed reports in MS SQL Server environment using SSRS-2005

Confidential

Senior Software Engineer

  • Develop Software for various clients. Also part of the Cognos Implementation team inside the company.
  • Migrated 6 Years of data from UNIFY to Oracle 7 for SIDBI, India
  • Migrated Insurance Data into Oracle 7 at Irish Life
  • Built many Cognos Impromptu Reports and PowerPlay cubes for different businesses
  • Trained many computer professionals on Cognos Software

Confidential

Data Processing Superintendent

  • Manage the Software requirements of the Stores department for the Coach Factory
  • Installed and created Oracle Database in Oracle 6
  • Wrote many UNIX Shell Scripts

TECHNICAL SKILLS

  • Database Server: MicrosoftSQLServer2008,SSAS,SSIS,SSRS,Cognos 8,4/10, Oracle6/7/8/9i/10g,DB2, Informix, Sybase
  • Operating System: Windows, UNIX, Windows NT, Vista, Linux
  • Programming Languages: Cobol, C, XML, SQL, HTML, Java, HTML, Hadoop
  • Development Tools: Visio, Visual Studio, Cognos BI suite, Informatica
  • Source Control: Visual Source Safe 2005 and 2003
  • Web Server: IIS, Apache Tomcat

We'd love your feedback!