Romin Joseph
Verified Expert in Engineering
Software Developer
Romin is a developer with deep expertise in the function, features, and applicability of complex legacy software products in the healthcare and oil industries. He has 17 years of global experience, including in regulated environments like GE Healthcare. He writes high-quality, well-tested, and maintainable code using the Microsoft technology stack, primarily .NET and SQL Server. Romin delivers and advocates for technical excellence everywhere he works.
Portfolio
Experience
Availability
Preferred Environment
C#, Microsoft SQL Server, Visual Studio, .NET, SQL, Windows, Databases, Python 3, Microsoft Power BI
The most amazing...
...thing I've done is a Python-based business process automation tool to extract data from Excel files, clean, transform, and create structured Word/PDF documents.
Work Experience
Power BI Expert
Energy Management Company in UK
- Created parameters to enter a SharePoint folder and Excel filename so that source data could be selected to create dynamic reports.
- Fixed the issues in the queries and removed errors in Excel source files by analyzing current ingestion processes, which enabled faster reports.
- Built data models and created data filters for analyzing datasets. Wrote DAX queries and made new reports for monthly data, converting raw data to meaningful insights.
Python Developer
D2 Legal Technology
- Developed a Python-based business process automation tool to extract data from a series of Excel files, transform them, and generate a structured Word document. Used Pandas to analyze, clean, and manipulate data (20+ Excel files to a Word document).
- Used Python libraries to automate table of contents updating and Word to PDF conversion, reducing tedious manual labor and improving accuracy, speed, and consistency. This resulted in a total turnaround time of five minutes.
- Used the Tkinter Python GUI library and designed and developed a basic user interface to add version history to the generated documents and keep the audit trail of the documents.
- Created internal hyperlinks for a table of codes and related bookmarks for detailed description sections so that the user can click and go to the location in the document.
- Authored a detailed user guide for the end user to run the application with minimal training.
Software Developer
Derivative Path, Inc.
- Categorized performance issues - caching, slowest URLs, and 500 errors -conducting a thorough analysis of log files such as IIS, HTTP errors, applications, and events, using LogParser.
- Utilized advanced tools like WinDbg and Debug Diagnostics to analyze crash dump files for a deeper understanding of performance issues and to identify the root causes.
- Identified IIS settings to be rectified for performance improvement and recommended code snippet for more robust error logging.
- Recommended performance counters for monitoring and load testing of the application.
SQL Developer | SQL Trainer
Carmen Diep
- Taught the client according to her skills and pace, diving deep into advanced SQL topics such as indexing, joins, and query optimization.
- Explained ER diagrams, database modeling, and normalization concepts in detail. Walked through CRUD operations by introducing stored procedures, T-SQL coding practices, and functions.
- Solved complex data science-oriented queries using aggregate functions, common table expressions, views, and temp tables. Imported CSV flat files and created single-file script-based databases from the model database.
Full-stack Developer
SAPA SpA
- Prepared data models and ER diagrams for the database design logically and efficiently using different data sources and Excel spreadsheets.
- Designed SQL schema, including tables, views, and procedures in Microsoft SQL Server to store manufacturing data.
- Designed and created a simple web application using PHP, HTML, JavaScript, and Bootstrap to create and modify manufacturing components and work orders.
- Wrote SSIS packages using C# to efficiently import massive data from various ERP systems and store them in a common SQL Server database.
Senior Engineering Lead
Nuchange Informatics, Bangalore
- Implemented SonarQube and SonarLint quality gates for clean and safe code. Analyzed the projects and fixed many potential bugs and vulnerabilities.
- Developed PostgreSQL scripts to fast-track testing of different clinical configurations.
- Executed load testing using Apache JMeter and JSON files with random values and CSV files.
- Created user stories and Kanban cards for smooth project execution.
Senior Technology Analyst
Infosys, Bangalore
- Developed technical roadmaps for projects, ensuring all components were aligned with business objectives.
- Collaborated with other architects, engineers, and stakeholders to ensure the successful implementation of new technologies. Participated in code reviews and provided feedback to developers.
- Provided guidance on best practices and standards for software engineering, system design, and application development and researched emerging technologies and trends to stay ahead of industry developments.
Senior Software Developer
Pearl Global Solutions, Cochin, India
- Performed query optimization of the data model to predict likely destinations, trajectories, stop locations, speeding, and braking events at different times and days of the week for individual drivers.
- Optimized PostgreSQL database functions and indices to load data into a dashboard and won customer confidence by running essential SQL procedures in under 20 seconds.
- Increased client satisfaction in safekeeping the driver and re-routing the fleet to avoid traffic. Achieved fuel efficiency and optimized resources and maintenance based on usage patterns, thereby adding value to the business while making profits.
Senior Database Developer
Al Nab'a Holding LLC, Oman
- Archived close to 25 million business-critical database records: wrote procedures, views, and SQL jobs for a seamless archiving process and ensured the availability of archived records for reporting.
- Optimized, over five months, more than 50 SQL procedures via code modifications and performance indexing, which reduced the execution time of critical SQL jobs, such as payroll processing and the month-end account close, by up to 90%.
- Developed SSRS and Power BI reports, including drill-through reports and sub-reports (journal vouchers, P&L sheets, etc.) for the consumption of various departments.
- Wrote SQL procedures and views for crucial business data to be used in reporting.
- Implemented transaction log shipping for faster report generation and transaction load optimization.
- Strategized and configured the backup and restore automation.
Senior Software Developer
Greenergy Fuels Pvt Ltd, UK
- Designed and developed core business services using C#, WCF, web services, XML, and T-SQL for a high level of asynchronous communication with a logistics system, supporting the enterprise data warehouse system and downstream applications.
- Provided production support for existing applications. Owned the support process, documentation, and implementation, creating a knowledge base and training.
- Debugged and optimized legacy SQL-stored procedures and Microsoft Access front-end applications as part of support and maintenance, significantly reducing the support workload.
- Built a SQL-based alert application with a single-page UI, using C# for internal IT teams and reducing alert support requests.
- Developed Excel macros and VBA to email daily job schedules to drivers and site leaders, automating the daily communication processes.
- Managed five developers in support and development activities, prioritizing tasks and ensuring deliverables with an excellent entrepreneurial mindset. Won team members' respect by organizing and motivating the team.
- Designed a solution to monitor daily prices of oil and exchange rates from various sources and to alert if the prices are stale - using C# routines and T-SQL procedures, reduced support tickets, and avoided routine manual verification.
Lead Program Integrator
GE Healthcare, Bangalore
- Led the engineering and product development core teams to design a global ultrasound product.
- Developed the maintenance software releases that met FDA requirements and allowed the radiology engineering team to address customer complaints and product safety and avoid product recalls.
- Served as a global project leader to manage and deliver cardiology software maintenance programs. Drove cross-functional execution to meet milestones and program targets.
- Implemented the hardware obsolescence projects without a production gap for a critical customer go-live by developing integrated program plans that delivered business commitments.
- Worked on the customer complaints, performed root cause investigation, did CAPAs, and FMEA, and met HL7, DICOM, and IHE healthcare standards.
Personal Banker
HDFC Bank, India
- Managed the critical customer needs through cross-selling of all products and services–primarily accounts and investments, ULIP, and MF product portfolio.
- Helped the customer complete the documentation and application formalities and promoted new-age banking services for a superior customer service experience.
- Advised the customer of the various benefits of the products offered, cross-sell, and achieved the set productivity norms.
Senior Systems Analyst
Sonata Software Ltd, Bangalore
- Conducted testing for performance and functional quality assurance of Centura Team Developer, an IDE tool to develop applications and connect with ODBC.
- Analyzed the requirement specifications, executed manual and automated testing, and prepared test plans.
- Executed functional, compatibility, and regression tests by writing applications in Centura and Microsoft Visual C++.
Software Engineer
AEB Software Systems, Cochin, India
- Designed the user interface, developed benchmark graphical algorithms, and coded graphics modules for Profi-graphics—a customized 2D graphical laying software tool for a DIY paneling solution using Java, Visual C++, and MFC.
- Seamlessly integrated a Visual Basic COM component into a Visual C++ project to be used for invoicing.
- Built GUI modules and shared libraries using Centura (Gupta) Team Developer for Elan, an ERP solution.
- Developed and designed a module to add the euro column in a legacy invoicing application running on Windows CE, programmed in C.
- Developed a full-fledged music/film website for a leading movie production house, including extensive search options, sample music in RealPlayer format, and chat rooms using classic ASP, HTML/JavaScript, and MS Access database.
Experience
Taxonomy PDF Generator
Greenergy Logistics System
ROLE AND KEY ACTIVITIES
• Worked with a business analyst to understand the business processes, gather and document project requirements, and translate them into functional and non-functional specifications.
• Developed WCF web services and T-SQL procedures to fetch data from the third-party logistics software and make it available in an SQL Server-based schema for consumption by downstream applications and data warehousing.
• Developed diligent alert mechanisms using Windows services to maintain data integrity.
• Designed and developed SSRS reports based on user needs; for example, a daily report to proactively confirm the availability of customer contracts.
• Implemented effective logging, trained the support team, and authored a detailed troubleshooting guide to ensure technical support during out-of-office hours.
GE Healthcare | Cardiology
ROLE
• Managed changes in priorities, formulated and executed strategies to resolve customer complaints, and deployed software releases on time.
• Consistently provided full transparency to management on the installed base landscape, which resulted in a significant reduction in complaints.
• Developed integrated program plans to meet business commitments.
• Communicated project status and timelines to upper management and the global core team for all the software maintenance releases.
GE Healthcare | Radiology
ROLE
• Delivered the maintenance releases for these products to address customer complaints and software issues through coordinated efforts with cross-functional teams and on-time program execution.
• Developed maintenance design change plans and formal design reviews to ensure the projects were delivered with quality and met FDA-stipulated regulatory requirements.
AEB Profi Graphics
ROLE
• Designed and developed a 2D graphical laying software tool.
• Designed a GUI for freehand drawing of basic geometrical shapes and coding graphics modules.
• Developed algorithms and coded complex 2D geometric operations.
Skills
Languages
C#.NET, SQL, T-SQL (Transact-SQL), C++, Excel VBA, C#, C, Stored Procedure, Visual Basic for Applications (VBA), PHP, Python, SQL DML, Visual Basic, Python 3, VB.NET, VB, VBScript, Web Services Description Language (WSDL), XML, HTML, JavaScript, Active Server Pages (ASP), HTML5, Visual Basic .NET (VB.NET), Visual Basic 6 (VB6), CSS, Java, Java 8, XSL, XSLT, Power Query M
Frameworks
.NET, ASP.NET, Windows Presentation Foundation (WPF), .NET Core, VB.NET WinForms, Windows PowerShell, Hibernate, Bootstrap, Classic ASP, Qt
Tools
Microsoft Visual C++, Visual Studio, Microsoft Report Builder, Microsoft Access, Excel 2013, Excel 2016, Microsoft Excel, C#.NET WinForms, Microsoft Power BI, Microsoft Visual Studio, Excel 2010, SQL Server BI, Visual Studio .NET, TFS, SoapUI, Altova XML, GitHub, Microsoft Word, Google Sheets, Microsoft PowerPoint, Dapper, Microsoft Power Apps, Visual Studio Tools for Office (VSTO), Open Office, Visual SourceSafe, Microsoft Project, CAD, IBM Rational ClearCase, Git, pgAdmin, SonarQube, Apache JMeter, GitLab, WinDbg, Power Pivot, Power Query, CMake, Crystal Reports, Microsoft Dynamics CRM, Microsoft Dynamics
Paradigms
Testing, Database Design, ETL, Manual Testing, Automation, Business Intelligence (BI), Object-oriented Programming (OOP), Data-driven Design, Application Architecture, OLAP, Requirements Analysis, Database Development, Design Verification Testing, HIPAA Compliance, DevOps, Continuous Delivery (CD), Continuous Integration (CI), Dimensional Modeling, Fast Healthcare Interoperability Resources (FHIR)
Platforms
Windows, Windows Server, Ubuntu, Windows Server 2016, SharePoint, Visual Studio Code (VS Code), Microsoft Power Automate, SharePoint 2016, Windows CE, Linux, Amazon Web Services (AWS), Docker, SharePoint 365
Storage
SQL Server Reporting Services (SSRS), SQL Stored Procedures, SQL Server Integration Services (SSIS), Microsoft SQL Server, SQL Server 2014, Database Modeling, Database Architecture, SQL Server 2012, Databases, Relational Databases, Database Performance, SQL Architecture, SQL Views, DB, ANSI SQL, SQL Server Agent, RDBMS, SQL Performance, SQL Server 2016, SQL Server 2008, Data Integration, Web Forms, SQLite, Database Structure, Database Transactions, OLTP, Master Data Management (MDM), MySQL, SQL Server DBA, Database Migration, PostgreSQL, IIS SQL Server, Database Administration (DBA), Data Pipelines, Microsoft DBA, JSON, Database Backups, DBeaver
Industry Expertise
Project Management, Healthcare, Banking & Finance, Trading Systems
Other
WCF Web Services, Debugging, Requirements & Specifications, Level 3 Support, Algorithms, IIS, Validation, Analytical Thinking, Medical Devices, Windows Services, Data, Remote Work, Data Migration, Data Modeling, SOAP, Documentation, SQL Server 2015, SQL Server 2019, Finance Reports, Reporting, CSV File Processing, Excel Expert, CSV, Data Handling, Reports, Medical Software, Architecture, Database Optimization, Excel Macros, Data Architecture, Query Optimization, OOP Designs, Data Queries, Relational Database Design, Database Schema Design, APIs, Operations, Data Engineering, Performance Tuning, Communication, Data Visualization, Data Warehousing, Manual QA, Data Management, Scripting, Leadership, Excel 365, Data Wrangling, Normalization, Dashboards, Automation Scripting, Microsoft Stack, Data Analytics, Mathematics, C# Operators, Software Development, Data Structures, Optimization, Legacy Software, Electronic Data Interchange (EDI), API Integration, IT Automation, Data Cleaning, Transactions, Software Design, BI Reporting, CSV Export, Relational Data Mapping, Macros, Data Warehouse Design, Microsoft 365, Oil & Gas, Project Leadership, 2D Graphics, Team Mentoring, Product Support, Master Data, Geometry, Writing & Editing, Regulatory Compliance, Indexing, SSRS Reports, Data & Backup Management, Finance, Technical Writing, HTTP REST, Training, K-12 Education, ETL Tools, Full-stack, Solution Architecture, Test Documentation, Software QA, Test Planning, QA Test Plan Management, QA Leadership, Software, Data Transformation, Quality Assurance (QA), Data Extraction, Full-stack Development, Scripting Languages, Internet Information Services (IIS), Data Aggregation, CLR, Data Manipulation, DAX, Data Analysis, Excel Reporting, ETL Development, Statistics, Report Development, Web Development, Technical Leadership, Admin Panels, Back-end, Technical Documentation, Trading, Scalability, .NET 6, Electronic Medical Records (EMR), Electronic Health Records (EHR), EMR, Task Automation, Data Processing, Data Processing Automation, Excel Add-ins, Scheduling, Version Control, Invoicing, Office 365, HL7, DICOM, Civil Engineering, Medical Imaging, Work Breakdown Structure, Regulatory Reporting, Information Technology, Log Shipping, Private Banking, Manufacturing, CI/CD Pipelines, Schemas, Entity Relationships, Health Insurance, Mutual Funds, Cloud Architecture, IIS 10, Stock Trading, PDF, Site Reliability Engineering (SRE), Site Reliability, Development, Forex, Robotic Process Automation (RPA), Visualization, Tkinter
Libraries/APIs
Microsoft Foundation Class (MFC) Library, Windows Forms (WinForms), ODBC, Pandas, Microsoft Foundation Classes (MFC), jQuery
Education
Bachelor's Degree in Information Technology
Cochin University of Science and Technology - Cochin, India
Certifications
Microsoft PowerApps Crash Course – From UI to Integration
Udemy
Learn Python Programming Masterclass
Udemy
Automate the Boring Stuff with Python Programming
Udemy
Microsoft Power BI Desktop for Business Intelligence
Udemy
DevOps, CI/CD(Continuous Integration/Delivery) for Beginners
Udemy
Certified C Programmer
Brainbench
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring