SUMMARY:

• About 9 years of experience in Design, Installation & Implementation of multi-server, multi-tier Business Intelligence systems.
• Highly skilled in Planning & Implementations of small to very large BI Infrastructures.
• Expert in architecting, planning, installing and configuring IBM Cognos BI, EP, IBM Powerplay, TIBCO Spotfire and SAP Business Objects infrastructure.
• Extensive experience in upgrading Cognos environments - handled CRN1.1 to Cognos 8.1, 8.1-8.2, 8.2-8.3, 8.3-8.4.1 and 8.4.1-10.1upgrade projects.
• Experienced in Installing and Configuring TM1 service instances and Architect.
• Scaled up the infrastructure based on the increased user base and reports.
• Created numerous Zero-foot print environments and highly experienced in troubleshooting issues in multi-server environments
• Designed architecture for Cognos.8 BI, Cognos Enterprise Planning, Cognos Reportnet and Cognos Powerplay, Infrastructure in large scale projects.
• Administered and Supported reporting tools to provide self-service reporting solutions and capabilities to end users.
• IBM Certified Technical Specialist and Administrator
• Extensive experience in IBM Cognos.8 BI (Authoring, Relational Modeling, DMR and OLAP Modeling)
• Created Transformer models for building power cubes and implemented drill-throughs from Cubes to reports.
• Created POC environments for new software releases and Beta versions.
• Extensive experience in designing security model for packages, reports and cubes in Cognos connection.
• Expert in TIBCO Spotifire Professional - Setup, Security and Analysis.
• Experienced in Cognos namespace integration with Access Manager and also LDAPs like Novell.
• Highly experienced in using Control-M for scheduling Powerplay, cube refresh and in troubleshooting refresh issues.
• Developed mapping and process flows in using Oracle Warehouse Builder for extraction of Data the Reporting structure from different source systems
• Experienced in Business Objects Enterprise XI 3.1 Administration
• Exposure to new generation BI & Financial products like IBM TM1, OBIEE (oracle), Hyperion and Qlikview
• Experienced as a 24x7 On-call production support engineer
• Worked in offshore-onsite model

EDUCATION:

• Master of Technology in Geotechnical Engineering.

CERTIFICATIONS:

• IBM Certified Administrator - Cognos 10 BI
• IBM Certified Administrator - Cognos 8 BI
• IBM Certified Technical Specialist - Cognos 8 BI
• IBM Certified Designer - Cognos 8 BI Reports
• IBM Certified Professional - Cognos 8 BI
• Certified CSR in Through the Customer’s Eyes
• Cognos ReportNet Authoring Product Professional
• Cognos Reportnet Product User
• Business Intelligence E3 Level Solution Architect
• Oracle Certified Associate 9i

TECHNICAL SKILLS:

IBM Cognos BI 10.1, IBM Cognos 8 BI (8.1, 8.2, 8.3 and 8.4.1), Cognos Reportnet (1.1 MR2 and 1.1 MR3), Cognos, Powerplay 7 Series, IBM Powerplay 8.4, Cognos 8 Upgrade, Manager, Business Objects Enterprise XI 3.1, Qlikview, Spotfire, IBM Cognos 8.x Planning, IBM TM1 9.4, BMC Control-M 6.2, Oracle 10g Warehouse Builder, Oracle 9i/10g, SQL, PL/SQL, Unix Shell Scripting, HP Sitescope, Concord eHealth Suite, HP Project & Portfolio Management Centre, Wiki, Toad, SQL Navigator, Hummingbird, Connectivity, Secure CRT, XManager, Putty, Clearcase, VSS, ERWin, Sun Solaris 8/9x,
Linux, Windows 2008 Enterprise Server, Windows XP, Windows 2000, Windows 7

EXPERIENCE:

Confidential, San Diego, CA, USA 2/2008 - Present
Senior Cognos Architect/Administrator
Confidential is an American wireless telecommunications research and development company, as well as the largest fabless chip supplier in the world, based in San Diego, California. Business Intelligence gas got a huge presence in Confidential. A wide variety of BI tools being used in this company, of all, Cognos has got a largest customer base.
Hardware/Software:
VMWare ESX Clusters, NAS, Solaris blades, Intel Core vPro processors, IBM Cognos 8.x & 10.1, IBM Powerplay 10.1, Powerplay 8.4.1, Cognos 8 Planning (8.x & 8.4), TM1 9.4, Cognos Series 7 Powerplay, Cognos Reportnet, Business Objects Xi 3.1, Qlikview9, Tibco Spotfire 2.2, Control-M 6.2, Hummingbird Connectivity 10, Secure CRT 5.5.2, SQL Navigator, MS Office Visio 2007

Responsibilities:

• Architected, Installed, Configured and implemented Cognos 10.1 BI infrastructure with 2 Content Managers, 7 Reporting Servers and 2 Gateways.
• Currently Developing a Sandbox for Cognos 10 Environment
• Involved in capacity planning and analysis for the IBM Cognos 10.1 Infrastructure development
• Worked as Technical Lead in Cognos upgradation projects - Cognos 8.2-8.3, Cognos 8.3 to 8.4.1 and Cognos 8.4.1 to 10.1
• Administered User Groups and Roles by creating permissions in Cognos portal
• Installed regular fix packs and hotfixes to keep the infrastructure upto date.
• Tuned the environment for performance and documented the techniques.
• Installed TM1 Architect
• Implemented security from scratch for every new instance of TM1
• Configured TM1 instances and troubleshooted issues.
• Troubleshooted numerous issues in the Cognos environments and achieved a bench mark that no one has reached yet. (2300 tickets)
• Designed Access Policy for the end users
• Reviewed server backup, content back up and database backup
• Set up monitoring in MS MOM and Centauri for web URL and windows services.
• Actively involved in gathering and analysing functional requirements from the Business Users
• Published standards for content development in Cognos connection and circulated the same among the Development teams
• Transformed the functional requirements into technical specifications
• Installed Cognos Go Products in Cognos 8.4.1 Environment.
• Successfully Migrated Reports from Cognos 8.2 to 8.3, 8.2 to 8.4, 8.3 to 8.4.1 and 8.4.1 to 10.1
• Worked as 24x7 support on-call support engineer
• Expert Member of Corporate Cognos Centre of Excellence
• Took lead in Framework Manager Modelling. Developed efficient Models by creating different layers in the models like Database Layer, Logical Layer and Presentation Layer
• Created filters and used Native SQL for relational modelling in FM
• Created DMR models and enabled the packages drill-down functionality in Report Studio.
• Created List Reports, Cross tab Reports and Control Charts in Report Studio
• Built numerous Powerplay cubes and tuned them for performance.
• Scheduled the cube refresh through the Control-M
• Held training classes for the end users and explained tips & tricks using the Cognos connection features, Query Studio, Analysis Studio and Powerplay Studio
• Communicated with the IBM support executes thoroughly about the performance bottle necks and helped them in troubleshooting and fixing various issues.
• Worked with Bright Start Partners (BSP Inc.) for Meta Manager implementation.
• Performed RPD and DAC migrations between OBIEE environments.
• Supported OBIEE software during 24x7 on-call.
• Installed & configured SAP Business Objects Xi 3.0
• Worked with SAP for resolving critical incidents in BO environment
• Troubleshooted issues with scheduler in Business Objects
• Set up functional level security in Business Objects
• Developed custom audit reports in Tibco Spotfire
• Created information links in Spotfire and set up permissions on them.
• Scheduled reports to be delivered by email so that the reports available even when the Cognos services are down.
• Trained the end users using the published libraries and creating their own analysis using the DXP files.
• Developed offshore team and organized weekly support calls to get status and assign tasks.
• Appreciated for faster to responses to PPM tickets

Confidential, Titusville, NJ, USA 7/2007 - 1/2008
Cognos Lead Administrator
Confidential has identified the automation of status reporting in a Clinical Trial process as a very important area, which reduces lot of manual intervention and the effort involved in reporting. Global Clinical Operations (GCO) and e-Clinical services of Confidential identified important Operational and Management metrics, which helps to track the Clinical Trial process.
Hardware/Software:
Windows 2003 ES, Oracle 10g Database, Rational Clear Case, Cognos ReportNet/Cognos8.2 & 8.3, Cognos PowerPlay Enterprise Server, Cognos PowerPlay Transformer, SQL Navigator, ERWin.

Responsibilities:

• Installed & Configured Cognos 8.3 BI Environment for Dev, Test and Production environments and scaled for later capacity expansion.
• Upgraded the old Cognos 8.2 Infrastructure to Cognos 8.3 BI and documented issues in the migration.
• Worked with Business Units to define Business Strategy and created centralized reporting capability for users to perform ad-hoc reporting in business applications
• Worked extensively on troubleshooting long pending issues and got the hotfixes from IBM for the identified defects.
• Expert in environment customization and troubleshooting.
• Increased the logging levels in Prodcution environments and carefully analysed logs to understand the issues.
• Escalated issues to the Cognos support to get the hotsites developed.
• Implemented common log server in Cognos 8.3 Infrastructure so that cogserver.log is available for effective troubleshooting.
• Installed, configured a Cognos 8.3 BI pilot system for exploring the various features of the just released version with oracle as the backend content store.
• Fully documented the installation procedure including the issues & fixes.
• Experience with the Cognos Upgrade Manager, during the upgrade projects.
• Defined backup strategy for the reporting server file systems and network share where customer data and cubes are stored.
• Imported Relational Metadata into Frame Work Manager and defined table joins, aliases and views.
• Worked as 24x7 on-call production support engineer
• Developed List Reports, Crosstab Reports and Chart reports with Filters, Calculations, Predefined Conditions, and Prompts in Report Studio using the Audit package.
• Implemented stand alone filters and embedded Filters and Prompts in frame work manager
• Developed use cases for reports to be tested by the QA team..
• Implemented Package level Security and Object Level Security for the Audit Information distributed to the Users
• Provided training to Report Users and Query users
• Modelled powerplay cubes in Transformer and tuned them for a better performance.

Confidential, Manhattan, NY, USA 10/2006 - 6/2007
Cognos Lead Administrator
Confidential of New York Inc. is the major Utility Company serving New York Metro Area. Impromptu is the standard reporting tool with 1000 users. This Project consists of following Phases. Migration from previous version of Cognos reports to the updated version. Analysing all reports and standardizes these reports using Power Prompts and Charts. Design Multi Dimensional Cubes, so that all key performance indicators can be analyzed Provide a pragmatic approach to data model design and architecture in order to ensure a high level of quality in integrity, reliability, extensibility, performance, and maintainability.
Hardware/Software:
Sun Solaris 9, Windows XP/2000, Oracle 10g Database, Rational Clear Case, Oracle 10g Warehouse Builder, Cognos ReportNet/Cognos8.1/8.2, Cognos PowerPlay Enterprise Server, Cognos PowerPlay Transformer, TOAD, ERWin.

Responsibilities:

• Installed & Configured the Cognos 8.2 BI Environment for Staging and Production environments.
• Created automated silent installers for Framework Manager clients
• Automated the deployment migration script for moving the deployment archives from Staging to Prod and Dev to Prod.
• Developed guidelines and naming conventions for content development in Cognos connection.
• Administered and supported all reporting tools to provide self-service reporting solutions.
• Customized data by adding calculations, summaries and functions in the Framework Manager.
• Created standard templates in Report Studio.
• Researched and proposed applications and systems, presenting recommendations to CIO.
• Design and development activities to ensure software requirements were met. Develop and maintain Reports and Catalogs, Cognos Power Play, Cognos Impromptu, and Cognos IWR with Power Prompts.
• Liaised with clients and vendors to resolve day-to-day problems and made process changes.
• Tested the report studio reports for QA and documented the use cases
• Helped the technical administrators team in installation & configuration of Cognos 8.1 system
• Organized Weekly conference calls with Offshore to distribute tasks and assign tickets

Confidential, Holland, MI, USA 11/2004 - 9/2006
Cognos Administrator
Confidential Controls is world\'s largest independent supplier of automotive seating and interior systems such as overhead systems and consoles, door panels, instrument panels and floor consoles. Customers include: Confidential. Cognos has been used in various departments like Sales & Marketing, Procurement, Manufacturing and Human Resources. As Cognos Developer have supported the Cognos technical environment, developed reports for departments where there is no super user identified and deployed user-developed solutions to production.
Hardware/Software:
Windows NT . Oracle 10g Database, Cognos ReportNet/Cognos8.1, Cognos PowerPlay Enterprise Server , Cognos PowerPlay Transformer, TOAD, ERWin.

Responsibilities:

• Upgraded the old Reportnet environment to the Cognos 8.1 BI.
• Performed content store consistency check to resolve any issues with the content store.
• Installed various Cognos tools, ODBC drivers and set-up / defined data sources.
• Worked extensively with Cognos support (it was not IBM then) to troubleshoot some issues and proved them as defects.
• Interacted with users to develop various reports as per their requirement.
• Designed and developed reports that reflect business view of the data. Created different types of joins and aliases as required and set-up user classes and security.
• Developed several complicated reports for HR Skill set application featuring multiple prompt selections, different types drill downs and Sub Reports.
• Modified Power cubes as per the user requirement by adding new dimensions and layers etc., and published cubes through PPES Administration.
• Actively involved in the Reportnet-Cognos 8.1 Migration project. Documented key issues and best practices and involved in post production support activities

Confidential Berhad, Malaysia 1/2004 - 10/2004
Cognos Report Developer
Confidential was a Malaysian bank and the ninth-largest lender while being one of the ten anchor banks in Malaysia.
Hardware/Software:
Oracle 9i Database, Windows NT/XP/2000, MS Visual Source Safe, Cognos Reportnet 1.1 MR3, TOAD

Responsibilities:

• Analyzed requirements from BRS
• Developed Relational models in Framework Manager
• Developed custom SQL for some reports and FM Models
• Developed reports in Report Studio (CRN)
• Tested the Reports for defects and fixed the bugs raised by QA
• Requested for deployment production move after customer sign-off.

Confidential, UK 9/2003 - 12/2003
Cognos Report Developer
Confidential is a leading global provider of risk management software solutions. A pioneer in neural technology and advanced analytics, the company empowers organizations to reduce losses and optimize revenue in the areas of fraud, collections, bad debt, customer attrition, revenue assurance and security.
The objective behind this project is to provide an enterprise wide single platform for reports to user community. Providing timely reports will support management decisions and make forecasts.
Hardware/Software:
Oracle 9i Database, Windows XP/2000, Visual Source Safe, Cognos Reportnet 1.1 MR3, TOAD

Responsibilities:

• Developed reports in Report Studio based on the requirements document
• Tested the reports for defects based on the use cases provided
• Requesting Production move after UAT
• Fixing the post-production issues

Confidential 8/2002 - 8/2003
Reportnet Developer
Hardware/Software:
MS SQL Server 2000 Windows XP/2000, Cognos Reportnet 1.1 MR2, TOAD

Responsibilities:

• Developed reports in Report Studio based on the requirements document
• Tested the reports for defects based on the use cases provided
• Requesting Production move after UAT