SUMMARY

• Experienced with Metadata modeling using Framework Manager, creating Projects, Models, Packages, Security and Parameter mapping techniques, Query Studio for Ad - hoc reporting and Report Studio for advanced report authoring.
• Hands on experience in Report building (Crosstab, List, Dashboard reports) using Report Studio and Analysis Studio.
• Extensively worked in developing complex reports using drill-through reports, prompts, dashboards, master-detail, burst-reports, dynamic filtering in Cognos, Created Prompts, Cascading Prompts, designed the Multiple Report Pages, Prompts pages.
• Strong experience in client interaction and understanding business application, business data flow and data relations from them.
• Knowledge in Planning, Designing, developing and deploying Data warehouses / Data Marts with experience of both relational & multidimensional database design using Data Modeling tool Erwin (Physical and Logical data models).
• Experience with Transformer models and cubes that were used in Power play analysis and also these cubes were used in various Analysis Studio reports.
• Good Experience with MDX Functions in Report Studio using Multi-dimensional Sources.
• Experience in OLTP/OLAP System Study, Analysis and ER Modeling, developing database schemas including Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8.X Environment, Cognos 8.4 reports to Cognos 10.2 ad currently from 10.2.2 to cognos 11.1.3
• Worked with moderate to difficult complex SQL queries, Functions, Packages, Stored procedures, triggers according to the specifications.
• Good exposure in Cognos Analytics and training business users with interface in Cognos analytics
• Good understanding of Data Warehousing and ETL tools like Informatica & Data Stage.
• Extensive experience on production support and troubleshoot/test issues with existing reports and cubes.

TECHNICAL SKILLS

• Cognos Analytics 11.0.6 to 11.1.3,Cognos 10.2.1,10.2,10.1.1, Cognos 8.4, 8.3, 8 BI, Report Net 1.1 (Framework Manager, Report Studio, Query Studio, Cognos Connection), Cognos Series 7.3/7.1 (Impromptu 7.3, Power Play Transformer, Power Play Enterprise Server, Access Manager, Cognos Query, Data Manager Visualizer, Impromptu Web Reports(IWR), Oracle12c/11g,10g/ 9i/8i, 7.0, MS SQL Server 2008/2005/2000 , Teradata, DB2 and MS-ACCESS, Windows NT 4.0/2000/XP Professional, Windows 7, C, C++, SQL, PL/SQL, HTML, Java Script, Informatica, Data Manager in Cognos, Data Stage, IIS, Apache, Tomcat, Star Schema Modeling, Snow Flake Modeling, FACT & Dimensions, scripting languages batch,awk,shell, MS Excel, MS Word, MS Visio, MS PowerPoint, Mass forge, JIRA, Toad, Erwin, Tableau

PROFESSIONAL EXPERIENCE

Senior Data Warehouse Cognos Developer

Confidential, Boston, MA

Responsibilities:

• Worked with Business users to gather Business strategy and created a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications.
• Developed Business Requirement Documents based on Client’s Requirements.
• Developed and managed relational models using Framework Manager.
• Defined the keys, Joins, cardinalities and global filters in Framework Manager.
• Used package level security and folder level security.
• Developed Burst reports, Drill through, Master Detail, List, Chart, cross tab and complex reports (which involves Joins, Unions, Prompts, Report Library, Table of Content, Report Layout, template, Dashboards etc.) in Report Studio based on the business requirements involved Multiple Prompts in Report Studio
• Developed Query Studio Packages for Ad-Hoc reporting.
• Used HTML, Java scripts in prompt pages
• Worked on enhancements to existing Cognos reports in Report Studio & models in Framework Manger
• Mainly Involved in Upgradation project from Cognos 10.2.2. to Cognos 11.1.3 - Currently Migrating.
• Migration from Cognos 8 to Cognos 10.2.2 In 2015
• Performed detailed Cognos Analytics 11 Support tasks by creating application feeds and scripts to activate data loading and scheduling procedures within the environment.
• Written MDX to develop dashboards and Framework models (GMIS package) and developed IBM Cognos 11 Reports Using MDX functions from that package.
• Created various Dashboards in Cognos analytics and presented at one of the cognos conference in MA to explain how evolved with each cognos version released in cognos analytics
• Trained around 500 cognos users on the new analytics since the interface has changed completely from 10.2.2 to 11
• Created query studio reports using Custom Grouping option.
• Applied conditional formatting for hiding the data, and highlighting the data
• Incorporated Layout Component Reference in the new reports.
• Created Cascading prompt and re promotable prompts to view report
• Performed administration task for user permissions (LDAP, ADFS) & scheduling the reports.
• Administered Security using Persona but used virtual gateway as the main authentication for users
• Used Static Choices to conditionally hide and display the objects
• Used Event Studio to trigger the jobs.
• Developed around 10 cubes packages using transformer and maintain around 60-80 cubes weekly/monthly and quarterly
• Use the advance functionality of Analysis Studio such as drill up and drill down, rank, slicers etc.
• Created Technical Specification documents for QA team to understand more about reports which was helpful for their testing.
• Interacted with QA team for Unit Testing, System Testing and Performance Testing.
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production.

Environment: Cognos 11.1.3,10.2.2(Cognos Connection, Framework Manager, Report Studio and Query Studio), Transformer, Powerplay, Oracle 11g/12C, IIS 6.0, Windows 2007 Server, AWS Cloud, TOAD, PLSQL Developer,Massforge,JIRA.

Senior Cognos Developer

Confidential, Manhattan, NYC

Responsibilities:

• Involved in analysis of functional and business requirements and design the technical specifications for development phase
• Involved in Design and Development of complex data model designs, Framework Manager models, implementing security at package level, data level by restricting users
• Developed complex Report studio reports using IBM Cognos 10.2/10.2.1 with multiple complex queries, joins, unions and different prompts, calculations and filters, macros, and designed SQL based reports
• Developed reports using Drill-through, complex calculations, Master-Detail Relationships, Adhoc querying using IBM Cognos 10.2.1 Query studio/Workspace Advanced
• Involved in Cognos and JAVA application integration, used XML as metadata source and designed REST service based reporting solution for complex business requirements
• Used HP ALM for testing and uploading test cases and as defect tracker tool to help customers for better solutions.
• Developed dashboard style reports using Cognos Workspace Advanced, used Active reports for showing various financial key performance indicators using different graphs
• Extensively involved in monthly release schedules for support and maintenance
• Supported full Life-cycle project activities from defining project roles and responsibilities, requirement gathering and specification to implementation, testing and support
• Dealt with performance issues if the report is taking a longer time to execute
• Extensively used Toad for database analysis performance tuning and trouble shooting.

Environment: Cognos 10.2,10.1/8.4.1, Framework Manager, Report Studio, Query Studio, Business Insight Advanced, workspace Advanced, power play transformer, Cognos Connection, Windows Vista/7.0, Oracle 11g, Toad, HP Application life cycle Management

Senior Cognos Developer

Confidential, Seattle, WA

Responsibilities:

• Analyze functional and business requirements.
• Developed & tested Power Cubes meeting business requirements and successfully deployed them into production.
• Assisted System Administrators in Cognos Migration and installed software updates.
• Used Report Studio to design Simple and Complex standard reports with multiple cascading prompts.
• Designing the Data Model using Cognos Frame Work Manager.
• Creating relationships among the tables in FM and Set various securities like package level, Data level and Object level in cubes
• Scheduled Reports to run on a monthly, weekly and daily basis using Cognos Scheduler.
• Involved in writing test scripts, test strategy documents.
• Resolved ambiguous relationships by Ensuring clear query paths.
• Creation of procedures, views, tables and functions according to business requirements in Oracle.
• Developed reports using Layout component reference.
• Testing the data in the reports comparing with the source data in the database.

Environment: Cognos 10.2,10.1/8.4.1, Framework Manager, Report Studio, Query Studio, Business Insight Advanced, power play transformer, Cognos Connection, Windows Vista/7.0, Oracle 10g and SQL Server Management 2008, Epic hyperspace.

Senior Cognos Developer

Confidential, Brea, CA

Responsibilities:

• Coordinate with various business stakeholders like the Business unit teams, operational risk management, compliance, IT Risk Management, SOX/MAR compliance to determine the reporting and system requirements.
• Created complex reports involving complex list reports, dashboards that involved complex drill through report, conditional formatting, master-detail relationships and those involved complex joins between the lists and multiple prompts on board using cognos 8.4 on open pages GRC application.
• Involved in defining Relationships and Cardinality between query subjects, Built models containing query subjects, query items, and namespaces from scratch as well as from imported Metadata in Frame work manager.
• Experienced managing DEV, TEST & PROD environments and supported both business users and IT users within the organization.
• Every week attend status meeting.
• Deployed Reports & Packages from Development to QA and QA to Production using Deployment.
• Tested all the reports with Generated SQL and Manual SQL data.
• Assisted Quality Assurance Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas.
• Develop \implement changes to the IBM Open Pages GRC application. Assist with the general Support and maintenance of the application, and help users resolve application and reporting issues.
• Coordinate with the vendor (IBM) to design and trouble shoot custom application components and utilities.
• Worked closely with business and end users to achieve business goals and reporting done within the scheduled time frame.

Environment: Cognos 10.2,10.1.1,10.1/8.4.1 Open Pages GRC application, Framework Manager, Report Studio, workspace, Query Studio, Business Insight Advanced, business objects, power play transformer, Cognos Connection, Windows Vista/7.0, Unix Oracle 11g, TOAD and SQL Server 2005,Unix.

Senior Cognos Developer

Confidential, Monroe, LA

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 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.
• Created folders, filters, and complex business calculations in Framework Manager.
• Created User groups, roles to implement the Cognos Security using LDAP.
• Created complex reports using Report Studio including conditional blocks and conditional formatting.
• Created multiple complex List, Crosstab and Chart Reports and generated outputs in Excel, PDF and HTML.
• Developed various reports with calculations, Conditions & Filters, Query Prompts, Prompt Pages, Variables using Cognos Report studio.
• Developed Prompt pages, used Conditional Variables for Conditional Formatting in Report Studio.
• Created Ad-hoc reports using Query Studio.
• Created reports using Filters, multiple Prompts (Select & Search prompt, value prompt, tree prompt) and provided option for Bursting of reports.
• Worked on Enhancement of the existing Reports.
• Worked on Data manager that provides ETL capabilities for the high performance analysis of relational data by creating aggregate tables at multiple levels within and across hierarchies in the dimension table and useful mostly for multiple developers to share information.
• Designed the Dashboard Templates and Created Various Dashboard reports for the Business Users.
• Design the Model for Different Business Areas and analyzing the indexes and Keys and creating star schema.
• Participating in the User meetings to analyze and prepare the reporting and analysis requirements of users.
• Designing, Constructing, Testing and Deploying the Cognos Framework Manager Models, Packages, Reports and Created Reusable templates for developing reports.
• Migrated all Packages & Reports from Cognos8.4 to Cognos10.2
• Prepared test cases to test the Cognos10.2,10.1 reports
• Created IQD’s in framework manager to use them in Transformer.
• Used Cognos Connection as Web Portal for managing reports.
• Created Detailed Design document and Impact Analysis document.
• Coordinating with the ETL team in defining the ETL logic for Reporting table loads and in setting up the timely schema refreshes for the Reporting Schemas

Environment: Cognos 10.2,10.1.1,10.1/8.4.1 Framework Manager, Report Studio, Workspace, Query Studio, Business Insight Advanced, power play transformer, Cognos Connection, Windows Vista/7.0, Unix Oracle 10g and SQL Server 2005,Unix.

Senior Cognos Developer

Confidential, Nutley, NJ

Responsibilities:

• Worked closely with client resources and business analysts to analyze and understand business requirements
• Customized data by adding Filters Calculations, Prompts, Summaries and Functions.
• Generated various reports List Reports, Grouped Reports, Cross-tab Reports, Chart Reports, and Drill -Through Reports.
• Added prompts and filters to modify existing reports to accommodate change in user requirements.
• Used Analysis Studio to create Analysis from Power Play Cubes
• Created complex multipage reports using multiple list reports and multiple queries to associate each of the list report
• Created simple to complex reports as well as Dashboard like reports using Report Studio by applying various concepts and functionalities such as drill-through, conditional reporting, block, tables, master-detail, charts, various calculations and joins using tabular sets and tabular models
• Created dashboards (crosstabs and charts) to display the business details from different aspects and using different representations
• Created Prompts with static choices and conditional variables for rendering the multipage reports
• Used Filters for efficient retrieval of data and conditional variables for hiding summary totals for report
• Created professional reports in Report Studio and ad hoc reports in Query Studio
• Implemented Data Level Security, Object Level Security and Package Level Security
• Modified existing Cubes to comply with changes in the Requirements
• Performed scheduling and maintenance of reports using Cognos Connection and Microsoft SharePoint based support portals
• Involved in Installation of Cognos8.4 Frame Work Manager, Report Studio, Query Studio, Cognos Connection
• Performed Unit testing for all developed reports
• Involved in deployment process of all the reports and packages from Development to production server.

Environment: Cognos 8.4, Report Studio, Query Studio, Framework Manager, Cognos connection, TOAD, Oracle SQL developer, Oracle 8i, SQL, PL/SQL, Windows 7.

Cognos Developer

Confidential, Greenville, WI

Responsibilities:

• Generated reports and handled modeling as per user requirement.
• Developed test cases for report optimization after interacting with the end users.
• Created multiple projects and published DMR packages.
• Building relational and dimensional models in Framework Manager, based on work flow and end user analysis requirement. Developed Framework Manager Models by importing metadata from different relational databases such as SQL Server, Oracle.
• Created filters, prompts, calculations and determinants for efficient data retrieval and analysis.
• Created parameter maps, stored procedures for importing as data source, checked for corrupted models and restored to original.
• Worked extensively at editing native and pass through SQL generated to resolve incorrect generation of stitched queries.
• Proficient in Report building using Report Studio, and Analysis Studio.
• Created List, Crosstab and Drill-Through reports using Report Studio.
• Created Ad-Hoc reports using Query Studio.
• Deployed the reports from development environment to test environment.
• Active team player in the Project.
• Tested models and reports, from time to time to remove any inconsistencies. Responsible for Unit testing and System testing of the reports based on the specification.
• Reporting testing - creating test cases, scripts and executing them. Tested the fixed reports in Cognos 8 environment as well as the Performance of the reports in Cognos 8 environment

Environment: Cognos 8.3 BI Series, Power Play, Transformer, Framework Manager, Oracle, SQL Server, PL/SQL, Windows 2000, Microsoft Excel, Microsoft Word.

Cognos Developer

Confidential, Seattle, WA

Responsibilities:

• Gathering and analyzing the end user business requirements for new models
• Developed and Published Packages by implementing DMR Modeling in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Developed Stored Procedures and created Stored Procedure Query Subjects in Framework manager to enhance Report Performance.
• Worked on relationships cardinality between query subjects to better represent the logical structure of the business and the user requirements
• Assist in the development of programming tools, macros and techniques to improve efficiencies in reporting Developed Standard Reports, Dash boards, YTD reports, Tabbed reports Charts, Drill through Reports, Master Detail Reports, Bursting Reports and Multilingual Reports Using Report Studio and Query Studio.
• Designed the standard template for creating reports in report studio
• Responsible for the delivery of solution-oriented complex reports using report studio.
• Define global drill through definitions and established drill-through from analysis studio to report studio
• Created drill through to several reports for providing better functionality.
• Dealing with the performance issues if the report takes much time to execute.
• Involved in making project plan, forming the analysis and migration team.

Environment: Cognos 8.3/8.4 Framework Manager, Report Studio, Query Studio, Analysis Studio, Report Net 1.1, Cognos Connection, TOAD, Windows 2003/XP, Cognos PowerPlay Transformer, Oracle 10g, Excel 2003, Unix.