Sr. Systems Architect And Software Engineer Resume
Derry, NH
SUMMARY:
- Sr. Systems Architect and Software Engineer who is well versed in multiple data modeling and engineering technologies. Expert level skills architecting, designing and developing solutions on the Lotus Domino / Notes platform. Experienced with data migration from/to Lotus Notes with Microsoft Outlook/Exchange as well as other data warehousing products.
- Experienced in SharePoint development as well. Relevant Lotus experience includes proficiency with XPages, LotusScript, JavaScript, JQuery, Java, Ajax, Formula language, HTML and CSS. Also experienced with all of Lotus’ tie - in products, including: IBM Connections, Confidential, LEI, Lotus Workflow, Sametime, Quickplace, Domino.Doc and the Domino/Notes API.
TECHNICAL SKILLS:
SKILLS: LOTUS DOMINO/NOTES v3/4/5/6/7/8.5/9 JAVASCRIPT LOTUS SCRIPT SHAREPOINT LOTUS FORMULA VISUAL BASIC LOTUS SAMETIME MICROSOFT OUTLOOK v98 thru v2013 AJAX MICROSOFT EXCHANGE 2007/2010 UNIX LINUX XPAGES HTML 4/5 JQUERY XML ASP SQL JSON JAVA LOTUS CONNECTORS W/ Confidential (LOTUS SCRIPT EXTENSIONS) PHP LOTUS QUICKPLACE DATA WAREHOUSING DOMINO.DOC C / C++ LOTUS NOTES C/C++ API SAP BUSINESS INTELLIGENCE LOTUS WORKFLOW MAPI / EXTENDED MAPI LOTUS ENTERPRISE INTEGRATOR (lei / NotesPump) CSS v3/4 Replic - Action WORDPRESS WEB DESIGN Notrix MICROSOFT ACCESS WEB SERVICES SQL SERVER 2005/2008 ECLIPSE SEARCH ENGINE OPTIMIZATION (SEO) E-COMMERCE SOLUTIONS MICROSOFT FRONTPAGE
PROFESSIONAL EXPERIENCE:
Confidential - Derry, NH
Responsibilities:
- Part of a team building a large internal web application for safety and compliance reporting. This project is being built against a Lotus Domino 9.0 backend. The front-end is custom HTML 5.0, JavaScript, LotusScript, AJAX calls, JSON and some Formula language.
- Frameworks, libraries and tools being used are Bootstrap, JQuery, Chosen and Formvalidation.io
- Application is built upon 16 databases from 4 different Notes template designs. A common tabbed UI is presented to the user as the front-end. Security features are implemented for segregating allowable features to authorized users.
- Agents are being created to handle mail flow, AJAX calls, document ID numbering, etc. Many script libraries are also being designed for common module usage.
- Dynamic backend data retrieval via AJAX calls to the Domino databases is used for seamless work flow activities.
Confidential - Derry, NH
Responsibilities:
- Long term remote contract working on multiple projects
- One project was converting the existing external HR site (which had been developed using Visual Basic) to SharePoint 2007
- Created Sites, site collections, content types, custom lists and libraries, Meta data, tagging and image mapping to the HR site
- Worked on the migration of a SharePoint 2007 site to SharePoint 2010
- Another large project was designing and developing enhancements to a suite of web based Domino R8.5 applications for corporate intranet usage
- Handled all security concerns as related to ACL's, roles, policies and workflow issues
- Made use of XPages and Domino Web Services to deliver cross-platform applications
- XPages work was making use of DOJO and AJAX to refresh selective page parts
- Front-end work built using JavaScript, JQuery, HTML 4/5, LotusScript, CSS 3 and AJAX agent calls for partial page updating
- Server side coding was accomplished using C++ and ASP
Confidential - Derry, NH
Responsibilities:
- Working with international team to design, enhance and maintain a highly complex sales analytic system in use by a very large community of end users and management teams.
- Handle all new feature requests by analyzing, designing and then implementing into the total sales application. Work with requesting end users to gather data requirements and present impacts on existing system.
- System is currently organized into roughly 12 Lotus Notes database solutions, each over multiple lines of business. Code is being written in LotusScript, JavaScript and Formula language.
- Additional project was to take existing Notes application and convert to web based using XPages while adding some additional usability features.
- Data warehousing is stored on multiple systems throughout the organization. These include COGNOS, SAP, DB2, and other Lotus Notes data sources. SQL stored procedures and functions are being created for faster and smoother transaction processing. Necessary modifications and enhancements on servers is being written in Java. LEI was used for stage one data transfer from DB2 and SQL databases.
- A common dashboard / reporting interface has been developed for use across global boundaries while also customizing unique geographical requirements as needed for each business unit.
- Lotus Notes development work is being performed using Domino versions 8.5 and 9.0.
- Used Confidential LC (Lotus Connectors) to connect to Sybase and DB2 for retrieving and updating some backend data.
- Data consolidation is key for report generation, data export and import as well as scheduled agents throughout the day for data synchronization (with regards to load balancing).
Confidential - Tewksbury, MA
Responsibilities:
- Architect and developer of a custom audio and web conferencing system (ConferenceManager)
- Responsible for designing and coding calendar and scheduling user interfaces between the conference server and desktop calendaring programs such as Lotus Notes, Microsoft Outlook, Gmail, etc.
- Outlook functionality was developed as Add-ins via DLL’s and Active-X components, including embedded Active-X controls (OCX) on custom forms
- Built for Outlook versions 2000, 2002(XP), 2003, 2007 and 2010 for Windows XP, Vista and Windows7
- Developed using Visual Studio tools and Visual Basic utilizing the OOM (Outlook Object Model), COM and Extended MAPI interfaces to the MS Exchange 2003/2007 servers
- Administrated all Lotus Domino servers and configured all workflow, managed ACL's, Policies, User Accounts, Application support and end user requests
- Lotus Notes functionality was designed and coded into templates for Lotus Notes / Domino versions 6.5, 7.0, 8.0, 8.5 and 9.0.
- Web versions were built under an AJAX framework and utilized an XPages design built around JavaScript libraries as well as using the DOJO toolkit
- Agents, Lotus Script Libraries, Forms, Sub-Forms and Views were all built as needed for front-end work in JavaScript, HTML, CSS 3 and LotusScript.
- Prepared for use with Domino Global Workbench in anticipation of international rollout
- All interfaces needed to allow user to fully integrate into their calendaring program and sync to Blackberry handheld devices while providing information back to the conference manager, BES server and SQL server 2005 and 2008
- Code was written on Windows 2003 and 2008 servers for the conference manager side in multiple languages including SQL, Java, ASP, C++, JavaScript, VBScript and HTML
- Helped customers migrate from Lotus Domino to Microsoft Exchange server 2003 and 2007
- Worked directly with customers to resolve escalated problems and offer solutions
Confidential - Boston, MA
Responsibilities:
- Was responsible for the design and development of multiple applications based on the Lotus Domino / Notes platform, versions R5 and R6 running on an IBM AIX UNIX system
- Designed a Lotus Domino web app for the 529 College Savings program interfacing with an ASP front end using Active Directory for authentication
- Wrote shell scripts to obtain, enter, and extract data from MySQL database to generate .CSV output
- Approximately 20,000 users registered in a secondary NAB and each with a unique Profile document. Agents, Forms, HTML and LotusScript Libraries were heavily used for handling Newsletter creation, email functions, registration/de-registration, updating, etc
- A second Notes application was in support of the Human Resources (HR) department. A unification of multiple separate databases, enhanced functionality, new scheduled agents for extracting data and formatting in XML for transmission to a third party company and web enabling the entire application
Confidential - Cambridge, MA
Responsibilities:
- Design and developed a Domino R6 web based sales opportunity tracking and reporting system
- This web site was responsible for handling all approval, risk review, data gathering and validation, PO revenue sharing and workflow routing for a new business opportunity across multiple lines of business (LOB)
- Lotus Workflow was employed to handle routing of documents through their many stages and to all the necessary recipients for approval
- Lotus Domino Document Manager (Domino.Doc) was used for repository of all opportunities and supporting documentation
- Application was comprised of multiple Forms, Sub-forms, Script Libraries, Agents and Views, all written in a combination of Java, JavaScript, LotusScript, Pass-thru HTML and Formula language
Confidential - Boston, MA
Responsibilities:
- Designed, coded and implemented a multi-part financial based web site written for the Lotus Domino R6 platform as part of a financial institution buyout
- Coding was accomplished using JavaScript, Lotus Script, HTML, Formula language and Java applets
- Extensive front-end data input validation was designed into the web site to negate user input errors
- Backend data was retrieved, compared, modified and auto-populated to the front-end from both SQL Server and FoxPro databases
- Common script libraries were developed for ease of maintainability and enhancement
- ACL and other security methods were implemented along with Administrator only maintenance views and forms
- Where necessary, web agents have been designed and implemented along with the use of CGI variables
Confidential - Hawthorne, NY
Responsibilities:
- Contracted to work on the design and development of two Lotus Domino R5 and R6 applications used for performing complex analysis and predictive calculations on software development life cycles
- A complete user interface was built to retrieve mandatory and optional data from the user, along with table data from various other sources and were all used in the multiple LotusScript libraries developed to perform the analysis, calculations and report generation
- Import/export routines were also developed, including sources from spreadsheets and text files along with destinations including DB2 and ACCESS databases and other ODBC registered sources.
- Lotus Enterprise Integrator (LEI / Notespump) was utilized for the ODBC backend calls to a DB2 database and a SQL data warehouse.
- Notrix was configured for data acquisition of additional base data sets
Confidential - Merrimack, NH
Responsibilities:
- Designed and developed a suite of desktop based Domino R5 applications for corporate intranet usage
- Applications developed included an expense management tool, a project time tracking tool, an HR approval process tool and a facilities inventory tool
- All applications were Domino designed web based and incorporated security features and workflow following a “Rules Based” design for the approval process
- Multiple views were built into each application for ease of navigation. Document archiving and report generation was also built into each database
Confidential - Cambridge, MA
Responsibilities:
- Responsible for the architect and development of a Lotus Notes mail and Name&Address Book add-in
- The purpose of this add-in was to allow subscribers to the Peoplestreet system who are using Lotus Notes to automatically send and receive contact information, referred to as LiveCards. This information, when received as part of an email, was disseminated and added or updated into the Name&Address Book of the user for the contact who sent the email
- Multiple forms, views, agents and script libraries were designed to facilitate the automated installation process and back end functions for checking for new program updates as well as new contact information from the Peoplestreet server
- Utilized the Notes backend classes via the API from inside new object classes. XML formatted strings were created for information transfer from the backend web server
Confidential - Natick, MA
Responsibilities:
- Developed a C++ DLL to add Lotus Domino R5 compatibility into an existing password management utility used by company IT staff
- A separate configuration executable was also written in C++ to allow customization of the module by the end user and to store the collected information into the system Registry
- This DLL was written using Microsoft Visual C++ v6.0
- The Lotus Notes C API, v5.0.3, was used to make all the necessary calls into the Lotus Notes system from within the DLL
- The use of Extension Manager Callback functions and agents were needed as well
- After password management was concluded an agent was started in a newly developed Notes R5 database, which included the use of Domino Workflow v2.1. This database used web views to allow for the multi-level approval and notification of all changes and provide an audit trail
Confidential - Cambridge, MA
Responsibilities:
- Contracted to develop Lotus Notes R5 applications for the Palm OS and Win CE WAP enabled platforms
- Applications were shipped with Lotus’ new Mobile Services for Domino v2.0 (MSD) product
- Databases developed included a contact management application (Name and Address Book), Email application, To-Do application, Journal application and Calendar application
- Responsible for prioritizing subsets of the Formula, JavaScript and LotusScript languages that were to be included in this release along with the XML compiler team
- Specific detail was paid to the conservation of physical screen space on the PDA’s, the limited development environment and to the syncing of data between the server, client and the handheld device
Confidential - Cambridge, MA
Responsibilities:
- Created a Lotus Domino R5 application for the marketing information services group
- Application pulled together specific product, part and pricing information for all Lotus products, as well as IBM and Tivoli products
- Import routines were written in HTML, Javascript and LotusScript to interface with disparate systems, including UNIX, LINUX, NT and AS-400 servers
- Complete Korn Shell script package was written for UNIX server to extract information, format it, error check and create transfer files for movement to Domino system
- An FTP process was kicked off to send these files to IBM for use in their part management system
Confidential - Danvers, MA
Responsibilities:
- Designed and coded a Lotus Domino R5 web application to calculate, format, and display sales contracts to registered customers, distributors and sales force people
- Registration into web site and verification was via an LDAP directory before the user was presented with a series of links to available options. Each option page brought up appropriate input boxes and then passed that information on to Domino via a POST method to a Domino agent
- Processing continued through a set of web based forms and lookup views. CGI variables, HTML, Javascript and LotusScript code were all used
Confidential - Lexington, MA
Responsibilities:
- Notes DB consisted of several navigators, forms and approximately 40 views. There were also a large number of agents, action buttons and supporting script libraries written to verify data, calculate service formulas and generate various management reports
- Workflow was implemented for approval processes and notifications. Lotus Notes work was written primarily in LotusScript as well as some Formula language as applicable
- SQL code (stored procedures) was written to provide proper data to Notes DB
- Set up a Domino.Doc server and rolled it out to corporate executive users
Confidential - Natick, MA
Responsibilities:
- Performed work on developing major new feature designs as well as enhancements to a Lotus Notes v4.6 sales lead and marketing data warehouse application for a software development company
- Included workflow approval processing for sales commitments, automated call-back reminders, sales information and quote projection calculations, customized sales letter and label automation, automatic daily import of telemarketing data with creation of appropriate doc/response docs
- Enhancements included new views, navigators, forms, and security measures for each sales rep to view only their data as well as the manager’s ability to view all information
- Also created detailed productivity, cumulative and total detailed reports, web links, email links, and email notifications
Confidential - Boston, MA
Responsibilities:
- Was in charge of overseeing all Lotus Notes and Domino projects being developed with regard to network engineering and messaging issues for equities group
- Lead architect in charge of working with all the Notes developers during their design stage to ensure that each new database would use the best techniques for minimizing network utilization by way of workflow and messaging
- Responsible for the design and code review of all existing database applications with regards to the same issues as above
- Assigned to recommend and/or approve new 3rd party Notes tools for business use along with setting up test systems for these tools and evaluating them and their impact on the existing network and messaging infrastructure. Tools evaluated and tested were Replic-Action, Lotus Enterprise Integrator (LEI) / NotesPump, Notrix, SameTime and Web-Archive
- Designed departmental web page using LotusScript, JavaScript and HTML, as necessary to accomplish desired results
Confidential - Framingham, MA
Responsibilities:
- Created a corporate web site. Domino.Action Site Creator was used as the design element template with specific industry requirements and changes being made to the site as necessary
- Additional extensive work was also done in Notes v4.6 LotusScript to re-design the flow, logic, functionality and workflow of a help desk call center application comprised of approximately 45 views, 12 forms, 4 sub-forms and numerous script library functions
Confidential - Danvers, MA
Responsibilities:
- Performed work on the design and coding of a complex sales quoting system in Lotus Notes v4.6 LotusScript and Formula for use by sales reps in the field as well as corporate sales team
- Multiple forms, sub-forms and script libraries were used to maintain product information for thousands of products that were kept in a separate SQL database and accessed by the main program
- Workflow was incorporated for multi-level approval depending on a set of various parameters. Data transfer of sales and product information was performed via scheduled agents between the Notes system and a SAP system
- Also wrote LotusScript code to perform OLE functions between Notes and MS Word and Excel
- An executable was written in C to monitor data passed between two different systems in flat files and then send Notes mail via the Notes VIM API