SUMMARY

• Over Eight (7) years of Experience in Designing and development of relational database applications with expertise in Cognos BI Applications like Reporting, design development, Performance Tuning, Application Development and product support on various platforms.
• Worked with Business Users to analyze the business process and made necessary changes to schema objects to cater their reporting needs.
• Hands on experience in Analysis, design and development of Data Warehousing, Business Intelligence, Reporting and Project Management applications using Cognos.
• Recent experience with Cognos 10 - Framework Manager, Cognos Connection, Report Studio and Query Studio, Business Insight, Active Reports.
• Extensive experience on Cognos 8 with Framework Manager, Analysis Studio, Cognos Connection, Report Studio and Query Studio.
• Strong experience in the development of various reports using SQL, PL/SQL, Cognos Impromptu, Cognos PowerPlay, Cognos Visualizer, Impromptu Web Reports (IWR), ReportNet (Report Studio, Query Studio) using databases such as Oracle 10g/9.x/8.x/7.x, Teradata, SQL Server 2000/7.0/6.5 , DB2 and MS Access.
• Performed user acceptance testing and end user training for Cognos Users and involved in Data validation and testing procedures.
• Have good exposure on Informatica (Power Mart/Center, Meta Data Repository, Designer, and Work Flow Manager) for Data Extraction, Transformation and Loading (ETL).
• Check performance issues for reports to make sure to use best sources to reduce production expenses from Business Objects and Cognos.
• Solid analytical and dynamic troubleshooting skills. Possessing excellent communication skills and is able to work individually and as a team member.
• Extensively used RDBMS like Oracle and SQL Server for developing different applications.
• Installed and Configured Cognos 8.4 BI, Framework Manager and Cognos 8 Transformer. Configured Cognos 8 Content Store Database and IIS web server.
• Check performance issues for reports to make sure to use best sources to reduce production expenses from Business Objects and Cognos.
• Performed system analysis, design and user training and system maintenance and support.

TECHNICAL SKILLS

Hardware and OS: Windows XP/7, Windows 2003/8, UNIX and MS DOS

Languages: Java, JSP, C, C++, SQL and PL/SQL

Cognos BI Series 8: Cognos version 8.3 & 8.4, Cognos Connection, Metric Studio, Query Studio, Analysis Studio, Report Studio, Event Studio, Framework Manager, Cognos 8 Go Office, Office Connection, Metrics Designer, Metric Studio, Map Manager

Cognos BI Series 10: Cognos version 10.1, Business Insight, Business Insight Advanced, Active Reports, Report Studio, Framework Manager, Cognos for MS Office, Cognos Analysis for MS Excel

ETL Tools: Informatica Power Mart v8.1/7.0 & Power Center v8.1/7.0, Microsoft SQL Server DTS 2005/8.

Data Modeling Tool: Erwin 3.5.2/4.0

Databases: Oracle 10g/9i/8.i/7.x, MS SQL Server 2008/2005, Sybase, DB2

DB Tools: SQL*Plus, SQL*Loader, TOAD 8.3/7.6

Testing Tools: Mercury Tools Load Runner, Win Runner and Test Director.

Web Servers: IIS, Apache.

PROFESSIONAL EXPERIENCE

Confidential, Warren, NJ

Senior Cognos Developer

Responsibilities:

• Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Involved in Designing models with Relational Data using Framework Manager and deployed packages to the Cognos Reporting Servers.
• Implemented data level, object level and package level security in framework manager to achieve highly complex security standards.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio.
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting.
• Upgraded Framework Manager Models, Transformer Cubes from Cognos Version 8.4 to 10.
• Created cubes in Transformer using various data sources.
• Developed Dash board reports to display all the information related to environment using Summary reports.
• Created Master Detail reports, drill through and custom prompting reports, and Scheduled reports for efficient resource utilization.
• Created optional filters/prompts in report studio using Java Script and HTML.
• Worked on Analysis Studio to develop multi dimensional reporting.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Created and performed testing strategy and test plans for any changes/upgrade to Cognos Reports.
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production
• Deploying models and reports from Development to Production and administering users/groups/roles.
• Assisted Quality Assurance Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas
• Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support.

Environment: Cognos 10/8.4 (Framework Manager, Report Studio, Analysis Studio, Query Studio), Cognos Power Play Transformer v7.4, Cognos SDK, Web Sphere application server, JSP, HTML, Java, Shell Script, Sybase 12.5, Sybase IQ 15.0, DB2 v8.1, Linux

Confidential, New York, NY

Cognos Developer/Administrator

Responsibilities:

• Installed and Configured Cognos 8.4 BI in single server Environment.
• Worked with our Business Analysts in order to reach the requirements of our End Users on time.
• Created Multi Dimensional Models (DMR) and Relational Models and published the packages using Framework Manager and then generated reports based on these packages.
• Implemented Star Schema Grouping and Dimensional Hierarchy in Framework Manager Model.
• Designed & developed reports from the Data warehouse using Cognos 8.4 report studio, Analysis Studio reports.
• Involved in defining Relationships and Cardinality between query subjects, Built models containing query subjects, query items, and namespaces from scratch as well as from imported metadata in Frame work manager.
• Developed reports using various functionalities like Drill through, Master Detail, Conditional Formatting, Conditional Blocks and multiple Prompts in Boards.
• Working experience with different date functions like YTD, QTD, and MTD in Report Studio
• Extensively worked on Analysis Studio to develop multi dimensional reporting.
• Designed OLAP Reports using most of the Report studio features (Conditional Formatting/Page layout, Sections, page Breaks, sorting, summaries, grouping, Drill Down, Drill Up).
• Created Dashboards with the selection criteria defaults by user role to help pre-select a subset of data that is most critical and most relevant for the users.
• Created HTML and Java Scripts to default the values in the Prompts and also to default the search options for the prompts in Prompt page
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos
• Involved in the entire project of migrating reports and cubes from Cognos 7 to Cognos 8.2 and creating project documentation for future use
• Developed stored procedures, triggers and complex packages using PL/SQL.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Trace, Stored Outlines.

Environment: Cognos 8.4 (Report Studio, Analysis Studio, Event Studio, Metric Studio, Query Studio), Cognos Power Play Transformer v7.4, PPES, Web Sphere application server, Java, Shell Script, Oracle 10g, MS SQL Server 2005, Win 2K, HP-UNIX

Confidential, Hartford, CT

Senior Cognos Consultant

Responsibilities:

• Work with project managers, business analysts and end users to understand business requirements and translating them to technical specifications.
• Involved in analyzing, documenting functional and technical requirements for developing packages and reports.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Proven experience building ad-hoc and complex reports using prompts and parameters in Report Studio and Query Studio.
• Involved in designing Models using Framework Manager.
• Moving applications from one server to other using Deployment Manager.
• Involved in setting up sign-on for Groups/Roles to secure the Models and packages.
• Developed reports using various functionalities like Drill through, Master Detail, Conditional Formatting, Conditional Blocks and multiple Prompts in Boards.
• Created Reports using multiple data providers like Packages, Personal data files, Stored Procedures and Free Hand SQL.
• Also involved in planning a model which help the business in making suitable decisions.
• Experienced in creating security setup in Cognos 8 BI environment.
• Developed list, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query, Burst Reports against database.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.

Environment: Cognos 8.3 BI Series, IWR, Power Play, Framework Manager, Oracle, SQL Server, PL/SQL, Windows 2000, Microsoft Excel, Microsoft Word.

Confidential, Detroit MI

Cognos Developer

Responsibilities:

• Installed and configured Cognos 8.2 in Dev in Multi server Distributed environment
• Created different types of reports like List, Cross-tab, Drill-Thru and Master-Detail Reports.
• Created multiple Dashboard reports for multiple packages.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters.
• Involved in extensive use of conditional formatting while developing reports in Report Studio.
• Initiated training for the users to do ad-hoc reporting using Query Studio.
• Extensive experience on Structuring Metadata and Cognos Models using Framework Manager.
• Provided support for slowly changing dimensions in data marts.
• Designed and Prepared a Training Material for the Users.
• Implemented Security for Data access, Object level access and Package access.
• Used Cognos Connection extensively for organizing, security, scheduling and distributing reports.

Environment: Oracle 10g, DB2, Sun Solaris, Power Play Transformer 7.3, Cognos 8.2 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection)

Confidential, Minneapolis, MN

Cognos Developer

Responsibilities:

• Managed Product data by developing Framework Manager Metadata Model in Cognos 8 MR2.
• Developed Relational Models well as Dimensional Model (DMR) with use of hierarchies for advanced functions.
• Created various complex reports in crunch time to meet the deadline. Reports included complex calculations using various functions, filters and multiple HTML formatting.
• Tuned the performance of the reports by using the metadata compression method.
• Created Templates by gathering Requirements from Business Analysts.
• Created Dashboard reports for business users.
• Developed Standard Reports, Charts, and Drill through Reports, Master Detail Reports and Bursting Reports using Report Studio.
• Developed reports with Prompt pages with HTML items, Multiple Report Pages with Page Breaks and Conditional Variables.
• Fixed the errors in yearend critical Ad-hoc Reports.
• Provided Production support for managed reports and the users Ad-hoc reports.
• Created job aids for Business users in Query Studio, Analysis Studio and Cognos Connection.

Environment: Cognos 8 BI, Analysis Studio, Event Studio, Framework Manager, Metrics Studio, Cognos Connection, Report Studio, Query Studio, Cognos Configuration Manager, Content Manger, Windows 2000, Oracle 9i, PL/SQL.

Confidential

Cognos Reports Developer

Responsibilities:

• Generated reports using Cognos ReportNet 1.1.
• Created List Reports, Cross Tab Reports and Chart Reports.
• Customized data by adding calculations, summaries and functions to the report.
• Experience in creating multi-prompt reports with drill-through capabilities.
• Created summary & detailed Filters, Conditions and Prompts in reports using Catalog and Package.
• Changing Filters, Exception Highlighting, Sorting.
• Designed web based transaction reports in ReportNet 1.1.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos connection in ReportNet
• Scheduled the execution of report in multiple formats.
• Queried data from different database tables as per the requirement using SQL PLUS.

Environment: Cognos ReportNet (Report Studio, Query Studio), ReportNet SDK, SQL, Oracle 9i, Solaris 9, IBM DB2, Informatica, Windows 2000/NT