Harsh Hansaliya (ハーシュ ハンザリア) Email & Phone Number

Vadodara, GJ, IN

Sofrware Engineering | PowerBI | SSIS | SQL

• Responsible for large scale deployed data warehouse system containing 100+ SSIS ETL packages, 20+ Reports
• Designed and developed advance level SSIS packages for various requirements of the client
• Maintained deployed OLAP Cubes
• Develop PowerBI Reports for day-to-day monitoring of ETL processes, data validation

Vadodara

Windows Server tuning, SQL server deployment, Database monitoring & tuning, SQL Always-On Availability, Healthcare ERP deployment & Configuration, Power BI reporting, Capacity Assessment of Servers for Software Upgrades

Ahmedabad

• Complete responsibility of maintain healthiness of 9 server with over 40 databases of ABT and EMS monitoring systems located across four thermal power plants of adani power in India
• Ensure availability of All Monitoring Systems > 99 % of time in a year and troubleshoot issues
• Hands on Experience of T-SQL queries, SQL Tables,Views,Stored procedures, Functions on part of SQL database Administration.
• Designed and developed SSIS packages to import and transform data between databases and external data sources (IBM PI, notepad, excel, csv) using various integration tools.
• Integration of regulatory amendments of government in SQL database logics of existing systems
• Complete data processing & analysis of all Interface & Energy audit meters of all adani thermal sites in SAP BI & SQL This helps to immediate availability of meters data in SAP and eliminate human efforts for metering.

Ahmedabad

• Significant Highlights:
• Responsible for Project delivery and Service Assurance for ABT & EMS Projects in Western region of India
• Mapping customer requirements of Customer with development team at Head office
• Conducted Project Engineering activities (FAT inspection, procurement process and vendor management) for New projects
• Integration of various logics in SQL Views,Tables,stored procedures as per customer requirement
• Commissioning of Metering communication network and software at various site locations

Ahmedabad Area, India

• Significant Highlights:
• Energy accounting of Generated Energy, Depooling of Energy accounts, Daily/weekly reporting of commercial settlement of Scheduled Wind powers to customers
• Validation of UI calculation report published by SLDC
• Involved in implementation of Online Centralized Monitoring system of Eight wind farm generation data over wireless GSM network at Ahmedabad location
• Effective wind power scheduling and live monitoring of schedule vs, actual wind power generation