INFOJINI, INC. - Laserfiche WebLink

Home Browse Search

RFP NO. 20-124 (7N'F JI"NI Information Technology As -Needed Professional Services • Created a partition scheme to improve the performance of queries, reduced contention, and increase data availability. • Implemented appropriate error handling techniques such as try... catch blocks, raise an error, and various other system functions to robustly handle errors per business requirements. • Created clustered, non -clustered indexes including covering and filtered index by analyzing execution plans to further improve the performance of slow running SQL statements. • Designed dimensional model architecture identifying required dimension and fact tables. • Implemented packages in SSIS to extract data from source systems and resolved issues associated with finding data. • Performed data cleansing operations during the ETL process utilizing transformations such as derived column, data conversion, and fuzzy lookup. • Utilized event handlers to handle errors and implemented logging in SSIS to store detailed information. • Implemented Team Foundation Server TFS as Version Management for Microsoft Technologies. Helm360, San Diego, CA October 2015 — January 2017 SQL SSIS Developer • Provided technical and functional support for the project team and participated in documentation reviews. • Conducted design reviews with the business analysts and ensuring the feasibility of the logical and physical design models. • Redesigned and tuned stored procedures, triggers, UDF, views, indexes to increase the performance of the slow running queries. • Configured join statement in TSQL code combining data from numbers of data sets. • Wrote While statement in TSQL to loop through a table on a row -by -row basis per business requirements. • Developed SQL scripts and stored procedures with multiple JOINS and SET operators per business requirements. • Identified and removed duplicates from tables utilizing ranking functions and CTEs. • Created DDL statements for index rebuilds and reorganized to relief influence from index fragmentation. • Created source -to -target data mapping documents to streamline the transfer of data from logical to physical data models. • Designed dynamic SSIS packages to transfer data across multiple platforms, and performed data profiling to validate data. • Utilized different SSIS properties to optimize the ETL process both in data flow and control flow level. • Implemented different strategies to control errors in data flow and control flow levels during the ETL process utilizing precedence constraints and event handlers. • Implemented TFS for BI application and SQL code source control. Infojini Inc. Response � 40 Microsoft'� r ,�, �� rr 10)w b r le r