Objective

A Project Specialist or Team Lead position utilizing my technical skills while offering increased responsibility for system architecture, improving patient care, and meeting other goals of Partners IS.

Key Qualifications

• M.S., Business Computer Information Systems.
• 8 years of experience developing databases and data-driven applications.
• Skilled at data modeling and user interface design.
• Can work with business owners, users, and staff to map business needs to technical solutions.
• Will take initiative to learn new skills, make improvements, and find the right answer to a problem.
• Microsoft Certified Professional:
  • Designing and Implementing Databases with Microsoft SQL Server 2000
  • Microsoft .NET Framework 2.0 - Application Development Foundation

Experience

Systems Designer,
Partners HealthCare, February 2007-present

Work on Partners’ EMPI (Enterprise Master Patient Index), a mission-critical, enterprise database application supporting over 100 clinical sites (including several major hospitals) with more than 5 million patient records, processing over 100,000 HL7 transactions and responding to over a million service requests in SOAP, XML, and legacy formats daily.

Technologies used

C#, ASP.NET, JavaScript, HTML, CSS, Caché
(ObjectScript, objects, SQL, Weblink, ODBC), Microsoft SQL Server 2005, SQL Server Integration Services (SSIS), XML Web Services
(SOAP, POX, WSE, WS-Security), Dojo

Projects

• Used Microsoft SQL Server 2005 and SSIS to implement a weekly extract process (ETL) of over 20 million database rows from a Caché database via ODBC.
• Created Alert Viewer application using Caché bitmap indexes to allow users to very quickly find and drill down into data of interest. The UI was enhanced with an AJAX control from the Dojo toolkit.
• Maintained intranet management applications. Working with users and business analysts, developed user interface improvements to provide more information in a cleaner layout, while retaining look and feel users were accustomed to. Refactored existing code for consistency, performance, and maintainability.
• Developed custom ASP.NET data grid control using C# and JavaScript featuring usability enhancements such as client-side sorting and rich paging, scrolling, and navigation functionality. The control ensured a consistent user interface with less code, and helped prepare for future development.
• Upgrading ASP.NET 1.1 application to run on .NET 2.0 in a phased approach (in progress)
• Modified existing Caché classes to support ODBC projections of date and time data to Crystal Reports.

Additional responsibilities

• Performed bug fixes, data conversion, and testing.
• Updated issue tracking and source control systems as appropriate (TCS, VC/m, SourceSafe)
• Performed scheduled deployments to production.
• Provided 24/7 on-call support as required for patient care.

Senior Lead Developer,
Insight Direct, Inc., August 2004-February 2007

Development team member for a client/server business application, in use by over 3,000 companies in the field service industry for CRM, accounting, and operations management. A major personal focus was improving data quality and reliability of the software and build process.

Technologies used

C#, Windows Forms, Microsoft SQL Server 2000/2005, Visual Studio 2005, .NET Framework 2.0, ADO.NET, XML, Visual Basic 6.0, COM Interop, InstallShield, DB Ghost, MbUnit, Visual Build Professional, Perforce, Crystal Reports

Development projects

• Created the Database Validator, now in its second version, saving hundreds of hours of technical support time while increasing customer satisfaction by finding and fixing data quality problems.
• Built employee time tracking and payroll functionality, integrating service-oriented architecture with existing logic. The project had user interfaces with custom keystroke handling to facilitate data entry and configurable logic wrapped with a setup wizard for new users. It was developed iteratively with feedback from product management, customers, and QA.
• Created database backup and restore tool for efficient troubleshooting of multiple customer databases. Originally for internal use, the core components were reused by another developer to build a customer-facing tool.
• Developed “customer price levels” feature, refactoring complex and poorly documented logic and working closely with QA team on functionality designed to increase the application’s market share.
• Worked on XML accounting data export and QuickBooks integration.
• Worked on API framework using C# 2.0 generics and web services; created lightweight data binding framework for presentation of business objects.
• Helped develop and implement a “quick complete” feature, finding a way to greatly increase functionality with minimal code changes.
• Modified application to support SQL Server 2005 while maintaining backwards compatibility with SQL Server 2000.
• Improved ODBC database connection functionality in VB 6.0 application using a COM Callable Wrapper (CCW), providing a way for multi-user installations to easily configure database connections.

Process improvement and build automation projects

• Implemented daily build process with automated unit testing.
• Assisted with implementing Perforce version control software and determining branching strategy.
• Designed and implemented database change management system providing version-controlled schema and automated end-user upgrades, integration DB G host, Visual Build Professional, and Perforce with custom logic.
• Championed unit testing and test-driven development; wrote test suite for legacy code and reports using COM Interop and MbUnit.
• Wrote data-driven upgrade test system using MbUnit combinatorial tests, ADO.NET, and COM Interop.

Additional responsibilities

• Resolved bugs and improved data access and error handling code in Visual Basic 6.0 project containing over 500 classes and half a million lines of code.
• Created, maintained, and documented stored procedures and schema in an SQL Server database with over 200 tables and 700 stored procedures, with an eye toward increasing performance and relational integrity.
• Wrote specifications and use cases; attended daily Scrum meeting following an agile development methodology; served as mentor/technical lead on projects with junior developers; interacted with customers in online forums; worked with technical support staff to re solve customer issues.

Application Developer, DALBAR, Inc., February 2001-August 2004

Technologies used

C#, ASP.NET, Microsoft SQL Server 2000, DTS, Microsoft Access, HTML, CSS, Python, JavaScript, XML, XSD, XSLT, Visual Basic 6.0, Subversion, ReportLab, Windows NT, Windows 2000

Projects

• Designed and implemented system for generating customized PDF market research reports for over 100 customers, using SQL Server, DTS, XML, Visual Basic, Python, ReportLab, and data warehousing techniques.
• Initiated software testing process, increasing user satisfaction and reducing errors.
• Designed and implemented new database schema, improving data quality and system performance.
• Created quality control process for database reports, ensuring consistent, accurate data for clients.
• Developed web sites to provide clients with reports, data, and interactive forums using C#, ASP.NET, SQL Server, XML, and XSL.
• Work on intranet CRM application.

Additional responsibilities

• Attended “Presenting Data and Information” course by Edward Tufte
• Performed database administration tasks
• Assisted with network administration and support

Systems Manager, USCJ, July 1999-September 2000

Technologies used

Classic ASP, VBScript, Microsoft SQL Server 7.0, Microsoft Access, HTML, CSS, Perl, JavaScript, VBScript, XML, Windows NT, Windows 2000, IIS, ListServ, SMTP

Projects

• Administered web and e-mail hosting services for the organization and its member organizations.
• Researched, recommended and implemented ListServ software for e-mail and mailing list services-one of the organization’s largest IT investments-and developed automated data conversion scripts and tests to roll out with minimal disruption to users.
• Developed database, intranet and e-commerce applications.

Additional responsibilities

• Supervised student interns.
• Provided technical assistance to local and remote staff.

Publications Coordinator, USCJ, November 1996-July 1999

• Developed early web site and online strategy for an international organization.
• Gained project management and communications experience overseeing the production and distribution of books, newsletters, promotional materials, and press releases.

Education

M.S., Business Computer Information Systems, 2000
Zicklin School of Business, Baruch College, The City University of New York

• GPA: 3.9
• Coursework in major: Systems Analysis, Database Systems, Networking and Telecommunications, Object-Oriented Programming in C++
• General business studies: Marketing, Accounting, Finance, and Human Resource Management
• As a team project following the Software Development Life Cycle (SDLC) methodology, developed online stock trading application using Java Server Pages (JSP), HTML, Cascading Style Sheets (CSS), and SQL
• Member of Beta Gamma Sigma, the honor society for accredited business programs
• Received departmental award for academic excellence

A.B., 1996
Washington University, St. Louis

• Major: Jewish and Near Eastern Studies
• Minor: Business Administration
• Twice named to Dean’s List
• Held leadership roles in student activities
• Study abroad experience at Tel Aviv University, Israel

Professional Activity

• Classes taken towards Partners’ Management Fundamentals Certificate:
• Performance Management
• Role of the Manager
• Submitter to
  MbUnit, an open source unit testing framework for .NET.
• Contributed bug fixes to
  ReportLab, an open source Python framework for generating PDF files.
• Have attended local user group meetings including Boston .NET (Waltham), Beantown .NET (Boston), Cambridge Python, and New England MUMPS group.