anand.ucer.2009
About Candidate
Oracle Database Developer with 5+ years of experience in Data Engineering,Log Analysis,ITIL,Python,data analysis,unix scripting, data warehousing, performance tuning,data visualization, Power BI, RHEL, Data Analytics, Application Support,Oracle,Unix.
Location
Education
I have done a B.Tech in computer science from the United College of Engineering and Research, Allahabad, which is under the UPTU.
Work & Experience
Project name & Client – Bharti Airtel Environment- Unix, SQL, Shell scripting, ServiceNow Associated with the SMDP AIRTEL team & handling the day-to-day application/server-related activity. Using the ACROS monitoring portal to monitor the server’s health check and day-to-day publish the report to management. Using the Unix commands and a script to monitor the system and generate a report with the connectivity of the database.
Handled the SSDF project for client AT&T and provided and resolved support L1/L2 issues based on priority. Responsible & for developing the UNIX script to monitor the process job, and file system, and configure the cron jobs to schedule the scripts. Monitored the application (product) for CPU utilization (Health Checks) and coordinated with the Technology team for product/application queries. Providing technical support to the business team with the Q Messenger tool and developing the daily basis report as per business requirements. Understanding the project documents and developing document files.
Developed the day-to-day application performance health check reports and managed day-to-day data processing operations with the help of writing SQL. Providing technical support to the business team with the S-NOW tool when necessary. Ensure the application services are running fine and business requirements are fulfilled. Supported the ETL process to develop a report with a defined process and run on UNIX. Ensure the business request is handled through the Service Management ticketing tool (Service-Now). Responsible for extracting the data from the source server and transferring it to the business reports.
Experienced in solution testing and report development for MIS. Worked in ETL framework to generate the reports. Revenue and Usage-related report developed using on SQL statement for prepaid customers. Developed the daily application performance health check reports and managed daily data processing operations. Experienced in report development of daily, weekly, and monthly on Oracle DB with Optimized SQL statement. Adhoc Management report request has been handled and scheduled for auto- generation. Developed the daily application performance health check reports and managed day-to-day data processing operations. Ensure the business request is handled through the incident management portal (Jira). Diagnosing, troubleshooting, and developing new solutions that solve the root cause of customer problems Used basic Unix-Linux commands to check process and system health.
Responsible to extract the data from the source server and transfer to the vendor server. Supported the ETL process to develop a report with a defined process and run UNIX script. Responsible for database table creation and data load. Diagnosing, troubleshooting, and developing new solutions in terms of SQL statement development. Worked on Oracle databases, and SQL developer applications for report development. Developed the day-to-day application performance health check reports.


