Enterprise Architect Resume.

April 2009 – Present. Microsoft/Razorfish

Enterprise Architect

Project:

SEO Feeds ¨ Solution Architect

Architected and led team of developers designing feed management platform based on Biztalk Server 2009 cluster. Highly scalable solution allows efficiently retrieve, process and deliver shopping feeds with hundreds of  thousands products to the search shopping engines.  Frontend is ASP.NET with extensive use of Telerik UI library and SQL 2008 SSRS, middle tier run on the Biztalk 2009 message broker and backend is SQL Server 2008 with Linq-to-SQL ORM.

Project:

Rank Source¨ Enterprise Architect

Redesigned existing internet scraping application to became highly scalable and distributed  across internet nodes. Led effort of transforming existing Service Bus architecture to Cloud based. Analysed and benchmarked competitive designs against Windows Azure and Amazon EC2 implementations. Improved overall system stability and manageability to be able produce 24x7 results as well as instant ad-hock scans. Optimized BI performance transforming existing data warehouse to OLAP SSAS based reporting.

January 2006 – March 2009. Associated Press

Solution Architect

Project:

AP Hosted¨ Solution Architect/Technical Lead

Architected and led distributed team of developers for the AP Hosted platform. The platform allows customers to design their sites and incorporate extensive AP content into the pages. AP hosts thousands sites for newpapers with custom branding and content provided by AP. The application integrates data from multiple data sources (AP, Morningstar, Sunguard) is a management façade for internal services and SQL Server database.  The presentation layer is implemented in ASP.NET with ExtJS/Ajax for dynmic user experience, business layer is a combination of .Net windows services and Biztalk 2006 content processing.

*      Project:

eAP Administration ¨ Technical Lead

Led the design and implementation of Customer and Product management application. The application is a management façade for internal services and SQL Server database.  The presentation layer is implemented in ASP.NET, business layer implemented in c#.

*      Project:

Compression Service ¨ Solution Architect/Technical Lead

Designed and implemented highly scalable Compression service and download provider to centralize content compression functionality and provide SOA façade for internal applications. Service implemented in c# with .Net 3.0 WCF (windows communication foundation) used for messaging.

July 1999 – present WebIntellics Inc.

Founder

*      Project:

Optionist ¨ Solution Architect

Designed and led implementation of the stock options research application, which reflects fundamental, technical   and social aspects of trading. It integrates historical stock and options data from Google and Yahoo financial APIs, 3^rd party pre-screens, charting and Twiter sentiment analysis into a single view. Silverlight frontend, loads data through the webservices façade. Data collecting backend is a combination of windows services, feed adapters and SSIS processing packages to collect and process data in SQL 2008.  

*      Project:

NHS Integration ¨ Integration Architect/ Technical Lead

Designed and led development team in implementation of the business integration solution for the NHS. System is based on the BizTalk 2002 Integration platform and connects internal Great Plains and various custom data sources to the Blue Cross, Verizon and ADP. Designed business workflow, custom BizTalk 2002 adapters and COM+ business objects to extract data, convert it to the vendor specific EDI format and deliver to the partners.

*      Project:

DbToXml application ¨ Application Architect

Designed and implemented unique integration application. The template driven code generator produces xml, xsd, BizTalk 2002 schemas and complete data access layer ready to be integrated with the BizTalk AIC. It uses an ODBC compliant data source for the data model of the application. DbToXml can generate data layer in a variety of programming languages: C#, Java, Vb.NET and Vb6.0.  The application is successfully marketed with over 20,000 downloads and the number is growing.

Project:

SSIS Documenter¨ Application Architect

Designed, implemented and delivered to over 10,000 users SQL Server 2005/2008 SSIS Documentation solution, which generates SSIS documentation. , SSIS Documenter is integrated into SQL Server Business Inteligence studio and provides command line interface for easy integration with MSBuild in CI environments. Application is implemented in .Net C# Win-Forms.

DTS Documenter¨ Application Architect

Designed, implemented and brought to the market a SQL Server 2000 DTS documenting solution, which generates DTS documentation, xml export, administrative overview of the package and detail package call graph to help DBA analyze, document and improve the collection of the DTS packages. DTS Documenter is implemented in .Net C# Win-Forms.

July 2000 – December 2005. Cross Current Inc

Application Architect

*      Project:

CNET (Crime Network RMS) ¨ Application Architect/ Technical Lead

Led the design and implementation of the CNET record management solution for Pensylvania Government. The solution is a highly scalable, redundant and configurable application, implemented on the .Net platform. It delivers rich web interface with word processing, image management, and pdf reporting and notification capabilities. It integrates data and interfaces with multiple government agencies. The presentation layer is driven by ASP.NET and the business layer is implemented using C#, .NET, XSL. The database layer is SQL Server powered by fully redundant Stratus server. Application is deployed in PA and actively used by several hundreds of government agencies.

*      Project:

Justice Hub ¨ Integration Architect/ Technical Lead

Designed and led implementation of the Justice Integration solution. The BizTalk 2002 driven SOA system connects multiple county departments and delivers single point of administration, data retrieval, notifications and data exchange. The integration components are implemented in C#. The presentation layer is ASP.NET and C#. The business layer is decoupled with the secure web service implementing WSE 3.0. The data layer consists of COM+ components written in C#. The system Integrates multiple data sources driven by Oracle 9i, SQL Server 2000 and DB2. Local messaging is implemented using MSMQ, and external data exchange is JMS implementation over the MQSeries transport layer. System architectural design performed in Borland Together with UML 2.0

*      Project:

Victim Witness Management System ¨ Application Architect/ Technical Lead

Designed and led implementation of a 3-tier case management solution for the juvenile probation. The application is implemented in ASP.Net and C#. It is responsible for the data manipulation, business workflow and user collaboration. It produces various notifications (email, pager and WinWord documents to be printed and send by regular mail) and a number of statistical reports.

*      Project:

Query Controller ¨ Integration Architect

Designed and implemented a Query Controller application. The Query Controller is an integration component capable of executing xml queries against arbitrary data sources. The system is a chain of specialized components responsible for logging, message transformation, response correlation, response analysis and notifications. This integration component was optimized to submit EDI queries to the NCIC based RMS system and deliver xml response to the requesting application. The controller is implemented in C# and uses MSMQ and MQSeries as source and destination transports accordingly.

*      Project:

Map Solution for the CAD application¨ Application Architect

Designed and led implementation of the mapping solution for the Computer automated dispatcher application. The .Net/C# application incorporates ESRI mapping engine to process the GIS data.  The application is a real time monitor for the police, EMS and fire activities. Technologies used: .Net Remoting for messaging and GDI for rendering the GUI layer. GIS data is managed by ESRI SDE Server, which uses SQL Server 2000 as backend.

*      Project:

Sentencing application

Designed and led implementation of a 3-tier case management solution. The application is implemented on the J2EE platform. It uses Tomcat application server. Presentation layer is designed using Struts/StrutsCX xml transformation engine, database layer is powered by the Hibernate persistence engine. The business layer utilizes the Spring container manager. System architectural design performed in Borland Together with UML 2.0

*      Project:

OneChem Integration. ¨ Integration Architect/ Technical Lead

Architected and led SOA implementation of B2B xml-based document exchange application based on the WebMethods Integration platform. MS SQL server 7.0 and Oracle 8i were used as Database backend. Business logic was implemented in the server based COM+ objects. WebMethods B2B application server was used to control the business flow, routing of the XML documents, data validation and transformation. Designed several custom WebMethods adapters for data retrieval, processing, email notification and generic proxy adapters to access COM+ based business layer from WebMethods B2B Server.

January 1999 – July 2000 WebSci Technologies Inc, NJ, USA.
As consultant for AT&T, Voice Response Solutions

*      Project:

Pay for performance ¨ Technical Lead

Implemented a Call Center application that delivers voice and data to customer care agents and gives full call control over information from the java based GUI. Enhanced Computer Telephony Interface server to generate the information on the agent performance. The server receives and analyzes call information and control messages from the Interactive Voice Response system and the Call Data Control (CDC) client applications, loads agent activity records to the Oracle database to generate reports on Agent efficiency. Was responsible for developing server programs using C and ASAI Calls (PBX) interface, the application utilizes UDP protocol and message queues for exchanging data, developed interface programs using PRO*C, SQL*PLUS, PL/SQL and UNIX Shell scripts and Generating WEB reports using PRO*C and DHTML. Unix scripts were written using Korn shell and Perl. The RDBMS used was Oracle 7.3.

*      Project:

Texas Local Factory IVR System ¨ Technical Lead

The conversant voice information system is AT&T's premium platform for providing interactive voice response solutions to the customers. The objective of the system is to automate most functions performed by customer relations agents. Led the team of 4 developers implementing client server solution on Unix System IV platform. The multi-threaded servers and C-Motif based GUI soft-phone application exchange real-time messages by UDP to automate business workflow of the call center. The system generates statistical reports.  Technologies used: Unix, C, Motif, perl, Oracle 7.3, Crystal Reports.

*      Project:

CDC Java rewrite ¨  Technical Lead

Led the development team in design and implementation of Java-based client-tier CDC application which initially was developed in C/Motif. Extensive use of java Swing for the user interface; message exchange was implemented over the UDP transport layer.

October '97 - January 1999:
Consultant for AT&T Teleconferencing:

*      Project:

Billing filter Korn Shell based¨ Technical Lead

Changed and improved existing billing filter for teleconferencing service. Wrote a number of reporting scripts to access Sybase Database from Korn Shell. Scripts were based on Sybase isql and c-programs that access to Sybase Database throw Sybase DB-library. Developed c-programs that correct records with logical and validation errors, and perform other manipulations with float files.

*      Project:

Translation of Billing filter to C++ ¨  Technical Lead

Designed and developed C++ MFC-based application dedicated for manipulation with flat files and data from Sybase Database. Created architecture for data processing and general workflow of the user interface. The application lets correct, sort, browse and edit information and generate statistical reports. It improves and expands facilities of existing Korn Shell based billing filter. Advanced, user-oriented interface was designed to speed up and improve quality of data processing. Development was done with Microsoft Visual C++ and Sybase Db-library.

*      Project:

Porting of existing software from Sybase to Oracle ¨ Technical Lead

Actively participated in translation of existing programs and scripts, due to the platform upgrade from Sybase to Oracle. Ported numerous of shell-based scripts to make them available in Oracle 7.1 environment and SQL Plus. Upgraded C++ based software from Sybase db-library to Oracle PRO*C and OCI. Created and optimized stored procedures and triggers for quick data processing. Performed SQL tuning and data-modeling. Client front-end was WinNT 4.0; server side was SunOS 5.6.

January '94 - October '97: St.Petersburg National International Phone, St-Petersburg, Russia.

Software Engineer

*      Project:

White Page Business Directory ¨ Sr. Developer

As a team member participated in design and implementation of the system, which accesses to the detail information on a specific business. System utilizes 3-tier architecture with Sybase as database-tier, middle-tier server and presentation-tier implemented in three modes: web client, UNIX terminal client, windows client. Led a team of 5 programmers in design and implementation of server side, web and Unix clients. Developed C-based CGI scripts. Server side application was implemented in C++ and uses Sybase Db-library. The client applications submit various queries and retrieve business details and call history information. The server was a Sun SPARC station’s machine running Solaris 2.5.1. Sybase was the RDBMS used. Initially the system was developed using Empress RDBMS but later was ported to Sybase. Also was involved in Data-modeling and database optimization using RWin.

*      Project:

Conversion from Empress to Oracle ¨ Developer

Shared responsibility for overall application conversion from Empress to Oracle driven data layer. This involved extensive coding using Oracle PRO*C, Oracle OCI and Oracle Forms. Converted most Empress reporting programs to Oracle PRO*C. Used C/C++ extensively to add new functionality of existing programs. Installed and administered Oracle RDBMS 7.1 on Data General UNIX platform. Did performance tuning, wrote scripts to download data from Empress database to flat files and then from flat files into Oracle Databases.

Sun Certified Enterprise Architect