neil ramrattan

• Code/update SQL Server Integration Service packages for ETL of Oracle, SQL Server and MS Excel workbooks • Create/update SQL Server functions, stored procedures or triggers as per business requirements • Ad hoc SQL scripting and data analysis • Write/update technical and user documentation for supported applications

 Code/update ASP.NET MVC, Webforms, WinForms applications  Create/update Oracle functions, stored procedures or triggers as per business requirements  Ad hoc SQL scripting and data analysis using PL SQL Developer tool  Application Support (desktop, web, MS Access, Excel), used by multiple internal and external business clients  Write/update technical and user documentation for supported applications

 Code/update Xaml files and corresponding ViewModels, and Models to satisfy user story requirements  Code/update interfaces/classes; utilized inheritance and override base methods where appropriate  Add/update objects within Entity Data Models (Entity Framework)  Code/update LINQ queries  Create .sql files and update .wxs files to inject CRUD operations into application install process  Build release code and check in to TFS main branch; branching and merging; Continuous Integration.  Coordinate with Test Automation team on automated smoke tests and resolve problems  Perform user story refinement, finalize and create tasks on scrum board (VSTS)  Update Software Design Documents before and after completion of user stories  Perform feature demonstrations to BA’s, Product Owners and Verification team  Test Driven Development, utilizing the Moq framework, maintaining coverage at 80%+  Update hardware emulator service that connects to the desktop application  Perform code reviews of other developers’ work  Collaborate with software architects on application design best practices and optimization  Utilize design patterns such as MVVM, Dependency Injection (IoC), Repository, Unit of work, Factory  Work with the Break Fix team to resolve bugs  Familiarity with Lightning Charts (Arction) for graphical display of studies’ channel data  Familiarity with GDPR, HIPAA act and FDA rules as they pertain to software development practices