SUMMARY:

• An Industry expert with over two decades of overall experience in Software Industry with 14+ years in IBM Cognos BI Suite of products Cognos Analytics 11, 10.2.2, QlikView 10, Tableau, BigData, HDFS.
• Highly Experienced in working with Data Visualizations, Dashboards, Metadata layers and different types charts in Tableau/Cognos Anaytics
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration
• Implementation experience in design/deploying data visualizations using Tableau/Cognos Analytics.
• Multiple Server Security Integration, World Class Support, Multi-Server/Dispatcher Installations, DB2 UDB, Oracle, Teradata, SQL Server, Sybase, Data Modeling, Raid Management, Clustering, Failover Support and Load Balancing.
• Broad competence and passion for Software Design, Development, Architecture and Implementation.
• Demonstrated aptitude to quickly learn and apply newer technologies in solutions.
• Exceptional and proven analytical, technical problem solving, team leading, training, coaching skills.
• A clear thinker, an effective communicator and an inclusive leader.
• Maturity and abilities to perform varied roles starting from hands-on work to leading, managing, directing and Strategizing in matters related to product development, systems integration and solutions architecture.

TECHNICAL SKILLS:

Operating Systems: HP-UX 9.x, 10.x, 11.x. Solaris 7, 8, 10, UNIX, Linux, XENIX, Onyx, Windows, MVS 360.

Hardware: HP Itanium rx86xx, 76xx, RP 8400, 74xx. Sun Servers, HP EVA5000 SAN, Intel Xeon 8 Processors, HP DL360, Compaq Proliant 1600R/3000/9000, AS/400, Dell Servers, HP Itanium Servers with dual core, dual processors.

Data Warehouse Tools: Tableau, Powerplay, Transformer, Cognos 1.1, 7.x, 8.x, 10.2.2, 11, Framework Manager, QlikView 11.2 Dashboards, All Studios (Metrics / Report / Query / Event / Analysis / Power Play), Advanced Business Insight, Workspace, Workspace Advanced, Cognos Enterprise Planning, Cognos Controller

Data Modeling Tools: Erwin 3.5, 4.0

Databases: Oracle 11G, Teradata, SQL Server, MS Access, MS Excel, DB/2

Development/FTP Tools: Java SDK, Hummingbird Exceed, WS-FTP, Toad, SQL Navigator

Presentation Tools: Microsoft Visio, Rational Rose

Document Management: Visual Source Safe, Clear Case, Clear Quest, PVCS, Change Management, Remedy, Peregrine

Web / Internet: Visual Interdev, Html, VBScript, JavaScript, MTS, ActiveX, ASP, DHtml, Crystal Reports, Data Visuzations, Tableu Visualizations, QlikView

Web Servers: Apache, IIS, IBM Web sphere

Languages: PL/SQL, T SQL, COBOL, Cobol/400, Rpg/400, Visual Basic, Pascal & C.

PROFESSIONAL EXPERIENCE:

Confidential, Weehawken, NJ

BI Architect & Developer (Shared Services Environment)

Responsibilities:

• Created HIVE Tables, Loading data into Hadoop using Scripts & also Tools
• Created Scripts in Spark, Pig, MapReduce
• Worked on   Spark   Scripts to find Trending Data Patterns using Scala.
• Configure BigData Database connectivity from Cognos & Tableau
• Write MapReduce Scripts for Data Retrieval Procedures.
• Guide-Install Multi-Server Architecture in DEV/UAT/Pre-PROD and PROD
• Identify Critical Issues in Cognos BI and Plan/Implement Upgrade Path for Cognos Environments
• Install Cognos Fixes & Patches, Design Alternative Solutions and work around solutions for Critical issues
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Work with IBM regarding trouble tickets and enhancements
• Server Level Tuning, User’s Security Enablement using Single Signon
• Active Directory, Access Manager, Sun One Directory Server security solutions
• Server to Cognos Roles Mapping, Data Level Security, Report & Folder Security
• Customize Cognos Portal for Client Specific requirements
• Create Framework Manager Modelling using Star/Relational Schemas
• Interact/Discuss/Gather Requirements from Users and Create Proof of Concept reports
• Scheduling reports using Daily/Weekly/Monthly with BURST Options and Email Distribution of reports
• Installing Cognos Analytics 11 using Oracle Content Store.
• Creating Active reports using Cognos 11 Datasources. Create Master/Detailed and Burst Reports.
• Schedule Burst Reports and distribute the reports via email. Fix Report Performance issues.
• Fix Framework Manager Joins/Cardinality/Performance issues.
• Create Dimensional Models using Relational/Star Schema Tables.
• Create/Manage Daily Reporting Deliverables meetings and coordinate team effort.
• Writing Custom and complex SQL’s for report studio reports for specific requirements.
• Creating Tab Reports in Active reports and creating Navigation Paths and story boards in Version 11.
• Installing JSON Visualizations, Building Custom reports using New Report Styles and Heat Maps
• Building Custom Visualizations using RAVE and JSON. Created Several Active Reports.
• Building On-Demand customer facing dashboards using Business Insight Advanced
• Build Complex Report Studio Dashboards, Reports using Master/Detail, Sectioning
• Built Canned Reports/Dashboards in Version 11 to support Client Teams
• Support Production Environment Cycles and troubleshoot/fix Production issues
• Follow Change Management procedures and use PPM Ticketing for Promotions
• Deliver Cognos BI Solutions with defined SLA’s. Build Dimensional Framework Models
• Involved in publishing various kinds of live interactive data visualization dashboards.
• reports and workbooks from Tableau Desktop to Tableau servers.
• Writing Pig scripts for data processing. Implemented Hive tables and HQL Queries for the reports.
• Create RAVE Visualations in Cognos BI Using HIVE Tables.
• Written and used complex data type in Hive. Storing and retrieved data using HQL in Hive. Developed Hive queries to analyze reducer output data. 
• Identify Reporting Requirements with several interactions with Users
• Install QlikView in dedicated QlikView Servers, Define QlikView Schedules, Load Data into QlikView
• Create Custom Style sheets in QlikView for referencing them in multiple areas
• Loading Dimensions Using XL Data, Database Queries, CSV Files etc
• Experience with   QlikView   Desktop,   QlikView   Management Console,   QlikView   Server/Publisher
• Client Interaction, analyzing end user requirements and developing technical solutions. 
• Expertise in using complex multiple data sources such as SQL, Flat Files, Excel and Access for designing and modeling of   QlikView   data files.
• Extensive experience in end to end BI Implementation using   QlikView . 
• Strong experience in writing SQL Queries, views and stored procedures. 
• Install Tableau Enterprise Software using SAML Configurations.
• Create Users and Users Security for Tableau. Author Report/Dashboard Security for Users.
• Create Dashboards using Tableau Desktop Client and Publish.
• Involved in creating a dual-axes bar chart with multiple measures. 
• Creating Dashboards using different source systems like flat files, Excel, HIVE and SQL 
• Extensively used data blending in   Tableau .  Define Functional & Technical Specifications, Data Mappings
• Create sample data for reporting requirements. Create/guide testers for creating Test Plans
• Move/guide Database team for moving data across regions for test support
• Develop Change Management procedures. Create Change Tickets, Coordinate with change teams
• Identify/Create Users in several Non-Prod/Prod regions. Implement Cognos security with Single sign-on etc.,
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 9.0
• • Scheduled the reports to run on daily/weekly basis and published the reports created to the Tableau Server
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.

Confidential, Pratt & Whitney, NJ 

Cognos Admin/Developer

Responsibility:

• Install Multi-Server Cognos Cognos Installations in RHEL Linux Environment
• Setup Cognos Content Stores. Developer Complex Cognos reports / Dashboards using Report Studio
• Maintain / Support Pratt & Whitney Cognos Linux/Windows Servers, troubleshoot issues
• Open / work with Cognos support tickets on a day-to-day basis
• Customize Cognos Portal to facilitate Client related interfaces and images
• Customize Cognos Style Sheets to work with Cognos Templates for easy reports creation
• Create User Training guides for ad-hoc reporting and complex reporting
• Created user friendly Dimensions, calculated objects and measures for prospective students to visualize through self-service approach
• Created various interactive customized dashboards and stories. 
• Applied various types filters like Data source filters, Quick filters and Context Filters. 
• Created table calculations, calculated fields and parameters. 
• Publishing sheets and dashboards to   Tableau   Public and cloud hosting 
• Developed complex reports and visualizations using   Tableau   Desktop as per requirements. 
• Created groups, sets, bins and performed conditional sorting and filtering as per the requirements. 
• Upgrade Cognos to next level environments. Integrate Cognos With Active Directory/Tivoli/SiteMinder
• Sun One Security Custom Variables and extend Security beyond default level
• Install DEV / QA / PROD environments and support patches
• Create Framework Manager Models using Relational / Star Schemas
• Define Modeling Criminality for optimal reports execution. Support Cognos DEV/QA/Prod environments
• Implement Patches and upgrades to various environments.
• Install Database connectivity to Teradata and other DB's
• Setup URL-Based images and reports for Pratt & Whitney

Confidential,Defend, NJ 

Cognos Lead/Architect

Responsibility:

• IBM SPSS Modeler (Predictive modeling)
• Business Process/Financial system improvement and Finance Performance
• Working with TM1 Perspectives, Performance Modeler, Turbo Integrator, Rules, Contributor, Analyst, Cognos Insight, Cognos EP, Cognos 10, IBM SPSS Modeler
• Designed and developed all the functional and technical process for the project delivery.
• Developed project implementation methodology and best practices.
• Understand Business Requirements and Create Framework Packages with relevant Defend Tables and Data
• Define Data Cardinality between tables to build Report Studio reports
• Create Different Underlying Reports which support the Visualizations
• Create Dynamic Dashboards using Workspace Advanced Visualizations
• Re-Design Report Studio reports using multiple Queries to Improve the Dashboard Performance
• Create Custom and conditional formatting for each sections of the Report Studio Reports
• Build GVP/NASP/Burn Status Prompts for Data Filtering
• Create Data Level Security for Defend to make sure the Sales reps/GVP's see their restricted data only
• Facilitate GVP level Impersonation in the Data Level Security
• Deliver Cognos Dashboard reports using RMT (Revenue Management Tool)

Confidential, NJ 

Admin: Cognos BI/Tableau

Responsibility:

• Install Multi-server Cognos installations for Dev/QA/Pseudo Prod/Prod Environments Provide 24*7 production support to this mission critical environment.
• Perform Cognos Custom installation, migration, configuration, maintenance, technical support, and troubleshooting & implementation of a shared environment.
• Upgrade Cognos 10.0 to Cognos 10.2.1 using industry best practices. Migrate content store, Cognos objects into higher versions using deployment practices and following Change Management procedures.
• Define Backup procedures for the Network Team and Take Backups for some instances.
• Recovered Cognos instances in case of crash.
• Setup Cognos replication/Mirroring for Disaster recovery. Performed DR drills
• Tune Cognos Servers for Optimal Performance Define high and low affinity parameters based on hardware architecture, Distribution of Cognos servers for better throughput.
• Define folder /Report and Data level security. Define Portal and Portlets.
• Conduct User Acceptance test with massive user base.
• Implement Patches and other day-to-day Cognos Planning administration tasks.
• Interacted with IT and business users to gather requirements for Cognos projects and deliver appropriate solutions as per SLA’s.
• Troubleshoot all Cognos issues and act as a SME for all Cognos related questions. Interact with Cognos for resolving critical issues.
• Create/Recommend Dev/QA/PSuedo Prod Databases for Business Intelligence
• Create Cognos Power Cubes and Automate Power Cubes thru windows Batch and MDL Scripting.
• Execute, Download and Publish Cognos Reports to File Servers, SharePoint with Burst Features.
• Deploy Cognos Packages / Reports / Dashboards into multiple environments
• Create Custom SDK Scripts for various departmental and organizational needs
• Create Custom Cognos Data/Report/Folder/Portal security provisioning
• Define/Design Custom Templates for Report Studio reports design using custom XML templates.
• Design/Develop/Recommend Cognos Reporting Branding and Color reports to represent/improve Clients image with the clients customers suitable for GoMobile and Ipdas.
• Create Custom Dashboards using ERSI Maps and Map Manager
• Create Dashboards using Advanced Business Insight.
• Set Watch Points/Alerts on Data changes in reports and set data change elements and thresholds
• Worked as   Tableau   developer /SME in standardizing   Tableau   for shared service deployment. 
• Extensively used data blending, embed functionalities in   Tableau . 
• Installed   Tableau   Server in Dev, QA, UAT and Prod environments. 
• Created multiple visualizations like Heat Maps, Bar Graphs and Bullet Graphs. 
• Created MDX and SQL Queries for testing   tableau   dashboards. 
• Strong knowledge on Tableau Enterprise, Tableau Desktop, Data Visualizations, Reporting, dashboards
• Administered user, user groups, and scheduled instances for reports in   Tableau . 
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards. 
• Created report schedules, data connections, projects, groups in   Tableau   server. 
• Defined and created procedures to install   Tableau   desktop in silent mode. 
• Defined best practices for   Tableau   report development. 
• Used Tab   admin   and Tab cmd commands in creating backups and restoring backups of   Tableau repository. 
• Provided 24/7 production support for   Tableau   users. 
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Confidential, NJ 

Cognos Lead/Architect/Developer

Responsibility:

• Design World Class Support Structure for 24/7 Cognos Support
• Design SLA’s and Escalation points for Platinum/Gold/Silver Level SLA’s
• Create Best Hardware/Failover Infrastructure for optimal performance guarantee
• Create Single Sign on Security authentication from workbench and Cognos for seamless Janus Security
• Design, follow change management procedures which include Alacrity, ECMS, ClearQuest, Peregrine Roles
• Install Multi-server Dispatcher Cognos installations for Dev/QA/Pseudo Prod/Prod Environments on Unix, Linux and Windows environment.
• Provide 24*7 supports to Cognos mission critical instances running on Unix, Linux and Windows.
• Installed latest patches for solving critical issues and keeping servers updated.
• Tuned Cognos servers for optimal performance. Involved in Capacity planning activities.
• SME for resolving all Cognos related questions and troubleshoot all Cognos issues.
• Installed and configure Cognos Replication / Mirroring in Dev, QA as well as Production servers.
• Wrote Cognos Recovery procedures for Disaster recovery. Performed DR activities and DR scheduled drills
• Perform Daily backups and recover Cognos instance in case of crash.
• Create Business Intelligence Book of rules and delivery expectations
• Customize Cognos Portal and Design/Guide Complex Dashboards
• Create/Maintain Cognos User Base with Janus Authentication Role Based Structure and user account provisioning
• Perform Cognos Custom installation, migration, configuration, maintenance, technical support, troubleshooting & implementation of a shared environment.
• Participate in and contribute to the implementation of best industry practices for Cognos 8.4 and TM1 9.5.
• Contribute to architecture and capacity planning activities.
• Create Data sources using Oracle, SQL Server, SybaseIQ, Teradata and other sources for various projects.
• Create Cognos Power Cubes in 8.4, Automate Power Cubes thru windows Batch and MDL Scripting
• Deploy Cognos Packages / Reports / Dashboards into multiple environments
• Create Custom SDK Scripts for various departmental and organizational needs
• Upgrade cognos 8.x reports using Life Cycle Manager
• Create Custom Cognos Data/Report/Folder/Portal security provisioning
• Generate and Audit Users Cognos daily activities
• Design Complex Report Studio Dashboards/Reports
• Create Burst Key Based reports for Easy Distribution of reports to various users’ emails,
• Troubleshoot upgrade problems/fix issues
• Create Relational/Dimensional Metadata Models using FM as per Ralph Kimbal Methodology
• Define/Design Custom Templates for Report Studio reports design
• Design/Develop/Recommend Cognos Reporting Branding and Color reports to represent/improve Clients image with the clients customers
• Create Custom Dashboards using Go Dashboards and Flash Technology
• Create Dashboards using Business Insight.
• Create Training Material for In-house Training and Train the Trainer

Confidential, NY 

Cognos Architect/Lead

Responsibility:

• Install and configure Cognos 8.x, Cognos 10 (Beta) and provide production support to 25 servers running in a global environment. Provide production support to servers in EU, ASPAC and America’s
• Upgrade Cognos 7.x to 8.x
• Gathered requirements from Global users and create Cognos Architecture based on Business needs.
• Installed and configured Cognos Mirroring, replication and Clustering across multiple environments globally.
• Participate in and contribute to the implementation of best industry practices for Cognos.
• Conduct performance tuning and capacity management.
• Implement Patches and other day-to-day Cognos Planning administration tasks.
• Work with IT and business users to resolve support and technical questions.
• Create Cognos Power Cubes in 8.4, Automate Power Cubes thru windows Batch and MDL Scripting
• Deploy Cognos Packages / Reports / Dashboards into multiple environments
• Design Complex Report Studio Dashboards/Reports
• Create Relational/Dimensional Metadata Models using Framework Manager as per Ralph Kimbal Methodology
• Create Fact/Fact less/Key based Models in Framework Manager
• Create Metrics Models using Metrics Studio

Confidential, NJ 

Cognos Administrator/Lead

Responsibility:

• Install and Configure Cognos 8 with All Studios on Various Hardware Types which Include Windows / Unix
• Installing Cognos Version 8 BI Suite with multiple Gateways Architecture
• Custom Configuration of Cognos Connection
• User / Folder / Report Level Security Implementation in Cognos Connection
• Writing Cognos Installation and Configuration Documentation and Guides
• Production Support and User Support, Interaction with Cognos for Troubleshooting
• Functional & Technical Requirement Analysis and User Interaction
• Defining reporting requirements and reports development standards.
• Scheduling Reports in Cognos ReportNet using SDK Event Handler.
• Leading the team members regarding development and all other activities.
• Authored complex reports for General Ledger (Profit and Loss statements) using Tree-hierarchy which is inherent in most PeopleSoft reporting. The tree structure in ReportNet reports provided the users the same look and feel of the canned reports from Crystal or SQR.
• Architected the Cognos ReportNet reporting solutions for the Accounts conversion process, which entailed converting accounts from their legacy system to PeopleSoft fully qualified accounts (FQA). These reports provided an easy and convenient solution for the users to convert their Accounts into the new system.
• Authored complex ReportNet Reports to replicate the out-of-the box PeopleSoft reports for Accounts Receivables module.
• Authored Cognos ReportNet reports with advanced functionality like Tabular SQL and Custom groups. Extensively used Conditional block sections for creating Multiple Queries in a single Cognos ReportNet Reports for reuse and layout.
• Authored Cognos ReportNet reports to Generate Billing Invoices Batch Printing using Cognos ReportNet with several advanced functionalities
• Enforcing Modular Reporting and performance-enhanced report design.
• Testing developed reports and enforcing QA\QC and Change Management procedures.
• Creating User Acceptance Test (UAT)\QA\PROD Schedules for reports and other Cognos objects delivery.