Summary
Overview
Work History
Education
Skills
Timeline
SoftwareEngineer

Sergey Medjitov

South Orange,New Jersey

Summary

Software engineer with 15+ years of expertise in designing, developing, and maintaining 20+ cloud-based, web-based, and client-server solutions. Proven track record of leading projects from inception to completion. Collaborate closely with clients to customize software products and provide on-site support. Continually stay at the forefront of emerging technologies and diverse business sectors, consistently adapting to the evolving industry landscape.

Overview

23
23
years of professional experience

Work History

Software Engineer

Kyowa Kirin/3C Company
04.2024 - Current
  • Designed and developed 2 Azure data flows and 15 SQL procedures to automate manual processes of ETL heterogeneous data from multiple organizations and sources into Azure SQL Database with real-time data integrity checks. Output data was formatted for the Planisware platform and Power BI Reports. Identified and solved limited cross-database transactions issue.

Software Engineer

Summit Clinical Research
11.2022 - 05.2024
  • Architected and produced an Azure RESTful Web API Library of 47 functions to bring data from cloud-based front-end Budget application to Azure database
  • Collaborated on front-end development, administrator functionality (.Net Core, C#, Ajax, JSON) and wrote 3 Azure logic apps to send emails, create data for Power BI Reports, and manage Key Vault.

Software Engineer

Merck
09.2016 - 09.2022
  • Rewrote a legacy application from classic VB into a VS .Net C# application, boosting app performance by ~30% and enhancing the functionality.
  • Built a Resources screen (C#, MS Access) that allowed optimizing and forecasting workload management and project allocation for the group of 30+ managers
  • The functionality makes predictions for the next 3 months.
  • Automated inter-table data analysis of multiple Excel files (Excel VBA macro) to improve decision-making in management and cut down manual work by 90%.

Software Engineer

WriteResult
02.2010 - 09.2016
  • For global (over 30 countries and 20K+ data points daily from 400+ devices) EDC system using digital pen/OCR technology and iPad devices designed and coded a Transact-SQL database and 7 Windows services to parse real-time XML and PDF files from various devices and web forms.
  • Developed and maintained various ASP.NET web services and Transact-SQL stored procedures to generate Excel reports for edit checks, quality assurance, etc., achieving an error rate of less than 0.5% (1 error in 200 data points).
  • Proposed and implemented an idea to make an Android mobile device app in Java to show real-time report status dashboards off the office, reducing time spent on reports support by 80%.

Senior Software Engineer

Novartis Pharmaceuticals
08.2004 - 02.2010
  • Designed and implemented an n-tier global OLAP application to track Clinical Trials data, resulting in the generation of over 40 unique Performance Metrics that enhanced data-driven decision-making across multiple departments:
  • Data tier: Coordinated with the group of 6 developers to produce Data Model and Operational Data Store, ETL procedures, and star schema, ensuring optimal ETL performance for globally distributed 100+ users with time zone constraints.
  • Middle tier: As personally responsible for that tier, designed and developed over 50 business objects created within Cognos Framework Manager, data-driven framework objects dynamically generated in NetBeans Windows application, and Java objects created in a WebLogic application for the interface to the database.
  • Presentation tier: Led a team of 5 developers on a demanding delivery schedule for Cognos web portal development, including web portlets, reports, and cubes.
  • Worked in close cooperation with business users and analysts on technical requirements Resources Allocation Java web application for 100+ users and Pronto Metrics dashboard portlet displaying 9 Clinical Metrics to process multi-source clinical, financial, and administrative data, producing reports in HTML, PDF, Excel, and Cognos formats.

Software Engineer

Schering-Plough
08.2001 - 08.2004
  • Modernized legacy VB 6 application by embedding of newly built web .NET application (Clinical Trials KPI) and web components to avoid rewriting expenses of $30K+.
  • Integrated customized web .NET components managing up-to-date products list and generating online ads flyers with a client-server Online Warehouse Clarion-coded application
  • This functionality reduces publishing expenses by $12K a year.

Education

Skills

  • Cloud computing
  • Web/Server/Client/Database design and development
  • Team Collaboration
  • Cloud platform and IDE: Azure, Visual StudioNET, Net Core, Net Framework, MS SQL Server Studio
  • Programming and scripting: C#, Java, Transact-SQL, PL/SQL, HTML/CSS/XML, JavaScript, Ajax, JSON, Python, shell scripts
  • DBMS: MS SQL Server, Oracle, MS Access
  • BI: Microsoft Power BI
  • Developer platforms: DevOps, GitHub

Timeline

Software Engineer

Kyowa Kirin/3C Company
04.2024 - Current

Software Engineer

Summit Clinical Research
11.2022 - 05.2024

Software Engineer

Merck
09.2016 - 09.2022

Software Engineer

WriteResult
02.2010 - 09.2016

Senior Software Engineer

Novartis Pharmaceuticals
08.2004 - 02.2010

Software Engineer

Schering-Plough
08.2001 - 08.2004
Sergey Medjitov