SUMMARY

• 7+ years of IT experience with hands - on experience in different phases of software development life cycle (SDLC) including analysis, design, development, testing and production support.
• Strong understanding of relational database design concepts and in depth knowledge of implementing Reporting and OLAP solutions using Cognos10.1.1, 10.2.1/ Cognos 8 BI, Power Play Transformer, Cognos Workspace, Cognos Workspace Advanced.
• 6 plus years of hands-on experience designing Data Models using Framework Manager and Developing simple to moderately complex Reports using Report Studio, Query Studio, Event Studio and Analysis Studio.
• Hands on experience in Cognos content Administration, deploying and maintaining Models and reports across multiple Cognos environments (Dev/QA/UAT/Production)
• Created cubes in Transformer using existing multi-dimensional packages, implemented cube partition and auto refresh of cubes using windows scripts and schedule tasks.
• Trained and evaluated senior excel engineers on Cognos 10 Report Studio in IBM.
• Developed various types of reports like List, Cross tab, Chart and Dashboard reports in Cognos 8.3/8.4/10.
• Applied Conditional formatting, Conditional blocks, TOC and different kinds of prompt functionalities.
• Created bursting reports, drill-up, drill-down, drill-through, Master-detail relationship and report views in Report studio.
• Created Active reports and converted existing reports to Active reports.
• Created reports from different sources using Unions and Joins.
• Creating Query Set, filters, prompts, calculations and implemented package level, object level and data level securities in Framework Manager.
• Performed unit tests for complex reporting programs prior to release of code for Quality Assurance
• Sound knowledge on Data warehouse concepts.
• Knowledge on Oracle Database Administration, SSIS, Informatica and Tableau.

TECHNICAL SKILLS

Data Warehousing: Cognos 10.1,Cognos 8.4.1, 8.3, Cognos Framework Manager, Cognos Transformer, Report Studio, Event Studio, Analysis studio, Workspace and Workspace Advanced

Programming languages: HTML, JavaScript, C++, Python

RDBMS: Oracle 9i /10g, IBM DB2, Sql Server 2008/2012

Operating Systems: Windows XP / Windows 2000/2003 Server, Linux

PROFESSIONAL EXPERIENCE

Confidential

Senior Developer

Responsibilities:

• Understood the existing architecture and identified few irregularities.
• Proposed a new solution to organize the reports under Geo, Brand buckets
• Implemented the above solution with careful division of reports with a new frame work manager model.
• Created dashboard reports for Sales leaders in order to easily identify the top and bottom performing Brands, Sectors.
• Created FM models and designed packages for the report studio authors.
• Developed most report types (Lists, Crosstab, Charts, master-detail, drill down, drill through, Active reports, reports based on OLAP data sources like Transformer Cubes) using Cognos 10.2.
• Involved in conversion of existing Excel reports into Cognos.
• Implemented User/Data/Package level security using Framework Manager and Cognos Connection.
• Simplified Report development effort for developers by creating calculated query items for over 90% of Key Metrics inside Framework Manager. Developers can use these query items directly from the presentation layer of the Reporting Packages.
• Created Dashboard reports, implemented drill through functionalities.
• Implemented trigger based scheduling.
• Involved in conversion of existing Excel reports into Cognos.
• Used Prompts and Prompt tokens effectively for merging many excel reports to Single Cognos report.
• Worked on Conditional formatting, Unions and Joins
• Created report documentation and related tech specs.

Environment: Cognos 10.1/10.2.1 , Framework Manager, IBM DB2

Confidential

Senior Developer

Responsibilities:

• Extensively uses Unions and joins in reports to get data from different sources, which are not joined at model level.
• Worked on Enterprise Framework Model development.
• Created Different types of packages using IBM DB2 database for automation of existing Excel and Hyperion Brio based reports.
• Extensively existing excels reports automation.
• Worked on Multilingual model to support different region customers.
• Created different type of Active reports for demo.
• Worked on Packages and reports Deployments.
• Created various kinds of Filters, Prompts and Cascading prompts.
• Implemented drill through functionalities for several reports including charts.
• Worked on report performance issues of existing reports.
• Used Prompts and Prompt tokens effectively for merging many excel reports to Single Cognos report.
• Developed Test Case reports for QA.
• Created report documentation and related tech specs.
• Involved in Weekly Sanity Testing.

Environment: Cognos 8.4.1/10.1, Framework Manager, IBM DB2

Confidential

Report Developer

Responsibilities:

• Analyzed the changes requested for the reports from the specification and identified the gaps.
• Involved in preparing/Updating Low Level Design Documents for Framework Manager.
• Involved in Creating / Updating Framework Manager Models.
• Created complex reports in Report studio.
• Create Code Export file to move the package and reports to TEST environment.
• Designed drill through reports for analyzing the business performance.
• Scheduled reports using event studio.
• Developed standard reports based on business requirements using report studio.
• Worked on framework manager, to import metadata from data source and maintain business models for standard reports and Analysis Studio and publish packages to Cognos server.
• Worked on Master-Detail Relationship Reports.
• Worked on, Drill through reports, Conditional Layout reports and extensively worked on Chart and Cross-Tab reports.
• Worked on different rendering report using render variables.
• Extensively worked on conditional styles and using different variables and different Formatting types.
• Extensively worked on Data Format.
• Involved in Unit Testing.

Environment: Cognos 8.4.1, Framework Manager, Oracle 10g

Confidential

Developer

Responsibilities:

• Understood the business requirements for the development and design of reports.
• Involved in Creating / Updating Framework Manager Models
• Created Triggering Events by using Event Studio for automatic mailing of reports.
• Developed list reports and cross tab and chart reports.
• Prepared the reports using prompts, cascading prompts, filters and variables in report studio
• Used Query studio for Ad-hoc Reporting and Report studio for Advanced Reporting.
• Developed and Executed Test Cases.
• Used conditional formatting based on Threshold values.
• Used Rendering based on conditions.
• Designed drill through reports for analyzing the business performance.

Environment: Cognos 8.4, Framework Manager, Oracle 10g

Confidential

Developer

Responsibilities:

• Used Report Studio to develop various types of reports like List Reports, Cross tab Reports Chart Report & Master Detailed Reports as per the client requirements.
• Involved in creation of Drill -Through and Master-Detail reports.
• Prepared various reports using cascading prompts, Text box prompts and value prompts in Cognos Report Studio.
• Developed reports based on conditional formatting.
• Created reports Views and scheduled in Cognos connection.

Environment: Cognos 8.3, Framework Manager, Oracle 9i

Confidential

Oracle DBA

Responsibilities:

• Database creation and maintenance
• Table space creation and maintenance
• Monitoring Space (Table spaces, Extents) and allocating if needed
• Monitoring Alert logs for any oracle errors and fixing.
• Responsible for managing users, roles and profiles.
• Cloning Production Databases for Testing Purpose Periodically.
• Database security planning and implementation
• User creation and maintenance
• Backup and recovery (Hot and Cold backups, RMAN)
• Archive log maintenance and clean up.
• Export /Import of whole database or selected schemas
• Responsible for application high availability
• Created and managed users, roles and groups

Environment: Oracle 9i, Linux 4.0