SUMMARY

• Senior Cognos Developer wif 7 years of experience in design, development, testing, implementation and documentation of business, financial and technical applications in client/server and web based Business Intelligence environments.
• Extensive experience in Cognos Tools such as Cognos 10.1 BI Suite, Cognos 8 BI Suite (Framework Manager, Cognos connection, Report Studio, analysis Studio, Query Studio & Event Studio) Cognos Report net 1.1.MR3, and Analysis Tools such as Cognos Transformer.
• Experience in Designing models using Framework Manager and deploying packages to teh Report Servers.
• Experience in Framework Manager Modeling (Database Layer, Business Layer, Presentation Layer).
• Sound working noledge of building Complex reports, Burst Reports, Drill Through reports, Cascading Reports, Cross Tab Reports and Summary Reports. Created complex reports, drill through reports, dashboards using report studio.
• Experience in developing multi - dimensional model design and cube building, security using Cognos Transformer.
• Used Cognos Connection for scheduling and bursting reports across teh Business segments.
• Installation of various Cognos tools in Distributed Environment (Development, Test and Production).
• Involved in migration from Cognos EP Series 7 (7.3 and 7.4) to Cognos 8 BI latest version 8.4.
• Experienced in performance tuning and optimizing of teh reporting solution.
• Experience in writing SQL, PL/SQL, Oracle, Teradata, Stored Procedures, Functions, Packages as per business requirements.
• Knowledge in working on Extraction, Transformation and Loading (ETL) using Informatica 8.X.
• Strong noledge in data warehousing concepts (Star schema, Snow Flake Schema, Fact constellation schema).
• Proficient in building front-end BI applications according to specifications.
• Strong analytical, conceptual, and problem-solving abilities.

TECHNICAL SKILLS

• Cognos 8.1 8.2 8.3 8.4 & 10.1BI Suite
• Framework Manager
• Cognos Transformer
• Cognos connection
• Query Studio
• Report Studio Analysis Studio
• Cognos EP
• Series 7.x (Power play
• Transformer
• Power play Windows/Web
• Impromptu
• Upfront).
• C
• C++
• Core Java
• HTML
• JavaScript
• SQL
• PL/SQL
• MS SQL Server 2005/2008
• Oracle 9i/10g
• IBM DB2
• MS Access
• Teradata
• Informatica PowerCenter 8.1/8.6
• Cognos 8 BI Data Manager
• IIS
• Tomcat
• Active Directory
• Sun One Directory
• Apache Directory
• Windows XP/VISTA
• UNIX

PROFESSIONAL EXPERIENCE

Senior Cognos Developer

Confidential, Bolingbrook, IL

Responsibilities:

• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Multi-query, Cubes in Report Studio.
• Created custom prompt reports and dashboards in Report Studio.
• Involved in Query Optimization, Creating Query Prompts, Developing Prompt pages and Conditional variables.
• Developed standard Templates for various kinds of reports.
• Added prompts and filters to modify existing reports to accommodate change in user requirements.
• Created professional reports in Report Studio and ad hoc reports in Query Studio.
• Created dashboards (crosstabs and charts) to display teh business details from different aspects and using different representations.
• Modified teh existing reports by adding required prompts to comply wif changes in teh business requirements.
• Created simple to complex reports as well as Dashboard like reports using Report Studio by applying various concepts and functionalities such as drill-through, conditional reporting, block, tables, master-detail, charts, various calculations and joins using tabular sets and tabular models
• Worked on Cognos 10.1 Report Studio in order to built multiple crosstab, list and chart reports.
• Created folders, filters, prompts, and complex calculations in Framework Manager.
• Involved in design and development of joins, filters and calculations in Packages wifin Framework Manager.
• Worked on Relational Models in order to built multipage prompts and complex crosstab reports.
• Created complex reports such as Customer Invoice, Bookmark, Product Analysis and Multi-Prompt reports.
• Created complex custom queries to optimize teh Report Studio report performance.
• Created Drill through from Analysis Studio to Report Studio Reports.
• Created new calculated columns which are not present in teh published packages.
• Used Cognos Connection for scheduling and bursting reports across teh Business segments.

Environment: Cognos Suite 10.1(Report Studio, Query Studio, Analysis Studio, Cognos Connection, Framework Manager, PowerPlay Transformer), Oracle 11g, DB2, Teradata, Windows XP.

Senior Cognos Developer

Confidential, Oklahoma City, OK

Responsibilities:

• Gathered business and functional requirements, estimated time, designed, developed and implemented Business Intelligence solutions.
• Design, Develop and Implement end-to-end Business Intelligence Solutions.
• Developed Summary and Detail Reports.
• Created Database Tables and Loaded Data from Excel Sheets and Feeds.
• Creating Query Prompts, calculations, Conditions & Filters, Prompt pages and Conditional variables.
• Developed standard Templates for various kinds of reports.
• Creating New Jobs and Data sources in Cognos Connection.
• Implemented data and user level security in Cognos Connection.
• Developed Standard Reports, Charts and freestyle reports using Report Studio.
• Created Packages in Framework Manager Modeling tool.
• Created Views and imported into Framework Manager.
• Created IQD files using Framework Manager.
• Created Groups and Assigned Roles using Cognos user classes.
• Deployment of teh Cubes to Development and Production Servers.
• Organized teh metadata as per teh requirement in Folders and Namespaces in Framework Manager.
• Published Packages to teh COGNOS 8.4 server using Framework Manager
• Implemented teh Security at data and object level in Framework Manager.
• Installed and Configured teh Cognos Power play Transformer
• Designed teh Dimensional Models for transformer and Power Play cubes using PowerPlay. Explored teh cube data using teh Report Studio and Analysis Studio.
• Created Multi-dimension cubes using Power Play Transformer to create reports in Power Play
• Documented user guide and trained business in Query Studio and Analysis Studio for creating adhoc reports.
• Coordinate wif Offshore team and ensure all teh Data warehouse work products are developed wif high quality.

Environment: Cognos Suite 8.4(Report Studio, Query Studio, Analysis Studio, Cognos Connection, Framework Manager, PowerPlay Transformer, PowerPlay Web), Oracle 10g,DB2, TOAD, PL/SQL, Windows 2003.

Cognos Developer

Confidential, Miami, FL

Responsibilities:

• Involved in teh Installation of Cognos 8.3 and up gradation of Packages from Frame Work Manager, Reports from Report Studio from Cognos 8.2 to Cognos 8.3.
• Schedule various reports Using Schedule Management used in Cognos Connection.
• Providing Cognos access by assigning roles and maintaining security for auditing purposes.
• Created roles in Cognos connection and Access permissions were given to users.
• Experienced wif SSIS DTS packages for Import and Export mechanisms.
• Coordinating wif business users to understand teh business rules and working wif data warehousing team.
• Testing teh developed reports for final deployment.
• Created complex reports in Report Studio such as conditional, dashboards and drill through reports.
• Customized data by adding teh Prompts, Filters, Calculations, Summaries, Functions and Conditional formatting.
• Developed Multi-page reports, List reports, Charts, Drill through and Master-detail reports using Report Studio.
• Involved in Installation and configuring Framework Manager and its components on Windows.
• Developed teh Metadata layer by importing teh required objects into Framework Manager
• Documented self developed reports and Framework Manager (FM) Models as well as supported them.
• Organized teh metadata as per teh requirement in Folders and Namespaces in Framework Manager.
• Published Packages to teh Cognos 8.3 server using Framework Manager
• Implemented teh Security at data and object level in Framework Manager.
• Created various reports using Cognos functionalities like Sub-Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail and Formula's.
• Designed teh Dimensional Models for transformer and Power Play cubes using PowerPlay. Explored teh cube data using teh Report Studio and Analysis Studio.
• Scheduled teh reports in Cognos Connection and distributed them via mail.
• Responsible for creating test plan documents and documented teh test results.

Environment: Cognos 8.3 BI (Framework Manager, Report Studio, Analysis Studio, Query Studio, Event Studio and Metric Studio), Cognos Transformer, Cognos PowerPlay, PowerPlay Enterprise Server (PPES), Cognos Access Manager, Brio Intelligence 5.0, Oracle 10g, Windows NT/2000

Cognos Developer

Confidential, Herndon, VA

Responsibilities:

• Created metadata models from multiple data sources and resolved loop joins in Framework Manager and published teh packages
• Performed application analysis to come up wif a strategy to migrate or develop BI applications to support Client needs.
• Analyzed and explored different user requirements to develop security in Cognos 8 Models and Cubes.
• Created appropriate user class, users, database signons in Active Directory and provide different levels of authentication and provide teh security to different users.
• Secured organization’s data by setting access permissions across teh different departments.
• Created jobs, scheduled them and modify teh sequence in which teh job steps can be executed.
• Distributed reports by bursting them while keeping teh authentication to various data intact.
• Optimized speed and efficiency of Cognos by Managing dispatchers and services along wif teh number of processes and connections limit.
• Developed QA Testing procedures of teh reports that are developed and managed testing server environment.
• Developed prompt pages and cascaded input prompts to display only teh selected entries in teh report.
• Defined relationships and cardinality between different database tables.
• Used dimensional modeling and Snowflake Schema to develop unique data warehouse models.
• Developed Journal Entries and General Ledger Balance Data Marts.
• Created multiple dimensions, special categories and alternate drill through in Transformer models.

Environment: ReportNet 1.1 MR2 (Report Studio, Query Studio, Framework Manager), Cognos Impromptu, Access Manager, PowerPlay 7.1, Transformer, Oracle 9i, SQL Server 2000, Toad 7.4.0.1, Windows 2000.

Cognos Developer

Confidential, San Jose, CA

Responsibilities:

• Interacted wif different business teams to collect teh requirements for reporting analysis.
• Analyzed current business processes, assess opportunities for redesigning these processes.
• Creating relationships between query subjects to better represent teh logical structure of teh business and teh user requirements.
• Created Projects, metadata Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.
• Analysis of data necessary to resolve issues uncovered relating to source data.
• Implemented security for Data access, Object level access and Package access in Framework Manager
• Involved in design and development of joins, filters and calculations in Packages wifin Framework Manager.
• Published Power Play cubes & reports onto Cognos Connection and scheduled Cube building in Scheduler
• Supported production application, interacting wif users, running jobs and troubleshooting issues as needed
• Worked on developing standard Reports, Drill-Through and Master Detail Reports enabling to understand and monitor current performance while planning future business strategies
• Created charts, Lists and Crosstabs, using Report Studio and ad hoc reports using Query Studio
• Scheduling, Distributing Reports and Administering Reports. Bursting Reports and Multilingual Reports Using Report Studio and Query Studio
• Developed stored procedures and user defined functions using PL/SQL
• Involved in developing, support, unit test and deployment of teh reports.

Environment: Cognos 8.1/8.2, Cognos Connection, Frame Work Manager, Cognos ReportNet1.1,Cognos Query 6.0, Access Manager, SQL Server 2000,Windows Server 2003/NT.

Cognos Developer

Confidential

Responsibilities:

• Gathered new requirements, analyzed teh existing business requirements and interacted wif business users.
• Involved in teh Installation and Configuration of Cognos Web Portal, Cognos Transformer and Report Net Server.
• Worked wif senior management to better understand teh data available in teh data warehouse.
• Created User Profiles in teh Catalog for teh security.
• Worked on Access Manager for giving security by creating Users and User Classes.
• Created Impromptu reports wif various filter conditions to retrieve specific data.
• Created complex reports like List and Cross-tab reports, Charts and Dashboards using Impromptu.
• Created Drill Down and Drill Up reports according to teh business requirement using Impromptu Web Reports.
• Created Mailing Labels using Cognos Impromptu.
• Created simple Ad-hoc reports using Query Studio.
• Included Prompts for teh reports to filter teh data based on teh selection.
• Applied Drill through for teh reports to get detailed information of a particular field in another report.
• Bursting of reports was done in ReportNet.
• Involved in creating, running and scheduling of jobs in Cognos Web Portal.
• Formatted teh Folders, Jobs and Reports using Cognos web portal.
• Performed Report Net Admin functions.
• Customized end-users Cognos Connection wif appropriate reports and security measures.

Environment: Cognos BI (Report Studio, Query Studio, Analysis Studio), Power Play, Transformer, Upfront, Informatica Power Center 6.1, SQL, PL/SQL, Oracle 8i, SQL Server 2000, Windows 2000/ NT.

Cognos Developer

Confidential, San Ramon, CA

Responsibilities:

• Developed data-reporting infrastructure and created catalogs for reporting and decision-support purposes
• Administered Impromptu and PowerPlay.
• Created Impromptu reports wif various filter conditions to retrieve specific data
• Applied Drill through for teh reports to get detailed information of a particular field in another report
• Worked on Access Manager for giving security to Cognos Applications by creating Users and User Classes
• Front-end development of teh data warehouse using Cognos products as an administrator heavily involved wif creating reports for users
• Administered changes to PowerPlay Cube based upon new requirements for customer identification project
• Use Framework manager to create data packages combining data from different data sources.
• Customize end-users Cognos Connection wif appropriate reports and security measures.
• Create complex reports using Report studio and developing Ad-hoc reports using Query Studio.
• Worked wif senior management to better understand teh data available in teh data warehouse

Environment: Cognos Impromptu 7.1, Power Play 7.1, IWR, Transformer 7.1, Upfront, SQL, PL/SQL, Oracle 8i, Windows NT/2000.