Los Angeles T-Sql

Avraham Lichaa

******@*****.*** 310-***-**** 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 DEVELOPER 2023 - 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.

Benevis Atlanta, GA

SENIOR DEVELOPER 2022- 2024

●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% t.

●Integrated Genesys Call Center into existing DetaPro EHR using T-SQL, Stored Procedures, SSMS, and PowerBuilder, enhancing data collection and improving business analytics.

thethingmarket.com Los Angeles, CA

SENIOR DEVELOPER 2022- 2023

●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 & Entertainment Marina del Rey, CA

STAFF DATABASE ENGINEER 2019 - 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 Group Marina del Rey, CA

SENIOR PROGRAMMER ANALYST 2017 - 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.t.

Walt Disney Studios Burbank, CA

SENIOR DEVELOPER 2016 – 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 Group Beverly Hills, CA

SENIOR PROGRAMMER ANALYST 2013 - 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 & Company Santa Monica, CA

ASSISTANT VICE PRESIDENT / DEVELOPER 2010 - 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 Companies Burbank, CA

Senior Applications Programmer 2006 – 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

Contact this candidate