SUMMARY:

• Over 15 years of experience in different phases of software development life cycle including analysis, design, development, documentation, deployment and system support.
• Experience of working independently and in a large team environment.
• Ability to interact with customers with ease and professionalism.
• Ability to analyze and study systems, prepare initial study reports and requirement specifications.
• Experience as Database Developer and Software Developer.
• Have designed Proposals and Solutions according to the requirements and needs of the systems and organizations.
• Good experience in Development, QA and Production support activities.
• Ability to learn new skills on the job and have a ‘Can Do’ attitude.
• Extensive knowledge in .Net development.
• Experience developing Client/Server as well as 3 - tier software solutions using a variety of tools and technologies for small and medium organizations.
• Experience developing Web & Window based Front End and Back Office applications from scratch.
• Experience in migrating legacy applications to .Net platform.
• As Database Developer:
• Good knowledge in RDBMS concepts, conceptual/logical/physical data models.
• Extensive experience in SQL Server 2005/2008, SQL, T-SQL, Stored Procedures, Triggers, UDF, BCP, DTS and SSIS packages.
• Experience in larger databases running on SQL Server.
• Experience in Performance Tuning and Optimization of SQL Stored Procedures and Scripts.

SKILLS AND EXPERTISE:

Operating Systems: MS Windows 9x/NT/2k/XP/Vista/Windows 7/Windows 8

Case Study Tools: MS Visio, Power Designer, Erwin

Programming Languages and Tools: Visual Basic .Net, C#, Visual Basic 6, Power Builder 8, Visual Source Safe, SVN, TFS, ASP.Net, HTML, JavaScript, WCF Web Services, Silverlight 5

Database Systems: MS SQL Server 2005 & 2008, MS Access, Sybase, Advantage Database

Reporting Tools: SQL Reporting Services 2000 & 2005, Crystal Reports

Technologies: OOPCOMCOM+, ADO.NETODBC

ActiveX Controls: DTSXMLMulti-Threading, SSISSSISMessage Queue (MSMQ),MVC 5Kendo UIjQuery PlugIns, Knockout JSBackbone JSAngular JS, Dependency InjectionUnity

EXPERIENCES:

Confidential, Santa Ana, CA

Sr. Applications Developer

Technologies Used: Visual Studio 2013, .Net Framework 4.5, C#, LINQ, MSMQ, WCF Web Services, Dependency Injection, Microsoft Unity, SQL Server 2008

Responsibilities:

• Database Development
• Developed and maintained Stored Procedures, Tables, Views, Functions, SQL scripts for all new development and enhancements.
• Optimized Stored Procedures and SQL Queries.
• Developed migration scripts to retrieve and update data from one SQL database to another.
• Automated Review Tool (aka ART, a Web App for Financial Aid)

Confidential, Fullerton, CA

.Net/SQL Developer

Technologies Used: Visual Studio 2008, .Net Framework 3.5, C#, LINQ, Dynamic Data, LINQ to SQL, WCF Restful Web Services, MSMQ, Ajax, jQuery, JavaScript, SQL Server 2005, SSRS, SSIS and MapQuest API

Responsibilities:

• Database and Business Intelligence Development (SSIS)
• Developed and maintained Stored Procedures, SQL scripts for existing and new development.
• Created database schemas for new development.
• Modified and maintained SSIS Packages for loading text files from USPS into the Database.
• Client Package Management System (Web App for CSR & DP Dept)
• Developed a new 3-tier application for internal management of Client, Package, Formset, Product and associated data. This application is being used by CSR and Data Processing Departments.
• Archive System (Web App for Data Processing Dept)
• This application consists of two major components:

Confidential, Irvine, CA

Database Engineer

Technologies Used: SQL Server 2005, T-SQL, DTS, SQL Replication, SSRS, SSIS

Responsibilities:

• Designed and developed Stored Procedures, Functions, SQL scripts, DTS and SSIS packages.
• Involved in Performance Tuning and Optimization of Stored Procedures and SQL scripts.
• Maintained Stored Procedures for extensibility.
• Maintained and developed scripts for Replication.
• Supported existing schema and designed new Database schemas.
• Extracted data using ad-hoc queries.
• Participated in new projects and provided database development support.

Confidential, Irvine, CA

Sr. Software Developer

Technologies Used: Visual Studio 2003, .Net Framework 2.0, C#, Ajax, JavaScript, Web Services, SQL Server 2000, T-SQL, DTS, SSRS

Responsibilities:

• Database and Business Intelligence Development (SSRS)
• Involved in Performance Tuning and Optimization of Stored Procedures,
• Maintained Stored Procedures for extensibility.
• Created database schemas for new development.
• Maintained SQL jobs for different reports and processes.
• Converted old fashioned DTS Reports to SQL Reporting Services 2005.
• Overall conversion of reports into SQL Reporting Services 2005 retrieving data from SQL Server 2000 database as well as deploying and publishing the reports.
• Setup Transactional Replication from Back Office to Reporting Database.
• Online Transaction Processing (OLTP) Application
• Supported a critical multi-threaded OLTP Windows Service application. This application was supporting DMS procedure was responsible for receiving, processing and responding to all incoming concurrent transactions from Merchants. The application was also responsible to synchronize Card Balances on both OLTP and Live databases.
• Conversion of IVR System into a .Net Application
• Converted a legacy VB6 IVR application to a new .Net application using C# platform.
• Overall conversion of IVR system into .Net C# 2.0 Application which was using Intel/Dialogic Telephony Card and APIs to get the calls, plays VOX messages, gets customers response and update database on customer's selected options like activating a Card, marking a card as lost or playing card balance.
• CardEx Portal (ePortal for Internal and External Users)
• Developed a new 3-tier portal application with IT team, which is used by internal & external users.
• Conversion of VB6 Back Office Applications into .Net Applications
• Converted multiple legacy Back Office VB6 applications (including applications generating files like Card Order File for Card Vendor, Positive Balance Files for Banks, etc.) to new .Net console applications using C# platform.
• Overall conversion of such applications into .Net C# Applications as well as their deployment were my duties.
• ISO Fee Application
• Developed a new console application to charge different Fee from ISO Client’s customers.
• Automated Ordering Module For ISO Clients (a part of ePortal)
• Designed Asp.Net web based application that allows ISO Clients (usually Banks) to configure their automated orders and then another console application generates the orders according to the configuration setup.
• Web Accounting Application (a web based application for CardEx internal use)
• Designed a web-based Accounting Application for Customer Service Department to enter Performa Invoices and Receipts into the system and to get the client’s ledger.
• Great Plains Integration
• Developed integration between ECAP and Great Plains Application to export new clients and all types of invoices from Enterprise Application to the Great Plains Database to avoid time consuming manual entries.
• Developed DTS packages and used GP Integration Tool to achieve this goal.

Confidential, Irvine, CA

Analyst/Programmer

Technologies Used: Visual Studio 2000, .Net Framework 1.0, VB.Net, JavaScript, SQL Server 2000

Responsibilities:

• Electronic Medical Record (EMR) System (for HealthCare Industry)
• Medical Transcriptions (a web based part of EMR system for HealthCare Industry)

Confidential

Programmer

Technologies Used: Visual Studio 2000, .Net Framework 1.0, VB.Net, PowerBuilder 8, Sybase, SQL Server 2000

Responsibilities:

• Shares Accounting System (for Stock Exchange Registered Companies)
• Inventory Manufacturing and Stock Control System
• Consumer Billing System
• Payroll System