 Supporting quality Engineering for data analysis, data cleansing and data format requirement for Oracle Fusion application. Writing, tuning and executing complex SQL queries to perform analysis on large data sets as to report on data issues to development and business teams. Writing PL/SQL procedures, packages, view, analytical functions for the successful implementation of data validation scripts. Identifying and reporting data sets violating the business rules to the appropriate data groups to resolve data integration issues. Testing ETL process for performance and performed data quality after the load process at the source and target data. Created and implemented test plans and test cases to support functional and analytic testing  Designed and implemented automated regression testing, negative testing, boundary and error handling testing, and UI testing with Synergy Developed, configured and executed security test scenarios with HP WebInspect  Performed OS certification system testing  Identified and analyzed performance issues with APC-MDO and APC-RO  Performed various basic QA tasks: filed and monitored bug reports, documented test results, escalated high alert defects as needed, and reviewed software documentation to ensure technical accuracy and compliance

 Performed data cleansing, and validation to support automated daily data loads for MDO. Utilized SQL*Loader to load data from flat files (containing historic and weekly data) for large data sets (approx 4TB). Performed basic data analysis to conform the quality of the data after staging them in staging tables and worked with customer data team in fixing the data. Performed SQL query optimization to improve performance for custom report queries. Used the concepts of partitioning of tables, bulk collect, materialized views and dynamic SQL for performance improvement. Developed several UNIX shell scripts for pre and post processing of custom implementations. Met with clients to obtain data specification formats required for custom configuration changes for MDO. Deployed and configured Web logic application servers, installed and applied back-end and front-end and front-end host fixes for MDO using SQL, PL/SQL.

 Supported, maintained and executed ETL (written in Java) for the Analytical Services group Wrote SQL*Loader control files and UNIX scripts to load and spool large data sets (approx 4TB) Developed PL/SQL scripts to perform post-ETL data validation Optimized performance of ETL processes by tuning queries and leveraging Unix parallel processes  Converted and migrated schemas across different versions of the Oracle database (e.g. facilitated an Oracle9i to Oracle10g schema upgrade) Managed application servers and storage for the Analytical Services group  Wrote and tuned several SQL queries to help analysts and scientists access historic data marts efficiently

 Analyzed new requirements based on business processes. Planed, designed and developed the entire computerized system for the facilities. Wrote custom report with SQL analytical functions. Exported data following requirements of insurance company for audit. Implemented and customized Medinotes and Medisoft Network healthcare software on Windows Server 2003 with Advantage Database Server (Sybase database) and Acrendo, medical application on Windows Server 2011 with Microsoft SQL Server. Implemented, deployed and documented daily back-up and disaster recovery system.  Migrate and update Windows workstation, Windows server to the most recent and stable release. Maintained and support network performance and secure Vpn access. Trained and support End users applications.  Troubleshooting and configure network printers. Customized scripts for the management billing and accounting system using SQL queries and PL/SQL code blocks.