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.