Harsh Joshi Email & Phone Number

Canada

- Design systems with new services, cron jobs, kafka consumers & producers in a distributed microservices environment - Use technologies like Java and Python for development- Write efficient code and write tests (unit tests, integration tests, smoke test & performance tests)- Write Jenkins pipelines and deploy to kubernetes- Maintain and monitor services using tools Datadog, New Relic, Grafana

Oakville, Ontario, Canada

• Develop integrations to perform extract, transform and load between financial systems and Questica budgeting application. Integrations involve working with different database systems and multiple file types like JSON, XML, and CSV. • Write complex SQL queries and develop reports in Power BI and SSRS.• Performance tuning of SQL queries and databases.

Markham

Fraud Reporting – Dashboard Development Project with PRESTO: PRESTO is required to keep track of the activities by visualizing the trends in Power BI which could be indicative of fraud. Responsibilities were:▪ Perform data analysis using SQL on data-warehouse and create models for Power BI▪ Create Power BI dashboards for fraud analytics. ▪ Writing complex SQL queries to perform data analysis and collaborating with the development team to build the dashboards.Data Migration Project with TD bank:TD Bank is required to migrate the petabytes scale of data from their 1000+ applications to a central Hadoop ecosystem which was previously been migrated to smaller data warehouses. Responsibilities were:◦ Perform data analysis using PySpark library with Python◦ Build metrics in Hive using HQL◦ Validating expectations on data structure, meaningful metadata, data profiles, reference data, and source-specific metrics◦ Validating how systems link internally and externally from a business perspective◦ Applying data security standards for data governance◦ Supporting definition of atomic and compound data quality rules◦ Communicating with cross-functional business and technical teams to gather information◦ Categorizing information entities by data governance classifications and retention schedules

Ahmedabad Area, India

• Transactional data was huge and the structure of the database was designed to serve the purpose of both analytical and transactional use. This was causing performance issues for the application and reporting. • To overcome this problem we developed a new version of the existing product using layered architecture and entity framework. • Redesigned database in SQL & released the new updates of the product using .NET technologies

Dubai, United Arab Emirates

• Released a successful major upgrade of the existing property management application by working with a client and gathering the requirements. During my tenure, the application was then delivered to a dozen more clients and generated more than $1M in the company’s revenue. The solution was developed using ASP.NET, REST API, and SQL. It was also integrated with the existing ERP solutions for financial postings.• Implemented and trained the company’s clients overseas for various modules of ERP as well.

Master'S Degree, Computer Science

Bachelor'S Degree, Computer Science & Engineering