Sql Server C#

Albin Rajappa

Home: 703-***-****

Mobile: 703-***-****

VISA Status: US CITIZEN

Clearance: Secret

Email: *************@*****.***

Summary

·More than eighteen years of Professional IT experience in the development, testing and implementation of web applications solutions using C#, VB.NET, ASP, VB, ORACLE, MS SQL Server.

·Good understanding and experience with Software Engineering principles, Database Management System (SQL, PL/SQL) and Web application architecture.

·Good working knowledge of Oracle Packages and Stored Procedures, Views, Triggers, REF Cursors, SQL SERVER DTS packages, database connectivity using ODP.NET/ /ADO.NET/ADO for ASP.NET/ASP applications.

·Developed Visual Basic COM objects for ASP applications. Developed a COM object in Visual Basic that uses Microsoft Word objects and ADO to fetch address data from SQL SERVER database and populate an AVERY 5160 STANDARD Label sheet template document automatically. The Avery 5160 label sheet populated with address data will be displayed in browser.

·Implemented a third party tool called EO.PDF in ASP.NET applications that directly generate PDF pages from ASPX pages.

·Implemented a third party tool called PERSITS ASPPDF in a ASP application that directly generates PDF pages from ASP pages.

·Coordinated with QA team to get the deliverables in time.

·Good working knowledge of Microsoft Visual SourceSafe and COLLABNET TeamForge for version tracking and have written technical documents like Implementation plan, User Manual, test plans and other documents.

·Attended SAP HR training.

·Successfully completed the UNISYS LEAP 3 training.

·Attended HP Fortify (Web Applications Security Testing Tool) training.

·Based on Security Scan report from tools like Web inspect, have successfully addressed lot of Application Security issues for asp.net as well as asp applications like Sql Injection issues and Section 508 compliance.

·Troubleshooting applications in Production, QA and development environments.

·Developed several asp.net 64 bit applications in WINDOWS 2012 environment.

·Participated on Bid and Proposal for GSA PBS ROW RECOMPETE for an Operations and Maintenance Contract. Unisys won that Contract.

·Recently worked on jQuery fixes for a c#/Sql Server based web application.

·Since 2016 working on C#/MVC/Entity Framework/SQL Server based & ASP.NET Core applications on various projects for DoE, CDC, NIMH/NIH, DoD

Project Experience

ASM Research – .Net Developer 11/2021 – Present

Recently hired by ASMR as a .Net web developer. Worked on various C#, ASP.NET Core applications.

·Involved in application enhancements/fixes/troubleshooting various web applications for Army Training Requirements and Resources System (ATRRS) Team (DoD Client Project)

·Running Pipelines/Releases/builds for code deployment and also executing Powershell scripts.

·Reviewing log files after exection of Powershell Scripts and mitigating any Server configuration related issues by identifying and installing appropriate Microsoft windows patches and also ensuring IIS/AppPools/Virtual directories are configured correctly as desired.

·Installing appropriate Microsoft ODBC drivers, creating/updating stored procedures. Developed C# console applications to ensure successful database connectivity/execution of stored procedures.

Tools used: Visual Studio community 2022, Google Chrome, Microsoft Edge, C#.NET, Microsoft.Net, ASP.NET Core, WebAPI, SQL Server 2022, JavaScript/jQuery/bootstrap, Persists PDF, ABCpdf .NET, Aspose.PDF, Aspose.Cells for .NET, TFS, Azure Devops

SAIC, Rockville, MD – .Net Developer 08/2020 – 01/2021

Recently hired by SAIC as a .Net developer. Worked on a ASP.NET Core application for NIMH/NIH.

·Involved in application enhancements and fixes for a web application.

Tools used: Visual Studio community 2019, C#.NET, Internet Explorer, Google Chrome, Microsoft Edge, Microsoft.Net, C#, SQL Server 2014, JavaScript/jQuery/AngularJS, GitHub, Jira, Confluence.

AuroTech, Silver Spring, MD – .Net Developer 07/2019 – 06/2020

As an employee of this organization, was a software consultant to CGI Federal, part of a web development project team.

Involved in the maintenance and enhancement of a C#/Oracle based web application for The Centers for Medicare And Medicaid Services(CMS). Also worked on another c#/Sqlserver application called eGRATIS (electronic Grants Application Tracking Information System) for Centers for Disease Control and Prevention, Atlanta, GA.

·Involved in application enhancements and fixes for a web application as and when required directed by the Team Lead.

·Implemented a functionality to upload 2GB documents very quickly from the website.

·Implemented lot of jQuery fixes for eGRATIS application.

Tools used: Visual Studio.NET 2015/2017, C#.NET, Oracle 11g, Sql Developer, Internet Explorer, Google Chrome, Microsoft Edge, HTML Scripting, Microsoft.Net, C#, SQL Server 2014 and earlier, XML/XSD, MS Entity Framework, JavaScript/jQuery, HTML5, TFS, ASP.NET Object Models.

BOOZ ALLEN HAMILTON, Herndon, VA – Lead Technologist 09/2016 – 01/2019

As an employee of this organization, was part of a web development project team.

Involved in the maintenance and enhancement of couple of C#/SQL SERVER based web applications that include energy Program Information Center (ePIC), EERE for ARPA-E, Department of Energy, Washington DC.

·Involved in application enhancements and fixes for couple of web applications as and when required directed by the Team Lead.

·

Tools used: Visual Studio.NET 2015, C#.NET, MICROSOFT SQL SERVER 2014, DevExpress Controls 15.x, Internet Explorer, Google Chrome, Microsoft Edge, HTML Scripting, MS Entity Framework, JavaScript, ASP.NET Object Models.

UNISYS, Reston VA – Software engineer 09/2007 – 09/2016

As an employee of this organization, was part of a web development project team

Involved in the development/migration of applications from ASP TO ASP.NET, maintenance and enhancement of many ASP.NET 2.0/ASP based web applications that include RENT ON THE WEB (ROW), BUILDING PRESERVATION PLAN (BPP) and ASSET BUSINESS PLANS (ABP), RENT CHARGEBACK TRACKING SYSTEM (RCTS) for Public Buildings Service (PBS), Office of the Chief Financial Officer (CFO), General Services Administration (GSA), Washington DC. Also worked on Region 5 ASP.NET applications.

·Developed a asp.net 64 bit windows 2012 server application using VISUAL STUIDO 2008 for RENT ON THE WEB application to load bills.

·Developed a asp.net 64bit windows 2012 server application that generates PDF reports for all the buildings available in a application called BUILDING PRESERVATION PLAN’s database.

·Completed several online JAVA training courses from UNISYS University.

·Implemented third party tools called EO.PDF & PERSITS ASPPDF that directly generates PDF pages from ASPX and ASP pages.

·Developed ASP.NET pages using VB.NET and ODP.NET in ASP.NET 2.0 environment.

·Handled Oracle CLOB (data type) data in ASP.NET 2.0 pages and stored procedures in Oracle 10g.

·Handled Third party controls called Telerik RAD controls in the ASP.NET 2.0 pages.

·Implemented “Extending Session Timeout feature” for an ASP based application called BPP as users continue to type in chunks of building information in multiline text boxes for more than 20 minutes to even more than one hour.

·Involved in the production support on a daily basis by responding to all the customer emails (over phone as well as through emails) providing alternate solutions to all the time –sensitive PRODUCTION issues/queries that happens then and there and also during the monthly RENT BILL process for RENT ON THE WEB application.

·On a regular basis, involved in supporting the Customer's applications testing team (called IVV) in their application testing efforts and also helping our support staff in our data center (ESC) located in Chantilly, VA in deploying/installing various applications on their application test servers and also in Production servers as we deliver application releases. Also involved in fixing issues of application components as and when they encountered issues while building new servers for various reasons and/or install patches to the servers.

·Involved in the migration of ROW & RCTS ASP.NET applications from BIS database to MAR database.

·As part of an enhancement effort for one of the REGION 5 application called BA54, involved in updating SQL SERVER Integration Services (SSIS) packages to move data from EXCEL to SQL SERVER database. Also involved in updating SQL SERVER Report Builder 2.0 reports.

Tools used: VISUAL STUIDO 2008, WINDOWS 2012 SERVER, Visual Studio .NET 2005 VB.NET 2.0, ODP.NET 10, Internet Explorer, HTML Scripting, JavaScript, ASP.NET Object Models, ASP Object Models, Oracle 10g., MICOROSOFT SQL SERVER 2008 R2, SSIS packages, REPORT BUILDER 2.0.

UNISYS, MCLEAN VA – Software engineer 09/1999 – 04/2007

Part of a three-member web application development project team to design, develop and implement a ASP.NET web based application BEC ASSURANCE STATEMENT AND INTERNAL CONTROL SYSTEM (BASICS) for Audit Follow-up and Evaluation Division (BECA), Public Buildings Service (PBS), Office of the Chief Financial Officer (CFO), General Services Administration (GSA), Washington DC.

·Developed ASP.NET pages using VB.NET and ADO.NET in ASP.NET 2.0 environment.

·Development and Implementation of an Intranet application called TABLES for the Federal Government’s Information Logistics Division, Public Buildings Service (PBS), Office of the PBS Chief Information Officer (CIO), General Services Administration (GSA), Washington DC.

·Developed several ASP pages using Visual InterDev 6.0. Server side and Client side scripts were written in VBScript / JavaScript. Written stored procedures in MS-SQLSERVER 7.0.

·Worked on conversion of ASP/SQL SERVER application to ASP/ORACLE application.

·Written stored procedures and views in ORACLE 9i.

·Developed an ASP component (Active X DLL) using Microsoft Visual Basic 6.0 and Microsoft Word objects to fetch address data from the database and print in Avery standard 5160 label sheets.

·Implemented AJAX architecture in an ASP web page to populate values in drop-down box from the database based on the values selected from another drop-down box.

·Installed Windows NT and created web sites using IIS 4.0.

·Designed, developed and implemented security module for the application.

·Involved in the development of Budget Tracking System (BTS) for the Technology Division of Public Buildings Service (PBS), Office of the PBS Chief Information Officer (CIO), General Services Administration (GSA), Washington, DC.

·Developed several ASP pages using Visual Interdev 6.0. Used CDONTS for providing Email services among various types of users in the system. Implemented Microsoft Windows Explorer kind of menu using JavaScript. Also implemented client-side image maps for swapping menu bar images.

·Worked on the development of AD-HOC reporting System for the Information Logistics Division of Public Buildings Service (PBS), Office of the PBS Chief Information Officer (CIO), General Services Administration (GSA), Washington DC.

·Developed several ASP pages using Visual Interdev 6.0. Used CDONTS for providing Email services among various types of users in the system. Worked on a third party tool called NETCHARTS to implement bar charts in ASP pages.

·Developed Information Logistics Reporting (ILR) system for the Information Logistics Division of Public Buildings Service (PBS), Office of the PBS Chief Information Officer (CIO), General Services Administration (GSA), Washington DC.

·Converted Business Objects reports to ASP pages using Visual Interdev 6.0. Analyzed business logic in Business Objects reports and wrote equivalent Oracle Stored procedures.

Tools used: Visual InterDev 6.0, Visual Basic 6.0, Internet Explorer, HTML Scripting, VB Script, JavaScript, ASP Object Models, ASP.NET Object Models, Active-X Data objects (ADO), MTS, IIS 4.0, MS SQL Server 7.0, TOAD, ORACLE 8.1.7/9i/10g, NETCHARTS, Business Objects, Visual Studio .NET 2003/2005, Visual Basic.NET 2.0, ADO.NET 2.0, ODP.NET 9.2 /10, MS ACESS, SQL SERVER DTS.

Education

·Masters Degree Programme in Computer Science.(MSC), Manonmaniam Sundaranar University, India, 1997

·Bachelors Degree in Computer Science, Manonmaniam Sundaranar University, India, 1995

Technical Skills

·Key Skills and Knowledge

Web Application Development, Database Application Development

·Databases

Oracle 11g/10g/ 9i/8i, MS SQL Server, MS-Access

·Programming Languages & Tools

Visual Studio community 2022, Google Chrome, Microsoft Edge, C#.NET, Microsoft.Net, ASP.NET Core, WebAPI, SQL Server 2022, JavaScript/jQuery/bootstrap, Persists PDF, ABCpdf .NET, Aspose.PDF, Aspose.Cells for .NET, TFS, Azure Devops, ASP.Net 2.0/3.5, VB.Net, C#, ASP (Active Server Pages), SQL, PL/SQL, TOAD, SQL DEVELOPER, Visual Basic 6, JavaScript, HTML, VB Script, XML, EO.PDF components, Persits ASPPDF components, Telerik RAD controls, COLLABNET Team Forge, Visual SourceSafe, Visual Studio 6, Visual Studio 2005, Visual Studio 2008, Visual Studio 2012, Visual Studio 2019 community edition, SQL SERVER Integration Services (SSIS) packages, Report Builder 2.0, COBOL/HP-UX B.6.25, HP Fortify.

·Operating Systems

Windows 2012/7/ XP/2000/NT

·Technical Documentation

Implementation Plan, Computer Operations Manual, Detailed Design Specification, Release Letter, Test Plans, User Manual.

Contact this candidate