Qualification Highlights

• Experience : 5 years in Data analysis and Reporting
• IBM Certified Designer - Cognos 8 BI Reports
• IBM Certified Designer - Cognos 8 BI Multidimensional Reports
• IBM Certified Developer - Cognos 8 BI Metadata Models
• IBM Certified Administrator - Cognos 8 BI
• BOCP - BusinessObjects web intelligence XI 3.0 - Level One
• Experience in SQL server queries(MS SQL, Oracle, Sybase)
• Good communication skills.
• Strong development, analytical and problem solving skills
• Strong knowledge of Data warehousing and Business Analytics concepts
• Expert level skills in Cognos8.3 and Business Objects

IBM Cognos 8.1/Cognos 8.3/Cognos 8.4

• Expertise in: Cognos 7 Reportnet, Cognos 8.4 Report Studio, Query Studio, Analysis studio, Cognos Connection, Cognos Go! Office
• Experience in: Framework Manager, Cognos Administration, Cognos configuration
• Familiar with: Cognos Transformer, Event Studio, Metric Studio, Cognos 8.4 suite
• Certified in : Cognos BI reports, Multidimensional Reports, Metadata models and Admin

SAP Business Objects

• Expertise in: BOXI R2/R3 - Desktop Intelligence, Designer, Infoview, Central Management Console(CMC), BOXI R3 WebI Rich client, BO 6.5(Designer, Supervisor)
• Experience in : BO Import wizard, Translation Manager and Report Conversion tool
• Familiar with : BO Data Integrator(ETL tool)
• Certified In : BOCP - BusinessObjects web intelligence XI 3.0 - Level One

Database

• Expertise in: MS SQL server 2005 queries, stored procedures and jobs
• Experience in: Sybase, Oracle 9
• Certified in : Sybase ASE SQL Developer Associate

Languages

• Experience in: T-SQL, Java, Java Script, Velocity, MS Excel, MS Word
• Platforms: Microsoft Windows

Associate Application Consultant

October 08 - May 10

Confidential,
Client : Confidential, France Domain : Industrial Products

• Experience in creating reports based on Relational, Dimensional and DMR models.
• Developed Dynamic Dashboards for displaying multiple reports communicating with each other using Cognos Connection, Global Filters and Drill functionality.
• Master-Detail reports were created using charts, lists and crosstabs to display the detail data graphically.
• Developed complex reports in Report studio having the following:
• Large number of joins and multiple queries from different data sources.
• Conditional Formatting using Conditional blocks.
• Variables for highlighting important data.
• Drill up and Drill down in multidimensional reports and Drill-Through from one report to another.
• Conditional display of list/chart/crosstab in the report using Smart Prompts.
• Filtering the data using Cascading Prompts.
• Sorting/Formatting a report based on prompt selection.
• Complex calculations using various built in Functions and Parameters.
• Java script for Data Validations.
• HTML for Hyperlinks and tooltips.
• Tables and Blocks for the report alignment.
• Layout Calculations for formatting the report parameters.
• Suggested improvements while migrating from old to new versions of Business Objects to Cognos applications.
• Time to time analysis and comparison of Cognos and Business Objects was done to identify which tool suits the Client requirements.
• Handled performance tuning of the various Cognos Reports by checking the reports against the database.
• Used Analysis Studio to carry out Dimension data analysis.
• The Reports developed in Report Studio were imported into Microsoft Excel and PowerPoint using Cognos Go! Office for distribution and Presentation purposes.
• Performed Business Analysis and developed performance reports which were used by the clients for decision making.
• Used Framework Manager to create Relational and DMR models.
• Performed single machine Installation and Configuration of Cognos 8 on Windows platform for training purposes.
• Developed and modified the SQL code for creating various tables with complex joins, indexes and conditions.
• SQL code developed for taking the backup of important database objects was well appreciated by the client.
• Developed MS SQLStored procedure queries for loading data from various sources. Performed scheduling and job monitoring for periodic data loading activities.
• Created design specifications and database mappings. Developed BO universes and Cognos FM packages based on these specifications.
• Developed Business Objects reports based on relational data model.
• Developed multilingual BO reports using BOXI R3 Translation Manager.
• Handled BOXI admin for a set of specific users.

Programmer Analyst

September 05 - October 08

Confidential,India
Client : Confidential

Domain : Healthcare

• Developed solutions to Cognizant's healthcare clients
• Involved in the Analysis of the business requirements and preparing the required analysis documents. This included data mapping documents and Report specifications.
• Strong experience in BO Designer for Design and Development of star schema model which involves creating cardinalities, joins, classes, resolving loops using contexts and alias, variables etc.
• Involved in creation of packages in Cognos Framework manager.
• Developed Cognos 8 reports in Reportstudio and Query Studio.
• Experienced in operational and analytical data models and design of de-identified operational data model.
• Developed reports in Business Objects 6.5. Used Infoview to publish the reports on Web and used BO Supervisor to assign user access.
• Created new reports in BOXI R2, migrated Reports and universes developed in BO 6.5 to BOXIR2 and tested the migrated reports.
• Performed installation and configuration of Business objects 6.5 client-server and cognos8.
• Performed performance tuning of the reports against the database(Sybase)
• Worked in Oracle to test the report data in the existing reports.
• Reports were created from various data sources like stored procedure, Excel and Free hand SQL.
• Performed basic ETL data load designs using BO data integrator.

Client : Confidential

Domain: Insurance

• Involved in design, development and testing of the reports in various Cognos applications in the project.
• Migration from VB application to Cognos application was successfully performed.
• Reportstudio was used to create dynamic reports and ad-hoc reports were created using Query Studio.
• Created additional reports with master detail and drill through functionalities.
• Implemented Java script for various selection panels, alerts, data validations and user interfaces.

• BE Electrical and Electronics

• IBM Certified Designer - Cognos 8 BI Reports December 08
• IBM Certified Designer - Cognos 8 BI Multidimensional Reports February 09
• IBM Certified Developer - Cognos 8 BI Metadata Models December 09
• IBM Certified Administrator - Cognos 8 BI December 09
• BOCP - BusinessObjects web intelligence XI 3.0 - Level One September 09
• Sybase ASE SQL Developer Associate December 07
• Sun Certified Java Programmer January 07

EAD with validity up to April 2012.