Valliammai is available for hire
Hire ValliammaiValliammai Sundaram
Verified Expert in Engineering
Tableau Developer
Culver City, CA, United States
Toptal member since June 18, 2020
Bio
Vali has nearly a decade of experience specializing in SQL, Oracle, and PL/SQL. Currently pursuing a master's degree in data science, she enjoys building applications for clients of all sizes. Valli is currently located in Los Angeles, CA, and enjoys working with global teams.
Portfolio
AT&T
Tableau, Autosys, Unix, PL/SQL, SQL, Oracle
Conspecta Capital (via Toptal)
Visual Basic for Applications (VBA), Macros
Citi Bank via Tata Consultancy Services
Excel VBA, Autosys, Unix, Oracle
Experience
- Oracle - 8 years
- SQL - 8 years
- PL/SQL - 8 years
- Microsoft Excel - 8 years
- Excel Macros - 8 years
- Autosys - 5 years
- Unix - 5 years
- Cron - 1 year
Availability
Part-time
Preferred Environment
MySQL, SQLite, Unix, Linux, Oracle, Data Structures, Excel VBA, ETL, Python, Java
The most amazing...
...project I've accomplished was creating a predictive model for the number of approved non-immigrant visas in the US.
Work Experience
Oracle Developer
2018 - 2019
AT&T
- Worked on migration projects and investigated production issues.
- Collaborated with the business team which included gathering business requirements and developing a rules engine.
- Created testing strategies to ensure the quality of the application and reviewed test cases to ensure alignment with business requirements.
- Contributed to the identification of poor performance areas and worked on process improvement.
- Mentored the offshore team and encouraged teamwork.
- Helped in the creation of charts/reports using Tableau to aid the business team.
Technologies: Tableau, Autosys, Unix, PL/SQL, SQL, Oracle
Trading Platform Maintenance
2018 - 2019
Conspecta Capital (via Toptal)
- Debugged the macro code and fixed the broken links which helped the application to run again in production.
- Proposed and added new functionalities to improve the application.
- Removed processes that were not used anymore resulting in a 2x improvement in run time.
Technologies: Visual Basic for Applications (VBA), Macros
IT Analyst
2011 - 2013
Citi Bank via Tata Consultancy Services
- Led the applications team, CITI Client First, in developing a collections application for CITI Bank.
- Supported the back end of the CITI Client First application of CITI Bank.
- Automated the conversion of file templates using Excel VBA, which were previously converted manually.
Technologies: Excel VBA, Autosys, Unix, Oracle
Oracle Developer
2008 - 2011
Bank of America via Tata Consultancy Services
- Created the back end of an anti-money laundering application.
- Migrated ETL data from various applications to the AML application at Bank of America.
- Proposed process improvements that reduced the run time from two hours to ten minutes.
- Automated and improved the process of running test scripts from Excel directly in Oracle for Merrill Lynch.
Technologies: Autosys, Unix, Oracle PL/SQL, Oracle
Experience
Complete IZ0-061 Oracle 12c Fundamentals Certification
This exam has been validated against Oracle Database 12.1.0.1.0. I completed this exam 12/16.
Active Member on Stack Overflow
https://stackoverflow.com/users/2524830/valliI love to solve technical problems, and I have learned a lot as an active member.
Code to Delete Records Fast
This code deletes records using the bulk collection. I proposed this as a process improvement to the Bank of America. An existing job was deleting all records by using a for loop. I proposed this script that uses bulk collect and for all. This process improvement created a fivefold reduction in the time it takes to delete records.
Active Member with Hacker Rank
https://www.hackerrank.com/vallitceI like challenges and enjoy participating in HackerRank challenges.
B2C Application with Oracle Backend
I have created backend to store information received from B2c Application, stored procedures that will insert Company & subsidiary information, create a read replica of the Database, Backup retrieval for every two hours. In addition to that, I have also created three reports using sql queries
A Predictive Model for the Number of Approved Non-immigrant Visas in the US
This project aimed to predict the number of non-immigrant visa issuances for any predetermined country and any predetermined visa type. In order to solve the problem proposed above, we attempted to predict the number of visa issuances by analyzing the trends of different non-immigrant US visa types worldwide. In summary, we compared three different machine learning models to select the most accurate one and made predictions for future years using the chosen model.
Education
2021 - 2021
Master of Science Degree in Data Science
University of West Florida - Florida, USA
2004 - 2008
Bachelor of Engineering Degree in Electrical and Electronics Engineering
Thiagarajar College of Engineering - Madurai, India
Certifications
DECEMBER 2017 - PRESENT
Oracle 12c Fundamentals
Oracle
Skills
Tools
Autosys, Tableau Desktop Pro, Tableau, Cron, Microsoft Excel, Git
Languages
SQL, Excel VBA, Visual Basic for Applications (VBA), JavaScript, Python, Java
Platforms
Oracle, Linux, Unix, iOS
Storage
PL/SQL, Oracle PL/SQL, MySQL, SQLite
Paradigms
ETL
Other
Google BigQuery, Macros, Machine Learning, Engineering, Excel Macros, Regression Modeling, Data Structures, Electronics, Data Management
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring