Project Data

Ramalingam Jayadevan

Certified Lotus Professional Phone No: 949-***-****

acsrda@r.postjobfree.com

Summary:

As an accomplished project leader with around 11 years of IT experience in Data Warehousing Solutions, Oracle Middleware, and developing Client/Server applications using Lotus Notes/Domino. I have proven ability with 9 Years’ experience in coding, developing and Testing Client/Server applications.

Excellent proficiency in migrating legacy LOTUS NOTES applications’ data to Oracle tables.

Strong knowledge in Lotus Domino/Notes 8.5, R7, R6.5, SQL, Unifier.

Good Knowledge with Teradata and physical implementation concepts.

Have worked in application data migration from Lotus Notes projects.

Well experienced in Development methodologies and standards, requirements analysis, writing Application Design Documents.

Strong Knowledge and experience in Application upgrade, Server Migration and Data Migration Projects.

Actively involved in Trouble shooting Real time issues, Designing, Coding & Documentation of various applications (Web based and Client based Products) Issue Management and Stake holders Communication.

Committed with strong analytical and problem solving skills.

Education:

Bachelor of Engineering in Information Technology, Bharathiyar University, Coimbatore, 1999-2003.

Training and Certification:

Teradata basics, Physical Implementation, and SQL.

Certified Lotus Professional.

Technical Skills:

Data warehousing

TERADATA

Groupware

Lotus Notes Domino 6, 7.X, 8.5 (Both Web and Client)

Operating System

WIN NT, WIN XP

RDBMS

Oracle, SQL.

Languages

Lotus Script, Lotus Formula language, JavaScript.

Oracle Middleware

Primavera Unifier

Professional Experience

JPMorgan Chase: Nov 2010 to Present.

General Motors: 2006 June to Nov 2010.

Franklin Templeton Investments: 2003 July to 2006 June.

Client: JPMorgan Chase

Role: Technical Lead

Responsibilities:

SME for Access Risk Management for Corporate Investment Bank LOB.

Worked with proposal and estimates.

Managed Migration projects from Notes based workflow/repository applications to unifier, SharePoint, java platforms.

Managing the team day-to-day planning and problem- solving to meet deliverables.

Mentoring offshore team in understanding the requirement, Design approach, Code Review, test and implement the semantic solutions.

Worked with other SME/BA to finalize and sign off on the design, Code and other approvals.

Helped the team in all resolving technical issues if any.

Coordinated with QA & UAT team for closure of defects and Sign off.

Headed the post Implementation Validation for the apps Moved to the higher environment.

Adhere to the JPMC & TCS Quality Control process for every deliverables. Tracking project activities documents like DEM, Tech Specs (Design), MOM, issue log, Component & Checklist, ITSM with backup plan strategy.

Managing Lotus notes application and the team.

Point of contact for Monthly billing vitals for our LOB.

Lotus Notes Data Migration: Perform High Level Analysis of source Lotus Notes application and define Complexity level per application.

Lotus Notes Data Migration: Perform Detailed Analysis of source Lotus Notes application shortlisted by the client and come up with a Technical document describing the application functionality, security, form/field level validations, events, lookups, View selection criteria, View Action button functionalities and application navigation.

Project 1.

Client JPMorgan Chase & Co, Tampa,FL.

Project Application Administration Communication Tool (AACT).

Role Technical Lead.

Description:

AACT is lotus notes based tool used to maintain the access for all applications of IB division of JPMC. It has workflow management, Request Management, Transfer handling, Leaver handling, current access rights module. It automates the leaver process for all the inactive employees of IB and triggers transfers in case of manager or cost center changes. My responsibilities are sustain AACT operations, provide a tactical solution by enhancing AACT to handle the entitlements, and to integrate it with the new Java based tool, to make the AACT to perform SMART DELETE, SMART PROVISIONING in case of leaver and transfer. AACT use the Notrix tool to integrate with Oracle tables.

We worked on Migrating AACT to Java platform. I was involved in providing the inputs for the JAVA team to arrive the estimate, and migrating notes data and attachments to oracle tables, data migration involves more than 100 million of notes documents from several AACT notes archive db’s

Environment:

Lotus Domino Server 8.5 & Lotus Notes Client 8.5, Oracle 11g.

Experience on Projects:

Project 2.

Client JPMorgan Chase & Co, Wilmington, DE.

Project JPMC Cards Remodeling – Wave 2 - Semantic.

JPMorgan chase & co. is a leading global financial services firm and one of the largest banking institutions in the United States, with Operations worldwide.

JPMC is building an integrated customer data warehouse with a high performance, scalable, extensible, and providing a 360 view of customer, which is critical to support future growth. Currently, JPMC is in the process of sun setting existing CDW applications, and Migrating them to ICDW Integration Layer which is build on a third normal form on IBM’s Reference Data Model BDW. ICDW foundation on Overall architecture, ETL process, Data Architecture & Modeling process is already in place which needs to be extended for the new applications which are planned to be on-boarded. Overall effort is spilt to 8 Waves. There are 13 CDW applications which need to be migrated to ICDW environment as part of second wave called as “Wave 2A”.

Environment: Windows 7, MS Office, Teradata 13, UNIX Shell Scripting, Informatica Power center 9.1.0.s

Client: General Motors

Role: Team Lead

Responsibilities:

Requirement gathering.

Creation of development plan.

SME for HR and Employee placement system.

Planning and implementing the Access control (ACL).

Provided complete technical guidance to the project team.

Represented the CAB Meetings (Change Advisory board – Change management process).

Provided end user training and involved in User Manual and Technical documentation of application.

Deployed the application on the Production server from development server.

Project 1.

Client General Motors, NA.

Project Employee Approval System.

Role Requirement gathering, coding and Implementation.

Description:

This system is a HR application handling the absence, travel, Over Time, Attendance regularization and Irregular exit/entry requests. Each request has separate nsf and all interconnected through main menu. There is a separate nsf to maintain the approval flow and the users details like, department, emp no, name, leave/OT balances, Office time, weekends. The flow is based on the users department, area and group, that is each group will have its org defined in the approval flow details. The approval flow form will have separate tab to track the final approvers names.

We designed the agent for workflow, this is generic agent and used for all the seven requests with very minimal customization. The system is designed such as the business could maintain the flow without any design changes. We designed all the agents (for mass update of the data – ON DEMAND) in all formula to improve the performance. All the activities in the system are being tracked for audit purpose. The system can handle the OT lapse policy. Security implemented using reader/author fields. Report functionality available for all the requests.

Responsibilities:

Requirement gathering.

Creation of development plan.

Creating the security of the workflow to see all the approvers listed were able to sign in

Written Agents and using Lotus Script.

Provided complete technical guidance to the project team.

To ensure that the form was not editable to the user after a certain level of approval using the Formula Language and also test the form according ACL privileges and the Roles assigned.

Development and Implementation of application using Lotus Script.

Using Lotus Script fetched the data from other notes database into the current database.

Provided end user training and involved in User Manual and Technical documentation of application.

Deployed the application on the Production server from development server.

Performed Unit, Module and Integration Testing.

Environment: Lotus Domino Server 6 & Lotus Notes Client 8.5

Project 2.

Client General Motors, NA.

Project Employee placement system

Role Programmer/support

Description:

EPS is an integrated program for former and present GM/UAW employees to apply for new jobs in GM Employee calls in to VRU to apply for desired Cisco(s). The applications are inserted into the Oracle database. Using Lotus Enterprise Integrator, the Domino retrieves application and additional information from the Oracle to Notes. A plant request is created and the user approves and submits requests for a roster. Once rosters are created, job offers are issued and application statues are updated real time in Oracle.

Client: Franklin Templeton Technologies.

Role: Team Member

Responsibilities:

1.Handled production support issues for 25+ lotus notes databases covering North America regions..

2.Requirement gathering n enhancements to the applications requested by Business and creation of development plan.

3.Development and Implementation of application using Lotus Script/Lotus Formula language.

4.Performed Unit, Module and Integration Testing.

5.Co-ordinated with change implementation to the production servers.

Contact this candidate