Profile:

• 8 years of experience in IT industry in Data warehousing and Enterprise Resources Planning.
• In depth knowledge in interfacing with multiple groups Incident Mgmt / Change Mgmt /Problem Mgmt for providing 24x7 uptime through ITIL framework.
• Trained and have a clear understanding of ITIL V3 Foundation Framework Service Delivery, Service Support, Change Management, Incident management .
• Efficiently used Cognos, Discoverer, Business Objects to implement Business Intelligence.
• Experience in Integration of data sources like Oracle, Db2, Netezza, SQL Server, Informix,Flat Files.
• Has deep technical skills of Cognos integration..
• Installed and provided administration support for various Cognos tools like Cognos 10.x/8.x/1.x on various platforms.
• Experienced application administrator with expertise in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems using Cognos 10.x/8.4/8.3/8.2/8.1
• Worked extensively in building models and packages using Framework Manager.
• Involved in administration activities like setting up security using user classes and setting user privileges in Cognos8 and EP 7 Series Access Manager .
• Developed several reports in Cognos ReportNet, Cognos Impromptu, Cognos Powerplay Explorer/Reporter, Business Objects Reporter, Segate Crystal Reports, Oracle Discoverer and MS-Excel.
• Trained by Cognos Corporation on ReportNet Query Studio, ReportNet Report Studio and Cognos ReportNet Connection, Cognos Framework Manager.
• Has good knowledge on OLAP tools like Cognos 7.2/7.1/7.0/6, Cognos ReportNet 1.0/1.1 MR2/MR3, Cognos 8. 1.1/8.2/8.3/8.4/8.4.1, Cognos 10.1, Oracle Discoverer 4i/9i/10g, Business Objects5.1/XI.
• Self-starter with drive, initiative and a positive attitude. Able to meet very stringent deadlines and always deliver results, even under pressure.
• Strong analytical good communication Skills. Very keen and enthusiastic constant desire to learn genuine commitment to excel.
• Technical Expertise:
• Reporting Tools: Cognos ReportNet 1.0/1.1 Report Studio, Query Studio, Cognos Connection, Framework Manager ,Cognos 8.1/8.2/8.3/8.4 Report Studio, Analysis Studio, Event Studio, Metric Studio, Query Studio ,Cognos10.1, Cognos 8.3/8.4.1 Go Mobile, Cognos Go DashBoard, Cognos Express, Cognos Business Viewpoint,Cognos Go Office,Cognos Impromptu 7.0/7.1/7.2, Powerplay 7.0/7.1/7.2, Cognos Transformer, Business Objects5.1, Power Analyzer, Crystal Reports 9/10/11, MS-Excel, Oracle Report 2.5/6.0, Oracle Discoverer. 4i/9i/10g/11g.
• ETL Tools: Informatica Power Mart 4.6/5.1, Cognos Decision Stream, Oracle Warehouse Builder, Composite Server, SSIS.
• Data Modeling tool: Erwin3.5.2/4.1, Embarcadero.
• Platform: UNIX, AIX, RHEL, Windows 2000/2003/2008/XP.
• Networking protocols: TCP/IP, DNS, Active Directory, IIS, HTTP, POP3, and SMTP.
• Databases: MS SQL Server/2000/2005/2008, Oracle 11g/10g/9i/8i/7.x, Teradata, UDB/DB2 and Netezza 2.5/4.0/4.5.
• Monitoring Tools: SolarWinds.
• Domain Knowledge: Financial, Higher Education, Healthcare.

Certifications:

• IBM Certified Administrator - Cognos 8 BI
• IBM Certified Administrator- Cognos 10 BI
• IBM Certified Specialist - Cognos 8 BI
• IBM Certified Solution Expert - Cognos 8 BI Migration

Work Experience:

Confidential

Sr. Cognos Administrator

Farmers Insurance Group of Companies is one of the largest insurer of both private Personal Lines passenger automobile and homeowners insurance, and also provides a wide range of other insurance and financial services products.

Responsibilities:

• Understanding existing business model and customer requirements.
• Installed and Configured Cognos 8.3/8.4/10.1 BI on a Distributed Environment along with Composite Servers.
• Installed Cognos Metric Server Cognos Transformer and integrated the same with Cognos BI 64 bit environment.
• Used Cognos LifeCycle Manager Tool to compare Cognos 8.3 reports with Cognos 10.1.
• Designed Security Architecture and implemented it.
• Configured Single Sign-on for Cognos 8.4/10.1 BI.
• Helped developers in fixing the issues which occurred while upgrading the reports from Cognos 8.3 to Cognos 8.4.1.
• Configured SSL setting for Cognos ReportNet using 3rd Party Certificate Giotrust .
• Upgraded Cognos 8.3/8.4.1 environment to Cognos 10.1 along with reports/packages/cubes.
• Integrated Cognos with SAP Enterprise Portal.
• Integrated Cognos with SharePoint Portal.
• Participated in on-call rotation to provide Business hours support.
• Production support which involves solving user related issues.
• Configured to distribute reports by bursting them to local file system.
• Installed and Configured Cognos Go Office on workstations.
• Installed Framework Manager on workstations.
• Administered the Reporting Environment for Cognos BI environments.
• Administered tasks such as scheduling, Deployment, Dispatchers and security.
• Deployed Data from one environment to another.
• Automated Content Administration task for daily back up of content store in case of disaster.
• Implemented Performance Tuning for Cognos BI environments.
• Configured different reporting databases such as SAP BW, SQL Server, Oracle 11g/10g, DB2, Netezza.
• Created various custom Report studio templates.
• Developed complex reports for Attorneys having many calculations and templates.
• Created Drill thru definitions for reports.
• Built a Star Schema model using Framework Manager.
• Developed projects and published packages using framework manager.
• Supported cubes using PowerPlay transformer.
• Created agents for notification using Event Studio to monitor performance and environmental issues.
• Closely worked with IBM Cognos support in fixing the issues and in identifying some of product bugs.
• Trained users to get familiar with Cognos 8 BI.
• Provided 24/7 production support for Cognos BI environments.
• Prepared several technical and non technical sops.
• Maintained Product Licenses for Cognos BI tools.

Environment: AIX 5.3/6.1, Windows 2003/2008, RHEL 5.3, IIS, Websphere 6.X/7.1, DB2, Oracle 10g/11g, SQL Server 2005/2008, Netezza 4.0/4.5, Composite Server 3.7.1, Windows xp, Apache, Cognos 10.1, Cognos 8.1/8.2/8.3/8.4.1, Cognos 7 Series Tools, SQL Navigator, Humming Bird, Microsoft Visio, LDAP, Http Servers, Load Runner, Html, Cognos SDK, Cognos Framework Manager, Cognos Transformer.

Confidential

Cognos Administrator

SGHE is a global technology company that provides software and services to help colleges and universities manage their operations and strengthen the educational experience.

Responsibilities:

• Understanding existing business model and customer requirements.
• Installed and Configured Cognos 7 Series, Reportnet 1.1 MR2, Cognos 8 Mr2 on a Distributed Environment .
• Installed and Configured Cognos 8.1 Cognos 8.3/8.4 BI on a Distributed Environment along with Composite Servers.
• Installed and Configured Cognos 8.3 Planning server.
• Provided Estimations for Projects.
• Lead a team of 3 members for supporting BI tools like Cognos.
• Scheduled Delegated tasks to the team members.
• Prepared Weekly Status Reports PSR and shared with the Managers.
• Designed the Security Architecture and Implemented it.
• Deployed Websphere as the Application Server for Cognos ReportNet.
• Configured Ldap Namespace to ReportNet.
• Configured Single Sign-on using IBM TAM for Cognos ReportNet.
• Helped developers in fixing the issues which occurred while upgrading the reports from CRN 1.1 to Cognos 8.1.
• Configured SSL setting for Cognos ReportNet using 3rd Party Certificate Giotrust .
• Installed and Configured Cognos SDK.
• Scheduled Jobs and Reports using SDK.
• Build a Star Schema model using Framework Manager.
• Administered the Reporting Environment.
• Administered tasks such as Scheduling, Deployment, Dispatchers.
• Deployed Data from one Environment to Another.
• Migrated the Cognos 7 series content to Cognos 8.1 mr2 .
• Developed Complex Reports having many calculations, child reports, HTML items etc in Report Studio.
• Developed Several Reports including burst reports using Query Studio, Report Studio, Analysys Studio and other cognos 7 tools like impromptu.
• Created Cubes and maintened them.
• Deployed Cubes from one environment to other.
• Developed Projects and Published packages using FrameWork Manager.
• Used SDK for taking Back-ups, Scheduling jobs and also for Custom Provided Authentication.
• Closely worked with Cognos Support in fixing the issues in identifying some of the product bugs.
• Developed Shell Scripts on Aix Server for kicking the Jobs.
• Production Support which involves solving user problems.
• Prepared Best Practices Documentation for Authoring for Developing a metadata model using Framework Manager.
• Prepared User documentation to train users and functionality of each report.
• Integrated Cognos with other Business Intelligence application platforms used internally.
• Trained Users to get familiar with Cognos ReportNet Functionalities.
• Maintained the Product Licenses for Cognos Reportnet Cognos Impromptu.

Environment: AIX 5.2, Windows 2003, RHEL, IIS, Websphere 5.X, DB2, Oracle 9i, SQL Server, Netezza 4.0/4.5, Composite Server 3.7.1, Windows xp, Apache, Cognos Report Net 1.1 Mr2, Cognos 8.1/8.2/8.3/8.4 Cognos 7 Series Tools, SQL Navigator, Humming Bird, Microsoft Visio, LDAP, Http Servers, Load Runner, Html, CRN SDK, Informatica.

Confidential

Cognos Consultant Aug 04 Feb 07

Lockheed Martin is a American global aerospace, security and advanced technology company with worldwide interests.

Responsibilities:

• Installed and Configured Cognos Reportnet 1.1 Mr2, Cognos 8.1/ 8.2 BI on a distributed enivironment.
• Designed the security architecture and implemented it in CRN 1.1/Cognos 8.x Production environments.
• Integrated Cognos with other Business Intelligence application platforms used internally.
• Created data sources, new roles, new groups in Cognos environment.
• Understanding existing business model and customer requirements.
• Installed SDK and configured, used SDK to pass parameters to reports.
• Scheduled reports using SDK. Customized the reports using SDK.
• Administered the Reporting Environment
• Administered tasks such as Scheduling, Deployment, Dispatchers.
• Migrated Cognos 7 series Catalogs and Reports to Cognos 8.2.
• Deployed Data from one Environment to Another.
• Developed Projects and Published packages using FrameWork Manager.
• Prepared User documentation to train users and functionality of each report.
• Provided tier 3 24/7 support to the end users.
• Production Support which involves solving user problems.
• Documented the CRN Administrative best practices.
• Documented the CRN Conversion best Practices.

Environment: Oracle 9i, Solaris 8.0, Unix, Windows xp, Apache, Cognos Report Net 1.1 Mr2, Cognos 8.2 BI, Cognos 7 Series Tools, SQL Navigator, Humming Bird, Microsoft Visio, LDAP,Sun Sparc Servers, Cisco Css.