SUMMARY

• Eight years of experience in analysis, design and development of Business Intelligence solutions using Cognos products.
• Excellent proficiency in the usage of Cognos tools such as Cognos 10.2.1, Cognos 8, ReportNet, PowerPlay, Transformer, Power Play Enterprise Server PPES and Upfront.
• Proficient in developing reporting applications employing Cognos 10, Cognos 8 ReportNet components like Framework Manager, Report Studio, Query Studio, and Cognos Connection.
• Experienced in designing, developing and maintaining Impromptu Power Play reports.
• Experienced in building multidimensional models and creating Power Cubes for distribution using PowerPlay Transformer.
• Strong understanding of dimensional modeling concepts like Star schema Snowflake schema.
• Proficient in all aspects of SDLC from requirements capture through system testing.
• Ability to learn very quickly and apply new skills to existing problems.
• Excellent communication skills and very good at working in a group.

SKILLS

BI Tools Cognos 10.2.1, Cognos 10.1, Cognos 8.4, Cognos 8.3, Cognos 8.2, Cognos 8.1,

Cognos ReportNet 1.1, Cognos Impromptu 7.x, Cognos PowerPlay 7.x, Cognos

PowerPlay Transformer 7.x, Power Play Enterprise Server 7.x, Impromptu Web

Reports IWR 7.x, Upfront 7.x, Cognos Scheduler, Access Manager

Databases Oracle 8i/9i/10g/11i, SQL Server 2000/2005, DB2, MS Access

Languages C , PHP, HTML, DHTML, JavaScript, ASP, PL/SQL

OS Windows NT/2000/XP/7

EXPERIENCE

Confidential

• Excellus BlueCross BlueShield is part of a family of companies that finances and delivers health care services to about 1.6 million members across upstate New York. I was involved in the Employer Group Reporting project which was undertaken by Excellus BCBS to modify the existing reports as per the new requirements of the Client Consulting team.
• Redesigned the existing Employer Group Reports to use the new Datawarehouse that was developed.
• Added various Report Studio features like page sets, conditional formatting and conditional page rendering to the reports.
• Added Value, Date, Textbox and Select Search prompts to the prompt pages as per the user requirements.
• Fixed the performance issues in the developed reports.
• Worked with the Client Consulting team to resolve data discordance issues in the developed reports.
• Created agents in Event Studio to execute and email reports based on the occurrence of events mentioned in the agent.

Environment: Cognos 10.2.1, Report Studio, Event Studio, Cognos Connection, Oracle 12c, PL/SQL Developer, Windows 7.

Confidential

• Boston Medical Center HealthNet Plan is a managed care organization sponsored by Boston Medical Center that serves members of the Commonwealth's MassHealth Medicaid programs.
• Analyzed the specifications provided by the business users to define reporting requirements.
• Wrote the technical specifications for the reports that needed to be developed.
• Wrote stored procedures on SQL Server 2005 and used them to create query subjects in Framework Manager.
• Designed and developed Framework Manager models using stored procedures and relational tables and published packages to Cognos Connection.
• Created standard list reports, crosstab reports, master-detail and drill-through reports in Report Studio.

Environment: Cognos 10.1, Cognos 8.4, Report Studio, Framework Manager, Cognos Connection, SQL Server 2005, Windows 2003/XP.

Confidential

• Developed 39 complex List reports using Report Studio Cognos 8.3 for multifarious business areas like Accounting, Appeals, Claims, Commissions, Customer Service, and Recoveries.
• Composed complex SQL queries in Framework Manager which were then used as the basis for canned reports that were developed using Report Studio.
• Worked with the business analyst to improve the performance of reports that were taking an inordinate amount of time to execute.
• Created stand alone calculations filters for Query Studio users.
• Created a parameter map to allow users to choose a database to run the report against, at the time of report execution.
• Used JavaScript in the prompt pages to prevent users from entering invalid data in the prompts by displaying alert boxes prompting them to modify their input.

Environment: Cognos 8.3, Report Studio, Query Studio, Framework Manager, Cognos Connection, Oracle 10g, JavaScript, Oracle SQL Developer, Windows 2000/2003.

Confidential

• Blue Shield with reports needed to study the performance of their Disease Management programs.
• I worked on the Disease Management Reporting project which was implemented to provide Blue Cross
• Developed list crosstab reports using Report Studio Cognos 8.3 to report on the member participation for various DM programs, billing data for various vendors, current activity for DM programs vendors.
• Worked with the data modeler to design a star schema data model for the reporting database to meet the requirements of query studio users.
• Imported metadata from ERwin data modeler Oracle 9i into framework manager to create the data model and published the package to Cognos Connection to enable report development.
• Implemented role-based security to enable only users with the necessary privileges to access sensitive personal information about BCBS members.
• Used JavaScript in the prompt pages to prevent users from entering future dates in the date prompts for the canned reports.
• Supported Query Studio users during the UAT phase of the project.
• Used the deployment tool in Cognos Connection to move reports packages from development environment to UAT environment.

Environment/Tools: Cognos 8.3, Report Studio, Query Studio, Framework Manager, Cognos Connection, Oracle 9i, DB2 version 9.1, JavaScript, ERwin Data Modeler, Toad, Oracle SQL Developer, WinSQL, Windows 2000/2003.

Confidential

• Used Report Studio Cognos 8.1 ReportNet extensively to develop list, crosstab and drill-through reports to fulfill the reporting needs of the marketing analytics team.
• Created prompt pages with different kinds of prompts and used complex calculations, conditional formatting and conditional blocks in the Report Studio reports that were developed.
• Migrated 19 report studio reports from ReportNet 1.1 to Cognos 8.1 using the deployment tool in Cognos Connection and fixed the bugs in the reports caused as a result of the migration.
• Created data models using Framework Manager and published packages to Cognos Connection to support the development of canned reports and to enable query studio users to perform ad-hoc querying.
• Created Impromptu catalogs and Impromptu reports using Impromptu Administrator and published these reports to Cognos Upfront.
• Worked closely with the DBA to optimize the queries for reports that were performing poorly.

• Identified various dimensions and measures required for the generation of a cube for reporting requirements in PowerPlay Transformer.
• Used PowerPlay for building reports that met business requirements.
• Involved in building multidimensional cubes using Cognos PowerPlay Transformer and setting the category levels that can be effectively used in analyzing the data in PowerPlay reports for decision making.
• Published Power Cubes on Upfront using Cognos PowerPlay Enterprise Server.

Environment/Tools: Cognos 8.1, Cognos ReportNet 1.1 MR2, Report Studio, Query Studio, Event Studio, Framework Manager, Cognos Configuration, Cognos Connection, Cognos Impromptu 7.1, Impromptu Web Reports 7.1 IWR , Cognos Upfront 7.1, Cognos PowerPlay 7.3, PowerPlay Transformer 7.3, Cognos Upfront 7.3, PowerPlay Enterprise Server 7.3, PL/SQL Developer, Oracle 10g, JavaScript, Windows 2000/2003.