Laserfiche WebLink
RFP NO. 20-124 <br />GN'F 6 JI"NI <br />Information Technology As -Needed Professional Services <br />Migrated the data from the external database to the internal <br />Oracle Database. <br />Document Imaging <br />Maryland <br />Worked on design and development of a document <br />Application Specialist <br />Judiciary <br />management application for archiving of criminal jackets for <br />(Laserfiche) <br />District Court warehouse. <br />Business Intelligence <br />Amtrak <br />- Designed and developed Tableau visualization solutions <br />Specialist <br />- Worked with customers to analyze and dissect user <br />requirements and build front-end BI applications according <br />to specifications <br />- Created complex formulas and calculations within Tableau <br />to meet the needs of complex business logic <br />- Performed administrative and support activities across a <br />multi -environment Tableau infrastructure including security <br />administration, release management, troubleshooting and <br />general systems maintenance <br />South Carolina <br />The South Carolina Department of Revenue (SCDOR) has <br />Department of <br />implemented a Data Warehouse and related software <br />Revenue <br />components for purposes of tax and revenue compliance and <br />analysis. The Data Warehouse also serves as a primary data <br />source for other business intelligence activities. This work <br />involves proprietary software from Revenue Solutions Inc. <br />(RSI), particularly their Portfolio Warehouse (PW) product. <br />Historically, the Data Warehouse application team has used <br />the proprietary Embarcadero DT/Studio tool, along with <br />custom transform code from RSI, to load data from federal <br />and state data sources into the Data Warehouse. The team is <br />now charged with converting all of the data load processes to <br />use Microsoft SQL Server Integration Services (SSIS) At this <br />time an experienced ETL (Extract, Translate, and Load) <br />specialist with expertise in SSIS is needed to assist in this <br />process. <br />Our services included: <br />• Building ETLs using SSIS packages to load data from <br />various data sources including files from internal and <br />external data sources. <br />• Setting up and running the proprietary Portfolio Warehouse <br />Associate and Grow (A&G) offline process for data <br />cleansing and matching of these files. This includes <br />configuring the A&G match keys with consultation from the <br />business users and SCDOR Data Warehouse team. <br />• Conducting quality assurance for loaded data. <br />• Creating and executing "views" as required by business <br />users. <br />• Performing database utility functions, such as SQL Server <br />Analytical Services for OLAP, development of stored <br />procedure, SSIS, etc. as needed for loading and analysis of <br />data. <br />Infojini Inc. Response � � 12 <br />Microsoft'� r ,�, �� rr <br />10)w b r le r <br />