Senior .NET & SQL Developer Resume – 24 Years Experience -C# -VB.NET –  ASP.NET  – Oracle -PL/SQL -SQL Server-  Winforms

Senior .NET & SQL Developer Resume – 24 Years Experience -C# –VB.NET –  ASP.NET  – Oracle -PL/SQL -SQL Server-  Winforms

A highly experienced Information Technology professional with 24 years of experience including 5 years of Systems Analysis, 10 years of Oracle PL/SQL (8i/9i/10g/11g), 10 years of SQL Server (2000/2005/2008/2014)/Sybase (12.5/15 ASE), 7 years of Visual Basic 6.0/.NET (VB.NET, Frameworks 2.0-4.5), 6 years of Winforms (.NET), 5 years of ASP.NET, 7 years of C#, 5 years of AJAX, 10+ years of Visual Studio .NET (latest version 2022), 2 years of Team Foundation Server (2008), 6 years of Visual SourceSafe, 2 years of XML, 6+ years with reporting software (Crystal Reports 6-10, ActiveReports, Access Reports, SSRS) including multitable/crosstab report generation, 1 year of Visual Studio Office (VSTO), 2 years with ComponentOne and Telerik controls, 1 year with Infragistics 13.2, familiarity with Windows Presentation Foundation (WPF) and Windows Communication Foundation (WCF), 2 years of Entity Framework 6, and Web API.

Certifications:

• MCDBA (SQL Server 2008)

Status:

• US Citizen with Overseas Citizenship of India (OCI)

Professional Experience & Responsibilities:

Sr. Software Developer – Energy Sector Client

• Modified configuration files and code in viewmodels/controllers and cshtml files via Azure repositories, with finalizing through pipelines, to incorporate single-sign-on and expansion of menu items in browser (desktop) and mobile views (.NET Core)

Self-Study & Skill Maintenance

• Taken training towards ministry (pastorate), kept up to date on .NET frameworks and SQL Server by downloading latest Visual Studio and MSSQL versions, and tinkering with programs (Console Apps, ASP.NET) and stored procedures/functions

Sr. .NET Developer – Financial Services

• Developed scrapes (transfer of data from internally-published report to database) of multiple business reports through a formless Windows application

• Worked also on Disputes and Payment-Processing Exceptions (MVC Web application with Web API and Entity Framework)

Sr. .NET MVC Consultant – Government Services

• Updated web pages, backend C#, and underlying JavaScript/Angular.js files for new functionalities (such as more flexible alert/error messaging, not requiring “hard” compile) in Services Online (.NET MVC Web/SQL Server 2016, Web API, Entity Framework)

• Involved in integration of data loading between Oracle 11g, Informatica, OneData, and .NET MVC

Sr. .NET Consultant (Winforms) – Semiconductor/Technology Client

• Developed enhancements for Winforms .NET 4.5 applications using Infragistics controls (grids, filters) with SQL Server 2014 backend databases

• Changed Level-2 Priorities to be set by workweek rather than fiscal year

• Moved several reports from SSRS to direct menu, displaying data on Infragistics grids

• Enhanced displays of mass-maintenance forms

• Modified procedures to retrieve new data fields as per business needs

Sr. .NET (Winforms)/SQL Server/VSTO Developer – Automotive Client

• Developed enhancements for code in .NET 4.0, C# (OOP development framework/language), SQL Server 2008r2, and VSTO

• Added right-click options to reflect modifications to tools, administer placeholder components, and approve cost data

• Sped up functionality of checkbox selections and filterings in application’s main dialog

• Added forms for new functionalities (such as Online Quote) and developed workbooks as needed

• Edited Webservice XSD/WSDL files

Sr. .NET (Winforms)/Oracle Developer – Automotive Client

• Developed routines (functions/voids) in VB.NET, C#, and PL/SQL stored procedures/functions/packages (with Team Foundation Server (TFS) source control) to enable multiple drag-drop of document foldering modules/nodes and for marking these nodes and production management modules

• Enabled upload of large numbers of folders (in Excel files) to document foldering, email reminders for excessively inactive application users, and reset of document production times for Legal Services Application

• Responsible for updates in TFS of various Telerik controls (Treeviews, Listboxes, Comboboxes) used in application

• Changed Webservice XSD/WSDL files to reflect table changes

Lead .NET Developer – Automotive Client

• Ported modules/forms of Application (Project Master, Sales Order, Target Parts Wizard, Replace Project Members, Sales Forecast) from VB6 with third-party controls to Winforms with ComponentOne controls using .NET 2.0 framework (C# code-behind)

• Converted code to ensure similar behavior in new system with enhancement of showing dates in local format (in lieu of US format of old system)

• Updated SQL Server 2008r2 stored procedures for parameter changes based on conversion

Sr. .NET Developer/DBA – Government Health & Environmental Agencies

• Troubleshooting and database creation/backup/restore/dump for National Violent Death Reporting System (VB.NET, SQL Server)

• Maintenance of website (ColdFusion, SQL Server) and added custom reports (ColdFusion pages) for data tracking

• Updated interface for various clients

• Redesigned ASP.NET pages and ColdFusion pages to be Section 503 compliant

• Developed/deployed web pages, stored procedures, functions, and SQL scripts for various government systems (ASP.NET/SQL Server) as well as reports (Excel/PowerPoint/Access)

• Added JavaScript popup forms and SQL Server backend database (tables/views/stored procedures)

ASP.NET/Oracle Developer – Geological Survey Client

• Converted online application from ColdFusion and Classic ASP to ASP.NET/VB.NET/ADO.NET (Oracle 10g backend, application resident on IIS), removed Deferred Maintenance module

• Added functionality for Rates Workbooks (originally stored offline as Excel sheets), redesigning them as AJAX-enabled web pages similar to offline Excel reports with functionality to export ad-hoc reports to Excel

• Created tables and procedures to store/load/process required data for added functionality

SQL Server DBA – Government Court Systems

• Created data dictionaries, T-SQL queries/scripts/stored procedures/functions, non-production PII data cleansing, data dumps (in SQL Server DTS/SSIS) to text/Excel/Access

• Designed backup/recovery strategies for government court system applications backend SQL 2000/2005 databases using T-SQL

• Redesigned government court system applications ASP.NET pages for enhanced functionality (reflecting data structures as per created dictionaries)

Production-Support DBA – Financial Services

• Administration – backup, recovery, synchronization (through Oracle or Sybase data dumps from production, replication/reload to Acceptance), PII data scrubbing (data cleansing), user group security – of financial applications data warehouses (100 million to 1 billion rows) on Solaris and AIX platforms using tools like DBArtisan, SQL Navigator/Toad, k-shell scripts including calls to parse PL/SQL and T-SQL code, ensuring SOX compliance of log outputs for database modifications, changes, help desk tickets

Oracle/GUI Developer – Health Claims Client

• Redesigned Claims database from Version 4 to 6 (table structures, PL/SQL loader scripts, parsing stored procedures)

• Developed new stored procedures to parse health-pertaining information (including PII) for Pharmacy/Benefits fulfillment databases

• Ported forms/classes/modules of Commercial Operating System from VB 6.0/UDB to VB.NET/UDB (ADO.NET)

SQL Server/VB.NET Developer – Financial Services

• Analyzed requirements for monthly dealer compliance and forms inventory/usage/stock on hand

• Developed front-end and back-end MS Access 2000 applications (backend interfacing with SQL Server 2000 database, reports and pass-through stored procedures exporting required data to front-end using DTS) to handle these requirements

• Designed reports (including multi-table, crosstab, and other complex base queries) in Access 2000, Excel 2000, and Crystal 10 formats

• Analyzed and re-engineered Project Tracking System application in VB.NET/SQL Server 2000/Crystal 10 to be more granular/normalized

• Started design of Call Management System Reporting Application

Senior Oracle/VB Developer – Patent Documentation Client

• Converted patent documentation functions/procedures from Pro-C to PL/SQL on Oracle 8.0.6 database

• Updated desktop application by developing interface to compare documents (patent class/subclass descriptions and proposed changes) through call to MS Word in Visual Basic 6.0

• Comparatively tested desktop application in Oracle 8.0.6 vs 8i

Systems Analyst – Education & Logistics

• Converted State Department of Education’s School Nutrition, QBE, and CPI systems to Oracle 8i using Pro-C, Visual C++, PL/SQL, Visual Basic 6.0/.NET, Active Server Pages (classical initially, introduced ASP.NET/VC++ at final stage), Crystal Reports 6.0, ActiveReports, HTML, VBScript, JavaScript, AJAX

• Designed and coded web-based data maintenance program interface modules using PL/SQL, Pro-C

• Modeled (through ERWIN) and set up tables and views for specific reporting and data storage requirements within these systems (including some multi-schema, calculated fields, crosstabs)

• Set up and deployed Visual Basic DLLs (accessed through ASP calls) interfacing with Crystal Reports 6.0 or ActiveReports to implement web-accessible reports using Internet Information Server (IIS)

• Met with end clients to analyze requirements for conversion of school data from flat-file/legacy systems to relational-type database as well as reporting needs

• Modified table structure of Logistics database (Sybase 10.0) to eliminate unneeded mutually exclusive fields

• Modified database-accessing program (Powerbuilder 4.0 on Windows 3.1) to use modified structure

• Administered AIX server – backing up both server and database; changed backup strategy to go to RAID device instead of tape drive

• Developed/administered HP-9000 and SparcStation servers (HP-UX and Solaris flavors of UNIX – k-shell scripting) and scheduled database (table structure, T-SQL stored procedures/UIs/reports/backups/restores) in Sybase 10.0 for public transit system using Sybase 10.0 and DB-UIMX (interface development tool), ERWIN, C/C++

• Designed backup/restore strategies for OS and database on these platforms using k-shell and inbuilt backup utilities

Programmer/Analyst – Government Tax Systems

• Met with end client to analyze system requirements for conversion of State Retrieval System from legacy system (flat-file based) to INFORMIX 4.0 relational database under UNIX

• Designed/created database and coded for this conversion using ESQL/C, Ace (report generator), FMLI (user interface development software), and shell scripts

• Wrote backup and recovery procedures (in UNIX k-shell) for database and system

Education:

• M.S. in Computer Science

• Computer Science Diploma – Information Systems

• B.S. in Chemical Engineering

Ideal For:

• Full-time Senior .NET Developer / SQL Developer / DBA roles

• Legacy system modernization and migration projects

• Enterprise application development and maintenance

• Government, financial, healthcare, and automotive domains

• Remote or US/India-based opportunities

• Important Notice : Candidate personal contact details including name, phone number, and email address are hidden for privacy and security reasons. Resume is strictly intended for legal hiring and recruitment purposes only. Any misuse, fraud, spam, illegal activity, or unauthorized distribution is strictly prohibited. Digital product only. No physical item will be shipped.