Manager Power

Nirmal Singh

cell: 516-***-**** **********@*****.***

US Citizen, Charlotte, NC

Summary

BI Developer(Power BI/Cognos/SAP BI/BW/CRYSTAL /Tableau/SSRS/SSIS/SSAS around 15 years of experience in IT includes extensive Functional and Technical experience in Data Warehousing, Business Intelligence (BI), Decision Support Systems (DSS) and Customer OLAP, ROLAP, product development and Reports Generation.

5 Years of Experience in creating reports, dashboards, datasets in Power BI desktop using various visualizations, themes, wallpapers, filters etc.

Experience in publishing the reports on to Power BI service and work in multiple workspaces.

Experience in creating measures and writing complex DAX code to achieve business requirements in Power BI desktop tool.

Experience in performance tuning of Power BI reports using Performance Analyzer, DAX studio and Vertipac Analyzer.

Understanding of the M-language and reviewing/wiring/modifying M-code as needed in Power BI desktop tool.

Experience in Data Modelling, cleaning (shaping), transforming in Power BI desktop tool.

Experience in managing query relationships with various cardinality and cross filter direction (Single and Both) in Power BI desktop.

Experience in working with different kind of data sources like Excel, Database (SQL Server, Oracle, DB2), dimensional data source (SSAS) and Web in Power BI Desktop.

Implemented row level security in Power BI desktop and published to Power BI service.

Experience in working with different storage modes in Power BI like Direct Query, Import and Live Connection.

Experience in working with large Power BI dataset for self-service reporting in Power BI Service.

Experience in using on-premise data gateway to refresh dataset for reports in Power BI Service.

· Over 10 years of experience in manufacturing Industry as Business Analyst/Report

writer from COGNOS 8.4/10.2. Created DMR/CUBE in COGNOS Transformer. Created

Database layer, presentation layer & Business layer in Frame Work Manager

Developed & implemented ETL logics in IBM Data Stage.

· Over 9 years of experience in the Analysis, Design, Development, Testing, Reporting and Maintenance of Applications in Client Server, RDBMS systems.

· Excellent Environment Expertise in UNIX and WINDOWS.

· Over 10+ years of experience with BI Tool COGNOS 8.x, Report Net 1.1/ EP Series 7 including Framework Manager, Impromptu Administrator & Impromptu Web Reports (IWR), Analysis tools such as, Analysis Studio, Metric Studio, Power play Transformer, Power Play Enterprise Server, COGNOS, Go Office.

· Involved in full life cycle of Data Warehouse Project, which mainly deals with forecasting and created reports on the forecasting comparing any Demand to any Forecast.

· Involved in Installation, Configuration, and Administration of COGNOS Series 8 and COGNOS 10 Suite.

· 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.

· Extensively worked on COGNOS Report Studio 8.2/8.3/8.4/10.2 built various types of reports.

· Created Multi Page tabbed Port let Dashboard Reports in COGNOS 8.3/8.4/10.2

· Created Dashboards using Report Studio. Used functionalities like drill through, drill down.

· Applied conditional formatting, conditional blocks, and different kinds of prompt for different functionalities in the reports.

· Written Java Scripts for additional functionality for Reports using Cognos 8.3 Report Studio

· Expert at creating Multi-dimensional Cubes for corporate data using Power play Transformer.

· Solid understanding of data warehousing, OLTP and OLAP concepts. Performed data extracts. Solid knowledge in Star Flake and Snowflake Schemas.

· Migrated reports from development environment to production environment.

· Migrating reports from Impromptu to Cognos 8 & Report Net.

· Created Scorecards in Metrics studio.

· Experience in Security Implementation in Cognos8, ReportNet, on various levels using third-party security providers like LDAP, Active Directory, and Series 7.

· Experienced in ETL Tool Microsoft DTS /SSIS.

· Experienced in Microsoft SSRS.

· Experience with ERP’s PeopleSoft

· Impromptu (like List Reports, Cross tab Reports, Drill through Reports and sub reports).

· Involved in connecting to corporate database, to setting up effective catalogs, joins, folders, filters ensuring that adequate security procedures.

· Expertise in building the different kinds of catalogs using Impromptu Administrator

· Experienced in Auditing, monitoring, troubleshooting and production support for Reporting Applications and infrastructure.

· Developed data Mappings between source systems and warehouse components.

· Experience in UNIX shell scripting, FTP and file management in various UNIX environments.

· Thorough understanding of system development life cycle (SDLC) experience from requirement analysis through design and development using modern programming languages.

· Experience working in the Functional Domains of Human Resource Management, Finance, Insurance, Food, Pharmaceutical and Health Care areas.

· Experienced in training power users on Query Studio in Ad-hoc reporting.

· Participated in business meetings and delivered reports on Product performance.

· Good team player with excellent communication skills, analytical and learning new technologies Microsoft SSRS SSIS SSAS 2012

Got trained in Tableau and trained the business super users by creating reports

Migrated the SSRS Report into SAP7.4 BI/BW by creating query in Query Designer and trained the user in AFO 2.84

Created the complex Cognos reports in to Crystal Reports and used the Excel Macro to apply the page break by region/Area

Experience

TECHNICAL SKILLS:

SAP: 3.5 years of experience in SAP BW/BO/Crystal reporting/AFO

MS Power BI: 2.5 Years of experience in MS Power BI

Tableau: Got trained in Tableau and trained the business super users by creating reports

Cognos: cognos 10.2 cognos 8.4 cognos 8.3,Cognos 8.2, Cognos 8 Query Studio, Report Studio, Event Studio, Analysis Studio, Metric Studio, Cognos ReportNet 1.1(MR1/MR2/MR3,Cognos Viewer, Cognos Office Connection, Cognos 8 Framework manager, Cognos Impromptu 7.0/6.0, Cognos Transformer6.5/7.6, Cognos Power Play 6.5/7.6, Impromptu Web Reports (IWR), Cognos Query, Cognos Metrics Manager 2.0, Business Objects

Languages: Java, C#.NET, ASP.NET, VB.NET, C++, C, SQL, PL/SQL, HTML, XML

OS: Windows 7/8/95/98/2000/2003/XP/NT, UNIX, Solaris, Red Hat Linux

GUI: Developer/2000 (Forms 4.5/5.0, Reports 3.0/2.5), Tight VNC

ETL: Microsoft DTS/SSIS, Data Stage, Informatica, Cognos Decision Stream.

Tools: SQL*Loader, SQA suite, Toad

Databases: Oracle 7.x/8.x/9.x/10g, SQL Server 2000/2005, MS Access, IBM DB2,

Teradata

Web Servers: IIS 4.0, Netscape Directory Server

Work Experience:

Affinia/MANN+HUMMEL Filtration Technology US LLC

Jan 2011 till Present

NC

Headquartered in Gastonia, North Carolina, Affinia/MANN+HUMMEL is a Purpose Driven Company, adhering to the highest ethical standards in its relationships with customers, suppliers and MANN+HUMMEL people. Core values include a global quality commitment to assure the best products possible regardless of where those products are designed and manufactured. Affinia/MANN+HUMMEL has operations in North and South America, Europe and Asia that support some of the industry's best known and respected brands in global and regional markets.

Full time role COGNOS/Power BI/Tableau/SAP BI/BW/Crystal Report/ Business Analyst/Cognos Developer/Promoted BI Lead/Manager 2015

Meeting with stake holders and Users to gather the business requirements and designed the functional and technical requirement of the Projects

Created the table design with the Fact and Dimensional table for the data mart and created the ETL Job for Data stage.

Understood the Essbase and Baan system to create the table design and the cardinality for the new data mart for the COGNOS reports

Created Daily Sales Module with Business plan and Forecast as well as gross margin percentage with color formatting and scheduled through COGNOS Scheduler and emailing business users on daily basis

Created Order fill Module with USA, CANADA and MEXICO data and Designed the reports with very complex logics and scheduled through COGNOS Scheduler early morning before 7 AM, and provided Production support 24/7 if any production issue.

Rebate Module out of relation Table and implement very complex logic in reports and used the super duper Burst functionality in COGNOS and distributed these reports to around 150 to 200 DMs and RMs with their region data only by restricting others data with each other

Created the AD Hoc reports on daily basis as business demand.

Always give the business the highest priority if anything needed for Business

Created the cognos reports based from the Baan and Essbase based report to minimize the manual calculation .

Designed models using Framework Manager and deployed packages to the COGNOS 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 Reports in COGNOS Administration through LDAP Server and configuration settings in COGNOS configuration.

Modified and created YTD and MTD Corporate Dashboard

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.

Collecting the data marts and creating model based on that data.

Created database layer and business layer, defining appropriate relationship/cardinality between query subjects within the named space

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.

Used conditional formatting, complex calculations, graphs, prompts and multiple drill downs.

Replased the essbase cube fully to Cognos Cube.

Wrote complex queries in BAAN and built the complex Rebate Registration reports for Canadian region by passing the Data Stage and did the dekiverables before time .

Always involved writing complex SQL in Baan and Oracle database to report validations or creating a COGNOS reports straight from SQL.

Time to time involved as COGNOS Administrator role by restarting the cognos application or did changes the setting or removed the junk file from the server to robust the Application.

Deployed the Reports and Packages from Development server to Production

Wrote Shell scrip to schedule the cognos cube in Crontab Job to load the cube on dailybasis incremental.

Trained the Users to use the COGNOS Business Intelligence Suite like Analysis studio

Created event based job to email the reports only when data is loaded at the back end to avoid sending the empty reports.

Intensive involvement in Data separation from data ware house by writing a complex SQL script for Chasi and Brakes separation.

Complete Seemless Migration done from Cognos 8.4 to cognos 10.2 around 150 reports and Modules and packages .

Worked with other team members at different part of the Globe, offshore and with in United States and played and maintained a very good team role

Worked independently with Business folks to proceed with projects as one man show as needed.

Experience in working with different kind of data sources like Excel, Database (SQL Server, Oracle, DB2), dimensional data source (SSAS) and Web in Power BI Desktop.

Implemented row level security in Power BI desktop and published to Power BI service.

Experience in working with different storage modes in PowerBI like DirectQuery, Import and Live Connection.

Experience in working with large Power BI dataset for self-service reporting in Power BI Service.

Experience in using on-premise data gateway to refresh dataset for reports in Power BI Service.

Using Query Editor, DAX calculations, M-code to clean and transform data in Power BI desktop.

Creating measures using advanced DAX calculations to achieve business goal.

Expertise in writing SQL queries using TOAD, DBeaver, and SQL developer.

Data Modelling, Transformation and cleaning using Power BI desktop to implement the data Model same as in Cognos.

After the promotion as BI Manager, lead the BI team of 9 people

Lead the SAP BI/BW project from COGNOS and SSRS.

Created the SAP BAEX( Query designer) Query and build the SAP Reports in AFO( Analyisis for Microsoft Excel 2.8) about 200 queries.

Created THE SAP BO reports in Crystal Reporting and under neath was the BAEX Query Designer Query.

Load the History data from BAAN/SQL SERVER to SAP BW 7.4

Moody Investors

7 World Trade center

NY, NY April 2010 to December 2010

ROLE cognos Developer/Lead

Environment:

Cognos 8.4 Event Studio,Report Studio, Query Studio, Cognos Connection,Cognos Planning, Framework Manager, Power play Transformer

DTS, Oracle 11i/10g,TOAD, HTML, MS-Access, MS- Excel, Unix, Windows NT

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.

Enormous experience in using with cognos 8.4.

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.

Very good experience in working with oracle databases and did Deployment also.

Having enough experience of working on Cognos SDK.

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.

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.

Experience in Web application development by using java script and asp.net with visual studio 2008 and HTML.

Designed Number of pages in the front end by using java script and .net frame work 3.5 along with visual studio.

Excellent experience with JSP aswell as servlets.

Used Transformer with a variety of sources and combined them into Multi-Dimensional Cube.

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

Having Experience in working with Metric studio and Event Studio.

Set security for individual reports in Cognos Connection.

· Created DMR models using Framework Manager.

· Created Dashboards Reports in Report Studio using Dimensional Model (DMR) developed in Framework Manager

· Created filters and prompts with in the Model for improving performance of the Model.

· Deployed the packages and reports from Dev to QA and Prod.

· Used Cognos Connection to administer and scheduling reports to run at various intervals.

· Set security for individual reports in Cognos Connection.

Mattel Inc Fisher price

East aurora

NY Jan 04, 2010- March 26, 2010

ROLE Cognos Developer

Environment:

Cognos 8.4/8.3/8.2, Series 7, Report Studio, Query Studio, Cognos Connection,Cognos Planning, Framework Manager, Power play Transformer, Cognos Scheduler, Access Manager, Cognos SDK, Java, VB.Net, PL/SQL, IBM DB2,SQL Server 2005,SSIS, RedBrick, DTS, Oracle 11i/10g,TOAD, HTML, MS-Access, MS- Excel, Unix, Windows NT

Responsibilities:

Developed Complex reports in Report Studio using Complex SQL queries

· Designed and modified reports in Report Studio.

· Created list reports, cross tab reports, chart reports, Master detail reports, Drill through reports and reports with lot of conditional formatting using Report Studio.

· Involved in creating Test plans, Unit testing and UAT of the Report Studio reports.

Event Studio : created the agents in the event studio and tested the agent

with the trigger.bat utility .

created the event studio based report through the query studio template

Assigned the the task, defined the expressions, assign the task to run the report, assign the task to update the database depending upon the flag status in the database.

Major testing going on through trigger.bat utility and by time scheduling.

Client: Washington Metropolitan Area Transit Authority Apr’ 09 – nov-09

Location: Washington DC

Role: Sr Cognos Consultant

Washington Metropolitan Area Transit Authority (Metro) was created by an interstate compact in 1967 to plan, develop, build, finance, and operate a balanced regional transportation system in the national capital area. The main objective of the project was to gather data from multiple sources analyze performance and generate reports that will help to identify the profitability of the institution at various levels. Performance summary reports were created which helped the executives to view their overall performance, the product level performance and the ranking of their branches depending on the growth and the customer retention.

Responsibilities:

· Involved in installing and configuring Cognos 8.4/8.3/8.2 BI and worked with modeling, Report Studio and Analysis Studio.

· Worked extensively on creating Models using Framework Manager and publishing the packages on Cognos Connection for reporting purposes.

· Created DMR models using Framework Manager.

· Created filters and prompts with in the Model for improving performance of the Model.

· Deployed the packages and reports from Dev to QA and Prod.

· Used Cognos Connection to administer and scheduling reports to run at various intervals.

· Set security for individual reports in Cognos Connection.

· Created customization of web Applications portal using VB, ASP.net.

· Created development of customer facing Web applications using Cognos SDK using JAVA, VB.

· Created

· Used Analysis studio to drill down on cubes and perform business analysis.

· Created Lists, Groups and Cross-tab reports with Drill-through functionality using Analysis studio.

· Scheduled reports to run on a monthly, weekly, and daily basis using Cognos Connection Scheduler.

· Created standard and Ad hoc reports using Cognos Query Studio.

· Developed reports in Report Studio upon requests from business users

· Busted Reports to various Recipients within the organization using Report Studio.

· Created Query Prompts, Tree prompts, Query calculations, Conditions & Filters.

· Developed Complex reports in Report Studio using Complex SQL queries

· Designed and modified reports with Java SDK in Report Studio.

· Created list reports, cross tab reports, chart reports, Master detail reports, Drill through reports and reports with lot of conditional formatting using Report Studio.

· Involved in creating Test plans, Unit testing and UAT of the Report Studio reports.

· Created Power play Cubes using Power play Transformer generated Power play Reports.

· Used time state rollups, average rollups and external rollups in some Transformer Models.

· Created IQDS out of Cognos 8.2 Packages.

· Created dimension maps and multidimensional cubes using Impromptu Query Definition in Power Play Transformer.

· Created many cross-tab, ranked, graph and business mix reports by using Power Play 7.3.

· Created many Power Play web views (cross-tab and chart) according to the end users demand.

· Involved in scheduling Report Studio and Query Studio reports and sending reports via email to several business users.

· Created Dashboards for a better understanding of the business performance metrics using Metric Studio.

· Involved in setting up Groups/Roles to secure the models and packages using Access Manager.

· Mentored business users on Query Studio for adhoc reporting.

· Participated in business meetings and delivered reports on Product performance.

· Worked with ETL team and helped in designing and developing ETL Scripts using Data Stage.

· Worked on SQL Server 2005 and DTS, in export data from excels text files to and from SQL server database.

Environment:

Cognos 8.4/8.3/8.2 Report Studio, Query Studio, Cognos Connection,Cognos Planning, Framework Manager, Power play Transformer, Cognos Scheduler, Access Manager, Cognos SDK, Java, VB.Net, PL/SQL, IBM DB2,SQL Server 2005, DTS, Oracle 11i/10g,TOAD, HTML, MS-Access, MS- Excel, Unix, Windows NT

Abbott Vascular Pharmaceuticals, Santa Clara, CA Apri’07- Mar’09

Role: Cognos Consultant

At Abbott Vascular, I was responsible for setting up the Cognos 8 infrastructure, architecting changes and Building framework manager model to accommodate business needs, performance tuning, troubleshooting, creating and developing reports based on business requirements and administration of Cognos Infrastructure etc.

Roles and Responsibilities:

· Worked with Senior Business and Data Analysts and suggested few changes in the business logic of the company to improve the business flow and performance as per the existing standard and requirements of Abbott Vascular business model.

· Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.

· Involved in Installation and configuration of Cognos 8.3 and Report Net.

· Involved in Migration Impromptu Reports on Cognos 8.3 box

· Implemented the security model as per the Licenses available and restricting users based on the Functional Role and access to different Studios.

· Implemented Security Implementation in Cognos8, Report Net, on various levels using third-party security providers like LDAP, Active Directory, Series 7.

· Implemented Data, Object and Package security as per the business user functional role and location.

· Developed complex Compare reports between different data sources coming from different schemas.

· Built Framework Manager Models, and established the cardinalities to suit the business needs.

· Involved in writing JavaScript to validate the prompt values Set the default values of the prompts and customized the prompts to facilitate user’s choices.

· Created User Groups, Roles in Cognos Connection to implement the Security Features.

· Generated various reports List Reports, Grouped Reports, Cross-tab Reports, Chart Reports.

· Used various functionalities in report studio like drill throughs, conditional formatting, parameter displays, Conditional blocks.

· Created Multipage Portlet Reports Which contains Dashboards.

· Created Scorecards in Metrics studio.

· Created Dashboards Reports in Report Studio using Dimensional Model (DMR) developed in Framework Manager.

· Involved with PeopleSoft EPM, Siebel eClinical for creating Trial Management payment reports.

· Designed and Deployed the Environments from Dev to Test and Test and Production environments.

· Created cubes using various data sources like SAP BW, Oracle, DB2, and Teradata & Flat Files and written Unix shell scripts in order to schedule to run monthly on production server.

· Played a role of business analyst when required and gathered the functional requirements time to time and translated business requirements to Quality reports.

· Scheduled reports to run on a monthly, weekly, and daily basis to send e-mail to users

· Scheduled reports to run on a monthly, weekly, and daily basis using control-m for Impromptu Reports.

· Supported Production Environment 24/7 for Reporting Applications and infrastructure for Clinical Solutions Team.

· Cross trained the Client team to Use Cognos BI Infrastructure.

· Documented the complete design, production process, Framework Designs and Reports as per the Best Practice Standards.

Environment:

COGNOS Suite 8.4,Cognos Suite8.3(Report Studio, Query Studio, Analysis Studio, Metric Studio, Cognos Connection, Framework Manager), SDK,Cognos Go Office, Impromptu, Oracle10g, PeopleSoft EPM, Siebel eClinical, DB2, Teradata, Toad, Data Stage, Erwin 4.5, Microsoft Visual Source Safe, MS-Access,Windows 2003, UNIX, Solaris, Java Script, Inform 4.6,Control-m.

ING Insurance Company, Dallas, TX Jan’06 – Mar’07

Role: Cognos Consultant

ING, a comprehensive mix of insurance through a network of trusted independent agents, brokers, and financial advisors nationwide. The Aim of the Project was to build reports, which would integrate all Insurance data for accounting purposes. Data was coming in from different Sources and types, which included mainly, PREMIUM, CLAIM, EXPENSES OR LOSS, CONTRACTS etc.

Roles and Responsibilities:

· Involved in Designing and Created various Projects in Framework Manager

· Involved in Designing Relational and Dimensional Models(DMR) using framework Manager

· Create various packages using frame work manager in ReportNet

· Involved in Migrating catalogs into report net using migration utility

· Created Multi Lingual packages for various Geographic Locations

· Involved in setting up Groups/Roles to secure the Models and packages

· Involved in installation and configuration of ReportNet and Framework Manager

· Involved in administration of servers using Cognos connection in ReportNet.

· Developed advanced reports using Report Studio and Adhoc reports using Query Studio.

· Integrated the existing security with ReportNet Security.

· Exception highlighting. Created Report Used parameters, prompts

· Created various report types like simple report, cross tab, sub report and drill through that cover the entire range of enterprise reporting requirements and distributed to users.

· Developed standard Templates.

· Developing Standard Reports, Charts, Drill through Reports, Master Detail Reports, Bursting Reports.

· Creation of user and changing their profile.

· Created power play cubes using Power Play Transformer.

· Creation of Multiple dimensions, Alternate drill through and creating special categories in Transformer.

· Created Various Types of Reports in Power play

· Provided Slice and Dice capabilities.

· Created Calculated Measures in Transformer.

· Applied User class security for Models in Transformer.

· Maintained Dimension level Security for Cubes in Power Play Transformer.

· Performance Optimization such as decreasing time in building cubes.

· Involved in Production support for Reporting Applications

Environment:

Cognos8.3/Reportnet1.1, Report Studio, Query Studio, Cognos Connection, Framework Manager, Cognos Impromptu Administrator,, Power play Enterprise Server, Power play Transformer, Cognos Upfront 7.1/7.3, Access Manager, Configuration Manager, Microsoft IIS 7.1, Oracle 8i/9i, PL/SQL, SQL Server 2005/2008, TOAD, HTML, MS-Access, MS- Excel,

ConAgra Foods Inc. Omaha NE Jan’03 – Sep’ 05

Senior Cognos Developer / Administrator

ConAgra Foods Cognos KPI Global Reporting system developed to eliminate the manual collection of KPI data and provide a single repository of KPI data. The KPI Cognos project is to provide a KPI data mart and reporting system for operational KPI’s for the SIG part of CFI’s business, excluding distribution. The data is extracted from multiple data sources and created data warehouse using Cognos Decision Stream (ETL) Tool. The ConAgra Foods Inc Global Reporting System is designed completely in Cognos Report Studio, Query Studio and Framework Manager.

Responsibilities:

· Created Packages and Folders in Framework Manager1.1 and published them to Cognos Connection.

· Gathered and analyzed business requirements from users and business community.

· Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.

· Created Sophisticated Reports using Report Studio 1.1

· Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.

· Supported Business Users in generating AdHoc Reports using Query Studio1.1

· Installed and maintained IWR Server Administration, Powerplay Enterprise Server (PPES).

· Created ConAgra Foods Inc security using Windows NT Authentication.

· Created different user classes and Users using Cognos Access manager.

· Published Impromptu Reports Using IWR using Report Administrator

· Published Powerplay cubes using Powerplay Enterprise Server Administration.

· Catalogs were Optimized by using Database Interaction, Client/Server balancing, Database functions, Table Weighting and Qualification, Governors

Contact this candidate