SUMMARY

• Around 7 years of IT experience in Enterprise Planning and Business Intelligence systems such as Analysis, Design, Development, Deployment, Testing, and Dimension Modeling. Worked extensively in various versions of COGNOS BI and TM1 and involved in implementation of complete life cycle of BI.
• Around 4 years of experience in Cognos TM1 (10.1.1/9.5.2/9.5/9.4 )
• Around 6 years of experience in COGNOS 10 (10.1.1/10.1 ) (Framework Manager, Report Studio, Analysis Studio, Query Studio, Business Insight, Business Insight Advanced, Cognos Connection and Transformer), wif COGNOS 8 (8.4/8.3/8.2)
• Experience in TM1 server maintenance and Administration
• Experience in Cognos Administration, in server maintenance, Migration and version upgrade
• Created Security groups in Cognos and assigned at various levels
• Experience in Advanced Turbo Integrator scripting
• Extensively worked on Rules to apply business rules to a cube
• Experience in scheduling Turbo Integrator process using Chores
• Expert in implementing dynamic security at all levels of TM1 objects
• Expert in creating Active Reports in Cognos 10 Report Studio.
• Experience working wif Cognos Metric Studio in creating customized scorecards and analyze business metrics
• Trained power users in Business Insight Advanced to create reports using externalized metadata.
• Proficient in meta data modeling wif Framework Manager and experienced in layered approach such as Physical Layer and Business Layer, Presentation Layer...etc
• Experience in DMR modeling wif Framework Manager
• Outstanding experience in creating report layout as List, Cross Tab, Chart and Repeater table
• Created complex reports wif advanced features such Master detailed sections, Conditional formatting, Render variables, Drill - through, Page Set, Java Script and Bursting using Report Studio
• Experience in gathering requirements from teh power users and modeling accordingly
• Used Analysis studio for multi-dimensional analysis and created context filters for better performance
• Implemented security at Cubes using Apex, Cloak, Suppress, Exclude
• Experience in databases such as Oracle 10g/9i/8g, SQL SERVER 2000/2005, DB2 and Teradata
• Experience in SQL Queries, Creating Views, PL/SQL Stored Procedures, Functions, Triggers, Cursors as per teh business needs requirements
• Experience in Production/Customer Support, Deployment, Development and Integration.
• Ability to meet deadlines and handle multiple tasks, decisive wif strong leadership qualities, flexible in work schedules
• Excellent interpersonal and communication skills, technically competent and result-oriented wif strong problem solving skills

TECHNICAL SKILLS

BI Tools: COGNOS 10 (10.1/10.1.1 ) (Framework Manager, Report Studio, Analysis Studio, Query Studio, Business Insight, Business Insight Advanced, Cognos Connection and Transformer)Cognos 8 Business Intelligence 8.4/8.3/8.2 (Report Studio, Query Studio, Analysis Studio, Metrics Studio, Event Studio, Framework Manager)

Enterprise Planning Software: COGNOS TM 1 9.4/9.5/9.5.1/10.1.1

ETL Tools: Informatica Power Center 8.1

Databases: Oracle 10g/9i/8.x, SQL Server 2000/2005, DB2, MS Access

Modeling: Erwin, TOAD, SQL*PLUS, iSQL*PLUS

Languages: SQL, PL/SQL, VB, HTML, XML

OS: Windows 95/98/2000/XP/NT, DOS, UNIX

Web Server: Java Web Server, Apache Web Server, IIS 5.0, Web Logic 7.0

PROFESSIONAL EXPERIENCE

Confidential, Portland, OR

Cognos BI Developer

Responsibilities:

• Involved in gathering Business Process Requirements from business users
• Developed Dashboard and Metrics for iPad using cognos Active Reports for Exemption Request Project using Cognos 10.2.1
• Developed Active Reports using Cognos Report Studio.
• Working on migration from cognos version 10.1.1 to 10.2.1.
• Designed complex reports using report studio and performed UAT.
• Designed different Control Charts such as Control U-Chart and Laney-U Chart based on Minitab calculations.
• Developed Relational and Dimensional Models for reporting using Framework Manager.
• Designed teh framework for teh report and developed dashboards using report studio.
• Developed Ad hoc Reports using Business Insight Advanced, Query Studio and complex reports using Report Studio. Installed and configured cognos products on server, distributed and client machines
• Maintained cognos security using Access Manager
• Moving/deploying reports from Development to testing and production servers using Content Administration.
• Developed Relational and Dimensional Models for reporting using Framework Manager.
• Designed teh framework for teh report and developed dashboards using report studio.
• Developed various reports, and they include, lists, cross tabs, charts, complex reports wif conditional blocks, static choices in prompt, bursting etc

Environment: COGNOS TM1 (10.1.1), COGNOS 10 (10.1/10.1.2 )

Confidential, Chicago, IL

Cognos TM1 and BI Developer

Responsibilities:

• Extensively worked on Active forms to create user input templates and reports wif conditional formatting and security
• Involved in Cognos and TM1 Administrative activities such as assigning security, object migration and server maintenance
• Worked on TM1 scorecard using Performance Modeler and deploying them onto Cognos Insight Portal
• Designed workflow in TM1 application wif manager dimension allowing managers to approve or reject forecasted values using picklists
• Implemented security at Application level, Cube level, Dimension level, Element level and Data level.
• Created User manual, which showcases all teh navigation steps for teh users across teh tool.
• Experience in creating dynamic subsets using mdx in dimension editor and also in turbo integrator scripting for loading cubes from database, creation of dimensions etc.
• Extensively used TM1 Perspectives for Excel to slice teh cube and also worked wif spread sheets to create TM1 applications and made available through TM1 web
• Declared skip check and feeders function in Rules editor for faster performance of complex calculations
• Experience in creating Approval hierarchy as a subset in dimensions and created cube views for use in contributor applications
• Deployed TM1 objects across different servers (Test, Prod) and worked on overall setup of teh servers.

Environment: COGNOS TM1 (10.1.1), COGNOS 10 (10.1/10.1.2 )

Confidential, Portland, OR

Cognos TM1 and BI Developer

Responsibilities:

• Involved in gathering requirements from end users, and writing specification documents
• Was involved in designing TM1 application architecture and its workflow
• Involved in TM1 10.1.1 installation and configured Perspective and TM1 web as remote servers
• Experienced in creating a dynamic excel templates by creating temporary view, export data to excel and destroy teh view
• Expert in writing TM1 rules wif feeders
• Extensively worked on Active forms to create user input templates and reports wif conditional formatting and security
• Designed workflow in TM1 application wif manager dimension allowing managers to approve or reject forecasted values using picklists
• Experience in creating dynamic subsets using mdx in dimension editor and also in turbo integrator scripting for loading cubes from database, creation of dimensions etc.
• Experience in Cognos Report Studio, in creating different types of reports using Prompts, Drill-through, master-detail query relationships, conditional formatting, grouping and sorting features of Report Studio to generate efficient and user-friendly reports
• Implemented security at Application level, Cube level, Dimension level, Element level and Data level.
• Experience in scheduling teh turbo integrator process using chores
• Used Framework Manager in Cognos 10.1.2 to design metadata from TM1 cubes and followed layered approach for model design then published packages
• Developed various reports, and they include, lists, cross tabs, charts, complex reports wif conditional blocks, static choices in prompt, bursting etc
• Due to teh huge volumes of data, their were many challenges which had to be addressed and different performance optimization tweaks were applied such as in TM1 we used parallel processing of teh TI scripts using teh external command in run TI, applied efficient feeders for teh TM1 rules.
• Also used HierarchyProperties Control object residing in TM1 which would model a dimension in teh form of levels when opened up as a data source in a Cognos report.
• Performance optimization on teh Cognos front was done using slicers instead of detail filters for reports generated out of teh database. Reduce teh number of queries to be processed, use necessary macros for prompts, check on query properties such as local cache, processing etc

Environment: COGNOS TM1 (10.1.1), COGNOS 10 (10.1/10.1.2 )

Confidential, Philadelphia, PA

Cognos TM1 and BI Developer

Responsibilities:

• Was involved in designing TM1 application architecture and its workflow
• Experienced in creating snapshot process in Forecasting cube which will populate all teh forecasted values in teh version dimension for given period, involving change of rules, changing flag in month dimension etc
• Involved in TM1 9.5.1 installation and configured Perspective and TM1 web as remote servers
• Experienced in creating a dynamic excel templates by creating temporary view, export data to excel and destroy teh view
• Expert in writing TM1 rules wif perfect feeders
• Extensively worked on Active forms to create user input templates and reports wif conditional formatting and security
• Designed workflow in TM1 application wif manager dimension allowing managers to approve or reject forecasted values using picklists
• Experience in creating dynamic subsets using mdx in dimension editor and also in turbo integrator scripting.
• Developed Cognos Active reports wif decks, tabbed interface and other advanced options. They were created in a way so that they could be accessible over iPad for offline reporting. It was specifically targeted towards sales and other marketing people over teh field.
• Worked on loading data using Turbo Integrator into database for teh purpose of Cognos analysis.
• Implemented security at Application level, Cube level, Dimension level, Element level and Data level.
• Experience in scheduling teh turbo integrator process using chores

Environment: COGNOS TM1 (9.5.1), COGNOS 10 (10.1/10.1.1 )

Confidential, Charlotte, NC

Cognos TM1 and BI Developer

Responsibilities:

• Installed and maintained TM1 application
• Expert in gathering business requirements and implementing best possible technical solutions
• Extensively worked integrating TM1 and Cognos BI wif best practices
• Created several cubes, dimensions and TI proceses implementing best practices
• Created a dynamic excel templates by creating temporary view, export data to excel and destroy teh view
• Expert in writing TM1 rules
• Designed Active forms and Worksheet application for user interaction wif TM1 and prompt selections
• Implemented email feature in TM1 to notify user about teh status of TI processes
• Implemented dynamic security by adding user from LDAP, create a user group according to teh country and assign appropriate privileges to teh user
• Developed complex reports in report studio using prompts, parameters, filters and conditional formatting
• Customized teh reporting environment by adding new portal skin including corporate logos and approved colors and new links
• Creating and Managing Jobs and Schedules
• Scheduled and managed events using Event studio
• Involved in Report testing and UAT

Environment: Cognos TM1 (9.5.1), TM1 Contributor, COGNOS 10 (10.1/10.1.1 ) (Framework Manager, Report Studio, Analysis Studio, Query Studio, Business Insight, Business Insight Advanced, Cognos Connection and Transformer), Cognos 8.4, Cognos Transformer, Oracle10g, Windows 2000/XP.

Confidential

Cognos Developer

Responsibilities:

• Designed, developed and maintained catalogs, Impromptu reports, templates, hot files, PDF files, snapshots, drill through.
• Generated reports as per teh requirements using Cognos Impromptu
• Used Multidimensional analysis for Data Retrieval using Powerplay structure
• Extensively worked on prompts based on teh user needs and format required
• Defined conditions, calculations and prompts in teh catalog
• Different department users used teh Powerplay environment that is customized for each user depending on teh requirements
• Created Hierarchies from providing drill down options for teh end-user
• Enabled users to access teh distributed HTML reports through local network intranet/internet, and via email
• Reporter Operations such as Sum and Average, Intersection, etc., Exception Highlighting Sorting, Ranking etc.
• Created various reports (List, Crosstab, Mailing Labels, Form Letter, Free Style) using Cognos Report Studio.
• Created standard and Adhoc reports (Formats, Layouts, quality data to carry) using Cognos Query
• Published teh IWR reports on teh web server.
• Created User Prompts, Conditions and Filters to improve teh report generation

Environment: Cognos 8.3 BI Suite (Frame work Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio), Windows 2000 server, MS SQL Server 2000, MS ACCESS, Windows XP, 2000