Harsh Patel Email & Phone Number

Toronto, On, Ca

Toronto, Ontario, Canada

• Led CRM&DS projects using MS SQL Server, SSIS, SSRS, and SSAS, delivering error-free reports and ETL packages.• Demonstrated technical proficiency in MS SQL Server, data warehouses, and SQL query optimization.• Fostered collaboration and teamwork across teams, contributing to a positive work culture.• Maintained high standards of integrity and accountability in project delivery and follow-ups• Certified in Azure Fundamentals (AZ900) and Power BI Data Analyst (PL300).• Improved BI efficiency by automating data migration with PowerShell script and optimizing incremental loads.• Continuously drove innovation by implementing advanced Power BI and SQL Server techniques.• Advocated for inclusivity and respect, promoting an accessible and inclusive work environment.• Integrated JSON data into SQL Server and utilized it in SSRS reports, enabling dynamic and flexible data presentation tailored to business requirements.Technologies: SQL Server (2005-2019), SSIS, SSRS, Power BI, and PowerShell for automation.Skills: Extract, Transform, Load (ETL), SQL, SQL Server Integration Services (SSIS), Databases, SQL Server Reporting Services (SSRS), Microsoft SQL Server, Power BI, PowerShell Script.

• Responsible for design, programming, testing, and maintenance of one or more applications using SQL technologies• Analyzed business requirements, design and implement required data model and ETL processes• Created complex Stored Procedures, triggers, tables, and views and other SQL joins and queries for applications by using SQL• Design, develop, and support projects in traditional relational databases (SQL Server, SSIS, SSRS & MSBI)• Involved in complete SSIS life cycle in creating SSIS packages, building and executing the packages in both the environments (Development and Production)• Monitor, tune and enhance existing SQL Server ETLs and scheduled jobs• Implemented Event Handlers and Error Handling in SSIS packages• Create intuitive and flexible reports using tools such as SSRS• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2019• Perform testing and prepare documentation• Interface with business users and technologists at client locations• Tune and maintain BI software and database components• Component Design/ Coding/ Unit Testing/ Debugging/SQL Optimization• Technologies used: SSIS, SSRS, SQL Server 2019, PowerBI

Charlottetown, Prince Edward Island, Canada

• Worked on SAP S4 Hana software to manage inventory in a GMP facility• Performed daily task like receiving, transfers of raw materials to production, shipping, inventory counts and Warehouse Activity Monitoring (WAM) Report• Worked with planner associate team to migrate data from SAP R3 to SAP S4 Hana • Developed excel sheet with purchase order data from old to migrate to new system• Assisted Procurement specialist with updating purchase order to SAP S4• Ensured attention to detail and company standard is followed to process movements of inventory in SAP• Generated variance reports and processed adjustment sheets and escalated high dollar amount queries• Conducted inventory counts at end of year and presented inventory result to finance and management team

Post Graduate Diploma, Computer Software Technology/Technician

Bachelor'S Degree, Computer Engineering