Sr SAS Developer & Analyst

Sasha (Alex) BONDAREV

Cambridge, MA *****

E-mail: *****.*********@*****.***

Strong programming and analytical skills, solid mathematical background and problem solving ability,

full life cycle development experience.

SOFTWARE & TECHNOLOGIES: .NET 2002/5/8/(C#, VB.Net, winforms, winservices, asp.net), VS 6, ASP/(D)HTML/VBScript/JavaScript, XML, XSL, NUnit, Enterprise Library .Net, WIN API, MS OFFICE, MS SQL Server, Oracle, DB2, TOAD, Embarcadero, DBSolo, COM/DCOM, SOAP, MSMQ, IIS, Enterprise Architect (Sparx), Visio, Crystal Reports, Dreamweaver, Homesite, Java, JSP, Jbuilder(9, X, 2005), Junit, PVCS, VSS, ClearCase, Vantive, XMLSpy

SYSTEMS: MS WINDOWS (XP, Server 2003, 7), Unix/Solaris

EXPERIENCE:

2006 (Jul) –

2010 (May) Advent Boston, MA

Senior Software Engineer

.Net 2003/2005/2008 (C#, VB, winforms, winservices, ASP.Net), Enterprise Library 2/3/4, Web ((d)Html, Xml, Xsl, Javascript,), BizTalk 2004/2006, SQL Server 2000/2005, .Net custom installations, Crystal Reports (9/10, dev and API)

in house web projects and applications

● IndexData utility/win service (winform, also available winservice version) – receive end of trade day data from vendors (Russell, S&P), create advent xml index (performance) data constituent files and ftp distribute them to the clients (by specified indices, levels, and sectors) – such files will be imported by clients Advent Dataport (http://www.advent.com/collateral/pb_acd.pdf, also http://www.advent.com/solutions/by-firm-type/wealth-managers-software/apx-platform/index-data).

● Fidelity Exchange (win form) – evaluate content of the fidelity exchange files – gather downloaded data into sql server database, perform analysis and create reports (crystal pdf exports).

● Advent Corporate Actions website (asp.net, uploads, reports, transactions, research) – sql optimization;

2004 (Mar) –

2006 (Jul) Investors Bank & Trust, Boston, MA

Project Director / Business Support & Development – development team lead

● .Net Add-ins (Nunit, Nant, Add-Ins: Build Rules, NantBuilder, Data Access Layer Builder)

● Generic Crystal Reports Export Utility (winform)

● Monthly Volume Report (asp.net Internal web application – architecture & development - .Net, Web, Oracle, Crystal Reports)

● Expense Report Application (winform, similar to above set)

● Internal utilities for developers (winform, in C# mostly)

2003 (Feb) –

2004 (Feb) Tyco (Software House), Bedford, MA (contract)

Consultant (Java, C++, C#, Progress, SQL, Oracle, Crystal Reports 9, iNet, Tomcat 4, Servlets, JSP, Clear Case, VB.6, Web (dhtml, scripts, xml, xsl))

Design and development of reporting system (replacement for Actuate) which does not require for clients any special software installed – only Internet Explorer version 5.5 and higher.

● Ccure Server java/C++ report development

● Crystal Reports (9) development, custom UFL dll (C++) to handle client time zones

● Standalone utility (C++) to export reports in various formats (to be used from Windows scheduler)

● Java front end / C++ com wrapper for Crystal backend Crystal Report viewing tool design, development.

● Replication in Crystal/XML/Java/C++ of existing Actuate reports (moving from Actuate to Crystal 9)

● Writing prototypes in C# (to move existing java based application into .Net) – dlls for business logic

● Development of Crystal Report Viewer (C#) plug-in to be used in .Net applications;

● Created OCX (in VB6) to preview Crystal Reports v.9 and earlier, uses xml enabled interface

2002 (Dec) –

2003 (May) Schlumberger, CT, http://www.slb.com/ (offsite contract)

Consultant (SQL Server 2000, SQLXML, .Net (ASP, C#, VB), jscript, dhtml, xsl)

Development of the geological modeling web application.

● Development and coding of business layer (C#) to extract data from database (SQL Server 2000)

● Development and coding presentation layer (ASP.Net, javascript, SVG, html, xml, xsl, HTC) to display geological simulation results in browser (IE 6)

2002 Tyco, Bedford, MA (contract)

Consultant (Java, Progress, SQL, Crystal Reports 8.5/9, VB6, scripts, ClearCase)

● Development of the “Time and Attendance Report” reports and utility to prepare data sources for them (Crystal Reports 8.5, VB6 for prototyping, vbscript for implementation, ADO to perform database logic based on client conditions)

● Generic vbscript to run reports (with DSN, parameters, etc supplied in INI file)

2001(Nov) -

2001(Dec) Investors Bank and Trust Co., Boston, MA (contract)

Senior Software Developer (VB, Oracle, Access, Crystal Reports)

● Development and implementation “Master Extract” project for Mutual Fund Administration (Security Master Extract) to provide functionality for Boston and Dublin locations

● Development of Oracle package to perform heavy database calculations on the server side.

● Writing VBA Access code to import Oracle extracts and present it to the client in Access front end (VB6 for prototyping is used)

2000 (May) -

2001 (Oct) Surefire Commerce Inc, Newton, MA (perm) - www.surefire.com

Senior Software Developer (VB/ASP/Scripts/XML/XSL/HTML, Oracle 8i, MS SQL 7/2000, MTS COM/ DCOM, SOAP, .Net(C#, VB, ASP), Rational Rose and Visio were used to put various UML diagrams related to the work processes)

● Designed and implemented Order processing business (VB) and data (Oracle, MSSQL) layers to complete

 Credit card verification and fund transfer via xPay (Credit cards, FirePay cards, eCash)

 Order data recording and retrieving confirmation from db, sending email to the consumer

● Designed and implemented Back Office administration (UI/Biz/Data – ASP, Scripts/VB/Oracle, MSSQL)

 Order maintenance

 Merchant administration

 Upgrading AOL Portal by uploading (FTP) Merchant current information

● Created and implemented internal the utility (GenDac) to generate VB class code to call existing Oracle/ MSSQL stored procedure. This utility was widely used by company developers to create VB data layer.

● Participated in architectural design and implementation of the Oracle bottleneck 2-tier interface which intercepts generic XML request and calls specific package functionality (Oracle, Java XML Parser)

● Loaded init/test data into Oracle database (SQL*Loader: csv files >> Oracle)

● Research & Development Projects:

 Created DHTML utility to generate standard DHTML menu (XML, XSL, JavaScript)

 Created C# utility to generate code (VB6, C#, VB.NET) to communicate with DB (Oracle, MS SQL)

 Usage of Dynamic SQL (DBMS_SQL) to create stored procedures to handle single input parameter: xml string request to perform various Oracle tasks.

1999 (Nov) –

2000 (May) Bell Atlantic, Boston, MA (contract)

Senior Software Developer (VB6/VBA/ASP/Scripts, Access, Oracle, MS SQL7/2000, Crystal Reports)

● Created tools for Bell Atlantic Forecasting team – broadcasting Oracle data into MS Office and intranet IE (Excel/VBA, VB/COM/ADO, MS SQL)

● Created tools to populate result data on intra-net BA WEB page (VB, DHTML, ASP)

● Maintained existing Forecasting Excel application – added functionality to evaluate data having specific business rules (Excel/VBA)

● Evaluated existing GTE (Florida phone company merged with Bell Atlantic) application from technical point of view and submitting proposal for its possible future modification/adjustment (MS SQL, Visual Modeler)

1999 (Jul - Nov) Wang Global, Tewkesbury, MA (contract)

Systems Consultant (VB6/ActiveX/ADO/MS SQL7/SQL/API, MTS COM/DCOM, MSMQ 7, Vantive)

● Developed and tested middle-ware part of the unique inside paging software for European Company. Created COM objects, being promptly implemented into MTS and run by VB Script from MS SQL scheduler, are responsible for receiving, generating and sending pager messages.

1998 (Aug) - 1999 (Jun) Bank of Boston, Boston, MA (contract)

Systems Consultant (VB5/6/ActiveX/RDO/MS SQL6.5/DB2/SQL/API, Crystal Reports)

● Designed and coded application to test Tempest Storage Management Server (Diamond Head Software), which along with the Optical JukeBox provides powerful storage services for windows applications on TCP/IP networks.

● Developed a utility to register scanned Bank documents into PC Docs (document management system) database, apply desired security rights (NT) to them, and send to/extract from optical disks (Tempest Storage).

● Improved/debugged various internal Bank applications.

● Was responsible for database tier level maintenance (developed routines (RDO/ADO) to communicate with SQL Server from VB and Interdev/VBscript) for in-house bank ticket monitoring application

1998 (Jan) -1998 (Jul) Sentinel Benefits Group, Inc, Wakefield, MA (perm)

Software Developer, System Administrator

● Developed/customized and supported SalesLogix application

● Created applications for import/export data to meet requirements of benefits calculation software and electronic transaction software ([ACCESS/VBA/WORD], [VB5/DataJunction])

● Converted LOTUS applications into EXCEL/VBA; ACCESS/VBA applications

● Maintained Network, Spin Mail, installs, upgrades for the whole company, resolved software conflicts

1995 - 1997 Commercial Union Insurance Companies, Boston, MA (perm)

Actuarial Analyst/Programmer, Personal Lines Department

Passed CAS exams: parts 1, 2, 3A, 3C, 4A, 4B.

● Performed Loss Trend Analysis based on ISO data (EXCEL, VBA);

● Performed analysis related to CA Earthquake mapping using UPS Web site and internal database (Internet, ACCESS)

● Automated various exhibits for regular Filings and Rate Reviews (VB, EXCEL, WORD);

● Created package for producing Rate Pages (VB 4, ACCESS 2)

● Created utility (VB, WIN API, EXCEL) for detecting EXCEL virus.

1992 - 1994 Import-Export Bank, Kharkov, Ukraine

Programmer/Analyst

● Performed engineering design and implementation of the financial applications for an international bank (INGRES/4GL, SQL, C - SUN, Unix/Solaris, HP workstations).

1986-1992 Educational Software, Inc., Kharkov, Ukraine

Software Developer (Turbo Pascal 5.5, Turbo Professional)

● Designed, coded and installed software for industrial enterprises.

● Developed and implemented software for a psychological testing.

Kharkov University, Ukraine

Assistant Professor

● Developed and maintained database for the mathematical section of the university library (dBase IV).

● Conducted classes in Applied Mathematics and Mathematical Statistics/Probability Theory, Algebra, Analysis, and Differential Equations

TRAINING & CERTIFICATES:

2003 Sun Microsystems, Burlington, MA

● J2EE Programming (certificate)

2001 Rational Rose (Rational University, Lexington, MA)

● Fundamentals of Rational Rose (certificate)

● Object-Oriented Analysis and Design Using the UML

2001 San-Francisco VBITS Conference (.NET Studio)

2000 Microsoft Project Manager – Surefire Commerce onsite training (Newton, MA)

1999 Microsoft Visual Basic 6 BrainBench (certificate)

1998 Windows NT Administration – NE University (Burlington, MA)

1998 SalesLogix System Administration – Success Automation (Waltham, MA)

EDUCATION:

1986 - 1989 Kharkov University, Ukraine

Ph.D. in Mathematics (Math Phys, Diff Eq, Probability, Analysis)

1979 - 1984 Kharkov University, Ukraine

MS in Applied Mathematics, Computer Science

HOBBIES: Skiing, classical guitar, thai-chi, psychology and related fields, reading, math, problem solving.

MISC: 2005 – Deitel & Deitel: "C#, How to program,.Net2005" (Chapters: Web, OOP, Database, XML/XSLT, SOAP & BizTalk, etc ).

2001 – Deitel & Deitel: "Programming in C#" (Chapters: Database, XML).

http://www.csharphelp.com/archives/archive146.html

US citizen

References available upon request

Contact this candidate