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.
|
|
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