PROFESSIONAL OVERVIEW

• 13 years of experience in IT Industry in Analysis, Design, Testing, Development, and Implementation of Business Intelligence, Data Warehouse and Client/Server Application
• 9 years of experience working with Cognos 10 8 suite - Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio and Cognos Connection
• Strong experience in installation, configuration and upgrade of Cognos environments
• Solid experience in server administration monitoring events, applying critical updates, fixing security vulnerabilities, utility patches, etc.
• Strong knowledge and experience on Cognos data and object security
• Experienced in creating/modifying/managing reports, users, user profiles and deployment
• Strong experience in developing reports with Report/Query Studio and Analysis Studio
• Strong experience in creating relational dimensional models in Framework Manager
• Proficient with different databases like Oracle 11g/10g/9i, MS-Access, SQL Server 2000/2005/2008, Teradata and DB2
• Strong expertise in troubleshooting corporate and remote user network problems
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
• Ability to manage and deliver results on multiple tasks by effectively managing time and priority constraints
• Provide extensive end user training and support

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Role: Senior Cognos TM1 Consultant

Responsibilities:

• Monitor, tune, administer and support Countywide BI platform which includes three Cognos environments Dev, Test and Prod for three customer departments ISD, DPSS, Probation and IBM TM1 environments
• Installed, Configured and Maintained Cognos 10.2 and Cognos 10.2.1 across multiple environments
• Upgraded Cognos environments from Cognos 8.3 to Cognos 10.2.1 and Cognos 10.2 to 10.2.1
• Installed and Configured IBM TM1 10.2.2 suite IBM TM1 Admin Server, IBM TM1 Web, IBM TM1 Application Web, IBM TM1 Architect/Perspectives and IBM TM1 Performance Modeler
• Upgraded IBM TM1 environment from 9.5.2 to 10.2.2
• Integrated IBM TM1 10.2.2 environment with BI CAM security and established SSO
• Worked on migration of Cognos BI and TM1 servers to Windows 2008 64 bit ecloud platform
• Setup Trusted SSO between Cognos and an external Java application through a cookie based solution
• Developed models using Framework Manager
• Implemented data security through security filters and macros in Framework Manager
• Planned and Created professional, dashboard and active reports in Report Studio
• Modelled a dynamic cube using County Enterprise warehouse as a POC
• Applied performance tuning of reports to effectively reduce report execution time
• Setup Cognos with external LDAP authentication mechanisms like Oracle Internet Directory, Microsoft Active Directory/ADAM and Novell Directory Server
• Apply and Manage object security for content published to Cognos Connection Portal to control privileges for users, groups, and roles on packages, folders, data sources, and cubes
• Applied TM1 security assignments to cubes, processes, dimensions and chores for multiple TM1 servers
• Involved in capacity planning and architecture for maximizing performance and failover strategies.
• Setup Cognos Audit reports, Cognos Audit Extensions and System Monitoring Methodology to automate and load metric dumps for populating the metric values
• Analyzed Server vulnerability assessment reports and applied fixes to repair the weaknesses for Windows 2003 and Windows 2008 servers
• Used Metamanager to blast portlets, templates and document the Content store objects
• Maintain/Update documentation for Server Topology Diagrams, Cognos on the Internet Architecture Diagrams, Installation and Configuration guides for various Cognos applications and Custom configuration documents
• Assist end-users with training, responding to questions and resolving problems
• Provide Customer Support to multiple County Departments on Cognos and TM1 related issues

Technical Environment: IBM Cognos 8.3/10.2/10.2.1, IBM TM1 9.5.2/10.2.2, IBM Virtual View Manager, Data Manager 10.2, Microsoft IIS 7 , Transformer 10.2.1, Microsoft SQL Server 2008, Oracle 11g, MS-Access, MS Active Directory, Oracle Internet Directory Server, Meta Manager, ESRI Maps Designer

Confidential

Role: Cognos Administrator

Responsibilities:

• Setup Cognos 10.2 POC environment to test and validate upgraded Cognos 8.4 contents
• Demo Cognos 10.2 new features to various business units
• Install, Configure and Setup of Cognos 10.2 on three environments Dev, Test and Prod
• Upgraded Cognos environment from 8.4 to 10.2
• Test and compare reports through IBM Life cycle manager to validate upgraded contents
• Diagnose and prescribe corrective action for application outages, performance impairments, data errors and other problems with deployed applications
• Re-designed BI security architecture and implemented it
• Change BI authorization from Cognos based to Active Directory groups and roles
• Create windows scripts to automate process
• Provide 24/7 Production Support for Cognos reporting application and server infrastructure

Technical Environment: IBM Cognos 8.4/10.2, IBM Transformer 8.4/10.2, Microsoft IIS, Oracle 9i/11g, MS Active Directory, Oracle Toad, Appworx

Confidential

Role: Senior Cognos Consultant

Responsibilities:

• Monitor, tune, administer and support Countywide BI platform which includes three Cognos environments Dev, Test and Prod for three customer departments ISD, DPSS, Probation and IBM TM1 environment
• Installed, Configured and Maintained Cognos 10.1 and Cognos 10.2 across multiple environments
• Upgraded Cognos environments from Cognos 8.4.1 to Cognos 10.1 and Cognos 10.1 to Cognos 10.2
• Installation and Configuration of TM1 9.5.2 suite TM1 Admin Server, TM1 Web, TM1 Architect, TM1 Perspectives, TM1 Contributor, and TM1 Portlets
• Upgraded TM1 environment from 9.4 to 9.5.2
• Integrated TM1 9.5.2 environment with BI CAM security and established SSO
• Setup Cognos with external LDAP authentication mechanisms like Oracle Internet Directory, Sun one Directory Server/Netscape iplanet, Microsoft Active Directory/ADAM and Novell Directory Server
• Apply and Manage object security for content published to Cognos Connection Portal to control privileges for users, groups, and roles on packages, folders, data sources, and cubes
• Setup Cognos Audit reports, Cognos Audit Extensions and System Monitoring Methodology to automate and load metric dumps to populate metric values in the Cognos Administration Scorecarding Dashboard
• Assist end-users with training, responding to questions and resolving problems
• Provide Customer Support to multiple County Departments on Cognos related issues

Technical Environment: IBM Cognos 8.3/10.1/10.2, IBM Virtual View Manager, Data Manager 10.1/10.2, Cognos TM1 9.4/9.5.2, Microsoft IIS , Transformer 10.1/10.2, SQL Server 2005/2008, Oracle 10g/11g, MS-Access, MS Active Directory, Oracle Internet Directory Server, Meta Manager

Confidential

Role: Cognos Administrator

Responsibilities:

• Install, Configure and Setup of Cognos 10.1 environments on a multi-server environment
• Installation and Configuration of TM1 9.5.1 suite TM1 Admin Server, TM1 Web, TM1 Architect, TM1 Perspectives, TM1 Contributor, and TM1 Portlets
• Upgraded TM1 environment from 9.4 to 9.5.1
• Manage security access for Cognos Connection and TM1
• Setup Single Sign on with Active Directory and Site Minder
• Setup SAP namespace on 64 bit Windows environment
• Add and Monitor jobs through Contributor Administration Console
• Applied patches and hot fixes to TM1 and EP Systems
• Supported Production Environment 24/7 for Cognos, IBM TM1, IBM Enterprise Planning systems and server infrastructure

Technical Environment: IBM Cognos 8.4/10.1, IBM TM1 9.5.1, IBM Enterprise Planning 8.4, IBM Contributor Administration Console, Microsoft IIS, Apache webserver, Site Minder, MS Active Directory, Oracle 11g, UNIX

Confidential

Role: Senior Cognos Consultant

Responsibilities:

• Monitor, tune, administer and support Countywide BI platform which includes three environments Dev, Test and Prod for three customer departments ISD, DPSS and Probation
• Installed, Configured and Maintained different versions of Cognos 8 across multiple environments
• Upgraded Cognos environments from Cognos Reportnet 1.1 to Cognos 8.2, Cognos 8.2 to Cognos 8.3, Cognos 8.3 to Cognos 8.4, Cognos 8.4 to Cognos 8.4.1 for CBI Platform and Cognos 8.1 to 8.3 for DPSS platform
• Installed and Configured Cognos Composite 4.5 and Cognos Virtual View Manager
• Upgraded Cognos Composite from version 4.01 to 4.5 and Composite 4.5 to VVM 8.4.1
• Installation and configuration of Cognos TM1 Admin Server, TM1 Web Client, TM1 Architect and TM1 Perspectives for Excel
• Migrated namespaces user profiles, schedules, preferences from Access Manager to Microsoft AD for CBI Access Manager to OID for DPSS
• Implemented data security through security filters and macros in Framework Manager
• Apply and Manage object security for content published to Cognos Connection Portal to control privileges for users, groups, and roles on packages, folders, data sources, and cubes
• Setup Cognos with external LDAP authentication mechanisms like Oracle Internet Directory, Sun one Directory Server, Microsoft Active Directory and Novell Directory Server
• Create and manage user, user classes/user groups, access rights, permissions and assign group memberships in Access Manager and Microsoft AD
• Setup Single Sign-on on Cognos environments with Microsoft Active Directory and OID
• Maintained security in Cognos Connection by controlling privileges for user, groups roles
• Setup Cognos Audit reports, Cognos Audit Extensions and System Monitoring Methodology to automate and load metric dumps to populate metric values in the Cognos Administration Scorecarding Dashboard
• Actively involved with DB team with the upgrade of SQL Server from version 2000 to 2008
• Assist developers with Framework Manager, Powerplay Transformer, Report Studio, Query Studio, Event Studio, Metric Studio programming problems or questions
• Performed selective as well as entire content store deployments
• Provide Customer Support to multiple County Departments on Cognos related issues

Technical Environment: Cognos 8.1/8.2/8.3/8.4/8.4.1, 10, Cognos ReportNet 1.1, Cognos Composite 4.5, Cognos Virtual View Manager, Data Manager 8.3/8.4.1, Cognos TM1 9.4, Cognos Go Office, Microsoft IIS , Transformer 7.4/8.3/8.4/8.4.1, SQL Server 2000/2005/2008, Oracle 9i/10g, MS-Access, Sun One Directory Server, Access Manager, Meta Manager

Confidential

Role: Senior Cognos Developer

The main purpose of the project is to convert the existing General Ledger reports that were built using Materialized Views to Database tables.

Responsibilities:

• Developed four Framework Manager Models for different General Ledger subject areas like Expenditure, Encumbrance, Budget and Revenue.
• Analyzed and Define mappings to build the Framework Manager Models and Packages with Query Subjects and Query items.
• Resolved ambiguous, hierarchical and recursive relationships in Framework Manager Model.
• Involved in design and development of filters, calculations and session parameters in Packages within Framework Manager.
• Developed List Reports, Cross-tab Reports and also some complex Reports using child tabular model and Tabular SQL.
• Testing and improving Report Performance and performing Query optimization.
• Extensive unit and performance testing for the reports and fixing report bugs.
• Created customized report templates for different type of reports list, cross-tab and chart .
• Created complex reports using union queries, conditional formatting and prompting, drill-through and HTML items.
• Expertise with creating page breaks, drill-through, and master/detail reports

Technical Environment: Cognos Reportnet1.1, Report Studio, Query Studio, Cognos Connection, Framework Manager, Cognos Scheduler, Cognos Query 7.3, Configuration Manager, Oracle 8i/9i, Oracle Toad, SQL Server 2005, HTML, MS-Access, MS- Excel

Confidential

Role: Cognos Administrator/Developer

Regions Bank is one of the largest banking and financial services organizations in southern U.S. The main purpose of this project is to track customers based on account's loan, renewal and maturity dates

Responsibilities:

• Installed and Configured ReportNet on WebSphere Application Server WAS for test and production environments on multiple servers.
• Integrated Cognos Series 7 Security to Cognos Report Net.
• Provided and set Single Sign-on in Cognos Reportnet using Series 7 Namespace.
• Maintained Security in Cognos by controlling privileges for users, groups and roles
• Setup users with security using Access Manager Administration
• Setting up User Groups/Roles in Access Manager to secure Cognos objects
• Testing and improving Report Performance and performing Query optimization.
• Extensive unit and performance testing for the reports and fixing report bugs

Technical Environment: Cognos Reportnet 1.1MR2, Report Studio, Query Studio, Cognos Connection, Framework Manager, Access Manager, Cognos Configuration, Oracle 9i/10g, Oracle Toad, Microsoft IIS, Websphere Application Server, SQL Server, HTML, MS-Access

Confidential

Role: Cognos Consultant

United Health Group is a leading health care provider the United States, which provides advanced health plan and health care services to its subscribers.

Responsibilities:

• Created several complex and professional Report Studio Reports over Oracle and SQL DB's
• Extensively worked on performance tuning in Framework Manager Model
• Created customized report templates for different type of reports list, cross-tab and chart .
• Testing and improving Report Performance and performing Query optimization
• Extensive unit and performance testing for the reports and fixing report bugs
• Expertise with creating page breaks, drill-through and master/detail reports
• Interaction with offsite team, coordination with users, Business Analyst and administrator
• Trained end users on Query Studio.

Technical Environment: Cognos Reportnet1.1, Report Studio, Query Studio, Cognos Connection, Framework Manager, Cognos Scheduler, Cognos Query 7.3, Configuration Manager, Oracle 9i/10g, Oracle Toad, SQL Server 2000, HTML, MS-Access, MS- Excel

Confidential

Role: Cognos Developer

Kaiser Permanente is a leading health care provider in the West Coast of the United States, which provides advanced health plan and health care services to its subscribers.

Responsibilities:

• Migrated existing Cognos series 7 applications to Cognos ReportNet 1.1
• Integrated Cognos Series 7 Security to ReportNet.
• Created multi-dimensional cubes using Power Play Transformer and deployed the same along with reports using Power Play Enterprise Server.
• Performance tuning power-cubes to reduce Query time and Partitioned Cubes.
• Trained end users on Query Studio for Ad-hoc reporting

Technical Environment: Cognos Reportnet1.1, Cognos Impromptu Administrator 7.1/7.3, Power play Enterprise Server 7.1/7.3, Impromptu Web Reports 7.1/7.3, Power play Transformer 7.1/7.3, Cognos Scheduler, Cognos Query 7.1/7.3, Cognos Upfront 7.1/7.3, Access Manager, Configuration Manager, SQL Server 2000, HTML, MS-Access, MS- Excel

Confidential

Role: Cognos Consultant

The Company specializes in selling and servicing quality personal line insurance products through more than 16,000 Good Neighbor State Farm Agents.

Responsibilities:

• Developed advanced reports using Report Studio and Adhoc reports using Query Studio
• Created various packages using Frame work manager in ReportNet
• Involved in Designing Models using Framework Manager
• Involved in installation and configuration of ReportNet and Framework Manager
• Involved in administration of servers using Cognos connection in ReportNet.
• Setup security using Access Manager Administration.

Technical Environment: Report Net 1.0, Framework Manager, Query Studio, Cognos Connection, Content Manager, Cognos Power Play 7.x, Cognos Transformer, Impromptu Web Reports, Upfront, Access Manager, PPES, Windows NT/2000, MS Access, SQL Server 2000

Confidential

Role: Cognos Developer This project is about Sales Management System Project and is built to facilitate the data warehousing of various business departments like Sales, Inventory Management, Budgeting, Production and Forecasting.

Responsibilities:

• Used to interact with users for requirement gathering
• Installed and Configured Cognos Suite
• Involved in analysis, and design the technical specifications to create Catalogs.
• Created folders, filters, prompts, calculations and stored in catalog.
• Created users and user classes through Access manager.
• Created and developed various reports like Business Mix Reports, Variance Reports
• Worked on Cross tab reports, drill-thru, linked-sub reports and sub reports

Technical Environment: Cognos Series 6.x/ 7.x, Impromptu, Powerplay Transformer, Powerplay for Windows/Excel, PowerPlay Enterprise Server PPES , IWR, Access Manager, Upfront, Oracle8i, SQLserver2000, Windows NT/2000

Confidential

Role: Systems Analyst

Responsibilities:

• Installed and configured Crystal Reports v 8.5 and MS SQL Server 2000
• Used Crystal Reports in designing formatted reporting along with chart indicators used sub reports to display RRI interface
• Optimized Crystal Reports performance for large reports

Technical Environment: Crystal Reports v7.x/8.0, SQL Server 2000, Data Transformation Service DTS , Windows 95/98, MS-Excel, MS-Access