Shailesh Solanki

Shailesh Solanki Email and Phone Number

Senior Consultant @ IQVIA
Bengaluru, KA, IN
Shailesh Solanki's Location
Bengaluru, Karnataka, India, India
About Shailesh Solanki

• Over 14 years of IT experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).• Strong experience in Oracle SQL, Data warehouse concepts, ETL.• Data integration and migration experience in leading the conversion of multiple legacy data systems from different sources into Oracle databases. • Developed Complex database objects like Stored Procedures, Functions, Packages using SQL and PL/SQL.• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.• Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE.• Created and modified severa

Shailesh Solanki's Current Company Details
IQVIA

Iqvia

View
Senior Consultant
Bengaluru, KA, IN
Shailesh Solanki Work Experience Details
  • Iqvia
    Senior Consultant
    Iqvia
    Bengaluru, Ka, In
  • Iqvia
    Senior Consultant
    Iqvia Oct 2022 - Present
    Project: Oracle Argus Consultant, Pharmacovigilance• Expertise includes working with following Oracle technologies: PLSQL experience in procedures, Functions, Packages, Cursor, Exceptions and Triggers for Oracle Argus Safety Database.• Techno-functional Consultant with deep understanding of technical and functional aspects of PV Safety systems.• Requirements gathering and analysis for safety system configuration, migration and reporting• Authoring and accountability of document deliverables (requirement and specification documents, IQ, OQ, PQ) and Design, build and implement system configuration for clients.• Author, execute test scripts and manage test execution and issue tracking.• Closely work with clients and vendors to support implementation and resolve product issues A Subject Matter Expert (SME) in Drug Safety Systems - Oracle Argus Safety.• Handling the routing of E2B reports in Argus Safety
  • Ibm
    Lead Data Engineer
    Ibm Mar 2013 - Oct 2022
    Noida Area, India
    Created PL/SQL stored procedures, functions and packages for moving the data from staging area to target DB.• Created scripts to create new tables, views, queries for new enhancement in the application using Oracle SQL Developer.• Created indexes on the tables for faster retrieval of the data to enhance database performance.• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Tech Mahindra
    Technical Associate: At&T Billing
    Tech Mahindra May 2011 - Mar 2013
    • Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.• Partitioned the fact tables and materialized views to enhance the performance.• Extensively used bulk collection in PL/SQL objects for improving the performing.
  • Amdocs
    Senior Subject Matter Expert (Development)
    Amdocs Feb 2008 - Oct 2010
    • Created and maintained PL/SQL scripts and stored procedures.• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures.• Created and modified SQLPlus, PL/SQL and SQL Loader scripts for data conversions
  • Cognizant
    Programmer Analyst
    Cognizant Feb 2007 - Mar 2008
    • Developed web-based dashboard applications for monitoring the server related statistics using charts to enable analysts to perform targeted customer analysis.• Analysis, design, development and implementation of customized solutions for new implementations.

Shailesh Solanki Education Details

Frequently Asked Questions about Shailesh Solanki

What company does Shailesh Solanki work for?

Shailesh Solanki works for Iqvia

What is Shailesh Solanki's role at the current company?

Shailesh Solanki's current role is Senior Consultant.

What schools did Shailesh Solanki attend?

Shailesh Solanki attended Jaypee University Of Information Technology, X Dav Public School, Sahibabad, Xii Dav Public School, Sahibabad.

Not the Shailesh Solanki you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.