Developer Sap
Resume:
Jyoti Gurnani
Edison, NJ - *8817
Tel #: 732-***-**** / 848-***-**** (Cell)
Qualification Summary
A dynamic, logical thinking, performance driven IT professional, with 15
years of experience out of which fourteen years of Lotus Notes Development
and one year of Lotus Notes Administration experience using Notes version
7.01 & Notes version 8.4. Possess full knowledge of Software Development
process including requirements definition, prototyping, Proof of concept,
design, implementation, testing and support.
Technical Skills
Lotus Notes Database Design / Programming Web Development
Unit / System Testing Business Rule Implementation / Business Analysis
Involved in the Deployment Analysis of Notes / web Applications Lotus
Notes 4.x, 5.x, 6.x, 7.01 & 8.4, (Also involved in piloting Lotus Notes
Applications that were created on Notes version 7.01 to version 8.4),
LotusScript, JavaScript, Lotus Formula, JavaServlets, HTML, DHTML, CSS, MS
SQL, SAP, MS Access, MS Visio, ASP.net & C# Programming.Knowledge of
Sharepoint 3.0.
Lotus Notes Sametime, Team Studio (Analyzer, Configurator and CIAO),
Notrix, LEI (Formerly Notes Pump), OLE Automation, Open Cube, Websphere 5.0
Windows 2007, Windows 2003, Vista, Windows XP, Windows 2000 Professional,
Windows NT, 5/98. OS/2 Warp
Education
BE (Bachelors in Instrumentation Engineering), Bombay University, India
Certifications
Certified Lotus Notes Specialist (CLS) &
Brain Bench Certification as Lotus Notes Developer Professional.
PROFESSIONAL EXPERIENCE
Horizon Blue Cross Blue Shield, NJ: July 2009 -- June
2010
Sr. Notes Domino Consultant (using Lotus Notes Domino version Designer 8.04
& Notes Client 8.04)
. Designed, developed, and maintained SSR (Security Service Request
Database) in order to track various security access given the
employees and consultants for various hardware and Software
Applications. In turn also created various Audit Applications in order
to Audit the User if he still requires access to the applications they
are been using. This is a total workflow based application and this
application is being used throughout the various Departments within
Horizon Blue Cross Blue Shield (HBCBS).
. Worked on a separate project to generate monthly, yearly reports for
all Over the Threshold Databases using MS Access, SQL and Excel.
Wrote and created queries to find matched nd Unmatched records and
also created various Macros to make this as an automated process.
. Involvement in gathering user requirements, prototyping, designing,
developing, testing, and support of other workflow applications such
as Horizon Family Care Enrollment Database, NASCO CareCore Over the
Threshold Database, and various other applications within HBCBS.
. Involved in software development life cycle (SDLC) of the application
from start to end from planning, designing, developing, testing (UAT),
checking and doing design analysis based on the standards followed
here at Horizon Blue Cross Blue Shield for deployment.
Environments: Windows XP, Notes Domino Designer 8.04 and Notes Client 8.04,
Domino Servers 8.04
BECTON & DICKINSON (BD), NJ: April 2008-July 2009
Sr. Notes Domino Developer Consultant / Business Analyst (using Lotus Notes
Domino version Designer 6.5.5 & Notes Client 7.01 and some extent on Notes
Client version 8.4, SAP)
. Designed, developed, and maintained workflow applications for
Compliance (21 CFR Part 11. Review (SDS Documentation), generating and
executing protocols and documenting validation plans.
. Developed application for the sales, marketing & communications
departments within BD. This application creates a new claim and
capture approvers digital signatures and claim is made active. Based
on this claim one could create various proof sources and claim
variations (The Claim Variations also have the same number of
approvers) and goes through the approval process.
. Involvement in gathering user requirements, prototyping, designing,
developing, testing, and support of other workflow applications such
as Supply Management, HR transaction change system etc. to support the
day to day business of BD.
. Created web applications using Domino server 7.01 & Lotus Notes
Designer 6.5.5 to support Everest Project -To manage vacation
schedules for SAP consultants and the SAP managers could approve or
reject consultant's vacation schedule using Blackberry.
. Involved in software development life cycle (SDLC) of the application
from start to end from planning, designing, developing, testing (UAT),
checking and doing design analysis based on the standards followed
here at BD for deployment.
. Also involved in creating Pilot applications (of migrating Lotus Notes
Applications that were created on version 6.5.5 to version 8.4 ---
Applications that were created as a Pilot project on version 8.4 are :
BD HR Change Transaction System & BD Price Quotes Database )
. Templates and the .nsf files needed to have the same design, same
template name and we also used Team Studio Build to move the changes
from the Development server to the test environment server (UAT)
server.
. Followed 3 suits of environment development, test (User Acceptance
Test) and production (Deployment).
. Used LEI in one of the Applications for the data transfer from backend
Oracle Database in the Global Security Database for creation of New
Employees / Departmental transfer of Employees.
. Used R3 connector to get data from back-end SAP (SD Module) in one of
the Notes based Application to get the pricing of the Products for
their Suppliers in a Lotus Notes Demand Capture pricing Database.
. Supported an intranet website developed in ASP.net backend SQL server
2005. Designed and developed custom .NET components and user controls
using ASP.NET and C#. Used C#, ASP.Net, WinForms, SQL Server to
develop .net components
Environments: Windows 2007, Notes Domino Designer 6.5.5 & Notes Client
7.01 Client and Notes Domino 8.4 Client, SAP (SD Module)
SAFRA NATIONAL BANK, NY: Jan 2007-Feb 2008
Sr. Notes Domino Developer / Administrator / Business Analyst (using Lotus
Notes Domino version 7.01)
. Designed & developed compliance monitoring alert system that uses ODBC
connectivity to backend MS SQL Database. This database is used as a
marketing tool for all account officers and representatives that are
not even bank employees. This application is like a feedback
Application called Know Your Client (KYC) wherein the account officers
put in their responses and the responses are submitted to the
compliance for their approval before the case is closed.
. Also developed HR based application for tracking Vacation, Sick,
Personal, and Floating Days.
. Day to day involvement in creation of new users, recertification,
deletion of users, created global archiving email policy, integration
of Notes Mail server with BES (Blackberry Enterprise 4.0 server),
messaging support, modified configuration, connection, server, domain
documents. Applied anti-virus and DST 2007 patch on Notes Servers and
BES (Blackberry Server), integrated RightFax version: 9.0 with Domino
mail server.
. Fully involved in the Business/Process Analysis, used clustering of
Domino Server for better performance and failover during replication,
wrote agents to run from enterprise vault into notes as enterprise
vault logs all the emails from mail journaling.
. Involved in deployment analysis, checking on the standards of the ACL
of the database and if the Notes application is a client or web
application, and deploying it in production, with the templates in the
root directory of the server and the databases in the respective
folder of the production server.
Environments: Windows 2007 & Notes Domino version 6.5.5 & 7.01(Client
7.01 and Designer 6.5.5) & Linux
BNP PARIBAS NY City, NY: Jun 2004 -Nov 2006
Sr Notes Developer / Consultant / Business Analyst
. Designed, developed and maintained various business / workflow
applications for fixed income capital markets division within BNP
Paribas.
. Developed applications for internal IT Audit, for entire bank for
tracking their audit programs, work papers, risk assessment memos,
audit findings and recommendation rendered, used LEI extensively to
get data from backend MS SQL Database into notes applications and vice
versa.
. Maintained 200 plus Notes applications, designed, developed a separate
intranet site for compliance wherein they could post their Compliance
Bulletins, Table of Contents, Compliance Manuals, and Compliance Forms
that user community could download.
. Used Teamstudio Configurator for global search and replace text
strings and Analyzer to test code auditing and standards compliance
violations), used CIAO tool in order to control the source code, check-
in, check-out audit trail of code changes.
. Performed a role of a Business Analyst to the entire group on issues,
enhancements, new applications that need to be created, designed,
developed workflow diagrams and the process flow charts in order to
better understand the Business Requirements and incorporated full
Software Development Lifecycle.
. Also involved in UAT Testing, and in deployment analysis Audit
trails, Standards followed in the ACL based on Notes Client or web
application )before the applications being deployed by the Notes
administrators.
Environments: Lotus Notes Domino version 6.5 (Client & Designer) & Windows
2003
Dupont Inc Wilmington-DELAWARE 04/01/2004--
05/30/2004
Sr. Lotus Notes Developer / Business Analyst (Consultant)
. Worked on various Lotus Notes Databases in order to support SAP
Project for entire DuPont. Resolve issues in existing databases,
bringing them to follow DuPont Standards and Procedures, use various
development techniques in order to streamline the Application for
better performance.
. New Enhancements as need arises for existing databases, as well as
creation of new databases. All new Database development is done using
Lotus Notes 6.0 Client.
. Databases created: SAP Batch Job Request: These requests are to detail
information in regards to jobs run in SAP. There is only one form,
and all batch requests must adhere to this form. The request requires
approval from both the business and batch team after submission.
. Create the workflow for various stages of Approval based on the
Status. Security in this database is controlled through two levels:
Database Access Control (ACL)
Database Roles
. Maintained various other databases 1. Security Access Request
Database, SAP Transport Management Database, SAP Defect Management
Database, SAP Business Scenarios.
. Also doubled up as a Business Analyst and performed detailed analysis
which included producing requirement documents for projects, also have
been responsible for assuring business requirement clarifications,
high level technical design, detailed application design, facilitating
- coding and testing & finally implementing of system solution.
Environments: Lotus Notes Domino version 6.5 (Client & Designer) & Windows
2004, SAP
COUNTRY WIDE INSURANCE, NYC,
August 2002- Mar 2004
Sr. Notes Developer / Business Analyst
. Worked on JN Docket Web Application for the Law Firm Jaffrey &
Nohavicka, extensively used MVC (Module View Controller) technology
with AS 400 as backend (DB2 Database) through Java Servlets using
Websphere (WSAD 4.0) environment and with Notes as front-end.
. Also doubled up as a Business Analyst and performed detailed analysis
which included producing requirement documents for projects, also have
been responsible for assuring business requirement clarifications,
high level technical design, detailed application design, facilitating
- coding and testing & finally implementing of system solution.
. Created and maintained project work plans with MS Project.
Environments: Lotus Notes Domino version 5.5 & 6.0, Windows 2003 &
Websphere WSAD 4.0
JP MORGAN CHASE, NYC Dec 2001-Jun 2002
Lotus Notes/Domino Developer / Business Analyst
. Responsible for Designing, development, UAT test, coordination &
maintenance of Notes & web based Domino applications using Notes
Formula, Lotus Script, Java Script, HTML & DHTML etc.
NY Daily Commentary Website Database (A repository for the New York Daily
Commentary, available both as a client and via the intranet, used DHTML
cascading Style Sheets (CSS) to create the Menu Bar from a Notes View over
the web. Used Lotus Script & HTML to display the commentaries on the web
and used OLE Automation along with Lotus Script to get the data from Excel
to Notes and vice versa.
Environments: Windows XP & Lotus Notes Domino version 5.5
AVAYA / LUCENT, New Jersey April 1998 - Oct 2001
Development Manager / Lotus Notes Development
. Designed, Developed, Managed & Supported:
GES Toolset Application to support the SAP Application (SD Module). GES
database is used to record and track problems undergone in SAP testing.
Maintained & Enhanced Intranet Domino sites using Lotus Script, Java
Script, HTML and DHTM.
. Fine tuned the Website / Application depending upon the number of hits
on the site etc.
. Handled & resolved replication save conflicts by troubleshooting the
forms used in the application and wrote and scheduled agents to
automatically run on the replication conflict documents in order to
keep the most recent document and get rid of the old documents on the
Notes database for various applications.
. Maintained consistent ACL (Access Control List) and secured the
application.
. Migrated applications / databases from Lucent to Avaya and also
migrated applications from Lotus Notes version 4.6 to Lotus Notes
domino version 5.5 and further cloned them on various other servers in
AVAYA, used Notrix for the data exchange from other Databases to Notes
and vice-versa.
Environments: Windows 2000 & Lotus Notes Domino version 4.6 and Lotus Notes
Domino version 5.01, SAP
Contact this candidate