PROFILE SYNOPSIS

• 8 years of IT experience with good knowledge in different phases of software development life cycle (SDLC) including Analysis, Design, Development, Testing and Production.
• Experience in Cognos 10, 8.x (Framework Manager, Report studio, Query Studio)
• Experience in Analysis studio, Event Studio
• Experience in creating Models, Packages in Framework Manager and Publishing to cognos connection
• Knowledge in Cognos Transformer and Power Play Cubes.
• Excellent knowledge in Data Warehousing Architecture Concepts, and Methodologies like Star Schema, Snowflake Schema used in Relational and dimensional modeling.
• Experience in Developing List, Cross Tab, Chart, Dynamic Reports and Drill through Reports in Cognos.
• Developing Dashboard, Report Calculations, Conditional Formatting, Filters and Cascading Prompts using Report Studio.
• Experience working in Relational Databases like Oracle 10g/9i/8i, DB2, MS SQL Server 2000/2005 and database access tool TOAD, SQL Developer.
• Strong programming and debugging skills on PL/SQL, SQL.
• Experience with basic ETL mapping creation using Informatica.
• Strong Writing and documentation skills for the management, development and control of project.
• Diverse background with fast learning skills and creative analytical skills.
• Good communication and interpersonal skills.

TECHNICAL SKILLS

Business Intelligence Tools: Cognos 8.x, Cognos 10.2

ETL Tools: Informatica 8.6, Informatica 9.6

RDBMS: Oracle 10g/9i/8i., DB2, MS SQL Server2005/2000, MS - Access.

Programming Languages: C, C++, Java, VB.Net, SQL, PL/SQL

Web / Scripting: HTML, Java Script

Web & Application Servers: IIS 5 & 6, Tomcat 4.x/5.x, Sun One Directory Server - iplanet

Testing Tools: Manual Testing, Unit testing

Operating Systems: Windows 2000, 2003 Server, XP

PROFESSIONAL EXPERIENCE

Confidential, Austin, Texas

Cognos Consultant

Environment: Cognos 10.2 (Framework Manager, Report Studio, Query Studio, Cognos Connection), Informatica 9.6, DB2, TOAD

Responsibilities:

• Extensively worked on data level security implementation in Frame work Manager integrating with Active Directory
• Developed Framework Model which supports current operational Reporting System, Dimensional Data models and Data mart models
• Experience in working with Report studio objects like Page sets, lists, crosstabs, graphs
• Experience in building Master-Detail, Drill-thru, Drill-down reports
• Involved in extracting data from refactored Data Sources DB2
• Experience in Scheduling reports by designing regular cognos jobs and using Event Studio for dynamic date parameters.
• Experience in creating and using session parameters in Framework manager and cognos Reports.
• Experience in developing reports using sql query approach to improve the performance of the query.
• Experience in creating Report template adding reusability for report header and Footer information. Ex: company logo, page numbers, Report Run date, Database update date.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Responsible for Unit Testing of Mappings and Workflows for the developed code.
• Used various Informatica Transformations like Source Qualifier, Rank, SQL, Router, Filter Lookup, Joiner, Aggregator, Normalizer, Sorter etc.
• Responsible for Unit Testing of Mappings and Workflows for the developed code.
• Documenting support guides for Support/service center team to handle the go-live process queries and address the after go-live User Queries.

Confidential, Chicago, USA

BI Modeler and Report Author

Environment: Cognos 8.4, 10 (Framework Manager, Report Studio, Query Studio, Cognos Connection), SQL Developer Tool, Windows 2003 server, Oracle 11g, Informatica 8.6

Responsibilities:

• Experience in working with Report studio objects like Page sets, lists, crosstabs, graphs
• Experience in building Master-Detail, Drill-thru, Drill-down reports
• Creating and Modifying business Data Model according to Business requirements
• Documenting System Requirements and technical requirements
• Designing of Complex Cross Tab Reports using Report Studio
• Involved in Migration from Cognos 8.4 to 10 and bug fixes
• Designing Jobs to Schedule reports and Bursting Reports to various Pay Group’s
• Generating reports by creating groups, Sections, defining filters, defining prompts and creating summary fields
• Involved in Deployment of Reports from Development Environment to QA and Production Environment
• Experience in Scheduling reports by designing regular cognos jobs and using Event Studio for dynamic date parameters.
• Experience in creating and using session parameters in Framework manager and cognos Reports.
• Experience in developing reports using sql query approach to improve the performance of the query.
• Experience in creating Report template adding reusability for report header and Footer information. Ex: company logo, page numbers, Report Run date, Database update date.
• Involved in extracting data from different types of Data Sources like Oracle, Sql Developer and Flat Files.
• Involved in identifying the bottlenecks for the long running jobs and performance tuning of the ETL's.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Used various Informatica Transformations like Source Qualifier, Rank, SQL, Router, Filter Lookup, Joiner, Aggregator, Normalizer, Sorter etc.
• Responsible for Unit Testing of Mappings and Workflows for the developed code.
• Involved in unit testing.

Confidential

BI Modeler and Report Author

Environment: Cognos 8.x (Framework Manager, Report Studio, Query Studio, Cognos Connection), SQL Developer Tool, Windows 2003 server, Oracle 10g, Informatica 8.6

Responsibilities:

• Designing of reports using Report Studio and Query Studio
• Updating FM Model according to the requirement and publishing package when required
• Defining Usage Properties, Validating cardinalities according to the requirements
• Generated reports by creating groups, defining filters, defining prompts and creating summary fields
• Customization of prompts and report pages functionality using JavaScript.
• Involved in Deployment of Reports from Development Environment to QA and Production Environment
• Unit testing the application and providing best approaches for quality improvement.
• Involved in Migration from Cognos 8.3 to 8.4 and bug fixes
• Understanding existing business Data Model and customer requirements
• Experience in Scheduling reports by designing regular cognos jobs and using Event Studio for dynamic date parameters.
• Experience in creating and using session parameters in Framework manager and cognos Reports.
• Experience in developing reports using sql query approach to improve the performance of the query.
• Experience in creating Report template adding reusability for report header and Footer information. Ex: company logo, page numbers, Report Run date, Database update date.
• Used various Informatica Transformations like Source Qualifier, Rank, SQL, Router, Filter Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties
• Involved in extracting data from different types of Data Sources like Oracle, Sql Developer and Flat Files.
• Used Informatica Workflow Manager to schedule jobs in Informatica and execute workflows
• Responsible for Unit Testing of Mappings and Workflows for the developed code.
• Used different workflow variables, session parameters, Mapping Parameters, Mapping Variables and Parameter files

Confidential, New Jersey, USA

Cognos Developer

Environment: Cognos 8.2 (Framework Manager, Report Studio, Query Studio, Cognos Connection), SQL Developer Tool, Windows 2003 server, Oracle 9i

Responsibilities:

• Translating business requirements into technical design document
• Extensively worked on data level security implementation in Frame work Manage, Transformer, Reporting
• Extensively worked on Java script usage in Cognos Report development to achieve complex features of prompts and display criteria
• Used Query Studio for developing Ad hoc reports and Report Studio for developing Dashboards
• Used join to extract data from different tables.
• Generated reports by creating groups, defining filters, defining prompts and creating summary fields
• Experience in working with Report studio objects like Page sets, lists, crosstabs, graphs
• Experience in building Master-Detail, Drill-thru, Drill-down reports
• Experience in Scheduling reports by designing regular cognos jobs and using Event Studio for dynamic date parameters.
• Experience in creating and using session parameters in Framework manager and cognos Reports.
• Experience in developing reports using sql query approach to improve the performance of the query.
• Created Requirements and Technical design documents. Attend the project meetings, Reviews and Walk-throughs for requirements, design and test plans
• Enhance the existing metadata models with the required changes in Framework Manager and

Confidential

Cognos Developer

Environment: Cognos 8.2, Microsoft SSIS, Windows 2003 Server

Responsibilities:

• Optimizing Cognos Reports and data warehouse for better performance of Reports
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Automating the Scheduling of Reports using Event Studio
• Worked on Key KPI Dashboards.
• Implementing the Best Practices at Reporting Level and Frame Work Manager Model
• Discussing new requirements with the team lead and understanding the development approach
• Working on proof of concept’s to validate the practical implementation of the design
• Designing of Complex Cross Tab Reports using Report Studio
• Experience in using conditional formatting, style variables and conditional Blocks for controlling the display for the lists, crosstabs
• Conducted various training sessions on basic/advanced report authoring to familiarize end users to the new reporting environment.
• Experience in using SQL to validate reports
• Experience in implementing conditional rendering cognos report pages and page components
• Experience in bursting the cognos report based on product region and sales manager.
• Experience in developing reports using cubes/ multi-dimensional models.