SUMMARY:

Strong professional experience in design, development, and support of business and engineering applications (includes object - oriented and database design). Ability to collect business requirements, translate them into project 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).

DBMS: Access 2003, 2007, 2010; MS SQL Server 7.0/2000/2005/2008 , 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, SSRS, Attachmate "Extra " 6.3, Imaging Pro 2.0, ImageWare EPI Builder 6.0, Visual InterDev 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.

PROFESSIONAL EXPERIENCE

 Sr. Programmer 

• Enhanced and expanded Collection & Customer Service System   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.
• Implemented nightly batch processing generating and distributing invoices (PDF generation using Fortis, zip, FTP), 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.
• Oracle tables and packages/stored procedures using SQL Navigator. Used LINQ to work with collections. Suggested and implemented an  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.

 Consultant 

• Developed components of XP3  a dynamic data processing, data analysis and presentation/reporting software solution that helps organizations transform data into actionable insights conveyed through interactive Microsoft PowerPoint Presentations and Excel Reports.
• Developed  Excel &  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 heritage VB6 and C++ COM modules in C# and adapted them for use in different versions of Office.
• Implemented an interactive  to facilitate user’s interaction with the system (C#, WinForms, DevExpress Controls).
• Worked with 3D data cubes using MDX and ADOMD to obtain  (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).
• Persisted data in XML format using LINQ to XML conversion.
• Designed  reports and rendered them using Report Viewer control.
• Worked with PDF documents using PDFBox and IKVM libraries.
• Customized  open source library to archive/extract user’s database. 

Confidential, Brooklyn, NY

 Sr. Programmer/Consultant 

• 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.
• Ported a car tracking application written in VB 6.0 to MS Access 2007.
• 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 and developed a number of  Excel reports. Used  to create and format a variety of reports.
• Customized and created new reports (SQL Reporting Services and  Excel). Provided troubleshooting of slow-running queries using Estimated Execution Plan. Modified and optimized stored procedures, functions, and views ( SQL 2008) in tandem with C# code according to new requirements and to improve performance. Wrote scripts to create tables, indexes, and databases. Created packages.
• Implemented new functionality and maintained intranet 

 Sr. Programmer/Consultant 

• 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.
• Application utilized SQL Server Reporting Services and Excel VBA to generate report in the form of pdf files or Excel workbooks that could then be automatically distributed via e-mail.
• 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.

 Sr. Programmer 

• Developed and supported  loan tracking application.
•  Loan is an enterprise-scale software application that 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 ( Excel, Active Reports).
• Enabled LoanTrak to send e-mails ( Outlook or Lotus Notes).

 Programmer/Consultant 

• 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  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.
• Developed data entry forms. Automated nightly batches monitoring.
• Implemented intelligent EDI files importing system.
• Recursively searched for folders and EDI files, repaired corrupted ones using 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.