Summary
Overview
Work History
Education
Skills
Timeline
Generic

ARABI ALSHAAR

Fresno,CA

Summary

Experienced Senior .NET/Database Developer with 15+ years of expertise in creating robust web applications, batch processing systems, and business intelligence solutions. Skilled in ASP.NET, C#, VB.NET, SQL Server, SSRS, and SSIS. Specialized in end-to-end project execution, including gathering requirements, designing scalable solutions, developing efficient code, conducting thorough testing, and ensuring smooth deployment and production support. Proven ability to drive system improvements and optimize performance while maintaining strong communication and collaboration with stakeholders.

Overview

15
15
years of professional experience

Work History

Information Technology Specialist I

California Department of Corrections and Rehabilitation
Rancho Cordova
04.2024 - Current
  • Evaluated and recommended new database technologies and tools to enhance productivity.
  • Configured user accounts, privileges, roles, profiles. in the database server.
  • Coordinated with other teams such as network administrators and system admins for resolving complex issues.
  • Installed, configured, and maintained open source PostgreSQL 13, 14, 15, 16 and 17
  • Configured PostgreSQL for remote access
  • Configured PostgreSQL for Active Directory security

Senior Software/Database Developer

Cognizant Technologies USA
07.2017 - 04.2024
  • Played a pivotal role as Senior .NET Developer, writing highly complex code in alignment with best coding practices
  • Developed a highly scalable Data Access layer which consisted of Web Services using C# and VB.NET to provide secure access to the database
  • Conducted code reviews to ensure industry coding standards
  • Ensured performance, security, and availability of databases
  • Suggested SQL Server upgrade requirements
  • Collaborated with other team members and stakeholders
  • Developed high-quality database objects and solutions
  • Developed and optimized stored procedures and functions using T-SQL
  • Reviewed and interpreted ongoing business report requirements
  • Analyzed existing SQL queries for performance improvements
  • Played a key role in architecting Development, Test, UAT (User Acceptance Testing) and Production environments, which included software and hardware requirements taking into account future upgrade or expansion
  • Helped developers become more efficient by refreshing lower environments databases with backups from clients, this helps developers troubleshoot bugs more efficiently
  • Created and maintained SSIS packages
  • Created and maintained SSRS reports that are based on multiple databases
  • Collaborated with software developers to integrate database solutions into applications
  • Strengthened client relationships through effective requirement gathering and developing solutions to deliver requirements to specification
  • Executed all phases of a typical system development lifecycle (scope, requirements, design, development, database design and development, test, deployment, and post-production support)
  • Worked closely with the Business Analysts to produce Story Boards that helped capture the basic structure of the design, gathered and documented business requirements, database design and software design
  • Developed Solid knowledge of Service Oriented Architecture (SOA) and Object-Oriented Programming (OOP) and Design
  • Led cross-business teams to design, develop and support a service-oriented application architecture for information systems in an Agile driven environment
  • Developed highly scalable code libraries using the reusable architecture methodology
  • Applied centralized security policies to comply with the state of Missouri security standards
  • Developed a rapid Prototype to help test the usability of the application at early stages
  • Produced architectural and technical system documentation
  • Implemented business logic as .NET Framework assemblies (C#, VB.NET)
  • Developed sophisticated SQL Server databases to responsively handle complex queries (T-SQL, DTS, triggers, stored procedures, functions, and optimization) and .NET data access components
  • Technologies used: .NET Framework, C#, VB.NET, Entity Framework 6.0, SQL Server 2019, 2022, SSRS, SSIS, bootstrap, DevOps, ServiceNow, ASP.NET, HTML5
  • Domains: Life Science, Education, Health Care, Payer, Manufacturing, Industrial, Claims Processing

Senior .Net Developer

Information Resource Group, Inc.
Jefferson City, Missouri
04.2013 - 07.2017
  • Lead a team of developers to develop an integrated online security system that would serve as a centralized data repository for Missouri commodity
  • The solution design and coding addressed and mitigated the Open Web Application Security Project's (OWASP) Top 10 Security threats
  • Application incorporated Responsive Web design (RWD)
  • Developed and automated the process of applying for Concealed Carry permit for the state of Missouri residents which is administered by the Missouri Sheriffs' Association
  • The project included integration with many Sheriff Offices throughout the state and it also included printing permit cards with the user's biometric signature
  • The Missouri Department of Agriculture requested analysis and development of a solution for the Fuel Quality Laboratory Information Management Systems (FQLIMS)
  • The project consisted of an estimated seventeen modules, resulting in a new system solution
  • Comprehensive work was done with the MDA SME's to do business analysis, requirement gathering for the modules and produce the requirement documents
  • The objective of this project was to provide services for the Missouri Export initiative, which provided over 500 MO businesses with the ability to export their products across the world
  • During this initial phase, there were new feature updates to the website, which included: creation and implementation of the web portal, database, and business-to-business directory
  • Technologies used: .NET Framework 4.5, VB.NET, Entity Framework 6.0, SQL Server 2014, SSRS, SSIS, bootstrap 3.0, Team Foundation Server (TFS)

.NET Developer

RKV Technologies
Jefferson City, Missouri
05.2010 - 04.2013
  • Missouri Office of Administration - Missouri Accountability Portal (MAP) 'allows the citizens of Missouri to review how their money is being spent and it provides financial data for the purchases of goods and services by the state as well as many financial disbursements through various state programs'
  • MAP was commissioned by Governor Matt Blunt in 2006 as a result of law passed by congress requiring a searchable Web site for federal contracts and grants
  • MAP won The American Business Award of Best MIS and IT Team
  • I have Led a team of state and consultants during the entire life cycle of the MAP project
  • MAP design and code was acquired and implemented by other local and state governments
  • Milwaukee County Accountability Portal (MCAP) is one of those local governments that launched an accountability site that uses MAP's design and code
  • RKV Technologies - Resource Recruiting System - Developed an in-house web-based resource tracking and recruiting system that helps HR management track and recruit top talent
  • This comprehensive solution simplifies the recruiting process by allowing users to search resumes for desired skills
  • Missouri Department of Elementary and Secondary Education - Automated ETL processing for CoreData System for Highly Qualified Teachers and designed complex reports using SSRS
  • Missouri Department of Elementary and Secondary Education - Lead a team of developers during the design and development of a web-based Teacher Certification System for Missouri educators
  • The system allows Missouri educators to apply, print and view their certificates and check fingerprint/background status
  • Missouri Office of Administration - American Recovery and Reinvestment Act (2009) Funds Tracking with MS Stimulus 360
  • The Stimulus 360 solution enables government agencies to plan, track and share information about federal stimulus programs
  • Played a leading role during the implementation of Microsoft Stimulus360 solution by extracting data from different data sources (Excel, Access, DB2, SQL Server, Oracle), validating and loading it into SQL Server
  • Missouri Department of Mental Health - Customer Information Management, Outcomes, and Reporting (CIMOR) - Developed and automated the delivery of complex SSRS reports based on CIMOR's data warehouse which required building efficient stored procedures that queried very large tables
  • Missouri Secretary of State - Reverse engineer an existing database into a database model
  • Developed a Knowledge Base for an existing database using Microsoft Office Visio Professional
  • APS Healthcare - Jefferson City, MO - Missouri Health Net
  • Developed an advanced dashboard that combined multiple SSRS reports into a single easy to use dashboard that utilizes colors and graphs to monitor certain thresholds
  • Missouri Department of Elementary and Secondary Education - Electronic Planning Grants System (ePsGs) - web based system that maintains Missouri's school grants and planning
  • Lead a team of consultants during the cycle of turning business requirements into functional requirements
  • Missouri Office of Administration - Employee Performance Appraisal System - Web-based intranet system that is used to simplify and enhance the entire employee performance appraisal process for Missouri employees
  • Lead a team of state employees during the entire life cycle of the project, from requirement gathering to post implementation support
  • Missouri Department of Mental Health - Statistical Information Maintenance System - Web-based intranet solution that is used to view, maintain and report complex statistical information for the Missouri Department of Mental Health facilities and providers

Education

B.S. - Computer Engineering

University of Missouri
Columbia, Missouri

B.S. - Electrical Engineering

University of Missouri
Columbia, Missouri

Skills

  • Business Intelligence
  • ASPNET
  • C#
  • VBNET
  • NET Core
  • Entity Framework
  • HTML5
  • JavaScript
  • JQuery
  • SQL Server Administration
  • Stored Procedures
  • T-SQL Development
  • SSRS
  • SSIS
  • DevOps
  • Agile
  • Waterfall
  • WinForms development
  • NET Framework
  • ServiceNow administration
  • PostgreSQL configuration
  • SQL performance tuning

Timeline

Information Technology Specialist I

California Department of Corrections and Rehabilitation
04.2024 - Current

Senior Software/Database Developer

Cognizant Technologies USA
07.2017 - 04.2024

Senior .Net Developer

Information Resource Group, Inc.
04.2013 - 07.2017

.NET Developer

RKV Technologies
05.2010 - 04.2013

B.S. - Computer Engineering

University of Missouri

B.S. - Electrical Engineering

University of Missouri

Similar Profiles

  • Melissa Lozano

    Melissa LozanoMelissa Lozano

    Medication Nurse at California Department of Corrections and RehabilitationMedication Nurse at California Department of Corrections and Rehabilitation

  • Lori Ebeling

    Lori EbelingLori Ebeling

    Licensed Vocational Nurse at California Department of Corrections and Rehabilitation - Mule Creek State PrisonLicensed Vocational Nurse at California Department of Corrections and Rehabilitation - Mule Creek State Prison

  • Anjelica Young

    Anjelica YoungAnjelica Young

    Office Technician at California Department of Corrections and Rehabilitation - Richard J. Donovan Correctional FacilityOffice Technician at California Department of Corrections and Rehabilitation - Richard J. Donovan Correctional Facility

  • Hilton Collins

    Hilton CollinsHilton Collins

    Associate Governmental Program Analyst at California Department of Corrections and RehabilitationAssociate Governmental Program Analyst at California Department of Corrections and Rehabilitation

  • Roxanne Garcia

    Roxanne GarciaRoxanne Garcia

    Resource Counseling Assistance at Calwa ElementaryResource Counseling Assistance at Calwa Elementary

CREATE PROFILE
ARABI ALSHAAR