SUMMARY:

• Strong professional experience in design, development, and support of business and engineering applications (including object - oriented and database design).
• Ability to collect business requirements, translate them into application design while generating innovative solutions, and execute the resulting implementation tasks alone or as part of the development team.

TECHNICAL SKILLS:

Languages: Visual Basic 6.0, .NET (2.0, 3.5, 4.0, 4.5), MS Office VBA (Access, Excel, Word, PowerPoint, VSTO); C/C++(Visual C++, 6.0, .NET, STL); C#; LINQ; MDX (ADOMD), DMX, DAX.

DBMS: Access 2003, 2007, 2010; MS SQL Server 7.0/2000/2005/2008/2014 (SSAS, SSRS, SSIS/DTS), Oracle 9i, 10g, 11g (PL/SQL, TOAD, SQL Plus, SQL Navigator).

Operating Systems: Windows XP/7 (WIN32, P/Invoke, ODBC), UNIX (Solaris).

Other Software: Crystal Reports 7.0, 8.5, 9.0, Attachmate "Extra " 6.3, Imaging Pro 2.0, ImageWare EPI Builder 6.0, WinFax PRO 9.0, ASP.NET; UNIX Shell Scripting, Data Dynamics Active Reports for NET, WiX Toolset, PDFBox/IKVM, SharpZipLib, DevExpress WinForms Controls, SAS 9.4.

PROFESSIONAL EXPERIENCE:

Confidential, NY

Consultant

Responsibilities:

• Ported a car tracking application written in VB 6.0 to MS Access 2010. “Car-Limo Information Flow” (CALIF) is a modular and fully integrated multi-user application having MS Access as backend. Added new functionality to the existing applications according to client’s requests using MS Access forms and VBA. Designed MS Excel reports.
• Troubleshooted slow-running queries using Estimated Execution Plan. Designed and modified SSRS dynamic reports (Drilldown, Drillthrough, Subreports) generated from relational databases and OLAP cubes and rendered them using Report Viewer control. Converted old Intranet application to WinForms (C#, DevExpress Controls).
• Modified and optimized stored procedures, functions, and views (MS SQL) in tandem with C# code according to new requirements and to improve performance. Wrote scripts to create tables, indexes, and databases. Created SSIS packages for transferring data from a variety of data sources into MS SQL database. Designed and implemented SSAS cubes (dimensions, calculations, aggregations, partitions, KPIs, roles, etc.). Researched Data Warehouse design, Data Mining Models’ creation, and BISM tabular model.
• Evaluated WPF, WCF, JavaScript, MVC. Familiarized myself with SAS programming and PowerPivot.

Confidential, New York, NY

Consultant

Responsibilities:

• Developed components of XP3 - adynamic data processing, data analysisand presentation/reporting software solution dat halps organizations transform data into actionable insights conveyed throughinteractive Microsoft PowerPoint Presentations and Excel Reports.
• Developed MS Excel & MS PowerPoint 2010 add-ins using Visual Studio 2010 (VSTO) (C#). Automated Excel pivot tables and charts creation and embedding in PowerPoint (VBA object model manipulated via C# dll). Re-implemented heritageVB6 and C++ COMmodules in C# and adapted them for use in different versions of MS Office. Implemented an interactive “wizard” to facilitate user’s interaction with the system (C#, WinForms, DevExpress Controls).
• Worked with 3D data cubes using MDX and ADOMD to obtain metadata (dimensions, hierarchies, levels, members, measures). Utilized common object-oriented architecture (built on MS ADO.NET) to integrate the application with different data sources (SSAS, MS Access files, Oracle or MS SQL databases). Created SSAS cubes. Persisted data in XML format using LINQ to XML conversion. Used LINQ to work with collections.
• Worked with PDF documents using PDFBox and IKVM libraries. CustomizedSharpZipLib open source library to archive/extract user’s database. Created installation packages utilizing open source WiX Toolset

Confidential, New York, NY

Sr. Programmer

Responsibilities:

• Enhanced and expanded Collection & Customer Service System (CCS) - lease administration application for credit card readers. CCS facilitates servicing active and delinquent accounts by automating processing of payments/ACH, notifications, referrals to Customer Service and Legal departments, providing ability to investigate and solve issues, offer loaner equipment, allow buyouts, process lease transfers, etc.
• Implemented nightly batch processing generating and distributing invoices (PDF generation using Fortis, zip, FTP, OSG Billing), lockbox processing (text and image files processing, persistence and integration into the billing systems). Each processing stage was tracked, recorded and reported via activity logs and notification emails.
• Created dynamic, end-user customizable screens. Improved application responsiveness by handling time-consuming database operations asynchronously (utilizing multi-threading). Created and modified Oracle tables and packages/stored procedures using SQL Navigator. Suggested and implemented an MS Excel generator process to simplify and automate the process of reports generation and modifications. Used reflection to ensure compatibility with a range of Excel versions. Used VB.NET to implement an SMTP client for use from heritage VB applications.
• Converted heritage VB6 WinForm application to VB.NET (with Oracle 10g at the back end moving to 11g). Developed com+ wrapper for existing WinForms to enable their invocation from .NET applications.

Confidential, NY

Sr. Programmer/Consultant

Responsibilities:

• Maintained and enhanced the document management system for litigation support (C#/MS SQL Server). The application extracted email metadata from Outlook and Lotus Notes files and saved them in the local database. The .tiff/.jpeg files were converted to .pdf documents and later OCRed on the third party server which generated text files. The information from these files was saved in the local database to make it searchable and easily extractable in the desired format. Utilized regular expressions to implement flexible business data extraction mechanism.
• Developed user controls using C# for display of custom dynamic charts using GDI+ (line, bar, candlestick types of plots) and GDI32 APIs. The controls facilitated viewing and analysis of stock trends in real-time trading systems.
• Designed and developed a number of MS Excel reports. Used VBA to create and format a variety of reports.
• Implemented new functionality and maintained intranet web site (VB.NET/ASP.NET/Infragistics controls).

Confidential, Jersey City, NJ

Sr. Programmer/Consultant

Responsibilities:

• Developed and supported Interlinx (a part of Windows-based client/server platform for eCommerce). Interlinx is a modular and scalable solution encapsulating all of the elements required to operate a successful ecommerce business. Added functionally to the existing and created new WinForms in the inventory management system using C# and DevExpress .NET WinForms Components. Stored information in MS SQL and XML files.

Confidential, NY

Sr. Programmer

Responsibilities:

• Developed and supported ACBS loan tracking application. ACBS LoanTrak is an enterprise-scale software application dat automates all the essential activities of a par or distressed loan trading desk - trade capture, real time position and P&L monitoring, mark-to-market, LSTA and LMA trading documents, workflow management for trade settlement, and reporting.
• Created and enhanced WinForms, reports, components, and web services. Ported VB6 modules into VB.NET and C# components using 3-rd party controls (DevExpress .NET WinForms Components and Component One FlexGrid). Developed reports (MS Excel, Active Reports). Enabled LoanTrak to send e-mails (MS Outlook or Lotus Notes).

Confidential, Parsippany, NJ

Programmer/Consultant

Responsibilities:

• Built an Employee Identification System for MTA Metro-North. Used ImageWare EPI Builder 6.0 suite to collect employee identification information, store it in the database and print ID cards (VB6, Oracle 9i). Controlled the ID card printer via winspool.drv and kernel32 APIs. Ported VB6 data entry forms and batches to VB.NET and C# WinForms.
• Enhanced and maintained Asset Management Account System (AMA) for AXA Financial using VB6 and MS SQL stored procedures. AMA has been designed to keep track of client accounts, including purchases of mutual fund shares, portfolio types, agencies information, AXA sales representatives, etc. Automated nightly batches monitoring.
• Implemented intelligent EDI files importing system. Recursively searched for folders and EDI files, repaired corrupted ones using kernel32 APIs (memory mapped files), parsed the files and stored the content in the database.
• Used Windows security APIs to read and manipulate accounts and associated permissions (advapi32).

Confidential, NY

Programmer/Analyst

Responsibilities:

• Created case-management system (mostly for car accident cases). Directly interacted with users to determine the requirements. The system kept track of the cases, generated status reports and reminders of key events, etc. The new legal document management system (VB6/ADO, Seagate Crystal Reports, MS Access for small or SQL Server for larger installations) dramatically speeded up the work of lawyers and their assistants (MS Word Templates, Rich-Text boxes, dynamically created form fields, clipboard APIs, MS Access, and other techniques)

Confidential, New Rochelle, NY

Programmer/Analyst

Responsibilities:

• Acted as a technical lead for a variety of in-house accounting applications. Collected raw data from external sources (utility companies’ web sites, NYC DOF Mainframe). Provided means for data storing, aggregation, viewing, as well as subsequent analysis and report generation (VB5/6, MS SQL Server, Seagate Crystal Report, MS Excel VBA, Win32 APIs, Attachmate "Extra " APIs, IE controls, ASP Mail, Imaging Professional VBA, WinFax PRO VBA, multi-page DunOrd scanner APIs). The system generated savings of more TEMPthan $1 million/year and facilitated the search for new potential clients (via analysis of the retrieved data).