для моего драго(ценного) супруга который без работы уже ровно столько, что мои нервишки начали сдавать.. Помогите ребята.. он правда хороший и шибко умный, вот сколько знает:
если нужно резюме- пришлю в личку
MS SQL Server, DB schema design, T-SQL, ERWIN, normalization, performance tuning, OLTP (no OLAP experience), SSIS
.NET/C# for backend development or WinForms. Some ASP.NET/Jscript
Borland Delphi 1-7 J
Ищется работа в Оранж каунти Калифорния
-
4жды4
- Уже с Приветом
- Posts: 500
- Joined: 16 Jul 2002 19:50
- Location: Michigan - California
-
Интеррапт
- Уже с Приветом
- Posts: 17281
- Joined: 07 Sep 2011 10:05
- Location: Seattle, WA
Re: Ищется работа в Оранж каунти Калифорния
Шибко умный, знает .NET и сидит без работы? Сколько лет опыта? По интервью хоть ходит?4жды4 wrote: .NET/C# for backend development or WinForms.
-
Medium-rare
- Уже с Приветом
- Posts: 9195
- Joined: 04 Mar 2011 03:04
- Location: SFBA
Re: Ищется работа в Оранж каунти Калифорния
Это уже pattern запросов такой, когда жёны пишут за мужей, которые без работы?
Ну, по делу, дотнетовская тема хороша, но есть некоторое перепроизводство спецалистов, такое подозрение. Жаба, которая в принципе в любую сторону с си-шарпом соизмерима, как-то в Калифорнии в большем ходу.
Надо в таком случае какой-то дефицитный и продажный скилл в дополнение. Вопрос лишь, как его получить, не работая... порочный круг.
Ну, по делу, дотнетовская тема хороша, но есть некоторое перепроизводство спецалистов, такое подозрение. Жаба, которая в принципе в любую сторону с си-шарпом соизмерима, как-то в Калифорнии в большем ходу.
Надо в таком случае какой-то дефицитный и продажный скилл в дополнение. Вопрос лишь, как его получить, не работая... порочный круг.
... and even then it's rare that you'll be going there...
-
YevgenyN
- Уже с Приветом
- Posts: 305
- Joined: 15 Sep 2001 09:01
- Location: Newport Beach, CA
Re: Ищется работа в Оранж каунти Калифорния
если ДЕЙСТВИТЕЛЬНО ОЧЕНЬ СИЛЁН в дизайне и оптимизации SQL Server-ных баз данных, то шлите в личку резюме. Wonderware, Lake Forest, CA.
-
Alexandr
- Уже с Приветом
- Posts: 3647
- Joined: 23 May 2010 15:10
Re: Ищется работа в Оранж каунти Калифорния
переживают, что у них сидят на шее, а не они?Это уже pattern запросов такой, когда жёны пишут за мужей, которые без работы?
или мысль идет дальше и переживают, что еще и в разводе содержать придется? вот и ищут им работу
ЗЫ я до привета был хороший, это меня тут испортили
-
Интеррапт
- Уже с Приветом
- Posts: 17281
- Joined: 07 Sep 2011 10:05
- Location: Seattle, WA
Re: Ищется работа в Оранж каунти Калифорния
А вот если бы жена не работала, а муж работал, но у него "нервишки начали сдавать" от того, что жена не работает, то мужа назвали бы скупердяемAlexandr wrote:переживают, что у них сидят на шее, а не они?Это уже pattern запросов такой, когда жёны пишут за мужей, которые без работы?
или мысль идет дальше и переживают, что еще и в разводе содержать придется? вот и ищут им работу
ЗЫ я до привета был хороший, это меня тут испортили
Ну а если по делу, пусть ТС резюме сюда выкладывает, коллективный разум может чего и посоветует. И это, если искать работу, то хоть бы местоположение озвучили, а то Калифорния - она большая. Или готовы к релокейшену?
-
Alexandr
- Уже с Приветом
- Posts: 3647
- Joined: 23 May 2010 15:10
Re: Ищется работа в Оранж каунти Калифорния
"это просто не мужчина" (с)А вот если бы жена не работала, а муж работал, но у него "нервишки начали сдавать" от того, что жена не работает, то мужа назвали бы скупердяем
-
М@ш@
- Уже с Приветом
- Posts: 23488
- Joined: 05 Jan 2005 11:11
- Location: Israel->NJ
Re: Ищется работа в Оранж каунти Калифорния
Вы настолько радостно за мыслью своей побежали, что даже не заметили (и не потрудились пересмотреть), что было сказано о районе.Интеррапт wrote:А вот если бы жена не работала, а муж работал, но у него "нервишки начали сдавать" от того, что жена не работает, то мужа назвали бы скупердяемAlexandr wrote:переживают, что у них сидят на шее, а не они?Это уже pattern запросов такой, когда жёны пишут за мужей, которые без работы?
или мысль идет дальше и переживают, что еще и в разводе содержать придется? вот и ищут им работу
ЗЫ я до привета был хороший, это меня тут испортили
Ну а если по делу, пусть ТС резюме сюда выкладывает, коллективный разум может чего и посоветует. И это, если искать работу, то хоть бы местоположение озвучили, а то Калифорния - она большая. Или готовы к релокейшену?
Я люблю шутить. Не нравится - не смейтесь :)
-
Интеррапт
- Уже с Приветом
- Posts: 17281
- Joined: 07 Sep 2011 10:05
- Location: Seattle, WA
Re: Ищется работа в Оранж каунти Калифорния
Каюсь, что название топика как-то ускользнуло из сознания.М@ш@ wrote: Вы настолько радостно за мыслью своей побежали, что даже не заметили (и не потрудились пересмотреть), что было сказано о районе.
-
Krys-Krys
- Уже с Приветом
- Posts: 12139
- Joined: 15 Feb 2010 10:32
- Location: Pacifica, CA
Re: Ищется работа в Оранж каунти Калифорния
Чукча не читаталь - чукча писатель (с)М@ш@ wrote:Вы настолько радостно за мыслью своей побежали, что даже не заметили (и не потрудились пересмотреть), что было сказано о районе.Интеррапт wrote:А вот если бы жена не работала, а муж работал, но у него "нервишки начали сдавать" от того, что жена не работает, то мужа назвали бы скупердяемAlexandr wrote:переживают, что у них сидят на шее, а не они?Это уже pattern запросов такой, когда жёны пишут за мужей, которые без работы?
или мысль идет дальше и переживают, что еще и в разводе содержать придется? вот и ищут им работу
ЗЫ я до привета был хороший, это меня тут испортили
Ну а если по делу, пусть ТС резюме сюда выкладывает, коллективный разум может чего и посоветует. И это, если искать работу, то хоть бы местоположение озвучили, а то Калифорния - она большая. Или готовы к релокейшену?
-
4жды4
- Уже с Приветом
- Posts: 500
- Joined: 16 Jul 2002 19:50
- Location: Michigan - California
Re: Ищется работа в Оранж каунти Калифорния
YevgenyN - мы тоже в Lake Forest - отослала в личку.
вот для коллективного разума
Alex ...
Lake Forest
OBJECTIVE
To obtain a Database Developer/Data Architect/SQL DBA position where over fifteen years of high quality DB architecture design and coding experience would be needed. Areas of expertise: high quality DB design/development for highly concurrent and parallelized OLTP systems (SQL Server and/or Oracle), normalization, performance tuning and DB redesign/reverse engineering, complex XML/XSD design and processing, Client/Server applications design/implementation, .NET/C# and a number of older technologies and languages.
QUALIFICATION SUMMARY
Programming languages:
T-SQL (12 years), Oracle SQL and PL/SQL (7 years), C# (7 year), VB.NET (3 year), Borland Delphi versions 1-7 (7 years), Java Script, C (1.5 years), Turbo Pascal v.3-7 (5 years), Assembler x86 (5 years), Fortran 4/77 (3 years)…
Databases, tools and other applications:
Microsoft SQL Server 6.5/7/2000/2005/2008R2 (12 years), Oracle 7.3.4 – 11g and PL/SQL (7 years), CA Erwin (10 years), Red Gate SQL compare (4 years), MS SSIS and DTS for ETL (3 years), MS SSRS (1 year), Tibco Turbo XML (2.5 years), Visual Studio.NET (6 years), Oracle Failsafe, Interbase v4-5 (3 years), Quest TOAD (5 years), Direct Oracle Access (DOA) and Infopower components for Delphi (3 years), Report Builder (3 years), Microsoft ADO (2 years), OLE DB (3 years), ADO.NET, ODBCExpress components for Delphi (6 months), BDE (4 years), ODBC (2 years), Paradox (5 years), DB2, FoxPro/FoxBASE (2 years), Crystal Reports (2 years), Microsoft Visual Source Safe, Microsoft Visio, Meran PVCS, MKS, Perforce, CVS.
Programming technologies:
ASP.NET (5 years), Client/Server (6 years), Object oriented design and programming (9 years), COM (1 year), ActiveX (2 years), Windows 32 API (4 years), multi-thread (3.5 years), real-time communication with hardware and digital signal processing (3 years), HTML (6 years), MS IIS4-7, ISAPI, CGI, XML/XSD (3 years), CSS, IBM MQ Series API (1 year)…
EMPLOYMENT
Pelican Hill Group – Irvine, CA – from 9/2012
Title: Sr. Developer - Contractor
- Designed and implemented DB schema for preprocessor to transfer Epicor employee’s records from SQL server based Ultipro HR to Oracle HR (Erwin, SQL Server 2008).
- Implemented SSIS package and stored procedures to transfer Ultipro HR records, finds the updated and new records and updated fields and populates the output tables in preprocessor. (Visual Studio 2008, SQL server 2008)
- Fields validation in Oracle HR (Oracle 11G, PL/SQL, Oracle SQL developer).
MyCustomerData – Aliso Viejo, CA – from 11/2011 to 07/2012
Title: Sr. Developer/DB Architect, contract
- Designed and implemented Web portal configuration tool. (SQL Server 2008R2, Erwin, C#, VB.NET, Visual Studio 2010, WinForms, Telerik controls).
- Performed DB analysis, performance tuning and redesigned table structure. Analyzed implied relationships and applied referential integrity (conversion scripts, fixing bad data, normalization, rewriting procedures, functions etc.). ERWIN, SQL server 2008, Tuning Advisor, Profiler
- Supporting existing applications, fixing bugs, DB side performance optimization including indexed views (MS SSIS packages, SQL management studio, SSRS, Profiler, Visual Studio 2008/2010)
Vigilistics Inc – Irvine, CA – from 04/2010 to 10/2011
Title: DB Architect/Developer
- Designed and implemented a new EMI DBs (Erwin for DB modeling and E/R diagrams, SQL Server 2008R2/SQL Server Express/Oracle 10 XE).
- Designed a new DB schema/sprocs/triggers/views etc for CIP system for the dairy industry (OLTP), implemented stored procedures/functions/views and triggers for web GUI (ERWIN, SQL server 2005)
- Debug/Fix numerous bugs and supported existing product installations that collect data from Vigilistics concentrator PLC and use it for analysis and production process improvement/savings (VB.NET/SQL Server 2005/2008, SSIS packages)
- Reverse engineered old versions of DB (including replacing triggers with foreign keys)
Accomplishments:
- Expert level experience architecting and designing SQL Server database
- Extensive experience with SQL performance optimization (including indexed/materialized views, partitioning and use of filtered indexes)
- Deadlocks resolution, parallel data processing and reporting from OLTP live data
Bank of America (former LaSalle Bank ABN AMRO) – Tustin, CA – from 03/2006 to 03/2010
Title: DB Architect/Sr. Software Engineer, officer
- Designed and implemented ratings warehouse to store raw data and ratings history from 3 major rating agencies (Moody, Fitch and S&P). SQL Server 2005, Visual Studio 2008, Erwin
- Designed and implemented dynamic valuation module that uses XML and SQL expressions for step-by-step valuation of user-entered expressions (including matrix calculation to valuate test thresholds). SQL server 2005 and Visual Studio 2005 for XML/XSD design, SSIS packages.
- Designed DB structure and implemented web interface for CDO trustee report collection/data entry and job assignment/tracking for outsourced team in India (Erwin, C#, ASP.NET 1.1, Infragistics .NET components, Microsoft Enterprise Libraries, SQL Server 2000).
- Designed and implemented batch processing application to copy/move/rename files/directories according to the deals logic/configuration in DB. (C#, SQL server 2000, Infragistics .NET components, Microsoft Enterprise Libraries).
- Designed and implemented Trustee Processor classes/modules/application to import data and process jobs on per-trustee basis (C#, SQL server 2000).
- Supporting and fixing bugs in current CDOSuite system (asp pages, VBScript, JavaScript, SQL server 2000).
- SQL server performance tuning and rewriting most offending stored procedures. SQL Server 2005.
- Various small in-house projects/patches/fixes.
Ameriquest Mortgage – Orange, CA – from 09/2005 to 03/2006
Title: Sr. Programmer Analyst
- Supported and enhanced Empower application including Oracle stored procedures (Delphi 6, Oracle 8.1.7i)
- Code optimization and performance tuning (Empower dynaforms, Delphi 6, Oracle stored procedures/queries)
Lason Systems Inc. – Livonia, MI – from 10/2002 to 08/2005
Title: Database Architect/Sr. Software Engineer
- Designed DB/XML schemas and as a part of development team implemented Workflow processing system – DB driven distributed application to process production data on 24/7 basis. The processes (universal modules for processing production data according to the XML configuration received from DB) are communicating with SQL server using XML (process communication, data exchange, job configuration). The processes are running on a number of workstations, DB is controlling the execution and data flow, sending to the processes job configuration, receiving back status information/data/results and automatically unregistering processes in case of expiration/failure and enable the next available process to continue the processing. (MSSQL 2000, Erwin, Turbo XML).
- Designed and implemented Workflow web site to control daily workflow processing, (VB.NET, ASP.NET, SQL server 2000, DTS, BCP, MS IE Web controls, C# for .NET components and Web Services, MD5 password protection, Java Script and DHTML)
- Designed and implemented multithreaded “lazy” log writer class (C#, sync objects, multithread) to write log file from the process (multiple processes may share the same log file and logging is not slowing down main processing thread(s)).
- Supporting, fixing bugs and converting legacy pre-workflow applications written on Delphi 3-5. (Delphi 3-5, C#, Sybase)
Accomplishments:
- Lason’s workflow system has received “Most Sophisticated Application” award from exstream.com
- Strong knowledge of XSD/XML, strong DBA skills (SQL server), deadlock resolving/code redesigning skills
- Heavy load OLTP DB transaction handling (over 200 concurrent connections hitting DB at least every 5 seconds on 24/7 basis), SQL server queries/procedures optimization skills (using profiler, index tuning wizard and staging multiprocessor environment), DB normalization, indexes design and optimization for medium size OLTP DB (currently over 60GB).
IDT Horizon Global Trading – New York, NY, USA - from 05/2002 to 08/2002
Title: Programmer Analyst
- Designed and implemented DB structure, COM interfaces and classes for security routines. It is validating user account and checks if user is allowed to perform a particular method of the interfaced object within the user’s “company entity” on role-based principles (Delphi 5, SQL server 2000, ADO, COM, and extreme DUNIT for testing).
- IBM MQ Series access classes design/implementation (on-demand dynamically load MQ Series Client or Server DLL for client or server installation, multithreaded calls support, business layer API) – transfer messages between MQ Series queues and SQL Server tables using COM business classes - company’s proprietary BondFire architecture (Delphi 5, Microsoft SQL Server 2000, ADO).
Chartwell Asset Management Inc. – Surrey, BC, Canada - from 11/2001 to 12/2004
Title: Software Developer Analyst (remote contractor)
- Analyzed business requirements, designed database structure and implemented the Portfolio Management System – web based portfolio allocation system to manage client’s portfolios in groups and individually with advanced online graphical reporting system. System allows sell/buy securities on a master account level (group) and splitting the transactions between client’s accounts according to their model portfolio; optimized rebalancing within master account; suggestions on what to buy/sell in order to maintain model portfolios. (Microsoft Visual Studio.NET, ASP.NET, C#,
Oracle 8.1.7i, XML, JavaScript, Delphi 5 CGI, Tee Chart components, Adobe PDF Distiller and ReportBuilder 6 for online web reports in PDF format)
- Developed service application to manage user groups, price data import from FoxPro 2.6 to Oracle (Delphi 5, Direct Oracle Access components for Delphi, ADO, and Oracle PL/SQL).
- Upgraded to Oracle 11G and performed various DBA tasks (11/2009 – 02/2010)
SRI Strategic Resources – Burnaby, BC, Canada - from 08/2000 to 11/2001
Title: Consulting Associate
SoftTracks Ent. Project
- Designed and implemented multithreaded database access classes and IBM MQ Series access module for corporate Transaction Gateway Server (TGS) to significantly increase the performance of the wireless financial transactions (ODBC Express components, Delphi 4, Oracle 8.0.5, NT4 cluster server, TCP/IP and UDP sockets). Transaction time has been decreased from 45-50 to less than 10 milliseconds (limited only by the network speed).
- Implemented POS (Point of Sale) TGS module for CIBC bank (Canadian Imperial Bank of Commerce).
Accomplishments:
- Strong object oriented application design and implementation in multithreaded, distributed environment.
- Oracle queries, stored procedures, triggers and views optimization
- Database and application maintenance in 24/7-production environment (including NT4 cluster server and Oracle Failsafe)
Liquor Distribution Branch project
- Designed database structure and implemented “PostOffice” application – database event-driven server application to process incoming/outgoing (Fax, Print, Email, EDI, Web) corporative documents (Oracle 7/8 PL/SQL, DB2, Delphi 5, Report Builder, Microsoft ADO, Quest TOAD, Platinum Erwin, Microsoft Visual Source Safe, Crystal Reports).
- Co-designed database structure and client/server application for automatic corporative purchasing system.
- Upgraded existing desktop and client/server applications from Delphi 3-4 to Delphi 5.
Accomplishments:
- Design, implementation and support the database server application and several clients’ applications.
Link-Wizard.com – my own web site (http://www.link-wizard.com) - from 11/2000 to 10/2002
Title: Software Developer/Oracle DBA
- Designed database structure and implemented dating web site – (Microsoft. NET, C#, ASP.NET, JavaScript, Oracle)
- Installed and administrated Oracle 8i database (8.1.7i).
- Performed daily database backups and manage user’s accounts.
- Designed and implemented service application for internal administrative purpose to manage emails lists and clients privileges (Delphi 5, Direct Oracle Access components, Oracle RDMBS).
Accomplishments:
- ASP.NET and C# object oriented design and development, knowledge of Oracle 8i PL/SQL, Oracle Intermedia and Oracle Web Agent, Oracle 8i database administration and maintenance.
3LOG Systems Inc. (Richmond, BC, Canada) - from 08/1999 to 08/2000
Title: Senior Software Developer
- As a team leader designed and implemented customized Log Inventory Management System (LIMS) for several forest companies in Canada and the United States. (Delphi 4/5, Oracle 7/8, Infopower components, Direct Oracle Access (DOA) components, Report Builder, Platinum Erwin, Quest TOAD, Microsoft VSS).
- Designed and implemented configurable text file import module to import scale’s data into Oracle database.
Accomplishments:
- User-friendly GUI design and implementation
- Strong knowledge of database design and data modeling using Platinum Erwin
- Strong knowledge of client/server architecture and application design in low-speed database connection environment
- For the first time in company’s history my team received $10000 bonus for finishing project earlier.
Krasnodar State Municipal Medical-Diagnostic Association (Russia) - from 10/1996 to 07/1999
Title: Senior Software Developer/Analyst of the Statistics Department
- Designed and implemented software project “Info-statistical System” (Delphi/Oracle, Windows NT).
- Designed and implemented the inventory management system (Interbase/Delphi 3-4).
- Translated old applications (Paradox, FoxPro, Dbase, Visual Basic) to the client/server platform (Interbase, Delphi).
Accomplishments:
- Designed and implemented various parts of client/servers applications
- Interbase stored procedures/queries/triggers optimization.
Scientific and Production company "Biosoft Laboratory ltd." (Krasnodar, Russia) - from 05/1993 to 10/1996
Title: Senior Software Engineer
Headed software development project “Portative Ultrasonic Diagnostic System”.
- Designed and developed software for new medical ultrasonic diagnostic device. Input analog signal from the ultrasonic gauge, real-time digital signal processing and output the graphical and text information to the built-in printer and to the built-in and PC’s display. (Borland Pascal, Turbo Vision, Btrieve, Assembler/MSDOS).
- Developed applications to test equipment and collect the statistical information in Windows environment (Win32 API, multithread programming – Assembler 80x86, Turbo Pascal, Delphi 1-2, BDE, Paradox, Borland C, DBase).
Accomplishments:
- Digital signal processing, multithreaded communication with hardware and between threads/processes.
Scientific and Industrial Association “Petroleum Geological Prospecting Devices” (Krasnodar, Russia).
Titles:
Senior Software Developer - from 10/1992 to 05/1993 and
Software Developer - from 08/1991 to 10/1992
- As a part of software team developed the software for new station of seismic-geological exploration. Direct programming of the equipment of the station, digital signal processing and development of the graphical interface library. (Borland C, Turbo Assembler/MS DOS, Dbase 3).
EMPLOYMENT DURING SCHOOL
Computer Center of the Ryazan State Radio Engineering Institute (Ryazan, Russia) -
from 10/1988 to 05/1991
- Undergraduate research work and developing mathematical and computer models of discharge devices (thyratrons) and research of plasma. (Fortran 4, Basic)
- Designed and implemented research application to simulate semiconductor devices. (Turbo Pascal).
Computer Center of the Moscow State Technical University name of Bauman (Moscow, Russia) -
from 10/1984 to 05/1987
- Developed application for simulation of mechanical parts and mechanisms (Fortran 4, PL1).
EDUCATION
- Moscow State Technical University name of Bauman (Russia) Power-Machine-Building Faculty (1983-1987). After 3-rd year have transferred to Ryazan State Radio technical Academy
- M.Sc. (Electronics Engineer). 1987-1991 Ryazan State Radio Technical Academy (Russia).
CERTIFICATIONS
“C#” – by Brainbench (score: 3.24) – June 12, 2005
“Visual Basic.NET” – by Brainbench (score: 3.42) – June 12, 2005
"RDBMS Developer" - by Brainbench - June 6, 2000.
"Delphi Programmer" - by Brainbench - June 6, 2000.
"Master Delphi Programmer" - by TekMetrics - January 27, 1999.
"Oracle Programmer" - by TekMetrics - January 31, 1999.
REFERENCES
Available upon request
вот для коллективного разума
Alex ...
Lake Forest
OBJECTIVE
To obtain a Database Developer/Data Architect/SQL DBA position where over fifteen years of high quality DB architecture design and coding experience would be needed. Areas of expertise: high quality DB design/development for highly concurrent and parallelized OLTP systems (SQL Server and/or Oracle), normalization, performance tuning and DB redesign/reverse engineering, complex XML/XSD design and processing, Client/Server applications design/implementation, .NET/C# and a number of older technologies and languages.
QUALIFICATION SUMMARY
Programming languages:
T-SQL (12 years), Oracle SQL and PL/SQL (7 years), C# (7 year), VB.NET (3 year), Borland Delphi versions 1-7 (7 years), Java Script, C (1.5 years), Turbo Pascal v.3-7 (5 years), Assembler x86 (5 years), Fortran 4/77 (3 years)…
Databases, tools and other applications:
Microsoft SQL Server 6.5/7/2000/2005/2008R2 (12 years), Oracle 7.3.4 – 11g and PL/SQL (7 years), CA Erwin (10 years), Red Gate SQL compare (4 years), MS SSIS and DTS for ETL (3 years), MS SSRS (1 year), Tibco Turbo XML (2.5 years), Visual Studio.NET (6 years), Oracle Failsafe, Interbase v4-5 (3 years), Quest TOAD (5 years), Direct Oracle Access (DOA) and Infopower components for Delphi (3 years), Report Builder (3 years), Microsoft ADO (2 years), OLE DB (3 years), ADO.NET, ODBCExpress components for Delphi (6 months), BDE (4 years), ODBC (2 years), Paradox (5 years), DB2, FoxPro/FoxBASE (2 years), Crystal Reports (2 years), Microsoft Visual Source Safe, Microsoft Visio, Meran PVCS, MKS, Perforce, CVS.
Programming technologies:
ASP.NET (5 years), Client/Server (6 years), Object oriented design and programming (9 years), COM (1 year), ActiveX (2 years), Windows 32 API (4 years), multi-thread (3.5 years), real-time communication with hardware and digital signal processing (3 years), HTML (6 years), MS IIS4-7, ISAPI, CGI, XML/XSD (3 years), CSS, IBM MQ Series API (1 year)…
EMPLOYMENT
Pelican Hill Group – Irvine, CA – from 9/2012
Title: Sr. Developer - Contractor
- Designed and implemented DB schema for preprocessor to transfer Epicor employee’s records from SQL server based Ultipro HR to Oracle HR (Erwin, SQL Server 2008).
- Implemented SSIS package and stored procedures to transfer Ultipro HR records, finds the updated and new records and updated fields and populates the output tables in preprocessor. (Visual Studio 2008, SQL server 2008)
- Fields validation in Oracle HR (Oracle 11G, PL/SQL, Oracle SQL developer).
MyCustomerData – Aliso Viejo, CA – from 11/2011 to 07/2012
Title: Sr. Developer/DB Architect, contract
- Designed and implemented Web portal configuration tool. (SQL Server 2008R2, Erwin, C#, VB.NET, Visual Studio 2010, WinForms, Telerik controls).
- Performed DB analysis, performance tuning and redesigned table structure. Analyzed implied relationships and applied referential integrity (conversion scripts, fixing bad data, normalization, rewriting procedures, functions etc.). ERWIN, SQL server 2008, Tuning Advisor, Profiler
- Supporting existing applications, fixing bugs, DB side performance optimization including indexed views (MS SSIS packages, SQL management studio, SSRS, Profiler, Visual Studio 2008/2010)
Vigilistics Inc – Irvine, CA – from 04/2010 to 10/2011
Title: DB Architect/Developer
- Designed and implemented a new EMI DBs (Erwin for DB modeling and E/R diagrams, SQL Server 2008R2/SQL Server Express/Oracle 10 XE).
- Designed a new DB schema/sprocs/triggers/views etc for CIP system for the dairy industry (OLTP), implemented stored procedures/functions/views and triggers for web GUI (ERWIN, SQL server 2005)
- Debug/Fix numerous bugs and supported existing product installations that collect data from Vigilistics concentrator PLC and use it for analysis and production process improvement/savings (VB.NET/SQL Server 2005/2008, SSIS packages)
- Reverse engineered old versions of DB (including replacing triggers with foreign keys)
Accomplishments:
- Expert level experience architecting and designing SQL Server database
- Extensive experience with SQL performance optimization (including indexed/materialized views, partitioning and use of filtered indexes)
- Deadlocks resolution, parallel data processing and reporting from OLTP live data
Bank of America (former LaSalle Bank ABN AMRO) – Tustin, CA – from 03/2006 to 03/2010
Title: DB Architect/Sr. Software Engineer, officer
- Designed and implemented ratings warehouse to store raw data and ratings history from 3 major rating agencies (Moody, Fitch and S&P). SQL Server 2005, Visual Studio 2008, Erwin
- Designed and implemented dynamic valuation module that uses XML and SQL expressions for step-by-step valuation of user-entered expressions (including matrix calculation to valuate test thresholds). SQL server 2005 and Visual Studio 2005 for XML/XSD design, SSIS packages.
- Designed DB structure and implemented web interface for CDO trustee report collection/data entry and job assignment/tracking for outsourced team in India (Erwin, C#, ASP.NET 1.1, Infragistics .NET components, Microsoft Enterprise Libraries, SQL Server 2000).
- Designed and implemented batch processing application to copy/move/rename files/directories according to the deals logic/configuration in DB. (C#, SQL server 2000, Infragistics .NET components, Microsoft Enterprise Libraries).
- Designed and implemented Trustee Processor classes/modules/application to import data and process jobs on per-trustee basis (C#, SQL server 2000).
- Supporting and fixing bugs in current CDOSuite system (asp pages, VBScript, JavaScript, SQL server 2000).
- SQL server performance tuning and rewriting most offending stored procedures. SQL Server 2005.
- Various small in-house projects/patches/fixes.
Ameriquest Mortgage – Orange, CA – from 09/2005 to 03/2006
Title: Sr. Programmer Analyst
- Supported and enhanced Empower application including Oracle stored procedures (Delphi 6, Oracle 8.1.7i)
- Code optimization and performance tuning (Empower dynaforms, Delphi 6, Oracle stored procedures/queries)
Lason Systems Inc. – Livonia, MI – from 10/2002 to 08/2005
Title: Database Architect/Sr. Software Engineer
- Designed DB/XML schemas and as a part of development team implemented Workflow processing system – DB driven distributed application to process production data on 24/7 basis. The processes (universal modules for processing production data according to the XML configuration received from DB) are communicating with SQL server using XML (process communication, data exchange, job configuration). The processes are running on a number of workstations, DB is controlling the execution and data flow, sending to the processes job configuration, receiving back status information/data/results and automatically unregistering processes in case of expiration/failure and enable the next available process to continue the processing. (MSSQL 2000, Erwin, Turbo XML).
- Designed and implemented Workflow web site to control daily workflow processing, (VB.NET, ASP.NET, SQL server 2000, DTS, BCP, MS IE Web controls, C# for .NET components and Web Services, MD5 password protection, Java Script and DHTML)
- Designed and implemented multithreaded “lazy” log writer class (C#, sync objects, multithread) to write log file from the process (multiple processes may share the same log file and logging is not slowing down main processing thread(s)).
- Supporting, fixing bugs and converting legacy pre-workflow applications written on Delphi 3-5. (Delphi 3-5, C#, Sybase)
Accomplishments:
- Lason’s workflow system has received “Most Sophisticated Application” award from exstream.com
- Strong knowledge of XSD/XML, strong DBA skills (SQL server), deadlock resolving/code redesigning skills
- Heavy load OLTP DB transaction handling (over 200 concurrent connections hitting DB at least every 5 seconds on 24/7 basis), SQL server queries/procedures optimization skills (using profiler, index tuning wizard and staging multiprocessor environment), DB normalization, indexes design and optimization for medium size OLTP DB (currently over 60GB).
IDT Horizon Global Trading – New York, NY, USA - from 05/2002 to 08/2002
Title: Programmer Analyst
- Designed and implemented DB structure, COM interfaces and classes for security routines. It is validating user account and checks if user is allowed to perform a particular method of the interfaced object within the user’s “company entity” on role-based principles (Delphi 5, SQL server 2000, ADO, COM, and extreme DUNIT for testing).
- IBM MQ Series access classes design/implementation (on-demand dynamically load MQ Series Client or Server DLL for client or server installation, multithreaded calls support, business layer API) – transfer messages between MQ Series queues and SQL Server tables using COM business classes - company’s proprietary BondFire architecture (Delphi 5, Microsoft SQL Server 2000, ADO).
Chartwell Asset Management Inc. – Surrey, BC, Canada - from 11/2001 to 12/2004
Title: Software Developer Analyst (remote contractor)
- Analyzed business requirements, designed database structure and implemented the Portfolio Management System – web based portfolio allocation system to manage client’s portfolios in groups and individually with advanced online graphical reporting system. System allows sell/buy securities on a master account level (group) and splitting the transactions between client’s accounts according to their model portfolio; optimized rebalancing within master account; suggestions on what to buy/sell in order to maintain model portfolios. (Microsoft Visual Studio.NET, ASP.NET, C#,
Oracle 8.1.7i, XML, JavaScript, Delphi 5 CGI, Tee Chart components, Adobe PDF Distiller and ReportBuilder 6 for online web reports in PDF format)
- Developed service application to manage user groups, price data import from FoxPro 2.6 to Oracle (Delphi 5, Direct Oracle Access components for Delphi, ADO, and Oracle PL/SQL).
- Upgraded to Oracle 11G and performed various DBA tasks (11/2009 – 02/2010)
SRI Strategic Resources – Burnaby, BC, Canada - from 08/2000 to 11/2001
Title: Consulting Associate
SoftTracks Ent. Project
- Designed and implemented multithreaded database access classes and IBM MQ Series access module for corporate Transaction Gateway Server (TGS) to significantly increase the performance of the wireless financial transactions (ODBC Express components, Delphi 4, Oracle 8.0.5, NT4 cluster server, TCP/IP and UDP sockets). Transaction time has been decreased from 45-50 to less than 10 milliseconds (limited only by the network speed).
- Implemented POS (Point of Sale) TGS module for CIBC bank (Canadian Imperial Bank of Commerce).
Accomplishments:
- Strong object oriented application design and implementation in multithreaded, distributed environment.
- Oracle queries, stored procedures, triggers and views optimization
- Database and application maintenance in 24/7-production environment (including NT4 cluster server and Oracle Failsafe)
Liquor Distribution Branch project
- Designed database structure and implemented “PostOffice” application – database event-driven server application to process incoming/outgoing (Fax, Print, Email, EDI, Web) corporative documents (Oracle 7/8 PL/SQL, DB2, Delphi 5, Report Builder, Microsoft ADO, Quest TOAD, Platinum Erwin, Microsoft Visual Source Safe, Crystal Reports).
- Co-designed database structure and client/server application for automatic corporative purchasing system.
- Upgraded existing desktop and client/server applications from Delphi 3-4 to Delphi 5.
Accomplishments:
- Design, implementation and support the database server application and several clients’ applications.
Link-Wizard.com – my own web site (http://www.link-wizard.com) - from 11/2000 to 10/2002
Title: Software Developer/Oracle DBA
- Designed database structure and implemented dating web site – (Microsoft. NET, C#, ASP.NET, JavaScript, Oracle)
- Installed and administrated Oracle 8i database (8.1.7i).
- Performed daily database backups and manage user’s accounts.
- Designed and implemented service application for internal administrative purpose to manage emails lists and clients privileges (Delphi 5, Direct Oracle Access components, Oracle RDMBS).
Accomplishments:
- ASP.NET and C# object oriented design and development, knowledge of Oracle 8i PL/SQL, Oracle Intermedia and Oracle Web Agent, Oracle 8i database administration and maintenance.
3LOG Systems Inc. (Richmond, BC, Canada) - from 08/1999 to 08/2000
Title: Senior Software Developer
- As a team leader designed and implemented customized Log Inventory Management System (LIMS) for several forest companies in Canada and the United States. (Delphi 4/5, Oracle 7/8, Infopower components, Direct Oracle Access (DOA) components, Report Builder, Platinum Erwin, Quest TOAD, Microsoft VSS).
- Designed and implemented configurable text file import module to import scale’s data into Oracle database.
Accomplishments:
- User-friendly GUI design and implementation
- Strong knowledge of database design and data modeling using Platinum Erwin
- Strong knowledge of client/server architecture and application design in low-speed database connection environment
- For the first time in company’s history my team received $10000 bonus for finishing project earlier.
Krasnodar State Municipal Medical-Diagnostic Association (Russia) - from 10/1996 to 07/1999
Title: Senior Software Developer/Analyst of the Statistics Department
- Designed and implemented software project “Info-statistical System” (Delphi/Oracle, Windows NT).
- Designed and implemented the inventory management system (Interbase/Delphi 3-4).
- Translated old applications (Paradox, FoxPro, Dbase, Visual Basic) to the client/server platform (Interbase, Delphi).
Accomplishments:
- Designed and implemented various parts of client/servers applications
- Interbase stored procedures/queries/triggers optimization.
Scientific and Production company "Biosoft Laboratory ltd." (Krasnodar, Russia) - from 05/1993 to 10/1996
Title: Senior Software Engineer
Headed software development project “Portative Ultrasonic Diagnostic System”.
- Designed and developed software for new medical ultrasonic diagnostic device. Input analog signal from the ultrasonic gauge, real-time digital signal processing and output the graphical and text information to the built-in printer and to the built-in and PC’s display. (Borland Pascal, Turbo Vision, Btrieve, Assembler/MSDOS).
- Developed applications to test equipment and collect the statistical information in Windows environment (Win32 API, multithread programming – Assembler 80x86, Turbo Pascal, Delphi 1-2, BDE, Paradox, Borland C, DBase).
Accomplishments:
- Digital signal processing, multithreaded communication with hardware and between threads/processes.
Scientific and Industrial Association “Petroleum Geological Prospecting Devices” (Krasnodar, Russia).
Titles:
Senior Software Developer - from 10/1992 to 05/1993 and
Software Developer - from 08/1991 to 10/1992
- As a part of software team developed the software for new station of seismic-geological exploration. Direct programming of the equipment of the station, digital signal processing and development of the graphical interface library. (Borland C, Turbo Assembler/MS DOS, Dbase 3).
EMPLOYMENT DURING SCHOOL
Computer Center of the Ryazan State Radio Engineering Institute (Ryazan, Russia) -
from 10/1988 to 05/1991
- Undergraduate research work and developing mathematical and computer models of discharge devices (thyratrons) and research of plasma. (Fortran 4, Basic)
- Designed and implemented research application to simulate semiconductor devices. (Turbo Pascal).
Computer Center of the Moscow State Technical University name of Bauman (Moscow, Russia) -
from 10/1984 to 05/1987
- Developed application for simulation of mechanical parts and mechanisms (Fortran 4, PL1).
EDUCATION
- Moscow State Technical University name of Bauman (Russia) Power-Machine-Building Faculty (1983-1987). After 3-rd year have transferred to Ryazan State Radio technical Academy
- M.Sc. (Electronics Engineer). 1987-1991 Ryazan State Radio Technical Academy (Russia).
CERTIFICATIONS
“C#” – by Brainbench (score: 3.24) – June 12, 2005
“Visual Basic.NET” – by Brainbench (score: 3.42) – June 12, 2005
"RDBMS Developer" - by Brainbench - June 6, 2000.
"Delphi Programmer" - by Brainbench - June 6, 2000.
"Master Delphi Programmer" - by TekMetrics - January 27, 1999.
"Oracle Programmer" - by TekMetrics - January 31, 1999.
REFERENCES
Available upon request
-
Alexandr
- Уже с Приветом
- Posts: 3647
- Joined: 23 May 2010 15:10
Re: Ищется работа в Оранж каунти Калифорния
В информационный век, когда все перегружены информацией - грамотно донести свою мысль читателю и без неоднозначностей - задача писателяKrys-Krys wrote:Чукча не читаталь - чукча писатель (с)М@ш@ wrote:Вы настолько радостно за мыслью своей побежали, что даже не заметили (и не потрудились пересмотреть), что было сказано о районе.Интеррапт wrote:А вот если бы жена не работала, а муж работал, но у него "нервишки начали сдавать" от того, что жена не работает, то мужа назвали бы скупердяемAlexandr wrote:переживают, что у них сидят на шее, а не они?Это уже pattern запросов такой, когда жёны пишут за мужей, которые без работы?
или мысль идет дальше и переживают, что еще и в разводе содержать придется? вот и ищут им работу
ЗЫ я до привета был хороший, это меня тут испортили
Ну а если по делу, пусть ТС резюме сюда выкладывает, коллективный разум может чего и посоветует. И это, если искать работу, то хоть бы местоположение озвучили, а то Калифорния - она большая. Или готовы к релокейшену?
-
Интеррапт
- Уже с Приветом
- Posts: 17281
- Joined: 07 Sep 2011 10:05
- Location: Seattle, WA
Re: Ищется работа в Оранж каунти Калифорния
Во-во. А судя по тому, как женщины тут же отметились, им только дай возможность указать на промашку умного мужчины, радости то сразу сколькоAlexandr wrote: В информационный век, когда все перегружены информацией - грамотно донести свою мысль читателю и без неоднозначностей - задача писателя
-
Krys-Krys
- Уже с Приветом
- Posts: 12139
- Joined: 15 Feb 2010 10:32
- Location: Pacifica, CA
Re: Ищется работа в Оранж каунти Калифорния
Особенно модератора.Интеррапт wrote:Во-во. А судя по тому, как женщины тут же отметились, им только дай возможность указать на промашку умного мужчины, радости то сразу сколькоAlexandr wrote: В информационный век, когда все перегружены информацией - грамотно донести свою мысль читателю и без неоднозначностей - задача писателя
-
Интеррапт
- Уже с Приветом
- Posts: 17281
- Joined: 07 Sep 2011 10:05
- Location: Seattle, WA
Re: Ищется работа в Оранж каунти Калифорния
Судя по резюме, может вашему мужу просто влом работать? Решил взять заслуженный отдых?4жды4 wrote:YevgenyN - мы тоже в Lake Forest - отослала в личку.
вот для коллективного разума