java applications, database development and administration, project scoping and managementCreate an IT security strategy, configure oracle auditing and setup and audit reports. Maintain user roles and access, and troubleshooting of oracle applications. Train users on application security and guidelines. Wrote stored procedure to collect data using a cursor from the staging layer to the ODS layer and into the data mart to be stored as the master record. Acted as onsite coordinator for an offshore team of 2 members. This involved task planning and documentation, Issue resolution, development tracking and UAT before code submission to VSS.-Worked on Database Design (tables and referential integrity) from the ground up, created a high-level database design document by interacting with business team.
Database development, maintenance, production support-Query and application performance and tuning, ad-hoc requests etc. Successfully implemented Data Warehouse built all components for a flip schema mechanism by creating synonyms and granting the right privileges. -Schema creation, user ID management, roles and privileges, oracle parameter setup, oracle directories, synonyms, server monitoring, -Performed production support identified issues and resolutions. -Used Er/Win to design structures and Meta data in the logical model and generated physical model. -Created partitions using Er/Win in the logical model, generated script to be run in the physical model. -Developed complex stored procedures to load data from external feed to staging and ODS layers. -Unix data pump loads to export and import data and Meta data, writing procedures and -functions, testing queries for data quality. -Performed unit, regression and performance testing.
