- ------------------------------------------------------------------------------------------------------------------------------

Summary of Experience:

• Over 19 years of experience in IT Industry with experience in analysis, design, testing, development, and implementation of client server applications of which around 17 years of experience on Cognos 10/8.4, Report Net, Impromptu, Powerplay, Sever Administration and Informatica 9.1/8.6/7.2/6.1/5.1 4.7 .
• Designing of Data mart using ERwin Star schema/snowflake methodology.
• Extensively worked on Publishing of Impromptu Web Reports IWR, Analysis Studio, Power Play Cubes and Report Net Reports.
• Expert in windows server administration and active directory Severs.
• Design and development of OLAP models for Data warehousing.
• Expertise in ETL process using Informatica.
• Created and Monitored Batches/workflows and Sessions/Tasks using Informatica Power Center Server/ Workflow Manager.

Skillset:

• Cognos 10.2.1/8.4 BI Analysis Studio Power Play
• Cognos Access Manager Cognos Server Administration Cognos Workspace
• Repository Manager Workflow Manager Workflow Monitor
• Designer Source Analyzer Mapping Designer
• Informatica - Power Center 9.5.1/8.6 ERwin PL/SQL
• Oracle 10g/9i/8i SQL Server DB2/UDB
• Windows NT OWB Cognos Visualizer
• VB Teradata AS400
• UNIX Shell Script Progress V 8 7 TOAD/QUEST

Professional Experience:

Confidential

Cognos BI Analyst

Responsibilities:

• Used Transformer with a variety of sources and combines them into Multi-Dimensional Cube.
• Published Cubes and Reports to Cognos Connection through Framework Manager and used Analysis Studio to view the cubes.
• Created Cognos Framework model and Cognos reports using Teradata.
• Extracted data from Teradata using Teradata utilities to DB2 using Informatica.
• Created Dashboard Reports in Report Studio to present data graphically.
• Expert in windows server administration and active directory servers.
• Business Data Analysis, Design, Development of Multidimensional OLAP Cubes, deployment and provided drill-through targets to another Cube, Power Play Reports, Report Net reports.
• Scheduled the Reports on Cognos Connection.
• Deployed multiple ReportNet Reports from one environment to another.
• Developed List, Crosstab, Chart, Section and Drill Through Reports in Report Studio.
• Development of filters, calculations, prompts, conditions, and created various reports, Created Value Prompts and Text Prompts to filter the Data Cognos Report Studio.
• Held meetings with business analyst to review/understand business requirements before development.
• Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Preparation of Unit Test plans and Unit testing of COGNOS Reports.
• Provided technical assistance, training and mentoring to Users and Business Partners.
• Written Macros and Batch files for automating tasks and Job Scheduling.
• Involved Designed, developed most efficient Reporting Solutions with improved performance and best practices.
• Designed, developed and implemented efficient Cognos FM models, Power Play Transformer models and reusable report templates.
• Working closely with Product leadership team and User groups to understand the business needs and source systems to design and implement better report architecture solutions.
• Documented the architecture/technical Designs and roadmaps.
• Act as a primary subject matter expert and given technical directions to team members to develop the better and efficient bug free reporting solution.
• Building models and publishing packages in Framework Manager to the Cognos Connection server.
• Worked extensively with all Informatica Designer tools including Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer

Environment: Environment: COGNOS 10.2.1 Suite Framework Manager, Report Studio, Query Studio, Analysis Studio and Cognos Connection, PowerPlay Transformer, Access Manager, DB2, Teradata, MS SQL Server 2005, Windows Batch Programming and Windows XP Professional , Erwin, Repository Manager, Designer, Workflow Manager, Workflow Monitor. ERP, UNIX, Flat Files and App Works.

Confidential

Responsibilities:

• Interacted with Business Users for gathering Business Requirements to develop the reports.
• Developed Dashboards which consisted of charts, graphs, Standard Reports, list, cross tab, charts, drill-through Reports by using Report Studio, Query Studio and also delivered reports in different formats like PDF, XML, HTML and CSV.
• Implemented Data/row level security to cognos packages.
• Applied dynamic sorting on column headers asc and desc.

Environment: Cognos10 BI Suite, Framework Manager, Cognos Connection, Reports Studio, Query Studio, Analysis Studio, Business Insight Advanced, BIRT, Cognos Transformer, SQL Server, SQL Assistant.

Confidential

Responsibilities:

• Interacted with Business Users for gathering Business Requirements to develop the reports.
• Generated packages in Framework Manager and published them to be used in creating reports in Cognos studios.
• Developed Dashboards which consisted of Standard Reports, list, cross tab, charts, drill-through Reports by using Report Studio, Query Studio and also delivered reports in different formats like PDF, XML, HTML and CSV.
• Designed reports using slicers to filter dimensional data.
• Published reports in Cognos connection and implemented security to grant access to business group.
• Scheduling and Distributing Reports through Scheduler in Cognos Connection.
• Applied dynamic sorting on column headers asc and desc.

Environment: Cognos10 BI Suite Framework Manager, Cognos Connection, Reports Studio, Query Studio, Analysis Studio, Business Insight Advanced, Cognos Transformer, Teradata, SQL Assistant, Cognos Administration.

Confidential

Responsibilities:

• Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Held meetings with business analyst to review/understand business requirements before development.
• Designed, developed most efficient Reporting Solutions with improved performance and best practices.
• Created User Classes in Access Manager, applied data level, Query Subject level security in Cognos FM Model.
• Migrated Reports from one environment to another environment Dev to QA and QA to PROD .
• Designed, developed and implemented efficient Cognos FM models, Power Play Transformer models and reusable report templates.
• Working closely with Product leadership team and User groups to understand the business needs and source systems to design and implement better report architecture solutions.
• Documented the architecture/technical Designs and roadmaps.
• Expert in windows server administration and active directory servers.
• Act as a primary subject matter expert and given technical directions to team members to develop the better and efficient bug free reporting solution.
• Building models and publishing packages in Framework Manager to the ReportNet server.
• Development of filters, calculations, prompts, conditions, and created various reports, using Cognos Report Studio.
• Responsible for the delivery of solution-oriented complex reports using Cognos Report Studio.
• Development of ad-hoc reporting interfaces using Cognos Query Studio.
• Business Data Analysis, Design, Development of Multidimensional OLAP Cubes, deployment and provided drill-through targets to another Cube, Power Play Reports, Report Net reports.
• Created Dashboard Reports in Report Studio to present data graphically.
• Published Cubes and Reports to Cognos Connection through Framework Manager and used Analysis Studio to view the cubes.
• Used Transformer with a variety of sources and combines them into Multi-Dimensional Cube.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Preparation of Unit Test plans and Unit testing of COGNOS Reports.
• Provided technical assistance, training and mentoring to Users and Business Partners.
• Written Macros and Batch files for automating tasks and Job Scheduling.
• Involved in migration from ReportNet to Cognos 8 and upgraded from Cognos 8.1 to 8.4.
• Worked extensively with all Informatica Designer tools including Source Analyzer, Warehouse Designer, Mapping Designer and Transformations.
• Manage the Informatica Server Workflows and Tasks and schedule them.
• Created and Monitored Workflows and Tasks using Informatica Workflow Manager.
• Testing and validating the data on target data system.
• Created various mappings using Designer include Source Qualifier, Expression, Aggregator, Look up Transformations.
• Extracted the data from ERP, OSS, Oracle, Files into Data warehouse.

Environment: COGNOS 10/8.4 Suite Framework Manager, Report Studio, Query Studio, Analysis Studio and Cognos Connection, PowerPlay Transformer, DQM,Access Manager, Erwin, Repository Manager, Designer, Workflow Manager, Workflow Monitor, Oracle 10g, OWB, TOAD, ERP, UNIX, Flat Files and App Works.

Confidential

Responsibilities:

• Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Held meetings with business analyst to review/understand business requirements before development.
• Development of filters, calculations, prompts, conditions, and created various reports, Created Value Prompts and Text Prompts to filter the Data Cognos Report Studio.
• Developed List, Crosstab, Chart, Section and Drill Through Reports in Report Studio.
• Deployed multiple ReportNet Reports from one environment to another.
• Scheduled the Reports on Cognos Connection.
• Business Data Analysis, Design, Development of Multidimensional OLAP Cubes, deployment and provided drill-through targets to another Cube, Power Play Reports, Report Net reports.
• Expert in windows server administration and active directory servers.
• Created Dashboard Reports in Report Studio to present data graphically.
• Published Cubes and Reports to Cognos Connection through Framework Manager and used Analysis Studio to view the cubes.
• Used Transformer with a variety of sources and combines them into Multi-Dimensional Cube.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Preparation of Unit Test plans and Unit testing of COGNOS Reports.
• Provided technical assistance, training and mentoring to Users and Business Partners.
• Written Macros and Batch files for automating tasks and Job Scheduling.
• Involved in migration from ReportNet to Cognos 8.
• Designed, developed most efficient Reporting Solutions with improved performance and best practices.
• Designed, developed and implemented efficient Cognos FM models, Power Play Transformer models and reusable report templates.
• Working closely with Product leadership team and User groups to understand the business needs and source systems to design and implement better report architecture solutions.
• Documented the architecture/technical Designs and roadmaps.
• Act as a primary subject matter expert and given technical directions to team members to develop the better and efficient bug free reporting solution.
• Building models and publishing packages in Framework Manager to the ReportNet server.
• Worked extensively with all Informatica Designer tools including Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer

Environment: Environment: COGNOS 8.4 Suite Framework Manager, Report Studio, Query Studio, Analysis Studio and Cognos Connection, PowerPlay Transformer, Access Manager, Oracle 10g, MS SQL Server 2005, Windows Batch Programming and Windows XP Professional , Erwin, Repository Manager, Designer, Workflow Manager, Workflow Monitor., Oracle, OWB,TOAD, ERP, UNIX, Flat Files and App Works.

Confidential

• Created various mappings using Designer include Source Qualifier, Expression, Aggregator, Stored Procedure, Look up Transformations.
• Extracted the data from Oracle, Files, and Access into Data warehouse.
• Performed data manipulation using Informatica transformations.
• Wrote PL/SQL procedures replaced by Informatica mappings to improve warehouse loading.
• Developed Mappings/ Transformations by using mapping designer and transformation developer in Informatica Power Center.
• Workflow Manager used for creating and maintaining the Sessions. Workflow Manger also used to Monitor, edit, schedule, copy, abort and delete the session.
• Setting up workflows and Tasks to schedule the loads at required frequency using Power Center Workflow manager.
• Performed Developer testing, Functional testing, Unit testing for the mappings.
• Analyzed the requirements and framed the business logic for the ETL process.
• Developed Unix shell scripts to execute the workflows.

Environment: Erwin, Repository Manager, Designer, Workflow Manager, Workflow Monitor.

Confidential

• Gathered and analyzed User requirements and the reporting issues from Business analyst.
• Created packages from the data source using Framework Manager.
• Developed CPF files on Cognos connection using the Frame Work Manager.
• Developed Advanced Reports in Cognos Report Studio.
• Developed Cross tab reports and applied advanced filters using Analysis Studio.
• Burst the report to the Network location using Report Studio.
• Created Cascading prompts using Report Studio.
• Created the various business reports - List Reports, Form Reports Cross-tab Report and Drill through Reports.
• Created multi dimensional cubes using Transformer.
• Developed all the required cubes and Drill Through cubes for the project.
• Interacted with Cognos Administration team to schedule the Cubes.
• Workflow Manager used for creating and maintaining the Sessions. Workflow Manger also used to Monitor, edit, schedule, copy, abort and delete the session.
• Developed Mappings/ Transformations by using mapping designer and transformation developer in Informatica Power Center.
• Wrote PL/SQL procedures replaced by Informatica mappings to improve warehouse loading.
• Performed data manipulation using Informatica transformations.
• Extracted the data from Oracle, Files, and Access into Data warehouse.
• Created various mappings using Designer include Source Qualifier, Expression, Aggregator, Stored Procedure, Look up Transformations.
• Created documentation to assist the end-user.
• Deployed multiple Report Net Reports from one environment to another.
• Validated the results of data on ReportNet reports as well as Cognos Cubes using Quest Central for DB2.
• Developed the Drill Through reports from Cubes to ReportNet for detail data.
• Developed cubes in Power Play, published on Cognos Connection.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Performed Developer testing, Functional testing, Unit testing for the mappings.
• Analyzed the requirements and framed the business logic for the ETL process.

Environment: Cognos 8 BI, Analysis Studio, Cognos Connection, Cognos Power Play, Power Play Enterprise Server, Framework Manager, Query Studio, Report Studio, Cognos Access Manager, with DB2,Quest. Cognos Report Net, Erwin, Repository Manager, Designer, Workflow Manager, Workflow Monitor.

Confidential

Responsibilities:

• Interacted with Business users to collect the Reporting Requirements.
• Prepared prototypes and got approvals from the from business owners.
• Created/enhanced catalogs and set User profiles to grant user permissions for querying.
• Create Joins between the tables and Shortcuts.
• Developed all the required cubes and Drill Through cubes for the project.
• Developed Business Reports and Cycle time Metrics.
• Created User Classes in Access Manager.
• Created Value Prompts and Text Prompts to filter the Data Cognos Report Studio.
• Developed List, Crosstab, Chart, Section and Drill Through Reports in Report Studio.
• Deployed multiple ReportNet Reports from one environment to another.
• Scheduled the Reports on Cognos Connection.
• Created various mappings using Designer include Source Qualifier, Expression, Aggregator, Stored Procedure, Look up Transformations.
• Extracted the data from Oracle, Files, and Access into Data warehouse.
• Performed data manipulation using Informatica transformations.
• Wrote PL/SQL procedures replaced by Informatica mappings to improve warehouse loading.
• Developed Mappings/ Transformations by using mapping designer and transformation developer in Informatica Power Center.
• Workflow Manager used for creating and maintaining the Sessions. Workflow Manger also used to Monitor, edit, schedule, copy, abort and delete the session.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Performed Developer testing, Functional testing, Unit testing for the mappings.
• Analyzed the requirements and framed the business logic for the ETL process

Environment: Cognos Power Play, Power Play Enterprise Server, Framework Manager, Query Studio, Report Studio, Cognos Access Manager, Cognos Upfront, with Oracle 9i,TOAD, Teradata, Cognos Report Net V1.1, Erwin, Repository Manager, Designer, Workflow Manager, Workflow Monitor.

Confidential

Responsibilities:

• Developed Master Detailed Reports in Cognos Report Studio.
• Developed Drill through Reports in Cognos Report Studio.
• Developed Advanced Reports in Cognos Report Studio.
• Developed Ad-hoc reports in Cognos Query Studio.
• Published Packages on Cognos Connection using Frame Work Manager.
• Developed Models using the Frame Work Manager.
• Testing and validating the data on Impromptu reports as well as Cognos Cubes.
• Cycle Time Metrics at the high level has the summary information and the drill through/the low level has the detailed information of the HCSIS Application statuses.
• Developed all the required cubes for the project. HCSIS Cycle Time Metrics are the main ones developed.
• Designed the dimensional metrics matrix prototype. This matrix would identify the Dimension, hierarchies and the granules required for the Cognos cube.
• Created and enhanced existing power cubes as per user requirement.
• Created multi dimensional cubes using Transformer.
• Created/enhanced catalogs and set User profiles to grant user permissions for querying.
• Prepared prototypes of all the reports and an approval for the requirements and the prototypes were obtained from business owners.
• Identified the required dimensions and, measures for the reports.
• Created Value Prompts and Text Prompts to filter the Data Cognos Report Studio.
• Scheduled the Reports on Cognos Connection.

Environment: Cognos Impromptu V7.3, Power Play V 7.3, Power Play Transformer, Server Administration, Impromptu Web Reports, Cognos Upfront, Report Net 1.1 with Oracle, DB2, SQL Server. ERwin was used for database modeling.

Confidential

Responsibilities:

• Developed .cpf files using ReportNet FrameWork Manager
• Testing and validating the data on Impromptu reports as well as Cognos Cubes .
• Cycle Time Metrics at the high level has the summary information and the drill through/ the low level has the detailed information of the ALDB Application statuses.
• Migrated Reports and cubes from Cognos 5.1 to 7.1
• Developed UNIX Scripts and batch files to run the Macros.
• Developed macros to save .imr to .pdf. and combine all .csv file to one csv files.
• Created List Reports, Cross tab Reports and Drill through Reports.
• Created / enhanced catalogs and set User profiles to grant user permissions for querying.
• Prepared prototypes of all the reports and an approval for the requirements and the prototypes were obtained from business owners.
• Identified the required dimensions and, measures for the reports.
• Developed ad-hoc reports using ReportNet Query Studio.
• Develop Advance reports using the ReportNet Report Studio

Environment: Cognos Impromptu V7.1 5.1, Power Play V 7.1 5.6, PowerPlay Enterprise Server, Cognos Architect, Cognos Query, Impromptu Web Reports, Cognos Upfront, Report Net with Oracle 8i,TOAD, SQL Server. AIX, ERwin was used for database modeling.