SUMMARY

• Cognos Certified Business Intelligence Professional with 8(+) years of Complete BI project life cycle experience - Analysis, design, Administration, configuration, development and implementation of Business Intelligence systems esp IBM Cognos
• 8 years Business Intelligence experience using Cognos Series 10.x, Series 8.x, Report Net, and Series 7 - Impromptu 7.1/6.6/6.x, PowerPlay, Transformer, Impromptu Web Reports (IWR), Upfront, Power Prompts, Visualizer, Cognos Query, Architect, Powerplay Enterprise Server, Cognos DecisionStream, Scripting, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Event Studio, Metrics Studio, Map Manager, Business Insight, Business Insight Advanced, Active Reports.
• Strong experience in Installation, Configuration, Monitoring and Management of Cognos on both UNIX and Windows platforms. Expertise in defining the multi-tiered Cognos Architecture, Performance tuning, Security infrastructure and Deployment work flows from Prod, Dev and Test environments. Efficient in Optimizing, Debugging and testing SQL queries and stored procedures written in Oracle and SQL Server
• Expertise in Metadata Modeling- Advanced Relational Model as well as Dimensional Modeling (DMR) modeling with Cognos recommended approach, Create project, Prepare Metadata, Prepare the Business View, Create and Manage packages, Set security and publish into portal.
• Experienced in ETL Tools. Knowledge in extracting data from source systems (Oracle, MSSQL and DB2) and bringing it into the data warehouse utilizing an ETL tool like COGNOS Data Manger, INFORMATICA, SSIS.
• Expertise in Data Modeling for DW using Erwin. Strong experience in creating reports using Relational, DMR models, Transformer Cubes, TM1 Cubes as data sources in Report Studio.
• Proficient in RDBMS and good programming experience in Oracle10.x/9.x/8.x/7.x, SQLServer 2008/2005/2000, SQL, PL/SQL, T-SQL, Stored Procedures, Functions, DTSpackages, DB Triggers, Stored Procedures, Functions and Packages.
• Experienced in Migration Projects (Cognos Series 7 to ReportNet/Cognos 8.x, Cognos 10.x and from Cognos 8.x to Congos 10.x. as well Maintenance and support of existing Reports and OLAP Cubes.
• Good team player with excellent communication skills, analytical and problem solving, time management skills. Provided Professional Cognos & DW Training to the Resources.

TECHNICAL SKILLS

Hardware and OS: Windows XP/7, Windows 2003/8, UNIX and MS DOS

Languages: Java, JSP, C, C++, SQL and PL/SQL

Cognos: Series 7.x/8.x/10.1Cognos version 10.2, Business Insight, Business Insight Advanced, Active Reports, Report Studio, Framework Manager, Cognos for MS Office, Cognos Analysis for MS Excel, Cognos version 8.3 & 8.4, Report Net, Cognos Connection, Metric Studio, Query Studio, Analysis Studio, Report Studio, Event Studio, Framework Manager, Cognos 8 Go Office, Office Connection, Metrics Designer, Metric Studio, Map Manager, TM1, Impromptu Administrator, Impromptu Web Reports (IWR), Upfront, Power Prompts, Visualizer, Cognos Query, Architect, Powerplay Enterprise Server

ETL Tools: Informatica Power Mart v8.1/7.0 & Power Center v8.1/7.0, Microsoft, SQL Server DTS 2005/8.

Data Modeling Tool: Erwin 3.5.2/4.0

Databases: Oracle 10g/9i/8.i/7.x, MS SQL Server 2008/2005, Sybase, DB2

DB Tools: SQL*Plus, SQL*Loader, TOAD 8.3/7.6

Testing Tools: Mercury Tools Load Runner, Win Runner and Test Director.

Web Servers: IIS, Apache.

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Sr. Cognos Developer

Responsibilities:

• Actively involved in documenting the business requirements, software requirements and translated them to technical specifications.
• Participated in Business Intelligence Core Group meetings for schema design and physical data modelling.
• Involved in development of Framework models based on a star schema and Cognos Reports based on the specifications.
• Performed cutover activities for application migration, distribution management and do performance tuning of the existing data models along with scheduling of Cognos Reports.
• Implemented Complex row level security apart from the data level, object level security in the Frame work manager, using the sessions parameters and security tables.
• Implemented Quality assurance methods including unit testing of Business Intelligence Solutions that ensured consistent delivery of defined solution
• Performed installation of Cognos Framework.
• Ensured overall integrity of the Cognos Models. and shared information and established best practices for BI and performed post implementation support.
• Trained the users on how to use the Ad-hoc reporting tools Query Studio, Business Insight and Business Insight advanced.
• Involved in DEV, TEST & PROD environments deploying Reports & Packages from Development to Testing Environment and from Testing to Production Environment using Deployment.
• Created Detailed Design document and Impact Analysis document.
• Conveyed complex technical information to people with all backgrounds and skill level.

Environment: Cognos 10.2 (Framework Manager, Cognos Connection, Business Insights, Business Insight Advanced, Active reports, Dashboard reports), Cognos 8.4 (Query Studio, Report Studio, Analysis Studio, Event Studio), Cognos Transformer 10.1,Cognos Transformer 8.4, HTML, Oracle Database 11g, EDW (Enterprise Data warehouse), SQL Server 2012,Windows 2003 Server.

Confidential, El Segundo, CA

Cognos Tech Lead

Responsibilities:

• Actively involved in documenting the business requirements, software requirements and translated them to technical specifications.
• Involved in development of Framework and Cognos Reports based on the specifications.
• Performed cutover activities for application migration and do performance tuning of the reports
• Ensured proper coordination among my team and with other teams, including the Business Analysis, Production Support and Quality Assurance in order to perform System Integration Testing and support User Acceptance Testing.
• Designed data access solution to satisfy design business requirements and created deliverables such as functional specifications, technical specifications, data flow diagrams, context diagrams, and test plans
• Ensured overall integrity of the Cognos Models. and shared information and established best practices for BI and performed post implementation support.
• Trained the users on how to use the Ad-hoc reporting tools Query Studio, Business Insight and Business Insight advanced.
• Worked on Fine-tuning the queries and Enhancement of the performance of the existing Reports and Data Models.
• Involved in DEV, TEST & PROD environments deploying Reports & Packages from Development to Testing Environment and from Testing to Production Environment using Deployment.
• Created Detailed Design document and Impact Analysis document.
• Trained/assisted end users and team members to operate, troubleshooting running the reports and its performance in Cognos environment.

Environment: Cognos 10.2 (Framework Manager, Cognos Connection, Business Insights, Business Insight Advanced, Active reports, Dashboard reports), Oracle Database 11g, EDW (Enterprise Data warehouse), SQL Server 2005,Windows 2003 Server. OPLA version 3.3.1

Confidential, Los Angeles CA

Cognos Tech Lead

Responsibilities:

• Analyzed the functionality and business requirement and transformed the Functional Design Document into Technical Design Document. Conducted User Interviews and documented their query, business analysis and reporting needs. Understood data and business logic with reporting viewpoint.
• Install Multi-server Dispatcher Cognos installations for Dev/QA/Pseudo Prod/Prod Environments. Crete/Maintain Cognos User classes and groups with Windows Role Based Structure and user account provisioning.
• Install/setup Cognos 10.1 software. Upgraded the Cognos 8.x reports. Troubleshoot upgrade problems/fix issues. Created and managed agents using Event studio, which monitors the data and performs the task when an event occur
• Involved in ETL process by requesting the ETL team for custom calculation columns and complex logics to be implemented at the database level, in order to improve the performance of the report, while fetch and load data to Various Target Tables
• Developed Framework Manager Models (both relational and DMR models) to meet the reporting requirements, Created Import View, Business View and Star schema grouping Dimensional Views in Framework Manager.
• Implemented Complex row level security apart from the data level, object level security in the Frame work manager, using the sessions parameters and security tables.
• Designed and developed numerous list, crosstab, multi-query, multi-page reports utilizing the master-detail relationship, conditional blocks, conditional formatting, unions, etc.
• Created multiple complex and interactive Dashboard reports and Active reports with List Reports, Crosstab and Chart Reports, Repeaters, with Master Detail and Drill through functionality.
• Developed various reports with calculations, Conditions & Filters, Query Prompts, Cascading prompts, Prompt Pages, Variables using Cognos Report studio.
• Developed Prompt pages and report pages, using the Java script and HTML items for the custom functionality as per the user requirements.
• Extensively worked on Powerplay Transformer for Data Modeling of the Rx data, building Multidimensional Cubes. Created numerous power play reports and analysis studio reports using the multi dimensional power play cube. Experienced with trouble shooting and optimizing cube performance
• Trained the users on how to use the Ad-hoc reporting tools Query Studio, Business Insight and Business Insight advanced.
• Worked on Fine-tuning the queries and Enhancement of the performance of the existing Reports.
• Created User groups, roles to implement the Cognos Security using LDAP. Scheduled the various reports as per user requirements, using the report bursting feature as well as the Event studio to create the agents and tasks.
• Involved in DEV, TEST & PROD environments deploying Reports & Packages from Development to Testing Environment and from Testing to Production Environment using Deployment.
• Created Detailed Design document and Impact Analysis document.
• Trained/assisted end users and team members to operate, troubleshooting running the reports and its performance in Cognosenvironment.

Environment: Cognos 10.1 (Framework Manager, Cognos Connection, Business Insights, Business Insight Advanced, Active reports, Dashboard reports), Cognos 8.4 (Query Studio, Report Studio, Analysis Studio, Event Studio), Cognos Transformer 10.1,Cognos Transformer 8.4, HTML, Oracle Database 10g, EDW (Enterprise Datawarehouse), SQL Server 2005,Windows 2003 Server.

Confidential, North Brook, IL

Sr. Cognos Analyst / Admin

Responsibilities:

• Involved in Full life Cycle of the Project from Installation& Configuration, Administration, Development, Testing, Troubleshooting and support for the production applications.
• Scaled the production environment from a single server to a multi-tiered architecture that included 4 application servers and 1 web gateway server to allow more concurrent users
• Administered the Scheduling and Distributing Reports through Schedule Management in Cognos Connection and Bursting reports to different user groups
• Installed and configured Sun One LDAP directory server, IIS server and migrated all the security from the old to the new servers. Migrated Cognos 7 Upfront, IWR reports, PPES, Cubes, automation scripts and all the scheduled jobs over to the new data center. Migrated all Cognos 8.4 related content including Cognos Content Store and data source connections.
• Installation of various Cognos tools in distributed environment (Development, Test and Production).
• Customized Cognos Connection with appropriate reports and security measures.
• Implemented Single sign on Security with LDAP and Group level security in Cognos Connection Portal.
• Involved in Analysis of Functional/Business Requirements and design the Technical specifications.
• Involved in Design and Development of Framework Manager Models for Various Business Applications
• Involved in implementing security to Package Level, as well as Object and Data Level security by restricting users.
• Involved in enhancement and testing of existing application to satisfy business requirements.
• Development of Complex Report Studio Reports using IBM Cognos 8.4 Report Studio, Design reports with Multiple Complex queries, Joins, Unions and diff prompts, Calculations and Filters. Designed Reports using Drill-throughs, Java/HTML Scripts, Master-Detail Relationships, Ad-hoc querying using IBM Cognos 8.4 Report Studio.
• Developed Dashboard reports using Cognos Portlet, Applied Global Filters, also used the Go Dashboard applications to show the Various KPI's.
• Created Database Objects like Tables, Views, Stored Procedures, and UDF's in the database for projects involving new bus applications.
• Implemented and Enhanced Indexes for performance tuning of Tables. Provide recommendation for performance tuning of IBM Cognos Framework Models and Report Studio Reports. Write Complex SQL/T-SQL queries for analysis, testing and troubleshooting purposes.
• Developed Multi dimensional models using 8.4 Transformer, designed and published packages to re-place existing IQD based data sources on transformer models with Framework manager query subjects. Installed & gave training on C8.4 Powerplay client for business users
• Migrating all cubes in C7 to C8 using Transformer and modifying the models as per the new business requirements with enhancements.
• Experienced with Development, troubleshooting and performance tuning of IBM Cognos 8.4 BI Cubes.
• Involved in Ad-hoc testing of reports and also performed Complex Report testing.

Environment: Cognos 8.4/IBM Cognos 8.4 Framework Manager, Cognos Connection, Cognos Report Studio 8.4, Cognos Query Studio 8.4, Cognos Analysis Studio 8.4, Cognos 8.4 BI Transformer, Dashboards, Metrics Studio, Event Studio, Windows XP Professional, Oracle 10g, Oracle 11g, Toad 9.0, Linux, Putty, Unix, SQL/PL-SQL, Microsoft SQL Server 2005/2008, SSIS, HP Quality Center 10.0, TM1 9.5, Java 1.5.

Confidential, SAN FRANSCISCO, CA.

Cognos Developer / Adminstrator

Responsibilities:

• Analyzed the existing system & reporting requirements and interacted with Business users and collected business information and their requirements for developing the Framework Models and different types reports using Cognos 8
• Lead and implemented the successful Cognos migration project which involved the migration of existing numerous reports, catalogues into cognos 8.
• Involved in the installation & integration of ReportNet SDK with Cognos 8. Also developed a renaming utility using SDK to rename the busted reports for better distribution of the reports to various user groups.
• Involved in administration, migration and support of existing 20+ Catalogs and query definition files using various joins and filtering conditions using Impromptu administrator
• Provided technical support and administration for the existing powerplay cubes
• Performed Metadata Modeling using the Cognos 8 Framework Manager and published the packages.
• Created dimensions, levels and hierarchies using Framework Manager.
• Created simple and Ad hoc reports using Query studio.
• Involved in creation of advanced reports using Report Studio.
• Developed list reports, cross tab reports, chart reports, reports with multiple prompts, cascading prompts and Filters.
• Created complex reports such as dashboard reports, master detail reports, drill through reports.
• Applied model filters, query filters, user access filters, detail filters and summary filters to generate user specific reports.
• Involved in applying conditional formatting in reports.
• Involved in bursting reports to several users.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Documented Design documents based on the requirements document and also documented Unit test case results.
• Worked closely with Business Users in order to rectify any defects within the Developed code/Migrated code to Higher environments in order to avoid any Production failures or any mismatch of the data.
• Worked closely with the Configuration Managements teams in order to avoid any failures or code mismatches in Production migrations.
• Worked closely with Database Administration teams in order to develop many complex SQL queries and avoid any time consuming Queries.
• Involved in all the Phases of deployment of code from Development until Production.
• Developed separate Complex reports for the 3rd Party sources which were used for the Audit purpose.
• Designed the Cognos Connection portal according to user specifications.
• Trained users on navigation and creating simple reports in query studio.

Environment: Cognos 8.1, Framework Manager, Power Play Transformer, Power Play, Impromptu 7.1, PowerPlay, Transformer, Impromptu Web Reports (IWR), Upfront, Power Prompts, Visualizer, Cognos Query, Architect, Powerplay Enterprise Server Access Manager and Windows 2005, Clear Case, Clear Quest, Toad, Oracle 10g.

Confidential, Chicago, IL

DW / BI Developer (Informatica, Cognos)

Responsibilities:

• Analysis of the requirements for the creation of CRN reports.
• Migrated catalogs and reports from Cognos 7.3 to Cognos 8.2 and CRN Reports to Cognos 8.2.
• Migrated powerplay cubes and reports from Cognos 7.3 to Cognos 8.2.
• Involved in the design and development of CRN reports in Report Studio.
• Developing Standard Reports, List, Cross tab, Charts, Drill-through Reports, Master Detail Reports, using Report Studio and Query Studio.
• Created query prompts, calculations, conditions and filters in Report Studio.
• Developing prompt pages and conditional variables using Report Studio.
• Experience with conditional blocks and conditional layouts.
• Created the data sources in Cognos Connection.
• Upgraded the existing (Cognos ReportNet 1.1 MR2) Models and Packages to Cognos 8 BI environment.
• Converted the existing ReportNet 1.1 reports to Cognos 8 BI reports.
• Maintain Cognos software (Upgrade, apply patches etc).
• Involved in deployment of applications to production.
• Troubleshoot the errors during the upgrade process.
• Manage Cognos Portal and all content in the portal.
• Interacting with the Cognos support team and creating & following-up the cases in the Cognos support site.

Environment: Cognos 8 BI, Power Play Transformer 8.0, 7.0, Upfront 7.0, Access Manager, Oracle 9i (SQL, PL/SQL), Enterprise Datawarehouse (EDW), Windows NT, UNIX.