Developer .Net

Srinivasan Varadarajan Skype ID: srinivasan.varada

H No 3-39/A

Irukula Sesharao House

Durgi, Guntur Distt, AP

522612

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

Status US Citizen with OCI (Overseas Citizenship of India)

Certifications MCDBA (SQLServer 2008)

Summary

21 years experience in Information Technology including 5 years of Systems Analyis. 6 years Oracle PL/SQL (8i/9i/10g/11g), 6 years SQL-Server (2000/2005/2008)/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, 5 years C# 5 years AJAX 10+ years VisualStudio (latest version 2013), 1 year Team Foundation Server (2008), 6 years Visual SourceSafe, 2 years XML, 6+ years with reporting softwares (CrystalReports 6-10, ActiveReports, Access Reports, SSRS) including multitable/crosstab report-generation, 1 year Visual Studio Office (VSTO).

Experience

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, 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 filterings in application’s main dialog

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

; 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#, 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).

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

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) 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 to ASP.NET/VB.NET /ADO.NET (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