PROFESSIONAL SUMMARY:

• Over 8 years of experience in Business intelligence reporting, Design, Development, Testing and Documentation implementation of Cognos applications and maintenance of data warehouses, data bases, data marts and providing solutions for Manufacturing, Retail, Health care, Insurance, and Banking domains.
• Extensive experience working with Cognos 10.x/8.x Business Intelligence Reporting Suite (Framework Manager, Event Studio, Report Studio, Query Studio, Transformer, Dynamic Cubes, Workspace, Workspace Advanced,Tableau, Qlikview, Visio, Data stage,TM1).
• Installed, configured and worked on Cognos BI suite, including Business Insight & Advanced, Report Studio, Workspace Advanced, Framework manager, Transformer and Cube Designer.
• Involved in COGNOS administration and security implementation among COGNOS Applications using Cognos Access Manager,LDAP, and Custom Authentication Provider. Performed administrative roles in COGNOS Connection and set security permissions, configured and maintained users, groups and roles using COGNOS Administration.
• Technical expertise in Data Warehousing (Relational, Dimensional Relational (DMR),DQM,CQM, &OLAP Cubes) modeling and development, schemas (Star & Snowflake), logical data marts & table structures (fact & dimension) using Modeling tools such as Cognos Transformer, Cube Designer and Framework Manager.
• Had 3 years of experience developing, maintaining and enhancing complex and innovative programs using Java (J2EE), JSP/Servlets, JavaScript, and JDBC and in the whole SDLC.
• Complex Report building experience in Report studio by using filters customized prompts, conditional formatting, drill - through, Cross tab, bursting, Master/details queries.
• Used Java Scripts for validating Date/Time controls and adding customized buttons to facilitate the Show/Hide requests and involved in creating JQuery based on user request.
• Involved in migration and deployment of applications using SDKand had experience in maintaining upgrades, patches, and hot fixesandin Cognos portal customization techniques and in versioning tools like Motio,Service Now and IntegratedControl Suite (ICS).
• Strong SQL, PL/SQL Skills in Validating the Data/Reports and writing Stored Procedures.Extensive experience using various data sources such as Oracle, SQL Server, MySQL, Teradata, DB2, Netezza,Toad, MS Access and XML and also Query Optimization and Performance Tuning of reports.
• Good knowledge in Business Objects and integration Cognos with pega using SOAP and have experience with Cognos Maps.Full understanding of the ETL (Extract, Transform and Load) solution concepts and functional knowledge of Informatica.
• Experience in Designing and Deployment of Reports for the End-User requests using SSRS and Tableau. Experience in IBM Cognos, a Business Intelligence reporting tool to generate reports for non- IT users.
• Proficient in creating documentations like BRD, SRS, FRD,RFP, Wireframes, Mock-ups and conceptual design; creating Use Cases, specifications and Use case scenarios.
• Proficient in analyzing and creating Use Cases, Use Case Diagrams, Data Flow Diagrams, Activity diagrams, Class diagrams and Sequence diagrams using MS Visio.

TECHNICAL SKILLS:

BI Tools: Cognos 11.x, Cognos 10.2.X, Cognos10.1.X, Cognos Business Intelligence (8.1 to 8.4) (Report Studio, Query Studio, Analysis Studio, Metrics Studio, Cognos workspace, Cognos workspace advanced, Cognos Mobile, Cognos administration, Report Net, Cognos Access Manager, TM1, Tableau

Modeling Tools: Cognos Cube Designer, Cognos Transformer & Cognos Framework Manger,Erwin, Motio, ServiceNow, ICS

Database: Toad, SQL Navigator, SQL * Plus,DB2,Netezza,vertica

Languages: SQL, PL/SQL, HTML, MDX, Java script

Project Management Tools: IBM Clear quest, IBM Clear case, VSS, IBM RTC

RDBMS: Oracle Exadata, Oracle 11g/10g/9i/8.x, Teradata, MS Access/Excel, DB2, and SQL Server

Operating Systems: Windows 2003/2008/2012 R2, UNIX, Sun SOLARIS

Web Servers: IIS, Apache 7.0/6.0, Netezza

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Cognos Developer

Responsibilities:

• Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical and ad - hoc reporting for business applications especially financial reports and provide accurate information available to Decision Makers.
• Involved in Designing models with Relational Data using Framework Manager and published packages to the Cognos Reporting Servers.Implemented data level, object level and package level security in framework manager to achieve highly complex security standards.
• Developed active reports using report studio queries over large data sets nearly million rows of data.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Involved in migration of reports from Cognos 7.5 to Cognos 10.2.2 and to cognos 11 and Build active reports and dashboards for C-Level in cognos 11
• Integrate Cognos to batch processes to be able to run/create and save reports using Cognos SDK
• Using the Informatica tool extracted data from various sources and loads data into the warehouse. Involved in performing specific activities include object and environment migrations, security management, new user setup and training to end users, development and support of TM1 applications.
• Have very good experience in setting up the trusted sign on, dashboard installation using the latest features of the cognos SDK.
• Had experience in creating JQuery, JavaScript based on user requirement and Knowledge on SDK integration.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports and Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production and Providing training to the end users and involved in design with the SME's.
• Involved in development and support of web sheets and active forms, development and support of Turbo Integrator processes and support for TM1 Cafe.
• Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support and Production support.
• Interacting with business stakeholders to understand their decision-making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery.
• Involved in generating proper data in excel for Tableau Dashboard.
• Designed and developed Tableau visualizations which include preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies. Build some automated jobs using AWS, Azure.
• Deploying models and reports from Development to Production and administering users/groups/roles.
• Created optional filters/prompts in report studio using Java Script and HTML and had extensive experience in creating master detail relationship in Report studio.

Environment: Cognos 10.2.2 (Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio), Active Reports, Cognos Impromptu 7.5, JavaScript and HTML, SQL Server 2012, Windows 2008, Erwin, Service Now, TM1

Confidential, Chelsea- MA

Sr. BI Developer/Admin

Responsibilities:

• Used Cognos Connection as Web Portal for managing reports.
• Creation of Complex Multi - Object Report Studio Reports using Lists, Crosstabs.
• Involved in Metadata modeling of both Relational and Dimensional data using Framework manager modelling (stitchedqueries, cross joins and loops handling, determinants).
• Experience in implementing security based on user roles in Framework Manager in MUD environment and publishing reports and worked on Netezza and involved in environment set up and in deliverables in UAT/ST environment and has experience with Data warehouse concepts and in SDLC.
• Used static choice value prompts, cascading prompts, master detail relationships, conditional variables (Boolean and string) to create reports and had experience in validation using Java Scripts and had experience in DQM models.
• Involved in creation of templates, building complex reports in report studio and has experience in SAP module. Involved in scheduling the reports using SDK in java language.
• Involved in retrieving the My folders content using SDK. Involved in creating the replica of Motio tool for cognos using SDK
• Providing training to the end users and involved in design with the SME's and involved in writing TSQL using Sybase database.
• Involved in upgrading/migration from Cognos 10.2.1 to Cognos 11.x and in POC's.
• Implemented Drill Through and Prompts for better utilization of reports and implementedDMR modelling using mdx queries and worked on Tableau for one of the other project
• Scheduled Burst Reports for regions, zones and districts which delivered the appropriate output for the concerned mangers in Cognos Connections by email and involved in agile development cycle
• Created Backups of the content store and Public folders and involved in performance tuning of several Reports and involved in building dynamic cubes and had experience in administration of dynamic cubes, performance and ensuring they deployed/administered them in a production environment
• Involved in writing SQL queries to improve performance of the report and developed PL/SQL procedures, packages, triggers and other database objects and had exposure to power BI tool.
• Experience in OLTP/OLAP system study, analysis, E-R modeling and developing database schemas like star schema in DB2, Teradata, PeopleSoft HCM 9.1.
• Involved in IntegratingCognos with pega using mash up services and Web Based Technologies such as (Java, XML, and WSDL) and SDK and involved in doing Cognos reports using Hyperion tool and involved in IBM planning Cognos analyst v10.1.1 and integration with SSO and SSL.
• Experienced in Migration of other reports into Cognos and version up-gradation, patches, and hot fixes for Cognos and involved in developing batch job for reports and in versioning in tools like Motioand has knowledge in Hadoop, AWS domain.

Environment: Cognos 10.x (Framework Manager, Report Studio, AnalysisStudio, Query Studio), SDK, DB2, Tableau, Informatica,Sybase, TM1, Toad, Excel,cognos controller,DB2, Netezza,Active Reports and Ad-hoc Reports.

Confidential, Philadelphia- PA

Sr. BI Admin/Developer

Responsibilities:

• Involved in Analysis and Design of the requirements specification provided by Client, prepared data mapping documents and Business Required Documents.
• Interacted with ETL team and the DBA (permission for database objects) to make available certain tables, views and data modifications required to successfully execute report requirements. Involved in loading data into warehouse using Informatica tool
• Integrate Cognos to batch processes to be able to run/create and save reports using Cognos SDK and involved in scheduling reports using SDK.
• Involved in enhancement and development of cognos portal using Cognos SDK and involved in knowing the users and roles using cognos SDK.
• Experience and had depth knowledge in preparing HR reports for UltiPro system and entire design of SDLC of the HR system and involved in collecting and documenting business requirements, building and testing requested reports, dashboards and workflows
• Involved in designing Dynamic Cubes - in memory tool using Cube Designer tool and deployed in the Cognos environment to increase the performance and fixed the production issues.
• Creation of Complex Report Studio Reports using Lists, Crosstabs, prompts, Multi-Query and have experience in integrating with Cognos Maps
• Involved in Metadata modeling of both Relational and Dimensional data using Framework manager and involved in conversion of CQM models to DQM models.
• Experience in implementing security based on groups and roles in LDAP and CJAP.
• Had extensive experience in creating Active reports in cognos and involved in Agile development lifecycle
• Hands on experience in the data modelling tools like Erwin and in Micro strategy and also in tools like Versioning tool like Service Now and knowledge of healthcare data concepts.
• Extensively used insertable objects like query calculation, layout calculation and tables to generate efficient and user-friendly reports.
• Knowledge in creating Reports and KPI Dashboards using Active Reports and Business Insight and in SSRS/SSIS/SSAS worked on Netezza.
• Involved in Branching and merging enables multiple users to work on the same model at the same time and involved in linking the segments to other projects that contain related information to maintain consistency and reuse information.
• Scheduled Burst Reports for regions, zones and districts which delivered the appropriate output for the concerned mangers in Cognos Connections by email.
• Created Backups of the content store and Public folders and involved in performance tuning of several Reports and involved in migrating the Packages/Reports across environments (DEV, UAT, and PROD).
• Used Java Scripts for validating Date/Time controls and adding customized buttons to facilitate the Show/Hide requests.
• Using Cognos Workspace Advanced and Report Studio, integrated external data directly into the reports
• Experience in OLTP/OLAP system study, analysis, E-R modeling and developing database schemas like star schema and snowflake schema in DB2.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Indicators (KPI) and Measures (Using Tableau).
• Tested and validated the Report output against database to measure performance of reports.

Environment: Cognos 10.x (Framework Manager, Report Studio, Query Studio), Cognos Connection, DB2, Tableau, TM1, Excel, DB2, Netezza,Cognos Data Manager, Active Reports and Ad-hoc Reports.

Confidential, LosAngeles- CA

Sr. Cognos Developer/Admin

Responsibilities:

• Modeling data according to the requirements using Framework Manager.
• Developed Query Subjects, Query Items and added filters to customize data.
• Created DMR models and relational Model - Import database tables defining database layer, presentation layer, business layer, defining proper cardinality, applying determinants, apply row level and object levels security, applying embedded/standalone filters, providing multilingual support to package, publishing package and applying package security.
• Created Classes and Objects, Joins and Predefined conditions, Custom Hierarchies
• Created templates to maintain a uniform standard across all the reports.
• Restricting the user access with help of Access Level privileges and build API/SDK integration architecture with Java based application
• Worked on Stored Procedures in SQL Server Management Studio 2008 R2 and involved in SDLC.
• Developed Ad Hoc Reports Using Business Insight Advanced, Query Studio and complex reports using Report studio
• Created the dashboard report for C1 level using workspace and workspace Advanced.
• Have extensive experience in integrating with Cognos Maps and tool like PEGA and Providing training to the end users and involved in design with the SME's.
• Involved in scheduling the monthly, weekly and daily reports with saved prompts using Job scheduler and implemented SDK to trigger the jobs and have experience implementing an SDK solution coupled with JSP pages.
• Provided the security access management by creating users/groups and folders and involved in Cognos server, power play and OLAP administration.
• Designed and developeddynamic dashboards in Cognos 10.1 business Insight to evaluate the Company’s performance and had knowledge in Adobe Creative Suite.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Implemented Data Source level, Object level, Data level, Package level, Folder level security on Cognos by creating new security Groups and Roles.

Environment: Cognos 10.x, Report Studio, Query Studio, Framework manager, SQL Server Management Studio 2008 R2 database, XML, Excel and Windows 2008, 2012, SDK.

Confidential - NY

Sr. Cognos Developer

Responsibilities:

• Performed basic administrative tasks, such as scheduling and delivering reports in different formats (for example, HTML, PDF, and Excel).
• Scheduled reports to run on a monthly, weekly and daily basis using Cognos Connection and have experience in creating audit reports.
• Used Event Studio to create agents that monitored status changes and priority customers that was important for the Business users.
• Launch IBM Cognos Mobile and integrate the Cognos application with iPad and installed and configured Cognos environment using Linux and had some Linux scripting experience.
• Involved in deploying and supporting Dynamic Cubes and had experience in advanced routing rules and had experience in improving performance of dynamic cubes in multi-server environment.
• Developed and Published Packages using Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and created filters, prompts, calculations, summaries and functions in Framework Manager.
• Created prompts in report to restrict data fetch and ease data load.
• Created calculations, filters, parameter maps and session parameters used by report authors and Created, Published and Managed packages
• Implemented reports with Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, Master-Detail.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection. Involved in Performance Tuning the reports in Report Studio.
• Deployed Reports, Packages and Folders from DEV to UAT and from UAT to Prod environment.
• Designed and Developed Advanced Prompt Pages using various varieties of Prompts and validating the Prompts using Java Script.
• Generated SQL/MDX and analyzed Native SQL to trouble shoot the report issues.
• Involved in Cognos virtual view Manager setup and Integrate Cognos insight with Cognos 10
• Solid designing and development experience in developing various kind of reports like Cascading parameters, pick lists, Drill down, Drill through, Sub Reports and Charts.
• Developed Windows Batch scripts for reports and cubes scheduling

Environment: Cognos 10.x (Transformer, Workspace, Workspace Advanced, Report Studio, Analysis Studio, Cognos Connection, Framework manager), Oracle 10g, vertica, Windows 2003/7, Microsoft Excel.

Confidential, Walnut- CA

Cognos Developer

Responsibilities:

• Modeled and Reported against an Operational Data Source (OLTP).
• Created complex Dashboards with Area charts, Pie charts, Cross tabs and Multi prompts in Report Studio.
• Extensive interaction with Business Users and gather information and requirements.
• Created standard and Ad-hoc reports using Cognos Query Studio (Simple List, Grouped List, Crosstab, and nested Crosstab) reports and represented data graphically by charts utilizing Query Studio.
• Ensured that all assigned task was customer focused, results oriented, performance driven, and in compliance with all applicable internal and external requirements.
• Worked closely with the deployment team to ensure a smooth transition from development to production operation and support.
• Created customized BI reports linking various databases, to meet the user requirements.
• Experience in creating OLAP cubes using Transformer and Utilized TOAD to access and analyze data directly from databases.
• Implemented internal Cognos Security - Data Security using Security tables to secure sensitive data with Security Filter, Macros, Session Parameters and Parameter Maps.
• Developed Report Templates for Standard and Adhoc reporting to make the Reports look Consistent.
• Involved in all phases of the data warehouse project lifecycle, which includes assessment, business requirements gathering, data modeling and database design, ETL/BI architectures, Reporting Model and report Development, performance tuning, and data delivery mechanisms.
• Involved in the design and implementation of the balanced scorecard and online analytical processing (OLAP) solutions.
• Queried data from different databases as per the requirement.
• Created different filters and calculations in Framework Manager that can be effectively used while reporting.
• Created Hierarchies from providing drill down options for the end-user.
• Assisted users in trouble shooting their reports.

Environment: Cognos 8.3(Cognos Connection, Report Studio, Query Studio, Analysis Studio, Transformers, and Framework Manager), Oracle 9i, TOAD, windows server2003, Excel.

Confidential, San Leandro- CA

Cognos Developer

Responsibilities:

• Gathered reporting requirements from Business Users, Prepared functional and technical Requirements documentation.
• Created Query Subjects, Query Items which are not present in Data ware house.
• Involved in the Design, Development, Testing and Implementation of All phases of Project
• Created User Defined SQL Reports to improve performance and give more flexibility.
• Administered Cognos BI Server Environment
• Worked on 3 tier metadata modeling in Framework Manager and published multiple packages.
• Very good experience in Report building usingReport Studio and Analysis Studio and in Transformer model design and Power play cube building.
• Analyzing all reports and Standardize these reports using Power Prompts and Charts
• Built models containing query subjects, query items, and namespaces from scratch as well as from imported metadata.
• Provided the selection choice to the user with different kind of prompts like tree prompt, value prompt, date and time prompt and cascading prompts.
• Used different features like calculation, summary, grouping, header and footers to create an invoice report.
• Developed Multidimensional Models in Power-Play Transformer and generated Power Cubes for OLAP comprising of dimensions, hierarchies, levels, categories, and measures in Cognos 8.4.
• Modified Power Cubes by adding new Dimensions, Levels, Categories and Measures.
• Developed dynamic reports to sort on column headers by implementing Java scripts as HTML items and without JavaScript.
• Created detailed, summary and context filters and worked extensively with summary functions.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Extensively worked on SQL, created joins between huge tables to map the columns from multiple tables.
• Developed financial reports and business mix reports using query studio, Analysis studio and Report Studio.

Environment: Cognos 8.4.x, 10.0 (Transformer, Report Studio, Analysis Studio, Cognos Connection, Framework manager), Oracle 10g, Windows 2003/7, Microsoft Excel, SQL/PLSQL, MySQL.

Confidential, Newport Beach - CA

Cognos Developer

Responsibilities:

• Responsible for the Business Analysis and Requirements Collection.
• Involved in building Portal Pages and designing them according to user requirements and developed Performance Charts, Dashboards and Scorecards using Report Studio.
• Created Backups of the content store and Public folders.
• Established master-detail relationship between related query items in Report Studio
• Participated in Development life cycle, which includes, interacting with users to get the required specifications.
• Created different filters and calculations in Framework Manager that can use effectively used while reporting and Developed graphical reports extensively in report studio.
• Developed Framework Manager Models for different reporting projects within the organization to satisfy the needs of different departments and various project and published packages to the Cognos Connection.
• Created IQD’s as data sources in Power Play Transformer.
• Developed drill through definitions to create drill through between Analysis studio and report studio report.
• Designed Dynamic Cubes - in memory tool using Cube Designer tool and deployed in the Cognos environment to increase the performance.
• Implemented data level security using parameter maps, session parameters and macros.
• Worked extensively to achieve the Performance and Tuned SQL Queries and Stored Procedures, improved the performance of the reports.
• Proficiently customized the look and feel of the dashboard for improved visual presentation.
• Developed and Present POC on modeling, administration activities
• Used SQL Developer to access and analyze data directly from Oracle databases and testing reports data with Hand written SQL.
• Created complex reports with multiple queried using SQL, Master-Detail Relationships, Joins, Sub queried, Query references and Query Calculations.

Environment: Cognos 8.4(Cognos Report Studio, Query Studio, Cognos Framework Manager, Cognos Connection, Powerplay Transformer), Oracle 10g, SQL Developer, Excel.

Confidential

Cognos Developer

Responsibilities:

• Involved in data gathering and developing models in Framework Manager and publishing the packages onto Cognos Connection.
• Involved in creating complex reports involving stored procedures with parameters.
• Created Multiple Reports using Report Net and Power Play.
• Created Multi-Dimensional Cubes using Powerplay Transformer for multidimensional (IQD) reports.
• Used Report Net SDK to customize and automate various Report Net Tasks.
• Developed PL/SQL procedures, packages, triggers and other database objects
• Implemented Package level security and object level security in Framework manager.
• Created Simple List reports, Cross-tab reports, Conditional formatting and Drill - through Reports using Report Studio.

Environment: Cognos Report Net 1.01MR1/1.02MR2 (Framework Manager, Report Studio, Query Studio), Cognos Transformer 7.2/7.4, Cognos Power Play 7.4, Power Play Enterprise Server, Windows NT/2000, UNIX, Oracle 9i, 10g, SQL Server, SQL/PLSQL.