Swagatika Kar

Cognos Consultant

Looking for Projects only in NY/NJ Locations

Email: acdde0@r.postjobfree.com

Direct Number: 786-***-****

• 6 years of Strong design/development experience with Business Intelligence solutions, Data

Warehousing.

• Strong development knowledge of Cognos environment and tools IBM Cognos8BI/Cognos 10 BI

(Framework Manager, Report Studio, Query Studio, Analysis Studio)

Expertise with Framework Manager Modeling (Physical Layer, Business Layer, Packages) and

•

Complex Report building with Report Studio.

Work experience in implementing security (both data level and package level) in Framework

•

Manager

Experience in building reports containing Crosstab, List, Charts and Repeaters using Cognos

•

Studios.

Extensive experience on transformer models for corporate data for building multidimensional

•

cubes.

Profound knowledge in transformer model design and Power play cube building.

•

Experience developing complex reports using drill through, prompts, master detail, burst

•

options, dynamic filtering, etc., in Cognos.

Extensively worked on Conditional Formatting of reports using conditional styles, Render

•

variables and Conditional variables.

Developed Complex dashboard reports for various reporting requirements.

•

Strong understanding of Dimensional Modeling concepts and have experience in dimensional

•

modeling using Star and Snow Flake Schemas.

Involved as an onsite coordinator between Client and Offshore team.

•

Involved in Installation, Configuration of various windows environment.

•

Created Metrics and Scorecards in Metrics studio.

•

Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8.X Environment.

•

Work experience on Data Warehouse Concepts and ETL Tools like Informatics, Data stage. And

•

Knowledge in ERP modules likes SAP.

Involved in Extraction, Transformation, and Loading (ETL) solutions using Informatics.

•

Experienced with multiple relational databases, Sql Server, Oracle 11g/10g/9i/8i and DB2.

•

Hands on experience in analysis and report design documents, report layout, development,

•

testing of reports.

Excellent written and verbal communication skills and expertise in working with clients and

•

functional teams

Skills

IBM Cognos 8.X/10.BI(Framework Manager, Report Studio, Query Studio,

Analysis Studio, Event Studio, PowerPlay Studio, Framework Manager,

BI Tools Transformer, Cognos Connection,), Report Net 1.0/1.1,COGNOS Series 7.X .

Oracle 9i,Oracle 11G,SQL Server 2000/2005/2008,MS Access 97/00/XP/03

Databases

IIS, Apache, Web Sphere

Web/App Servers

SQL, C, C++, Java, J Script and HTML

Programming Languages

MS Excel, MS Word, MS Visio, MS Project and MS PowerPoint Studio,

Microsoft Tools

Windows NT4.x/9X/2000/XP

Operating System

Netezza

Training

EDUCATION:

Bachelors in Computer science and Engineering.

Professional Experience:

John Wiley and Sons, NJ Feb‘12 – Till date

Cognos Developer

Description: John Wiley is one of world's largest content and service providers with a broad range of

content which include scientific, technical and medical journals, books and online products and Services;

professional and consumer books and subscription services; and educational materials for students and

lifelong learners. Usage reporting project and Sales reporting project was initiated to enable the users to

access the usage data for decision making.

The main goal of these project were to create Usage and Sales reports,Dashboards, Cubes and developing

Report studio reports and Power Play reports using Cognos 8.4/10.1

Responsibilities:

• Extensively involved in creating List report, Crosstab Reports, Chart reports, Master Detail

reports, Drill through reports.

• Created and published Packages using Framework Manager.

• Involved in Cognos reports and Cognos PowerPlay cubes development and support.

• Effectively implemented complex reporting requirements like list report comprising cell by cell

calculations.

Creating complex reports using Report Studio (Drill thru, Grouped List, Chart, Crosstab,

•

Conditional Formatting etc.)

Created custom templates, interactive and user friendly reports using development techniques like

•

conditional blocks, conditional variables, colors to indicate reporting metric performance and

drilling capability.

Applying Security and User Authentication to the various User Groups.

•

Efficiently created and managed/updated all documents on the project – Technical documents,

•

reporting standards, unit test cases, Common error and resolutions, migration and deployment

related Docs Etc.

Scheduled reports and with different output formats.

•

Created new jobs using Cognos Connection.

•

Created reusable report templates, report headers, footers with custom messages.

•

Documenting the whole process flow.

•

Performed detailed Unit testing provided and guided the QA team in QA process and documented

•

the same.

Modified reports based on the feedback from QA testers and Users in development and staging

•

environments, performed regression testing.

Environment: COGNOS 10.1/8.4 (Report Studio, Query Studio, Analysis Studio, Power Play Studio,

Transformer), Microsoft SQL Server 2008, Windows XP/2003

Barr Pharmaceuticals Inc, Mar’10 – Jan’ 12

Cognos Developer

Description: Barr Pharmaceuticals, Inc. is engaged in the development, manufacture and marketing of

generic and proprietary pharmaceuticals. Barr has manufacturing, warehouse, and administrative facilities

in Cincinnati

Responsibilities:

• Involved in Environment readiness for the upgrade process.

• Coordinated with the business users and the development team understanding and prioritizing the

reports for upgrade/migration

• Was responsible for migrating the reports as per the schedule and monitoring the reports post

migration.

• Reporting the progress and rolling over and sharing the outcomes / results while suggesting the

appropriate fix for the reports failed in the migration.

• Used Report Studio and created complex lists, cross tab, chart reports and generated different report

outputs which include Excel, PDF, and HTML.

• Creating page breaks and Created complex reports using conditional formatting.

• Changed Filters, Exception Highlighting and Sorting.

• Developed various Reports using report studio, created ad hoc queries using query studio

• Created package roles, users to provide security to the report net packages

• Performed necessary analysis and evaluation to fully understand the technical strategies for projects.

• Developed Metadata Models using Framework manager.

• Created Packages in Framework Manger and published them on Cognos connection.

• Involved in Cognos Impromptu reports migration and Cognos PowerPlay cubes

Environment: COGNOS 10.1/8.4, Framework Manager, Report Studio, Analysis Studio, Query Studio,

ORACLE.

Galderma Laboratories, Dallas, TX Mar’09 Feb’10

Cognos Consultant

Description: Galderma is unique in pharmaceutical industry, as it has chosen to focus in Dermatology.

Galderma will contribute to the treatment of dermatological diseases and conditions by developing and

marketing products to meet the needs of dermatologist and the patients. The Galderma learning

management system provides a single system for administering, reporting and recording the training status

of all employees. This project involves in developing suitable models, packages, OLAP Cubes and complex

reports using Cognos BI products. The models will utilize actuarial practice and methodology for historical

data analysis as well as forecasting.

Responsibilities:

Analyzed requirement Specification document and preparing the Specification document as per the

•

Business requirement.

Created the Dash board reports using the Cognos Report Studio which helps the user to analyze the

•

Specialty Care data.

Created the different types of reports like Service availability, Average waiting days and different

•

utilization reports as per the business requirements.

Built metadata models, modified, and published several packages using Framework Manager according

•

to the business needs which can be used by Report Developers and the business users

Developing Dash Board reports in Report Studio.

•

Creating the Report Studio reports using the Cube as a data source.

•

Creating the Bar charts and list and cross tab reports using Cognos Report Studio and Analysis studio.

•

Applied Security in Cognos Connection by controlling privileges for users, groups and roles to the

•

various packages, reports & dashboards.

Deploying the reports and package from Development to testing, Testing to Production environments.

•

Estimating the time lines for the reports and Framework Manager Models.

•

Issue tracking and set up the meetings on weekly basis.

•

Unit testing, Integration testing and system testing of the reports in Development, Performance and

•

production environments.

Involved in Designing and creating various models and Publishing packages in Framework

•

Manager.

Created Complex, multipage reports involving prompts, Cascading prompts, Conditional rendering

•

and Conditional formatting.

Created custom prompted reports in Report Studio, Bursting reports to different user groups.

•

Tested and validated the report output against the database to measure performance of reports.

•

Environment: Cognos 8.3 (Framework Manager, Query Studio, Report Studio, Analysis Studio,

Transformer), SQL Server, Windows XP/2003, HP UNIX

Zieta Technology, India Jan 08 Feb’ 09

SAP ABAP / Cognos Developer

Description: In Scandia project I have done the SAP implementation using SAP ABAP and also developed

Cognos report net reports.

Responsibilities:

Developing SAP reports, designing smart forms etc.

•

Expertise in Smart forms, Module pulls programming, SAP Scripts.

•

Work closely with business analyst teams to understand the functional specifications for supporting

•

and enhancing SAP environment.

Provide business analyst with options for potential solutions to business needs.

•

Works with the business analysts to estimate effort, develop test plans, and test developed solutions.

•

Continuously review the Cognos application and suggest changes for improved performance.

•

Involved in developing SQL Scripts to validate the Reports data and UAT.

•

Provided support to fix Cognos report performance issues such as slower prompt pages, User

•

Interface redesign, SQL performance tuning etc.

Attend the project meetings, Reviews and Walk through for requirements, design and test plans.

•

Environment: SAP ABAP, Cognos Report Net (Framework Manager, Query Studio, Report Studio,),

My Sql

Contact this candidate