Informatica Software Engineer
Resume:
RESUME
Sanjay S
Mobile: +91-735*******, Email: ******.****@*****.***
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