Samuel Jinich
Woodland Hills, California *****
Mobile: 818-***-**** begin_of_the_skype_highlighting 818-***-**** end_of_the_skype_highlighting Home: 818-***-**** *******@*********.***
Creative programming professional with extensive experience translating business needs into efficient technical solutions that create value and contribute to efficient operations. Major strengths in meeting with internal and external clients to outline project needs, and follow up to plan and deliver effective IT solutions. Significant experience in maximizing available resources, creating custom business applications, programming development, and report design/analysis, web designing. Fluency in Spanish
TECHNOLOGY SKILLS
Operating Systems: Windows 7, Vista, 2000, XP. Windows NT Server, Novell
Microsoft Applications: All Microsoft Office Word, Excel, PowerPoint, Visio, Access, FrontPage
Database Applications: Visual Basic, Access, Crystal Reports, SQL 2000, Microsoft Query Analyzer
Communications Protocol: TCP/IP, DNS, DHCP, WINS, HTML, Ethernet & Hubs
Desktop Applications: CS4 Premium; Photoshop, Illustrator, Flash, Fireworks, InDesign, Dreamweaver
Accounting Systems: MAS90, ACCPAC, Quicken, QuickBooks & Peachtree
Hardware: Very savvy in configuration, installation & repair of various systems, desktop PCs & laptops.
PROFESSIONAL EXPERIENCE
CCRA TRAVEL SOLUTIONS (Formerly known as CCRA INTERNATIONAL INC., Agoura Hills, California 1999 to Present
$5M leading 274/7 reservations provider of ticketing/information on airline schedules/itineraries via 1,200 agencies, and a $4M Internet hotel booking subsidiary representing 32,000 hotels worldwide.
Programmer/Analyst
Direct all aspects of program design, coding, testing, and debugging of highly complex custom computer programs. Create customized business reports across divisions. Provide technical support to all levels of corporate and divisional management, including accounting, sales, marketing, customer service, call center reservation, training, and operations.
• Contributed to $4M annual revenue via initiation of RFP hotel booking program.
• Imported 32,000 Hotels Worldwide with their respective profile about 350 fields to an SQL database using Microsoft SQL 2000 and Visual Basic 6.0 database. Ensure coherent flow of contracted rates.
o Developed a user interface with 32,000 hotels for Directors to access data using Access 2000 and Visual Basic 6.0
o Create ad-hoc and custom reports for directors to query the data using Access 2000 and Crystal Reports.
o Create an online Hotel search for hotels to access their information using Perl, SQL Database. Also, create a hotel booking statistic for hotels to see the revenues and booking to their specific cities, using Perl.
• Create Weekly, Monthly, Quarterly reports for Hotel Directors that show growth and analyze potential markets using Excel 2007 Pivot Tables.
• Liaison with various “Hotel Relationship Teams” and “Rates & Content Teams” to ensure hotel content is obtained from
hotel sources in a timely manner. Assisted Latin Hotels in Spanish and brought new revenue to increase our total by 12% of the Latin market.
• Create and maintain an SQL database of 30,000 travel agencies. Ran custom queries using SQL Analyzer for the Directors to use for sales presentations to hotels.
• Work closely with the accounting department to provide management with weekly, monthly and annual projections with
year-to-year comparisons using Excel 2007 Pivot Tables, SQL Analyzer.
• Assisted Marketing Department creating hotel ads for our weekly eblast, hotel ads for our company websites, and online CCRA magazine using HTML coding, FrontPage, Photoshop 6, illustrator 9. The weekly eblast was targeted to the 30,000 agencies and contained Hotels specials. Created online questionnaires for Travel Agents using Perl, SQL 2000.
• Conducted training to office staff on Word 2000 and Excel 2007.
• Maintained three company websites: ccra.com, reservationcenter.net, ccratravel.com. Using HTLM, PHP, Perl 3.0, FrontPage 2003 and Photoshop 6.0. Posted new materials and forms.
Software Tools: MSQL 200, MS Access 2000 and Access 97, Visual Basic 6.0 Excel 2007, MS SQL Enterprise Manager Version 8, MS SQL Query Analyzer, Perl 4.0,Word 2000, FrontPage 2003, Photoshop 6, Adobe CS4: Photoshop, Dreamweaver, Illustrator, Perl 4.0, PowerPoint, Visio, Platform Windows NT 2000, Accpac, MAS90 and Crystal Reports
Samuel Jinich Page 2 *******@*********.***
INCA CORPORATION, Hawthorne, California 1994 to 1999
IT Systems Administrator
• Developed an in-house accounting program using dbase IV and Clipper that included accounts payable and receivables modules. Also, created ad-hoc reports for the President of the Company. Installed Accpac 3.0 and created invoice templates and in-house reporting.
• Installed and maintained a 10-user Novell 4.0 system and upgraded all computers.
• Developed company catalogs, manuals, and price lists on Page Maker 6 and Microsoft Word.
• Designed and maintained company’s Web pages using FrontPage.
Software Tools: Dbase IV, PageMaker 4.0, Microsoft Word 97, Excel 97, Access 97, Novell 4.0, Accpac
TOWN HALL OF CALIFORNIA, Los Angeles, California 1991 to 1994
Membership Database Coordinator
• Supervised 12 users of Novell network 386 V1.0. Built & updated membership database.
• Created various reports using dBASE, Clipper and Alpha IV. Performed merge/purge membership lists.
• Created projection graphs and spreadsheets.
• Conducted computer-training classes for the staff using Word.
Software Tools: Novell 386 V1.0, Alpha IV, Dbase III, Word 2.0, Lotus 1-2-3
EDUCATION
AA, Data processing, SANTA MONICA CITY COLLEGE, Santa Monica, California
Service Quality Optimization High level User Support Streamline Project Budget/Delivery
Design, Coding, Testing Significant Cost Savings Contribution Process Design & Standards
Workflow Management Full Life-Cycle Project Management Continuous Process Improvement
Translate Business Requirements into Technical Applications Dynamic Team Building/leadership
Problem Analysis & Rapid Resolution Complex Initiatives & Customized Design Strategic Planning