Summary:

• Around 8 years of experience in analysis, design and development of Business Intelligence applications using Cognos products.
• Extensive experience in various business sectors such as Finance, Insurance, and HR.
• Expertise in Cognos 10 Report Studio, Framework Manager, Business Insight, Business Insight Advanced , Cognos 8 BI suite Report Studio, Query Studio, Framework Manager, Cognos Connection, Analysis Studio, Event Studio, PowerPlay studio , ReportNet 1.1, Transformer, Cognos suite 7.x Impromptu catalogs, Impromptu Web Reports, Upfront and PowerPlay Enterprise Server.
• Expertise in developing complex reports using Cognos 10, 8, ReportNet, PowerPlay and Impromptu.
• Good experience in Conceptual, Logical and Physical data modeling with strong knowledge of Data-warehousing concepts, Dimensional modeling Star schema and Snowflake schema.
• Expertise in using Best Practices for dimensional and relational data modeling using Framework Manager.
• Experience in developing ETL processes using Microsoft SSIS, SSAS to extract, transform and load data from various source and archive systems into Data warehouses and Data marts.
• Extensive experience in database design, data analysis, development, SQL performance tuning, data conversions and user documentation.
• Strong experience in building cubes from multiple data sources in PowerPlay Transformer and published them to Upfront using PowerPlay Enterprise Server.
• Proficient in query optimization and improved report performance through use of index, aggregate tables and drill-thru functionalities.
• Expertise in installation, configuration and administration of Cognos products in a distributed multi-server environment.
• Hands on experience in Cognos Connection and security permissions, configuration and maintaining users, groups and roles using Cognos Administration.
• Hands on experience in administering, deploying and maintaining models, reports and cubes
• Strong Experience in user acceptance test, product support, version control and change management.
• Good understanding of Cognos TM1.
• Experience in setting up and configuring the entire OBIEE suite BI Server, BI interactive Dashboards, BI Answers, and BI Publisher etc. to meet business reporting needs.
• Team Player and have been successful in mentoring and guiding teammates, as well able to work independently with minimum supervision.
• Good communication skills with strong ability to interact with end-users, customers, and team members Enthusiastic, quick learner and strong desire to keep pace with latest technologies.

Technical Skills:

Operating Systems Windows, UNIX

Web Servers Microsoft IIS, Apache 7.0

Professional experience:

Confidential

BI Developer

A 10 billion integrated global health enterprise headquartered in Pittsburgh, Pennsylvania UPMC develops and delivers Life Changing Medicine by harnessing the power of technology, translating science into cures, and accelerating the pace of innovation worldwide.

Responsibilities:

• Worked on Active Reports to develop highly interactive and easy to use report.
• Worked on Business Insight and developed dashboard using prompt and multiple widgets.
• Experience on Cognos portal UI customization based on requirements.
• Developed user-friendly self-serve reports for business user, to perform business Intelligence analysis.
• Written complex SQL queries for the reports
• Created metadata models, Namespaces, Folders, Query Subjects and Packages from SQL Server 2008/Oracle 11g data sources using Cognos 10.1 Framework Manager.
• Developed Standard Reports, auditing reports, Dashboards, Tabbed reports Charts, Drill through Reports, Master detail Reports, Bursting Reports Using Report Studio and Query Studio.
• Defined Global Drill through Definitions on Cognos Report Studio.
• Came up with a plan on the list of reports and departments to target for the SSRS to Cognos move.
• Setting up regular meetings with the users point of contact in each department to get new reporting requirements and suggesting enhancements to the current reports.
• Understanding the present SSRS reports design and metadata structure.
• Developing equally enhanced and capable reports in Cognos.
• Testing the reports, and automating them for run delivery.
• Handling Cognos admin activities like managing user accounts, security rights for access to Cognos Portal, etc., in Active Directory.
• Supporting the current Cognos framework, updating objects and query definitions.
• Creating SSIS packages for data load and setting up the job on a schedule.

Environment: Cognos 10, Cognos Connection, Report Studio, Query Studio, Business Insight, Framework Manager, Analysis Studio, PowerPlay Transformer, PL/SQL, SSIS, SSRS, MS SQL Server 2008, Oracle 11g.

Confidential

Cognos Developer

A leading financial services company providing a range of services including Retail banking, Corporate Banking, Investment Banking, Asset Management and Credit Card services.

Responsibilities:

• Worked with business users, functional lead to understand and document the Business requirements.
• Planned and Created professional reports in Cognos 10, Report Studio and ad hoc reports in Business insight advanced.
• Created metadata models, Namespaces, Folders, Query Subjects and Packages from SQL Server 2008/Oracle 11g data sources using Cognos 10.1 Framework Manager.
• Developed Executive dashboards with Conditional Variables, JavaScript, Hyperlinks and Bookmarks for reporting, which included various charts, Crosstabs, lists, master-detail relationship Complex Drill-Through, Cascading Prompts, Summary Reports Burst Reports.
• Customizing Cognos Connection Portal based on the User Requirements.
• Performance testing and tuning of the reports dashboards for a quick runtime.
• Deployed packages, folders and content store from a development environment to test and production environments.
• Actively involved in the administration part of Cognos Connection for organizing, security, scheduling and distributing reports.
• Designed Dimension maps and developed Transformer models and cubes in Transformer.
• Built Effective Cognos Active Reports and dashboards.
• Written complex SQL queries for the reports.
• Hands-on with SSIS, including distributed operations and data warehouse ETL process flows.
• Reviewed data models with the data architect to ensure that the current design can support the business reporting requirements.
• Trained business users to use/develop reports using Report Studio/ Business insight advanced.

Environment: Cognos 10, Cognos Connection, Report Studio, Query Studio, Business Insight, Framework Manager, Analysis Studio, PowerPlay Transformer, PL/SQL, SSIS, MS SQL Server 2008, Oracle 11g.

Confidential

Cognos Developer/BI Consultant

Confidential

the largest insurers of vehicles, homes and small businesses and provides a wide range of other insurance and financial

Responsibilities:

• Worked with business users, functional lead to understand and document the Business requirements.
• Extensive experience in Framework Manager to create models, packages and publish packages.
• Built models containing namespaces, query subjects and query items from scratch as well as from imported metadata.
• Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Planned and Created professional reports in Report Studio and ad hoc reports in Query Studio.
• Developed complex Reports, Dashboards, YTD reports, Tabbed reports Charts, Drill through Reports, Master Detail Reports, Bursting Reports and Multilingual Reports Using Report Studio and Query Studio.
• Defined Global Drill through Definitions and established drill-through from Cognos 8 Analysis Studio to Cognos 8 Report Studio.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Integrated Cognos 8 with third-party security providers like LDAP and distributed Reports through bursting, e-mail and uploading to folders.
• Involved in understanding of Business Processes, grain identification, identification of dimensions and measures for OLAP applications.
• Created OLAP cubes using Transformer and published Power Cubes to Cognos Connection.
• Upgraded reports from 8.4 to 10 and customizing the Cognos Connection Portal based on the User Requirements.
• Scheduled Reports to run on a monthly, weekly and daily basis using Cognos Scheduler.
• Tuned performance in Cognos 8 for quick runtime of reports.
• Involved in the report testing and validating of the data it retrieves from the database.
• Trained business users to develop use reports using Report Studio Query Studio.

Environment: Cognos 8 10, Cognos Connection, Report Studio, Query Studio, Framework Manager, Analysis Studio, PowerPlay Transformer, XML , PL/SQL, SSIS, MS SQL Server 2005 2008, Oracle 11g.

Responsibilities:

• Involved in data gathering and developing models in Framework Manager and publishing packages onto Cognos Connection.
• Created model query subjects, parameter maps and established relationships required between different model query subjects and between model query subjects and data source query subjects according to the business needs.
• Deployed packages, folders and content store from a development environment to test and production environments.
• Extensively used prompts, summaries, and conditional formats, grouping and sorting features to generate efficient and user-friendly reports.
• Scheduled reports using Cognos Connection.
• Created Power Play multidimensional cubes using Power Play Transformer and created drill-through.
• Formatted data to analyze in drill mode and slice dice mode.
• Responsible in the weekly refresh of multiple multi-dimensional cubes.
• Worked on Cognos Security Administration to restrict the Users.
• Maintained the Cube Security by Category level and Dimension level.
• Coordinated in training sessions and demonstration of Cognos tools to End-users.
• Assisted users in troubleshooting their reports.

Environment: Cognos 8, Cognos Connection, Report Studio, Query Studio, Framework Manager, Metric Studio, Analysis Studio, Access Manager, Oracle 9i, MS SQL Server 2008, Windows XP.

Responsibilities:

• Involved in creating sophisticated reports using Cognos 8.4 Report Studio and Ad-hoc reports using query studio.
• Responsible for metadata modeling, data security, object security and package security in Cognos 8.4 Framework Manager.
• Responsible for creating various prompts, cascading of prompt pages, filters, calculation and used conditional formatting accordingly.
• Published packages on Cognos portal.
• Created Dashboards which include drill through reports and scheduled reports.
• In charge for Cognos admin activities by creating user classes, managing user accounts, security rights for access to Cognos Portal, etc., in Cognos Access Manager Administration Active Directory.
• Involved in preparing Test Scripts and validating the data based on the Scenarios.
• Involved in writing complex SQL Queries, Views, Stored Procedures for application integration between the Modules.
• Created and executed MDX Queries to extend the SQL Analysis Services SSAS OLAP Cubes.
• Deployment of SSIS packages and scheduling SQL Jobs.
• Proficiency in database migration and implementation.

Environment: Cognos 8 BI, Cognos connection, Report Studio, Query Studio, Framework Manager, Metric Studio, Analysis Studio, Access Manager, Oracle 9i, XML ,Windows XP.

Confidential

IT Consultant

Responsibilities:

• Created reports Report/query studio which cater to different employees at different levels.
• Migration of reports, catalogs, cubes from Cognos series 7 to Cognos series 8.
• Created new packages from model and publish to Cognos server.
• Analyzed the requirement and build complex SQL Queries and backup restore scripts for SQL Server as needed.
• Creating complex models using Framework manager.
• Dashboards and Drill-through reports for the complete management hierarchy.
• Interacting with the user to get the detailed information about the issues.
• Preparing and testing the code to fix the issues in Development and QA environment.
• Involved in Preparing the ETL Spec, developing data mappings based on the spec and creating packages for scheduling and refreshing the cube in periodic basis.

Environment: OBIEE, Cognos 8, Cognos Connection, Report Studio, Query Studio, Framework Manager, Metric Studio, Analysis Studio, Access Manager, MS SSIS 2005, MS SQL Server 2005, Oracle 9i, Windows NT/2000.