We provide IT Staff Augmentation Services!

Production Support Analyst Resume

CARRER OBJECTIVE:

Strive to be the best at what I do. To better my skills and learn new ones at everything I do. - To be a team player but still have the strength and skills to make it on my own.- To become the best at what I do. To look for new technologies and integrate what is new into what has been tried and tested to work. To always be looking for a way to better my techniques along with my knowledge and understanding of my skills.

SUMMARY:

  • Over 5 years of IT Experience in providing ETL/Application Support.
  • Microsoft Certified Database Technology Associate.
  • Good working experience of ETL, SQL preferably on Oracle & SQL Server.
  • Good in DWH/BI concepts.
  • Experience on real time data integration using INFORMATICA tool.
  • Good in informatica transformation and session task like lookup, expression, Aggregator, Source Qualifier, Joiner, Update Strategy, etc & Session like command task, session task event task, etc.
  • Good hands on experience on UNIX commands and basic scripting.
  • Primary contact for production support and issues.
  • Strong experience in handling FTP and Batch processing.
  • Experience working in an environment which involves scheduling /monitoring batch jobs
  • Experience in handling feed files from multiple sources
  • Experience supporting web based application.
  • Ability to write queries to extract data and analyze the same to figure out client reported issues.
  • Good understanding of ITIL concepts.
  • Ability to communicate effectively with business and technical staff of existing or prospective clients.
  • Resolve incident and problem tickets within defined service level agreements and coordinate with third party vendors where required.
  • Triage customer issues such as job failures, outage messages and provide a quick communication to clients on status of such issues.
  • Determine failures of automated jobs and provide manual intervention to restart failed jobs.
  • Maintain FTP folders for clients to remove stale files, retrieve older files, and rerun jobs that fail as a result of FTP errors.
  • Good knowledge of Software Development life Cycle (SDLC).

TECHNICAL SKILLS:R

DBMS: Oracle 10g, MS SQL SERVER 2008

Operating Systems: UNIX, Windows 7

Languages: SQL, PL/SQL, Unix shell scripting.

Scheduling Tool: Informatica Scheduling, TIVOLI

Other Tools: Sql-Developer, WinSCP, JIRA Ticketing Tool

PROFESSIONAL EXPERIENCE:

Confidential

Production Support Analyst

Environment: Oracle 10g, DB2, LINUX, Windows, ETL (Informatica 9.1 Hot Fix)

Responsibilities:

  • Resolve incident and problem tickets within defined service level agreements and coordinate with third party vendors where required.
  • Supporting and troubleshooting Informatica mappings & workflows.
  • Supporting to the data integration in ODS and existing tool Compass using Informatica tool.
  • More engaged in issue reproduction & fixing it.
  • Triage customer issues such as job failures, outage messages and provide a quick communication to clients on status of such issues.
  • Determine failures of automated jobs and provide manual intervention to restart failed jobs.
  • Maintain FTP folders for clients to remove stale files, retrieve older files, and rerun jobs that fail as a result of FTP errors or any downstream application errors
  • Analyze and debug Scripts.
  • Analyze tickets and maintain quality.
  • Engage with the clients to answer their queries & provide timely resolution & fixes to their issues.
  • Write SQL queries to extract data and analyze the same to figure out client reported issues.
  • Prepare & provide reports to the clients and higher management as per requirement.
  • Provides shift handover to team members working globally.
  • Raise PR & give necessary information to the development team to fix the bug.
  • Regularly attend & resolve the issues such as application outage, issues impacting multiple users. Solving issues within SLA.

Confidential

Production Support Analyst

Environment: Oracle 10g, LINUX, Windows, Putty, WinSCP

Responsibilities:

  • Responsible for providing Application Support & development.
  • Raise incident tickets & track all the incidents through problem management tool(s).
  • More engaged in issue reproduction & fixing it.
  • Responsible to ensure that the backend as well as front end application running fine.
  • Application batch monitoring rerun / restart batches, where necessary supporting and responding to Business or user queries.
  • Work with Development team to rollout changes in the production environment (Release Management).
  • Raise proper and correct changes. Manage production releases - standard and planned by properly coordinating with other teams.
  • Analyze and record the log files.
  • Engage with the clients to answer their queries & provide timely resolution & fixes to their issues within SLA.
  • Automate different reports & provide it to the clients as per requirement to minimize resources & time.
  • Raise CR & give necessary information to the development team to fix the bug.
  • Regularly attend & resolve the issues such as application outage, issues impacting multiple users. Solving issues within SLA.

Confidential

ETL Support Analyst

Environment: Oracle 10g, LINUX, Windows, Putty, WinSCP, ETL

Responsibilities:

  • Responsible for providing Application Support.
  • Triage customer issues such as job failures, outage messages and provide a quick communication to clients on status of such issues.
  • Determine failures of automated jobs and provide manual intervention to restart failed jobs.
  • Release Deployments.
  • Analyze and record the log files.
  • Engage with the clients to answer their queries & provide timely resolution & fixes to their issues.
  • Prepare & provide reports to the clients as per requirement.
  • Provides shift handover to team members.
  • Raise CR & give necessary information to the development team to fix the bug.
  • Regularly attend & resolve the issues such as application outage, issues impacting multiple users. Solving issues within SLA.
  • Excellent aptitude to understand and meet client needs.
  • Excellent communication, presentation, project management skills and a very good team player and self-starter with ability to work independently and as part of a team.

Hire Now