Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic

Rohan Dhamecha

Vadodara

Summary

Dynamic consultant with a proven track record at Infosys Ltd, specializing in data warehouse solutions and ETL processes using Azure Data Factory. Adept at leading teams and enhancing user experiences through AI chatbots. Proficient in .NET technologies and Agile methodologies, delivering high-quality results while fostering effective collaboration.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Consultant

Infosys Ltd
10.2021 - Current
  • Experienced in building data warehouse solutions, including ETL processes with Azure Data Factory and data storage in Azure SQL Server.
  • Utilized Azure Data Lake's capabilities to efficiently store large files with significant compression.
  • Developed data warehouse solutions using Star and Snowflake schemas, creating dimension and fact tables, and performing complex data processing with PL/SQL.
  • Built system integrations using Azure Service Bus for asynchronous communication and Azure Functions (developed in .NET Core) for event-driven processing.
  • Created AI chatbots to enhance user experience by providing instant Q&A support and automating support ticket creation based on user interactions.
  • My consulting experience includes leading development teams, actively participating in development activities, and ensuring timely project delivery while maintaining the highest quality standards.
  • My experience covers the entire project lifecycle, from initial requirements gathering and planning to ongoing client and management communication, and effective cross-team coordination.

Software Engineer

Healthcare Informatics Pvt Ltd
06.2018 - 10.2021
  • Company Overview: HIPL is product based software company which build software for healthcare domain like Electronic Health Record, Patient portal etc
  • Build and extend website capabilities using Angular JS on the client-side and .NET Framework Web API on the server-side.
  • Also have hands-on experience with ASP.NET website development and continuous maintenance.
  • Implement data access within the Web API using Entity Framework and LINQ for efficient SQL database querying and manipulation.
  • Ability to create PL/SQL stored procedures and functions that handle complex CRUD operations and business logic.
  • Create and maintain Windows applications, implementing new features and improvements with .NET Framework, C#, VB.NET, class libraries, and SQL.
  • I produce clean, efficient, and maintainable code by adhering to established design patterns and SOLID principles.
  • Work on creation of Web Service using .NET Framework along with WCF and Windows Service.
  • I have experience working within agile teams, and am familiar with the ceremonies like stand ups, sprint planning, and retrospectives.
  • HIPL is product based software company which build software for healthcare domain like Electronic Health Record, Patient portal etc

Education

Bachelor of Engineering - Computer Science & Engineering

The Maharaja Sayajirao University of Baorda
Vadodara, Gujarat
05.2018

Skills

  • NET Framework and Core
  • C# and VBNET
  • SQL and PL/SQL
  • Azure Data Factory and Data Lake
  • Web services and APIs
  • AngularJS and HTML
  • Entity Framework and LINQ
  • ETL processes
  • Azure Functions and Logic Apps
  • Power BI and Virtual Agent
  • Power Automate workflows
  • Agile methodology practices
  • Unit testing strategies
  • Azure DevOps and TFS

Certification

  • PL-900 - Microsoft Certified: Power Platform Fundamentals, 01/01/22 - Present
  • DP-900 Microsoft Certified: Azure Data Fundamentals, 03/01/24 - Present
  • PL-100 Microsoft Certified: Power Platform App Maker Associate, 04/01/22 - Present

Accomplishments

  • Infosys Insta Award (09/2024) - I have been awarded to recognise that Rohan has done an excellent job in optimising ADF pipelines in the CDW project He is actively contributing to helping other team members fix technical issues Keep up the good work."
  • Infosys Insta Award (10/2022) - awarded to recognise Rohan as technically strong and a valuable member of the team, apart from his own deliverables, he guides other team members technically, I really appreciate all the hard work he has put into this project
  • Infosys Insta Award (03/2022) - Awarded for 'Being new to Infosys and technology, Rohan displayed great acumen in picking up technology and handling the client Kudos for the work, and best wishes for the future

Timeline

Consultant

Infosys Ltd
10.2021 - Current

Software Engineer

Healthcare Informatics Pvt Ltd
06.2018 - 10.2021

Bachelor of Engineering - Computer Science & Engineering

The Maharaja Sayajirao University of Baorda
Rohan Dhamecha