SUMMARY

• Over 8 years of experience in Analysis, Design and Development of Business Intelligence Projects and software development life cycle.
• Strong knowledge and experience in BI environment utilizing tools such as Cognos 10.1/Cognos 8.x (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio and Metric Studio), Cognos Impromptu 7.x, and experience wif ETL tools like Informatica 8.0.
• Expertise on a range of Data warehousing products such as: Cognos 8 BI, Cognos Report Net.
• Experience in building cubes using Power Play Transformer.
• Expertise in Framework Manager Modeling (Database Layer, Intermediate Layer, Presentation Layer, Packages).
• Experience in building Complex Reports (List Reports, Cross Tab Reports, Charts, Maps, Drill through, Master - Detail Reports and burst Reports).
• Extensive experience in BI modeling/Report Authoring using Cognos 8 Suite, Cognos Report Net 1.1.
• Strong knowledge on Installation & Configuring teh Cognos 8/7i tools in distributed environments.
• Hands on experience in developing score card reports using metric studio.
• Experience working in various domains including healthcare, banking and financial services.
• Excellent knowledge on data warehousing concepts - Star schema, Snow-flake Schema and worked on both OLAP and OLTP databases.
• Strong Experience in Data Modeling, Data Validation & Implementing Data ware housing Concepts.
• Experience in Migrating and Upgrading cognos reports and models
• Deploying models and reports from Development to Production and administering users/groups/roles.
• Very good Experience wif MDX Functions in Report Studio using Multi-dimensional Sources.
• Solid understanding of Cognos 10.1 BI Architecture and Administration including Framework Manager, Query Studio, Report Studio, Access Manager.
• Developed Materialized Views for Report Performance Tuning.
• Extensive experience on production support and troubleshooting/test issues wif existing reports.
• Experienced wif Multiple Relational Databases including Oracle, MS SQL Server, Teradata and DB2.
• Ability to meet deadlines and handle multiple tasks, flexible in work schedules and possess good communication skills.

TECHNICAL SKILLS:

Reporting Tools: Cognos 10.1, Cognos 8.x (Report Studio, Query Studio, Analysis Studio, Framework Manager, Metric Studio), Cognos ReportNet 1.1 MR1 and MR2, Cognos Impromptu 7.x, Impromptu Web Reports(IWR),Power Play Transformer 7.x, 8.4, SSAS,Toad, SQL Navigator

ETL tools: Informatica Power Center 8.0

Operating Systems: Windows 95/98/NT/2000/2003/XP, Unix and MS-DOS

Programming skills: C, SQL, PL/SQL, HTML

Databases: Oracle 11g/10g/9i/8i, SQL Server 2005/2000, MS Access, DB2, IDMS and Teradata.

PROFESSIONAL EXPERIENCE

Confidential, Dublin, OH

Sr Cognos Developer

Responsibilities:

• Identify business needs and prospects and document teh business requirements.
• Developed Metadata Models and DMR models using Framework Manager, published new packages and made changes to teh already existing packages.
• Created IQDs by externalizing teh Query Subjects in Framework Manager and Implemented teh Security atdata, object and package levelin Framework Manager.
• Involved in building Transformer Cubes using IQDs and Packages as data sources.
• Experience in building complex reports, Developed Multi-page reports, List reports, Charts, Drill through and Master-detail reports using Report Studio.
• Customized data by adding teh Prompts, Filters, Calculations, Summaries, Functions, Conditional formatting and Conditional Page layouts.
• Developed several Dashboards wif drill-downs to various detail reports.
• Worked on conversions and enhancements of existing reports.
• Created reports in Analysis Studio using cubes and DMR models.
• Involved in Upgradation of models and reports from cognos 8.3 to cognos 10.1.1.
• Created and regenerated materialized views to optimize performance.
• Developed Stored Procedures and created Stored Procedure Query Subjects in Framework manager to enhance Report Performance.
• Involved in testing and validation of report data against teh database to measure performance using Toad & SQL Developer.
• Scheduled, refreshed and bursted teh Reports according to user requirements inCognosconnection and distributed them through email.
• Documented various test cases of teh reports.
• Resolved issues resulting User Acceptance Testing (UAT).

Environment: Cognos 10.1.1, Cognos 8.3 Bi Suite (Framework Manager, Transformer, Cognos Connection, Query Studio, Report Studio, Metric Studio and Event Studio), Unix, Oracle 11g, SQL Server 2008, Toad, SQL Developer.

Confidential, Durham, NC

Senior Cognos Developer

Responsibilities:

• Involved in gathering teh business requirements from teh Users and documenting it for reporting needs.
• Research on collected business requirements and translate business requirements into system specifications and develop reports as per teh client requirements.
• Building models in IBM Cognos Framework Manager (Database Layer, Logical Layer, Presentation Layer) and publishing packages.
• Created Data Level, Object level, Package level and Row level Securities in Framework Manager Models.
• Developed Multi-page reports, List reports, Charts, Drill through and Master-detail reports using Report Studio.
• Created various Prompts, Filters, and Calculations and used Conditional Formatting as per teh requirement.
• Worked on Data Analysis, Validate reports and find data quality issues.
• Scheduled teh reports in Cognos Connection and distributed them via mail.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• To maintain numerous pre-existing reports and a fully functional multi user Portal Dashboard.
• Built multi-dimensional reports using Analysis Studio.
• Involved in building OLAP Transformer Cubes using multiple data sources like IQD's, Packages and Reports.
• Publishing Cubes and Packages for teh web users.
• Customizing user class security views in Cube by user classes / Roles.
• Created Technical design document for Report studio reports based on Functional specifications.
• Created and performed teh Unit and Integrity test cases and assisted teh testing team in System Test and Production move process.
• Performance tuning by analyzing and comparing teh turnaround times between SQL and Cognos.
• Provided teh documentation and tutored teh End Users how to use Different types of studios.
• Performed Data validations, Unit testing and preparation of Unit test cases.
• Troubleshoot Cognos Server Environment for teh better performance.

Environment: Cognos 10.1, Cognos 8.4 Bi Suite (Framework Manager, Transformer, Cognos Connection, Query Studio, Report Studio, Metric Studio and Event Studio), Oracle 10g, Teradata, Toad, Windows 2003 Server.

Confidential, Boston, MA

Senior Cognos Developer

Responsibilities:

• Direct Interaction wif customers and responsible for Business analysis and Requirements collection.
• Created Business Requirements and High-level design documents.
• Built Framework Manager Model, and established teh cardinalities to suit teh business needs.
• Developed and Published Packages in Framework Manager - Connecting and testing teh data source, creating database layer and presentation layer, defining appropriate relationships between query subjects.
• Created Dimensional models from relational data source in Framework Manager to publish packages to be used in Analysis Studio.
• Created, refreshed and supported Cognos Transformer OLAP models and Power Play cubes.
• Implemented security for Data access, Object level access and Package access.
• Developed Dash Board reports from Cube data source in Report Studio using MDX Functions.
• Developed Reports using Conditional Formatting, Cascading Prompts and Report Bursting.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases.
• Created User Groups, Roles to implement teh Cognos Security, using Directory Server.
• Worked on Analysis Studio to develop multi dimensional reporting.
• Modified teh existing reports, based upon teh change request by teh user.
• Opened many cases wif IBM Cognos Support Team to resolve teh issues.
• Involved in Performance Tuning using Materialized Views (using query re-write).
• Resolving teh Performance issues of teh Reports.
• Deployment of reports from Development to Test and Production Environments.

Environment: Cognos 8.4 (Report Studio, Framework Manager, Query studio, Cognos Connection, Transformers, Metric Studio, Analysis Studio), Unix, SQL Server 2005, Oracle 10g, SQL Server Management Studio, Toad, MS access.

Confidential, New York City, NY

Cognos Developer

Responsibilities:

• Met wif business users to better understand teh business rules.
• Coordinated wif Data Architects to implement teh system design.
• Created Various Models and Packages using Framework Manager and published to ReportNet Server.
• Developed advanced reports using Report Studio and adhoc reports using Query Studio.
• Created various reports like List, Cross tab, Drill Through, Summary Details, link, Charts etc.
• Scheduled various reports using teh Schedule Management feature wifin Cognos Connection.
• Deployed teh reports to different environments using teh Deployment Management tool.
• Implemented security using Access Manager.
• Created and modified Catalogs.
• Developed and Customized Impromptu Reports.
• Customized data by adding Filters Prompts, Calculations, Summaries and Functions.
• Created Multi-Dimensional reports using Power Play.
• Created Power Play Models and Cubes using Transformer (Power Play).
• Worked on drill down, slice and dice and change displays.
• Created daily, weekly, monthly and quarterly reports for teh management team.
• Used Power Play Enterprise Server to publish Power Play reports to teh web.

Environment: Cognos 8.2/ 8.3 BI Suite (Report Studio, Query Studio, Cognos Connection, Framework Manager, Event Studio, Analysis Studio), Content Manager, Oracle 9i, DB2, SQL, PL/SQL, Windows XP, JavaScript, HTML.

Confidential, Warren, NJ

Cognos Developer

Responsibilities:

• Worked on Cognos 8.1 framework manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos 8 server.
• Implemented Security wif LDAP and Group level security in Cognos Connection Portal.
• Developed Standard Reports, List, Cross tab, Charts, Drill-through Reports, Master Detail Reports, using Report Studio and Query Studio.
• Created query prompts, calculations, conditions and filters in Report Studio.
• Developing prompt pages and conditional variables using Report Studio.
• Experience wif conditional blocks and conditional layouts.
• Upgraded teh existing Cognos Report Net 1.1 MR2 Models and Packages to Cognos 8 BI environment.
• Converted teh existing Report Net 1.1 reports to Cognos 8 BI reports.
• Involved in deployment of applications to production.
• Troubleshoot teh errors during teh upgrade process.

Environment: Cognos 8.0/8.1 (Framework Manager, Cognos Connection, Report Studio, Query Studio, Event Studio, Transformer), Oracle 9i and SQL Server 2005, HTML, Windows 2003.

Confidential, New York, NY

Cognos Developer

Responsibilities:

• Created new Catalogs for reporting using teh Cognos Impromptu.
• Created catalogs from multiple data bases using hot files.
• Customized data by adding Calculations, Filters, Prompts and Governor Settings.
• Created time-based reports using Cognos Impromptu and Cognos Power Play.
• Distributed copies of data using Local snapshots, Remote snapshots, Thumbnails and Hot files to improve report performance.
• Created drill through reports, sub reports, list reports etc.
• Developed Models based on teh dimensions, levels and measures required for analysis.
• Involved in design, development and maintenance of Catalogs.
• Developed Power Play Excel Reports (PPX Reports) and published them using upfront.
• Published Impromptu reports on Impromptu Web Server (IWR).
• Worked wif users to deliver reports using Impromptu Scheduler.

Environment: Cognos ReportNet 1.1, Framework Manager, Cognos Impromptu 7.2, Cognos IWR, Power Play Transformer, Power Play Windows, Power Play Enterprise Server, Access Manager, Upfront, Cognos Scripts, Impromptu Scheduler, Oracle 9i and Windows 2000.

Confidential

Cognos Developer

Responsibilities:

• Created List Reports, Cross Tab Reports and Drill Through reports.
• Developed Impromptu Web Reports (IWR) and published them into Upfront.
• Created Impromptu Reports and published them to teh PPES server.
• Created users, roles and privileges on teh Oracle databases.
• Created and configured database for development and production environments in SQL Server.
• Developed SQL Scripts in Oracle to validate data quality.
• Developed stored procedures and database triggers using PL/SQL.
• Participated in unit testing and system testing.

Environment: Cognos EP Series 7 (Impromptu, Power play, Transformer), Cognos ReportNet1.1( Framework Manager, Report Studio, Query Studio), Oracle 8i, SQL Server 2000, UNIX, PL/SQL.