SUMMARY

• Senior Cognos Developer with 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 the Report Servers.
• Experience in Framework Manager Modeling (Database Layer, Business Layer, Presentation Layer).
• Sound working knowledge 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 the 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 the 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 knowledge 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 the business details from different aspects and using different representations.
• Modified the existing reports by adding required prompts to comply with changes in the 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 within 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 the Report Studio report performance.
• Created Drill through from Analysis Studio to Report Studio Reports.
• Created new calculated columns which are not present in the published packages.
• Used Cognos Connection for scheduling and bursting reports across the 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 the Cubes to Development and Production Servers.
• Organized the metadata as per the requirement in Folders and Namespaces in Framework Manager.
• Published Packages to the COGNOS 8.4 server using Framework Manager
• Implemented the Security at data and object level in Framework Manager.
• Installed and Configured the Cognos Power play Transformer
• Designed the Dimensional Models for transformer and Power Play cubes using PowerPlay. Explored the cube data using the 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 with Offshore team and ensure all the Data warehouse work products are developed with 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 the 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 with SSIS DTS packages for Import and Export mechanisms.
• Coordinating with business users to understand the business rules and working with data warehousing team.
• Testing the developed reports for final deployment.
• Created complex reports in Report Studio such as conditional, dashboards and drill through reports.
• Customized data by adding the 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 the Metadata layer by importing the required objects into Framework Manager
• Documented self developed reports and Framework Manager (FM) Models as well as supported them.
• Organized the metadata as per the requirement in Folders and Namespaces in Framework Manager.
• Published Packages to the Cognos 8.3 server using Framework Manager
• Implemented the 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 the Dimensional Models for transformer and Power Play cubes using PowerPlay. Explored the cube data using the Report Studio and Analysis Studio.
• Scheduled the reports in Cognos Connection and distributed them via mail.
• Responsible for creating test plan documents and documented the 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 the packages
• Performed application analysis to come up with 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 the security to different users.
• Secured organization’s data by setting access permissions across the different departments.
• Created jobs, scheduled them and modify the sequence in which the job steps can be executed.
• Distributed reports by bursting them while keeping the authentication to various data intact.
• Optimized speed and efficiency of Cognos by Managing dispatchers and services along with the number of processes and connections limit.
• Developed QA Testing procedures of the reports that are developed and managed testing server environment.
• Developed prompt pages and cascaded input prompts to display only the selected entries in the 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 with different business teams to collect the requirements for reporting analysis.
• Analyzed current business processes, assess opportunities for redesigning these processes.
• Creating relationships between query subjects to better represent the logical structure of the business and the 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 within Framework Manager.
• Published Power Play cubes & reports onto Cognos Connection and scheduled Cube building in Scheduler
• Supported production application, interacting with 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 the 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 the existing business requirements and interacted with business users.
• Involved in the Installation and Configuration of Cognos Web Portal, Cognos Transformer and Report Net Server.
• Worked with senior management to better understand the data available in the data warehouse.
• Created User Profiles in the Catalog for the security.
• Worked on Access Manager for giving security by creating Users and User Classes.
• Created Impromptu reports with 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 the business requirement using Impromptu Web Reports.
• Created Mailing Labels using Cognos Impromptu.
• Created simple Ad-hoc reports using Query Studio.
• Included Prompts for the reports to filter the data based on the selection.
• Applied Drill through for the 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 the Folders, Jobs and Reports using Cognos web portal.
• Performed Report Net Admin functions.
• Customized end-users Cognos Connection with 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 with various filter conditions to retrieve specific data
• Applied Drill through for the 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 the data warehouse using Cognos products as an administrator heavily involved with 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 with appropriate reports and security measures.
• Create complex reports using Report studio and developing Ad-hoc reports using Query Studio.
• Worked with senior management to better understand the data available in the data warehouse

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