Data Analyst, Database Admin

Kalaivani KG

437-***-**** *********.*******@*****.*** Toronto, ON LinkedIn

“As like Database, I am evolving everyday”

Summary of Qualifications

●7+ years of experience providing end-client customer support in the IT industry

●Demonstrated ability to provide satisfactory solutions to clients with excellent problem-solving skills developed through years of customer support experience and community engagement events

●Highly skilled in troubleshooting and performance tuning with interaction in data analytics and processes

Technical Skills

Operating Systems: Windows 10, UNIX

Applications & Tools: Microsoft Excel, Azure Sandbox, SQL Server, SNOW, SQL Developer

Oracle OEM, Toad

Tools: G Suite by Google, RDBMS, IBM Cognos Analytics, Jupyter, SQLite

Project Management Fundamentals: Agile, Waterfall, Scrum, Kanban, Trello

Languages: SQL, Python

Work Experience

Configuration Management Oct 2020 - Dec 2021

Gainwell Technologies (Legacy HPE) Chennai, India

●Managed databases required for non-production and production usage by adding and removing required records

●Supported Azure SQL Team in deployment and delivery standards and processes for new and existing customers which resulted in smooth delivery

●Effectively managed audits of configuration records that reduced the redundancies between testing and production environment

●Collected and reported data metrics with excel visualization graphs at regular intervals

●Recognized as Star of the Quarter for exemplary performance, seamlessly and effectively delivering on projects commitments

Oracle Database Administration/Capacity Management June 2016 - Sep 2020

DXC Technology (Legacy HPE) Chennai, India

●Developed skills in performance tuning using EXPLAIN PLAN, AWR, ASH and ADDM reports

●Effectively resolved 3 to 4 Levels 1 and 2 Service Tickets a day simultaneously through different mediums of communication, prioritizing the issues based on the severity

●Familiarity with DB Refresh using import/export and data pump utility

●Hands on experience with Golden Gate to manage replication process.

●Proactively monitors Space/Capacity of the database which results in zero downtime

●Created new database users as required, maintained access management, database privileges and system security

●Administered all database elements including tables, clusters, indexes, views and sequences

SQL Server Database Administration Jun 2014 - Jun 2015

Hewlett-Packard Enterprise Chennai, India

●Completed Database administrative tasks using SQL with Windows

●Managed and updated 48 servers and 50 databases over the course of work

●Provided solutions to assigned tickets as per defined priority, to maintain the SLA

●Performed ad hoc manual backup and restoration activities that fix the ad hoc issues

●Shared periodic metrics of the database usage to clients and vendors

●Installed and configured third party tools like SMC, Java and .Net framework on virtual machines that helped developers to work on VM

Education & Certifications

Microsoft Azure Fundamentals Professional Certificate July 2022

IBM Data Analyst Professional Certificate Sept 2022

Junior Data Analyst Program May 2022 – Sept 2022

NPower Canada Toronto, Ontario

14-week intensive online training on the fundamentals of computer technology, and project management

●Utilize Excel spreadsheets to perform data wrangling and data mining

●Develop working knowledge of Python language for data analysis using Pandas and Numpy

●Effectively complete a capstone project by collecting data from multiple sources, performing exploratory data analysis, data wrangling, statistical analysis and mining of the data using Python libraries

●Work extensively on creating charts and plots to visualize data, and building an interactive dashboard using IBMs Cognos Analytics and various Excel charts/graphs

●Visualize data using Python libraries including Matplotlib, Seaborn, Plotly and Dash

●Compose queries to access data in cloud databases using SQL and Python from Jupyter notebooks

●Explain cloud concepts, benefits of cloud computing and core Azure architecture components

●Use core Azure services and choose the Azure AI services that best address a company’s challenges

●Control Azure spending and manage bills by applying recommended practices to minimize cost

●Demonstrated a high level of understanding of Agile Project Management Lifecycle and key techniques and successfully completed Agile projects using tools such as Scrum, Kanban

Oracle Database 11g: SQL Fundamental I Nov 2016

Bachelor of Engineering, Computer Science May 2014

Anna University Coimbatore, India

Contact this candidate