SUMMARY

• Cognos BI Developer with 8 years of experience in Analysis, Design and Development of Data Warehousing and Business Intelligence Reporting tools.
• Expertise in Cognos software tools like Framework manager, Transformer, Report Studio, Query Studio, Analysis Studio and related applications.
• Solved security and report, model issues being an Administrator.
• Designed Frame Work Manager Models, Transformer cubes to build scorecard, Dashboard reports.
• Possess extensive experience and in - depth knowledge of business intelligence methodologies and data warehousing tools
• Plan and implement projects in line with the project requirement and goals
• Deliver the project requirements through quality work on time
• Communicate fluently and effectively with on-shore and off shore clients
• Strong interpersonal skills and ability to use it for maintaining relations with colleagues and clients
• Proficient in handling problems/issues and make prompt solutions to resolve them
• Possess strong analytical reasoning and ability to lead a team
• Work using the best technological practices in the industry
• Extensive knowledge on various business domains.
• Aware of all the latest technologies, applications and processes in the Cognos environment.

TECHNICAL SKILLS

Business Intelligence Tools: Cognos 8 / 10.2: Framework Manager, Report Studio, Query Studio, Cognos Connection, Cognos Life Cycle Manager, Metric Studio, Analysis studio and Event Studio, TransformerCognos ReportNet: Report Studio, Query Studio and Framework ManagerETL: Informatica

Operating Systems: Windows 7/VISTA/NT/XP/ME/2000/95/98, LINUX/UNIX

Databases: Oracle 11g/10g/9i/8i, DB2, MS-SQL Server 2000/2005, Teradata

Programming Languages: C, C++, Java, SQL, PL/SQL(Cursors, Stored Procedures, Triggers and Functions), Perl, PHP, UNIX Shell Scripting, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

Sr. Cognos Consultant

Responsibilities:

• Lead, design and develop BI solutions using Cognos BI 10.1.1
• Performance management and best practices for Cognos reporting and modeling
• Maintaining and augmenting the FM and Transformer Models
• Troubleshoot and resolve the applications or integrations issues
• Cognos based work estimates and work planning
• Architecting Cognos multi-dimensional cube solutions
• Designed Framework Manager Models for building Budget Reports.
• Design and implement security for Transformer cubes.
• Developing Framework Manager models by leveraging Cognos recommended design techniques
• Relational and Dimensional database design for Oracle.
• Worked to build Scorecards against dimensional models.
• Communicate clearly and effectively with the development teams, management and business users
• Structured and lateral thinking in order to provide multiple options and recommend the best suited option
• Assist project manager in preparing time estimates and justification for assigned tasks
• Designing and developing standard reporting and ad-hoc reporting environments.
• Worked to solve service requests from TGS department.
• Consistently managed server environments.
• Worked to create Cognos insight reports to business users and demonstrated the business value of those reports.

Environment: IBM Cognos 10.1.1(Report Studio, Analysis Studio, Query Studio, Business Insight Advanced, Framework Manager, Transformer), Cognos Insight, Infosphere 8.5,Service Request System, Web sphere, Oracle 10g, Windows XP.

Confidential, Secaucus, NJ

Sr. Cognos Consultant

Responsibilities:

• Worked closely with user's to successfully identify, document, and deliver the user requirements.
• Installed and Configured the Cognos 10.2 on windows for development Environment
• Worked on Supporting and Troubleshooting the Cognos 10.2 environment
• Created Framework models for each sales group in Panasonic Corporation.
• Worked to create a DMR model in framework manager of Cognos.
• Migrated content store which have reports, cubes from one environment to another in Cognos 10.2.
• Created ad-hoc reports in query studio for user testing and Created views, scheduled reports for users.
• Resolved issues on existing, Cognos reports and packages from different sales departments.
• Created and maintained various cubes for Sales managers based on departments.
• Responsible for maintaining the folder structure and versions of cubes in transformer..
• Worked on creating dimensional reports based on sales cubes.
• Created securities for the power cube and Deployed cubes among different environments.
• Administration of the Cognos 10.2 Portal, Users, Groups, Security and fixed issues as an Administrator.
• Alternatively worked with ETL and Database people to understand the data retrieval from SAP, SLX, and also retrieved data by writing SQL queries.
• Trained fellow team members to understand cognos 10.2 strategy.
• Educate/mentor end users on the appropriate use of Cognos 10.2 BI tools.
• Trained users on Cognos workspace advanced and cognos workspace, of various departments.
• Develop and maintain end user and technical documentation.

Environment: IBM Cognos10.2, Cognos 10.1.1(Report Studio, Analysis Studio, Query Studio, Business Insight Advanced, Framework Manager, Transformer), IIS, SQL Server 2008, Windows XP.

Confidential, White Plaines, ny

Sr. Cognos Consultant

Responsibilities:

• Expertise with Cognos 10.1 BI suite.
• Administered, model and leveraged the use of analytical and reporting capabilities.
• Created OLAP models in Transformer cube.
• Worked to create layered architecture in Framework manager.
• Created complex reports based on sales hierarchy and distributors using conditional blocks and conditional variables in report studio.
• Worked with MDX functions to get data from level members of dimensional data.
• Developed multi page reports, scorecard reports in report studio.
• Developed cross tab reports (DMR) with drill through, drill up, drill down and complex reports which involved multiple prompts and multi-queries.
• Created jobs for the report views and scheduled them to get those reports to emails.
• Created dashboards for immediate visibility into key performance indicators (KPI's) for rapid decision-making.
• Created Prompts based on the conditional variables to display pages based on render variable conditions.
• Worked with reports in production and solved the performance issues.
• Worked to improve the performance of the reports.
• Worked with supporting team to solve issues related to servers.
• Executed scripts to refresh the cubes on a daily and weekly basis.
• Administered database and Cognos security, backups, tuning, configuration, and performance.
• Created user, group access roles for reports and packages.
• Raised ticket in conditions of dispatcher error and remote connection failure.

Environment: IBM Cognos10.1(Report Studio, Analysis Studio, Query Studio, Event Studio, Cognos Workspace Advanced, Framework Manager, Transformer),oracle10g(SQL), Apache (TOMCAT),Windows XP.

Confidential, Edison, NJ

Sr. Cognos Consultant/Architect

Responsibilities:

• Installed & Configured the Cognos 8.4 on windows for development Environment and supported applications.
• Developed and Published Packages in Framework Manager Connecting and testing the Data Source, created database, physical and presentation layer(DMR) model, defining appropriate relationship between query subjects and fact tables.
• Worked with sales data and validate the existing reports against SQL Server Database.
• Created changes in the existing models of Cognos Framework Manager and published packages for reporting activity
• Created Framework Manager Models with calculated columns, securities for model, filters from different data source.
• Created relational and multidimensional models using star schema in Frame Work Manager and published packages and implemented for reporting activity and deployed packages to the Cognos Connection Portal.
• Developed the List reports, Chart, Graphs, Cross tab, Dashboard reports, Master detail and Drill through reports and Multi Lingual Reports using Report Studio and Analysis Studio.
• Created views for Summary detail reports and created jobs and scheduled them in Cognos Connection.
• Deployed the packages and reports from development to test environment and test them in production environment.
• Tested and validated the report output against the database to measure performance of the Report.
• Involved in creating performance tuning and troubleshooting of reports, created templates and modify the existing templates. Executed scripts to refresh the cubes on a daily and weekly basis.
• Administered database and Cognos security, backups, tuning, configuration, and performance.
• Created user, group access roles for reports and packages.
• Responsible for solving problems as Administrator and Created reports in Query Studio for user access
• Responsible for scheduling meetings with team members and clients.
• Organized status meetings with manager to give updates about reports and cubes.
• Migrated reports, cubes, Framework Models from Cognos8.4.1 to Cognos10.1.

Environment: IBM Cognos10.1(Report Studio, Query Studio, Business Insight Advanced Framework Manager),Cognos8.4.1 (Framework Manager, Report Studio, Query Studio, Analysis Studio,), oracle11g(SQL), IIS,Windows XP

Confidential, NYC, NY

Sr. Cognos Consultant

Responsibilities:

• Analyze the business specification of client & Develop specification documents for Reports as per client requirements.
• Developed and Published Packages in using Frame Work Manager and testing the Data Source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and fact tables.
• Created a Framework Manager Models with calculated columns, filters and Macros from different data source.
• Setting up the security in framework manager for packages.
• Developed the List reports, Crosstab reports, Chart reports, Master detail and Drill through reports and Multi Lingual Reports using Report Studio and Query Studio.
• Created dashboard based on the requirements using Multidimensional Functions as per user requirements for them to make decisions on business users and implemented drill through to dashboards.
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection.
• Developed cross tab reports (DMR) with drill through, drill up, drill down and complex reports which involved multiple prompts and multi-queries.
• Guided offshore teams in various aspects, during development phase of project.
• Deployed the packages and reports from development to test environment and test them in production environment.
• Created ad-hoc reports and demonstrated for business users in Query Studio.
• Created OLAP cubes by using PowerPlay Transformer.
• Tested and validated the report output against the database to measure performance of the Report.
• Created Data Dictionary for future reference and updated document for cognos development environment.
• Documented minutes of meeting and also cognos frame work, report progress on daily basis.
• Involved in creating performance tuning of reports, templates and modify the existing templates.
• Executed scripts to refresh the cubes on a daily and weekly basis.
• Administered database and Cognos security, backups, tuning, configuration, and performance.
• Responsible for scheduling meetings with team members and clients.
• Migrated of Reports and Cubes from 8.1/8.2 to Cognos version 8.4.

Environment: IBM Cognos 8.4 (Framework Manager, Report Studio, Query Studio and Transformer),oracle11g(SQL), DB2,SQL server 2005, Apache(TOMCAT),Windows XP.

Confidential, NYC, NY

Sr. Cognos Developer

Responsibilities:

• Involved in requirements gathering, report design, report development, and support of all client/server layers.
• Planned an approach for documenting, categorizing and packaging the requirements.
• Created Scheduled Jobs by scheduling multiple reports in a job.
• Involved in Designing and creating various models and Publishing packages in Framework Manager.
• Imported metadata from various sources such as Relational Databases using star schema the Framework Manager.
• Involved in Designing DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers.
• Created Framework manager security for Data, Object level and Package level based on the Organization Level.
• Worked on Analysis Studio to develop multi-dimensional reporting.
• Created Power Play Reports by using Analysis Studio.
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports.
• Developed advanced reports using Billing Data in Report Studio.
• Created folders, filters, prompts and calculations in Report Studio/Query Studio and Framework Manager and Customized data by adding calculations, Filters, Prompts and Governor Settings.
• Developed various ad-hoc report types ranging from simple lists, crosstab, chart, through complex dashboards, drill-through, Master-Detail and Conditional formatting reports.
• Created Complex, multipage reports involving prompts, Cascading prompts, Conditional rendering and Conditional formatting and Create ad-hoc reports in Query studio
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Created dashboards for immediate visibility into key performance indicators KPIs for corrective action and rapid decision-making. Created Dashboard indicators.
• Developing Multi-Dimensional Analysis and building Power Cubes using Cognos Power Play and Transformer and created the drill through reports for the cubes.
• Developed Models based on the dimensions, levels and measures required for the analysis.

Environment: Cognos 8.3 (Framework Manager, Report Studio, Query Studio, Analysis Studio and Transformer),Oracle 9i, DB2,SQL Server 2000,Windows 2000

Confidential, San Jose, CA

Cognos Developer

Responsibilities:

• Involved in Planning and implementation of Cognos8 BI Suite.
• Designed models using Framework Manager and deployed packages to the Cognos Connection Portal.
• Created financial reports in report studio.
• Collecting the data marts and creating model based on that data.
• Created user groups and provided login credentials for end users.
• Importing data into SQL Server tables from other applications and environments.
• Worked on IBM Cognos 8 reporting against financial data cubes with non-staged Data Source and Reporting.
• Created database layer and business layer, defining appropriate relationship between query subjects.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple
• Created reports that included functionality such as prompt pages, cascading prompts, Conditional filters etc.
• Developed Dashboard Reports using Report Studio using Cube Data Sources.
• Created Ad-hoc reports for user demonstration in Query Studio.
• Extensively worked on Analysis Studio to develop multi-dimensional analysis.
• Designed Transformer Models using Framework Manager IQD sources and built the cubes..
• Administered database, Cognos security and backups, tuning, configuration, and performance.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports (Query studio).

Environment: Cognos 8.2: Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection, Transformer, Oracle (SQL), SQL Server 2000 and Windows 2000.