We provide IT Staff Augmentation Services!

Cognos Developer Resume

Pennington, NJ

SUMMARY:

  • Certified IBM Cognos BI Designer with over 10 years of experience in the area of Framework Manager, Query Studio, Report Studio and Cognos Connection.
  • Excellent working knowledge in development, designing, Administration and deployment of Data Warehousing and Business Intelligence applications using COGNOS Suite 7/ 8/ 10.x.x and Cognos Report Net.
  • Capable Qlikview Developer with a proven record of corporate client satisfaction. Adept at handling multiple projects simultaneously. Able to adapt work approach quickly in response to evolving client needs.
  • Developed cubes with iqd's and have strong knowledge with Power play Transformer model design and Power play cube building and Power play reports.
  • Strong experience in Installing, Configuring, Monitoring and Management of Cognos on Windows platform.
  • Expertise in Framework Manager Modeling (Database Layer, Physical Layer, Business Layer) and creating Packages and Complex Report building with Report Studio.
  • Strong Experience in developing Business models and publishing packages using Framework Manager along with Cognos Connection in Cognos 10/8 and Report Net1.x.
  • Customized Reports and created portals using HTML and JAVA SCRIPTS.
  • Expertise in OLTP/OLAP system study, analysis, E - R Modeling and developing Database schemas like Star Schema and Snowflake Schema.
  • Developed and successfully deployed multiple initiatives with Executive Dashboards with charts and reports with easy navigation into subsequent reports by drill down feature.
  • Extensively worked on Data Extraction with Oracle (8i, 9i and 10g), SQL Server & MS-Access.
  • Experience in Deployment (Export, Import) using Framework Manager into Cognos Connection.
  • Implemented Security at different levels in Framework Manager and Cognos Connection to restrict access.
  • Expertise in version up gradations of Cognos suite such as Cognos 7.3 and Migrating Report Net reports and Impromptu into Cognos 8 BI.
  • Extensive one to one interaction with end users/Business analysts to identify their needs and wants, then translate the functional requirement into reporting requirements, design and business data flow.
  • Migrated the Framework Manager Models and reports from Cognos Report Net to Cognos8 BI.
  • Designed the Transformer model and built the cubes using Power Play Transformer, explored the Cube data using the Report and Analysis Studio.
  • Expert in all stages of Software development life cycle (SDLC) which includes requirement analysis, design, development, testing and documentation.
  • Strong troubleshooting and production support skills and coordination/ interaction abilities with end users.
  • Self-motivated and enjoy working in a technically challenging environment.
  • Possess excellent communication and interpersonal skills.
  • Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
  • Actively involved in Change Management process for deployment approvals.
  • Provided Cognos to Business Users.

TECHNICAL PROFICIENCIES:

Business Intelligence Tools: Qlikview 11,Cognos 10 & 8 Framework Manager, Report Studio, Query studio, Analysis Studio, Event Studio, Report Net 1.1(MR1/MR2), Cognos Connection, Cognos Impromptu Administrator, Impromptu User, Impromptu Web Reports, Cognos Power Play Transformer 7.x.

ETL Tools: Informatica, Datastage 8.7.

Databases: ORACLE 7.x /8i, 9i, 10g, DB2, MS SQL Server 2000, 2005 and MS Access.

Data Modeling Tool: Erwin 4.1, Transformer and Frame Work Manager.

Programming Languages: C, C++, SQL, PL/SQL.

GUI: Visual Basic 6.0, Toad, HTML.

Operating Systems: Windows 95/98/2000/2003/ XP/2008 and UNIX.

Software Packages: MS-Office, Microsoft Word, Excel and Power Point.

PROFESSIONAL EXPERIENCE:

Confidential, Pennington, NJ

Cognos Developer

Responsibilities:

  • Developed and Support various Complex report types ranging from simple Lists, Cross - tabs, Charts by using different Functionalities like drill-through, Master-detail, conditional formatting, Multiple Prompts, Cascading Prompts, Conditional blocks Filters, multi-page, multi-query reports, Multi-tab reports using Java/HTML scripts, Dashboards, Drill up/Drill down .
  • Created Cube using Transformer and did incremental cube and cube Full build using xml s scripts.
  • Worked on creating User groups in SIT and in UAT and provide user access to folders and reports.
  • Created Dashboard and portal using HTML for easily access of reports, cubes, ad-hoc report (created by Business users and client).
  • Created database layer by defining appropriate relationship between query subjects and Logical layer, DMR layer and business layer in Framework Manager.
  • Task management, coordinating with QA for testing activities, Co-coordinating with users for UAT and other teams like Cognos Admin, Database.
  • Lead the Cognos Framework Design, Development and Review of New and would-be development.
  • Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and Business logic underlying the requirement.
  • Review architecture and come up with solution for any performance/technical concerns.
  • Serve as SME (Subject Matter Expert) for technical issues on Cognos BI Platform.
  • Collected and Managed Business Requirements for creating the Cognos reports & cubes.
  • Worked extensively on Dashboards and portals.
  • Documentation of development and enhancement activities in functional and technical perspective.
  • Preparing analysis documents and submitting to client for code change.

Environment: Cognos Series 10.2, Oracle, Quality Center 11,Nexus 5, PVCS .

Confidential, Berkeley Heights, NJ

Module Lead

Responsibilities:

  • Reloading Qlikview report and publishing to server.
  • Developed and Support various Complex report types ranging from simple Lists, Cross - tabs, Charts by using different Functionalities like drill-through, Master-detail, conditional formatting, Multiple Prompts, Cascading Prompts, Conditional blocks Filters, multi-page, multi-query reports, Multi-tab reports using Java/HTML scripts, Dashboards, Drill up/Drill down .
  • Created Dashboard and portal using HTML for easily access of reports, cubes, ad-hoc report (created by Business users and client).
  • Created database layer by defining appropriate relationship between query subjects and Logical layer, DMR layer and business layer in Framework Manager.
  • Working closely with Cognos Admin team for deployment of Packages and Cognos reports.
  • Worked on Audit package which will trace each and every report executed by Users.
  • Working closely with Business Analyst and business users in requirement gathering, creation of FSD and TSD.
  • Effectively prioritize the tasks and assigning to the team members in a high-pressure business environment to meet tight deadlines expectations.
  • Task management, coordinating with QA for testing activities, Co-coordinating with users for UAT and other teams like Admin, Database.
  • Weekly status calls with Client and forecast analysis for future project tasks.
  • Lead the Cognos Framework Design, Development and Review of New and would-be development.
  • Develop and continuously improve BI practices within the organization.
  • Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and Business logic underlying the requirement.
  • Train members and business users with Cognos.
  • Review architecture and come up with solution for any performance/technical concerns.
  • Serve as SME (Subject Matter Expert) for technical issues on Cognos BI Platform.
  • Setting up user access on data and user group within Cognos environment.
  • Collected and Managed Business Requirements for creating the Cognos reports & cubes.
  • Worked extensively on Dashboards and portals.
  • Documentation of development and enhancement activities in functional and technical perspective.
  • Preparing analysis documents and submitting to client for code change.

Environment: Cognos Series 7, 8.2 & 10.2, Qlikview 11, SQL Server, Oracle, Service Now, PVCS .

Confidential, Berkeley Heights, NJ

Module Lead

Responsibilities:

  • Sound ability to interact with end users and craft clear technical requirements from business language
  • Excellent ability to translate client requirements into effective solutions in QlikView Applications.
  • Understanding source systems and customer requirements.
  • Creating and Managing Qlikview Reports Dashboards.
  • Publishing and Deploying the Dashboards based on business requirements.
  • Developing Set Analysis to provide the custom functionality in QlikView Applications.
  • Testing Applications, reports using review checklists, Data quality for quality assurance before delivering to the end users.
  • Reloading Qlikview report and publishing to server.
  • Created different Reports based on user requirements for business decision making.

Environment: Qlikview 11

Confidential

Module Lead

Responsibilities:

  • Analyze business needs and translate them into technical specs and maintain the information flow in the team.
  • Working closely with Business Analyst in requirement gathering, creation of FSD and TSD.
  • Reviewing the code and giving coding guidelines .
  • Loading data into Database using SSIS tool.
  • Extensively worked on Framework manager.
  • Effectively prioritize the tasks and assigning to the team members in a high - pressure business environment to meet tight deadlines.
  • Task management, coordinating with QA for testing activities, Co coordinating with users for UAT and other teams like Admin, Database.
  • Weekly status calls with Client and forecast analysis for future project tasks.
  • Documentation of development and enhancement activities in functional and technical perspective.
  • Trained Fresher on Cognos Tool.

Environment: Cognos 8.2/8.4, SSIS, SQL, Java

Confidential

Sr. Cognos Developer

Responsibilities:

  • Analyze business needs and translate them into technical specs and maintain the information flow in the team.
  • Deployment of Reports and Package from one environment to other environment.
  • Worked closely with Team members in resolving Issues.
  • Working closely with Business Analyst in requirement gathering, creation of FSD and TSD.
  • Effectively prioritize the tasks and assigning to the team members in a high - pressure business environment to meet tight deadlines.
  • Task management, coordinating with QA for testing activities, Co coordinating with users for UAT and other teams like Admin, Database.
  • Daily status calls with Client and forecast analysis for future project tasks.
  • Working closely with Change Control management/ Release management activities and post release activities.
  • Documentation of development and enhancement activities in functional and technical perspective.

Environment: Cognos 8.2, SQL, Java

Confidential

Sr. Cognos Developer

Responsibilities:

  • Used Framework Manager, Report Studio, Query Studio for Report design in Cognos BI version 8.2/8.4.
  • Expertise with Framework Manager in building models and publishing packages and reporting.
  • Expertise in implementing durable Layered Structure of the model taking Data Layer, Model Layer and Presentation Layer, and Implemented the changes made to the database into the Layered structure of the model by re importing query subjects in the Data Layer and remapping query subjects in the presentation layer.
  • Performed update object on the model query subjects for every change made to the entities in the database and remapped Query items and verify model functionalities.
  • Created packages combining data from multiple data sources using Framework Manager.
  • Synchronized objects based on the previously saved model and implement the newly added features to the model
  • Development of filters, calculations, and prompts, conditions, created various reports such as Simple List, Cross Tab, and Charts using Cognos Report Studio.
  • Responsible for the delivery of solution-oriented complex reports using Cognos* Report Studio.
  • Extensively used cascading prompts, drill-through, sub-reports, summaries, master detail reports, conditional formats, grouping and association features to generate efficient Crosstab and List reports reports.
  • Added JavaScript actionable items and HTML items on the reports.
  • Involved in the Cognos Administration using Cognos Connection for Data source creation, security implementation, scheduling and distributing reports and performance tuning.
  • Validating/Testing of the reports against database.
  • Addressing user queries/Issues and production issues.
  • Work closely with other teams to get the information and resolve any issues reported.

Environment: Cognos 8.2 / 8.4, Toad, Windows Vista,Remedy,JIRA

Confidential

Sr. Cognos Developer

Responsibilities:

  • Publishing reports to Upfront.
  • Manually running of IWR Reports in IWR Production.
  • Editing Catalogs like adding Columns, adding Folders as per the Business User Requirement.
  • Migration from Cognos 7.3 to Cognos 7.4.
  • Giving access to users for accessing the IWR reports.
  • Supporting for Business End Users in Cognos Impromptu (Upfront).

Environment: Cognos Impromptu 7.4, TWS, Toad, Windows 2000

Confidential

Developer

Responsibilities:

  • Analysis of the specifications provided by the clients.
  • Involved in client interaction to analyze the problems and to rectify them.
  • Created multidimensional models from multiple data sources using Transformer.
  • Imported the IQD' files provided by the client created in FM into Transformer to construct a power cube.
  • Defined, created, published and maintained cubes using Powerplay Transformer.
  • Created reports in Powerplay.
  • Involved in Created FM Models.
  • Published Packages.
  • Involved in Created Reports in Report Studio using various prompts & condition blocks.

Environment: Cognos Impromptu7.3, Power play Transformer, Power play, Report Net 1.1, Cognos8, Brio, Win 2000, Toad.

Confidential

Developer

Responsibilities:

  • Creation of reports according to client requirement.
  • Involved in loading reports to Upfront.
  • Monthly and Weekly cube build.
  • Doing Production Support for Cognos..

Environment: Cognos Impromptu, Powerplay Transformer, Powerplay, Brio, Win 2000, Toad.

Hire Now