SUMMARY

• Around 7 years of extensive experience in IT industry which includes extensive Functional and Technical experience in Data Warehousing, Data Modeling, Business Intelligence (BI), Decision Support Systems (DSS) and OLAP, ETL tools, Product Development, Reports Generation, Testing.
• Experienced in analysis, design, development and implementation of Business Intelligence and Maintaining Applications using Cognos BI Tool suite
• Expertise in Data Warehousing, Modeling, DSS and generating OLAP reports using Cognos 10.2 (Report Studio, Query Studio, Analysis Studio), Cognos 8 Series, Cognos Series 7, ReportNet 1.1
• Experience in creating Business Intelligence Reports and Multidimensional cubes using Cognos BI and PowerPlay Transformer.
• Functional and Technical Expertise with proficiency in requirements gathering, design, development and implementation of a project (SDLC).
• Extensive exposure to various business sectors such as Finance, Insurance, Retail, and .
• Extensively worked on DMR (Dimensionally Modeled Relational) and OLAP.
• Involved in writing JAVA Scripts to enhance teh reports.
• Developed and Published Packages in Framework Manager - Connecting and testing teh data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Experienced in modeling using Framework Manager and relational database as source including applying data level, and query subject level and package level security & Publishing packages to Cognos
• Designing and developing complex reports (List Reports, Cross Tab Reports, Maps, Drill through & Master Detail Reports) using Report Studio.
• Worked on designing teh multiple Report pages and multiple Prompt pages. Worked on Report Bursting. Created reports from multiple data sources.
• Expertise in creating Dash board reports using Business insight, Report studio to get reports from different packages and applying common filters.
• Designed portal tabs, portlets.
• Worked on Cognos Connection (Data Source, Schedule Management, Security Administration & Content Administration).
• Excellent knowledge on data warehousing concepts - Star schema, Snow-flake schema and worked on both OLAP and OLTP databases.
• Experience in Manual testing, Automation testing. and Performance Testing/Load Testing
• Experienced in Performance Tuning by analyzing and comparing teh turnaround times between SQL and Cognos.
• Involved in business users in developing/using various Reports.
• Excellent Communication skills (Verbal/Written) and Self Motivated Team player.

TECHNICAL SKILLS

BI Tools: Confidential Cognos BI Suite Cognos10.x and Cognos 8.x,Report Studio, Query Studio, Framework Manager, Analysis Studio, Cognos PowerPlay, Cognos Transformer, Report Administration, Access Manager, LDAP.

Databases: Oracle10g/9i, SQL Server 2005, 2008, Teradata, Confidential DB2

Web Servers: Microsoft Internet Information Server (IIS) 4.0/3.0, Apache HTTP Server, Confidential HTTP Server (IHS)

Data Modeling: Star and Snowflake Schemas Modeling, Facts & Dimensions.

ETL Tools/ DataWarehousing: Knowledge of Informatica 9, SAP BODS 3.0

Operating Systems: Windows 7, XP, 2000, NT, 98, 95 & 3.0 and UNIX Server (Red hot, AIX)

PROFESSIONAL EXPERIENCE:

Confidential, Carrollton, TX

Sr. Cognos Developer

Responsibilities:

• Developed Active Reports using active controls and teh different decks (e.g.: Static, Data Decks,, Data control tabs, Data Drop-Down List, Data Radio Button Group, Interactive Behavior) available in Active Reports.
• Extensively worked on Dashboard reports based on user requirements using Workspaces in Cognos 10.2 (Added text, images, pick lists and action buttons)
• Extensively worked on Audit Reports based on business heads needs defined KPIs which has been placed into teh Dashboards in Cognos 10.2
• Design and develop meta-data models by Importing Metadata from Multiple Sources.
• Involved in managing group of people and leading them for development and management activities,, assigning tasks, making task plans and weekly and monthly status reports.
• Worked on performance of reports with data end SQL server database query test.
• Work on teh Framework manager to build teh model.
• Developed central modeling Layer (Framework Model) with Star and Snowflake schema groupings, Parameter Maps for enhanced performance .Implemented macros to build teh dynamic string to enforce dynamic behaviors.
• Defined appropriate relationships between Query Subjects and Define Determinants as and when required.
• Developed reports with Drill through, rendered variables functionalities and multilevel queries using joins & union data sets.
• Performed Deployment of Cognos Content from DEV to PROD, Job Scheduling, Folder Security, and Framework Object Level Security.
• Developed highly complex reports involving dynamic selection based sorting, Drill-Through, multiple Conditional blocks, Rendered Variables and Conditional Variables, select and search prompts with multiple options, prompt pages and multilevel queries using joins & union data sets.
• Preparation and Review of Technical Analysis and Design Documents. Created Implementation plan and live release plan for teh Production release. work on teh Solution design documents to check teh feasibility of teh report specifications
• Lead teh team to distribute teh work among teh team members and update teh work progress to teh client.

Environment: Cognos 10.2 (Query Studio, Report Studio, Analysis Studio, Active Reports, Work Space Advance, Cognos Connection, Framework manager), PowerPlay Transformer, Teradata, SQL Server 2008, Windows 7 Professional, Java scripting

Confidential, NYC, NY

Sr. Cognos Developer

Responsibilities:

• Worked with users and coordinated with application developers to understand and capture data/reporting requirements
• Designed and developed Dash Boards, Report studio to show reports from different packages on to a single portal page and applying filters.
• Worked With Work Space Advanced.
• Drill-through definitions from Cube to a relational Package.
• Designed portal tabs, portlets.
• Created Crosstab reports using DMR Models, also improved teh turnaround time by tuning some of teh functionalities.
• Developed Prompt Page Reports using Conditional blocks and Conditional Variables
• Worked on exploring teh dimensions such as Drill Down, Drill Up, Drill down and up on nested categories, filtering teh data etc.
• Created various reports using Conditional formatting as required by teh User.
• Created Income and Balance sheet Reports based on Company details, Revenues, Budget vs. Forecast reports etc.
• Implemented security in reports based on various companies and roles according to teh requirement.
• Involved in creating security and deployment (exports and imports).
• Created folders, filters, prompts, and complex financial calculations in Report Studio
• Created static choice value prompts, conditional variables (Boolean and string) and conditional blocks associated with these variables to display/hide columns and queries based on user’s selection in Prompt pages. Worked with Java scripts for different report requirements.
• Created multiple relational models based on teh requirements.
• Created Cognos Mobile Dashboard reports.
• Designed teh standard template for creating reports in Report Studio In-order to meet teh reporting standards. Worked on performance tuning of reports and testing at different stages.
• End User documentation, Technical documentation and UAT document.

Environment: Cognos BI Series 10.1.1.4, Framework Manager, Query Studio, Report Studio, Analysis Studio, Windows 7, Oracle 11g, SQL Developer, PeopleSoft

Confidential, Princeton, NJ

Cognos Developer

Responsibilities:

• Resolve teh day to day incidents & Requests which has been raised by teh business users.
• Worked extensively on enhancements of production reports.
• Given Access to teh Business Users for teh User groups in Access manager.
• Created teh Users in Cognos Connections and given permissions to teh reports.
• Created user groups in Cognos Connection from Access manager groups.
• Involved on Migration of reports, Packages SIT to UAT and UAT to Production environment.
• Involved on server restarts scheduled and on demand basis.
• Involved in setting up teh Audit Data base in teh Cognos configuration
• Involved in Migrated of Cognos 8.4 environment to Confidential Cognos 10 environment.
• Involved in security settings, schedule management, data source creation and deployment.
• Performed Deployment of Cognos Content from DEV to PROD, Job Scheduling, Folder Security, and Framework Object Level Security. Involved in installation and configuration of teh development environment
• Design and develop meta-data models by Importing Metadata from Multiple Sources.
• Created drill through and Master detail relationship reports as per teh client requirements.
• Worked on parameter maps in Frame work manager for dynamic filtering teh data sources.
• Worked on Analysis studio and creating teh drill through from teh Dimensional data to relational data report (Dynamic drill through).
• Involved in preparing teh Reports development estimations and deliverable plans.
• Involved in preparing Data validation sheets/Test Cases for teh developed reports.

Environment: Cognos 8.4.1 &10.1.1 (Business Insight Advanced, Query Studio, Report Studio, Analysis Studio, Active Reports, Cognos Connection, Framework manager), PowerPlay Transformer, SQL Server 2008.

Confidential

Associate

Responsibilities:

• Imported metadata from various sources such as Relational Databases, ReportNet models, Impromptu Catalogs into teh Framework Manager.
• Constantly interacted with teh business users, attended several meetings in understanding teh requirements better.
• Used Framework Manager to build models, packages and publish packages to teh ReportNet Server.
• Built models containing query subjects, query items, and namespaces from scratch as well as from imported metadata.
• Implemented data level, object level and package level security in framework manager to achieve highly complex security standards.
• Developing reports with Cognos 8 report studio (using Classes, Maps, Financial reports, and prompts).
• Creation of Calculations, Prompts and Filters for usage in various Reports.
• Creation of Complex Multi-Object Reports using Lists, Crosstabs, charts, Images and HTML applications using Report Studio and ad-hoc reports using Query Studio.
• Conversion of existing Impromptu Reports to report studio reports.
• Created burst table and reports and made them available for appropriate users.
• Administering teh user groups based on teh user requirements
• Created Master Detail reports, drill through and custom prompting reports, and Scheduled reports for efficient resource utilization.
• Provided solutions and implemented efficient ways to improve teh performance of teh reports.
• Developed Multi-dimensional Models and cubes using Power play Transformer.
• Implemented drill-through from power play web to Cognos ReportNet

Environment: Cognos Suite 8.0, Power Play Enterprise Server 7.3, oracle 9i.

Confidential

Jr. Associate

Responsibilities:

• Developing a logical model dat conforms to star schema concepts, different views (import, business, external) as per Business requirement.
• Analyzing requirement Specification document and preparing teh Specification document as per teh Business requirement.
• Developing teh SQL scripts as per teh business requirement.
• Developing Dash Board reports in Report Studio.
• Creating teh Report Studio reports using teh Cube as a data source.
• Adding business rules by defining different kinds of calculations and filter.
• Developing teh reports using various templates like list report, Cross-tab Report and Chart Report.
• Working experience with different date functions in Report Studio.
• Creating teh Bar charts and list reports using Cognos Report Studio and Analysis studio.
• Extensively working with Stored Procedure Query Subjects in FM and Reports.
• Performance tuning teh by analyzing and comparing teh turnaround times between SQL and Cognos.
• Deploying teh reports and package from Development to testing, Testing to Production environments.
• Unit testing, Integration testing and system testing of teh reports in Development, Performance and production environments.
• Trained Users on Query Studio for Ad-Hoc Reporting.

Environment: Cognos Series 7, Windows NT/2003, UNIX, Oracle 10g, SQL Server 2005 and TOAD.