OBJECTIVE:

• To obtain a developer position that utilizes my strong analytical and problem solving skills while achieving growth, a sense of and an opportunity to learn new technologies

SUMMARY:

• Senior Microsoft Visual Studio .NET enterprise applications analyst & developer
• Expertise in C#, VB.NET, ASP.NET, ADO.NET, SQL Server, HTML, JavaScript
• Knowledge of MVC 4, MVVM & Entity Framework 5 (Code First)
• Experience in SDLC, including creating “User Requirement “& “Technical Design” documents
• 8+ years of extensive experience in software development and data modeling
• Microsoft .NET Framework - Application Development Foundation - Microsoft Certified Technology Specialist (MCTS)

TECHNICAL SKILLS:

Skills: C#, VB.Net, ASP.Net (1.1, 2.0 & 3.5 Framework) ActiveX Data Objects (ADO.NET) SQL Server 2000, 2005 /Data Modeling/ Stored Procedures / Triggers / Relational Database Systems (RDBMS) SSRS (SQL Server 2005 Reporting Services) SSIS (SQL Server 2005 Integration Services) XML/HTML/VBScript/JavaScript

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Responsibilities:

• Designed and developed Winforms application (Market ReRate System) in VB.Net 2005 and VB.Net 2010, that involved reading / writing to excel files and reading / writing to SQL Server database using stored procedures, following mission critical data processes such as determining freight rates and re-rating freight costs, based on customer criteria. Redesigned “Claims” application in VB 2010 using SQL Server database, based on requirements gathered after interfacing with customer. Modification of the application involved eliminating duplicate data entry, and allow users to view data that is validated against a primary SQL database, and moving the current database from Access to SQL Server 2005. Designed a new application “Order Status” that displayed the current status of an order. This application required creating a web service, that allowed the user to enter a batch of orders and obtain their status.

Confidential, Atlanta, GA

Web Applications Developer / Consultant

Responsibilities:

• Designed and developed, tested and debugged ASP.Net applications using C# 2008, Ajax, SQL Server 2005, providing users with a web based interface to perform business transactions, which were previously conducted using excel spreadsheets. Also redesigned and migrated existing asp.net 1.1 framework applications to 3.5 framework, enabling an Ajax interface to allow faster performance using SCRUM methodology. Migrated and added enhancements to existing Cold Fusion applications into asp.net using VB.Net and SQL Server 2005. Developed, tested and debugged asp.net applications using C# 2008, SQL 2005 in an agile environment. The applications developed include “Procurement User Maintenance” which involves creating, modifying or deleting permissions for a procurement user. This would modify the user’s access to view purchase order, the ability to approve purchase orders or deny any access.

Confidential, Atlanta, GA

Web Applications Developer / Consultant

Responsibilities:

• Confidential and debugged an existing HR talent management web application using VB 2005 with SQL Server 2005 database. Met with client to determine business requirements and made appropriate recommendations to ensure applications effective performance. Modifications involved client side coding in vbscript, JavaScript & HTML, writing SQL stored procedures, triggers and views, while managing the project to meet client’s deadlines.

Confidential, Framingham,MA

Professional Services Engineer

Responsibilities:

• Developed an application that provided an interface for user role authentication system, using C# 2008, Ajax & SQL 2005 database. This application involved the user (a manager) granting or denying permissions to a user based on their role. Developed a series of Ad HOC reports using SSRS (SQL 2005), that involved obtaining results from stored procedures, grouping results to display in a tabular report format. Developed Identity Mapping system using SSIS (SQL 2005), that mapped users (using various types of mapping logic such as first initial + last name, etc) from HR extracts (flat file source) to their role in Active Directory (flat file source). The mapping process involved joins to combine recordsets based on two fields, concatenating columns to create a new column etc.

Confidential, Atlanta, GA

Web Applications Developer / Consultant

Responsibilities:

• Performed analysis and redesigned an existing application (FOCUS) improving performance time by over 50%. This was accomplished by optimizing SQL queries, creating indexes, redesigning the SQL 2000 database, DTS packages, stored procedures, converting functions and procedures to ASP.Net 2005 web services. Performance improvement was reflected in web page load time and the display of custom reports using Active Reports and was documented in a Technical Design document. Interacted with customers to analyze and gather requirements in order to create a “Time Entry” page in FOCUS, using ASP.Net 2008 & Ajax that allowed users to enter hours spent on a project. The data entered would be written into a SQL 2005 database, via complex stored procedures. Created enhancements to a pre-existing web application “Server Data Warehouse”, based on customer requirements. Enhancements included web page modifications in a 3 tier architecture environment, using ASP.Net / VB.net 2003 & ADO.Net, creation and modification of SQL Server stored procedures.

Confidential, Atlanta, GA

Windows Applications Developer / Consultant

Responsibilities:

• TYES is a centralized, computerized yard inventory system providing accurate, timely reports on car & train movements. As a phase of migration from VB6 to VB2005, I developed a windows based application in VB2005 that would be launched when a user entered command line parameters. Based on the parameters passed, the application would retrieve values from the database, and launch either a vb6 ocx, pasted on a vb6 form, or a vb.net dll, pasted on a vb2005 form, with which the user would interact with.

Confidential, Atlanta, GA

Web Applications Developer / Consultantt

Responsibilities:

• Confidential com objects that filtered incoming spam email, used in customizing Onyx CRM application in ASP, using HTMLVbScript and JavaScript. Converted an existing MS Access sales application front end and back end, to C# 2005 and SQL Server. This project involved converting 140 access queries to stored procedures, as well as developing a new UI front end in C# 2005 and creating ADO.Net data connections to SQL Server Redesigned SQL Server database to optimize data integrity, along with writing new and modifying existing stored procedures and creating DTS packages. Created technical design documents and functional documents for the Sales application.

Confidential, Atlanta, GA

Web Applications Developer / Consultant

Responsibilities:

• This allowed project managers to be in control of the status of their projects, request additional resources from corresponding Resource Managers and monitor funding levels. Related team members would be allowed to update their individual project status. The application is currently being used by approximately 1500 employees throughout the enterprise. Developed an email notification component, which would send an email to Resource Managers and cc the Project Manager, when a project manager had requested resources, and the system would send an email to Project Manager and cc the Resource Manager, when the resource allocation was accepted. Developed SQL scripts to move database objects (tables, views, stored procedures, udf’s which I developed or enhanced) to staging and production servers.

Confidential, Atlanta, GA

Web Applications Developer / Consultant

Responsibilities:

• Developed two major web pages “Brokerage Account Conversion” and “Summary Statement” for a pre-existing application “SNAP”. This application was designed for SunTrust Securities, to eliminate the need for filling out paper, and maintaining all records electronically, and is used by over 1200 field agents. Project business rules were undocumented, and I was responsible for developing the two web pages with minimal business knowledge, and project guidance. The application was a 3 tier architecture environment, involved developing the web page in ASP (VBScript, HTML) using Visual Interdev, creating data validations in JavaScript, creating a processor page in VBScript, which would pass values to a COM dll. I developed and Confidential COM components in VB6, registered them in Windows 2000 using MTS COM+ and developed nested Stored Procedures in SQL Server 2000 which in turn would read / write data values from the COM objects to the database and vice versa. Interdev code was archived in Visual Source Safe.
• I was also responsible for creating a detailed design document reflecting all the new functionality implemented and for supporting the complete application when moved to the production environment. Re-designed a data validation web page using C# 2003 on an existing application called “Compliance Reporting”, which was used to report customer profile information for regulatory compliance issues. This page forced the user to enter only valid data (such as Name, Address, Phone #, Account # etc) to be read and saved into a SQL database, using stored procedures. A separate page was developed to export data to an excel file or to a web “Print Preview” page.

Confidential, Atlanta, GA

Senior Web Developer

Responsibilities:

• Designed and developed an ASP web application (Custom 2000) using SQL Server 2000 database, which allowed all PC users to download new applications or upgrades to applications currently existing on their local machine based on Active Directory userID credentials. This was accomplished in a 3 tier environment, using COM components developed in VB, to read their windows login id, matched with their group profile in AD. Another VB component was used to read the local windows registry and eliminate existing software from a list of recommended applications. My involvement in the project was through the full development lifecycle including gathering and creation of Business Requirements and Technical Design documentations, developing UML diagrams, interaction with customer throughout the lifecycle of the project, providing status updates. Actively participated in developing a pilot website using a leading web content management system. This allowed users to check-in web content in document format that are to be displayed on the corresponding department’s website.

Confidential, Atlanta, GA

Developer / Consultant

Responsibilities:

• Developed a web application (Team-Finder) using Interdev and ASP (VBScript), HTML and CSS allowing all users & project managers to locate team-members using search criteria such as name, email address, User-ID or phone-number. Converted a pre-existing Web application (Proposal Manager) into total web-enabled application, utilized enterprise wide, to assist sales people in dynamically generating proposal agreements for customers. This involved extracting VB dll’s / that contained functions and runtime controls, and replacing them with ASP functions, using HTML-based controls. Developed Web application interfaces (Atlas) with SQL Server database using ADO connections that allow sales people to store current customer and potential customer information, dynamically create a customer contract, including product category and product pricing information.

Confidential, Atlanta, GA

Developer / Technical Consultant

Responsibilities:

• Converted VB applications into web enabled applications, utilized company wide, to track employee productivity time. Designed and develop an ActiveX COM component used by banks to prevent check fraud. The application extracts all check numbers and check amount from the user’s database, using ODBC database connection, and create a text file, which is sent to a bank. The bank uploads this file to prevent any check fraudulent activity. Debug and support pre-existing VB financial applications. Developed ActiveX controls using VB 6 and SQL Server 6.5. Applications enabled clients to synchronize databases, extract budget data into a text file format, and upload the data into SQL Server 6.5 Used VBScript to modify clients’ User Interface of Clarusä ERP software packages using COM and ActiveX components.

Confidential, Columbia, SC

Developer / Analyst

Responsibilities:

• Designed and developed user interfaces for a statewide data entry and analysis application SAAMIS in Visual Basic5 and SQL Server 6.5. Design of the interface involved interacting with users to analyze and determine their needs. The application involved validating alcohol and drug abuse data received from South Carolina counties, analyzing and generating error reports using COM objects and Crystal Reports 6.0. Designed and developed security system for users, involving login and password encryption, user access permission control database, so as to allow users appropriate rights to view and modify data. Configured Visual SourceSafe 5.0, to record and store all changes made to system code