PROFESSIONAL SUMMARY:

• 10+years of extensive experience in IT industry as Cognos Developer/ TM1 Developer/ ETL Developer which includes extensive Functional and Technical experience in Data Warehousing, Data Modeling, Business Intelligence (BI), OLAP, ETL tools, Product Development and Reports Generation.
• Experience in Migration from Cognos 8 series, Report Net to Cognos 10 BI series and experience in Installing and Configuration of Cognos8 on client - server architecture.
• Hands-on experience in COGNOS 11.x/10.x/8.x Suite (Framework Manger, Cognos Transformer, COGNOS Connection, Report Studio, Query Studio, Business Insight, Advanced Business Insight, Analysis Studio and Event Studio) with expertise in Metadata Modeling-Create project, Prepare Metadata, Prepare the Business View, Create and Manage packages, set security and publish into portal.
• Expertise in Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.
• I Have experience with Cognos 11 and I have created dash boards by using cognos 11 version
• Move the Cognos Framework Manager model from development, test environment to production environment.
• Experience installing and configuring Cognos 8x/Cognos 10x in distributed environment.
• Performed Defect Prevention Activities in Project.
• Expertise in developing SQL programming.
• Experience using IBM Cognos Cube Designer and Integrated Dynamic Cubes to develop Virtual Cubes.
• Excellent understanding of OLAP data processing methodology.
• Worked with Business Analysts and end users in understanding and preparing functional, technical specifications and designed documents.
• Designed & Developed TM1 Processes, Dimensions, Cubes and Applications.
• Expertis in creative dashboard with cognos 11 and Strong Knowledge with Dashboard
• Experience in understanding and working with On-site Off-shore environment.
• Excellent problem solving ability coupled with good communication skills to interact with end-users, customers, and team members.
• Customized Reports using HTML and JAVA SCRIPTS.
• Strong Knowledge with Power Play Transformer model design and Power play cube building.
• Extensive experience in Data Warehousing tools including SSIS, Data Modeling Tools like Erwin using Oracle, DB2, MS SQL Server databases, SAP.
• Experience in OLTP/OLAP System Study, Analysis and ER Modeling, Maintaining Database like Star Schema and Snowflake Schema used in relational and dimensional modeling and Kimball methodology.

TECHNICAL SKILLS:

BI Tools: Cognos Analytics11, Cognos 10.2.2/10.2, Cognos 10.1, Cognos 8x,Cognos TM1 10.2.2/, Business Objects XI Rel2.0, TM1 Web, Tableau 9/9.2

ETL Tools: Informatica 8.6/9, Data stage 7.5, Microsoft SSIS 2008, Cognos Data Manager.

Database s: Oracle 10G/11g, SQL Server 2005/ 2008/2010/2012, Teradata 12/V2R6, DB2 8.0

Web Server s: Apache web server, IIS 7.0.

Language s: C, HTML, SQL, PL/SQL.

Internet Technologies: HTML, DHTML, ASP, Java Script and VB Script, XML.

PROFESSIONAL EXPERIENCE:

Confidential, Nashville,TN

Sr. Cognos Developer/TM1 Developer

Responsibilities:

• Installed and configured Cognos Analytics 11 on R&D servers.
• Developed some POC reports using Cognos Analytics 11.
• Involved in meetings with the users which included discussing and gathering the business requirements, reporting enhancements, changes and issues.
• Worked on enhancements and modifications of the Meta data models using Framework Manager.
• Used Framework Manager to create different layers like Database Layer, Transformation Layer and Presentation Layer by defining appropriate relationships between query subjects.
• Designed Meta Data Model’s - Packages in Framework Manager.
• Worked on Enhancements in Dash Boarding For 11V, We provide access to relational frame work manager(FM) packages directly from the Dash Board.
• Developed various templates by using Cognos Analystics 11 that contain pre define layout and grid lines for easy arrangements and alignment of the visulization in view.
• Was involved in designing TM1 application architecture and its workflow
• Involved in TM1 10.1.1 installation and configured Perspective and TM1 web as remote servers
• Extensively worked on widget connections by using Cognos 11V to compare sales values of various products and created sales dash Board
• 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
• 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.
• 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
• 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.
• 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.
• Worked closely with the ETL and QA teams and involved in meetings to discuss test case documents and resolve any kind of issues reported during the testing process.
• Wrote simple to complex SQL queries in the process of unit testing of the reports.
• Involved in Scheduling and distributing the reports using Cognos administration.
• Created the export and import packages in content administration.
• Worked closely with the migration team to deploy the reports and packages from Development to QA, UAT and Production environments.
• Customized Cognos Data Source Connection with appropriate reports and security measures.

Environment: Cognos Analytics 11.0.3/11.0.4 (Report Studio, Cognos Workspace Advanced, Data Module, Cognos Workspace, Cognos Connection, Framework Manger, Query Studio, Event Studio), Cognos TM1 10.2.2/10.2 .1 (Architect, Contributor, Perspectives, Turbo Integrator), Cognos Analytics 11, TM1 Architect, TM1 Web, Turbo Integrator, SAP, Oracle 10g/11gSQL Server 2008/2010/2012, SSIS, Informatica 9.

Confidential, Jacksonville, FL

Cognos Developer/ Architect/TM1 Developer

Responsibilities:

• Installed and configured Cognos Analytics 10.x on R&D servers.
• Developed some POC reports using Cognos 10.1, 10.2.1, 10.2.2.
• Recommended best practices to build and maintain Framework Manager Models, metadata packages, and Transformer models.
• Designed Cognos framework according to the need of the project.
• Worked on enhancements and modifications of the Meta data models using Framework Manager.
• Involved in meetings with the users which included discussing and gathering the business requirements,
• Used different functionalities like Cascading Prompts, Optional prompts, Conditional Formatting, Conditional Variables, Render Variables, Page Break, Page Sectioning, Drill through, Drill Down, Drill up, Bookmarks and Conditional Blocking.
• Cognos cube Designer is used to model Dynamic Cubes.
• Assigned Administration tasks include the cube to the Query Service instance, starting it, monitoring its health, and refreshing its contents.
• Configured Dynamic Cube by publishing a dynamic cube to Content Manager as a data source and for a dispatcher.
• Assigned dynamic cube on dispatcher machine with high CPU and memory capacity in excess of required for DQM server.
• Developed and enhanced of Cognos Portal through SDK
• Designed and developed standard reporting and ad-hoc reporting environments
• Improved the report performance by analyzing and comparing the turnaround times between Database and Cognos.
• Worked closely with the ETL and QA teams and involved in meetings to discuss test case documents and resolve any kind of issues reported during the testing process.
• Wrote simple to complex SQL queries in the process of unit testing of the reports.
• Involved in Scheduling and distributing the reports using Cognos administration.
• Created the export and import packages in content administration.
• Worked closely with the migration team to deploy the reports and packages from Development to QA, UAT and Production environments.
• Customized Cognos Data Source Connection with appropriate reports and security measures.
• Created Standard Template design for report studio reports and Created ad hoc reports using Cognos Workspace Advanced.
• Created Sales dashboard for Sales Department using Tableau Desktop and published work book to Tableau server.
• Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio.
• Installed and Configured Cognos TM1 and various components.
• Conducted training sessions to help users generate reports to meet their daily reporting needs. Creation of dimensions cubes and processors using TM1 architect for Finance team.
• Creation of rules using the rules editor and adding Business Rules to Cubes. Scheduling of TM1 process for data population.
• Created TM1 Workflow process and assigned the Task to TM1 Users. Created reports using TM1 web base application.
• Creating TM1 Application by adding TM1 objects and External files to an application
• Loading and Maintain Data in Cube using Turbo Integrator. Optimize the Rule Performance by adding SKIPCHECK and FEEDERS. Integrated TM1 cubes with Cognos 10.2 and used as a source to build BI reports in Report Studio.
• Created Dashboards using Cognos Work space comprising of list reports, cross-tab reports and chart reports using underlying multiple query structure by using filters, calculations, complex expressions, and conditional formatting.

Environment: Cognos 10.2.2/10.1/10.2 (Dynamic Cubes, Dyamic Cube Designer, Report Studio, Cognos Workspace Advanced, Cognos Workspace, Cognos Connection, Framework Manger, Query Studio, Event Studio), Cognos TM1 10.2.2/10.2 .1, TM1 Architect, TM1 Web, Turbo Integrator, Tableau Desktop 9.2/9, Tableau Server, Oracle 10g/11gSQL Server 2008/2010/2012, SSIS, Informatica 9, IBM Netezza, IBM DB2, SAP

Confidential, Portland, OR

Cognos Developer/ TM1 Developer

Responsibilities:

• Installed and configured Cognos 10.1 in distributed environment.
• Used IIS for configuring web server and set up security using Active Directory.
• Provided access to users to respective groups and roles.
• Monitored servers, schedules and set up Audit database for Cognos Audits.
• Analyzed business requirements and prepared functional specifications/system technical design documentation.
• Designed Framework Manager Projects, Model & Packages by importing the Metadata from various Data Source tables, Views, Data Marts and Macros.
• Defined cardinalities between the data objects for ad-hoc query users and power users.
• Worked extensively on relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Created most of the Documents like Technical Document, LLD, TM1 and BI integration document, Work flow Document, Project Plan, Document on report format and Standards, etc.
• Managed and designed the Cognos BI and TM1 integration for reporting and analysis.
• Designed and implemented TM1 architecture for the corporate planning system and applications.
• Created solutions pertaining to financial budgeting, planning and forecasting, sales and profitability solutions for companywide analysis using Cognos TM1 suite.
• Provided technical guidance and solution to junior developers in the team
• Managed data load, batch monitoring, cube refresh schedule and production support activities
• Planned and conducted user training sessions for super level user. Trained users on TM1 Perspective, Cognos Query Studio and Event studio.
• Participated in data model creation resulting in creating Star schema architecture, Snow-Flake Model and Fact and Dimensional Models as per project requirements.
• Developed Prompt Pages and used Conditional Formatting.
• Developed the Drill Through Reports, Master Detail Reports Using Report Studio and Query Studio
• Developed some custom report templates based on user requirements.
• Designed summary and detail reports which involves the key functionalities of the report studio like conditional blocks, conditional layouts.
• Developed OLAP cubes from the Cognos Power Play Transformer using IQD files that were generated from the Framework Manager.
• Created URL’s to navigate from one report to another report using Java Script functionality.
• Creating Analyses from the published cubes using Analysis Studio as per the Business needs.
• Creating the scripts for the automation of cube building and publishing.
• Writing the Java Script in Report Studio Reports to display default values in value prompt.
• Bursting complex reports and scheduling them to improve server performance and delivered the reports through email.
• Tested all the reports against UAT and Production from the test cases provided by Database team.
• Provided extensive training to end users, how to use the Dashboard reports in Cognos 8.
• Installation & Configuring the Cognos 8.4 on Windows Environment.

Environment: Cognos 10.1(Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio), Cognos 8.4 FP2 Suite, Cognos Data Manager, Power Play Transformer, SQL Server2005, Toad, Cognos Access Manger, Oracle 10g, Cognos TM1 9.4, TM1 Web, Windows 2003 Server, IIS, Informatica 8.

Confidential, Colmbous,OH

BI Consultant

Responsibilities:

• Designing Cognos Framework Manager Model for the Data Marts.
• Built Several List, Crosstab reports using Cognos 8.3 Report Studio.
• Implementation of Framework Manager Model in Cognos 8.3.
• Implementation of Data Level, Object Level and Package Level Security in Framework Manager Model.
• Creation of Model Query Subjects, Embedded and Model Filters.
• Developed FM Model against STAR, SNOWFLAKE and Fact Constellation Data Models.
• Creation of Packages and publishing the same.
• Educating business users on how to make use of the Cognos Package/Namespace in Cognos Query Studio.
• Creation of Complex Reports in Report Studio.
• Created complex report by making use of Style Variable, Render variable and Block Variables in Report Studio.
• Created DMR in Framework Manager Model against relational Data Source.
• Installation & Configuring the Cognos 8.3 on Windows Environment and Configured with LDAP.
• Working experience with different date functions like YTD, QTD, MTD in Report Studio
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting.
• Created Executive Dashboards, complex reports using Report Studio.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Carried out Testing by developing test scenarios, test cases, test data to be used in testing based on business and user requirements, technical specifications and/or product knowledge.
• Assisted Quality Assurance Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas

Environment: Cognos 8.3/8.4, Transformer 8.4, Framework Manager, Cognos Report Studio, SQL Server 2005/2008, PeopleSoft.

Confidential

Cognos Developer

Responsibilities:

• Used Framework Manager to create models, packages and publish packages to the Cognos 8 Server.
• Migration of reports and catalogs from Cognos series 7.1 to Cognos series 8.3. Upgrading of reports from series 7.1 to series 7.3
• Experience in developing models using prompts and filters.
• Distributed reports to various agents using Bursting.
• Added new Dimensions and Measures in the already existing reports in the Production.
• Performed BI Content Administration tasks including scheduling and content management
• Developed SQL in TOAD and exported results to Access Database.
• Developed SQL Driven reports.
• Administered user access protocols and managed user accounts and access privileges.
• Setting up different environments(development, testing and production)
• Deployed the reports from development to QA and QA to production using deployment tool.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Created various portals involving Cognos 8 port lets.
• Administer user access protocols and created user accounts and access privileges

Environment: Cognos 8BI,Cognos Connection, Report Studio, Query Studio, Analysis studio, Metric studio, Frame Work Manager, Oracle 10g, SQL, Scheduler, XML and Windows NT/4.0

Confidential

Cognos Developer

Responsibilities:

• Created Packages and Folders in Framework Manager1.1 and published them to Cognos Connection.
• Gathered and analyzed business requirements from users and business community.
• Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.
• Created Sophisticated Reports using Report Studio 1.1
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Supported Business Users in generating Adhoc Reports using Query Studio1.1.
• Catalogs were Optimized by using Database Interaction, Client/Server balancing, Database functions, Table Weighting and Qualification, Governors Settings.
• Created filters, prompts, sub reports, provide drill through capabilities
• Creating User Classes and Restricting the user access with the help of User Class Privileges in the Governor settings.
• Worked on Star Schema Database Design.

Environment: Cognos Report Net 1.1MR2, Cognos Connection, Report Studio, Framework Manager1.1 MR2, Cognos Impromptu 7.1 MR3, Cognos Access Manager, Cognos Scheduler, SQL, PL/SQL, Oracle 8i, Windows XP.