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, Datastage,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,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), &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.
• Experience in Creation of Models, Project and Publishing Packages using Framework Manager and created IQD’s in Framework Manager to use in Cognos Transformer using externalized method and also in Cognos Data Manager.
• 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.
• Deliver advanced/ complex reporting solutions such as KPI Dashboards and Standardized Reporting (including the bursting of reports globally) using Cognos Active reports.
• Expertise in OLTP/OLAP system study, analysis, E-R modeling and developing database schemas like Star schema and snowflake schema. Experience in Designing Transformer models and developing for corporate data for building Multidimensional Cubes (MOLAP/OLAP/ROLAP) and also in IBM cognos planning analyst V10.1.1
• Involved in migration and deployment of applications and also had experience in maintaining upgrades, patches, and hot fixes for Cognos
• 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 also have experience with Cognos Maps .
• Knowledge in Cognos planning Application (TM1) and Cognos SDK and also in Data Modelling techniques.
• Experienced in working with RAVE Visualizations in Cognos Workspace Advanced and Report Studio for building interactive reports for the end users.
• Strong design and programming technical skills, ability to learn new emerging technologies and adapt quickly and e xcellent analytical, co-ordination, interpersonal, leadership, organizational skills.

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

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, Chelsea, MA

Sr. Cognos 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 (stiched queries,cross joins and loops handling,determinants) and knowledge in Data Modelling techniques and data vault technology.
• Experience in implementing security based on user roles in Framework Manager in MUD environment and publishing reports and worked on Netezzaand also involved in environment set up and also in deliverables in UAT/ST environment
• Used static choice value prompts, cascading prompts, conditional variables (Boolean and string) to create reports and had experience in validtion using Java Scripts.
• Involved in creation of templates,building complex reports in report studio.
• Implemented Conditional formatting and Java Scripts for customizing the reports. Used Java Scripts for validating Date/Time controls and adding customized buttons to facilitate the Show/Hide requests.
• Providing training to the end users and involved in design with the SME's.
• Involved in upgrading/migration from cognos 10.2.1 to cognos 11.x and also in POC's.
• Implemented Drill Through and Prompts for better utilization of reports.
• 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 also involved in building dynamic cubes.
• Involved in writing SQL queries to improve performance of the report and also developed PL/SQL procedures, packages, triggers and other database objects.
• Experience in OLTP/OLAP system study, analysis, E-R modeling and developing database schemas like star schema in DB2.
• Involved in Intergrating cognos with pega using mashup services and Web Based Technologies such as ( Java, XML, and WSDL )and SDK and also involved in doing cognos reports using hyperian tool and also involved in IBM planning cognos analyst v10.1.1 and alsointegration with SSO and SSL.
• Experienced in Migration of other reports into Cognos and version up-gradation,patches, and hot fixes for Cognos and also involved in developing batch job for reports

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

Confidential, Philadelphia, PA

Sr. Cognos 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
• Worked on Cognos10 framework manager to import metadata from multiple data sources and to create subject oriented business models, publish packages to BI server and also involved in cognos server administration, OLAP administration.
• Used Cognos Connection as Web Portal for managing reports by using folders and security groups.
• Creation of Complex Report Studio Reports using Lists, Crosstabs, prompts, Multi-Query and also have experience in integrating with Cognos Maps
• Involved in Metadata modeling of both Relational and Dimensional data using Framework manager.
• Experience in implementing security based on groups and roles in LDAP and CJAP.
• Created columnar tables in DB2 for better performance of the query.
• Hands on experience in the data modelling tools like Erwin and also in Microstrategy.
• 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 also in SSRS/SSIS/SSAS worked on netezza.
• Involved in forming joins, Segregating Tables in Folders according to reporting needs of users and hands on experience in selenium tool and had experience in LCM.
• Involved in Branching and merging enables multiple users to work on the same model at the same time and also 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 also 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, Los Angeles, 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.
• Worked on Stored Procedures in SQL Server Management Studio 2008 R2.
• 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.
• Involved in scheduling the monthly, weekly and daily reports with saved prompts using Job scheduler and implemented SDK to trigger the jobs.
• Provided the security access management by creating users/groups and folders and also involved in cognos server, powerplay and OLAP administration.
• Designed and developed dynamic dashboards in Cognos 10.1 business Insight to evaluate the Company’s performance.
• 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, New York, 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.
• Using the Cognos Scheduler (Schedule Management tool), scheduled the long-running reports to provide static views to the business user.
• 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 and
• Worked on 3 tier metadata modeling in Framework Manager and published multiple packages.
• Very good experience in Report building using Report 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 PowerPlay 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 Power play Transformer for multidimensional (IQD) reports.
• Used Report Net SDK to customize and automate various ReportNet 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 PowerPlay 7.4, PowerPlay Enterprise Server, Windows NT/2000, UNIX, Oracle 9i, 10g, SQL Server, SQL/PLSQL.