PROFESSIONAL PROFILE:

• 8+ Years of experience in Business intelligence reporting, development, analysis, design, testing, implementation maintenance of Cognos Web applications, Database, Data warehouses , Data Marts and providing solutions for Finance, Banking, Insurance , Pharmaceuticals and Retail.
• Experience with Cognos Tools such as Cognos 10.1/8.4/8.3/8.2 Suite, Cognos Report net 1.1.MR3 and Analysis tools such as Cognos Transformer.
• Developed and Published Packages using Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and created filters, prompts, calculations, summaries and functions in Framework Manager.
• Complex Report Building Experience by using native SQL, Filters, Prompts, Conditional Formatting, Dashboard Reporting using Master/Detail queries, Ranking, Drill-through, Cross tabs, Bursting and performance tuning the cognos reports
• Expertise in OLTP/OLAP system study, analysis and developing Database schemas like Star Schema and Snowflake Schema.
• Expertise skills with Transformer, analysis studio.
• Have solid experience with data profiling, data validation through native SQL queries in the oracle environment. Ability to troubleshoot data problems in the cube against oracle data warehouse and source systems.
• Creating the Complex Report studio reports using the different MDX expressions using the cubes as the source data.
• Experience in creating and translating information from various corporate systems and data into visually rich Dashboards using maps, charts, cross tabs and lists and other graphical elements.
• Involved in migration and deployment of applications from BI Series 7 to Report COGNOS8 and COGNOS8.2 to COGNOS 8.3 and 8.4 Versions.
• Excellent Team Coordinating Skills with the Development Teams and Deliverable dates.
• Strong understanding of data warehousing concepts, principles and techniques.
• Experience in Upgrades reports from 8.1 to 8.2, 8.2 to 8.4.
• Writing and executed the different Test scenarios (Unit, System & Integration and UAT).
• Strong problem solving skills, ability to develop strategies for clients, and provide detailed documents to clients.
• Excellent team player at all levels with ability to perform independently. Exceptional communication, analytical, presentation and problem solving skills.
• Proficient at developing and implementing training programs to enhance the efficiency, competency and motivation levels of the employees in line with organizational objectives. A keen communicator with honed problem solving & analytical abilities.

TECHNICAL STACK:

Operating Systems: Windows 2003 Enterprise Server, XP, 2000, UNIX
Databases : SQL Server2005, Oracle 9i/10g
Cognos Tools : Cognos 8.4 Suite, Cognos 8.3 Suite, Cognos 8.2 Suite, CRN 1.1 MR3, Cognos EP Series 7.3
Servers : Application Servers (WAS, Tomcat), Web Servers (IIS, IHS)

PROFESSIONAL EXPERIENCE DETAILS:

Confidential, Permanente, CA Jan 11 - Till Date
Cognos consultant

Responsibilities:

• Gathered requirements from analysts.
• Determining functional report requirements, writing functional specifications, developing, customizing, and testing reports using the Cognos 8 tools.
• Implemented security in FM model and reports.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Created and Published Packages from Cognos 8 BI Modelling.
• Developed multi dimensional models in Cognos 8.4 Framework manager and cognos 8.4 Transformer.
• Created Metadata Modelling by using Multiple Databases in Cognos 8 BI Modelling
• Working with performance tuning the Cognos cubes and Cognos reports.
• Created Complex Reports using Cognos 8 BI Report Studio and Ad-hoc web based reports using Cognos 8 BI Query Studio.
• Analyzed the data in Analysis studio using CUBE or DMR.
• Manually modified SQL in Report Studio to tune and/or to write complicated reports. Used Union queries in Report Studio.
• Created the dashboard reports using the Cognos connections by creating the new pages in Cognos connection.
• Created Trend line charts, Histogram chart reports and dash board reports using HR data in Report Studio.
• Slicing the Cognos cube data with Cognos report studio
• Tested and validated the report output against the database to measure performance of reports.
• Responsible in creating reports using Active Reports in Cognos 10.1 using Report Studio.
• Involved in creating cognos Business Insight in cognos 10.1
• Converted existing reports to an Active Report in Cognos 10.1
• Developed various Complex report types ranging from simple Lists, Cross-tabs through complex dashboards, drill-through, Master-detail & conditional formatting reports.
• Created Scheduled Jobs by scheduling multiple reports in a job.

Confidential, Cognos 10.1/8.4, Cognos Framework Manager, Query Studio, Report Studio, Analysis Studio, and Cognos Transformer, Cognos Report Studio 8.4 BI (Framework Manager, Report Studio and Query Studio), (SQL, PL/SQL), SQL Server.

Confidential, Permanente, Oregon Aug 09 - Dec 10
Cognos consultant

Responsibilities:

• Developing a logical model that conforms to star schema concepts, different views (Foundation, business, and Presentation layers) as per Business requirement.
• Analyzing requirement Specification document and preparing the Specification document as per the Business requirement.
• Creating the Dash board reports using the Report Studio and Cognos Connection which helps the user to analyze the Specialty Care data.
• Creating the different types of reports like Service availability, Average waiting days and different utilization reports as per the business requirements.
• Writing the SQL scripts in Frame work manger as per the business requirements and used as source data to the Dashboard cube.
• Writing the SQL scripts to load the data into the summarized tables to optimize the cube built time.
• Adding the new Hierarchy to the existing cubes as per the report and business requirements.
• Creating the manual categories and special categories to meet the business requirements and reporting needs.
• Built metadata models, modified, and published several packages using Framework Manager according to the business needs which can be used by Report Developers and the business users
• Upgraded all Cognos 8 Packages, Reports and Folders from 8.2 to 8.4
• Developing Dash Board reports in Report Studio using MDX Functions.
• Creating the Report Studio reports using the Cube as a data source.
• Created Complex Dashboards using Cognos connection like displaying Cognosnavigator, Cognos search & Cognos viewer in a single page.
• Ensuring clear query paths by resolving ambiguous relationships (loops, reflexive and recursive).
• Defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio, Burst Reports against database.
• Creating prompts with query macros by including references to parameter maps.
• Creating the Bar charts and list and cross tab reports using Cognos Report Studio and Analysis studio.
• Applied Security in Cognos Connection by controlling privileges for users, groups and roles to the various packages, reports & dashboards.
• Performance tuning the by analyzing and comparing the turnaround times between SQL and Cognos.
• Deploying the reports and package from Development to testing, Testing to Production environments.
• Estimating the time lines for the reports and framework manager models.
• Issue tracking and set up the meetings on weekly basis.
• Diagnosing and resolving any design problems using techniques like show scope, count,reference and by generating categories.
• Unit testing, Integration testing and system testing of the reports in Development, Performance and production environments.

Environment: Cognos 8.4 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio, Transformer), Cognos Report Studio 8.2 BI (Framework Manager, Report Studio and Query Studio), Cognos Transformer, SQL Server.

Confidential, Oregon Jan 09 - Aug 09
Cognos Developer

Responsibilities:

• Installation & Configuring the Cognos 8.4 on windows Environment.
• Analyzing requirement PDM (Physical Data Modelling) documents and creating the Framework manger model.
• Designing the EIS (Enterprise Information System) model as per the business requirement.
• Import Views to the Framework manager model and set the cardinality between them as per the business requirements.
• Creating the Database layer in framework manger for different Subject areas like Product, Sales Order and Customer etc.
• Created Business layer and Presentation Layer query subjects as per reporting requirements in Framework Manager.
• Design and Developing the EIS Dashboard Reports for Key Performance Metrics.
• Creating the List Reports, Charts, Drill Through Reports and Multilingual Reports Using Report Studio and Query Studio.
• Setting up cardinality (minimum, maximum & optional), Determents to avoid double counting, support loop joins, optimize data source, and identify dimensions and facts.
• Created special categories in Cognos Transformer cube for use in Report Studio reports.
• Upgrade Cognos 8.2 reports to Cognos 8.4.
• Bug fixing of the migrated reports from Cognos 8.2 to Cognos 8.4.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio, Burst Reports against database.
• Creating prompts with query macros by including references to parameter maps.
• Performance tuning the by analyzing and comparing the turn around times between SQL and Cognos.
• Deploying the reports and package from Development to testing, Testing to Production environments.
• Experience in writing with HTML/Java Script in Cognos report studio reports as per the requirements.
• Creating the Cognos Report studio reports for EIS model.
• Unit testing, Integration testing and system testing of the reports in Development, Performance and production environments.
• Trained Users on Query Studio for Ad-Hoc Reporting.

Environment: Cognos 8.4 Suite, Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Cognos Access Manger, Windows 2003 Server, Unix Shell scripting, SQL Server, Cognos SDK.

Confidential, NY Jun 07 - Dec 08
Cognos Developer

Responsibilities:

• Developing a logical model that conforms to star schema concepts, different views (import, business, external) as per Business requirement.
• Analyzing requirement Specification document and preparing the Specification document as per the Business requirement.
• Working experience with installation of the Cognos 8BI and administering the Cognos Services.
• Creating star schema grouping for better understanding of the model & facilitate multi-fact (cross-fact) reporting.
• Customizing the Cognos Reports using the Java Script.
• Developing the List Reports, Charts, Drill Through Reports, Master Detail Reports and Multilingual Reports Using Report Studio and Query Studio.
• Developing the SQL scripts as per the business requirement.
• Creating the DMR model using the Cognos Framework manger.
• Preparing the Entity Definition Sheet for Reporting tables.
• Developing Dash Board reports in Report Studio using MDX Functions.
• Creating the Report Studio reports using the Cube as a data source.
• Creating the Report Studio reports using the MDX functions.
• Setting up cardinality (minimum, maximum & optional), Determents to avoid double counting, support loop joins, optimize data source, and identify dimensions and facts.
• Ensuring clear query paths by resolving ambiguous relationships (loops, reflexive and recursive).
• Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio, Burst Reports against database.
• Adding business rules by defining different kinds of calculations and filter.
• Creating prompts with query macros by including references to parameter maps.
• Developing the reports using various templates like list report, Cross-tab Report and Chart Report.
• Developing the Dashboard reports using Cognos Report Studio and Metric Studio.
• Working experience with different date functions in Report Studio.
• Creating the Bar charts and list reports using Cognos Report Studio and Analysis studio.
• Extensively working with Stored Procedure Query Subjects in FM and Reports.
• Performance tuning the by analyzing and comparing the turnaround times between SQL and Cognos.
• Deploying the reports and package from Development to testing, Testing to Production environments.
• Based on proto type refining the model by creating dimension map (dimensions, drill down path, alternate drill downs) and measures.
• Diagnosing and resolving any design problems using techniques like show scope, count, reference and by generating categories.
• Creating cube groups where the child cubes were intended for different users.
• Unit testing, Integration testing and system testing of the reports in Development, Performance and production environments.
• Trained Users on Query Studio for Ad-Hoc Reporting.

Environment: Cognos 8.3 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio), Cognos 8.3 Suite, Cognos Transformer 8.3, DB2 8.1.

Confidential, Peoria Jan 06 - Jun 07
Cognos Consultant

Responsibilities:

• Reports, Score card reports that will replace Caterpillar Insurance's Management Profitability Reports and Hotsheet. These will be presented to the end user through the Cognos portal.
• Pre-prepared reports to enable creation of monthly BEC presentation.
• The 1st generation of data warehouse schema with identified conformed dimensions.
• Development of documented support processes.
• Ensuring clear query paths by resolving ambiguous relationships (loops, reflexive and recursive).
• Developed Dash Board reports in Report Studio using MDX Functions.
• Writing the SQL scripts as per the business requirements.
• Designed Meta Data Model's - Packages in Framework Manager.
• Administer Security in Reports based on the user role (Executive, Team Leads and Manager).
• Java Script for complex validation, navigation, communication and format customization.
• Performance Tuning of complex reports.
• Writing the SQL scripts using the Teradata.
• Export and Import of Packages / Reports for Auto / Manual Deployment to UNIX Box (Dev, QA and PROD).
• Followed the proper coding standards while creating the reports.
• Content Store Migration from CRN 1.1 to Cognos 8 BI Version.
• Writing the batch file script from CRN 1.1 to Cognos 8 BI for migration.
• Dimensional Modelling of 8BI Packages.
• Creation of Transformer Cubes from IQD's /Cognos Connection Package.
• Customizing user class security views in Cube by user classes / Roles.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
• Developedthe reports using analysis studio.

Environment: Cognos 8.3 Suite, Framework Manger, Report Studio, Query Studio, Analysis Studio, Cognos Series 7.3(Transformer), Cognos Access Manger, Oracle 9i, Siebel CRM.

Confidential, Chattanooga Jan 05 - Dec 05
Cognos Consultant

Responsibilities:

• Designed models using Framework Manager and deployed packages to the Report Net Servers
• Implemented Framework manager security for Data access, Object level access and Package access.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager. Model.
• Involved in migration of Catalogs, reports from Cognos Series 7/CRN to Cognos 8 using Migration Utilities.
• Created Dashboard reports using the Cognos Report Studio and Metric Studio.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• 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.
• Created custom templates and custom tool boxes for the use of reporting.
• Extensively worked on Analysis Studio to develop multi dimensional reporting.
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports (MOLAP - ROLAP).
• Writing the Batch script to update the cube on daily basis.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Database analytical skills with ability to apply skills to developreports in Crystal.
• Moved Packages and reports from development to QA and then Production servers.
• Deployed the cube from Testing Environment to Production Environment using Batch script.
• Involved in writing Stored Procedures and functions in Oracle PLSQL.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.

Environment: Cognos 8 BI, Framework Manager, Oracle 9i, Report Studio, Transformer 7.3, Analysis Studio, Cognos XML, Generic/Cognos JavaScript, PeopleSoft.

Financial Analyst and planner March 04 - Jan 05
Confidential, San Francisco, California

• Excels in analysis and review of financial statements including revenues, costs, expenses, and tax rates for company projects; recommends and implements improvements as required.
• Performs monthly and quarterly financial and ratio analyses to identify areas in need of improvement in order to meet required financial targets; additionally determines weekly profit and loss.
• Developed a Capital Budgeting Analysis through NPV to determine current worth of projects; developed tools to analyze and measure ROI and ROE.
• Reduced corporate expenses by 11% through more accurate expense budgeting and leveraging of cost reduction analysis.
• Increased annual revenues by 2.4%; developed analysis tools that more accurately measure ROI/ROE leading to improved performance.
• Create and analyze quarterly reports; identify key factors for performance improvement.
• Prepared financial statements in compliance to the GAAP.
• Develop and implement project expense budgets for the Information Technology, Human Resources, and Operations Departments.
• Environment: MS Visio, MS Office, HP quality center, MS Project, Archer

Education: BBA in Finance

Reference: Available upon request.