Candidates About

Sanjay Gupta       

PROFILE

·         In-depth Experience in Solution Architecture, Product Development, Application Customization, System Design and engineering, large corporate systems analysis and design and development, Research & Development on emerging technologies, database design and performance tuning.

·         Architect & Developer on Database design, Stored Procs, T-SQL, PL/SQL, SSIS, ETL Design, SQL Tuning of MS-SQL Server and Oracle. Enterprise level Integration between applications

·         As an Architect, created infrastructure based on Windows 2008 and Windows 2012 with High Availability of Application, Backup, Restore, Web Farm, Replication/Clustering, Networking, NAT, Firewall, Ports, Security/SSL, RAID Controller, guest operating system on hypervisor Microsoft Hyper-V and Citrix XenServer.

·         As an Architect and developer, implemented Service Oriented Architecture, Software as a Service (SaaS), Cloud as computing platform and Implementation of internet services in to applications on.NET platform developed in C#

·         Hands on experience with Object Oriented Programming, .NET Framework, C#, C++,  VB.NET, VB 6.0, Web Services in .Net, Windows Services, MSMQ, Multiple-Threading

·         Products with recognition - Dialect CTI Product of the year, HIP Nursing Tablet wireless application, RestaurantWave product with high customer satisfaction and almost zero customer attrition

·         Experience in all phases of Software Development Life Cycle (SDLC) – Concept Definition, Requirements, Detailed Analysis, Design, Development, Testing, Delivery and Maintenance.

·         Architected Redis Caching on ASP.Net application

·         Infrastructure programming FTP, SFTP, Robocopy, PGPEncryption

·         As an Architect, implemented Mobile Technologies as mobile website and apps, using HTML5, Phone Gap, or Native Development in Java or Objective-C.

·         As an Architect & Developer, Implemented XML, XSLT, DOM, Schema Design, Validations, X-Path Query

·         As an Architect & Developer, designed, developed and implemented real time monitoring and dashboard for applications and infrastructure

·         Analysis and Design on MVC Pattern, Signal-R, Object Relational Mapper, Caching, Entity Relation Diagram

·         Guiding team on Mobile Devices development using JavaScript and Phone Gap

·         User interface Analysis and Design of Mobile Responsive interface e.g., iPhone, Android Phone, Tablets of different sizes

·         Architected & Developed, products and innovative solution with research & development in C#, C++, Visual Basic, MS SQL Server, service side and client side

·         Hands on knowledge of Building data center in the cloud, fairly good understanding of Hard-drive RAID, Firewall Configuration, NATing, Colocation, Redundancy, VPN Network, SSL, FTP/PGP-Encryption

·         As an Architect and Developer, Developed applications with strong understanding of logging with different level of errors, now in the internet applications monitoring user behavior is critical

·         As a Tech Lead, Root cause analysis of issues/outages hardware or software, and remedial approach to minimize and eliminate the recurrence of such issues in future

·         As a Lead & Architect, continuous improvement of existing application & systems, also manage and improve organization methodologies and management approach.

·         Project Planning, Resources Planning, Hardware & Software Costs, Effort Estimation, delivery timeframe

·         Guide the team with best practice on Version Control, Management of different environment like Dev, Staging/UAT, and Production.

·         Passion for learning and problem solving, with ability to lead and motivate team to achieve goals
Build Team, Improve Processes and Create Efficiencies; creative and smart automation
Raise the team’s performance; Working with the team to accomplish complex objectives
Persistence; a strong sense of “can do” with ability to make progress against odds

SKILLS               

Leading/Management: Develop new Products and Applications, Maintain and Enhance Applications, Solution Architecture, Technical Lead, Effort Estimation, Delegation and Monitoring, Bugs/Issues/Project tracking using JIRA

Technical: MS SQL-Server, Microsoft .Net Asp.net, Web Services, Windows Services, C#, C++, MSMQ, PostgreSQL, Oracle PL/SQL,  Windows Performance Monitoring, Cloud, Hardware Infrastructure, Networking, Databases

Business Verticals: Healthcare, Hospitality, Defense, Telecom, HR/Timekeeping/401K, Marketing

EXPERIENCE     

Vrindi Inc – Software Architect & Developer                                 July 2017 – Present

Architecting POS and Inventory System: Leading the design of next generation cloud based software, with offline/online real-time connectivity. The technology platform is, Angular, Bootstrap, ASP.net, with multiple database support on MSSQL and PostgreSQL.

Data Warehouse and Real-time Dashboard: Architecture and Design of Data Warehouse for real time dashboard and business intelligence using ASP.Net Core 2.0 Web API, SQL Server and PostgreSQL.

Analysis and Design of mobile platform for loyalty application using React Native with multiple database support on MSSQL and PostgreSQL.

JIRA installation and configuration of multiple products version and phases. Working through Epic, Sprint and Stories to organize working of multiple teams and projects.

Leading team to manage diverse CMS eCommerce platform e.g., Magento.com, SplendidCRM, WordPress, Umbraco. Also design and delivery of HummusandPitas.com responsive website and apps for Cluck-U-Chicken.com and Hummus and Pitas.com

Networking and Server Management: Configuration of Cisco network firewall, building of servers using Microsoft Hyper-V and Citrix XenServer. SNMP Alert configuration on Dell Open Manage server.

Vrindi Inc – Consultant @ Lockheed Martin/Sikorsky as Solution Architect      Feb 2016 – June 2017

Rotary Mission System CRM ETL using SSIS/SQL (2 months): Designed and developed interfaces to Dynamic CRM using Kingsway Soft SSIS plugin. Designed and developed TSQL stored procedure to transform Sales Force data to Dynamic CRM. Also designed and Developed program to load data into Dynamics CRM from Excel using .Net application.

HR/Badging System Data Feed TSQL PL/SQL ETL (8 months): Designed and developed data feed from Sikorsky Corporation to Lockheed Martin from SQLServer to Oracle PL/SQL to PGP Encrypted File. Majority of the work was in PL/SQL. The application required problem solving using PL/SQLs when getting feed from SQLServer as there were limitations in advance adhoc queries against SQLServer links.

Sikorsky Aircraft Maintenance System and Others (6 months): Designed .Net applications used for keeping Aircraft Logs, Electronic Technical Manual.  Hand-on extensive work in PL/SQL to optimize performance of slow running processes and solving complex data issues. Re-engineered existing application, with most of the application developed in PL/SQL, which integrates Sikorsky Badging/HR data with Lockheed Martin HR System.

The initial goal on this project was to port a large legacy application from VB6 and Oracle to web application on .Net platform. The initial effort on this assignment required, effort estimation, project timeframes, costing, application architecture, high level design, establishment of application framework and standards, identification of third party tools and controls that can accelerate development. I built a prototype using .Net 4.5, Entity Framework 6, Oracle 11G and Telerik Reporting and other Components.  The bugs tracking, monitoring, analysis/dashboard of labor hours for various issues was done in JIRA.

Vrindi Inc - Software Architect & Developer                                              July 2008 – Jan 2016

RestaurantWave Product (2008 – 2016): Lead the team of six developers to create the product from conception to design and implementation. I launched the product for small to medium restaurant businesses, with more than two hundred business using it. The technology enables ecommerce transactions and organic marketing for the restaurants. Many custom projects designed with complex delivery logistics. Framework uses web services for Telephone and Fax Integration and for real time monitoring of transactions. Many other cloud based services are used for Email marketing, Media Streaming and more. The financial transactions were implemented considering the best PCI Compliance standards. The system currently processes tens of thousands online transactions with millions of pages of served each month.  The product is engineered on ongoing basis with the team size of two to three developers. Also got part of the application developed using HTML5, CSS, JavaScript using PhoneGap.

Centralized Administration and Monitoring Tools (2008 – 2010): Centralized management tools help manage hundreds of websites on different servers & datacenters. The centralized monitoring gets real time feed from all the production with events monitoring of telephone calls, faxes and other important events. The solution is complex because of real time monitoring.

RestaurantWave.com Portal (2012 – 2015):  An aggregated solution which will offer new classes of services that will work seamlessly with local web solution. It currently offers event reservation / ticketing system.

HotelWave Product (2010 – 2013): Created ecommerce and marketing platform for hotels. The framework provisions Room Booking Engine, Payment Gateway Interfaces and more.

Customer Relationship Application (2008 – 2014): Bugs/Issues Tracker, Timesheet Login/Logout through tablet and advance labor management system, Billing, Sales and Splendid CRM System for tracking customer information.

Vrindi.com and HospitalityWave.com Portals (2008 – 2016): These two portals positioned the sales and marketing of the product. The website have advance functionality on pricing based on Pay-per-click model,  or pricing  of contents and  functionality of pricing and promotions based on the IP-Address and link to other tracking system for monitoring leads.

Environment: Windows 2012, .Net 4.5, .Net 3.5, Azure, Telerik, SQL-Server 2012, SQL-Server 2008, Web Services, MSMQ, T-SQL, Redis, Phone Gap for iPhone and Android, C#, SFTP, Cloud Monitoring Services, Signal-R, XML, XSLT, HTML, CSS, Payment Gateway Authorize.net, PayPal, Mercury Payment System, Mobile app on PhoneGap using HTML5, CSS, Javascript

Responsibilities across all projects: Architecture, Analysis, Design and Hands-on troubleshooting of issues related to performance or serious platform issues.

Horizon Blue Cross Blue Shield, Developer/Architect                   May 2005 – June 2008

Message Oriented Middleware (MOM) was an exciting project to serve data from multiple sources through service bus. Several applications that consumed the services are, Member’s Portal, Provider Portal, Siebel (now Oracle) Customer Services Application / IVR / Other mainframe bound Message Queue applications. I worked in multiple roles, as a Developer and Architect, Designed & Developed web services to multiple backed data sources connected using MSMQ and SQL-Server. The development required application of best practices in Service Oriented Architecture using Microsoft Technologies.

Hands on development of critical web service serving millions of transactions per month across the enterprise. One of it was providing National Provider Identifier (NPI) to many applications throughout the organization.

BizTalk interfaces for transformation of data from one system format to another, followed by PGP Encryption or Decryption for transferring the data to agencies outside the organization. I have good understanding of HIPAA compliance and adoption of best practices on security of information inside and outside the corporation.

I also helped PMO office with projects dashboard designs which could help make strategic decision during the Concept definition and detailed Analysis of costs and resources in Design phase.

Environment:  Microsoft .Net 2.0, Visual Studio 2005, SQL-Server 2005, BizTalk 2006, Microsoft MSMQ, C#, MSSQL Stored Procedure, XML and XSD, .net Serialization and Deserialization.

New York State Teachers Retirement                                             Mar 2005 – Apr 2005

Architect the highly scalable .Net Web Application, to work with PeopleSoft backend.

Health Insurance Plan of New York, Tech Lead & Developer        Nov 2003 – Dec 2004

Architected, Designed and developed TabletPC wireless application for patient’s clinical information to be used by nurses in hospitals. The diagnosis and prognosis about patients were discussed between HIP doctors and hospital nurses/doctor, which allowed HIP to proactively limit the wasted procedures and cost. The application was recognized as one of its kind application in the healthcare Industry for innovation and reducing healthcare costs. Information Week featured an article by HIP CTO on this application http://www.informationweek.com/story/showArticle.jhtml?articleID=21700225

Environment:  Net C# (User Interfaces, Web Service, Windows Service), SQL-Server DTS, .Net Interop, VB6, MSDE, SQL-Server, Wise Installer, TabletPC Inking SDK, ComponentOne controls and Crystal Report.

Northern Telecom, Technology Adviser/Technical Lead                           1993 – 2003

(Williams Telecommunications & NextiraOne)

I did many telecom software products as a team member and technical lead. Dialect suite was a comprehensive product for enterprise call centers that enabled Computer Telephony Integration with Northern Telecom PBX switches. The product created newer breakthrough interfaces to service customers reaching for help via Email, Online Text Chat and Fax, in addition to IVR/Telephone Call. We created Telephone call distribution queue as primary delivery mechanism by creating phantom call. It has won awards for being the best in its class and has many success stories with large corporate customers.

The Dialect Suite has won a coveted 1998 CTI Product of the year from CTI Magazine (The Dialect Suite has won a coveted 1998 CTI Product of the year (http://www.tmcnet.com/articles/ctimag/0199/ctipoty98.htm) Product of the Year Award for 1999 from Communications Solutions magazine; Judges Pick award from Computer Telephony Demo and Expo '98; and the Society for Technical Communication Award of Excellence.

The role also involved hands on design and development of many modules. I designed and developed the demo for the application that made a huge difference in connecting with the buyer.

I also worked with many Telephone/IVR/Client Server technologies with a unique approach to managing projects/labor hours for Amusement parks and large government organizations. The recording of labor hours could be done from different client operating system and using Telephone IVR System. The product was called “Wye Time and Attendance System”, developed using C-language, Uniface, SQL-Server and Oracle.

Coopers & Lybrand – Human Resources Technology Group, Consultant                                    1992 - 1993

I was involved in the Develop application for Human Resources Technology Group for Retirement Benefits.

The project required integrating HR Benefits application with 401K plan. The project required application of Client-Server technology on a highly portable client technology. The solution was developed using Uniface, Pro-C & Oracle. This was a 20-man year project involving strong project coordination.

Wipro Infotech & Polaris, Senior Engineer                                                                         1989 – 1992

Worked in International Operation Division, with design and development of Preventive Maintenance System for a France based Company. This was a product sold to many small manufacturing units. It also involved evaluation of CASE tools like FLOW, Views++/C++, 4GL-Windows on Ingres, MS-Windows, and Oracle, Sybase, Ingress.

At Nucleus/Polaris, main line business was in providing Banking application solutions to large bank such as Citibank India, Saudi American Bank Riyadh.

I worked on Generalized Installment Loan System. The product was designed to have flexible usage across different types of loan system. Developed in SQL-Forms , Oracle on PC-ATs and Novel LAN.

Vehicle Loan Booking De-Centralization was an improvised way to do booking of loans at point of sale and the data porting to the main system at End of Day. The development tools used were Cobol-II & ABP.

EDUCATION       M.Sc. (Tech.) Computer Science                                                               1985 -1989

                        Birla Institute of Technology and Sciences, India

RECOGNITION   Part of the team that won coveted “Product of the year” award in for best

& AWARDS        Computer Telephony Integration (1998) http://www.tmcnet.com/articles/ctimag/0199/ctipoty98.htm

                           Northern Telecom Honor Circle award (1997)

                           Information Week featured an article by HIP CTO on this application (2004)
http://www.informationweek.com/story/showArticle.jhtml?articleID=21700225

                                    Medals for scoring highest marks in Math & Chemistry in High School at State level (1989)

                           President for Home Owner’s Association (2005 – 2006)