Oracle Developer
2018 - 2019AT&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, OracleTrading Platform Maintenance
2018 - 2019Conspecta 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), MacrosIT Analyst
2011 - 2013Citi 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, OracleOracle Developer
2008 - 2011Bank 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
Valliammai Sundaram
Tableau Developer in Culver City, CA, United States
Member since November 23, 2017
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.
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
Full-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.
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
- 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.
Skills
Languages
SQL, Excel VBA, Visual Basic for Applications (VBA), JavaScript, Python, JavaPlatforms
Oracle, Linux, Unix, iOSStorage
PL/SQL, Oracle PL/SQL, MySQL, SQLiteOther
Excel Macro, Google BigQuery, Macros, Machine Learning, Electronics Engineering, Excel Macros, Regression Modeling, Data StructuresTools
Autosys, Tableau Desktop Pro, Tableau, Cron, Microsoft Excel, GitParadigms
ETL
Education
- Master of Science Degree in Data Science2021 - 2021University of West Florida - Florida, USA
- Bachelor of Engineering Degree in Electrical and Electronics Engineering2004 - 2008Thiagarajar College of Engineering - Madurai, India
Certifications
- Oracle 12c FundamentalsDECEMBER 2017 - PRESENTOracle
