profile-pic

Srinivasan Varadarajan

Srinivasan Varadarajan

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.
  • Role

    .NET

  • Years of Experience

    24.1 years

Skillsets

  • WinForms - 6 Years

Professional Summary

24.1Years
  • Dec, 2021 - Jan, 2022 1 month

    Sr. Software Developer

    AcetInfo Solutions
  • Aug, 2018 - Apr, 2019 8 months

    Sr. .NET 4.6.1 Developer

    Synovus
  • Jun, 2017 - Jul, 20181 yr 1 month

    Sr. .NET MVC Consultant

    Capricorn Systems
  • Aug, 2012 - Mar, 20141 yr 7 months

    Sr. .NET (Winforms)/Oracle Developer

    Brenton Consulting
  • Apr, 2014 - Mar, 2015 11 months

    Sr. .NET (Winforms)/SQL-Server/VSTO developer

    Altimetrik, Inc
  • Aug, 2016 - Nov, 2016 3 months

    Sr. .NET Consultant (Winforms)

    Sun Technologies
  • Jan, 2012 - Jul, 2012 6 months

    Lead .NET Developer

    Syntel, Inc.
  • Jan, 2011 - Nov, 2011 10 months

    Sr. .NET Developer/DBA

    AceInfo Solutions
  • Jan, 2010 - Nov, 2010 10 months

    ASP.NET/Oracle developer

    enGeniusInc
  • Jun, 2005 - May, 2006 11 months

    Oracle 9i/GUI Developer

    Amer Technologies
  • Jun, 2006 - Nov, 20071 yr 5 months

    Production-support DBA

    Prodilink Solutions
  • Mar, 2008 - Sep, 20091 yr 6 months

    SQL-Server DBA

    CIBER, Inc/Mission Critical Solutions
  • Jul, 2002 - May, 20052 yr 10 months

    SQL-Server/VB.NET Developer

    Polaris Software Labs
  • Nov, 2000 - Sep, 2001 10 months

    Senior Oracle/VB Developer

    SOLUTRON, INC
  • Jun, 1995 - Aug, 20005 yr 2 months

    Systems Analyst

    Core Education & Consulting Services
  • Jan, 1994 - Apr, 19951 yr 3 months

    Programmer/Analyst

    Dobbs, RAM & Co

Applications & Tools Known

  • icon-tool

    C#

  • icon-tool

    Javascript

  • icon-tool

    MySQL

  • icon-tool

    Angular

Work History

24.1Years

Sr. Software Developer

AcetInfo Solutions
Dec, 2021 - Jan, 2022 1 month
    Modified configuration files, and code in , and cshtml files via Azure repositories, with finalising through pipelines -- to incorporate single-sign-on, and expansion of menu items in browser (desktop) and mobile views (.NET Core, Optimizely)

Sr. .NET 4.6.1 Developer

Synovus
Aug, 2018 - Apr, 2019 8 months
    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

Capricorn Systems
Jun, 2017 - Jul, 20181 yr 1 month
    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)

Sun Technologies
Aug, 2016 - Nov, 2016 3 months
    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

Altimetrik, Inc
Apr, 2014 - Mar, 2015 11 months
    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 applications 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

Brenton Consulting
Aug, 2012 - Mar, 20141 yr 7 months
    Developed routines (functions/voids) in VB.NET, C# (OOP languages), and PL/SQL stored- (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

Syntel, Inc.
Jan, 2012 - Jul, 2012 6 months
    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

AceInfo Solutions
Jan, 2011 - Nov, 2011 10 months
    Troubleshooting and database for CDC's National Violent Death Reporting System or NVDRS (VB.NET, SQL-Server), maintenance of NVDRS website (ColdFusion, SQL-Server), 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 () for SDWIS, added JavaScript popup-forms and SQL-Server 2008R2 backend-database (tables/views/stored-procedures).

ASP.NET/Oracle developer

enGeniusInc
Jan, 2010 - Nov, 2010 10 months
    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 (originally stored offline as Excel sheetsCommon Services, Facilities, Appropriated, Reimbursable, Non-full-rate, Trend), redesigning them as AJAX-enabled web- pages similar to offline-excel reportswith 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

CIBER, Inc/Mission Critical Solutions
Mar, 2008 - Sep, 20091 yr 6 months
    Created data-dictionaries, T-SQL -, 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

Prodilink Solutions
Jun, 2006 - Nov, 20071 yr 5 months
    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

Amer Technologies
Jun, 2005 - May, 2006 11 months
    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 (including PII) for Pharmacy/Benefits fulfilment databases. Ported of Zurich NA's Commercial Operating System (COS) from VB-6.0/UDB to VB.NET/UDB (ADO.NET).

SQL-Server/VB.NET Developer

Polaris Software Labs
Jul, 2002 - May, 20052 yr 10 months
    Analysed requirements for monthly dealer-compliance and forms -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

SOLUTRON, INC
Nov, 2000 - Sep, 2001 10 months
    Converted patent documentation 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

Core Education & Consulting Services
Jun, 1995 - Aug, 20005 yr 2 months
    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.

Programmer/Analyst

Dobbs, RAM & Co
Jan, 1994 - Apr, 19951 yr 3 months
    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.

Major Projects

16Projects

Sr. Software Developer at AcetInfo Solutions

Dec, 2021 - Jan, 2022 1 month
    Modified configuration files, and code in , 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)

Sr. .NET 4.6.1 Developer at Synovus

Aug, 2018 - Apr, 2019 8 months
    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

Jun, 2017 - Jul, 20181 yr 1 month
    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

Aug, 2016 - Nov, 2016 3 months
    Developed enhancements for Intels 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

Apr, 2014 - Mar, 2015 11 months
    Developed enhancements for Fords 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 applications 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

Aug, 2012 - Mar, 20141 yr 7 months
    Developed routines (functions/voids) in VB.NET, C# (OOP languages), and PL/SQL stored- (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 GMs 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.

Jan, 2012 - Jul, 2012 6 months
    Ported modules/forms of Takata NAs 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

Jan, 2011 - Nov, 2011 10 months
    Troubleshooting and database for CDC's National Violent Death Reporting System or NVDRS (VB.NET, SQL-Server), maintainance of NVDRS website (ColdFusion, SQL-Server), redesigned ASP.NET pages of USDAs eDRS and ColdFusion pages of FDAs Watering Point and EPAs 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 for SDWIS, added JavaScript popup-forms and SQL-Server 2008R2 backend-database (tables/views/stored-procedures).

ASP.NET/Oracle developer at enGeniusInc

Jan, 2010 - Nov, 2010 10 months
    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 sheetsCommon Services, Facilities, Appropriated, Reimbursable, Non-full-rate, Trend), redesigning them as AJAX-enabled web- pages similar to offline-excel reportswith 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

Mar, 2008 - Sep, 20091 yr 6 months
    Created data-dictionaries, T-SQL -, 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

Jun, 2006 - Nov, 20071 yr 5 months
    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

Jun, 2005 - May, 2006 11 months
    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 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

Jul, 2002 - May, 20052 yr 10 months
    Analysed requirements for monthly dealer-compliance and forms -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

Nov, 2000 - Sep, 2001 10 months
    Converted patent documentation 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

Jun, 1995 - Aug, 20005 yr 2 months
    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

Programmer/Analyst at Dobbs, RAM & Co

Jan, 1994 - Apr, 19951 yr 3 months
    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

  • M.S, Computer Science

    Central Michigan University (1993)
  • Computer Science Diploma

    Mount Royal College (1988)
  • B.S, Chemical Engineering

    The University of Calgary (1986)

Certifications

  • Mcdba (sqlserver 2008)