SUMMARY

• Over 7+ years of working experience as a Senior BI Developer with an experience in Cognos 10.x, 8, Framework Manager, Query Studio, Analysis Studio, Metric Studio, Cognos Connection, Work Space, Work Space Advanced and CD.
• Technical expertise in Data Warehousing (Relational, Dimensional Relational (DMR), &OLAP Cubes) modeling and development, schemas (Star & Snowflake), logical data marts & table structures (fact & dimension) using Data Modeling tools such as Cognos Transformer, Cube Designer and Framework Manager.
• Developing Dashboard Scorecards and visualizations using Cognos and Tableau.
• Developed and maintained Transformer and Dynamic Cube Models.
• Building & maintaining Power cubes in Transformer using relational, DMR and OLAP packages as data sources.
• Developed various Complex reports using Report Studio involving Bursting and Macros.
• Created and maintained all metadata models both Relational and DMR (framework manager).
• Developed Oracle views, functions, and procedures to help with reporting.
• Experience in creating Prompts, Cascading Prompts, Conditional Variables and Bookmarks with multiple Report pages and multiple Prompt pages in Report Studio.
• Delivered solution - oriented complex reports using Report Studio, ad-hoc reporting interfaces using Query Studio, multi-dimensional analysis & visualizations from OLAP cubes using Analysis Studio, created checkpoints & alerts in Event Studio, and developed scorecards & metrics in Metric Studio.
• Performance Tuning report by Query optimization and improved performance of the reports using index, aggregating the data in tables.
• Customizing Reports using Various Queries and JavaScript for date validations.
• Upgrading COGNOS to new versions on a distributed install.
• Installing, configuring and administrating COGNOS products in a distributed multi-server environment.
• Strong SQL, PL/SQL Skills in Validating the Data and writing Stored Procedures.
• Performed administrative roles in COGNOS Connection and set security permissions, configured and maintained users, groups and roles using COGNOS administration. Involved in COGNOS administration and security implementation among COGNOS Applications
• Implemented data loading, migrations, conversions, and scheduled job operations.
• Assists with implementing the processes necessary to refresh or otherwise maintain sets of data for testing and development purposes and automates processes when possible.
• Experience in working with various Relational Databases like MS-SQL Server, Oracle, MS Access and Teradata.
• Experience with ETL using SQL and Batch scripts.

TECHNICAL SKILLS

Tools: and Utilities IBM COGNOS 10.x, 8.x (Report Studio, Query Studio, Framework Manager, COGNOS Connection, Analysis Studio, Event Studio, Power Play, Business insight, Transformer)

Programming skills: PL/SQL, Unix Shell Scripts, HTML, JavaScript, C and C++

O/S Worked: WINDOWS 2000/2003/2008/2012 , UNIX, Linux

Databases: Oracle 9i/10g/11g, SQL Server 2003/2005/2008 , DB2

Web Servers: Microsoft IIS, Apache 6.0/7.0, Apache 2.0

Other: MS Office, Adobe Photoshop.

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Senior Cognos Developer

Responsibilities:

• Interacted with the business users to gather and refine requirements.
• Designed and developed Complex Reports (List Reports, Cross Tab Reports, Chart, Maps, Dashboard Reports and Canned Reports) using Report Studio.
• Created Prompts, Cascading Prompts, Conditional Variables and Bookmarks with multiple Report pages and multiple Prompt pages in Report Studio.
• Designed and Implemented new dashboards.
• Trained end users to use Report Studio, Query Studio, Workspace Advanced and Metrics Studio.
• Created Complex Reports with advanced features such as Master Detailed sections, Conditional formatting, Render variables, Drill-trough, Page set and bursting using Report Studio.
• Developed Metadata models and DMR models using Framework Manager and created filters, prompts, calculations, summaries and functions as per Functional Requirement Specifications.
• Developed and maintained BI architecture principles, best practices, patterns, guidelines, standards, methods, techniques, and models.
• Worked on complex reports using Static Prompt and MDX functions and union conditions
• Expertise in using Query Studio for developing Ad hoc reports.
• Developed Windows Batch scripts for reports and cubes scheduling.
• Developed and Present POC on modeling, administration activities, design and implement production processing architecture, including performance monitoring, scheduling, and notification in the event of failures.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Extensively involved in designing/developing Transformer models and Cubes with single or multiple data sources.
• Followed quality standards and best practices for the development tasks.
• Documented and analyzed user requirements.
• Hands on experience in using various query components of Report Studio including Join and Union and intersect.
• Created Backups of the content store and Public folders and involved in performance tuning of several Reports.
• Effectively involved in Unit Testing
• Added Data Security, Object and Row level Security according to the requirements.

Environment: Cognos 10.2 and 10.2.2 BI versions, Report Studio 10.2.2, Query Studio 10.2.2, Framework manager, IBM Cognos Configuration, Cognos 10.2 tool suite, SQL, PL/SQL, Windows 2008, 2012.

Confidential, Houston, TX

Senior Cognos Developer

Responsibilities:

• Participated in requirement meetings with end-users to understand and collect Business Intelligence (BI) report and Web content needs.
• Installed, configured and administered various Cognos components such as the Cognos BI server, Framework Manager and Transformer, Cube designer on Linux operating system.
• Involved in the installation and configuration of Cognos server in Dev, Test, UAT and Production environments on Linux virtual platform.
• Performed backup, upgrades, set up security roles and users, and troubleshoot by understanding the various log messages using Cognos log view analyzer.
• Involved in creating and maintaining installation documentation and architectural diagrams.
• Used SSL protocols for communication between Cognos components in single server and distributed installations.
• Developed BI analytical and reporting solutions based on user needs and maintain interfaces using Cognos SDK.
• Involved in installation and configuration of TM1 architect, TM1web components, clients, TM1 server, and Contributor.
• Applied security to the TM1 cubes by creating and managing clients and assigning clients to various groups and defined the security to groups.
• Created dimensions manually as well as using Turbo Integrator Process.
• Load the data into cubes by using ETL Tool Turbo integrator to create dimensions and levels and hierarchies.
• Maintain and create rules, feeders, and TI processes and performed the complex calculations using the Rules.
• Created chores with different processes and scheduled the chores to run at specific times.
• Integrate the TM1 data with Excel spreadsheets by using TM1 perspective and also created active forms and enhanced the performance of active forms.
• Design and developed the Dynamic cubes by importing the data from Framework manager as well as importing data from data sources.
• Developed Dynamic cubes using Multidimensional calculations.
• Used Aggregate advisor in optimizing the performance of dynamic cubes.
• Implemented Performance tuning of Dynamic cubes as well as experience on data validation.
• Maintained existing Dashboard reports and developed additional reports as required. Created new dashboards using workspace and maintain user security and kept active users up to date.
• Created highly interactive portable active reports using Cognos 10.2 report studio.
• Distributed the developed active reports to management and users and external customers through emails and mobile distribution.
• Developed Complex reports using Report Studio, which includes various report types ranging from simple lists, crosstabs and chart through complex dashboards, drill-through, master-detail and conditional formatting.
• Develop and maintain shell scripts to accomplish merging of final PDF report outputs using third party software.
• Created multipage reports involving prompts, cascading prompts, conditional rendering and conditional highlighting.
• Worked elaborately in modeling of metadata, such as by creating joins among Query Subjects with proper Cardinality and also used Determinants to maintain the proper granularity.
• Hands on experience in using various query components of Report Studio including Join and Union and intersect.
• Created Backups of the content store and Public folders and involved in performance tuning of several Reports.

Environment: Cognos 10.2.2 (Transformer, Cube Designer, Report Studio, Workspace, Workspace Advanced, Analysis Studio, Cognos Connection, Framework manager), Cognos 10.2 tool suite and Performance Management tools (TM1 Architect and Perspective, IBM Cognos insight), Tableau8.2, Oracle 12c, 11g, SQL, PL/SQL, Toad, Windows 2012,Microsoft Excel.

Confidential, Michigan

Senior Cognos Developer

Responsibilities:

• Developed TM1 application to gather and consolidate data for annual report
• Developed Cubes, Reports, and Dashboards using Cognos BI
• Used TMI for loading data into Dimensions and Cubes
• Created Ad-hoc queries from multidimensional views for analysis.
• Manage TM1 data through TM1 Reports
• Performed Data Analysis and developed Data Mapping documents for ETL projects.
• Developed and managed projects through Cognos solutions
• Applied and worked on Cognos TM1 and Enterprise.
• Created regularly scheduled automated jobs to load TM1 data structures. Created regularly scheduled automated jobs to load TM1 data structures.
• Developed Dash Board reports, Scorecards, Visual Layouts, Master detail Drill through reports, Drill up and Drill down reports, multiple prompt reports and cascading prompts in Report Studio.
• Created and published packages for different functional areas and assigned security rules to them in Framework Manager.
• Executed the unit as well as system testing of the reports developed.
• Validated reports based on Functional Requirements.
• Manage TM1 data through Excel and Spreadsheets
• Capable of troubleshooting report performance/query optimization issues

Environment: Cognos 10.x, Cognos Framework Manager, Cognos Power Play Transformer, Cognos Access Manager, Oracle 9i Database.

Confidential, Cleveland, OH

Cognos BI Developer

Responsibilities:

• Conducted User Interviews and documented their query, business analysis and reporting needs.
• Understood data and business logic with reports.
• Responsible for creating the Catalogs, Joins and Folders for the users and managing & testing of Catalogs
• Used calculated and special columns in the catalog
• Involved in analyzing joins to improve performance of reports.
• Involved in the design, development and implementation of Power Play Cubes.
• Created Catalog and set User Profiles to grant user permissions for querying.
• Discussed business requirement and mapped Business need using Model Capability of Cognos transformer.
• Defined dimensions, levels and measures.
• Created dimension maps for transformer, established all dimension hierarchies, designed special categories, calculated measures and special time categories.
• Involved in creating dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Monitored Application Server and data server activity to track performance and system stability.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau Server v6/v7, Tableau Desktop v7/v6, Windows Server Standard R2, Clear quest, Clear case, Excel, JAVA, J2EE, SQL Server management studio, MS SQL Server 2008R2, UNIX, LINUX

Confidential, Cleveland, OH

Cognos Developer

Responsibilities:

• Formatting data to analyze in drill mode and slice & dice mode. Develop reports based on user requirements from Business Support users - both for standard reporting and ad hoc requests using Cognos Power Play.
• Involved in the Design, Development, Testing and Implementation of all phases of Project.
• Created shell scripts to ftp the files.
• Publishing priority reports to the Corporate Intranet with security and scheduling them
• Analyzing all reports and standardize these reports using Power Prompts and Charts.
• Created DMR in Framework Manager with the help of the Star Schema models created.
• Extensively worked with List Reports and various formats of report generation like PDF, Xl etc.
• Worked extensively with prompt based reporting.
• Developed cube models in Power Play transformer, creating cubes and publishing the cubes to Power Play web and Cognos 8.
• Published the Cubes to Cognos 8 and using Analysis Studio to analyze the data and creating the reports in Analysis Studio and Report Studio based on the published cubes.
• Maintained Roles and Groups in Cognos 8.4 and scheduled reports to publish, and managed Cognos Connection.
• Used Cognos Scheduler to schedule various reports
• Created Catalog and set User profiles to grant user permissions for querying.
• Created different joins according to requirements
• Created list reports and Drill through reports.
• Documenting and understanding the existing system designs and then building the Power Play Cubes.
• Involved in documenting the project.

Environment: Cognos 8.x, Cognos Power Play 6.0, Cognos Transformer 6.0, Access Manager, Windows NT/2000, UNIX, Oracle 8i

Confidential

Report Developer

Responsibilities:

• Involved in the Design, Development, Testing and Implementation.
• Involved in the design and development of Data Staging tables.
• Involved in creating Ad-Hoc reports.
• Involved in creating reports in query studio for analysis of data.
• Extensively involved in creating complex reports and scheduling them.
• Developing data mapping document and ETL design document.
• Extensive ETL development using Informatica.
• Created sessions and batches and scheduled on daily basis.
• Created Catalog and set User profiles to grant user permissions for querying.
• Created different joins according to requirement
• Effectively involved in Unit Testing
• Created list reports and Drill through reports.
• Creation of Multidimensional Cubes Model using Transformer and generation of Power Play.
• Documenting and understanding the existing system designs and then building the Power Play Cubes.

Environment: Cognos 8, Informatica Power Center 5.1, Cognos Impromptu, Cognos Power Play, Cognos Transformer, Access Manager, Windows NT/2000, UNIX, Oracle 8i, Net, SQL Server, Oracle 9i.