Professional Summary

• Over 9 years of IT experience in Business Intelligence systems such as Analysis, Design, Development, Deployment, Testing, Dimension Modeling.
• 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
• Extensively worked on various versions of COGNOS BI and TM1.
• Significant experience in Data warehouse concepts viz Star schema, snowflake. Experience of the technologies involved in Data warehouse including Cognos Suite of Products.
• Responsible for ongoing BI projects and day to day activities pertaining to Datawarehouse across onsite and offshore teams.
• 4 years of experience in Cognos TM1 10.1.1/9.5.2/9.5/9.4
• Experience in TM1 server maintenance and Administration
• 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

Professional Experience

Confidential

Sr. Cognos TM1 Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection for the Planning cycles in every year.
• Develop and support IBM Cognos TM1 models through all stages in the project life cycle.
• Design and build successful technical solutions that involve TM1 cubes, dimensions, TI processes, rules, and executing the completion of the TM1 architecture per project.
• Edit/create rules while utilizing Turbo Integrator.
• Develop and support Cognos reports on TM1.
• Develop and implement TM1 coding standards
• Working with the users, Analyzing, design and plan Reports.
• Analysis of the specifications provided by the clients.
• 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.
• Involved in routine task like loading the data into the particular cubes.
• Involved in updating the Line items in the dimensions, deleting any unnecessary items.
• Monitoring the daily routine tasks.
• Resolving any production issues and working with IBM vendor if there is any tool relating issues.
• Developing reports as defined in the requirements documentation to illustrate financial projections.
• 24/7 Production support to Forecast and Budgeting applications.

Environment: IBM Cognos TM1 Express 10.1, MS SQL Server, MS Office 2010.

Confidential

Sr. Cognos TM1 Developer

Responsibilities:

• Imported data into dimensions and cubes using Turbo Integrator
• Created new Cubes and Dimensions manually, using dimension worksheets and also using Turbo Integrator.
• Involved in creating TM1 servers, Dimensions, Cubes, Subsets, etc. using TM1 Architect.
• Creating TM1 forecasting calculations based on requirements.
• Interacted with the various development teams in order to achieve key project objectives.
• Loading and/or transferring data to or between business models on client request.
• Train system administrators and end-users on TM1 functionality, models, and reports.
• Configure and optimize TM1 objects and server environments.
• Drive month-end processes and reporting activities, including expense accruals, validation of consolidated results, headcount reporting, and other requests.
• Develop integrated Budgeting and Forecasting Cubes and Templates.
• Working with the users, Analyzing, design and plan Reports.
• Responsible for Business Analysis and Requirements Collection for the Planning cycles in every year.
• 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.
• Involved in routine task like loading the data into the particular cubes.
• Resolving any production issues and working with IBM vendor if there are any tool relating issues.

Environment: IBM Cognos TM1 9.4, IBM Cognos BI 8.2/8.4, Oracle 10g, MS SQL Server 2005.

Confidential

Sr. Cognos TM1 Consultant

Responsibilities:

• Requirement gathering and documenting technical design document
• Involved in developing and designing of cubes, dimensions, Input sheets and Reports.
• Updating the rules to capture the data into the scenarios
• Integration of TM1 with Cognos
• Used various data spreading techniques
• Creating Aliases ,picklists
• Created Slice, Active form and Snapshot report and uploaded into Applications
• Created and published package from the Framework Manager FM
• Created dashboard using Business Insight
• Build complex packages using various tool options, also used Model Design Accelerator to build star schema model in Framework Manager
• Created various Reports like list ,crosstab and chart
• Created Reports, Filters, and Cascading Prompts
• Customized reports using various features Header/Footer, run report with options, etc.
• The reports ranged from using repeaters, conditional variables and complex calculations.
• TM1 Cube maintenance and support
• Gathering the requirements and analysis of the specifications provided by the clients during weekly meetings.
• Performed Query optimization.
• Interacted with the business users and assisted them to use query Studio to develop ad hoc reports.
• Accomplished various user request using Sorting/ aggregation tools, Grouping/Ungrouping, Expand/Collapse Group, Formatting tools, Swap options, setting up web page size / page breaks

Environment: Cognos 10 Report Studio, Query Studio, Analysis Studio, PowerPlay Studio, Event Studio, Transformer and Framework Manager , SQL Server 2008, Oracle 9i/10g SQL, PL/SQL , SSIS

Confidential

Sr. Cognos Consultant

Responsibilities:

• Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and business logic underlying the requirement.
• Built Multi Dimensional Models DMR with Relational Data using Framework Manager and Deployed Packages to the Report Servers.
• Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Developed Framework Manager Models against Teradata and Oracle Database.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Delivered advanced/ complex reporting solutions such as Dashboards and Standardized Reporting including the bursting of reports globally using Cognos 8.4.
• Developed reports in Analysis Studio from Powerplay Transformer Cube.
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection.
• Designed models by mapping business needs using Power Play Transformer and created multi dimensional cubes, cube groups, Power Play reports.
• Designed multidimensional models using Transformer.
• Decreased the Cube build times drastically and increased runtime performance.
• Third Party Security with LDAP and use those in creating Data Level, Object Securities in Framework Manager Models.
• Involved in Deploying reports, cubes and packages from Development to Production environment.
• Assigning work to the offshore team on daily basis.
• Developed technical specification document for the offshore team.

Environment: Cognos 8.4 Cognos Connection, Report Studio, Query Studio, Framework Manager ,

Access Manager, SQL Server 2005, Oracle 10g, Windows XP.

Confidential

Cognos Consultant

Responsibilities:

• Gathered business requirements and designed functional and technical requirements documentation.
• Installed and Administered Cognos products 8.4 in both gateways and dispatchers in distributed environment.
• Involved in Designing DMR models with Relational Data and Relational models using Framework Manager and deployed packages to the Report Servers.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Set up the Security at the package level, query subject level and the query item level.
• Used Governing techniques for improving performance of the Query.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports and Drill-Through Reports.
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Delivered Advanced Multidimensional reporting solutions using Report Studio.
• Developed Reports with multiple Cognos Viewers and integrated multiple Cognos reports onto a Single Page Report.
• Customized Reports by writing complex custom SQL.
• Worked with ETL team for loading /Extracting data from Nateeza data base.
• Security Administration for setting up users, groups and roles and creating access permissions.
• Deliver advanced/ complex reporting solutions such as Dashboards, Scorecards and Standardized Reporting including the bursting of reports globally using Cognos 8.
• Creating IQD files from Report net and designed Power play models in Transformer.
• Built Power Play Reports based on the cubes and published to Report Net Server.
• Involved in building the complex cubes and optimizing the cube creation.

Environment: Cognos8.2 Report Studio, Query Studio, Analysis Studio,Framework Manager ,

PowerPlay, Transformer, Access Manager, Nateeza,Oracle 10g, Windows XP

Confidential

Cognos Developer

Responsibilities:

• Involved in Requirement gathering from Business Users.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Design and Developed the Framework Manager models and Published into server.
• Design development of the reports using Cognos 8 Report Studio, Query Studio reports
• Design development of multiple reports using various templates like list reports, cross-tab reports and chart reports
• Created Filters, Prompts, Calculations both at package level and report level.
• Performance tuning by analyzing and comparing the turn around times between SQL and Cognos.
• Extensively worked with database views to create Query Subjects in Framework Manager and Reports.
• Experience in Migrating reports from Cognos EP Series 7 to Cognos 8 Environment.
• Involved into move to Deployment to UAT and Production.
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports.
• Co-facilitate client workshops and training, typically small to medium group of clients.
• Testing reports using review checklists for Quality Assurance before delivering to the end users.

Environment: Cognos 8.1/Cognos Reportnet 1.1 Report Studio, Query Studio, Analysis Studio and Frame work manager , PowerPlay Transformer , Toad 9.5, Oracle 9i.