SUMMARY

• Software professional with 7+ years of experience in supporting mission critical trading applications.
• Expertise in identifying and troubleshooting issues, impacting timely availability of data in the data warehouse or delivery of critical reporting within established SLA’s.
• Experience in fast - paced production environment and have ability to handle multiple, simultaneous problems with changing priorities.
• Extensive experience in Quartz framework, ETL Informatica, Unix, DB2, SQL, Sybase, Sandra, Oracle, Autosys, Geneos ITRS, ITIL, FTP, SFTP.
• Exposure to Hadoop Ecosystems in Big data Technologies - Hadoop HDFS, Sqoop, Flume, Hive, Pig, MapReduce, Spark, Oozie, Hue and Zookeeper.
• High proficiency in Back office and Middle office applications of Global markets operations and Technology.
• Trouble-shooting production incidents requiring detailed analysis of issues on web and desktop applications, Autosys batch jobs, quartz bob jobs and databases. (mainly SANDRA, Oracle)
• Fair knowledge on Investment banking, Derivatives, Commodities, Equities, Rates and Credits.
• Hands on experience in Informatica Power Center (Power center Designer, Workflow Manager and Workflow Monitor)
• Accountable for impact analysis and code changes.
• Nurturing and helping new team members to understand the application and BAU.
• Involved in Quartz code review and deployments, scheduling jobs on Quartz Bob monitor for the Regulatory Reporting, Quartz GFX and settlements applications.
• Experience in working with Electronic Trading applications (BART), Trade matching applications (TRAM) and Regulatory Reporting application Cirrus for various Jurisdictions.
• Automated existing application tasks and user reports which reduced manual effort.
• Used coding methods in specific programming language to initiate or enhance program execution and functionality.
• Strong understanding of Banking and Financial domain concepts and their risk and security policies.
• Efficiently handling resource management for global coverage production support.
• Experience in Integrating and working with various databases including SANDRA, ORACLE, and Microsoft Sql server.
• Experience in working on UNIX environment, shell scripts and Python scripting.
• Good Knowledge on transmission protocols FTP, SFTP, FTPS, TCP/IP connections, firewall issues.
• Good knowledge on ITIL and Change Management process.
• Actively involved in many DR (Disaster Recovery) activities and BCP programs.
• Provided accurate reporting to business stake holders with utmost quality.
• Expertise in handling production incidents and production related issues involving multiple vendors.
• Fair knowledge in ticketing tools such as Jira, PAPA (ITSM) and incident tool Maximo.
• Skilled in providing proactive support and successfully reduced response time on user queries and BAU issues.
• Excellent written and oral communication skills and a great team player.
• Exceptional ability to quickly master new concepts with a strong problem solving and analytical skills.

TECHNICAL SKILLS:

Database: SANDRA, Oracle 10g/11g, SQL server,DB2, SYBASE, TOAD 9.5

Tools: Quartz tools, Informatica 9.1, ITRS, Autosys, Ticketing tools (JIRA&PAPA), Maximo.

Operating Systems: Windows, UNIX, Putty, Hortonworks Distribution Platform, CentOS.

Language: Oracle SQL, PYTHON, Java

Scripting: Unix Shell scripting, Perl, Apache Pig

Big data Ecosystems: Hadoop, HDFS, Sqoop, Flume, Hive, Pig, MapReduce, Oozie, Hue, Spark

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Production Support Executive

Responsibilities:

• Holding responsibility for analyzing and supporting Real time Regulatory reporting applications.
• Responsible for transaction reporting on time to the regulators, which includes various message types such as RT, MTMT Valuations, ETD, PET and SNAPSHOT for various jurisdictions.
• Actively working with Transaction Reporting Operation teams on Lateness reporting transactions and generate report to the stakeholders.
• Working on Quartz platform on various tools with python scripts to perform analysis and automations.
• Working on a UNIX environment for performing file transfer protocols and server maintenances.
• Responsible for identifying and troubleshooting the processing issues impacting timely availability of data in the data warehouse or delivery of critical reporting within the established SLA’s.
• Automating user’s EOD reports and schedule it to run and deliver on time.
• Setting up ITRS alerts for the files/feeds delay from source team
• Actively involving in team building, team management and business related improvements and enhancements of an existing applications.
• Performing changes to the production environment in accordance with the bank’s change management process.
• Working in preparation of Support trouble shooting documents to ensure all work is carried out and documented in accordance with required standards, methods and procedures.
• Currently leading a global team across onshore- offshore-nearshore model, covering 24*7*365.
• Involved in project’s audit and Risk audits and maintained as per strict audit policies.
• Coordinating metrics reports with management and weekly status calls with development team to discuss on existing application performance and future enhancements.
• Preparation of weekly and monthly trending reports on the issues resolved, incidents handled, development escalated issues and support involvement in deployment releases.
• Performing weekend maintenance of application servers and systems.
• Providing on call support out of office hours, during weekends and during major release work for development and customer to help them resolve issues faced.

Confidential

Production Support Executive

Responsibilities:

• As a team leader of major Investment banking project, I had handled a team of 18 across onshore- offshore-nearshore model of covering 24*7*365 (global coverage).
• Held responsibility of identifying and troubleshooting the processing issues impacting timely availability of data in the data warehouse and delivery of critical reporting within the established SLA’s.
• Identified and deployed improvements in production application solutions or operational processes in support of data warehouse applications and business intelligence reporting.
• Supported working of TRAM (trade matching) applications and electronic system (BART) for trading applications.
• Coordinated with various third party vendors during business impacting changes and deployments.
• Worked with third party vendors (Broad ridge), trading desk and development team to resolve the production issue on time.
• Provided market data analysis to the Trading desk on time.
• Resolved complex issues through root cause analysis as appropriate.
• Created SQL scripts and PL/SQL procedures to load data from flat files into new tables.
• Built complex SQL queries for application reporting to suit client business requirements.
• Developed SQL scripts for conversion and load of legacy data in to production tables.
• Prepared UNIX shell scripts and Perl scripts to automate and systemize the load process at nightly cycles.
• Actively involved in deployment of major migrations in Quartz applications.
• Successfully re-engineered every application within data warehouse to comply with updated changes.
• Hand coded all the backend working scripts that refreshes the entire warehouse.
• Provided technical as well as functional support in project implementation for mission-critical applications.
• Provided performance tuning to improve the processing time of jobs.
• Involved extensively in business reporting, data mining, adhoc analysis and business forecasting across various departments.
• Worked with various teams across the domain to improve the performance in system and to drive future innovation.
• Prepared Support trouble shooting documents for future analysis.
• Involved in project’s Risk audits and provided L3 support on mission critical applications
• Coordinated daily metrics status reports and status meeting.
• Coordinated weekly status calls with development team on application performance.
• Created Weekly, Monthly trending reports on the issues resolved, incidents worked, development escalated issues and support involvement in deployment releases.
• Performed weekend maintenance activity of servers and systems.
• Experience with automation tools and concepts used to automate server builds and application releases

Confidential

ETL Informatica Support Engineer

Responsibilities:

• Effectively handled business scenarios and developed complex mappings.
• Resolved client support issues based on priority and severity as well as held responsibility for providing enhancements to all systems/products/applications within our domain.
• Worked on creating a various end to end reporting feeds which included designing and development using technologies such as Informatica, Oracle Database, and other reporting tools.
• Liaised with users, software developers and business clients for delivery of IT solutions and services.
• Effectively performed Application Enhancements and troubleshooting of Informatica and Database errors.
• Analysed the Informatica bottleneck and improved performance of workflows.
• Held Responsibility for creating alerts for production Informatica jobs and Informatica servers.
• Identified and performed troubleshooting of processing issues impacting timely availability of data in the data warehouse and involved in delivery of critical reporting within the established SLA’s.
• Identified and deployed improvements in production application solutions and operational processes in support of data warehouse applications and business intelligence reporting.
• Provided technical as well as functional support for project implementation of mission-critical applications.
• Held Responsibility for file transfer through FTP, SFTP and also in FIX protocol.
• Analysed root cause for the outage issues and worked with developers on the permanent fix.
• Responded to incidents raised from the L1 level Support and provide Level 2 (L2) production support for the applications with the SLA of 15 minutes.
• Generated daily critical reports to UK regulatory systems and to client money systems on time.
• Managed and resolved user queries and issues in timely and effective manner.
• Worked on JIRA Enterprise tool and PAPA ticketing tool for tracking incident tickets.
• Held Responsibility for preproduction and post production testing for the new enhancements.
• Worked on production batch scheduling and monitoring heavy loads.
• Support of Application processing (i.e.) attending to alerts and monitoring back end jobs.
• Interacted with Clients and worked with developers for the enhancement of existing applications.
• Received and analysed application related faults and data related faults from first line support.
• Coordinated with QA team for testing and resolving of defects before enhancements.

Confidential

L1 Production Support Analyst

Responsibilities:

• Effectively provided 24*7 L1 Support for all applications of GBOSS.
• Escalated issues to the corresponding L2 Support upon initial investigation.
• Effectively monitored support jobs which runs on Autosys, Informatica and Unix Scripts.
• Actively involved in weekend application Health checks to ensure system’s availability to business.
• Provided Access management for the GBOSS applications through ARM tickets upon approval.
• Worked on production batch scheduling and monitoring heavy loads.
• Supported Application processing (i.e.) attending to alerts and monitoring back end jobs.
• Actively involved along with L2 Support and Developers in various application deployments.
• Identified and raised incidents on tools such as Maximo and Papa Ticketing tool.
• Created weekly, monthly trending reports on the issues resolved, incidents handled, development escalated issues and support involvement in deployment releases.
• Support trouble shooting documents are updated and uploaded in SharePoint.
• Coordinated daily metrics status reports and weekly status meeting with L2 Support team SME’s.
• Worked on rotating shifts to make sure Support coverage is available 365*24*7
• Configured application support jobs in Geneos ITRS, monitored and resolved alerts on time.