Systems Programmer / Analyst
Texas, United States
Contributed $4M annual revenue via initiation of RFP hotel booking program• Imported and processed 32,000 worldwide hotels to an SQL database using Microsoft SQL and Visual Basic database. Ensured coherent flow of contracted rateso Developed user interface using Access and Visual Basico Created ad-hoc and custom reports for directors to query the data using Access and Crystal Reports• Created online hotel search to access hotel information using Perl and SQL Database including reports on revenue and booking statistics to hotels• Provided technical support to all levels of corporate and divisional management, including accounting, sales, marketing, customer service, call center reservation, training, and operations• Conducted monthly training for office staff using Word and Excel• Created weekly email office tips in Word and Excel, banner of email titled Sam’s Corner• Created weekly, monthly, quarterly reports for Hotel Directors that tracked growth and analyzed potential markets using Excel Pivot Tables• Liaisoned with various “Hotel Relationship Teams” and “Rates & Content Teams” to ensure hotel content was obtained from hotel sources in a timely manner• Assisted Latin Hotels in Spanish• Brought new revenue to increase total by 12% of the Latin market• Created and maintained an SQL database of 30,000 travel agencies• Ran custom queries using SQL Analyzer for Directors’ sales presentations to hotels• Worked closely with Accounting Department to provide management with weekly, monthly, annual projections and year-to-year comparisons using Excel Pivot Tables and SQL Analyzer• Assisted Marketing Department and created hotel ads for weekly eblasts and websites• Designed online ads for CCRA magazine using HTML coding, FrontPage, Photoshop. Weekly eblast targeted 30,000 agencies• Created online questionnaires for travel agents using Perl and SQL• Updated and maintained three company websites using HTML, PHP, JAVA, Perl and Photoshop