Arsen Orins
Consultant Programmer Db Architect @EY
Signup · Get unlimited contacts
WORK HISTORY
Consultant Programmer Db Architect @EY
New York, NY, US
Designed new features and maintained existing functionalities in the PERE/GTP DBs and Collibra governance tools for company utilizing MS SQL Server (on-Prem & Azure), Erwin, T-SQL, DevOps, SSMS, PowerShell, CI/CD, Collibra API, VBS, XML/JSON, SSIS/pipelines, batch (BCP), VBA.• Proposed an idea, designed, developed. and implemented DB Historical Execution Log (DBHEL) structure/process to track stored procedure executions with all details (time, parameters, errors & so on) and query to analyze. Technology: PowerShell, MS SQL Server (Azure), SP, JSON.• Designed, developed,% implemented process to reconcile SQL Server DBs with Erwin logical/physical models (ErSync). ErSync has processed over Erwin files in GIT Repo. Technology: Erwin, PowerShell script, Excel VBA, T-SQL, XML/JSON, csv files. • Designed, coded. and implemented ETL Migration Process to move client related notification data to corporate Azure DB/warehouse. Replaced ADF pipelines with PowerShell code & simplify dataflow from DB/blob storage. Built/loaded snowflake warehouse. Technology: PowerShell, MS SQL Server (Azure), T-SQL, SP, JSON, Data Vault, snowflakes/star warehouses (Kimbell approach), CI/CD (RedGate SQL automation tools).• Prototyped, designed, developed, and implemented universal DB Testing Suite (UDBTS) to verify modified(new) functionality and automatically determinate if release is ready for the next environment. Formed help, procedures, & standards for developers to create/store test files. UDBTS reduced 90% manual work & made validation process 100% reliable. Technology: MS SQL Server 2016, T-SQL, DDL, DML, VBS, XML/JSON.• Investigated Collibra manual approach to create asset types and came up with alternative solution to design business models/data dictionary/ reference data using regular Excel files, reduce the learning curve and make regular users very comfortable to handle it with full Excel automation. Technology: MS SQL Server 2016, T-SQL, SP, Excel VBA, Collibra API.
EDUCATION
Kharkov Polytechnic University, Ukraine
Master of Science (MS)
SKILLS
ABOUT ARSEN ORINS
Programmer/Analyst with over 15 years of comprehensive experience across all phases of…
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.