Sql Server Windows

** ******* **** *********@*****.***

Arlington, MA - 02474 Mobile: 806-***-****

VIJAY JOHNSON

SUMMARY

Detail-oriented, software engineer with 15 years’ hands-on development experience and a consistent track record of delivering complex programs and managing multi-disciplinary teams of varying sizes.

TECHNOLOHY SKILLS

Languages: C#, Java, Perl, T-SQL, KSH, C++, C, AWK, ANSI-SQL

.NET: ASP.NET- 3.5, 4.0, 4.5 Win Forms, WPF, WCF, LINQ, MVC, XML Web Services, Remoting, Multi-Threading, Webparts

Operating System: Sun Solaris 2.x, HP UNIX, Linux, Windows NT, 2000, XP, Windows Server 2003, 2008

Databases: MS SQL Server 2005/2008, Sybase 11.x/12.x, MS Access 2000, Oracle 9i, 10g, MySql, DB2

Technology & Tools: OOPS, OOA/OOD, DBI/DBD, Visual Studio 2008, 2010 CGI, CronTab, MS Visio, Toad, ERWin, Eclipse, Git, Subversion, Telerik, Sitecore CMS, Solr Index, Node.js, MongoDB, AWS technologies - EC2, VPC, S3, Lambda.

Front-End Tools: JavaScript, Html, Less, Sass, Sench, Extjs 3.x,4.x, Backbone, React.js, Jquery Mobile, Underscore.js, Bootstrap.

Web Servers: Apache, Netscape Enterprise Server, Tomcat, IIS 5.0, 6.0, 7.0

Protocols: TCP/IP, FIX, SWIFT, HTTP, SOAP, REST, UDP/IP and FTP

EXPERIENCE

Vistaprint Inc, Waltham, MA July 2012 – Present

Principle Software Engineer

Responsible for the design and development of the scalable, multi-threaded, and distributed customer website Vistaprint.com with 16 million unique visitor’s per month.

Designed & developed business layer with clear separation of Model object, DB Gateway service, and WCF service. Launched Sitecore CMS and migrated products to it from Legacy systems.

Responsible for early stages of software product design. Involved in User interface/User experience research, web/mobile application interface design and security. Created prototypes, wire-frame mockups. Worked with User focus groups and Analyst to improve user experience in the site.

Assisted in coding and designing the first mobile web application using JQuery mobile and Sencha touch JS frameworks. Worked with upper management & sales team to create prototype for sales and product demo.

Responsible for managing technical risks throughout the project cycle. Assigned tasks and worked along junior developers. Adapted Scrum software development methodology.

Involved in database design and development, participated in query & stored procedure tuning.

Wrote automated scripts and marketer tools for migration. Migrated in-house web & database servers to Amazon Web services (AWS). Migrated C# based application to Sitecore CMS.

Worked with end-users on usability testing. Worked closely with business analysts, visual designers, usability specialists, and project managers. Implemented UI using MVC framework with ExtJS 4.0; Charts, grids etc.

Actively participated in code reviews & unit testing; Organized migration plan with DBA's for legacy data to new product platform. Lead impact and risk assessment meetings for client database isolation project. Created design & technical documentation, architectural diagram using visio, wiki & presented to engineering team. Practiced Agile and Scrum methodology.

Technologies: ASP.NET - 3.5, 4.0, 4.5, Ajax, JavaScript, ExtJS 3.x, 4.0, JQuery, Sitecore, IIS 7.0, C#, WCF, Oracle, SQL Server 2008, Windows Server 2008, HTML 5/CSS 3, Newtonsoft, Groovy, PS scripts, Sitecore CMS, Underscore, Backbone, React.Js.

E-dialog Inc (Subsidiary of E-Bay), Burlington, MA July 2008 – June 2012

Technical Lead

Responsible for the design, development and integration of a distributed, multi-threaded, cloud based campaign management application used by clients such as Target, NFL, OfficeMax, and Dell for massive email marketing campaigns.

Implemented UI using MVC framework with ExtJS 4.0; Charts, grids, ListView with Telerik. Contributed to coding and design of first mobile web application using Jquery mobile and Sencha touch JS frameworks.

Responsible for updating product manager regarding status of development efforts. Handled the tasks of identifying system deficiencies and implementing effective solutions.

Responsible for managing the product throughout the product lifecycle, gathering and prioritizing product and customer requirements, defining the product vision, and working closely with senior managers to deliver winning products.

Participated in the specification and development of a web-based tool for managing campaigns.

Worked with upper management & sales team to create prototype for sales and product demo. Created design & technical documentation, architectural diagram using visio, wiki & presented to engineering team.

Technologies: ASP.NET - 3.5, 4.0, Ajax, JavaScript, ExtJS 3.x, 4.0, JQuery, Telerik, Flex, IIS 7.0, C#, WCF, Oracle, SQL Server 2008, Windows Server 2008, YUI, HTML 5/CSS 3, Entity framework.

Morgan Stanley & Co Inc, Brooklyn, NY June 2006 – July 2008

Enterprise Data Management System (EDMS)

Responsible for the design and development of a web-based data management application providing customer account, profile, party and trading name information. Institutional Securities Group (ISG) uses EDMS to define its ‘customers’ through a client centric data model, business process, and organization. Coverage is a component of EDMS that enables the Institutional Securities Group to associate people with Referential Data (i.e. Trading Name, Business Definitions) through an improved data model, business process, organization and technology.

Designed & developed Web User Interface (UI) using ASP.NET, C#, HTML, JavaScript, server controls such as DataGrid, DataList, Validation controls. Extensively Used ADO.Net to access database objects tables, stored procedures.

Coordinated with non-technical users and resolved design and business issues during User Acceptance Testing (UAT). Worked with Flash developers to develop training materials for Business users.

Involved in developing Middleware components such as Bulk Data Loader, Mailer, Job scheduler. Worked closely with Sybase DBA to develop Sybase Replication Server Latency Monitors.

Used Kerborized, forms user authentication system. Developed Sybase, MS SQL Server stored procedures, triggers, indexes, views, and tables.

Designed data base model using Erwin tool for Trading Name data; Created SharePoint site for Business users and QA testing team.

Build SharePoint WebParts and deployed to IIS. Created reusable custom controls using .NET Assemblies: Developed Autosuggest textbox using Ajax. Created reconciliation scripts using PERL and scheduled in Autosys and crontab.

Technologies: ASP.NET, Ajax, JavaScript, IIS 6.0, C#, VB, ADO.NET, Sybase 12.5, MS SQL Server 2005, KSH, Linux, Windows Server 2003, Windows Sharepoint Services 3.0.

PERI Software Solutions Inc, Newark, NJ May 2005 – June 2006

Trader/Broker Compensation System

Responsible for the design and development of a Java based, compensation system used to calculate compensation, commission/incentive information for the Traders and Brokers. System calculates Commission, Profit and Loss for every equity trade. It has modules to receive intraday and EOD trading data and portfolio, price, trader/broker info etc., and calculation engine calculates the commission and P&L and post it against every account/trade/trader/broker. It has reports on compensation, performance comparison of traders and brokers, monthly, yearly compensation reporting for brokers and P&L reports generated using PERL/CGI scripts with HTML and Java applet.

Involved extensively in Application, Query, Stored procedure, Database Tuning in Sybase. Worked in data handling using KSH, BCP, SQL*Loader and ISQL; Created many Sybase & Oracle Tables, Stored Procedures, packages, Triggers, Indexes.

Designed, developed and modified Perl scripts & Java classes for calculation; Created front end for calculation engine configuration and changes for new rule and commission structure

Worked in user management module using PERL, Java and TSQL; Used DBI/DBD connectivity from PERL to Sybase and JDBC from Java application to database

Parsed complex trade related files using Java & Perl; Created many reports on P&L using HTML supported by Perl/CGI scripts; Used Apache web server; Participated in application and query tuning; Worked extensively on Transact SQL; Created many batch scripts using PERL and KSH and scheduled in CRON TAB; Did documentation and testing.

Technologies: Sybase 12.5, Oracle 10g, Java, Perl, CGI, KSH, TSQL, CRON TAB, Apache, Eclipse, Solaris 2.5, Windows XP

Automotive Ancillary Ltd, Chennai India May 1998 – July 2001

Inventory Tracking System

Created many Perl programs for inventory update and maintenance; Wrote Transact SQL modules for Sybase database; Created Triggers for multiple table updates and insertions

Developed T-SQL batches to do daily reports and weekly reports; Trouble shooting existing modules; Created supporting functionalities in KSH for front-end programs

Enhanced and created many Sybase Stored Procedures; Converted many Cursor based screens to client based Perl/CGI; Created Excel reports for material and warehouse master; Used PERL for scripting; Worked in Unix Shell scripting; Supported VB programmers using Sybase Stored Procedures.

Technologies: Perl, CGI, DBI/DBD, HTML, C, K-Shell, Sybase 10.x, Apache Web Server, HP-Unix, NT

Purchase Management System

This system enabled the purchasing department to receive the purchase request from its retail outlets all over the country to the central purchase department. System includes module to edit purchase request, purchase order, quotes based on the ID of the user.

Design and development of quote request, reporting and query modules

Designed and implemented Sybase stored procedures and triggers; Wrote numerous Perl modules for background processing

Participated in query and application tuning; Coded many Perl routines for data retrieval, migration and manipulating; Implemented CGI scripts using DB Library/DBI/DBD to fetch data from Sybase in Unix;

Development of Scripts to generate HTML reports on Intranet; Participated in unit, system, and end to end testing; User meetings for requirement analysis and bug fixing

Technologies: Perl, K-Shell, C, Sybase 11.x, Sybperl, HP UNIX, NT, Html, JavaScript, Apache Web Server

EDUCATION

Texas Tech University, Lubbock, TX

Master of Science in Mathematics and Statistics, 2003-2005

Master of Science in Engineering, 2001-2003

TPGIT, Vellore, India

Bachelors of Engineering, 1994-1998

REFERENCES: Available upon request.

Contact this candidate