SUMMARY

• Over 15 years of IT experience in Infrastructure and Development Technologies with specialization on Informatica Administration, Oracle Database Administration, Oracle Enterprise Manager Administration on RHEL Linux, IBM AIX, HP - UX, Sun Solaris environments.
• Extensive experience on Informatica PowerCenter 10.x/ 9.6.1/9.1/8.6.1/8.6/7.1. x/6.2.x/6.x/5.x, Informatica 9.6.1/9.1 Data Quality (IDQ), Enterprise level Architectural Designing, System Configuration, Installation, Administration and Implementation of Informatica tools on RHEL Linux, IBM AIX, HP-UX, Sun Solaris & Windows in multiple environments, Development (UT), SIT, UAT and Production.
• Informatica Domain with Multi Node, High Availability (HA) and Server Grid Configuration to avoid single point of failure for Informatica Services.
• Informatica Upgrades/Hotfix Upgrades from 5.x/6.x/7.x/8.x to 9.x/9.6.1/10.x in a cross-platform environments to support Applications, Infrastructure and Vendor support requirements.
• Informatica Domain & Node Management, Domain Folder Management, Security Administration, Log Management, Service Management and Domain Reports, Automatic Domain Backups and Restarts.
• Migration ( Deployment/Rollback, Export/Import) of Objects from lower environment UT to SIT to UAT to production.
• Informatica Domain Security Configuration & Administration (Users, Groups, Roles), Account Management, OS Profiles, Audit Reporting and Repository Folder, Object and Connection Security.
• Active Directory (AD) Authentication and LDAP Configuration to Manage Informatica Security.
• Repository Folder Management, Object Management, Relational & FTP Connections and across multiple environments.
• Domain & Repository Backups, Automatic Shutdown & Restart of Domain, Node, PC Repository, Integration, Model Repository, Data Integration, Analyst Services.
• Experience on Version Controlled Process, Change Management, Release Management & Outage handling procedures.
• Informatica System Level Monitoring and Alerting, Capacity Planning (CPU, Memory, Loads (sessions), I/O, etc). using Monitoring tools to proactively increase System Capacity as needed.
• Performance diagnosis/improvement for ETL processes, Co-ordinate & support environment for Infrastructure changes related to UNIX, Windows, Storage, Network, Middleware.
• Strong verbal & written communication skills, teamwork, analytical skills and eagerness to learn new technologies and ability work well in a team oriented, agile environment.
• Monitor, Troubleshoot, Debug and Fix Failures & Performance issues. Log file analysis for Domain, Service and User Activity. Manage Log Aggregator to collect, debug Domain and Node information, Hang & Crash analysis of services and collaborate with vendor in analysis of log files.
• Support and analysis of complex business functionality, represents application team on defect remediation discussions, Tracks application and batch performance and develops plans for remediation of issues, work with vendor support in CRIT-SIT events, Identify Bug fixes & Patches.
• Apply various patches to assures quality, security and compliance requirements are met for supported areas.
• Work & coordinate with various on-site/off-shore APP & Infrastructure teams on various Infrastructure and Development teams support activities during new app releases, scheduled/monthly maintenance activities.
• Define Standards and Best Practices for Environment and ETL Design Standards, Work with application teams, participates in code walkthroughs, ensure best practices implemented in ETL process.
• Maintain Disaster Recovery (DR/BCP) Plans, Coordinate Execution activities related to platform maintenance, Disaster Recovery (DR/BCP) and Software release management.
• Training on New features of Informatica & Advanced Techniques, best practices for various Business groups and users.
• L3+ escalation for Platform Issue resolution, troubleshooting and root cause analysis
• Provide 24 x 7 on-call rotation for Infrastructure Administrative and Production issue analysis & resolution
• Experience in Onshore/Offshore Services, Task Allocations & Project Delivery.

TECHNICAL SKILLS

ETL Tools: Informatica 10.2/10.1/9.6.1/9.1/7.1.3/7.1.2/7.1/6.2. x/6.1.x/5.x, Data Quality (IDQ), High Availability (HA), Server Grid, Session on Grid, Profiling, Scorecard, PC Repository, Integration Service, Model Repository, Web Services Hub, Data Integration, Analyst, Metadata Manager, Data Analyzer, Report & Dashboard (Jasper Report), Search Service.

Database: Oracle 12cR1/11gR2/10gR2/9i/8i, RMAN, Active DataGuard, GoldenGate MS SQL Server 2008R2/2005, MySQL Enterprise 5.5, DB2 (LUW) 9.x

Database Management & Performance: Oracle Enterprise Manager (OEM) 13cR2/12cR4/12cR3/11gOracle Database Diagnostic & Tuning Packs, Lifecycle Management Pack Oracle SQL Developer, Toad, MSSQL Management Studio MS SQL - Dell Foglight Performance Analyzer 7.x. Dell Foglight 5.7 DB2 Data Studio, DB2 Connect, MySQL Workbench

Developer & OLAP Tools: Oracle SQL Developer, Toad, PL/SQL, Business Objects 5.1/Xi, COGNOS BI 7.0

Monitoring Tools: Oracle Enterprise Manager(OEM), Dell Foglight, CA Insight, CA eHealth, CA Database Command Center.

Change Management Tools: CA Software Change Manager (SCM) Workbench 12 (Harvest), CA ServiceDesk

Scheduler Tools: Autosys, UNIX Crontab, OEM Job Scheduler

Hardware: IBM Power 750/Power VM, Lenovo Blade/VMware

Operating Systems: IBM AIX 5.0/5.1/5.3/6.1 , RedHat Linux 5.x/6.5/7.2 Windows 2008R 2/2005/2003/2000/ XP, Solaris 10.x/11.x, HP-UX 10.0/11.0

Tools: WinSCP, MobaXterm, PuTTy, SecureCRT, BoKS, PAC2000, Windows AD, LDAP, NDM

Storage: SAN, Pure Storage, EMC, NetApp

PROFESSIONAL EXPERIENCE

Confidential

Lead Informatica Administrator

Responsibilities:

• Informatica PowerCenter 10.2/9.6.1/9.1 , Informatica 9.6.1/9.1 Data Quality (IDQ), Enterprise level Architectural Designing, System Configuration, Installation, Administration and Implementation of Informatica tools on RHEL Linux, Sun Solaris & Windows in multiple environments, Development (UT), SIT, UAT and Production.
• Configure & Administration of Informatica Domain in a Multi Node, High Availability (HA) and Server Grid Configuration environment to avoid single point of failure for Informatica Services.
• Informatica Upgrades/Hotfix Upgrades from 9.1/9.6.1 to 10.2 in a cross-platform environments to support Applications, Infrastructure and Vendor support requirements.
• Informatica Domain & Node Management, Domain Folder Management, Security Administration, Log Management, Service Management and Domain Reports, Automatic Domain Backups and Restarts.
• Migration ( Deployment/Rollback, Export/Import) of Objects from lower environment UT/SIT/UAT to production.
• Informatica Domain Security Configuration & Administration, Account Management, OS Profiles, Audit Reporting and Repository Folder, Object and Connection Security.
• Active Directory (AD) Authentication and LDAP Configuration to Manage Informatica Security.
• Repository Folder Management, Object Management, Relational & FTP Connections and across multiple environments.
• Domain & Repository Backups, Automatic Shutdown & Restart of Domain, Node, PC Repository, Integration, Model Repository, Data Integration, Analyst Services.
• Experience on Version Controlled Process, Change Management, Release Management & Outage handling procedures.
• Informatica System Level Monitoring and Alerting, Capacity Planning (CPU, Memory, Loads (sessions), I/O, etc). using Monitoring tools to proactively increase System Capacity as needed.
• Performance diagnosis/improvement for ETL processes, Co-ordinate & support environment for Infrastructure changes related to UNIX, Windows, Storage, Network, Middleware.
• Strong verbal & written communication skills, teamwork, analytical skills and eagerness to learn new technologies and ability work well in a team oriented, agile environment.
• Monitor, Troubleshoot, Debug and Fix Failures & Performance issues. Log file analysis for Domain, Service and User Activity. Manage Log Aggregator to collect, debug Domain and Node information, Hang & Crash analysis of services and collaborate with vendor in analysis of log files.
• Support and analysis of complex business functionality, represents application team on defect remediation discussions, Tracks application and batch performance and develops plans for remediation of issues, work with vendor support in CRIT-SIT events, Identify Bug fixes & Patches.
• Apply various patches to assures quality, security and compliance requirements are met for supported areas.
• Work & coordinate with various on-site/off-shore APP & Infrastructure teams on various Infrastructure and Development teams support activities during new app releases, scheduled/monthly maintenance activities.
• Define Standards and Best Practices for Environment and ETL Design Standards, Work with application teams, participates in code walkthroughs, ensure best practices implemented in ETL process.
• Maintain Disaster Recovery (DR/BCP) Plans, Coordinate Execution activities related to platform maintenance, Disaster Recovery (DR/BCP) and Software release management.
• Training on New features of Informatica & Advanced Techniques, best practices for various Business groups and users.
• L3+ escalation for Platform Issue resolution, troubleshooting and root cause analysis
• Provide 24 x 7 on-call rotation for Infrastructure Administrative and Production issue analysis & resolution
• Experience in Onshore/Offshore Services, Task Allocations & Project Delivery.

Environment: Informatica- PowerCenter 9.1/9.6.1/10.2 , Server Grid, High Availability, Informatica Data Quality (IDQ), Profiling, Scorecard, (Repository, Integration Service, Model Repository, Data Integration, Analyst, Content Management, Data Analyzer, Web Services Hub, Search, Metadata Manager, Oracle 11gR2/12cR1, PL/SQL, SQL Developer, TOAD, Autosys Scheduler, WinSCP, putty, PAC2000, SecureCRT, BoKS, Windows AD, LDAP, NDM, UNIX, HP Performance Center.

O/s: RedHat LINUX 5.x/6.x/7.x, Solaris 11.x, Windows 2008R2, Windows 10

Confidential

Lead Systems Administrator (Informatica & Oracle)

Responsibilities:

• Enterprise level Architectural Designing, System Configuration, Installation, Upgrade, HotFix Upgrade, Administration, Development and Implementation of Informatica 10.1/9.6.1/9.1/8.6. x/7.1.x Data Integration tool on IBM AIX, HP-UX, RHEL Linux, Sun Solaris & Windows.
• Configuration and Administration of Informatica Application Services and Informatica Data Quality Services like, PowerCneter Repository Service, Integration Service, Model Repository Service, Data Integration Service, Analyst Service, Content Management Service, Search Service, Metadata Manager, Web Services Hub Service, Reporting (Data Analyzer), Reporting and Dashboard Service (JasperReports).
• High Availability (HA) of Informatica platform configuring and maintain servers with multiple nodes.
• Informatica upgrades/HotFix from 7.1.x/8.6.x to 9.1/9.6.1/10.1 in a cross platform environments to meet various Infrastructure & vendor support requirements.
• Configure Informatica Connection objects for Data Object Cache, Profiling Data Warehouse, Human Task, Reference Data Warehouse databases.
• Informatica Domain & Node Management, License Management, Alert Management, Folder Management, Domain & User Security Management.
• Manage Informatica Security Design, Implement and Administration of Roles, Groups and Users to Manage Domain and Services level privileges.
• Informatica Log management for Domain, Service and User Activity. Manage Log Aggregator to collect debug Domain and Node information, Hang & Crash analysis of Analyst, Data Integration, Model Repository, Repository and Integration services and for vendor support.
• Log file Analysis and collaborate with vendor in analysis of log files.
• Capacity planning and on-going monitoring (e.g. CPU, Memory, etc.) to proactively increase capacity as needed.
• Create Repository Folders, Manage folders Security between different application teams.
• Create Deployment folders and Maintain security to Perform Code Deployment/Rollback operations, Export/Import between Development, Integration, Model Office & Production.
• Informatica Code Deployment Support from Development (UT) to Integration (SIT) to Model Office (UAT) to Production.
• Developed and Implemented Best Practices to Manage Security and Naming Standards to be followed by all Development teams.
• Developed and implemented Repository Backup scripts and Automated Backup strategies for PowerCenter Repository, Model Repository and Reports (Data Analyzer) Repository.
• Coordinate and work with Infrastructure UNIX, Windows, Database, Network, and Storage Administration Teams on Infrastructure requirements Scheduled / Emergency maintenance support requirements.
• Develop & implement various system level scripts to monitor Informatica Processes.
• Worked with Conseco & Confidential India management teams on expanding the offshore Informatica support.
• Coordinate with Confidential India support team on Daily Off-Hours Informatica Administration & Production support
• Automated the Workflow log, Session log, and Repository log maintenance using UNIX Shell Scripts
• Implement Informatica System level Process monitoring using CA Spectrum / eHealth tools.
• Ensure 24x7 System availability and meet Infrastructure SLA requirements.
• Familiarize with the Design standards, Specifications, Development Process, Techniques and tools to support task performance and Escalate issues which cannot be resolved by the team.
• Involved in coordinating with the Business System Analysts, Project Managers and Functional Management to discuss project impediments and issues in completing the tasks.
• Work closely with various ETL Development teams on Development & implementation of various Financial, Marketing, Claims projects related to Conseco/Bankers/Colonial Penn Data Warehouse, Field Technology projects.
• Develop various Development standards & Best Practices to standardize the Informatica environment across the enterprise level
• Develop and implement Automated Monitoring process to eliminate physical monitoring & operator support.
• Monitor Model Office (UAT) and Production workflows, Maintain schedules and submit on-demand jobs.
• Develop, Maintain and enforce repository best practices within the Informatica environment to meet the requirements of Sarbanes-Oxley (SOX) change management compliance.
• Troubleshoot & Fix deployment errors between Developments, Integration, ModelOffice & Production.
• Perform ModelOffice & Production Fixes as per Release Management & Sarbanes-Oxley Procedures.
• Monitor, Troubleshoot, Debug and Fix Failures and Performance issues in ModelOffice (UAT) & Production.
• Provide 24 x 7 on call production support for daily, weekly and Monthly loads.

Environment: Informatica- PowerCenter 7.1/7.1.2/7.1.3/8.6/8.6.1/ 9.1/9.6.1/10.1 Model Repository, Data Analyzer, Data Integration, Analyst, ODBC Progress Data Direct, Mainframe, COBOL, Flat Files, XML, MS Excel, MS Access DB, C/C++, MS Visio, ERwin4.0, Business Objects 5.1/Xi, Oracle 11gR2/10gR2/9i/8i, RMAN, SQL*Loader, Oracle Enterprise Manager 11g Grid Control, 12c Cloud Control, Application Management Suite 4.0 for eBusiness Suite, MS SQL Server 2008/2005, SQL Management Studio 2008R2, Dell Foglight Performance Analyzer, DB2 (LUW), DB2 Data Studio 3.2, DB2 Connect, MySQL Enterprise 5.5, MySQL Workbench, WebLogic 10.3.2, JDK, SQL Developer, TOAD, CA eHealth, CA Insight/Spectrum, CA SCM Workbench, CA Autosys Job Scheduler, CA ServiceDesk, WinSCP, MobaXterm, Windows AD, NDM, UNIX, awk, ksh, bash, sed, perl

O/s: IBM AIX 6.1/5.3, RHEL 6.7/6.5/6.2/5. x, HP-UX 11.0, Windows 2008R 2/2005/2003/2000/ XP