Solomon Matisoff
Lower Gwynedd, PA 19002
ad19jd@r.postjobfree.com
Results-oriented Programmer with 15+ years of experience. Skilled in developing and implementing innovative software solutions to address complex business challenges. Proven expertise in evaluating and utilizing user requirements, designing efficient coding and data structures, and seamlessly integrating applications to optimize organizational efficiency. Demonstrated ability to collaborate with cross-functional teams, translating user needs into technical solutions. Committed to staying abreast of industry trends and best practices to drive continuous improvement in the software development processes.
WORK EXPERIENCE
Senior Programmer Analyst
Anju Software
November 2018 – November 2023
Engineer and upgrade web-based clinical trials management application for the pharmaceutical industry, maintain, and support upgrades using VB.NET, JavaScript and T-SQL, and train others in the installation of both new product and hot-fixes on client's servers, keeping client's servers up-to-date and running smoothly
Design and implement VB.NET code and Microsoft SQL stored procedures and triggers to implement specific business logic requirements, leveraging comprehensive programming skills to develop efficient and effective solutions, enhancing system functionality and contributing to project success and client productivity
Create and update tools in VB.NET, C#, Microsoft SQL, and Excel to reduce redundant tasks, and speed time-intensive processes
Senior ETL Developer
IQVIA
September 2016 – October 2018
Engineer data migration code for 6 distinct projects for pharmaceutical financial reporting, transforming and importing data from diverse flat file formats, including CSV and fixed formats, into SQL databases, ensuring seamless integration and accessibility
Design and implement C# business logic tailored to meet specific requirements, leveraging comprehensive programming skills to develop efficient and effective solutions, enhancing system functionality and contributing to project success
Senior TM1 Consultant
Data Clarity Corporation
September 2015 – May 2016
Design and develop TM1 solutions to support a wide range of business's financial and reporting applications, enhancing system functionality and speed
Perform data cleansing and migration from flat files and ADO connections into TM1 and T-SQL databases, utilizing my knowledge of VBA, macro coding and file formats, to ensure the complete and direct transfer of data from system to system
Solutions Architect
Breakaway Technologies, Inc.
May 2010 – July 2015
Design and engineer financial reporting and forecasting software to meet client requirements using TM1 and SQL Server systems, expanding my knowledge base while developing efficient and effective solutions
Create and validate ETL imports of data from CSV, Excel, TM1 and SQL Server databases, ensuring clean, quick, and smooth importation and sharing of data across multiple systems
Evaluate internal pain-points and engineer internal tools, saving hundreds of hours of developer time
Lead Programmer
AllianceTek
May 2009 – May 2010
Program and modify VB.NET code and SQL Server databases to update pharmaceutical and insurance data ETL and reporting by leveraging my coding experience in a highly object oriented application
Analyze requirements, design relational databases, and manage off-shore programmers to create software using C#, ASP.NET and SQL Server, resulting in an on-time product delivery
Additional Work Experience
Technical Projects Manager
Acurian, Inc.
Write and tune queries in Oracle dealing with very large databases for clinical trial management and subject outreach, using my knowledge of data warehouses, speeding up the return of complex data sets
Designed and developed tools in C#, VB.NET and VBA, reducing the complexity and time required for day-to-day upkeep and reporting
Project Manager and Program Systems Analyst
Thomson Elite LawManager
Managed a team of 10 through the full life-cycle of multiple products in law project management and billing, leveraging my experience in project design and client expectations management to reduce scope creep and increase reliability by 70%
Senior Programmer and Manager of the Software & Technology Division
Asta Engineering, Inc. / Key Education, Inc.
Lead and mentor a team of 6 employees to develop a vocational assessment software system, using my experience to design databases, interfaces, and APIs, delivering 3 versions on time and on budget
Software Developer II
Vertex Inc.
Responsible for bringing existing code-bases from outdated styles to current best practice, contributing to product stability
Writing functional and technical specifications and then implementing them using best practices
Systems Analyst
MSS Software
Developed off-the-shelf software to meet specifications, developing a clean and well documented coding style, developing intuitive interfaces for a non-technically savvy client base
Education
Bachelor of Science in Computer Engineering, Lehigh University
Core Competencies
Software Development, Microsoft Visual Basic.NET, C#, JavaScript, Relational Database Design, SQL Server, OLAP Database Design, TM1, Excel and Word VBA