Professional Summary:

• Over 9 years of IT experience in Business Intelligence systems such as Analysis, Design, Development, Deployment, Testing, Dimension Modeling and Enterprise Planning.
• Experience in Advanced Turbo Integrator scripting
• Experience in Cognos server maintenance and Administration
• Experience in TM1 server maintenance and Administration
• 4 years of experience in Cognos TM1 10.1.1/9.5.2/9.5/9.4
• Extensively worked on various versions of COGNOS BI and TM1.
• Expert in implementing dynamic security at all levels of TM1 objects
• Experience in scheduling Turbo Integrator process using Chores
• Extensively worked on Rules to apply business rules to a cube
• Experience in COGNOS 10 10.2/10.1/10.1.1 Framework Manager, Report Studio, Analysis Studio, Query Studio, Business Insight, Business Insight Advanced, Cognos Connection and Transformer , with COGNOS 8 8.4/8.3/8.2 , COGNOS series 7 suite Cognos Impromptu Administrator 7.x/6.x, Impromptu Web Reports IWR 7.x/6.x, Power Play Transformer 7.x/6.x, Power Play Enterprise Server PPES and Access Manager
• Expert in creating Active Reports in Cognos 10 Report Studio.
• Trained power users in Business Insight Advanced to create reports using externalized metadata.
• Proficient in meta data modeling with Framework Manager and experienced in layered approach such as Physical Layer and Business Layer, Presentation Layer...etc
• Experience in DMR modeling with Framework Manager
• Outstanding experience in creating report layout as List, Cross Tab, Chart and Repeater table
• Created complex reports with advanced features such Master detailed sections, Conditional formatting, Render variables, Drill-through, Page Set, Java Script and Bursting using Report Studio
• 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 the business needs requirements
• Experience in Production/Customer Support, Deployment, Development and Integration.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules
• Excellent interpersonal and communication skills, technically competent and result-oriented with strong problem solving skills

Technical Skills:

Professional Summary:

Confidential

Sr Cognos TM1 Developer

Responsibilities:

• Worked closely with the business to understand and model the business processes. Created the models of 'AS-Is' and 'To-Be' business processes.
• Involved in defining the scope and defining business rules of the project.
• Interacted with Business Users and created the process requirements. Also discussed/explained the flow of future data modules with design and development teams.
• Experienced in creating a dynamic excel templates by creating temporary view, export data to excel and destroy the view
• Created user input templates using Active forms with conditional formatting and security
• Implemented security at Application level, Cube level, Dimension level, Element level and Data level.
• Created Drill through Process from TM1 Cube to Sql Server for querying transaction level data for each Cost Center.
• Using Global Variables performed Error handing /TI Process monitoring in Chores and loaded the Error Status into logging cube.
• Proactively monitored the environments for capacity and performance related issues and take steps necessary to address them.
• Migrated TM1 objects from Prod to Dev and Installed TM1 test Servers for Users.
• Worked as BI Report Author on Cognos 10.2 toolset including Report Studio, Query Studio, Analysis Studio, Framework Manager, Active Reports, and Cognos Workspace.
• Conducted user acceptance testing UAT along with the business team and made modifications to the current process as per recommendations.
• Demonstrated excellent business writing skills, business process flow diagrams, comparison of current and projected processes and their impact, efficiency gains in implementing new technologies and processes
• Administered Cognos BI Environment which includes, adding users and groups, update fixpacks, installation etc
• Extensively worked on Active reports to create static reports for offline users
• Defined various Drill through definitions for navigating from Analysis studio to Report studio and Report Studio to Query Studio
• Scheduled reports requiring distribution or bursting to stakeholders
• Created Master-Detail relationship based reports that represented information pertaining to a certain identifier or master field based upon either User entered report-filters e.g. Drop down lists, from/to date ranges, sorting options etc.
• Created several complicated reports that involve multiple query joins, cascade prompts, conditional variables and report filters
• Worked extensively on various report layouts such as Chart, List, Crosstab and Repeater for presenting the data in efficient manner in Report Studio
• Used Cognos Framework Manager for metadata modeling and followed layers approach such Database Layer, Business Layer and Presentation layer
• Interacted with Data Modeling team and ETL team to make available certain table and data modifications required to successfully execute report requirements
• Create test plans, manage user acceptance testing, document and track issues and ensure resolution of issues.

Environment: Cognos TM1 10.1, TM1 Contributor, Cognos 10.2 Framework Manager, Report Studio , Sql Server 2005, Microsoft Office 2003, Windows 7.

Confidential

Sr Cognos TM1 and BI Developer

Responsibilities:

• Worked with spread sheets to create TM1 applications and made available through TM1 web
• Extensively used TM1 Perspectives for Excel to slice the cube which are similar to the earlier perspectives
• Declared skipcheck and feeders function in Rules editor for faster performance of complex calculations
• Expert in writing several business TM1 rules with perfect feeders which were applied to the cube as per business needs.
• Written TI scripts for parameterized loading of historic data into the cubes
• Extensively used Turbo Integrator to perform ETL process efficiently
• Worked with subsets and cube views
• Assigned several aliases and attributes to different elements and applied various formats for measure in the dimension
• Created dimensions using Turbo Integrator TI process which replaced the old dimensions
• Interacted with business users to gather requirements and designed TM1 architecture so that previous architecture is not disturbed.
• Used several TM1 functions to interact with the data from TM1 cubes
• VBA/Macros was used to create best user interface in excel
• Added new client groups, assigned users to groups and implemented security at Application level, Cube level, Cell level, Dimension level, Element level, Process level and Chores level
• Created Approval hierarchy as a subset in dimensions and created cube views for use in contributor applications
• Designed contributor applications, deploying the application, assigning security rights to at each level of approval hierarchy.
• Interacted with historic cube data using earlier TM1 cubes

Environment: Cognos TM1 9.5.1, TM1 Contributor, Oracle 11g.

Confidential

Cognos TM1 Developer

Responsibilities:

• Designed workflow in TM1 application with manager dimension allowing managers to approve or reject forecasted values using picklists
• Extensively worked on Active forms to create user input templates and reports with conditional formatting and security
• Expert in writing TM1 rules with perfect feeders
• Experienced in creating a dynamic excel templates by creating temporary view, export data to excel and destroy the view
• Involved in TM1 10.1.1 installation and configured Perspective and TM1 web as remote servers
• Experienced in creating snapshot process in Forecasting cube which will populate all the forecasted values in the version dimension for given period, involving change of rules, changing flag in month dimension etc
• Involved in designing TM1 application architecture and its workflow
• Experience in creating dynamic subsets using MDX in dimension editor and also in turbo integrator scripting
• Implemented security at Application level, Cube level, Dimension level, Element level and Data level.
• Experience in scheduling the turbo integrator process using chores

Environment: COGNOS TM1 10.1.1 , COGNOS 10 10.1/10.1.1

Confidential

Cognos BI Developer

Responsibilities:

• Installed and maintained Cognos application
• Expert in gathering business requirements and implementing best possible technical solutions
• Extensively worked integrating Cognos BI with best practices
• Created several cubes, dimensions and TI processes implementing best practices
• Implemented email feature notify user about the status of TI processes
• Implemented dynamic security by adding user from LDAP, create a user group according to the country and assign appropriate privileges to the user
• Developed complex reports in report studio using prompts, parameters, filters and conditional formatting
• Created a dynamic excel templates by creating temporary view, export data to excel and destroy the vie
• Designed Active forms and Worksheet application for user interaction and prompt selections
• d the 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 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 BI Developer

Responsibilities:

• Worked with subsets and cube views. Extensively used Turbo Integrator to perform ETL process efficiently
• Involved in creating Active reports and Business insight advanced.
• Developed the Framework Manager model by pulling the data from multiple data sources like Oracle, SQL Server 2005 and published packages to the Cognos Connection
• Involved in Requirements collection with Business users and prepared Functional Requirement Specifications for report development
• Was involved in creating new client groups, assigned users to groups and implemented security at Application level, Cube level, Cell level, Dimension level, Element level, Process level and Chores level
• Experience in creating Approval hierarchy as a subset in dimensions and created cube views for use in contributor applications
• Used VBA/Macros to create best user interface in excel
• Declared skipcheck and feeders function in Rules editor for faster performance of complex calculations
• Created dimensions manually and also using Turbo Integrator TI process
• Experienced in using TI scripts for parameterized loading of data into the cubes
• Created Dimensions, Levels, Calculated Measures, Special Categories with relative time period and Cube groups
• Applied various kinds of prompts such as Value prompt, Date prompt, Textbox Prompt, Select Search Prompt for report's better performance
• Created reports using advanced features like Master-Detail, Drill-through, Conditional Formatting and Page set

Environment: 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.
• Published the IWR reports on the web server.
• Created standard and Adhoc reports Formats, Layouts, quality data to carry using Cognos Query
• Created various reports List, Crosstab, Mailing Labels, Form Letter, Free Style using Cognos Impromptu tool by querying the database
• Reporter Operations such as Sum and Average, Intersection, etc., Exception Highlighting Sorting, Ranking etc.
• Used Impromptu's optimizing features like table weighing, governors, bulk fetch
• Enabled users to access the distributed HTML reports through local network intranet/internet, and via email
• Created Hierarchies from providing drill down options for the end-user
• Different department users used the PowerPlay environment that is customized for each user depending on the requirements
• Defined conditions, calculations and prompts in the catalog
• Extensively worked on prompts based on the user needs and format required
• Used Multidimensional analysis for Data Retrieval using PowerPlay structure
• Generated reports as per the requirements using Cognos Impromptu
• Created IQDs using Impromptu Administrator
• Created User Prompts, Conditions and Filters to improve the report generation

Environment: Cognos 7 Series Impromptu, Cognos Server Administration, Cognos Upfront, Impromptu Web Reports IWR , Cognos Query, Metrics Manager Erwin Data Modeler, Windows 2000 server, MS SQL Server 2000, MS ACCESS, Windows XP, 2000