Title:  Lead Consultant

Required Skills:

Experience in the software development life cycle including Requirements, analysis, design, development, testing and implementation of HR / Payroll applications using DOT NET, Oracle PL/SQL, HTML, JavaScript,

  Angular JS, jQuery CSS.

Experience with SQL Server, SSIS ,SSRS ,Oracle 19C, DOT NET framework with VB and C# languages, ADO.NET, SAML 2.0, Web frameworks ASP.NET MVC, ASP.NET Core, Communication frameworks like WCF, Web Services, worked with Microsoft IIS 6.0/7.0/8.0/12.0

Worked with TOOLS & UTILITIES like GIT, VSS, TFS, SVN, Microsoft Visual Studio, Sql Server Management Studio, TOAD, SQL Plus, Oracle SQL Developer, Erwin Data modeler, AJAX2.0, Active-X, COM, MTS, XML, Xpath, XSLT,: HTML, DHTML, CSS, Fiddler, JAVA SCRIPT, JQUERY Widgets , VB SCRIPT, Bootstrap, SQL Server Integration Services (SSIS), Erwin Data Modeler, VISIO, and REPORTING TOOLS SQL Server Reporting Services (SSRS), CRYSTAL Reports

Experience in designing, developing, testing, and implementing complex DOT NET programs including database programs using Oracle PL/SQL. Worked on the Oracle SQL queries and PL/SQL objects like functions, procedures, packages, triggers, views including materialized views, db_links, sequences, cursors, transactions, dynamic SQL queries, exception handling.

Good knowledge and Experience in understanding of Excel Macros

Experience in managing production support activities, debugging / fixing DOT NET code and Sql Server / Oracle objects.

Optimizing performance of existing DOT NET/ Oracle code, Oracle queries, stored procedures, packages, functions using explain plan.

Experience in working closely with QA teams and reviewing test plans.

Experience in assessing and solving complex issues imposed by nature of business, also, to carry out detailed impact assessments for proposed change requests, proposing alternative cost-effective solutions where appropriate.