Programmer/Analyst Resume

Title
Programmer/Analyst

Primary Skills
Requirements Analysis, Client Interaction, SQL, SAS, Large Database Manipulation, ETL

Location
US-DC-Washington

Posted
Oct-31-09


PROFILE

Innovative, solutions-driven programmer with 15+ years of success in data analysis along with the design of complex databases and sophisticated web applications. Applies excellent problem solving skills to efficiently and creatively resolve complex issues. Adept in utilizing and analyzing large analytic files. Assertive, self-motivated leader who possesses strong organizational, team building, training, and mentoring abilities. Articulate communicator who interacts easily with all levels of clients and end users to develop requirements and evaluate prototypes. Additional areas of expertise include:

Requirements Analysis • Survey Design • Management • Technical Writing • Quality Assurance & Testing

SELECTED PROJECTS

• FINRA Surveillance Design and Implementation. In support of FINRA's Market Regulation staff, responsible for defining, constructing and maintaining electronic surveillance programs designed to identify potential rule violations and/or market manipulation resulting in investor harm. Responsible for ensuring that surveillance program areas reflects business and technical needs and meets all requirements. Responsible for interfacing between area experts and technology staff.

• Analyzed survey data and developed survey support applications. For several SAMHSA/CMHS surveys of mental health organizations and client surveys, used SAS to set up the surveys and select the samples. Used SQL, ASP, HTML, VBScript, JavaScript, and Crystal Reports to provide sophisticated survey-support systems to track and process all survey data. Survey data was processed through paper forms and faxes in addition to the websites. Developed a sophisticated array of validation routines to test the data and code changes. Used SAS to do edits, imputations, weights, report writing, tabulations, and file distributions. Each iteration of these projects added additional functionality and value for the client without added cost.

• Designed www.EmbracingOurTraditions.com, an extremely powerful website that supported the functions for every phase of this extremely complex national conference. Employed ASP, SQL, HTML, VB Script and JavaScript under difficult circumstances to satisfy demanding conference attendees from around the world. This website was widely recognized as an important part of making this conference a success.

• Developed an application for the clinical trials support system for NIH/DAIDS using Delphi and MS SQL. This application supported all facets of the regulatory operations system for several NIH/DAIDS clinical trials programs.

• Planned and led a significant expansion of the ADAA's SQL membership database, integrating several new functions into the existing system, including automatic generation of renewal notices and daily membership labels. Used Crystal Reports to develop several new reports to facilitate planning and budgeting.

• Participated as a key member of a system design team that used SAS to develop a microcomputer-based micro-simulation model that simulated the financial impact of healthcare reform proposals for the White House Healthcare Reform Commission. Performed overnight modifications of comprehensive reports to Congress, the CBO, and the White House during a highly politicized analytical effort. TECHNICAL SKILLS

? SAS (Base, Stat, Macros, etc.)
? MS SQL
? ORACLE SQL
? ASP
? HTML
? Crystal Reports
? VBScript
? JavaScript
? SUDAAN
? Delphi
? TPL
? IBM Mainframe
? Windows
? MVS
? UNIX
? JCL
? COBOL
? DBMS Copy
? Visual Studio
? Source Safe
? Star Team
? Tele-Forms
? VB
? Various Editors & Utilities
JEFFREY SUSSMAN
Programmer/Analyst
js@jcsussman.org
H: 301.603.7895
C: 240.678.4603
CAREER TRACK

FINANCIAL INDUSTRY REGULATORY AUTHORITY (FINRA), Programmer/Analyst 2006 to present

Served as a programmer/analyst with diverse responsibilities in a demanding environment.
• Works closely with regulatory business managers to elicit business requirements from regulation managers and staff. Works with these managers to update requirements as necessary.
• Analyzing large data sets, such as stock market transactional data to prepare and present electronic surveillance program specifications.
• Coding, testing, debugging and documenting surveillance programs and procedures.
• Monitoring and adapting electronic surveillance changes to address industry changes, data issues, participant behavior, and/or rule changes.
• Maintaining relationships with business users, internal and/or external parties.

SOCIAL & SCIENTIFIC SYSTEMS, Systems Analyst 10+ years

Functioned as lead programmer on multiple highly complex data analysis and survey support projects.
• Worked with a diverse base of end users in designing, planning, and executing complex IT projects.
• Gathered the data necessary to define requirements; produced and maintained requirements documentation. Authored and reviewed program, file, and project documentation.
• Instituted procedures for and headed all facets of quality assurance, validation, and testing of project code, to include final validation and acceptance testing.
• Reviewed, evaluated, modified, and validated the code of other programmers.

Used SAS to conduct sophisticated statistical analyses of data from national surveys and complex databases.
• Collaborated with researchers, bio-statisticians, epidemiologists, data analysts, and managers as needed.
• Partnered with researchers in designing surveys, creating sampling plans, determining frames, and preparing survey documentation.
• Programmed multi-stage sample selection, shadow sampling, weights, edits, imputations (hot decking and regression analysis, among others), cross-tabulations, and reports.
• Created data sets and tables for publication, public use, web sites and feedback to survey respondents.

Designed high-level computer applications including web sites and survey-support systems using SQL, ASP, HTML, VB Script, Java Script and Crystal Reports.
• Survey support applications included online data submission, data entry of hard copy forms, verification, database updates, data checking, and survey activities tracking.
• Designed a wide variety of sophisticated websites tied to complex SQL databases.

Provided leadership and motivation to teams of 1-5 programmers.
• Monitored and supervised the daily activities of team members, serving as a mentor to programmers who ranged from junior to senior programmers.
• Prepared team schedules and timelines. Assessed project needs and ensured the availability of all required resources. Provided formal and informal progress reports to management and clients.
• Created and administered budgets.
• Drove efforts to maintain positive client relationships, ensuring satisfaction and identifying new opportunities.
• Served as a key member of several winning proposal writing teams.

Previous positions with Social & Scientific Systems included Senior Programmer and Programmer.

EDUCATION
Bachelor of Science in Computer Science, University of Maryland

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Washington, DC | Resumes in District of Columbia

View other Programmer/Analyst resumes, Programmer / Developer resumes