OBJECTIVE:

• To obtain a challenging position in the Confidential field as a Senior Software and Database Engineer that will utilize my diverse computer skills and my strong analytical abilities, also seeking a position that offers opportunity for rapid advancement.
• 20+ years IT experience in software development / architecture and system integration

SUMMARY

• My background includes over 20+ years of application development, architecture and system integration with in - depth knowledge, diverse skills sets and strong analytical abilities.
• I am a dedicated and driven professional that offer particular expertise in the high tech sector by developing and implementing software products that are on the cutting-edge of technology.
• Hands-on full life-cycle design and development expertise creating production-strength applications based on wide variety of modern technologies in agile environment including .Net, Angular JS, JQuery, SOA, XML, mobile development and more
• Dependable team player well versed in both small company and large enterprise environments.
• Architected production featuring complex set of business logic, from scratch
• Quick adaptability to the new technologies
• Lead teams of 4-10 through SDLC iterations, mentored fellow developers on the various aspects of application architecture and development.

SKILLS SUMMARY:

• Microsoft ASP.NET (v4.5 or lower) / Microsoft VB.NET / Microsoft C# - 8 years
• MVC 5 and lower, Razor, JQuery, AJAX, JSON, HTML5, Web Services, REST APIs - 2 years
• Angular JS, Twitter Bootstrap, NodeJS, JQuery, Grunt, Bower, GIT, Azure, Mongo DB - 2 years
• Java - 3 years
• Mobile Android development - 6 months
• Microsoft Visual Studio (2013 or lower) - 6+ years
• Microsoft SQL Server (2008 R2 or lower) / MySQL - 10+ years
• Erwin, DTS, SSIS, - 8+ years
• Window Server 2008 R2, IIS 7.5 and related software installation / configuration - 6 years
• Microsoft Visual Web Developer 2008 - / Microsoft Visual Interdev 6.0 - 5+ years
• Microsoft Visio (2007 or lower) - 4 years
• Crystal Report (v.11 or lower) - 10+ years
• Oracle Database (11g / 9i or lower) / TOAD Software - 10+ years
• SharePoint - 10+ years
• Confidential Siteminder Agent r6/r12 DKO/AKO/SSO Single-Sign-On installation / configuration - 7 years
• Entity Framework / ORM, LINQ, Lambda Expression, Dependency injection - 5 years
• Multi-Layered, Multi-Tiered .NET applications using ORM tools - 7 years
• Data Access Layer with ORM tools, Entity Framework- 7 years
• ASP.NET AJAX Control Toolkit - 8 years
• Active Serve Page (ASP) /Visual Basic and VBScript / Java and JavaScript Script - 9+ years
• Oracle, SQL* Plus and Pl/SQL - / Oracle Forms / Reports (v.9i or lower) - 10+ years
• IBM Rational Software Modeler / Rational ClearQuest / Rational ClearCase / XML Spy - 1 year
• ArcGIS Server v9.2 /ArcGIS Engine v9.2 / ArcCatalog / ArcMap / ArcSDE - 1 year
• OLE, COM, DCOM, .Net Remoting, Web Services, ODBC - 9+ years
• NET Framework Installation v1.1, v2.0: Installation / Setup and Administration - 8+ years
• IIS & Visual Studio / Visual InterDev: Installation / Setup and Administration - 8+ years
• Microsoft SQL Server Management Studio: Installation / Setup and Administration - 8+ years

EXPERIENCE:

Confidential, Largo, MD

Lead Software Architect

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Updated functional specification and technical design documents and also created new design documents
• Design of the Architecture of the Data Warehouse and helped in performance tuning of the data base.
• Design the Entity Relationship (ER) models and logical data (LDM), physical data (PDM) models in Power Designer based upon the design documents.
• Modeling new fields/tables in Operational Data Store (ODS) as per new requirements.
• Extensively worked on full Software Development Life Cycle (SDLC) of the project from Database Design and Modeling to implementation and maintenance.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Set up development environment and process including quality standards, change management and configuration management
• Recruit development team and trained them in development process
• Develop customer survey system
• Develop bulk email system
• Solve security issues with ASP.NET
• Perform system deployments, modifications and routine maintenance

Confidential, Falls Church, VA

Lead Software Architect

Responsibilities:

• Used database first to generate data source and model from the CLED database objects
• Used model first to build brand new CLED and AIMP Log databases from models created using the designer in Visual Studio
• Used POCOs and C# code to generate instant ORM used on the CLED project
• Used Entity framework to request various data collections of Linguist, Organization, Contract instances
• Developed .Net web forms, reports, REST APIs, web services, database objects to track Linguist information including local nationals, their language(s)/dialect(s), current location, security clearance category, work history and security clearance status.
• Designed SSIS Packages to transfer data from various sources like Text Files, SQL Server, and Excel to SQL Server using Business Intelligence Development Studio.
• Wrote T-SQL queries, Stored Procedures and used them to build packages.
• Designed, Developed and Deployed packages in SQL server environment using SSIS 2008.
• Designed, modified and troubleshoot SSIS packages.
• Used SSIS to load data from various sources into on SQL Server 2005 database and created packages.
• Involved in tuning and configuration of SSIS.
• Deployed SSIS packages from Development to Testing Servers
• Debugging of SSIS packages.

Confidential, Alexandra, VA

Senior Web Developer

Responsibilities:

• Developed .net code for US Army Corps of Engineers ERDC (Engineer Research and Development Center) to assists the United States Army in the planning and execution of Military Operations on Confidential Terrain.
• Created ArcGIS applications in .Net environment to provide commanders with on - demand, integrated understanding of the dynamic Confidential battle space.
• Generated codes to complement and automate parts of the military decision making process in different scenario.
• Used .Net and ArcGIS products to demonstrate how the Confidential DST and ERDC tools could complement in the same lab environment.
• Integrated several ERDC tools into a singular application that can be used to provide dynamic mission planning and decision support.
• Experience in designing Database Models using Erwin.
• Involved in designing the Logical and Physical data models for the data warehouse.
• Created DDL scripts to create database schema and database objects like tables, stored procedures, views, functions, and triggers using T - SQL.
• Create the clustered/non-clustered indexes on tables; Trace out for any table required any indexes and determine the type of index on it.
• Created triggers to enforce data and referential integrity, on the specific table which helped users to prevent inserting invalid data or to respond to a certain events like INSERT, UPDATE and DELETE.
• Enabled the Future Force to achieve land force dominance at tactical and operational levels.
• Provided system for synchronized Intelligence, Surveillance, and Reconnaissance and the Tasking, Processing, Exploitation, and Dissemination.
• Enhanced the ability to execute battle command, synchronize fires and effects, rapidly shift battle focus, achieve situational understanding, and protect the force.
• Involved in database designing using Normalization.
• Place the huge table/non - clustered index on the separate file group to improve the performance.
• Traced complex stored procedures, SQL queries and monitored using SQL Profiler.
• Efficient use of Joins and sub-queries in queries that retrieve data from multiple tables.
• Involved in development and debugging of complex batch T-SQL Procedures and functions.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using SQL Server SSIS.
• Worked extensively on SSIS Package designs for Import/Export from various Data Source Flat file, Excel, Oracle to MS SQL Server and vice versa and schedule the jobs.

Confidential, Crystal City, VA

Senior Application Specialist

Responsibilities:

• Involved in a full life cycle designing, developing and implementation of these web applications.
• Developed and created various VB.net, Asp.net forms with data extracted from a SQL database.
• Developed various mathematical and statistical reports using Crystal Report 11.
• Used N - Tier Architecture development that involves Presentation Tier, Data Access Tier, Business Tier, and Database Tier.
• Coded Client side, Server side validations and extensively use Datagrid controls.
• Created CSS (Cascading Style Sheets) and JavaScript to enhance the esthetics of the web application.
• Created .net class object, program flowcharts, data flow and process flow diagrams with Microsoft Visio
• Developed SQL scripts to extract data from a MySQL and SQL database to be used in forms and reports requested by clients.
• Provided code documentation and Perform Unit Testing of all applications.

Confidential, Vienna, VA

Senior Software Developer

Responsibilities:

• Designed, analyzed, developed & tested ALIAS web application.
• Utilized Net Advantage 2003 to create tab controls, grid controls and menu controls; these custom controls are incorporated into the various web forms.
• Involved in the development and implementation of ALIAS User Interface, Web Sphere MQ SOAP Protocol, Web Services and Oracle Database on Window NT environment.
• Worked extensively on Container management, XML Serialization, Web Service management, Time - stamping initial entry and last update
• Used CSS (Cascading Style Sheets) and JavaScript for esthetics of the web application.
• Implemented security and session handling functionality in base class.
• Provided web pages interact with the object model when request is made to the backend and response is received. This allows data to the web pages in the form of objects and receiving requests via the objects methods.
• Created custom class for web forms, which provide features and behaviors common to all pages and a common base class that provides the application a common look and feel.
• Worked with full-featured IIS 6.0 Web server that provides a reliable, manageable, scalable, and secure Web application infrastructure built into Windows Server 2003.
• Provided code documentation.
• Performed Unit Testing of all applications.

Confidential, Clifton, VA

Senior Application Developer (LEAD)

Responsibilities:

• Developed & tested Project Tracking System Application (PTS).
• PTS helps to track the Status of project schedules, time estimation, Tracks the hours spent for Contractors for each project, Time Sheet management & Approval by manager etc.
• The Application was developed using .NET technology (ASP.NET, VB.NET, ADO.NET).
• Some of the features of .Net used were Server side Controls, event driven code, debugging features, just in time compilation, Caching Services for better performance, .Net frame work class library, built user Interface that separated Application Logic from Presentation code & handled events as in VB, used VB.NET for developing DLLs, Built - in State feature was used for maintaining the state of Objects.
• Use Post-back form feature to hold user inputs and Object oriented features (OOP). Confidential (Electronic Sales Engineer) - (ASP.Net, VB.Net, C#, ADO.Net, JavaScript, Visual Studio. Net, XML, XSL-T, HTML)
• Involved in analysis, development, and unit testing of Confidential product, promotions and reports
• Designed and developed the configuration screen for the product and reports.
• Followed N-Tier Architecture development that involves Presentation Tier, Data Access Tier, Business Tier, and Database Tier.
• Coded Client side and Server side validations. Also used validation controls
• Extensively used Datagrid and Repeater controls
• Extensively used ADO.NET for database connectivity. Datasets, SqlDataAdapters and SqlDataReaders are used.
• Provided code documentation and Unit Testing of all applications.

Confidential, Washington, DC

Senior Application Developer

Responsibilities:

• Solely designed, developed and implemented the Air Traffic Services Personnel Action Tracking System (ATSPATS): a multithread database application using the Windows NT, Unix operating system, Oracle and Microsoft s IIS (Internet Information Server) using Visual InterDev.
• Designed/constructed all of the SQL queries, many with multiple joins, that were used by the various ASP scripts to query and update data.
• Coded ASP scripts that consisted of conventional free - form VBScript that was embedded into the HTML pages and a number of functions available to the various ASP scripts that I placed into include ( header ) files.
• Wrote JavaScript on the front-end that was used primarily to perform the pre-validation.
• Used CSS (Cascading Style Sheets) and JavaScript to enhance the esthetics of the web site. This web-based consisted of over 100 database tables, Store Procedures, Functions, Event Triggers and all of which were designed by me, to provide Federal Aviation Administration s ( Confidential ) Service Areas, Program Directorates, and Regional Offices the ability to track various Personnel Actions, Pay Bands, Pay Ranges, Salaries, Career Levels, Job Categories, Positions, Status and others data entities that are included in Confidential Core Compensation and Management Staff & Specialist Pay Systems.
• Solely developed and deployed a tracking system using Microsoft Access 2000 and Visual Basic 6.0 for tracking personnel and employees salary information. The tracking system provided Confidential Human Resource Managers the capability to track budget expenses per Fiscal Year based on Line of Business staffs, and also the ability to track case workload by U.S. Regional Offices and Headquarters.
• Maintained and analyzed data, as well as developed reports, in a Microsoft Access database as the primary programmer on an account team for a specific company client.
• Developed and maintained graphical user interfaces using Microsoft Access forms and VBA which allowed easier entry, manipulation and review of the client s data by account team staff.
• Responsible for developing, enhancing and maintaining the routine processes in another company client s Microsoft Access database to handle the data flow for their major service program.
• Created, designed, and generated series of Reports and Letters using Oracle 6i and Crystal Report 8.5 for the OEAAA Tracking System, with advanced parameter passing, searching and sorting capability.
• Supervised and supported the system analyst and technical team to provide clients with the system documentations such as: business rules, system enhancements, requirements, testing matrixes, training manuals, user guides, work flowcharts and others documents.

Confidential, Washington, DC

Senior Application Developer

Responsibilities:

• Involved in a full life cycle designing, developing, analyzing and implementation of the Agricultural Labor Certification (H2A) and the Permanent Labor Certification (PLC) Software. Using Oracle Form 6i these web - enabled applications provided features such as On-line registration, Case tracking, logistics management, Case workload, Case assignment, ad-hoc query abilities and user friendly search screens.
• Created reports and letters using Oracle Report 6i tool.
• Converted modules from Oracle Form 4.5 & 5.0 to Form 6i and Oracle Report 2.5 to Report 6i as part of web enabling the applications.
• Implemented system rules and validations through codes. Developed user interface screens using Alerts, Visual attributes, check boxes, and even driven triggers.
• Developed an Inventory Tracking System for a Library & Book Store using Visual Basic 6.0, SQL Server 6.5.
• Involved in the Study of prevailing Manual Record - Keeping System, and Designed Data Model based on the Study.
• Implemented Stored Procedures for various functionalities, including book inventory maintenance, books on loan and late fee calculation, Search facility on ISBN Number, Author Name and Title for Library Module. The System maintained book inventory for the Book Store using ISBN Number to determine the books in stock, record Sales History and generate re-order statements based on the same.
• Developed as a three-tier Client-Server based solution, the system comprised of ActiveX EXE that exposed classes for Data Retrieval and Storage.