SUMMARY

• 7+ years of experience in Design and Development wif teh primary focus on teh Cognos 10/ Cognos 8 Suites, Cognos Reportnet 1.1, Cognos Impromptu, Cognos Transformer, Cognos Power Play, PowerPlay Enterprise Server, Impromptu Web Reports (IWR), Access Manager
• Experience in implementing large - scale applications wif leading technologies in Business Intelligence and involved in complete software development life cycle (SDLC)
• Extensive experience in Designing teh Framework Manager models, to meet BI industry standards applied Physical Layer, Business Layer and Presentation Layer approach to increase teh model durability
• Experienced in designing and development of DMR models
• Created models wif different data sources such as Oracle, SQL Server and MS Access
• Published packages to avail metadata for reports authors, using Framework Manager
• Created IQDs in teh Framework Manager which are considered as inputs for creating multi-dimensional cubes using Transformer
• Extensive experience in creating Managed/Complex reports using Report Studio and creating ad-hoc reports using Query Studio
• Created different kind of analytical reports including templates, List, Cross-Tab, Chart, Repeaters using Report Studio
• Worked on advanced features of Report Studio such as Conditional Variables, Conditional Blocks, Drill-through, Page set, Master-Detail relationships, Bursting and various kind of prompts (Value prompt, Date prompt, Textbox prompt)
• Experienced in Reports Deployment from development environment/server to Testing and Production environment/server using Content Administration
• Installed & configured teh Cognos 8 BI Single Server Environment, Administering teh Servers, Troubleshooting, Performance Tuning and implementing security
• Hands on experience in reports migrating from Cognos 7 series to Cognos 8.x & Cognos 8.x to 10.x
• Troubleshoot issues wif existing reports and cubes, Expertise on creation and maintenance of models, which involved defining security, joins, cardinality, filters and governor settings Cognos 8.x
• Designed and Created power cubes for multi-dimensional analysis
• Created multi-dimensional reports using Analysis Studio and applied context filters for better analysis
• Having experience in implementing security for Cubes and Package, Object and Data level security for Packages
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing database schemas (Star Schema and Snowflake Schema) used in relational, dimensional and multidimensional modeling.
• Involved in requirement gathering for effective analysis
• Involved in Reports Testing and UAT
• Excellent work ethics, self-motivated, quick learner and team oriented. Continually provided value added services to teh team through thoughtful experience and excellent communication skills

TECHNICAL SKILLS

Business Intelligence Tools: Cognos BI Suite 10.x/8.x/7.x (Query Studio, Report Studio, Analysis Studio, Business Insight Advanced, Active reports, Event Studio, Cognos Connection, Framework Manager, PowerPlay Transformer, Impromptu Administration, Data Manager Upfront, IWR and PPES) ReportNet 1.1 (Query Studio, Report Studio, Framework Manager, Metric Studio, Cognos Connection)

Databases: Oracle 8i/9i/10g, MS SQL Server 2000/2005, MS Access 7.0

Querying Tools: Toad, SQL-Plus

Data Modeling: Visio 2003, Erwin

Operating System: Windows-98/NT/2000/XP/Vista, Linux, Solaris, UNIX(IBM AIX, HP-UX), DOS

Languages: SQL, PL/SQL,.net,java.

Directory Servers: LDAP, Active Directory Server

PROFESSIONAL EXPERIENCE

Confidential, Jeresey City, NJ

Cognos Developer

Responsibilities:

• As a Cognos Report Developer responsible for building and optimizing Cognos 10 Report Studio reports supporting common data sources
• Global Services Operations (GSO) is responsible for service support and delivery for Confidential 's Global Technology Infrastructure (GTI).
• Includes roles related to data gathering, analysis and reporting. As Individual work directly wif data and information, creating meaningful analyses, reports and management presentations in support of client, business unit or function activities and performance.
• Redirect operational reporting and online tools from using teh SC reporting database to teh CPR(Center for Progressive Reform) database.
• As a member of a larger Business Intelligence team, responsible for reviewing business requirements and developing solutions to meet teh needs of teh customer. dis effort will support migration of reports from Business Objects to Cognos and creation of new consolidated reports leveraging basic to advanced Cognos 10 skills, including Active reports.

Environment: Cognos10.X (Framework Manager, Report Studio, Query Studio, Event Studio), Cognos Connection, Cognos BI Modeling, Cognos Transformer, Cognos Impromptu Administrator, Cognos PowerPlay, Cognos Scheduler, Access Manager, Configuration Manager, Oracle 10g, Windows NT/2000.

Confidential, Richmond, VA

Senior Cognos Developer

Responsibilities:

• Trained in Basic Risk management which halped in gathering precise business requirements
• Analyzed teh requirement and created a project plan
• Designed and Developed Relational and Dimensional Data Models in Framework Manager for Query Studio and Analysis Studio.
• Created Business Views, namespaces, model query subjects in Framework Manager Packages for easier report development and enhance multi-user environment.
• DMR was used as a source to teh Dashboard and relational source was used for detail drill through reports
• Dashboard was created wif sophisticated user interface by using CSS and JavaScript. It contains tabbed interface separating Credit Risk, Market Risk, Operational Risk and Wholesale Risk.
• Each indicator was shown wif various images of metrics to indicate its performance and highlights teh degraded trends of indicators
• Created individual detail reports for each Risk Indicator showing detail Guage and Combination charts. dis also shows a complex crosstab which dynamically renders teh years selected in teh main dashboard
• Drill through were provided for each indicator and made teh whole project navigation simple and easy to use interface
• All teh detail reports were scheduled to run by teh trigger, which fires as soon as teh data gets loaded into teh database
• Saved reports output was shown as a mouse over on teh Consumer Risk Dashboard using complex java scripts
• Implemented security by country level and gave access to that particular data in which teh user is responsible of
• Responsible for PL SQL development to develop stored procedures which are used as a sources to some of teh detail reports
• Developed many PL/SQL critical custom interface process for Accounts Defaulters/Risk as well Oracle extension modules for Custom Applications like Settlement/Debit Card/ISO/Third party Billing and Commission
• Involved in Step-by-Step Documentation of training material and Training of end users on Query Studio and Report Studio for Reporting.
• Created various test cases for teh Data validation in SIT environment
• Wrote test scripts and queries for teh reports to check teh data validation against Data warehouse database and source application database
• Used error handling strategy for trapping errors by using teh error function in teh mapping level and sending errors to an error table
• Responsible for creating, handling and taking care of parameter file modifications in new releases and enhancement.

Environment: Cognos10.X, Cognos 8.4/8.3 (Framework Manager, Report Studio, Query Studio, Event Studio), Cognos Connection, Cognos BI Modeling, Report Net 1.1, Cognos Transformer, Cognos Impromptu Administrator, Cognos PowerPlay, Cognos Scheduler, Cognos Upfront, Access Manager, Configuration Manager, Oracle 10g, Toad, Windows NT/2000.

Confidential, Pittsburgh, PA

Senior Cognos Developer

Responsibilities:

• Interacted wif business user and gathered requirements from teh business and analyzed teh best sources for teh reports
• Developed Technical Design Specifications for reports and also recommended preferred solution for report development
• Created Framework Manager Model based on business requirements for reporting and Dimensionally Modeled Relational (DMR) for multi dimensional analysis
• Created Database, Business and Dimension layers wif defining appropriate relationship between query subjects in Framework Manager
• Created Regular dimensions, Fact dimensions, Levels and Hierarchies
• Implemented Third Party Security wif LDAP and used roles & groups in creating Data Level, Object Level, Package Level securities in Framework Manager model
• Created multi-dimensional analysis reports using DMR models in Analysis Studio and applied context filter for better analysis
• Created score cards wif multiple formats using metric studio
• Created reports wif detailed and summary filters, provided various kinds of prompts such as Value, Date, Textbox…etc
• Developed complex reports in report studio using prompts, parameters, filters and conditional formatting
• Extensively used Query Studio for developing Ad hoc reports
• Customized teh reporting environment by adding new portal skin including corporate logos and approved colors and new links
• Creating and Managing Jobs and Schedules
• Created portal pages/Dashboards by including business critical reports to monitor teh business in a single glance
• Scheduled and managed events using Event studio
• Involved in Report testing and UAT

Environment: Cognos Suite 8.4 (Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Transformer), Oracle 10g

Confidential, Philadelphia, PA

Cognos Developer

Responsibilities:

• Worked on Cognos Framework Manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos 8 server.
• Mentored and trained team on Framework Manager, Report Studio and Query Studio tools.
• Involved in setting up Groups/Roles to secure teh models and packages.
• Deployed packages, folders and content store from a development environment to test environments
• Making enhancements of teh report based upon teh requirements of teh user.
• Created Dashboards to present critical company data in a single report
• Migrated Power Play reports to Cognos 8 BI Report Studio
• Modifying Business view wif calculations filters to reflect business rules
• Writing complex Cognos8 Report Studio reports, as well as teh unit and system integration testing of those reports.
• Maintaining Cognos Report Studio server in development environment and migrating reports from development to test environment.
• Used Cognos Connection to administer and schedule reports to run at various intervals of time
• Designing teh Dimensional (DMR) models using Framework Manger
• Created Regular Dimension as per requirements and arranged them as per teh Hierarchy defined by business users.
• Modifying teh Dimensional (DMR) models in Frame work Manger
• Published (DMR) Model for Multi Dimensional Analysis of reports and enabled drill up and drill down features.
• Created various reports using (DMR) package in Analysis Studio, Report Studio
• Performed Drill through definitions on Multiple reports
• Implementing data level security according to various user classes.
• Set security for individual reports in Cognos Connection.
• Worked wif user profiles to ensure security by restricting user access to data based on teh individual user.

Environment: Cognos 8.3/Report Net 1.1, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Teradata, XML, Oracle, SQL Scheduler and Windows NT/2000.

Confidential, Atlanta, GA

Cognos Developer

Responsibilities:

• Developing Models and Packages on Cognos Framework Manager Created Analytical Reports using Cognos Report Studio.
• Creating advanced reports in Report net using Cognos Connection.
• Preparing reports like list report, Cross tab Reports, chart reports created in Report Net.
• Creating filters, prompts, calculations in reports of Report Net.
• Creating folders, conditions, calculations, prompts in catalogs of Impromptu Administrator.
• Developed reports in Report Studio include Complex list reports, cross tab reports wif Report pick lists
• Developed Prompt pages, used Conditional Variables for Conditional Formatting
• Manually modified teh SQL in Report Studio to tune and/or to write complicated reports. Used subsets to write union/subtract queries in Report Studio
• Involved in formulation of joins strategy, query optimization and weighing teh tables
• Making enhancements and modifying teh existing report based upon teh change request by teh user.
• Developed reports using Drill through functionality
• Analyzed XML’s from Impromptu report to develop teh same query in Report Studio
• Created Impromptu Web Reports and published them on teh web server and later on Upfront.
• Applied Zero Suppression, Layering functionalities present in .PPX in Cognos 8 Reports
• Maintaining Cognos Report Studio server in development environment and migrating reports from development to test environment.
• Migrated several existing Cognos Impromptu Catalogs into xml files and imported teh xml files as data sources into Cognos Report Net Secured Cognos Connection and setup Report Net security by assigning to teh users.
• Migrating Cognos Series 7 Impromptu reports to Cognos 8 BI Report Studio.
• Scheduled Impromptu and Power Play reports to run on a monthly, weekly, and daily basis using Cognos Scheduler

Environment: Cognos Report Net 1.1 Frame Work Manager, Cognos Connection, Report Studio, Query Studio, Impromptu 7.3, Power Play 7.3, Power Play Transformer 7.3 and Oracle 8i, DB2 and Unix

Confidential, Piscataway, NJ

Jr. Cognos Developer

Responsibilities:

• Installed and Configured Cognos series 7 (IWR, Upfront, PPES and Access Manager)
• Generating various List Reports, Grouped Reports, Cross tab Reports, Chart Reports.
• Created Drill-Thru, Sub-reports and Chart reports using Impromptu Administrator.
• Created various reports using drill through, cascaded prompts, conditional formatting and master detail relationship.
• Published Impromptu Reports and Power Play Cubes to Upfront using Cognos IWR Administration and Power Play Enterprise Server respectively.
• Created special categories and secured Power Play Models using Power Play Transformer.
• Tuned teh IWR reports using Impromptu and Power Play cubes using Transformer.
• Created catalogs using Cognos Impromptu 7 to generate reports.
• Worked wif Access Manager Administrator to provide security for Cognos applications.
• Implemented security and granted privileges according to user classes using Access Manager.
• Involved in performance tuning of teh application.

Environment: Cognos Report Net 1.1 MR2(Frame work Manager, Report studio), COGNOS 7.3 (Impromptu Administrator, IWR, Power Play, Transformer, Power Play Enterprise Server, Power Play Web, Server Administration, Report Administration, Access Manager, Upfront), TOAD,DB2 and Sybase, Windows XP.

Confidential

Jr. Cognos Developer

Responsibilities:

• Involved in data gathering during teh business analysis and planning phase of teh project.
• Involved in Installation and Administration of Cognos Series 7 Tools
• Upgrade of Cognos products from Version 7.0 to 7.1.
• Importing meta data using Impromptu catalogs
• Improving query performance using Governors. Generated various reports including List, Grouped, Cross
• Created different types of reports like Drill through reports, Sub reports, and List reports.
• Created Impromptu catalog in order to generate reports.
• Created standard filters, calculations, prompts and conditions in catalog.
• Designed models by mapping business needs using Power Play Transformer and created multi dimensional cubes, cube groups, power play reports
• Decreased teh cube build times drastically and increased runtime performance
• Designed report sets wif user class mapping and published to different news boxes in Upfront in IWR server.
• Maintained Impromptu, IWR, Cognos Power Play and PPES

Environment: Cognos Impromptu 7.1, Impromptu Web Reports 7.1(IWR), Cognos Power Play 7.1, Cognos Power Play Transformer 7.1, Cognos Power Play Enterprise Server 7.1,Cognos Upfront 7.1, Access Manager 7.1, Configuration Manager 7.1, SQL Server, Erwin, Ms-Excel, UNIX, Windows NT