Vishnuprakash R Email & Phone Number

Chennai, Tamil Nadu, India

Chennai, Tamil Nadu, India

New Jersey, United States

• Played major role in data migration from legacy systems to oracle 12c from different sources of data like MS Access, IBM Mainframe and flat files
• Demonstrated skills in optimising reports that considerably reduced the report generation time
• DBA role in creating users, table spaces, providing privileges, Creating DB scripts and Implementation in higher environments.
• Interacting with users for system study, requirements gathering, analysis & testing of system and overseeing smooth implementation of the application
• Brain storm discussions with team members to ensure smooth progress of project work
• Coordinating with client DBAs at the times of project implementation, storage, allocation, creating new schemas & database related issues

Dubai, UAE

• Proved resolving critical production incidents effectively under 24x7 work environment
• Design, develop and maintain an Oracle database schema, tables, standard views, materialized views, synonyms, and other database objects.
• Implemented constraints, triggers, sequences as per the business logic
• Extensively analyzed queries and created unique indexes, non-unique indexes, Documenting system delivery specification including functional and non-functional requirements based on User requirement Specification
• Proved skills in complex data migration activities using Informatica workflows and DBMS schedulers/jobs from legacy system
• Automated Email reports/dashboards using Oracle Inbuilt UTL_SMTP packages

United Arab Emirates

• Credited for essaying a pivotal role in the Fare auditing and Pricing MIS reports for Emirates Airlines
• Proactively created automated programs to reduce man days' effort, conducted gap analysis in early stages & designed process flow diagrams
• Extensively used Analytical functions and object types for complex drill down reports
• Initiated R&D phase to measure scalability in different databases like oracle 12c RAC and Cassandra
• Data analysis with Twitter using R program
• Integration of oracle database with R Program

Chennai Area, India

• Got appreciation by clients from the UK for the stellar role in performance tuning and enhancements in the project of postgraduatesearch.com
• Improved in the response time of the websites and ensured 80% of the pages load within 1 second and 95% of the pages load within 2 seconds
• Initiated the usage of Advanced Oracle concepts like analytical functions and object types that resulted in performance improvisation
• Conducted regular on call discussions with On-site Team and updated status of the projects & any deviation in the proposed plan
• Attended External training on implementing oracle text and search engine optimization and shared the knowledge with the team members
• Search functionality using Oracle Text for efficient performance