Skills

Employment History:

Confidential

Sr. Cognos BI Consultant

Responsibilities

• Analyzed Business requirements from the clients.
• Involved in entire Project life Cycle from requirement gathering to development of the reports and successful Go Live.
• Involved in Designing BI planning DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers
• Implemented Framework manager security for Data access, Object level access and Package access.
• Examine relationships and cardinality in Framework manager.
• Designed ETL specification documents for all the projects.
• Designed and Developed ETL using InformaticaPowerCenter8.6/7.1.and UNIX shells scripts for the massive data loads from OLTP systems to staging database system.
• Taking updates from onsite on daily bases and transferring that knowledge to offshore team.
• Understanding the TM1 Cube built requirements and Post population calculation behind each scenario.
• Preparing documents for the integration of TM1 and Cognos BI, and shared to onsite and offshore team.
• Created a project plan and made team to working accordingly to reach the goal on time.
• Involved in developing TM1 input page in .ASPX and understanding the Code behind it.
• Developed a Java Script to pull the TM1 input Page to Cognos and also java script for handshaking of TM1 and Cognos BI.
• Validating data and Comparing in TM1 prospective excel and in TM1 web with Cognos Report Studio.
• Solved most of the Complex part in TM1 and Cognos BI integration.
• Training resources on TM1 and Cognos.
• Created most of the Documents like Technical Document, LLD, TM1 and BI integration document, Work flow Document, Project Plan, Document on report format and Standards etc.
• Developed most of the reports along with the team, made them understand the requirements and deliverables.
• Knowledge of logical and physical data modeling and data warehouse architecture.
• Gathered the requirements from Business Users and created the reports based on those requirements in Analysis Studio as well as in Report Studio.
• Handled Critical situations in QA and Production Support in the final Stages of the project
• Managed and designed the Cognos BI and TM1 integration for reporting and analysis.
• Responsible for conducting pre sales presentations before C-level executives and winning an account
• Responsible for lead generation via user group presentations
• Created solutions pertaining to financial budgeting and costing, sales and profitability solutions for a big retail company using Cognos TM1 suite
• Created Framework Manger Models and created and published packages into the portal.
• Interpreted complex Business specifications developed by the client and generated cubes and reports to meet customer specifications.
• Created Standard Reports using Report Studio and Ad- Hoc Reports using Query Studio.
• Created Lists, Groups and Cross-tab reports with Drill-through functionality
• Created Multi-dimensional reports by implementing Multi-Dimensional Cubes using PowerPlay and Transformer
• Provided security for Cubes of various User classes. Used Date Wizard to create time dimension in Transformer for creating cubes and Power Play reports.
• Calculated fields, created manual dimensions and used special categories for creating cubes and reports using Transformer models.
• Creating cross-tab reports and chart reports using multiple queries
• and drill down capabilities in a single report to meet the business needs

Environment: Cognos 10 Suite, Windows XP., Cognos TM1, Oracle 11g, Windows 2003 Server, Unix Shell scripting, SQL Server 2008, Shell scripting, UNIX, Tomcat/Apache, Cognos SDK.

Confidential

Cognos TM1 Consultant / Developer

Responsibilities

• Gathered business requirements and designed functional and technical requirements documentation.
• Managed the Cognos Planning and TM1 project as IBM Cognos implementation methodologies standards.
• Designed functional solution for planning applications in TM1 performance management environment.
• Developed and implemented the best practices in designing and for TM1 planning applications.
• Led the TM1 proven solutions in business process, performance improvement, and system implementation.
• Designed and implemented TM1 architecture for the corporate planning system and applications.
• Knowledge of logical and physical data modeling and data warehouse architecture.
• Migrated EP planning models and applications to new Cognos TM1 system.
• Developed and maintained the planning models in TM1 environment.
• Involved in Designing DMR models with Relational Data and Relational models using Framework Manager and deployed packages to the Report Servers.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Managed and designed the Cognos BI and TM1 integration for reporting and analysis.
• Set up the Security at the package level, query subject level and the query item level.
• Used Governing techniques for improving performance of the Query.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports and Drill-Through Reports.
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Delivered Advanced Multidimensional reporting solutions using Report Studio.
• Developed Reports with multiple Cognos Viewers and integrated multiple Cognos reports onto a Single Page Report
• Created Framework Manger Models and created and published packages into the portal.
• Created Standard Reports using Report Studio and Ad- Hoc Reports using Query Studio.
• Interpreted complex Business specifications developed by the client and generated cubes and reports to meet customer specifications.
• Created Lists, Groups and Cross-tab reports with Drill-through functionality
• Created Multi-dimensional reports by implementing Multi-Dimensional Cubes using Power Play and Transformer
• Provided security for Cubes of various User classes. Used Date Wizard to create time dimension in Transformer for creating cubes and Power Play reports.
• Calculated fields, created manual dimensions and used special categories for creating cubes and reports using Transformer models.
• Customized Reports by writing complex custom SQL.
• Customized Reports using HTML, JAVASCRIPT and SDK.
• Deliver advanced/ complex reporting solutions such as Dashboards, Scorecards and Standardized Reporting including the bursting of reports globally using Cognos 8.
• Creating IQD files from Report net and designed Power play models in Transformer.
• Built Power Play Reports based on the cubes and published to Report Net Server.
• Involved in building the complex cubes and optimizing the cube creation.
• Built Multidimensional Cubes, Sub cubes for user groups using PowerPlay Transformer.
• Created and managed jobs and schedules.
• Published cubes and OLAP reports using Upfront Server.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Installation of Cognos 8.4 BI Tools and Framework Manager, setting Cognos configuration and integrating different components.
• Created Transformer models and generated OLAP cubes for multi-dimensional analysis of the data.

Environment: Cognos 10/8.4 Cognos Connection, Report Studio, Analysis Studio, Query Studio, Power Play Studio, Framework Manager , Cognos TM1, Cognos PowerPlay, Cognos Transformer, Informatica Powercentre 7.1, Access Manager, SQL Server 2005, Oracle 10g, Windows XP

Confidential

Cognos Developer

Responsibilities

• Involved in analyzing and gathering requirements and provide input into project timelines and ensure adherence to project timelines.
• Installation of Cognos 8.4 BI Tools and Framework Manager, setting Cognos configuration and integrating different components.
• Designed, implemented technical solutions that address complex business requirements and served as a main technical support and perform root cause analysis for problems experienced within all the Cognos reports/Models.
• Designed and developed/modified the Framework Manager model packages defining the cardinalities and namespaces
• Used Conditional blocks to display the graphs, crosstab and list based on selection of a value from the value prompt.
• Used render variable on some report pages and also on List, Bar Graphs to render the list and the graph based on the user selection.
• Used Conditional formatting to discard unwanted columns in the report using style variables
• Managed and designed the Cognos BI and TM1 integration for reporting and analysis.
• Created Multi page reports with grouping and sorting, creating -master detail relationships.
• Created list reports and cross tab reports, charts, Maps and drill through reports. Created complex filters, Conditions and complex financial calculations for developing the reports using report studio as per the user requirements.
• Designed and developed complex Cognos reports and dashboards per business requirements.
• Experience in developing Dashboards for data management, data quality, and decision making ability and analyzing requirements. Knowledge of logical and physical data modeling and data warehouse architecture.
• Worked extensively in development of Framework Manager Model for development of dashboard style complex reports like Global Clinical Dashboard, Protocol Enrollment, Site Enrollment, Country Enrollment, Milestones and Management Reports throughout the project.
• Implemented Security prototype for Cognos business intelligence environment incorporating row level, object level, data level, and package level and report level security.
• Identifying and implementing process improvements in the existing Cognos reports/dashboards.
• Performed scheduling of the reports and created report view of a report for the users.
• Deployed reports and packages from development to test and from test to production using Cognos administration.
• Worked with Cognos support team and Involved in production support by resolving users problems.
• Support unit testing, integration testing and user acceptance testing.

Environment: Cognos 8.3 BI Report Studio, Analysis Studio, Query Studio, Framework Manager, Connection , PowerPlay Transformer, PowerPlay Windows, Informatica Powercentre 7.1, Access Manager, Oracle 10g/9i, Erwin 4.0, 7.1, SQL Server 2000, Flat Files, Windows NT

Confidential

Cognos Consultant / Developer

Responsibilities

• Worked with Cognos 8.1 during this requirement because Capital One was migrating Impromptu Catalogs to Cognos 8.1 and PowerPlay cubes to Cognos 8.1
• Worked extensively on creating the Model and publishing the package on Cognos Connection for future reporting.
• Installation of Cognos 8.1 BI Tools and Framework Manager, setting Cognos configuration and integrating different components.
• Designed and developed the Cognos 8.1 Framework Manager Metadata Model using PowerPlay cubes, Impromptu Catalogs as Data Sources to accommodate future growth in reporting requirements.
• Migrated cubes and Impromptu Catalogs single handedly from Series 7 to Cognos 8.1 MR1.
• Managed and designed the Cognos BI and TM1 integration for reporting and analysis.
• Created cube model packages in Framework Manager. A folder structure is used to group the cubes of the same nature in Upfront.
• Knowledge of logical and physical data modeling and data warehouse architecture.
• Optimized the cubes and set up Framework Manger model so that the cubes can be used in Analysis Studio and Report Studio.
• Gathered the requirements from Business Users and created the reports based on those requirements in Analysis Studio as well as in Report Studio.
• Upgraded Reportnet to Cognos 8.1 to get the required results as per the client requirement.
• Designed, developed, Tested and improved Report Performance.
• Created reports using cube views in production Series 7 in the upfront folder.
• Trained Business users in Analysis Studio.
• Created reports by using data from various data marts created by DataStage jobs.
• Created Frame Work Manager Models using PL/SQL stored Procedures.
• Migrated ReportNet 1.1 MR1 package on to Cognos 8.1
• Created Dashboards in Cognos 8 BI to communicate complex information quickly.

Environment: Cognos 8.1 BI, Analysis Studio, Event Studio, Framework Manager, Metrics Studio, Cognos Connection, Report Studio, Query Studio, Upfront, Cognos 7 series Impromptu, PowerPlay, IWR, Cognos Configuration Manager, Content Manger, Informatica Powercentre 7x, Windows 2000, Oracle 9i, PL/SQL, Microsoft Excel, Microsoft Word, MS Visual SourceSafe 6.0, Data Stage.

Confidential

Cognos Developer

Responsibilities

• Migrated Cognos 7.3 Catalogs and Reports to Report Net1.1 MR2.
• Developed Framework Manager Models with Physical layer and Presentation Layer to cater the various businesses needs Folders, Filters, and Macros
• Implemented Third Party Security with AD and use those in creating Data Level, Object Securities in Framework Manager Models.
• Developed Complex Report Studio Reports using Bursting, Tabular Objects.
• Managed and designed the Cognos BI and TM1 integration for reporting and analysis.
• Created Drill- through reports and Customized Reports with Prompts List. Cross tab
• Created Informatica workflow, mapping, and loading the data into target tables.
• Prepared User documentation to train users and functionality of each report.
• Provided security in Cognos Connection and setup ReportNet security by assigning users to the groups and roles defined in Cognos Namespace.
• Created IQD files from ReportNet and designed Power play models in Transformer.
• Involved in building the Cubes and optimizing the cube creation.
• Published cubes and created Powerplay Reports for the web users.
• Designed sample business Reports to cater the business needs.
• Created Drill-Down Hierarchies and used slicing and dicing technologies to provide optimized Reports.
• Developed SQL Scripts for testing the reports developed Stored Procedures to build the Reporting Database for Exclusive Reporting.

Environment: Cognos ReportNet1.1 MR2 Framework Manager, Query Studio, Analysis Studio, Report Studio PowerPlay Enterprise Server 7.3, Transformer 7.3, Informatica Powercentre 7x, Oracle 9i, SQL Server 2005