/ Robert Magara
675 Willow Ave, Garwood, NJ07027  609-216-0132 /

04/2005 - PresentTMC/Berlitz – Cultural, Management & Language Training Princeton, NJ

Lead Programmer/Solutions Architect –Software Solutions Department

  • Architecting TMC’s core web applicationswith more than twenty separate web applications in all including:Cultural Navigator, Management Navigator, Learning Zone LMS Course Portal, Practitioner Report Portal, Survey 360 and COI 360, Bookstore, Web Usage Reporting System and company website TMCorp.com
  • Formulate web applications to parallel overall business strategies
  • Use various software development methodologies including Agile, Interative, Extreme (XP) and Waterfall in accordance to client demands and the scope of a particular projects
  • Implemented object oriented methodologies by developing class and components libraries in order to optimize code reuse, streamline developmental and standardize the look and feel of web applications
  • Creating database structures, developing database objects and maintaining multiple databases
  • Designing multi-tiered web and database server configurationsincluding security configuration, redundant systems and fail over processes, backup systems and staging environments
  • Managing full life cycle of projects, defining deadlines and delegating tasks to developers and consultants
  • Writing technical documentation including requests for proposals, feature requirements and technical documentation
  • Managing and coachingprogrammers, qa analysts, database administrators, support analyst and consultants
  • Responsible for software implementation and product performance
  • Managing budget and negotiating contracts for hardware/software assets and infrastructure including development software/tools, web servers and database servers, service contracts with vendors and vendor provided systems
  • Technologies used: C#, ASP .Net, XML, ADO .Net, JavaScript, HTML, Sql Server 2005, T-SQL, IIS and Windows Server
  • Client Sample: Air Products & Chemicals, Bose, Deutsche Bank, Daimler Chrysler, Deloitte Touche Tohmatsu, Honeywell, Novo Nordisk Pharmaceutical, Pfizer, Procter & Gamble, Wachovia
  • Public URLs:

01/2004-04/2005 StayInFront -Software Fairfield, NJ

Programmer/Analyst –Development Department

  • Developing Stay In Front’s CRM software product Visual Elk for pharmaceutical sales reps to collect data on medical professionals, inventory samples, distribute budgets, sales and perform reporting
  • Modeling customized database, web and windows based solutions to meet the various needs of pharmaceutical companies
  • Developing and managingdata import, export and update programs that exchange large amounts of data between the Visual Elk Engine, the database, the client and third party vendors
  • Standardizing data exchange processes, data schemas, formats, batch processes and implementation schedules with client and vendors
  • Developing data automation tools to increase efficiency and integrity in data exchange processes
  • Performing data integrity analysis, data validation and writing data correction applications
  • Delegating developmentwork to the Operations and Database Administration departments
  • Performing code reviews for Development and Database Administration departments
  • Managing the full life cycle of projects including prototyping programs, developing, testing, integrating and meeting deadlines
  • Providing realistic and precise timelines for development work to the Client Services department
  • Designing programming paradigms to standardize coding practices and to enhance performance through code reuse
  • Technologies used: Visual Source Safe, VB .Net, ADO .Net, C#, Crystal Reports, VB 6, ADO, VBScript, UML, XML, HTML, ASP, ASP .Net, SQL Server, T-SQL, DTS, Active Elk, MS Office, VBA, IIS and Windows 2000
  • Client Sample: SepracorPharmaceuticals – Lunesta Product
  • Public URLs:

08/2003 -01/2004 Gillespie - Advertising Princeton, NJ

Programmer/Consultant - Strategic Services Department

  • Developed and administereddatabases for Pharmaceutical advertising campaigns
  • Architected databases to provide normalized data structures
  • Developed web based components in to assist analysts in searching, viewing and modifying data
  • Provided statistical analysis for weekly and monthly reports submitted to clients
  • Performed data analysis to ensure quality of data and implemented data validation controls
  • Createdcustom triggers, user defined functions and procedures for standardizing data manipulation
  • Technologies used: C#, ASP .Net, T-SQL, SQL Server, Enterpriser Manager, Query Analyzer, DTS, VB6 and Windows API
  • Client Sample: McNeil Pharmaceuticals – Concerta Product

02/2002 - 05/2003 BDO Seidman, LLP- Accountants and Consultants Woodbridge, NJ

Programmer - Information Systems Department

  • Developed a windows based CRM application to enables users to track audit projects and client contact information
  • Designed and developed document tracking system to enable transition to paperless audits; this program enabled users to view documentation online, track document history, locate and request original hard copies and modify data related to the document
  • Developed HRIS system that automates the new hire, promotion and termination processes that was integrated into the user account management process in Windows Active Directory
  • Drafted functional specifications and managed full life cycle of projects and programs
  • Created deployment packages for software applications, managed roll-outs and upgrades
  • Technologies used: ASP .Net, VB .Net, ADO .Net, Access, Excel, Word, Crystal Reports, SQL Server, Enterpriser Manager, Query Analyzer, DTS, VB6, ADO, Windows Server 2000, IIS, Wise and ZenWorks

07/2000 - 01/2002 Lazard Frères & Co LLC - Investment Banking New York, NY

Programmer - Information Systems Department

  • Programmed an HR intranet applicationsto manage employee data
  • Developed intranet based expense tracking application that enabled employees and departments to create and submit expense reports
  • Architected and developed call tracking system for Help Desk and Tech Support departments
  • Technologies used: ASP, VBScript, HTML, VB6, ADO, SQL Server, Access, IIS and Windows Server 2000

01/2000 - 05/2000 Viacom - Entertainment New York, NY

Technical Writer/Internship -Computer Training Department

  • Wrote training documentation for each Microsoft Office 97 application with an emphasis on new features and advanced functionalities
  • Created training documentation for proprietary applications
  • Upgraded the Accounting departments Access databases, VBA modules and Excel templates
  • Technologies used: Publisher, VBA, Access, Excel and Word

09/1998 - 06/1999 Finepoint Technologies -Software New York, NY

Database Developer -Development Department

  • Developed a Sales and Marketing applicationusing to produce statistics, create reports, track sales and client information
  • Provided web based front-end to provided access to the database from the web and maintained web server
  • Developed, designed and published Internet web site
  • Technologies used: VB6, VBScript, ASP, ADO, Access, Excel, Word and Windows NT

Education

Solar Tech – Hasbrouck Heights, NJ

  • Microsoft Certification Training for MCAD: 2003

Pace University – New York, NY

  • Graduated: September 2000
  • Degree: Bachelor of Science in Computer Science and Information Systems

Rider University – Lawrenceville, NJ

  • Transferred: September 1997
  • Major: Business Administration

Certifications

Microsoft Certified Application Developer (MCAD) – 2003 – VB .NET

Microsoft Certified Professional (MCP)

  • Developing and Implementing Web Applications with Microsoft Visual Basic .Net and Visual Studio .Net
  • Developing and Implementing Windows Applications with Microsoft Visual Basic .Net and Visual Studio .Net
  • Creating and Managing Microsoft Windows® Services, Serviced Components, .NET Remoting Objects, and XML Web Services

Technical Skills

Development: Visual Studio .Net (Framework 1.0, 1.1, 2.0, 3.5, C#, VB .Net, ASP .Net, ADO .Net, XML, AJAX, Web Services), Visual Studio 6 (VB, ASP, ADO, Visual Source Safe), VBScript, VBA,SQL, T-SQL,HTML, CSS, Win-Batch UML, JavaScript, ComponentArt, ComponentOne, Infragistics

Database:SQL Server 2000/2005, MS Access Database

Server:Windows Sever (2000/2003, Internet Information Server/IIS, Active Directory)

Novell (NDS, ConsoleOne, Netware Administrator, ZenWorks, GroupWise)

Design:Macromedia MX (Dreamweaver, Fireworks, Flash)

Adobe (Acrobat, Photoshop, Illustrator)

Desktop:Windows(Vista, XP, 2000, 98, 95, NT)

Office ((2007, 2003, XP, 2000, 97, 95), Outlook, Visio, FrontPage))

Windows Installer, Wise Packaging Suite, Ghost, NetSupport, Lotus Notes