SUMMARY

• Over 8 years of experience with Business Intelligence tools like Cognos 10/8.x Report studio, Query Studio, Analysis Studio, Event Studio, Metric Studio Framework Manager , Cognos Administrator, Transformer, Power Play Enterprise Server OLAP , Upfront, Access Manager and Directory Server.
• Expertise in creating complex reports like Executive Dashboards, Cross tab reports, Top ten reports, ad-hoc reports, Charts and Score card reports using Report Studio.
• Strong working experience in Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, Physical and Logical Data Modeling, Fact and Dimension tables.
• Excellent knowledge on MDX Functions in Report Studio using Multi-Dimensional Sources DMR Mode and Power play Cube and IQD Packages through transformers.
• Expertise in Cognos Framework Manager, Query Studio, Report Studio, Essbase, Cognos Connection .
• Strong experience in generating various reports Dashboards, Master-Detail, etc., using Report studio.
• Usage of Query Studio to build ad hoc Business reports and Report Studio to build advanced reports multi-page, multi-query reports against multiple databases.
• Experience in deploying packages from one environment to other.
• Migration of Cubes and Reports from One environment to different environments In Cognos 8.
• Expert in all stages of Software development life cycle SDLC which includes requirement analysis, design, development, testing and documentation.
• Expertise with the set of code libraries, i.e. jars or dlls by using SDK language.
• Experience in Migration of the applications from Cognos Series 8.3 to 8.4 BI.
• Experienced in Installation, Up Gradation and Production Support of Cognos Series 7 and Cognos 8.
• Designed the architect model, developed the Cognos Query and packages for production and demonstrations.
• Extensively worked on performance tuning for existing reports in Report Studio and Testing and improving Report Performance and performing Query optimization through SQL.
• Experience in coming up with data cleansing, backup and restoration strategies.
• Excellent Verbal and Communication skills with strong potential to learn new technology and adapting to new tools/environment.
• Ability to meet deadlines, multi tasking, flexible in work schedules, team player and posses good communication skills.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Cognos BI Developer

Responsibilities:

• Created dashboards crosstabs and charts to display the business details from different aspects and using different representations
• Created Drill through Reports and also used Conditional Formatting extensively.
• Modified existing prompts, calculations, conditions filters in the report.
• Designed Reports and security using Cognos Administrator.
• Created standard filters, calculation, prompts, and conditions
• Rebuilding and publishing the packages from FWM.
• Created Business Mix reports and testing the performance of reports by using Sql scripts.
• Involved in upgrading of reports and concept of reports in report studio and on OLAP data base.
• Involved in various Development activities of reports in report studio and transformer and OLAP data base.
• Updating the KPI and Owners of KPI's in Metric Studio. Expertise in Data loading jobs from Staging to EPM content store.
• Resolving Data level security issues.
• Creating macros for importing of data and to function the process of loaded data by using DML scripts read, insert and update in TM1.
• Monitoring Cognos Contributor and datasource objects by DML files in TM1.
• Adding the data source by using DDL scripts in Cognos contributor with dba support.in TM1.
• Migration activities from one environment to another environment.
• Migration of reports and cubes and packages from Dev, Qa to Prod.
• Expertise in Reverse Migration of reports and packages.
• Migration of Cube Model and package from on server to another server and Hands on cube building.
• Expertise in scheduling of jobs and reports on Cognos environment.
• Created Data sources in all environments and also ODBC connections for that Data sources.
• Resolving security issue to user due to individual Transformer, FWM tool security activities.
• Active performance on Change Request activities in Cognos Environment.
• Communicating with Users and Developers regarding their status of issues.
• Refreshing Java Metrics status in Cognos Configuration on required servers.
• Communicating with Windows OPS team whenever it is required.
• Monitoring Citrix servers and fixing the issues occurs on servers.
• Monitoring Task Manger activities.
• Performed Unit testing for all developed reports.

Environment:

Cognos 10.1.1 Query Studio, Report Studio, Analysis Studio, Event Studio, Cognos Connection, Cognos Configuration, Access Manager , Metric Studio, TM1, cognos contributor, SQL Server 2005, Windows XP, Cognos Prod servers, Citrix servers, Cognos QA and DEV servers, Site scope, Solar Winds, Installations of Hot sites, ETL.

Confidential

Cognos BI Developer

Responsibilities:

• Participated in discussions with the senior management to create the business requirements
• Communicated with business users on requirements gathering
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Created model using SQL Server 2005 as Data Source
• Upgraded model and reports from Cognos 8.4 to Cognos 10
• Created security at package level, object level in model and security to package in cognos connection.
• Created stored procedure Query Subject in Frame Work FM model.
• Created Report Using SQL code in Report Studio. Created data source by using DDL scripts in cognos contributor.
• Created, and updated the data by using DML scripts in contributor.
• Monitoring the data and jobs in TM1.
• Created Adhoc reports based on user requirements using Query Studio.
• Created Managerial reports like List, Crosstab by using Report Studio.
• Created Drill through reports and Conditional Formatting by using Report Studio.
• Involved in deploying packages and reports from Dev to QA.
• Involved in Resolving the Performance issues of the Reports.
• Testing the report and the validity of the data it retrieves from the database.
• Verification of the data in the back end database.

Environment:Cognos 10/8.4, Query Studio, Report Studio, Analysis Studio, TM1, cognos contributor, Event Studio, Cognos Connection, Cognos Configuration, Access Manager , SQL Server 2005, Windows XP.

Confidential

Cognos BI Developer

Responsibilities:

• Worked closely with client resources and business analysts to analyze and understand business requirements
• Customized data by adding Filters Calculations, Prompts, Summaries and Functions.
• Generated various reports List Reports, Grouped Reports, Cross-tab Reports, Chart Reports, and Drill -Through Reports.
• Added prompts and filters to modify existing reports to accommodate change in user requirements.
• Used Analysis Studio to create Analysis from Power Play Cubes
• Created complex multipage reports using multiple list reports and multiple queries to associate each of the list report
• Created simple to complex reports as well as Dashboard like reports using Report Studio by applying
• various concepts and functionalities such as drill-through, conditional reporting, block, tables, master-detail, charts, various calculations and joins using tabular sets and tabular models.
• Created dashboards crosstabs and charts to display the business details from different aspects and using different representations
• Created Prompts with static choices and conditional variables for rendering the multipage reports
• Developed multi-dimensional cubes using PowerPlay Transformer and published to Cognos Connection for use with Analysis Studio.
• Built Multi Dimensional Power Cubes DMR using Power Play Transformer by using IQD as a Data Source.
• Developed Power Play Cubes, which involved model definition in Transformer, used multiple queries, calculated measures, customized cube content and optimized cube creation time.
• Used Filters for efficient retrieval of data and conditional variables for hiding summary totals for report
• Created professional reports in Report Studio and ad hoc reports in Query Studio
• Implemented Data Level Security, Object Level Security and Package Level Security. Modified existing Cubes to comply with changes in the Requirements
• Performed scheduling and maintenance of reports using Cognos Connection and Microsoft SharePoint based support portals, Essbase.
• Involved in Installation of Cognos8.4/ V10.1 Frame Work Manager, Report Studio, Query Studio, Cognos Connection and EPM with Production support.
• Experienced in Installation, Up Gradation and Production Support of Cognos Series 7 and Cognos 8.
• Strong knowledge in SQL, PL/SQL and Data Manager, Data warehousing Concepts through ETL.
• Good experience with Oracle database and expertise in java scripting reports through SDK.
• Expertise in the development of the programming language such as Software Development Kit SDK languages.
• Performed Unit testing for all developed reports.

Environment:

Cognos 8.4 and V10.1, Framework Manager, Connection, Report Studio, Query Studio, AnalysisStudio, Power Play, DMR, Transformer, Data warehousing concepts, Installation, security settings, EPM 8.1,

Data analytics, SSRS, ETL, MS Excel, Oracle, SQL Server 2000, Java scripting SDK, Adobe Acrobat, Windows 2000, Windows 2003 Server.

Confidential

Cognos Developer

Responsibilities:

• Troubleshoot performance issues pertaining to Report Studio performance within Cognos 8.3
• Assist in resolving and escalating Cognos and Cognos 8 support tickets.
• Experience with all Cognos tools 8 and above Transformer, Framework Manager, Report Studio, etc ,
• EPM and worked on Production Support.
• Provide guidance in Framework Manager modeling.
• Assist in infrastructure upgrade from Cognos 8.2 to 8.3 and randomly test reports in Cognos 8.3
• Interacted with the Users, Project Manager to get a better understanding of the Business Processes.
• Set up meetings with Cognos teams and explain the ongoing and new issues and creating status reports.
• Created Dashboards and modified the existing Dashboards using Report Studio.
• Created Drill through Reports and also used Conditional Formatting extensively.
• Modified existing prompts, calculations, conditions filters in the report.
• Maintained Oracle and Sql as the data base language to execute the queries and SDK languages.
• Unit Tested in Powerplay and in Analysis Studio and ETL to help improve Data Consistency.

Environment:

Cognos 8.3, Framework Manager, Report Studio, Query Studio, Data Analytics, Reportnet, ETL,

SDK, EPM, MS Access, Oracle Sql, Windows 2K

Confidential

Cognos Developer

Responsibilities

• Analyzed defined customer requirements/ specifications offered solutions to fit the customer's need.
• Designed Reports and security using Cognos Administrator.
• Created standard filters, calculation, prompts, and conditions.
• Published reports to the upfront web portal to provide accessibility to the staff.
• Created cascading prompts in Impromptu reports to help users refine their search.
• Created Drill-Through reports to provide users with more detailed information.
• Published Impromptu Web Reports using Distribution Shuttle Builder created posting folders.
• Developed reports for purchase orders, sales orders, and goods issued and goods receipt.
• Coded database procedure to calculate average purchase price of material for current financial year for costing purpose.
• Used Java scripting in executing the queries and upfront.
• Trouble shoot and evaluated report effectiveness by tuning query data's and controlling user access.

Environment: Cognos report studio , Testing, Unit testing, MS SQL Server, Java scripting, MS Excel, MS Visio, UNIX and Windows.

Confidential

Cognos Developer

Responsibilities:

• Created standard filters, calculations, prompts and conditions.
• Worked on creating Impromptu Reports using Prompts and Cascading Prompts.
• Designed catalogs and defined User Classes, Security and Privileges.
• Created Reports and published them on the web server and later on upfront.
• Created News boxes in Upfront and customized the environment. Set Security for News Item and New boxes in Upfront. Set Privileges for user classes by defining News Index Admin
• Involved in Migrating reports from Impromptu/CRN to Cognos 8.
• Created Business Mix reports and Top ten reports by using Sql scripts.
• Developed the different sales report in Report studio in line with variation in time and business strategy
• Developed Query Definition Files and imported those files in to Transformer and created aCubes using Power Play.
• Created List Reports, Cross Tab Reports and Drill Through reports.
• Associate reports to drill through form one report to another.

Environment:Cognos Report studio, transformer, Access manager, Windows NT, SQL server 2000, Upfront Server 7, PL/SQL, Java and UNIX.