Anish P. Email & Phone Number

Newark, Ohio, United States

 Involved in gathering Business requirements from business customers, analyzing and transforming them into business intelligence reporting specifications. Developed Technical Design and Functional Design Documents. Involved in discussions with business stakeholders to understand project goals and requirements in order to quickly deploy reports and analytics that enable better decision making. Strong understanding of Business Intelligence and Data Warehouse database concepts, Star schema and developed Report Studio queries that uses the relationships between fact tables in the Data Warehouse database. Integrated Remedy with Cognos reporting tool using cognos API. Used Motio CI to validate and Motio PI to make bulk changes to reports whe migrating from 10.2.2 to 11.1.7. Developed Cognos reports from stored procedures and reverse engeenered the SQL. Involved in creation of Relational and Multi-dimensional models using Cognos framework manager andcreated packages, published to the server for reporting needs. Work directly with business customers to build portals, reports, dashboards with the COGNOS BI suite(Framework Manager, Report Studio and Transformer). Experience in writing with HTML/Java Script in Cognos report studio reports as per the requirements. Extremely proficient in writing complex reports, building portals, dashboards, scorecards, FM models, OLAP cubes and integrating with SharePoint. Install and configure Content Server for 7.X on Unix/Linux/Solaris environment Experienced in implementing best practices on Cognos Dashboards, Scorecards, Portal, report design,development and testing. Design and develop Teradata presentation layer according to users' requirements Train end users on Teradata OLAP connector Created dashboards for a managerial/Directorial overview with drill up and drill down capabilities in 10.2.1

Schaumburg, Illinois

Hickory, North Carolina, United States

 Involved in gathering Business requirements from business customers, analyzing and transforming them into business intelligence reporting specifications. Developed Technical Design and Functional Design Documents. Involved in discussions with business stakeholders to understand project goals and requirements in order to quickly deploy reports and analytics that enable better decision making. Strong understanding of Business Intelligence and Data Warehouse database concepts, Star schema and developed Report Studio queries that uses the relationships between fact tables in the Data Warehouse database. Integrated Remedy with Cognos reporting tool using cognos API. Used Motio CI to validate and Motio PI to make bulk changes to reports whe migrating from 10.2.2 to 11.1.7. Developed Cognos reports from stored procedures and reverse engeenered the SQL. Involved in creation of Relational and Multi-dimensional models using Cognos framework manager andcreated packages, published to the server for reporting needs. Work directly with business customers to build portals, reports, dashboards with the COGNOS BI suite(Framework Manager, Report Studio and Transformer). Experience in writing with HTML/Java Script in Cognos report studio reports as per the requirements. Extremely proficient in writing complex reports, building portals, dashboards, scorecards, FM models, OLAP cubes and integrating with SharePoint. Install and configure Content Server for 7.X on Unix/Linux/Solaris environment Experienced in implementing best practices on Cognos Dashboards, Scorecards, Portal, report design,development and testing. Design and develop Teradata presentation layer according to users' requirements Train end users on Teradata OLAP connector Created dashboards for a managerial/Directorial overview with drill up and drill down capabilities in 10.2.1

Indian Land, South Carolina, United States

 Involved in gathering Business requirements from business customers, analyzing and transforming them into business intelligence reporting specifications. Developed Technical Design and Functional Design Documents. Involved in discussions with business stakeholders to understand project goals and requirements in order to quickly deploy reports and analytics that enable better decision making. Strong understanding of Business Intelligence and Data Warehouse database concepts, Star schema and developed Report Studio queries that uses the relationships between fact tables in the Data Warehouse database. Integrated Remedy with Cognos reporting tool using cognos API. Used Motio CI to validate and Motio PI to make bulk changes to reports whe migrating from 10.2.2 to 11.0.13. Developed Cognos reports from stored procedures and reverse engeenered the SQL. Involved in creation of Relational and Multi-dimensional models using Cognos framework manager andcreated packages, published to the server for reporting needs. Work directly with business customers to build portals, reports, dashboards with the COGNOS BI suite(Framework Manager, Report Studio and Transformer). Experience in writing with HTML/Java Script in Cognos report studio reports as per the requirements. Extremely proficient in writing complex reports, building portals, dashboards, scorecards, FM models, OLAP cubes and integrating with SharePoint. Install and configure Content Server for 7.X on Unix/Linux/Solaris environment Experienced in implementing best practices on Cognos Dashboards, Scorecards, Portal, report design,development and testing. Design and develop Teradata presentation layer according to users' requirements Train end users on Teradata OLAP connector Created dashboards for a managerial/Directorial overview with drill up and drill down capabilities in 10.2.1

Charlotte, North Carolina, United States

 Involved in gathering Business requirements from business customers, analyzing and transforming them into business intelligence reporting specifications. Developed Technical Design and Functional Design Documents. Involved in discussions with business stakeholders to understand project goals and requirements in order to quickly deploy reports and analytics that enable better decision making. Strong understanding of Business Intelligence and Data Warehouse database concepts, Star schema and developed Report Studio queries that uses the relationships between fact tables in the Data Warehouse database. Integrated Remedy with Cognos reporting tool using cognos API. Used Motio CI to validate and Motio PI to make bulk changes to reports whe migrating from 10.2.2 to 11.0.13. Developed Cognos reports from stored procedures and reverse engeenered the SQL. Involved in creation of Relational and Multi-dimensional models using Cognos framework manager andcreated packages, published to the server for reporting needs. Work directly with business customers to build portals, reports, dashboards with the COGNOS BI suite(Framework Manager, Report Studio and Transformer). Experience in writing with HTML/Java Script in Cognos report studio reports as per the requirements. Extremely proficient in writing complex reports, building portals, dashboards, scorecards, FM models, OLAP cubes and integrating with SharePoint. Install and configure Content Server for 7.X on Unix/Linux/Solaris environment Experienced in implementing best practices on Cognos Dashboards, Scorecards, Portal, report design,development and testing. Design and develop Teradata presentation layer according to users' requirements Train end users on Teradata OLAP connector Created dashboards for a managerial/Directorial overview with drill up and drill down capabilities in 10.2.1

Omaha, Nebraska, United States

 Interviewed business community to identify business, data, and delivery requirements. Designed models in Framework Manager. Updated & administered the security privileges at object level and data level for the user profiles in Framework Manager. Worked with Complex reports in Report Studio using master-detail relationship, drill through, burst options,cascading options and PROMPTS depending on user requirements. Created reports using cascaded prompts, value prompts, sections, dynamic filtering, conditional layouts and multi lingual reports in Report Studio Created reports containing multiple data containers like List, Cross-tab and Repeater tables. Created models in Transformer, built cubes and published cubes to Power Play server. Scheduled reports using Cognos scheduler and emailed to various recipients as required. Worked on TOAD for Oracle database systems for creation of adhoc queries and for improving variousperformance issues. Experience with oracle as the target for the data marts. Used Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects inFramework manager. Test/validate system tables/files in System Test environment, UAT environment and finally in Production environment. Trained End users to operate the reports. Optimized and modified the triggers, complex store functions, procedures, user base data type.

Fairfax County, Virginia, United States

Gathered functional requirements from business customers, analyzing and transforming them into business intelligence reporting specifications. Developed Technical Design Documents. Created and published packages for different functional areas and assigned security rules to them inFramework Manager. Created list, crosstab and drill through reports for departments like claims, billing, members/subscribers in Report Studio Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports. Created Burst Reports and Multilingual Reports based on groups of users &Preferences for our Asian, African and European partners. Created Drill Through Reports & Master Detail Reports for Accounts Department. Created dashboards, portlets for various HR and payroll related reports.. Developed various HR .Created complex reports that had multiple pages, multiple UI items like lists, charts, graphs, etc. Created complex reports in Cognos mainly dealing with Member Data, Claims data and Provider Data. Created score cards using Metric Studio. Wrote Procedures and triggers in Oracle for file handling, data validation, Inserting data etc. Wrote and executed the test cases for various reports that were developed in Cognos. Involved with making changes in the reports generated as business requirements changed and carry out validation and verification of the reports. Worked on the database performance by creating the indexes and partitions. Created models in Transformer, built OLAP cubes and published cubes to Analysis Studio Involved with the Solutions Architect and the QA team for validation and verification of the development. Exceptionally good and experienced in handling the problem and troubleshooting.

Reno, Nevada, United States

Interviewed business community to identify business, data, and delivery requirements. Designed models in Framework Manager. Updated & administered the security privileges at object level and data level for the user profiles in Framework Manager. Worked with Complex reports in Report Studio using master-detail relationship, drill through, burst options, cascading options and PROMPTS depending on user requirements. Created reports using cascaded prompts, value prompts, sections, dynamic filtering, conditional layouts and multi lingual reports in Report Studio Created reports containing multiple data containers like List, Cross-tab and Repeater tables. Created models in Transformer, built cubes and published cubes to Power Play server. Scheduled reports using Cognos scheduler and emailed to various recipients as required. Worked on TOAD for Oracle database systems for creation of adhoc queries and for improving variousperformance issues. Experience with oracle as the target for the data marts. Used Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects inFramework manager. Test/validate system tables/files in System Test environment, UAT environment and finally in Production environment. Trained End users to operate the reports. Optimized and modified the triggers, complex store functions, procedures, user base data type.

Master'S Degree, Computer And Information Sciences And Support Services

Bachelor'S Degree, Electronics And Communications Engineering Technology/Technician