Laserfiche WebLink
RFP NO. 20-124 <br />GN'F 6 JI"NI <br />Information Technology As -Needed Professional Services <br />• Collaboration Tools: SharePoint, JIRA <br />• Source Control: Team Foundation Server (TFS), GIT <br />Kaiser Permanente, Walnut Creek, CA March 2019 — Present <br />SQL/SSIS Developer <br />• JRD Meeting with clients to gather business requirements. <br />• Turning Business requirements into complex SQL Store procedures. <br />• Functional and Stress testing of Store procedures. <br />• Using SSIS package to Extract, Transformation, and loading into a shared network <br />location. <br />• Automation of SSIS package using SQL job agents. <br />• Created complex SQL for improving the performance of the Database. <br />• Created a Confluence page for daily reports. <br />• Trained in the EPIC system (Clarity). <br />NAMM CAL, Ontario, CA <br />SQL/ETL Developer <br />September 2018 — February 2019 <br />• Participated in JRD sessions to gather requirements and outline functional requirements. <br />• Defined multiple constraints in the logical phase of the data modeling life cycle. <br />• Created a data mapping document (DMD) by analyzing data sources and mapping to data <br />mart schema. <br />• Formulated SQL scripts to analyze historical data and extracted the required data to <br />support management decisions. <br />• Transformed a complex business logic into SQL stored procedures and user -defined <br />functions. <br />• Optimized queries by modifying T-SQL queries and eliminating redundant data. <br />• Prepared the complete data mapping for all the migrated jobs using SSIS. <br />• Used ETL (SSIS) to develop jobs for extracting, cleansing, transforming, and loading <br />data into a data warehouse. <br />• Designed complex SSAS cubes with fact measures groups and multiple dimension <br />hierarchies. <br />• Managed report delivery schedules by configuring standard/data-driven subscriptions <br />within the report manager. <br />• Delivered on -demand and scheduled reports for business analyses in SSRS. <br />Conifer Health Solutions, Encino, CA <br />SQL/ETL Developer <br />• Created technical design documents for exi <br />May 2018 — September 2018 <br />')QL procedures and ETL processes. <br />Infojini Inc. Response � 38 <br />Microsoft'� r ,�, �� rr <br />10)�"°^1f � b r le r <br />