Howard M Lopez

Senior Database Developer Profile

ady557@r.postjobfree.com • 702-***-****

linkedin.com/in/howard-m-lopez-a827b64/ • Reno, NV 89509

Detail-oriented and analytical IT professional with extensive experience in designing and developing efficient/scalable database solutions, while understanding business requirements and translating into logical and physical database designs. Instrumental in implementing processes and systems to monitor data quality, as well as ensuring availability, security, and integrity of databases. Proven expertise in supporting execution of best practices for scalability, supportability, and system performance. Track record of identifying and resolving performance bottlenecks by analyzing database statistics and system performance metrics. Adept at staying updated with latest trends and advancements in database technologies and best practices.

Areas of Expertise

Database Development

Data Validation & Replication

Strategic Planning & Execution

Software Development

Performance Optimization

End-to-End Project Management

Complex Problem Resolution

Team Building & Leadership

Cross-functional Collaboration

Technical Proficiencies

Languages: IBM i: ILE, ILE Free, CLP, SQL400 Familiar with: Teradata: BTEQ, PHP, C#, Java, SQL Software

Databases: SSMS, SSRS, SSIS, DB2, DB400, Teradata

Applications: Microsoft SQL Server Management Studios, Microsoft Server Report Services, INFOR Hotel Management System. LMS, Infinium (Back Office), Stratton Warren, DB2 Web Query, Microsoft Report Writer, iTera Replication

Professional Experience

Agua Caliente Casinos – Rancho Mirage, CA 2022 – 2023

Database Marketing Developer

Provided unwavering support to the marketing team in updating and modernization of current campaign processes to achieve higher campaign performance. Leveraged technical expertise to create SQL scripts via SSMS to pull patron lists for monthly campaign offers and promotions. Generated automated reports via SSIS for different departments, including Database Marketing and Finance to ensure seamless workflow. Developed and implemented custom programs with the aim of enhancing campaign processing.

Key Achievements/Contributions:

Converted all ACCESS SQL scripts to SSMS SQL scripts aimed at modernizing the marketing department.

Refined existing SQL scripts to run more efficiently.

Grand Sierra Resort – Reno, NV 2016 – 2021

Lead Programmer Analyst

Delivered support for back-office system encompassing Human Resources, Payroll, Purchasing, General Ledger, and Front Desk (Reservations), while ensuring data replication to HA system. Modified and developed customized programs aimed at optimizing processing efficiency. Upgraded and maintained all applications running on IBM I, as well as IBM i Power 7, including PTF and release upgrades. Documented and trained IT Operations staff on existing and new procedures related to IBM I with keen focus on enhancing operational efficiency and improving overall IT operations.

Key Achievements/Contributions:

Developed Application Interface to improve accuracy and streamline application process.

Bankers Life & Causality – Las Vegas, NV 2015 – 2016

Insurance Agent

Identified potential clients and generated leads through various methods such as referrals, cold calling, networking, and attending events. Presented insurance solutions to clients and guided through sales process. Ensured completion and compliance of all necessary paperwork, applications, and forms with regulatory requirements. Met with prospective clients to understand insurance needs and goals.

Key Achievements/Contributions:

Accomplished mentor and trainer to junior agents for Annuities.

The Cosmopolitan of Las Vegas Hotel & Casino – Las Vegas, NV 2011 – 2015

Release Manager Software Development Manager Senior Software Developer

Developed, implemented, and optimized consistent, repeatable, and predictable release management process to minimize risk and resolve issues promptly and efficiently. Formulated innovative strategies for managing release of software and hardware solutions within organization. Established appropriate development and quality assurance guidelines to create reliable and consistent environment for release management process. Supervised development of technical staff to complete projects and enhancements to system infrastructure. Oversaw development and testing of ELT processes to ensure accuracy and accessibility of data through Enterprise Data Warehouse for various business units.

Key Achievements/Contributions:

Acted as key technical liaison for Teradata Relationship Manager (TRM) Application between Marketing, and Teradata/Aprimo support staff, including EDW solutions, view and attribute creation, communication development/tuning, and training.

Served as primary support and developer of custom applications on IBM i (AS/400) system.

Developed new review process to ensure accurate creation of all software and installation according to specifications with minimal impact to end users.

Increased turnaround timer for projects and task by 15%, while increasing accuracy and user confidence.

Additional Experience

IBM i Admin (Development Consultant) Link Technologies – Las Vegas, NV

Senior Content Consultant Analyst in Motion Consulting – Irving, TX

BI Programmer Analyst Stations Casinos – Las Vegas, NV

Senior Programmer Analyst Nature’s Bounty (NBTY, INC) – Las Vegas, NV

Programmer Analyst Bally’s Entertainment – Las Vegas, NV

Programmer Analyst Rio All-Suite Hotel & Casino – Las Vegas, NV

Lead AS/400 Developer Allstate Ticketing – Las Vegas, NV

Education

Master of Science in Computer Informations Systems University of Phoenix – Las Vegas, NV

Bachelor of Arts in Mathematics Whitter College – Whittier, CA

Contact this candidate