PROFESSIONAL SUMMARY:

• 8+ years of experience in IT Industry as Cognos Developerand expertise in providing business solutions for IT Industry in areas such as Insurance, Health Care, Oil & Energy, and Banking Services wif a Functional and a Technical approach in Business Intelligence (BI) and Report Generation.
• Expertise in Full life cycle system development: Requirement gathering, Administration, Designing, Development, Testing and deployment of Data Warehousing and Business Intelligence applications using COGNOS Suite 7/ 8/10.
• Expertise of Cognos suite Cognos 8.x/10.x (Framework Manager, Cognos connection, Query Studio, Report Studio, Transformer, Metric Studio, Event Studio, Business Insight and Advanced Business Insight).
• Expertise in Framework Manager Modeling (DMR and Relational Models), Complex Report building wif Report Studio and Adhoc Reports in Query Studio.
• Proficient in designing multidimensional Model in FrameworkManager inCognosBI version 8and as well as Strong noledge and understanding of Snow Flake and Star Schemas.
• Expertise in creating List Reports, Crosstab Reports, Drill through Reports and Multidimensional Reports wif Cascading prompts, Macros, Filters, Conditional formatting, Table of Contents, drill through operations, bookmarks, and Calculations using Cognos Report Studio.
• Expertise in Report Burstingconcept to make available report to burst in report studio.
• Expertise inschedulingtheirports on daily/weekly/monthly basis to directory entries or sending emails to recipients in cognos connection.
• Expertise in providing security to teh reports in cognos connection and producing reports in different format such asPDF/Excel/XML.
• Expertise in designingDashboards and Scorecards for quick review for business users of different user classes from Cognos Connection.
• Expertise in working wif Transformer model and Building Power play cube.
• Extensive experience in SQL Server, Oracle, and DB2 for building and implementing data warehouse.
• Extensive experience on Cognos8/10 and Report net wif respect to Deployment, Content Administration, Users and User Class Creation, and Scheduling of Reports.
• Creating and managing agents dat monitor data and perform tasks when teh data meets predefined thresholds using Event Studio 8.4 and sending teh email report output to teh User community in a daily basis.
• Expertise in Migrating Cognos Impromptu Series to Cognos Business Intelligence.
• Strong noledge in teh area of Cognos Architecture and Administration.
• Good understanding of SDLC including design, coding, testing and implementation.
• Excellent communication and interpersonal skills. Strong experience in client interaction and understanding business application, data flow and data relations.
• Ability to meet deadlines and handle multiple tasks, flexible in work schedules and possess good communication skills.
• Ability to write and maintain technical documentation to describe Reports development, logic, coding, testing, changes and corrections.

TECHNICAL SKILLS:

Cognos Tools: Cognos 10.xand Cognos 8.x(Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Business Insight, Advanced Business Insight and Transformer), Cognos Report Net (Report studio, Query Studio and Framework Manager), Cognos EP BI series (Cognos Impromptu, Power Play, Transformer) and Access Manager.

Operating Systems: Windows (03, 98, NT, 2000, XP, Vista, 7), UNIX

RDBMS: SQL Server2005, Oracle 9i/10g/11g, DB2

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow - Flake Schema Modeling

Programming: SQL, PL/SQL, Embedded SQL, UNIX Shell Scripting, C, Java, C# HTML 4.0, DHTML

Applications: MS Office, MS Word, Excel, Visio, PowerPoint, Toad

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Cognos Admin/Developer

Responsibilities:

• Responsible for creating user groups and roles to manage security in Cognos Connection and Access Rights of teh reports for teh end users.
• Created database, physical, and presentation layers in framework Manager, defining appropriate relationship between query subjects and fact tables.
• Developed teh packages in Framework manager and published into teh Cognos connection server.
• Modifying teh existed report based upon teh changes requested by end users.
• Developed multi-dimensional cubes using Power Play Transformer and imported them into Framework
• Manager, created packages and published cube data to open in Report Studio and Analysis Studio for Reporting and Analysis.
• Created analysis studio reports wif context filters, and uses hide, suppress rows/columns property for better analysis and performance.
• Created crosstab reports in report studio by joining different packages into single union query, uses filters, date prompt page.
• Created list reports in report studio, and used these reports as data source in powerplay transformer.
• Responsible for any admin related issues and server maintenances.
• Responsible for running month end reporting jobs using Cognos connection.
• Prepared Cognos documents for end users.

Environment: Cognos 10.2 (Report Studio, Query Studio, Framework Manager, Analysis Studio), Powerplay Transformer SQL Server 2008, Windows Server.

Confidential, Pittsburgh, PA

Sr. Cognos Developer

Responsibilities:

• Interacted wif business analyst to gather business requirements.
• Involved in designing functional documentation.
• Created Technical design document for Report studio reports based on Functional specifications.
• Performing Report Rationalization during requirement gathering.
• Worked inFramework Manager to develop (business logic by creating prompts, folders, calculated columns, joins and naming convention) and deployed packages to teh Cognos Connection.
• Used Dimensional modeling (DMR) and Relational modeling techniques to develop Framework Manager Models.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Worked wif user profiles to ensure security by restricting user access to data based on teh individual user.
• Worked onPage explorer, query explorer, and condition explorers were used to manage teh content of teh reports in Report Studio.
• Developed dashboards comprising of list reports, cross-tab reports and chart reports using filters, calculations, complex expressions, and conditional formatting.
• Developed Multi-page reports, Drill through, and master-detail reports using Report Studio.
• Created list page headers and sub headersto lists using block in report studio list reports.
• Created Table of contents page in report studio to develop teh report in PDF format and provides drill through operations to respective content entries were used to navigate through reports instantly.
• Used table properties like merging selected cells and splitting teh merging cells, and group or ungroup selected data for lists in report studio.
• Worked on query join logic, various types of prompts like value prompt, search & select prompt, Text Box prompt and Date & Time prompt.
• Worked on layout component in page header, page footer and prompt page for uniformity across teh reports.
• Developed Burst Optionssuchas Report Bursting to make teh report available for bursting on basis of burst groups and burst recipients in report studio.
• Schedulesthe report for monthly as per client's requirementand burst teh reports to directory entriesin PDF format, and also sendse-mail notificationto particular recipients in Cognos Connection.
• Applied Securityfor individual reports in Cognos Connectionto respective users only.
• Used Cognos Scheduler to update a report for specific or recurring times and dates.
• Strong noledge wif writing SQL for fine performance, and to resolve teh reports complexity and also report testing before moving to UAT, and production.
• Uploaded and downloaded project related files from teh SharePoint team portal.
• Involved in Cognos administration, deployment (DEV, UAT, PROD environment) and production support.

Environment: Cognos 10.1 (Report Studio, Framework Manager, Analysis Studio, Business Insight and Business Insight Advanced), Oracle 11g, Toad, SQL.

Confidential, Memphis, TN

Sr.Cognos Developer

Responsibilities:

• Interacted wif business analyst and end user to gather business requirements.
• Involved in designing functional documentation.
• Created Technical design document for Report studio reports based on Functional specifications.
• Performing Report Rationalization during requirement gathering.
• Worked inFramework Manager to develop (business logic by creating prompts, folders, calculated columns, joins and naming convention) and deployed packages to teh Cognos Connection.
• Used Dimensional modeling (DMR) and Relational modeling techniques to develop Framework ManagerModels.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developed detailed and summary reports using Cognos Report Studio.
• Developed List, cross tab, drill through, master-detail, chart and complex reports,dis involved Multiple
• Prompts, Conditional formatting, Conditional blocks in Report Studio.
• Created Dashboards(Combination oflist reports, cross-tab reports, chart reports and Drill through) using underlying multiple query structure by using filters, calculations, complex expressions, conditional format.
• Involved in setting up Hierarchies, performing Drill Up and Drill Down reports and Slice & Dice operations and creating Cross Tab Reports.
• Developed reports using different Joins, Unions, complex display logics using different variables and customized teh reports by applying filters, calculations, conditions, prompts (text box, tree, value, date) and Cascading Prompts in Report Studio.
• Created Ad-hoc Reports using Query Studio.
• Used Cognos Connection for scheduling and bursting reports across teh Business segments and providing additional security to publish cubes as well as reports.
• Created various IQD in Framework Manager and from dis IQD’s as source, integrated to Power Play Transformer to create various models and build cubes.
• Design and creation of Multi Dimensional Cubes using Transformer, so dat all key performance indicators can be analyzed.
• Publishing teh Cubes to Cognos Connection to be used for multidimensional analysis.
• Developing AnalysisStudio views of analysis from dimensional modeled packages and made teh reports using them in Analysis studio.
• Assisted Quality Assurance Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas.
• Preparation of Cognos presentation for end users.

Environment: Cognos 10 (Query Studio, Report Studio, Framework Manager, Analysis Studio, Business Insight and Event Studio), Powerplay Transformer, SQL Server 2005, Windows Server.

Confidential, Houston, TX

Cognos Developer

Responsibilities:

• Analyzing teh specifications provided by teh clients and Developing specification documents for reports as per client requirements
• Created User groups and roles to manage security in Cognos Connection and Access Rights of teh Reports for theend users.
• 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 and fact tables.
• Developed FM Model against Star, Snowflake and Fact Constellation Data Models.
• Created metadata models, Joins, filters and calculations in packages, organized Folders according to teh Business view and published teh packages using Framework Manager onto Cognos Connection and created teh store procedure.
• CreatedLists, Grouped Crosstab, andReportswif calculated fields and Conditional Formatting, Conditional Page layout, Sections, page Breaks, sorting, summaries, grouping, Drill Down, Drill Up).
• Applied grouping and associated teh data wif group functionality, Performed aggregate functions on calculations inreportstudio.
• Developed prompts wifreportpick listand generated teh current information by applying proper filter condition.
• Created Models using Power Play Transformer using various data sources.
• Creating teh Cubes based on teh requirements and creating teh drill through reports forthe cubes and provided to teh end users.
• Modifying teh existing report based upon teh changes requested by teh users.
• Scheduled to triggerreports based on an event using Event Studio.
• Developed Ad-hoc reports using Query studio.
• Developed OLAP multi-dimensional cubes using Power Play Transformer and imported them into Framework Manager, created packages and published cube data to open in Report Studio and Analysis Studio for Reporting and Analysis.
• Updated Stored procedures, Database views as per user requirements.
• Trained teh end users to TEMPeffectively use teh reporting tool to build and customize their ad-hoc reports.
• Created documentation for teh complete project life cycle and mentored teh End Users and Provided teh Technical Support.

Environment: Cognos 8.4 (Report Studio, Query Studio, Framework Manager, Event Studio and Power Play Transformer),Windows NT,Oracle 9i, Toad, PL/SQL, MS Access.

Confidential, Irving, TX

Cognos Developer

Responsibilities:

• Built Framework Manager Model, and established teh cardinalities to suit teh business needs. Implemented security for Data access, Object level access and Package access.
• TEMPEffectively communicated wif Business Analysts to resolve design action items. Involved in providing both business and technical expertise in teh requirements gathering, report design, report development, and support of all client/server layers and components of teh data warehouse.
• Created Materialized views to aggregate data at teh lowest level for faster cube build times.
• Responsible for creating User groups and roles to manage security in Cognos Connection and Access Rights of teh Reports for teh end users.
• Designed and Developed summary and detail reports which involves teh key functionalities of teh report studio like conditional blocks, conditional layouts.
• Designed and Developed reports which involve drill down, drill up and drill through functionalities in report studio.
• Supplemented regular prompts, cascading prompts, filters, Conditional style, static headers, Drill Through, sub queries to add interactivity for users in Report Studio.
• Carried out UAT by developing test scenarios, test cases, test data to be used in testing based on business and user requirements, technical specifications and/or product noledge.
• Bursting Reports based on groups of users & Ps for our Asian and European partners.
• Designing teh Power play Transformer Models and publishing teh cubes for teh business users to analyze data.
• Creating Analyses from teh published cubes using Analysis Studio as per teh Business needs.
• Creating teh scripts for teh automation of cube building and publishing
• Tested and improved Report Performance through query optimization.

Environment: Cognos 8.1 (Report Studio, Query Studio, Framework Manager and Power Play Transformer),Windows NT,Oracle 9i, Toad, PL/SQL, MS Access.

Confidential, Frisco, TX

Cognos Developer

Responsibilities:

• Created Impromptu Catalog by adding tables and data files, & creating new joins.
• Created Prompts, Calculations, Conditions & Filters and creating New Jobs using Impromptu Administrator.
• Created Models by using various data sources in Power Play Transformer.
• Created User Classes and Users in Access manager and provided teh user credentials.
• Created extremely big OLAP cubes.
• Used Power Play Enterprise Server to publish teh cubes and Impromptu reports to teh Upfront.
• Build Transformer models using Cognos 7 series.
• Create catalogs and reports in Cognos Impromptu, design teh cubes using Power play Transformer and build & testing of power play cubes.
• Publish reports on Cognos Upfront and create users, user classes, user groups and grant permissions using Access Manager Administration
• Develop new Unix Scripts for enhancement to existing system using detailed design documents.
• Migrated teh Impromptu catalogs from Cognos 7.3 to Cognos 8.
• Create simple list, grouped list, cross tab, grouped cross tab reports by using report studio
• Create simple, complex reports using Cognos Report Studio
• Create reports using report studio wif multiple charts and reports
• Create relational, OLAP models in Framework Manager and publish teh packages
• Involved in creating teh IQD.
• Designed teh transformer model by identifying teh dimension, hierarchy and teh measures.
• Implemented Drill through from Analysis Studio to Report Studio.
• Prepared teh following business/technical writing of requirements, design, templates, development standards documents and detailed design documents.
• Prepare Quality Documents and also give project induction and noledge transition to new joiners.
• Involved in performance tuning of Cognos reports by tuning teh SQL.

Environment: Cognos 7 (Impromptu, Transformer, PPES Administrator, Impromptu Web Report Administrator), Cognos 8.1 (Framework Manager, Query Studio, Report Studio, Analysis Studio), Oracle 9i

Confidential, San Diego, CA.

Cognos Developer

Responsibilities:

• Involved in Installation & configuration of Cognos Impromptu, IWR and Access Manager.
• Created Catalogs to meet teh reports requirements.
• Interacted wif end Users to identify key Dimensions and Measures and Levels. Created Power Cubes.
• Created teh calculations, conditions, and prompts, organized teh folders, set up user classes and Security.
• Involved in design, development and maintenance of catalogs, created Impromptu reports and IQDs using Impromptu Administrator.
• Created standard and Ad hoc reports using Cognos Impromptu tools querying databases.
• Created teh various business reports - Simple, Group, Cross Tab, and Drill down.
• Created and maintained News boxes using Cognos Upfront.
• Published Impromptu Reports in teh Web using Cognos Server Administration tool
• Created Multidimensional Models & Cubes from IQD, MS Access, MS Excel, Crosstab, Flat Files.
• Deployed teh Power Cubes on Cognos Power Play Enterprise Server.
• Created multiple layer reports providing a comprehensive and detail report wif Drill through facility
• Generated Nested Categories and Revenue Statements, Business Mix Reports, Changing filters, layers and measures, Sorting, Ranking, etc.
• Created user classes and users using Access Manager.

Environment: Cognos Impromptu, Cognos Transformer, Cognos Power Play, Cognos PPES Administrator, Cognos Impromptu Web Report Administrator and Oracle 9i