Unnamalai Ramanathan
Senior System Analyst
Chennai
Summary
Adept Senior System Analyst with a proven track record at Acentra Health, leads cross-functional teams to deliver IT solutions that enhanced business operations. Expert in AWS Redshift and SQL, I excel in developing robust database structures and mentoring teams, significantly improving project delivery . Renowned for strategic risk management and impactful technology integration.
Overview
13
13
years of professional experience
4
4
years of post-secondary education
1
1
Certification
Work History
Senior System Analyst
Acentra Health
Chennai
06.2019 - 07.2024
- Collaborated with cross-functional teams to develop and implement effective IT solutions for business needs.
- Organized large sets of data through AWS Redshift, and AWS Quicksight.
- Directed the company's data warehousing solution, resulting in more efficient data management.
- Implemented data-driven solutions that improved business processes.
- Designed robust database structures that supported efficient data management and reporting capabilities.
- Participated in change management initiatives, supporting seamless transitions during technology upgrades or process overhauls.
- Mentored junior analysts, sharing industry knowledge and best practices to improve team performance.
- Managed multiple projects simultaneously, consistently meeting deadlines while maintaining high-quality results.
Software Engineer
Tata Consultancy Services
Chennai
12.2011 - 07.2017
- Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
- Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
- Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, and Materialized Views.
- Created Tables, Views, Constraints, Index .
- Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL developer and PL/SQL.
- Experience in Oracle-supplied packages, dynamic SQL, records, and PL/SQL tables.
- Partitioned large Tables using range partition technique.
- Worked extensively on Ref Cursor, External Tables and Collections.
- Expertise in Dynamic SQL, Collections and Exception handling.
- Experience in SQL performance tuning using Cost-Based Optimization (CBO).
- Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
Education
B.Tech IT - Engineering
SRM Valliammai Engineering College
Chennai 09.2007 - 05.2011
Skills
AWS Redshift
PLSQL Developer
SQL Developer
PostgreSQL
Certification
AWS Certified Developer - Associate
Timeline
AWS Certified Developer - Associate
09-2023
Senior System Analyst
Acentra Health
06.2019 - 07.2024
Software Engineer
Tata Consultancy Services
12.2011 - 07.2017
B.Tech IT - Engineering
SRM Valliammai Engineering College
09.2007 - 05.2011
Similar Profiles
Melissa PowellMelissa Powell
Clinical Evaluator at Acentra HealthClinical Evaluator at Acentra Health
Genesia HarrisGenesia Harris
Research Representative 2 at Acentra HealthResearch Representative 2 at Acentra Health
Sara GoldenSara Golden
Assessor (Virtual) at Acentra HealthAssessor (Virtual) at Acentra Health