Vijayesh Sainju (VJ)

* ****** **.

Jersey City

NJ 07305

acrip5@r.postjobfree.com 201-***-**** cell

KNOWLEDGE:

Desktop Programs: VBA, MS Excel, MS Access, MS PowerPoint, Lotus 1-2-3, SQL Server, TSQL, Stored Procedures, SharePoint

Web Development Related: ASP (Active Server Pages), ASP.NET, VB.NET, C#, VBScript, JavaScript, jQuery, HTML, DHTML, XML, FrontPage, PHP, Flash, mySQL, CSS, XHTML, DHTML, SharePoint

Others: SEO (Search Engine Optimization), Photoshop, Swish, Facebook Application using FBML, Social Media Optimization, PPC (Pay Per Click), Joomla, Wordpress, Magento, Zencart

Other Keywords: Business Analysis, UAT, BRD, SSIS, SSAS, SSRS, OOP

Expertise Level: HTML, Excel, Access, VBA and other MS Office applications - Advanced

ASP.NET, C#, SQL Server, Javascript, jQuery, CSS, graphics design - Intermediate

Marketing, Business Analysis - Intermediate

EXPERIENCE:

01/15 – 8/15 Freelance Jersey City,NJ

Freelance developer

WORKED AS A FREELANCE WEB AND DESKTOP DEVELOPERS FOR A DOZEN SMALL AND MID-SIZED BUSINESSES. I WORKED ON VARIOUS TECHNOLOGIES INCLUDING VB.NET, C# WINFORMS, WPF, ASP.NET AND PHP. MAJORITY OF THE TIME THE DATABASES USED WERE SQL SERVER, MYSQL AND ACCESS.

I ALSO MODIFIED TWO EXISTING ANDROID APPS WHICH WERE WRITTEN IN JAVA.

HERE IS AN EXAMPLE OF A FEW WEBSITES.

HTTP://WWW.BLACKSFORBLACKS.COM/

HTTP://WWW.THEEVENTZOO.COM/

HTTP://DESIGNERAUDIOVIDEO.COM/

HTTP://WWW.BAMBIBABY.COM/

010/14 – 12/14 Granite Tampa,FL

Excel, and.NET developer

GRANITE IS A GE AFFILIATED COMPANY THAT HAD AN URGENT NEED FOR A SENIOR LEVEL DEVELOPER EXPERIENCED IN EXCEL VBA AND .NET. A COMPLEX TIMESHEET APPLICATION WITH COMPLEX FORMULAS THAT INCLUDED MATH AND LOOKUP FUNCTIONS AND EXCEL USERFORM FRONTENDS AND AN ORACLE BACKEND NEEDED MAJOR ENHANCEMENTS. MOST OF THE DEVELOPMENT WAS DONE IN VBA TO AUTOMATE ALL THE MANUAL PROCESSES. LARGE AMOUNTS OF DATA PULLED FROM ORACLE HAD TO BE MANIPULATED TO CREATE MEANINGFUL REPORTS. MOST OF THE DATA ANALYSIS WAS DONE USING PIVOT TABLES THAT WERE CREATED ON THE FLY USING VBA MACROS. REPORTS HAD TO BE AUTOMATICALLY TURNED INTO PDF FILES WITH GRAPHS. SOME MINOR PROCESSES HAD TO BE CODED ON SHAREPOINT USING VB.NET AND JQUERY.

03/12 – 8/14 Liberty Mutual New York,NY

Excel, Access, SharePoint, VBA, .NET developer

I WORKED AS A PROGRAMMER AND BUSINESS ANALYST AND CREATED MULTIPLE APPLICATIONS IN EXCEL, ACCESS AND SHAREPOINT USING VBA FOR AUTOMATION. THE BIGGEST OF THE PROJECTS, WHICH WE NAMED AERUS REQUIRED CREATION OF AN EXCEL RATING ENGINE THAT HAD COMPLEX FORMULAS. ORIGINALLY, THE EXCEL FILE REQUIRED CONSOLIDATION OF MULTIPLE FILES AS EACH QUOTE AND RENEWAL OF POLICY REQUIRED SEPARATE EXCEL FILES. ULTIMATELY, THE SOLUTION WAS TO CREATE AN ACCESS FRONTEND TO SHAREPOINT AND USED VBA TO AUTOMATE THE PROCESSES. THE ACCESS FRONTEND WOULD ADD/UPDATE DATA IN THE SHAREPOINT LISTS. THE FRONTEND ALSO POPULATED DATA IN THE EXCEL RATING FILES AND PULLED VALUES CALCULATED BY EXCEL BACK INTO SHAREPOINT. ACCESS IS CAPABLE OF DOING COMPLEX CALCULATIONS AS WELL BUT WE DECIDED TO USE EXCEL FOR CALCULATIONS AS IT IS BETTER AND A LOT FASTER TO DEVELOP WHEN IT COMES TO NUMERICAL CALCULATIONS.

BESIDES THIS MAJOR PROJECT, I DEVELOPED SEVERAL OTHER SMALLER APPLICATIONS IN EXCEL AND ACCESS. IN MOST OF THESE APPLICATIONS, ACCESS WAS USED AS THE GUI TO PULL CSV AND TEXT DATA FILES TO CREATE EXCEL REPORTS WITH CHARTS AND PIVOT TABLES. IN MOST CASES, I USED EXCEL TEMPLATES WHICH WERE POPULATED WITH THE MANIPULATED DATA FROM THE CSV FILES.

I ALSO WORKED ON EDITING THREE WEBSITES. TWO OF THE WEBSITES WERE RISK MANAGEMENT WEBSITES FOR TWO SEPARATE DIVISIONS WITHIN LIBERTY INTERNATIONAL UNDERWRITERS (ARCHITECTS & ENGINEERING AND PROFESSIONAL LIABILITY MANAGEMENT). THE THIRD WEBSITE WAS A SHAREPOINT PORTAL TO KEEP LOG ISSUES FOR A&E. IN ALL THREE SITES SOME ASP.NET (C#), HTML, CSS AND JAVASCRIPT WAS USED.

TOWARDS THE END OF THE PROJECT I STARTED WORKING ON CONVERTING THE ACCESS/VBA AERUS PROJECT TO VB.NET AND SQL SERVER SYSTEM. WE DECIDED ON WINFORMS INSTEAD OF WPF AS THE IMPLEMENTATION WOULD BE QUICKER THIS WAY. HOWEVER, MY CONTRACT WAS OVER AS LIBERTY MUTUAL DOES NOT EXTEND A CONTRACTOR BEYOND 2 YEARS. DURING THE AERUS UPGRADE PROJECT I WORKED WITH VISUAL STUDIO AND WROTE STORED PROCEDURES, TRIGGERS AND VIEWS ON SQL SERVER. THE WORK CONTINUED WITH REWRITING VBA IN VB.NET SYNTAX.

03/10 – 12/11 Bank of America/Merrill Lynch New York,NY

VBA Rapid Application Developer and Business Analyst

It was a 6 months contract that extended to the maximum 18 months allowed in Bank of America. The position required someone with programming and business analysis experience.

Most of the work was RAD (rapid application development) around Access, Excel, PowerPoint, Outlook, Word and VBA (Visual Basic for Application). Requests from internal clients went through a prioritization cycle based on various criteria including hours saved through automation, whether the process is FED mandated or is requested by upper management. I met with the client to understand the process and gather the requirements. Next I created a BRD, which was a mix of business and functional requirements. Once the BRD was signed off by a director or higher from the clients’ business groups the project went into development phase. I developed around 15 applications in this Rapid Application Development setting.

A lot of the applications were around reconciliation. The data from two different sources (e.g., Sierra vs. GBS) were imported in a single Access database and reconciliation reports were produced in Excel. Most of the automation included importing of Excel, CSV and text files and processing the data and finally producing extensive reports. All of this was done in an extremely time sensitive environment.

The last project I was involved in was regarding the downgrade of Bank of America by the credit rating agencies. Moodys downgraded some entities in BAC on September 21 2011. S&P downgrade came a month and half later. I created a database that was used for tracking and remediating the trade population that was affected by the downgrade.

SSIS, SSAS and SSRS processes were used with some projects that required working with SQL Server data.

07/09 – 12/09 LiveProcess Verona,NJ

Web Developer and SEO

LiveProcess is one of the fastest growing companies in New Jersey according to Inc 500. After going through numerous web developers they found me to be the best match for their purpose. The site was a PHP based content management system with MySQL as the database. The site URL was well SEO’ed using .htaccess. Google Analytics was used to generate web stats.

The site has media files including flash, video and audio. It also has some advanced forms that when submitted posts the data to the database, then emails a couple of admin users and then pushes the data to Salesforce using curl functions.

07/08 – 12/08 Medco Franklin Lakes,NJ

Access VBA Programmer and Business Analyst

A complex Access MDE frontend-backend solution

It was a 2 month contract that was extended to more months as more departments within Medco wanted the software solution for their groups.

The position required expert knowledge in Visual Basics for Application as well as a capacity to work as a Business Analyst.

I started by gathering requirements from end users, documenting the requirements and discussing them during weekly meetings with the senior managers of the company.

The software (primarily Access VBA with some SharePoint and a C# ASP.NET web application) was created to track ‘request transactions’. Originally, hundreds of requests (or questions) were emailed to various staff. The people who received the questions (we will call them responders), would then communicate with the requestors back and forth through phone, email and IM. The management at Medco realized that there was no way to track these activities. Therefore, the Vice President of the company initiated this project so that the transactions (requests and responses) could be tracked with a lot of details.

I created the software that allowed users to enter their questions through web forms and then using VBA, automatically assign the requests, or reject the requests according to various criteria.

The coding included auto Outlook email generations, an admin functionality to control user roles and various other data within the tables, a system to control the access privilege on objects within the database by user roles, a method to import complex spreadsheets into the database tables and some very complex report generations (that included benchmarking and standard statistics).

The project was done with a lot of intensity (working over weekends and into late nights), because of the urgency. However, I wrote the codes with flexibility in mind when I understood that the business rules in this particular environment changed quite often. Unlike most applications that can run on a set of rules for years, this application had to be extremely flexible. On top of that, the flexibility had to be built in to be manageable by admins who are not programmers themselves.

Overall, this was one of the most complex Access/Visual Basic for Application project I have been involved in.

03/08 – 7/08 Freelance Jersey City,NJ

Freelance developer

WORKED AS A FREELANCE WEB AND DESKTOP DEVELOPERS FOR A SMALL AND MID-SIZED BUSINESSES. I WORKED ON VARIOUS TECHNOLOGIES THAT INCLUDED PHP, MYSQL AND CSS.

01/08 – 03/08 Wyeth Madison,NJ

Excel VBA Programmer

Excel Data Feed Automation, Formatting and Validation

I was hired for a short term position to work on 4 large Excel files that needed some data validation and formatting. The first major file was supposed to take approximately a month. I finished the work on the first file in 2 weeks. Ultimately, I was rewarded some more files to work on.

Data is downloaded from an in-house software by the Advertising department at Wyeth. For years, users were manually populating a major Excel file with the data downloaded. This ‘by hand’ process was prone to human errors.

So I created an Excel Add-in macro with menu/toolbar buttons that would automate the task of the file population and formatting.

I had to modify some of the C# code to capture the required data from SQL Server.

The other Excel files I worked on were similar and needed formatting and organization. All the files I worked on were coded with flexibility in mind. Most of these files could change in the future in the terms of number of tabs, the number of rows and columns in various tabs etc.

A quick way to finish the work would have been to hard-code everything but then the file would cease to work if there were structural changes. All the files were coded such that these changes could easily be incorporated in the macro by end-users.

Documentations were created in MS Word and in video format.

01/01 – 12/07 Banepa Enterprises, Inc. Jersey City

Web Developer and SEO

Web Development

Developed and maintained many database driven websites for various clients. Most of time the database is MS Access, SQL Server or MySQL. www.JustBare.com is one of the most recent clients. The client received data dumps regularly in csv format, which was then converted to Excel format through VBA and then uploaded into a SQL Server database on the web. The upload to Access is a complex process of addition, deletion and edition of recordsets in the Access database achieved through VBA and VBScript. The Excel-SQL synchronization has to be extremely accurate as it is done on a live production server. Amantel.com is another Access database driven site. The database is used by a number of employees with multiple access privileges. The admin can add, modify and remove cards and pins. Some of the other sites are mentioned towards the bottom of the resume.

The technologies used in the various sites were C#, VB.NET, jQuery, HTML, Javascript, CSS and PHP.

SEO / PPC / SMM

Optimized websites to rank in search engines for various clients particularly in the online casino industry. The process encompassed the use of business as well as technical skills. MS Access and Excel were used extensively. One Access project includes auto-creation of multiple websites with large number of pages randomly generated using random articles in the database. Another web based Access project uses XMLHTTP to fill out forms based on user entered SQL statements. Both these databases were made for developers and require a solid knowledge of Access database even as an end user.

Clients consult me regarding Facebook application, Facebook pages, Google Adwords, Yahoo Advertisement and MSN AdCenter PPC’s also.

11/00 – 12/01 AOL Time Warner New York City

Access / SQL Server / ASP / ASP / Excel / VBA Programmer

Excel

Transferred complex reports to Excel using Access and Excel VBA and macros. Created Excel templates that eased the formatting process. The Excel reports were generated after the end user selected 5 to 10 different criteria to report on. The data came from SQL Server and Access and were placed into Excel.

Tours Reconnect

Created a system that will let you switch between development and production versions of the database. The process incorporated a macro trigger that runs a number of VB subroutines in modules and re-establishes connection to alternate server tables and stored procedures. The module also fixed the problems with SQL Server Views loosing primary key when linked in Access.

Database Refresh and Delivery

Originally all the linked mdb files and the necessary Excel templates were delivered to the clients in a CD-ROM. I created a VBScript file that resides with some other files and the database on a server common to all the Labels under AOL (including Atlantic Records, Elektra, WMG, WMGGS). The script basically provided the latest updates on the databases.

Tours Intranet

Recreated the Artist Master Calendar database functionalities on the intranet. The functionalities included logins, email notifications, listing, reports by criteria, adding, deleting, searching and updating the database.

With Elektra, London Sire, Atlantic Records, WMG and many other Labels under the AOL roof the reports had to be accessible from all these companies. Domain authentication was extremely important as every label wants reports on their artists only. On desktop application (which was Access 97 or Access 2000), it was not an issue, since the operating system already had information on the domain. However, on the intranet the authentication had to be carried out by actually asking the user for the domain. Stored Procedures, Views and Constraint were used more frequently as the application was distributed over several domains.

10/99 – 7/00 Morgan Stanley Dean Witter NewYork City

Access / Excel / VBA / ASP Programmer

Created a monster Excel Add-in

Every time a new addin is created in Excel, a new menu is added. The menu and the toolbars get cluttered with new menus and buttons with every addin that gets opened. The master Excel plugin solves this by automatically placing all the other addin menus under one menu. The master addin also has the ability to open and close several add-ins from one place, without installing them.

Access Reports

Sybase tables were linked to an Access database through ODBC. Forms were created using Access and VBA Class modules as front end to set criteria for reports. All the reports were generated from Access and could be exported to Word or Excel format in Access. The parameters to the pass through queries were changed dynamically and then run on the server, mostly to return recordsets.

CompanyIT

CompanyIT was created to bridge the gap among the IT departments in Morgan Stanley, Dean Witter, Discover Financial and Van Kampen. I created an Access VBA database to survey the technologies used as a preliminary step to analyzing the overall skill sets at these various companies.

An ASP website was also crated to create an attendance sheet for the Town Hall meeting for CompanyIT.

ASP

Created VB components to enhance ASP functionalities for an intranet project called PRISM. The project was for a Wealth Management Group at Morgan Stanley. The project used IIS and MTS with ASP to query Sybase and pull necessary reports. One of the tasks involved dynamic paging of the records, where the end user was able to choose the amount of information to be displayed in a page of report. The result was an include ASP file to encapsulate the functionality that could be called from any page created later.

6/99 – 9/99 Coach Carlstadt, NJ

Excel / VBA Lotus Programmer / Analyst

Transform Lotus Spreadsheets to Excel

Sets of Lotus spreadsheet files were converted to .xls files using the Conversion Wizard. The wizard, however, does not convert every element of the Lotus files into their Excel counterparts. Therefore, special macros were written in Lotus and Excel VBA to automate and facilitate the smooth conversion to the remaining elements that did not convert properly.

For instance, Lotus macros were used to list all the range names in Lotus spreadsheet and a VBA macro was used to list the range names in the converted Excel workbook. They were then compared using another VBA procedure. Any discrepancy was spelled out and changes were made manually on the basis of it.

Rewrite Lotus Macros in VBA

Every line of Lotus macro has to be written in Visual Basic code for Excel to understand them. Each line of Lotus macro compares to approximately 5 lines of VB code on average. Therefore, some of the Excel files required thousands of lines of VB code and 5 to 10 modules to categorize them.

2/99 – 5/99 Chase Manhattan New York City

Senior Technical Manager

Preliminary Y2K Risk Assessment

Copies of backed-up servers from different regional branches were shipped to our center in NY. They were restored on our server and scanned using OnMark Assess.

Use Onmark 2000 Assess with SQL Server and Access to report

OnMark had front-end to SQL Server, which was used from reporting purposes. The reports were canned and inflexible. The initial scans also produced huge text files. We created an Access database with automations that could parse the text files and update the database engine with detailed information on the scanned files. Then Access reports and Excel pivot tables were used to create reports and charts.

Remediate Excel, Access and Visual Basic files

Intranet Reports

Reports were pulled into password protected ASP driven websites for management to keep track of the work progress.

7/98 – 2/99 Morgan Stanley New York City

Access / Excel / VBA Programmer

Create Access Database to automate Y2K remediation process of MS Office products.

The database would index each file name as a primary key. We could do this in spite of the fact that many files had the same name and even the same path, because a category prefix was automatically added to all the user-deemed business critical file names through an automated process during the file downloads.

The database kept track of every single file worked on by the Y2K lab. Details like who worked on any particular file and the dates they worked on those files were accessible to the lab manager using simple ActiveX forms with Visual Basic codes. The remediated files were returned in automated fashion also. All the remediated files were zipped as an executable and emailed to the end-user with programmed documentation and an executable VB Project. The VB project would automatically archive the non-remediated files on the user’s machine and change their extensions to .old and copy the remediated counterparts to the correct UNC file system.

Convert Lotus spreadsheets and the macros in them into Excel files and VBA codes before remediating the Excel files

Write Lotus macros to assist mass Lotus-to-Excel conversion

1/98 – 6/98 Waterhouse Securities New York City

ASP / Access Assistant Developer

Debug Active Server Pages codes

VBScript, Access and HTML to create updateable web pages

Recode VBA macros in the database.

2/95 – 11/96 R. Millenium Computers Jersey City, NJ

Database Admin and Teacher

Teach Access and Excel

Create and maintain Microsoft Access database for school

A few non-intranet websites I created or worked on.

www.mai-nyc.com

A shopping site for a NYC fashion company.

www.JustBeenTested.com

STD Awareness Site

www.NepalNepal.com

This is a social networking site with video, music, blogs and forums.

This is complemented through 2 viral applications in Facebook.

www.boutiqueforchildren.com

www.PlatinumPlay.com

Casino

www.bambibaby.com

www.OpenMyNetwork.com

www.aquaskills.com

www.designeraudiovideo.com

e-commerce site

www.theeventzoo.com

event based community site

EDUCATION:

01/97 - 12/97 Career Vision, New York City

02/92 - 12/94 Concord College, West Virginia

References available upon request.

Contact this candidate