SUMMARY

Senior Programmer – Twelve years of programming experience developing within the Microsoft Platform. Possess extensive knowledge of Object Orientated design, Database development and Application Architecture.

EXPERIENCE:

• Confidential,Hollywood, CA
• Sr. Programmer Analyst; June 2009 – October 2009
• Responsible for enhancements and modification of a custom financial accounting system (PARIS) that manages Participations and Residuals for actors, directors, writers, and talent. The application modules covered contract management, financial statement generation, and payment remittance. Application web interface written in ASP and JavaScript. Utilized VB6 and COM components for data extract and excel statement generation solutions. Created complex T-SQL stored procedures, functions and triggers in the SQL 2005 environment to handle the application business logic. Developed design documentation and change control documentation process. Worked with team of project managers, business analysts and database administrators to successfully promote the application to a production environment.
• Confidential,Hollywood, CA
• Sr. Programmer Analyst; November 2006 – November 2008
• As a member of the software division developed and supported existing client applications written in VB6, XML with SQL Server 2000 database backend. Unit test and debug code. Created technical documentation on assigned projects and worked with management, customers and business analyst to define and meet deliverables. Designed and customize reports using Crystal Reports and Tide stone reports. Reports created for Network Operations application and Exhibitor Management application for invoice, accounting, g/l and billing reconciliation of digital delivery and box office receipts. Reports used by senior management for decision support. All application business logic comprised of complex stored procedures and triggers written in T-SQL. Applications used by major and independent film studios for theatrical distribution of digital cinema. Used globally by film exhibitors to manage all key elements of theatrical exhibition. Applications eliminated manual processes and integrated with various vendors using web services. Developed customize internal application written in VB.net for Advertising division to handle physical and logistical distribution of pre-show content.
• Confidential,Los Angeles, CA
• Application Developer; June 2005 – October 2006
• Responsible for reengineering and augmenting existing client server and web applications. Implemented new development and quality assurance environments. Migrated web and SQL servers from Windows NT to Windows 2003. Strategize SQL data migration and implemented weekly DTS processes for third party content provided data. Test, remediate and enhanced Digital Listening station software with IBM touch screen kiosk, which ran OPOS 1.9 and WEPOS for retail systems. Tools used to build Digital Listening Station software consisted of a VB6, XML, ASP, and SQL 2000. Application required interfacing with Barcode Scanner and Motion Sensor peripherals. Application implemented at 12 retail stores with 250,000 users daily. Designed and Created customized web interfaces to support maintenance of the Digital Listening Station application after gathering department user requirements. Developed a back office replenishment and special order application using ASP.net and web services to retrieve third party inventory for fulfillment. Application contained open to buy budgets constraints to regulate cost. Created an automated workflow and purchase order process using data transformation services, which transferred the work order to JDA. Provided level III application level support for all in house customize applications and customer websites. Maintained and supported company web portal.
• Confidential,Glendale, CA
• Sr. Programmer Analyst; October 2000 – April 2005
• Part of a team which designed and implemented an n-tiered intranet application, which encompassed facilities management, human resources, finance, sales, and messaging functionality. Site accessed by 400 North American regional store locations and multiple business units within company headquarters. Used SQL Server 7, Visual Basic COM components, MTS, ASP, Visual Interdev, IIS, Active Reports, and Source Safe as development tools on a Windows NT Platform. Used JavaScript for web page validation and VB script for server side scripting. Created stored procedures, and DTS packages. Create Project Plans, technical specifications, database design, Use Case design, and code documentation using Microsoft Project, Rational Rose, Visio and SQL Server. Formulated and presented logical, persuasive messages and ideas to users. Provided quick response production support and resolved application Help Desk tickets as required. Designed and implemented an intranet application for 200 European Disney Stores and multiple business units located in the United Kingdom headquarters. Site access by English, French, Spanish, and Italian stores in their respective languages. Utilized SQL Server 2000, COM+, Visual Interdev, ASP, XML, Active Reports and IIS to build application on a Windows 2000 platform. Created desktop and application installation documentation for European application rollout. Implemented Application integration with Company Human Resource SAP Conversion Project.
• Confidential,Los Angeles, CA
• Programmer Analyst /Jr. Database Administrator February 1999 – October 2000
• December 1999 – October 2000
• Maintained and modified existing production applications written in various languages, such as Visual Basic 4.0/6.0, Access 97/2000, and Active Server Pages. Create customized solutions for numerous business units including Accounting, Technical Centers, Programming, Affiliate Relations, Scheduling, Production, International, and Regional News. Performed analysis of business practices, and use of legacy systems, to formulate solutions for solving business problems due to system upgrades and scalability issues. Developed a video digitizing and distribution application using VB 6.0, SQL Server 7.0, ADO and Windows API. Application used an N-tiered object model containing COM components, used to streamline and encapsulate business objects. Developed an event, and crew tracking system using a N-tiered object model for the Production department. Created an Outlook contact import/export application, using Outlook VBA, and Exchange for Affiliate Relations. Developed a customized vault, video clip, and melt reel management application using Access 97 and SQL Server 7.0 for the Technical Centers. Modified intranet applications using Visual Interdev and VBScript.

June 1999 – October 2000

• Assist the Sr. Database Administrator, in logical database design and structure, using SQL Server 6.5 and 7.0. Assign user permissions, implement database upgrades and modifications using SQL scripts, refresh test and development servers, administer all production and test databases, responsible for database change control, create and implement stored procedures. Performed data and schema migration of production, test, and development servers from SQL Server 6.5 to SQL Server 7.0. Created DTS packages, BCP, and imported data from AS400.
• February 1999 – June 1999
• As part of the Y2K compliance program, required to develop, and implement policy, standards, and procedures for excel spreadsheet remediation and testing. Supervised training of remediation software. Remediation of in-house, third party applications, and stored procedures developed in Visual Basic 4.0, SQL Server 6.5, and Access. Modification and report generation using Crystal Reports. Developed and maintained a compliance tracking, and task management database using Access 97. Data consist of compliance information for over 5,000 business partners, 200 business applications, infrastructure, and broadcast systems. Developed various reports to provide decision support for Y2K contingency planning.
• Confidential,Brentwood, CA
• Data/Programmer Analyst; November 1998 - February 1999
• Responsible for routine data maintenance of dBase files from a legacy property management system. Data is integrated to Visual Basic and Access Applications. Required to develop, maintain, troubleshoot, and provide user support for multiple applications and databases using Visual Basic and Com objects. Produced complex reports using algorithms, SQL, and VBA.
• Confidential,Los Angeles, CA
• Access Developer; June 1998 - November 1998
• As a consultant, designed, developed, and administered a complex data entry, report writing, and database maintenance system, for a maximum of fifteen users using MS Access. Standardized training and authored a user manual. System designed to track and monitor patient activity for the hospital’s Clinical Decision Unit. Reports consist of graph analysis, algorithms, and percentage totals used as decision support by Managing Physicians, Quality Assurance, and Nursing Administration.
• Confidential,Los Angeles, CA
• Programmer Analyst; August 1996 - June 1998
• Design, code, implement, and administer a Relational Database Management System. System developed after thorough departmental needs assessment. System used by twenty employees located in northern and southern California. Designed using Access, VBA, and SQL. Part of a team that designed and implemented data migration to Sybase SQL Server. System resulted in a thirty-three percent increase in production from a staff reduced by twenty-five percent.
• Event Planner; August 1995-August 1996
• Develop and implement project planning schedules, and assist in speaker recruitment and contracting. Maintain oversight of project schedule implementation to ensure timely production of extremely time-sensitive seminar products. Supervise all site coordinators and staff. Conduct and standardize training, as well as author training manuals. Responsible for cost reporting and analysis of all Southern California sites. Extensive use of Tandem Administrative Systems.
• Audio Visual Technician; August 1990-July 1995
• Responsible for all audio-visual needs for the Southern California regional office. Included site evaluation and setup, as well as training of audio-visual support staff. Gained extensive expertise in all areas of audio-visual equipment and exhibition techniques.

EDUCATION:

• Bachelor of Arts, History

COMPUTER SKILLS:

Microsoft office, Access v2, v7, v8, Visual Basic v5.0, v6.0, SQL Server 6.5, 7.0, 2000, 2005, Oracle 7.3, DBArtisan, ERStudio, Crystal Reports, Active Reports, Windows 2000, IIS, Visual Interdev, Macromedia Dreamweaver, DAO, RDO, ADO, MS Outlook and Exchange programming, Visual Source Safe, COM, COM+, Microsoft Transaction Server, XML, JavaScript, MS Project, Visio, C#, VB.NET, ASP.NET