SUMMARY

• IBM certified Cognos ReportStudio Developer, FrameworkManager Modeler
• 8 years of professional experience as IT consultant in Client/Server, Data Warehouse/Data Mart and Business Intelligence tools.
• 7+ years of experience in Cognos Impromptu, PowerPlay Enterprise Server, PowerPlay Transformer, Impromptu Web Reports (IWR), Upfront, Cognos Query, Cognos Visualizer, Cognos Decision Stream.
• 6 years of experience in Cognos 8 Framework Manager Modeling, OLAP modeling using Cognos8 Transformer, Cognos 8 Connection, Analysis Studio, Report Studio, Query Studio and nearly 3 years of experience in Cognos ReportNet 1.1 MR2/MR3.
• Actively implemented and lead Cognos 10.2 BI implementations for two projects.
• 1+ years of hands on experience in TM1 Architect, Turbo Integrator, EXCEL Perspectives, Contributor.
• Worked on 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 to customers.
• Experienced in building Dimensional Models using Cognos8 Framework Manager
• 4+ years of experience in building multi-dimensional cubes in Powerplay Transformer.
• Experience in building Multi Duimensional cubes in TM1 Atchitect and writing Turbo Integrator processes.
• Extensive experience in building dashboards using Cognos8 Go Dashboards & Cognos10 Business Insight.
• Experience in various Mappings, Mapplets, Transformations, scheduling the Sessions & Batches for ETL process using Informatica tool.
• Hands on experience in building simple to complex reports in Reportstudio 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, QueryStudio and Analysis Studio 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

BI/FPM Tools: Cognos10, TM1 10, TM1 Architect, Perspectives, Turbo Integrator, Framework Manager, Powerplay Transformer, Query Studio, Report Studio, Cognos Reportnet, Cognos EP 7 series Impromptu, Impromptu Web Reports.

ETL Tools: Informatica Power Center/ Power Mart 7.1/6.1

Operating Systems: Windows 2000/NT/98/95 XP, Unix (Sun Solaris, AIX, HP-UX)

GUI: TOAD 8.0, Oracle Developer 2000 (Forms 5.0/4.5 & Reports 3.0/2.5), IBM VisualAge for Java, JBuilder

Tools: Erwin Data Modeler, Rational Rose, SQL* Plus, SQL* Loader

RDBMS: Oracle 12/11/10g, 9i, 8i, DB2 UDB, MS Access, SQL Server2005/2000,Teradata

Languages: JAVA, Servlets, EJB, JSP, ASP, JavaScript, HTML, XML, SQL, PL/SQL, CGI-PERL

PROFESSIONAL EXPERIENCE

Confidential

Sr Cognos Developer/ Admin

Responsibilities:

• Extensively worked on understanding the business requirements and designing Cognos frontend.
• Actively involved in C-10.2.1 migration project(Distributed environment)
• Installed and configured TM1 10.2. Modifed configuration files’ settings as part of performance tuning reports built on TM1 cubes.
• Actively worked on TM1 architect. Created Turbo Integrator processes and built TM1 cubes and Dimensions.
• Documented development work, tested reports as well as resolved break-fixes during the test cycles and logged the defect in Fogbugz.
• Created nearly 10 packages in Framework Manager to satisfy Ad-hoc / complex reporting needs of Sales, Marketing, 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 to CognosConnection within a package.
• Worked with executive, management and end user reporting as part of presentations, demos and training on Ad-hoc reporting using AnalysisStudio.
• Trained C-level executives on creating Dashboards using Cognos WorkSpace.
• Trained technical and non-technical users on the use of Cognos tools.
• 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 ReportStudio to generate efficient and user-friendly reports.
• Created standard filters, calculation prompts, and conditions in the reports to validate the integrity of the data based on end user needs.
• Improved cube build time and access time by consolidating data and incrementally updating the cube. Implemented Cube Partitions.
• Extensively worked with DBA on creating indexes, partitions, and Materialized Views where needed.
• 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
• Applied object - level security within Framework manager and OLAP cubes.

Environment: Cognos10.2.1, TM1 10.2, Oracle 11G, MS Project, MS Excel, IBM Rational Clear Quest.

Confidential

Sr. Cognos/TM1 Consultant

Responsibilities:

• Gathering User requirements and reviewing them from a technical perspective and conduct meetings with end users to establish business rules, schedule deliverables and identify potential issues that could impact the development effort.
• Migrated Business Intelligence from Cognos 8.4 to Cognos 10.1.1.
• Involved in Installing, Configuring and Maintaining Cognos Products. Configured AD Server for BI Authentication.
• Actively participated in the installation and configuration of TM1. Upgraded TM19.4 to 9.5.
• Created batch scripts calling/starting TM1 servers as part of integrating with ETL jobs on windows 2003 servers.
• Interacted with the user community and development teams for gathering information for creating the Models using Framework manager and OLAP Cubes in TM1 architect.
• Built 3 TM1 cubes. Created nearly 10 TI processes.
• Interacted with the user community and development teams for gathering information for creating the Model using Framework manager.
• Created Framework Manager models based on both 3rd NF sources and Star Schemas.
• Created scorecard reports and dashboard using Cognos 10 Workspace. Trained end users on the same.
• Developed ad-hoc reports, drill through reports and created master detail relationship to burst a crosstab report using Report Studio
• Built complex reports using custom SQLs, joins, bursting, unions, except
• Designed model using power play transformer and created multiple cube views.
• Created a JavaScript to execute a report with multiple parameters and to submit a job and pass parameters to the reports in the job using Cognos SDK.
• Deployed the packages and reports from Dev to QA and QA to production environments
• Created Power Play reports by performing the drill down, slicing and dicing operations on the Power Play cubes to allow the business user to 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 10.1.1(Report studio, Query Studio, Analysis Studio), Powerplay Transformer, Cognos 8 Framework Manager, Cognos SDK 8.4, Oracle 11i, TOAD, Windows.

Confidential, Reston, VA

Cognos 10 Developer

Responsibilities:

• Designed, developed and implemented Cognos 10 best practice methodologies to support thebusinessrequirements and processes for various locations both within and outside the US.
• Installed TM1 & Cognos 10.2 on development environment and conducted POCs.
• Installed and configured Cognos 10.1.1 on a single server, and migrated the entire BI platform from Cognos 8 to Cognos 10 in one month time frame.
• Installed and configured C10 on distributed UNIX and SunSolaris environment.
• Configured Apache as a WebServer for Cognos Gateway. Enabled WebDav on Apache.
• Created and deployed Cronjobs for automation.
• Actively participated in regression testing and UAT. Logged enhancements with IBM where needed.
• Created Enterprise Template to be used in Report studio for creating new reports.
• Customized Cognos Connection portal by creating additional skins/fonts.
• Demonstrated the capability of building Dashboards in Cognos 10 Business Insight. Trained Executives and Business users on the same.
• Analyzed existing Framework Manager Models and performance tuned to reduce the report’s runtime and not generate unnecessary splits.
• Rebuilt 5 mostly viewed complex reports in Report Studio as part of Performance Tuning to reduce the run-time by at least 50%.
• Used IBM Mashup services as part of Widgets’ creation, so that executives can have those widgets on their desktops.
• Implemented Data level Security in Powerplay Transformer and TM1.
• Created drill-through relationships between Cognos10 Cube and a relational report. Implemented Bursting.
• Created a company template for Report Studio developers. Modified configuration files to deploy the template under File/Open window.
• Built three cubes in Powerplay Transformer using Cognos10 packages as source and embedded security.
• Replaced Java scripts, custom SQLs in some of the reports with Cognos 10 new features avoiding further maintenance.

Environment: Cognos 10 BI (Framework Manager, Report Studio, Query Studio, Analysis Studio), TM1 10(Architect, Turbo Integrator), IBM CognosPortlets, TOAD, Oracle 9i, UNIX, Sun Java Systems Web Server 6.1

Confidential, Portland, OR

Cognos Developer/Administrator

Responsibilities:

• Trained Business Analysts on using the new features of Cognos 8.4 Report Studio and Query Studio so effectively that client would need less Report Studio Licenses compared to ReportNet’s earlier version.
• Provided technical assistance, training and mentoring to Users and Business Partners for automating tasks and Job Scheduling.
• Worked independently in achieving optimization techniques for the Impromptu and ReportNet reports
• Installed and configured Cognos ReportNet 1.1 MR2.
• Actively participated in the installation and configuration of Cognos 8.4
• Worked closely with the client’s security team and deployed MS Active Directory Server as an authentication source. Also 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 who got CRN licenses for ReportStudio/QueryStudio.
• Built models and published packages to the ReportNet Server by embedding required security in Framework Manager.
• Performed migration of Cognos impromptu reports to Cognos ReportNet 1.1 using Cognos migration utility tools. This included formatting the reports and correcting them to run against the corresponding ReportNet package
• Migrated the existing Cognos ReportNet Reports 1.1 MR2 to Cognos 8.4.
• Created nearly40 different reports to explore the new advanced features of Cognos 8. This included 30 report studio reports.
• Developed complex reports (list, crosstab, chart, drill through etc,.) in Report studio by developing filters, calculations, prompts, conditions in reports.

Environment: Cognos 8.4 (Framework Manager, Report Studio, Query Studio, Cognos Connection), Oracle 9i, TOAD and Sun Solaris Server.

Confidential, Buffalo, NY

Cognos Developer/Administrator

Responsibilities:

• Migrated the existing Cognos Series 7 reports to Cognos 8
• Converted over 100 reports from Impromptu to Report Studio (C8) and about 50+ PowerPlay reports into Analysis Studio.
• Created data sources for various phases of the project.
• Modeled metadata in Framework Manager and set relationship cardinalities to 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 Studio using advanced features like Cascading Prompts, Drill Throughs, and Bursting.
• Worked closely with the administrator to modify the appearance of the Cognos portal 8.1.2 and Report viewer with Java Scripting.
• Developed and maintained reports to audit the report user's activities and reported this on a monthly basis to 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 (to a certain extent).
• Created user accounts using Cognos connection and then determined capabilities.
• Maintained/Updated report & Framework documentation from time to time.
• Helped users understand the uses of the Cognos BI tool and trained them to 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 to get their job done efficiently and effectively

Environment: COGNOS 8.2 (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.