Summary:

Around 10 years of in-depth and comprehensive experience in design, development, Testing, Security and Support for Data Warehousing, and Client/Server projects. Expertise in Cognos Planning 10.1.1FP2, OBIEE 11.1.1.5, SAS BI Administration and Tableau 7.0 Experienced application developer in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems using Cognos 8.4/8.3/8.2/8.1,Cognos10 and Cognos TM1. Expertise in Cognos8 securities and 3rd party tools such as Access Manager, LDAP, and Active Directory. Having the knowledge on Net integrity Site minder Expertise in Informatica tools such as Informatica Power Center Repository Manager,WorkFlow Manager,Designer,Work Flow Monitor And Administration Console Expertise in Cognos tools such as Cognos Report Studio, Query Studio, Analysis Studio, Metric Studio, Cognos Connection Has good knowledge on OLAP tools like Cognos 7.2 Upfront, Impromptu Web Reports IWR , Cognos Power play Transformer and Business Objects Designed and implemented data cubes using OLAP services, Cognos Impromptu, and Power Play, Analysis Studio to facilitate executive, management and end user reporting Expertise in OLTP/OLAP technologies, developing Cognos 8 Framework Manager Modeling using Star Schema and Snowflake Schema Experience using ETL Tools Informatica Power Center, Informatica Power Mart, in data mart life cycle development, design, development and testing of ETL procedures using Informatica. Strong Knowledge in Oracle Identity Manager, Installation and Configurations Strong Knowledge in Web logic Administration Console Upgrading Cognos 8.4 BI and Planning to Cognos BI 10.2 and Cognos Planning 10.1.1 FP2

Technical Expertise:

Professional Experience:

Confidential

Technical Lead

Description:

Confidential is the fiscal agent for the State of Alaska, NH, CA, Newyork, ND, and Department of Health Social Services. Confidential usiness Services, LLC and/or its subsidiaries Xerox provides this portal to support five statues Medical Assistance health care. Build the Environments, and deploy the code from all the environments. We are supporting almost 99 Environments.

Responsibilities:

• Application maintenance tasks like reconfiguring content store, User ID creation and maintenance, assigning privileges to objects
• Scheduling Report Studio reports in cognos portal page
• Data Source creation in Cognos Connection, package migration across development and production environment,
• Implement the Security levels in framework Manager Level.
• Metadata Modeling and publishing of packages using Framework Manager
• User Security implementation using Cognos Authentication Manager with Tivoli Directory Server
• Project Setup, installation-configuration and implementation of cognos BI 10.1.1 and Informatica 9.6 Suite Cognos Go Mobile, Cognos Go Office, Cognos Insight, Cube Designer, Power play Transformer, Framework Manager, Metric Designer, Planning Analyst and Contributor Administrator
• Create the Repository's in Power Center Repository Manager
• Deploy the code in to Informatica
• Implement the Security Levels in Informatica
• Create the users in Informatica.
• 24/7 Production Support for Informatica and Cognos.

• Maintenance and trouble shooting of Cognos OLAP environment.
• Configured Active Directory Namespace to Cognos
• Administered tasks such as Scheduling, Deployment, Dispatchers
• Deployed Data from one Environment to Another Environment

Environment:AIX,Linux,Cognos10.1.1,Oracle,CognosBI10.1.1,Informatica9.6,CognosGoMobile,CognosgoOffice,FrameworkManager,CognosCubeDesigner,PowerplayTransformeCognosInsight,CognosDynamicQueryAnalyzer,MircosoftProjectPlan,LDAP, WebSphere Application Server.

Confidential

Description:

Confidential is a wholly-owned subsidiary of Citigroup, one of the world's largest financial services organizations. By combining local expertise with the strength of Citibank's worldwide consumer banking network Citi the leading global bank, has approximately 200 million customer accounts and does business in more than 160 countries and jurisdictions. Citi provides consumers, corporations, governments and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services, and wealth management

Responsibilities:

• Maintenance and trouble shooting of Cognos OLAP environment.
• Best practice documents for data modeling on Report studio and Powerplay.
• Application maintenance tasks like reconfiguring content store, User ID creation and maintenance, assigning privileges to objects
• Scheduling Report Studio reports in cognos portal page
• Data Source creation in Cognos Connection, package migration across development and production environment,
• Implement the Security levels in framework Manager Level.
• Metadata Modeling and publishing of packages using Framework Manager
• User Security implementation using Cognos Authentication Manager with Active Directory Server
• Project Setup, installation-configuration and implementation of cognos BI 10.2 Suite Cognos Go Mobile, Cognos Go Office, Cognos Insight, Cube Designer, Powerplay Transformer, Framework Manager, Metric Designer, Planning Analyst and Contributor Administrator
• Configured Active Directory Namespace to Cognos
• Administered tasks such as Scheduling, Deployment, Dispatchers
• Deployed Data from one Environment to Another Environment

Environment:AIX,Teradata,CognosBI10.2,CognosGoMobile,CognosgoOffice,FrameworkManager,CognosCubeDesigner,PowerplayTransformeCognosInsight,CognosDynamicQueryAnalyzer,MircosoftProjectPlan,LDAP,Businesbjects XIR3,WebSphere Application Server.

Confidential

Cognos Administrator Technical Lead

Description:

Confidential is into production of ammonia and nitrogen fertilizers in Kuwait. PIC was established Kuwait Chemical Fertilizer Company KCFC was established by PIC as a joint venture Confidential first chemical fertilizer complex in Kuwait and the region was set up in Shuaiba Industrial Area.

Responsibilities:

• Worked as a Onsite Coordinator and requirement gathering from client
• Application maintenance tasks like reconfiguring content store, User ID creation and maintenance, assigning privileges to objects
• Scheduling Report Studio reports in cognos portal page
• Data Source creation in Cognos Connection, package migration across development and production environment,
• Implement the Security levels in framework Manager Level.
• Metadata Modeling and publishing of packages using Framework Manager and Metric Designer
• Verify the Source Environment and Target Environment Use Life Cycle Manager
• User Security implementation using Cognos Authentication Manager with Active Directory Server
• Upgrade from 8.4.1 Version to Cognos BI 10.2
• Maintained the Product Licenses for Cognos BI 10.2 and Cognos Planning 10.1.1 FP2
• Deployed Data from one Environment to Another Environment
• Administered tasks such as Scheduling, Deployment, Dispatchers
• Configured Active Directory Namespace to Cognos
• Maintenance and trouble shooting of Cognos OLAP environment.
• Best practice documents for data modeling on Report studio and Powerplay.
• Environment In Windows2008 Server R2 Environment.
• Project Setup, installation-configuration and implementation of cognos BI 10.2 Suite and cognos planning server 10.1.1FP2, Cognos Go Mobile, Cognos Go Office, Cognos Insight, Cube Designer, Powerplay Transformer, Framework Manager, Metric Designer, Planning Analyst and Contributor Administrator
• Designed the Security Architecture and Implemented it.
• Prepared User documentation to train users and functionality of each report.
• Case resolution with the help of Cognos Support team using Cognos Support secondary ID
• Deploy the Analyst Libraries from the Source Environment to Target Environment
• Verify the D-list,D-cube and D-links in Analyst using Upgraded Analyst Libraries
• Deploy The Contributor AdministrationLinks,Macros and Application Model and data
• Test the Administrationlinks,Macros,Application and Data in the web
• Install and configure the Contributor WebRichClient in Local machines.
• Prepare the Project Plans for Upgrade from Cognos 8.4 to Cognos 10.2

Confidential

Tableau Administrator

Description:

Confidential with a drug store on the corner of Confidential. Walgreens stores were originally connected to local groceries. In Chicago, their flagship market, they teamed up with either eagle food Finer Foods, usually with a walkthru to the adjoining store and often sharing personnel

Responsibilities

• As part of the Project, I was involved in the following phases of the project
• Analyse, Design, Test Support Tableau administration jobs
• Prepare the Transition Plans for Business Objects and SAS
• Prepare the Tableau Training Documents
• Prepare the OBIEE Training Documents

Environment:Windows2003,AIX,Oracle10g,Tableau,BusinessObjects,Tableau7.0,SAS9.2,WebSphereApplication Server,Netezza

Confidential

Cognos Administrator Specialist

Description:

Confidential business and competition, Business Intelligence Team is the central place for analyzing the data coming from various operational systems is apparent. The objective is to provide the development and Maintenance of Enterprise Data Warehouse for Business Analysis and reporting needs.

Responsibilities

• Project Setup, installation-configuration and implementation of Cognos 8.2 BI Environment UNIX platform.
• Migration from 7.4 Version of Cognos to 8.4.1 and Up gradation of 8.2 Version of Cognos to 8.4.1
• User Security implementation using Cognos Authentication Manager with Sun one Directory server.
• Installation and configuration of Sun one Directory server to Cognos Series
• Metadata Modeling and publishing of packages using Framework Manager,
• Implement the Security levels in framework Manager Level.
• Data Source creation in Cognos Connection, package migration across development and production environment,
• Scheduling Report Studio reports in cognos portal page
• Application maintenance tasks like reconfiguring content store, automating Power play cube refresh activities by shell scripts, User ID creation and maintenance, assigning privileges to objects
• Application Trigger implementation for automation of reporting cycle.
• Performance tuning of Multidimensional cubes and Report studio reports.
• Best practice documents for data modeling on Report studio and Powerplay.
• Maintenance and trouble shooting of Cognos OLAP environment.
• Configured LDAP Namespace to Cognos
• Case resolution with the help of Cognos Support team using Cognos Support secondary ID
• Installed and Configured OBIEE 11.1.1.5 Enterprise installation In Solaris and Windows2008 Server

Environment: Sun Solaris 5.9, Oracle 10g Database, IBM Cognos 8.2 ,8.4and CognosBI, Cognos Power Play Enterprise Server, Cognos Framework Manager, Cognos Power Play, Cognos Power Play Transformer, Cognos Access Manager SDS, Cognos Series 7 Migration Component, Upgrade Manager, TOAD,OBIEE11.1.1.5

Confidential

Senior Cognos Administrator

Description:

Confidential is having control of all Qatar National Education system and we have QNEDS as application supporting Education system in Qatar.

Responsibilities:

• Deployed Web sphere as the Application Server for Cognos Report Net
• We Publish the Cognos Reports Using Web sphere Portal server in to QNEDS Portal
• Understanding existing business model and customer requirements.
• Installed and Configured ReportNet 8.4, in single Environment
• Configured Single Sign-on using Web Sphere for Cognos ReportNet
• Configured Ldap Namespace to Cognos8.4 Using TDS

Environment:

Oracle, Windows 2003 Server,AIX 5.3, Cognos 8.4 -64 bit,PowerPlay Transformer, SQL Navigator, Microsoft Visio, LDAP, Http Server, WAS6.1, WPS6.1, VirtualViewManager and Studio

Confidential

Cognos Administrator

Description:

Confidential is primarily into hospitality business and has got chains of Hotels, Resorts, Spa Centers, Golf Resorts, Bars, Casino, vacation Home Rentals, HI-Class Meeting centers and Legacy Villas.

Responsibilities:

• Installed and Configured Cognos 8.1.
• Deployed Web sphere as the Application Server for Cognos Report Net
• Scheduling the reports in Cognos Connection.
• Configured Ldap Namespace to Report Net
• Configured Single Sign-on using Sun One Planer Directory Server for Cognos Report Net
• Installing and updating the cognos8.1.1 to Cognos 8.2 Environment.
• Installing and Configuring the Cognos Report Net Environment with Third-party LDAP Tools.

Environment: Cognos8, Cognos7 Series version 3, Windows 2003, IIS, SQL Server, Cognos 8.1/8.2, Cognos 7 Series Tools, Directory Server

Confidential

Cognos Administrator

Description:

Tops is a leading food service provider in the United States, with multiple operating companies conducting business in more than 1600 retail stores. Ahold retail operations comprise Stop Shop, Giant-Landover, Giant-Carlisle, Tops, and Peapod. Ahold is the American arm of Netherlands-based A hold, the third-largest food provider worldwide.

Responsibilities:

• Build the IQDS using Impromptu
• Creation of reports as per specifications.
• Provide the access for users using Access Manager.
• Creation of User classes and assigning Access Privileges
• Created Folders for adding calculations, Summaries in the tables/reports.
• Created List Reports, Group reports and Cross Tab Report.
• Created Reports with Charts and List Reports.

Environment: AIX, Windows2003 Server, IBM Mainframes, Cyborg, Cognos7, Oracle10G, Microsoft Visio

Confidential

Cognos Administrator

Description:

Confidential hotels, booking sources , travel agents , corporate agents ,commissions given to these agents .It also maintains information about various promotional offers for the guests. It also maintains a member's club and if a guest is a member of that club, he can avail various offers.

Responsibilities:

• Creation of reports according to client requirement.
• Configured Ldap Namespace to ReportNet

Environment: Windows 2000, Cognos Impromptu Admin, Cognos Power Play Transformer, Oracle8i

Confidential

Cognos Administrator and Developer

Description:

Confidential in more than 130 countries and jurisdictions. PIG companies serve commercial, institutional and individual customers through the most extensive worldwide property-casualty and life insurance networks of any insurer

Responsibilities:

• Analyze the Business Requirements.
• Creation of User classes and assigning Access Privileges.
• Applying Security at catalog level and cube level.
• Validating the Report data across the backend database.
• Publishing the Impromptu Web Reports and Power play cubes to the upfront portal

Environment: CognosEPSeries 7.3 Impormptu, Transformer, Powerplay, AccessManger, IWR, upfrontServer SQL Server2000, and Informatica.