Summary of Experience:

• 7+ years of experience in Business Intelligence with Cognos Mobile 10.1.0,Cognos 8.x series and Cognos 7 series.
• Experience in full life cycle of Software Development such as Analysis, Design, Development, Customization, Testing and Deployment.
• Extensive Experience in SQL Server, Oracle, Teradata and DB2 for building and implementing data warehouse.
• Expertise in creating complex reports in Cognos Report Studio such as List reports, Cross-tab reports, Drill through reports, Master-Detail Reports and Cascading Reports and involved in reports performance tuning.
• Experience in Metadata Modeling both Relational and Dimensional model.
• Created Projects, Models using Cognos Framework Manager and published packages to Cognos Server for reporting authoring.
• Experience in creating different layers in Framework Manager Models based on the business requirements.
• Created Dimensionally Modeled Relational in Framework Manager and created analytical reports using Analysis Studio.
• Experience in Reports Migration such as migrating from Cognos 8.4 to Cognos Mobile 10.1.1.
• Experience in developing dynamic Dashboards and Scorecards and various charts and map reports depends on the business requirements.
• Involved in the Design, Development and Implementation of the Cognos Multi Dimensional Power Cubes using Transformer.
• Developed several reports using Cubes as data source.
• Upgraded Cognos Impromptu Reports and Cubes from 6.0 and 7.0 to 7.1
• Experience in Using Cognos connection.
• Working knowledge of designing multidimensional architecture for Extract, Transform, Load environment with Cognos tools.
• Extensive experience on Cognos8 and Report net with respect to Deployment, Content Administration, Users and User Class Creation, and Scheduling of Reports.
• Strong knowledge in the area of Cognos Architecture and Administration.
• Generated different kind of reports including templates, List & Chart Reports, Cross-tab Reports, Drill through Report and Master Detail Reports using Query Studio and Report Studio.
• Excellent analytical and communication skills, technically competent and has strong problem solving skills.
• Strong experience in client interaction, understanding business applications and requirement gathering.

TECHNICALSKILLS:

Cognos Mobile 10.1.0,8 (8.1,8.2,8.3,8.4), ReportNet 1.1(MR3,MR4), Cognos 7.x, Report Studio, Query Studio, Framework Manager, Analysis Studio, Metric Studio, Event Studio , Data Manager, Access Manager, Transformer, PowerPlay, PowerPlay Web, Upfront, Impromptu Administration. Cognos Access Manager, Cognos Script Editor.

Databases:

Oracle (10g,8i,9i), MS SQL Server(2000,2005), DB2, MS Access

Querying Tools:

SQL*Plus, TOAD

Data Modeling:

Logical and Physical Data Modeling, Star Schema, Snow-Flake Schema Data Modeling, Erwin 4.0/3.5, Visio

Operating Systems:

Windows(03,98,NT,2000,XP,Vista,7), UNIX(IBM AIX, HP-UX), DOS

Languages:

• C, C++, CORE JAVA, HTML, SQL, PL/SQL.

EDUCATION:

• Bachelor of Technology in Electronics and communications

PROFESSIONAL EXPERIENCE
Client: Confidential, (OAKLAND,CA)
July 09-June 12.
Sr. Cognos Technical Consultant/Administrator.
The Office of the President is the system wide headquarters of the University of California, managing its fiscal and business operations and supporting the academic and research missions across its campuses, labs and medical centers. The 10 campuses of the University of California open their doors to all who work hard and dream big. Through its teaching, research and public service, UC drives California\'s economy and leads the world in new directions. The UC family includes more than 220,000 students, more than 170,000 faculty and staff, 37,000 retirees and more than 1.5 million living alumni.
Responsibilities

• Interacted with business analyst to gather business requirements and designed functional and technical requirements documentation.
• Developed models in Framework Manager and deployed packages to the Cognos Connection.
• Customized data by adding filters at both the Framework Level and Report Level.
• Published different packages from Framework Manager to Cognos Connection.
• Implemented all business logic in Framework Manager by creating prompts, folders, calculated columns, joins and naming convention.
• Worked on creating and analyzing the complex reports like Cross tab, drill-thru reports.
• Developed active reports using Cognos Mobile 10.1.1
• Page explorer, query explorer and variable explorer were used to manage the content of the reports.
• Bursting the reports in various formats, such as html, PDF, excel on the server based on the sales area and different levels of administration.
• Created Dashboards comprising of list reports, cross-tab reports and chart reports using underlying multiple query structure by using filters, calculations, complex expressions, and conditional formatting.
• Assisted in creating executive dashboard for management level reports using Report Studio.
• Worked on complex filter condition, query join logic, conditional formatting, various type of prompts like value prompt, search & select prompt, Text Box prompt and Date & Time prompt.
• Used layout component reference in page header, page footer and prompt page for uniformity across the reports.
• Changed the appearance of the reports in Query Studio by reordering the report items, swapping rows and columns and by limiting the number of rows that should appear on a page.
• Created Ad-hoc Reports using Query Studio.
• Used Cognos Connection to administer and scheduling reports to run at various intervals.
• Scheduled and Distributed reports using Schedule Management in Cognos Connection.
• Created Power Play cubes with data level security based on the user profile
• Created various IQD in Framework Manager and from this IQD’s as source, integrated to Power Play Transformer to create various models and build cubes.
• Creating the model and publishing the Cubes to Cognos Connection to be used for multidimensional analysis.
• Involved in performance tuning of the application using governor settings in framework manager and transformer models.
• Used Transformer with a variety of sources and combined them into Multi-Dimensional Cube.
• Generated all types of complex Work Order, Purchase Order, Account Balance Reports and Supervisor Reports using Report Studio and Query Studio. Analyzed cubes from cube packages using Analysis Studio
• Designed, developed, and tested Power cubes and deployed them in to production
• Created Virtual cubes using multiple Analysis Services Cubes.
• Creation of Model definition, calculated measures, multiple cubes and cube groups in Power Play Transformer
• Worked with user profiles to ensure security by restricting user access to data based on the individual user.
• Set security for individual reports in Cognos Connection.

Client: Confidential, (Lexington,MA) Jan’08 – June’09
Modeler / Report Developer
Confidential,is a bio-pharmaceutical company focused on the research, commercial­ization and creation of pharmaceutical products that address unmet medical needs in the acute care environment.
Responsibilities

• Analyzing and reviewing the business requirements, design document and functional requirements document.
• Designed and Developed Relational and Dimensional Data Models in Framework Manager based on client’s Reporting requirements.
• Designed and Developed List Reports, Crosstab Reports, Charts by using Cognos 8.4 Report Studio and Query Studio.
• Created Interactive Reports by building Report Prompts, cascading Prompts, Date Prompt.
• Created Corporate Performance Management (CPM) Dashboards.
• Developed Drill-Thru Reports that has Master Detail Relationship.
• Designed and Developed AdHoc query packages and trained the end users on how to develop reports in Query Studio.
• Scheduled reports in Cognos Connection based on the reports to run daily, weekly or monthly basis.
• Designed, developed and implemented an Enterprise Wide Reporting system using Cognos 8.4, Expandable (ERP) and SQL Server 2005.
• Involved in Cognos Administration. Create groups, access rights, security at data level.
• Excellent skills in retrieving the data by writing simple/ complex SQL Queries in SQL Server.
• Involved in Data modeling and design of data warehouse in star schema methodology with confirmed and granular DIMENSION and FACT tables.
• Publish the Packages to the web server to generate Reports using cognos 8.4.
• Involved in setting up Hierarchies, performing Drill and Slice & Dice operations and creating Cross Tab Reports.
• Implemented Dimensional Modeling and Relation modeling in Impromptu and created query subjects, relationships, filters and calculations in the model.
• Created Dimensionally Modeled cubes using cognos 7.3 Powerplay Transformer.
• Designed, developed and implemented an Enterprise Wide Reporting system using Cognos 7.
• Migrated various Reports from cognos 7 Impromptu to cognos 8.4.
• Created Filters, Joins, Calculations, Prompts in cognos 7.0 Impromptu.
• Outstanding experience in using SQL, PL/SQL, Indexes, Functions, Procedures and views.
• Excellent skills in retrieving the data by writing simple/ complex SQL Queries in Server 2005.
• Designed OLAP cubes, dimensionally modeled cubes using cognos 8.4 Transformer.
• Created Power Play cubes with data level security based on the user profile.
• Upgraded Cognos Impromptu Reports and Cubes from 6.0 and 7.0 to 7.1

Environment: IBMCognos 8.3,8.4.,Framework Manager, Report Studio, Analysis Studio, Query Studio, Oracle10g, Toad, Informatica, Sql Server 2005.

Confidential, (Frankfort,KY) Oct 06 – Dec 07
Report Developer/Analyst/Modeler
Confidential,the single reporting interface and repository for all education data within Kentucky. Intended to be used to enhance the efficiency, effectiveness, and service orientation of functions of KSLDS New ways to view data such as geographic mapping, prompts to slice and dice data, and the ability to view financial data, performance data and staff data via a single location. In additional analytic of student level data to authorized individuals, ad hoc analysis.
Responsibilities

• Analyzing and reviewing the business requirements, design document and functional requirements document.
• Developed metadata models with appropriate Joins, organized Folders according to the Business view and published the packages using Framework Manager onto Cognos Connection.
• Created Multidimensional reports by implementing Multi Dimensional Cubes using Power Play and Transformer.
• Used advanced report options like Table of contents, Reference objects & Report Bursting etc.
• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Crosstab Reports.
• Created Conditional formatting on List and Crosstab reports.
• Created Prompts, Calculations, Conditions & Filters.
• Enhanced the performance of the reports by changing the properties of the Query such as Auto Group & Summarize, Processing, Execution Method and Use Parameter Info.
• Developed Prompt pages, Cascading Prompts.
• Moving Reports & Packagesfrom Development to Production.
• Implemented Business Intelligence and Data warehousing concepts in the model designing and used Cognos BI Tools for Report Development.
• Provided QA Support by actively fixing and Updating Issues as per BI standards and DW Concepts.

Environment: Cognos 8.2 (Report Studio, Query Studio, Framework Manger, Analysis Studio, PowerPlay Transformer), Oracle 10g, MS Access 2007.

Client: Confidential, (LA,CA) Nov 05 – Sep 06
Cognos Developer
Confidential,is a HealthCare Services Company, which offers services such as traditional health maintenance organizations, point-of-service plans, third-party administration of employer-funded benefits plans and Medicare.
Responsibilities

• Involved in setting up the Cognos 8 BI environment. Installed and configured all the 8BI Components, Framework Manager, Analysis Studio, Event Studio, Query Studio and Report Studio.
• Development of model in both dimensional and relational in FM.
• Created Database Layer, Reporting Layer, Presentation Layer as per user requirement.
• Created Power Play cubes with data level security based on the user profile
• Built Prompt Macro at the FM level for Country (Whenever data is pulled from country query subject it should prompt for the country).
• Used parameter maps for implementing multilingual property based on the country.
• Created Query Prompts, Calculations, Conditions and Filters in the reports.
• Developed Prompt Pages and Cascaded input Prompts to display only the selected entrees in the report.
• Implemented Conditional formatting, Bursting and scheduling of the reports.
• Created drill through reports and associated with the summary reports to get details.
• Used conditional formatting, complex calculations, graphs, prompts and multiple drill downs.
• Created drill through reports and associated with the summary reports to get details
• Built shortcuts and provided the business names to the query items.
• Created various IQD in Framework Manager and from this IQD’s as source, integrated to Power Play Transformer to create various models and build cubes.
• Creating the model and publishing the Cubes to Cognos Connection to be used for multidimensional analysis.
• Involved in performance tuning of the application using governor settings in framework manager and transformer models.
• Used Transformer with a variety of sources and combined them into Multi-Dimensional Cube.
• Created and customized the data in data sources in Transformers using Packages generated at Framework level.
• Developed the Multidimensional Cubes with various Dimensions, Levels and Measures including Time Dimension with different hierarchy which enabled Drill Up and Drill Down capabilities.
• Refreshing cubes on demand and for core business processes.
• Scheduling cubes and reports as requested by the business users.
• Implementing Security in Power Play Transformer.
• Development and Testing of Reports.

Environment: Cognos 8 Framework Manager, Report Studio , Query Studio, Analysis Studio, Transformers, Oracle, SQL, PL/SQL, Windows 2003,Toad.

Client: Confidential, (Richmond,VA) Jan 05 –Sep 05
Role: Developer

Confidential,is one of the mid-south’s leading financial institutions. Design and developed reports for Capital one. Our growth allows us to focus on continuing to innovate and enhance customer service. The objective of this Project was to support Business Executives to take quick decisions.
Responsibilities

• Designed models using Framework Manager and deployed packages to the Cognos Connection Portal.
• Installed and configured Cognos 8 environment and maintain portal security.
• created user groups and provided login credentials for end users.
• Provided security to the ReportNet in Access Manager through LDAP Server and configuration settings in Cognos configuration.
• Importing data into SQL Server tables from other applications and environments.
• Worked on IBM Cognos 8 reporting against Financial data cubes with non staged Data Source and Reporting.
• Converted crystal reports to Cognos reports using migration tools.
• Collecting the data marts and creating model based on that data.
• Created database layer and business layer, defining appropriate relationship between query subjects.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database.
• Developed various Informatica Mappings, Mapplets and Transformations for migration of data from various existing systems to the new system using Informatica Designer.
• Created calculated columns based on existing items in the model.
• Extensively worked on Analysis Studio to develop multi dimensional analysis.
• Designed PPES Transformer Models using Framework Manager IQD sources and built the cubes.
• Designed Power Play reports to provide summarized results by measures and dimensions.
• Created Power Play cubes with data level security based on the user profile
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Built Power Play Reports based on the cubes and published to Report Net Server.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports, Cognos connection portal.
  Environment: Cognos 8,8.1 - Framework Manager, Report Studio, Analysis Studio, Query Studio, Report net 1.1, Cognos Transformer, Power play Window/Web, Informatica, Teradata, Impromptu7, AIX, Oracle, Windows.