SQL
Zachary Losoncy
Jenks,OK
Summary
Versatile developer adept at working with customers, quality assurance, project managers and fellow developers to develop leading-edge programs that enhance customers' business success. Strong problem solver and team player. Dedicated learner, able to get up to speed on new technology quickly.
Overview
8
8
years of professional experience
Work History
Senior Developer
Maggy London
01.2023 - Current
- Discussed project progress with customers, collected feedback on different stages and directly addressed concerns.
- Developed clear specifications for project plans using customer requirements.
- Planned and developed interfaces (AirTable, SSRS, Cube, PowerBI) that simplified overall management and offered ease of use.
- Oversaw all changes and development for ERP system.
- Company EDI (Electronic Data Interchange) knowledge expert.
- Managed relationships with over 20 retail partners
Data Developer/Analyst
Mid-Continent Group
03.2022 - 12.2022
- Develop ETL packages for deployment for use in internal reporting utilized by insurance claims managers and adjusters.
- Develop SQL scripts to fix production data
- Develop new WebFocus (Tibco product) reports
- SSIS, SSMS, SQL, WebFocus
Technical Consultant
Casino Cash Trac
11.2019 - 02.2022
- SQL Developer/Data Analyst: developed data loads and retrieves using SQL stored procedures, Oracle linked servers, and API calls to provide custom casino audit reporting.
- Business Analyst: Worked with clients to gather requirements and develop use cases to relay to development team. Assisted with QA scripts and Testing.
- Technical Project Lead: Configured and deployed the Casino Insight software suite, created custom reporting tailored to individual client needs, worked closely with other vendors in the casino industry to develop SQL views and reports, first line of defense for any software or configuration needs during installation go-live, traveled across the country to provide on-site training and technical support to some of the largest casinos in the World, including:
- Resorts World Las Vegas: Resorts World opened on June 24, 2021. It is the first new resort to be completed on the Las Vegas Strip since the Cosmopolitan, which opened in 2010. At a cost of $4.3 billion, Resorts World is the most expensive resort property ever developed in Las Vegas.
- Resorts World New York: Resorts World New York City (RWNYC) is the only casino in New York City, offering over 6,500 slots and electronic table games to 10 million guests annually.
- Circa, The D, and Golden Gate: Circa Resort & Casino opened its doors in October 2020, the first new downtown hotel built from the ground up since 1980.
- Turtle Creek Casino: Located only 11 miles outside of Traverse City in Williamsburg, the premier Northern Michigan casino has become a popular vacation spot for locals as well as visitors to the area. People from all over the Midwest come to enjoy Turtle Creek Casino, which is why it has become not only one of the favored casinos in Michigan, but also one of the all-around best destinations for entertainment and vacation.
- Black Oak Casino: Located just outside of Sacramento, CA, Black Oak Casino contains a 148-room luxury hotel, with over 6,000 sf of flexible meeting space, 164,000+ sf of gaming and entertainment options for everyone.
Technical Support Specialist
Casino Cash Trac
06.2019 - 11.2019
- Provided technical support for users of the Casino Insight software suite. This included correcting data in SQL, updating stored procedures, and XML dashboard design.
- Collaborated with and supported 50+ Casinos across the country
Cybersecurity Intern
ONE Gas
05.2018 - 03.2019
- Handled daily tasks like phishing and incident response, creating dashboards, monitoring logs, SCADA specialization
IT Intern - Security - Access Control
Magellan Midstream Partners
08.2017 - 11.2017
- Approve or deny security requests from queue and perform any tasks necessary for approval
IT Intern - Desktop Support
Magellan Midstream Partners
05.2017 - 08.2017
- Project lead for Windows 10 application testing, imaged/deployed laptops and monitors, performed some networking tasks, as well as general desktop help desk support
Education
B.S.B.A. - Computer Information Systems
University of Tulsa
Tulsa, Oklahoma05.2019
Skills
- SQL Specialist
- Customer Service
- Investigations and bug resolutions
- Automation
- EDI Expert
- Technical consulting
- Project management
- Documentation and reporting
- User experience
Software
EDI
JavaScript
JSON
API
Timeline
Senior Developer
Maggy London
01.2023 - Current
Data Developer/Analyst
Mid-Continent Group
03.2022 - 12.2022
Technical Consultant
Casino Cash Trac
11.2019 - 02.2022
Technical Support Specialist
Casino Cash Trac
06.2019 - 11.2019
Cybersecurity Intern
ONE Gas
05.2018 - 03.2019
IT Intern - Security - Access Control
Magellan Midstream Partners
08.2017 - 11.2017
IT Intern - Desktop Support
Magellan Midstream Partners
05.2017 - 08.2017
B.S.B.A. - Computer Information Systems
University of Tulsa
Similar Profiles
Jaymirra TaylorJaymirra Taylor
Resident Assistant at Maggy FreadResident Assistant at Maggy Fread
Ashley MoraAshley Mora
Cleaner at Maggy MaidCleaner at Maggy Maid
Breanna WilliamsBreanna Williams
Hostess at Chez MaggyHostess at Chez Maggy
Steven BelangerSteven Belanger
Operations Supervisor at Creek County AmbulanceOperations Supervisor at Creek County Ambulance
Jamie HagerJamie Hager
Radiologic Technologist at AMN HealthcareRadiologic Technologist at AMN Healthcare