Senior .NET/SQL Developer with 24 Years IT Experience

Srinivasan Varadarajan Skype ID: srinivasan.varada

*********@*******.*** +91-951*******

Status US Citizen with Overseas Citizenship of India (OCI)

Certifications MCDBA (SQLServer 2008)

Summary

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

Experience

Sr. Software Developer at AcetInfo Solutions

Dec 2021- Jan 2022

TecoEnergy, Vijayawada, INDIA (WFH)

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

May 2019 - Current

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 4.6.1 Developer at Synovus

August 2018 – April 2019, Columbus, GA

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 aka “Stops” (MVC Web application with Web API and Entity Framework).

Sr. .NET MVC Consultant at Capricorn Systems

June 2017 – July 2018

OPM, Macon, GA

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 EHRI and EoPF data-loading between Oracle 11g, Informatica, OneData and .NET MVC.

Sr. .NET Consultant (Winforms) at Sun Technologies

August 2016 – November 2016

Intel, Aloha, OR

Developed enhancements for Intel’s IBR-Modeller and SPOT applications – both 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 (Historical and Open Die Prep Instructions, Historical and Open Build Instructions) from SSRS to direct-menu, displaying data on Infragistics 13.2 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 at Altimetrik, Inc

April 2014 – March 2015

Ford Itek Dearborn, MI

Developed enhancements for Ford’s GTBOM code in .NET 4.0, C# (OOP development framework/language), SQL-Server 2008r2 and VSTO such as:

Addition of right-click options to reflect modifications to tools, administer placeholder-components, approval of cost-data

Speedup of functionality of checkbox-selections and filterings in application’s main dialog

Addition of forms for new functionalities (such as Online Quote) and development of workbooks as needed

editing of Webservice XSD/WSDL files for GTBOM

; worked heavily with FITSI (Ford IT Services India) personnel.

Sr. .NET (Winforms)/Oracle Developer at Brenton Consulting

August 2012 – March 2014

GM, Detroit, MI

Developed routines (functions/voids) in VB.NET, C# (OOP languages), and PL/SQL stored-procs/functions/packages (with Team Foundation Server (TFS) source-control) to enable multiple drag-drop of DFM (Document Foldering Module) folders/nodes and for marking these nodes and PMM (Production Management Module) Production folders/nodes, upload of large numbers of folders (in excel files) to DFM, email-reminders for excessively-inactive “Outside Counsel” application users, reset of document-production times for GM’s Legal Services Application (LSA). Responsible for updations in TFS of various Telerik controls (Treeviews, Listboxes, comboboes) used in application, change of Webservice XSD/WSDL files to reflect table-changes.

Lead .NET Developer at Syntel, Inc.

January 2012 – July 2012

Takata NA, Auburn Hills, MI

Ported modules/forms of Takata NA’s TAS Application (Project Master, Sales Order, Target Parts Wizard, Replace Project Members, Sales Forecast) from VB6 (partial OOP language) with VA Spread and SmartInput controls to Winforms/CE with ComponentOne controls using .NET 2.0 framework (C# code-behind - OOP) — conversion of code to ensure similar behavior in new system with enhancement of showing dates in local format (in lieu of US format of old system), updation of SQL-server 2008r2 stored procedures for parameter changes based on conversion.

Sr. .NET Developer/DBA at AceInfo Solutions

January 2011 – November 2011

Reston, VA

Troubleshooting and database creation/backup/restore/dump for CDC's National Violent Death Reporting System or NVDRS (VB.NET, SQL-Server), maintainance of NVDRS website (ColdFusion, SQL-Server 200842) and added some custom-reports (ColdFusion pages) for data-tracking

updated Deltek interface for various clients (Bridges Systems, BMI, OAMRI, ...);

redesigned ASP.NET pages of USDA’s eDRS and ColdFusion pages of FDA’s Watering Point and EPA’s DWTS to be Section 503 compliant

developed/deployed web-pages, stored-procedures, functions and SQL-scripts for USDA FAS (ASP.NET/SQL-Server-2008R2) and EPA SDWIS (VB, SQL-Server, Excel, Powerpoint), as well as reports (Excel/PowerPoint/Access) for SDWIS, added JavaScript popup-forms and SQL-Server 2008R2 backend-database (tables/views/stored-procedures).

ASP.NET/Oracle developer at enGeniusInc

January 2010 - November 2010

USGS, Reston, VA

Converted USGS’ FBA online application from ColdFusion MX-7 and Classic ASP to ASP.NET/VB.NET /ADO.NET (OOP languages and Oracle 10g backend, application resident on IIS), removed Deferred Maintenance module

Added functionality Rates Workbooks (originallly stored offline as Excel sheets—Common Services, Facilities, Appropriated, Reimbursable, Non-full-rate, Trend), redesigning them as AJAX-enabled web-pages similar to offline-excel reports—with functionality to export ad-hoc reports as Excel)

created tables and procedures to store/load/process the required data for the added functionality

SQL-Server DBA at CIBER, Inc/Mission Critical Solutions

March 2008 - September 2009

OTJAG, Arlington, VA

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

designed backup/recovery strategies for OTJAG (US Army court system) applications (CMS, ACMP, Torts/Claims, PPTO, . ) backend SQL-2000/2005 databases using T-SQL

redesigned OTJAG's (US Army's court system) applications (CMS, ACMP, Torts/Claims, PPTO, . ) ASP.NET pages for enhanced functionality (reflecting data structures-as per created dictionaries).

Production-support DBA at Prodilink Solutions

June 2006 - November 2007

FannieMae, Washington, DC

Administration--backup, recovery, synchronisation (through Oracle or Sybase data-dumps from production, replication/reload to Acceptance), PII-data-scrubbing (data-cleansing), user group security--of FannieMae Acceptance and Production Sybase 12.5 (DealFactory, Whole Loan Remic, Credit Enhancement, Consolidator) and Oracle 10g (EBoutique, Credit Loss Management) applications data-warehouses (100 mln to 1 bln rows) on Solaris and AIX platforms using such tools as DBArtisan 8.5 (Sybase), SQL-Navigator/Toad (Oracle), k-shell scripts including calls to parse PL/SQL and T-SQL code, ensuring SOX-compliance of log outputs (written in UNIX k-shell) for DB modifications, changes, help-desk tickets,. .

Oracle 9i/GUI Developer at Amer Technologies

June 2005 - May 2006

CSC, Hanover, MD

Redesigned SXC/MemberHealth Claims (Oracle 9i) database from Version 4 to 6 (table structures, PLSQL-loader scripts, parsing stored procedure), developed new stored procedure to parse health-pertaining information (incluing PII) for Pharmacy/Benefits fulfilment databases. Ported forms/classes/modules of Zurich NA's Commercial Operating System (COS) from VB-6.0/UDB to VB.NET/UDB (ADO.NET).

SQL-Server/VB.NET Developer at Polaris Software Labs

July 2002 - May 2005

CitiFinancial, Baltimore, MD

Analysed requirements for monthly dealer-compliance and forms inventory/usage/stock-on-hand, developed front-and-back 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 and Excel-2000 and Crystal 10 formats

analysed and re-engineered Project Tracking System application in VB.NET/SQL-Server 2000/Crystal 10 to be more granular/normalised, started design of Call Management System Reporting Application in WebFocus.

Senior Oracle/VB Developer at SOLUTRON, INC

November 2000 - September 2001

CSC/USPTO, Arlington, VA

Converted patent documentation functions/procedures from Pro-C to PL/SQL on Oracle 8.0.6 database, maintenance, updated CDS-Desktop application by developing interface to compare documents (patent class/subclass descriptions and proposed changes) through call to MS-Word, in VisualBasic 6.0, comparatively tested CDS-Desktop in Oracle 8.0.6 vs 8i.

Systems Analyst at Core Education & Consulting Services

June 1995 - August 2000

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

designing and coding of web-based data maintenance program interface modules (using Oracle-inbuilt HTML directives HTF/HTP to generate page-code including embedded JavaScript) using PL/SQL, Pro-C; modelled (through ERWIN;

setup tables and views for specific reporting and data storage requirements within these systems (including some multi-schema, calculated fields, crosstabs), setup and deployed VisualBasic DLL's (accessed through ASP calls) interfacting with Crystal Reports 6.0 or ActiveReports to implement web-accessible reports using Internet Information Server (IIS)

met with end-client to analyse requirements for conversion of school data from flat-file/legacy systems to relational-type database as well as reporting needs

Modified table-structure of FedEx' FLS (FedEx Logistical Systems) database (Sybase 10.0) to eliminate unneeded mutually-exclusive fields, modified FLS accessing program (Powerbuilder 4.0 on Windows 3.1) to use modified structure, administered its 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 flavours of UNIX – k-shell sripting) and schedule database (table-structure, T-SQL stored procs/UI's/reports/backups restores) in Sybase 10.0 for MARTA (Metro Atlanta's public-transit system) using Sybase-10.0 and DB-UIMX (interface development tool), ERWIN, C/C++, designed backup/restore strategies for OS's and database on these platforms using k-shell and inbuilt backup utilities.

Programmer/Analyst at Dobbs, RAM & Co

January 1994 – April 1995

Internal Revenue Service, Atlanta, GA

Met with end-client to analyse system requirements for conversion of IRS' State Retrieval System from System-20 legacy system (flat-file based) to INFORMIX-4.0 relational database under DC/Osx (UNIX), designed/created database and coded for this conversion using ESQL/C, Ace (Informix' report-generator), FMLI (user interface development software) and shell scripts, wrote backup and recovery procedures (in UNIX k-shell) for database and system.

Education

Central Michigan University Mt. Pleasant, MI M.S, Computer Science May 1993

Mount Royal College Calgary, AB Computer Science Diploma, May 1988

Information Systems

The University of Calgary Calgary, AB B.S, Chemical Engineering April 1986

Contact this candidate