Cognos

•

Khurram Nawaz Status: US Citizen

Email: *********@*****.***

Phone: 980-***-****

Summary

Over 6+year of experience in IT includes extensive Functional and Technical

•

experience in Business Intelligence (BI) product development and Reports Generation.

Expert in Business Intelligence Applications using Cognos Tools such as Cognos BI

•

8.0, 8.3, 8.4, 10.0, 10.1, 10.1.1, 10.2.1

Star Schema and Snowflake Schema used in relational, dimensional modeling.

•

Generated different kinds of reports list, crosstab, graph, map and created templates.

•

Experience developing Active reports, complex reports using drill-through reports, prompts, dashboards, master-detail, burst-

•

reports, dynamic filtering in Cognos..

Involved in full life cycle of Data warehouse Projects major deals with forecasting,

•

demand, primary and secondary sales analysis, HR Payroll analysis, and cost variance analysis .

Experienced in creating Multi-Dimensional Cubes by using Power play Transformer.

•

Extensively used Framework Manager for model design and Using Analysis Studio,

•

Query Studio, Report Studio for ad-hoc, can and advanced report authoring.

Involved in designing of Relational and Dimensional Model in FM using different databases for creating Models, Packages,

•

calculations, and publishing packages.

Experience in Cognos Administration, Security, roles and groups for authentication, Content Administration and Deployment.

•

Developed Active reports for IPAD, iPhones as well as Blackberries using the Cognos

•

Mobil application.

Extensively used RDBMS like Oracle, SQL Server and DB2 for developing different applications.

•

Experience working in the functional domains of Insurance, Health Care, Education,

•

Finance and Mortgage.

Performed user acceptance testing and end user training for Cognos Users. Involved

•

in Data validation and testing procedures. Fine-tuned and enhanced queries for the performance of the

reports.

Involved in gathering of business requirements Documented them technically with

•

all phases of SDLC life cycle.

Translate business requirements into technical specifications.

•

Mentored and trained users for the successful execution of the project.

•

Self-motivated and possess excellent critical thinking ability, good interpersonal and

•

communication skills, team-oriented.

Ability to work under stringent deadlines with teams as well as independent.

•

•

Technical Experience

BI Tools:

IBM COGNOS 10.2.1 COGNOS 10.1.1Cognos 8.4, Cognos 8.0 BI: Active report, Cognos Work Space, Cognos

Work Spaceadvance, Framework Manager, Report Studio, Metric Studio, Event Studio, Query studio,

Analysis Studio: COGNOS connection, Cognos Mobil, COGNOS Power Play Transformer, Power Play User,

Power Play Enterprise server, Upfront, OLAP cubes, STAR SCHEMAS and SNOW-FLAKE SCHEMAS,

Cognos Mobil, ETL Informatica

Operating Systems: Windows 95/98, Windows NT 4.0, Windows 2000/XP, Windows 7 professional.

Languages: SQL, HTML, XML, XHTML

Databases: DB2,Oracle 10g/9i, SQL Server 2000/0203/2008 R2

Software Packages: MS-Office 2007,2010 Microsoft Word, Excel and Power Point, JIRA, SharePoint.

Experience

July 2014 to

Bank of America Plano, Tx

Present

Cognos Developer & FM Modeler 10.2.1

• Analyze reporting requirement.

• Develop views to get the desired output as business needed.

• Worked on Framwork modeling and reporting.

• Worked on Report studio 10.2.1, Qurey Studio and Workspace advance.

• Developed Active reports for Ipad using workspace (Dashboard).

Environment: Cognos 10.2.1, Framework Manager, Cognos Connection, Report Studio, SQL server,DB2

Sep 2012 to

EngagePoint, MD

June 2014

State of Missouri MEDES (Missouri Eligibility Determination & EnrollmentSystem)

Cognos Developer 10.2.1

Interacting with the End users on a regular basis for resolving issues pertaining to the reports

•

• Developed Standard Reports, List Reports, Cross-tab Reports, Charts, Multiple-levels of Drill through Reports and Master Detail

Reports Using Report Studio.

• Developed Ad-Hoc reports using Query Studio.

• Developed Variables for Complex Formatting Reports.

• Developed cascading prompts in Report Studio to help users refine their search.

• Involved in Admin Tasks Like Maintaining Portal, Assigning Securities, Scheduling Reports.

• Involved in the development team to USL ( Universal Semantic Layer) development and for design and connectivity with FM.

• Testing the Report that is to be set to the client by following the guidelines

• Responsible in the setup of Cognos Security. Setup of User Groups, Roles, Etc

• Created reports using different prompts like value, date and time and text box prompt to add interactivity for the user

State of Maryland HIX Project ( Health Care Exchange)

Cognos Developer 10.1.1

• Day to day support of the Cognos applications which includes data updates.

• Creating data modeling solutions to support HIX analytic requirements.

• Building dashboard-style reports combining list, cross-tabular, and chart displays to give executives an

“at-a-glance” look at the results of the company.

• Be a part of the team to Installing/configuring IBM Cognos products; using Cognos Configuration and

Cognos Administration to set up a fully functional instance of the Cognos BI platform.

• Change the Cognos log files to set the UI as per the UX 2014 standard.

• Developed Standard Reports, List Reports, Cross-tab Reports, Charts, Multiple-levels of Drill through

Reports and Master Detail Reports Using Report Studio.

• Developed Ad-Hoc reports using Query Studio and business insight advance

• Pull the data from DB2 and create Model in the Framework Manager according to the MD HIX the State

and the Federal requirements.

• Involved in defining mappings to build the Framework Manager Model and Package with customized

Query subjects and Query items and published package from Framework Manager to Cognos Connection

• Scheduled reports, maintained public and individual folders, user groups and roles using the Cognos

Connection

• Developed the connectivity from USL (Universal Segmantic Layer) with Framework manager.

• Involved into move to Deployment to UAT and Production

• Involved in the analysis, design, development, testing, deployment and user training of analytical &

transactional reporting system.

• Creating a design document and upload the final version in Sharepoint (Local, State) with tracking all the

development tasks using JIRA.

MDHIX State Roadmap:

• Developing rapid-prototype or proof-of-concept reporting by using Excel as a data source and

demonstrating those solutions to the State PMO’s.

• Support the full report development life cycle, including: Working with internal HIX stakeholders to gather

and document business analytics requirements including: data, layout, and delivery requirements.

• Developed Medicaid, Madicare and CHIP user reports.

• Creating data modeling solutions to support HIX analytic requirements.

• Documenting the design of reports and tracing the design solution to the initial requirement

MDHIX Federal Roadmap:

• Facilitate Technical exchanges between IT groups to ensure delivery of high quality work products

• Give presentations and knowledge shares with Federal User’s, Case workers, LHD and LDSS.

• Capture the HIX design of reports and define the Cognos design solution to the initial requirement

• Monitored and managed project deliverables, artifacts, deadlines, tasks, responsibilities and development

teams.

Environment: Cognos 10.2.1, Framework Manager, Cognos Connection, Report Studio, Query Studio,

Analysis studio, Window7, Sharepoint, JIRA,DB2

Education Affiliates, MD

April 2012 to

Aug 2012 Cognos Developer 10.1.1

Used some advanced features like Conditional Formatting in Report Studio in

•

generating multi page Reports.

• Developed detailed and summary reports using Report Studio

• Moving Reports & Packages from Development to Production

• Created different Standard reports using prompts, filters, query calculations and conditional Formatting

of measures using variables in Report Studio, in Cognos 10.1.1

• Create ad-Hoc and mapping reports for end users using Business insight and Business insight Advance

• Administered tasks such as Deployment, set Cognos security using (Active Directory) and report

scheduling support to the users

Manually modified the SQL in Report Studio to tune and/or to write complicated

•

reports. Used Union/Join objects in Report Studio

• Production Support which involves solving End - user problems

• Developed complex reports using drill-through options and Master-detail relationships in Report Studio.

• Created list reports, cross tab reports and chart reports using cascading prompts, date prompts,

complex prompt pages

Improve the report performance and troubleshooting the issues within the report queries

•

and FM Model

Developed and Published Packages in Framework Manager

•

Connecting and testing the data source, created Database layer, Relationship layer and

•

Presentation layer, defining the appropriate relationship between query subjects.

Developing rapid-prototype or proof-of-concept reporting solutions and demonstrating

•

those solutions to customers

• Environment: Cognos 10.1.1, 10.2, Cognos Connection, Report Studio, Query

Studio, Analysis studio, Frame Work Manager, Active report, Business Insight,

Business Insight Advance, SQL,XML and Windows XP

K2M, INC, VA

Sep 2011

- Mar 2012 Cognos Developer 10.1.1

Extensively worked with List Reports and various formats of report generation e.g.,

•

PDF, Xml etc.

Developed Active reports for IPAD, iPhones as well as Blackberries using the Cognos

•

Mobil application

Scheduling the reports and performed Report bursting

•

Support the full report development life cycle, SDLC, moved to Deployment to UAT

•

and Production.

Building dashboard-style reports by business insight combining lists, cross-tabular,

•

and chart displays to give executives an "at-a-glance" Look at the results of the company.

Implemented best practices in the model by creating three layered architecture.

•

Extensively involved in designing Metadata Model using Framework Manger.

•

Working on Framework security by using the Object,Row, Data level securities

•

Installing/configuring IBM Cognos products; using Cognos Configuration and Cognos

•

Administration to set up a fully functional instance of the Cognos BI platform

Be a part of a conversion from Cognos v8.4.1 to v10 and then v10 to v10.1.1

•

Troubleshoot report development issues by querying the report source data directly using

•

Enterprise database tools.

Be a part to interact with Business users and Source system data owners to gather the

•

requirements.

Be a part of the team to work in ETL tool (Informatica)

•

Working with ETL developers team to filter the data from source to target tables

•

Working with internal stakeholders to gather and document business analytics

•

requirements including: data, layout, and delivery requirements

Facilitate Technical exchanges between IT groups to ensure delivery of high quality

•

work products.

Environment: Cognos 10.1.1, Cognos Connection, Report Studio, Query Studio,

•

Analysis studio, Frame Work Manager, Active report, Business Insight, Business Insight

Advance, SQL,XML and Windows XP

•

Great American Insurance, NC

July 2009

- June 2011 Cognos Developer 8.4

Generated various List Reports, Grouped Reports, Cross tab Reports, Chart

•

Reports, Drill-Down and Drill-Through Reports

Generated Complex reports in Cognos 8.4 report studio including Drill Down reports

•

from DMR modeled Framework model

Created Dashboards to present critical company data in a single report

•

Created list reports & cross tab reports using Cognos 8.4

•

Upgraded reports from 8.2 to 8.4

•

Used IIS(Internet information server) web server for configuration and management

•

Manually modified the SQL in Report Studio to tune and/or to write complicated

•

reports. Used union/Join objects in Report Studio

Experience in developing Framework Manager Models and analyzed those models in

•

analysis studio

Gathered and analyzed business requirements from users and business community

•

Analyzing existing transactional database schemas and designing star schema models

•

to support the users reporting needs and requirements

Used some advanced features like Conditional Formatting in Report Studio in

•

generating multi page Reports

Environment: Cognos 8BI,Cognos Connection, Cognos office Connection, Report

•

Studio, Query Studio, Analysis studio, Frame Work Manager, SQL,XML and Windows

XP, Cubes.

•

•

FedEx, PA

Sep 2008

- May 2009 Jr. Cognos 8.3 BI Developer and Tester

Gathered and analyzed business requirements from users and business community.

•

Developed UML Diagram following all phases of SDLC.

•

Tested the created reports by executing the Test Scripts

•

Upgraded reports from 8.3 to 8.4.

•

Created Cash Product Dashboard reports to present critical company data in a single

•

report using Cognos 8 metric studios.

Used some advanced features like Conditional Formatting in Report Studio in

•

generating multi page Reports.

Used Conditional blocks and conditional variables for generation of reports.

•

Good understanding and knowledge of Agile and Waterfall methodologies

•

Analyzing, documenting and maintaining business and system requirements.

•

Coordinating End to End testing with Cognos team

•

Involved different type of testing such as Blackbox, Whitebox, integrated testing, Unit

•

testing

•

Environment: Cognos 8.3BI, Frame Work Manager, ORACLE, HTML and UNIX,

•

Internet Information Service, Microsoft SQL services MS Office.

•

•

•

Certification

•

All Cognos\IBM Certification\2010.pdf

•

IBM Cognos 8.4/10.1 BI Author (IBM Professional Certification Program)

•

•

All Cognos\IBM Certification\2012.pdf

•

IBM Cognos 10 BI Metadata Model developer (IBM Professional Certification

•

Program)

•

•

Training Officaly trained : ETL tool Informatica Power Center,

•

Workflow Designer.

Contact this candidate