PROFESSIONAL SUMMARY:

• Purna - 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,, 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:

• BigData Participation
• Created HIVE Tables, Loading data into Hadoop using Scripts & also Tools
• Created Scripts in Spark, Pig, MapReduce
• Worked onSparkScripts to find Trending Data Patterns using Scala.
• Configure BigData Database connectivity from Cognos & Tableau
• Write MapReduce Scripts for Data Retrieval Procedures.
• Cognos Responsibilities
• 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 withQlikViewDesktop,QlikViewManagement Console,QlikViewServer/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 ofQlikViewdata files.
• Extensive experience in end to end BI Implementation usingQlikView.
• 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 inTableau. 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

Responsibilities:

• 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 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 toTableauPublic and cloud hosting
• Developed complex reports and visualizations usingTableauDesktop 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 Confidential 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

Responsibilities:

• 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

Responsibilities:

• 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 asTableaudeveloper/SME in standardizingTableaufor shared service deployment.
• Extensively used data blending, embed functionalities inTableau.
• InstalledTableauServer in Dev, QA, UAT and Prod environments.
• Created multiple visualizations like Heat Maps, Bar Graphs and Bullet Graphs.
• Created MDX and SQL Queries for testingtableaudashboards.
• Strong knowledge on Tableau Enterprise, Tableau Desktop, Data Visualizations, Reporting, dashboards
• Administered user, user groups, and scheduled instances for reports inTableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups inTableauserver.
• Defined and created procedures to installTableaudesktop in silent mode.
• Defined best practices forTableaureport development.
• Used Tabadminand Tab cmd commands in creating backups and restoring backups ofTableau repository.
• Provided 24/7 production support forTableauusers.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Confidential, NJ (Whippany)

Cognos Lead/Architect/Developer

Responsibilities:

• 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 Material for In-house and Train the Trainer

Confidential, NY

Cognos Architect/Lead

Responsibilities:

• 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 (Cherryhill)

Cognos Administrator/Lead

Responsibilities:

• 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.

Confidential, NY (City Hall)

Cognos Administrator

Responsibilities:

• Installing Cognos components and ReportNet components on FISA servers. Configuring necessary applications.
• Installation of web servers, Cognos frame work manager setup, Cognos configuration, creation of metadata models, Configuring Access Manager LDAP Security.
• Creating Requirement documents for reports, designing specifications for reports, creating documentation for ReportNet Architecture, Logging ReportNet functional and technical issues with Cognos and helping solve the software problems.
• Preparing documentation for different Installation Strategies, Production moves and following Change Management Procedures.
• Creating documents for User Acceptance Tests (UAT), QA moves.
• Troubleshooting Cognos issues on the servers.
• Creating Scripts for user configuration of Access Manager Authentication.

Environment: Impromptu 7.x, Power Play 7.x, Cognos Enterprise Server, Sun Solaris Servers. Cognos on Windows NT & Windows 2000 Servers. Impromptu Web Reports, Oracle 9I, SQL Server 2000, Access Manager Administration, ReportNet Framework Manager, Report Studio Query Studio.

Confidential, NJ (Rahway)

Cognos Administrator/BI Analyst

Responsibilities:

• Creating project implementation schedule.
• Creating POC (Proof of Concept) Documentation.
• Creating User Acceptance Test (UAT)\QA\PROD Schedules for reports and other cognos objects delivery.
• Implementing the Testing cycles.
• Getting end-user sign of on all stages.
• Creating Shell Scripts for Cognos Jobs
• Studying PL/SQL Procedures created by developers and analyzing the code.
• Recommending the code changes for better/optimized performance.
• Reducing the data retrieval time to the lowest possible time.
• Enforcing the necessary indexes.
• Creating package that defines a subset of data that is relevant to an intended group of users in Framework Manager.
• Personalize the way news boxes appearance in the portal.
• Involved in setting access permissions on folders to groups and users. Then, moved these permissions from users to roles for future use.
• Setting up Cognos ReportNet components Framework Manager, Report Net Studio and Cognos Connection, Query Studio etc.,
• Environment: Impromptu 7.x, Power play 7.x, Cognos Enterprise Server, Sun Solaris Servers. Cognos on Windows NT & Windows 2000 Servers. Impromptu Web Reports, Oracle 9I, SQL Server 2000 ENT. Server, Cognos Configuration Scripts, User Class views, Cognos Macros, Access Manager Administration, Multi-Server Configurations, IWR Server & Report Administering, Enterprise servers management, Report Net Framework Manager, Report Net Report/Query Studio.

Confidential, NJ (Berkeley Heights)

Cognos Adminnistrator/BI Analyst

Responsibilities:

• Creating Catalog Security Filters based on users level of access through the info. From the database.
• Created a Multi Server Cognos Environment for the Client.
• This includes Installation of Enterprise servers, IWR, Cognos Upfront on Cognos Servers.
• Creating Client Configuration Scripts (Registries) to access Power play Enterprise Server.
• Created NT Log-on Scripts to install Cognos Components depending on the User Access to Various Applications, Registry Script to register the Domain for the Browser to Access Upfront
• FTP Scripts to move the Cubes across Platforms.
• Performance Tuning Cognos Applications including PDF Rendering IWR and Power Play Enterprise Server
• Assigning User level Security on Impromptu with User class Filters
• Creating CUBE level security based on Dimension Views using MDL scripting thru Visual Basic for each user depending on the Database Access level for Power Play.
• Building Power Cubes with Dimension level Security Control

Environment: Impromptu 7.x, Power plays 7.x, Cognos Enterprise Server, Sun Solaris Servers. Using FTP Scripts, Catalog Security, PDF Rendering, Scripts to disconnect shares and copy cubes, Upfront Administering, IWR Server & Report Administering, Enterprise servers management, Report Net Framework Manager, Report Net Studio.

Confidential, FL (Miami)

SQL DBA/DW/Cognos BI Analyst

Responsibilities:

• Creating databases and tables for staging environment for data warehouse.
• Designing specifications for data marts.
• Creating Physical & Logical data models using Erwin.
• Creating specifications for visualizer dashboards.
• Building Visualizer Dashboards.
• Publishing the Dashboard presentations on the web.
• Building Impromptu Catalogs & Generating Impromptu Reports.

Environment: Cognos EP Series 7, Impromptu 7.0, Power play 7.0, Visualizer 7.0, Visualizer Web, Visualizer Dashboards, Cognos Enterprise Web Server, Impromptu Web Reports, SQL Server 2000 Enterprise Server & Erwin 4.0 (Data Modeling).

Confidential, NJ 

Cognos/Visual Basic Developer

Responsibility:

• Cognos Developer with in-depth knowledge of Impromptu, Transformer, Power play & Cognos Query.
• High degrees of proficiency building Power play Cubes and Reports.
• Designing/Creating the OLAP reports using Impromptu.
• Configuring Impromptu Web Reports Server.
• Connecting to AS400 System using IBM Client Access 400 software for AS400 Connectivity.
• Creating Reports using AS400 Physical and Logical Files.
• Creating Catalogs using AS400 ODBC.

Environment: Cognos Impromptu 6.0, Power play 6.5, Cognos Query, Transformer 6.5, AS400 V4R7 Risk System, IBM Client Access 400, SQL 7.0/2000, Crystal Reports 7, PL/SQL, Visual Source Safe, Erwin 4.0 on Compaq Proliant 3000 Servers with RAID-5.