Cognos TM1 Developer

Professional Summary:

• Experience in guiding users through TM1 Web and TM1 Reports.
• Knowledge on Cognos Insight and Performance modeler.
• Knowledge on Cognos TM1 Work flow and TM1 Executive viewer
• Working knowledge on Rules and Skip check and Feeders
• Experience in scheduling Turbo Integrator process using Chores
• Experience in writing/executing Batch files and their execution using TI scripting
• Completed the TM1 analyst and developer certification.
• 4 years of experience in Cognos TM1 10.1.1/9.5.2/9.5/9.4
• Around 9 years of experience in COGNOS 10 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
• Solid Experience in creating Active forms, Slicers, Snapshots and ISBs
• Hands on experience in integrating Cognos with TM1
• Extensive experience in Business Analysis, Project Management.
• Proficient in eliciting information and authoring Business Requirement Document BRD .
• Produced documents confirming to Substantial Measurable Articulate Reliable and Traceable SMART principles
• Worked closely with stakeholders to identify business benefits to support the business case and justify delivery.
• Created Project Charter, Test Plan, Designed Test Scenarios and Documented Test Cases and Test Scripts
• Organized and steered extensive meetings with the business team, system interface team, quality assurance team and the vendor team on a regular basis. Prepared minutes of meeting, action items and distributed to stakeholders.
• Experience working with SharePoint, involved in the design and implementation of SharePoint workflow
• Strong experience in working with all phases of SDLC through out the project life cycle using various methods, Rational Unified Process, Waterfall and Agile modeling.
• Quantified project effort estimation, used knowledge of estimates towards budgeting and task scheduling. Performed current state analysis and gap analysis
• Led Joint Application Development JAD sessions, requirement gathering initiatives, documentation signoff, testing efforts
• Extensive experience in testing system, integration, load, regression, user acceptance testing using manual and automation techniques
• Interacted closely with numerous business users, development team and vendors about business, technical, human resource financial specifications
• Proven accomplishment record amid tremendous organizational and technological transformation

• 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
• Excellent Inter-personal skills and a quick learner. Ability to get along with the team well, and can handle client issues at all stages of the development process

Technical Skills

• Operating Systems : Windows XP/7, Windows 2003/8, UNIX and MS DOS
• Languages : Java, JSP, C, C , SQL and PL/SQL
• BI Tools : Cognos 10 BI Series, Cognos TM1 9.5/10.1, Cognos Metrics
• Manager, Cognos Enterprise Planning, Business Objects
• ETL Tools : Informatica Power Mart v8.1/7.0 Power Center v8.1/7.0, Microsoft
• SQL Server DTS 2005/8.
• Data Modeling Tool : Erwin 3.5.2/4.0
• Databases : Oracle 10g/9i/8.i/7.x, MS SQL Server 2008/2005, Sybase, DB2
• DB Tools : SQL Plus, SQL Loader, TOAD 8.3/7.6
• Testing Tools : Mercury Tools Load Runner, Win Runner and Test Director.
• Web Servers : IIS, Apache.

Confidential

Sr Cognos TM1 Developer

Responsibilities:

• Independently and as a member of a development group, performs system analysis, design, programming, testing, documentation, installation, user training and system maintenance and support.
• Analyzed and worked on designing TM1 application Architecture
• Develops systems observing professional system design concepts and office standards and conventions.
• Working close with users and coordinating with application developers to understand and capture data reporting requirements
• Migrated TM1 objects from Prod to Dev and Installed TM1 test Servers for Users
• Creating and documenting BI report specifications with detailed database mapping and made Necessary changes in the DWH structure
• Created Drill through Process from TM1 Cube to Sql Server for querying transaction level data for each Cost Center.
• Collaborated with Data Architect DBA to develop optimize the Star-schema Snow flake schema model for the Cognos reporting tools Power Play and Report studio .
• Generated various types of reports like Dashboard, List, Grouped, and Cross tab, Different kinds of Chart reports, and Drill through reports, Master details reports, reports with complicated SQL queries, Repeater reports using Cognos BI Series 8.4.
• Involved in TM1 9.5.1 installation and configured perspective and TM1 web as remote Server
• Consolidated multiple individual Credit risk reports into standard reports based on specification, functionality, complexity and performance.
• Improved the performance and usability of the reports by creating appropriate prompts and filters.
• Developed Multi page reports with prompt pages, parameter maps and conditional variables according to the end user requirements
• Involved in the Administration and implementing Security.
• Extensively used TM1 Perspectives for Excel to slice the cube which are similar to the earlier perspectives
• Involved in Migration of reports, packages from 8.4 to Cognos 10.1.1.
• Scheduled reports using the Schedule Management tool, Event Studio in Cognos Connection
• Involved Cognos Security, user roles and groups in 3-tier environment and administered the Cognos
• Access manager user access, adding new users and modifying the existing user access
• Developed Models and packages according to the business user's specifications and assigned object level and data level security.
• Experienced in working with TM1 web tools.
• Design, development and implementation of Cognos TM1 models, Turbo Integrator.
• Experienced in creating dimension models in Cognos TM1 including design
• Created the Business view and database view structures for the better use of query studio users.
• Implemented row level securities using session parameters and parameter maps within the package.
• Creating User Classes and restricted the user access with the help of User Class Privileges.
• Responsible for the delivery of solution-oriented complex reports using Report Studio.
• Did the whole documentation of packages and applied Naming Standards.
• Used SQL Profiler monitor Performance of Queries and to index the Tables.
• Used JIRA for risk and issue tracking and production support for the clients applications.
• Used several TM1 functions to interact with the data from TM1 cubes
• Configured authentication authorization related security groups and roles in Cognos connection administration for metric related packages and reports for deploying metric related web content.

Environment: Cognos 8.4 BI, Framework Manager, Metric Designer, Report Studio, Analysis Studio, Event Studio, Metrics Studio, Query Studio, Cognos Connection, Access Manager , Cognos TM1, Report Administration, Access manager, upfront , Cognos 10.1,MS SQL Server 2005 and SQL Navigator, SSIS, MS.

Confidential

Sr Cognos TM1 Developer

Responsibilities:

• Gathering the business requirements from end users and clients and building the prototype model.
• Interact with client personnel in finance and information systems.
• Prepare detailed designs documents and technical specifications.
• Creating TM1 forecasting calculations based on requirements.
• Involved in creating TM1 servers, Dimensions, Cubes, Subsets, etc. using TM1 Architect.
• Created new Cubes and Dimensions manually, using dimension worksheets and also using Turbo Integrator.
• Imported data into dimensions and cubes using Turbo Integrator
• Creating a flexible modeling structure that is easily adaptable to future needs.
• Creating TM1 Turbo Loader processes for populating TM1 cubes from source data.
• Creating regularly scheduled automated jobs to load TM1 data structures.
• Developing reports as defined in the requirements documentation to illustrate financial projections.
• Documenting steps required for managing the system and for updating objects at the end of fiscal years.
• Actively mentoring developers and infrastructure staff so they understand the application and are prepared to support ongoing Cognos andTM1 development/maintenance activities.
• Interaction with End User Clients for conceptual changes to the model.

Environment: IBM Cognos TM1 Architect 9.5.1, TM1 Perspectives, Oracle 10g, Cognos 8 BI.

Confidential

Cognos TM1 Developer

Responsibilities:

• Business Analysis and Reports Requirement Gathering.
• Installed and maintained TM1 application
• 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
• Developed Dashboard reports for Retail sales and Hotel Management Phase.
• Designed functional specifications and technical specifications.
• Prepared the physical layout diagram of Hotel Management.
• Involved in Data Modeling and Data Quality Analysis.
• Expert in writing TM1 rules with perfect feeders
• Designed workflow in TM1 application with manager dimension allowing managers to approve or reject forecasted values using picklists
• Extensively worked integrating TM1 and Cognos BI with best practices
• Created Drill Through for navigation between Cubes and reports in Analysis Studio.
• Interacted with historic cube data using earlier TM1 cubes
• Worked with spread sheets to create TM1 applications and made available through TM1 web
• Responsible for documenting migration strategy, standards and best practices, and additional functional and technical specifications for upgrade from Cognos Series 7 to Cognos Series 8.
• Built Power play Transformer models combining data from corporate data store and transactional database.
• Created and maintained scripts to build and refresh Power Cubes on Windows server.
• Created Models, Packages and Importing Meta data using Frame work Manager.
• Migrating Power play cubes in to Cognos Connection.

Environment: Cognos TM1 9.5.1 , TM1 Contributor Cognos ReportNet 1.1 MR1 MR2 , Cognos Series 8.0 Impromptu, Powerplay, Transformers Cognos Configuration, Cognos Connection, Framework Manager, Metrics Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Metrics Studio , SQL, PL SQL, Analysis Services 2005,SSIS.

Confidential

Cognos Developer

Confidential is an Information Technology services organization providing full-service solutions in software development and process management. The process department was involved in generating reports according to location and view the funding and protection options. I was involved by using Cognos and Report Net Tools for revenue information to build cubes, models and catalogs.

Responsibilities:

• Gathered business requirements from users and understanding the report specifications
• Created relationships in Framework Manager Model and established cardinalities to suit business needs.
• Worked on Cognos components Report Studio, Query studio and Cognos connection
• Set up drill through reports to provide users with detailed information using Impromptu Administration.
• Developed multi-dimensional analysis and business reports using PowerPlay Transformer.
• Created Ad-hoc reports via Cognos Impromptu
• Developed standard reports and dash boards
• Tested and improved report performance. Also provided technical support for users.
• Created Power Play secured models using PowerPlay Transformer
• Published Impromptu reports and PowerPlay cubes using Cognos Report Net and Power Play Transformer respectively.

Environment: Cognos Report Net 1.0 Cognos connection, Framework Manager, Query Studio, Analysis Studio , Access Manager, Power Play Transformer 7.3, Impromptu 7.3 and Oracle 10g, MS-Excel, PL/SQL, TOAD v8.5

Confidential

Cognos Developer

Responsibilities:

• Key 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
• Involved in documentation of the whole process