Experience

DCSS

• United Kingdom
• Security and Investigations

• Senior Programmer Analyst

  • Apr 2007 - Present

  Lead developer in designing, developing and testing .NET Web based application, SharePoint, Active Directory using C#, Visual Basic, VB .NET, Java script, J-Query, AJAX, ASP, HTML5. Designing and normalizing database, writing complex Stored procedure, Function, View and Trigger. Automating manually processes, extract, transformation and load (ETL), executing SQL scripts, sFTP, smtp e-mail using SQL server Integration services (SSIS). Designing, writing and testing SQL server Reporting services (SSRS). Migrating classic ASP to 4.0 .NET framework. Converting Crystal Report to SSRS, and DTS to SSIS. Show less



Franchise Tax Board

• United States
• Restaurants

• DB2 Database Administrator

  • Feb 2005 - Apr 2007

  Maintained IBM DB2 databases included backup, restore, monitor, troubleshooting problems. Wrote Unix shell scripts for online production backups, and automating the processes. Performed database pushes with new/modified database build structure to all databases on multiple servers. Worked on database change requests for designing, modifying tables and relationships between the tables. Maintained IBM DB2 databases included backup, restore, monitor, troubleshooting problems. Wrote Unix shell scripts for online production backups, and automating the processes. Performed database pushes with new/modified database build structure to all databases on multiple servers. Worked on database change requests for designing, modifying tables and relationships between the tables.



CHP

• United Kingdom
• Construction
• 1 - 100 Employee

• Oracle and SQL server Database Adminstrator, Oracle Developer

  • Jan 2000 - Feb 2005

  Developed, tested and maintained Oracle Financials package with Fixed Assets, Account Payable, General Ledger modules. Designed, developed, tested and maintained Revolving Fund custom application to integrate with Oracle Financials. Wrote, modified and maintained stored procedure packages and functions using PL/SQL. Designed, modified and maintained Oracle Forms and Reports (Discoverer). Maintained, monitored, restored, and tuned performance Oracle databases (Sun Solaris). Wrote and modified Unix shell scripts for shut down/startup concurrent manager Oracle applications and databases. Scheduled, monitored, and executed scripts for SQL server backups, restores, and Agent jobs. Installed SQL server 7 and 2000 Client/server software. Upgraded and migrated data SQL server 7 to SQL server 2000. Maintained local/domain (Active Directory) user accounts for web applications and databases. Show less