Jyoti P. Sankaran
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.