With strong inclination towards building solutions that assist an organization in improving business operations, I worked development projects that used JavaScript API for ArcGIS and SQL Server Reporting tools.
Any example is mentioned below.
Automated Dailysheet Using SQL Server
Daily sheet is a analytical guide for the the Police Commissioner and its deputies which contains the number of incidents by the crime category that occurred in the past.
Research Analysts at Philadelphia Police Dept. create and share this guide on a daily use. The purpose of this development project was to automate the creation of this daily sheet report.
To improve and build knowledge of SQL Server, I took tutorials online on following:
SQL Queries
SQL Joins
SQL Functions
SQL Stored Procedures
Getting Started with SQL Server Reporting Service (SSRS)
Getting Started with SQL Server Integration Services (SSIS)
After taking tutorials and web course, I took on this mini development project to create Stored Procedures that would calculate the numbers required for the daily sheet in table format
Furthermore, this SQL Table (updated by SQL Server Job Agent) is connected to an excel file that is now utilized by the Research Analysts at Police Dept to automatically generate the daily sheet on daily basis