DATABASE DEVELOPER / SOFTWARE ENGINEER

TECHNICAL SKILLS

Databases: Oracle 7.3 - 11g / PLSQL / TOAD / SQL Server 7 - 2008 / T-SQL / LINQ
Data Migration/Loading: SQL*Loader / External Tables / Bulk Insert / BCP / SSIS / DTS / Linked Servers
Web Technologies: ASP.NET / ASP / HTML / JavaScript / AJAX / Web Forms / Web Services
.Net Technologies: C# / VB.NET / VB6 / ADO.NET / LINQ / WCF / .NET 1.1 - 3.5
Reports: Crystal reports / MS Excel / SSRS

PROFESSIONAL SUMMARY

• Gather requirements / work closely with clients to define the best possible solutions and translate them into Business solutions.
• Database Developer that focus on backend processes developing and maintaining PL-SQL / T-SQL - Triggers / REF Cursors /
• BULK COLLECT / Oracle Packages / Procedures / Functions / Types / Views / Materialized Views / Nested Tables / NLS /
• CLOB / Sequences / Indexes / SQL Scripts / Complex SQL queries / JOINS (Inner Join / Left Outer Join / Right Outer Join)
• Design and Develop Relational (OLTP) database Data Model including Logical and Physical Models and Conceptual Design.
• Modify existing database structure - Add an Index/Add a Column to a Table / Change a Colum Data Type and Create a Table
• Experience with PLSQL / TSQL performance tuning / troubleshooting. Tune/Optimize Complex SQL queries for performance
• Call Stored Procedures / Packages from within C# / VB.NET ASP.NET code-behind Page of Web Applications in Page Load
• Event / Windows Application / Execute the Stored Procedures and Packages using Execute-Reader / Dataset / Data Table
• Automate Data Migration and Data Loading of Excel Spreadsheets / Text Files / CSV Files / MS Access with data Interfaces
• Using Bulk Insert / BCP / SQL*Loader / External Tables / DTS / SQL Server Integration Services (SSIS) / ADO / ADO.NET
• Compress SQL Server Database / Implement Clustered / Non Clustered / Full-Text / Included Columns and Filtered Indexing.
• Experience with Oracle 7.3 -11g / PL-SQL / TOAD / SQL Server 7.0 - 2008 / T-SQL / Query Analyzer / SSMS / MS Access
• Experience with VB.NET / C # / VB6 / LINQ / ASP.NET / JavaScript / Encapsulation /Polymorphism / Inheritance / Interface
• Develop AJAX UI using JavaScript to Send AJAX Request / Process AJAX Response / Error Handling and Form Validation

Confidential, IA 03/10 - Present
DATABASE DEVELOPER
TOOLS: Oracle 11g / PL-SQL / TOAD / SQL Server 2008 / T-SQL / ASP.NET

• Gather requirements / work closely with users to define the best possible solutions / translate them into Business solutions.
• Database Developer that focus on backend processes developing and maintaining PL-SQL / T-SQL - Triggers / Packages / REF Cursors / BULK COLLECT / FORALL / Procedures / User Defined Functions / Types / Views / Materialized Views
  / Nested Tables / NLS / CLOB / Sequences / Indexes / SQL Scripts / Complex SQL queries / JOINS (Inner Join / Left
  Outer Join / Right Outer Join) / Dynamic SQL / MERGE / Exception Handling / Collections / Common Table Expression
• Optimize PL/SQL Packages / Stored Procedures using EXPLAIN PLAN / Bulk Collect / FORALL / Bind Variables/ Hints
• Modify existing database structure - Add an Index/Add a Column to a Table / Change a Colum Data Type / Create a Table
• Tune/Troubleshoot and Optimize MS SQL Stored Procedures / Functions / Views / Complex SQL queries for performance
• Compress SQL Server Database. Implement Clustered / Non Clustered / Full-Text / Included Columns / Filtered Indexing.
• Call Stored Procedures / Packages from within C# ASP.NET code-behind Page of Web Application in Page Load Event / Windows Application / Execute the Stored Procedures and Packages using Execute-Reader / Dataset and Data Table
• Use Ref Cursors to return result set from Oracle Packages to C# using ADO.NET to populate Windows Forms/Win-Forms
• Automate Data Migration / Loading of Excel Files / Text Files / CSV files with data External Tables / SSIS / Bulk Insert
• Document program Design / Coding / Maintenance / Enhancement / Bug-Fixes. Participate in design / code / test reviews.

Confidential, SAN FRANCISCO, CA 06/07 - 10/08
DATABASE / .NET DEVELOPER
TOOLS: Oracle 10g / PL-SQL / C# / VB.NET / .NET 3.0 / LINQ

• Develop Billing and Enrollment Applications using Oracle 10g / PL-SQL / TOAD / C# / VB.NET / ADO.NET / LINQ
• Database Developer that focus on backend processes with PL-SQL - Triggers / Packages / REF Cursors / Nested Tables /BULK COLLECT / FORALL/ Procedures / User Defined Functions / Types / Views / Materialized Views / NLS / CLOB /
  Sequences / SQL Scripts / Complex SQL queries / JOINS (Inner Join / Left Outer Join / Right Outer Join) / Dynamic SQL
• Provide Support / Bug-Fixes and Enhancements to existing PL/SQL / .NET Applications. Comment out all code created
• Optimize PL/SQL Packages / Stored Procedures using EXPLAIN PLAN / Bulk Collect / FORALL / Bind Variables/ Hints
• Create PL/SQL Collections / Select data from Oracle tables using Bulk Collect /Use FORALL to Insert/Update and Delete
• Use Ref Cursors to return result set from Oracle Packages and Stored Procedures to C# and VB.NET using ADO.NET
• Troubleshoot and Optimize Stored Procedures / Oracle Packages / Views / Complex PL-SQL queries for performance
• Automate Data Migration Excel Files / Text Files / CSV Files with data interfaces using External Tables and SQL*Loader
• Document program Design / Coding / Maintenance / Enhancement / Bug-Fixes to allow for future changes and code reuse.
• Develop Health Care Reports using Crystal Reports 9.0 - create Formulas / Parameters / Sub-Reports / Sections / Sorting.
• Write test case scenarios. Perform unit/full-life cycle testing to discover mistakes and verify programs meet specifications.

Confidential, CA 03/05 - 05/07
DATABASE / SOFTWARE DEVELOPER
TOOLS: ORACLE 9I / SQL SERVER 2005 / T-SQL / VB6 / VB.NET / ASP.NET / JAVASCRIPT / WEB SERVICES

• Develop Credit Card Processing Application using VB6 / VB.NET 2.0 / SQL Server 2000 / T-SQL / Oracle 9i / PL-SQL
• Database Developer that focus on backend processes developing and maintaining PL-SQL / T-SQL - Triggers / Packages / REF Cursors / BULK COLLECT / FORALL / Procedures / Functions / Views / Nested Tables / NLS / CLOB / Sequences
  / Indexes / SQL Scripts / Complex SQL queries / JOINS (Inner Join / Left Outer Join / Right Outer Join) / Dynamic SQL
• Create PL/SQL Collections / Select data from Oracle tables using Bulk Collect /Use FORALL to Insert/Update and Delete
• Troubleshoot and Optimize SQL Server / Stored Procedures / Oracle Packages and Complex SQL queries for performance
• Provide Support / Enhancements to existing Enrollment Application using ASP.NET / JavaScript / AJAX / Web Services
• Develop AJAX UI using JavaScript to Send AJAX Request / Process AJAX Response / Error Handling / Form Validation
• Automate Data Migration / Loading of Excel Files / Text Files / CSV Files using SQL*Loader / Bulk Insert / BCP / DTS
• Use N-tier architecture for Presentation Layer / Business Tier (Business Logic Layer and Data Access Layers) / Data Tier
• Optimize VB6 Code / Convert VB6 to VB.NET / Convert ADO to ADO.NET / Convert Inline SQL to Stored Procedures
• Develop Financial Reports using Crystal Reports 9.0 by creating Formulas / Parameters / Sections/Sub-Reports/ Grouping
• Write FTP Application to upload and download files to and from clients FTP Server. Participate in design / code reviews.
• Troubleshoot and correct unexpected failures in production programs in a timely manner. Write technical documentation.

Confidential, CA 04/02 - 02/05
SQL SERVER DEVELOPER / PROJECT LEAD
TOOLS: SQL Server 2000 / T-SQL / DTS / VB6 / C# 1.1 / MS Access 97

• Develop Insurance Certificate Application using VB6 / C# 1.1 / MS Access 97 / SQL Server 2000 / T-SQL / DTS (ETL)
• Design and Develop Relational (OLTP) database Data Model including Logical / Physical Models and Conceptual Design.
• Create/Maintain Stored Procedures/Views / Triggers / Indexes / SQL Scripts / Complex SQL queries / DDL /DML / Joins
• Tune / Troubleshoot and Optimize MS SQL Server / Stored Procedures / Views / Complex SQL queries for performance
• Automate Data Migration/Loading of Excel Files/Text Files/CSV Files with data interfaces using Bulk Insert / BCP / DTS
• Summarize SQL Server Data with ROLLUP to generate a result set showing aggregates using T-SQL to generate Reports
• Support/Enhance/Fix Bugs on Database Production Issues / Releases for Online Web Based/ Windows Based Applications
• Provide Support / Bug-Fixes / Enhancements to existing VB6 / .NET Production Applications. Comment out code created.
• Write FTP Application to upload and download flat files to / from clients FTP Server. Create Ad-Hoc request using TSQL.
• Convert MS Access database to SQL Server - Design / Develop new database for the application and Normalize Database
• Develop Insurance Reports using Crystal Reports 8.5 - Create Formulas / Parameters / Sub-Reports / Sections / Grouping.
• Mentor programmers in T-SQL / Stored Procedure Optimization using Indexes. Participate in design / code / test reviews.

Confidential, CA 11/99 - 03/02
SR APPLICATION DEVELOPER
TOOLS: VB5 / ADO / COM / MS ACCESS / ORACLE 8I / PLSQL / CRYSTAL REPORTS / WINDOWS FORMS

• Develop and Maintain Mortgage Loan/Payroll System Applications using VB5 / DLL / MS Access 97 / Oracle 8i / PLSQL
• Create new and maintain existing Stored Procedures / Views / Joins / Debug and Optimize SQL queries for performance.
• Provide Support / Modifications and Enhancements to existing VB5 Application / Optimize VB5 code for performance.
• Troubleshoot/correct unexpected failures in production programs in a timely manner / Restructure the code for efficiency.
• Use Ref Cursors to return result set from Stored Procedures to Visual Basic using ADO to populate VB Windows Forms
• Design and implement MS Access 97 Database. Compact / Repair and Backup MS Access 97 database using DAO / VB5.
• Compute Monthly Loan Payment and Amortization/Wages and Salaries/Social Security taxes/SDI/Federal and State taxes.
• Create Payroll Register / Reconciliation / General Ledger / Garnishment and Mortgage Loan reports using Crystal Reports.
• Develop / modify /enhance existing Excel Spreadsheets / Write Formulas within cells / Filter / Format data / Sort / Charts.
• Document program Design / Coding / Maintenance / Enhancement / Bug-Fixes to allow for future changes and code reuse.
• Mentor developers in PLSQL/Software Development/Design. Implement version control system using Visual Source Safe.
• Write test case scenarios. Perform unitfull-life cycle testing to discover mistakes and verify programs meet specifications.

Confidential, CA 07/94 - 10/99
PROGRAMMER ANALYST
TOOLS: VB3-6 / DAO / ADO / COM / DCOM / Oracle 7.3-8 / PL-SQL / MS Access / PeopleSoft / PS-Query / SQL*Loader

• Develop Manufacturing Application using VB 3-6 / DAO / ADO / COM/DCOM / Oracle 7.3/8 / PL/SQL / Access /SDLC
• Develop / maintain PeopleSoft PEOPLETOOLS / PEOPLECODE / PS-QUERY. Create Crystal Reports / Ad-Hoc Query.
• Use N-tier architecture for Presentation Layer / Business Tier (Business Logic Layer and Data Access Layers) / Data Tier
• Support and enhance existing Crystal Reports / Document complex custom reports. Review and test Crystal Reports code.
• Document program Design / Coding / Maintenance / Enhancement / Bug-Fixes to allow for future changes and code reuse.
• Evaluate/redesign existing program logic to improve system performance. Develop user- interfaces using Windows Forms.
• Provide Support / Enhancements and Maintenance for existing applications. Optimize Visual Basic code for performance.
• Convert VB3 to VB4 / VB4 to VB6 / DAO to ADO. Create Excel Spreadsheets. Read data to / from Excel Spreadsheets.
• Troubleshoot and correct unexpected failures in production programs in a timely manner. Comment out all code created.
• Implement version control system for the application using VSS / Compact and Backup MS Access database using DAO.
• Write test case scenarios. Perform unit full-life cycle testing. Support QA through testing and validation of applications.

MA.,COMPUTER SCIENCE
BA.,MATHEMATICS