 created the Typescript components, modules, and services to consume REST APIs using component-based architecture provided by Angular.  Worked on Microservices and REST/API for the mortgage loan originator Application.  Created database core objects, such as Stored Procedures, Functions, tables, views, triggers, and so on.  Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of database.  Worked in Agile Development and SDLC lifecycle.  Used GIT as a version control tool, and Azure DevOps for the User Stories and Bugs tracking

Roles and responsibilities include working as Principal software engineer on a multitude of projects and client engagements, designing and developing Business Intelligence and customized solutions based on Microsoft technologies and SharePoint solutions for portals, collaboration, and content management using SharePoint server technologies. Role as Principal Software Engineero Work directly with client to understand, clarify, and extract business/functional requirements. o Break-down business requirements into technical/task activities and provide best-effort design and estimate for implementation.o Efficiently manage own and team schedule, availability, and can distribute work among project members according to their skillsets.o Contribute as primary .NET/Database/SharePoint developer (responsible for the majority of deliverables) in client projectso Leverage information provided in business/functional requirement to create test case, validation script prior to actual project work.o Apply critical thinking skill to analyze issue and steer senior/junior members in the right direction to determine the proper solution.o Produce consistent and high-quality work that conforms to best practices, industry standard.o Help guiding Senior/junior resources in improving their work output (coding as well as non-development activities)o Follow and contribute to improve standard followed by all team members (coding standard, operating procedure, best practices on production environment, etc.) and be directly responsible for any delay and slippage of own and the other members work.o Execute unit testing and coordinate integration test to ensure quality delivery.

 Contribute as primary .NET/SharePoint developer (who are responsible for the majority ofdeliverables) in client projects Break-down business requirements into technical/task activities and provide best-effortestimate for implementation. Perform necessary research and construct quick proof-of-concept solutions. Leverage information provided in business/functional requirement to create test case,validation script prior to actual project work Apply critical thinking skill to analyze issue and steer junior members in the right direction todetermine the proper solution Thoroughly understand and apply the knowledge of different SDLC and all documentationrequired at each stage; and can easily create these documents when requested. Produce consistent and high-quality work that conforms to best practices, industry standard. Help guiding junior resource in improving their work output (coding as well as nondevelopmentactivities). Provide quick technical, SharePoint development introductory training to induct new teammembers upon request. Follow and contribute to improve standard followed by all team members (coding standard,operating procedure, best practices on production environment, etc.) and be directlyresponsible for any delay and slippage of own and junior members work. Execute unit testing and coordinate integration test to ensure quality delivery. Fully aware of project progress and timeline to ensure work slippage or roadblocks areidentified early and handled properly.

working as Database Developer to design, implement Data models in SQL server database, manage and troubleshoot the system and database issues, performance tuning in mid-tier and database backend, and worked closely with the teams to implement high quality application.• Technologies: SQL Server 2008 R2/2012/2013, Visual Studio 2010/2012/2013, Ants Profiler, SQL Profiler, ASP.NET with C#, VB.net, ADO.NET, Ajax, Jquery, HTML/DHTML, CSS, Microsoft team foundation, Enterprise Architect, Re-Sharper, Windows Server 2008 R2, IIS7.• Role and Responsibilities:o Responsible for the performance tuning on the stored procedures, functions, and scripts in SQL Database, and created proper indexes to improving query execution time.o Wrote the queries to create/update Stored procedures, Functions, Triggers, Tables, and Viewso Responsible for the performance tuning in the middle to reduce the DB calls. Utilized tool ANTS Profiler to analyze the hot spots in the system for performance enhancement.o Worked on the root cause analysis and the fixes for production Defectso Worked with teams to implement the application in C# and .neto Wrote Tsqlt Database unit tests for stored procedures, functions in SQL server 2008 R2, SQL Server 2012, o Wrote Unit tests and integration tests in C# for the system.o Helped the Engineer support team to work on the application tickets which were requested from clients, created the proper scripts and solutions for the data and system fix.o Utilized Enterprise architect to create the Database documents such as database dictionary, Data models, ER diagrams, etc.o Ran the performance tests to compare the performance reports on different builds in Visual studio 2010/2012/2013

Worked on various projects of web applications(vb.net, C#, asp, ado.net, LINQ), Business Portals (SP 2010, Moss 2007, WSS 3.0, and DotNetNuke), Reports (Microsoft SQL reporting service and crystal reports), MS Business intelligence (MS SQL Server 2008/2005/2000), GUI interface design (Photoshop, HTML, CSS, Javascript). Applied strong supporting skills in trouble-shooting and server configuration.Performance optimization (Application and SQL query)

Activities: Collected the all system requirements based on the existing system and database, and Business users  Analyzed the entire system based on the requirements, developed the specifications for the system Created DTS in SQL server 2000 to set up daily data transferring and splitting job from MS Access to SQL Server 2000  Developed the entire new web system from GUI front-end to Database back-end Integrated all modules and subsystem and conducted regression test for entire application Applied new technologies to the systems for online search engine optimization Documented the software implementation and the user run books Deployed applications in IIS on company server Implemented window applications for company management applications Supported MS Windows server 2003, SQL 2000, IIS server and associated networked systemsTechnologies:ASP.NET with C#, VB.net, VSS (Visual SourceSafe 6.0), SQL server (Triggers, Stored Procedures, DTS), ADO.NET, ASP, Microsoft Access, ADO, VB, JavaScript, VBScript, HTML/DHTML, Photoshop, CSS, Windows Server 2003, IIS and SMTP.

Collected the system requirements from company existing system and database, and company's departmentsAnalyzed the entire system based on the requirements, developed the specifications for the systemCreated DTS in SQL server 2000 to set up daily data transferring and splitting job from MS Access to SQL Server 2000 Developed the entire new web system from GUI front-end to Database back-endIntegrated all modules and subsystem and conducted regression test for entire applicationApplied new technologies to the systems for online search engine optimizationDocumented the software implementation and the user run booksDeployed applications in IIS on company serverImplemented window applications for company internal management systemSupport and maintain Windows server 2003, SQL 2000, IIS server and associated network systems Technologies:ASP.NET with C#, VB.net, VSS (Visual SourceSafe 6.0), SQL server (Triggers, Stored Procedures, DTS), ADO.NET, ASP, Microsoft Access, ADO, VB, JavaScript, VBScript, HTML/DHTML, Photoshop, CSS, Windows Server 2003, IIS and SMTP.

Activities: Collected payroll system requirementsDesigned, developed user interface technical specifications for a payroll database systemDeveloped the entire payroll system from front-end to back-endIntegrated all subsystems and conducted system test for the entire applicationDeveloped the software implementation, documents, and user tracing guideDeployed applications in IIS on Company ServerSupported MS Windows server 2003, SQL 2000, IIS server and associated networked systemsTechnologies:ASP.NET with C#, VSS (Visual SourceSafe 6.0), SQL server (Triggers, Functions, and Stored Procedures), ADO.NET, JavaScript, XML, SOAP, HTML/DHTML, CSS, Windows Server 2003 and IIS.

Activities: Collected system requirements for Internship Department at Cal-State Fullerton Designed CISL system with database including module specification and user interfaces Delivered the entire CISL system from front-end to back-end Integrated all subsystems with Campus system and conducted system test for the entire application Developed the software implementation, documents, and user tracing guide Rolled out applications in IIS on Campus ServerTechnologies:ASP.NET with VB.NET, VSS (Visual SourceSafe 6.0), SQL server (Triggers, Functions, Stored Procedures and DTS which is used to transfer data within three different servers in daily), ADO.NET, JavaScript, HTML/DHTML, CSS, Windows Advanced Server and IIS.

Designed CISL system with database including module specification and user interfacesDelivered the entire CISL system from front-end to back-endIntegrated all subsystems with Campus system and conducted system test for the entire applicationDeveloped the software implementation, documents, and user tracing guideRolled out applications in IIS on Campus Server