SUMMARY

• 8+ Years of experience in Business intelligence reporting, development, analysis, design, testing and implementation of Cognos applications and maintenance of Data warehouses, Database, Data Marts and providing solutions for Finance, Banking, and Health Care domains.
• Experienced in various Cognos tools such as Cognos10 Suite (framework Manager, Metric Designer, Cognos connection, Report Studio, Analysis Studio, Event Studio and Query Studio).
• Expertise in Report building using Report Studio, Query Studio and Analysis Studio.
• Extensive experience in creating Complex reports using Customized prompts, Conditional formatting, Drill through relationships and Master Detailed Relationship.
• Experience in creating and translating information from various corporate systems and data into visually rich Dashboards using gauges, Maps, Charts, and other Graphical elements.
• Developed and Published Packages using Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and created filters, prompts, calculations, summaries and functions in Framework Manager.
• Experience in setting up user groups, Cognos Active Directory roles and Data Differentiator model to assign User Permissions and to enable folder & data security.
• Setup row level security using Session Parameters and Security Dimension in Framework Manager.
• Automated reports generation according to a schedule or by trigger using Cognos Scheduler.
• Involved in Migration and deployment of reports, metadata, packages & models from IBM Cognos 8.4 to 10.1
• Prior involvement in end-to-end BI Life Cycle Development Process - Requirement Analysis, Feasibility Study, Design Documentation (Functional Requirements Preparation, Technical Design), Specification Definition, Development, User Walk-through and demo, Testing, Maintenance, Post-deployment check-out and Production Support.
• Experience in Administration tasks of Cognos 10 BI Suite.
• Experience in Deployment (Export, Import) in Cognos Administration and Implemented Security at different levels in Framework Manager and Cognos Connection to restrict access.
• Expertise in OLTP/OLAP system study, analysis, E-R modeling and developing Database schemas like Star Schema and Snowflake Schema.
• Performed different Test scenarios (Unit, System & Integration and UAT).
• Extensively worked on Relational databases like Oracle, SQL Server, DB2, Netezza and Teradata.
• Extensive one to one interaction with end users/Business analysts to identify their needs and wants, then translate the functional requirement into reporting requirements, design and business data flow.
• Possess ability for critical thinking, analysis, good interpersonal and communication skills.
• Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

TECHNICAL SKILLS

BI Tools: Cognos 10.2,10.1, 8.x (Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Metric Studio, Transformer, Cognos Power play)

RDBMS: Oracle, SQL Server, DB2, Teradata, and Netezza.

Operating Systems: Windows NT/2003/Windows 2008R2, UNIX, LINUX.

Programming Languages: SQL, PL/SQL, T-SQL HTML, XML, DHTML,JAVA Script.

Other Tools: SQL* Loader, TOAD, SQL Developer, Developer 2000, SQL Navigator.

Data Modeling: Star-Schema Modeling, Snowflakes Modeling, FACT & Dimensions

PROFESSIONAL EXPERIENCE

Confidential, Oaks, PA

Sr. Cognos Developer

Responsibilities:

• Involved in frequent sessions with the Business Users in requirement gathering and documenting the Business Requirement Documents prior to reporting.
• Worked Extensively in Cognos Suite which involves Data Modeling using Framework Manager, built reports with Report studio.
• Worked in building reports out of Cognos Report Studio.
• Imported tables, views and stored procedures from Oracle database into Framework Manager and created relations and filters in the model.
• Troubleshooting and tuning of FM Relational Models, DMRs and reports for better performance.
• Developed various Complex report types ranging from simple Lists, Cross-tabs through complex dashboards, drill-through, Master-detail & conditional formatting reports for end-users.
• Developed Reports using Conditional Formatting and Cascading Prompts.
• Developed List, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page reports.
• Developed and unit-tested list, cross tab, master-detail and Drill-through reports using data model and Passthru SQL.
• Standardized reports to maintain uniformity across the organization.
• Worked on the Active Reports to provide the interactive behaviour outputs to the users. Created tabbed reporting with complex calculations/formatting.
• Worked 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 user training to Business Authors in creating Ad-Hoc reports using Query Studio and as well in preparation of Training materials for the same.
• Maintained Security via LDAP and Cognos Administration, in assigning roles to the user groups and assigning the same to the Folder Structure in Cognos.
• Resolved Administration issues such as maintaining the parameters affecting the output of the reports, setting up the Audit Logging features, maintaining the Cognos environment in events of database upgrades.
• Experience in deploying the Reports as well as Content stores from one environment to another using File Transfer Protocol (FTP).
• Resolved critical production issues with quick turnaround times.
• Experience in using Cognos Connection to organize and schedule reports based on the user requirements.
• Supervised Off-Shore resource for Cognos Reporting.
• Experience in using SQL to validate reports.

Environment: Cognos 10.2(Framework Manager, Transformer, Report Studio & Query Studio, Business Insight and Business Insight Advanced), Oracle 11g, SQL Server 2008, Windows 2008 Server, Toad, XML.

Confidential, NYC, NY

Sr. Cognos Developer

Responsibilities:

• Developed reports, maintained and provided Production support for multiple projects simultaneously.
• Provided end-to-end support, maintenance and enhancements to the Cognos reporting framework (security, data model, packages and reports).
• Created reports primarily focused on providing Yearly and Quarterly Revenue and Profit Accounting.
• Wrote Technical Design documents, Supplementary specifications, designed Active Directory Security model, Data Differentiator model, user groups and access request tool changes.
• Presented pre-implementation Cognos reporting sales pitch & post-implementation walk-through to business end-users in collaboration with Business Analyst.
• Proposed and implemented Cognos environment improvements and Cognos reports' performance improvements to increase productivity.
• Completely revamped reporting environments for a couple of applications reducing total number of maintained reports by extensive use of parameterized reporting & Report Views to reduce number of maintained reports by 80%.
• Improved Cognos Framework manager model by breaking loops in data model with the use of alias shortcuts.
• Created Active Directory roles to enable folder access and sign-on security permissions in Cognos Connections.
• Migrated reports, packages, and models from Cognos 8.4 to 10.1 and from Test to Production.
• Worked extensively on Conditional Formatting using prompt parameters, Conditional Blocks, conditional styles, render variables, conditional variables and classes.
• Experience in using Cognos Connection to organize and schedule reports based on the user requirements.
• Applied row level security on query items to ensure data security using Session Parameters and Security Dimension in Framework Manager.
• Enhanced and maintained Framework Manager models to support new reporting requirements.

Environment: Cognos 8.4/10.1 Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Cognos Data Manager, Cognos Access Manager, Business Insight and Business Insight Advanced, DB2, Windows 2003 server, TOAD.

Confidential

Cognos Developer

Responsibilities:

• Working with the team to work in more efficient manner for all testing activities, providing daily, weekly and monthly project status reports to the higher management of project.
• Providing quality standards for operational areas & ensuring adherence to quality standards & leading efforts in developing & executing best practices & standard operating procedures targeting at organizational excellence.
• Developing standard reports, list, cross tab, charts, Drill-through reports by using Report Studio, Query Studio and also developed reports in different formats like PDF, XML, HTML, EXCEL.
• Creating list, cross tab and chart reports using multiple queries in a single report and conditional formatting to highlight the business needs.
• Designing reports using most of the report studio features (Conditional formatting, Conditional Page Layout, sections, Page Breaks, Master-detail and Drill through etc.).
• Producing Conditional block reports to dynamically hide or show report objects & provide the end user the option to view the data in different formats.
• Generating various prompts like date prompt, value prompt, select and search prompt and calculations for the reports as per the requirement.
• Creating relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Creating the derived columns from the present columns for the given requirements and multipage report based on multiple queries using Prompts and Parameters. Also Create Query Prompts, Calculations, and Conditions & Filters.
• Using Conditional formatting and Conditional blocks to display different sets of data based on different conditions in Report studio.
• Validating the data with the SQL queries and performed Unit Testing to ensure the accuracy of data is displayed in the report.
• Working with different teams for development purposes, knowledge transfer and future support.

Environment: Cognos V10.1 Bi Suite Framework Manager, Cognos Connection, Query Studio, Report Studio, Analysis Studio, Metric Studio, Windows 2003, DB2.

Confidential

Cognos Report Developer

Responsibilities:

• Creating required Projects, Name Spaces, and Data Sources, Query Subjects and Packages and publishing the Packages for the sake of Report Authors.
• Developed some complex Reports by using calculated fields in Report Studio.
• Used Report Studio & Query Studio to develop various types of reports like List Reports, Cross tab Reports, Chart Reports & Master Detailed reports.
• Involved in creating the Burst Reports & MAP Reports in Report Studio to distribute the report to the multiple Recipients.
• Creating Query Prompts, Calculations, Conditions and Filters in the Reports.
• Analyzation of the report problems in the Framework Manager and doing necessary R&D.
• Used Drill through reports to link multiple reports.
• Involved in creating Condition palettes for effectiveness of the Reports.
• Creating Query Studio Templates for the query studio users.
• Created Mailing labels using the Repeater table template in Report Studio.
• Used Analysis Studio to analyze the dimension and measure used in the project.
• Used Event Studio to plan the events and run the jobs according to the conditions based on the event.
• Scheduled and Distributed reports using Schedule Management in Cognos Connection.
• Involved in Design, Development and Maintenance of multiple ad hoc queries with complicated reports and different types of Drill Through reports on Multiple Prompts selection.
• Job monitoring and resolution of failures through UC4.
• Follow up/ escalation with source system support resources if the issue is dependent on them and impacting delivery of reports and cubes by SLA time.
• Changes in the existing report/cube.
• Ad hoc report required by user.
• Formatting of the report.
• Cognos and all data sources discrepancy analysis and resolution report not launching resolution.
• Answering queries from users.
• Documenting the change / support activity details.
• Creation of documentation of existing cube and reports.
• Estimation of Time and effort involved in the modifications.
• Cube/Report testing and Fixing Cube/Report related problems.
• Addition of new dimensions and measures in the existing cube.

Environment: Cognos 8.4 Suite Framework Manager, Cognos Connection, Query Studio, Report Studio, Analysis Studio, Metric Studio, Transformer 8.4 and Windows2000/NT, Oracle, Teradata.

Confidential

PL/SQL Developer

Responsibilities:

• Created custom table, triggers, stored procedures, functions, packages to modify the existing oracle database.
• Created a series of procedures and functions for loan and facilities transactions.
• Analyzed business functionalities related to back-end database interfaces and utilized PL/SQL developer tool to develop all back-end database interfaces.
• Involved in daily, weekly and monthly loading of data from Mainframe data sets to Oracle RDBMS.
• Developed triggers for error handling and to keep track of changes to the fields of tables when changes are made.
• Worked on the Stored Procedures, Functions and Constraints, Tables, Indexes and Tuned queries for performance.
• Tuning SQL queries using Explain Plan and SQL Trace.
• Created views which require complex joins and quick response time.
• Carried out technical specification documents for back-end and interface with front-end.
• Modified Stored Procedures and Packages using PL/SQL.
• Created and modified Reports using Crystal, Business Objects and Discoverer as per the business requirements.
• Defined relationships using primary keys and foreign keys for the entities and normalized the entities.

Environment: Oracle 10g, Toad, UNIX, HTML, SQL*Plus, Test Advisor, Test Director.