Post Job Free

Resume

Sign in

Sql Server Access Control

Location:
Baltimore, MD
Posted:
September 07, 2023

Contact this candidate

Resume:

DONEEL EDELSON

adzjux@r.postjobfree.com 410-***-**** BalƟmore, Maryland

www.linkedin.com/in/doneel-edelson-72098744

PROFESSIONAL PROFILE

Highly skilled soŌware developer with a strong background in data migraƟon and maintenance. ExperƟse in mapping fields, wriƟng migraƟon scripts, and analyzing bugs enabling successful soŌware development and maintenance projects. Known for excellent troubleshooƟng, logical thinking, and problem-solving skills. EXPERTISE

• Data migraƟon, including field mapping and migraƟon script wriƟng.

• Maintenance and enhancement of exisƟng code in various systems built in the past 10 years.

• Bug analysis and troubleshooƟng in large modern systems.

• Strong problem-solving and analyƟcal skills.

• Excellent aƩenƟon to detail and ability to work under pressure.

• EffecƟve communicaƟon and collaboraƟon skills.

• Emphasis on customer saƟsfacƟon at all touch points. PROFESSIONAL EXPERIENCE

ALLIANZ TRADE / EULER HERMES, Owings Mills, Maryland 1984 – 2023

• Migrated claims data from the Compass claim system to the Compass collecƟon system. o Designed and developed SQL scripts generaƟng mulƟple xml files using SQL Server Management Studio, PostgreSQL, DBeaver, and Excel.

o Migrated Canada and Greek claims.

• Migrated core data from the Compass insurance system in Owings Mills to the Compass insurance system in Paris.

(mulƟ-year project)

o Designed and developed SQL scripts migraƟng core insurance data to MicrosoŌ SQL Server and PostgreSQL databases using large complex SQL scripts, SQL Server Management Studio, MicrosoŌ Visual Studio, PostgreSQL scripts, psql, and DBeaver.

o Tested extensively, including user tesƟng, and implemented in producƟon.

• InvesƟgated and solved user soŌware issues for the Compass insurance system and other systems. o Solved dozens of issues every year using Gitlab, Jira, Confluence, Splunk, and Eclipse.

• Produced numerous user reports using stored procedures and SSRS data driven reports. o Gathered user requirements for each report.

o Designed, developed, and implemented each report, meeƟng or exceeding user requirements.

• Built interface files between the Compass insurance invoicing system and the Wells Fargo Bank online payment system.

o Designed and developed a SSRS data driven report generaƟng insurance invoice PDF files for Wells Fargo Bank. o Designed and developed SQL scripts and stored procedures that import customer payments into the Compass system using the Wells Fargo Bank payment data.

o Tested extensively, including user tesƟng, and implemented in producƟon.

• Built insurance policy endorsement templates with bookmarks and custom merge fields. Doneel Edelson 410-***-**** adzjux@r.postjobfree.com o Wrote Java code pulling merge field values from the database. o Wrote SQL code to populate the database configuraƟon tables.

• Added / modified fields on Compass insurance applicaƟon screens. o Wrote Java and JavaScript code to get the values from the database and format them on the screen.

• Added / modified access control modules to the Compass access control sub-system to control who can approve insurance policies and for how much.

o Wrote Java code for the access validaƟon.

o Wrote SQL code to populate the database configuraƟon tables.

• Built a data import system to load claim collecƟons from the collecƟon system into Compass. o Designed the SQL scripts to generate the required transacƟons in the Compass claims system using stored procedures and SQL Server Management Studio.

o Tested extensively, including user tesƟng, and implemented in producƟon.

• Produced numerous user reports using stored procedures and iReport.

• Built data extracƟon interfaces between two major credit insurance systems. (mulƟ-year project) o Gathered business needs and technical requirements of the two systems. o Developed the data interfaces using dozens of SQL Server database triggers and stored procedures. o Tested extensively, including user tesƟng, and implemented in producƟon. o Delivered ongoing post-implementaƟon new features and bug fixes.

• Built data screens for the original Compass credit insurance system. o Gathered business needs and technical requirements. o Designed and developed the screens for credit insurance risk analysis using PowerBuilder and SQL Server. o Tested extensively, including user tesƟng, and implemented in producƟon. o Delivered ongoing post-implementaƟon new features and bug fixes. TECHNICAL PROFICIENCIES

• Programming Languages: MicrosoŌ T-SQL, Postgres SQL, Java, XML, PowerBuilder, Cobol

• Databases and SoŌware: MicrosoŌ SQL Server, PostgreSQL, SQL Server Management Studio (SSMS), DBeaver

• ReporƟng SoŌware: SQL Server ReporƟng Services (SSRS), iReport, Jasper Reports

• Tools and Technologies: SQL Server IntegraƟon Services (SSIS), Git, Jira, Confluence, Eclipse, Splunk, WinSCP EDUCATION

NER ISRAEL RABBINICAL COLLEGE, Pikesville, Maryland Bachelor’s Degree - Talmudic Law

CONTROL DATA INSTITUTE, BalƟmore, Maryland

CerƟficate - Computer Programming

LEARNING TREE INTERNATIONAL, Herndon, Virginia

CerƟficate - SQL Server ReporƟng Services

CerƟficate - Java Best PracƟces and Design PaƩerns Training CerƟficate - Struts 1 for Enterprise Java Web Development: Hands-On CerƟficate - IntroducƟon to Java Programming Training Doneel Edelson 410-***-**** adzjux@r.postjobfree.com



Contact this candidate