OBJECTIVE SOFTWARE ENGINEER / PRODUCTION SUPPORT ENGINEER

STRENGTHS

• Creative problem-solver, analytical thinker, result-oriented, independently productive worker, team player and quick-learner.
• Gather requirements. Evaluate / redesign existing program logic to improve overall system performance. Administer MS-SQL.
• Provide support / enhancements / modifications for existing applications. Document all changes/updates made to applications.
• Troubleshoot/Correct unexpected failures in production programs in a timely manner. Write user and technical documentation.
• Experience in VB6 / VB.NET / C# / ADO.NET / ADO / COM+ / ASP.NET / JavaScript / XML / CSS /AJAX / Web Services.
• Create and maintain existing Excel Spreadsheets / Charts / Graphs / Write Formulas within cells / Filter / Sort / Format data.
• Experience in creating Scatter plots / Bar charts / Histograms / Pie Charts / Area / Line / Doughnut / Bubble / Radar / Surface.
• Experience in Oracle 7.3 -10g / PL-SQL / SQL*PLUS / SQL Server 7.0 – 2005 / T-SQL / SQL Query Analyzer / MS Access.
• Extract data from SQL databases. Optimize VB6 code for performance. Convert VB6 to.NET. Perform design / code reviews.
• Develop / maintain existing Stored Procedures / Views / Functions /Triggers / Indexes / Scripts / Complex SQL user queries.
• Develop Crystal Reports / SQL Reporting by creating Functions / Expressions / Parameters / Sub-Reports / Sorting / Grouping.
• Write test case scenarios. Perform unit and full-life cycle testing. Support Users/QA through testing /validation of applications.

EMPLOYMENT

SR SOFTWARE ENGINEER Confidential, CA 11/08 - Present

• Develop / maintain Payroll Application using VB6 / Oracle 10g / PL-SQL / COM+. Optimize VB6 code for performance.
• Gather requirements and translate into Business solutions. Develop user-friendly interfaces (GUI) using Windows Forms.
• Download Payroll data from remote server into database by automating the process. Write user / technical documentation.
• Provide support /modifications / maintenance for existing applications. Document changes / updates made to applications.
• Troubleshoot / Correct unexpected failures in production programs in a timely manner. Perform design and code reviews.
• Design / implement SQL databases. Debug and Optimize SQL queries for performance. Write complex SQL user queries.
• Create/Maintain Stored Procedures / Views / Functions / Indexes. Document all changes and updates made to applications.
• Develop / maintain existing Crystal Reports and Excel Spreadsheets. Read and Write data to and from Excel Spreadsheets.
• Perform unit/full-life cycle testing. Automate unit testing. Support users/QA through testing and validation of applications.

SR SOFTWARE ENGINEER Confidential, CA 06/07 – 10/08

• Develop/Maintain Enrollment/Billing Application using VB6, VB.NET, ADO.NET, ADO, XML, MS-SQL 2005 / T-SQL.
• Create Excel Spreadsheets/Write Formulas within cells/Filter/Sort/Format data. Develop GUI using Win and Web Forms.
• Read and write data to and from Excel. Load Excel data into MSSQL. Use File System to store and retrieve files on a disk.
• Convert VB6 to VB.NET. Download Enrollment data from remote server into SQL Server database. Administer MS-SQL.
• Develop Crystal Reports/SQL Reporting by creating Functions/Expressions/Parameters/Sub-Reports / Sorting/Grouping.
• Evaluate / redesign existing program logic to improve overall system performance. Transfer data into database using SSIS.
• Create Stored Procedures/Views/ Functions / Indexes / Triggers /complex queries. Optimize SQL queries for performance.
• Troubleshoot and correct unexpected failures in production programs in a timely manner. Write technical documentation.
• Perform unit and full-life cycling testing. Support QA through testing/validation of applications. Mentor junior developers

PROJECT LEAD Confidential, CA 03/05 – 05/07

• Develop and maintain Credit Card Processing Application using VB6 / VB.NET / XML / ASP.NET / Oracle 9i / PL-SQL
• Develop Financial (Credits / Debits) and Sales Tax Applications using ASP.NET / JavaScript / CSS/AJAX/Web Services.
• Lead projects and take responsibility for providing tasks/developing project plans. Optimize SQL queries for performance.
• Write FTP Application to upload / download files to and from clients FTP Server. Write user and technical documentation.
• Gather requirements and translate into Business solutions. Perform code review. Use MSMQ to send / receive messages.
• Design / implement SQL databases. Create Stored Procedures / Views / Functions / Triggers / Scripts / Complex queries.
• Provide support / enhancements / modifications for existing applications. Link Access to Oracle. Create Crystal Reports.
• Create Excel Spreadsheets/Charts / Write Formulas within cells / Filter / Sort / Format data. Load Excel data into Oracle.
• Write test case scenarios. Perform unit/full-life cycle testing. Support QA through the testing and validation of application.

PROJECT LEAD Confidential, CA 04/02– 02/05

• Develop Insurance Certificate Application using VB6 / VB.NET / ADO / ADO.NET / XML / MS-SQL 2000 / MS Access.
• Gather requirements and translate it into Business solutions. Develop user-friendly interface using Win /Windows Forms.
• Create Introduction/Deficiency Letters. Implement Bar-Code on the letters. Convert VB6 / VBA applications to VB.NET.
• Provide enhancements and maintenance for existing applications. Document all changes and updates made to applications.
• Write FTP Application to upload / download files to and from clients FTP Server. Transfer data into database using DTS.
• Develop and maintain Crystal Reports by creating Functions / Expressions / Parameters / Sub-Reports / Sorting/Grouping.
• Create Excel Spreadsheets / Write Formulas within cells / Filter / Sort / Format data. Read / write data to and from Excel.
• Design and implement SQL databases. Perform database Backup and Restore. Write user and technical documentations.
• Create Stored Procedures / Views. Evaluate and redesign existing program logic to improve overall system performance.
• Lead projects and take responsibility for providing tasks/developing project plans. Optimize SQL queries for performance.
• Provide 24 x 7 on call support. Perform unit/full-life cycle testing. Support QA through testing/validation of applications.

SR APPLICATION DEVELOPER Confidential, CA 11/99 – 03/02

• Develop / Maintain Mortgage Loan/Payroll System Applications using VB6 / ADO / OLEDB / COM+/ Oracle 8i /PLSQL.
• Gather requirements and translate into Business solutions. Develop user- friendly interfaces (GUI) using Windows Forms.
• Extract data from Oracle 8i database. Convert MS Excel Spreadsheets data / Text files / CSV files into Oracle 8i database.
• Develop, maintain and reverse engineer client-server applications. Document all changes and updates made to application.
• Maintain and Support existing Treasury Application. Troubleshoot / Correct unexpected failures in production programs.
• Compute Monthly Loan Payment and Amortization/Wages and Salaries/Social Security taxes/SDI/Federal and State taxes.
• Optimize VB6 code for performance. Perform code reviews. Perform unit/full-life cycle testing. Mentor junior developers.
• Create Payroll Register / Reconciliation / General Ledger / Garnishment and Mortgage Loan reports using Crystal Reports.

PROGRAMMER ANALYST Confidential, CA 07/94 – 10/99

• Develop Manufacturing and Sales Applications using VB 3-6, DAO, ADO, COM / DCOM, Oracle 7.3 /8 and MS Access.
• Develop and maintain PeopleSoft PEOPLETOOLS, PEOPLECODE, PS-QUERY; Create Crystal Reports/Ad-Hoc Query.
• Provide support / enhancements/maintenance to existing applications. Document all changes/updates made to applications.
• Gather requirements and translate into Business solutions. Create and maintain existing Stored Procedures/Views/Indexes.
• Convert VB3 to VB4; VB4 to VB6 and DAO code to ADO. Create Excel Spreadsheets. Read / write data to / from Excel.
• Optimize SQL queries for performance. Evaluate /redesign existing program logic to improve overall system performance.
• Evaluate/redesign existing program logic to improve overall system performance. Develop user-friendly interfaces (GUI).
• Implement version control system for the application using Visual Source Safe. Compact / Backup MS Access database.
• Perform unit and full-life cycle testing. Support QA through testing/validation of applications. Train non-technical users.

EDUCATION

MA.,COMPUTER SCIENCE
BA.,MATHEMATICS

Training in PEOPLESOFT and ORACLE
Courses taken at University of California, Riverside: JAVA, ASP, XML and PERL.