• Conduct multiple discovery sessions with diverse client teams to gather project requirements.• Analyze different user requirements and comes up with specifications for the various database applications.• Develop, implement and share viable automated solutions using dynamic stored procedures, views and other application related database objects with encryption.• Tuned and optimized queries by altering database design, analyzing different query options and indexing strategies.• Assisted the testing team in preparing the test cases and validation of data for quality testing and assurance purpose.• Maintained MYSQL scripts indexes and complex queries for analysis and extraction.• Worked in cross functional environment, multiple stakeholders including project managers, developers, and testing teams across units to identify business needs and adapt effective solutions.• Ensured best practice to follow to maintain security and integrity of data.

• Performed Quality check on data by making different Sql queries• Automate the file uploading, data extraction, table updates, drop etc processes using SSIS Packages• Redesigned month-end reporting process, reducing time from days to hours to maintain and generate reporting for internal and external business partners.• Design and co-ordinate test projects, taking up the calibration meeting with different teams.• Collaborate with internal business units and clients.• Mentor and coach new members of the team• Assessed QA performance – Retrieved and analyzed QA information to identify root causes of performance gaps and other QA problems.• Designed quality regulations and evaluations based on monitoring of data flow.• Create Views, Cursor, Indexes, Procedures, Triggers, joins, etc.• Effectively worked, managed and completed multiple projects within deadlines along with adhoc projects.

• Generate the expense report, estimate expense report, port/marine calculated cost and month end report for clients on with oracle database support• Worked on SQL DDL & DML both queries• Fine-tune and optimized SQL queries• Extract data from data warehouse as per business user requirement• Created PL/SQL procedures which were used to integrate the existing data from third parties• Planning and implementing capacity expansion in order to ensure that the company’s databases are scalable• Identify issues with the database and resolve issues like database access and checking on performance issues• Clarify any issues and queries on emails with vessel planner in Europe.