|
|
Dennis
Gorelik E-mail:
|
You
describe your business problem – I deliver technical solution. Fast and
reliable.
Demo
Please, take a look at the web site that I architected and developed: www.postjobfree.com
Ask me:
- Why I used ASP.NET 2.0 and Membership provider and how it helped to keep users passwords reliably encrypted.
- Why I used SQL Server 2005 and how it helped to create high performance web site with Full-Text search.
- What tiers I used for this web application and how chosen architecture helped to improve maintainability and performance of the web site.
- How I setup data exchange with other web sites through XML web services.
- How I accomplished regular web sites changes deployment without interruptions in web site work (which is 24/7 service).
- How I integrated Google Maps API into www.postjobfree.com
- How I improved web site usability.
- How I tracked web site performance and usage.
- How my experience can be applied to your project.
Background
Senior ASP.NET 2.0 Developer/Architect/Team Lead. Over 10 years of experience in analysis, design and software development.
Full system life cycle experience: design, coding, testing, bug fixing, deployment, documentation and maintenance.
Preferences in Agile/RAD methodologies.
Technical skills
Languages: C# 2.0, VB.NET, T-SQL (DDL, DML), VB script, JavaScript, HTML/DHTML, XML (XSD, XDR, XSLT), UML.
Technologies: ASP.NET 2.0, ADO.NET 2.0, XML Web Services, Remoting, .NET Provider model, Unit test, …
Databases: MS SQL Server, Oracle, DB2 …
Development Tools: Google Search, Visual Studio.NET 2005 Team Edition, Microsoft SQL Server Management Studio, Nant, Toad VI, Rational ClearQuest, MS Visio, XML Spy, XSelerator, MS Office, Google Maps API.
Web Development: ASP.NET 2.0, XML Web Services, IIS, JavaScript, HTML, DHTML, CSS, Themes, XML/XSLT.
Reporting Tools:
Version and Source Control: TFS, Visual Source Safe, Subversion, VisualSVN, MKS, SourceOffSite,...
Operating Systems: Windows Server 2003, MS Windows XP/2000/NT, Windows 95/98/Me, Windows 3.xx, MS DOS.
Employment history
September 2005 - Present. Senior ASP.NET & database developer, National Flood Services, Kalispell, MT
http://www.nfsmt.com/ - the company works in flood insurance business.
Conversion from Legacy system (AS-400/DB2/VB6/ASP/ASP.NET/MS SQL2000) to new ASP.NET 2005 / MS SQL 2005 application.
Tools & Technologies: ASP.NET 2.0, VS.NET 2005, C# 2.0, Generics, Provider Model, User Controls, Master pages, GridView, Web parts, ADO.NET, Web Forms, XML Web Services, MS SQL Server 2000, Validation controls, JavaScript, HTML/DHTML, CSS, VSS, Web Forms.
Achievements:
· Data Warehouse: Architected
and developed system that imports data from legacy database (DB2) in form of
flat files. Incoming data is parsed, scrubbed for errors, and loaded into final
database in denormalized form for fast reports performance.
· Data
Correction Application: Designed and developed application that allows to
review and fix incorrect data that was imported into Data Warehouse (Winforms,
C#, Web Services, SQL Server 2005).
· Insight
Reports: Architected and developed web application for report requests – users
can customize reports according to their requirements (ASP.NET 2.0, MS SQL
2005, Web Services, JavaScript, HTML/DHTML, DB2, SQuirreL SQL 2.1).
·
Developed custom Membership and Role providers to access legacy database
(ASP.NET 2.0, Provider Model, MS SQL 2000, DB2).
·
Developed custom localization provider (C# 2.0, Reflector.
Namespaces: System.Reflection,
System.Resources, System.Web.Compilation, System.IO).
· Developed User Management system + Web site administration (MS SQL 2005, ASP.NET 2.0 Login controls).
· Developed several Flood Service providers (C# 2.0, HttpWebRequest).
· Developed UI for testing various Flood Service providers (ASP.NET, C# 2.0, GridView, ObjectDataSource, Session, ViewState).
· Helped others to solve their technical problems.
June 2005 – August 2005. Senior ASP.NET developer, IBM
Global Services, Indianapolis ,
IN
This is fast paced project for Wells Fargo bank (http://www.wellsfargo.com/). The project was about making web portal for managing vendor-evaluation scorecards.
Snapshots: http://www.dennisgorelik.com/resume/IbmGlobalServices
Tools & Technologies: ASP.NET, C#.NET, ASP.NET User Controls, ADO.NET, Web Forms, MS SQL Server 2000, Validation controls, JavaScript, HTML/DHTML, CSS, VSS, RapTier codegenerator.
Achievements:
· Analyzed business requirement.
· Defined technical details of the solution.
· Developed scorecard template functionality edit/view/report (ASP.NET, C#, MS SQL, Stored Procedures, RapTier, CSS, HTML).
· Implemented making and handling web-page snapshorts in “Web archive, single file (*.mht)” format:
- Developed functionality for saving web pages snapshots into database (used CDO functionality).
- Developed functionality for viewing saved snapshots.
· Saved images into database and showed images from database on web pages.
· Implemented Scorecard View with dynamical load of heterogeneous user controls into the web page.
· Developed several appendices for Scorecard functionality:
- Designed database tables.
- Created stored Procedures / Views / User defined functions
- Created middle-tier DB classes (C#).
- Created AppendixControl_Base.cs as a base for “Appendix” user controls. This base class was used by me and other developers in the team.
- Created user controls (*.ascx / C#).
· Tested, fixed, and modified application according to changes in user requirements.
December 2004 – June 2005. Senior ASP.NET developer, Cendant Mobility, Danbury, CT
http://www.cendantmobility.com/
Tools & Technologies: ASP.NET, C#.NET, ASP.NET User Controls, ADO.NET, Web Forms, Win Forms, MS SQL Server, Remoting, Validation controls, JavaScript, HTML/DHTML, CSS, Nant, VSS.
· Analyzed business requirements.
· Developed Template Request module (ASP.NET, C#, JavaScript, ADO.NET) and integrated it with existing application https://atlas.cendantmobility.com/.
o Template finder.
o Multiple container pages.
o Various template list screens with "multiple rows add" and "multiple rows remove" functionality (ASP.NET, JavaScript). (“Template associations”, “Template list”).
o “Update” screens (document template update, package template update).
· Developed ASP.NET User controls, including:
o Template list ASP user control - with Middle tier call, page navigation (paging), and sorting all columns.
o Navigation ASP user control.
· Created unit tests (WinForms).
· Used the following techniques:
o Nested pages (iframe), including nesting iFrames.
o Popup pages (Template finder, Product selection)
o Style sheets (*.css)
· Analyzed stored procedures.
· Set up Nant --- tool for automatic build generation (for daily build).
· Helped other developers to solve technical problems.
August 2004 – December 2004. Senior ASP.NET developer, MPS Group, Jacksonville, FL
“Knowledge Spring” web portal project development.
Developed portlets(ASP.NET user controls) for multi-tier web system.
Tools & Technologies: VS.NET, ASP.NET, User Controls, Portlets, Repeater, DataList, Validator Controls, JavaScript, C#.NET, VB.NET, WebForms, WinForms, Oracle 9.2, LLBLGen Pro Engine, Toad VI, SQL Plus, VB Script, PL/SQL script, ADO.NET, XML Web Services, MS VSS 6.0d, ComponentArt TreeView.
Projects:
· Directory Browser (recursive browsing through database items +
Properties PopUp)
· MessageSet Editor & Message Editor (used repeater and Cute
Editor control)
· Role Editor, UserSelectionControl, Actions Editor PopUp
· Attribute Editor, Portlet type editor, User Control editor, Item
Types editor, DomainMappings editor, Audiences editor, Actions editor
(repeater, JavaScript including passing data between main and popup windows,
Web Validation Controls)
· SubstitutionVariables editor (used RegEx expressions)
· FileReportViewer (including NTFS permissions check through Advapi32.dll and Kernel32.dll API)
· Developed Windows services (C#).
· Developed win forms test app.
· Site Directory View 3-layers tree (ComponentArt TreeView).
· Configurations loading (VB Script, PL/SQL script, *.lst files).
May 2004 – July 2004. .NET architect, Yellow Pepper, Boston , MA
Tools & Technologies: VS.NET, ASP.NET, C#.NET, VB.NET, WebForms, WinForms, MS SQL 2000, ADO.NET, XML Web Services, MS Visual Source Safe, Groove.
Projects:
· Shazam web service wrapper.
· SMS Tracker – tracks information about SMS messages delivery.
· SMS Games – games based on sending/receiving SMS text messages to/from cell phone.
· Phone number look up – look up information about specified phone number (Carrier, Gate, IsWireless, City, State, Country, Switch).
August 2003 – April 2004. Senior .Net Software developer, Wurzburg, Memphis, TN
Tools & Technologies: ASP.NET, C#.NET, WebForms, WinForms, MS SQL 2000, ADO.NET, Microsoft Application Block, Remoting, Crystal Reports, XML Web Services, User controls, Server Controls, MS Visual Source Safe, MS Project, MS Visio.
Projects: Development of various functionalities for warehouse project.
Web-site
security
Designed and developed security framework for the web application: User authentication and authorization, Cross-applications calls.
UPS
address validation project
Designed and
developed mail address validation program. The program interface is exposed
through web-page interface (and .csv file) and through XML Web Service (http://www.wurzburg.com/UPS/UpsValidation.asmx).
Technologies: ASP.NET, IIS, C#, XML,
XML Web Services.
The program prepares XML-request and send it to UPS.
The program is based on UPS EDI functionality exposed here:
https://www.ups.com/ups.app/xml/AV
Reports
project
Developed various business reports. Reports are provided in PDF-format, HTML-format, and can be printed directly to the specified printer. Reports functionality is exposed as to end users (through web-pages) as to other developers (in form of XML web services).
Catalogue
project
Designed catalogue module, including ASP.NET and MS SQL database design. Developed shopping card functionality.
Label
printing project
Designed and developed program to print
bar-code labels. Program is tightly integrated with the company’s database. For
instance, user which prints a label is associated with it’s own label printer.
Technologies: IIS, ASP.NET, C#,
Crystal Reports, ADO.NET, MS SQL Server 2000 (stored procedures, views,
functions), IE 6.
Deployment
Worked out fast and reliable deployment method. This method allows to deploy development changes to Production every day. Automated deployment SQL-script preparation.
In case of emergency deployment can be made even more often (in extreme cases up to 4 times per day).
Technologies: VS.NET, Database project, VSS, ASP.NET.
Performance
After initial prototyping and user evaluation I improved performance of "bottle-neck" applications. Modified SQL-queries, used MS SQL Query analyzer and SQL Profiler.
Other
responsibilities
Was responsible for managing project documentation and for Visual Source Safe administration.
April 2003 – August 2003. Team leader. Global Consulting
Group, Cincinnati , OH
Tools & Technologies: Visual Studio .NET, VB.NET, C#.NET, WebForms, WinForms, ADO.NET, MS SQL 2000, MS Visual Source Safe, MS Project, MS Visio.
Responsibilities: Lead team of 3 developers.
Achievements:
· Analyzed business requirements.
· Designed application architecture.
· Wrote technical specification.
· Coached team members.
· Implemented logical and physical database design.
· Created SQL-queries (T-SQL).
· Developed web UI forms (ASP.NET, WebForms).
· Implemented data exchange (ADO.NET).
· Created business components (C#.NET).
· Created reports (Crystal Reports 9.0).
· Created XML Web services.
· Created XSL transformations.
May 2002 - April 2003. Application Developer, Scala
Tools & Technologies:
Visual Studio.NET, VB.NET, ASP.NET, WinForm, WebForms, Visual Basic 6.0, MS XML Parser, SOAP, Crystal Reports, MS SQL Server, Oracle, VC++, VB Script, Syncro VSS, Source of Site and Visual Source Safe for version control.
MS Project for time tracking.
Benjamin (http://benjamin.scala.se/) - for tracking bugs and features.
MS Office, Rational Rose diagrams – for
documentation purposes.
Responsibilities: Migration of legacy VB6 application into new .NET application. Reports development, XML services
development for ERP (Enterprise Resource Planning) system. Retail sales,
Warehousing, and Accounting modules development.
· Converted existing VB6 application into VB.NET application.
· Developed WinForms (VB.NET).
· Developed WebForms (ASP.NET).
· Implemented business logic
(VB.NET).
· Created and modified
SQL-queries.
· Developed several XML
services for iScala (see: http://www.scala.net/scalasap/scalasap.asp):
· Created XSD, XDR schemas
and XML samples. (Used XML Spy http://www.xmlspy.com/).
· Created XSLT
transformations. Used Xselerator http://www.vbxml.com/xselerator/.
· Created business reports (Crystal Reports).
· Created and maintained tools for development process:
o Universal AutoTest program for testing iScala XML-services.
o Wrote documentation for AutoTest program.
o XML validator – allows quick checking is XML document valid or not.
o XML service registrator –
copies all necessary components of specified XML service on tester’s computer
and registers them under COM+ server.
· Created and modified type
libraries (*.idl, *.tlb).
· Designed Work Flow
diagrams for iScala.
October 2001 - April 2002: System analyst/Software
developer, Egar Technology Corporation
Tools
& Technologies: MS SQL 2000, VB 6.0, Data
Environment, ADO, Far Point Spread 2.5 (data grid), Crystal Reports 8.0, VSS
6.0, Visual InterDev 6.0, ASP, Rational ClearQuest and MS Outlook.
Responsibilities:
Development of the Collateral module for financial
system. Data Modeling. ER-diagrams (ERwin).
Full Application consists of more than 300
database tables, 200 views, 500 stored procedures, 1000 VB-forms and modules
Achievements:
· Developed Back End of the
Collateral module (tables, constraints, views and stored procedures).
· Developed VB user
interface (Designed client forms and wrote VB-code).
· Created various financial reports (Crystal Reports 8.0).
· Developed Web interface
(ASP).
· Wrote SQL-script for
database deployment on customer computer.
· Used Rational ClearQuest
to track defects and change requests.
· Used Visual InterDev for
DB-scripts (SP and view) handle and version tracking and control via VSS.
November 2000 – September 2001: Software developer, Granat
International Inc., Cleveland, OH
http://www.granatinternational.com/
VB 6.0, MTS, Visual Source Safe 6.0,
InterDev, IIS, ADO, MS SQL 7.0 (MS SQL Query Analyzer, MS SQL Enterprise
manager), Microsoft Transaction Server 2.0, Crystal Reports 8.0, VB-script
(MS-Word 2000), Windows 2000.
Project: Loan
Inventory Control System. Migration from Clipper to VB6.
Application consists of more than 200 forms
and reports. It is 3-tier application.
Responsibilities:
The task was complete transferring the
business logic from the existing file-server application (AS400, Clipper) to
the Windows 3-tier architecture. Customer is the “Leader Mortgage” co.,
Achievements:
· Investigated behavior of
DOS-application and its source code (Clipper).
· Created DTS-package for
conversion *.dbf into MS SQL database.
· Developed SQL-queries and
business logic (COM+ components).
· Created reports (Crystal
Reports 8) and forms for view and update database information.
· Developed VB-script (MS Word 2000), which helps to convert large fragments of clipper source code to VB code.
· Developed VB-script (MS
Word 2000), which helps to convert large fragments of clipper source code to VB
code.
· Developed Web interface
(ASP).
January 1998 - October 2000: Software developer/System
Analyst, Joint Stock Company Guard ,
Russia
Tools & Technologies:
MS SQL 7.0, Visual Basic 6.0, Visual
InterDev 6.0, ASP, ADO, True DB Grid, MSDN Library, MS Office, MS Access, IE
5.0, HTML, DHTML, Windows 98, Windows 2000.
Responsibilities:
Business process analysis, design,
development, testing, upgrade and maintenance application for account orders,
customers, salary calculation and other working information (VB 6.0 + ASP + MS
SQL 7.0).
Achievements:
· Analyzed business processes.
· Designed application architecture.
· Designed Database
structure, user interface, logical structure of project, server logic (2-tier
model).
· Used MS SQL Enterprise
manager for creation tables and database diagrams and MS SQL Query Analyzer for
design and debugging views and stored procedures.
· Deployed project and
trained end users.
· Developed utilities for
program support and administration.
· Dynamic-content web-site.
June 1996 - December 1997: Software developer, Design
Bureau Rotor, Russia
Tools & Technologies:
Microsoft Access, Access VBA, SQL queries, Access forms, MS Excel, Excel VBA.
Responsibilities:
Development of a salary accounting application.
Certification
Microsoft
http://www.microsoft.com/learning/mcp/transcripts
Transcript ID: 663106
Access Code: dennisgorelik
· 070-320 exam (Developing XML Web Services and Server Components with
Microsoft Visual C#.NET and the Microsoft .NET Framework).
Score: 981.
· 080-316 exam (Developing and Implementing Windows-based Applications
with Microsoft Visual C#.NET and Microsoft Visual Studio.NET).
Score: 917.
· 080-315 exam (Developing and Implementing Web Applications with
Microsoft Visual C#.NET and Microsoft Visual Studio.NET).
Score: 916.
Brainbench
· 2004 Brainbench certification ASP.NET.
· 2004 Brainbench certification C#.NET.
· 2004 Brainbench certification VB.NET.
(http://www.dennisgorelik.com/resume/BrainbenchNetCertification.htm)
· 2000 Brainbench certification in MS SQL 7.0.
· 2000 Brainbench certification in VB 6.0.
· 2000 Brainbench certification in Active Server Pages (ASP).
· 2000 Brainbench certification in MS Visual Interdev 6.0.
Education
1997 - 2000 MS degree in Economic and
Management.
Personal
Excellent analytical, problem solving,
technical, interpersonal and communication skills with a strong entrepreneurial
drive.
References
Keywords
Visual Basic, VB, ASP, SQL, MS SQL Server, Microsoft SQL Server, Microsoft developer, Microsoft technologies, Visual Studio 6.0, Visual Studio.NET, VC++, XML, MS XML Parser, XML services, XML Web Services, SOAP, EDI (Electronic Data Interchange), BizTalk, XSLT, XPath, XSD schemas, XDR schemas, OAGIS, Active Server Pages, ASPX, Visual InterDev, Visual Source Safe, VSS, VSS 6.0d, IIS, Internet Information Server, MS Office, Microsoft Office, Microsoft Access, Microsoft Word VBA, Microsoft Excel VBA, Outlook VBA, Windows 2000, Windows XP, Windows NT, Windows 98, Windows 95, Object Orienting Programming, OOP, Component Object Model, COM, COM+ Server, MTS Server, RDBMS, UML, Rational Rose, Rational ClearQuest, Crystal Reports 9.0, MSDN Library, AS400, XML Spy, ERP, Microsoft Office VBA, Microsoft Query Analyzer, Microsoft Enterprise Manager, Profiler, XSelerator, OAGIS, *.idl, *.tlb, mIDL, DLL, VB6, VB.NET, ASP.NET, User controls, Server Controls, Portlets, Repeater, DataList, DataGrid, C#, Components, ActiveX controls, ADO, OLE DB, MS Project, MS Visio, Work Flow diagrams, The Far manager, The Bat, Grid, True DB grid, FarPoint Spread, MSN, ICQ, Email, VB script, Java script, HTML, DHTML, programmer, data modeling, ER-diagrams, Erwin, Database technologies, Database developer, System Analyst, DBA, stored procedures, SP, Views, Triggers, MS IE, eCommerce, Microsoft Internet Explorer, MCAD, NTFS permissions check, Oracle 9.2, Toad VI, SQL Plus, ComponentArt TreeView, LLBLGet, RapTier codegenerator, mht, CDO.
Willing to relocate to: Tampa, FL; Saint Petersburg, FL; Orlando, FL; Jacksonville, FL; Miami, FL; Atlanta, GA; Dallas, TX; Houston, TX; Austin, TX; San Antonio, TX; Louisville, KY; Lexington, KY; Raleigh, NC; Memphis, TN; Chattanooga, TN; Nashville, TN, Phoenix, AZ; Kansas, KS; Cincinnati, OH, Columbus, OH; San Diego, CA; San Francisco, CA; Oakland, CA, Los Angeles, CA; Orange County, CA; Richmond, VA; SC; AL; LA; CO; AR; IN; MS; MO; NM; OK; WV and other places.