Manager Cognos

Santhosh Gade

Sr. Cognos Consultant

Ph No: 908-***-****

Email Id: ***************@*****.***

Professional Summary:

IT Professional with more than 8 years of experience in Software Design, Development and Analysis, Testing, Data Warehouse and Business Intelligence tools.

Experience in Cognos Analytics (C11), Cognos 10,8 (Query Studio, Report Studio, Analysis Studio, Framework Manager, Cognos Connection, Business Insight, Business Insight Advanced) and Cognos Series 7.x (Cognos Report net 1.1, Cognos Impromptu, Cognos Power Play Transformer, Cognos Power Play, Cognos Scheduler, Cognos Access Manager, Upfront).

Experience with Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio. Developed Active Reports to meet the user requirement of high interactivity at offline reporting.

Experience in Installation, Configuration, Monitoring and Management of Cognos. Experience in Cognos Upgrade from version 8.4 to 10.2.

Experience in Cognos Upgrade from version 10.2 to Cognos Analytics (C11). Developed tabbed reporting/automatic highlighting of chart contents using active reports.

Experience in Report building (Crosstab, List, Dashboard reports) using Report Studio and Analysis Studio.

Experience developing complex reports using Drill-through reports, Prompts, Dashboards, Master-detail, Burst-reports, Dynamic filtering in Cognos.

Expertise in creating Dashboard reports using Java Script in Report studio. Experienced in building Scorecard reports and Dashboard reports using Metric Studio.

Experience with Transformer models and cubes that were used in Power play analysis and also these cubes were used in various Analysis Studio reports.

Trained users in using the Business Insight for dash boarding and the Business Insight Advanced for Ad-hoc reporting. Good Experience with MDX Functions in Report Studio using Multi-Dimensional Sources.

Extensive experience with Cognos security (LDAP, Active Directory, Access manager, object level security, data security).

Experience with Cognos Software Development Kit (SDK) to customize reports using JAVA. Sound Skills in developing SQL Navigator, SQL Scripts, PL/SQL Stored Procedures, Functions, Packages and Visual Source Safe. Attended training sessions on Cognos TM1. Supported Cognos BI integration with Cognos TM1.

Expertise in Oracle 9i, 10g, 11g and MS SQL Server 2005, 2008, 2014 and 2016. Involved in OLTP/OLAP system study, analysis and E-R modeling, developing database schemas including Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.

Extensive experience on production support and Troubleshoot/Test issues with existing reports and cubes. Ability to translate Business requirements into technical specifications and interact with end users to gather requirements for reporting.

Good understanding of business process in Financial, HCM and Healthcare areas. Good work ethics, detail oriented, fast learner, team oriented, flexible and adaptable to all kinds of stressful environments. Possess excellent communication and interpersonal skills.

Education:

Bachelors in Electronics and Communication Engineering – DRK Institute of Science and Technology, India.

Technical Skills:

Hardware

IBM PC Compatibles and NT servers

OS

Windows, UNIX, Linux

OLAP tools

Cognos Analytics (C11) Cognos 10, 8 (Report Studio, Frame work manger, Analysis Studio), Transformer 8.3, Impromptu Administrator, Powerplay Transformer, Powerplay, Report Net, Oracle

ETL Tools

Informatica 7.1,8.1,8.6, 9.5, Data stage 7.5

Databases

Oracle 7.x/8.x/9.x/10&11g, Sql Server 2005, 2008, 2014 and 2016, Sql* loader, Teradata

RDBMS

Stored Procedures, Database Triggers, and Packages.

Professional Experience:

VF Corporation, Greensboro, NC Aug 2018 - Present

Sr. Cognos Consultant

Responsibilities:

Involved in collecting and identifying the reporting requirements and design phase for creating the Reporting/Metadata layers.

Successfully completed the Development and Unit testing part of the SDLC process implemented across the company.

Implement statistical data analysis, designing, developing and testing reports in Cognos 11\10.x for the various disciplines within organization in accordance with standard team processes.

Created and worked with SQL based reporting queries and utilized them in IBM Cognos Analytics to create data modules.

Other activities include data preparation for data services layer, unit testing, and other project lifecycle activities support.

Develop Cognos Framework Manager Models and created Packages.

Develop Cognos Reports in Cognos Analytics based on the requirements.

Implement test plans for new data integration and responsible for application reporting projects.

Drive efficient and effective internal and customer interfacing reporting processes.

Take ownership, organizes appropriate party interaction and facilitates resolution of reporting

issues.

Communicate regularly with customers, regarding statuses and issues.

Perform analysis and design for business processes and/or projects for reporting needs.

Analyze business process changes and utilize technology to perform complex data analysis.

Tune the reports utilizing best practices in designs to improve the performance of reports and

database.

Migrate Cognos content from one version to another version of Cognos.

Ultimate Software Group, Weston, FL Sept 2017 – Jul 2018

Sr. Cognos Admin/ Developer

Responsibilities:

Involved in upgrading the Cognos Reporting Environments from 10.2.2 to Cognos Analytics (C11). This upgrade includes 90+ separate Cognos environments that include 750+ servers.

Upgrading the Reports Servers, Web Servers, Gateways, Content Store, Reports and Cubes.

Deployed the Cognos content from one environment to other environments.

Troubleshoot any and all issues related to the Administration of the Cognos reporting environment.

Provided level 3 support (last line of support) for the Cognos environment.

Responsible for the Cognos environment performance and tuning on all servers.

Installed and configured new Cognos Environments.

Enable-Disable Cognos capabilities based on specific client needs.

Responsible for creating database connections for different data sources.

Responsible for creating and managing Jobs and Schedules.

Responsible for applying Security and User Authentication to the various User Groups.

Responsible for deploying the Packages (exporting and importing the packages) using the Deployment functionality under Cognos Connection Portal and Documenting the process.

Experience in creating models using Framework Manager.

Supported Cognos BI integration with Cognos TM1.

Supported Cognos TM1 server integration to authenticate users using Cognos BI security.

Updating the Metadata Model when new metadata is imported.

Created agents using Event studio for business factors performance monitoring.

Test all servers for 24-7 availability to both internal and external clients.

24-7 on call for any Cognos Administration issues.

Worked on Quarterly upgrade projects for the Company’s core product.

Environment: Cognos Analytics, Cognos 10.2, Framework Manager, SQL Server, TOAD, PL/SQL, Informatica v9.5

Universal Service Administrative Company (USAC), Washington D.C Jan 2017 – Aug 2017

Sr. Cognos/Pentaho Consultant

Responsibilities:

Interacted with Users to obtain initial information related to the business requirements and required documentation for clear understanding of requirements.

Responsible for the Cognos and Pentaho environment performance and tuning.

Involved in migration from Cognos to Pentaho.

Deployed content from Development to Production and administer users/groups/roles.

Installed and configured new Pentaho environment.

Responsible for securing the content and user authentication to various groups.

Creating the Schedules and Jobs.

Responsible for troubleshooting any/all issues in BI environments.

Created List, Cross tab, Chart, Drill through, Master-detail and complex reports with Multiple Pages/Prompts in Report Studio.

Created Database layer and Business layer, defining appropriate relationship between query subjects in Framework Manager.

Created and published metadata models using Framework Manager.

Created and published metadata models using PDI tools.

Trained the end users to use the reporting tool to build Ad-hoc reports.

Attended training sessions on Cognos TM1.

Created User manual for Business Users to understand the reporting architecture.

Environment: Cognos 10.2, Report Studio, Query Studio, Sql Server, TOAD, Pentaho 6.1, Pentaho Metadata Editor, Pentaho Report Designer, Pentaho Schema Workbench, Pentaho Spoon.

Ultimate Software Group, Weston, FL Feb 2014 – Jan 2017

Sr. Cognos Consultant

Responsibilities:

Involved in upgrading the Cognos Reporting Environments from 8.4 to 10.2.1 and from 10.2.1 to 10.2.2. This upgrade includes 70+ separate Cognos environments that include 550+ servers.

Upgrading the Reports Servers, Web Servers, Gateways, Content Store, Reports and Cubes.

Deployed the Cognos content from one environment to other environments.

Troubleshoot any and all issues related to the Administration of the Cognos reporting environment.

Provided level 3 support (last line of support) for the Cognos environment.

Responsible for the Cognos environment performance and tuning on all servers.

Installed and configured new Cognos Environments.

Enable-Disable Cognos capabilities based on specific client needs.

Responsible for creating database connections for different data sources.

Responsible for creating and managing Jobs and Schedules.

Responsible for applying Security and User Authentication to the various User Groups.

Responsible for deploying the Packages (exporting and importing the packages) using the Deployment functionality under Cognos Connection Portal and Documenting the process.

Experience in creating models using Framework Manager & creating simple to complex reports in Report Studio.

Updating the Metadata Model when new metadata is imported.

Created agents using Event studio for business factors performance monitoring.

Used Analysis studio to create Ad-hoc reports using cubes.

Test all servers for 24-7 availability to both internal and external clients.

24-7 on call for any cognos Administration issues.

Integrated Cognos with INFOR Workbrain for Time and Attendance product.

Worked on Quarterly upgrade projects for the Company’s core product.

Environment: Cognos 10.2, Report Studio, Query Studio, Framework Manager, SQL Server, TOAD, PL/SQL, Informatica v9.0

Houston Independent School District, Houston, TX Aug 2013 - Jan 2014

Cognos Developer

Responsibilities:

Understood the source system and interacted with users to acquire the elaborate technical and business requirements and required documentation for clear understanding and traceability of requirements.

Experience in building models using Framework Manager. Created Database Layer and Business Layer, defining appropriate relationship between query subjects in Framework Manager.

Created Dashboard reports using the Cognos Report Studio which includes iframes and Dynamic Sorting.

Developed ad-hoc reports using Query Studio. Developed List, cross tab, drill through, master-detail, chart and complex reports which involved multiple prompts, multi-query, Cubes in Report Studio, Burst Reports against database.

Created custom prompted reports in Report Studio. Trained end users effectively to use reporting tool, to build and customize their ad-hoc reports.

Performance tuning of the reports implemented by creating summarized tables, views and appropriate indices.

Involved in creating the User Training manual to help the Business Users understand the reporting architecture.

Conducted training on Cognos technology to the Business users. Mentored the Project Team on latest trends in Reporting.

Environment: Cognos 10.2, Transformer, Report Studio, Query Studio, Oracle 11g, TOAD, SQL Navigator, Visual Source Code, PL/SQL, Informatica v9.0, IBM Netezza v5, Linux v5.4.3.

Celgene Pharmaceuticals, Nutley, NJ Oct 2012 - Jul 2013

Cognos Developer/Administrator

Responsibilities:

Gathered report requirements from Business Users and converted them in to technical documents.

Experience in building models using Framework Manager & creating simple to complex reports in Report Studio.

Created Database layer and Business layer, defining appropriate relationship between query subjects in Framework Manager.

Designed & Implemented List, Cross tab, Chart, Drill through, Master-detail and complex reports with Multiple Pages/Prompts in Report Studio.

Created multi-page reports based on multiple master queries to show the data on different pages when the master record changes in a report using Report Studio.

Performance tuning of the reports implemented by creating summarized tables, views and appropriate indices.

Developed Dash board reports to display all the information related to environment using Summary reports.

Created Master Detail reports, Drill through and Custom Prompting reports, and Scheduled reports for efficient resource utilization.

Implemented Cognos SDK code for extracting the report schedules defined by power users.

Trained the end users to effectively use the reporting tool to build their Ad-hoc reports.

Deploying models and reports from Development to Production and administering users/groups/roles.

Involved in creating the User Training manual to help the Business Users understand the reporting architecture.

Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support.

Environment: Cognos 8.3 (Framework Manager, Report Studio, Analysis Studio, Query Studio), Cognos Transformer v7.4, Cognos SDK, WAS, HTML, Java, Shell Script, Oracle 11g, HP-Unix.

Prelude Systems, Chennai, India Jul 2011 - Sep 2012

Software Programmer

Responsibilities:

Involved in designing of Conceptual Logical Model and Physical Model.

Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.

Developed Database Triggers to enforce Data integrity and additional Referential Integrity.

Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.

Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.

Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.

Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.

Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.

Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Environment: SQL Server 2000/7.0, Oracle 8i, Windows NT, C++, HTML, T-SQL.

Contact this candidate