PREOFESSIONAL SUMMARY:

• Over Six years of experience in development and implementation of Business Intelligence Applications using Cognos BI tool.
• Strong experience in Cognos BI Server Installation and Configuration, Configuring database server and web server connectivity for use with Cognos.
• Experience in the Migration of Cognos Applications fromCognos 8 to Cognos 10, Impromptu/CRN toCognos8 Environment.
• Worked with all modules of Cognos including Framework Manager, Report Studio, Analysis Studio, Query Studio and Cognos Connection.
• Involved in Metadata modeling using Cognos Framework Manager, Cognos Transformer
• Implemented Framework manager security for Data access, Object level access and Package access.
• Developed detailed design documents for reports.
• Strong experience in developing customized templates for uniformity in reporting.
• Expertise in developing Complex Reports (List, Crosstab, Drill through, Master-Detail, Charts, Maps, multi-query reports, burst reports) and Dashboards and Active Reports using Report studio
• Developed various kinds of prompts and filters to increase retrieval speed without compromising on the scope of the reports.
• Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Grouping, Drill Down, Drill Up).
• Have a clear understanding of building Dimensional Models, Data warehouse architecture.
• Experience in creating ODBC, XML, Native Metadata Data source connections.
• Possesses knowledge on various phases of Software Development Life Cycle (SDLC) including Requirement Analysis, Documentation, Design, Development, Testing, Implementation and Maintenance.
• Extensive experience in Relational Database Systems Oracle, MS-SQL Server, and database development experience with SQL, PL/SQL, SQL PLUS, Stored procedures, Packages, Triggers and Materialized Views.
• Have a sound knowledge on ETL processes and have experience working with ETL tools like Informatica.
• Expert at creating Multi-dimensional Cubes for corporate data using Powerplay Transformer.
• Experience in scheduling the reports according to user requirements and business needs.
• Involved in theCognos Administration Tasks like Creating Data source Connections, Publishing Packages, scheduling reports, User Creation, Assigning Security, Deployment of Packages and reports in different environments.
• Expertise in creating Technical, Functional and Non-Functional Requirement documents, High Level and Detailed Design Documents, User Guides and Technical Uptake documents
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.

TECHNICAL SKILLS:

Cognos10/8.2/8.3/8.4, Reportnet1.1, Framework Manager, Query Studio, Report Studio, Analysis Studio, Impromptu, Powerplay Transformer

ETL tools

Informatica 7.x/8.x,SSIS

Databases

DB2 9.5/9.7,Oracle 8/9i/10g/11g, MS SQL Server 2000/2005/2008, MySQL

Querying Tools

• Toad, SQL- Plus, SQL Developer

Operating System

• Windows 7/Vista/XP/2000/2003, Unix, Linux

Languages

• HTML, XML,C,C ++, SQL, PL/SQL, T-SQL

EXPERIENCE SUMMARY:

Confidential, Aug '2011 - Oct '2012
Pleasanton, CA
Confidential, is the largest nonprofit health plan in the United States. Kaiser Permanente Information Technology involves in developing various projects for their business users.
PO Planning project is to enable the senior level executives to view the quarterly financial Forecast data and reports. The Regional Leadership & Program Offices is looking for a more robust reporting tool, which can replace the current Excel and PowerPoint files used for reporting the Budget & Forecasting. The Budget & Forecasting will be reported in one combined report.
Role: SeniorCognos Developer

Responsibilities:

• Interacted with Business users regarding the business requirements and reporting needs and analyzed the end-user business requirements.
• Involved in Strategic Planning for Cognos Framework Model and Secured Models are created using Framework Manager.
• Creating design documents for data model, reports and Framework Manager Model and obtaining sign off from business
• Created physical layer, business layer and presentation layer, defining appropriate relationship between query subjects
• Created Packages in Framework Manager by importing metadata from different data sources
• Implemented Framework manager security for Data access, Object level access and Package level access based on the Organization Level
• Created various complex List, Crosstab, Charts and Dashboard Reports and Drill-Through Reports
• Performance tuning by writing DB2 procedures and importing it as data source and creating Native SQL in Framework Model Layer
• Creating custom calculations in Framework Manager layer to handle complex report logic shared by multiple reports
• Customized data by adding advanced prompts, Filters, Calculations, Summaries and Functions
• Deployed packages, folders and content store from a development environment to test environments
• Created various Crosstab reports and Drill through reports as per the user requirements using conditional formatting
• Modifying Business view with calculations filters to reflect business rules
• Maintaining Cognos Report Studio server in development environment and migrating reports from development to test environment.
• Used Cognos Connection to administer and schedule reports to run at various intervals of time
• Created Regular Dimension as per requirements and arranged them as per the Hierarchy defined by business users.
• Performed Drill through definitions on Multiple reports
• Set security for individual reports in Cognos Connection.
• Worked with ETL team to design datamarts by understanding user requirements and increasing the reporting efficiency.
• Worked with SSIS to extract, transform and to load data.
• Analyzing the performance requirements of the reports carrying out performance tuning by creating Materialized Query Tables, Views, Indexes and handling complex joins and logic at ETL level
• Worked with user profiles to ensure security by restricting user access to data based on the individual user.
• Involved in the Testing of the reports and updating the Bug Tracking Tool
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports

Environment: Cognos 8.4/Report Net 1.1, Framework Manager, Cognos Connection, Report Studio, Query Studio , Analysis Studio, XML,SSIS, Html, Oracle, SQL Scheduler and Windows NT/2000.

Confidential, April 2010 - July 2011
San Francisco, CA
Confidential, is a fast growing highly profitable financial holding company. Wells Fargo Corporation is one of the top financial holding companies in the country. Wells Fargo's operating strategy distinguishes it from other financial holding companies.
The Metrics Dashboard Project used Cognos 10 suite to develop a dashboard showing several business metrics.
Role: Cognos Developer

Responsibilities:

• Analyzed the business functional requirements and worked with the business units to define the strategy of the business and created centralized reporting capability.
• Involved in administration tasks like creating data source, publishing packages, creating users, role based user security and scheduling the reports
• Modeled the metadata in the project by adding business rules such as filters and calculations.
• Build power cubes with package as source using power play transformer.
• Created Framework packages with various security settings and published onto Cognos connection
• Created database layer, business layer and presentation layer, defining appropriate relationship between query subjects in Framework Manager
• Created Active Reports, List, Crosstab, Dashboard Reports and Drill-Through Reports using advanced reporting techniques in Cognos
• 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
• Created several burst reports using Cognos.
• Involved in the migration of Cognos 8 to Cognos 10
• Performance tuning of reports at Reporting layer and Framework Manager Model layer
• Extensively worked on the complex prompt page design of various reports
• Provided security at different levels for Cognos reports and Framework model
• Analyzed the particular problems with the ETL, Database and the Development teams regarding the issues and solved the problems efficiently
• Monitored the ETL loads using Informatica Workflow monitor.
• Scheduled and distributed reports using Schedule Management in Cognos connection.
• Created Test Plan and involved in test cases preparation and execution of the test plan
• Created the documentation in specific format for end users.
• Handled deployment of packages in different environment, user training, knowledge transfer, support and transition activities

Environment: Cognos 10.1/8.4, 8.3 (Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Connection, Framework Manager),Power Play transformer 10.1/8.3, Oracle 10g, SQL Server , PL/SQL, Html, Toad ,Informatica, Windows 7/XP.

Confidential, Jan 08 - March 2010
Atlanta, GA
Confidential, is the largest provider of fixed telephony in the United States. It has a huge network and provides services globally. In order to provide critical information like daily revenue, total sales, goals, information on employees and new plans, AT & T has developed Business Intelligence System based on Cognos suite of products.AT & Tspecializes in Telecommunications billing solutions. Project involved participation in the development of decision making support solutions, giving mainstream users the ability to access, analyze and share information in the company's database. We developed reports for billing, payroll, sales, orders, and marketing and gross profit analyses.
Role: Cognos Developer
Responsibilities:

• Gathered Business requirements and designed functional and technical requirement and design documentation
• Designed DMR data models and Published Packages using Framework Manager.
• Involved in administration tasks like creating data source, publishing packages, creating users, role based user security and scheduling the reports
• Created SQL scripts to validate the data from the integrated data mart through Cognos reports
• Created Ad-hoc Framework Manager Model and trained users to work in Query Studio
• Worked on Quality Centre for QA related tasks
• Involved in development of life cycle (SDLC) within Cognos reporting Framework from developing business requirements to QA and production environment.
• Applied three levels of security to the model (Data, Object and Package).
• Installed Cognos 8 Metric Studio, Report Studio, Query Studio and Cognos Connection
• Provided the prompts, filters, drill up/drill down in Query Studio.
• Created different types of reports like predefined Filters for the Ad hoc users, List, Cross-tab, Chart, Drill-Through, Scorecard, variance and Master-Detail Reports for production using report studio.
• Created multiple Dashboard reports for multiple packages.
• Created scorecards to calculate the actual and target sales reports in Metric studio.
• Developed Prompt Pages, Cascaded input Prompts to display only selected entries in the report and also worked on the customization of prompt parameters.
• Created multi page, multi query, Prompts, drill through Report Studio report for corporate marketing, Sales and Products.
• Created Cubes using Power Play and Transformer for multidimensional reports.
• Created calculated fields in Transformer for the analytical data based on measures, Levels and dimensions.
• Involved in Migrating Reports, Cubes from Cognos series 8 to Cognos 8.4.
• Scheduled reports using the Schedule Management tool, Event Studio in Cognos Connection
• Performed unit testing and documented test cases and detail design of the project.
• Deployed reports, packages and folders from DEV to UAT and from UAT to PROD environments.
• Worked on Quality Centre for QA related tasks
• Designed and Prepared a Training Material for the Users

Environment: Cognos 8.4 (Framework Manager, Report Studio, Query Studio, Metric Studio, Analysis studio), Cognos 8, Power play, Transformer, Toad, ORACLE10g, PL/SQL, SQL.

Confidential, Aug 06 - Dec 07
Pittsburgh PA
DelMonteFoods is one of the most well-known producers, distributors and marketers of premium quality, branded food and pet products for the U.S. retail market. This project has two phases. The first phase involves developing of custom reports for employee time and attendance which is kronos time and attendance reporting and second phase involves standard finance reporting which has pet and consumer product reports. Finance has to run these reports in order to obtain the consolidated forecasted and committed amounts for these products for each brand.
Role: Cognos Developer
Responsibilities:

• Involved in business requirement gathering by interacting with managers across the Del Monte facilities to develop reports.
• Developed and published packages onto Cognos connection using framework Manager.
• Developed complex reports using report studio.
• In order to provide optimal flexibility and usability all the reports are generated in Excel so that the users can further manipulate the data using Excel functions if they so choose.
• Created complex filters, Conditions and complex financial calculations for developing the reports using report studio as per the user requirements.
• Used Conditional formatting to discard unwanted columns in the report using style variables and used render variable on some report pages to render the page based on the user selection.
• Developed List, Cross Tab, Chart and Drill Through Reports in Report Studio
• Applied different types of prompts like text box prompt, value prompt, select and search prompt, date prompts.
• Worked with Sorting, Conditional Formatting, Conditional block
• Extensively used cascading prompts, drill-through, filters, summaries, grouping and sectioning features to generate efficient and user friendly reports.
• Created complex reports by using multiple queries and joins.
• Worked on scheduling and publishing the reports to Cognos connection.
• Designed and created dashboard style complex reports to provide information on key performance indicators.
• Worked closely with IBM Cognos support team.
• Involved in Production Support which involves solving user problems.
• Involved in UAT by writing complex queries.
• Created User Documentation describing the functionality of each report developed.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports

Bachelor's Degree
Master's Degree in Computer Sciences