ASP/NET/SQL Developer

MYKHAYLO KAPLUNOV 6 CHADWICK STREET 2ND FL APT GLEN COVE, NY 11542 MICHAILK2001@YAHOO.COM ************************************************************ OBJECTIVE: SEEKING STAFF POSITION AS A ASP/NET/SQL/ WEB DEVELOPER ************************************************************ COMMON SKILLS: C# - 6 YEARS VB 5.0/6.0/NET - 8 YEARS JAVASCRIPT - 4 YEARS AJAX - 4 YEARS WINDOWS SCRIPT HOST - 4 YEARS ASP.NET - 4 YEARS ADO.NET - 8 YEARS MS SQL SERVER 2000/2005 - 8 YEARS MS VISUAL WEB DEVELOPER 2005/2008 - 4 YEARS MS VISUAL STUDIO.NET 2005 - 4 YEARS ERP-SYSTEMS - 10 YEARS ************************************************************ SKILLS SUMMARY: - .NET : MS FRAMEWORK; C#; VB.NET; ASP.NET; ADO.NET. - DB/SQL: MS SQL SERVER; ACCESS; MYSQL; T-SQL; ORACLE. - WEB: AJAX; C#; JAVASCRIPT; VBSCRIPT; HTML; IIS; APACHE; PHP. - MODELING: RATIONAL ROSE; ERWIN; BPWIN; RUP; VISIO. - REPORTING: CRYSTAL REPORTS; REPORT SMITH; ACCESS REPORTS. - LEGACY SYSTEMS: WINDOWS SCRIPT HOST; FORTRAN; COBOL; MUMPS; PL/1; MSM; OS 360/370 (IBM360/370); RSX11M (PDP11); OPENVMS (VAX); FOXPRO. ************************************************************ EXPERIENCE: ************************************************************ JUN/06-PRESENT INTECH21 INC.,PORT WASHINGTON,NY POSITIONS: ASP.NET-DEVELOPER/INTEGRATED ENGINEERING  FULL SDLC FOR 3 ASP.NET PROJECTS "DISPLAY OF FREE ADDRESSES AREA FOR MEASURING SENSORS", "CONTROL SYSTEM FOR WAREHOUSING", "ADMINISTRATIVE TOOLS FOR CONTROL SYSTEM 'CHAS'": - WORKED CLOSELY WITH END USERS, GATHERED AND ANALYZED DETAILED BUSINESS REQUIREMENTS. - DESIGNED SYSTEM ARCHITECTURE BASED ON THE REQUIREMENTS, CREATED TECHNICAL SPECIFICATIONS. - DESIGNED DATABASE STRUCTURE, CREATED TABLES, VIEWS, CONSTRAINTS, INDEXES, STORED PROCEDURES AND TRIGGERS (MS SQL SERVER 2005, TRANSACT-SQL, STORED PROCEDURES). - WROTE SOFTWARE CODE TO IMPLEMENT BUSINESS LOGIC (MS FRAMEWORK.NET, MS VISUAL WEB DEVELOPER 2005,C#, TRANSACT-SQL, ADO.NET, JAVASCRIPT, AJAX, ASP.NET). - DEVELOPED ACTIVE SERVER PAGES FOR THE SYSTEM(IIS). - PREPARED TEST DATA SETS AND TESTED THE SYSTEM MODULES. - DID SYSTEM INTEGRATION OF CREATED SYSTEM WITH EXISTING WEB-SYSTEMS "NYCHA" AND "CITY". - DID SYSTEM INTEGRATION OF CREATED SYSTEM WITH CALIBRATED WORKING PLACES. - DID COMPLEX TESTING OF SYSTEM. - CREATED COMPLETE TECHNICAL, USER, AND SYSTEM DOCUMENTATION.  MAINTENANCE OF CONTROL SYSTEM 'CHAS' FOR NYCHA - ANALYZED CLIENT'S REQUESTS FOR SYSTEM CUSTOMIZATION AND BUG REPORTS; MODIFIED EXISTING CODE FOR BUG FIXES AND NEW BUSINESS RULES IMPLEMENTATION; DEVELOPED NEW MODULES AS NECESSARY (MS VISUAL WEB DEVELOPER 2005, MS VISUAL STUDIO.NET 2005, ASP.NET, C#, JAVASCRIPT, AJAX, T-SQL, ADO.NET, MS SQL SERVER, STORED PROCEDURES, IIS); DESIGNED AND DEVELOPED NEW DATABASE TABLES, STORED PROCEDURES, AND TRIGGERS TO IMPLEMENT CLIENT CUSTOMIZATIONS (MS SQL SERVER, T-SQL, STORED PROCEDURES, TRIGGERS); TESTED AND DOCUMENTED SYSTEM CHANGES AND ENHANCEMENTS.  DEVELOPMENT ASP.NET PROJECT "CALIBRATE SYSTEMS FOR DEVICES RE, KW". FULL DEVELOPMENT CYCLE. - WORKED CLOSELY WITH END USERS, GATHERED AND ANALYZED DETAILED BUSINESS REQUIREMENTS. - DESIGNED SYSTEM ARCHITECTURE BASED ON THE REQUIREMENTS, CREATED TECHNICAL SPECIFICATIONS. - DESIGNED DATABASE STRUCTURE, CREATED TABLES, VIEWS, CONSTRAINTS, INDEXES, STORED PROCEDURES AND TRIGGERS (MS SQL SERVER 2005, TRANSACT-SQL, STORED PROCEDURES). - WROTE SOFTWARE CODE TO IMPLEMENT BUSINESS LOGIC (MS FRAMEWORK.NET, MS VISUAL WEB DEVELOPER 2005, MS VISUAL STUDIO.NET 2005,C#, TRANSACT-SQL, ADO.NET, JAVASCRIPT, ASP.NET, AJAX). - DEVELOPED ACTIVE SERVER PAGES FOR THE SYSTEM(IIS). - PREPARED TEST DATA SETS AND TESTED THE SYSTEM MODULES. - DID SYSTEM INTEGRATION OF CREATED SYSTEM WITH PROJECTS "DISPLAY OF FREE ADDRESSES AREA FOR MEASURING SENSORS" AND "CONTROL SYSTEM FOR WAREHOUSING". - DID SYSTEM INTEGRATION OF CREATED SYSTEM. - DID COMPLEX TESTING OF SYSTEM. - CREATED COMPLETE TECHNICAL, USER, AND SYSTEM DOCUMENTATION. FRONT END TOOLS: ASP.NET / MS FRAMEWORK.NET / C# / JAVASCRIPT / AJAX / HTML /T-SQL / ADO.NET / XML BACK END TOOLS: MS SQL SERVER 2000/2005 ************************************************************** FEB/02 – MAY/06 INSTITUTE OF BUSINESS, BERDYANSK, UKRAINE POSITION: LEAD DEVELOPER/THE HEAD OF THE CHAIR "THE INFORMATION SYSTEMS AND TECHNOLOGIES"  LED GROUP OF 6 TO 8 PROGRAMMERS THROUGH THE FULL DEVELOPMENT CYCLE OF IN-HOUSE ERP-SYSTEM FOR CUSTOMERS OF THE MANUFACTURING DEPARTMENT - WORKED CLOSELY WITH END USERS, GATHERED AND ANALYZED DETAILED BUSINESS REQUIREMENTS. - DESIGNED SYSTEM ARCHITECTURE BASED ON THE REQUIREMENTS, CREATED TECHNICAL SPECIFICATIONS FOR THE DEVELOPMENT TEAM. - DESIGNED DATABASE STRUCTURE (RATIONAL ROSE, ERWIN), CREATED TABLES, VIEWS, CONSTRAINTS, INDEXES, STORED PROCEDURES AND TRIGGERS (MS SQL SERVER 2000, TRANSACT-SQL). - WROTE SOFTWARE CODE TO IMPLEMENT BUSINESS LOGIC (MS FRAMEWORK.NET, VB.NET, C#, TRANSACT-SQL, ADO.NET, WINDOWS SCRIPT HOST). - DEVELOPED ABOUT 40 REPORTS FOR THE SYSTEM CRYSTAL REPORTS, ADO.NET. - DEVELOPED PROGRAMMING INTERFACES BETWEEN THE VB.NET AND C# COMPONENTS OF THE APPLICATION. - PREPARED TEST DATA SETS AND TESTED THE SYSTEM MODULES. - CREATED COMPLETE TECHNICAL, USER, AND SYSTEM DOCUMENTATION. - WROTE SCRIPTS TO CONVERT LEGACY DATA FROM HIERARCHICAL MSM DATABASE TO THE RELATIONAL STRUCTURE OF MS SQL SERVER 2000. - DEPLOYED THE SYSTEM AT TWO AUTOMOTIVE MANUFACTURING FACILITIES.  DEVELOPED A NUMBER OF WEB-APPLICATIONS FOR THE AUTOMATED CONTROL SYSTEM FOR THE MANUFACTURING DEPARTMENT: - ASP.NET WEB-APPLICATION FOR THE SCHEDULING SYSTEM (ADO.NET, MS SQL SERVER, IIS). FULL DEVELOPMENT CYCLE. - PHP WEB-APPLICATION FOR WAREHOUSE MANAGEMENT (PHP/MYSQL, HTML, APACHE). FULL DEVELOPMENT CYCLE. WROTE SCRIPTS TO TRANSFORM DATA FROM MS SQL SERVER 2000 TO THE STRUCTURES OF MYSQL. -• ASP WEB-APPLICATION FOR THE TECHNOLOGICAL SYSTEM (HTML, VBSCRIPTS, ADO, MS SQL SERVER, IIS). FULL DEVELOPMENT CYCLE.  DEVELOPED AND IMPLEMENTED THE IN-HOUSE ERP-SYSTEM FOR SMALL BUSINESSES INCLUDING THE FOLLOWING MODULES: WAREHOUSE, CASH MANAGEMENT, ACCOUNTS PAYABLE, ACCOUNTS RECEIVABLE - VB6.0, MS ACCESS): - DESIGNED THE SYSTEM ARCHITECTURE (RATIONAL ROSE); - DESIGNED THE DATABASE STRUCTURE (RATIONAL ROSE, ERWIN). CREATED TABLES, CONSTRAINTS, INDEXES (MS ACCESS); - WROTE CODE TO IMPLEMENT DATA INTERFACES AND BUSINESS RULES (VB6.0, ADO); - PREPARED TEST DATA, TESTED PARTS OF SOFTWARE, CONDUCTED INTEGRATION TESTING OF THE SOFTWARE; - TESTED AND DEPLOYED THE SYSTEM AT THE CLIENT’S SITE. FRONT END TOOLS: MS FRAMEWORK.NET / VB.NET / TRANSACT SQL / ADO.NET / ASP.NET / CRYSTAL REPORTS / VB6.0 / PHP / HTML BACK END TOOLS: MS SQL SERVER 2000 / ACCESS / MYSQL ********************************************************** FEB/99 – NOV/01 MIRACLE SOFTWARE GROUP, LANGENHTAL, SWITZERLAND POSITION: PROGRAMMER / ANALYST RESPONSIBILITIES: MAINTENANCE, DEVELOPMENT AND IMPROVEMENT TO THE EXISTING "MIRACLE" ERP-SYSTEM (PARTICIPATED IN WORK OF DEVELOPERS TEAMS – ACCOUNTS RECEIVABLE, ACCOUNTS PAYABLE, PURCHASING, SALES, PRODUCTION CONTROL) - ANALYZED CLIENTS’ REQUESTS FOR SYSTEM CUSTOMIZATION AND BUG REPORTS. - MODIFIED EXISTING CODE FOR BUG FIXES AND NEW BUSINESS RULES IMPLEMENTATION, DEVELOPED NEW MODULES AS NECESSARY (VB 6.0, MIRACLE SOFTWARE VB EXTENSION, MS SQL SERVER). - DESIGNED AND DEVELOPED NEW DATABASE TABLES, STORED PROCEDURES, AND TRIGGERS TO IMPLEMENT CLIENT CUSTOMIZATIONS (MS SQL SERVER, TRANSACT-SQL). - DEVELOPED GENERIC AND CLIENT SPECIFIC REPORTS (CRYSTAL REPORTS, REPORT SMITH, ADO, MIRACLE SOFTWARE REPORT GENERATOR). - TESTED AND DOCUMENTED SYSTEM CHANGES AND ENHANCEMENTS. - MIGRATED EXISTING ORACLE DATABASE OF CLIENT INTO THE PROPRIETARY MIRACLE SOFTWARE DATABASE. - IMPLEMENTED THE MIRACLE SOFTWARE SYSTEM ON 4 MACHINERY PLANTS IN SWITZERLAND, INCLUDING OMAN, FREZA, NOSTALGI, AND NESKE. FRONT END TOOLS: VB6.0 / TRANSACT-SQL / CRYSTAL REPORTS / REPORT SMITH BACK END TOOLS: MS SQL SERVER ************************************************************* EDUCATION / DEGREES MSCS LETI ST.PETERSBURG UNIVERSITY OF TECHNOLOGY MAJORING IN SYSTEM DESIGN SAMPLES OF WORK ARE AVAILABLE COMPENSATION REQUIREMENT - $80K PLUS BENEFITS

Application Support

Glen Cove, NY