Amir Rafati

About Amir Rafati

I have 20+ yrs work experience in IT with 15+ yrs experience as BI Architect/Developer, SQL Server Analyst/Designer. I am expert at Microsoft BI stack (SSIS, SSAR, SSRS). In the past I worked as.NET Application Analyst/Developer, Project Manager in vast area of technologies for frontend & backend application development, Windows based & Browser based. Here are some of the software I worked with:•Relational databases (RDBMS): MS SQL-Server, MySQL, Oracle, MS Access & FoxBASE•Script languages: JQuery, JavaScript, DOM, CSS, ASP.Net, JSP, Java Servlets, HTML, XHTML & XML, SEO, LINQ, AJAX•Programming languages: C#, VB.Net, Java (JEE), Visual C, Groovy, Ruby on Rails, C++, Visual Fox, DELPHI, Assembler (IBM360 and x86), COBOL, FORTRAN & Pascal•Programming Frameworks: WPF, WCF, Hibernate, NHibernate, ASP.NET •IDE: MS Visual Studio, Adobe Dreamweaver, Oracle JDeveloper, JavaBeans, Eclipese•Microsoft office Suite: Word, Excel, Access, PowerPoint, Project, Visio•PM methods: Extreme, Agile, SCRUM & Waterfall SDLC, Extreme Programming•PM software: MS Project, MS Visio, MS Office suite, UML•PM Skills: Business process modelling & management (BPM), Business performance management, PPM, WBS, TOC, CCPM, PERT, DMS, EDM, ECMS, RMS•App. development models: Cloud Computing (SaaS) & n-tier Client Server architecture (online banking, e-commerce, Smartphone & Tablet Applications) & Grid computing•Web Content Man. Systems (WCMS): Joomla, DotNetNuke, MojoPortal, Drupal, WordPress•OS: Windows, Linux (Ubuntu, Red Hat, Android), Unix (Solaris)•Telematics: 802.11p, ICT (Information & Comm. Technology), Intelligent Transportation, Wireless Access for the Vehicle Environment (WAVE), Dedicated Short Range Comm.(DSRC), Odometry, dead reckoning, Fleet management, GPRS, EDGE, VOIP•Simulators: OPNET, QualNet, NS2 & MATLAB

Experience

1. Senior Software Engineer CDO Expert (Assistant Vice President) at Us Bank

   U.S. Bank

   Jul 2015 — Present · Irvine, CA, US

   Technologies: SQL Server 20••••22, SSIS, SSRS, SharePoint 2019, VB.NET, C#.Net, Visual Studio 20••••22, TFS and Gitlab, JFrog Artifactory, Active Batch Scheduler, MS Teams•Technical owner of Portfolio Optimizer (PO) a web app to meet Asset Managers to adjust and tune holdings in their CLO. Developed an ETL SSIS package to transfer over PO CLO assets from system of record database to PO database. In charge of Prod release and handling Prod incidents.•Automation of reconciliation process to match CLO cash transactions to incoming paid cash transactions. Transaction matching involves 1 to 1, 1-Many and Many-Many matches. Auto reconciliation process runs nightly processing over 280K transactions providing time savings to business users and improved accuracy.•Solutioned and implemented the conversion of database table primary key columns from datatype int to Bigint to preserve business continuity prior to the tables running out of unique values. Data conversion involved over 20 tables containing 2.5 billion rows. •Created an app for bulk loading of business users’ data (Excel or CSV) to the CLO application database. Loading process handles, validation, data transformation, error handling and logging results. Implemented bulk loading of Trades, the buying or selling of assets in a CLO. Trade loading involved strict processing rules and validation to preserve the integrity of the CLO transaction data. Examples are preserving the trade order, removing possible duplicates, skipping oversold trades considering pending or settled trades. •Created a monitoring SSIS package to identify the blocking spids, logging them and killing them.•Created a queuing system for daily and Ad hoc snapshot generation process to better utilize and reduce the chance of deadlock.•Created Waterfall payments process and compliance tests to CDO snapshot.•Created Sequence, groups and calculations to CDO as a new generation of assumption scenarios consumed by the snapshot process.

Education

• Islamic Azad University Central Tehran Branch

  Bachelor of Science (BSc), Computer Software Engineering

  1990 — 1994

• Nottingham Trent University

  Master of Science (MSc), Computer Software Engineering (machine vision)

  2002 — 2003