Dev Bharat Doshi Email & Phone Number

Melbourne, Victoria, Australia

Melbourne, Victoria, Australia

Melbourne, Victoria, Australia

• Created real-time data pipeline using SSIS, PowerShell, C#, and SQL to ingest and transform over 65 million records from 3 sources. • Owner and developer of an internal resourcing dashboard with >165 active monthly users. I created a dashboard for senior leadership to get a comprehensive view of the company's resource utilization. This dashboard is planned for a firm-wide release to >3000 users.• Deliver robust data engineering solutions tailored to each project's data… Show more • Created real-time data pipeline using SSIS, PowerShell, C#, and SQL to ingest and transform over 65 million records from 3 sources. • Owner and developer of an internal resourcing dashboard with >165 active monthly users. I created a dashboard for senior leadership to get a comprehensive view of the company's resource utilization. This dashboard is planned for a firm-wide release to >3000 users.• Deliver robust data engineering solutions tailored to each project's data volume, complexity, and specific client requirements. Show less

Melbourne, Victoria, Australia

• Automated reporting for a major Australian bank, resulting in clients saving ~$4.6 million. • Led the development of 5 ETL pipeline to ingest data into a SQL data warehouse. Created pipeline audit tables to store data such as pipeline run duration, start time, number of processed rows, number of updated records, source file name, etc. to maintain an audit trail of pipeline runs. • Design, develop and optimize Power BI reports that support engagement operations across the… Show more • Automated reporting for a major Australian bank, resulting in clients saving ~$4.6 million. • Led the development of 5 ETL pipeline to ingest data into a SQL data warehouse. Created pipeline audit tables to store data such as pipeline run duration, start time, number of processed rows, number of updated records, source file name, etc. to maintain an audit trail of pipeline runs. • Design, develop and optimize Power BI reports that support engagement operations across the project lifecycle. • Developed SSIS package with C# tasks to extract more than 18,000 SSRS reports into separate Excel files for data repatriation to a major Australian bank. Show less

Melbourne, Victoria, Australia

• Created automated processes to move over 4 million records from source to a database, reducing manual work and human errors.• Optimized SQL stored procedures, resulting in cutting data update time from ~3 hours to ~40 minutes.• Used Power BI to show pipeline performance to senior stakeholders, leading to discussions on optimizing pipelines.

Melbourne, Victoria, Australia

• Utilized Python and Selenium to perform web scraping and extract relevant data from multiple websites.• Developed and maintained efficient web crawlers to automate the data extraction process.• Implemented data cleaning and transformation techniques to ensure the accuracy and quality of the extracted data.• Integrated the web scraping and data processing pipelines to create a streamlined data engineering workflow.

Melbourne, Victoria, Australia

• Extracted and pre-processed (cleaning, manipulation) data for statistical and time series analysis.• Conducted regular meetings with supervisors to present insights.• Created a research proposal and research report of the project.

Ahmedabad, Gujarat, India

• Developed user interfaces with modern .NET frameworks, HTML5 and CSS3.• Collaborated with product managers, testers, and developers to initiate process improvements.• Troubleshot and debugged code to ensure compatibility with devices.• Supported database development by ensuring data quality and ETL.

Cairo, Egypt

• Supported a team of designers, developers and business analysts to design and setup a website which would allow users to sell used products for recycling in exchange of points, and use those points to buy recycled products from the shopping page.

Ahmedabad, Gujarat, India

• Conducted regular meetings with key business users to collect information on business and userrequirements.• Assigned tasks to development team and updated all involved parties to enhance optimal business flow.• Created supporting documents and reports to facilitate project development and evaluation of team performance.

Master Of Analytics, Data Analytics

Data Preprocessing, Database Concepts, Statistical Computing, Machine Learning, Data Visualization, Time Series Analysis, Business.

Bachelor Of Computer Applications, Information Technology, Distinction

Activities and Societies: Soccer Team Player, Theater Participant, Music and Dance Participant, Star Student Batch 2016 Application.