Sr Application Support Analyst

Job Description:

• Looking for a Senior Application support Analyst with 5+ years of experience in Unix, SQL, and Ab initio (or any other ETL tool).
• Need to be senior enough to work independently and self learn at times.
• MUST be able to optimize SQL queries, performance tune, table structures and indexes.
• MUST know basic Unix commands, command lines, how to move or add files.
• AbInitio is not required as long as another ETL tool is known.
• Must be able to work onsite in Tampa 2-3 days per week.

Job Purpose: 

• This business-critical requisition required to support daily production batches. 
• This requires research and identification from failed batches to resolutions at the quickest time. 
• This is a business sensitive position that requires attention to detail and quick turnaround. 
• Liaise between various support team across multiple vendors to provide seamless customer experience.

Job Background/context:
(Where the position sits within the department/organization)

• This reports to the application support manager lead locally and globally. 
• Also, the responsibility is for all the job functionalities and ensure that the support teams are addressing the production issues and intimating the finance customers for any ongoing issues.

Key Responsibilities:
(Describe the main activities the job-holder will perform)

• Leads a critical operational support service, process, capability or initiative within an operational unit and ensures performance and/or risk indicators are met.
• Establish and monitor process performance measurements and business impact. Gather and communicate performance statistics and reports to internal stakeholders and senior management.
• Monitor effectiveness and efficiency of production and/or process. Determine and/or drives change and improvement efforts in production and/or processes.
• 5-7 years’ experience in handling production support activities.
• Unix shell scripting experience and understanding of Ab Initio environment (Co?Operating system). He should be able to understand, analyze and write PL SQL queries on Oracle and Sybase.
• Extensive knowledge of Ab-Initio development, components usage, EME, migration process with branching. He should be able to analyze the existing graphs and should be able to provide impact assessment.
• Should have good expertise in database level analysis to trace issues to closure.
• Willingness to learn backed with solid technology understanding of distributed systems is essential. Must have the ability to co-ordinate with other teams and come to a resolution of batch issues at the earliest.
• Coordinate with other stake holders located across shores
• Ownership and responsibility for end-to-end production batches.
• Ensure process compliance and manage expectations of the leadership
• Actively trace and track issues and document the issue resolutions.
• Create monthly issue reports.
• Ensure best practices are followed

Development Value:

• (What opportunities to develop can the job offer a prospective candidate?)
• Excellent opportunity to get involved in cutting across global functions, related analytics, reporting methodologies for a large global bank
• Opportunity to learn/ add domain skill in the area of finance and primary market trading and accounting
• Opportunity to directly work with a highly motivated team
• Person Specification

Knowledge/Experience:

• Experienced with handling production support activities.
• Familiar with Ab Initio architecture for issue identification and issue resolution
• Should be aware of the scheduling tool.
• Hands-on experience UNIX with knowledge in scripting language to create scripts for automation of daily batch reports.
• Relational Database SQL (Oracle) experience (5+ year). Should be capable of writing complex and efficient SQL DML statements
• Experience on shell scripting would be added advantage
• It is desired but not mandatory to have experience with ETL Development tools

Skills:

• Strong design & execution bend of mind
• Thorough understanding of DWH methodologies
• Design pattern implementation, Algorithms and Data Structure.
• Ab-Initio development, components usage, EME, migration process with branching
• Unix shell scripting
• Software engineering best practices
• Passion for technology and self- starter
• Orientation towards Disciplined development processes
• Strong writing, communication, time-management, decision-making, and basic task organization skills
• Ability to prioritize and manage schedules under tight, SLA’s.

Qualifications:

• First class degree with excellent academic qualifications. 
• B.E/ B.Tech. in Comp science, IT, or other engineering disciplines from a reputed institute with relevant work experience. 
• Competencies

Business Process Design - Extensive Experience

• Knowledge of business process design techniques that encourage a critical, fresh look at key processes and focus on optimizing organizational performance; ability to apply this knowledge appropriately to diverse situations.
• Standard Operating Procedures - Extensive Experience
• Knowledge of and ability to design, implement and evaluate standard operating procedures affecting daily and strategic business operations in order to increase operational efficiency.
• Process Management - Subject Matter Expertise
• Knowledge of business process improvement tools and techniques and ability to understand, monitor, update, or enhance existing business or work processes.
• Effective Communications - Extensive Experience
• Understanding of effective communication concepts, tools and techniques; ability to effectively transmit, receive, and accurately interpret ideas, information, and needs through the application of appropriate communication behaviors.
• Decision Making and Critical Thinking - Extensive Experience
• Understanding of the issues related to the decision-making process; ability to analyze situations fully and accurately, and reach productive decisions.
• Accuracy and Attention to Detail - Extensive Experience
• Understanding of the necessity and value of accuracy and attention to detail; ability to process information with high levels of accuracy.
• Managing Multiple Priorities - Extensive Experience
• Ability to manage multiple concurrent objectives, projects, groups, or activities, making effective judgments as to prioritizing and time allocation.
• Problem Management Process - Extensive Experience
• Knowledge of and ability to bring a reported problem to successful resolution.
• Operational Functions - Extensive Experience
• Knowledge of major functional processes and associated operating requirements; ability to apply this knowledge appropriately to diverse situations.