SUMMARY

• 7 years of experience with Business Intelligence tools like Cognos 8.x (Report studio, Query Studio, Analysis Studio, Event Studio, Metric Studio, Framework Manager), Cognos ReportNet1.1 MR1(Framework Manager, Report Studio, Query Studio), Impromptu Administrator, Power Play, Transformer, Power Play Enterprise Server (OLAP)
• Expertise in creating complex reports like Executive Dashboards, Cross tab reports, Top ten reports, ad-hoc reports, Charts and Score card reports using Report Studio.
• Strong working experience in Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, Physical and Logical Data Modeling, Fact and Dimension tables.
• Expertise in Report Net (Framework Manager, Query Studio, Report Studio, Cognos Connection).

Strong experience in generating various reports (Dashboards, Master-Detail, etc) using ReportNet.

• Usage of Query Studio to build ad hoc Business reports and Report Studio to build advanced reports (multi-page, multi-query reports) against multiple databases.
• Experience in deploying packages from one environment to other.
• Involvement in designing models and developing of various kinds of Impromptu catalogs.
• Expert in all stages of Software development life cycle (SDLC) which includes requirement analysis, design, development, testing and documentation.

Experience in Migration of the applications from Cognos Series 7 to Report Net and 8BI.

Designed the architect model, developed the Cognos Query and PowerPlay packages for production and demonstrations.

Extensively worked on performance tuning for existing reports in Report Studio and Testing and improving Report Performance and performing Query optimization.

Experience in testing and validating Cubes, Framework Manager Models and Packages.

• Experience in coming up with data cleansing, backup and restoration strategies.
• Good knowledge on Cognos 10 Business Insight, Business Insight Advanced, Active reports.
• Excellent Verbal and Communication skills with strong potential to learn new technology and adapting to new tools/environment.

Ability to meet deadlines, multi tasking, flexible in work schedules, team player and posses good communication skills.

TECHNICAL SKILLS

Cognos Tools: Cognos 8/10 BI, Framework Manager, Query Studio, Report Studio, Cognos Connection, Cognos UI, Analysis Studio, Event Studio, Metric Studio, Cognos Report Net, Cognos Impromptu, Cognos Power Play Transformer, Impromptu Web Reports (IWR), Upfront Server Administration, Power Play Enterprise Server, Access Manager.

Databases:

Oracle 8i/9i/10g, Teradata, SQL Server 2000/2005/2008

Data Modeling:

Erwin, Toad Data Modeler, Star schema and Snowflake-Schema Modeling

Languages:

C, C++, PL/SQL, SQL, HTML, JavaScript

Operation Systems:

Windows 2000/NT Servers,Windows NT/95/98/XP, Windows XP Professional, Unix

EDUCATION

• Bachelor of Technology in Information Technology.

PROFESSIONAL EXPERIENCE

Confidential,Phoenix, AZ Mar 12 – Till date
Cognos Developer
Confidential,is The World’s Biggest Hotel Family with more than 4000 hotels in over 100 countries. The project was about migrating the whole system from Cognos 7 to Cognos 8 and rectifies the defects and makes enhancements for better performance.
Responsibilities:

• Worked closely with Project manager, developers and users to understand the business and identifying some common production support tasks.
• Performed the Quality Analysis by comparing the existing cubes to new Cognos 8 cubes and validating by testing overall and individual dimensions along with date dimensions.
• Tested Measures with different dimensions and context filters using analysis studio.
• Tested and Validated the Framework Manager models by comparing the existing model and new model in the Development environment.
• Generated list reports using Report studio to test the Join Strategy in the Framework Manager models.
• Tested the usage and filter settings for each query item to ensure proper auto-grouping and summary are performed as expected.

Unit Tested in Analysis Studio to help improve Data Consistency.

Identified the differences in generated SQL and rectified the models.

Created tickets using HP Quality center for the defects in DEV and QA environments.

Co-ordinated day to day activities with off-shore team and performed knowledge transfer on any new changes and developments.

Environment: Cognos 8.4, Framework Manager, Connection, Report Studio, Analysis Studio, PowerPlay Transformer, MS Word, PL/SQL, Windows 2000,HP Quality center.

Confidential,Boston, MA Mar 11 – Feb 12
Cognos BI Developer
Confidential,a product developed by MetraTech Corp. offers a new approach to charging, billing, settlement and customer care that enables organizations to embrace change without compromise. MetraNet automates business processes and business models that address rapidly changing, complex or radical business strategies across any industry for an unlimited number of services.
Responsibilities:

• Worked closely with client resources and business analysts to analyze and understand business requirements
• Customized data by adding Filters Calculations, Prompts, Summaries and Functions.
• Generated various reports List Reports, Grouped Reports, Cross-tab Reports, Chart Reports, and Drill -Through Reports.
• Added prompts and filters to modify existing reports to accommodate change in user requirements.
• Used Analysis Studio to create Analysis from PowerPlay Cubes
• Created complex multipage reports using multiple list reports and multiple queries to associate each of the list report
• Created simple to complex reports as well as Dashboard like reports using Report Studio by applying various concepts and functionalities such as drill-through, conditional reporting, block, tables, master-detail, charts, various calculations and joins using tabular sets and tabular models
• Created dashboards (crosstabs and charts) to display the business details from different aspects and using different representations
• Created Prompts with static choices and conditional variables for rendering the multipage reports
• Used Filters for efficient retrieval of data and conditional variables for hiding summary totals for report
• Created professional reports in Report Studio and ad hoc reports in Query Studio

Implemented Data Level Security, Object Level Security and Package Level Security

Modified existing Cubes to comply with changes in the Requirements

Performed scheduling and maintenance of reports using Cognos Connection and Microsoft SharePoint based support portals

Involved in Installation of Cognos 8.4 Frame Work Manager, Report Studio, Query Studio, Cognos Connection

• Performed Unit testing for all developed reports
• Involved in deployment process of all the reports and packages from Development to production server.
• Upgraded reports and models from Cognos version 8.4 to Cognos 10.
• Worked onCognos 10Active reports.
• Created several reports using Cognos 10.

Environment: Cognos 8.4/10, Framework Manager, Connection, Report Studio, Query Studio, Analysis Studio, PowerPlay Transformer, MS Excel, SQL Server 2000, Adobe Acrobat, Windows 2000, Windows 2003 Server

Confidential,Allen, TX Jan 10 – Feb 11
Cognos Developer
Confidential,provides local phone service, local bundled phone service and dial up internet access. The project was to support the new initiative by Sage to move their BI Competency Center to a new vendor with most of the production support activity being moved off-shore.
Responsibilities:

Worked closely with the on-site coordinator in understanding the application inventory and identifying some common production support tasks.

Installed and configured QA Cognos 8 environment.

Used Framework Manager to build models, packages and publish packages to the Report Net Server.

Built models containing with complex security requirements from imported metadata.

Modified packages to suit the business needs and improved the performance of the reports by defining filters and adding calculations.

Conversion of existing Impromptu Reports to report studio reports.

Developing Standard reports, Charts, Drill through reports, Master Detail reports Using Report Studio and ad hoc reports in Query Studio

Created list reports, cross tab reports, chart reports using Report Studio.

Created query prompts, calculations, conditions & filters, prompt pages, using Report Studio for several reports.

Created Complex reports using custom prompts and Tabular Objects.

Scheduling and distributing reports through Schedule Management in Cognos Connection.

Developing Multi-Dimensional Analysis and building Power Cubes using Cognos Power play and Transformer and created the drill through reports for the cubes

Associate with ETL team to create data marts build a data warehouse environment and provide constant updates about the necessary changes required

Co-ordinated day to day activities with off-shore team and performed knowledge transfer on any new changes and developments.

Environment: Windows NT/2000, UNIX Server, Cognos 8.2 (Frame Work Manager, Report Studio, Query Studio), Cognos Suite7 (Impromptu, Power play, Upfront, Access Manager) Sqlserver 2000 SSIS, Oracle9i.

Confidential,OH Sep 08 – Dec 09
Senior Cognos Developer
Confidential,initiated STARS (State Tax Accounting and Revenue Services) project in 2009 to greatly enhance access to variety of data, to enable quicker and better informed management decision-making to generate additional Tax Revenue and reduce technology, maintenance and training costs by consolidating hardware and software systems into a single system. Improve service levels and accuracy of tax administration by adopting one database which provides records on any Taxpayer that are integrated, consistent and accurate. To provide an easily adoptable system that increases opportunities to interact with internal customers and provide more ‘self-service’ features for external customers.
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.

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 and sending via e-mail 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 various IQD in Framework Manager and from this IQD’s as source, integrated to Power Play Transformer to create various models and build cubes.

Worked with user profiles to ensure security by restricting user access to data based on the individual user.

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.

Set security for individual reports in Cognos Connection.

ENVIRONMENT: Cognos 8.3 and 8.4 (Report Studio, Framework Manager, Analysis Studio) PowerPlay Transformer, XML, HTML, SDK, Oracle Database, Windows Server. Confidential,Parsippany, NJ Jan 08 - Aug 08 Cognos Developer

Confidential,a global strategy and technology consulting firm, was founded in 1914 with more than 19,000 employees on six continents currently and generates annual sales of $4 billion. They provide services to the world\'s leading corporations, government and other public agencies, emerging growth companies, and institutions.
Responsibilities:

Troubleshoot performance issues pertaining to Report Studio performance within Cognos 8.3

• Assist in resolving and escalating Cognos CRN and Cognos 8 support tickets.
• Provide guidance in Framework Manager modeling.

Assist in infrastructure upgrade from Cognos 8.2 to 8.3 and randomly test reports in Cognos 8.3

Interacted with the Users, Project Manager to get a better understanding of the Business Processes.

Set up meetings with Cognos teams and explain the ongoing and new issues and creating status reports.

Created Dashboards and modified the existing Dashboards using Report Studio.

Created Drill through Reports and also used Conditional Formatting extensively.

Modified existing prompts, calculations, conditions & filters in the report.

Unit Tested in PowerPlay and in Analysis Studio to help improve Data Consistency.

Environment: Cognos 8.3, Framework Manager, Report Studio, Query Studio, Reportnet, MS Access, Windows 2K

Confidential,India Oct 06 – Dec 07
Cognos Developer
This project was developed based on total automation of hospital management. It was a comprehensive package, which dealt with inpatient, outpatient, laboratory, pharmacy, operation theatre and administration modules. My job was to work on outpatient, inpatient modules and reports related to above. I was responsible for creation of Impromptu reports, which provided users the ability to access, analyze, and share information in the company’s database.
Responsibilities:

• Created standard filters, calculations, prompts and conditions.
• Worked on creating Impromptu Reports using Prompts and Cascading Prompts.

Designed catalogs and defined User Classes, Security and Privileges.

Created Impromptu Web Reports and published them on the web server and later on upfront.

Created News boxes in Upfront and customized the environment. Set Security for News Item and New boxes in Upfront. Set Privileges for user classes by defining News Index Admin.

Created Multi Dimensional Cubes using Power play Transformer for multidimensional (IQD) reports.

Published cubes and created Power play Reports for the web users.

Involved in Migrating reports from Impromptu/CRN to Cognos 8.

Created Business Mix reports and Top ten reports.

Used mapping designer and Mapplets to generate different mappings for loading.

Developed the different sales report in Impromptu in line with variation in time and business strategy

Developed Impromptu Query Definition Files and imported those files in to Transformer and created a Cubes using Power Play.

Created List Reports, Cross Tab Reports and Drill Through reports.

Associate impromptu reports to drill through form one report to another.

Environment: Cognos Impromptu 7.3, Power play, transformer, Access manager, Windows NT, SQL server 2000, Upfront Server 7, PL/SQL.

Confidential,India Jun 05 - Sep 06
Cognos Developer
Confidential,provides the entire project implementation, including project design, development, testing, deployment and support. Human Resource Management System enables any consultancy firm to maintain human resource details effectively. This application is divided into 3 modules Admin, Client, Employee. As a part of Data warehouse team designed and created various Metadata models and packages, generated reports out of them and migrated and tested reports in Cognos Impromptu.
Responsibilities

Analyzed & defined customer requirements/ specifications & offered solutions to fit the customer’s need.

Designed Catalogs, Reports and IQDs using Impromptu Administrator.

Created standard filters, calculation, prompts, and conditions.

Published reports to the upfront web portal to provide accessibility to the staff.

Created cascading prompts in Impromptu reports to help users refine their search.

Created Drill-Through reports to provide users with more detailed information.

Published Impromptu Web Reports using Distribution Shuttle Builder created posting folders.

Developed reports for purchase orders, sales orders, and goods issued and goods receipt.

Coded database procedure to calculate average purchase price of material for current financial year for costing purpose.

Trouble shoot and evaluated report effectiveness by tuning query data’s and controlling user access.

Environment: Cognos (Impromptu, Power Play, Upfront, IWR), MS SQL Server, MS Excel, MS Visio, Windows.