Ashok Veerasamy
Data Analyst
Manchester,MAN
Summary
Accomplished Database Administrator with a proven track record at Lloyds Banking Group, enhancing system stability and data quality through expert database management and recovery processes. Leveraged analytical skills and SQL expertise to improve ETL development and data analytics, resulting in significant efficiency gains. Demonstrates exceptional problem-solving abilities and a commitment to driving technological advancements. High-performing professional with extensive experience managing large-scale, complex databases. Skilled in SQL and database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up-to-date with new technologies and advancements.
Overview
12
12
years of professional experience
Work History
Database Administrator
Lloyds Banking Group
2019.08 - Current
- Streamlined backup and recovery processes, enhancing overall system stability and availability.
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
- Provided timely resolution of critical production issues, minimizing downtime and avoiding potential revenue loss.
- Established proactive monitoring solutions that alerted administrators to potential issues before they escalated into major problems.
- Enhanced reporting capabilities by designing efficient ETL processes that improved data accuracy and completeness.
- Conducted tests to identify issues and make necessary modifications.
- Set up and controlled user access levels across databases to protect important data.
- Streamlined the macros and procedures for better usability.
Support Specialist
JCPenney
2017.02 - 2019.07
- Monitored systems in operation and quickly troubleshot errors.
- Boosted customer confidence in company products through consistent provision of accurate information during interactions.
- Championed customer feedback initiatives that informed product improvements and feature enhancements over time.
- Collaborated with cross-functional teams to develop and implement effective support strategies.
- Tracked and documented customer interactions in customer relationship management system to maintain accurate records.
- Responded to customer inquiries and resolved complaints to establish trust and increase satisfaction.
- Streamlined support procedures for quicker response times, resulting in higher client retention rates.
- Maintained detailed documentation of support interactions, ensuring valuable insights are preserved for future reference and analysis.
Systems Engineer
Morgan Stanley
2012.12 - 2017.01
- Supported system users, educating employees on troubleshooting and problem-solving protocols.
- Contributed towards continuous improvement initiatives aimed at streamlining internal processes and enhancing overall service delivery quality.
- Designed high availability strategies to minimize downtime during critical systems outages or disasters recovery scenarios.
- Developed custom software solutions for various business needs, resulting in improved productivity.
- Evaluated new tools and technologies for possible integration into existing infrastructure environments.
Education
Bachelor of Engineering Technology -
M.kumarasamy College of Engineering
India, Karur 2001.04 -
Skills
Database monitoring
Database Management
Database Administration
Backup and recovery
Data Quality Management
Query Optimization
ETL development
Data Analytics
Advanced SQL Queries
Stored Procedures
SQL analytics
Database Design
Data Validation
SQL Expertise
Data Warehouse Architecture
SQL Programming
Problem-solving abilities
Test Planning
Decision-Making
Analytical Skills
Accomplishments
- Optimized existing procedures to improve performance by 30%.
- Automated processes to reduce workflow by 2 hours.
- Supervised team of 10 staff members.
- Achieved complex requirements with shell scripting and got awarded by the customers.
- Completed the ITIL foundation certification.
- Worked on the migration projects.
Timeline
Database Administrator
Lloyds Banking Group
2019.08 - Current
Support Specialist
JCPenney
2017.02 - 2019.07
Systems Engineer
Morgan Stanley
2012.12 - 2017.01
Bachelor of Engineering Technology -
M.kumarasamy College of Engineering
2001.04 -