Valliammai Sundaram, Developer in Culver City, CA, United States
Valliammai is available for hire
Hire Valliammai

Valliammai Sundaram

Verified Expert  in Engineering

Tableau Developer

Location
Culver City, CA, United States
Toptal Member Since
June 18, 2020

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.

OracleSQLPL/SQLLinuxUnixMicrosoft ExceliOSMySQLSQLiteGitMacrosOracle PL/SQLVisual Basic for Applications (VBA)TableauMachine Learning

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

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/valli
I 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/vallitce
I 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.

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

Tools

Autosys, Tableau Desktop Pro, Tableau, Cron, Microsoft Excel, Git

Other

Google BigQuery, Macros, Machine Learning, Engineering, Excel Macros, Regression Modeling, Data Structures, Electronics, Data Management

Paradigms

ETL

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

DECEMBER 2017 - PRESENT

Oracle 12c Fundamentals

Oracle