OBJECTIVE:

Development of Web, Desktop and Database Applications for wide range of business purposes using Microsoft Technology.

PROFESSIONAL PROFILE:

• Over the course of 20 years IT career, I have been engaged in full application delivery management life cycle process including but not limited to: definition of requirements, prototyping, proof of concept design, user interface implementation, data extraction and transformations, testing, deployment and maintenance.
• This experience allow me today utilize project management best practices to track book of work priorities, communicate updates, & manage projects to successful completion; explain data concepts & challenges clearly to technical and non - technical stakeholders
• Experience in analysis, design and development of client/server desktop and intranet, internet N-tier applications.
• Professional level skills developing web applications in ASP, Microsoft Visual Studio .Net using VB.NET, ASP.NET, ADO.NET, CSS, HTML.
• Professional level skills developing desktop applications in Microsoft Visual Studio 6.0 using VB, and Microsoft Visual Studio 2008, 2010, 2012, 2013
• Solid experience in SQL Server Database administration and support at DBA capacity.
• Effective in working independently and collaboratively in teams.
• Have worked with 3rd-party web controls
• Very Strong MS SQL Server (includes working with DML, DDL, Stored procedures and BI suite of products for Data Warehousing and BI applications)
• Knowledge and solid experience of Agile and Waterfall practice

TECHNOLOGY:

Application Development: ASP.NET, VB.NET, SQL, ORACLE SQL*PLUS, ORACLE PL/SQL, PowerBuilder 4.0/5.0, MS Visual Basic 3.0/4.0/5.0/6.0 , Microsoft Access 2.0/7.00/8.00 , Crystal Reports 4.6/5.0/6.0/8/10 , Active Server Pages, Site Server 3.0, Commerce 2000, Microsoft Visio, VBscript, JavaScript, Jquery, SharePoint 2010, mPower, NetSuite, Angular

Database Platforms: ORACLE, MS SQL 6.5/7.0/2000 / 2005/2008/2012 and MS ACCESS.

Operating Systems: MS Windows XP, Windows NT, Windows 2000/3.1/ 95,2003,2007, Vista.

Tools: Visual Source Save 4.0/5.0/6.0, Team Foundation Server (TFS), Microsoft BI Suite of products (SSRS, SSIS 2005/2008/2012 ).

WORK EXPERIENCE:

VB.NET Developer

Confidential

Responsibilities:

• Was responsible for maintenance and support of several databases including the design and development of stored procedures, views, triggers and tables for the application running on MS SQL Server 2005/2008 platform.
• Successfully implemented the data movement capability and reporting using MS SQL Server Suite of Business Intelligence products (SSIS for ETL module and SSRS for reports)
• Designed and developed several web based applications for the business needs using VB.NET, JavaScript, JQuery. Supported existed desktop/web based applications for troubleshooting and new applications futures.
• Designed and developed several web based applications using mPower tool with MS SQL Server 2008 database on a backend. Wrote custom utilities for the futures not provided and supported by mPower tool.
• As member of large team, implemented NetSuite ERP system with primary focus on reports and dashboards design for the user’s needs.
• Performed Share Point 2010 website administration and maintenance including troubleshooting of user permissions, new sites, pages, workflows, web parts. Have used Share Point Designer to create and edit workflows.
• Performed administration of access controls and user’s permissions for Customer Relationship Management application
• Upgraded legacy VB 6 desktop application to VB.NET web based application
• Developed and supported several web based applications using Visual Studio 2010, 2013 and SQL Server 2008.
• Developed and supported call in application using Angel Click web provider.
• Provided customer support through the helpdesk web application.

Software Engineer

Confidential

Responsibilities:

• Was responsible for SQL backend development using MS SQL Server BI Suite of products
• Maintained and supported several databases, designed database schema, implemented stored procedures, views, triggers and tables for SQL 2005/2008.
• Was responsible for the database support and troubleshooting based on clients requests and error log messages. Developed several programs for the business needs using VB.NET.
• Was instrumental of Confidential Insurance EDI eligibility process using BizTalk and SSIS packages used for submitting EDI 834 eligibility data to Confidential .
• Led effort for overseeing, creating and maintaining scheduled jobs and complicated SSIS packages for the data operation.
• Processed legacy 4010and new 5010 files due to the HIPAATalk regulation.
• Provided customer support for the processes running under SQL server SSIS scheduled packages.

Application Developer

Confidential

Responsibilities:

• Responsible for upgrade from SQL 2000 to SQL 2008 (Facts1 and IFCS databases). Duties for the upgrade included design and implementation of the stored procedures, functions, views, tables compatible to SQL 2008, rewriting the DTS packages not supported in SQL 2008 to SSIS, redesigning hardcoded SQL statements in web applications asp pages to be compatible with the SQL 2008 version of SQL. Used SSRS for the reports generation.
• Maintained and supported several SQL 2000/2005/2008 databases, created database schema design, implemented stored procedures, views, triggers and tables.
• Participated in the yearly Disaster Recovery Exercise of BPD Intel Platform Applications. Performed security vulnerabilities scans (cross-site scripting, sql injection) of the confidential web application, analyzed and corrected issues found by the scan report.
• Responsible for analyzing, troubleshooting and resolving issues related to the various web applications. Worked with business owners to provide technical guidance and operational support for resolving issues related to the web and desktop applications.

Sr. Programmer Analyst

Confidential

Responsibilities:

• Designed and developed reports using Crystal Reports and MS SQL Server 2000/2005/2008. Implemented SQL commands, stored procedures and triggers for the reports.

Sr. Programmer Analyst

Confidential

Responsibilities:

• Wrote and supported DLLs with VB 6.0 and MS SQL Server 2000.
• Developed SQL commands, wrote stored procedures, triggers for the applications needs.
• Designed and developed Web application using ASP, ASP.NET and MS SQL 2000.
• Implemented stored procedures for automatic reports generation, utilized SQL Mail for programmatically sending emails with reports and the user’s data.
• Responsibilities included DBA tasks such as database design and disaster recovery, DTS packages design.

Sr. Programmer Analyst

Confidential, Silver Spring, MD

Responsibilities:

• Maintained and supported the Biomedical Research Support Management Information System ( Confidential ). Confidential application stores and tracks large amount of information supplied from Confidential over the last 15 years.
• Responsible for data transfers from Confidential to Confidential database.
• Generated ticklers, scheduled jobs, data transformation services, stored procedures, and maintained the integrity of the database to meet evolving needs of the AIDS Clinical Trials Group Network. Designed and developed reports using Crystal Reports 8.0/10 and MS SQL Server 2000. Designed and developed a Windows application using VB.NET, MS SQL Server 2000 for automatic generation of Word and Excel documents. Implemented stored procedures for automatic reports generation, utilized SQL Mail for programmatically sending emails with reports and the user’s data.
• For the National Institute of Child Health and Human Development’s Microbicide Research project, designed and developed the web registration process for using ASP, ASP.NET, designed and developed back-end applications using MS SQL Server 2000, implemented SQL commands, stored procedures and triggers, managed scheduled jobs. Wrote and supported DLLs with VB 6.0.

Software Developer

Confidential, Rockville, MD

Responsibilities:

• Developed several client/server applications using VB 6.0 and MS SQL Server 2000.
• Developed SQL commands, wrote stored procedures, triggers for the applications needs.
• Participated in the design and development of the Passport records imaging system, a digital imaging system used onsite at passport agencies that scans and stores information in easily retrievable format.
• The primary purpose of that application is to scan passport applications quickly, efficiently, and reliably and store these records for immediate access from any PC terminal authorized to recall the record. System maintains a document archive of more than 44.000.00 documents.
• Implemented fault tolerance for network and database problems.
• This included error logging (text file) for all possible run-time errors.

Senior Consultant

Confidential, Washington, DC

Responsibilities:

• Designed and developed Web application using ASP, MS SQL Server 6.5/2000, developed and designed back-end applications using MS SQL Server 2000, implemented SQL commands, stored procedures and triggers.
• Migrated data and upgraded databases from MS SQL Server 6.5 to MS SQL Server 2000.
• Responsibilities included DBA tasks, including installations of MS SQL Servers, performance testing and improvement of database-intensive applications, creations of databases, tables, users, roles, regular backups, restoring and recovering databases.
• Wrote and supported various DLLs for the Institute’s Intranet site utilizing VB 6.0.

Senior Consultant

Confidential, Annapolis, MD

Responsibilities:

• Designed and developed Web application using ASP, SM Site Server, Commerce 2000 and MS SQL 6.5/7.0/2000 , implemented back-end business logic processing support using MS SQL 7.0.
• Developed SQL commands, wrote stored procedures, triggers, created local packages using MS SQL 7.0 to execute stored procedures and scripts on a scheduled basis on the servers.
• Was responsible for the upgrading databases from MS SQL 6.5 to MS SQL 7.0 and from MS SQL 7.0 to MS SQL 2000.
• Developed and supported Visual Basic back-end scripts for generating dynamic html pages for various web based applications. Installed and supported several development and production computers including installation and configuration of Operating Systems and applications (Windows 2000, MS SQL 2000, Commerce 2000, Solution Sites, BizDesk, etc.).