Vikas Srivastava

• Leading the database development and optimization for regulatory solutions in the pharmaceutical domain.
• Designing and reviewing PL/SQL packages, procedures, and triggers for critical modules.
• Collaborating with cross-functional teams (DevOps, QA, Product) to streamline release pipelines and improve DB performance.
• Mentoring a team of 5+ developers, ensuring adherence to coding standards and best practices.
• Conducting code reviews, query optimizations, and performance benchmarking across multiple projects.
• Responsible for resolving production issues, providing RCA and implementing corrective actions.
  
  
  
  
  
  
  
  

• Developed and maintained Oracle PL/SQL code for in-house marketing analytics product.
• Automated file processing and data load workflows using Unix shell scripts and crontab.
• Tuned complex queries to improve report generation and dashboard performance.
• Involved in production support, bug fixing, and enhancement implementation.

Myer Pty Ltd, Australia ( January-2013 to June 2018 )

Myer is an oldest retail chain in Australia. Popular mainly for its fashion brands.

I have worked as a part of CIW (Customer Information Warehouse) team. It is a data repository for all sales transactions and customer details on Oracle DB. Sales and Customer data being used to target customer for marketing and reporting for higher management and end business users.

Direct interaction with client. Client Focal for IBM and IBM Focal for client.

My tasks involved writing PL/SQL and SQL queries and optimize them

Johnson & Johnson, USA ( July 2018 to September 2018)

Involved with the development of various DB objects, gathering requirements from client. Project was starting from scratch. Developing ETL system viz. SQL*Loader, Control File, Defining batch flow. Writing SQL queries for business requirements.

Shop Direct Group, UK ( October-2018 to present )

Shop Direct Group is a client for IBM India, I am working on Oracle PL/SQL 11g, Development of PL/SQL packages, procedures, using trigger, cursor, and various objects. Involved in daily scrum call for providing latest update on defects fix and development tasks. I have also designed SQL queries to get data for client.

Developed DRI ( Daily Reporting Interface ) system, it checks batch status viz. start / end time and success failures of the jobs then updates a web page, which can be accessed from any PC or mobile device, such that users / client don't need to wait for updates on any glitches on the system. Such that they can plan their day accordingly. We are updating them as soon as they start their day.