Responsibilities• Design and implement tables, functions, stored procedures and triggers in SQL Server 2015, 2013, 2008. • Write SQL queries, Stored Procedures, Functions, and Views for several applications• Analyze user data requirements and develop reports to satisfy user and system needs.• Develop reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures. Configure and maintain Report Manager and Report Server for SSRS. • Build… Show more Responsibilities• Design and implement tables, functions, stored procedures and triggers in SQL Server 2015, 2013, 2008. • Write SQL queries, Stored Procedures, Functions, and Views for several applications• Analyze user data requirements and develop reports to satisfy user and system needs.• Develop reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures. Configure and maintain Report Manager and Report Server for SSRS. • Build WCF Services and Web Services to access MS SQL Databases • Set up and maintain database environments to support production, QA and development activities•Implement migration SQL Server databases, user logins, and DTS packages from one server to another• Install, configure and maintain MS SQL Servers • MS SQL Server database administration, including configure Scheduled Tasks for regular Database Backup and Maintenance Activities, create and modify tables, stored procedures, various clustered/non-clustered indexes, triggers, check constraints and functions.• Build ETL processes utilizing SSIS and DTS, including FTP data from remote location, transform it, mart it to data warehouse.. Show less

Responsibilities • Assist in the development of the OPM Grant funding database, a web based repository for multi-departmental funding requests• Create an ASP script to publish a cell phone directory list of city employees. • Debugged and convert the Fire Training Requirements Reports using Crystal Reports from version 9 to 8.5 so they could be integrated into Fire RMS5 MS SQL application and debug a data access permission problem. • Create a projected position based annual… Show more Responsibilities • Assist in the development of the OPM Grant funding database, a web based repository for multi-departmental funding requests• Create an ASP script to publish a cell phone directory list of city employees. • Debugged and convert the Fire Training Requirements Reports using Crystal Reports from version 9 to 8.5 so they could be integrated into Fire RMS5 MS SQL application and debug a data access permission problem. • Create a projected position based annual salary report and an employee annual salary report using Crystal Reports exported to MS Excel, from the EDEN payroll system database. • Modify, debug and fix supporting Database applications and reports for Planning and Records Departments.• Maintenance support and troubleshooting for MS SQL Backup maintenance plans and logon deployment scripts Show less

Responsibilities• Develop Crystal Reports based on stored procedures that access the corporate MS SQL based DataMart. Publish reports using Crystal Enterprise E Portfolio. • Design, Configure, and administer a MS SQL database and Access Project Client program, “LoadManager”, Management System for the Trucking group. The system included a central MS SQL Server (Compaq DL380 with RAID 5) and 12 Clients located in four warehouses. Access Projects was used as a front end using Visual… Show more Responsibilities• Develop Crystal Reports based on stored procedures that access the corporate MS SQL based DataMart. Publish reports using Crystal Enterprise E Portfolio. • Design, Configure, and administer a MS SQL database and Access Project Client program, “LoadManager”, Management System for the Trucking group. The system included a central MS SQL Server (Compaq DL380 with RAID 5) and 12 Clients located in four warehouses. Access Projects was used as a front end using Visual Basic modules to access the MS SQL centralized Database using stored procedures, views, and triggers. PO information from the UNIX Business System was sent to the MS SQL Database using sockets. • Design, configure, and administer an Access database, “TripDB”, to record and report on Driver Trip data for the trucking group. The database uses multiple tabbed input forms to collect driver hours, trip log records, state trip times and mileage, vehicle hours and mileage, driver expenses, and vehicle and refer unit fuel cost. The data is the used to create driver payroll updates to ADP, report on driver hours, tractor and trailer mileage, fuel tax rebates, route and trip analysis, and reconcile fuel receipt with fuel vendor billing. • Setup, maintenance and support of JJ Keller Log Manager, KellerScan, Drug and Alcohol testing, and Driver Management programs. Show less

I was responsible for the day to day running of the SERA computer network, communications, and printers. This included trouble shooting and maintenance for hardware and software on a Unix Ethernet TCPIP based network; hardware and software, and networking installation on a Convergent Technologies S3 mini computer; IBM PC’s running UNIX System V release 4.2; and IBM PC workstations running Microsoft Windows 3.0. Responsibilities • Supplied user software support for Quattro Pro… Show more I was responsible for the day to day running of the SERA computer network, communications, and printers. This included trouble shooting and maintenance for hardware and software on a Unix Ethernet TCPIP based network; hardware and software, and networking installation on a Convergent Technologies S3 mini computer; IBM PC’s running UNIX System V release 4.2; and IBM PC workstations running Microsoft Windows 3.0. Responsibilities • Supplied user software support for Quattro Pro, Alpha 4 database, and Wordperfect 5.0.• Helped prepare the analysis on the environmental externalities for the proposed California Oregon Transmission Project.• Help create a bid proposal under USAID to supply the Philippines Department of Agriculture with the following: 315 IBM PCs, 32 UNIX workstations, Laser printers, optical worm drives, HP scanners Hp7575 plotter, Archive tape drives and software including Lotus 123, WordPerfect 5.0, FoxBASE Pro, and MicroStat II. We were awarded the USAID project we had 6 weeks and 8 people to purchase, assemble, configure, test, pack and ship the equipment. I designed, implemented and oversaw the assembly process and testing procedures. I was also responsible for preparing complete shipping manifests and inventory for all hardware and software. The project was completed on time and within budget. • Maintain the UNIX accounting and reporting of computing resource usage for computer time billing. I modified the standard UNIX accounting system to report by group ID and to breakout project specific stats and designed and maintained a group logon system for the Window PC workstations to integrate with the UNIX accounting computer resource usage reports . Show less

As a member of the programming team, I was responsible for the development and maintenance of C and Assemble Language modules for the Shelley Authoring System on MS DOS and the UNIX operating systems.Responsibilities• Develop and test disk based computer training for the following applications: Lotus 123, dBase, Uniplex, Informix, and Microsoft Word, and WordPerfect.