Professional Summary

• IT Professional with over 10 years of broad range experience including Business System Analyst, Project Management, QA, Business Intelligence, and Database Management.
• Successfully project managed 5 third party financing lenders technical integration over the course of 7 years with a retail e-commerce business. These financing lenders program are:
• Private Label financing program with GE Money Bank, Alliance Data Bank, and Genesis Financial.
• Lease to Own financing program with Progressive Finance.
• Flexible Pay Retail Installment financing program with Axcess Financial (ChecknGo), and Monterey Financial Services.
• Reporting to the CIO, led a small team of developers to develop two e-commerce websites: venue.com and emporium.com. Both sites are architected using LAMP technology and hosted on Amazon Cloud. The vision is to have multiple store fronts with different financing program connected to one single backend system.
• Advance skills in SQL development and generating analytical reports in Excel.
• In depth cross functional experience in retail e-commerce business with multiple marketing channels and financing programs.
• Excellent communication skills with ability to liaison between technical and non-technical groups. Strong analytical and problem solving skills. Well adverse working in a fast paced, dynamic environment with timelines and milestones.

Professional Experience

Confidential, Los Angeles, CA (October 2004 to Present)
Sr. Business Systems Analyst

• Manage outsourced developers for all web development, and engineers for all in house desktop/server support needs.
• Analyze and recommend solutions to critical business and process improvement based on system expertise knowledge and ROI during governance meetings.
• Oversee all phases of web development using the SDLC process for venue.com and emporium.com e-commerce websites. Discuss requirements with various business groups, document functional specification, oversee development, and approve the validation phase. Provide pre and post release deployment support.
• Responsible for the analysis, design, creation and administration of all enterprise MySQL 5.1 databases.
• Develop SQL queries for data extraction, analysis and reporting. Analyze complex datasets in Excel and prepare ad-hoc business reports for the executive management including the CFO and CEO of the company.
• Set up promotion data related to new marketing campaign that generates revenues up to $ 20 million per campaign in a custom MySQL table. Import new prospect customer list in text file that consists of 4-5 million records using the MySQL data import utility tool.
• Built new and updated existing custom PL/SQL packages in a legacy backend Oracle system. Maintained SQL views and reports using Quest Toad and Oracle Discover 4.0. Administered daily processes on Oracle Applications 11i.
• In charge of entire day to day IT operations. This includes managing critical system uptime and 24x7 support, updating records in the master database using batch SQL update scripts, managing backup and recovery, training and data communication with bank partner and suppliers.

Confidential, Burbank, CA (June 2004 to July 2004)
Web Application Developer

• Updated existing web forms in ASP and SQL Server 2000.
• Built queries, views and stored procedures in SQL Server 2000.
• Worked with Marketing to provide ad-hoc data analysis in Excel.
• Participated in many projects for the new "Rapid Messaging Service" product.

Confidential, Tallahassee, FL (December 2003 to May 2004)
Computer Support Specialist (part time)

• Provided first line support of hardware and software for about 400 users.
• Managed procurement for the entire IT group.
• Updated and maintained the inventory database using Access 2000.

Confidential, Martinelli, S. A. - Panama City, Republic of Panama (January 1999 to July 2002)
System Administrator (part time)

• Managed a network system of about 10 users in a Microsoft Windows 2000 server environment.
• Built and maintained the customer database using Microsoft Access 2000.
• Back up data on daily basis using Veritas Backup Exec 9.1.

Technical Summary

• Operating Systems: Linux (CentOS), Microsoft Windows operating systems from 95 on.
• Software Development Tools: mediaWiki documentation, Tortoise SVN subversion, Mantis Bug Tracker, Lucid Charts, Visio, and Smartsheet.
• Languages: SQL, PL/SQL, T-SQL, PHP, HTML, JavaScript, UNIX Shell, and Microsoft Batch Scripting.
• Communication Protocols: xml web services, EDI and SOAP.
• Desktop Application Software: Microsoft Word, Excel, Outlook, PowerPoint, and Access.
• Databases: MySQL 5.0/5.1, Microsoft SQL Server 2000/2005 and Oracle 9g.
• Database Application Software: Navicat MySQL, SQL Server Enterprise Manager 2000/2005, Quest Toad, SQL Plus, Quest SQL Navigator, Oracle Discover 4.0 and Oracle Applications 11i, DTS and various ETL Tools.
• Networking: LAN, WAN, TCP/IP, DHCP, DNS, VPN and Active Directory.
• Security: Sonicwall Pro 2040 Firewall, Sonicwall Email Security 300 and Symantec Endpoint Protection 11.0.
• Network Application Software: Microsoft Exchange 2000 & 2007, StoreVault Manager 3.0, Snap Manager for SQL Server, Blackberry Enterprise Manager 5.0, Titan FTP, Veritas Backup Exec, Norton Ghost.
• Hardware: HP, Dell, Compaq, Sonicwall and Cisco.

Education and Certification

• B.S., Computer and Information Science
• MCSA - Completed all courses of Microsoft Certified System Administrator (Windows 2000)