Resume Of

Bikshapathi Chenchu

571-***-**** (Mobile)

PROFESSIONAL PROFILE

• Seven (7) years of experience in Enterprise Data Warehousing, OLAP, and Report Generating Systems.

• Excellent Knowledge in Data Warehousing Concepts.

• Extensive knowledge with Dimensional Data modeling, Star Schema/snowflakes schema, Fact and Dimension tables.

• Involved in the Design,Development and Adminsitration Phases.

• Expert in Business Intelligence Applications using Cognos Tools such as Cognos 8 BI, (Framework manager, Analysis Studio, Powerplay Studio, Report studio, Event Studio ,Query studio), Transformer, Reportnet, Impromptu, PowerPlay, Impromptu Web Reports (IWR), Access Manager and Server Administration on Cognos 8.4 and IWR servers.

• Created Various Dashboard Reports for different Business Areas based on Powerplay Cubes and DMR’s.

• Developed Dashboard Reports using AJAX.

• Involved in the Migration of FM Models,Transformer Models and reports from Cognos 8.3 to Cognos 8.4.

• Involved in installation Cognos 8.4 Suite on Unix and Windows.

• Extensively worked on Cognos 8 Dimensional Functions on OLAP Datasource.

• Extensively worked with large Databases in Production Environments.

• Strong in Transformer for Data Modeling of Multidimensional Cubes using Star Schema.

• Worked on Creating Categories, Sub Categories, Terms and Report Paths in Business Glossary (8.1.1) and importing the files to the Business Glossary for creating the Definitions which can be used as Glossary in the Cognos 8.4 reports.

• Created Framework Manager Packages following best practices in multi-user Environment.

• Created various SQL Scripts to be used in Framework Manager and also for the verification of the Data.

• Created Powerplay Cubes based on the Cognos 8 Packages and Reports.

• Install COGNOS suite of tools and configure gateways and dispatchers.

• Strong Enterprise Data Warehouse and OLAP skills using COGNOS Tools PowerPlay Transformer, ReportNet and COGNOS 8.

• Extensively worked on the Conditional Formatting of the reports using the Render and Conditional Variables.

• Used drill through, prompts, filters, and complex calculations in Cognos 8.

• Experience in dimension mapping, creating dimension views to implement the data security and generating, grouping and partitioning cubes.

• Involved in the Cognos 8.4 Administration like Creating Datasource Connections, Publishing Powerplay cubes to the server as a Package and Publishing FM Packages and Assigning the security for Business User Community and also Deployment of Packages and reports from Development to Production Servers

• Extensive Unix Shell Scripting knowledge.

• Develop UNIX-based Transformer models.

• Involved in the Atomization of the cubes on Unix Server.

• Extensive experience in ETL Tools-Data stage and Informatica.

• Load balance Cognos Servers such as PPES and IWR Servers..

• Catalog Development and Management, making IQD files, regular reports, and drill thru reports in Impromptu.

• Experience in creating the Catalogs and implementing the Security using User Classes in Impromptu Administrator.

• Implement data security in IWR reports using database sign-on.

• Maintain security through Access Manager and LDAP Server.

• Handle online interactive and batch programming.

• Write Macros using Cognos Script Editor and Visual Basic.

• Publish and mirror cubes and publish IWR reports using Administrator tools.

• Schedule cube builds and IWR Public Reports using Cognos Script, Visual Basic, and Autosys.

• Experience in building and maintaining multi-dimensional cubes in Powerplay.

• Provide Cognos user support and troubleshooting.

• Monitor Cognos Production Servers, taking backups and batch processing of the user requests.

• Extensively worked on migration projects such as upgrading servers to newer version of Cognos tools and upgrading Cognos reporting (worked on upgrades 6 to 7, 7 to 7.1, and 7.1 to 7.3).

• Extensively worked on the documentation of the application design and deployment.

• Certified as ORACLE Associate.

• Certified in COGNOS.

TECHNICAL SKILLS

BI Tools: Cognos 8.4, Cognos 8.3, Cognos 8.1(Report Studio, Analysis Studio, PowerPlay Studio, Event Studio, Query Studio), Cognos 8.1.1 Business Glossary, ReportNet 1.1, Cognos Tools Suite (Series 6 and EP Series 7.0/7.1/7.3MR2), SDK, Impromptu, PowerPlay Transformer, PowerPlay Enterprise Server, Access Manager, Upfront, IWR Admin Tools and Script Editor.

ETL: Datastage, Informatica and Oracle Warehouse Builder.

Programming Languages: SQL, PL/SQL (Cursors, Stored Procedures, Triggers, Packages and Functions), C, C++ and UNIX Shell Scripting.

Databases: Oracle 8i, 9i, 10g and Microsoft SQL Server.

Reporting Tools: Oracle Discoverer, Oracle Administrator and D2K Reports.

Operating Systems: WINDOWS 95/98, WINDOWS- NT/2000/XP Professional, MS-DOS and UNIX.

Others: Autosys, PcAnywhere, Remote Desktop and Net Meeting.

EMPLOYMENT HISTORY

Inter American Development Bank (IADB), Washington, DC, USA

Cognos Architect Mar’ 08 – Present

Project Description:

The EDW is a centralized information repository for the various systems in the Bank. Data Warehouse provides Reporting/OLAP solutions to diverse user communities with the help of Cognos business Intelligence suite of tools. The project works on the Headquarters/Country Offices model.

Responsibilities:

• Gathering the Report requirements from the Users to Design the FM Model and developing the Dashboards, Cubes and Complex reports.

• Designed the Dashboard Templates and Created Various Dashboard reports for the Business Users.

• Design the Model for Different Business Areas and analyzing the indexes and Keys and creating star schema.

• Participating in the User meetings to analyze and prepare the reporting and analysis requirements of users.

• Designing, Constructing, Testing and Deploying the Cognos Framework Manager Models, Packages, Reports and Powerplay Models.

• Created a Framework Manager Models with Multiple Namespaces.

• Created a Framework Manager Models with calculated columns, filters and Macros from different data source and created packages to suit the reporting needs of the client.

• Created dimension views and Custom views to implement the data security in the Powerplay Transformer Model.

• Involved in installation Cognos 8.4 Suite on Unix and Windows.

• Created Multiple Power cubes from Single Model.

• Experience on Running the SDK Scripts on Security.

• Created Dashboard reports from the OLAP source.

• Implemented the Dashboard reports with the various Cognos Dimensional Functions.

• Developed Dashboard Reports using AJAX.

• Created various Crosstab reports and Drill through reports as per the user requirements using conditional formatting using the Rendering and Conditional Variables.

• Developed various complex and customized (Inserting tables and Blocks) reports using prompts like value prompt, Tree prompt, date prompt, type in, cascading prompt, Select & Search Prompt and using conditional formatting as well.

• Created Powerplay cubes using multiple datasources, which are retrieved by Cognos Packages and Reports.

• Extensively worked on the OLAP Datasource Reports.

• Created UNIX shell scripts for atomization of the Cubes Refresh using the Crontab on the Cognos AIX Server.

• Involved in Performance Tuning of the reports.

• Preparing User manuals, Operational Guides, Planning and Conducting User trainings.

• Involved in the Cognos Administration like creating new Datasource Connections and Creating Packages, handling the Deployment of reports copying from Development to Production server and also handling the user permissions on the Packages and Folders.

• Collecting and sharing best practices and tips in Framework Manager modeling, security setup, Report Authoring, Stress testing and Performance tuning.

• Addressing the Performance and other Production issues with the Cognos 8 reports and Powerplay cubes.

• Created various SQL for the test cases and also used some User-Defined SQL’s In Framework Manager.

• Coordinating with Database team in setting up the required Materialized views, Aggregated and De-Normalized tables for the Reporting and Analysis needs.

• Coordinating with the ETL team in defining the ETL logic for Reporting table loads and in setting up the timely schema refreshes for the Reporting Schemas.

Environment:

Cognos 8.4/8.3, (Framework Manager, Cognos Connection, Report Studio, Query Studio,

Analysis Studio, Event Studio, Powerplay Studio), Cognos 8.4 Transformer, Cognos 8.1.1, Business Glossary,SDK, Data stage 6.0, Oracle 10g, SQL Server, TOAD.

Platform:

AIX, Windows 2000/2003/XP.

American International Group Inc, New Jersey, NJ, USA

Cognos Consultant Jun’ 06 – Mar’ 08

DBG-DSS (Domestic Brokerage Group – Decision Support Systems)

Project Description:

The DBG Data warehouse is a centralized information repository for the Domestic Brokerage Group (DBG) of AIG. The Decision Support Systems built upon DBG Enterprise Data Warehouse provides Reporting/OLAP solutions to diverse user communities with the help of Cognos business Intelligence suite of tools i.e. Cognos 8, Powerplay, etc. The project works on the Onsite/Offshore model with the offshore team supporting from India.

Responsibilities:

• Participating in the User meetings to analyze and prepare the reporting and analysis requirements of DSS users.

• Designing, Constructing, Testing and Deploying the Cognos Framework Manager Models, Packages, Reports and Powerplay Models.

• Migrating the existing Cognos Impromptu Catalogs to Cognos 8 Models.

• Enhancing the Powerplay, Framework Models and Reports to meet the changing business requirements.

• Created a Framework Manager Model with calculated columns, filters and Macros from different data source and created packages to suit the reporting needs of the client.

• Create IQDs using Framework Manager

• Created dimension views and User Class views to implement the data security in the Powerplay Transformer Model.

• Created various Powerplay reports for the Different user groups.

• Created various Crosstab reports and Drill through reports as per the user requirements using conditional formatting.

• Developed various complex and customized (Inserting tables and Blocks) reports using prompts like value prompt, date prompt, type in, cascading prompt, Select & Search Prompt and using conditional formatting as well.

• Extensively worked on Expense and Claims Cubes.

• Created various cubes using multiple datasources.

• Involved in Performance Tuning of the reports.

• Preparing User manuals, Operational Guides, Planning and Conducting User trainings.

• Collecting and sharing best practices and tips in Framework Manager modeling, security setup, Report Authoring, Stress testing and Performance tuning.

• Addressing the Performance and other Production issues with the Cognos 8 reports and Powerplay cubes.

• Defining the Users, Group and Roles in LDAP using Cognos Access Manager.

• Installed Cognos 8 On Windows 2000 Server and Configured the Dispatcher and Gateway.

• Coordinating with Database team in setting up the required Materialized views, Aggregated and De-Normalized tables for the Reporting and Analysis needs.

• Coordinating with the ETL team in defining the ETL logic for Reporting table loads and in setting up the timely schema refreshes for the Reporting Schemas.

Environment:

Cognos 8(Framework Manager, Cognos Connection, Report Studio, Query Studio,

Analysis Studio), Cognos Report Net 1.1, Cognos EP Series 7 (Impromptu, Powerplay, Powerplay Transformer, IWR, Upfront, Access Manager), Datastage 6.0,SSIS Oracle 10g, SQL Server, DB2 7.0, ERWIN,

Genio 4.6, TOAD & Sun One Directory Server.

Platform:

Sun Solaris, Windows 2000/2003/XP.

TTSL-Enterprise Data Warehouse, India

Report Developer Jul’03-Jun’06

Tata Tele Services Ltd., Hyderabad, India

Project Description:

Tata Tele Services limited is India’s leading Private Basic Service Operator and the pioneers of CDMA mobile services. It provides products and services like CDMA mobiles, Post Paid Internet Services, Plain Old Telephone Services and Public Telephone booths. TTSL currently offers services under the brand name 'Tata Indicom' in 20 circles in India. With the growing business and competition, a central place for analyzing the data coming from different operational systems is apparent and hence an Enterprise Data warehouse. Successful implementation of EDW will support management decisions in proactively analyze business and make forecasts.

Responsibilities:

• Enhancements of COGNOS Impromptu.

• Design and Develop OLAP Cubes using Cognos Power Play Transformer.

• To map Business requirements into System functionality

• To design and develop ETL mappings in Oracle Warehouse Builder.

• Written Unix Shell scripts.

• To write Shell Scripts for automating ETL processes

• Design Model using the Macros.

• Security is provided for accessing the Cubes and also for accessing the Data.

• Developed PLSQL Procedures.

Environment: Oracle, Cognos Report Net 1.1,Cognos Suite (Series 7.1/7.3 of Impromptu, PowerPlay, PPES, Upfront, Architect, Cognos Query, Access Manager, IWR Admin Tools, PowerPrompts), IIS 5.0, Win NT, Unix ,Informatica and Oracle Warehouses Builder.

Contact this candidate