Avraham Lichaa

Avraham Lichaa

SQL and powerbuilder programming
Reply rate:
-
Availability:
Full-time (40 hrs/wk)
Location:
Los Angeles, Ca, United States
Experience:
20 years
About

I am a highly experienced Senior Developer with a proven track record of success in database management, application development, and system optimization. My career spans over two decades, with a strong focus on utilizing core technologies like SQL, PowerBuilder, MSSQL, SQL Server, SSMS, Sybase, and PostgreSQL to deliver impactful solutions for renowned companies in entertainment, finance, and healthcare.

My deep expertise in these technologies has enabled me to consistently drive significant improvements in operational efficiency and productivity. In my recent role at Quality Acceptance, I revamped overnight SQL jobs using T-SQL, Stored Procedures, SQL Server Agent, and SSMS, cutting processing time in half and significantly boosting operational efficiency. I also streamlined critical data exports to third-party vendors by developing queries, stored procedures, and automating processes with T-SQL, SQL Server Agent, and SSMS, resulting in accelerated customer payments and enhanced cash flow.

At Benevis, I leveraged my PowerBuilder and SQL Server skills to develop a multi-patient document printing feature, saving 100 hours daily across 200 dental offices and streamlining workflows for 6,000 patients. I also engineered a Payment Import module using T-SQL, Stored Procedures, and SSMS, accelerating payment processing and reducing manual administrative overhead by approximately 50%.

My experience at Fox Networks Group further demonstrates my proficiency in these core technologies. I engineered the technical separation of application data between Fox and Disney, employing PowerBuilder and SQL to ensure compliance with Department of Justice regulations. Earlier in my career at Fox, I designed and implemented an interface using TIBCO, Sybase, and PowerBuilder to automate promo placement in cable logs. I also provided best-in-class support for critical applications related to program scheduling, advertisement scheduling, and sales systems.

At Walt Disney Studios, I strengthened and maintained the RERUN application using T-SQL, stored procedures, and functions in MS SQL Server, enabling prompt and accurate payment to talent. And at Warner Bros. Entertainment, I fully administered the Sybase database used for their Sales Traffic and Billing System, migrating it from a legacy HP system to AIX LPAR. I successfully tuned Sybase to enable multiple users to run complex reports simultaneously and implemented a disaster recovery procedure.

My educational background includes a BS in Computer Science and Applied Mathematics with a Minor in Business Administration from the State University of New York at Albany. This foundation, coupled with my extensive hands-on experience, makes me a highly proficient and results-oriented Senior Developer.

I am passionate about using my SQL, PowerBuilder, and database expertise to solve complex challenges and drive business growth. I am a proactive and detail-oriented individual with a strong commitment to excellence, making me a valuable asset to any team.

Languages
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.