SUMMARY

• Over 7+ years of hands on experience in IT industry as Cognos Developer with Extensive exposure to various business domains such as Finance, Banking, Automobile, Insurance and Healthcare providing Functional and Technical services experience in Data Warehousing, Data Modeling, Business Intelligence (BI), Decision Support Systems (DSS), OLAP, ETL tools, product development and Reports Generation.
• Experience in full life cycle of Software Development (SDLC) such as gathering and documenting user requirements, Analysis, Design, coding, Development, Customization, Testing, Deployment, and security.
• Experience in COGNOS suit - Framework Manager, Cube Designer, Query Studio, Report Studio, Analysis Studio, Event, Metric Studio, Workspace Advanced, Cognos Connection, Power Play Studio
• Experience in Impromptu web reports (IWR)(7.3, 7.4, 7.5), Powerplay Transformer, Enterprise server, Access Manager, cognos scheduler Visualizer, OLAP Cubes and Power Play Windows/Web, upfront).
• Experience in Administration, designing, development, deployment, Scoping and estimating using COGNOS Suite 6 / 7 / 8/ 10/11 and ReportNet (1.1, 8.1.2, 8.3) MR1, MR2, MR3, MR4.
• Experience in Cognos TM 1 10.2.2/10.1.1/9.5/10.3 (Planning Analytics) - Design and Development at Functional and Technical levels. Modeling, creating enterprise data, enterprise, analytical reporting.
• Expertise in Metadata Modeling - Create project, Prepare Metadata, Prepare the Business View, Create and Manage packages, Set security and publish into portal.
• Experience in Physical Layer and Business Layer, Presentation Layer and modifying relationships, resolving the loops and Dimensionally Modeled Relational data (DMR/ROLAP).
• Experience in ETL Tools - Extracting data from source systems (Oracle, MSSQL, PL/SQL, T-SQL and IBM DB2) and bringing it into the data warehouse utilizing an ETL tool like Cognos and Informatica.
• Experience in Oracle 11g/10g/9i/8g/7g SQL SERVER 2000/2005, 2008, MDX Queries, DB2 and Teradata, SQL queries, PL/SQL scripts, TOAD. Proficient in RDBMS, CDBMS, NoSQL DBMS.
• Experience in Create Views, PL/SQL Stored Procedures, Functions, MDX, Triggers, Cursors.
• Performance Tuning of SQL Queries with good knowledge in XML, HTML, DHTML and Java script.
• Expertise in Report building using Report Studio, Query Studio and Analysis Studio.
• Experience in Advanced Turbo Integrator scripting and scheduling Turbo Integrator process.
• Experience in designing cube, Transformer model design and Power play cube building.
• Experience in developments, bug fixes, testing, Deployment of product upgrades and configurations.
• Experience in the installing, upgrading and administration of COGNOS Packages and client tools like Framework Manger, Transformer and Powerplay and configured.
• Experience in Upgrading and reports migration from Cognos7 to Cognos8 to Cognos10 Versions.
• Experience in Data migration from Oracle/Access/Excel Sheets to SQL Server 2000/2005/2008.
• Proficient creating complex DTS Packages for Data Migration and Transformation.
• Troubleshooting and resolving complex Production and Performance issues.

TECHNICAL SKILLS

Enterprise Planninge/ BI Tools: COGNOS 10 (10.2/10.2.1/10.2.2 ) (Framework Manager, Report Studio, Analysis Studio, Query Studio, Business Insight, Business Insight Advanced, OLAP Cubes, Cognos Connection and Transformer) Cognos 8 (8.4/8.3/8.2) (Report Studio, Query Studio, Analysis Studio, Metrics Studio, Event Studio, Transformer, Framework Manager), SAP Business Objects.

Cognos Audit packages, Cognos SDK: COGNOS TM1 (10.2.2/10.1.1/9.5.1/9.4 ), Cognos Analytics 11, QlikView

ETL Tools: Informatica Power Center 8.1, IBM DataStage, SSIS/DTS, Custom ETL solution with T- SQL, PL/SQL & Cognos TM1, SAP BW

Databases: Oracle 11g/10g/9i/8.i, SQL Server 2000/2005, 2008, SSIS, SSAS, SSRS MDX Queries, DB2, MS Access, sysbase SQL Server, Informix, Netezza

Modeling: Erwin 7.1, 7.3, TOAD, SQL*PLUS

Languages: SQL, PL/SQL, Perl, Shell scripts, JSP, VB, HTML, CSS, XML, C#, C, Python, JAVA

OS: Windows 95/98/2000/XP/NT/8/10, AIX, SOLARIS, Unix/Linux, Mac

Web Server: Java Web Server, Apache Web Server, IIS 5.0, Web Logic 7.0

OLAP: Cognos TM1 9.5.1 (Turbo-Integrator, Web, Rules, Perspective), Cognos Power-Play Transformer, Power-Play for Windows, Excel & Web MS Analysis Services (SSAS), PivotTable Services

Project Management: Water Fall & Agile/Scrum Method

PROFESSIONAL EXPERIENCE

Sr. Cognos Developer

Confidential, NY

Responsibilities:

• Involve in Business requirements gathering, technical designs, testing and documentation.
• Involved in Full life cycle project development (SDLC), including design, coding and testing development, and implementation, ongoing product support and troubleshooting.
• Working on IBM Cognos Report Studio, Analysis Studio, Query Studio, Framework manager, TM1 data loads, Turbo Integrator, Cognos Workspace, viewer, Business Insight, ReportNet.
• Used Fact, Dimensional modeling (DMR), Star Schema and Snow flake modeling techniques.
• Involved in metadata modeling in Framework Manager using OLAP data source.
• Define relationship between query subjects and fact tables in Framework Manager.
• Developed List report, Cross Tab report, Chart, tabbed and Repeater table in Report Studio.
• Used dynamic measures, dynamic column selection using render variables in Report Studio.
• Developed reports using complex filters, Cascading prompts, optional prompts, Conditional Formatting, Conditional Page layout, page Breaks, sorting, grouping, Set Operations.
• Implemented data level, object level, row level and package level security.
• Developed TM1(10.2) Rules editor to create, update various calculations, Turbo Integrator process, Dimension, Hierarchy, Dimension subset, TM1 financial forecasting model.
• Documented the TM1 Design proposed and created Support documents for the business.
• Manage TM1 data in Excel, Spreadsheets and Setup user security across the TM1 models.
• Created regularly scheduled automated jobs to load TM1 data structures.
• Involved in the IBM Cognos TM 1 10.2.2/10.1.1 dimensional cubes development.
• Involved in budgeting and planning applications with TM1 Web and TM1 Applications web
• Use Powerplay connect to Setup cube and prepare cube for drill trough access.
• Create External Query Subjects for development of transformer Models and Cubes.
• Design, develop, maintain, modify and deploy OLAP cubes, reports, dashboards, scorecards.
• Developed the OLAP cubes and created templates for the users.
• Used Time-based partitioning to optimize cubes for OLAP reporting purposes
• Create appropriate dimensions, manual levels and cube groups in the Transformer model.
• Created Namespaces - Database Layer, Business Layer, and Presentation Layer, Query Subjects, Filters -Stand alone and embedded filters.
• Financial Reports like Comparative Balance sheet, P&L Trend analysis, Activity Statement, and Cash Flow reports. Dashboard Reports like Trend over Time, Variance and Forecast.
• Configured ReportNet to use Cognos 10 namespace to render entities in Cognos Connection.
• Involved in converting catalogs into ReportNet 1.1 MR3/MR4 packages using migration utility.
• Develop centralized reporting system for users to perform analytical and ad-hoc reporting.
• Trained end users to effectively use Cognos Workspace Advanced to build and review reports.
• Using JavaScript for prompts built tabbed reports, dynamic sorting column header, hiding and showing objects.
• Involved in projects using SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Data Transformation Services (DTS).
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Used ROLAP and OLAP models as source to create reports using Report Studio
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user input and performance tuning and monitoring of both T-SQL and PL/SQL blocks
• Write Tabular SQL, PL/SQL code, stored procedures, Views, Functions for data analysis.
• Involved in development, deployment, scheduling and troubleshooting SSIS packages.
• Involved in Teradata scripts and shell scripts migration process on the UNIX box.
• Involved in writing, tuning SQL queries to debug data loads, QA, User Acceptance level testing.
• Test/analyze the report by running queries in SQL server to make sure data accuracy/quality.
• Developed Impromptu Web Reports and published using Upfront.
• Helped on migrating theCognosImpromptu Catalogs to Webfocus
• Migrating existing financial reports from Cognos 8.4 to Cognos 10.2.2
• Modified Cognos portal, Edited the system.xml and the default.css files to have a better UI.
• Provided the Technical Support testing and reviewing the application based on the test cases.
• Deploy and support Cognos reports, ad-hoc packages, and OLAP cubes.
• Worked with HTML items/Java Script in Cognos Report Studio to customize reports
• Developed Complex Reports, Dashboards for Mobile and IPad Report Applications.
• Extracted data from databases using ETL tools like data manager and InfoSphere Datastage.
• Cognos SDK for ReportNet. Designed Cognos SDK App using Java and integrated into portal.
• Monitor logs for active users. Backup and recovery plans and testing.
• Experience in on-shore and offshore.
• Use QlikView when needed for Data Visualization, quick data discovery and flexibility.
• Resolved helpdesk tickets and Issues troubleshooting- forms server, Apache server issues.
• Setup user/clients and roles, manage setting security/Authoring permissions of reports.
• Worked with IBM on installing and configuring Cognos Analytics 11 on cloud platform.

Environment: IBM Cognos 11/10.2.1/10.2.2 product suit, COGNOS TM1 10.2/10.1 Application, Snowflake, OLAP, ReportNet 1.1 MR2/MR3, SSIS, SIS HTML, Java script, Oracle 9i/10g/11g/12c, SQL Queries, SQL Server 2008/2012, ERwin, Toad 11.6, QlikView 11/11.2, Datastage 11.5/11.3

Sr. Cognos Developer

Confidential - Washington, DC

Responsibilities:

• Involved in complete SDLC - Requirements gathering, technical designs, documentation etc.
• Installed and Configured IBM Cognos BI and Cognos Insight 10.2 and Cognos TM1 Application.
• Developed report layout as List report, Cross Tab report, Chart reports and Repeater tables.
• Created Active Dash Board Reports using Report Studio, Business Insight and Advanced.
• Dashboard were created Using Business Insight Advance and finely tuned for performance.
• Developed DMR modeling, Star schema model using Framework Manager.
• Created models in Framework Manager and cubes in Transformer using various data sources.
• Created Multidimensional cubes and generated categories in Cognos PowerPlay transformer.
• Develop, maintain, and manage Cognos cubes, transformer models, and Framework Manager
• Published cubes and OLAP reports using PowerPlay Enterprise Server to Cognos Portal.
• Deploy and support Cognos reports, ad-hoc packages and OLAP cubes.
• Proficient in Metadata modeling with Framework Manager and experience in layered approach such as Physical Layer and Business Layer, Presentation Layer.
• Used Framework Manager to externalize query subjects in order to generate IQD data sources for Powerplay cube creation in Powerplay Transformer.
• Involved in Designing models with Relational Data using Framework Manager.
• Publish packages to the Cognos Reporting Servers.
• Assist analysis, troubleshooting source data which is fed to TM1 cubes from Cognos Planning
• Setup security standards data level, object level and package level in framework manager.
• Designed and developed reports in Report Studio with drill-down and slice-and-dice options.
• Implementing the HTML items in the Reports to get the Dynamic Reports.
• Upgraded Framework Manager Models, Transformer Cubes from Cognos 8.4 to 10.2.1.
• Involved in extracting data from Oracle, Sybase, and Flat files
• Involved with ETL team in testing the data manipulated through Datastage.
• Worked on Advanced turbo Integrator scripting, Advanced rule and feeder development.
• Developed Reports using Cognos Insight and published into Cognos TM1 Application and Cognos Connection.
• Designed Budgeting and Forecasting models for medical group units using Cognos TM1 10.2
• Developed Scorecards using Metrics Studio for trending Analysis.
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting using JAVA Script
• Involved in Testing ORACLE, SQL Scripts, PL/SQL Stored Procedures, functions, packages.
• Used T-SQL scripts for Developing stored procedures, functions and triggers database maintenance, deployment and installation.
• Developed SQL Driven reports, SQL in TOAD and exported results to Access Database.
• Used SQL server management tool to verify database as compared to the requirement given.
• Done Unit Testing of the reports by checking the report to SQL output and Documented.
• Testing the Report data with the Oracle SQL scripts.
• Involved in the entire project of migrating reports and cubes from Cognos 8 to Cognos 10.2
• Trained end users onQuery Studiofor Ad-hoc reporting and involved in the Documentation.
• Configured the .ini files for faster cube load in Upfront and Customize the Upfront pages.
• Maintain, monitor, and support Cognos security groups and account.
• Analyzed, troubleshoot and tuned product performance and fixed deployment issues.

Environment: Cognos 10.2.2/10.2.1/8.4, Cognos Connection, Workspace, Workspace Advanced, Transformer and Report Studio, IBM Cognos TM1 9.5/10.2, Cognos SDK, SSIS, Unix shell script, HTML, SQL Server 2008, Oracle 9i/10g/11g/12c, DB2 v7, SQL, ReportNet 1.1 MR2/MR3, TOAD 11.6/10.

Cognos Developer

Confidential, MI

Responsibilities:

• Involved in full datawarehouse project lifecycle (SDLC) - assessment, requirements gathering, data modeling and database design, ETL/BI architectures, Reporting Model and report Development, performance tuning, and data delivery mechanisms.
• Worked with business users, lead to understand and document the Business requirements.
• Developed and implemented information management solutions as a part of BI Organization.
• Participated in the design, development, deployment and support of Reporting solutions in the areas of Sales & Marketing, Forecast & Planning and Supplier Performance.
• Developed report layout as List report, Cross Tab report, Chart reports and Repeater table.
• Involved in the design and implementation of balanced scorecard and on OLAP solutions.
• Deploy and support Cognos reports, ad-hoc packages and OLAP cubes.
• Build OLAP cubes using Cognos Transformer, views using Power Play.
• Designed SSAS Cubes in Microsoft analysis server 2005.
• Created complex financial reports using different calculations in Impromptu
• Implemented security at Cubes using Apex, Cloak, Suppress, and Exclude.
• Used union and Join objects, repaired joins, created new joins, built standalone filters.
• Developed high-level designs - logical models and functional specification documents.
• Built metadata models in Framework Manager, which could be used by Report Developers.
• Actively worked with the BI team and Business to transmit the application into Production Environment by providing support and training through the release cycle.
• Prepared training materials, developing Business models and training users in Query Studio according to their specific needs and requirements.
• Assisted ETL developers with model being developed is according to business requirements.
• Responsible for deployment of the reports from TEST to PROD & DEV to TEST.
• Developed complex Reports using different features like slice & dice, Drill capabilities, queries, Master detail reports and cross tab tables with multiple breaks.
• Development of TM1 financial forecasting model.
• Designed and developed Powerplay cubes for multidimensional analysis for Sales, Marketing, Forecast and Planning users.
• Provided Drilldown capability from Power cubes to Report Studio Reports.
• Develop & administer SSAS cubes to support ad-hoc production reporting needs.
• Automate loading of cubes and develop supporting integration (SSIS).
• Created complex stored procedures & SSIS jobs in SQL Server 2005/2008.
• Publish Framework Packages to Dev, QA Servers.
• Wrote SQL scripts and developed audit reports to compare warehouse data with the staging and source data.
• Involved in using SDK to validate reports for Cognos ReportNet 1.1 MR1/2 and Cognos8 SDK.
• Managed Package Migrations and Deployments from one Environment to another.
• Resolved issues for the reports during QA, UAT phase using JIRA 6.3 issue tracking system.
• Written complex SQL queries for the data validation of the reports using Oracle 11g.
• Wrote Procedures and triggers in Oracle for file handling, data validation, and Inserting data.
• Involved in Cognos deployment between DEV/QA/UAT/PROD environments.
• Used Cognos SDK to develop various java applications.
• Worked in JIRA /QC's ticket tracking tool to resolve the issues raised by the end users
• Created documentation for the complete project life cycle and Provided Technical Support.

Environment: Cognos 8.4 (Cognos Connection, Report Studio, Analysis Studio), Framework Manager, SQL Server 2005/2008, Cognos SDK, JIRA 6.3, Oracle SQL Developer 4.0, SSIS, SSAS, Oracle 9i/10g/11g/12c, ReportNet 1.0/1.1 MR1, MR2, Cognos TM1 9.5.2

Cognos Developer

Confidential

Responsibilities:

• Involved in the installation and configuration of Cognos 8.4
• Involved in Requirement gathering from Business Users.
• Security validation of user access/Data source access through Cognos Access Manager
• Developed reports in Report Studio upon requests from business users
• Created and published Packages using Framework Manager.
• Implemented data level security, object level security and package level security using the Framework manager and Access manager.
• Created several Repeater and Repeater table Reports using Report Studio.
• Created reusable templates for creating of reports.
• Designed & developed list reports, crosstab reports, master-detail, chart reports, and complex reports with conditional blocks, static choices in prompt.
• Used various Prompts, Drill-through, master-detail relationships, conditional formatting, grouping/sorting features, layout calculation of Report Studio to generate efficient reports.
• Involved in developing data models using ER/Studio (Modeling, Metadata Management).
• Deployed packages, folders, reports - development to Testing and Production environment
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports
• Created Burst Reports and Multilingual Reports based on groups of users & Preferences.
• Write and maintain technical specifications that describe program development, data modeling, coding, testing, changes, corrections and Report Authoring.
• Defined hierarchies according to business requirements for Drill ability.
• Created some Complex interactive reports using conditional formatting.
• Deploying Sample, Testing the Server and Managing Cognos Connection Portal.

Environment: Cognos 8.4, Transformer 8.4, Report Studio, Query Studio, Event Studio, Analysis Studio, Oracle 11g/10g, DB2, SQL Server 2008, TOAD 10, ER/Studio, Cognos Access Manager.

Cognos Report Developer

Confidential

Responsibilities:

• Involved with the Business Analysts team to collect the requirements for users and turn them to technical specifications.
• Involved in the design and development of reports inReport Studio
• Created database connections for different data sources
• Built models usingFramework Managerand published the package
• Accessed published package usingCognosConnection
• Created Query Subjects in Framework Manager as stored procedure source.
• Involved in Dimensional Data Modeling using Erwin 3.5.2 Data Modeler
• Involved in developing the DMR models using the existing models
• Used DMR models in the Analysis for creating Analysis Reports.
• Framework ManagerQuery Subject was pointed to SQL Server 2000 as database.
• The sameFramework Manageris deployed to Oracle 9 and all theReportNetreports made to run successfully on both the platform
• Create and manage scheduled jobs Createdcomplex reports with Sub and Sub-Sub-queries
• Used Cognos Impromptu tool to create standard and ad-hoc reports.
• Created reports that includedComplex Reportfunctionality such as prompt pages, cascading prompts, conditional filters etc
• The report was designed as a"Master-Detail"report as every manager could have several objectives, strategies and resources.
• Exposure on Cognos Software development kit - SDK to customize reports.
• Wrote SQL queries to enhance the performance of the cognos reports.
• Troubleshooting application or Data issues as needed and manage and resolve tickets.

Environment: Cognos 8 BI, Framework Manager, Cognos Connection, Report Studio, Query Studio, Erwin 3.5.2, Metric Studio, Impromptu 7.4, Cognos Power Play Transformer 7.4, Power Play for Web, Access Manager, XML, SQL Server 2005, Oracle 10g, DB2, RHEL 3.x, Windows 2003 server.