Sign in

Technical Support Software

Powell, Ohio, 43065, United States
February 12, 2018

Contact this candidate

Santanu Lahiri

Powell, OH *****

I have 15 years of experience as a CTO in a small company and commensurate expertise in the technical aspects of the position as well as developing client relations. I also have extensive experience in software development. I am accomplished in analyzing and finding resolution to clients’ technical challenges resulting in a more efficient and effective business function. I possess a demonstrated career success in developing and implementing strategies that promote growth and optimal utilization of emerging technologies. Professional Experience

July 2015 – July 2017

Battelle Memorial Institute, Columbus, OH, Contract Programmer

.Net software development. Subject was Electric Resistance Weld defect analysis to be utilized in pipe fracture analysis for large diameter high pressure gas or liquid pipes. The goal was to create software capable of forecasting usable lifetime of pipes under varying pressure loads, given specific defect characteristics. Software has a multi-threaded simulation component using multiple statistical distributions for analyzing possible failure scenarios. The software was awarded the R&D 100 Awards for 2017 for excellence in the software category. Created a distributed version of the above simulation software as a proof of concept for long-running simulations using socket communications.

Also created front end GUI software to feed data into simulation software for analyzing defects in nuclear reactor pipes. July 2015 – February 2017

Retail Management Products DBA RxScan, Lewis Center, OH, Consultant

*Currently serving as a Consultant on a part-time basis developing additional software, bug fixes and documentation for existing software. August 2000 –July 2015

Retail Management Products DBA RxScan, Lewis Center, OH, Chief Technology Officer Responsibilities

• Performing the designing and development of an SAAS environment in support of back-office processing and a comprehensive reporting suite as an online perpetual inventory solution for a client.

• Using Mirth Connect to create data channels between different sites for near-real time transfer of usage of pharmaceuticals for said SAAS application.

• Plan and execute virtualization of existing servers using VMWare ESXI Server Software Platform.

• Developed and maintain comprehensive Business Process Infrastructures on a web-based model for all business functions except accounting.

• Strategize and deliver web-based protocols and processes that improve the efficiency and effectiveness of the client’s business functions.

• Compose user friendly manuals for clients regarding the RxScan software resulting in improved training of the user base and corresponding reduction in technical support calls.

• Managed the RxScan Prescription Drug Information database with derivatives of the Drug database used by clients to perform prescription verification, filling automated dispensing machines, etc.

• Work in concert with external software firms to define specifications for web-based drug sample inventories and electronic medical records applications.

• Collaborate with clients and first and second level client technical support to provide training and support as necessary.

• Provided software training to clients on an as–needed basis.

• Utilize Server Virtualization by employing VMWare and XenServer, 2012 – 2015. Accomplishments and Selected Highlights

• Architected a system that retrieves the client’s drug dispense data from multiple client networks and transmits the data to a remote server that processes and merges data into a perpetual inventory database for display in near real-time.

• Developed prescription verification and inventory software for Windows and embedded platforms resulting in those products driving the majority of sales revenue for much of my tenure as RxScan.

• Designed applications for easier import of drug information from the FDA drug database, editing and merging data into the RxScan Drug Database using both web-based and client-server formats.

• Created a drug label printing application for hospital pharmacies for easier designing of labels using 1D and 2D barcodes. Enabled the use of custom scripting for more complex interactions of data printed on the labels. The application is one of the primary offerings of RxScan and driving sales of other products.

• Produced an in-house web-based technical support application for client interactions.

• Developed sales strategies recovering hardware investments of approximately $60K over six months.

• Devised applications that allow clients to edit drug information in their copy on the drug database and designed protocols for collision avoidance between the master database data and client copies. April 1990 – July 2000

Center for Human Resource Research, Ohio State University, Columbus, OH Senior Programmer Analyst, June 1995 – July 2000

Created data retrieval software for retrieving data from the National Longitudinal Survey (NLS) databases and reduced data retrieval time from 16+ hours to less than two hours. Created a mechanism for distributed processing of data collected by the NLS Youth Cohort (NLSY) data reducing the turnaround time from up to six months to less than two weeks. Responsibilities included writing a code generator to automate generation of SAS and SPSS scripts to read and analyze data and generate some basic reports based on user selection of data sets and variables. Programmer Analyst, April 1990 to June 1995

Developed Computer Assisted Interview software for data collection with an average interview containing over 350 active data items and resulting in over 4000 variables. Reduced interview error rates to less than two per interview from a rate of 15 or more. Interview produced approximately 4000 data points for over 9000 subjects each. Eliminated costs associated with producing paper questionnaire and expensive data verification and protocols.

Additional Professional Experience

Bureau of Economic and Business Research, University of Florida, Gainesville, Florida, Research Assistant Faculty Support Center, University of Florida, Gainesville, Florida, Support Consultant Education

Ohio State University, Columbus, Ohio, Master’s Degree in Computer and Information Sciences University of Florida, Gainesville, Florida, Master’s Degree in Business Administration Bengal Engineering College, Shibpur, West Bengal, India, Bachelor of Engineering in Civil Engineering Technical Skills

Operating Systems: Windows 95/98/NT/2000/XP/7/W10, Windows Server 2003/2008/2012 Hypervisors: Basic familiarity with VMWare ESXi, Citrix XenServer Programming Languages: VB.Net, C#, C, C++, VB, JavaScript, Java, SQL, PHP, ASP, VBScript, Pascal, R, FORTRAN, X86 Assembly Frameworks/Libraries: ReactJS, JQuery, .Net, Java Swing, MFC, Some experience with Node.JS and AngularJS. Databases: MySQL/MariaDB, Microsoft Access, Oracle Other: TCP/IP, HTML, CSS, Git XML, SAS, SPSS, PL/SQL, HL7, MirthConnect, BIRT, Jasper Reports, Drug Barcodes with 1D & 2D Symbologies, Project Management (MPM).

Volunteer Accomplishment

First Lego League Robotics Challenge. Created in July 2014 and served as Main Coach for a Robotics Club (Powell Robotics) where children ranging from 9 to 12 years old use Lego Robot kits to build robots and discover basic engineering challenges. In 2014, with help from the children’s parents we fielded a team in the First Lego League Robotics Challenge (FLL) which consisted of a Robotics Presentation, Project Presentation, and a Core Values Presentation and won 5th place out of 16 teams in the November 2014 regional championship. In addition there were three robot games where the robot is expected to autonomously solve a series of challenges and in this competition our team took 6th place. Worked with team members, helping them learn basic C programming. The team also competed in 2015 and won an award for outstanding research on recycling done by the team members without adult intervention. In 2016, the team won an award for their core values presentation. Affiliations

Woodworkers of Central Ohio, Columbus, OH, 1990 - 2014

• Developed an administrative website used for maintaining the club member roster, club library and automated mailouts of the club newsletters and other postings by club members.

Travel Agent Survey, 1997-2010

• Took over maintenance of a paper document

• Converted a static international travel agent survey document into a dynamic website application with full-text search capability.

Contact this candidate