RESUME

Sanjay S

Mobile: +91-735*******, Email: ada9qi@r.postjobfree.com

Professional Summary

Expert Software Engineer dedicated to constantly improving tool and infrastructure to maximize productivity, minimize system downtime and quickly respond to the changing needs of the business.

Having 3 years of experience in Data warehouse and ETL Development, Maintenance, Business requirements analysis, Informatica Administration and Documentation.

Proficient in Informatica Administration work including Installing and Configuring Informatica PowerCenter and Repository servers on Windows and UNIX platforms, backup and recovery, folder and user account maintenance.

Good working experience in Upgrade Informatica from lower version to higher version. i.e. 9.5.1/9.6.1

Hands on experience in Installing Informatica power center 9.5.1/9.6.1/10.1.1 HF2

2+ years of experience as an OBIA Administrator in 11.1.1.9.x

Having 2+ years of experience in Installations, Configurations, Patching and Migrate of OBIEE 11g/ in Windows and Linux Environments.

Applied weblogic and bundle patches in OBIEE 11.1.1.9

2 years of experience in DAC administration

1 year of experience in Cognos BI Administration (10.2)

Good work experience in apply the oracle provides interim and bundle patches to fix the bugs in the application.

Self-motivated, excellent analytical, communication and presentation skills.

Extremely worked for end to end client.

Supports 24*7 and coverage weekend outage (DB, Linux, patching) Activities.

Professional Experience

Working as a Informatica, OBIA, Cognos BI Admin at Cognizant, Chennai from Jan 2017 to till date

Academic Profile

Bachelor of Engineering: Electrical and Electronics from Acharya Institutes Bangalore,2016

Technical Skills

BI Tools: Oracle Business Intelligence (OBI) EE 11g

(Admin, Presentation Services), Cognos 10.2

ETL Tool: Informatica PowerCenter 9.x/10.x

Databases: Oracle 11g/10g

Languages: SQL, C, C++, .Net

Operating System: Windows XP/2000/98, LINUX.

Work History JAN 2017 to till date

Project Title: Informatica and Cognos Platform support

Client Name: XL Catlin

Skills Used: Informatica 9.6.1, 9.5.1, 10.1.1

Responsibilities:

I have Installed/Upgraded Informatica powerCenter 9.x, 10.x product and administering the Informatica environments

Administration of Informatica servers and services, user administration, creation of Informatica Folders

Carry out deployment, migration, installations, upgrades, hot fixes etc.

Maintaining all level of securities for all environments Repositories

Monitor performance of overall system on all environment (prod, QA, test, dev)

Monitor disc space and load balance

Handling outages and restarting services

Coordinating with Unix, DB and network team for troubleshooting the issue

Handling application issues and providing root cause analysis

Migrating Informatica Application to new server

Analysing the Informatica job failures and fixing the issues.

Configuring application on new domain on migration or change of domain and repository database

Troubleshooting Informatica server and client critical runtime issues

Cognos Package and Reports deployments

Restarting Cognos webserver, content manager and dispatcher

User access management in cognos

Project # 2: April 2017 to till date

Project Title: OBIA Administration

Client Name: XL Catlin

Skills Used: Oracle Business Intelligence 11.1.1.5, 11.1.1.7, Oracle 10g

Responsibilities:

Successfully Upgraded from OBIEE 11.1.1.5 to OBIEE 11.1.1.7

Providing support on any new updating OBIEE metadata repository (RPD).

Participated in the installation and configuration of Oracle BI EE 11.1.1.7 on the Linux Environment.

Monitoring the OBIEE server and components.

Applied oracle patches to fix the existing bugs in application.

Handling Repository migration process to production.

Clearing BIP log files and actuate report logs.

Working with migration of repository (.rpd) and cache management.

Solving the mount point issues for all the environments.

Providing supports to user in order to resolve system and application related issues

Application deployment, application configuration, setting up application, migrating application.

Supports monthly schedule activities for moving the code from dev to stage and production.

Co-ordination with DBA/other support teams for planned/unplanned outages.

Audit trails for all the servers.

Logo change in the reports and dashboard and disclaimer setup in OBIEE login pages.

Installing, setup and configure Data Administration Console(DAC) server

DAC repository content migration

Scheduling DAC Execution plan and troubleshooting

Contact this candidate