Scroll To View More
Seetha Venkatadri, SQL Developer in Menlo Park, CA, United States
Seetha Venkatadri

SQL Developer in Menlo Park, CA, United States

Member since March 3, 2017
Seetha is a database developer with over 6 years of industry experience. She has successfully completed and delivered several database projects for multiple clients—on time and exceeding expectations. Having worked in different domains such as banking, insurance, and consumer goods, she has experience in handling development, enhancement, and migration projects. She is also an Oracle certified SQL and PL/SQL expert.
Seetha is now available for hire

Portfolio

Experience

  • SQL, 6 years
  • Toad, 6 years
  • Oracle PL/SQL, 6 years
  • Unix Shell Scripting, 5 years
  • Linux, 5 years
  • SQL Performance, 3 years
  • MySQL, 2 years
  • Oracle SQL Data Modeler, 2 years
Menlo Park, CA, United States

Availability

Part-time

Preferred Environment

Oracle, Linux, Tortoise SVN, MySQL

The most amazing...

...thing that I have coded is an employee search engine for UBI Banca.

Employment

  • Lead Database Developer

    2013 - 2016
    UBI Banca, Italy (via Accenture)
    • Led the database team handling multiple work requests contributing to the development and enhancements of 6 key bank applications: HR-Balance, Anagrafe-Prospect, IWB Migration, CRM Contact History, CRM In Action, and GeMo Migration.
    • Performed overall work flow management for the database team using Rational ClearQuest.
    • Suggested code review and version control tools to the client team to improve code quality.
    • Trained entry-level engineers as part of Accenture's development initiatives.
    Technologies: Oracle PL/SQL, Shell Scripting, MySQL
  • Senior Database Developer

    2012 - 2013
    Centrica, UK (via Cognizant Technology Solutions)
    • Worked on a project that involved a WMIS database upgrade; ported Pro*C, Perl, shell scripts, and SQL scripts from Solaris to Linux and Oracle 9i to Oracle 11g respectively.
    • Led a team of engineers in identifying migration issues and debugging the defects.
    • Performed estimation, planning, and task allocation for the project.
    • Supported user acceptance testing.
    Technologies: Oracle PL/SQL, Shell Scripting
  • Database Developer

    2011 - 2012
    Avon, Brazil (via Cognizant Technology Solutions)
    • Worked on the project called ASLCP Pre-Rezoning which involved the implementation of pre-rezoning logic in PL/SQL from Java. I also worked on the changes to the physical data model using Erwin.
    • Refreshed the ARRM hardware which involved the migration of scripts and unit testing; I delivered it with zero defects.
    Technologies: Oracle 10g, Linux
  • Programmer Analyst

    2011 - 2011
    Comcast, USA (via Cognizant Technology Solutions)
    • Worked on commercial workbench reports which involved converting FoxPro code to Oracle SQL queries for reporting order cancellations and pending orders.
    • Conducted query tuning using explanation plans.
    Technologies: Oracle 10g
  • Programmer Analyst Trainee

    2010 - 2011
    Emdeon Inc., USA (via Cognizant Technology Solutions)
    • Worked on advanced claiming and a real-time payment gateway. I contributed to data loading, benefit building for 4010, Minnesota and 5010 payers, FER service, data enhancement service, and data loading.
    • Tuned data enhancement queries for optimal performance bringing down the response time from 20 minutes to 7 seconds.
    • Prepared and tested deployment scripts for a testing environment.
    Technologies: Oracle 10g, Linux

Experience

  • HR Balance for UBI Banca (Development)

    I developed the database and back-end logic for this employee assessment tool for the bank. I also developed the search engine for finding the best-fit employee for an open position based on their assessment history.

  • GeMo Migration for UBI Banca (Development)

    As the lead database developer, I was responsible for the estimation, implementation, and overall delivery of this critical and complex migration project involving the migration of stored procedures, functions, views, materialized views, shell scripts, and stand-alone application queries. I managed a team of 4 database developers—guided them so that they understood the requirements and accomplished their tasks under strict deadlines.

  • Anagrafe Prospect for UBI Banca (Development)

    I implemented the prospect customer creation process (census). I also developed data-loading procedures, contact validation (Recapiti Validazione), and address normalization involving web service calls (UTL_HTTP), file handling, and XML extraction. I created extensive error handling and logging methods using exception handling and autonomous transactions for the entire application. This project also involved a geolocalization feature for the bank’s website for which I developed a stored procedure invoking Google web services.

  • CRM Contact History (Development)

    I worked on creating database objects for the customer contact history management involving procedures, functions, and sequences. I created batch jobs to establish the communication between the contact history database and the data warehouse of the bank (InSight) and the transaction database (InAction)—using external tables, XML parsing, and MERGE statements.

  • IWBank Migration (Development)

    IWBank is one of the banks in the UBI banking group. I implemented a data replication solution using triggers and the Oracle Advanced Queuing where I created DML triggers, source queues, and queue tables along with the queue procedure.

Skills

  • Languages

    SQL, C, Python
  • Tools

    MySQL Workbench, PuTTY, Toad, Erwin, Oracle SQL Data Modeler, TortoiseSVN, Git
  • Storage

    SQL Developer, Oracle PL/SQL, SQL Performance, Oracle 10g, Oracle 11g, Oracle 12c, MySQL
  • Other

    Unix Shell Scripting, Data Modeling, Estimations
  • Platforms

    Linux, Unix, Windows

Education

  • Bachelor of Technology in Information Technology
    2005 - 2009
    Anna University - Chennai, India
I really like this profile
Share it with others