Avraham Lichaa-| - |Los Angeles, CA | LinkedIn: Avraham Lichaa's LinkedIn Profile
Technical Skills
Proficient: SQL, PowerBuilder, MSSQL, SQL Server, SSMS, Sybase, PostgreSQL
Exposure: Python, C#, Azure Cosmos DB Azure, Azure Serverless Functions, UiPath, Java, C++, C
Professional Experience
Quality Acceptance Los Angeles, CA
SENIOR DEVELOPER2023 - Present
Revamped overnight SQL jobs, employing T-SQL, Stored Procedures, SQL Server Agent, and SSMS, reducing process time from 14 to 7 hours and improving operational efficiency.
Streamlined critical data exports to third-party vendors by developing queries, stored procedures, and automating processes with T-SQL, SQL Server Agent, WinSCP, and SSMS, accelerating customer payments and enhancing cash flow.
Developed new Forced Insurance report using T-SQL, Stored Procedures, SSMS, and PowerBuilder, providing enhanced business analytics for decision-making.
BenevisAtlanta, GA
SENIOR DEVELOPER-
Developed multi-patient document printing feature using T-SQL, Stored Procedures, SSMS, and PowerBuilder, saving 100 hours daily across 200 dental offices and streamlining workflows for 6,000 patients.
Engineered Payment Import module using T-SQL, Stored Procedures, SSMS, and PowerBuilder, accelerating payment processing and reducing manual administrative overhead ~ saving time by 50%.
Integrated Genesys Call Center into existing DetaPro EHR using T-SQL, Stored Procedures, SSMS, and PowerBuilder, enhancing data collection and improving business analytics.
thethingmarket.comLos Angeles, CA
SENIOR DEVELOPER-
Integrated ThingMarket with Stripe subscription, developed automated transactional emails using Python and SendGrid templates, streamlining customer communication and enhancing user experience.
Optimized SEO for JavaScript-heavy website elements by employing Pyppeteer to render HTML snapshots, increasing search engine visibility and site traffic by 60%.
Engineered scalable serverless backend solution on Azure Serverless Functions, using Python and Cosmos DB, supporting ThingMarket and Stripe integration, resulting in increased sales transactions.
Disney Media & EntertainmentMarina del Rey, CA
STAFF DATABASE ENGINEER2019 - 2021
Developed report automation using UIPath, saving over 2,100 man-hours annually by streamlining the generation and storage of data for 26,000 reports.
Orchestrated rapid resolution of bugs within proprietary logging system, navigating complex web of store procedures (26K+ lines), debugging PowerBuilder code, and securing timely broadcasts to protect $10 million in daily ad revenue.
Fox Networks GroupMarina del Rey, CA
SENIOR PROGRAMMER ANALYST2017 - 2019
Engineered technical separation of application data between Fox and Disney, employing PowerBuilder and SQL, ensuring company's compliance with Department of Justice regulations and protecting it from potential legal and financial risks.
Directed and guided team of 6 developers, overseeing flag creation and database modifications, ensuring successful and timely completion of data segregation project.
Provided hands-on coding, development, and troubleshooting support alongside team members, accelerating resolution of technical challenges / contributing to t on-time delivery of projects, resulting in saving time and money.
Walt Disney Studios Burbank, CA
SENIOR DEVELOPER2016 – 2017
Enabled the prompt and accurate payment to talent by strengthening and maintaining the RERUN application used to calculate and disburse payment based on quarterly revenue
Drove regular sprints by handling production support stories
Executed the analysis, development, and unit testing of user stories
Developed and modified UNIX scripts scheduled for regular jobs
Promoted the quick resolution of production issues by partnering with product owners
Raised code quality and championed collaboration in code review
Wrote T-SQL, store procedures, and functions in MS SQL Server
Fox Networks GroupBeverly Hills, CA
SENIOR PROGRAMMER ANALYST2013 - 2016
Allowed the automatic placement of promos in a cable log by designing and implementing an interface using TIBCO, Sybase, and PowerBuilder
Strengthened the in-house PACE systems and fixed bugs to improve performance in airing and exporting logs
Provided best-in-class support for critical applications related to program scheduling, advertisement scheduling, and sales systems
Jefferies & CompanySanta Monica, CA
ASSISTANT VICE PRESIDENT / DEVELOPER2010 - 2014
Start-to-end SDLC of the real-time-workflow data processing system for a High Yield (Fixed Income) and Convertibles trading departments. The system also includes interface with the Legacy System, which mainly performs calculations and partially a reporting. Designed and developed:
• Front-end Real-time Order Management System for TRACE, ADP and IPM Reporting
• Real Time Inventory and PnL Application
• Real Time Tracking of Traders \ Sales Commissions and Credits for Net Payouts.
• Feeds from JDOE, Market Axess, Reuters and Bloomberg
• Enhanced Aging reports, Top Sales Reports, Credit Blotter and Ticket reports
Warner Bros. Entertainment Group of CompaniesBurbank, CA
Senior Applications Programmer2006 – 2010
Work with clients and process owners to translate business requirements into technical specifications
Created detailed functional specification documents, user interface design, and process flow charts for execution of programming
Participate in project planning, track activities and task execution.
Provide technical direction and support to the project manager
Designed and developed a user-friendly interface to MediaVu which enables users to import Commercial restrictions into our STBS system
Completed integration between Warner bros and CBS system to transfer CW Broadcast logs and Broadcast Items via Web services, Biz Talk and MQ
Fully Administered the Sybase database used for STBS (Sales Traffic and Billing System)
Migrated Sybase database from Legacy HP system to AIX LPAR
Successfully tuned Sybase to enable multiple users to run multiple complex reports simultaneously
Implemented Disaster Recover Procedure with failover to Manassas site
Configured Sybase to run on Veritas Clustered Filesystem used for local failover
EARLY ENGAGEMENTS
SENIOR APPLICATION DEVELOPER ▪ Warner Bros Entertainment
SENIOR PROGRAMMER ANALYST ▪ Kabbalah Centre International
SENIOR PROGRAMMER ANALYST ▪ International Funds Service, a State Street Bank Company
SOFTWARE ENGINEER ▪ ICM Electronic Banking Services
Education
State University of New York at Albany, Albany, NY
BS in Computer Science and Applied Mathematics Minor: Business Administration
