PARAS

 

 

 

 

 

 

 

PROFESSIONAL SUMMARY

Proficient senior data engineer with 6 years of experience in crafting dynamic data pipelines, Snowflake ,Data warehousing, Dbt ,ETL ,Python and various tools. Proven ability in orchestrating end-to-end project management, adept at leading teams towards successful project delivery.

Committed to continuous skill enhancement and dedicated to leveraging expertise to deliver resilient solutions that drive innovation within the IT industry.

 

 

EXPERIENCE

MAY 2023 TO PRESENT

 

SR.DATA ENGINEER, Confidential.

• Successfully managed the Snowflake data warehousing project with integration of multiplethird-partytoolsandvariousdatasources.Buildtheoptimizedtransformation pipelines in Dbt
• Successfully led and executed a comprehensive data migration project, proficiently migrating data from SQL Server to Snowflake. Additionally, played a pivotal role in transitioningETLprocesses,seamlesslymovingfromInformaticatodbt,demonstrating expertiseinmodernizingdatainfrastructureandensuringoptimalsystemperformance
• Spearheaded the optimization of data transformation processes by transitioning from Informaticatodbt,resultinginasignificantreductioninprocessingtimeandimproved data quality

 

JUNE 2021 TO MAY 2023

 

SR. DATA ENGINEER , Confidential.

• Designedthearchitecturalplanfornewsystemacquisitions,createdandmanagedthe structures and ETL pipelines for the different database layers as Staging, Business and Reporting.
• DesignedandimplementedscalabledatasolutionsleveragingSnowflake'sclouddata platform, optimizing data warehousing architecture for improved performance and efficiency
• Developed and maintained ETL pipelines in Azure data factory using Snowflake's native featuresandintegrations,ensuringseamlessdataingestion,transformation,andloading processes
• DevelopedandmanagedthepythonscriptsandstoredproceduresforvariousETLtasks.

 

AUGUST 2018 TO JUNE 2021

 

DATA ENGINEER, Confidential

• DevelopedtheSQLqueriesforExportingthedatafromoneEHRsoftware,Transforming the exported data to make it compatible with our EHR software and Loading the transformed data to our EHR Software
• Developed the customized reports as per the client’s requirements to visualize and analyzethedata.HaveexperienceinthevariousdatavisualizationtoolslikePowerBI, Google data studio, and Jaspersoft
• EngineeredPythonscriptstoautomatedatapipelinecreation,facilitatingseamless extraction of data from diverse client servers. Transformed retrieved data into standardized formats for centralized reporting and tracking on our server

 

 

 

EDUCATION

2015 TO 2019

COMPUTER ENGINEERING ,LDRP- ITR GANDHINAGAR

 

 

 

SKILLS, CERTIFICATIONS & ACHIVEMENTS

TECHNICAL

• SQL(MySql, Postgres, SQL Server, Sybase, Snowflake),ETL
• Python(Basics ,Pandas ,Openpyxl ,Recordlinkage)
• Azure(ADF ,Blob),AWS(Lambda,cloudwatch,S3)
• Web Scraping(Beautiful Soup),Web Automation(Selenium)
• Dbt ,Pentaho, Informatica
• SSRS, Google data studio

EXTRA

• Project planning and management
• Due to regular meeting with U.S based clients, having decent communication skill
• Having 60 WPM typing speed with 97% accuracy

CERTIFICATIONS

• SnowflakeSnowProCoreCertification
• DbtAnalyticsEngineeringCertification
• MicrosoftCertified:AzureFundamentals(AZ-900)

ACHIVEMENTS

• Got the key contributor award for2022-Q1
• Received the appreciations from multiple clients for going to extra mile and putting more than satisfactory efforts to the project
• Got the opportunity to provide SQL training to batchof30newemployees