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 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)
• 3+ years of experience in Cognos TM1 (10.1.1/9.5. X)
• Experience in Cognos server maintenance and Administration
• 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.
• 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

Cognos BI: COGNOS 10/8.4/8.3/8.2/7 (Framework Manager, Report Studio, Analysis Studio, Query Studio, Business Insight, Business Insight Advanced, Cognos Connection and Transformer, Event Studio, ReportNet 1.1 MR2, IWR etc).Cognos TM1 COGNOS TM 1 9.4/9.5/9.5.1/10.1.1 TM1 Architect, TM1 Contributor, TM1 Perspective, TM1 Web, TM1 Insight and Performance Modeler.

ETL Tools: Informatica Power Center 8.1

Databases: Oracle 11g/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,C#

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, Columbus, OH

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.
• Interacted with Data Modeling team and ETL team to make available certain table and data modifications required to successfully execute report requirements
• Used Cognos Framework Manager for metadata modeling and followed layers approach such Database Layer, Business Layer and Presentation layer
• Worked extensively on various report layouts such as Chart, List, Crosstab and Repeater for presenting the data in efficient manner in Report Studio
• Created several complicated reports that involve multiple query joins, cascade prompts, conditional variables and report filters
• 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.)
• Scheduled reports requiring distribution or bursting to stakeholders
• Defined various Drill through definitions for navigating from Analysis studio to Report studio and Report Studio to Query Studio
• Extensively worked on Active reports to create static reports for offline users
• Administered Cognos BI Environment which includes, adding users and groups, update fixpacks, installation etc
• 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
• Conducted user acceptance testing (UAT) along with the business team and made modifications to the current process as per recommendations.
• Create test plans, manage user acceptance testing, document and track issues and ensure resolution of issues.

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

Confidential, Portland, OR

Cognos TM1 Developer

Responsibilities:

• Interacted with business users to gather requirements and designed TM1 architecture so that previous architecture is not disturbed.
• Created dimensions using Turbo Integrator(TI) process which replaced the old dimensions
• Assigned several aliases and attributes to different elements and applied various formats for measure in the dimension
• Worked with subsets and cube views
• Extensively used Turbo Integrator to perform ETL process efficiently
• Written TI scripts for parameterized loading of historic data into the cubes
• Expert in writing several business TM1 rules with perfect feeders which were applied to the cube as per business needs.
• Declared skipcheck and feeders function in Rules editor for faster performance of complex calculations
• Extensively used TM1 Perspectives for Excel to slice the cube which are similar to the earlier perspectives
• Worked with spread sheets to create TM1 applications and made available through TM1 web
• 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, Oracle 11g.

Confidential, Peoria, IL

Cognos TM1 Developer

Responsibilities:

• Involved in designing TM1 application architecture and its Contributor.
• 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 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 the view
• Expert in writing TM1 rules with perfect feeders
• Extensively worked on Active forms to create user input templates and reports with conditional formatting and security
• Designed workflow in TM1 application with 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
• 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, Atlanta, GA

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
• Created a dynamic excel templates by creating temporary view, export data to excel and destroy the view
• Designed Active forms and Worksheet application for user interaction and prompt selections
• 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
• Customized 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, Jersey City, NJ

Cognos BI Developer

Responsibilities:

• Understanding the ERP System used by the company.
• Understanding the requirements and functional specifications from business and develop the technical specifications for SSIS package
• Responsible for Analysis of impact on the core Data warehousing to check the feasibility of any new requirements or changes
• Extracting data from the source (SQL) and creating a single data mart,data analysis and dimensional modelling.
• Design and Developing various Mappings, Transformations of data
• Involved in understanding the report requirement form the Users and develop technical specification for Reports.
• Involved in creating sophisticated reports using Cognos 8.4 Report Studio
• Responsible for metadata modeling, data security, object security and package security in Cognos 8.4 Framework Manager.
• Involved in Unit test case preparation and unit testing of developed data quality plans, mappings and reports against data.

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.
• Created IQDs using Impromptu Administrator
• Generated reports as per the requirements using Cognos Impromptu
• Used Multidimensional analysis for Data Retrieval using PowerPlay structure
• Extensively worked on prompts based on the user needs and format required
• Defined conditions, calculations and prompts in the catalog
• Different department users used the PowerPlay environment that is customized for each user depending on the requirements
• Created Hierarchies from providing drill down options for the end-user
• Enabled users to access the distributed HTML reports through local network intranet/internet, and via email
• Used Impromptu’s optimizing features like table weighing, governors, bulk fetch
• 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 Impromptu tool by querying the database
• Created standard and Adhoc reports (Formats, Layouts, quality data to carry) using Cognos Query
• Published the IWR reports on the web server.
• 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