Resume

Sign in

Sql Server Developer

Location:
Washington, District of Columbia, United States
Posted:
June 13, 2018

Contact this candidate

Resume:

Jyoti P. Sankaran

Washington DC *****-****

Residency status: U.S. citizen

ac5vg2@r.postjobfree.com

SQL Server Developer-Architect With .NET

SUMMARY

Employed by reputed technology companies: Hewlett-Packard, Cigna, Partners. Harris;

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,

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

Internet/Web/GUI tools: IIS, ASP.NET, jQuery, JavaScript, XML Web Services, MS Windows Forms, MS Web Forms, OSF/Motif

Version Control: Visual SourceSafe, Team Foundation Server, Subversion

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

Agile Methodologies: Extreme Programming (XP), Scrum

PROFESSIONAL ACCOMPLISHMENTS

US COURTS, ADMINISTRATIVE OFFICE, Washington DC -- CONTRACT Dec 2017 – May 2018

Senior Database Developer, Department of Technology Services

oCreated queries/stored procedures/reports to manage Security Operations Center [SOC] activities

Locate/Track IP addresses assigned to all 40+ US Courts;

Update SOC database with missing / corrected IP addresses;

Automate IP mailings to Network Administrators in all US Courts;

Install/configure SSMS/Visual Studio with SSDT;

Provide inputs to design/consolidation of multiple databases

CSRA Inc. - Senior Database Architect Oct 2016 – Jun 2017

CONTRACT: DEPARTMENT OF HOMELAND SECURITY, US SECRET SERVICE

Principal Reports Developer, COTS Implementation of Kronos Workforce TeleStaff

oResponsible for designing/developing/implementing complex custom SSRS reports;

All reports organized on Stored Procedures using CTEs and performance Indexes;

Installed/configured elaborate development environment of Visual Studio,

Report Builder, Report Manager and Report Server;

Configured granular user access based on Secret Service Divisions and Ranks;

Met aggressive deadline schedules in an Agile Scrum environment of 10-day Sprints;

oProvided ad hoc TSQL queries and other database support as needed.

INTERNATIONAL MUSIC ASSOCIATES, Washington DC, Est.1982 Sep 2014 – Oct 2016

Vol. Database Developer/Administrator

oDesigned and implemented SQL Server 2014 database for archived audio storage devices

and media content of various musical artistes;

oResponsible for routine administration, CRUD operations using TSQL, data loads using SSIS.

Jyoti P. Sankaran Page Two

RADIUS TRAVEL COMPANY, Bethesda MD Oct 2011 – Jul 2014

Senior Developer / Database Architect, Supplier Relations Solutions

oDesigned 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;

oDesigned/implemented weekly/monthly/quarterly/ad-hoc SSRS Reports to monitor company

performance;

oDesigned/developed SSIS Packages to replace forms-based Visual Basic applications for

efficient, flexible ETL processing;

oDesigned/implemented ASP.NET WebForms application with SQL Server backend

for quarterly Accounting use;

oConverted critical databases from Simple Recovery Mode to Full Recovery Mode;

oAutomated, stabilized and improved several other database maintenance tasks.

HARRIS CORPORATION, Silver Spring MD May 2010 – Jul 2011

HealthCare Solutions – Veterans’ Administration (VA) Programs

Senior Software Engineer IV

oDeveloped the following for multiple VA Registries (DVEIR, EFR, TBI, VITAS),

each dealing with a different injury:

●SSIS 2008 ETL Packages;

●SSRS 2008 Reports;

●ASP.NET forms using jQuery.

CORPORATION FOR PUBLIC BROADCASTING, Washington DC Apr 2010 – May 2010

Senior Applications Developer, Information Systems

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

PARTNERS HEALTHCARE SYSTEM, Boston, MA Jan 2009 – Apr 2009

Senior Software Engineer, Research Applications Group

oDeveloped complex SSRS reports analyzing research data for premier institutions like MGH and BWH

oCreated ASP.NET forms in Insight, the group’s principal management information systems application.

CIGNA HEALTHCARE, Manchester, NH 2007 - 2008

Senior Applications Developer, ChoiceLink Software Division

Member of AdminOrchestrator, a .NET n-tiered Winforms application that automates health-care

enrollment setup. Designed/developed:

oMiddle-tier web services; and

oAssociated C# web methods, SQL Server database stored procedures and scripts, NUnit tests.

HEWLETT-PACKARD COMPANY 1997 – 2006

[Successors to Digital Equipment Corp & Compaq Computer Corp]

Software Engineer V, Americas Software Manufacturing, Nashua NH

oIndependently 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.

oMember 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.

oIndependently developed a proof-of-concept prototype using Enterprise Library Data Access Block and design patterns.

oIndependenMember 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.

Jyoti P. Sankaran Page Three

EDUCATION

oCertificate Course in Artificial Intelligence, Harvard University

oMA, Economics, University of Bombay

oBA, Economics, University of Bombay

PROFESSIONAL DEVELOPMENT

oFrequent attendee at in-depth Microsoft Developer Days and TechEd seminars, technical events, training programs:

Microsoft launches of new versions of .NET / Visual Studio / SQL Server

Language tutorials/lectures/seminars by eminent authors J Liberty, D Chappell, Chris Sells, Don Box, etc.

oPresented several “brown-bag” seminars at Hewlett-Packard relating to new technologies.

oContinuous Member of .NET and PASS SQL Server User Groups since 2000.

oSubscriber to MSDN, Visual Studio, SQL Server magazines.



Contact this candidate