Cognos Resume Sample Three

Mark Jones

PROFESSIONAL PORTFOLIO

Top secret clearance
Expert experience in Business Intelligence and Data Warehousing
Certified IBM COGNOS Developer, Architect, and Administrator
Certified IBM COGNOS Report Studio, Query Studio, Analysis Studio, and Event Studio
Certified IBM COGNOS GO Dashboard! And Scorecard
Certified IBM COGNOS Framework and Transformer
Certified and experience in Oracle Business Intelligence Enterprise Editions OBIEE
Expert experience in Business data analysis and Data Warehouse
Over ten years of successful experience in Information Technology applications
Over ten years of technical training experience
Experience in Federal financial management system
Experience in project management Professional and project leadership
Finely honed leadership and interpersonal skills; adept at working independently and as a team member
Proven ability to work efficiently under pressure on several projects simultaneously

AREAS OF EXPERTISE

Business Intelligence Enterprise • Project leader
COGNOS Business Intelligence • Written and oral communication
Oracle Business Intelligence Enterprise Edition • Workforce development
Information Technology Project leadership • Team building
Strategic planning and leading change
Data Modeling techniques and methodology
Dimensional modeling and data cube building
Technical trainer for the corporate world • Achieving end result quickly and efficiently

EMPLOYMENT HISTORY

Cognos Developer – ABC Inc Mar 2010 – Present

Working on Cognos 8 implementation for Default Data Group.
Design and validate Cognos Power Play cubes for mortgage analysis including Loss Mitigation, Foreclosure, and Bankruptcy.
Mapping and testing common dimensions and new fact data sets.
Define valid values and maintain in SAS format files.

Sr. Programmer Analyst – XYZ Corp Dec 2007 – Mar 2010

Automated daily sales reporting process by migrating 50+ reports from a manual process in MS Access to a more robust streamlined and secured Report net platform.
Interacted with clients to understand the reporting needs, evaluated requirements, designed, developed and implemented reporting deliverables using Power play Cubes and Report net reports. Provided ad-hoc reporting support.
Migrated Cognos Cubes and Report net reports from an internal database system to an outsourced system. Researched and identified required report elements and gaps against new data sources.
Optimized Impromptu queries and cube build queries and provided strategies at the database level and Cognos reporting tool level to improve performance.
Identified problems and limitation with current Cognos environment, addressed technical issues, applied hot fixes.
Administered Cognos environment including Report net, Enterprise Server, and Access Manager.
Provided 24/7 remote on-call operational support for the reporting application. Resolved production outages. Assisted and supported other applications for which the group is responsible for.
Created procedures, wrote shell/batch scripts, created production control documents and scheduled jobs in enterprise automation software.
Provided user training on Report net reports and Power play cubes.

Sr. Cognos BI Consultant – BCD Inc June 2006 – Dec 2007

Installed and configured various components, such as the Framework Manager and Content Manager.
Developed and maintained Development, UAT and Production server.
Developed and Implemented Best Practices (Development Standards, Modeling Standards & Security Model).
Installation and Configuration of Cognos BI Server and Power Play Transformer on Windows Sandbox.
Involved in gathering the functional requirements for financial budgeting, forecasting and related reporting and analytics requirements.
Developed Multidimensional Models in Power-Play Transformer and generated Power Cubes for OLAP comprising of dimensions, hierarchies, levels, categories, and measures in Cognos 8.4.
Worked closely with the business users to build the models and delivered based on the sign-off.
Modified Power Cubes by adding new Dimensions, Levels, Categories and Measures.
Extensively worked on Validating and testing report in Query Studio and Analysis Studio.
Created different Dashboards in report studio using combination of List, Crosstab, and Graph and Map reports.
Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
Developed user acceptance documentation and placing Screen shots of actual Report and tested report in documentation.
Extensively worked on SQL, created joins between huge tables to map the columns from multiple tables.
Tracked the weekly bug or issue report updates from the developers in the form of the QA Error Log.
Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager.
Led team meetings, providing status and defining go-forward approach based on achievable results.
Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
Extensively worked on call support by coordinating and maintaining offshore team.
Worked extensively to Achieve the Performance and Tuned SQL Queries and Stored Procedures, improved the performance of the reports.
Provided Production support through problem analysis and resolution to correct deficiencies.
Developed Balanced Scorecard and executive dashboards, as means for measuring activities and outcomes for effective performance management.
Involved in review sessions and demos with business users and draft design and solution
Responsible for various tasks including user communication, follow ups, reports and Power cubes development, testing, document preparation and moving components into different environments.
Used Cognos Metric Designer to populate the application by transferring information from relational and dimensional data sources.
Used Metric Studio score cards extensively to track the Finance and sales Metrics such as revenue, margin and customer growth.
Trained power users to use Query Studio for Ad-Hoc reporting and Analysis Studio.

EDUCATION

2006 – Bachelor of Science Degree in Computer Science, University of Maryland, College Park
2007 – COGNOS 8 Report Authoring Part I ∧ II
2007 – COGNOS 8 Data Modeling and fast track Part I and II
2007 – COGNOS 8 Data Modeling and Design Part I and II
2007 – COGNOS 8 Content Administration
2007 – COGNOS 8 Server Administration

OTHER ACHIEVEMENTS and AWARDS

PROFESSIONAL MEMBERSHIPS AND ASSOCIATIONS

Click to download the Cognos Resume Sample Three in PDF.

Jeff the Career Coach