SUMMARY:

• Develop New / Maintain Existing VB6 Applications / Reverse Engineering VB6 Code
• Design and Build VB6 Windows - Forms / Create ActiveX DLL / Optimize VB6 Code
• Use ADO Record Sets / Connections (Cursor Location / Cursor Type / Lock Type ) To Manipulate data
• Develop Modules / Functions / Subs / DLL that Increase Efficiency Of Repetitive Visual Basic 6 Tasks
• Repair & Update Existing VB6 Code As Needed Due To Reported Bugs Or Development Changes
• Develop New and Maintain existing Reports in MS Excel / MS Access / Create MS Access Database
• C#
• VB.NET
• Microsoft SQL Server 2000 - 2016 Using T-SQL
• Sybase 15.7 Using Transact SQL (T-SQL)
• Oracle 11g - 12c Using PL/SQL
• Create Databases / Schemas / Tables / Constraints / Stored Procedures / Indexes / Triggers / Views
• Create Oracle Packages & Cursors / Functions / Complex SQL Queries / Sub-Queries / PIVOT /
• Create Joins (Inner & Outer Joins / Self-Join) / UNION / UNION ALL / CROSS & OUTER APPLY
• Create Sub-Queries / XML Parsing / CTE / Embedded Html / Temp & Derived Tables
• Add Included / Covered / Filtered Indexes To Avoid Table Scan Using T-SQL
• Pulling Data And Turning Them Into Reports
• Crystal Reports (Versions 9-2016) / Business Objects
• Create New / Modify Existing Reports in Crystal Reports
• Resolve Defects to existing Crystal Reports by Referencing detailed Report Requirements
• Create Conditional Formulas / Record Selection Formulas / Single & Multi-Value Parameters
• Create Field & Section Suppression / Formatting Fields / Field & Row Highlighting / Charts
• Document Complex Custom Crystal Reports And Ensure Proper Testing And Validation
• VSS / SVN / TFS / GIT / JIRA / KANBAN WORKFLOW

EMPLOYMENT:

Confidential, AGOURA HILLS, CA

VB6 / .NET / SQL DEVELOPER

TOOLS: VB6 / C# 2015 / SQL SERVER 2014-2016 / SYBASE 15.7 / WCF / CRYSTAL REPORTS / GIT / JIRA / KANBAN

Responsibilities:

• Convert Sybase Stored Procedures / VB6 Inline SQL & Business Logic / Rules into Stored Procedures Using T-SQL
• Provide Support / Development to Therapy Source / Health Wyse VB6 Financial / Scheduling / Billing Applications
• Use VB6 ADO Record Sets and Connections through Cursor Type / Cursor Location / Lock Type to Manipulate Data
• Optimize VB6 Code / Repair & Update Existing VB6 Code As Needed Due To Reported Bugs Or Development Changes
• SQL Developer Creating / Maintaining Stored Procedures / Complex SQL Queries / User Defined Functions / JOINs / Temp & Derived Tables / CTE / SQL Scripts / CASE / TRY CONVERT/ XML Parsing / DDL / DML / SQL Error Handling
• Create WCF REST to implement CRUD Data Access & Business Logic Layers Using C# and Consume Using HttpClient
• Develop New Reports And Modify Existing Billing / Financial Reports in Crystal Reports by Creating Stored Procedures
• Resolve Defects to existing Crystal Reports by Referencing detailed Report requirements to Identify the cause of the defect
• Document Coding & Bug-Fixes / Create Test Data / Perform Unit & Full-Life Cycle Testing / Assist Business in UAT

Confidential, CYPRESS, CA

CONSULTING - SOFTWARE ENGINEER

TOOLS: VB6 / C# 2012 / VB.NET / WCF / SQL SERVER 2014 / CRYSTAL REPORTS / EXCEL / VBA ACCESS 2013

Responsibilities:

• Develop New / Modify Existing Shipping / Sales / Billing / Accounting / Various Manufacturing Reports in Crystal Reports by Creating Stored Procedures / Parameters / Formulas / Section Suppression / Grouping / Summary / Row Highlighting
• Resolve Defects to existing VB6 / Crystal Reports by Referencing detailed VB6 / Report requirements to Identify the cause
• Provide Production Support / Bug-Fixes / Development to existing Manufacturing Application Using VB6 / VB.NET
• Use VB6 ADO Record Sets and Connections through Cursor Type / Cursor Location / Lock Type to Manipulate Data
• Develop Enhancements (Modules / Functions / Subs / Stored Procedures) that Increase Efficiency of Repetitive VB6 Tasks
• SQL Developer Creating / Maintaining Stored Procedures / Complex SQL Queries / Functions / JOINs / Temp & Derived Tables / CTE / Dynamic SQL / SQL Scripts / Sub-Queries / TRY CONVERT / DDL / DML / Delete Duplicates Using CTE
• Provide Production Support to existing Accounting Application in VBA MS Access - Queries / Reports / Modules / Backup
• Create / Enhance Shipment Tracking Web Application & Convert Excel Reports to Web Reports Using C# / ASP.NET
• Develop / Modify existing Excel Reports by Creating Stored Procedures / Formulas / Format Data / Charts Using VB.NET

Confidential, WOONSOCKET, RI

CONSULTING - PRODUCTION SUPORT

TOOLS: VB6 / ORACLE 12c / PL/SQL / CRYSTAL REPORTS 2013 / SVN

Responsibilities:

• Provide Production Support / Development to existing Promo Tools Retail Application Using VB6 / Oracle / Client Server
• Optimize VB6 Code / Repair & Update Existing VB6 Code As Needed Due To Reported Bugs Or Development Changes
• Develop New Reports / Maintain Existing Reports in Crystal Reports by Creating Stored Procedures / Formulas / Parameters
• SQL Developer Creating / Maintaining Packages / Stored Procedures / User Defined Functions / Cursors / Joins / Complex SQL Queries / Temp & Derived Tables / Materialized Views / SQL Scripts / Sequences / Composite Indexes / DML / DDL
• Perform Data Migration To Import Excel / Flat Files from Various Confidential Stores into Oracle Using EXTERNAL TABLES
• Document program Design / Coding / Maintenance / Enhancement / Bug-Fixes to allow for future changes and code reuse.

Confidential, SAN BERNARDINO, CA

PROJECT LEAD / QA TESTER

TOOLS: C# 2012 / VB.NET / ASP.NET / SQL SERVER 2012 / T-SQL / SSRS / SDLC / TFS

Responsibilities:

• Convert Dept. Of Behavior Health Crystal Reports to SSRS Reports Using Report Designer by Creating Stored Procedures/ Expressions / Parameters / Custom Code using VB.NET / Configure and Deploy to Development / Tests Environments
• Create HealthCare Web Application for Dept. Of Behavior Health Using C# / ASP.NET with Client / Server Architecture
• SQL Developer Creating / Maintaining Stored Procedures / Complex SQL Queries / Functions / JOINs / Temp & Derived Tables / CTE / SQL Scripts / Convert Views to Stored Procedures / Cross & Outer Apply / TRY CONVERT / Sub-Queries
• Add Included / Covered Index on all Columns on SELECT / JOIN / WHERE / HAVING / GROUP BY to avoid Table Scan
• Lead Projects & Take Full Responsibility to Assign Tickets / Perform Design & Code Review / Mentor Junior Developers
• Document Coding & Bug-Fixes / Create Test Data / Perform Unit & Full-Life Cycle Testing / Assist Business in UAT

Confidential, LOS ANGELES, CA

PROJECT LEAD / SOFTWARE ENGINEER / SQL DEVELOPER

TOOLS: VB6 / VB.NET 2010 / C# / SQL SERVER 2008 R2 / T-SQL / VBA

Responsibilities:

• Convert HR / Payroll VB6 Applications to VB.NET / Windows Forms to VB.NET Win Forms / ADO to ADO.NET
• SQL Developer Creating / Maintaining Tables / Stored Procedures / SQL Queries / Functions / JOINs / Derived Tables
• Provide Production Support / Development to existing HR & Payroll Applications Using VB6 / Design VB6 User Controls
• Optimize VB6 Code / Repair & Update Existing VB6 Code As Needed Due To Reported Bugs Or Development Changes
• Create new / Maintain / Bug-Fixes and Enhance existing Excel Spreadsheets / Write Formulas within cells / Format data /Filter data / Multiple Chart Types / Pivot Tables / Macro Security on Excel / Remove Excel Duplicates using VBA Excel
• Provide Production Support / Development to existing HR Application in MS Access - Forms / Queries / Reports / Modules
• Lead Projects & Take Full Responsibility to Assign Tickets / Perform Design & Code Review / Mentor Junior Developers

Confidential, WEST DES MOINES, IA

SQL DEVELOPER / PRODUCTION SUPPORT

TOOLS: VB6 / C# 2010 / ORACLE 11G / SQL*LOADER / CRYSTAL REPORTS 2008 / VBA EXCEL 2009 / VSS

Responsibilities:

• Provide Production Support / Development to Agriculture Insurance VB6 Applications In Client / Server Environment
• Develop Enhancements (Modules / Functions / Subs / Stored Procedures) that Increase Efficiency of Repetitive VB6 Tasks
• Use VB6 ADO Record Sets and Connections through Cursor Type / Cursor Location / Lock Type to Manipulate Data
• Resolve Defects to existing VB6 Application by Referencing detailed requirements to Identify the cause of the defect
• PL/SQL Developer Writing and Debugging Oracle Packages / Stored Procedures / Functions / Cursors / Sequences / JOINs / Complex SQL Queries / CTE / Statistical Computation / Dynamic SQL / DDL / DML / Ad-Hoc Data Extraction
• Perform Data Migration to Import Flat Files to Oracle Using SQL*LOADER / Validate the data migrated into database
• Develop / Maintain Agriculture Insurance Reports using Crystal Reports 2008 / Visual Basic - Create Stored Procedures / Formulas / Parameters / Sections / Section Suppression / Grouping / Summary / Cross Tabs / Charts / Graphs / Formatting
• Create new / Maintain / Bug-Fixes and Enhance existing Excel Spreadsheets / Write Formulas within cells / Format data /Filter data / Multiple Chart Types / Pivot Tables / Macro Security on Excel / Remove Excel Duplicates using VBA Excel
• Document program Design / Coding / Maintenance / Enhancement / Bug-Fixes to allow for future changes and code reuse.

Confidential, SAN FRANCISCO, CA

CONSULTANT - PRODUCTION SUPPORT

TOOLS: VB6 / ADO / SQL SERVER 2008 / T-SQL / ETL (BULK INSERT / OPENROWSET) / EXCEL

Responsibilities:

• Provide Production Support / Development to existing Billing / Enrollment Applications in VB6 / ADO / SQL Server
• Develop Enhancements (Modules / Functions / Subs / Stored Procedures) that Increase Efficiency of Repetitive VB6 Tasks
• Use VB6 ADO Record Sets and Connections through Cursor Type / Cursor Location / Lock Type to Manipulate Data
• Resolve Defects to existing VB6 Application by Referencing detailed requirements to Identify the cause of the defect
• SQL Developer Creating / Maintaining Stored Procedures / Views / Complex SQL Queries / Functions / JOINs / Temp & Derived Tables / SQL Scripts / Sub-Queries / Dynamic SQL / Ad-Hoc Data Extraction / DML / DDL / SQL Error Handling
• Add Included Index on Non-Key Columns on SELECT / JOIN / WHERE / HAVING / GROUP BY to avoid Table Scan
• Perform Data Migration to Upload CSV / Excel / Text Files To SQL Server Using BULK INSERT / OPENROWSET
• Perform Data Validation And Data Profiling After Data Integration and Migration by Creating Queries and Reports
• Create New / Enhance existing Excel Reports by Creating Stored Procedures / Formulas / Format & Filter Data using VB6
• Document Coding & Bug-Fixes to allow for future changes & code reuse / Perform Unit / Full-Life Cycle Testing

Confidential, HEMET, CA

PROJECT LEAD / SOFTWARE ENGINEER / SQL DEVELOPER

TOOLS: VB6 / ORACLE 9I / SQL SERVER 2000 - 2005 / CRYSTAL REPORTS / VBA / VSS

Responsibilities:

• Develop & Maintain Insurance Certificate Application Using VB6 / Design & Build VB6 Windows-Forms & ActiveX DLL
• Use VB6 ADO Record Sets and Connections through Cursor Type / Cursor Location / Lock Type to Manipulate Data
• Develop New and Maintain existing Clients Vendor Insurance Certificate Web Application in ASP / VBScript / HTML
• Create new / Maintain and Enhance existing Financial Reports using MS Excel by creating Formulas within cells / Format data / Filter data / Charts / PIVOT TABLES and remove duplicate data from MS Excel using VBA and SQL Queries
• Develop / Maintain Custom Insurance & Various Reports Using Crystal Reports by Creating Stored Procedures / Parameters
• Database Developer Creating / Maintaining Database / Tables / Constraints / Oracle Packages / Cursors / Indexes / Stored Procedures / Functions / SQL Queries / JOINs / Temp Tables / SQL Scripts / Sub-Queries / DDL / DML / Database Backup
• Convert Insurance Certificate VB6 Application to VB.NET / Windows-Forms to Win-Forms / VB6 ADO To ADO.NET
• Develop / Maintain FTP Application to Download Files from our Clients site and Upload Files to our client site Using VB6
• Develop Access Database / Normalize the Database / Create Access Queries / Forms / Modules For Accounting Department
• Lead Projects & Take Full Responsibility to Assign Tickets / Perform Design & Code Review / Mentor Junior Developers