SUMMARY:

• Over 15 years of extensive software development experience using C#, VISUAL STUDIO.NET, ORACLE, MS SQLSERVER, and SYBASE. GUI experience includes Analysis, Design and Development of GUI applications and Class Libraries using OOPS.
• Extensive experience with all phases of software development, from requirements gathering to post - implementation support and maintenance. Experience working within both large and small teams as well as being the sole developer on a project. Extensive knowledge and experience in writing Stored Procedures, Functions and Triggers using ORACLE, MS SQL Server and Sybase.

TECHNICAL SKILLS:

Technology and Tools: Sr. Software developer (15+ years of experience) Visual Studio 2013/2010 C#4.0/3.0, VB.net, Java Script, ASP, XML,CSS, HTML, IIS, AJAX, Telerik Controls, WCF, WPF, Winforms, PowerBuilder 12.0 Oracle 11i/10G/9i, MS SQL Server 2012//2008, Sybase 15.0 SubVersion, TFS, PVCS, Object Cycle, Rational Clear Case Test Director, Win Runner, JIRA Infomaker and Crystal Reports

PROFESSIONAL EXPERIENCE:

Confidential - Suitland, MD

.Net architect

Responsibilities:

• Modifications, enhancements, Bug fixes, Testing and deployment of CARI system using C#4.0, VB.net, ASP.NET, VS2013 and Oracle 11G.
• Improved screen response time for various screens and reports.
• Created new PL/SQL Stored Procedures, Functions and views to in corporate new business logic and reports.
• Created Store Procedures, Triggers and Functions using Transact-SQL.
• Optimized SQL queries to improve speed and performance.
• Made changes to the GUI/UI layer as per user requests.
• Created functional and user documentation

Environment: VS2013, C #5.0, VB.net, Telerik controls, TFS, Oracle 11G, SQL Server 2012, Toad 11.6, Windows 7.0

Confidential - Princeton, NJ

Lead Developer

Responsibilities:

• Modifications, enhancements and bug fixes to Genasys system using C#4.0, ASP.NET, VS2010 and Oracle 11G.
• Created WCF web services and used AGILE development methodology.
• Redesigned web pages using HTML, CSS, ASP.Net, Ajax and jQuery for new interactive features.
• Implemented ASP.NET MVC pattern to separate UI layer from model and controller logic.
• Used SSIS to perform ETL and to Integrate and move data from various sources.
• Created PL/SQL packages and hierarchical queries using Oracle 11G and resolved data sorting issues in 11G during the database migration from Oracle 9i to 11G.

Environment: VS2010, ASP.NET MVC 4.0, C#4.0, TFS, Jscript editor1.1.2, HTML 4.01, Oracle 11G, SQL Developer 3.0, SQL Server 2012, Windows 7.0

Confidential - Fort Washington, PA

Software Architect

Responsibilities:

• Modifications and enhancements to Capital Market Web system using C#3.0, ASP.NET, VS2008 and Oracle 11G.
• Made use of C# 3.0 feautures such as interfaces, structs and delegates
• Made use of DataSets, Data reader and Data Adapter controls and created new and modified existing reports.
• Modifcations to the GUI layer of Financial accounting system using WPF
• Created new PL/SQL Functions, Packages, Stored Procs and Views using Oracle Sql Developer 3.0.04 to store business rules
• Optimized and fine-tuned Oracle queries to improve performance.
• Created various database objects such as Synonyms, Sequences, Indexes and views
• Worked on supporting table-partitioning initiative.
• Interacted with Business users to gather requirements

Environment: VS2008, Web forms, ASP.NET, WPF, C#3.0, TFS, JavaScript 1.8.2, HTML 4.01, Oracle 11, SQL Developer 3.0, Subversion 1.6

Confidential - Arlington, VA

Lead Developer

Responsibilities:

• Created .Net Web Services using C#, ADO.NET, Javascript, CSS, HTML and XML that was consumed by the S application
• Worked extensively with Data Adapter, Dataset and Data reader as part of ADO.Net to access and update Database.
• Used LINQ to SQL to query database objects
• Designed new tables and created T-Sql Stored Procedures to implement business rules for the Project Overview Reporting System
• Was involved in doing impact analysis of Stored Procs, Joins etc during migration of Sybase 12.5 to Sybase 15.0
• Wrote Perl Scripts to run Nightly Batch Jobs on a Weekly or Monthly basis.
• Wrote Functional, Technical and user Documentation for the s System

Environment: VS 2008, C#, Net 3.5, LINQ, Sybase 12.5/15.0, Perl Scripts, Rational Clearcase and ClearQuest.

Confidential - Mount Laurel, NJ

Sr Developer

Responsibilities:

• Developed Web interface in ASP.NET for facilitating self-enrollment into the AAA program.
• Made extensive use of Dataset for XML Data Binding and Bindings to server controls.
• Made use of Grid View, Data List and Repeater Controls to display data in a customized format in the ASP.NET web pages
• Made use of the various validation controls in ASP.NET to validate user input.
• Created DTS/SSIS packages for transfer of data between databases and also these packages were treated as Datasource for reports generated through SSRS(Reporting Services)
• Used SSRS for creating tabular, freeform and crosstab reports using the Report Designor for the Retail office management system.
• Optimized and fine-tuned the SQL Queries to improve performance bottlenecks.
• Created new web reports for telemarketing using Crystal reports 11.0
• Did Maintenance, Production bug fixes, created builds and test plans for the MPS System
• Did enhancements to the web based Retail Office management system written in C# ASP.NET

Environment: Visual Studio 2005, C# 2.0, Business Objects 11.0, Sql Server 2008

Confidential - Hopewell, NJ

Lead Developer

Responsibilities:

• Migration of existing PowerBuilder application to .NET application using ASP.NET, C# 2005.
• Made customizations to existing FIPB reports as per client needs
• Debugged and removed defects in the web interface of the reporting system written in C#2.0
• Extensively used PL/SQL stored procedures, triggers and Packages using TOAD.
• Made use of object oriented features such as Inheritance, Encapsulation and Polymorphism.
• Wrote new logic to dynamically modify the Data window Sql to facilitate exporting of reports to different formats such as PDF, XLS, TXT etc using PowerBuilder 10.5
• Created new user objects and base class windows to reuse business rules and wrote new complex stored procedures that served as the data source for the reports.
• Wrote Unix Shell Scripts to schedule Autosys jobs and analyzed and resolved bugs in production.

Environment: Visual Studio 2005, C#, .Net 2.0, Oracle 10G, PowerBuilder 10.5, Autosys, Win XP

Confidential - Princeton, NJ

Responsibilities:

• Made customizations & bug fixes to IVRS System as per client requests.
• Created new Bas and Class modules and functions in Visual Basic 6.0 to store front-end business logic.
• Created local and Global External functions in PowerBuilder and did windows API calls and RPC calls.
• Created Dynamic Sql based on the 4 formats available in PowerBuilder.
• Created New T-Sql Stored Procedures and Triggers to store business logic and enforce referential integrity.
• Optimized and enhanced Stored Procedures and generated Ad hoc reports on a daily basis.
• Created various custom reports using Sql Select and Stored Procedure as the Datasource for the Data windows.
• Did Bug Fixing and enhancements to the Shell System written in PowerBuilder 9.0.
• Created Ancestor windows & User objects to make use of the Object Oriented Capabilities of PowerBuilder.
• Used Custom Data Utility to do Bulk Data loads into Production Databases.

Environment: PowerBuilder 9.0, Visual Basic 6.0, Sybase 12.0, DB Artisan

Confidential - Indianapolis, IN

Responsibilities:

• Made various modifications and bug fixes to the Caretrak System.
• Used the various PFC services such as Sorting, Filtering, Multitable update, Find and Replace, Linkage service etc.
• Optimized SQL queries in Datawindows and Stored Procedures to improve response time and performance.
• Designed new ancestor Userobjects for reusing business rules and modified the existing systems to be more Object Oriented.
• Developed new reports, made front-end builds and was involved in the implementation of CareTrak v4.0 at different Client sites.
• Did production support to resolve Front end and Database related issues.
• Created Stored Procedures, Functions & Triggers using PL/SQL.
• Was involved in writing a module in C# using WinForms

Environment: PowerBuilder 9.0, PFC, Oracle 9i, C#, Winforms, Visual Studio 2005

Confidential - Indianapolis, IN

Responsibilities:

• Made various enhancements to natural order, natural receivables and natural payables.
• Did bug fixing and enhancements to various projects in the Natural suite of projects using.
• PowerBuilder 9.0 and PFC.
• Extensively used Datawindows, Datastores, DropdownDatawindows and NVO’s.
• Made changes to Base Class windows and User objects and extensively used object oriented.
• Features such as Inheritance, Polymorphism and Encapsulation.
• Created new stored procedures/triggers and wrote SQL scripts for creating and modifying tables.
• Designed/developed customized invoice forms, shipping documents and reports.
• Independently added international support for date and telephone number formats for the entire Natural suite of products.

Environment: PowerBuilder 9.0, PFC, Ms Sql Server 2000, Visual Sourcesafe 6.0

Confidential - Pittsboro, IN

Responsibilities:

• Developed the shipping module that comprised of Load Building, Load Scheduling, Carrier, Route and Rate maintenance.
• Independently developed the Load Building and Load Scheduling functionality.
• Analysis and Design of Database tables and Powerbuilder Screens for the Shipping module.
• Developed Stored Procedures using PL/SQL constructs and Oracle Enterprise Manager to store business rules.
• Created Devices, tables, views and Sql scripts using SqlServer Enterprise Manager.
• Developed new reports for Shipping, Sales and Casting departments.
• Extensively used Grid, Crosstab and N-up datawindows for the various reports.
• Did web based reports using Cynergy Systems Framewok for EAServer.
• Did Bar code Scanning applications using PocketBuilder 1.5.

Environment: Powerbuilder 9.0, Oracle 9i, Ms Sql Server 2000, Visual Sourcesafe 6.0, PowerDesigner 9.0, EAServer 4.0

Confidential - Edison, NJ

Responsibilities:

• Designed the Request Maintenance Module wherein users can manually add/change loan information for each request.
• Developed the Security module to manage Groups & Privileges.
• Designed and developed a Front End Query tool, which allows the users to create and save their own ad hoc queries.
• Extensively used Tab controls, NVO’s, Datawindows and Datastores.
• Maintenance, enhancements and Bug Fixing the different Modules in the application.
• Designed new reports and modified existing reports.
• Wrote New PL/SQL Stored Procedures, Triggers and Oracle Packages using TOAD.
• Wrote UNIX Shell Scripts.

Environment: Powerbuilder 7.0.3, Oracle 8.1.7, Toad 7.3.0, PVCS 6.0.1

Confidential - NYC, New York

Responsibilities:

• Designed COM objects to WEB enable all Client Server reports.
• Maintenance, enhancements and Bug Fixing the different Modules in the application.
• Designed the base class windows using PB 6.5/8.0 Inheritance concepts and made use of the various PFC services.
• Designed the security module with user and role base.
• Migration of the application from PB 6.5 to PB 8.0.
• Extensively used Tab controls, Tree Views, List Views and Non-visual user objects.
• Wrote New Stored Procedures, Triggers and optimized Existing Procedures.

Environment: PowerBuilder 8.0/6.5, PFC, Ms Sql Server 2000, Visual basic 6.0, IIS, ASP, Object Cycle, Visual Source Safe and Test Director.

Confidential - NYC, New York

Responsibilities:

• Responsible in Creation of New Reports.
• Creation of COM components to WEB enable the existing Client Server reports.
• Modification and Enhancement of Existing Reports.
• Designed the base class windows using Power Builder 6.5 Inheritance concepts extending PFE layer in PFC.
• Migrated the application from 5.0 to 6.5.
• Made Front-end enhancements to in corporate new search criteria.
• Optimized Datawindow sql’s to improve performance.
• Wrote Stored Procedures and Triggers

Environment: PowerBuilder 6.5/7.0, Ms SQL Server 6.5, PFC, IIS 6.0, ASP

Confidential - NYC, New York

Responsibilities:

• Involved in Debugging and Enhancement of the Existing System.
• Worked on conversion from DB2 to Sybase 11.0.

Environment: Power Builder 7.0, Sybase11.0, DB2