Chaim Spear

Rockland County, NY

917-***-**** 929-***-**** ad24d4@r.postjobfree.com http://chaimspear.net https://www.linkedin.com/in/chaim-spear-87020ab

SENIOR SOFTWARE ENGINEER\COMPUTER PROGRAMMER

Senior software engineer\computer programmer professional with extensive experience in writing desktop applications, coding web applications and doing extensive work with Oracle and general SQL development.

Aside from the actual development work, I have been heavily involved in production support with troubleshooting

and have managed several projects end to end.

SKILLS

Software Development (Coding\Scripting)

Oracle\Database Development

GUI Design

Debugging & Troubleshooting

Production Support

Project Management

TECHNOLOGY SUMMARY

Front End DEV: HTML, JavaScript, Blazor, MudBlazor, CSS, Babylon.js, jQuery, jQuery UI, jqGrid, React.js, Angular (2), TypeScript, Knockout, Kendo, Video.js, Storybook

Back End DEV: C#, Python (3), WinForms, ASP.NET (Web Forms), MVC (3,5), ASP.NET Core 1-3.1, .NET 5-7, LINQ, Entity Framework, Node.js, Oracle PL/SQL, Twilio, Slack API, Zoom API, JSON, XML, Storybook, Delphi, Classic ASP, Classic Visual Basic, Cold Fusion

Databases: Oracle (8i,9i,10g,11g,12c), SQL Server (2012, 2016), MS Access, Redis

Cloud: Azure

Other: NPM, Git, JIRA, IIS, Agile\Scrum\Kanban

FINANCE RELATED SUMMARY

Financial concepts such as corporate entities and structures, understanding financial statements, basic security laws, understanding of stocks, options trading\investing and a solid understanding of investment principles in general etc.

PROFESSIONAL EXPERIENCE

Upwork Freelance Job

Full Stack .NET Blazor Developer 12/2023 - Present

●Directing best practices by guiding the team to use DevOps Tasks (Microsoft's Jira like task system), git branching and code reviews.

●Enhancing and Modifying a .NET Blazor WASM application, hosted by .Net Core on the backend, which utilizes MudBlazor components, a SQL Server database and Azure Blob Storage to store files.

●Added new web pages and features in the front end UI (Blazor WASM).

●Created Custom Blazor components, and re-engineered parts of UI to use the Blazor components, while reducing redundant code.

●Developed .Net Core Services for the new web pages and features .

●Developing new tables and stored procedures in SQL Server.

●Using Azure Blob Storage to save files using C# .

Transaction Scanner project

Architect and Developer 2023 - ongoing

●Transaction Scanner http://transactionscanner.us will be used for customers to monitor transactions, see patterns and trends and help detect fraud.

●Designing and Developing ‘Transaction Scanner’ using .Net 7, C#, Blazor WASM, MudBlazor and SQL Server.

●Developed the front end using Blazor WASM and MudBlazor.

●Developed the back end .Net Core, C# APIs called by the front end,

●Designed and Developed the SQL Server database, including the tables, functions, stored procedures, table types and the complex queries.

●Developed Custom Blazor components, which is used throughout the application .

Bank of America, Jersey City, NJ

Consultant - Senior Developer\Application Architect 08/2022 - 10/2023

●Enhancing financial service application APIs involved in calculating balances, payments and other financial information using C# with REST APIs, and some SQL Server and Oracle development.

●Working on an Agile team with Jira to review (and enhance) requirements, do code reviews and help coordinate releases.

Credit Suisse, NC and NY

Consultant - Senior Developer 04/2021 - 08/2022

●Maintaining and developing applications in C# and the .NET environment that utilizes Active Directory and 3rd party vendors (APIs) such as Zoom, Slack etc.

●Researched and implemented advanced ZOOM and SLACK API features .

●Collaborating with team members and business users to create and fine tune requirements.

●Developing import programs to import conversations from SLACK using the SLACK API into SQL Server, using complex Database objects\types in SQL Server to bulk load large amounts of data.

IBM, NY

Consultant - Senior Developer 12/2020 - 04/2021

●Maintained an HR application for an end client, written in C#, JavaScript, jQuery with a SQL Server database, which used Stored Procedures extensively.

Elsevier, PA and NY

Consultant (through Kforce) - Senior Developer 11/2019 - 08/2020

●Maintained and enhanced applications for the clinical solutions products, which include patient care and health education (libraries and videos), using ASP.NET, C#, JavaScript, jQuery, Reacts.js (with Redux and Saga), Node.JS with SQL Server and using AWS S3 buckets for file storage .

●Developed custom library components using React.js, with Storybook used for demos, and using Jest for unit-testing.

●Enhanced users video watching experience using the video.js library for the clinical solutions products.

●Worked on a squad team to track our work progress, do code reviews and exchange ideas.

Bank of America, Jersey City, NJ

Consultant (through Matlen Silver) - Senior Developer 04/2018 - 10/2019

●Maintained and enhanced internal applications in the compliance department, using ASP.NET (Web Forms), C#, JavaScript, jQuery with SQL Server.

●Coded enhancements and optimized C#, JavaScript\jQuery code including Kendo and Knockout .

●Wrote, Designed and modified SQL Server Tables and Stored Procedures.

●Worked in a Scrum\Kanban team, with other developers, business analysts and a scrum master, where we shared our ideas, suggested features and enhancements.

●Used Jira in our Scrum\Kanban team, to track our progress in the various different projects we worked on.

●Extensively used Git for source control, branching, pull requests and to reference Jira tasks.

IDT Corp, Newark, NJ

Programmer/Web Developer/Oracle Developer 03/2004 - 02/2018

●Developed and maintained C# web applications using ASP.NET (Web Forms), ASP.NET MVC & ASP.NET Core, with JavaScript, jQuery & Angular frameworks.

●Developed and maintained C# & Delphi front end applications and back end utilities.

●Wrote, Designed and modified Oracle tables, triggers, packages, functions, procedures and scripts.

●Optimized queries in Oracle & added indexes, foreign keys and partitions to tables.

●Maintained existing Cold Fusion, Classic ASP web pages.

●Developed Brio reports.

●Worked with business users from several different departments to work out suitable solutions for their business needs.

●Handled real time production emergencies.

●Used github, including forking projects and merging\handling pull requests.

●Set up and configured internal, windows based websites through IIS .

Notable Accomplishments

●Wrote an in house phone number utility, REST API, which was written in ASP.NET Core 2.1, would interact with a Twilio interface and use a REDIS database .

●Designed, developed, managed and maintained a company wide fraud system for Calls and Transactions.

Key components

Developed the ASP.NET, MVC, C# web pages for the business users to manage and monitor the system

Developed the backend C# Windows application\utilities involved with the project

Designed and wrote the Oracle tables, packages etc.

Worked with the business users to get the requirements, and continuously worked with and supported the system\users

●Created an in house Invoice generating system, which gets emailed or printed and mailed to customers.

●Designed and developed an in house event based emailing system, which emails customers based on email events, with custom email templates for each event type.

Worldco LLC, New York, NY

Programmer/Web Developer/Oracle Developer 02/2000 - 10/2003

●Developed Delphi applications with Oracle and/or SQL Server database.

●Wrote and maintained Classic ASP web pages with Oracle databases.

●Wrote Oracle triggers, packages, functions, procedures and scripts.

●Created Crystal Reports for web applications.

●Dealt with financial/brokerage production support issues, including day trading rules, PL, fees, clearing, operations and compliance issues.

Electronic Sales Systems, New York, NY

Programmer/Web Developer 12/1998 - 11/1999

●Wrote Cold Fusion web pages with SQL Server.

●Built COM objects and custom Cold Fusion tags (CFX tags) using Delphi.

●Designed SQL Server database tables, views and stored procedures.

NON-PROFESSIONAL EXPERIENCE (Recent)

2021

●Learned Microsoft Blazor and developing some small web based games in Blazor WASM ( https://happy-bell-2be167.netlify.app, https://happy-bell-2be167.netlify.app/Animals and https://jovial-hugle-ccdfe1.netlify.app )

●Learned Babyon.js and implementing it for non professional use and as a showcase site for myself http://chaimspear.net

2020

●Learned Python using online resources, including practice problems from HackerRank.

●Developing a simple engaging topic related trivia web application in React.js to enhance my skills in React.js ( http://funreactgames.ga/ ).

PROGRAMMING EDUCATION

Cope Institute, New York, NY

Student 09/1997 - 04/1998

Completed a course in computer programming using C, Visual Basic, SQL,

Oracle and UNIX (including shell scripts).

Contact this candidate