Item 14 - Agreements for As-Needed Information Technology Services

Home Browse Search

RFP NO. 20-124 CIVIJINJ Information Technology As -Needed Professional Services .:��...• • .. • Developed Store Procedures and user -defined functions to implement business logic and calculations. • Wrote SQL code with complex logic utilizing multiple temp tables and table variables. • Created SQL scripts with looping constructs for row by row operations as required. • Handled runtime errors with try -catch and other error functionality. • Created SSIS package to import data into SQL tables from multiple Excel files with multiple sheets. • Utilized script tasks in SSIS packages to make customized Excel reports. • Scheduled SSIS packages utilizing job agents during off -hours. • Developed SSRS reports with drill -down functionality to provide the required info. Speedway, Enon, OH SQL Developer February 2018 — May 2018 • Participated in daily scrum meetings to update the status of the tasks. • Configured SQL database from scratch and to receive requests form Front-end. • Provided documented solutions to the team related to design and development. • Developed well -designed procedures to manipulated data from front end applications • Added error handling techniques in procedures utilizing the @@error and try -catch blocks. • Debugged procedures utilizing TSQL debugger and scalar and table variables. • Created SSIS packages to pull data from multiple sources and loaded it to SQL Server Database. • Handled runtime errors in SSIS packages for OnError and OnTaskFailure events utilizing event handlers. • Developed SSIS packages to use logging with text and SQL table providers to ease debugging. • Designed different reports in SSRS with appropriate formatting according to business requirements. • Checked In/Checked out SQL code and other DB objects in TFS. Aetna, Scottsdale, AZ January 2017 — February 2018 SQL Database Engineer • Collaborated in JRD sessions with the project manager and business analyst to analyze the project -goals and prepare BRD documents. • Created stored procedures, triggers, user -defined functions, and views for newly added OLAP data. • Utilized joins, subqueries, temporary objects temporary tables, table variables, and CTEs in writing complex queries and storing data. • Implemented business in TSQL query through case statement and looping structure. • Optimized TSQL stored procedure by recompile and fix parameter sniffing issue with the variable. • Utilized explicit transactions to maintain ACID properties for queries and Infojini Inc. Response 39 MP,grinerr ....... . JIMixt-acrrroi'�1, partnpartner