Vivek Ranjan Email and Phone Number

• 7 years of experience in SQL, PL/SQL, T-SQL, SSIS and Shell scripting. Proficient in developing optimized database solutions, writing efficient queries, and creating robust ETL processes. • Has 5 Years of hands on experience with Azure data factory, Azure Data lake, Blob storage.• Successfully developed and implemented multiple Azure Data Factory pipelines to streamline the cleansing, transformation, and ingestion of customer data.• Collected data in Azure Data Lake Storage and transformed the data later by using an Azure Synapse Analytics compute service..• Proficient in integrating Power BI with different data sources including cloud data sources for seamless data analytics and reporting.• Extensive expertise in data warehouse concepts and a proven track record in designing and implementing robust Datawarehouse solutions in Oracle, SQL Server and Snowflake.• Hands on experience in developing complex SQL queries and performance tuning.• Has hands-on experience of developing and managing projects from ORACLE, SQL SERVER, SSIS and Microsoft Azure.• Has developed Complex stored procedure, views, materialized views and Triggers.• Effectively used Table functions, Indexes, Table Partitioning, Collections, Analytical functions.• Has experience with data flow diagrams, Data dictionary, database normalization technique, and data modelling.• Experience with all stages of the SDLC using different Software development methodologies like Agile, Scrum, Lean etc. right from the requirement gathering to development, deployment, Testing and production support.• Has worked with giants clients like BNP Paribas Bank, Deutsche Bank, Hewlett Packard, Oracle, Cargill, IQVIA, HP Enterprise, LV= and MTN hence has good understanding of various domains like Retail Banking and financial services, Sales & Compensation, Enterprise database solutions, Agriculture & Food chain Industry, Medical devices and healthcare industry and Telecom.• Oracle Certified Associate, Competent Communicator (By Toast Master International)