SUMMARY

• Professional and detail - oriented with 15 years experience with, systems analysis and design along with production support in the software industry.
• Possess excellent understanding of business intelligence using Cognos BI tools. I possess excellent communication skills and organizational capabilities.
• Experience in requirement gathering and planning the application.
• Interacting with the users and user groups and the business analysts.
• Technical expertise in designing and developing Business Intelligence applications using OLAP & Reporting tools, Cognos Suite/6x/7.1/7.3/8 (PowerPlay, Impromptu, PowerPlay Enterprise Server, Impromptu Web Reports (IWR), Access Manager, Transformer Upfront,. impromptu reports, Cognos Administration, Report Studio, Query Studio and Analysis Studio. Cognos Planning Administration).
• Understanding databases Oracle, SQL Server 2000/2005.
• Construction & analysis of Logical Data Model, Metadata and Logical Design Documentation.
• Worked on data structures and analysis of Source Systems, Staging area & Target systems and documentation of OLAP Reports Requirements.
• Experience with Business Systems and Business Requirements Analysis & Documentation
• Worked with multidimensional reports/cubes creation and analysis as per the requirements.
• Implementation and server configuration for Cognos installations. Development, Testing and Production environments.
• Maintain Database Security
• Create Indexes and Set Primary Keys on DB tables.
• Production Support

TECHNICAL SKILLS

Tools: Suite of Cognos' products, Framework Manager Report Studio, Query Studio, Cognos 10x, Cognos8, Cognos Planning - Contributor Administration, Analyst, Cognos Administration, Cognos Configuration, Action Request System (Remedy), Remedy ITSM 7.6

Peregrine System: JIRA, Windows Project Server

Operating Systems: Windows Solaris 8 AIX Linux

Databases: Oracle, Oracle SQLPlus, Sybase, MS Access 97, SQL Server DB2

PROFESSIONAL EXPERIENCE

Confidential

Cognos Administration

Responsibilities:

• Administrate the BI Application systems in a AIX environment
• Backup Hadoop Administration role
• Resolve production issues responsively, maintain audit/security of the systems, evaluate and make improvements to enhance system performance.
• Provide Business Intelligence Applications group status of production issues on a timely basis.
• Report and Package migration between environments
• Performance tuning and monitoringof Cognos servers
• Create PMRs as needed for vendor escalation of issues
• Backup and Recovery strategies
• Installation for Single Server and Distributed environments

Confidential

Cognos Administration

Responsibilities:

• Administrate the BI Application systems
• Provide a stable production environment that meets the performance needs.
• Resolve production issues responsively, maintain audit/security of the systems, evaluate and make improvements to enhance system performance.
• Provide Business Intelligence Applications group status of production issues on a timely basis.
• Provide on-call support as needed.
• Report and Package migration between environments
• Performance tuning and monitoringof Cognos servers
• Vendor interactionfor escalated issues with vendor software
• Backup and Recovery strategies
• Installation and upgrading of Cognos environments

Confidential

Cognos Administration

Responsibilities:

• Respond and resolve of Remedy related tickets for user issues
• Report and Package migration between environments
• 24*7 Global support for Cognos environments
• Performance tuning and monitoringof Cognos servers
• Create PMRs to vendor for Cognos related issues
• Backup and Recovery strategies
• Server installation and configurations
• All related administration duties
• Installation and configuring of Cognos 10 for Cognos Mobile and iPad

Confidential - Atlanta, GA

Cognos Administration

Responsibilities:

• Handle useraccess requests and issues pertaining to their usage of Cognos tools
• Migrate reports, packages and content between DEV, QA and Production environments
• 24*7 Global support for Cognos environments
• Performance tuning and monitoringof Cognos servers
• Confer with IBM for escalated issues with vendor software
• Manage all Cognos- specific patch upgradesand System Admin activities
• General Oracle knowledge for report and database validations
• IIS configuration for Web Server
• Application and Dispatcher configurations
• Datasoucre connectivity
• Coordinate all Cognos production activities (job schedules, tests, etc.)
• Setup users and userclasses via Ldap

Confidential - Honolulu, HI

Cognos Administration and Development

Responsibilities:

• End user training using Cognos 8 and Cognos Planning
• Framework Manager - published packages
• Provide technical support and administration of COGNOS reporting and planning environments
• Maintain Development/QA/Production Environments, including new installations, upgrades, add and remove users and user groups/roles
• Performance tuning and monitoringof Cognos servers
• Conversion of business requirements to Framework designs and publish packages for Report development
• Maintain Database Security
• Create Indexes and Set Primary Keys
• Validate report using Sql query analyzer
• IIS configuration for Web Server
• Application and Dispatcher configuration

Confidential - Indianapolis, IN

Cognos Administration and Development

Responsibilities:

• Administration and Development for IWR and PowerPlay
• Provided security using Access Manager Administration
• Mentorship for Series 7 MR2
• Transformer for cube building.
• Support for Action Request System
• Break Fix and User Requirements for report and cube changes
• Responsible for customized end user training
• Publish Reports and Cubes into Upfront
• Installation, Upgrade and configuration of all Cognos products
• Support for Peregrine System
• Convert flat files to create usable reports.

Confidential - Indianapolis, IN

Cognos 8 Development

Responsibilities:

• Cube development using Framework Manager tool
• User requirements gathering
• Validate reports against database using sql queries
• Publish packages
• Migration Cognos 7x to Cognos8x

Confidential - Indianapolis, IN

Cognos Administration

Responsibilities:

• Installation of ReportNet and Series 7 MR2.
• Provided security using Access Manager Administration and LDAP.
• End User Training for ReportNet and Series 7 MR2.
• IIS configuration
• Application and Dispatcher configuration
• Created/Modified models in ReportNet Frame Work Manager.
• Publishing packages from Framework Manager.

Confidential - Indianapolis, IN

Cognos Administration and Development

Responsibilities:

• Created user profile and define governor settings.
• Define join conditions, table aliases and views.
• Provided security to Cognos tools using Access Manager Administration and LDAP.
• Set folder and report permissions thru ReportNet.
• Add and Remove Users, Group and Roles in ReportNet.
• Deployment between different environments Test, UAT and Production.
• Developed PowerPlay reports using PowerPlay for Windows application.
• Involved in Report/Server Administration.
• End User Training for ReportNet.
• Designed customized training material using client data to teach ReportNet.
• Created/Modified models in Frame Work Manager.
• Publishing packages from Framework Manager.
• Extensively worked on Query Studio and Report Studio for creating Ad-hoc and Managed Reports.
• Validate report for data accuracy thru SQL queries.

Environment: SQLServer 2000, Oracle 8i, Oracle SQL Plus, SQL Server Enterprise Manager, Cognos (Transformer, Access Manager, PowerPlay, Cognos Metric Manager Upfront), Windows XP, ReportNet 1.1, MR2.

Confidential, Indianapolis, IN

Responsibilities:

• Interact with the client/users for the requirement gathering.
• Analyzing the User requirement for report generation.
• Created Catalogs using Impromptu Administration.
• Created user profile and define governor settings.
• Created folders, filters, prompts, calculations and stored in catalog.
• Define join conditions, table aliases and views.
• Created Impromptu Reports (.imr) and published as Impromptu Web Reports (IWR) on Upfront.
• Provided security to Cognos tools using Access Manager Administration.
• Published Impromptu Reports and PowerCubes to upfront using Cognos Server Administration.
• Created complex reports like, Sub-reports, linked sub-reports, drill-thru and cross tab reports.
• Created IQD's or other data sources to build the Transformer models and Cubes.
• Build the Transformer Models with IQD data source.
• Published PowerCubes using Cognos Server (PPES).
• Developed PowerPlay reports using PowerPlay for Windows application.
• Involved in report/server administration.
• Involved in multi-server installation.
• Involved in ReportNet installation and configuration.
• Created/Modified models in ReportNet Frame Work Manager.
• Publishing packages from Framework Manager.
• Working knowledge on migrating Impromptu catalogs and architect models using ReportNet.
• Extensively worked on Query Studio and Report Studio for creating Ad-hoc and Managed Reports.

Environment: SQLServer 2000, Oracle 9i, Oracle SQL Plus, SQL Server Enterprise Manager, Cognos (Transformer, Cognos Impromptu Administrator, Access Manager, PowerPlay, Upfront), Windows XP, ReportNet 1.1.

Confidential, New York, NY

Responsibilities:

• Actively involved in the data modeling.
• Created specs and technical specs for the reports.
• Actively involved in gathering requirements from the end users.
• Developed Prototype and gave demos to the End Users for user acceptance.
• Interacted / involved with ETL team to identify the required data for developing the reports is being loaded into the data mart.
• Changed CGI environment to ASAPI.
• Integrated Series 7 and ReportNet for cube and report access for PowerPlay.
• Generated simple list, cross tab and sub reports for detailed analysis.
• Developed PowerPlay cubes to generate drill-down analysis reports.
• Implemented strict security measures for the catalogs using Access manager.
• Customer training.

Environment: Cognos PowerPlay, Cognos Impromptu, Transformer, ReportNet and Windows NT, Windows 2000, Cognos Upfront, Cognos Admin Manager.

Confidential - Cleveland, OH

Responsibilities:

• Interpreted complex functional specifications developed by the client and generating cubes and reports to meet customer specifications.
• Created multi-server environment for IWR and PowerPlay.
• Customized gateway for IWR load balancing between servers.
• Customized PPES for cube mirroring to enhance load balancing between servers.
• Created Impromptu Web Reports (IWR) and published them in the web server.
• Created standard and Ad hoc reports (IMR) using Cognos Impromptu.
• Created Multi Dimensional Cubes using PowerPlay Transformer for multidimensional (IQD) reports.
• Date Wizard was used for creating time dimension in the PowerPlay transformer for creating cubes and PowerPlay reports.
• Calculated fields, manual dimensions and special categories were used while creating cubes and reports using transformer models.
• Drill Down and Drill Through functionalities were used in the cubes and reports.

Environment: Cognos PowerPlay, Cognos Impromptu, Transformer, Oracle 8i/9i, Impromptu Web Reports (IWR), and Windows NT, Cognos Upfront.

Confidential, Austin, TX

Responsibilities:

• Created user profiles and user privileges.
• Customized data by adding calculations, summaries.
• Created List Reports, Group Reports and Cross Tab Reports with Drill Through and Drill Down functionalities.
• Created standard and Ad hoc reports using Report and Query Studio.
• Used ReportNet to create (IQDs).
• Created Cubes using PowerPlay Transformer for multidimensional (IQD) reports.
• Worked with Framework Manager to create packages for Report and Query Studio.
• Created calculated fields in transformer for the analytical data.
• Customized PowerPlay reports using drill through and charts where needed.
• End User training.

Environment: Cognos PowerPlay, ReportNet, Transformer, SQL Server and Windows NT, SQL.

Confidential, Columbus, OH

Responsibilities:

• Created and maintained different types of catalogs.
• Created folders for adding calculations, summaries in the tables/reports.
• Created List Reports, Group Reports and Cross Tab Reports with Drill Through and Drill Down functionalities.
• Created standard and Ad hoc reports using Cognos Impromptu tool.
• Created Impromptu Web Reports (IWR) and published them in the web server.
• Created Cubes using PowerPlay Transformer for multidimensional (IQD) reports.
• Multidimensional reports were created using flat files (importing from other databases).
• Worked with PowerPlay time dimension analytical reports using date wizard.
• Created calculated fields in transformer for the analytical data.
• Upgrade 7.0 to 7.1 MR3 for multi-server environment.
• Customer training.
• Installation and configuration.

Environment: Cognos PowerPlay, Cognos Impromptu, Transformer Oracle 8i, Impromptu Web Reports (IWR), SQL Server and Windows 98/NT/2000XP.