SUMMARY:

• Variety of industry domains: Manufacturing, Health - Care, Hospitality, Travel;
• Varied skill-set encompassing both database and application development;
• Actively applied or explored OO, BI, AI and other breakthrough software techniques and tools;
• Track record of several successful projects, executed independently or in teams;
• Most effective in a dynamic environment offering autonomy and a quality, results-driven, continuous improvement orientation.

TECHNICAL OVERVIEW:

Languages/Frameworks/IDEs: Visual Studio.NET; Visual* suite of languages C#, C++, BASIC; LISP, OPS5

Patterns and Practices: MS Enterprise Library (Application Blocks), Design Patterns

Scripting languages: UNIX Korn, Bourne and C shells, Awk, Sed; Windows PowerShell

DBMS/Middleware/Tools: SQL Server versions 2000 - 2016, SSIS, SSRS, SSAS, BI Stack including Power BI, Cognos, BO, TSQL, MS Access, Ansi SQL, NoSQL, Attunity RMS/Rdb Adapters, ADO.NET, Redgate database synchronization tools

COTS Implementation: Kronos Workforce TeleStaff

Operating Systems: Windows 7/8/10, Advanced Server, Open VMS, UNIX

Graphical User Interfaces: MS Windows Forms, MS Web Forms, OSF/Motif

Internet/Web tools: IIS, ASP.NET, jQuery, JavaScript, XML Web Services

Version Control: Visual SourceSafe, Team Foundation Server, Subversion

Modeling Tools: ERD, UML, MS Visio, Enterprise Architect

Agile Methodologies: Extreme Programming (XP), Scrum

WORK HISTORY:

Confidential

Principal Reports Developer, Washington, DC

Responsibilities:

• Responsible for designing/developing/implementing complex custom SSRS reports;
• Provided ad hoc SQL Server queries and other database support as needed.

Confidential

Voluntary Database Developer/Administrator, Washington, DC

Responsibilities:

• Designed and implemented SQL Server 2014 database for archived audio storage devices and media content of various musical artistes;
• Was involved in designing and implementing reports using Business Objects & Cognos
• Responsible for routine administration, CRUD operations using TSQL, data loads using SSIS.

Confidential

Senior Developer / Database Architect, Bethesda, MD

Responsibilities:

• Designed multi-gigabyte large SQL Server database with schemas and multiple File Groups to merge disparate Supplier Relations databases into a single, logically-grouped database to enforce hitherto missing referential integrity, reduce fragmentation and improve performance;
• Designed/implemented weekly/monthly/quarterly/ad-hoc SSRS Reports/Tableau to monitor company performance;
• Managed to work on Cognos & Business Objects reporting tools
• Designed/developed SSIS Packages to replace forms-based Visual Basic applications for efficient, flexible ETL processing;
• Designed/implemented ASP.NET WebForms application with SQL Server backend for quarterly Accounting use;
• Converted critical databases from Simple Recovery Mode to Full Recovery Mode;
• Automated, stabilized and improved several other database maintenance tasks.

Confidential

Senior Software Engineer, Silver Spring, MD

Responsibilities:

• Developed the following for multiple VA Registries (DVEIR, EFR, TBI, VITAS), each dealing with a different injury:
• SSIS 2008 ETL Packages;
• SSRS 2008 Reports;
• Cognos & BO Reporting;
• ASP.NET forms using jQuery.

Confidential

Senior Applications Developer, Washington, DC

Responsibilities:

• Administered SQL Server database(s); planned their development and upgradation.

Confidential

Senior Software Engineer, Boston, MA

Responsibilities:

• Developed complex SSRS reports analyzing research data for premier institutions like MGH and BWH
• Created ASP.NET forms in Insight, the group’s principal management information systems application.

Confidential

Senior Applications Developer, Manchester, NH

Responsibilities:

• Middle-tier web services; and
• Associated C# web methods, SQL Server database stored procedures and scripts, NUnit tests.

Confidential

Software Engineer, Nashua, NH

Responsibilities:

• Independently developed an Info Board web application for the Fulfillment business using ReportViewer Control in Visual Studio 2005, ASP.NET 2.0 and SQL Server 2005.
• Member of development team for the following applications in the Product Introduction business segment:
• Daedalus, a .NET application that evolved through at least six releases/versions; responsible for:
• Database Project Lead for implementation of SQL Server distributed database utilizing Replication
• Data-access methods using Visual C#/ADO.NET, exposed as Web Services.
• Data-conversion Project Lead for transforming legacy data in flat files to a relational database using ETLs and Attunity Adapter for RMS/Rdb middleware.
• PISCES, a 3-Tier Web application; responsible for designing/implementing SQL Server database and COM interfaces in Visual C++, converting all legacy data to new format using SQL Server DTS and Oracle DBI.
• Belvedere, a .NET product submission-tracking tool; Responsible for SQL Server 2000 database search functions and stored procedures, coding of data-access methods in Visual C#. eLibrarian/eGold, .NET applications that deal with CDD/DVD/Image content storage and transfer between sites;
• Designed/implemented SQL Server database and some WinForms presentation screens.
• Independently developed a proof-of-concept prototype using Enterprise Library Data Access Block and design patterns.
• IndependenMember of SPECWeb/3rdBase project responsible for alterations to the design and contents of the logical Oracle database and upgrade of the physical database server to v7.2.

Confidential

Senior Software Engineer, Nashua, NH

Responsibilities:

• Reviewing, kitting, testing and distributing fixes to multiple Digital UNIX versions.
• Shell scripts to automate various steps/functions in the kitting process.
• Project leader for inaugurating new support streams for Digital UNIX.

Confidential

AI Knowledge Engineer, MA

Responsibilities:

• Member of SOLUTIONS ADVISOR project - a tool to assist DEC sales staff in choosing 3rd party software to sell to customers. Responsible for:
• Developing graphical user interface using OSF/Motif.
• Identifying and removing bottlenecks adversely affecting database performance that resulted in improving interactive access times by a factor of 20.
• Design and implementation of complex, multi-file Rdb database.
• Coding of AI rules in the OPS5 language, key C modules that compute metrics based on Statistical Process Control (SPC) methods, SQL module language procedures, DCL command language procedures to automate production runs.
• Back-end report generation programs using DEC Rally (4GL).