We provide IT Staff Augmentation Services!

Sr. Tableau Admin / Sr. Cognos Admin Resume

5.00/5 (Submit Your Rating)

Jersey City, NJ

SUMMARY

  • Around 18 years of experience and sound knowledge in different phases of software development life cycle (SDLC) including analysis, design, development, testing and Production Support..
  • Extensive experience wif Tableau 8.x, 9.x, 10.x Desktop, Server and Mobile
  • Extensively worked on Tableau Upgrades from Version 8, 9 to 10.X
  • Worked on SAML Integration for Tableau
  • Configured SSL Setup for Tableau platforms
  • Experience in installing Tableau 9.x, 10.x on multi - server nodes wif high availability Setup
  • Excellent knowledge on Tableau Primary and Worker wif Load balancing
  • Extensive experience in using Tabadmin and Tabcmd utilities
  • Developed a PowerShell script to handle bulk-publication requests.
  • Worked on Tabmigrate utility to migrate workbooks and Sites b/w environments
  • Excellent hands on experience in setting up TABMON on single and multi-node setup
  • Excellent knowledge on Tableau Desktop and Server Licensing
  • Installed and Configured Tableau Server Monitor dashboard, Audit Activity dashboard for auditing purposes.
  • Setup a Multi-Server Tableau COE Instance to meet the Client requirements for 10,000 users
  • Excellent troubleshooting skills for the issues faced by users in Tableau
  • Experience wif disaster recovery environment setup & testing for Tableau platforms.
  • Installed and configured Cognos Analytics 11, Cognos suite of BI tools: Cognos BI 10.2.2/10.1.1/8.4.1 /8.4/8.3/8.2, ReportNet 1.0/1.1MR2/MR3, PowerPlay 6.0/7.0/7.1/7.3/8.0, PPES, PowerPlay Transformer in a single and multi server environment.
  • Installed and Configured ActiveState Python 2.7.8.11 and RevolutionR 7.4/7.1.
  • Created and updated Multi-dimensional PowerPlay Models/Cubes Using Transformer.
  • Expertise in Client/Server application development using Oracle, PL/SQL and SQL Server.
  • Interacted wif Customers for requirement gathering, effective analysis and also to provide end-user training.
  • Ability to meet deadlines and handle multiple tasks, decisive wif strong leadership qualities, flexible in work schedules and possess excellent communication and interpersonal skills.

TECHNICAL SKILLS

Business Intelligence: Tableau 8.x, 9.x,10.x, Tableau Server/Worker, Tabjolt, Tabcmd, TABMON, Tabadmin, Tableau for iPad, Tableau REST API, Cognos Analytics 11, COGNOS BI 10.2.2/10.2.1/8.4.1/8.4/8.3/8.2, Qlikview 11.20, COGNOS ReportNet 1.0/1.1, 1MR2/MR3, Framework Manager, PowerPlay 6.0/7.0/7.1/7.3/8.0, PowerPlay Transformer, Impromptu, IWR and PPES

Operating Systems: Windows 2012, Windows2008, NT, Linux 6.6/6.4, Sun Solaris 2.6, IBM AIX 5.3

Languages: Java, C++, C, VB, ASP3.0, HTML 4.0, XML, VBScript, JavaScript and COBOL.

Database: Hadoop, ORACLE 7.x/8i/9i/10g, DB2, SQL Server and MS-Access

Database Tools: PL/SQL, SQL*Loader, SQL* Plus, Pro*C Oracle forms 6i and Designer2000

OLAP Servers: Oracle Express, MS SQL 2000 Analysis Server, and MS-DTS

Hardware: SUN Solaris, IBM-AIX and Intel Pentium Based PCs

PROFESSIONAL EXPERIENCE

Confidential, Jersey City NJ

Sr. Tableau Admin / Sr. Cognos Admin

Responsibilities:

  • Sr. Tableau Administrator / Sr. Cognos System Administrator.
  • Expertise wif the installation, maintenance & support of the Tableau 8,9,10 versions.
  • Experience wif upgrading Tableau 9 version upgrade to 10.1.3
  • Hands on experience in Setting up SAML and SSL.
  • Setup TabMon to monitor the Tableau Server Health.
  • Hands on experience in setting up Tableau on multi servers hosted on Amazon Web Services.
  • Experience in installing Tableau’s TabCmd Utility and used it to publish workbooks.
  • Excellent knowledge on TabAdmin commands
  • Worked on creating New projects and applying security rules to restrict project access
  • Worked on Tableau server backup setup and automated the entire backup process
  • Extensively used TabCmd to Publish Workbooks.
  • Excellent knowledge on tuning Tableau servers and Workers processes.
  • Installed and configured the Cognos Analytics 11, Cognos 10.2.2, 10.1.1 and 8.4.1 BI suite products and Cognos TM1 in multi server Linux and Windows environments.
  • Supported the Production environments as a part of the Production Support team.
  • Managed the LDAP requests for user provisioning.
  • Proficient in deploying the packages from one environment to other environment.
  • Managed the Cognos Security Administration to restrict the Users.
  • Worked wif the IBM Cognos Support on resolving the Cognos environment issues.
  • Got trained in Hadoop Administration as part of my job.
  • Installed and configured the ActiveState Python 2.7.8.11 and RevolutionR 7.4/7.1 on Linux servers.

Environment: Tableau 10.3, 10.2.2, 9.1, 9.3, 8.x, Tableau Desktop, Tableau Server, Tableau Reader, Tableau iPad, Amazon Cloud, Cognos Analytics 11, COGNOS BI 10.2.2/10.1.1/8.4.1, Cognos TM1, Windows 2012/2008/2003, Linux 6.4/6.6, Websphere 8, SQL server, Oracle 11.2/10.2, DB2 V9.7, ActiveState Python 2.7.8.11, Revolution R 7.4/7.1.

Confidential, Bethesda MD

Cognos System Administrator

Responsibilities:

  • Cognos System Administrator.
  • Supported the Production environment as a part of the Production Support team.
  • Created the Cognos 8.4 Installation documentation for the Dev, UAT and Prod environments.

Environment: COGNOS BI 8.4.1, Windows 2008/2003, SQL server, Oracle 10g.

Confidential, Chicago IL

Cognos System Administrator

Responsibilities:

  • Cognos System Administrator.
  • Supported the Production Environment 24x7.
  • Created the complete step by step documentation for the Cognos BI installation in the Dev, UAT and Prod environments.
  • Created the documentation for the basic trouble shooting of the Cognos BI environment.
  • Trained Confidential off shore team which is located in India.

Environment: COGNOS BI 8.4/8.3/8.2, AIX 5.3, Oracle 10g, Teradata, Websphere.

Confidential, Cleveland OH

Cognos System Administrator

Responsibilities:

  • Supported 24*7 mission critical Cognos 8.0/7.3 server
  • Maintained Security of the Cubes and Reports for all the Corporations using Cognos Access manager administration
  • Responsible for Performance tuning of all servers.
  • Changed the default gateway CGI to ISAPI enhancing security and performance
  • Bursting of the Reports every Friday after updating the Security in the Catalog.
  • Used flat files to develop PowerPlay cubes.
  • Fine tuned PowerPlay cubes using SQL Queries.
  • Queried from different database tables as per the requirement
  • Created filters, prompts, sub reports, burst reports and provided drill through capabilities.
  • Created Transformer models and implemented security into the Model.
  • Created alternate drill-down paths and special categories
  • Managed LDAP security using Cognos Access Manager Administration.

Environment: COGNOS 8.0/7.3, Transformer 8.0/7.3, PowerPlay 8.0/7.3, PowerPlay Enterprise Server 8.0/7.3, Upfront 8.0/7.3, DB2 UDB 8.2, Oracle 10g, AIX 5L Version 5.3, Windows 2003.

Confidential, Richmond, VA

Cognos System Administrator

Responsibilities:

  • Installed from scratch ReportNet1.1 MR2 and Cognos 8.0/7.3 servers and supported 24X7
  • Developed Framework models and created advanced reports using ReportStudio.
  • Administered the ReportNet1.1MR2 administration and Cognos Connection
  • Conducted user training sessions and trained the users in QueryStudio and ReportStudio.
  • Created / Updated PowerPlay cubes and set user profiles to grant user permissions for querying.
  • Queried from different database tables as per the requirement
  • Created filters, prompts, sub reports, burst reports and provided drill through capabilities.
  • Created Transformer models and implemented security into the Model.
  • Created alternate drill-down paths and special categories
  • Inserted the cubes into PowerPlay Enterprise Server and published the cubes to upfront portal so that users could analyze them in the PowerPlay Web Client.
  • Managed LDAP security using Cognos Access Manager Administration.

Environment: Report Net 1.1MR2, Oracle9i, COGNOS 8.0/7.3, Transformer 8.0/7.3, PowerPlay 8.0/7.3, PowerPlay Enterprise Server 8.0/7.3, Upfront 8.0/7.3, Test Director and Windows 2003.

Confidential, Hartford, CT

Cognos System Administrator

Responsibilities:

  • Installed PowerPlay Transformer ReportNet1.1 MR1 in a multi server environment and supported 24X7.
  • Developed Framework models and created advanced reports using ReportStudio.
  • Conducted user training sessions and trained the users in QueryStudio and ReportStudio.

Environment: Report Net 1.1, Oracle9i and Windows 2003.

Confidential, Herndon, VA

Cognos System Administrator

Responsibilities:

  • Installed and configured ReportNet 1.0/1.1, IWR and PowerPlay Enterprise Server in a multi server environment and supported 24X7.
  • Responsible for Performance tuning of all servers.
  • Created and Published Packages using Framework Manager.
  • Used Report Studio to build multi-page, multi-query reports against multiple databases
  • Created filters, prompts, sub reports, burst reports and provided drill through capabilities.
  • Created Transformer models and implemented security into the Model.
  • Created alternate drill-down paths and special categories
  • Inserted the cubes into PowerPlay Enterprise Server and published the cubes to upfront portal so that users could analyze them in the PowerPlay Web Client.
  • Managed LDAP security using Cognos Access Manager Administration.

Environment: Oracle 8i, SQL/PLSQL, Report Net 1.1, COGNOS 7.0/7.1, Transformer 7.0/7.1, PowerPlay 7.0/7.1, PowerPlay Enterprise Server 7.0/7.1, Upfront 7.0/7.1 and Windows 2000.

Confidential, Cincinnati OH

Cognos System Administrator

Responsibilities:

  • Involved in Installation of Cognos Tools
  • Developed Reports in Cognos Impromptu, PowerPlay and Impromptu Web Reports (IWR).
  • Developed a Standard template for data warehousing requirement specification collection of requirements for development under COGNOS environment
  • Developed Catalog definition, design, and presentation and user classes/security.
  • Involved in all aspects of impromptu, from connecting to the corporate database to setting up effective catalogs, joins, folders, and filters, to ensure that adequate security procedures are in place.
  • Associate Impromptu Reports to drill through from one report to another.
  • Setting up appropriate User Class and security for the different groups of people who use the catalogs
  • Developed multidimensional power cubes wif Cognos PowerPlay.
  • Optimized the Catalog by using Database Interaction, Client/Server balancing, Database functions, Table Weighting and Qualification, Governors Settings.
  • Worked wif Access manager Administrator to provide security and Multi-user access
  • Created Snapshots to minimize data processing when the network traffic for the database is heavy

Environment: Oracle 8x, PL/SQL, Cognos (Impromptu & PowerPlay, Access Manager, Upfront, IWR), Data Mart, Sun Solaris 2.6, Java, SQL* Loader, Windows NT, XML, Excel, HTML, SQL Navigator.

Confidential

Cognos System Administrator

Responsibilities:

  • Created Financial Master Catalog used Impromptu Administration.
  • Created various canned reports in Impromptu Web Reports in Windows 2000.
  • Created Trend Over Time Reports
  • Divisions wise Profitability Analysis, Cash flow Analysis, Profit & Loss Statement Analysis and Variance Reports.
  • Developed Impromptu Web Reports (IWR) and published using Upfront.
  • Upgraded the Reports and Catalogs from series 6 to series 7
  • Changing filters, layers and measures.
  • Exception Highlighting, Sorting, Ranking etc.
  • Created OLAP cubes in Cognos PowerPlay using analytical data marts.
  • Worked on PowerPlay Enterprise Server to publish PowerPlay cubes and reports on web
  • Created quarterly and yearly reports for the management team and field operation Managers using PowerPlay reports
  • Provided various management levels wif reports, time series graphs and pie charts using PowerPlay cubes.

Environment: Impromptu 6.0, PowerPlay 6.5, IWR 6.0, Oracle 8i and SQL server 7.0, Cognos NoticeCast.

Confidential, Murray Hill, NJ

Cognos System Administrator

Responsibilities:

  • Involved in Installation, Configuration and Administration of Cognos products.
  • Designed and developed various Types of Reports (3D Bar, Pie Chart, Impromptu reports and OLAP Query Reports) to be used by various User Groups.
  • Actively involved in the design and implementation of Physical and logical Data warehouses and Data marts, OLAP solutions, installation of Cognos Tools, Multidimensional analysis, and Building Multidimensional cubes for strategic decision making for upper management.
  • Responsible for meeting wif end users and gathering and analyzing business requirements and Developing queries and reports using Cognos tool (Impromptu) and other web development .
  • Tools To provide Web-enabled data analysis solutions to business clients
  • Created Users and User Groups and tan allocated Privileges to Groups.
  • Scheduled various Reports for distribution using various means at varying schedules.
  • Developed and used Stored Procedures to transfer processing load to the backend server.

Environment: Cognos Impromptu, Transformer, FTP, PowerPlay Web, ODBC, Oracle 8i, MS Access, Windows NT 4.0.

Confidential

Cognos System Administrator

Responsibilities:

  • Developed procedures and functions using PL/SQL
  • Extensively used PL/SQL to implement Cursors, Triggers & Packages
  • Used SQL*loader for data migration.
  • Developed Data entry, query and reports request screens.
  • SQL tuning on existing report

Environment: Oracle 7.3 Forms 4.5, Reports 2.5, PL/SQL, and Windows 95.

We'd love your feedback!