PROFESSIONAL SUMMARY:

• Over 8+ year of IT Experience in Cognos Tools such as Cognos TM1 10.1/9.5 and Cognos BI Suite, Analysis Tools Cognos Transformer & Power Play
• Experienced in Design, Development and Implementation of Cognos TM 1 10.1/9.5.2 Applications for Financial Planning and Budgeting Models with Complex Rules
• Experienced of Cognos 10 TM1 Insight and Performance Modeler for building Applications, Cubes, Dimensions, Replications, Processes and models
• Strong experience with Cognos TM1 9.5 Applications in Architect, Contributor, Perspectives and Turbo Integrator
• Experienced in Cognos TM1 Turbo Integrator mapping and Rules Editor, Worked on Creating Dimensions and Cubes in Cognos TM1
• Hands on Experience with Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio
• Expertise in Developing Dashboards using Business Insight and Business Insight Advanced
• Expertise in Developing reports using Active Reports, Report Studio, Query Studio and Analysis Studio
• Hands on experience in maintaining Cognos Enterprise Planning (EP) Environment for Forecasting and Budgeting Life Cycles
• Experienced in analyzing Star schema, Snow Flake Schema and Dimensional Data Models, good experience working with MDX Functions in Report Studio using Multi - Dimensional Sources
• Strong experience in OLAP Analysis and Cube Development, worked in Maintenance of TM1 Users, Groups and Security
• Proficient in development of applications using XML, HTML, DHTML, JavaScript.
• Extensive experience in Relational Databases including SQL Server, Oracle, Teradata
• Deploying Models and Reports from Staging to Production and Administering Users/Groups/Roles
• Experience in integrating Heterogeneous Data Sources like Flat files, XML, Databases etc
• Excellent communication and interpersonal skills. Ability to work effectively in a team as well as individually
• Strong problem solving skills, ability to develop strategies for clients, and provide detailed documents to clients
• Excellent Team coordinating Skills with the Development Team and Deliverable dates
• Excellent team player at all levels with ability to perform independently. Exceptional communication, analytical, presentation and problem solving skills

TECHNICAL SKILLS:

BI tools: Cognos10.2, 10.1,8.x (Report Studio, Framework Manger, Analysis Studio, Query Studio, Business Insight), Transformer

ETL Tools: Informatica 8.6, Data stage 7.5

Databases: Oracle 9i/10g/11g, Netezza, SQL Server 2008, Teradata, DB2

Languages: C, C++, Java, VB.net

Scripting: VB Script, Java Script, HTML, CSS

DB Tools: SQL *Plus, SQL *Loader, TOAD 8.3, IBM Data Studio

Web Servers: IIS, Apache

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr Cognos TM1 Developer/Admin

Responsibilities:

• Installed and maintained TM1 application
• Expert in gathering business requirements and implementing best possible technical solutions
• Extensively worked integrating TM1 and 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
• Expert in writing TM1 rules
• Designed Active forms and Worksheet application for user interaction with TM1 and prompt selections
• Implemented email feature in TM1 to 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
• Extensively worked on Active forms to create user input templates and reports with 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
• Designed workflow in TM1 application with 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 the navigation steps for the users across the 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 the cube and also worked with spread sheets to Create TM1 applications and made available through TM1 web
• 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
• Experience in Scheduling the turbo integratorprocess using chores. Used Framework Manager in Cognos10.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 with conditional Blocks,static choices in prompt, brusting
• Due to the huge volumes of data,there were many challenges which had to be addressed and different Performance optimization tweaks were applied such as in TM1 we used parallel processing of the TI Scripts using the external command in run TI,applied efficient feeders for the TM1 rules

Environment: Cognos TM1 10.1.1, Cognos 10.2, Oracle 11g, Win 7

Confidential, NYC NY

Sr. Cognos Developer

Responsibilities:

• Involved in gathering requirements from end users, and writing specification documents
• Involved in designing TM1 application architecture and its workflow
• 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 feeders
• Extensively worked on Active forms to create user input templates and reports with conditional formatting and security.
• Import the data from ODBC and Text files using TM1 Turbo integrator.
• Designed workflow in TM1 application with manager dimension allowing managers to approve or reject forecasted values using pick lists
• 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.
• Implemented security at Application level, Cube level, Dimension level, Element level and Data level.
• Experience in scheduling the 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 with conditional blocks, static choices in prompt, bursting etc
• Maintenance of TM1 users, roles, and security. Used TM1 rules editor to create and edit rule to create various calculations.
• Due to the huge volumes of data, there were many challenges which had to be addressed and different performance optimization tweaks were applied such as in TM1 we used parallel processing of the TI scripts using the external command in run TI, applied efficient feeders for the TM1 rules.
• Also used Hierarchy Properties Control object residing in TM1 which would model a dimension in the form of levels when opened up as a data source in a Cognos report.
• Performance optimization on the Cognos front was done using slicers instead of detail filters for reports generated out of the database. Reduce the 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.1/10.1.2, Oracle 11g

Confidential, Virginia Beach VA

Sr. Cognos Developer

Responsibilities:

• Involved in Designing models with Relational Data using Framework Manager and published packages to the Cognos Reporting Servers.
• Implemented data level, object level and package level security in framework manager to achieve highly complex security standards.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting.
• Upgraded Framework Manager Models, Transformer Cubes from Cognos Version 8.4 to 10.2.1
• Developed Dashboard reports to display all the information related to environment using Summary reports.
• Design, develop, and implement Cognos TM1 10 Applications for Financial Planning and Budgeting models with complex rules.
• Created Turbo integrator processes to retrieve data from data sources and created dimensions and cubes for forecasting.
• Maintenance of TM1 users, roles, and security
• Created optional filters/prompts in report studio using Java Script and HTML.
• Worked on Analysis Studio to develop multi dimensional reporting.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Deploying models and reports from Development to Production and administering users/groups/roles.

Environment: Cognos 8.4/10.2 (Framework Manager, Transformer, Report Studio, Query Studio), Oracle 11g, WAS, SQL Server 2008, TOAD, PL/SQL, Java Script, Data Stage, zLinux.

Confidential, Denver CO

Sr. Cognos Developer / Administrator

Responsibilities:

• Involved in all phases of the data warehouse project lifecycle, which includes assessment, business requirements gathering, data modeling and database design, ETL/BI architectures, Reporting Model and report Development, performance tuning, and data delivery mechanisms.
• Created metadata models using Framework Manager with relational data and deployed packages to the Cognos Reporting Servers
• Designed and Developed DMR models using regular & fact dimensions in Framework Manager
• Implemented data level, object level and package level security in framework manager to achieve highly complex security standards
• Implemented Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting
• Developed dimensional models in Transformer, built cubes and published cubes to Cognos Portal
• Involved in Upgrading Cognos reporting application from Cognos Version 8.4 to 10
• Created, refreshed and supported Cognos Transformer OLAP models and Power Play cubes
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production
• Deploying models and reports from Development to Production and administering users/groups/roles
• Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support

Environment: Cognos 10.1.1/8.4, Framework Manager, Transformer, Report Studio, Query Studio, Oracle 11g, SQL Server 2008, TOAD, SQL Navigator, PL/SQL, Java Script, Informatica 9, AIX.

Confidential, Jacksonville FL

Sr. Cognos Consultant

Responsibilities:

• Worked with business users, functional lead to understand and document the Business requirements.
• Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager
• Worked jointly with the data management team members to understand data domains, values, cardinalities and other dimensions of data needed to support BI solutions.
• Created Metadata Modeling importing query subjects from multiple databases in Cognos Framework Manager.
• Created and published packages from Cognos Framework Manager.
• Created Complex Reports in Report Studio, PowerPlay Reports using Analysis Studio.
• Developed multiple page reports with page-breaks based on the first page of the report using Master-detail relationship.
• Developed List, cross tab, drill through and complex reports which involved multi-queries.
• Extensively used Power play Transformer to create powercubes loading data from datamarts.
• Deployed Packages and Reports from DEV Environment to UAT and PROD Environments.
• Imported metadata from various sources such as Relational Databases, Report Net models, Impromptu Catalogs into the Framework Manager.
• Did Unit Testing for all reports and packages.
• Creating report views with saved prompts and schedule according to the business requirement.
• Created Jobs to Schedule multiple reports in Cognos Connection.
• Personalized Cognos Connection, Specified display options, regional options and rmation.

Environment: Cognos 8.4, Transformer 8.4, Report Studio, Query Studio, Metric Studio, Oracle 10g, Sybase IQ 12, Erwin 4.0, TOAD, PL/SQL, Informatica 8, UNIX (Sun Solaris).

Confidential, Chicago, IL

Cognos BI Developer

Responsibilities:

• Involved in installing and configuring Cognos 8.4/8.3/8.2 BI and worked with modeling, Report Studio and Analysis Studio.
• Worked extensively on creating Models using Framework Manager and publishing the packages on Cognos Connection for reporting purposes.
• Created DMR models using Framework Manager.
• Created filters and prompts within the Model for improving performance of the Model.
• Deployed the packages and reports from Dev to QA and Prod.
• Used Cognos Connection to administer and scheduling reports to run at various intervals.
• Set security for individual reports in Cognos Connection.
• Used Analysis studio to drill down on cubes and perform business analysis.
• Created Lists, Groups and Cross-tab reports with Drill-through functionality using Analysis studio.
• Scheduled reports to run on a monthly, weekly, and daily basis using Cognos Connection Scheduler.
• Created standard and Ad hoc reports using Cognos Query Studio.
• Developed reports in Report Studio upon requests from business users
• Busted Reports to various Recipients within the organization using Report Studio.
• Created Query Prompts, Tree prompts, Query calculations, Conditions & Filters.
• Developed Complex reports in Report Studio using Complex SQL queries
• Designed and modified reports with Java SDK in Report Studio.
• Created list reports, cross tab reports, chart reports, Master detail reports, Drill through reports and reports with lot of conditional formatting using Report Studio.
• Involved in creating Test plans, Unit testing and UAT of the Report Studio reports.
• Created Power play Cubes using Power play Transformer generated Power play Reports.

Environment: Cognos 8.4/8.3/8.2 Report Studio, Query Studio, Cognos Connection, Cognos Planning, Framework Manager, Power play Transformer, Cognos Scheduler, Oracle 10g