• Schema Design for NOSQL database (mongodb). Developed mappings using the Mongodb connector, java transformation for inserting records in batch to Mongo database. Designed queries for retrieving data from Mongo.• Application DBA for Corporate Services. Worked on development of stored procedures and triggers, performance tuning of SQLs using large tables, logical/physical data modelling using ERWIN, production support. Redesigned and implemented the import process for stock options using PERL. • Application DBA for Schwab Institutional. Worked on application support for Schwab Advisor Network, applications using SQL server, production support, performance tuning, development of shell scripts.• Application DBA for eCommunications. Worked on redesigning the eCommunications database, development of stored procedures and triggers for database redesign, logical/physical data modelling using ERWIN, production support for different applications, performance tuning of SQLs accessing large tables, development of PERL/shell scripts. Handled several database upgrades and migration to a RAC environment.• Designed and developed analytical reports using Tableau.• Designed and developed complex mappings, workflows using Informatica involving XML processing, flat files, reading from relational sources such as Oracle, SQL server, Teradata, writing to relational sources such as Oracle, invoking web services for triggering emails using Strongview, data integration with Salesforce.• Performance tuning of workflows accessing data from Oracle/Teradata.
Listed skills include Informatica, Oracle, Pl/Sql, Data Modeling, and 14 others.