SUMMARY:

• Over 10 years of IT experience with expertise in Analysis, Design, Development, Customization and Implementation of various Software applications and generation of reports using Various Databases.
• 10 years of experience in OLTP/OLAP/Data Warehouse reporting using Cognos.
• Experienced in Cognos 11/10/8 with Framework Manager, Cognos Connection, Analysis studio, Event Studio, Report Studio and Query Studio, Cognos Workspace, Transformers, Cube Designer.
• Created and managed reports in Zero - footprint environment.
• Strong knowledge of designing multidimensional architecture for Extract, Transform, Load environment with Informatica,IBM Datastage, IBM Cognos Data Manager/Decision Stream.
• Experienced in TM1, DQM and Dynamic Cubes.
• Solid understanding of data warehousing, OLTP and OLAP concepts.
• Experienced in Data Modeling for DW using Erwin.
• Experienced in setting up data replication using materialized views.
• Expert in Business process modeling, Data analysis and Business Requirement gathering.
• Experienced in developing applications using Vertica, Oracle 12c/11.x/10.x/9.x, SQL Server, and Netezza.
• Excellent Communication, Interpersonal and Organizational skills.
• Good team player.
• Keen on learning new technologies.
• Excellent trouble shooting skills.
• Experienced in onsite offshore model.

SKILLSET:

Cognos 11/10.x/8.x (Framework Manager, Cube designer,PowerPlay transformer, Cognos Connection, Analysis studio, Event Studio, Report Studio and Query Studio),Cognos Sdk,Cognos TM1, Motio ADF, Cognos Data Manager, Tableau 9.x,Informatica,DataStage, Business Objects, Micro strategy, Actuate, SAP BW,Microsoft Reporting and Analysis services, Erwin, Eclipse/Netbeans IDE,Java 1.6.2, Microsoft Visio for Enterprise Architects, HTML, XML, SQL, PL/SQL, T-SQL and C, Windows 2010 server/XP, UNIX, Unix shell scripting, Vertica, SQL Workbench, Oracle 9.x/10g/11g/12c, Toad, SQL Server 2000/2005/2008 , Tortoise SVN, IBM Rational ClearCase, MS Access/Excel, DB2,SAP R3, ATG 9,IBM Sterling Commerce,IBM Curam, Cayenta.

PROFESSIONAL EXPERIENCE:

Confidential, Longview, WA

IBM Cognos BI/Datastage Consultant

Responsibilities:

• Interacted with business users for reporting needs/requirements and documented business requirements into functional and technical specifications.
• Designed Server/Parallel jobs in Datastage Designer to replace materialized views and in this process answered new requirements alongside.
• Used DataStage Director to monitor and schedule the jobs.
• Created Paystub in Cognos for all the employees and distributed it via bursting.
• Enhanced the Customer utility monthly bill by adding EBill functionality to the regular bill.
• Created highly sophisticated reports using List, Cross tabs, Prompts, Cascading Prompts, Drill through, Charts, Master Detail, Bursting and Maps.
• Performed unit and integration testing.
• Coordinated with the server team for upgrading to IBM Cognos Analytics.
• Installed and configured Cognos 11.
• Demonstrated the new functionality (Data Module, Story) available in Cognos 11 to the users.
• Maintained different Cognos environments by performing exports and imports.

Environment: Cognos 11.0.6/10.2.1 , Framework Manager, Cognos Connection, Analysis studio, Event Studio, Report Studio, Query Studio, Cognos Workspace,Transformers,CubeDesigner,TM1 9.5.2,DataStage 11.5,Oracle 12c,Cayenta 7.7.

Confidential, Albany, NY

IBM Cognos BI & Tableau Consultant

Responsibilities:

• Helped infrastructure team in setting up Cognos.
• Educated the users with the functionalities of different studios and how the tool works.
• Interacted with business users for reporting needs/requirements and helped in documenting them.
• Extensively used Microsoft Excel for analyzing the data.
• Modeled Clinical, DSRIP, Implementation Plan and Health Home program based reporting requirements in Framework using Vertica database (MAPP DW) as the backend.
• Converted Excel Pivots into Cognos reports.
• Created a drill through executive dashboard.
• Created organized and formatted reports, folders and other contents on Cognos Connection Portal
• Created Prompted reports using Report Studio.
• Created highly sophisticated reports using List, Cross tabs, Prompts, Cascading Prompts, Drill through, Charts, Master Detail, Bursting and Maps.
• Created Dynamic cube for Clinical Subject area with more the 25 million records in the fact table.
• Used the dynamic cube package to create sophisticated reports using dimensional functions.
• Created DSRIP Transformer cubes to demonstrate the functionality of the tool.
• Created Active reports and Cognos Workspace examples for demonstrating the new features in 10.2.2
• Extensively worked with Relational, DMR and Cube based dimensional Packages.
• Converted Oracle Sql to Vertica while switching the DSRIP database platform.
• Recommended creation of projections in Vertica tables for faster response.
• Recommended consolidation of Providers in one Dimension that can be used across multiple subject areas within Confidential .
• Performed unit and integration testing.
• Helped in integrating Cognos through MAPP portal.
• Created Tableau worksheets and dashboards using Clinical data as a POC to assess the performance impact between Cognos and Tableau for large dataset and to evaluate which tool offers better Map features.

Environment: Cognos 10.2.2, Framework Manager, Cognos Connection, Analysis studio, Event Studio, Report Studio, Query Studio,Cognos Workspace,Transformers,CubeDesigner, Tableau 9.2,, IBM Curam, Oracle 12c,Vertica 7.1.1-4, IBM Rational ClearCase.

Confidential, Longview, WA

DW & IBM Cognos BI/TM1 Consultant

Responsibilities:

• Interacted with business users for reporting needs/requirements and documented business requirements into functional and technical specifications.
• Consolidated around 200 report requirements from Accounting Department to lay the foundation of an Accounting data mart.
• Worked with the dba’s to set up data replication using materialized view so that the reporting database do not hit the operational database.
• Used materialized view as a foundation for designing the fact tables.
• Created aggregate table/mv based on the requirement for good performance.
• Wrote the Framework model for efficient reporting and empowering the end users.
• Created individual subject areas for GL, AP, AR, WO, FA and Payroll.
• Worked on integrating the TM1 budget module in BIDW.
• Trained the users in creating their own queries in Query studio and thus empowering them to come out of ODBC based excel analysis.
• Created a Payroll Earning & Deduction Transformer Cube to drive the Labor Dashboard and to demonstrate the usefulness of a transformer cube.
• Extensively used Microsoft Excel for analyzing the data.
• Extensively worked with Relational, DMR and Cube based dimensional Packages.
• Created a drill through executive dashboard for monitoring the labor count at PUD.
• Created organized and formatted reports, folders and other contents on Cognos Connection Portal
• Created Prompted reports using Report Studio.
• Created highly sophisticated reports using List, Cross tabs, Prompts, Cascading Prompts, Drill through, Charts, Master Detail, Bursting and Maps.
• Created sophisticated reports using dimensional functions.
• Created Active reports and Cognos Workspace examples for demonstrating the new features in 10.2.1
• Performed unit and integration testing.
• Performed a single server installation and upgraded the environment to 10.2.1.
• Maintained different Cognos environments by performing exports and imports for moving the reports and framework models from one environment.
• Helped in developing proof of concept for DQM and Dynamic Cubes.
• Assisted Cayenta with TM1 Architect in setting up dimensions, cubes, cube views, rules and TI Processes.
• Worked on TM1 Web and TM1 perspective for MS Excel to help users in entering budget numbers.
• Hands on TM1 Macros and Feeders.

Environment: Cognos 10.2.1, Framework Manager, Cognos Connection, Analysis studio, Event Studio, Report Studio, Query Studio,Cognos Workspace,Transformers,CubeDesigner,TM1 9.5.2, Oracle 11g,Cayenta 7.5, Windows 2008.

Confidential, Beaverton-OR

Cognos 10 Consultant

Responsibilities:

• Interacted with business Users for reporting requirements and documented business requirements into functional and technical specifications.
• Involved in strategic planning for elevating the Framework model for efficient report development
• Involved in decision making for using a view or aggregate table based on the business requirement for good performance.
• Created the Framework model which involved columnar modeling approach to ease report development and TY vs. LY analysis for adhoc users.
• Interacted with web analytic team for consuming omniture visits data into the DW.
• Extensively used Microsoft Excel for analyzing the data.
• Initiated the project with rewriting a dashboard for daily orders.
• Created organized and formatted reports, folders and other contents on Cognos Connection Portal
• Created Prompted reports using Report Studio.
• Created List Reports, Cross tabs, Drill through, Cascading Prompts, Charts, and Maps.
• Created Master Detail and Burst reports
• Involved in unit and integration testing the reports in the QA environment.
• Extensively worked with Relational and DMR Packages.
• Created reports with Html tags to enhance the functionality using Java scripts.
• Involved in performance tuning of the reports.
• Maintained different Cognos environments by coordinating the exports and imports for moving the reports and framework models from one environment to other with the Platform config team at Confidential .
• Helped in developing proof of concept for DQM and Dynamic Cubes.

Environment: Cognos 10.1,10.2, Framework Manager, Cognos Connection, Analysis studio, Event Studio, Report Studio and Query Studio, Oracle 11g,Tortoise SVN, ATG 9,IBM Sterling Commerce, Windows 2010.

Confidential, Plano, TX

Cognos 10/ADF Consultant

Responsibilities:

• Interacted with Business Users for Reporting Requirements.
• Involved in planning for using the model driven architecture to elevate the reporting platform.
• Created Xml files for generating the query subjects using Motio ADF.
• Reviewed the Framework models created by the ADF process.
• Unit/Integration tested the query subject resulted from the ADF process.
• Participated in code reviews to enhance the xml code used for generating the query subjects.
• Created Framework Relational and dimensional models which involved importing dimension and fact tables, views and store procedures for a separate project.
• Created Powerplay Cube for NM-Product Robustness department at Confidential for the users to analyze the data/traffic on higher level based on protocols like Iucs, Iups, GB, GnGi, Lte and VoIP.
• Created the dimension and Fact data sources and layed the dimensions and measures in Powerplay Transformer based on the requirements.
• Created the reports as per the business requirements.
• Involved in unit and integration testing the reports in the QA environment.
• Extensively worked with Relational, DMR and Cube based dimensional Packages.
• Created organized and formatted reports, folders and other contents on Cognos Connection Portal
• Created List Reports, Cross tabs, Drill through, Cascading Prompts, Charts, and Maps.
• Created Master Detail and Burst reports
• Created reports with Html tags to enhance the functionality using Java scripts.
• Maintained different Cognos environments by creating exports and imports for moving the reports and framework models from one environment to other along with performance tuning the environment for fast and efficient usage.

Environment: Cognos 10/8.4.1, Framework Manager 10/8.4.1, Cognos Connection, Analysis studio, Event Studio, Report Studio and Query Studio, Cognos 10/8 transformer, Cognos Sdk,Motio ADF,Oracle 10g,DB2,Eclipse/Netbeans IDE,Java 1.6.2, Tortoise SVN, Windows 2010.

Confidential, Saint Louis, MO

Cognos 8 Consultant

Responsibilities:

• Interacted with Business Users for Reporting Requirements.
• Involved in strategic planning for laying the structure.
• Initiated the project with designing a Powerplay Cube in order to resolve the performance issues on an already existing relationally developed report.
• Created the dimension and Fact data sources and layed the dimensions and measures in Powerplay Transformer based on the report requirements.
• Created Framework Relational and dimensional models which involved importing dimension and fact tables, views and store procedures.
• Created the reports as per the business requirements.
• Involved in unit testing the reports in the QA environment and rectifying the bugs reported.
• Extensively worked with Dimensional Packages.
• Created organized and formatted reports, folders and other contents on Cognos Connection Portal
• Created Prompted reports using Report Studio.
• Created List Reports, Cross tabs, Drill through, Cascading Prompts, Charts, and Maps.
• Created Master Detail and Burst reports
• Created reports with dimensional functions in report studio.
• Created reports with Html tags to enhance the functionality using Java scripts.
• Involved in Performance tuning the Cognos Environment.
• Created imports and exports for moving the reports and framework models from one environment to other.
• Helped in developing a proof of concept using TM1.

Environment: Cognos 8.4.1, Framework Manager 8.4.1, Cognos Connection, Analysis studio, Event Studio, Report Studio and Query Studio, Cognos 8 transformer, Cognos TM1,Oracle 10g, Sql Server 2005,2008,Toad 9.7,Actuate 10.

Confidential, Philadelphia, PA

Sr. Cognos 8 Consultant

Responsibilities:

• Interacted with Business Users for Reporting Requirements.
• Converted Microsoft SSRS reports to Cognos.
• Involved in strategic planning for laying the database structure in order to bring written premium, accruals, ceded and budget premium information without compromising the performance.
• Provided the list of dimension and Fact tables based on the report requirements.
• Segregated the reports into two separate groups so that it can be sourced from separate aggregate fact tables in order to get the desired performance.
• Created Framework Relational projects which involved importing dimension and fact tables, views and store procedures.
• Implemented security for Data access, Object level access and Package access.
• Created the reports as per the business requirements.
• Involved in testing the reports in the QA environment and rectifying the bugs reported in Bugzilla.
• Created a Daily testing dashboard for accounting team for daily testing activities.
• Implemented report level security on Cognos Connection.
• Extensively worked with Dimensional Packages.
• Created organized and formatted reports, folders and other contents on Cognos Connection Portal
• Created Prompted reports using Report Studio.
• Created List Reports, Cross tabs, Drill through, Cascading Prompts, Charts, and Maps.
• Created Master Detail and Burst reports
• Created Power play Cubes for Accounting and created reports with dimensional functions in report studio.
• Involved in Performance tuning the Cognos Environment.
• Created imports and exports for moving the reports and framework models from one environment to other.
• Upgraded the Cognos Environment from 8.4 to 8.4.1

Environment: Cognos 8.4,8.4.1, Framework Manager 8.4,8.4.1, Cognos Connection, Analysis studio, Event Studio, Report Studio and Query Studio, Cognos 8 transformer, Bugzilla, Windows 2003, Sql Server 2005,2008.

Confidential, Whitestone, NY

Cognos 8 Developer/Analyst/Admin & SQL Server Developer

Responsibilities:

• Interacted with Business Users for Reporting Requirements.
• Documented Business Requirements into functional and Technical Specifications.
• Extensively used Microsoft Excel for analyzing the data.
• Laid the database structure in the form of tables, views and store procedures to answer the business requirements.
• Created a Daily Dashboard for Finance team for Daily activities.
• Created Framework Relational projects which involved importing tables, views and store procedures.
• Created (DMR) Dimensional Framework models in Cognos8.
• Extensively worked with Dimensional Packages.
• Created organized and formatted reports, folders and other contents on Cognos Connection Portal
• Created Prompted reports using Report Studio.
• Created List Reports, Cross tabs, Drill through, Cascading Prompts, Charts, and Maps.
• Created Master Detail reports
• Created Power play Cubes for Sales and created reports with dimensional functions in report studio.
• Involved in Performance tuning the Cognos Environment.
• Created imports and exports for moving the reports and framework models from one environment to other.
• Installing and upgrading the Cognos Environment to Cognos 8.4.
• Upgraded the report and Power Play cubes to 8.4 environments.
• Involved in normalizing the table structures.
• Extensively worked on developing and maintaining the database jobs for daily refresh of Cognos from SAP.

Environment: Cognos 8.2,8.4 Framework Manager 8.2,8.4, Cognos Connection, Analysis studio, Event Studio, Report Studio and Query Studio, Power Play Transformer 7.4, Cognos 8 transformer, Windows 2003, Sql Server 2005,Sap R3.

Confidential, Dallas,TX

Cognos 8 Developer/Admin

Responsibilities:

• Interacted with Business Users for Reporting Requirements.
• Documented Business Requirements into functional and Technical Specifications.
• Created a Daily Dashboard for Operational team for Daily activities.
• Created Framework Relational projects which involved importing tables, views and store procedures.
• Created (DMR) Dimensional Framework models in Cognos8.
• Created Data sources connection with Powerplay, Microsoft Analysis cube as the source
• Extensively worked with Dimensional Packages.
• Created organized and formatted reports, folders and other contents on Cognos Connection Portal
• Created Prompted reports using Report Studio.
• Created List Reports, Cross tabs, Drill through, Cascading Prompts, Charts, and Maps.
• Created burst report based on individual properties which involved bursting crosstab reports.
• Created Master Detail reports
• Created Power Play reporter/explorer reports.
• Involved in developing Power play Cubes based on Revenue, Sales and Marketing.
• Involved in setting the Current period, Quarter to date, Month to date and Year to Date special categories for business analysis by end users.
• Worked on partitioning large cubes with more than 30 million records.
• Worked on Cognos Script for enabling a disabling the cubes and creating PDF report for each property and archiving it.
• Worked on VB script for renaming and archiving the burst output files.
• Involved in Performance tuning the Cognos Environment.
• Involved in creating user signon in Access manager.
• Created imports and exports for moving the reports and framework models from one environment to other.
• Working knowledge in installing and upgrading the Cognos Environment.
• Worked on Publishing the Power play reports and cubes to the portal.
• Setting up the parameters for saving the burst output on a local disk.
• Experienced in onsite offshore model.

Environment: Cognos 8.1,8.2, Framework Manager 8.1,8.2,Cognos Connection, Analysis studio, Event Studio, Report Studio and Query Studio, Power Play Transformer 7.3,7.4, Windows 2003, Sql Server 2005.