SUMMARY

• 8 years of professional experience as IT consultant in Administration, Framework Manager, Report Studi and Cognos Power play, Client/Server, Data Warehouse/Data Mart and Business Intelligence tools.
• 6 years of experience in Cognos Impromptu, Power Play Enterprise Server, Power Play Transformer, Impromptu Web Reports IWR
• 5 years of experience in Cognos 8 Framework Manager Modeling, OLAP modeling using Cognos8 Transformer, Cognos 8 Connection, Analysis Studio, Report Studio, Query Studi and nearly 3 years of experience in Cognos ReportNet 1.1 MR2/MR3.
• Worked on the complete Life Cycle Development process using Cognos as a BI tool.
• Experience in gathering end-user business requirements and providing specific direction, training and mentoring t customers.
• Experienced in building Dimensional Models using Cognos8 Framework Manager
• 4 years of experience in building multi-dimensional cubes in Powerplay Transformer.
• Extensive experience in building dashboards using Cognos8 G Dashboards Cognos10 Business Insight.
• Experience in various Mappings, Mapplets, and Transformations, scheduling the Sessions Batches for ETL process using Informatica and SSIS tools.
• Hands on experience in building simple t complex reports in Reportstudi like Sparkline Charts, Master-Detail, Self Drillthroughs, complex crosstabs, bursting etc.,.
• Proficient in implementing Stored Procedures, Triggers, Functions, and Packages using PL/SQL
• Expertise in UNIX environment. Good knowledge of Unix Shell Scripting.
• Proficient in training end users and junior level developers on the usage of Cognos Connection, QueryStudi and Analysis Studi and documenting the same.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent written and verbal communication skills
• Excellent analytical, interpersonal and communication skills and a versatile team player

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Cognos BI /TM1 Developer

Responsibilities:

• Administration
• Created POCs for TM1 C-10 including Cognos Business Insight.
• Actively involved in C-10 migration project. Created Regression test plan.
• Installed and configured C-10.1.1 on distributed servers. Deployed Cognos content from Test->QA->UAT->Prod.
• Worked with IBM Cognos support as part of logging bugs and enhancements.
• Installed and configured TM1. Integrated TM1 with IBM Cognos.
• Worked with IBM Cognos support as part of logging bugs and enhancements.
• Improved cube build time and access time by consolidating data and incrementally updating the cube. Implemented Cube Partitions.
• Framework Manager, Transformer Report Building:
• Extensively worked with DBA on creating indexes, partitions, and Materialized Views where needed. Created SSIS/Informatica mappings.
• Created cube groups and user class views suppress, cloak and exclude in Transformer.
• Worked on performance tuning of the reports based on the report queries generated at the database level
• Created nearly 10 packages in Framework Manager t satisfy Ad-hoc / complex reporting needs of Sales, Marketing, and Operations. Modeled using both Star Schema and Snow-flake Schema.
• Extensively worked on OLAP modeling and built multidimensional cubes in Powerplay Transformer using Datasource Querysubjects created in FrameworkManager Model and publishing them t CognosConnection within a package.
• Created 3 TM1 cubes in 6 month timeframe using TM1 Architect and Turb Integrator.
• Monitored data quality, resolving problem data issues, and ensuring timely updates.
• Extensively used prompts, drill-through, master-detail query relationships, conditional formats, grouping and sorting, Bursting features of ReportStudi t generate efficient and user-friendly reports.
• Created standard filters, calculation prompts, and conditions in the reports t validate the integrity of the data based on end user needs.

Environment: Cognos 8.4, Cognos10.1, TM1 9.5.2, Oracle 11G, MS Project, MS Excel, IBM Rational Clear Quest.

Confidential

Sr. Cognos/TM1 Consultant

Responsibilities:

• Installed and configured Cognos on a distributed platform.
• Demonstrated the capability of modeling and building Cognos10 PowerCubes on a Sun SOLARIS platform by using script and commands.
• Gathered User requirements and reviewed them from a technical perspective and conducted meetings with end users t establish business rules, schedule deliverables and identify potential issues that could impact the development effort.
• Actively written batch scripts as part of deploying and running Cognos10 Power Cubes on UNIX prod box.
• Created scorecard reports and dashboard using Cognos 8 report studio.
• Developed ad-hoc reports, drill through reports and created master detail relationship t burst a crosstab report using Report Studio
• Designed model using power play transformer and created multiple cube views.
• Created a JavaScript t execute a report with multiple parameters and t submit a job and pass parameters t the reports in the job using Cognos SDK.
• Deployed the packages and reports from Dev t QA and QA t production environments
• Created Power Play reports by performing the drill down, slicing and dicing operations on the Power Play cubes t allow the business user t review the data differently.
• Documentation of the report results and updated daily with the testing results.
• Participated in the testing of the developed reports and reported the defects.

Environment: Cognos 8.4 Report studio, Query Studio, Analysis Studi , Powerplay Transformer, Cognos 8 Framework Manager, Cognos SDK 8.4, Oracle 11i, TOAD, Windows, Sun SOLARIS.

Confidential

Cognos8 Developer

Responsibilities:

• Migrated the existing Cognos Series 7 reports t Cognos 8 MR1, MR2
• Converted over 100 reports from Impromptu t Report Studi C8 and about 50 PowerPlay reports int Analysis Studio.
• Created data sources for various phases of the project.
• Modeled metadata in Framework Manager and set relationship cardinalities t retrieve accurate data.
• Followed Cognos best practices by creating Database Presentation Views.
• Accommodated repetitive calculations within the Framework for increased performance levels.
• Explored new features like Data and Conditional formatting in Query Studio.
• Developed complex reports in Report Studi using advanced features like Cascading Prompts, Drill Throughs, and Bursting.
• Worked closely with the administrator t modify the appearance of the Cognos portal 8.1.2 and Report viewer with Java Scripting.
• Developed and maintained reports t audit the report user's activities and reported this on a monthly basis t the project manager.
• Optimized cube metadata access by running the cube optimizer utility.
• Updated cubes using macros built with Cognos Script Editor.
• Coordinated with the DBA in creating aggregate / summary tables.
• Ensured data accuracy and quality of the report result by running queries against the database.
• Performed all the tasks from deployment, installation, configuration, development and administration t a certain extent .
• Created user accounts using Cognos connection and then determined capabilities.
• Maintained/Updated report Framework documentation from time t time.
• Helped users understand the uses of the Cognos BI tool and trained them t an extent where they can create their own day-to-day reports.
• Trained users on the Framework front. Helped them manipulate relationships and have a work around in order t get their job done efficiently and effectively

Environment: COGNOS 8 MR 1, MR2 Framework Manager, Analysis Studio, Query Studio, Report Studio, Cognos Connection , Cognos Series 7 Version 3 Impromptu Administrator, Access Manager, PowerPlay Transformer for Windows, PowerPlay client for Windows, Cognos Script Editor, Scheduler , Oracle 9i, TOAD and Win2003 Server.

Confidential

Cognos ReportNet Developer/Administrator

Responsibilities:

• Trained Business Analysts on using the new features of Cognos 8 Report Studi and Query Studi s effectively that client would need less Report Studi Licenses compared t ReportNet's earlier version.
• Provided technical assistance, training and mentoring t Users and Business Partners for automating tasks and Job Scheduling.
• Worked independently in achieving optimization techniques for the Impromptu and ReportNet reports
• Administration:
• Installed and configured Cognos ReportNet 1.1 MR2.
• Actively participated in the installation and configuration of Cognos 8
• Worked closely with the client's security team and deployed MS Active Directory Server as an authentication source. Als worked closely with the IIS Web Server's team in establishing SingleSignOn between ReportNet and AD Server.
• Used Cognos Connection for organizing, securing, scheduling and distributing reports
• Created user accounts using Cognos connection and then determined capabilities for the users.
• Configured an another namespace Cognos Series 7 using Cognos Configuration apart from MS AD Server as there were some Impromptu users wh got CRN licenses for ReportStudio/QueryStudio.

Development:

• Built models and published packages t the ReportNet Server by embedding required security in Framework Manager.
• Performed migration of Cognos impromptu reports t Cognos ReportNet 1.1 using Cognos migration utility tools. This included formatting the reports and correcting them t run against the corresponding ReportNet package
• Migrated the existing Cognos ReportNet Reports 1.1 MR2 t Cognos 8.
• Created nearly 40 different reports t explore the new advanced features of Cognos 8. This included 30 report studi reports.
• Developed complex reports list, crosstab, chart, drill through etc., in Report studi by developing filters, calculations, prompts, conditions in reports.

Environment: COGNOS ReportNet 1.1 MR2 Framework Manager, Report Studio, Query Studio, Cognos Connection , Cognos 8.1.1, Windows Modeling tool Framework Manager 8.1.1, COGNOS 7.3 Impromptu Administrator, IWR, Server Administration, Report Administration, Access Manager, Upfront , Oracle 9i, TOAD and Sun Solaris Server.