Post Job Free

Resume

Sign in

SQL T-SQL TM1/OLAP Developer Vb .Net C#

Location:
William Penn Annex West, PA, 19107
Salary:
110000
Posted:
December 27, 2023

Contact this candidate

Resume:

Solomon Matisoff

**** ****** ***** ****

Lower Gwynedd, PA 19002

484-***-****

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



Contact this candidate