Having 4+ years of experience in Movate Technologies PL/SQL development & production support .
3 Years of experience in Integration Engineer in Non.IT
Extensively worked on Oracle 11g
Proficiency in writing and tuning complex queries, stored procedures, joins, triggers, Sub query, tables, functions, and packages experienced in requirement analysis, coding and testing various modules in a software development
Life cycle using PL/SQL
Strong Customer Centric Approach, with Process Orientation.
Motivated by internal standards of performance to deliver quality results.
Working knowledge of Agile Methodology of Project Management.
Worked experience in rotational shifts and L1 Production Support.
Involved 24*7 support work.
Generate reports as per the upstream and downstream user's requirement.
Experienced in providing production support in different geographies and time zones all over the globe.
Strong analytical skills combined with a deep understanding of data modeling, ETL processes, and data governance principles.
Overview
9
9
years of professional experience
Work History
SQL Developer
Movate Technology
Chennai
11.2020 - 02.2024
Written PL/SQL Procedures, Functions, Packages, and SQL Scripts using Oracle SQL and PL/SQL.
Developed data model, PL/SQL Queries, SQL Query tuning process.
Created and maintained tables, procedures, functions, and packages, and update, delete, and insert statements and compile them.
Experience working with Oracle CLOB, BLOB, Materialized Views, Ref Cursors, Index, Tables, Partitions, Objects/Collections, Execute Immediate etc.
Formulated SQL queries, functions and processes as per requirement.
Used standard packages like UTL FILE, DMBS SQL, and PL/SQL.
Collections and used BULK Binding involved in writing database procedures, functions and packages.
Worked with developers to repair and enhance current base of PL/SQL, packages to testing issues.
Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
Data Load into Oracle tables using SQL 'Loader', and PL/SQL procedures.
Responsible for Unit Testing of Database PL/SQL Packages, Procedures, Functions and Database Triggers.
Defect tracking through JIRA and defect summary reporting.
Worked on agile and test-driven environment, participated on daily scrum meeting, and discussions.
Understand the requirement and nature of the client's business and will suggest & Documentation works.
Regular follow up with the clients.
Coordinating with other teams regarding the pending process.
Reporting daily status and weekly review.
Logs tickets, performs initial diagnosis, and escalates complex problems to L2 support if necessary.
Design system configuration a way that improves network resilience.
Monitoring the status of server and creation of alerts using OEM tool.
Engineer
Nokia
04.2015 - 03.2020
Site Survey & Validation / Network Deployment (BTS Installation, Commissioning and Integration).
Responsible for TRX addition, VSWR clearance, BTS hardware issue clearance.
Expansion of Multiplexes to enhance the capacity of E1's by adding BTS for OML Protection.
Quality checking and Acceptance test in coordination with vendors.
Checking of the GSM and MW antennas for proper angles and its alignment done by AT.
Resolving site down, transmission issues and trx blocking alarms regularly maintaining the KPI 99.99% in O & M.
Optimization of GSM antenna for customer complaint, Over shoot problem, Hand over problem, Worst cell improvement, CQI, RLF.
EMF report submitting for new sites.
I have successfully handled the Projects in Vodafone, Airtel, Ooredoo, T-Mobile, TPG RAN Refresh.
Handled all projects documents submitted with Quality of Audit a short time period.
Responsible for providing on-site technical service and support for customers and installers.
Installation, commissioning Huawei bts and Nokia transmission and power installation.
Knowledge on both hardware and software of Huawei BTS and Nokia BTS.
Ability to perform work independently within the given deadlines although in team.
Installation & Commissioning of Mux & Radios in Co-ordination with Vendors.
Preparation of Installation certificates & other documents related to projects.
Preventive & Corrective maintenance of SDH equipment by clearing the Major/Minor/Critical alarms in the network with minimum outages.
Routing of E1's for new sites in SDH hops.
BSC & BTS Alarms analysis, escalation, troubleshooting, and preventing fault propagation and ensure network availability And all the daily Operation and Maintenance activities.
Alarm Reduction and Alarm analysis, Notification of Service Affecting/degradation faults/alarms & fixing the same in the network within the operator specific SLA.