SUMMARY:

• Overall 14+ years of IT experience (9+ years in US) in Business Intelligence , Data Warehousing , Middleware, Cloud computing , QA Testing, and Business Analyst.
• Extensive experience in IBM Cognos installation, configuration and troubleshooting across OS in Linux , Windows, and UNIX .
• Expert level experience in setting up distributed/clustered Cognos environment across all OS.
• Sound experience in server migration from on - premises data centres to cloud platformslike AWS (Amazon Web Service) and Microsoft Azure .
• Sound experience in Cognos installation, configuration and troubleshooting on cloud platforms like AWS and Azure .
• Extensive experience with installing, configuring, and troubleshooting different web servers like IHS (IBM http server), MS IIS (Internet information services)and Apache web server.
• Experience in setting up SSO (single sign-on ) on webserver level in Windows (IIS) and Linux (apache, IHS etc).
• Experience in setting up SSL (secure socket layer) on webserver level in Windows (IIS) and Linux (apache, IHS etc).
• Sound experience with setting up permission/security (users, roles, groups etc.) for Cognos objects, TM1 objects and database. Some of the security providers that I worked are Oracle directory LDAP, MS Active Directory for security.
• Experienced in installation and configuration of IBM Infosphere Information server 9.1, 9.1.2 and 11.3 .
• Sound experience with Windows and LinuxAdministration and Shell/Batch scripting.
• Extensive Experience in IBM Cognos version migration from Cognos 8.x to 10.1.x to 10.2.x to 11.0.x.
• Experienced in TM1 and IBM IIS (Infosphere Information server) installation and configuration on different OS (Linux and Windows).
• Experienced ininstallation and configuration of Cognosdesktopclients like Framework Manager, Transformer,Cube designer, Go-Office, Architect, Perspective, and Cafe .
• Experienced Data Modelling in Framework Manager and writing reports in Report Studio.
• Experienced on applying hotfixes, fix-packs on IBM Cognos, TM1 and Infosphere.
• Experienced in IBM WebSphere administration version 7 and 8.
• Experienced in Cognos SDK (java ) using Eclipse tool.

TECHNICAL SKILLS:

Operating Systems: Windows 7/8/10, Windows Server 2008/12/16, Unix, Linux

Languages: Puppet, terraform, SQL, windows batch scripting, Unix shell scripting

Tool: IBM Cognos Analytics, IBM Cognos SDK, IBM Infosphere services, IBM WebSphere, IBM Http server (IHS), MS IIS, Apache, MS Active Directory, Oracle LDAP server,HP Service Manager, HP Quality Center, HP Servicenow, MKS Tool Kit, Toad, PL/SQL Developer, Hummingbird, Cygwin, Putty,WinSCP, FileZilla, Xming

Database: Oracle 8i/9i/10g/11g/12c,Sql server, Teradata, DB2, MS Access, DB2, Sybase, Snowflake.

PROFESSIONAL EXPERIENCE:

Confidential, Portland, OR

Cognos PlatformAdministrator

Responsibilities:

• Migration of Cognos and TM1 servers from on-premises to AWS and Azure
• Migration of Cognos servers from Windows to Linux
• Cognos objects (content store) migration from version 10.2.1 to version 11.0.7
• Cognos installation and configuration on Linux andWindows server (on the AWS and Azure cloud).
• Cognos authentication setup with multiple providers like Okta, LDAP and Active directory.
• Data source setup and troubleshooting for Sql Server/Teradata/Snowflake/Oracle/Power cubes.
• Routing rules for SQL server packages as Linux cannot run ODBC reports on Sql Server
• Implement SSL on the web server level (apache) and security as per business requirement
• Installation and configuration of Framework manager and Transformer desktop tools
• Set up user capabilities and security on Cognos portal
• Content store backup and restore if needed
• Cognos objects deployment from lower environment to Prod
• Outage planning for the servers for OS patching on the servers
• Recycle script for Cognos services (windows batch script and Linux shell script for different environment)
• Troubleshooting of all kind ofCognos and OSissues (Level 1/2/3).
• Working with IBM on PMR for product related issues

Environment: Cognos 11.0.3/4/6, Apache, Windows server 2012/16,Redhat Linux server 7.x, Windows Batch script, Linux shell script,Autosys, Sql Server DB, Oracle 12c, Teradata 15.x, Snowflake DB, OKTA authentication

Confidential, Chicago, IL

BI Infrastructure Lead

Responsibilities:

• Cognos installation and configuration on Windows server, IIS web server and MS AD for security.
• Implement SSL on the IIS level and security as per business requirement
• Worked on multiple namespace in the cognos environment with AD and CJAP
• Implemented multiple gateway URL for same cognos environment for different set of users using different virtual directories and security (via AD group) on the web layer.
• Namespace override on gateway level
• IIS security on GW level to restrict users from cognos URL access
• Set up user capabilities and security on cognos portal
• Content store backup and restore if needed
• Recycle script for cognos services
• Troubleshooting of all kind of issues if developers fail to fix
• Working with IBM on PMR for product related issues
• Set up TM1 server on windows server 2012 in mode1 and mode5
• Troubleshooting of TM1 issues for all tools (Architect, TM1 Web, server explorer, CAFÉ)

Environment: Cognos 11.0.2/3/4/5, IIS 8.5, Windows server 2012, Windows Batch script, Control-M, Oracle 12c, TM1 10.2, Data stage 11.3.

Confidential, Charlotte, NC

Middleware Administrator Lead

Responsibilities:

• Cognos distributedinstallation and configuration across Linux and Windows server, IIS and IHS web server and oracle LDAP for security.
• Cognos single server installation on Linux and windows server. Oracle LDAP Directory as security provider and IIS and IHSas web server.
• Troubleshooting cognos issues in Linux and Windows environment.
• Linux shell script for cognos cube build, services start and stop etc.
• Windows batch scripts to build cognos cubes on windows environment.
• Cognos SDK to retrieve FM package from cognos portal. Used Eclipse tool for the same.
• Used Motio and Meta Manger third party tools for various cognos activities.
• IBM Cognos TM1 infrastructure install and maintenance
• Troubleshooting of cognos desktop clients likeFramework Manager, Transformer and Power play. Cognos code deployment from one environment to another.
• Cognos portal Administration that is set up security for Packages, folders, Data source creation etc. creating LDAP security groups and working with built in cognos roles.
• Cognos code deployment from Dev to QA to Production.
• Worked with IBM for cognos product related issues.
• Performed WebSphere administration tasks and troubleshooting

Environment: Cognos 10.2.1, IIS 7, Windows server 2008, Z-Linux, Shell Script, Windows Batch script, HP service Manager, Putty, Oracle 11g, DB2.