We provide IT Staff Augmentation Services!

Bi Consultant Resume

DetroiT

SUMMARY:

  • Post Graduate having around 12+ years of experience in consulting Software Development with Complete SDLC exposure, in which Data warehousing Professional as a primary skill COGNOS BI Reporting Tool.
  • Expertize in using Reporting Applications of different versions like Cognos Report Net 1.2, Cognos 10,10.1,10.2.1 Cognos8 all Versions 8.1 to 8.4 Worked on Framework Manager, Query studio, Report Studio for Report Design using COGNOS Suite, Got Explored with Applix TM1 acquired by IBM Components TM1 Architect, TM1 Perspective,TM1 Web components.
  • Extensive documentation of Functional and Technical Specifications in Report Solution Design and Testing.
  • Demonstrated ability to understand complex business needs and translate business requests into reporting and analytical deliverables.
  • Hands on Cognos Multilingual Reporting Analytics system for Japanese Analytics Using Metadata/Static Text/Transaction Data.
  • Gathered requirements for Business Intelligence systems, participated in design and enhancement of those systems to improve the quality and accessibility.
  • Identify, prioritize and resolve fit/gap issues between current and future Business Intelligence systems.
  • Strong knowledge on Cognos Architecture and Strong analytical and communication skills combined with leadership skills and experience for proven ability to implement organizational change.
  • Familiar with TM1 rules editor to create various calculations, What if analysis for TM1 planning , budgeting and forecasting
  • Basic knowledge in Cognos Enterprise Planning: Analyst, Contributor, Contributor Add - In for Excel.
  • Flexible in terms of working hours and ability to stretch beyond the hours with proactive/self-motivated working style having strong personal ownership of problem resolution in an innovative approach while solving and finding solutions.
  • Involved in preparing and executing use cases and functional test cases as per the Report requirement.
  • Business exposure to a wide range of industries, including real estate, banking, gaming, telecommunications, health care, aerospace, logistics, retail, as well as a depth of technical experience.
  • Proven ability to successfully lead teams in the development of high-quality solutions using either the onshore or offshore engagement model.

TECHNICAL SKILLS:

Data warehousing: Data warehousing Concepts

ETL Tools: Informatica 9.1.0, Power center 9.1.0BI tools: Cognos Analytics 11.0.8, Cognos Analytics 11.0.7, Cognos Analytics 11.0.5 Access Manager, Frame Work Manager, Report Net 1.1,1.2, IBM Cognos Analytics 11.0.6,COGNOS 10.1, 10.2 8, 8.1, 8.2,8.4, Cognos SDK, Cognos Connection (Query Studio, Report Studio, Analysis Studio),TM1 Architect,TM1 Web, ERP Planning,Cotnributor,TM1 Architect,TM1 Web,TM1 perspective, IBM Optim Solutions, IBM Netezza, BI Pentaho Programming Languages: C

Scripting: HTML, Java Scripting

Other: MS office

Operating System: Windows XP, Unix, Bug Tracking Tools Remedy, Mantis

RDBMS: Oracle 9i/10g/11g, DB2, Toad, Rapid SQL, DB2, IBM Netezza Appliance, Green Plum, Teradata. Having a Good exposure on Installation and configuration COGNOS with ORACLE, DB2 as back end.

PROFESSIONAL EXPERIENCE:

Confidential, Detroit

BI Consultant

Responsibilities:

  • Gather requirements directly from clients and Business Analysts through meeting and group discussions for presenting data set for KMOC Audit remediation reporting system.
  • Created database Layer, Business Layer and Presentation Layer, defining appropriate cardinality between query subjects in Framework Manager and incorporated security at different levels for in Framework model as needed and incorporated Business Naming convention as per business demands.
  • Creating Data Sets using FM package and Created Data modules with source as Data sets using Data Modules Built Dashboards.
  • Created Reports, Dashboards, Story and Data modules as per business need.
  • Created Navigation Groups to Build Drill Up and Drill Down Reports.
  • Creating Framework model for ad-hoc reporting needs of the business and training users to build and customize their ad-hoc reports for users.
  • Performance tuning of reports at reporting layer and Framework Manager Model layer.
  • In depth interaction with Database Architects, SME’s for requirement gathering for solution implementation for Financial Leasing vehicles based out of Germany country.

Environment: IBM Cognos Analytics (11.0.6), Teradata SQL Assistant.

Confidential, TN

Business Intelligence Senior Developer.

Responsibilities:

  • In depth interaction with Database Architects, SME’s for requirement gathering for solution implementation for KMOC Audit remediation analytics Reporting system.
  • Responsible for the architectural design and detailed design of reporting and obtaining sign off from the business for KMOC Audit Remediation Reporting system.
  • Involved in administration tasks like creating data source, publishing packages, export, Import, creating users, role based user security and scheduling the reports
  • Gather requirements directly from clients and Business Analysts through meeting and group discussions for presenting data set for KMOC Audit remediation reporting system
  • Created database Layer, Business Layer and Presentation Layer, defining appropriate cardinality between query subjects in Framework Manager and incorporated security at different levels for in Framework model as needed.
  • Created Active Reports, visualization Reports and, Dashboards and Drill-Through Reports using advanced reporting techniques and Bursting Several reports for Business users on regular intervals on their Business demand request.
  • Performance tuning of reports at Reporting layer and Framework Manager Model layer
  • Creating Framework model for ad-hoc reporting needs of the business and training users to build and customize their ad-hoc reports in Query Studio
  • Used JavaScript for certain validations to overcome the limitations in Cognos report studio for customized reports for KMOC Audit Remediation Application Reports.
  • Handled deployment of packages in lower to higher environment, user training, knowledge transfer, and support and transition activities as per SDLC process Sprint Releases.

Environment: Cognos 10.2.2 Suite (SDK, Framework Manager, Cognos Connection, Query Studio, Report Studio), TeraData SQL Assistant, Erwin Data Modeler 4.5, Windows

Client: Confidential, TN

Sr. Cognos Writer / Developer

Responsibilities:

  • Involved in the Installation and Configuration of Cognos 10 BI tools and Framework Manager
  • Involved in administration tasks like creating data source, publishing packages, creating users, role based user security and scheduling the reports
  • Gather requirements directly from clients and Business Analysts through meeting and group discussions for presenting data set.
  • Created database layer, business layer and presentation layer, defining appropriate relationship between query subjects in Framework Manager
  • Created Active Reports, List, Crosstab, Dashboard Reports and Drill-Through Reports using advanced reporting techniques and Bursting Several reports for Business users on regular intervals on their Business demand request.
  • Performance tuning of reports at Reporting layer and Framework Manager Model layer
  • Extensively worked on the complex prompt page design of various reports for different customized report requirements.
  • Creating Framework model for ad-hoc reporting needs of the business and training users to build and customize their ad-hoc reports in Query Studio
  • Created ad hoc framework manager model and trained business users to work with the ad hoc package in Cognos Query Studio
  • Provided security at different levels for Cognos reports and Framework model
  • Used JavaScript for certain validations to overcome the limitations in Cognos report studio
  • Created Test Plan and involved in test cases preparation and execution of the test plan
  • Handled deployment of packages in lower to higher environment, user training, knowledge transfer, and support and transition activities as per SDLC process Sprint Releases.

Environment: Cognos 10.2 Suite (Framework Manager, Cognos Connection, Query Studio, Report Studio), MS SQL Server, Erwin Data Modeler 4.5, Windows

Employer: Confidential .

C Confidential

Cognos Architect

Responsibilities:

  • Extensively using BI reporting Cognos Tool Feasibilities for presenting data set on reports according to the multilingual data presentation according to user profile Language and requirements.
  • Gather requirements directly from clients and Business Analysts through meeting and group discussions for presenting data set.
  • Created Multilingual Reports using Cognos for Japanese Business Analytics system for their analytical solutions for sprint releases.
  • Modeling using Framework work manager to present preferred data set Chosen by user in and providing solutions on demand accordingly and deploying package.
  • Incorporated Filters and Prompts in reports to display data set according to the user choice at the run time to get dataset present on reports.
  • Reviewing High Level and Low level Design docs and clarified design solutions with Team and Business Users to Present data set.
  • Proficient in designing, reviewing and documenting Technical and Data workflow, Advising g test Procedures for test cases on the basis of client’s requirements and related technical design documents.
  • Performing data validation for report data set against testing using SQL and resolving data issues and providing solutions accordingly.
  • Perform sanity check, security checks, and regression testing and data reconciliation.
  • Co-ordinate with Internal team to explain requirements and work with them to achieve deliverables.
  • Follow Defects in Bug tracking tool and Fix those in reports and test it thoroughly before handover to QA team and then deploying into higher environment after receiving QA signoff.
  • Perform review with client for our activities and ensure all requirements are developed and tested properly.

Confidential, Hartford, CT

Cognos BI Consultant

Responsibilities:

  • Health care products and services
  • Group disability, life and accident insurance
  • International insurance coverage
  • Design, develop, test and deploy new application /analytical /reporting solutions to meet end-user requirements as per Business Need.
  • Generated Data Warehouse Design recommendations and alterations, based upon issues discovered during Business Requirements Definition Phase of Ad Hoc Reporting system.
  • Creation and generation of various statistical Active reports for QA, and other portions of ongoing design Data Warehouse.
  • Gather document requirements from end-users for new applications/Active reports/analytics.
  • Regularly met with project teams and management to present options / project updates / obtain and document various Business Requirements.
  • Presented options for automation of security to provide single, central point of maintenance with pass-through (via Access Manager Objects) from namespace to Power play cube, including points in between.
  • Interaction with the Business Users to gather requirements, define the report formats, develop the Active reports and assist them to become familiar with the features of Cognos Web component of Query Studio.
  • Analyzing Prompt Data source details for the filters available in the all Business need of Active reports and Captured those information for creating index for report Optimization.
  • Good Explore on Report Performance tuning and optimization apart from Cognos Reporting.
  • Providing resolution for the tickets by dig into the Database Objects and analyzing from the
  • Report prospect with reference to the data model.
  • Handing Independently Cognos Administration and Security of user’s role maintaining using LDAP.
  • Kick of ESP Jobs to build Power play cubes and Checkout data before handover to Business for Validation.
  • Adding Users to Global Group as a part of User access to Cognos Power play cubes and Active reports.
  • Build credibility, establish rapport, and maintain communication with stakeholders at multiple levels, including those Internal to the organization
  • Primary Coordinator for all Project related activities
  • Ensure QA on all Project deliverables
  • Monitor compliance with development and configuration standards
  • Manage Project issues, actions and risk logs, Issue resolution and escalation
  • Manage delivery of functional/configuration work assigned to My project team
  • Identify risks and clearly communicate them to project stakeholders
  • Define problem solving and risk mitigation strategies
  • Oversee the compilation and analysis of project activity and will deliver statistical data/reports on a project's feasibility and progress.

Environment: Cognos 8.4, Power play Transformer, Framework Manager, Cognos Connection (Report Studio, Analysis Studio), Oracle 11g, Informatica 9.1

Confidential, NYC.

Cognos BI Consultant

Responsibilities:

  • Design, develop, and implement Cognos TM1and Cognos BI solutions for financial planning and budgeting projects using Turbo Integrator (TI) and complex business rules.
  • Extensively used TI for loading data into Dimensions and Power play cubes, added new dimensions and Power play cubes to existing environment.
  • Developed TM1 application to gather and consolidate data in support of the footnotes in the annual report.
  • Manage TM1 data through TM1 Reports (Active Form & Slice).
  • Created and arranged different TM1 rule statements and performed complex calculations for Power play cubes at N&C levels
  • Created ad-hoc queries from multidimensional views for analysis.
  • Developed Power play cubes, Reports, and Dashboards using Cognos BI.
  • Created Dynamic Reports from Worksheets and Power play cube views using different functions (DNEXT, DFRST and ELCOMP).
  • Worked on replicating the Power play cubes between servers, sharing data between Power play cubes and linking asymmetrical Power play cubes.
  • Created ETL (Extraction, Transformation & Loading) processes in TM1 performing business rule mappings of relational data into dimensional model.
  • Deployed the TM1 data into production environment.
  • Prototyped system interfaces in Excel and facilitated reviews and capture project related documentation and maintain project repository.
  • Facilitated discovery and documentation of multi-organizational planning and forecasting processes.
  • Validated reports based on Functional Requirements.
  • Prepared for Unit Testing, UAT and created Logs, Defect Tracking using Quality Center.

Environment: Cognos TM1 9.5.2, Cognos 8.4, MS Excel, HP Quality Center, Windows XP Professional.

Confidential

BI Consultant

Role and Responsibilities:

  • Understanding Cognos Performance Applications (PApps) framework and reports
  • Creating Detailed Design Document (DDS) for the user requirements
  • Enhancing the existing PApps reports as per user requirements
  • Develops high complexity Cognos reports
  • Created List reports, Cross-tab reports with Conditional formatting and Drill-through Reports using Report Studio.
  • Assist more junior Cognos resources in the development or medium and low complexity ETL programs.
  • Analyzing Prompt data source details for the filters available in the all OTB reports and Captured those information for creating index for report Optimization.
  • Performs Unit Testing of Cognos reports and ensures all Unit Tests carried out are documented and have passed
  • Communicates status to PASCI PM & onsite Cognos Lead.
  • Assists in performing Verification Testing
  • Assists in the transition of the Reporting solution from development/test to production

Environment: Cognos 8.4, Framework Manager, Cognos Connection (Report Studio, Analysis Studio), Cognos PApps, Cognos Data Manager, Oracle 11g

Confidential

Developer

Role and Responsibilities:

  • Performed Optimization on the existing reports at the report level to decrease the run time to meet the real time requirements and made changes to the existing reports for good look and feel for end users.
  • As Per FS Algorithm created function in the Database and implemented into the report level.
  • Involved in the Analysis of the Report Design documents.
  • Creation of Templates, Created Layout and Query Calculations.
  • Involved in Resolving User Problems like Tickets based on Priority at Report level or at database level.
  • Involved in Various Enhancements of the reports like adding prompts, columns for the given Change Request and implementing the Coding standards.
  • Using Version control tool Dimension Moving the reports from one environment to another.
  • Involved in testing of reports Unit Testing, regression testing.
  • Using the Third party tool Access manager providing the different access to the users at the report level Like Creating accounts, disabling accounts, resetting passwords and so on.

Environment: Access Manager, Report Net M.R.1.1, COGNOS 8.2, Oracle 10g, Version Control tool Dimension, Toad, Windows XP …

Confidential

Developer

Role and Responsibilities:

  • Involved in Requirement gathering for Developing Relational Model using Framework Manager and Publishing the Package onto Cognos Connection.
  • Installation and Configuration Cognos 8.2 on Windows NT.
  • Developed Dashboards and scorecards.
  • Created simple List reports, Cross-tab reports with Conditional formatting and Drill-through Reports using Report Studio.
  • Involved in implementing Conditional Blocks for one report.
  • Created different Filters and Calculations effectively used while reporting.
  • Using conditional Blocks to implement conditional formatting.
  • Created charts with Drill Through.
  • Created Burst reports and made them available to appropriate users
  • Resulting in saving lot of time and effort.
  • Created Master-Detail Relationship Report.
  • Interacting with client on regular basis.

Environment: COGNOS 8.1, Informatica power center 7.1.1, Oracle 9i, Windows NT

Confidential

Developer

Role and Responsibilities:

  • Implemented Conditional formatting in the List reports.
  • Developed Standard Templates, Reports, Charts, Drill Through for one a Report,
  • Master Detail Reports and Report Studio.
  • Creating charts with drill through.
  • Performed optimization on the existing reports to decrease the run time to meet the real Time requirements and made changes to the existing reports for good look and feel for Users.
  • Involved in Resolving User Problems based on Priority at Report level or at database level.
  • Created/modified reports based on the business requests sent by the client.
  • Performed user Acceptance tests and made sure that each report is approved.
  • Provided support and troubleshoot problems as required.

Environment: COGNOS 8, Informatica power center 7.1.1, Oracle 9i, and Windows NT

Confidential

Developer

Role and Responsibilities:

  • Created different filters and calculations in Framework Manager that can be effectively used while reporting.
  • Created simple list reports, cross-tab reports, Drill through reports using Report Studio.
  • Using conditional Blocks to implement conditional formatting.
  • Creating score cards and dash boards.
  • Created burst reports and made them available to appropriate users resulting in saving lot of time and effort.
  • Develop single select and multi select cascading prompts.
  • Participated in user meetings to understand the reporting need.
  • Interacting with client on regular basis.

Environment: Report Net 1.1R, Informatica power center 7.1.1, Oracle 9i, Windows NT

Hire Now