SUMMARY

• Having 8 + Years of experience in Data warehousing, Business Intelligence, designing, developing, and maintenance of reports and systems utilizing BI software including Cognos suite.
• IBM Cognos 10.1.1(Framework Manager, Report Studio, Analysis Studio, Query Studio, Event Studio, Cognos Connection, Active Reports, Business Insight and Business Insight Advanced)
• Cognos 8 BI v8.4,8.3,8.2 (Framework Manager, Report Studio, Analysis Studio, Query Studio, Event Studio),Cognos Power play Transformer V8.3, Cognos Access Manager, TM1 Architect, TM1 Web and Executive viewer.
• Built Framework Manager Model and established the cardinalities to suit the business needs, connecting and testing the data source, created database layer and business layer.
• Build models with Model Query Subjects, Data source Query subjects, Query Items and Namespaces from scratch as well as from imported metadata to create Database layer and Business View Layer.
• Designed Framework Model and used modify existing models and republish packages.
• Created models using Framework Manager in multiple namespaces by creating shortcuts, joins, star schema groupings, Calculations and filters.
• Imported Metadata from various data sources into Framework Manager.
• Worked on Various Projects for Unit testing of the different layers of Framework Model and increased the Performance of Framework manager code.
• Defining Scope relationships and determinants.
• Developed and Published Packages by implementing DMR Modeling in Framework Manager.
• Defined and built hierarchies for various dimensions as a part of DMR modeling.
• Customized data by adding calculations, Filters and Prompts.
• Experienced in creating Dashboards using Report studio.
• Developed Prompt Page Reports using Conditional blocks and Conditional Variables for developing the User Prompted Report.
• Used Manually Modified SQL in Report Studio to write complicated reports. Used subsets to write union, intersection and joins in Report Studio.
• Developed the OLAP cubes using Power Play Transformer.
• Created Models by using Impromptu Query Definition (IQD) in Power Play transformers and developed cubes.
• Created User Classes and users in Access manager and worked on Cognos Security administration.
• Experienced in SQL, PL/SQL stored Procedures.
• Good knowledge of Cognos architecture, Dimension modeling using Star Schema and Snow - Flake Schema.
• Experience with Transformer models and cubes that were used in Power play analysis and also these cubes were used in various Analysis Studio reports.
• Experienced working on DB2 Win SQL, ORACLE 9i, 10g, SQL SERVER 2000/2005 environment.

TECHNICAL SKILLS

BI Tools: IBM Cognos 10,Cognos 8 BI (Report Studio, Query Studio, Analysis Studio, Framework Manager), ReportNet 1.1, Impromptu Web Reports (IWR), Power play Transformer 7.x/6.0, TM1 Architect, TM1 Web and Executive viewer, MS BI (SSRS, SSAS,SSIS).

ETL Tools: Informatica, Datastage.

Databases: Oracle9i/10g/11g, SQL Server 7.0/2000, Teradata, DB2, MS Access 7.0/00/97.

Modeling: Toad 7.x, SQL Navigator, Toad for Oracle, Toad for MS SQL

Languages: SQL, PL/SQL, VB.NET, ASP.NET, JAVA, C++,XML

OS: Windows 95/98/2000/XP/NT/7/8, DOS, Unix

Web Server: Java Web Server, Apache Web Server, IIS

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr.Cognos Developer

Responsibilities:

• Participated in Requirement Gathering, Business Analysis, User meetings, discussing the issues to be resolved.
• Worked extensively on creating the Model and publishing the package on Cognos Connection for Reporting purposes.
• Published different packages from Framework Manager to Cognos Connection
• Implemented all business logic in Framework Manager by creating prompts, folders, calculated columns, joins and naming convention
• Worked on creating and analyzing the complex reports like Cross tab, drill-thru reports.
• Created multiple page reports with page-break based on the first page of report using master-detail relationship.
• Created list reports, cross-tab reports and chart reports using underlying multiple query structure by using filters, calculations, complex expressions, and conditional formatting.
• Applied different functionalities like filters, prompts for Cognos reports to retrieve relevant data
• Enhanced the performance of the reports by changing the properties of the Query such as Auto Group & Summarize, Processing, Execution Method and Use Parameter Info.
• Used Layout component reference in page header, page footer and prompt page for uniformity across the reports.
• Set security for individual reports in Cognos Connection.
• Constructed Conditional Drill through, Drill through and Master-detail reports using parameterized filters in Report Studio
• Developed Reports using Queries and set operations logics
• Created Prompts like value, Date, time and cascading prompts
• Created consolidated reports for different formats like PDF, Excel and CSV using conditional layouts.
• Developed various standard reports like list reports, cross tab reports.
• Written String, Boolean variable conditions as per the requirements in the reports.
• Involved in unit testing, smoke testing and performance testing of the reports
• Written SQL queries in database to test cognos reports before moving to QA testing.
• Prepared migration template and raised work order for move the code to different env.
• Prepared design documents for the reports developed in Cognos.
• Involved in production support.

Environment: Cognos 8.4/10.1.1 Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection, Windows XP/7, Toad for Oracle, Oracle 10g/11g.

Confidential, NJ

Cognos Report Developer

Responsibilities:

• Understand the customer Requirements and the Technical specification documents.
• Involved in Creation of Model and Publishing Package in Framework Manager.
• Created filters within the Model for improving the performance of the Model
• Designed the reports in report studio as per the requirements.
• Generated various kinds of reports like List, Cross tab, Labels, Repeaters, Drill through, Master-Detail and Bookmark.
• Created list, crosstab reports using cascading prompts, calculations, and drill-throughs.
• Created the conditional formatting reports.
• Creating reports using DMR to enable drill up and drill down on data
• Formatted the reports using layout component reference and Classes.
• Created reports by using Query calculations and Layout calculations.
• Formatting, sorting and grouping the reports.
• Developed Prompt pages and Conditional Variables
• Customized data by adding Filters, Prompts, Calculations, Summaries and Functions.
• Created page breaking by using page sets for displaying the reports according to the data item value.
• Scheduling and distributing reports through schedule management in Cognos Connection.
• Applied Security for Object level, Data level and Package in Framework Manager
• Developed Customize and Burst reports using Report Studio.
• Deployed packages and reports from development environment to test environment and to production environment.
• Involved in Unit Testing and Performance Testing.

Environment: Cognos 8.4(Framework Manager, Report Studio, Query Studio, and Cognos connection), Cognos Access Manager, Toad, Windows XP, Oracle 10g,Java Script.

Confidential, VA

Cognos Report Developer

Responsibilities:

• Gathered reporting requirements and converted it to technical specification
• Provided design and development of star schema data warehouse. Data Warehouse constantly evolved, as more types of data were required.
• Assisted in design of star schema data warehouse.
• Dimensionally modeled data for BI reporting using Cognos Framework Manager.
• Created DB Layer, Business Layer and presentation Layer, handled the relationships between query subjects.
• Published package from Framework Manager to Cognos Connection
• Hide and Show the objects by using conditional blocks
• Developed reports using prompts like value prompt and Tree Prompts.
• Created customized tool bars in Cognos connection
• Made Documentation to all dynamic sorting techniques, locked headers and locked columns.
• Implemented Data Level Security in the framework model and Report Level Security with Users Groups
• Created complex reports, Drill Through reports and graphs in Report Studio
• Used Conditional Formatting using variables, blocks and layouts
• Responsible for Cognos Code Moves among various serves Development/ Test/ Production.
• Involved in testing Cognos reports in Accuracy & Performance using SQL.
• Created Burst Table and involved in bursting of reports

Environment: Cognos 8 Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Data Modeler, Oracle 9i.

Confidential, PA

Cognos Developer

Responsibilities:

• Interacted with business analyst to gather business requirements and designed functional and technical requirements documentation.
• Monitoring the performance of the drill through reports and Scheduled Reports
• Created new Query subjects and arranged in different Folder Structure for Business View
• Analysis of the performance issues in different environments like Dev, QA and Prod.
• Created Packages according to the company specifications using Framework manager
• Created metadata in Framework Manager created and published packages based on the security
• Constructed Drill up, Drilldown, Drill through, master-detail reports using parameterized filters in Report Studio
• Developed Reports using new Page sets concepts for Hierarchical reports
• Developed Reports using Queries and set operations logics
• Created Job to Run the Multiple Reports through Job
• Created Prompts like value, Date, time and cascading prompts
• Created the conditional formatting reports.
• Developed various standard reports like list reports, cross tab reports.
• Comparison of the way the IQDs and drill through are getting generated.
• Worked on Mdl models and Mdc power cubes.
• Involved in unit testing of the reports

Environment: Cognos Report net 1.1, Cognos 8.2, Impromptu, Poweplay, Decision Stream 7.1.5, Access Manager 6.5,Remedy 6.3, SQL Navigator 4, Informatica 7X, Facets, Sql server 2005 and Oracle 9i on Windows 2000/XP.

Confidential

Cognos Report Developer

Responsibilities:

• Interacted with Onsite Coordinator for Requirement gathering.
• Worked on Data marts related to Claims, Policy, Billing, Coverage and Premium.
• Worked on Segregation of Dimensions, Navigation Dimensions, and Measures and computed measures from Data marts.
• Involved in Creation of Data model in ERWIN.
• Developed a FM Model for CLAIMS Subject Area.
• Created report templates using Query Studio.
• Designed and developed different types of reports using Report studio.
• Coordinated with Onsite coordinator and involved in change requests after development
• Involved in preparing Data Validation Sheets.
• Involved in writing test queries and executing them for testing against the reports Unit Testing .
• Warranty support after project delivery

Environment: Cognos 7.0 tools, Cognos Report Net 1.1, Informatica Power Center, Oracle 8i, SQL Server, PL/SQL MS Access, WINDOWS 2000/NT/XP.