Summary

• Around 8 Years of experience in IT includes extensive Functional and Technical experience in, Data Modeling, Business Intelligence BI product development and Reports Generation.
• Strong Experience in Data warehousing project life cycle such as Data modeling, Data extraction, Reporting and Dash boarding.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies, worked in ETL Tool Data Stage.
• Strong in SQL, PL/SQL, T-SQL, Stored Procedures, Database Triggers and SQL Loader.
• Experience in gathering Business requirements, Analysis, Design, Development, Testing and Implementation of Cognos applications and End-user training.
• Proficient in Cognos 10/8 BI software Installations, Configuration and Administering the Cognos Connection for security.
• Client facing / consulting skills, such as the ability to work with the business partners to translate business requirements into potentially complex technical solutions that meet or exceed those business needs.
• Strong knowledge in TM1.
• Strong Knowledge in using Java, HTML, MS Visio 2003, MS Excel 2003.
• Proficient with accessing data in TOAD, Teradata SQL Assistant, MS SQL Server 2005 and implementing data solutions utilizing PL/SQL.
• Good knowledge in UNIX Shell scripting
• Excellent Verbal and Written Communication Skills have proven to be highly effective in interfacing across business and technical groups.
• Strong knowledge in Retail, Finance, Marketing and Human Resources.
• Proficient in RDBMS concepts, dimensional modeling, relational databases such as Oracle and MS SQL Server.
• Highly motivated, innovative, ability to adapt quickly to change, reliable responsible.

Technical Skills:

Professional Experience:

Confidential

Responsibilities:

• Migrated from 7.4 to 10.2 using migration tools like migratefroms7 and deployfroms7.
• Compared impromptu reports in 7.4 with reports in 10.2.
• Compared filters, groups and prompts in 10.2.
• Built models containing query subjects, query items, name spaces and folders.
• Tested and fixed various bugs in the report, drill-through reports.
• Created complex reports using Report Studio, Analysis studio.
• Worked on Multi dimensional model, developed dashboards using cubes.
• Scheduled and Bursted Reports on weekly, monthly basis.
• Worked with master-detail reports, drill-through, prompts, complex calculations, formatting, conditional formatting, Bursting reports, Crosstab, multi-query reports, charts.
• Created Query Prompts, Developed Prompt pages and Conditional Variables.
• Created prompts, Calculations, Conditions, Filters using Report Studio.
• Built Customized Charts like age analysis and trending, Enhanced Report Layouts.
• Worked on JavaScript code in some of the reports.
• Developed Standard Reports, List Reports, Cross-tab Reports, Drill through Reports and Master Detail Reports using Report Studio.
• Deployed packages, folders and content store from a development environment to test and then to production environments.
• Fine tuned SQL queries and reports for performance.

Environment:- Cognos 10.2, Cognos 7.4, Report Studio, Query Studio, SQL, PL/SQL, Oracle 11g, SQL Server 2K.

Confidential

Responsibilities:

• Involved in requirements gathering from business users, report design, report development, and support of all client/server layers and components of the data warehouse.
• Planned an approach for functional documenting, categorizing and packaging the requirements.
• Design development of the reports using Cognos Report studio, Analysis Studio, Query studio, and Event Studio.
• Developed advanced reports using Report Studio.
• Created Dashboards in Report Studio to display the data interactively to the end users as per the business requirement.
• Added Prompts, Cascading prompts, filters, Conditional style, Drill Through to the reports using report studio.
• Developed Drill through reports, Master Detail reports, in Report Studio based on the business requirements.
• Responsible to build the Framework Manager Models and packages as per the business requirements.
• Developed Complex dashboard reports for various reporting requirements and also created multi page reports by using Cascading prompts, conditional formatting and page rendering.
• Tested and validated the report output against the database to measure performance of reports.
• Built DMR and Cubes in Transformer using IQDs, packages, reports, etc., as a data source.
• Identified various dimensions and measures required for the generation of a cube.
• Involved in the Installation of Cognos components in various environments.
• Customization of Cognos connection using SDK.
• Developed various HR reports MTD, QTD, YTD, last fiscal year, current fiscal year reports.
• Exposure on Cognos development Software development kit like SDK in order to customize reports.
• Involved in move the developed reports from Dev to UAT and UAT to production.

Environment: IBM Cognos 10 Report Studio, Analysis Studio, Query Studio, Cognos Connection , Framework Manager, Power center, SSRS, Oracle10g SQL, PL/SQL .

Confidential

Responsibilities:

• Built models containing query subjects, query items, namespaces and folders.
• Created Models using star schemas and snowflake schemas, Packages using Framework Manager.
• Designed the model based on the requirements for different subject areas and by analyzing the underlying data.
• Worked closely with the users, Business Analyst in gathering requirements, developing prototypes, getting the BRD approval and participated in project meetings.
• Worked on integrating Cognos with java application using SDK for running and archiving reports for different submissions.
• Removed loop joins by creating shortcuts.
• Created model based calculations, filters and relationships to make it feasible for the report authors.
• Created complex reports using Report Studio, Analysis studio.
• Developed Standard Reports, List Reports, Cross-tab Reports, Charts Pie Charts, Column Charts, Bar Charts, and Line Charts , Drill through Reports and Master Detail Reports using Report Studio.
• Built Customized Charts like age analysis and trending , Enhanced Report Layouts
• Created prompts, Calculations, Conditions, Filters using Report Studio.
• Created Query Prompts, Developed Prompt pages and Conditional Variables.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Worked with master-detail reports, drill-through, prompts, complex calculations, formatting, conditional formatting, Bursting reports, Crosstab, multi-query reports, charts.
• Scheduled and Bursted Reports on weekly, monthly basis.
• Worked on JavaScript in implementing various functionality
• Deployed packages, folders and content store from a development environment to test and then to production environments.
• Have used SQL Server 2005 Integration Services SSIS transformations in the data flow of a package to aggregate, merge, distribute, and modify data.
• Fine tuned SQL queries and reports for performance.
• Exposed to Transact-SQL, PL/SQL, Stored Procedures, Cursors, Packages, UNIX Shell scripting and Windows batch file creations for Oracle9i/8i, SQL Server2k databases.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Trained users in query studio and provided sample report Studio reports to the users for getting them used to the report layout and functionality.

Environment:- Cognos 10.2BI, Cognos Connection, Report Studio, Query Studio, Analysis studio, Frame Work Manager, Java, Java Script, HTML, SQL, SSIS,PL/SQL, Oracle 11g, SQL Server 2K, Linux 5.4,Data Stage.

Confidential

Responsibilities:

• Cognos 10 installation and configured IIS, content store SQL server database , security namespaces , WebServer setup. Followed best practices in configuring the server and setting up the environment.
• Involved in requirements gathering from business users, report design, report development, and support of all client/server layers and components of the data warehouse.
• Planned an approach for functional documenting, categorizing and packaging the requirements.
• Involved in Designing and creating various models and Publishing packages in Framework Manager.
• Design development of the reports using Cognos Report studio, Analysis Studio, Query studio, and Event Studio.
• Developed advanced reports using Report Studio.
• Developed active reports using Cognos 10 version in various environments.
• Created Dashboards in Report Studio to display the data interactively to the end users as per the business requirement.
• Added Prompts, Cascading prompts, filters, Conditional style, Drill Through to the reports using report studio.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Developed Burst reports, Drill through reports, Master Detail reports, in Report Studio based on the business requirements
• Developed Complex dashboard reports for various reporting requirements and also created multi page reports by using Cascading prompts, conditional formatting and page rendering.
• Tested and validated the report output against the database to measure performance of reports.
• Created Scorecards and metrics by using metric studio.
• Built DMR and Cubes in Transformer using IQDs, packages, reports, etc., as a data source.
• Identified various dimensions and measures required for the generation of a cube.
• Published the Cubes to Cognos 8 and using Analysis Studio to analyze the data and creating the reports in Analysis Studio and Report Studio based on the published cubes.
• Involved in the Installation of Cognos components in various environments and also involved in Go Office Installation.
• Customization of Cognos connection using SDK.
• Maintained Roles and Groups in Cognos 8.4 and scheduled reports to publish, and managed Cognos Connection.
• Developed cube models in Power Play transformer, creating cubes and publishing the cubes to Power Play web and Cognos 8.
• Developed various HR reports MTD, QTD, YTD, last fiscal year, current fiscal year reports.
• Exposure on Cognos development Software development kit like SDK in order to customize reports.
• Involved in move the developed reports from Dev to UAT and UAT to production.

Environment: IBM Cognos 10/ 8.4 Framework Manager, Report Studio, Analysis Studio, Query Studio, Cognos Connection , Power Play Transformer 10, Informatica 8.1 power center, SSRS, oracle10g SQL, PL/SQL , DB2 v8, HP-Unix.

Confidential

Responsibilities:

• Worked on complete life cycle of Cognos 8 Administration and Cognos BI Installations, Security, Configurations, Migration and deployment.
• Worked closely with Clients and Business Users to analyze and understand business requirements and Participated in requirements gathering meetings / Sessions.
• Developed technical specifications, data identification and also recommendations on the preferred solution for development, and deploy efficient BI solutions
• Worked on technical design specs for Framework manager, and reporting as per the requirements.
• Created Relational and dimensional models using Framework Manager. Provided Data level security in Framework Manager.
• Worked on multiple database, and multiple data source in Framework Manager to generate reports
• Created standard reports in Cognos Report Studio, and Analysis Studio.
• Responsible to build the Framework Manager Models and packages as per the business requirements.
• Created folders, filters, prompts, and complex business calculations in Framework Manager and Report Studio.
• Worked on various reports like, List, Crosstab, drill-thru, multi-query, master/detail, prompted, dashboards, port lets, and tabular reports.
• Designed complex reports with union queries, and SQL queries
• Improved long running reports performance thru writing SQL queries, resolving complex joins in framework manager, filters, and using stored procedures.
• Written java scripts for report prompts automation.
• Expertise to understanding, analyze, Cognos, data warehouse OLAP , and OLTP data
• Designed transformer models, and PowerPlay cubes using PowerPlay transformer.
• Worked on PowerPlay studio to slice/dice Cognos cubes,
• Worked on performance tuning to maintain fast performance of the cubes and Transformer models.
• Recommended to do the complex database calculations in the database to improve report query performance.
• Provided customer training in Report Studio, and Query Studio

Environment: Cognos 10/8.4, Report Studio, Framework Manager, Query Studio, Event studio, Powerplay Studio, Analysis studio, Powerplay transformer8.4, Teradata12.0, and Oracle10g, Informatica, zLinux

Confidential

Responsibilities:

• Used Framework Manager to create models, packages and publish packages to the Cognos 8 Server.
• Migration of reports and catalogs from Cognos series 7.1 to Cognos series 8.3.
• Upgrading of reports from series 7.1 to series 7.3
• Experience in developing models using prompts and filters.
• Distributed reports to various agents using Bursting.
• Added new Dimensions and Measures in the already existing reports in the Production.
• Performed BI Content Administration tasks including scheduling and content management
• Developed SQL in TOAD and exported results to Access Database.
• Developed SQL Driven reports.
• Administered user access protocols and managed user accounts and access privileges.
• Setting up different environments development, testing and production
• Deployed the reports from development to QA and QA to production using deployment tool.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Created various portals involving Cognos 8 port lets.
• Administer user access protocols and created user accounts and access privileges

Environment:- Cognos 8BI,Cognos Connection, Report Studio, Query Studio, Analysis studio, Metric studio, Frame Work Manager, Oracle 10g, SQL, Scheduler ,XML and Windows NT/4.0

Confidential

Responsibilities:

• Used Framework Manager to create models, packages and publish packages to the Cognos 8 Server.
• Migration of reports and catalogs from Cognos series 7.1 to Cognos series 8.3.
• Upgrading of reports from series 7.1 to series 7.3
• Experience in developing models using prompts and filters.
• Distributed reports to various agents using Bursting.
• Added new Dimensions and Measures in the already existing reports in the Production.
• Performed BI Content Administration tasks including scheduling and content management
• Developed SQL in TOAD and exported results to Access Database.
• Developed SQL Driven reports.
• Administered user access protocols and managed user accounts and access privileges.
• Setting up different environments development, testing and production
• Deployed the reports from development to QA and QA to production using deployment tool.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Created various portals involving Cognos 8 port lets.
• Administer user access protocols and created user accounts and access privileges

Environment: Cognos 8BI,Cognos Connection, Report Studio, Query Studio, Analysis studio, Metric studio, Frame Work Manager, Oracle 10g, SQL, Scheduler ,XML and Windows NT/4.0

Confidential

Responsibilities:

• Gathered and analyzed business requirements from users and business community.
• Created Packages and Folders in Framework Manager1.1 and published them to Cognos Connection.
• Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.
• Created Sophisticated Reports using Report Studio 1.1
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Supported Business Users in generating Adhoc Reports using Query Studio1.1.
• Catalogs were Optimized by using Database Interaction, Client/Server balancing, Database functions, Table Weighting and Qualification, Governors Settings.
• Created filters, prompts, sub reports, provide drill through capabilities
• Creating User Classes and Restricting the user access with the help of User Class Privileges in the Governor settings.
• Worked on Star Schema Database Design.
• Environment: Cognos Report Net 1.1MR2, Cognos Connection, Report Studio, Framework Manager1.1 MR2, Cognos Impromptu 7.1 MR3, Cognos Access Manager, Cognos Scheduler, SQL, PL/SQL, Oracle 8i, Windows XP.