Basil Evans Email & Phone Number

Washington, Dc, Us

Responsibilities:• Designed and implemented data management systems to ensure secure, efficient, and reliable data storage and retrieval.• Developed and maintained data governance policies and procedures to ensure data integrity, privacy, and compliance with regulatory standards.• Conducted data analysis and reporting to support business decision-making processes, using tools such as SQL, Python, and data visualization software (Tableau, Power BI, ArcGIS)• Managed database performance, including tuning, backup, and recovery operations to ensure high availability and data security.• Coordinated with cross-functional teams to integrate data from various sources, ensuring consistency and accuracy across platforms.• Trained and supported staff on data management best practices, tools, and technologies to enhance overall data literacy within the organization.• Troubleshot and resolved database issues, optimizing system performance and minimizing downtime.• Developed data dashboards and data stories to follow the progress of defendants from arrest to sentencing.Key Achievements:• Successfully migrated legacy data systems to a modern database infrastructure, reducing operational costs by 20%.• Implemented an advanced data analytics platform, leading to a 30% improvement in data processing speed and accuracy.• Developed a comprehensive data security strategy, resulting in zero data breaches over a two-year period.• Led a project to automate data reporting, saving over 100 hours of manual work per month.• Played a pivotal role in achieving compliance with industry data standardsTechnical Skills:• Database Management: SQL, SQL Server 2019• Data Analysis: Excel, Tableau, Power BI• Data Security: Encryption, Access Controls, Data Masking• ETL Tools: SSIS, Tableau Prep• Cloud Platforms: Azure

• Developed tools, designing dB objects, using SSIS (data transforms), SSRS, T-SQL and scripts, to monitor SQL Servers in a domain by auditing the activities and measuring the resources available for a machine. • Developed packages for multi-server installation, monitoring and debugging. Developed the procedures and code to evaluate suitability of the I/O subsystem for the SQL farm.• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance• Establish all related Policy and Procedures, and Build out the SQL farm of servers• Clustered SQL farm for use with service now platform. Additionally, performed s-now discovery to discover all physical assets into the CMDB.

Falls Church, Va, Us

• Data Architect / Database Analyst / Business Intelligence Developer (Data ETL) • Created dimensional model and SSAS Tabular model, lead on end-to-end solution integration • Developed PL/SQL Packages to extract the data from the source systems. • Analyzed the system, met with end users and business units in order to define the requirements. • Wrote SQL Queries, Triggers, and Shell Scripts to apply and maintain the Business Rules• Extracted the data from SQL Server, Flat files and load into Data warehouse• Created mapping document for source to target• Responsible for database modeling, extract transformation load (ETL) procedures, design and development, OLAP design and development; using SQL server 2005, 2008 database for data mart, SSIS for data integration, SSRS for reporting, and SSAS for OLAP• Extensively worked in the performance tuning of the programs, ETL Procedures and processes. • Extensively worked in the performance tuning of the programs, ETL Procedures and processes• Review high level business reqs, technical specs, data mapping documents and create detailed test cases• Administration of all Internal Operations Databases• Database tuning and Optimization• Installation and Administration of Reporting Services• Develop, Deploy and Maintain Reports for Internal Corporate Leadership Team• Gather Requirements from Business Product Owners for Reports and Analysis• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance• Prepared the complete data mapping for all the migrated jobs using SSIS.• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and• Conduct code walkthroughs and review peer code and documentation• Created, Designed and Deployed multi-dimensional SSAS cubes for executive team

Stamford, Ct, Us

• Administration of all Internal Operations Databases• Installation and Administration of Reporting Services• Develop, Deploy and Maintain Reports for Internal Corporate Leadership Team• Gather Requirements from Business Product Owners for Reports and Analysis• Perform backups and database recovery• Audit Backup and Recovery process for SOX Compliance• Develop SSIS packages for Enterprise Datawarehouse• ETL/EDW Development for BI Reporting System (SAP)• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance• Train and manage developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices• Conduct code walkthroughs and review peer code and documentation• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes• Created system for capturing, reporting, and correcting error data• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production• Provide on-call support to production system to resolve any issues• Gather requirements and design of data warehouse and data mart entities

Blue Bell, Pennsylvania, Us

Public Sector, Administrative Office of the United States Courts• Install, configure and maintain MS-SQL 2000/2005 database servers within the AOUSC• Analyze and determine informational needs and elements, data relationships and attributes, dataflow and storage requirements and data output and reporting capabilities• Define logical attributes and inter-relationships and design data structures to accommodate database production, storage, maintenance and accessibility• Test designed applications using database management software or general application software for either web enabled or client server applications• Perform system level database maintenance, backups and database recovery• Provide task direction to team members as required• Designed, configured and managed all phases of system workflow using ASP.Net and C#.net to manage the workflow of AOUSC operations

• Responsible for all customer implementations• Coordinate all customer support communications• Final escalation point for all technical support issues • Responsible for database scripts, stored procedures and DB Change Requests in MS SQL and Oracle 9i • Design, develop, and maintain development, test and production databases• Create replication strategy between corporate and remote servers• Create backup strategies for customers and in house clients• Documentation of all processes as it pertains to implementation, db scripts and conversions

• Administration of all corporate MS-SQL Servers including SQL Server 6.5, 7 and 2000• Design, develop, and maintenance of development, test and production databases, including database management, configuration, optimization, security, maintenance, and support• Develop stored procedures for better database performance• Create the databases, table spaces, tables, views, indexes• Tuning and optimization of all databases • Create replication strategy between corporate and remote servers• Create SQL alerts for database performance and notification• Implement notification and reporting Services

• Administered the network infrastructure and software systems• Designed and Implemented Windows NT to 2000 migration• Managed server based antivirus system using Symantec Corporate Edition• Managed 200+ user accounts for a multiple domain network• Diagnosed hardware, software and network problems and implemented solutions• Implemented and administered Firewall/VPN Solution using Checkpoint FW1/VPN1• Purchased hardware and software as required• Setup, maintained, administered and tuned MS-SQL Server 7.0/2000 development, test and production servers• Created and maintained DTS packages and scripts to handle daily production tasks for database servers• Scheduled DBA maintenance jobs for SQL Servers• Developed Interactive Voice Recognition system using VB Script and Zeacomm• Managed Telephony system using Avaya Definity G3si PBX• Installed and maintained Cisco Routers using Cisco 2600/1705/1600 Routers

Project: Bailey, Emory, Patton Class Action SettlementDates: April 1998-September 1999• Team member responsible for database design to administer an $800,000,000.00 tax settlement to retirees in North Carolina• Designed SQL Server 6.5 database to hold data for more than two million records• Imported all data from different sources including tape, ASCII files and Access databases• Assisted Application teams in data modeling and stored procedure coding• Provided technical and production support as neededClient: Productivity PointDates: September 1999-December 1999• Planned and installed Epicor Platinum accounting information system• Administered SQL and Access databases• Migrated Access databases to SQL Server 7.0• Managed user and login requests and security maintenance• Performed daily maintenance jobs and backups on all MS-SL servers• Provided one on one training to users• Wrote technical documentation for the system

Bachelor Of Arts - Ba

Certificate, Computer Information Systems

Vocational High School And Secondary Business/Vocational-Industrial/Occupational Diploma Program