We provide IT Staff Augmentation Services!

Sr.cognos Consultant Resume Profile

5.00/5 (Submit Your Rating)

Torrance, CA

Professional Summary

  • Played a key role in business requirements gathering / analysis, data warehouse designing / development, integration and testing.
  • Working experience in using and designing Framework Manager to access data sources, creating and publishing packages, applying filters, enabling multilingual filter and enabling security.
  • Worked on newly introduced Cognos 10 tools like Active Reports,Business Insight and Business Insight Advanced.
  • Worked extensively with Business analysts and power users to analyze the business process and user requirements to cater their needs for reports.
  • Extensively worked on Design and Building Dashboards and scorecard reporting.
  • Created and published packages using Framework Manager and generated different kinds of reports including templates reports using Query Studio Report Studio in Cognos 8
  • Thorough understanding of Software Development Life Cycle SDLC experience from requirement analysis through design and development.
  • Familiar with Data warehousing concepts along with implementation of Business Intelligent systems, Operational Databases, Data Marts, understanding of Star and Snow Flake schemas.
  • Designed Developed TM1 Processes, Dimensions, Cubes and Applications.
  • Familiar with Change Management and Promotion to Test / Production processes.
  • Strong working experience with different Databases like Oracle 11g/10g/9i/8i, SQL Server 7.0/2000, MS Access.
  • Desire to learn new skills, technologies, and adapt to new information demands.
  • Excellent oral and written communication skills and inter-personal skills.
  • Have the strength to handle the project independently as well as handling/managing the team.
  • Exposed to XML and RDBMS and MQ Series.
  • Hands on experience in writing, testing and implementation of the triggers, stored procedures, functions, packages at database level and form level using PL/SQL
  • Strong indesign, development and implementationof applications onMicrosoft technologies usingdifferent versions of MSOperating Systems
  • Self-starter and Team player, capable of working independently and motivating a team of professionals.
  • Manager to COGNOS 10 BI Server/Report Net Server.

TECHNICAL SKILLS:

BI Tools

COGNOS TM1 8.2/8.4/10 BI Suite Framework Manager, Report Studio,

Query Studio, Analysis Studio, Event Studio, Metric Designer, Metric

Studio, COGNOS Connection , COGNOS Content store, LDAP Server,

SDK,Deployment Tool, MDX, Cognos TM1

Data Base Applications

Oracle 11g/10g/9i/8i/7.x, SQL Server 2000/2005,Teradata, DB2, Sybase, MS Access

Programming Languages

SQL, PL/SQL C, C ,

Web Technologies

HTML, XML, JavaScript

Other Tools

MS Project, TOAD.

Operating Systems

Windows 2000/NT/98/95, UNIX

Professional Experience

Confidential

Sr.Cognos Consultant

Responsibilities:

  • Worked with Business users to analyze the business process and user requirements to cater their needs for reports and multidimensional cubes.
  • Develops and maintains Framework Manager Models and apply proper securities and publishing packages.
  • Creation of analytical reports, modifications to existing reports in Base Product.
  • Developed dimensional reports using multidimensional data sources in Report Studio.
  • Developed complex Reports using different features like slice dice, Drill capabilities, queries, Master detail and cross tab tables with multiple breaks.
  • Developed User Interfaces, Reports, Rules and Turbo Integrator processes using Cognos TM1 for Expenses, Revenues, Salary and Compensation, Headcount, Budget Variance and Summary.
  • Worked with creating Business Rules that perform calculations, such as average price, currency conversions, and price/earnings ratios in TM1
  • Created different Dashboards in report studio using combination of List, Crosstab, and Graph and Map reports.
  • Develop dimensions, measures and calculation using Power play Transformer for OLAP Analysis of data.
  • Developed user acceptance documentation and placing Screen shots of actual Report and tested report in documentation.
  • Building data source query subjects and using stored procedures to create query subjects that are used to build reports for specific users.
  • 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.
  • 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
  • Interacted with business and technical users to gather requirements and created design document
  • Responsible for creation of metadata models in Framework Manager and cubes in Transformer Responsible for upgrading their Enterprise Planning and Cognos BI Content from Cognos 8.4 to Cognos 10.1.1 and troubleshooting upgrade process
  • Developed various dimensional and relational reports by employing lists, crosstabs, charts, union, joins, burst, master-detail, drill through and drill down, report burst techniques
  • Developed reports, cubes and dashboards using Cognos Insight, Cognos Insight Advanced and Cognos Workspace
  • Installed Cognos Audit Package and documented the entire process
  • Understanding the customer's requirement, analyzing whether the requirements are feasible and checking if they are clear and deployable
  • Developed and modified large number of reports sophisticated reports/dashboards/scorecards, analysis and queries to highlight various revenue and expense components of plan, actual and budget data using Cognos Report Studio, Cognos Query Studio and Cognos Analysis Studio

Environment: Cognos BI 10.1/10.1.1/8.4 Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, BIA, Business Insight and Event Studio , Cognos TM1, , Informatica 8.6.1, SQL Server 2008, Oracle 10g and Windows server.

Confidential

Sr. Cognos Developer

Responsibilities

  • Migrated EP planning models and applications to new Cognos TM1 system.
  • Developed and maintained the planning models in TM1 environment.
  • Managed the on-site and offshore team and developed client relationship through all phase of the implementation cycle.
  • Managed the change and control process in the financial planning solution design and architecture
  • documentation.
  • 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.
  • 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.
  • Managed the Cognos Planning and TM1 project as IBM Cognos implementation methodologies standards.
  • Planned, and successfully implemented the cross functional projects within defined budgets and timelines.
  • Identified and assembled the project resources and directed project team tasks to assure effective project completion.
  • Led the overall Cognos Planning architecture in the development and production multi server environments.
  • Designed and implemented the migration and upgrading to the current version EP 8.3 to 8.4 in both the environments.
  • Designed the analyst models, libraries and application workflow for financial planning and forecasting system.
  • Developed and enhanced the merchant forecast and budgeting applications as business needs in Cognos Planning.
  • Designed and created rolling planning and forecasting process within the existing planning applications.
  • Managed all the design, development and implementation strategy and process in Cognos Enterprise Planning.
  • Designed functional solution for planning applications in TM1 financial performance management environment.
  • Developed and implemented the best practices in designing and development for TM1 financial 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.
  • 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.
  • 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.

Environment: Cognos 8 Suite v8.3 , Windows XP., Informatica v9.1, Cognos TM1 Oracle 10g, Windows 2003 Server, Unix Shell scripting, SQLServer2005, Shell scripting, UNIX, Tomcat/Apache, Cognos SDK.

Confidential

Sr. Cognos Developer

Responsibilities:

  • Designed and developed DMR models for analysis.
  • Designed and developed multiple models for different modules and published packages.
  • Created and established Joins / cardinality between the tables in the application layer.
  • Designed and applied conditions and created functions based on the requirements.
  • Drafted and finalized documents such as Unit Test Plans , Design and Requirements Specification,
  • Used DB2 MQTs for designing the models
  • Used Report Studio Cognos 8.3 to create multi query, multi-page reports from DB2 databases.
  • Implemented Security in Framework Manager Models
  • Gathered requirements by studying the system business process and interacting with the business users and developers
  • Customizing the data by adding functions, calculation and summarizing
  • Designed and developed dashboard reports and applied drill up / down functionality.

Environment: Cognos 8.3 Suite of tools i.e. Report Studio, Analysis Studio, Query Studio, Cognos Connection and Framework Manager, DB2, SQL/PLSQL, Windows XP and Toad 3.1 / 4.0.

Confidential

Sr. Cognos Developer

Responsibilities:

  • Planned, gathered, analyzed, designed and upgraded the CRM Project DMR models.
  • Revisited the requirements to upgrade and finalize by involving and interacting with the business user.
  • Migrated and validated the Cognos 7.4 / 7.3 series reports.
  • Designed and developed metadata models based on the existing Transformer 7.4 IQD's models.
  • Created and established cardinality /relationships between tables in application layer.
  • Used functions and calculation extensively at the model level to duplicate the IQD's results
  • Helped in resolving the issue by bug tracking and issue resolving in the production
  • Helped and trained the user to get familiar with Power Play, Analysis Studio and Report Studio.
  • Created and published nested packages.
  • Applied data level security to steam line information to the users.
  • Created Users / User groups and maintained profiles
  • Used flat files to upgrade the models for monthly financial transactins by creating data sources
  • Helped different project by simultaneously working on different issues in order of priority
  • Did data entry in CRM application to created business scenarios test the report for functionality
  • Helped the business user in created test cases to test the report by creating real time CRM test cases

Environment: Cognos 8.4 Report Studio, Analysis Studio, Query Studio, Cognos Connection, Framework Manager, COGNOS 7.4, Transformer 8.4/7.4, Power Play 8.4/7.4, Power Play Enterprise Server 7.4, Oracle 9, SQL/PLSQL, Windows XP, Linux, People Soft CRM Application 8.44 and Toad

Confidential

Cognos Developer

Responsibilities:

  • Involved in gathering Business Requirements.
  • Prepared the requirements specification document.
  • Built Framework Manager Model and established the cardinalities to suit the business needs.
  • Created Packages and published packages to Cognos server.
  • Created Ad-hoc reports using Query Studio.
  • Created complex reports using Report Studio.
  • Developed complex dashboard reports using Report studio.
  • Involved in Installation of Cognos Server, Frame Work Manager, Report Studio, Query Studio and Cognos Connection.
  • Developed multiple page reports with page-breaks based on the first page of the report using Master-detail relationship.
  • Deployed the packages and reports from development to test environment and test to production environment.
  • Scheduled various reports using Schedule Management used in Cognos Connection.
  • Involved creating and maintenance of views, indexes using TOAD as per report requirements.
  • Fine-tuned SQL queries and reports for performance.
  • Created mappings and reusable mapplets using ETL tool Informatica power center to transform data from multiple sources including flat files and Oracle relational sources.
  • Created and validated active/passive transformations like Source qualifier, Router, Normalizer, Aggregator, Filter, Joiner, Expression, Lookup, Update strategy and reusable mappings

ENVIRONMENT: Cognos Suite 8.0 Report Studio, Query Studio, Analysis Studio, Cognos Connection, Framework Manager , Oracle 9.2, Ms-Access , Windows 2000, TOAD 7.3, Informatica Power Center, SQL Server 2005, Flat files, MS Excel, Erwin.

We'd love your feedback!