ABINAYA B
Data Analyst
Chennai
Summary
Detail-oriented Data Analyst with overall 4 years of experience. Eager to support DataDive Analytics in driving significant business decisions by analyzing critical data and delivering impactful reports.
Overview
4
4
years of professional experience
2
2
Certifications
Work History
Internal Audit Department–DataMining and Analytics
Axis bank
7 2022 - Current
- Analyzing the Audit Requirement and fetch data using SQL queries across different database.
- Worked on different systems like Finacle, Finnone, CTL, Caslite, Tradax etc.
- Writing complex SQL queries including sub queries for faster data retrieval from multiple tables.
- Planning and coordinating activities with data administrator in order to ensure regular and accurate update of databases, validation of data, and fresh additions
- Scheduling the reports generated on a daily, monthly and quarterly basis according to the requirement.
- Developed and Implemented Strategies for efficient storage, retrieval and manipulation of CLOB (Character Large Object) data in Oracle Database.
- Developed SQL queries involving String Manipulation such as SUBSTR for substring extraction and regular expression (regexp) for advanced pattern matching.
- Handling errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Associate Professional Software Engineer
DXC Technology
06.2020 - 07.2022
- Analyzing the business requirements of the projects by studying the Business Requirement Specification document.
- Good understanding of Incident Management, Problem Management and Change Management.
- Monitoring ticket queue for proper resolution and updates.
- Documentation of projects and database.
- Creating database objects like tables, procedure and function.
- Creating indexes on the tables for faster retrieval of the data to enhance database performance
- Using for all and Bulk collect to fetch large volumes of data from table.
- Using Pragma Autonomous Transaction to avoid mutating problem in database trigger
- Using the advanced features of PL/SQL like Dynamic SQL.
- Solid Exposure to Performance tuning of the SQL queries.
- Having Knowledge on Explain Plan.
Education
B.E. (Computer Science Engineering) -
Sri Venkateswara College of Engineering (SVCE)
Higher Secondary - Computer Science
Sri Krishnaswamy Matriculation Higher Secondary School
Skills
SQL
undefinedCertification
Microsoft certified Azure fundamentals (AZ-900)
Disclaimer
I hereby declare that all the above information given by me is true of my best knowledge.
Timeline
Tableau Data Analyst/Specialist desktop certification (Udemy Course)
05-2024
Microsoft certified Azure fundamentals (AZ-900)
12-2021
Associate Professional Software Engineer
DXC Technology
06.2020 - 07.2022
Internal Audit Department–DataMining and Analytics
Axis bank
7 2022 - Current
B.E. (Computer Science Engineering) -
Sri Venkateswara College of Engineering (SVCE)
Higher Secondary - Computer Science
Sri Krishnaswamy Matriculation Higher Secondary School
Similar Profiles
Lakshay SharmaLakshay Sharma
Deputy Manager at Axis Bank (On Payroll Of Axis Bank)Deputy Manager at Axis Bank (On Payroll Of Axis Bank)
Preethi VPreethi V
Relationship Associate at Axis Bank - Axis Max Life InsuranceRelationship Associate at Axis Bank - Axis Max Life Insurance
Prodip SahaProdip Saha
Collection Officer at HDFC Bank, Bajaj Finance, Axis Bank, IDFC BankCollection Officer at HDFC Bank, Bajaj Finance, Axis Bank, IDFC Bank
ANIL BASAKANIL BASAK
Sales Manager at Axis Max Life Insurance Co. LTD With (AXIS BANK)Sales Manager at Axis Max Life Insurance Co. LTD With (AXIS BANK)
Hari Krishna NallapareddyHari Krishna Nallapareddy
Lead Engineer at VESTAS WIND TECHNOLOGY INDIA PRIVATE LIMITEDLead Engineer at VESTAS WIND TECHNOLOGY INDIA PRIVATE LIMITED