Business Intelligence/database Developer
Designed, developed, and implemented SQL Server database used for reporting, along with procedures to extract, transform and load data from production OLTP databases. Developed T-SQL stored procedures, user-defined functions, views and ad hoc queries to support reporting requirements. Supervised two other developers and streamlined processes to greatly increase the group's efficiency, resulting in fewer resources needed to support the same workload. Worked with other departments to assess and support their reporting needs, maintaining good relationships with department heads to continuously support changing report requirements. Created and maintained geospatial data using MapInfo for all localities in the contiguous 48 states and automated mapping processes using MapInfo MapBasic.
- Developed reports for new databases often with little or no application or database documentation
- Designed reports using Crystal Reports, SQL Server Enterprise Manager and Reporting Services
- Developed software applications to facilitate and automate common data extraction tasks and printing Crystal reports.
- Proactively identified and resolved data quality issues in production databases, where appropriate.