SUMMARY

• Over 9+ years of experience in design, development, analysis and implementation of BI/DWH solutions and maintained multiple components of IBM Cognos 10.2.1.2, Cognos 8 BI suite (Framework Manager, Report Studio, Metric Studio, Go Dashboard, Cognos Connection),and 2 year’s hands on experience as a Release Manager with all aspects in development cycle.
• Expertise in Report Studio, Query Studio and operation of detailed queries in Cognos 10.2.1.2.
• Expertise in building the framework model architect from scratch or with reverse Engineering
• Experience in gathering & analyzing the business requirements and develop BRD’s (Business Requirements Documents) and Technical documentation for metadata modeling and report development.
• Experience with migration and upgrade from Cognos 8.3 to Cognos 10.2.1.2
• Preparing User manuals, Operational Guides, Planning and Conducting User trainings.
• Involved in the Cognos Administration like creating new Data source Connections and Creating Packages, handling the Deployment of reports copying from Development to Production server and also handling the user permissions on the Packages and Folders.
• Experienced in implementing large - scale apps with leading technologies in Business Intelligence.
• Strong Experience in Framework Manager Modeling (Relational & DMR).
• Developed Complex Dashboards Reports using Report Studio with Cube and DMR Sources.
• Experience with Cognos Report Studio and Analysis Studio in development of financial, analytical and operational reports on operational and data-mart sources in Cognos 8.
• Performed end to end design including derivation of calculations and ideal precision/scale determination.
• Implemented object-level and package level security in Framework Manager Models for restricting access to metadata across Cognos 8 environment.
• Experience in designing, development and testing of Cognos Power play cube models.
• Expertise in Cognos Power play, cubes development, Cognos impromptu report and catalog development
• Familiar with data modeling as it informs use of the tool and understanding of database, metadata and reporting elements and requirements.
• Fine-tuned and enhanced queries for the performance of the reports and Models.
• Have good exposure on Informatica (Power Mart/Center, Meta Data Repository, Designer, and Work Flow Manager) for Data Extraction, Transformation and Loading (ETL).
• Extensively used RDBMS like Oracle and SQL Server for developing different applications.
• Installed and Configured Cognos 8.4 BI, Framework Manager and Cognos 8 Transformer. Configured Cognos 8 Content Store Database and IIS web server.
• Customized Cognos Connection Portal and assigned users, roles and groups for authentication and authorization.
• Check performance issues for reports to make sure to use best sources to reduce production expenses from Business Objects and Cognos.

TECHNICAL SKILLS

Reporting Tools: Cognos 10 .2.1.2, Cognos 8 series, Report studio, Query Studio, Analysis Studio, Event Studio, Framework Manager,Cognos Transformer, Motio CI, SAP BO, OBIEE

Servers: Application Servers (WAS, Tomcat), Web Servers (IIS6, 7, IHS).

Operating Systems: Windows 2003 Enterprise Server, XP, 2000, UNIX.

Databases: SQL Server 2005, SQL 2008, Oracle 9i/10g, DB2, MS Access2003, Teradata.

Languages: SQL, Knowledge on C, HTML, DHTML and Java

CRM - TOOLS: Pulse, MKS - Integrator, HP Quality center 10.0, Service Desk.

Data Modeling: Star-Schema and Snowflake-schema.

ETL Tools: Knowledge on Informatica, Data stage, SSIS.

PROFESSIONAL EXPERIENCE

Confidential, San Mateo CA

Senior BI Consultant

Responsibilities:

• Production Support for Daily, Weekly, Monthly and Quarterly reports on regular basis.
• Support on FM models and Transformer Cubes for any changes required.
• Designed New and existing reports as per business request and changes for both relational and dimensional Reports.
• Proposed solutions for Cognos Server Architecture and performance tuning and Cube Automation.
• Created Events using Event Studio for Daily, and Weekly Schedules.
• Work on building the daily, Weekly and Monthly Cubes.
• Assigning User Setup and access request using Series 7 Access Manager.
• Work on LOC for implementation of Dynamic Cubes.

Environment: FM Motio PI 2.9.16 for 10.2.1,Transformer Admin, Prod Support, Report Development, Cube Building, User Access, Access Manager, Cognos Series 7 Security, SharePoint, Oracle SQL Developer, Dashboards, Dynamic Cubes

Confidential, El Segundo CA.

Sr BI Architect/Consultant

Responsibilities:

• Proposed solutions for Cognos Server Architect, Framework Model and Cognos Insight.
• Assisted to upgrade Cognos 10.2.1.2, Enterprise ProtectionPlanning and TM1 with installation and deployment process.
• Access the tickets for the implementation of new reports related to priority and update them with latest templates and design as per the requirements.
• Designed EPP Framework Manager for relational structured Model and publish packages with self-serve reporting capability.
• Designed multiple Cubes using IQD’s using Transformer for OLAP.
• Worked on reverse Engineering to design the complex reports.
• Assisted users in the professional system design concepts and business standards and conventions.
• Performed user acceptance testing and end user training for Cognos Users and involved in Data validation and testing procedures.
• Worked as a Mentor for Cognos training for Business Users.
• Created Ad-hoc reports using Query Studio and designed a plan to implement crystal reports to Cognos.
• Provide Cognos user support and troubleshooting with the testing team.
• Involved in user requirement gathering with Business User proxies.
• Expert in creating complex standard reports, and created prompts, query calculations, conditions, formatting, conditional formatting, filters, multilingual reports using Report Studio.
• Created Executive Dashboards using Workspace and Workspace Advanced.

Environment: Cognos 8.3, Cognos 10.2.1.2, TM1, Query Studio, Analysis Studio, Event Studio, Business Insight, Business Insight Advanced, Framework Manager, Transformer,SAS, Teradata 14.0, Service Desk.

Confidential

Sr BI Consultant

Responsibilities:

• Installation of Cognos 10.1.1 and helped the end users being as mentor.
• Proposed solutions for Security implementation for package level and for assigning user group roles according to the responsibilities.
• Verified the current model and assisted with the needed changes.
• Modeled the Framework Manager for Dimensional modeling.
• Worked on deployments and securities for the catalog using session parameters and also implemented data source Connections for Cubes.
• Worked on reverse Engineering to design the complex reports.
• Assisted users in the professional system design concepts and business standards and conventions.
• Performed user acceptance testing and end user training for Cognos Users and involved in Data validation and testing procedures.
• Worked on installation of Cognos 10 and validated the current report content.
• Built models containing query subjects, query items, and namespaces from imported metadata.
• Created Ad-hoc reports using Query Studio and designed a plan to implement crystal reports to Cognos.
• Provide Cognos user support and troubleshooting with the testing team.
• Tuning the report performance with drastic time difference.
• Involved in user requirement gathering with Business User proxies.
• Implemented securities to the packages while publish with respect to the user groups and roles.
• Expert in creating complex standard reports, and created prompts, query calculations, conditions, formatting, conditional formatting, filters, multilingual reports using Report Studio.

Environment: Cognos 10.1.1, Cognos mobile, IBM Cognos Lifecycle Manger10.0.1, Query Studio, Analysis Studio, Event Studio, Business Insight, Business Insight Advanced, Framework Manager, Oracle 10G, SQL server 2008.

Confidential

Project Manager /BI Architect / Cognos Administrator

Responsibilities:

• Designed the entire architecture and plan for the BI suite.
• Installation of Cognos 10.1.1 for Development and Prod setup with security implementation and deployed the prior version reports from 10.1 to 10.1.1
• Modeled the Framework Manager for Dimensional modeling.
• Fine-tuned and enhanced queries for the performance of the reports and Models.
• Worked as a mentor, trained report studio, Analysis Studio and Query Studio for the BI team
• Worked with the Business Users to gather the requirement documents and mentor the requirements with standards.
• Performed user acceptance testing and end user training for Cognos Users and involved in Data validation and testing procedures.
• 24/7 Support when users needed for Access and Deployment process.
• Worked on upgrading the IQD files to the 10.1.1 FM Model.
• Built models containing query subjects, query items, and namespaces from imported metadata.
• Created Ad-hoc reports using Query Studio and designed a plan to implement crystal reports to Cognos.
• Provide Cognos user support and troubleshooting.
• Expert in creating complex standard reports, and created prompts, query calculations, conditions, formatting, conditional formatting, filters, multilingual reports using Report Studio.

Environment: Cognos 10.1.1, Cognos mobile, IBM Cognos Lifecycle Manger10.0.1, Business Insight, Business Insight Advanced, Framework Manager, SQL server 2008, SSIS.

Confidential - Denver, CO

Sr Cognos BI Architect

Responsibilities:

• Planning for the implementation of the upgrade from Cognos 8.3 to Cognos 10.
• Worked on IBM Cognos Lifecycle Manger 10.0.1 for validating report content and for the introduction of new environment.
• Proposed solutions for Security implementation for package level and for assigning user group roles according to the responsibilities.
• Verified the current model and proposed the best practice methods.
• Worked on deployments and securities for the catalog using session parameters.
• Fine - tuned and enhanced queries for the performance of the reports and Models.
• Worked as a mentor, trained report studio, Analysis Studio and Query Studio for the BI team
• Assisted users in the professional system design concepts and business standards and conventions.
• Performed user acceptance testing and end user training for Cognos Users and involved in Data validation and testing procedures.
• Worked on installation of Cognos 10 and validated the current report content.
• Built models containing query subjects, query items, and namespaces from imported metadata.
• Created Ad-hoc reports using Query Studio and designed a plan to implement crystal reports to Cognos.
• Provide Cognos user support and troubleshooting.
• Implemented securities to the packages while publish with respect to the user groups and roles.
• Expert in creating complex standard reports, which can be used by most of the clients and Created prompts, query calculations, conditions, formatting, conditional formatting, filters, and multilingual reports using Report Studio.

Environment: Cognos 10.1.0, IBM Cognos Lifecycle Manger10.0.1, Oracle 10G, SQL server 2008, Crystal V10.

Confidential - Durham, NC

Sr BI Consultant

Responsibilities:

• Worked on the data validation reports from TM1 Cubes and EDW Reports for planning.
• Proposed solutions for Frame work Manager Architecture for the current model.
• Dealt with the Business Requirement document gathering from the business users and documented Technical Designed documents.
• Worked on deployments and securities for the catalog using session parameters.
• Fine-tuned and enhanced queries for the performance of the reports and Models.
• Ability to work under stringent deadlines with teams as well as independent.
• Assisted users in the professional system design concepts and business standards and conventions.
• Performed user acceptance testing and end user training for Cognos Users and involved in Data validation and testing procedures.
• Involved in weekly and monthly schedules for the reports and also worked on report bursting.
• Maintaining weekly cubes refresh for TM1 to populate the latest data from the PROD screenshots.
• Built models containing query subjects, query items, and namespaces from imported metadata.
• Created Ad-hoc reports using Query Studio.
• Provide Cognos user support and troubleshooting.
• Worked on Unit testing, Smoke test and QA support for the reports that are created by me or in the team.
• Implemented security to the packages while publish with respect to the user groups and roles.
• Expert in creating complex standard reports which can be used by most of the clients.
• Created prompts, query calculations, conditions, formatting, conditional formatting, filters, multilingual reports Using Report Studio.

Environment: Cognos 10.1.0, Cognos TM1 9.5.2, Report Studio, Query Studio, Analysis Studio, Event Studio, Business Insight, Business Insight Advanced, Framework Manager, HP Quality center 10.2.0 Bug tracking tool, Teradata 12.0.

Confidential - NYC

Release Manager / Sr Cognos BI

Responsibilities:

• Worked on Work force, Securities and Services, Score cards and blue print Project.
• Worked on Business requirement and preparing BRD’s and also involved in preparing Data Dictionary.
• Provided plan and estimates for Frame work modeling.
• Proposed solutions and approach to closing gaps via process re-design and system functionality.
• Analyzed business operation’s strengths and weaknesses and identified opportunities for automating processes and functions.
• Created Query Prompts, value prompt, search prompt, calculations, Conditions & Filters, Prompt Pages using Report Studio.
• Fine-tuned and enhanced queries for the performance of the reports and Models.
• Performed user acceptance testing and end user training for Cognos Users. Involved in Data validation and testing procedures. Fine-tuned and enhanced queries for the performance of the reports.
• Tested the reports with various testing methodologies like Functional testing, Regression testing and UAT.
• Involved in Designing Models and Created various Projects in Framework Manager
• Worked on Report studio using DB2 SQL scripts without a model for emergency delivery deadlines.
• Worked with the end users for the production support from DEV-UAT, UAT - PROD.
• Worked as a release manager for the packages, code deployment for the development and testing cycles.
• Deployed the reports from Dev-Prod cycle.
• Expertise in Unit testing, Smoke test and QA support.
• Worked with Business Analyst for user requirements to create Business Requirement Documents and Technical Requirement Docs.
• Raising Enterprise Chain management system and processing flow with implementer and approvers.
• Involved in Peregrine Incidents handling in stringent and Emergency deadlines.
• Supported Users and business when ever needed.

Environment: Cognos 8.4 Report Studio, Query Studio, Analysis Studio, Event Studio, Go Office, MotioTI (Version Control) HP Quality center 10.2.0 Bug tracking tool, ECM, DB Visualizer 7.5.1, Share point, Oracle SQL server 9i, Windows 2000.

Confidential, Denver, CO

Sr Cognos BI Cosultant

Responsibilities:

• Worked on testing reports from Cognos 8.3 to Cognos 10 beta version for future development on Cognos upgrade.
• Proposed solutions and approach to closing gaps via process re-design and system functionality.
• Analyzed business operation’s strengths and weaknesses and identified opportunities for automating processes and functions.
• Re-designed entire model for the Kansas healthcare reform government project and Georgia State.
• Held every day standup meeting for the status updates and meeting for new implementations on business prospective.
• Worked with a team of 4 Offshore Developers and 2 Testers.
• Documented Technical and business requirement specifications.
• By using Cognos scheduler for scheduling reports to run at various intervals.
• Developed various mappings using Informatica Mapping Designer like Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, and Stored Procedure.
• Worked on Modifications for existing packages using version control and publishing newer versions.
• By using MKS integrator (BUG tracking tool) tracking the changes and additional modifications from user prospective.
• Assigned security access for the users by using Cognos administrator.
• Deployed the reports and packages from Dev - QA, QA-UAT and DEV- PROD.
• Administered and supported reporting tools to provide reporting, ad-hoc query and dashboard solutions and capabilities to end users.
• Ensured business objectives were met by consulting with user management and staff throughout all stages of the report development cycle.
• Assisted users in the professional system design concepts and business standards and conventions.
• Performed user acceptance testing and end user training for Cognos Users and involved in Data validation and testing procedures.
• Fine-tuned and enhanced queries for the performance of the reports and Models.
• Ability to work under stringent deadlines with teams as well as independent.

Environment: IBM Cognos10, Cognos 8.3, Cognos, Report Studio, Query Studio, Framework Manager, Cognos Scheduler, MKS integrator, MS- Excel, Oracle SQL developer, Windows 2000.

Confidential, Lisle IL

BI Architect / Cognos Team Lead

Responsibilities:

• Worked on testing reports from Cognos 8.3 to Cognos 10 beta version for future development.
• Proposed solutions and approach to closing gaps via process re-design and system functionality.
• Analyzed business operation’s strengths and weaknesses and identified opportunities for automating processes and functions.
• Worked as a team for On-Site and Offshore supporting Business needs.
• Managed the project, leading a team in India, Assigning Development Requests using Siebel pulse CRM tool.
• Expert in Report Studio8.3, Query Studio, Analysis Studio, Event Studio.
• Created the Framework Packages and using frame work manager.
• Helped in upgrading the installation from Cognos 8.3 to Cognos 8.4.
• Used Cognos Connection to administer and scheduling reports to run at various intervals.
• Developed various mappings using Informatica Mapping Designer like Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, and Stored Procedure.
• Created filters within the Model for improving performance of the Model.
• Involved in Designing Models and created various Projects in Framework Manager.
• Involved in Migrating catalogs into report net using migration utility.
• Used Show case Query 6.0 SQl generator to analyze the data in the Database matches the reports created in the report studio 8.3.
• Expert in creating complex standard reports which can be used by most of the clients.
• Involved in weekly status meetings, everyday conference dial meetings and also with IBM- Confidential VP’s for growth in effective production.
• Worked and Documented for Business requirements with the help of client requirements.
• Created list reports, cross tab reports, Lists, Groups and Cross-tab reports with Drill-through functionality, chart reports and reports with lot of conditional formatting using Report Studio.
• Created Query Prompts, value prompt, search prompt, calculations, Conditions and Filters, Prompt Pages using Report Studio.
• Created multiple dimensions, Calculated Measures Alternate drill through and creating special categories in Transformer.

Environment: IBM Cognos10, Cognos 8.3, Cognos, Report Studio, Query Studio, Power play studio, Framework Manager, Upfront, Power play Transformer, Power play enterprise server, Cognos Scheduler, Access, AS/400, DB2, MS- Excel, Showcase Query 6.0, Windows 2000.

Confidential

SR BI LEAD / Release Manager

Responsibilities:

• Worked as a Cognos Developer and data warehouse team for the implementation of various Cognos Projects.
• Worked and assisted for system administration for Cognos Planning and Cognos BI applications and Business Objects applications.
• Responsible in the setup of Cognos Security and Setup of User Groups, Roles, Etc.
• Supported efficient quality assurance and testing of various system applications.
• Created complex Dash boards for the business requirements and for the end users.
• Efficiently served as a liaison between the business and IT Business needs.
• Determined and analyzed the problems in service, performance and provided solutions.
• Load balanced the Cognos 8.4 Bi Multi server environment for performance issues.
• Built models containing query subjects, query items, and namespaces from imported metadata.
• Created Ad-hoc reports using Query Studio andProvide Cognos user support and troubleshooting.
• Checked performance issues for reports to make sure to use best sources to reduce production expenses.
• Worked for Data Ware House using Cognos Data Manager 8.4.
• Created and developed new reports in Report Studio upon requests from business users.
• Developed Standard Reports, List Reports, Cross-tab Reports, Charts, Drill through Reports and Master Detail Reports Using Report Studio.
• Migrated cubes and reports to Cognos 8.4 from old versions.
• Created prompts, query calculations, conditions, formatting, conditional formatting, filters, multilingual reports Using Report Studio.
• Created Query Prompts, Developing Prompt pages and Conditional Variables.
• Created Bursting Reports and Multilingual Reports Using Report Studio and Query Studio.
• Worked with multi-query reports and charts.
• Created Models based on the dimensions, levels and measures required for the analysis studio-using Transformer.
• Worked on performance tuning of all the Cognos Cubes such as decreasing time in build timesand published them to enterprise Server Used Framework Manager to build models, packages and publish packages to Cognos connection.
• Used Cognos Connection to administer and scheduling reports to run at various intervals.
• Implemented security to the reports and packages.
• Interacted with the Management and Development teams for Requirement gathering.
• Coordinated Onsite and Offshore resources for various business needs.
• Closely worked with data warehouse designers to refine data and metadata.
• Performance tuning of the reports which are on demand reports.
• Migrated the reports from dev, test and prod
• Tested the reports with various testing methodologies like Functional testing, Regression testing and UAT.
• Worked closely with IBM/Cognos on troubleshooting and analysis of environmental and reporting issues. Escalated to second level of support as needed.
• Performed user acceptance testing and end user training for Cognos Users. Involved in Data validation and testing procedures. Fine-tuned and enhanced queries for the performance of the reports.
• Implemented, tested, and documented an upgrade process from an existing Cognos Series 7.1 and 7.4 applications to ReportNet MR3 and then to Series 8 architecture.
• Migrated reports and Cubes from Cognos 7.x to 8.x.
• Managed internal and external resources using Oracle applications for ERP (Enterprise Resource Planning).

Environment: IBM Cognos 8.4, Data Manager 8.4, Cognos 8.3, Cognos 8.1,, Report Studio, Query Studio, Power play studio, Metric studio, Cognos Connection I-PLANET, Framework Manager, Cognos Scheduler, Access Manager, Informatica, Oracle 9i, SQL Server, TOAD, HTML, MS-Access, MS- Excel, Windows 2003.

Confidential

SR COGNOS BI / Architect -CONSULTANT

Responsibilities:

• Designed, Installed, configured and Managed the deployment of Cognos 8 Business Intelligence (version: 8.1) in development, Test and Production.
• Proposed solutions and approach to closing gaps via process re-design and system functionality.
• Analyzed business operation’s strengths and weaknesses and identified opportunities for automating processes and functions.
• Worked for Data Ware House using Cognos Decision Stream 7.1.
• Upgraded Cognos versions from Series 7.4 and ReportNet MR3 to Cognos 8.1 BI.
• Responsible for all server maintenance, upgrades, configuration, and performance tuning.
• Used Cognos Connection to administer and scheduling reports to run at various intervals.
• Installed, configured and managed LDAP, Set security for individual reports in Cognos Connection.
• Installed, configured and published cubes and reports through power play enterprise server.
• Interpreted complex Business specifications developed by the client and generated cubes and reports to meet customer specifications.
• Interaction with the Management and Development teams for Requirement gathering.
• Created Dashboards for a better understanding of the business performance.
• Used Analysis studio to drill down on cubes and perform business analysis.
• Expert in Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio.
• Created the Framework Packages and used frame work manager in ReportNet.
• Created the cubes with help of Framework Manager to change the Source Hierarchy.
• Created filters within the Model for improving performance of the Model.
• Involved in Designing Models and created various Projects in Framework Manager.
• Involved in Migrating catalogs into report net using migration utility and Created Multi Lingual packages for various Geographic Locations.
• Set security for individual reports in Cognos Connection.
• Scheduled reports to run on a monthly, weekly, and daily basis using Cognos Connection Scheduler.
• Bursting Reports and Multilingual Reports Using Report Studio.
• Created list reports, cross tab reports, Lists, Groups and Cross-tab reports with Drill-through functionality, chart reports and reports with lot of conditional formatting using Report Studio.
• Created Query Prompts, value prompt, search prompt, calculations, Conditions and Filters, Prompt Pages using Report Studio.
• Trained power users to use Query Studio for Ad-hoc reporting.
• Checked performance issues for reports to make sure to use best sources to reduce production expenses.
• Involved in migrating Impromptu reports to ReportNet, analysis, design, develop, testing of analytical and transactional reporting systems and user training.
• Created standard and Ad hoc reports using Cognos Impromptu and various packages using frame work manager in ReportNet.
• Involved in Migrating catalogs into report net using migration utility, setting up Groups/Roles to secure the Models and packages.
• Designed catalogs and defined User Classes, Security and Privileges.
• Developed various mappings using Informatica Mapping Designer like Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Managed internal and external resources using Oracle applications for ERP (Enterprise Resource Planning).

Environment: Cognos 8 Report Studio, Query Studio, Cognos Connection, Framework Manager, Power play Transformer, Cognos Scheduler, Decision Stream 7.1, Access Manager, Informatica, Oracle 9i, PL/SQL, SQL Server, TOAD, HTML, MS-Access, MS- Excel, UNIX, Windows NT.

Confidential, Columbus OH

SR COGNOS DEVELOPER

Responsibilities:

• Checked performance issues for reports to make sure to use best sources to reduce production expenses.
• Designed, installed, configured and Managed the deployment of Cognos Reportnet1.1 in development, Test and Production
• Worked as a team for On-Site and Offshore supporting Business needs.
• Responsible for all server maintenance, upgrades, configuration, and performance tuning.
• Used Cognos Connection to administer and scheduling reports to run at various intervals.
• Involved in installation and configuration ofReportNet, Designing and created various Models and Projects in Framework Manager.
• Involved in setting up Groups/Roles to secure the Models and packages.
• Involved in administration of servers using Cognos connection in ReportNet.
• Developed Impromptu Web Reports (IWR) and published using Upfront, Exception highlighting, Created Report and list prompts.
• Created and Modified Catalogs for different applications by using Impromptu Administrator.
• Created Folders, Prompts, Calculated Columns, User classes and User class filters in Catalogs.
• Developed standard Templates, Standard Reports, Charts, Drill through Reports, Master Detail Reports and Bursting Reports.
• Maintained Dimension level Security for Cubes in Power Play Transformer.
• Performance Optimization such as decreasing time in building cubes.

Environment: Cognos Reportnet1.1, Report Studio, Query Studio, Cognos Connection, Framework Manager, Cognos Impromptu Administrator,, Power play Enterprise Server, Impromptu Web Reports, Cognos Scheduler, Cognos Query 7.1/7.3, Cognos Upfront 7.1/7.3, Access Manager, Configuration Manager, Informatica, Microsoft IIS 7.1, Oracle 8i/9i, SQL Server, TOAD, HTML, MS-Access, MS- Excel, Windows.

Confidential, Dayton, OH

COGNOS DEVELOPER

Responsibilities:

• Interacted with Business users to identify key dimensions and measures for business performance.
• Extracted data from Oracle data marts.
• Generated reports using Cognos Impromptu and Power Play.
• Created Hot Files to be used as Lookup tables to prepare reports and reduce querying time.
• Formed joins and database definitions according to the requirements.
• Created Prompts, set Filters and Calculations.
• Generated Multi-Dimensional reports using Power Play.
• Enhanced existing Power Cube as per user requirements.
• Made use of both Auto and Manual Design for creating Power Cubes.
• Created Time dimension properties.
• Developed Impromptu Web Reports and published them using Upfront.
• Used Access Manager to meet the security requirements of the reports and cubes on the Upfront.

Environment: Cognos 7.x, Cognos PowerPlay, Impromptu, SQL server 2000, Oracle 8i, Informatica 6.x, Erwin, ASP.net, Load Runner, QTP.PL/SQL, TOAD, HTML, MS-Access, MS- Excel, UNIX, Windows NT.