Senior Cognos Developer Resume Profile
NY
Summary:
- 8 years of extensive Functional and Technical experience in Data Warehousing, Data Modeling, Business Intelligence BI , and OLAP, ETL tools, product development and Reports Generation.
- Hands on experience in Cognos 10,8 Query Studio, Report Studio, Analysis Studio, Framework Manager, Cognos Connection, Business Insight, Business Insight Advanced
- Expert in Business Intelligence Applications using Cognos Tools such as cognos 8 BI, Cognos10 BI Framework manager, report studio, query studio and Analysis studio .
- Worked on Framework Manager, Analysis Studio, Query Studio and Report Studio for Model and Report design in Cognos BI version 8.3
- Experience developing Metadata Models, DMR Models, and creating filters, prompts, calculations, summaries and functions in Framework Manager.
- Involved in gathering of business requirements Documented them technically with all phases of SDLC life cycle.
- Extensive Experience in the User Creations, Group Maintenance, Security assignment.
- Worked on various tasks for delivering the transformed data to coordinated data marts, delivering metadata to Framework Manager and publishing data movement tasks to IBM Cognos Connection. Extensively used Framework Manager, Query Studio and Report Studio for model design, ad-hoc reporting and advanced report authoring.
- Extensive experience in building the time based partition cube, custom views, signons in cognos transformer
- Extensive experience in cognos model design accelerator in the frame work manager
- Exposure to client interaction and user-requirement analysis.
- Mentored and trained users for the successful execution of the project.
- Experienced in designing of Relational and Multidimensional databases.
- Good understanding of business process especially in the Financial and Insurance areas.
- Experience in integration of various data sources, Multiple Relational Databases like Oracle, and Worked on integrating data from flat files, and XML files.
- Strong Experience in User acceptance test, product support, version control and change management.
- Involved in the entire BI lifecycle project development, including design, coding, testing and implementation and ongoing product support.
- Expertise in OLTP/OLAP system study, developing models and publishing packages using different schema concepts.
- Strong Troubleshooting and production support skills and coordination/interaction and users.
- Team Player with ability to prioritize multiple tasks while meeting deadlines.
Technical Skills
Business Intelligence Tools:
Cognos 10.1.0/ 8.X BI Version 8.1.1, 8.2, 8.3, 8.4 Analysis Studio, Cognos Connection, Business Insight Advanced, Query Studio, Report Studio, Event Studio, Cognos Framework Manager, Cognos Transformer.
OLAP Tools:
Cognos Tools Transformer, Cognos PowerPlay
Reporting Tools:
Cognos Report Studio, Query Studio, Analysis Studio, Framework Manager, Powerplay Studio, Business Insight, Business Insight Advance
Operating Systems:
Windows 95/98/NT/XP/2000, UNIX.
MS Applications:
Advanced Excel, Word, Advanced PowerPoint
PROFESSIONAL EXPERIENCE:
Confidential
Senior Cognos Developer
Responsibilities:
- Used Framework Manager to build models, packages and publish packages to the ReportNet Server.
- Created Diverse Cognos Reporting Solutions
- Developed Standard Reports, List Reports, Cross-tab Reports, Charts, Drill through Reports and Master Detail Reports Using Report Studio.
- Created prompts, Calculations, Conditions, Filters, Multilingual Reports Using Report Studio.
- Created Query Prompts, Developing Prompt pages and Conditional Variables.
- Involved in Design and development of filters, calculations and session parameters in packages within Framework Manager.
- Analyze and define mapping to build the Framework Manager Models Packages with Query Subjects and Query Items.
- Created Custom Dashboard pages using Cognos Portlets.
- Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
- Worked with master-detail reports, drill-through, prompts, complex calculations, formatting, conditional formatting, Bursting reports, Crosstab, multi-query reports, charts.
- Scheduled Reports on weekly basis.
- Creating the Cubes based on the requirements and creating the drill through reports for the cubes
- Created Dimensional Maps, Transformer Models, Power-Cubes and Drill through Developed Combine Filter, User-Defined Filters, Custom ranking using Analysis Studio
- Created Drill down / Drill Up reports using Analysis Studio
- Created Models based on the dimensions, levels and measures required for the analysis-using Transformer.
- Tuning the performance of the Cognos Cubes and publishing Cubes on to the Powerplay Enterprise Server.
- Closely worked with data warehouse designers to refine data and metadata.
Environment: Cognos BI 10.1/10.1.1/8.4 Framework Manager, Cognos Connection, Query Studio Report Studio, Analysis Studio, BIA, Business Insight and Event Studio , SQL Server 2008, and Windows server.
Confidential
Senior Cognos Developer
Responsibilities:
- Produced standard reports for various business needs using best approach and fine tuned the performance based on the users need.
- Extensive performance and tuning work to make the entire model to meet users requirements.
- Built dashboards using Business Insight and Business Insight advanced.
- Used IBM Cognos 10 BI Report Studio and Query Studio for end user reports.
- Implemented Dynamic filtering, Dynamic sorting, JavaScript to concatenate multiple prompt values to input stored procedure .
- Implemented customized URL's to launch ad-hoc templates using business Insight advanced to enable the users to built their own ad-hoc reports.
- Implemented model based entitlements based out of stored procedure and defined joins across different dimensions to enable the data level security.
- Designed and implemented DMR for multidimensional analysis of relational data which enables the user to slice and dice the data and also drill up and drill down behavior.
- Created Models using star schemas and snowflake schemas, Packages using Framework Manager.
- Designed the model based on the requirements for different subject areas and by analyzing the underlying data.
- Supported SIT and UAT phases and provided quick fixes and deployed the code from one environment to another.
- Used standard filters, prompts, conditional blocks and various other conditions for creation of reports.
- Created a portal tab that comprise of different portlets that gives the users to navigate reports around folders and also upload files from cognos portal page instead logging into front end application.
- Created Query Prompts, Developed Prompt pages and Conditional Variables.
- Trained users in query studio and provided sample report Studio reports to the users for getting them used to the report layout and functionality.
- Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution
Environment: Cognos 10.1.1 Report Studio, Business Insight Advanced, Business Insight, Analysis Studio, Cognos Connection, Framework Manager, Cognos SDK, Cognos 10 Powerplay and Transformer.
Confidential
Senior Cognos Developer
Responsibilities:
- Migrated Cognos8.4 reports into Cognos 10 and tested.
- Ran all Cognos 10 reports and compared the actual execution time with Cognos 8.3 and did performance tuning where needed.
- Gathered the requirements from business users to create the reports.
- Created security for reports by restricting / granting access to roles, groups and users created in Access Manager.
- In Frame Work model, tables, views, store procedures were imported, and maintained the layers, having folders inside them to separate views, tables, store procedures, Attributes, facts and keys.
- Created Power Play model to build the cube using IQDs in framework manager.
- Used Analysis Studio for multidimensional analysis and exploration of large data sources.
- Developed crosstab and chart reports with Drill Down Drill Up capabilities in report studio using cube source data.
- Created Ad-hoc reports as per user requirements.
- Created several reports using conditional formats with Drill though options and rendered different prompts based on the location of a report.
- Worked on the Performance Tuning of the reports.
- Involved in full development life cycle of the cognos reporting solutions.
- Involved in user training session for understanding of the Report environment.
- Assist end-users with training, responding to questions and resolving problems.
- Responsibilities also include production/user support, publishing the pages for users, creating ad-hoc reports, scheduling updates.
Environment: Cognos 8.4/8.3, ReportNet 1.1 MR2, Report Studio, Cognos Connection, Framework Manager, Analysis Studio , Transformer, Cognos 10, SQL Server 2005/2008, Cognos 10 frame work manager, Cognos 10 administration, Microsoft Active Directory.
Confidential
Cognos Developer
Responsibilities:
- Migration of reports and catalogs from Cognos series 7.1 to Cognos series 8.3
- Used Framework Manager to create models, packages and publish packages to the Cognos 8 Server.
- Upgrading of reports from series 7.1 to Series 7.3
- Published package for cognos query to Upfront
- Used Data Access Layer to maintain keys, joins, SQL queries.
- Experiencing in developing models using prompts and filteres.
- Performed BI Content Administration tasks including scheduling and content management.
- Used Cognos connections for organizing, security, scheduling and distributing reports.
- Created various portals involving cognos 8 portlets.
- Administer user access protocols and created user accounts and access priviliges.
Environment: Cognos 8 BI, Cognos Connection, Report Studio, Query Studio, Frame work Manager,
Oracle, SQL, XML and Windows 4.0
Confidential
Cognos Developer
Responsibilities:
- Gathered and analyzed business requirements from users and business community.
- Generated complex reports in Cognos 8.3 report studio including Drill through reports.
- Upgraded reports from 8.2 to 8.3
- Designed and Developed multiple models for different modules and published packages.
- Queried from different database tables as per the requirement
- Customized data by adding calculations, summaries and functions
- Tested the created reports by executing the test scripts
- Extensive use of Report Studio to develop a product inquiry systems reports as defined by detailed specs.
- Distributed reports to various agents using Bursting.
- Created sophisticated reports using Report Studio.
- Created and managed Multiple Dashboards
Environment: Cognos 8.3 BI, Report Studio, Query Studio, Frame work Manager, Oracle, MS Access, SQL
Confidential
Cognos Consultant
Responsibilities:
- Performed detail design documentation Involved in the design and development of reports in Report Studio
- Managed and responded to help-desk Tickets.
- Created User Accounts and user classes using Access manager
- Developed Multi-Dimensional cubes according to the requisite dimensional categories.
- Designed Cubes to analyze rejects and refurbishments and rerouting to outlet centers
- Developed Drill-Down templates for specific analysis purposes
- Performed Troubleshooting for Cognos Applications.
Environment: Cognos 8, Oracle, SQL Server, Windows 2000