Lotus Notes Resume
New Jersey, NJ
Qualification Summary
A dynamic, logical thinking, performance driven IT professional, with 15 years of experience out of which thirteen years of Lotus Notes Development including 5 years of Business Analysis in the Health , Medical and Finance Industry experience and one year of Lotus Notes Administration experience using Notes version 7.01 & Notes version 8.4. Around 2 years of Sharepoint (MOSS 2007) Development experience. Possess full knowledge of Software Development process including requirements definition, prototyping, Proof of concept, design, implementation, testing and support. Also used MOSS 2007, to develop and enhance Sharepoint sites. Familiar with current industry standards such as HIPAA, SOX, Title 21 CFR Part 11 Electronic Records; Electronic Signatures. As a Business Analyst conducted interviews with key business users to collect requirement and business process information. Gather Business Requirements, analyze data/workflows. Defined the scope, financial projections and Cost/benefit analysis. Gathered Business Requirements and wrote Business Requirements Document (BRD) by working with the client IT staff, project managers.
Technical Skills
Moss 2007 (Experience in designing Sharepoint Sites , Custom Lists, Libraries, Custom Web Parts, Site Columns , Used Quest Web parts for Dashboards, Master Page Layouts, Microsoft InfoPath Forms , also used Sharepoint Designer Toolkit for building Custom Master Pages).
Lotus Notes Database Design / Programming Web Development
Unit / System Testing Business Rule Implementation / Business Analysis –MS Visio, MS Project, Borland CaliberRM, MetaVance –Claims Processing , Claims Adjudication.
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.
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
Skill Set:
Education
BE (Bachelors in Instrumentation Engineering)
Certifications
Certified Lotus Notes Specialist (CLS) &
Lotus Notes Developer Professional.
PROFESSIONAL EXPERIENCE
Confidential, November 2010-Present Lotus Notes Developer ---Migration Project)
- Working as a Sr Lotus Notes Domino Developer on Notes vers 6.5 . in Legal / Compliance Dept.
- Helping in the Migration of the Notes Documents, Field Mapping , Creating ad hox Excel Reports for the migration
- Enhancements to the Current Application and resolving day by day issues before the migration to the Pega PRPC Systems.
- Helping in Clean-Up Agents to find duplicate records , orphan records that do not have the corresponding parent records before the migration.
Confidential,Hartford , CT: June 2010-Sep 2010
(Business Systems Analyst –Conversion Project of CIGNA Phase II to MetaVance –(HiPAA Related system)
- Worked as BSA/IA on MetaVance a HIPAA-ready system that supports consumer-directed health plans, medical management and claims processing. It helps you better administer health insurance products such as HMO, PPO, CDHP, indemnity and hybrid managed care programs.
- Involved in the Data Conversion on the Claims Adjudication, Conversion from old Legacy system to MetaVance.
- Acted as a liaison between the developers and the Business Users.
- Developed use cases, workflow, screen mock-ups, and conversion requirements.
- Conducted risk engineering to derive and execute action plans on time.
- Interfaced with SMEs to prepare BPR documents for ongoing projects.
- Prioritized business and systems problems; analyzed legislation and conducted impact analysis.
- Participated in JAD & RAD sessions with Team, Users and Tech Leads
- Prepared business process models; used Visio to create use case diagrams.
- Familiar with current industry standards HIPAA.
- Worked with SQL queries for data manipulations.
- Used CaliberRM Business Requirement tool to enter Requirements, Add References to the current Business Requirement and create a Traceability Matrix.
Confidential,NJ: July 2009 - May 2010
Business Systems Analyst / MOSS 2007 Development (using Visual Studio 2005 , SQL Server 2005, ASP.net and Sharepoint Designer ) / Sr. Notes Domino Consultant (using Lotus Notes Domino version Designer 8.04 & Notes Client 8.04)
- As a Business Systems Analyst , attended meetings with respective SME’s to gather high – level requirements for the current Lotus Notes Database in order to make major changes to the claims that were above 50K$ amount.(A workflow based application to be created , in order to be approved by various Sr Executives)
- Created Process Models using MS Visio, also used Rational –Requisite Pro and ClearQuest to document high level FSD (Functional Specification Document), and BRD’s
- Participated in JAD sessions with the Team.
- Acted as a liaison between the developers and the Business Users.
- Facilitated User Acceptance Testing with other developers and testers.
- 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 and 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.
- Progressed from Problem Statement to well-documented Designs.Interacting with the developers on resolving the reported bugs and various technical issues.
- Used Requisite Pro and ClearQuest to document Business Requirements speacially new changes to be made to the application
- As a Sharepoint Analyst , Designed and implemented Data Grid Web parts to display data from SQL Server 2005 database utilizing Business Data Catalog features.
- Hands on experience with designing Custom Master Pages and custom Page layouts using Sharepoint Designer, Adding Custom Web parts, Lists and Libraries and also generating Word documents using InfoPath Forms using MOSS 2007 and ASP.net.
- Created Top Level sites and site collections. Maintained a unique look and feel across the portal by using Master Pages, CSS and HTML. Additionally designed and manipulated these pages using SharePoint Designer 2007.
- Designed and implemented Dashboard functionality using Excel services by enabling/activating appropriate features and establishing data connections to SQL Server.
- Used Java Script and .NET Validation Controls for Client side validation.
- Designed, developed, and maintained SSR (Security Service Request Database) using Lotus Notes Domino 8.4 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).
Environments: UML Rational---Requisite Pro and ClearQuest , MOSS 2007, Sharepoint Designer, Microsoft Office Infopath Forms , MS Office 2007, Windows Server 2005, SQL Server 2005, Visual Studio 2005, Notes Domino Designer 8.04 and Notes Client 8.04, Domino Servers 8.04
Confidential,NJ: April 2008-July 2009
Business Systems Analyst / Sr. Notes Domino Developer Consultant (using Lotus Notes Domino version Designer 6.5.5 & Notes Client 7.01 and some extent on Notes Client version 8.4, SAP)
- 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.
- Designed, developed, and maintained workflow applications for Compliance (21 CFR Part 11. Review (SDS Documentation), generating and executing protocols and documenting validation plans. Fully conversant in 21 CFR Part 11 (Electronic Records; Electronic Signatures) and best business practices impacting regulatory, clinical, manufacturing and safety groups.
- 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.
- Conducted risk engineering to derive and execute action plans on time.
- Interfaced with SMEs to prepare BPR documents for ongoing projects.
- Prioritized business and systems problems; analyzed legislation and conducted impact analysis.
- Participated in JAD & RAD sessions with Team, Users and Tech Leads
- 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 )
- Used SQL Queries for Data Manipulation on some applications that had SQL server at the backend.
- Created folders in Sharepoint and appropriate access to team members and SME ‘s to review the documents (FSD, BRD, TRD , and Process flow diagrams.)
- 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.
- 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.
- 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: Windows2007, Notes Domino Designer 6.5.5 & Notes Client 7.01 Client and Notes Domino 8.4 Client , SAP (SD Module)
Confidential,NY: Jan 2007-Feb 2008
Sr. Notes Domino Developer / Administrator / Business Systems 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.
- Provide 2nd/3rd Level Notes/Domino/Blackberry Admin Support, servicing an R8 environment, of 2,000+ users, on6 Domino Mail, Application and Blackberry Servers, at4 sites, in the USA, Brazil and Luxemberg, UK
- Resolved ongoing issue with multiple users who were unable to send/reply via iNotes/DWA mail, by modifying browser settings on client machines.
- Reviewed over 400 recent Notes / Domino / Blackberry tickets, as part of effort to recommend changes / modifications to the Help Desk and Notes Team, in assisting them to be more efficient.
- Discovered failed personal agents trying to run on mail servers.
- Discovered and fixed damaged adminp view. Rebuilt view by running updall -r command.
- Discovered and deleted multiple rep conflicts on ddm.nsf (Domino Domain Monitor) database hidden view.
- Discovered many users have template replication enabled on replication page, needlessly trying to replicate with many templates, multiple times, on a daily basis.
- 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
Confidential,NJ: 11/15/2006 – 03/15/2007 Business Analyst / Lotus Notes Domino Developer
- Understanding Business Requirements. Gathering and Documentation such as Functional specification Document and other project management related documents.
- Facilitate meetings with SME’s to gather requirements to build an application using Notes Domino For a Formulation Project for filing AND with FDA.
- Prepared the Process Flow , flowcharts using MS Visio , in order to capture different stages in Formulation.
- Performed Gap Analysis between Business Requirement and Functional Specs.
- Preparation of prototype for the business signoff, in tune with the Functional Spec Document.
- As a Lotus Notes Developer , Designed, Developed , a Start to End Formulations Project for filing ANDA with FDA.
Confidential,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:LotusNotes Domino version 6.5 (Client & Designer) & Windows 2003
Confidential,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
Confidential,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
Confidential,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
Confidential,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