OBJECTIVE:

• To work in a globally competitive IT era on challenging assignments that shall yield twin benefits of job satisfaction and steady paced professional growth.

SUMMARY

• 9 yrs of Data Warehouse Experience.
• Vast Experience in different business domains such as Securities, Banking, Retail and Healthcare
• Expert Informatica Admin with strong experience on Development and Ops Support (L1/L2/L3).
• 9 yrs of experience on Teradata, Oracle, UNIX etc.

TECHNICAL SKILLS

• Informatica 8.1, 8.6, 9.1, 9.5, 9.6, 10.2
• Oracle, Teradata
• UNIX, Windows
• ESP (Mainframe), Tidal
• SAP BO, Tableau

PROFESSIONAL EXPERIENCE

Confidential, San Francisco

Responsibilities:

• User Management - Providing Access/Privileges to the users over Informatica Powercenter services and objects.
• Automated the process flow for access management.
• Log Management - Retrieving logs for the users as per their request and log purging according to the business requirements.
• Server Health Checkups - Monitoring server space, CPU utilization.
• Application Monitoring - Monitoring Informatica Powercenter and data quality services and ensuring their availability to the users
• Incident and Problem Management - Handling incidents like server/service outages, connection failures etc. Working on incident tickets as per their priorities and provide timely response and solution.
• User Requests - Handling user requests to setup Informatica connections or to configure Informatica objects like sessions.
• Vendor Co-ordination - coordinating with Informatica vendor on troubleshooting activities.
• Automation Initiatives - To improve application design, system performance, to reduce manual intervention in production environment etc. - Automated access management process flow which is saving around 2 hours of efforts every week.
• Application Maintenance Support- includes handling planned application/server outages, application startup/shutdown and User notification.
• Customer Status Meetings - To attend meetings to provide customer status updates on deliverables.
• Conducting Informatica training for new recruits and junior team members

Confidential

ETL Design and Development

Responsibilities:

• ETL Design and Development of new SRs (Service Requests) - It includes, requirement gathering, Design, Workflow /Mapping Development, Teradata Query scripting, UNIX shell Scripting, Testing, Production Deployment, Documentation etc.
• Automation Initiatives - To improve application design, system performance, to reduce manual intervention in production environment etc.
• Operational Support- includes job monitoring, failure handling, data/code fixes, maintenance, manual ETL loads, reporting etc.
• Application Maintenance Support- includes handling planned application/server outages, application/server startup/shutdown, batch stop/resume, User notification.
• Customer/User Queries - Attending user queries and providing timely response and solutions
• Incident Management - Handling incident tickets as per priorities.
• Regular Informatica Server Health Check ups - Checking Server Space, memory consumption, Log/old source data purging, repository tablespace cleanup etc.
• Bi- weekly Customer Meetings - Attending bi-weekly progress meetings with customer
• Involved in initial planning/inventory listing of PLANET 2.0 upgrade which is an environment upgrade project.
• Performed Informatica Powercenter upgrade from 8.6 to 9.5 on UNIX platform. Also contributed to Informartica Powercenter installation/setup/configuration in PLANET 2.0 environment.
• Fine-tuned poorly performing Teradata queries to optimize User Report performance.
• Automated Failure Handling to avoid manual intervention in one of the operational activities that would take lot of manual work hours to catch up with the regular batch load when failed.

Confidential

Responsibilities:

• Worked as Application Lead in Production services team leading in APAC hours and responsible for Global service delivery.
• Daily work comprises of Incident Management, handling user requests, change deployments, serious incident handling and maintaining overall health of application.
• Heading Infra activities, releases, sending reports to client/higher management.
• Supporting shifts, weekends, holidays and taking end to end - RUN THE BANK responsibility.
• Co-ordination with various onsite/offshore team and Confidential higher Management.
• Activities like conducting team meetings, conducting Handover Calls, setting up User calls to close issues, client management calls etc.

Confidential

Responsibilities:

• Understanding the business requirements in terms of skillset, experience, volume, urgency.
• Understanding the Open Indents
• Understanding Supply Inventory Report
• Proposing exact/closely matching profiles against the open indents
• Follow up until the closure of the indent.

Confidential

Application Lead

Responsibilities:

• Lead the team of 6 testing members along with primary responsibilities as Informatica Admin.
• Timeline, plan and design the Informatica 9.5.1 installation, configuration, setup and environment testing.
• Check the software compatibility against the Database and OS platform in the project.
• Install the Informatica Powercenter 9.5.1 S/W on Windows Server (OS- 2007) - DEV/QA/PROD.
• Informatica Powercenter 9.5.1 Configuration - Domain, Node, Repository, Integration service, GRID, High Availability setup.
• Informatica Powercenter 9.5.1 Repository Setup - DEV/QA/UAT Folder/Connection Setup.
• Security User/Group Access Setup.
• Migrate the Informatica Powercenter Repository Folders from Informatica 8.1 environment to new environment (Informatica 9.5)
• Fix Migration/Application Issues.
• Plan for workflow testing in DEV/QA environments - test executing almost around 1000 workflows in both the environment to certify successful install of the software.
• Guide Testing team to meet testing timeline as the amount of testing work was huge and was supposed to be delivered in short span of time with all the proper documentation.
• Fix Testing issues if related to application/environment.
• Daily status update to Customer and Confidential Management.
• Documentation Work- Testing Tracker, Install and Configuration Document, Infrastructure Document, Delta Restoration Document, Progress Tracker, Minutes of Meeting and Action Tracker.
• Co-ordinate with Onsite Team and Customer to report Outstanding Issues and discuss on the solutions.

Confidential

Production Support and Infrastructure Team Lead

Responsibilities:

• Onsite (USA) Production Support and Infrastructure Team Lead. Team size - 12 (DBA 3 offshore, 1 onsite; Informatica Admin 3 offshore, 1 onsite; Business Object Admin 2 offshore, 1 onsite; Operational Support 8 offshore, 4 onsite).
• Go-to person for customer for all infrastructure and operational issues/requests.
• Responsible for Infrastructure upgrade and health checkups
• Contributed to Informatica upgrade from Powercenter 8.6 to Powercenter 9.5 - Lead Informatica Administrator
• Responsible for updating Informatica License across the ETL servers.
• Performed License upgrade for PDO, salesforce connector etc in Informatica 8.6.
• Responsible for all the ETL Installation work.
• Code Migration (Import-Export/DG), Folder/Connection Creation, Access Management
• Responsible for all version and patch upgrades.
• Installed Informatica hotfixes - Powercenter8.6 HF2, Powercenter8.6 HF4, Powercenter8.6 HF14, Powercenter 9.5 HF1, Powercenter9.5 HF2, Powercenter9.5 HF3 etc.
• Installed Powercenter9.5 EBF for Pushdown issues in 9.5
• Turned on versioning over non-versioned repository.
• Co-ordination with Informatica Vendor on trouble-shooting activities.
• Done a research on Informatica PDO - Teradata combination deadlock issue over database. Have implemented quite a few solutions to reduce these deadlocks.
• Conducting Informatica training for new recruits.
• Trainings on Informatica Administration, UNIX Security Setup, Shell scripting, Access Management etc
• Handling all the Production Support Activities as a part of Support Team. - Batch Monitoring, Failure Handling, User Notification, Weekend/Holiday Support, Incident and Problem Management, Release Cycle Management, handling planned Infra Outages.
• Upgrade project - Informatica Upgrade from Powercenter 8x to Powercenter 9x.