Sr Software Engineer
CurrentClient British Telecom (BT), UK.Post Sr. Software EngineerRoles & Responsibilities Working as a developer, involved in 3rdline support activities from offshore.Major Responsibilities include • Participate in Business requirement Understanding.• Involved in coding and testing activities for new requirements and fixing the bugs of the application reported by second line support team.• Analyze/Tune complex SQL queries for faster execution.• Handling migration related activities for the application.• Maintain SLA’s when attending customer issues. • Participate in impact analysis.• Attend status meetings with Client Manager.• Attend project meetings.• Provide status reports and timesheets to Client/TechM managers.• Analyze the system performance and tuning of the system using Performance Monitor tool.• Provide KT to new joiners in the project.Application : ARTISAN.Automated Reporting and Target Investment System for Access Network (ARTISAN) application is aimed to assist network planners in proactive maintenance of the ‘access’ network. The following are the functionalities provided by ARTISAN:• Collection of data about customer reported faults on a daily basis from the source systems and generation of relevant measures.• Recording of visual inspection faults and reporting related to them.• Recording and initiation of work packages (PMF) by one-step planners in the planning group in Fault Management Program.• Build Auto WorkStreams for faults with estimated cost.Database : Oracle 10gTechnologies : SQL, PL/SQL, SHELL Scripting.Tools Used : Toad, SQL developer, Clarify(Bridge), Vi Editor.OS : Unix(Solaris).Project Location : Tech Mahindra, Pune.