Oracle Developer
2018 - 2019AT&T- Worked closely with the databases and other back-end systems.
- Supported the compensation system which compensated the dealers.
- Created testing strategies to ensure quality. Reviewed the test cases to make sure it aligns with the business requirements.
- Involved in identifying the poor performance areas and worked on process improvement.
- Mentored the offshore team and encouraged teamwork.
- Was a part of creating charts/reports using Tableau to help the business team.
Technologies: Tableau, Autosys, Unix, PL/SQL, SQL, OracleTrading Platform Maintenance
2018 - 2019Conspecta Capital (via Toptal)- Debugged macro code and fixed the broken links. This helped the application to run in production.
- Added new functionalities to improve the application.
- Improved the run time by deleting unwanted processes.
Technologies: Visual Basic for Applications (VBA), MacrosIT Analyst
2011 - 2013Citi Bank via Tata Consultancy Services- Led the application team, CITI Client first in developing a collections application for CITI Bank.
- Supported the back-end of CITI Client First Application of CITI Bank.
Technologies: Excel VBA, Autosys, Unix, OracleOracle Developer
2008 - 2011Bank of America Tata Consultancy Services- Created the backed of 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 to 10 minutes from 2 hours.
- Proposed and automated the process of running test scripts from Excel directly in Oracle as a process improvement for Merrill Lynch.
Technologies: Autosys, Unix, Oracle PL/SQL, Oracle
Valliammai Sundaram
Tableau Developer in Culver City, CA, United States
Member since August 12, 2017
Villiammai has nearly ten years of experience specializing in SQL, Oracle, and PL/SQL. With her degree in electrical and electronics engineering, she enjoys building applications for clients of all sizes. Villiammai is currently located in Los Angeles, CA, and enjoys working with global teams.
Valliammai is now available for hire
Portfolio
- AT&TTableau, Autosys, Unix, PL/SQL, SQL, Oracle
- Conspecta Capital (via Toptal)Visual Basic for Applications (VBA), Macros
- Citi Bank via Tata Consultancy ServicesExcel VBA, Autosys, Unix, Oracle
Experience
- PL/SQL 8 years
- SQL 8 years
- Excel Macros 8 years
- Microsoft Excel 8 years
- Oracle 8 years
- Unix 5 years
- Autosys 5 years
- Cron 1 year
Availability
Part-time
Preferred Environment
MySQL, SQLite, Unix, Linux, Oracle
The most amazing...
...thing I have coded is a PL/SQL script that can update values of XML data when the XML tag name is given.
Employment
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 Overflowhttps://stackoverflow.com/users/2524830/valli
I love to solve technical problems, and I have learned a lot as an active member.
- Active Member with Hacker Rankhttps://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
Skills
Languages
SQL, Excel VBA, Visual Basic for Applications (VBA), JavaScriptPlatforms
Oracle, Linux, Unix, iOSStorage
PL/SQL, Oracle PL/SQL, MySQL, SQLiteOther
Excel Macro, Google BigQuery, Macros, Machine Learning, Electronics Engineering, Excel MacrosTools
Autosys, Tableau Desktop Pro, Tableau, Cron, Microsoft Excel, Git
Education
- Master's Degree in Data Science2021 - 2021University of West Florida - Florida
- Bachelor of Engineering Degree in Electrical and Electronics Engineering2004 - 2008Thiagarajar College of Engineering - Madurai, India
