SUMMARY

• Over 8 years of experience in Information Technology, with over 6 years of extensive experience in analysis, design and development of Business Intelligence applications using Cognos products
• Extensively used Cognos BI in delivering reporting solutions in healthcare, insurance, pharmaceutical, banking and telecom domain.
• Experience working in the field of Business Intelligence as a Report Writer/Cognos Developer/Modeler.
• 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.
• Experience in Data Modeling - Relational, Multidimensional and DMR (dimensionally-modeled relational) modeling in Framework Manager.
• Used Best Practices for dimensional and relational data modeling using Framework Manager.
• Experience in building and maintaining Powercubes in Transformer using relational, DMR and OLAP packages as data sources
• Developed various Complex reports using Cognos 8, ReportNet, PowerPlay and Impromptu
• Performed 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.
• Involved in administration in Cognos Connection and security implementation among Cognos Applications. Performed administrative roles in Cognos Connection and set security permissions, configured and maintained users, groups and roles using Cognos Administration.
• Good communication skills with strong ability to interact with end-users, customers, and team members.
• Good analytical, problem solving and interpersonal skills. Ability to work on a team environment or independently and handle multiple tasks concurrently.

TECHNICAL SKILLS

BI Tools: IBM Cognos 8.x BI (Report Studio, Query Studio, Framework Manager, Cognos Connection, Analysis Studio, Event Studio, PowerPlay studio), Cognos 10 (Report Studio, Framework Manager, Business insight), ReportNet 1.1, Transformer, Cognos suite 7.x (Impromptu catalogs, Impromptu Web Reports, Upfront)

Programming skills: SQL, PL/SQL, C, C++

Scripting Languages: JavaScript, VB Script, PHP

Databases: Oracle 9i/10g/11g, SQL Server 2003/2005/2008, DB2

Tools and Utilities: SQL Developer, Toad, Erwin, Microsoft Visio, Rational Requisite Pro

Operating Systems: Windows, UNIX

Web Servers: Microsoft IIS, Apache 6.0/7.0, Apache 2.0

PROFESSIONAL EXPERIENCE

Cognos Report Developer

Confidential, Hoboken, NJ

Responsibilities:

• Analyzed and explored user needs and gathered requirements to meet the reporting needs in the organization.
• Created functional and technical specification documents to the functional and technical details of the reports including scope of the project/report, design specifications, report layout, filters, prompts, formatting details, security, design dependencies, technical mapping, etc.
• Involved in the process of importing metadata from Oracle 10g & Oracle 11g into framework manager and checked and corrected the Usage properties and dependencies of the query subjects and followed the best practices for metadata modeling.
• Involved in modifying existing models to changing reporting requirements as well as creating new models using Framework Manager.
• Created reinsurance based reports like Client Summary, Market Performance, Contract Analysis, Participation Report, etc. to replace the old CICS applications.
• Developed simple to complex reports using lists, crosstabs, gauge charts & graphs to meet user requirements.
• Extensively used parameters and a variety of prompts to help users in customizing the information in the reports to suit their own needs.
• Involved in the process of creating a management dashboard using gauge charts, tables, lists, prompts, filters and conditional highlighting. Provided drill-thru report functionality from the dashboard to a detail reports in Excel and established master-detail relationship between related query items.
• Extensively used insertable objects like query calculation, layout calculation,repeaters, blocks & tables to generate efficient and user-friendly reports.
• Used detail, summary and context filters to focus a report by excluding unwanted data.
• Used Conditional Blocks, Summaries, Grouping & Sorting features of Report Studio.
• Used render variables and data items to hide report pages that were not required with a particular radio prompt selection and highlighted particular measures that are of interest to the user.
• Enhanced reports by using various aggregate functions and oracle functions to match the user requirements.
• Frequently used ‘if then else’ or ‘case when’ constructs in Report Studio in filters, data items and calculations.
• Used Javascript to modify the objects on prompt pages to meet the user report specifications.
• Create complex Queries using joins and set operations like union, intersect & except for creating lists.
• Created different active reports using Cognos 10 and dashboard reports using Business Insight.
• Used best practices and techniques to improve report performance.
• Used SQL Developer for testing data-level errors & cross-checking values in the database by running SQL queries.
• Participated in creating and modifying existing tables to accommodate for report changes and new requirements.
• Involved in the process of creating patches and migrating reports into different environments.
• Used Cognos Connection for creating jobs, scheduling and bursting reports across the Business Segments.

Environment: Cognos 8.2 (Report Studio, Framework Manager), Cognos 10 (Report Studio, Framework Manager, Business insight), Cognos Connection, Access Manager, SQL Developer, Oracle 10g, Oracle 11g, Windows Server 2003

Cognos Developer/Analyst

Confidential, Atlanta, GA

Responsibilities:

• Analyzed the user needs and gathered the requirements for reporting purposes.
• Imported metadata by creating database connections for different data sources like Oracle and MS SQL in Framework Manager
• Involved in designing models using Framework Manager and published them.
• Used Transformer to create cube groups based on sales territories for different regional managers.
• Used various techniques to improve report performance.
• Created various business mix and trend over time reports using Report Studio.
• Created claims summary reports with multiple measures for different years.
• Generated financial reports related to revenue generated vs. cost comparison for each product line and sales region.
• Used detail, summary and context filters and row suppression to focus on the more relevant part of a report.
• Designed a high level graphical view of company’s performance indicators in a dashboard report using a crosstab, column chart and a gauge chart.
• Created a Bonus Report that shows the employees that received bonus in an year by region using list reports, page sets, multiple prompts, filters, grouping, conditional highlighting and conditional rendering
• Created multiple paged professional reports with table of contents and bookmarks, to provide easy access to data.
• Worked on Report Studio to create calculated columns to measure the Gross Profit and Net Profit in terms of Revenue.
• Used Render variables and data items to hide confidential information in the reports.
• Provided drill-thru report functionality with drill thru to a different report in Report Studio.
• Used Analysis studio for slicing and dicing of the cubes
• Managed scheduling of reports, maintenance of public and individual folders, users, groups and roles using Administrative tools in Cognos 8
• Provided training and support to internal clients and end-users on Query studio, Analysis Studio and the Cognos portal.

Environment: Cognos 8.4 (Query Studio, Report Studio, Analysis Studio, Framework Manager), Cognos Connection, Transformer, Access Manager, MS SQL Server 2008, Oracle 11g, Windows 2005.

Cognos Developer

Confidential, Tampa, FL

Responsibilities:

• Involved in the entire project life cycle from evaluation, installation and development of end user reports.
• Gathered and analyzed requirements and reporting issues from the users.
• Involved in streamlining existing models to current requirements as well as creating new models using Framework Manager
• Designed relational and dimensional models in Framework Manager by defining cardinality and joins between query subjects
• Built OLAP cubes, customized cubes for users by creating cube groups, applied security with custom & dimension views.
• Worked with different types of reports such as list, crosstab, charts and applied advanced grouping and sorting options, and advanced formatting options including conditional formatting, style variables, and render variables.
• Created various trend over time, variance and financial reports using report studio.
• Used detail, summary and context filters and row suppression for making the report more relevant and user friendly.
• Used different kinds of prompts like tree prompt, value prompt, date and time prompt and cascading prompts to provide a selection choice for the type of health plan (by member, broker, employers, providers, etc.)
• Published list reports with charts with the user choice to select the type of view and toggle between the reports.
• Used Analysis Studio to perform slicing and dicing of the cubes.
• Provided end user training and support for Cognos 8

Environment: Cognos 8.3 (Report Studio, Query Studio, Analysis Studio, Framework Manager), Access Manager, Transformer, Oracle 10g, MS SQL server 2005, Windows Server 2003

Cognos Developer

Confidential, Fort Worth, TX

Responsibilities:

• Gathered the reporting issues from the users and analyzed user requirements.
• Involved in migrating metadata and reports from Cognos 7.4 to Cognos 8.2 using utilities.
• Assessed the scope for migration and used different approaches of Lift & Shift, Compress & Optimize wherever necessary for migrating cubes and catalogs.
• Created multiple data source connections for importing different data sources into Framework Manager.
• Designed relational and DMR models in Framework Manager and published packages to Cognos.
• Implemented data security, object security and package security in Framework Manager.
• Creating list reports, cross-tab reports and chart reports using multiple queries in a single report, drill- through reports and conditional formatting to highlight the business needs.
• Created multi-query and ad hoc reports in the report studio and query studio and developed many complex reports for financial analysis.
• Used detail, summary and context filters for making the reports more specific.
• Used conditional formatting, conditional styles and Style variables to render reports for different user needs.
• Created calculated columns to measure the Gross Profit, Net Profit, and Burden in terms of Revenue.
• Created a toggle report that swaps a report layout as list or chart.
• Developed monthly Product Sales Trend, Transactions History and Backlog reports filtered by regions in Analysis Studio.
• Created Sales analysis and summary reports for current year and previous year using Analysis Studio
• Scheduled reports in the Cognos Connection portal to use off-peak hours effectively.

Environment: Cognos 8.2(Framework Manager, Query Studio, Report Studio, Analysis Studio), Cognos Connection, Transformer, Cognos 7.4 (Impromptu, PPES, Upfront, IWR), Access Manager, MS SQL Server 2005, migratetoc8, deploytoc8

Cognos Report Developer

Confidential, Lexington, KY

Responsibilities:

• Gathered requirements, created documents to clarify functional specification during the Planning and analysis phase of the project.
• Created appropriate roles, users, database signons in Access Manager and provide different levels of authentication and provide the security to different users.
• Created jobs, scheduled them and modify the sequence in which the job steps can be executed.
• Created reports such as list, crosstab, charts and applied advanced grouping and sorting options.
• Created multiple page reports with Table of Contents, Bookmarks and links to other relevant pages.
• Provided the selection choice to the user with different kind of prompts like tree prompt, value prompt, date and time prompt and cascading prompts.
• Created advanced formatting options including conditional formatting, style variables, and render variables.
• Established master-detail relationship between related query items in Report Studio
• Created query calculations and layout calculations in Report studio.
• Provided drill-thru report functionality with drill thru to the same report and to an external report
• Created detailed, summary and context filters and worked extensively with summary functions.
• Created financial reports and statistics to cover daily, monthly, quarterly, half-year and annual historical information with detailed analysis.
• Developed financial reports and business mix reports using query studio, Analysis studio and Report Studio.

Environment: Cognos 8.1(Framework Manager, Report Studio, Query Studio, Cognos Connection), Oracle 9i, Access Manager, Windows 2003.

Cognos Developer

Confidential ., Miami, FL

Responsibilities:

• Primary responsibilities include functional analysis with management to understand and validate business requirements.
• Imported metadata from multiple data sources into the Framework Manager for metadata modeling and provided package and data level security.
• Created complex reports such as Customer Invoice, Portfolio reports and Product Analysis reports.
• Worked on list reports, cross-tab reports and chart reports using multiple queries in a single report and conditional formatting to highlight the business needs.
• Used different features like calculation, summary, grouping, header and footers to create an invoice report.
• Used conditional formatting, conditional styles and Style variables to render reports for different users.
• Created multiple paged, multiple-query reports using multiple prompts for showing selective data on user input.
• Created query calculations, layout calculations and used case construct and If then else for customized analysis in the reports.
• Used Table of Contents and Bookmarks to created multiple page reports with for easy access to data

Environment: ReportNet 1.1 (Framework Manager, Report Studio, Query Studio, Cognos Connection), Oracle 9i, Toad, Erwin, Windows 2003.

Cognos BI Author

Confidential

Responsibilities:

• Developed visualization reports and Dashboards using Cognos Visualizer.
• Created Impromptu reports with various filter conditions to retrieve specific data.
• Applied drill through for the reports to get detailed information of a particular field in another report.
• Included prompts for the reports to filter the data based on the selection.
• Developed Monthly, Quarterly, YTD and other detailed list reports using Impromptu.
• Developed Business Mix Reports, Financial Reports using PowerPlay.
• Administered changes to PowerPlay Cube based upon changing requirements.
• Worked in a team to build multidimensional cubes using PowerPlay Transformer.
• Published cubes and OLAP reports to the Upfront server.
• Gathered and analyzed user requirements, and developed requirement specifications and process diagrams including context, dataflow and decomposition diagrams.
• Used MS-Visio for model diagrams, MS-Word for documentation and used Unified Modeling Language (UML) for visual modeling.
• Worked with system analysts to create application’s functional and non-functional requirement document using Rational Requisite Pro.
• Worked closely with the development team to communicate client requirements.
• Practiced Rational Unified Process methodology during all phases of software development lifecycle;
• Create and maintain internal web sites using PHP, MySQL, JavaScript
• Formulated the test plan, procedures and written test cases. QA testing for new reports and databases during development stages.
• Reviewed and validated design documents against Requirements Specifications.

Environment: MS Word, MS Visio, Rational Requisite Pro, PHP/ MySQL, HTML, XML, Apache, Windows XP