Priyadharshini Kumaravelu
South Windsor,CT
Summary
“Design for the present, with an awareness of the past, for a future which is essentially unknown”.
Innovative software developer with experience in designing, developing, and implementing software solutions to address complex business issues. Skilled in multiple programming languages and frameworks, with a strong ability to adapt to new technologies quickly. Demonstrated success in improving system performance and enhancing functionality through strategic updates and modifications. Committed to collaborating closely with team members to achieve project goals and meet deadlines efficiently.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Technical Lead
TCS
USA
05.2018 - Current
- Client: Cigna Corporation – Health Care.
- Being a database developer, I designed, developed, implemented, and maintained systems to support application development needs using Oracle PL/SQL and Aurora PostgreSQL databases.
- Expertise in writing complex PL/SQL procedures, functions, packages, triggers, cursors, and utilizing advanced features like collections and object-oriented programming.
- Designing efficient database schemas, creating tables, views, indexes, and understanding data normalization principles.
- Writing optimized SQL queries, identifying performance bottlenecks, and utilizing indexing strategies to improve query speed.
- Monitoring database performance, analyzing execution plans, and optimizing PL/SQL code for efficiency.
- Experience in AWS, especially in Amazon DynamoDB web services.
- Participated in data modeling sessions, contributing to the development of logical and physical database designs.
- Utilized version control systems like GitHub to manage changes to SQL scripts and database objects, ensuring consistency across environments.
- Leveraged Agile methodologies to move development lifecycle rapidly through initial prototyping to enterprise-quality testing and final implementation.
- Analyzed user needs and software requirements to determine design feasibility.
- Wrote user manuals and other documentation for roll-out in customer training sessions.
Developer
TCS
India
05.2014 - 05.2018
- Client: Hartford – Insurance.
- I started my IT journey with Hartford Client as a PLSQL developer and worked on one of its critical billing applications.
- Developed complex database objects, like stored procedures, functions, procedures, and triggers, using SQL and PL/SQL.
- Designed and developed a few screens using Oracle Forms.
- Experience in ETL techniques, analysis, and reporting.
- Creating workflows and monitoring to extract, transform, and load using Informatica and PL/SQL.
- AINS certified (Associate in General Insurance)
Senior Process Associate
TCS
India
10.2010 - 05.2014
- Client: Citi Bank – Banking.
- Back-office operations for Citibank's mortgage foreclosure process.
- Monitors and manages the foreclosure process, ensuring that all aspects of the foreclosure meet federal, state, and local regulations by working closely with U.S. attorneys.
- Provide supporting documents to attorneys to ensure files are moving to either sales or successful foreclosures that benefit Citi Mortgage.
Process Associate
CTS
India
04.2008 - 02.2010
- Client: The Hartford
- Back office operations to perform policy changes as requested by the insured.
- Auditing the policies to ensure delivering the accurate changes and meeting the policy guidelines.
- Acquired INS-21 certification, TTT (Train the Trainer).
- Recognized for achieving the quarterly award, 'OPEL'.
Education
Bachelor of Science - Computer Science
Bharathiar University
04-2006
Skills
Technologies
- PL/SQL
- Python
Database:
- Oracle
- Aurora PostgreSQL
Tools:
- TOAD for Oracle
- PgAdmin
- DBeaver
- Visual Studio
- PyCharm
- Jenkins
- Informatica
- AWS
Certification
- Oracle Certified Associate (OCA), External
- Oracle Certified Professional, External
- AWS essentials, Udemy certified
- AWS Certified Cloud Practitioner, Udemy certified
- AWS – Solution architect, In-progress
- Generate AI – E0, Internal
- Python – E1 level, TCS internal competency
- AINS – Associate in general insurance, Domain certification external
Personalityhobbiesinterests
I am very much interested in knowing the history and I love to play badminton. My hobbies are spending time with my 2 daughters and watching web series with my husband.
Timeline
Technical Lead
TCS
05.2018 - Current
Developer
TCS
05.2014 - 05.2018
Senior Process Associate
TCS
10.2010 - 05.2014
Process Associate
CTS
04.2008 - 02.2010
Bachelor of Science - Computer Science
Bharathiar University
Similar Profiles
Raghu UppatalaRaghu Uppatala
Data Engineer at TCSData Engineer at TCS
Judy ThomasJudy Thomas
Senior Process Associate (Pharmacovigilance) at TCSSenior Process Associate (Pharmacovigilance) at TCS
HANAMANT MANEHANAMANT MANE
DevOps Engineer at TCSDevOps Engineer at TCS