Swathi P

Having around 3.11 years in Application Support and Production Support in Banking and Telecom domain using Technologies are Unix, Shell scripting, Oracle SQL/PLSQL. Having good experience on L1 and L2 support. Having extensive Experience on ITIL Concepts like Incident management, Problem management & Release management. Good experience on Ticketing tools (ServiceNow and Jira). Having good knowledge in AWK and SED programs in UNIX environment. Extensively worked on FTP and SFTP commands. Strong knowledge in database objects like Tables, Views, Indexes, Synonyms and Sequences. Good knowledge on scheduling jobs using Crontab scheduler. Well Experience in Batch processing & Job scheduling by using Autosys Good hands-on experience on file system permissions. and special Permissions, Providing SUDO access. Extensive Experience in Stored Procedures, Functions, Triggers. Having good knowledge on TLM reconciliation. Involved in Explain Plan for Query Optimization and having knowledge in Performance Tuning. Have good interpersonal, analytical & problem-solving skills with ability to meet tight deadlines and work under pressure. Good Team Member, positive attitude and Self-motivated, quick Learner.

Investment banking, BMO BANK CANADA, 07/22 - Present, L2 Application support Engineer, Project is completely on Brokerage reconciliation. We would receive trade files from the bank and invoices from brokers. We would upload both the data into the reconciliation platform and perform the reconciliation and raise exceptions with brokers and banks. The Transaction Fee Invoice Management (TFIM) is a system that enables a Payer (Bank) to accept trade files from providers, map the trade files, and upload those files into TFIM., My role is L2 production support engineer., On Call Coverage- Resolved the issues based on priority that is by ticketing., Analyze and Resolve field issues maintained on Dimension., Deployment Support as well as migration support., Writing shell scripts, and implementing the SQL queries according to the customer requirement., Implementing the new SQL scripts, and enhancing the existed SQL scripts as per the requirement., Forwarding to L3 team if fix is required., Bouncing an application of servers., Creating the control files and modifying the existed files as per the business logic., Performing the monthly, weekly activities and validating the data using the existed report., Monitoring ticketing tool frequently and assigning incident to team., Interacting with onsite clients. Revenue Assurance, British Telecom Plc Ltd, UK, 02/21 - 07/22, L1 production support Engineer, The domain Revenue Assurance involves identifying leakages in revenue and finding discrepancies in data which could lead to incorrect billing. I was responsible for support and maintenance of applications in RA domain for the client - British Telecom. These applications are related to inter connect billing (number portability), generating discrepancies reports and performing audits on switches., My role is L1 production support engineer., On Call Coverage- Resolving the issues based on priority., Deployment Support as well as migration support., Optimizing the SQL queries., Scheduling the jobs using crontab command in UNIX., Forwarding to L3 team if fix is required., Writing the shell scripts and SQL queries according to the customer requirement., Implementing the new SQL scripts, and enhancing the existed SQL scripts as per the requirement., Creating the indexes on table columns based on the column cardinality., Finding out the root cause of performance SQL Queries and resolving accordingly., Loading the data in to the database using the SQL loader and External table concepts., Creating the control files and modifying the existed files as per the business logic., Performing the monthly, weekly activities and validating the data using the existed report.