SUMMARY

• Over 7+ years of experience in development and implementation of Business Intelligence Applications using Cognos BI tool.
• Worked with all modules of Cognos including Framework Manager, Report Studio, Analysis Studio, Query Studio and Cognos Connection.
• Experience in Cognos BI Server Installation and Configuration, configuring database server and web server connectivity for use with Cognos.
• Adept at creating metadata with relational model and dimensional model from data marts using Framework Manager.
• Developed detailed functional documents and technical design for reports.
• Experience in developing customized templates for uniformity in reporting.
• Detailed experience in creating List, Crosstab, Bar Chart, Repeater and Customized reports.
• Familiar with creating a dynamic dashboard with analytical knowledge and best practice to meet the business need.
• Experience in creating bookmark, drill up/down, and drill through reports.
• Developed various kinds of prompts and filters to increase retrieval speed without compromising on the scope of the reports.
• Experience in setting up Security prototype for cognos business intelligence environment incorporating data level, object level, and package level and report level security.
• Adept at using relational databases like MS SQL Server 2000 and 2005 and Oracle with Cognos.
• Have a clear understanding of Data warehouse architecture and building Dimensional Models.
• Excellent skills in writing SQL queries.
• Experience in interacting with all levels of end users to gather requirements for reporting.
• Experience in creating ODBC, XML, Native Metadata Data source connections.
• Good knowledge of Software Life Cycle Development process, with focus on Agile Scrum, Waterfall and Prototype mythology.
• Quantitative Finance background with strong mathematical aptitude and deep research skills.
• Extensive knowledge of sales, marketing, supply chain and finance KPIs.
• Excellent oral and written communication skills.
• Excellent team player with self - motivation and experienced in task prioritizing and time management.

TECHNICAL SKILLS

Operating Systems: Windows 9x/XP/2000/VISTA/7, UNIX

Databases: SQL Server, Oracle9i/10g/11g, DB2, SQL, PL/SQL, MS Access, ANSI SQL.

Reporting Tools: Cognos 10.2/10.1/8.4/8.3/8.2 BI, Impromptus 7/0/7.2/7.3, ReportNet 1.1, Spotfire

Cognos Tools: Framework Manager, Report Studio, Analysis Studio, Query Studio

MS Office: MS PowerPoint, MS Word, MS Excel, MS Outlook, MS Visio

SDLC Methodologies: Agile Scrum, Waterfall, Prototype

Business Skills: Functional Requirements Documentation, Requirement Prioritizing Techniques

Language: English, Chinese

PROFESSIONAL EXPERIENCE

Confidential, Columbus. OH

Sr. Cognos Developer/Analyst

Responsibilities:

• Worked in multiple phases of Software Life Cycle starting from the scratch to production delivery.
• Single point of contact for client for all reporting & database questions/concerns.
• Created and published packages for different subject areas with best practice, using Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.
• Created DMR model with Dimension and Hierarchies for providing drill downs & ups in Analysis Studio
• Created list, crosstab and chart reports and implemented drill-though conditions and Master-Detail relationships.
• Used various kinds of prompts like Value Prompt, Date and Time prompt, Cascading Prompts, etc. for better performance, also worked with customized prompts using HTML Items.
• Extensively used filters, calculations, conditional variables, multiple queries for data extraction in reports.
• Created conditional variables to change the graph headers and list column headers based on the user parameter selection.
• Multiple Report Pages usingPage Breaks and grouping/sorting.
• Created Burst Reports, distributed and scheduled reports in Cognos Connection.
• Used Union, Intersection, Except, and Join between queries in query explorer.
• Developed several active reports of Dashboard with tab control in Report Studio.
• Implemented Drill-up and Drill-down with advanced options.
• Deployed reports, models and cubes from Development to Test and Production environments.
• Developed Stored procedures and user defined functions using PL/SQL.
• Part of Unit testing and data validation of various reports that were developed in Cognos.
• Involved with making changes in the reports generated as business requirements changed and carry out validation and verification of the reports.
• Carried out performance tuning of reports, both on data base side and Cognos report and modeling side.
• Used Business Workspace / Insights and Business Workspace / Insights Advanced to arrange individual reports into dashboards.

Environment: Cognos 10.2, 10.1 (Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Workspace, Cognos Workspace Advance), Framework Manager, Oracle 11g, and SQL Server 2005, Informatica, TFS Version Control

Confidential, New York, NY

Sr. Cognos Developer/Administrator

Responsibilities:

• Involved in the installation and configuration of Cognos 8.4
• Security validation of user access/Data source access through Cognos Access Manager
• Involved in Requirement gathering from Business Users.
• Analyzed the requirements provided by the clients and Developed specification documents for reports as per client requirements.
• Developed new reports in Report Studio upon requests from business users
• Created and published Packages using Framework Manager.
• Implemented data level security, object level security and package level security using the Framework manager and Access manager.
• Designed & developed multiple reports using various templates like list reports, crosstab reports, chart reports, and complex reports with conditional blocks, static choices in prompt.
• Extensively used various Prompts, Drill-through, master-detail relationships, conditional formatting, grouping and sorting features, layout calculation of Report Studio to generate efficient and user-friendly reports
• Deployed packages, folders and reports from a development environment to Testing and Production environment
• Resolved issues resulting from User Acceptance Testing (UAT)
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports
• Created list, crosstab and drill through reports for departments like claims, billing, and members/subscribers.
• Created Burst Reports and Multilingual Reports based on groups of users & Preferences for our various partners.
• Defined hierarchies according to business requirements for Drill ability.
• Created some Complex interactive reports using conditional formatting.
• Deploying Sample, Testing the Server and Managing Cognos Connection Portal.

Environment: Cognos 10.1, 8.4, Transformer 8.4, Report Studio, Query Studio, Event Studio, Analysis studio, Oracle 11g, DB2, SQL Server 2008, TOAD

Confidential, Mount Laurel, NJ

Cognos Developer/Modeler

Responsibilities:

• Analyzed the functionality and business requirement and transformed the Functional Design Document into Technical Design Document
• Conducted User Interviews and documented their query, business analysis and reporting needs. Understood data and business logic with reporting viewpoint
• Install Multi-server Dispatcher Cognos installations for Dev/QA/Pseudo Prod/Prod Environments
• Install/setup Cognos 10.1 software. Upgraded the Cognos 8.4 content to Cognos 10.1. Troubleshoot upgrade problems/fix issues
• Created projects, designed models for reporting and created & published packages in Framework Manager from various data sources.
• Used Dimensional modeling (DMR) and Snow flake Schema modeling technique to develop models.
• Implemented Row Level Security in Framework Manger, Data Level, Object Securities and package Level Security in Framework Manager Models.
• Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, Page Breaks, Master-detail, Drill Through, Drill Down, and Drill Up).
• Developed complex Report Studio reports and Dashboard reports with dynamic drill down, expand collapse, on-click sort, Freeze headers & footers, hiding the same page prompts etc. using HTML, Java Scripts, Conditional formatting, stored process etc.
• Used Business Insight and Business Insight advanced to create the dashboard report widgets and other user interface functionalities.
• Developed and distributed complex Active reports using report studio for the senior management.
• Created and managed agents using Event studio, which monitors the data and performs the task when an event occur
• Used Cognos Transformer to build OLAP multidimensional cubes and used it in Dashboards.
• Developing OLAP Analysis Studio views of analysis from dimensional modeled packages.
• Created the scorecard reports using the Metric Studio.
• Analyzing all reports and standardizes these reports using Power Prompts and Charts.
• Used Cognos Connection for scheduling and bursting reports across the Business segments and providing additional security to published cubes as well as reports.
• Developed the mapping specifications from the business requirements and the data model. Involved in data modeling and design of the data warehouse.

Environment: Cognos 8.4, 8.3 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio, Business Insight and Event Studio), Cognos Transformer 8.4, Oracle10g, SQL Server, SSAS, Toad

Confidential, Peapack. NJ

Cognos Developer

Responsibilities:

• Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager.
• Developed Data warehouse design, Implemented Staging, QA and Prod Environments.
• Customized Cognos Connection with appropriate reports and security measures
• Involved in Designing DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Created User groups, Roles in Cognos Connection to implement the Security Features.
• Created Ad-hoc, List, Crosstab, Charts and Drill through Reports by using Query Studio and Report Studio.
• Created dynamic filter by using Value prompts, Cascading prompts and Tree prompts.
• Scheduled Reports to run on a monthly, weekly, and daily basis.
• Worked with Stored Procedure Query Subjects and Direct SQL reports in Report Studio.
• Developed Dashboards which can be easy for the users to understand and navigate.
• Involved in the Deployment of reports from Dev to Production
• Involved in Conditional Formatting like highlighting the data and to show or hide the data.
• Customized Cognos reports based on user specifications.
• Involved in Performance Tuning of the reports.
• Updated the reports according to the client requirements.
• Involved in the Testing of the reports.
• Implemented security with LDAP and Group level security in Cognos connection portal.
• Demonstrated and Trained Query Studio to various users and Developed various presentations.
• Developed SQL Scripts for testing the reports & developed Stored Procedures to build the Reporting Database for Exclusive Reporting.

Environment: Cognos 8.4, 8.3 and 8.2 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio), Cognos Report Net 1.1 MR2, Cognos Impromptus, PowerPlay 7.2, Cognos Transformer 7.2, Oracle 9i/10g (SQL, PL/SQL), SQL Server 2005

Confidential

Reporting Analyst

Responsibilities:

• Core team member of Cognos Business Intelligence implementation team putting strong emphasis on SDLC (Software Development Life Cycle) best practices.
• Assess technical requirements, existing infrastructure and data sources.
• Involved in modification of models and packages using Framework Manager for developing the Ad-Hoc reports in Query Studio by Business users.
• Modified the Models in Framework Manger and republished the packages to reporting server for report development.
• Developed List, Cross tab, Chart reports using Cognos functionalities like Conditional Formatting and set operations like union and joins in report Studio.
• Developed new reports using functionalities like Layout Component Reference where to reuse prompts, Report Header and Footer.
• Created the user defined classes in report studio and override the existing classes for formatting of the report.
• Scheduled the reports in Cognos Connection according to delivery schedules set by the users
• Burst the Reports against the regions, zones and districts for delivery the appropriate output for the concern mangers in Cognos Connections by email and saved these reports in the directory for analysis purposes of the internal users.
• Test cases and test plans for User Acceptance Testing.
• Involves in deployment of reports from Dev to Test to Prod.
• Design, develop and test new queries with end users.
• Enhanced the created reports and modified the reports according to the user requests.
• Created reports in Query studio for testing of the internal reports.

Environment: Cognos 8.3 (Framework Manager, Query Studio, Report Studio, Analysis Studio), Windows XP, ReportNet 1.1, Cognos Transformer, Oracle 9i, SQL Server