ANIL SINGHAL

917-951-8540 | | US Citizen | ALPHARETTA, GA 30022

SUMMARY OF SPECIALIZATION:

  • 13 years of IT industry experience and 7 years of experience in SOA including TDD, IoC/DI etc.
  • Played key/main role every part of the projects 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.
  • Up to 12 years of experience delivery products in .NET, MVC4.6, 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:Application Architecture & Design, Database Architecture & Design, Test Driven Development, Data warehouse Architect, SOA

Window Platform Programming:MVC/ASP.NET/C#,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, HandleBar, ReactJS, EmberJS

Database Technologies:SQL Server, SSIS, 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, Factory methods,

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

Testing:Unit Testing, White Box Testing, Black box testing, Regression testing

PROFESSIONAL EXPERIENCE:

Indian Embassy (Indian Government Project), New York09/22/2015-04/07/2017

Architect/Developer/Client Advisor

  • Architected and Designed (and partially implemented) Health Record System (ASP.NET, MVC, C#, SQL Server, JQuery, HTML, and CSS)which link patients, doctors, patient medical records, pharmacies, medical lab tests, diagnosis, prescribed medicines, appointments, etc. It was all-in-one complete medical record system which could do billing also for hospitals, clinics, medical labs, and pharmacies.
  • Assisted/Advised government on various government Projects including Driver License, passport, opening/closing Business, various data related projects such as birth certificate, death certificate, etc.
  • Advised Government on non-technical issues.

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

JPMC, Jersey City06/17/2015-09/17/2015

Sr. Application Developer/Architect

  • Converted four legacy .Net Projects into 4.5 .Net framework with Entity Frameworkand 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 AgileTeam 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 realtime 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, Melville01/06/2014-04/06/2015

Sr. System Analyst/Technical Architect

  • Re-Architected, Redesigned and helped developed all applications layersincluding brand new Security Layers and web layer totrack patients’ health using C#, MVC4,Linq, Entity Framework,WebApito support multiple platforms, WCF,JQuery, JavaScript, Handlebar, AngularJS, Bootstrap, React, and EmberJavaScriptframeworks, Xamarin Mobile Platform,as well as other JavaScript frameworksetc.
  • 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 DevelopedData 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 datainto well designed (searchoriented)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, Melville11/06/2013-12/31/2013

Senior .NET Architect (Consultant)

  • Architected, Designed and Developed SOAmulti-tier two web projectsusing ASP.NET,MVC,C#,Entity Framework,HTML, JavaScript, AngularJS, HandleBarJS, ReactJS, Bootstrap,JQuery, CSS, and SQL Serverfrom scratch.
  • 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.
  • 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.NETC#, 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 York09/16/2008-06/30/2011

Senior Application & Database Architect/Developer

  • Designed & Developed SOAASP.NET MVC 3.0C#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 retrievedthousands 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 Server2008 R2.
  • Created hundreds of ETLSSIS 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 Chartsto embed them into asp.net application.

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),Middletown07/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 ManagementSystem 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 York07/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 York01/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

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

Page 1 of 4