SUMMARY:

• Over 8 years of progressive experience in Information technology in various sectors.
• Seven years of experience in handling Business Intelligence (BI) and Data Warehousing tools, worked with the Series of Cognos Business Intelligence suite in production, development, and test environments using IBM Cognos 10/8.4/8.3/8.2/8.0, ReportNet, Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection, PowerPlay Transformer 7x/6x, Access Manager.
• Migrated reports and cubes to IBM Cognos 10 Version from 8.4 and 8.3.
• Worked on the Cognos 10/8 Framework Manager to include the Cube source models and to create the models by importing metadata from data sources i.e. Oracle, Sql Server, and SAP BW.
• Performance tuning of Queries( SAP BW BEX and Cognos) by maintaining Aggregates, Compression, partition, indexing of info cubes and use of statistics for the same.
• Developed reports using different performance variables such as filter and prompts for better report functionality and quicker response time.
• Experienced in performance tuning of Cognos Reports with BW reporting objects.
• Strong experience in reporting with SAP BW info providers such as Info objects, Cubes, Queries.
• Expertise in reporting with Cognos 10/8 tools on different SAP R/3 functional areas combining data from different R/3 function modules (SD, FICO, MM) in BW.
• Expertise in SAP BW components like InfoCubes, MultiProviders, InfoSource, Info Objects.
• Migration experience from different environments (Impromptu to ReportNet, Power Play to Cognos8 and ReportNet to Cognos8 environment).
• Extensively worked with Framework Manager and Transformer.
• Experience with the using Relational, OLAP and DMR source in reports studio reports.
• Created Portal Pages, Dashboards and Metrics in Cognos connection.
• Developed and designed multi - dimensional cubes using PowerPlay Transformer.
• Experience with building the Transformer models and running the models on UNIX environment to build the OLAP Multidimensional Cubes.
• Used SQL and PL/SQL programming to query the database to generate reports.
• Used Perl scripting language in updating database.
• Well versed in Web languages - HTML, XML, CSS and JavaScript for creating and customizing interactive user interface for more advance and complex reports/dashboards
• Experienced in using SDK and scheduling the reports, cubes.
• Knowledge on Business process of Sales, Manufacturing, Procurement, GL, Trading.
• Exceptional ability to quickly master new concepts and technologies.
• Capable of working in a group as well as independently with excellent communication skills.

TECHNICAL SKILLS:

DW Tools: IBM COGNOS10/8.4/8.3/8.2/8.0, ReportNet 1.1/1.0x, Impromptu7x/6x/5x, PowerPlay7x/6x/5x, Transformer 7x/6x/5x, MDX,Access Manager.

ETL Tools: Informatica 7.1.2, 8.1

RDBMS: Oracle, Sybase, SQL Server, MS-Access.

SAP BW: BEx Designer and Analyzer, Infocubes, Multi Provider

Web ASP: .NET, PHP, HTML, CSS, DHTML, XML, JavaScript, Web CMS Software, Dreamweaver, Contribute, Flash

Enterprise Tools: SQL Server Enterprise Manager, SQL Query Analyzer, TOAD for Oracle

Data Modeling: Erwin

Operating Systems: Windows 2003 Server, XP,7, Unix, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

Senior Cognos Developer

Responsibilities:

• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Design and Developed the Framework Manager models using stored procedures, Relational tables and published in to server.
• Created cubes in Transformer using Framework Manager IQD's, packages and report studio reports as a source.
• Upgraded reports from Cognos 8.4 to 10 Version.
• Used Dimensional modeling (DMR) and Snow flake Schema modeling technique to develop models
• Used Informatica 8.x (Source Analyzer and Warehouse Designer) to import the source and target database schemas and the mapping designer to map the sources to the targets.
• Developed various Mappings and Workflows in Informatica as required by the Design specifications.
• Customizing Cognos Connection Portal based on user specifications.
• Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up).
• Experience in writing with HTML/Java Script in Cognos report studio reports as per the requirements.
• Developing the Dashboard reports using Cognos Report Studio and Metric Studio.
• Worked with Stored Procedure Query Subjects in FM and Reports.
• Created Drill- through reports and Customized Reports with Prompts (List. Cross tab).
• Developed Dash Board reports in Report Studio using MDX Functions.
• Created Oracle PL/SQL Stored Procedures, Functions, Cursors for use by Framework Manager Packages and Report Studio reports.
• Worked with Analysis Studio to develop multi-dimensional reporting
• Java Script for complex validation, navigation, communication and format customization.
• Performance tuning the by analyzing and comparing the turnaround times between SQL and Cognos.
• Resolved issues resulting from User Acceptance Testing (UAT).
• Performed Data validations, Unit testing and preparation of Unit test cases.

Environment:Cognos 10/ 8.4 (Framework Manager, Cognos Connection, Report Studio, Analysis Studio), Oracle 11g, Toad.

Confidential, Sacramento, CA

Senior Cognos Developer

Responsibilities:

• Involved in the Requirement Gathering from end users and design of Business RequirementDocuments.
• Extensive use of framework Manager modeling connecting BW data sources and Oracle.
• BEx - Worked extensively in Bex Designer, Analyzer in building queries and generating reports.
• Created BEx queries to generate reports for Cognos query and also tested the performance differences between Cognos and BEx.
• Created and fine tuned Infoqueries leveraging business rules in SAP BW to minimize load on Cognos BI.
• Created metric packages by importing data from external files and developed reports.
• Used metric designer to define and load data from various sources into metric studio.
• Developed data packages using frame work manager and published packages for the users to use it for ad hoc reporting .
• Implementing Data Level Security in the framework model and Report Level Security with Users Groups.
• Used Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.
• Developed Complex Reports using Custom SQL which involved Union, Intersection of multiple queries.
• Developed Procedures and triggers in Oracle for file handling, data validation, Inserting data etc.
• Performance tuning of Queries( SAP BW BEX and Cognos) by maintaining Aggregates, Compression, partition, indexing of info cubes and use of statistics for the same.
• Developed reports using different performance variables such as filter and prompts for better report functionality and quicker response time.
• Experienced in performance tuning of Cognos Reports with SAP BW reporting objects.
• Used SAP BW BEx functionalities in Cognos for enhanced Reporting.
• Strong experience in reporting with SAP BW infoproviders such as Info objects, Cubes, Queries.
• Used Data Source Query Subjects, Model Query Subjects and Stored Procedure
• Query Subjects in Framework manager.
• Used extensively SQL and PL/SQL for developing complex reports.
• Worked with Complex reports in Report Studio using master-detail relationship, drill through, burst options, cascading options and PROMPTS depending on user requirements.
• Developed web type User interface for the users using java script.
• Sound Skills in Developing Standard and Complex Dashboard Reports using ReportStudio.
• Created reports using cascaded prompts, value prompts, sections, dynamic filtering, conditional layouts and multi lingual reports in Report Studio
• Created reports containing multiple data containers like List, Cross-tab and Repeater Tables
• Test/validate system tables/files in System Test environment, UAT environment and finally in Production environment
• Deploying, Testing and Managing Cognos Connection Portal and also creating and managing Jobs and Schedules
• Exceptional ability to quickly master new concepts and technologies.
• Capable of working in a group as well as independently with excellent communication skills.
• Strong production support experience, good at trouble shooting with quick turnaround in fixing the issues
• Documented Best Practices and Reporting Governances for Cognos.
• Training end users in building the ad hoc reporting

Environment:Cognos 8.4/ 8.3 (Framework Manager, Cognos SDK, Cognos Connection, Report Studio, Query Studio, Analysis Studio), OLAP, SAP BW, Oracle 10g, BEx Analyzer, BEx Designer, Erwin, Toad, Oracle SQL Developer.

Confidential, Carlsbad, CA

Senior Cognos Developer

Responsibilities:

• Involved in gathering Business Requirements from Business Analysts and Users
• Interacted with the Business users to identify process metrics and other key dimensions and measures
• Involved in extracting and loading data from two systems oracle and SAP to Data warehouse system (EDW).
• Worked closely with Relational, OLAP, dimensional data models and BI/ DW architecture
• Used Framework Manager to build metadata model, which could be used by Report Developers in the group
• Created and published several packages in Framework Manager
• Developed Standard Templates, which laid a foundation for all reporting needs
• Developed Standard and Dashboard Reports, Charts, Drill through Reports, Master Detail Reports and Burst Reports using Report Studio and Query Studio
• Created Conditional Blocks, Filters and other prompts for dynamic selection for users
• Scheduled and Run Reports through Schedule Management in Cognos Connection
• Developed Cube for analysis of the data using reports, Packages as data source.
• Trained users on Query Studio for Ad-Hoc Reporting and involved in documentation
• Developed HTML, CSS enabled report pages for customized report content
• Extensively worked on Analysis Studio to develop multi-dimensional reporting using MDX function.
• Developed MDX scripts for generating reports based on the cubes created for every month
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports
• Migrated cubes and reports from 8.2 to 8.4 version.
• Used SDK to schedule the reports and Control-M to schedule cubes in 8.4 on Linux environment.
• Developed and deployed Cognos reports to IPAD using Roambi.
• Implemented security and granted privileges according to user classes using Access Manager (Used LDAP Directory Server)
• Enhancements of existing cubes and reports.
• Worked with team in resolving tickets on development and admin.
• Ensured all project related documentation is accurate, comprehensive, and current

Environment:Cognos 8.4/ 8.3 (Framework Manager, Cognos SDK, Cognos Connection, Report Studio, Query Studio, Analysis Studio),, Oracle 10g, Transformer 8.4/8.3,, DB Artisan, Aqua Data Studio, Erwin, Toad.

Confidential

Report Developer

Responsibilities:

• Installation and configuration of Cognos 8 Report Studio and Framework Manager.
• Involved in the Requirement Gathering from end users and design Business Requirement documents.
• Design Star - Schema out of Report Requirement Documents.
• Developed Meta - Data Model using Framework Manager, Create and Publish Packages.
• Imports Tables, Views and Stored Procedures from Different Database Schemas.
• Created Joins, Unions and Calculations in the Model.
• Created ad hoc and complex reports using Query and Report Studio for sales and trading.
• Monitored and managed dispatchers and services set and maintain security.
• Analyzed and understood the requirements and specifications to create the Reports, Quarterly Package and Dashboards on financial data.
• Created Data Sources to create the cube source packages in the Framework Manager Model for reporting needs and published packages to the Cognos Server.
• Experience with using OLAP and DMR sources for creating reports using report studio.
• Publish portals from user to user using SDK.
• Setup event based triggers using SDK.
• Developed various Power Play reports in Report Studio reports by replicating the Power Play functionality using dynamic Sorting, Ranking and with dynamic measure selection via the prompt also provided prompts in the report page so that the user can re-prompt the query from the report page.
• Developed cross tab and chart reports with Drill Down capabilities in report studio using prompts like Value prompt, Tree prompt, and Cascading prompt.
• Created various IQD package in Framework Manager and from this IQD, integrated to powerplay transformer to create various models and cubes.
• Developed advanced reports using Report Studio and adhoc reports using Query Studio.
• Constructed Dynamic reports that give users the ability to choose the columns to be displayed on the report page.
• Integrated the existing security with Cognos 8 Security.
• Developed standard templates in Report Studio for developing reports.
• Created List Reports and Cross Tab Reports and Drill Through reports.
• Created Multi-Dimensional reports using Power Play.
• Created power play models and cubes using Transformer (Power Play).
• Drill down, slice and dice and change displays.
• Created Catalog and set User profiles to grant user permissions for querying. Created Complex Impromptu Reports. Maintenance of impromptu report administration and server administration.
• Developed Impromptu Reports and published using Upfront. Implementation of Impromptu reports.
• Provided Training and End User Support with my report and also knowledge transfer.

Environment:Cognos 8.3 (Framework Manager, Cognos SDK, Cognos Connection, Report Studio, Query Studio, Analysis Studio), Report Net 1.02, Cognos Office Connection 8.1/8.2, OLAP, Sybase, Oracle 9i,, Impromptu 7.3, Transformer 7.3, Power Play 7.3,Cognos Impromptu, Impromptu Web reports (IWR), DB Artisan, Aqua Data Studio, Erwin.

Confidential

Network Support

Responsibilities:

• Implemented Active Directory domain controller with local DNS Resolution with PDC and BDC.
• Hands on experience in Windows 2003 environment and Windows 2000 pro.
• Implementing, Administering, User policies and Group policies.
• Installing and configuring DHCP.
• Installing and configuring network printers and print server.
• Design and implement the network.
• Install servers and configure all systems in network.
• Installing, Configuring & Upgrading Windows 2003.
• Installing, configuring& maintaining IIS server.
• Managing Users, Groups and system policies.
• Creating weekly server status reports and backup reports.
• Maintaining the network 120 computer systems based on windows.
• Worked on Dos 6.22, Windows 95/98/NT/XP/2000 OS platforms.
• Installation and Configuration of Windows NT 4.00 Server/Workstation, Windows for Workgroup 95/98/XP/2000(peer to peer),windows 2000 professional & Server.
• Planning, Designing & implementation of local networks using hubs, switches & other devices.
• Troubleshooting any TCP/IP related problems.

Environment:Windows XP, 2000 and Windows NT, 2003 Server.