SUMMARY:

• 9 years of experience in Full SDLC life cycle project development, including Planning, Requirements, design, coding, testing, documentation, implementation, migrated to production and ongoing production support for Cognos 11/10/8.x products.
• Extensive experience in IBM Cognos BI including Framework Manager Modeling, Report Studio, Query Studio, Analysis Studio, Active Reports, Cognos Workspace (Business Insight Dashboards), Cognos Workspace Advanced (Business Insight Advanced), Cognos Transformer (Multi - dimensional OLAP Cubes), Cognos Connection, Event Studio, Cognos Admin tasks like Creating, Publishing and deploying the Packages, Tableau Desktop, Tableau Server, ETL Tools like Informatica, Cognos SDK, SQL/PLSQL, Microsoft SQLSERER, ORACLE, IBM DB2, Data Warehouses and JAVA Programming.
• Development and Maintenance of Framework Manager Metadata Models including Dimensionally Modeled Relational (DMR) model and Relationally Modeled Relational (RMR) model by implementing the best practices of modeling metadata.
• Developed various types of complex reports like List Reports, Cross tab Reports, Chart Reports, Drill Down Reports, Drill Through Reports, Master detail reports, Conditional Formatting, Workspace Dashboards, Active Reports, Standard Templates, Dimensionally Modeled Relational Model (DMR) Reports, Relationally Modeled Relational Model (RMR) Reports, Reports from Cubes, Customized Prompts using JavaScript and HTML, custom templates and porting existing reports to use new templates.
• Sound Skills in Report Authoring - Conditional Blocks, Conditional Rendering to develop Hide and Show scenarios, Conditional Styles, Summary filter/detail filters/ Context Filters, Sections, Cascaded Prompts, Master-Detail Reports, Drill-through, Drill-down, Custom functionality in prompt page and Report Page using JavaScript in HTML.
• Designing, building and publishing of Cognos Multi-Dimensional OLAP Cube solutions.
• Developed Active Reports with advanced RAVE extensible Visualizations for providing an advanced interactive analytics experience in a self-contained Cognos Business Intelligence application for browsing and exploring data offline.
• Built variety of Executive Dashboards using Cognos Workspace (Business Insight) and Cognos Workspace Advanced (Business Insight Advanced) for a quick glance of various attributes/KPIs for Executive management.
• Well-versed in SQL / PLSQL, Microsoft SQLSERVER, ORACLE, IBM DB2, Postgre SQL.
• Experience in Migration of IBM Cognos 8 BI Versions to IBM Cognos 10 BI Versions and Birt business intelligence reporting tool to Cognos BI.
• Performed Cognos admin tasks like installing and configuring the Cognos Server and Framework Manager, Webserver, publishing the packages from Framework Manager, importing the packages and exporting the packages from/to dev/test/prod environments, integrating Cognos BI application with other applications.
• Prepared report scheduling procedures document and provided business training to schedule report views themselves.
• Debugging Java/J2EE code in Eclipse for fixing the issues of Reports that are integrated with other applications.
• Developed data sources in Tableau, Tableau visualizations and dashboards using Tableau Desktop and published the same on Tableau Server and Report Scheduling in Tableau server.
• Developed Dashboards and Worksheets with action filters, parameters, calculated set and so on in Tableau.
• Experience with Agile / Scrum Methodology, Iterative, Waterfall and so on Project Methodologies.

TECHNICAL SKILLS:

Business intelligence tools: IBM Cognos BI Versions 11/10.2.2/10.2.1 /10.2/10.1/8.4/8.3 /ReportNet, IBM Cognos Framework Manager, Report Studio, Query Studio, Analysis Studio, Active reports, RAVE Visualizations, Cognos Connection. Cognos Workspace (Business Insight), Cognos Workspace Advanced Dashboards (Business Insight Advanced), IBM Cognos Transformer/Power Play Transformer, Event Studio, Tableau Desktop, Tableau Server 8.3.x/9.1.x,, IBM SPSS Modeler data mining, Infor 10 BI performance management Tool, ETL Tools

ETL Tools: . InformaticaLanguages/Scripting: Java/J2EE, C, C++, SQL, PL/SQL, XML, JavaScript, HTML

Web Servers/ App Servers: Apache, IIS, JBOSS, WebLogic

UML/IDEs: IBM Rational Rose, Eclipse/My Eclipse, NetBeans

Reporting Tools: IBM Cognos BI, Tableau Desktop, Tableau Server, Birt reporting tool

Databases: MS SQL Server 2012/2008/2005, Oracle 11g/10g/9i/8i, PostgreSQL, IBM DB2, Toad

Version Control System: SVN, CVS

Operating Systems: Windows 2012 Server/Windows 7/Vista/XP, Linux, UNIXDirectory Services: Active Directory, LDAP, Custom Authentication

PROFESSIONAL EXPERIENCE:

Confidential, Malvern, PA

Cognos developer/ Tableau Developer

Responsibilities:

• Involving in Sprint meetings, writing goals, stories on Agility board, cross team meetings and Scrum calls with different teams including development teams, QA teams, database teams, content writing teams and Business.
• Gathering requirements from business for new reports and enhancements on existing reports.
• Developed various types of reports like List Reports, Cross tab Reports, Chart Reports, Drill-Down, Drill-Through Reports, Master detail reports, Conditional Rendering, Conditional Formatting, Cascading, Workspace Dashboards, Dimensionally Modeled Relational Model (DMR) Reports, Relationally Modeled Relational Model (RMR) Reports Web Service reports, JavaScript, etc.
• Developed Cognos Framework Manager Models, published packages on content stores, elevating reports from/to Dev/Test/Prod regions.
• Developed reports with different datasources including databases, open deployable xml data sources and web services.
• Development and maintenance of Cognos Reports, fixing issues, testing and migrated to production.
• Developed reports for different target countries with open deployable legal disclaimers xmls.
• Developed Advanced Dashboards using advanced features available in Cognos Workspace 10.2.1 like tabbed-dashboards, Action Button Widget, Global Area, Freeze Column, Row Headings, Expand/Collapse Column/Row headings and Cognos Workspace Advanced for Accessing advanced functions.
• Cognos Event Studio’s Scheduling including creating events, jobs, report views with different parameter settings and schedule different reports to run on different business days and send the same to business on mails.
• Developed complex reports with sql queries and stored procedures.
• Gave demos to business when developed new reports or adding enhancements to existing reports and demo to business for creating different report views with different parameters and scheduling the same on their own.
• Involved in synchronizing the Cognos reports and manual excel spreadsheet reports.
• Developed custom prompts using Java Script .
• Performing unit testing of the reports and peer review among team members.
• Developed reports based on Cognos Framework Manager metadata model’s queries/stored procedures and by writing direct manual sql queries in reports.
• Prepared technical documents like providing business the capabilities of scheduling reports on their own.
• Developed data sources in Tableau.
• Developed Tableau visualizations and dashboards using Tableau Desktop and published the same on Tableau Server.
• Report Scheduling in Tableau server.

Environment: Cognos BI 11/10.2.2/10.2.1, Cognos Framework Manager, Cognos Connection, Cognos Event Studio, Query Studio, Report Studio, Analysis Studio, Cognos Workspace, Cognos Workspace Advanced, Tableau Desktop/Tableau Server 8.3.x/9.1.x, IBM DB2, Oracle, Web Servers, open deployable xml, Frapi xml(Rest service), web services, JAVA applications, HP TeamSite, Active Directory Server and Windows 7.

Cognos Developer/Consultant

Roles and Responsibilities:

• Involved in gathering Business Requirements for new reports.
• Developed custom templates, training to team mates how to use custom templates while developing the new reports, Porting already existing reports to use Brand new Templates.
• Involved in full life cycle of Cognos BI including installation, configuration of Cognos BI Products, development and maintenance of Cognos Reports, fixing issues, testing and migrated to production.
• Developed various types of reports like List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down, Drill-Through Reports, Master detail reports, Developed Active Reports, Conditional Formatting, Workspace Dashboards, Active Reports, Standard Templates, Dimensionally Modeled Relational Model (DMR) Reports, Relationally Modeled Relational Model (RMR) Reports and JavaScript.
• Development and Maintenance of Framework Manager Models including Dimensionally Modeled Relational model(DMR) and Relationally Modeled Relational model(RMR).
• Developed Advanced Dashboards using advanced features available in Cognos Workspace 10.2.1 like tabbed-dashboards, Action Button Widget, Global Area, Freeze Column, Row Headings, Expand/Collapse Column/Row headings and Cognos Workspace Advanced for Accessing advanced functions.
• Developed Active Reports with advanced Visualizations for providing an interactive analytics experience in a self-contained Cognos Business Intelligence application for browsing and exploring data offline.
• Deployment and administration of Cognos BI.
• Involved in SCRUM meetings and developed and fixed the issues in Cognos Reports.
• Developed Power Cubes using IBM Cognos Transformer, published and Analyzed on Cognos BI Studios.
• Fixed the standard issues and client generated issues.
• Cognos Framework Manager-enabling a multi developer environment using Creating Segment/ link Segment.
• Managed Translations in Framework Manager using import/export features in Framework Manager.
• Involved in synchronizing the Cognos reports and Birt reports.
• Developed the reports based on the Spec docs and testing the reports.
• Developed Dashboards & Incontext BI’s using Performance Management tool- Infor 10 BI.
• Publishing the packages from Framework Manager & Importing/exporting the packages.
• Browsing and Debugging Java code in Eclipse to see the parameter passing from third party application to Cognos Reports.

Environment: Cognos BI 10.2.2/10.2.1.1//10.2.1/10.1, Framework Manager, Cognos Connection, Query Studio Report Studio, Analysis Studio, Cognos Workspace, Cognos Workspace Advanced, Active Reports, Transformer, Integration of Cognos Reports with Supply Chain Execution Application, Java/J2EE, BIRT Reports, MS SQL Server 2012, Oracle 11g, Active Directory Server and Windows server 2012.

Cognos Developer

Responsibilities:

• Upgradation / Migration of IBM Cognos 8 BI to IBM Cognos 10 BI.
• Involved in gathering Business Requirements for new models/reports.
• Developed various types of reports like List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down, Drill-Through Reports, Master detail reports, Developed Active Reports, Conditional Formatting, Workspace Dashboards, Active Reports, multi-query multi-prompt reports, Standard Templates, Dimensionally Modeled Relational Model (DMR) Reports, Relationally Modeled Relational Model (RMR) Reports.
• Involved in maintenance and developing the metadata model using Framework Manager publishing the packages
• Migrated the reports from Birt to Cognos.
• Developed Advanced Dashboards using advanced features available in Cognos Workspace 10.2 like tabbed-dashboards, Action Button Widget, Freeze Column and Row Headings and so on.
• Developed Active Reports for providing an interactive analytics experience in a self-contained Cognos Business Intelligence application for browsing and exploring data offline.
• Fixing the issues in Cognos reports.
• Developed customized prompts using Java Script.
• Involved in developing power cubes using IBM Cognos Transformer.
• Provided Production support and resolved maintenance issues.
• Performed Cognos admin tasks like installing and configuring the Cognos Server and Framework Manager, Webserver, publishing the packages from Framework Manager, importing the packages and exporting the packages, deploying the packages in servers, integrating Cognos BI application with other applications.
• Installed and Configured the Cognos BI environment, administering the servers, Troubleshooting

Environment: IBM Cognos 10, Cognos 8.3/8.4, Framework Manager, Analysis Studio, Report Studio, Query Studio, Cognos Workspace, Cognos Workspace Advanced, Cognos Transformer, Cognos Active Reports, Enterprise Business Vault, Enterprise Database Oralce 11g, MS SQL Server 2008, Oracle, SQL Developer,

Cognos Developer

Responsibilities:

• Created list reports, cross tab reports, chart reports and reports with features like conditional formatting, Page break, Master Detail, drill through, drill up, drill down and have extensively used the other features in Cognos.
• Built variety of Executive Dashboards.
• Developed Active Reports for providing an interactive analytics experience in a self-contained Cognos Business Intelligence application for browsing and exploring data offline.
• Managed Translations in Framework Manager using import/export features in Framework Manager
• Cognos Framework Manager-enabling a multi developer environment using Creating Segment/ link Segment and Merge methods.
• Maintaining multiple Segment-models and single Master model and publishing the package on Master model.
• Development and Maintenance of Framework Manager models.
• Developed Reports of Dimensionally Modeled Relational model (DMR) and Relationally Modeled Relational model (RMR).
• Browsing and Debugging Java code in Eclipse to see the parameter passing from third party application to Cognos Reports.
• Involved in SCRUM meetings and developed and fixed the issues in Cognos Reports.
• Fixed the standard issues and client generated issues.
• Developed power cubes in Cognos Transformer.
• Performed Cognos admin tasks like installing and configuring the Cognos Server and Framework Manager, Webserver, publishing the packages from Framework Manager, importing the packages and exporting the packages, integrating Cognos BI application with other applications.
• Responsible for documenting the code changes as per the User change requests
• Involved in Unit and Integration testing.
• Modified the Framework Manger Models to in corporate the new data elements.

Environment: Cognos 10.1/8.4 suite (Query Studio, Report Studio, Analysis studio, Active Reports, Transformer), IBM Cognos Administration, Birt Reports, SQL Server 2005, Oracle, Java/J2EE,Integration of Cognos BI Reports with CRM Application, BODS, Enterpirse Service Bus, ERP, Active Directory Server.

Cognos Developer

Responsibilities:

• Involved in entire Project life Cycle from requirement gathering to development of the reports and successful Go Live.
• Developed the Cognos reports based on the Spec docs and testing the Cognos reports.
• Created list reports, cross tab reports, chart reports and reports with features like conditional formatting, Page break, Master Detail, drill through, drill up, drill down and have extensively used the other features in Cognos
• Involved in maintaining and developing the metadata model using Framework Manager
• Development and Maintenance of Framework Manager Models including Dimensionally Modeled Relational model (DMR) and Relationally Modeled Relational model (RMR).
• Developed Reports of Dimensionally Modeled Relational model (DMR) and Relationally Modeled Relational model (RMR).
• Development and Maintenance of Framework Manager models and examined relationships and cardinality and so on in Framework manager.
• Fixing the issues in Cognos reports.
• Involved in SCRUM meetings and developed and fixed the issues in Cognos Reports.
• Fixed the standard issues and client generated issues.
• Performed Cognos admin tasks like installing and configuring the Cognos Server and Framework Manager, Webserver, publishing the packages from Framework Manager, importing the packages and exporting the packages, integrating Cognos BI application with other applications.
• Handled Critical situations in QA and Production Support in the final Stages of the project

Environment: Cognos 8.3/8.4/10.1 BI, Framework Manager, Cognos Connection, Report Studio, Query Studio, Oracle 10G, Windows 2003 server and TOAD, SQL Developer, PL/SQL Developer, Active Directory Server.

Cognos Developer

Responsibilities:

• Created list reports, cross tab reports, chart reports and reports with features like conditional formatting, Page break, Master Detail, drill through, drill up, drill down and have extensively used the other features in Cognos.
• Fixing the issues in Cognos reports.
• Involved in SCRUM meetings and developed and fixed the issues in Cognos Reports.
• Fixed the standard issues and client generated issues.
• Performed Cognos admin tasks like installing and configuring the Cognos Server and Framework Manager, Webserver, publishing the packages from Framework Manager, importing the packages and exporting the packages, integrating Cognos BI application with other applications.
• Implemented the architecture based on the MVC framework, using a Central Servlet acting as the controller
• Design and creation of GUI screens using JSP-Servlets and HTML
• Involved in developing for the application using n-tier J2EE architecture
• Client Side validation in user interface screens has been done using JavaScript
• Performed Unit testing.
• Involved in meetings to gather information and requirements from the clients.

Environment: Cognos 8.3BI, Framework Manager, Cognos Connection, Report Studio, Query Studio,DB2, Oracle, Windows 2003 server and TOAD, SQL Developer Oracle, PL/SQL Developer,Java, Servlets, JSP, JDBC, JavaScript, WebSphere, Eclipse, Oracle, Windows XP.