PRATAP C. DAS
.NET Architect and team leader with more than 16 years of effective experience in design application architecture, data models and deployment architecture, building sustainable enterprise level software solutions
Experience gathering business requirements, completing key architecture design, and overseeing low-level and high-level design and documentation across the software development lifecycle.
Experience in Healthcare industry, developing and maintaining Laboratory Information Management System, Specimen Tracking & Management System., and Specimen Accessioning & Processing System.
Experience in finance industry in developing assets management on multiple platforms Windows as well as Web; using different technology stacks and tools. C/C++, VB, ASP, .Net Framework, C#, ASP.Net.
Experience in media industry with supporting Media Asset Management using innovative technologies like Azure DevOps, TDD, SQL Server and .NET Framework
Architecting, designing, and developing web and windows software applications using C#, VB.NET on Microsoft .Net Framework using Microsoft Visual Studio.
Developed multiple ASP.Net web applications using Web Forms as well as MVC, WCF; utilized web tools and technologies like .NET, Angular, node, bootstrap.
Designed and developed Service Oriented Architectures (SOA) using REST API & .NET Core.
Wrote stored procedures and optimized performance using PL/SQL and T-SQL for relational databases: Oracle, MS SQL Server
Created customer as well as management reports using SSRS, and Crystal Reports.
Imported data from different systems by developing SSIS packages for data analysis and verification.
EDUCATION & TRAINING
Bachelor of Computer Science & Engineering, Jadavpur University, Kolkata, India 2003
AI Programming with Python Nanodegree – from Udacity, 2018
Currently attending: Master of Science in Analytics, Georgia Tech expected graduation in 2021.
Platforms and Languages
C#, VB.NET, .Net Framework, .NET Core, Python, R, C/C++, Azure DevOps, Iguana, HL7
Nunit, MS Fakes
ADO.Net, OData, Entity Framework, PL/SQL, T-SQL
Database Management Systems
SQL Server, Oracle
SSRS, Crystal reports
SOA, Clean Architecture, Object Oriented Principles & Design (OOPD), Test Driven Development (TDD)
Agile, Scrum, Extreme, Waterfall
Visual Studio, Visual Studio Code, SSMS, Toad, GitHub, Bitbucket, Azure DevOps
VIACOMCBS, INC., NYC, USA MAR 2020 – PRESENT
Contributed to test driven development approach using Microsoft Fakes
Enhanced and supported business critical distributed systems
Developed code to enhance services hosted in Azure service bus.
Contributed to code management using Azure CI, and code coverage
Developed and reviewed T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
Technology: C#.NET, ASP.NET, .NET Core, Azure, Azure DevOps, SQL-SERVER, Bitbucket, Git
BIO-REFERENCE LABORATORIES, INC., Elmwood Park, NJ AUG 2011 – PRESENT
Design application architecture, data models and deployment architecture
Create and manage messaging based interfaces between applications. These interfaces receive, process and send around half a million messages a day. Load balanced these interfaces.
Principal developer for Building a system dashboard in Angular5 and nodeJS for monitoring applications.
Created Micro services for requisitions (images) and client’s data (Client Master). Requisitions and Clients data is considered a reference data which is consumed by different applications.
Designed and developed micro services in .Net Core for Azure migration
Designed and developed SSIS packages to integrate heterogeneous data sources.
Wrote complex SQL queries and developed Data base models, objects, and fine tuned stored procedures.
Designed and developed Specimen Processing Module to help Lab integrate with external EMR Solutions (Electronic Medical Record). The software also allows Lab’s order processing department to create and validate incoming orders and then interface those orders to multiple other systems in core lab and other departments like results entry, billing, reporting and other vendors.
Designed and developed a small yet extensively used content management system for lab users to allow them to access documents, articles, reports and software applications.
Created Continuous Integration and Delivery.
Transformed code repository from VSS to Git ( bitbucket)and transitioned to branch per feature development and adopted a standard branching policy.
Work with a team of 5 developers.
Meet with Business Analysts and end users to understand business requirements.
Technology: C#.NET, ASP.NET MVC5.0, VB.NET, .NET Core, Azure, SQL-SERVER,SSIS, Iguana, NodeJs, AngularJS 5, WebAPI’s, Azure, Reporting Services, BitBucket, Git
CETERA FINANCIAL, MN, USA FEB 2011 – JUL 2011
Optimized and wrote several stored procedures, triggers, views in Oracle 10g.
Optimized data transfer by reducing time consumption from 2 hours to 1 hour
Performed Code reviews on the code written by the team and ensured that the quality matched value chain expectations within operational standards
Contributed to the architecture and design of the application and developed the UI, Web Forms and User controls resulting in full optimization and utilization that improved internal efficiency
Technology: Visual Studio 2008/2005, C#, ASP.NET, WCF, WPF, .NET Framework 3.5/2.0, ADO.NET, Oracle 10g, Visual Source Safe.
GENERAL MOTORS ACCEPTANCE CORPORATION, MN, USA MAR 2007 – JAN 2011
Team Lead - onsite coordinator
Worked as a Technical lead, Primary support person and on site coordinator (onshore – offshore model) that drove vision and team collaboration
Contributed in the architecture and design of various projects.
Developed Win forms, web forms, reusable UI controls, backend components & high level classes using Object Oriented concepts.
Developed project’s custom Exception handling framework
Followed Agile / Scrum approach to design, develop and unit testing.
Migrated ASMX services to WCF services
Performed Code reviews on the code written by the team and ensured that it was of high quality
Implemented deployment architecture for diversity of user bases
Implemented design patterns wherever applicable to improve utilization efficiency
Wrote & optimized stored procedures, triggers, views and functions in SQL Server. Involved in database analysis and key design decisions.
Designed and developed SSRS reports.
Participated in Requirements Gathering / Clarifications from Business Analysts to ensure that the business requirements reflect in the project development
Proved myself as a key member of the elite development team & was praised several times by customers, colleagues and supervisors for the work I delivered.
Technology: Visual Studio .NET 2005 and 2008, C#, Win forms, Web forms, WPF, WCF, .NET 2.0/3.5, ADO.NET, SQL Server 2005, VSS, SVN, XML, HTML, CSS, Java Script, VB6, ASP, Oracle
INVERTO INDIA PRIVATE LIMITED, INDIA JUN 2005 – MAR 2007
Key member of R&D team
Designed and developed Win forms, Web forms, SOAP services, components
With hard work, dedication and integrity I contributed to deliver the product in time.
Received prestigious 'Champion of the quarter' award for designing layered architecture for this project
Technology: Visual Studio .NET 2005, ASP.NET 2.0, .NET Framework 2.0, ADO.NET, HTML, CSS, Java Script, SQL Server 2005, Visual Source Safe, XML, IE/Mozilla
COMPUTER EXCHANGE PRIVATE LIMITED, INDIA MAR 2004 – MAY 2005
Promoted to ‘Module Leader’ based on technical expertise and leadership in resource utilization, team inspiration, change management and strategic thinking.
Developed customized control for intuitive utilization and improved efficiency
Performed a gap analysis between the old version of the same software and the new requirements from the industry best practices to improve efficiency
Made the user interface more attractive and better performing than the old one through detailed configuration enhancements from internal team ideas and various customer feedbacks.
Analyzed and implemented multilingual web application
Key member of R&D team that provided overall leadership on strategic vision, design, assessment and implementation of systems to support operational efficiency
Development and Maintenance of Components
Lead a small team of Crystal Report .NET Developer
Technology involved: NET 1.1, C# .NET, Oracle, Crystal reports, VSS
SUN MACHINERY SYSTEMS PRIVATE LIMITED, INDIA JUL 2003 – DEC 2003