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

PROFESSIONAL EXPERIENCE:

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

Confidential

Responsibilities:

• 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

Sr. .NET (Winforms)/Oracle Developer

Confidential

Responsibilities:

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

Lead .NET Developer

Confidential

Responsibilities:

• 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
• 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 updation of SQL-server 2008r2 stored procedures for parameter changes based on conversion.

Sr. .NET Developer/DBA

Confidential

Responsibilities:

• 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

Confidential

Responsibilities:

• Converted USGS’ FBA online application from ColdFusion MX-7 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

Confidential

Responsibilities:

• 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

Confidential

Responsibilities:

• 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

Confidential

Responsibilities:

• 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

Confidential

Responsibilities:

• 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

Confidential

Responsibilities:

• Converted Georgia Department of '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.