Resume

Sign in

SQL Server / B.I. Developer with .NET Experience

Location:
Washington, DC
Posted:
April 29, 2021

Contact this candidate

Resume:

Jyoti P. Sankaran

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

Residency status: U.S. citizen

adl11v@r.postjobfree.com

SQL Server / B.I. Developer With .NET Experience

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, TSQL, MS Access, Azure SQL, NoSQL,

Attunity RMS/Rdb Adapters, ADO.NET, Redgate database synchronization tools

COTS Implementation: Kronos Workforce TeleStaff

Cloud Services: Microsoft Azure PaaS configuration of SQL Server database

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, Git

Modeling / Reporting / BI Tools: ERD, UML, MS Visio, Enterprise Architect, Microsoft BI Stack: SSRS, SSIS, SSAS, Power BI,

DAX, MDX

Agile Methodologies: Extreme Programming (XP), Scrum

PROFESSIONAL ACCOMPLISHMENTS

VETERANS ADMINISTRATION MAHSO PROJECT, Washington DC – CONTRACT Jul 2019 – Sep 2020

Senior SQL Server / B.I. Developer in a Teams / Scrum / Jira Kanban / Git environment

Developed key Queries, Views, Stored Procedures for 150 GB Azure SQL database;

Deployed Development database to Production using SSDT DacPac, BacPac, PowerShell;

Independently developed and implemented Data Dictionary using Azure SQL and Power BI;

Created Power BI reports and SSIS Packages to support project’s analytical objectives.

DEPARTMENT OF HUMAN SERVICES, Washington DC – CONTRACT Jul 2018 – Jan 2019

Senior SQL Server Backend Developer, Office of Information Systems

Developed key backend components of CATCH application 3.0 in TFS/Agile SCRUM environment

oWrote SQL queries, stored procedures, functions for ASP.NET ReportViewerControl;

oDesigned and developed statistical and other reports in SSRS with charts/graphs;

oConfigured SSRS Report Manager / Report Servers for multiple deployments.

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

Senior Database Developer, Department of Technology Services

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

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

oUpdate SOC database with missing / corrected IP addresses;

oAutomate IP mailings to Network Administrators in all US Courts;

oInstall/configure SSMS/Visual Studio with SSDT;

oProvide inputs to design/consolidation of multiple databases

Jyoti P. Sankaran Page Two

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

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.

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.

Jyoti P. Sankaran Page Three

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.

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 Build, 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