Architect Developer

Anil Singhal

917-***-**** ************@*****.*** US Citizen Alpharetta, GA 30022

Summary of specialization:

** ***** ** ** ******** experience

Over 7 years of experience in Software Architecture using various design patterns and solid Principles

Enhanced various architectures including Network Architecture, Application Security (Authentication/Authorization/Encryption/Decryption), Application Architecture, Application design, application implementation, Application testing, delivering complete solution to Production, Database Architecture, Data Migration and Systems, Gap Analysis/impact analysis, etc.

Lead various projects at department of education, KPMG, AT&T etc. using Agile and waterfall approach.

Delivered/studied Cloud Based system using Azure PaaS Services for various clients including Institute of Physics, KPMG, JPMC, and Windy Bay Power.

Up to 13 years of experience delivery products in .NET, ASP.NET Core, MVC, C#, EF 6.0, ASP.NET, AngularJS, Bootstrap, JQuery, JavaScript, SOA, Windows Form, WCF, WPF, SSIS, DTS, Wire frames, SQL Server, WCF, WebApi etc. technologies, and Over 5 years of experience using Oracle, Java, various Scripting languages, and various UNIX platforms.

Technical skills:

Architect Expertise: Design Patterns, Solid Principles, Application Architecture & Design, Database Architecture & Design, TDD, Data warehouse Architect, SOA/Saas

Window Platform Programming: .Net Core, C#, ASP.NET Core MVC, ASP.NET, Windows Form, WPF/XAML 4.0, HTML, CSS, Ninject, DI, Web Services, Restful, WCF, WebApi, WSE 3.0/2.0, WSCF.Blue, XML, XSLT, ADO.NET, EF, SSRS,

JavaScript Technologies: JQuery, AngularJS, JavaScript,

Database Technologies: SQL Server, SSIS/DTS, Batch file, T-SQL,

UNIX Platform Programming: Solaris, Linux, Shell Scripting, Java, PL/SQL, SQL*PLUS, Oracle 11g/10g, PERL, SED, AWK, AIX, VI

Design Patterns: MVC, MVVM, Singleton, Abstract Factory (SOA/Polymorphism), Factory methods(lazy loading), Proxy, Bridge, Mediator, Observer, Prototype, Flyweight (object pool),

Tools Used: IIS, Visual Studio.NET, Visio Pro, UML, ERWin, Office, JIRA

Testing: TDD, Unit Testing,

Education:

Microsoft Certified SQL Server 2008 DBA

Sacred Heart University, Fairfield M.S. Computer Science 05/2006

Wright State University, Dayton B.S. Computer Science 12/2001

Professional experience:

Watching Party (Personal Projects and other personal projects) July 05, 2019 to Present

.Net Application Architect

Working on various personal projects which could help host a party in virtual environment as well as a project related to Budgeting the expense which could help allocate money based on previous spending and given priorities using .Net Core, SQL Server, C#, ASP.NET, MVC, WebApi, Jquery, etc.

Opteamix Jan 14, 2019 to Jul 05, 2019

.Net Application Architect

Updated and migrated many. net applications for new servers

Updated and migrated SSIS packages to Windows Server 2016 from Windows Server 2008

Designed and Developed new asp.net web applications using C# and SQL server 2016

VIVA USA Columbia, SC Aug 2018 - Oct 15, 2018

.Net Application Architect/Lead

Proposed possible solutions to support future functionality and extended Batch Process Framework (it is in-house designed and developed framework where job can be added by writing c# code and later they can be run at scheduled time) using C#

Processed various data using C# into the existing framework

Delivered projects ahead of schedule

Personal Research Project 09/22/2015-04/07/2017

I was performing research on personal project.

Technologies Used: Visio 2010 Pro, UML, C# 4.5, ASP.NET MVC, T-SQL, SQL Server 2016, Angular JS 2, Windows 10, IIS 8.5, Visual Studio.NET 2015, Excel 2010, Word 2010 etc.

JPMC, Jersey City 06/17/2015-09/17/2015

Sr. Application Developer/Architect

Converted four legacy .Net Projects into 4.5 .Net framework with Entity Framework and provided guidance various approaches in multiple areas pertaining to New Hardware and Applications.

Identified right amount of hardware for New Servers.

Brain stormed various feasible solutions within Agile Team to address any upcoming issues so they can be addressed before they arise.

Helped laying down the foundation for New Servers so multiple applications can be fed with real-time data with full centralized approach.

Technologies Used: Visio 2010 Pro, UML, C# 4.5, ASP.NET MVC, Entity Framework, T-SQL, SQL Server 2012, Window Server 2012, IIS 8.0, Visual Studio.NET 2013, Excel 2010 etc.

North Shore Hospitals, Melville 01/06/2014-04/06/2015

Sr. System Analyst/Technical Architect

Re-Architected, Redesigned and helped developed all applications layers including brand new Security Layers and web layer to track patients’ health using C#, MVC4, Linq, Entity Framework, WebApi to support multiple platforms, WCF, JQuery, JavaScript, Handlebar, AngularJS, Bootstrap, React, and Ember JavaScript frameworks, Xamarin Mobile Platform, as well as other JavaScript frameworks etc.

Redesigned and designed GUI for the new/existing requirements as well as provided End to End solutions to feed or support various applications.

Worked in Agile environment to address previous day issues and provided recommendations.

Architected, Designed, and Developed Data Warehouse from scratch using Star Schema, Visio, and SSIS packages so data can be retrieved from multiple insurance companies and hospitals, standardize the data format, and store the data into well designed (search oriented) SQL Server 2012 data warehouse to feed various systems.

Technologies Used: JQuery, AngularJS, Bootstrap, HandlebarJS, EmberJS, ReactJS, Visio 2010 Pro, Agile, UML, Visio 2010, C# 4.5, ASP.NET MVC, Linq, Entity Framework, T-SQL, SQL Server 2012/2008 R2, Window Server 2008 R2, IIS 7.5, Visual Studio.NET 2013, Excel 2010 etc.

American Institute of Physics, Melville 11/06/2013-12/31/2013

Senior .NET Architect (Consultant)

Architected, Designed and Developed SOA multi-tier two web projects using ASP.NET, MVC, C#, Entity Framework, HTML, JavaScript, AngularJS, HandleBarJS, ReactJS, Bootstrap, JQuery, CSS, and SQL Server from scratch.

Implemented solution using various Azure Paas Services including App Service, Key Vault, APIM, Azure Service Bus

Developed optimized search engine from scratch to find articles based on keywords.

Aggregated multiple data from many sources using Multithreading to show the management where they are with sales and profits.

Created new database tables to support additional functionality including stored procedures, triggers to support additional business requirements.

Technologies Used: Visio 2010 Pro, UML, Erwin, Entity Framework, C# 4.5, T-SQL, SQL Server 2008, Window Server 2008 R2, IIS 7.0, Visual Studio.NET 2012, Excel 2010 etc.

KPMG, Mountville 04/25/2013-10/31/2013

Senior .NET Architect (Consultant)

Architected/Designed/Delivered various complex SSIS packages/ETL Programs using C#, T-SQL, Batch files, Database tables, triggers, and SSIS Controls.

Designed, implemented, and Deployed using various Azure Paas Services including App Service, Key Vault, APIM, Azure Service Bus

Resolved various issues including Architect, design, and implementation issues as Team Leader; communicated issue status to business users’ timely manner.

Provided many solutions to complex problems quickly and delivered projects ahead of schedule.

Developed various batch files and C# utilities to retrieve/deliver files from/to different files systems using ftp, http, shttp, and sftp.

Technologies Used: Visio 2010 Pro, UML, Erwin, C# 3.5, Entity Framework, T-SQL, SQL Server 2008, Window Server 2008 R2, IIS 7.0, Visual Studio.NET 2008, text files, CSV files, Excel 2010 etc.

NYC Dept. of Education, Brooklyn 10/03/2011-04/24/2013

Senior Architect/Lead (Consultant)

SOA Architected, Designed, and Developed 4 different multi-tier applications (including Online Classes Creation Tool, Work Flow System from scratch, Role Based System/Authorization Tool which can be incorporated into multiple applications, and AD/LDAP authentication API to support all Department’s applications) using MVC4, ASP.NET C#, Linq, AngularJS, Bootstrap, JQuery, Restful multi-tier application from scratch.

Resolved various design issues in existing applications as a Team Lead and help team members to resolve issues pertaining to new development.

Developed WCF services and client proxies from scratch, and changed existing functionality of various web services which were used on different protocols and hosted on IIS and as window services.

Enhanced various stored procedures in SQL Server and Oracle.

Technologies Used: C# 4.0, ASP.NET MVC 4.0, UI, AngularJS, Bootstrap, JQuery, MVVM, WPF, XAML, WCF, WSCF.blue, WSE 3.0, SoapUI, Fiddler, FireBug, ADO.NET, LINQ, AJAX, Entity Framework, AngularJS, JQuery, ODBC, AGILE, Telerick, T-SQL, SQL Server 2005, Window Server 2003, IIS 7.0/6.0, Windows XP, HTML, CSS, JavaScript, Visio 2007 pro, Visual Studio.NET 2010, Web Services, flat files, CSV files, Excel 2007, UML 2007 etc.

Windy Bay Power LLC (Energy Trading Company), New York 09/16/2008-06/30/2011

Senior Application & Database Architect/Developer

Designed & Developed SOA ASP.NET MVC 3.0 C# multi-tier Trading Web Platform application including integrate third party platforms where Power Market Traders view their hundreds of customized reports, submit their bids to external systems using various services.

Created Systems and subsystems to retrieved thousands of data feeds per day from private and public internet data sources (via ftp, HTTP, APIs, web services, scraping) to store into SQL Server 2008 and SQL Server 2008 R2.

Created hundreds of ETL SSIS packages to upload various type of files (csv,txt, xls, xml etc) into database and to make files downloadable in CSV format from website and Window’s application. Built data warehouse from scratch to support reporting project.

Designed and developed various reports including Email Reports, Mobile Phone Reports, Google Charts using Google Chart API and MS Charts to embed them into asp.net application.

Deployed .net applications on Azure Cloud based platforms to reduce cost for the client.

Technologies Used: C#, ASP.NET, ASP.NET MVC3, ADO.NET, WPF/XAML 4.0, GUI, LINQ, AJAX, WCF, WSE 3/2 Entity Framework, JQuery, RAD, ODBC, AGILE, Telerick, T-SQL, SQL Server 2008, Window Server 2008, IIS7.5/7, Windows Vista, HTML, CSS, JavaScript, Visio 2007 pro, UML, Visual Studio.NET 2010/2008, Google Charts, MS Charts, Web Services, flat files, CSV files, Excel 2010/2007 etc.

AT&T (Research & Development Center), Middletown 07/24/2006 – 09/12/2008

Senior Application Architect/Developer (Consultant)

Designed and Developed Two Complex ASP.NET C# multi-tier applications “Dispute Tracking System” and “Collection Tracking Tool”; Incorporated SSO into these two applications.

Designed and developed TFS like product for AT&T as internal Unix Based Source Code Management System tool.

Leading and mentoring other offshore developers about their part of projects & helped developed functionality from scratch.

Created migration plan, disaster planning, rollback plan, combining existing hardware architecture and software architecture to use existing resources efficiently.

Technologies Used: C#, VB.NET, ASP.NET 2005/2003, GUI, HTML, ADO.NET, Java, SQL Server 2008/2000, Window Server 2008/2003, Windows XP, VB, VBScript, JavaScript, Visio 2003, Visual Studio.NET 2003/2005, Visual Source Safe 6.0, Web Services, ADO.NET, notepad, Excel 2003, Access 2003, XML etc.

Commerce Bank Inc. (Completing my Masters at this time), New York 07/18/2005 - 07/22/2006

Customer Service Representative

Performed various duties as required or assigned including handling customer inquiries, introducing producing to customers, open new accounts, and wire transfer for clients nationally & internationally.

QSR Concepts Inc., New York 01/21/2002 – 07/15/2005

Senior Application Developer (Consultant)

Developed Shipment System which was written many different languages including PL/SQL, C++ and Java on UNIX and Windows platforms to perform activities such as ordering, calculating of price, and transferring data from local server to central server of the company when order was shipped.

Optimized existing infrastructure and created sophisticated SQL Server databases to responsively handle complex queries and .NET data access components

Designed Skeleton for large application using .NET Web Forms. Used Crystal Reports to create reports based on SQL Server database. Envisioned and built front-end for the site designed in .NET.

Enhanced distributed application using multi-threading and object orient techniques. Completed Implementation of Remote C program to data transfer between many computers and perform operations using C and korn Shell on UNIX (Solaris and AIX) platform.

Technologies Used: VB 6, ASP, Visual Studio 6.0, SQL Server 2000, Windows Server 2003, Visual Studio.NET 2003, VB.NET, C#, ADO.NET, ASP.NET, XML, VBScript, HTML, DHTML, JavaScript, Dreamweaver, HTML, CSS, C/C++, Solaris, Oracle 9i, Crystal Reports 9

Harco Brake System, Subsidiary of GM, Englewood 03/14/1999 – 12/31/2001

Oracle Developer, Quality Assurance – Systems Analyst

Developed database architecture with normalized tables, Developed and enhanced packages, procedures, and functions using PL/SQL.

Developed Database triggers

Tested Unit & Integration test cases

Tuned Performance

Technologies Used: IBM-AIX, UNIX, Shell Scripting, ORACLE 9i/8i, PL/SQL, SQL*PLUS, C, PR*C

Contact this candidate