Ishendu Agrawal Latest Bio Data Resume March 2024
Ishendu Agrawal is a Netsuite technical lead at Wipro Technologies since more than 2 years
1 of 7
Download to read offline
More Related Content
Me_Ishendu_Resume_Latest_March_2024.docx
1. Page 1/7
CURRICULAM VITAE
ISHENDU AGRAWAL
House no 248/2A 2nd floor, street no 6, Virender Nagar, Janakpuri,
New Delhi 110058.
ishendu@hotmail.com
9810739947 [DOB: 19th
March 1977]
Working as a Netsuite Technofunctional Consultant/Developer
NetSuite Work Experience: 10+ years
Excellent knowledge of
NetSuite cloud ERP and Integration Apps,
NetSuite scripting 1.0, 2.0 (almost all types of client and server-side scripts including
bundle post installation scripts)
Workflows management and action scripts.
Most Functional things like a functional consultant efficiency.
Custom records management linking cross linking and parent child records management
etc.
Suitelets and Restlets. - made many integrations with restful apis and NS Suitebilling.
Map reduce scheduled scripts with code efficiency in respect to time and governance.
Saved searches and reports customizations etc.
Suite commerce SCA denali, killimanzaro, aconcagua till latest 2019.1.2 (complete end to
end implementation and detailed customization in all areas like Checkout, PLP, PDP,
domain configurations MyAccount and Shopflow, SMT and CCT design and development.
Google adwords, GTM, google reviews and Google analytics integration to a SCA site with
share bars and more.
Sitebuilder (although old but worked exhaustively on that as well)
Inventory management and adjustment.
Working with logs and Abundant cart management.
Plugins creation and maintenance. Creating JS libraries for most common scripting stuffs
for shared access.
Transaction body fields, Item Options and line fields processing.
Templates and advanced templates creation and editing for. [Emails and PDF]
Data migration.
Import csv and mass updates.
Excel VBA to code bi analytics for smart reports.
Roles and permissions management.
Intercompany journal. Entries and elimination subsidiary.
Forms and HTML template forms with exhaustive custom CSS designs and automation.
Worked with Avalara Tax.
Amazon AWS integration for capturing latest sales orders and tracking information for
shipping etc.
CRM, O2C, P2P, supply chain, complete inbound and complete outbound inventory - PO -
and SO management using restlets and NS scripting 2.0 with a JAVA middleware
application.
Requirement gathering and developing BRD and reports.
Additional Skills:
JAVA-J2EE-JSP, SQL, .NET ASP(C#), PHP, VBA advanced automating all MS office apps, SQL
Server/Oracle/MySQL, Desktop Publishing apps, Multitasking expert with team guiding spirits.
Degree/Certifications:
1. Commerce Graduate Delhi University [B. Com].
Projects as NetSuite Functional:
End to end implementation projects.[Saved Searches, MassUpdate]
Modules worked: (Procure to Pay, Order to Cash, Items, Masters, Financials, Setups,
Customization)
As NS Technical:
Worked on Restlets, Suitelets, Suitetalk on Java application, Suitetalk on .NET, Scripting, AJAX,
JSON [wrapping/binding/unbinding], Sitebuilder, SCA, Node NPM, Gulp.
As Suite Commerce Advanced Developer:
Websites on Denali, Kilimanjaro, Aconcagua [both theme and extension development],
customization on MyAccount and Checkout modules. NS Site Management Tools etc.
2. Page 2/7
Completed Projects:
1. Total Inbound and Outbound Inventory management: NOV 2019- MAY 2020
Technology used: Netsuite, Suitelets, Restlets and Scripting and integration.
Description: There was a warehouse in Dakota US and all the transactions for incoming and
outgoing material and goods are being tracked and recorded in NetSuite. We import all PO via a
middleware Java application through Restlets that every time when new information added to
warehouse triggers the Java SQL based application and we receives the fresh POs and PO
(existing) update/delete information. We also process SOs created in NS and send fulfillment
information to allot items as needed and manage the inventory alongside. There was a new feature
I have added called catchweight management which the NS system not having as out of the box
that time. Also there were variety of Suitelets developed to help he associates to update and pull
information about SO, PO, and VB with variety of roles assignments. The warehouse has bins
and racks as well and the equipped with provisions for serialized and un-serialized items, so we
have managed to record separate stock information according to the serial lot numbered inventory
at the time of issue an returns with respective prices. There was the tool at client side that they
will manage prices for some limit and we have created Restlet services that will be invoked from
the middleware Java application and we update inventory records and inventory adjustments.
2. Developed SCA 2019.1 and Aconcagua website in Belgium: MAR 2019- AUG 2019
Technology used: Netsuite, Restlets and Scripting and SCA extensions.
Description: Designed the complete topsecurity.nl website in Belgium. Implemented almost all of
their business rules and online features with variety of normal and matrix products. Also developed
many internal workflow and SO/PO management with scripts to automate some processes and
Vendor Bill management.
3. Amazon AWS connector for NS: DEC 2016- JUN 2018
Technology used: Netsuite, Restlets and Scripting.
Description: Designed the PHP middleware API to interact with Amazon AWS to import orders,
these PHP API urls were being invoked through the NS scripts to receive the JSON bound results
data and import the SO with shipping and tracking information and import these to NS SOs and
shipping records. I have also managed multiple sorts of query reports in NS to meet the variety of
dynamic needs and released in the form of suitelets exposed to multiple sites.
4. Ecommerce SCA Website developed on NS: DEC 2016- JUN 2018
Technology used: Netsuite, SCA.
Description: Designed/upgraded SCA module for British UK based client
(web:http://www.trueshopping.co.uk). Special attraction [http://www.trueshopping.co.uk/bathroom] a
page for bathroom suite to sell various bathroom products as a customizable/configurable
package having normal items, matrix items and kit package items all customizable using accordion
drop downs. The suite elements and package price gets instantly updated as customized on
product descriptions while the image gets changed dynamically as per the choice of variant or
product in options. There are kit packages single select while the Brassware has multi-select
feature and all these products gets updated in package description also gets added to cart just a
single click away for entire package elements. There are many more features added in website
that cant be described here in detail.
5. Project: Export/Import XLS Standalone Application for a US based client. . [Jan 2015
to Mar 2015]
Technology used: JAVA, Web Service, Netsuite Suitetalk API.
Description: Import (Upload) the XLS file received by FedEx shipment (after customization
applied) to the Netsuite and process serially each record by searching the appropriate Sales
Order, link it and store the information in a custom record, the record being created should also
be linked to the respective SO and the SO link information should be the part of the custom record
(cross linking). The records if failed to find respective SO should be bucketed to another XLS file
along with other rejected ones with an additional column for reason of skipping.
Responsibility: Develop the entire system over NetBeans and created transaction text file log
report on per import process with timestamp. Setup the application at clients remote server and
done the testing by implement different possible test cases.
3. Page 3/7
6. Project: Online Cloud Server Configurator SSL secured C# Application for a Canada
based organisation. . [Jan 2014 to Apr 2016]
Technology used: .NET, Web Service, C#, Suitelet.
Description: The ASP.NET Application reside on secured windows 2012 server, should triggered
from customer record in Netsuite upon click on a button imports, vital information about customer
and WHOA products information to Application and present the UI for Sales Team so that they
can chose custom cloud server configuration and apply discounts as well. Finally after the Quote
generation process is completed when Application will be posted to Netsuite via Suitelet using
JSON data format which create and populate Custom Quotation Records and Create Estimate.
Further in Netsuite UI Integration has to be made upon Customer Record the Quote details are to
be listed in specific Custom Tab from where the customer can view the entire quote in online
generated PDF. The customer record also have the Edit module so that the old quote can be
revised and saved in Netsuite (serially named like 001, 002, 001a, 001b). The edit module is
supposed to retrieve the current quote to the SQL Server on Remote Server and populate the
forms for editing.
Responsibility: Develop the entire Web Application over Visual Studio using SQL Server backend
and which is triggered from within the Netsuite Customer Record. The after setting/customizing
the quote information the user clicks on Generate Quote button which wraps up multiple cloud
server details and submit over a Suitelet and JSON parameter.. Setup the application at clients
remote server and done the testing by implement different possible test cases.
7. Project: US based School Online Application for Enrollment and Re-enrollment for
students in USA. [Apr 2015]
Technology used: JAVA, Suitelet.
Description: The application aim was to deploy automated Form management while parents are
filling up forms online. The parents of existing students used to login using their parent id and
password which then allow them to add siblings of a student. The Information is to be retrieved
from the Netsuite and prefills the form. The school was having multiple campuses which are
supposed to be chosen according to the program/timing matrix record in netsuite. Also there was
provision for the extended day care options available for variety of students that parents may
choose beforehand and the fee is being paid using payflow integration. The submitted application
retrieve the payflow authorization along with pnref field which is supposed to be stored as part of
the admission application record.
The Re-enrollment process again pull all the students and siblings at once for the parent being
logging in. Then the parent is supposed to choose any particular student from the list where the
application is retrieving the student information when he/she should be enrolled in last year then
assigns the promoted grade level only when he-she did passed the existing level, If not they should
be retained in the same grade. The rest of form fields are supposed to be prefilled and only the
information for the campus and program/matrix things are updatable by parent filling application
form.
Responsibility: Develop the entire Web Application over Netsuite suitelets and JAVA on eclipse.
A small dashboard built for desktop so that the person can see the day to day admission summary
and re-enrollment progress on a single screen.
4. Page 4/7
CAREER Profile: (Present on top)
Duration : From 4-Feb-2022 Now / Present
Organization : Wipro Technologies Limited
(from 11st
May 2022 on Wipro payroll) initially with Maneva Consultancy and finally
conversion to direct Wipro payroll
Working As : Technical Lead NetSuite (PRESENT)
Major Projects Detail
Working for US based Wipro client. Work location WIPRO Technologies Gurugram
GDC (WFH). Working from home since joined, just now started in hybrid mode.
Planning and extending the existing SUiteBilling NS package with applying more Order
Request business logics to import data sent from SFDC and create subscription and
send the NS subscription details to intermediate external system FNO which sends the
Entitlement details further to be manged in Entitlement request record in NS and send
confirmation.
Currrent project support and implementation on Netsuite scripting, workflows RTR,
automation and SCA webstore extensions and themes.
Duration : From 5-Jun-2020 28-Jan-2022
Organization : Quesscorp Limited
Working As : Lead Developer NetSuite Associate
Major Projects Detail
Working for US based HCL client. Work location HCL technologies Noida NSEZ.
Working from home since joined.
Currrent project support and implementation on Netsuite scripting automation and SCA
webstore extensions and themes.
Duration : From 18-Nov-2019 28-May-2020
Organization : Chetu India Pvt. Ltd.[http://www.logitail.com; http://cronos.be ]
Working As : TM Developer - NetSuite
Major Projects Detail
Worked on SCM inbound outbound complete process for Dakota warehouse in USA.
Used a middleware JAVA application which interacts with the help of NetSuite restlets.
Design and documentation for post installation of bundled application to production
environment.
Managed post install bundle scripts to set up the production environment with access
tokens for multiple clients that access the warehouse.
Duration : From 18-MAR-2019 7-Aug-2019
Organization : TechUnido Software Solutions Pvt. Ltd.[http://www.logitail.com; http://cronos.be ]
Working As : Lead Developer - NetSuite
Major Projects Detail
Working directly for the Logitail (Belgium) on Kilimanjaro and Aconcagua.
Currrent project end to end implementation on SCA extensions and themes.
Had been to Belgium for a month on site for work.
Duration : From Aug 2018 15-MAR-2019
Organization : Yantra Tech innovation Labs Pvt. Ltd.[http://www.yantrainc.com]
Working As : Lead Developer - NetSuite
Major Projects Detail
Worked on Payflow integtration on SCA order confirmation module Aconcagua.
Worked on Email reply as approved to manage EFT automation on Payment file
Administration.
Worked on Amazon connector over PHP MWS modules and APIs to create shipment
and tracking from Amazon SO Records.
5
4
3
2
1
5. Page 5/7
Duration : From Dec 2016 June 2018
Organization : Virtual Employee (P) Ltd, Noida.[http://www.virtualemployee.co.in]
Working As : Lead Developer - NetSuite
Major Projects Detail
Designed/upgraded SCA module for client Big Home Shop Inc. UK
(web:http://www.trueshopping.co.uk). There were also internal scripting things in their
NS account for automation on features. They have their other websites as well.
Duration : From May 2016 Nov 2016
Organization : Webbee eSolutions Private Limited, Noida.[http://www.webbeeglobal.com]
Working As : Netsuite Technical Consultant/Developer and Team Leader
Major Projects Detail
Started on Netsuite Website Development on modules for Ecommerce Website
[Custom record templates and integration to the website] client Noorart [Noorart.com]
and Converting their existing site to full fleshed responsive model for mobiles and other
device while merging their mobile version site features together.
Duration : From Jul 2013 Apr 2016
Organization : Upaya - The Solution Inc.[http://www.upayasolution.com]
Working As : Netsuite Technical Consultant/Developer
Major Projects Detail
Worked on Netsuite cloud ERP Ecommerce Web Site Frontend as well as Backend for
Sales Order Processing, Fulfillment, Shipment and maintain Order Summary. Designed
Web Sites on Netsuite for the client Upayasolutions (upayasolution.com) a Canada
based Inc. include { www.matrboomie.com, www.westcastlemotel.ca,
www.parkwaymotel.ca, teeter.com, portal.foscam.us, portal.amcrest.us
www.number21sports.com, www.cgsparks.com, www.upayasolution.com etc.
Responsibility:
Create the Analysis and Design documents.
Code writing and assisting other developers.
Ensuring the objectives match the content from a purely technical perspective
Review documentation for technical flow, technical accuracy
Technical Skills Inventory
Operating System : Window Win7&8
Languages : JAVA, NLAPI - NetSuite, SuiteTalk.
Database : MS-Access, SQL server, Oracle, MySQL
Multimedia : Photoshop, CorelDraw
Others : MS-Office 2010, HTML,CSS,DHTML/scripting/Jquery
Duration : From March 2002 Dec 2005, April 2009 Jul 2013
Organization : Dolphin Process Automation Pvt. Ltd., Gurgaon.
Working As : ADVANCED SOFTWARE ENGINEER
Major Projects Detail
Worked on Netsuite cloud ERP Ecommerce Web Site Frontend as well as Backend for
Sales Order Processing, Fulfillment, Shipment and maintain Order Summary. Designed
Web Sites on Netsuite.
Reconfigured drivers in VC++ to manage Alarms by auto-restart-able windows services on
SCADA system in Delhi Metro Rail Corp. (THALES) Timarpur, Delhi.
Various MIS reports online, member login and transactions are generated.
Development of Web & Enterprise applications using JAVA and J2EE Technologies.
A comprehensive, modular, enterprise wide travel management system that automates and
integrates all the business processes of travel organizations such as travel agents, airlines, tour
operators. The product suite addresses all the critical business functions such as Operations,
Sales management and Distribution, Financial Management, Revenue Accounting and Interline
Billing, etc. It consists of different modules like flight, hotel, car, and cruise. Responsibility:
9
7
8
6
6. Page 6/7
Create the Analysis and Design documents, and coding.
Ensuring the objectives match the content from a purely technical perspective
Review documentation for technical flow, technical accuracy
Technical Skills Inventory
Operating System : Window 98/NT/2000/XP/Win7&8
Languages : JAVA, C++, C#, .NET (VB,ADO), NLAPI - NetSuite, SuiteTalk.
Database : MS-Access, SQL server, Oracle, MySQL
Multimedia : Photoshop, CorelDraw
Others : MS-Office 98/2000/XP/2007/2010, HTML,CSS,DHTML/scripting
Known as the ACHIEVER OF THE OFFICE. Solved many issues regarding development process.
Duration : From September.1999 to March 2002
Organization : Computer Maintenance Corporation (CMC)
Worked As : SOFTWARE ENGINEER & NETWORK ADMINISTRATOR
Responsibility : Developing Application Educational & Software, online examination system etc.
Managing Win NT Server & Unix administration.
In-House Developed software: Cash Flow & Fund Flow Statement Inventory Control, Payroll, School Management
Software,
Accounts with features of multiple company and year ending facilities and Auto Emailing and Fax System.
PROFILE SUMMARY
Hands on experience over Suitelets, Restlets, Netsuite Integration, Scripting,
Workflows and Templates, Desktop Application Development, E-Commerce Website
Templates and configuring Shopping Cart and Checkout modules on both site builder
and on SCA. SMT and CCT design and development.
Hands on experience Glass Fish and Tomcat web servers.
Cohesive team worker, having strong analytical, problem solving and interpersonal skills.
Developed scripts for Oracle database giving existing roles additional permissions allowing
access to the newly developed pages.
Expert Level on Access, Excel, VBA and SQL with regards to Data Management and
processes automation/standardization (UDF).
Extensive experience in data extraction, modification, transformation and data mining along
with designing customized forms and control flow (do loops, queries, and forms) procedures.
Continuous problem solving, data analysis, complex reports generation with built in macros
through data transfer between different environments.
Conceptualize the analytical methodology and solve business problems, provide strategic and
operational data-based insights to insurance business.
Modification in existing codes, development of Macro codes to increase programming
efficiency.
Developed different procedures and function in forms for performing different actions/events
using VBA.
Analyze the business problems and provide constructive solutions on customer / agents
behavior and create win-win solutions through proposed analytical solution.
Point of contact for all client call/team interaction and along with presentation to leadership
team on process improvements.
Handled teams three to six people for all issues related to career path and performance
management.
Data modification/analysis on product sales and offers on automated IVR, with respect to
different metrics such as Location, Agents Wise and Managers Wise performance for different
products. (Cross Sell, Up sell).
Responsible for extraction, manipulation/transformation, and cleaning of data on database
and have built-in different ODBC connectivitys within data management tools/office tools.
Interacting with various business owners to understand the issues and providing executives
updates and ad-hoc data analysis in a structured manner.
Lead different projects which involved data mining and analysis facilitating best service
delivery in activities to the interest of client (E-E client management and process transitions
from onshore).
10
7. Page 7/7
Technical Knowledge
Two years Diploma in Software Sciences (MAGNUM) from
TIMES COMPUTER EDUCATION
Lajpat Nagar III
Packages Known:
NetSuite Scripting 1.0 & 2.0, SCA, and Techno-functional skills.
Dbase. FoxBASE, Visual FoxPro, Lotus 123, LotSuite, MS Office, RDBMS (ORACLE SQL/PLSQL),
Photoshop, Imageready, Illustrator, CorelDraw, 2D & 3D Animation (Flash, Max), Web design and
development applications (Director, Flash, FrontPage etc.).
Languages Known:
NLAPI, Visual Basic for Applications and Bi analatics, BASIC, C, C++, VB, VB.NET, ADO.NET,
ASP.NET, C#, JAVA JDBC (Netbeans/Ecllipse), HTML (stylesheets), DHTML.
Operating Systems:
DOS, Unix, Linux, Windows 2000-XP/7/8/10 (NT Server and Workstation), MAC,
Network Systems:
Novell NetWare 2.x, 3.x, 4.x, Windows NT
Others:
Artificial Intelligence (AI), Web Designing & Programming, Software Systems Analysis and
Design (SSAD), DTP (PageMaker, CorelDraw).
Installation of Novell NetWare and WinNT (Including Hardware & Administration with Client &
Server), Cabling, Crimping, and preparing Clients. DTP on LaserJet Printers.
Good Knowledge in SDLC.
JAVA-J2EE-JSP, SQL, .NET ASP(C#), PHP, VBA advanced automating all MS office apps,
SQL Server/Oracle/MySQL, Desktop Publishing apps.
NetSuite Skills:
Suitelets, Restlets, Netsuite Integration, Workflows and Templates and PDF templates,
Scripting 1.0 and 2.0, Plugins and Library scripts, Bundles and bundles installation and post
installation scripts, Custom record management and HTML forms, other entry forms and client
scripts to apply business rules. The custom fields management for Items, Line levels and
Transaction body and line levels, Item options fields for web store.
Desktop Application Development, E-Commerce Website Templates and configuring
Shopping Cart and Checkout modules on both site builder and on SCA
Strengths :
Team Player -- Work independently, if situation demands within set deadlines (multi-
tasking).
Good with numbers strong analytical ability.
Understand the client needs and focus.
Handled complex situation proactively.
Ability to Plan and prioritize task
Personal Detail:
Date of Birth : 19th March 1977
Fathers Name : Sh. Bal Krishna Agrawal
Marital Status : Married
Nationality : Indian
Languages Known : English, Hindi and Punjabi
Passport Number : N 3016732
Dated: February 27, 2024 (ISHENDU AGRAWAL)