Summary

• Over 7 years of IT industry experience with analysis, design, testing, development and implementation of client/server applications.
• Well experienced in working with the users to define and create the business functional requirements.
• Strong business understanding of Retail, Financial, Banking and service oriented industries.
• Expertise in documentation for building the client/user applications.
• Experience in Data Warehousing projects and methodology. Created physical data, logical data and enterprise models for different organizations.
• Around 6 years of experience with IBM Cognos Tools such as Cognos 10.x/8.x Suite, Cognos 7.3 and Analysis Tools such as Cognos Transformer Power Play 6.x/7.x/8.x.
• Created dimensional and relational models using IBM Cognos Framework Manager Tool 8.x Suite .Imported and published cubes using Framework Manager.
• Created Dashboards, Scorecards using Report Studio.
• Experience in creating simple and complex reports using Report Studio. Applied conditional formatting, conditional blocks, and different kinds of prompts for charts, graphs, list and crosstab reports.
• Knowledge in OLTP/OLAP, RDBMS, ODS systems. Analyzed conceptual, logical and physical data models at an enterprise level.
• Hands on experience with implementation of full life cycle Cognos BI projects, which includes requirement gathering and analysis, documentation, development, testing, implementation and maintenance/production support.
• Creation of High Level Design Document HLD , Business Requirement Document BRD , Data Flow Diagram DFD , Test Cases, Guideline document, Best Practices and User Manual.
• Interaction with customers and trained business users in Cognos 8.x suite and Cognos 7.

Confidential

Professional Summary

Sr BI Developer Cognos

Responsibilities:

• Involved in gathering business requirements and designing functional Specifications for Cognos reports from SME's
• Involved in preparing Functional Specifications, Technical Specifications, Testing Plans and other documentation as required by SDLC.
• Created database layer and business layer defining appropriate relationships and cardinality between query subjects in Framework Manager.
• Created role-based permissions and views.
• Used to perform Backup and recovery in cognos using import export utilities.
• Created user groups and assigned security using Access Manager.
• Created reports using drill-through and drill down functionalities
• Developed Reports using Conditional Formatting, Conditional Blocks, Cascading Prompts, Optional prompts.
• Bursting and scheduling the reports using Cognos Connection.
• Experience in Change Process Management.
• Developed multidimensional reports based on Cognos cubes and third party OLAP sources.
• Worked closely with the DBA for SQL tuning, implementing indexes to make sure that the reports are running fast and smooth.
• Performed Unit /QA testing and bug fixing.
• Participated in the User Acceptance Testing UAT of Cognos Cubes and Reports and provided necessary assistance to the users during User Acceptance Test.
• Provided technical assistance, training and mentoring to Users and Business Partners

Environment: Cognos 10.1.1 Framework Manager, Report Studio, Query Studio, Events Studio, Metric Studio, Cognos Configuration, Cognos Connection, Business Insight, Business Insight Advanced, Active Directory, IIS Data Stage 8.5, TWS 8.5.1, Clear Case, Oracle11g, PL/SQL, TOAD and Windows

Confidential

Cognos Developer

Responsibilities:

• Administered the Reporting Environment
• Involved in building Multidimensional Cubes, Sub cubes for user groups using Power Play Transformer
• Developed data specific reports with various filter conditions to retrieve specific data
• Created Trend Over Time Reports, Productivity, Variance Reports and Finance Reports
• Developed Several Reports including burst reports
• Created and performed the Unit and Integrity test cases and assisted the testing team in System Test and Production move process
• Conducted workshops to provide end user training
• Involved in understanding requirements for report design
• Created Cognos Meta Data Package using Framework Manager.
• Created master-detail relationship reports based on a time period and trend over time reports using Report Studio.
• Worked on subset and join of queries for complex reporting.
• Created reports in Analysis Studio using cubes and DMR models.

Environment: Cognos 8.4 BI Framework Manager, Report Studio, Analysis Studio, Query Studio , MS SQL Server 2007

Confidential

Cognos Developer

Responsibilities:

• Generated SQL analyzed Cognos SQL, Native SQL to troubleshoot the report issues.
• Applied Cascading Prompts functionality in runtime for narrowing the final results for better understanding of the requirement.
• Used Drill-up/down and Drill through functionalities to give a detailed and analytical report.
• Created complex reports with advanced features such as Master detailed sections, Conditional formatting, Page Set, bursting, Render Boolean variables using Report Studio.
• Developed Simple List, Nested Cross tab, Chart, Drill through reports.
• Designed developed reports using Report Studio, created ad-hoc reports using Query Studio and helped business user in creating Analysis reports using Analysis Studio.
• Created stand-alone filters and embedded filters while creating a model by using Cognos Framework Manager.
• Built models containing namespaces, level hierarchies, query subjects, query items and members from scratch as well as from imported metadata.
• Designed and developed the Framework Manager Models and Published into server for further use in the report authoring process.
• Provided End User Training sessions.

Environment: Cognos 8.4 BI Framework Manager, Report Studio, Analysis Studio, Query Studio , MS SQL Server 2007

confidential

Cognos Report Developer

Responsibilities:

• Analyzed the reporting requirements, data sources and current systems that are used for modeling and reporting data.
• Highly responsible to define and create the business functional requirements for the client.
• Responsible for analyzing the technical/functional requirements and providing the documentation for building the client/user applications.
• Worked closely with ETL team to get the data structured according to the reporting needs.
• Created standard filters, calculations, and conditions in FM Models.
• Designed and developed metadata model packages using Framework manager and published packages with appropriate security settings to cognos connection.
• Involved in few Admin roles like setting up Groups/Roles to secure the Models and Packages whenever required.
• Installed and configured all Cognos8 Tools like Report Studio, Query Studio, and Analysis Studio.
• Implemented security for reports using Cognos Connection.
• Created standard Calculations, Filters, and Prompts for Ad-hoc queries.
• Created complex reports with Cross tab and conditions to fulfill the business requirements.
• Created multi page report based on multiple queries using Prompts and Parameters.
• Developed complex reports using Conditional blocks, Conditional layouts, Conditional formats and Master Detail Drill through definition reports in Report studio, simple and ad-hoc reports in Query studio.
• Created jobs and scheduled the jobs using Schedule Management in Cognos Connection.
• Scheduled Daily, weekly, Monthly and Quarterly and distributed reports using Schedule Management in Cognos Connection.
• Defined roles that will have access to two types of reports: reports published and scheduled in Cognos 8 portal Canned reports and provided security levels for reports.
• Created/Updated Multi-dimensional Power Cubes with Power Play Transformer by using IQD's as data sources.
• Developed Power Play cubes which involved model definition in Transformer, used multiple queries, Calculated Measures, Customized cube and Optimized Cube creation time.
• Performed unit testing during defect fixing cycle using AQT.
• Have good understanding of Cognos BI security models and was able to identify best practices for configuring applications and work with the development teams to implement the standards.
• Provided training and knowledge transfer to client report developers.

Environment: Cognos 8.3/8.4 BI Framework Manager, Report Studio, Analysis Studio, Query Studio , Cognos 10, Power Play Transformer, UNIX, Oracle 10g

Confidential

Cognos Consultant

Responsibilities:

• Interacted with business users to gather business requirements and designed functional and technical documentation.
• Designed and developed the Framework Manager Models and Published into server for further use in the report authoring process.
• Built models containing namespaces, level hierarchies, query subjects, query items and members from scratch as well as from imported metadata.
• Created Stored Procedure query subject with a prompt value into the model while creating a package in Framework Manager.
• Developed Multidimensional Models Cubes using Cognos PowerPlay Transformer.
• Created stand-alone filters and embedded filters while creating a model by using Cognos Framework Manager.
• Developed Simple List, Nested Cross tab, Chart, Drill through reports.
• Created complex reports with advanced features such as Master detailed sections, Conditional formatting, Page Set, bursting, Render Boolean variables using Report Studio.
• Used Drill-up/down and Drill through functionalities to give a detailed and analytical report.
• Applied Cascading Prompts functionality in runtime for narrowing the final results for better understanding of the requirement.
• Created Dash Board Reports using Report Studio MDX functions and added to the portal page.
• Implemented Data level, Object level and Package level security in Framework manager to achieve highly complex security standards.
• Scheduled and distributed reports to the end users by schedule management in Cognos Connection.
• Generated SQL analyzed Cognos SQL, Native SQL to troubleshoot the report issues.

Environment: Cognos 7.0 BI Impromptu, Decision Stream , Cognos 8.0, Power Play windows/web, Transformer, UNIX, Oracle 9i, Windows 2003 server.

Confidential

Cognos Consultant/Report Author

Responsibilities:

• Co-facilitate client workshops and training, typically small to medium group of clients.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Developed dashboard reports using MDX Functions.
• Interacted with the end users on a regular basis for resolving issues pertaining to the reports.
• Designed developed multiple reports using various templates like list reports, cross-tab reports and chart reports.
• Designed developed the reports using Cognos Report Studio, Query Studio.
• Designed and developed the Framework Manager models and published them into server.
• Analyzed the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Involved in Requirement gathering from Business Users.
• Provided End User Training and Support.

Environment: Cognos Report Net Cognos Connection, Framework Manger, Report Studio, Query Studio Oracle 9i, Cognos Access Manger, C , Windows 2003 Server.

Confidential

Responsibilities:

• Responsible for requirement definition, analysis, scope and time estimation for Cognos reports
• Responsible for solving users technical/functional issues
• Involved in installation and evaluation of report net Framework Manager, Query Studio, Report Studio and Cognos Connection
• Defined metadata modeling created packages by using framework manager and published those packages into Cognos connection
• Created complex reports by using Report Studio
• Developed Power Play cubes which involved model definition in transformer, used multiple queries, calculated measures, customized cube content and optimized cube creation time
• Used direct SQL code to create reports by using union function
• Trouble shooting and tuning of reports for better performance

Confidential

Cognos Application Developer

Responsibilities:

• Created catalogs with the help of Impromptu utilizing relational databases.
• Developed impromptu reports using different functionalities like Drill through, and Cascading prompts.
• Created templates utilizing Impromptu, Created ad hoc reports utilizing Cognos Query.
• Created user prompts, conditions and filters to improve report generation.
• Created hierarchies to provide drill-down options for end-users.
• Created powerplay cubes using powerplay transformer to permit multi-dimensional cross sectioning and drilldown analysis.
• Coordinated training sessions and demonstrated Cognos tools to end-users.
• Used various OLAP query/reporting tool to maximize or reinforce the data delivery function in a data warehouse environment.
• Provided support to projects for new applications / report needs.
• Provided technical support to other team members in all supported areas.

Environment: Impromptu 6.0 Transformer 6.6 and Power play windows and Web Internet Information Services IIS 5.1, MS SQL Server, Windows 2000.