SUMMARY: SQL SERVER DEVELOPER / SOFTWARE ENGINEER

TECHNICAL SKILLS

MS SQL Server 7 - 2008 / T-SQL / MS Access / Oracle 7.3 – 11g / PL-SQL / TOAD

Data Migration/Loading:

Business Intelligence:

Languages:

Reports:

PROFESSIONAL SUMMARY
* Database Developer that focus on backend processes with PL-SQL / T-SQL / Stored Procedures / Oracle Packages / Indexes /
User Defined Functions / Views / Sequences / Dynamic SQL / SQL Scripts / Complex SQL queries / JOINS (Inner Join / Left
Outer Join / Right Outer Join / Union / Union ALL / Self Join) / Sub-Queries / T-SQL CTE / MERGE/ Compress SQL Server
* Design and Develop Relational (OLTP) database Data Model including Logical and Physical Models and Conceptual Design.
* Modify existing database structure / Create and Enhance SSRS using Report Designer / Delete duplicate records from MSSQL
* Use SQL Server Column-level Encryption and Decryption capabilities to secure sensitive information by using Symmetry Key
* Experience with T-SQL/PL-SQL performance tuning / troubleshooting. Tune/Optimize Complex SQL queries for performance
* Create / Maintain / Enhance SSIS (ETL) using SSMS / BIDS - (Implement Connection Manager / Control Flow / Data Flow)
* Experience with SQL Server 7.0 – 2008 / T-SQL / Query Analyzer / SSMS / Oracle 7.3 -10g / PL-SQL / TOAD / MS Access
* Experience with C # / VB.NET / .NET 1.1-3.5 / VB6 / Encapsulation / Inheritance / Polymorphism / Interface / WCF / XML
* Middle-Tier Developer focus on Developing / Maintaining and Enhancing WCF SOAP-Based Web Services (using Proxy)
And WCF REST-Based Web Services (XML and JSON Formats using Web-Get and Web-Invoke Attributes and GET / POST
/ DELETE / PUT Methods without creating Proxy) with Custom Classes and Consume with Web-Client and Channel Factory
* Call Stored Procedures from within .NET WCF Web Services to SELECT (Pull Data from database) / INSERT / UPDATE /
DELETE through SQL Command / SQL Parameter data objects and execute the Stored Procedures using Dataset / Data Table
/ Execute-Reader / Execute Non Query / Execute Scalar and return result sets to Client Application through Custom Class
* Experience with SQL Server 7.0-2008 / T-SQL / Query Analyzer / SSMS / SQL Server Enterprise Manager / Oracle / PL-SQL
* Automate Data Migration of Flat Files - Excel Files / Text Files / CSV Files / MS Access using SSIS / Bulk Insert / ADO.NET

Confidential, WEST DES MOINES, IA 03/10 – Present

SQL SERVER DEVELOPER / SOFTWARE ENGINEER
TOOLS: SQL SERVER 2008 / T-SQL / SSIS / ASP.NET

• Design and Develop Relational (OLTP) database Data Model including Logical / Physical Models and Conceptual Design.
• SQL Server Developer focus on backend processes with Stored Procedures / Triggers / User Defined Functions / Indexes /

Complex SQL Queries / Dynamic SQL / SQL Scripts / Views / JOINS (Inner Join / Left Outer Join / Right Outer Join /
Union / Union ALL / Self Join) / Ad-Hoc Requests / Common Table Expression (CTE) / DML / DDL / DBCC / MERGE /
Backup & Restore / Database Normalization / Compress SQL Server Database / SQL Server Error Handling using T-SQL

• Performance Tuning / Troubleshooting / Optimization of SQL Server / Stored Procedures / Views / Complex SQL queries
• Use MS SQL Server Column-level Encryption & Decryption capabilities to secure sensitive data by using Symmetry Key
• Automate Data Migration / Loading of Excel Files / Text Files / CSV Files with data interfaces using Bulk Insert and SSIS
• Convert MS Access database to SQL Server using SSIS (SSMS / BIDS) / Modify existing SQL Server database structure
• Call Stored Procedures from within C# code-behind Page of Sales Web Application in Page Load Event and Windows

Application / Execute the Stored Procedures using Execute-Reader / Execute Non Query / Execute Scalar and Dataset

Confidential, SAN FRANCISCO, CA 06/08 – 02/10

PRODUCTION SUPPORT DEVELOPER
TOOLS: SQL SERVER 2005 / T-SQL / SSIS / SSRS / VB.NET / C# / WCF SOAP-BASED WEB SERVICES

• Provide Production Support / Modifications / Bug-Fixes / Enhancements to existing Billing and Enrollment Applications

Using SQL Server 2005 / T-SQL / SSIS / C# / VB.NET / .NET 3.0 / WCF SOAP-Based Web Services / XML / XPATH

• Create / Modify Stored Procedures / User Defined Functions / Indexes / Views / Dynamic SQL / DDL / DML / Complex

SQL queries / JOINS (Inner Join / Left Outer Join / Right Outer Join / Union / Union ALL / Self Join) / Ad-Hoc Requests

• Performance Tuning / Troubleshooting / Optimization of SQL Server / Stored Procedures / Views / Complex SQL queries
• Create SSIS packages using (SSMS / BIDS) / Provide Support to Developers and Customers in database related issues
• Use MS SQL Server Column-level Encryption & Decryption capabilities to secure sensitive data by using Symmetry Key
• Automate Data Migration and Data Loading of Excel Files / Text Files / CSV Files using Bulk Insert / SSIS / ADO.NET
• Troubleshoot and correct unexpected failures in production programs in a timely manner / Write technical documentation.
• Develop / Maintain / Enhance Database Middle-Tier WCF SOAP-Based Web Services with Custom Classes (Hosting in

IIS) and Consume/Integrate with Win-Forms (GUI) creating Proxy by Adding Service Reference and passing parameters

• Lead projects / Take full responsibility for providing tasks / Managing Priorities / Deliverables and Develop project plan
• Create and Enhance SSRS using Report Designer by creating Expressions / Parameters / Sub-Reports / Sorting / Grouping.
• Write test case scenarios. Perform unit/full-life cycle testing to discover mistakes and verify programs meet specifications.

Confidential, CALABASAS, CA 03/06 – 05/08

DATABASE DEVELOPER / SOFTWARE ENGINEER
TOOLS: SQL SERVER 2005 / T-SQL / DTS / ORACLE 9I / VB6 / VB.NET / CRYSTAL REPORTS / WEB SERVICES

• Develop Credit Card Processing Application using VB6 / VB.NET 2.0 / SQL Server 2005 / T-SQL / Oracle 9i / PL-SQL
• Provide Support / Enhancements to existing Enrollment Application using ASP.NET / JavaScript / AJAX / Web Services
• Design and Develop Relational (OLTP) database Data Model including Logical / Physical Models and Conceptual Design.
• Modify existing database structure - Add an Index/Add a Column to a Table / Change a Colum Data Type / Create a Table
• Create Stored Procedures / Oracle Packages / Sequences / Functions / Indexes / SQL Scripts / Complex SQL queries/ Joins
• 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
• Automate Data Migration of Flat Files - Excel Files / Text Files / CSV Files with data interface using DTS and Bulk Insert
• Implement SQL Server Column-level Encryption and Decryption / Delete duplicate records from database using Self Join
• Call Stored Procedures from within VB.NET code-behind Page of Sales Web Application in Page Load Event / Windows

Application / Execute the Stored Procedures using Execute-Reader / Execute Non Query / Execute Scalar and Dataset

• Create Financial Reports using Crystal Reports and .NET / Export Crystal Reports to PDF Format and Excel Spreadsheets
• Create and maintain existing Excel Spreadsheets/ Charts /Graphs / Write Formulas within cells / Filter / Sort / Format data.

Confidential, HEMET, CA 04/02 – 02/06
SQL SERVER DEVELOPER / PROJECT LEAD

TOOLS: SQL SERVER 7/2000 / T-SQL / VB6 / C# / MS ACCESS 97 / ASP.NET / JAVASCRIPT

• Develop Insurance Certificate Application using VB6 / C# / Access 97 / ASP.NET / JavaScript / SQL Server 2000 / TSQL
• Lead projects / Take full responsibility for providing tasks / Managing Priorities / Deliverables and Develop project plan
• Focus on backend processes with TSQL / Stored Procedures / Views / Functions / Indexes / Dynamic SQL/ Complex SQL

Queries / JOINS (Inner Joins / Left Outer Join / Right Outer Join / Union / Union ALL / Self Join) and Ad-Hoc Requests

• Tune / Troubleshoot and Optimize MS SQL Server / Stored Procedures / Views / Complex SQL queries for performance
• Automate Data Migration / Data Loading of Excel Files/Text Files/ CSV Files with data interfaces using Bulk Insert / DTS
• Design and Normalize MS Access database/Compact and Backup MS Access/ Optimize VB6 Application for performance
• Create complex Access Queries / MS Access Reports / MS Access Forms. Develop and Modify MS Excel Spreadsheets
• Call Stored Procedures from within C# code-behind Page of Sales Insurance Application in Page Load Event / Windows

Application / Execute the Stored Procedures using Execute-Reader / Execute Non Query / Execute Scalar and Dataset

• Convert VB6 to C# / Windows-Forms to Win-Forms / ADO to ADO.NET / ADO Record set to Dataset and Data Reader
• Develop / Maintain / Enhance Clients Web Applications using ASP.NET/JavaScript / HTML / Web Forms / Web Services
• Write test case scenarios. Perform unit / full-life cycle testing. Support QA through testing and validation of applications.

SR PROGRAMMER ANALYST

Confidential, LOS ANGELES, CA 11/99 - 03/02

TOOLS: VB6 / ADO / MS ACCESS 97 / SQL SERVER 7 / T-SQL / DTS / MS EXCEL / CRYSTAL REPORTS

• Develop Health Care Application using VB6 / MS Access 97 / SQL Server 7 / T-SQL / DTS / Crystal Reports / MS Excel
• Gather requirements / work closely with users to define the best possible solutions / translate them into Business solutions.
• Develop and maintain existing Stored Procedures / Views / Complex SQL queries. Optimize SQL queries for performance
• Design / Develop MS Access database and normalize the database. Compact and Backup MS Access database using DAO
• Provide Support / Bug-Fixes and Enhancements to an existing VB6 Application / Optimize VB6 code for performance
• Create VB6 Windows-Forms (GUI) / Develop Call Center application to help users retrieve member’s information quickly
• Do Analysis / Design / Coding / Debugging / Testing / Write Documentation / Installation / Deployment / Training Users
• Automate Data Migration of Flat Files – Excel Files / Text Files / CSV Files with data interfaces using Bulk Insert / DTS
• Use N-tier architecture for Presentation Layer / Business Tier (Business Logic Layer and Data Access Layers) / Data Tier
• Develop Health Care Reports using Crystal Reports – Create Formulas / Parameters / Sub-Reports / Sections / Grouping
• 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 T-SQL/Software Development/Design. Implement version control system using Visual Source Safe.
• Write test case scenarios. Perform unit/full-life cycle testing to discover mistakes and verify programs meet specifications.

Confidential, FULLERTON, CA 07/94 – 10/99

PROGRAMMER ANALYST
TOOLS: VB 3-6 / DAO / ADO / Oracle 7.3-8 / PL-SQL / MS ACCESS / CRYSTAL REPORTS / PEOPLESOFT

• Develop Manufacturing Application using VB 3-6 / DAO / ADO / COM/DCOM / Oracle 7.3/8 / PL-SQL / Access /SDLC
• Develop and maintain PeopleSoft Application / Create Crystal Reports / Convert Excel Spreadsheets to Oracle database
• 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.
• Convert VB3 to VB4 / VB4 to VB6 / DAO to ADO. Create Stored Procedures and Views / Optimize Stored Procedures
• 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 to discover mistakes and verify programs meet specifications.

EDUCATION

MA.,COMPUTER SCIENCE

BA.,MATHEMATICS