SUMMARY:

• 4+ Years of IT Experience in analyzing, designing, developing and implementing Data Warehouse in different Business Intelligence Environments with Emphasis on generation of complex reports using data modeling and Business Intelligence reporting tool.
• Expertise in Data Analysis, Data Modeling and Mappings, Data Warehousing and Business Intelligence applications with participation in entire life cycle of the projects.
• Proficient in developing reporting applications using Cognos 10.2/10.1/8. x tools (Framework Manager, Report Studio, Query Studio, Powerplay Studio, Analysis Studio, Metric Studio, Event Studio and Cognos Connection).
• Expertise in Reports generation including creating complex reports using Report studio (Master - detail reports, List reports, Cross-tab reports, Drill through reports, Summary reports, Burst reports, etc.).
• Knowledge of Data warehouse concepts, DMR (Dimensionally Modeled Relational), Star Schema and Snow Flake Schema.
• Experience working in Financial and Retail Sectors.
• Developed Framework Manager Models (Layers, Joins, Prompts, Filters and Calculations)
• Experience in Migrating data from Cognos 8.4 to 10 (Life-Cycle Manager) and Dynamic Query Analyzer
• Implemented Data Security, Object Security and Package Security in Framework Manager and created user classes as per the requirement
• Good Experience in Business Insight and Business Insight Advance
• Designed and Developed Transformer Models and Cubes
• Experience with Scheduling, Report Bursting and delivery via e-mail
• Experience developing complex reports using drill-through reports, prompts, dashboards, master-detail, burst-reports, dynamic filtering in Cognos.
• Strong Knowledge of Data Warehousing, OLTP and OLAP concepts
• Performance tuning of the reports by using more drill-through, reducing SQL queries, using more inbuilt functions and applying star schema where possible.
• Created three layer Architecture (Database view, Modeling View and Presentation View) Using Cognos Framework manager.
• Created Ad-Hoc Reports using Query Studio based on user requirements.
• Developed Dashboards over Cognos Workspace and Business Insight and using reports from report studio and Cubes.
• Developed Active reports using various controls for high level summarized data for the executives.
• Created/modified, deployed and published Framework Manager packages in various environments
• Experience in Installing and Configuration of Cognos 8 on client-server architecture.
• Strong-hands On experience on Cognos Administration including deployments, migrating reports, managing user accounts and assigning access rights through the Cognos Server linked to standard LDAP.
• Interactive participation in requirements, technical/business meetings, QA and UAT
• Extensive experience in writing, testing and debugging of SQL.
• Experience in coordinating with various teams, reviewing tasks in detail, tracking project status and reporting/presenting the same to client.

TECHNICAL SKILLS:

BI Reporting Tools: COGNOS BI 10.2/10.1/8. x(ReportNet 1.1, Cognos Connection, Framework Manager, Report Studio, Query Studio, Analysis studio, Transformer)

Operating Systems: Windows XP, Windows 7, Unix and Linux

Languages: HTML, JAVA,JDBC,Java Script

ETL Tools: Informatica 9.1, BODS, IBM Datastage 7.5

Databases: Oracle,MS SQLServer, TeraData and Netezza

Web Server: Microsoft Internet Information Services (IIS)

GUI Tools: Visual Studios 2005/2008, Dreamweaver, Photoshop, Flash, Photo Impact12, So Think Flash Tools

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Cognos Developer

Responsibilities:

• Experienced working with Cognos BI architect to provide efficient reporting.
• Facilitated JAD sessions with external and internal Clients, in order to develop artifacts to support the development and implementation of Enterprise Architecture, Business Transformation, and Systems Development projects.
• Worked with Cognos Insight 10.2 Tree Maps, Smart metadata, Drill-able, drag and drop charting and Top/Bottom filtering, Package Import, and Time Rollups.
• Worked with Cognos Workspace and workspace advanced (Formerly Business Insight) Multi Tabbed Workspaces, Freeze and Unfreeze Column and Row Headers, Data Visualization Guide, Graduated Capabilities.
• Created Prototypes for the business showcasing them the Models and future report samples and Dashboards.
• Created Model Query subjects, Data Source Query subjects, Stored Procedure Query subjects as per the business requirements in the Framework Manager.
• Designing the Logical model that conforms to star schema concepts, different views (Import, Business, and External) as per Business requirement.
• Developed Framework Model against different data sources with the best practices (Database, Business and Presentation layer), set cardinality between the tables, filters and calculations included in FM for effective reporting and published packages on Cognos portal.
• Developed Active reports and allowed users to view reports while signed off Cognos portal.
• Designed, developed and implemented Cognos 10.2 Framework Manager and Report studio reports.
• Interacted with the business to gather reports requirements and created LLD and HLD Documents.
• Worked on Analysis, design, developing, testing, scheduling, security, publishing and maintained Cognos 10.2 BI.
• Developed Framework Model against different data sources with the best practices (Database, Business and Presentation layer), set cardinality between the tables, filters and calculations included in FM for effective reporting and published packages on Cognos portal.
• Created complex dashboard, multi-page, multi-tabs, drill through, master detail, conditionally formatted reports including graphs and Images.
• Excessively worked on Reports tuning, Modification and report performance on daily bases.
• Excessively worked on complex SQL queries to build Cognos reports.
• Worked on-shore/off-shore model. Experience guiding a team of 3 off-shore developers.
• Prepared User Documentation to train users and to explain functionality of each report.

Environment: Cognos 10.2 (Query Studio, Report Studio, Cognos Insight 10.2 Cognos Workspace, Analysis Studio, Cognos Connection, Framework manager), Oracle 11g, Toad, Microsft Sql Server, Microsoft Excel, Windows XP.

Confidential, Schenectady, New York

Cognos Developer

Responsibilities:

• Developing models using Framework Manager Techniques.
• Created Packages and published these packages on to Cognos Connection for creating ad-hoc reports using Query Studio and professional reports using Report Studio.
• Created new Query Subjects and arranged in different folder structure for Business View.
• Created complex reports like Crosstab, Drill through, Master detail, Dashboards and Burst Reports using Report Studio.
• Created reports using Conditional formatting, Conditional blocks, Conditional variables, Advanced Conditional styles and Conditional Layout features in Report Studio.
• Created queries in report studio using Join and Union.
• Developed Reports using Cognos 10.1.1
• Built Multi Dimensional Models (DMR) with Relational Data using Framework Manager and Deployed Packages to the Report Servers.
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports (MOLAP - ROLAP)
• Experience in Deploying reports, cubes and packages from Development to Production environment.
• Developed Score Cards, Dashboard Reports, Standard Reports, Charts, and Drill through Reports,using Report Studio and Query Studio in Cognos 8.3 and Cognos 10.1.
• Designed Cognos Power Cubes to provide analytical solutions for complex business requirements.
• Developed Prompt Page Reports using Conditional blocks and Conditional Variables
• Worked on exploring the dimensions such as Drill Down, Drill Up, Drill down and up on nested categories, filtering the data etc.
• Created reports with custom prompt pages (using HTML and JavaScript) in Report Studio.
• Setting up cardinality (minimum, maximum & optional), Determinants to avoid double counting, support loop joins, optimize data source, and identify dimensions and facts.
• Used Cognos Transformer to build multidimensional cubes.
• Developed DMR Models & IQD’s in Framework Manager.
• Fine-tuned the queries for performance purpose and enhanced the performance of the reports.
• Developed Prompt pages and Cascading input prompts to display only selected entrees in the report.
• Developed Report Views to organize reports in Cognos Connection
• Expertise in handling Administration tasks like bursting and scheduling the reports.
• Strong experience in all phases of testing including defining user acceptance criteria, developing plans/scripts, documenting expected results, execution of scripts, validating actual results.

Environment: Cognos 10.2.1(Cognos Connection, Report Studio, Query Studio, Analysis Studio Framework Manager), Access Manager, Cognos Transformer, Netezza, DB2, TOAD, Windows XP

Confidential

Cognos Developer

Responsibilities:

• Worked closely with Clients and Business Users to analyze and understand business requirements and Participated in requirements gathering meetings / Sessions.
• Designed and developed highly customized reports in Cognos 8.3 Report Studio and Ad-hoc reports in Query Studio.
• Analyzed the requirements and created technical design specs for Framework manager, and reporting for the same. Expert in writingTM1ruleswith perfectfeeders
• Experienced in creatingsnapshot processin Forecastingcubewhich will populate all the forecasted values in the version dimension for given period, involving change of rules, changing flag in month dimension etc
• Involved inTM19.5.1installationand configured Perspective andTM1web as remote servers
• Created project, namespace (Database View, and Business View), and folders and imported required metadata in Cognos Framework Manager.
• Created model query subjects, Data source query subjects, stored procedure query subjects as per the business requirements in the Framework Manager
• Implemented the best practices of Cognos BI.
• Created schema prompts, required, optional prompts, parameter files, parameter mappings for automation using macros.
• Administered the reporting environment.
• Developed data specific reports with various filter conditions to retrieve 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.
• Created reports with conditional formatting to enhance the readability of the report outputs and enabled Prompts and Cascading Prompt pages to give users the ability to derive focused reports.
• Involved in complete Software Development Life Cycle using Agile and Scrum.
• Created functions, stored procedures for inserting, updating data based on conditions.
• Involved in testing the package developed by co-developers.
• Prepared User documentation to train users and functionality of each report.
• Involved in troubleshooting and data gathering during the business analysis and planning phase of the project.
• Created Star Schema using fact and dimension tables and further created dimensions, levels and hierarchies.
• Tuned Performance of reports by reconfiguring join strategy in SQL Queries/Framework Metadata Models and requested the DBA to create summary tables/views at the database level or enable the indexes on the columns used in the joins when appropriate.
• Designed complex reports with union queries, and SQL queries
• Improved long running reports performance through writing SQL queries, resolving complex joins in framework manager, filters, and using stored procedures.
• Developed number of prototypes for the business users. This project was bases of star schema, OLTP data.
• Involved in Scheduling and Distributing reports through Schedule Management in Cognos Connection and Burst reports to different user groups.

Environment: Cognos 8.4/10, Framework Manager, Cognos Report Studio, Analysis Studio, series 7, ReportNet, SQL Server 2005, Windows XP, Windows Server 2000