Srinivasan Varadarajan Summary

• 
  Over 21 years’ experience in Information Technology including Systems Analysis, passionate about structured and optimized programming, especially object-oriented
  
• 
  Strong experience in authoring requirements, design, development and implementation of Automotive, Public-transport, Logistics, Health-Insurance, Education and government applications
  
• 
  Ability to collaborate and communicate with global clients, worked on-site in various US states (GA, TX, VA, MD, MI, OR) including on projects involving offsite (other US states such as AZ, CA or OH) or global (India) team-members
  
• 
  Worked in Agile Scrum and SDLC methodology, good experience in application architecture, design input, UI/UX, database design/programming and development on the .NET environment, have participated in many daily standup meetings
  
• 
  Strong experience in preparing/managing Project Estimation, Requirement Analysis, Project Plan, High Level Design Document, Code Review, User Guide, Development and Release Management -- including from-scratch projects
  
• 
  Strong experience in building web applications from the grounds-up as well as support & maintenance.
  
• 
  Strong knowledge in writing Views, Stored Procedures, Cursors, Triggers and User Defined Functions
  
• 
  Knowledge in JavaScript, reporting-tools (SSRS, Crystal), Web development languages (HTML, ColdFusion, ASP.NET), XML-Schema.
  
• 
  1 year of experience designing Excel add-ins (such as right-click options) and sheet modifications in VSTO/.NET 4.5, able to do similar with Outlook addins.
  
• 
  4 years of experience with Microsoft Access – macros, reports, queries (internal and pass-through ODBC) versions 97/2000/2003
  
• 
  Quick learner, desire smart-work, good in logical, analytical, and troubleshooting skills.
  

MCDBA (SQL Server 2008)

• 
  M.S, Computer Science - Central Michigan University - Mt. Pleasant, MI (May 1993)
  
• 
  Computer Science Diploma, - Mount Royal College, Calgary, AB (May 1988)
  
• 
  B.S, Chemical Engineering - The University of Calgary - Calgary, AB (April 1986)
  

Developed enhancements for Intel’s IBR-Modeler and SPOT applications – both WinForms 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 grids
  
• 
  Enhanced displays of Mass-maintenance forms
  
• 
  Modified procedures to retrieve new data fields as per business needs
  

Developed enhancements for Ford’s GTBOM code in .NET 4.0, SQL-Server 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 filtering in application’s main dialog
  
• 
  Addition of forms for new functionalities (such as Online Quote) and development of workbooks as needed
  
• 
  Modification of XSD/WSDL files of SOAP webservices, such as adding more tables to XML format, reflecting field-modifications of tables
  
• 
  Creation/modification of user-stories on Ford Itek’s Sharepoint document-portal; worked heavily with FITSI (Ford IT Services India) personnel. Agile Methodology used for development-meetings (milestones to achieve, met so far, testing, …).
  

• 
  Developed routines (functions/voids) in VB.NET, C#, 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). Agile/SCRUM methodology (development meetings discussion of milestones to achieve, repairs to existing functionalities, …), modification of XSD/WSDL files to handle modifications of tables/views/stored-procs, creation/modification of specs documents on Sharepoint portal. Responsible for updation in TFS of various Telerik controls (Treeviews, Listboxes, comboboxes) used in application.
  

• 
  Ported modules/forms of Takata NA’s TAS Application (Project Master, Sales Order, Target Parts Wizard, Replace Project Members, Sales Forecast) from VB6 with VA Spread and SmartInput controls to WinForms/CE with ComponentOne controls using .NET 2.0 framework (C# code-behind) — 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 2K stored procedures for parameter changes based on conversion.
  

• 
  Troubleshooting and database creation/backup/restore/dump 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 using CSS-directives and MVC 3.0 Framework, and WCF
  
• 
  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 popup-forms using Angular.js/JQuery/Telerik Kendo controls (grids, combo-boxes, Listboxes) and SQL-Server 2008R2 backend-database (tables/views/stored-procedures).
  

• 
  Converted USGS’ FBA online application from ColdFusion MX-7 to ASP.NET/VB.NET /ADO.NET (Oracle 10g backend, application resident on IIS) MVC Framework 3.0, WPF and WCF, removed Deferred Maintenance module
  
• 
  Added functionality Rates Workbooks (originally 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 using CSS-directives and Kendo UI grids)
  
• 
  created tables and procedures to store/load/process the required data for the added functionality
  
• 
  Added Angular.js/JQuery client-side scripts for operations which could not be handled server-side
  
• 
  Agile/SCRUM methodology (meetings specifically to set milestones, ...)
  

• 
  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 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).
  
• 
  Placed documentation in OTJAG’s Sharepoint portal.
  

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

• 
  Redesigned SXC/Member Health 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 forms/classes/modules of Zurich NA's Commercial Operating System (COS) from VB-6.0/UDB to VB.NET/UDB (ADO.NET).
  

• 
  Analyzed 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
  
• 
  Analyzed and re-engineered Project Tracking System application in VB.NET/SQL-Server 2000/Crystal 10 to be more normalized and modular (object-oriented and structured methodologies used, specifically for portability)
  

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

• 
  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) interfacing 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 scripting) 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, Structured-design methodology used for modularization of functionalities.
  

• 
  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, using structured design-methodology for modularization of functionalities.