Rathi Mahendranath
100, Shelby Court,
[Send email to request phone number] 86-0600(H)
Simpsonville, SC – 29681
[Send email to request phone number] 70-5449(C)
rmahendranath@yahoo.com
Experience Summary
• An application specialist with a total of 12 years of IT Software Industry
experience.
• Has substantial experience in Insurance, Financial, and the ERP services
industry.
• Exposed and involved in all stages of Software development life cycle
• Self-starter, Organized, focused, team player, detail oriented and able to
work independently.
• Ability to rapidly learn and absorb new concepts and ideas with strong logical
& analytical skills.
• Expert and creative in documentation procedures. Created technical
requirements/specifications, training material and power point presentation
material.
• Hands on experience in Production support, issue escalation and resolution
process.
• Ability to handle multiple projects simultaneously.
• Has been commended for superior customer interaction on all projects to date.
• Consistently interacted with AD / Business partners / Co-workers
• Proactive in judging the risk and Produced excellent results,
• Has exposure to Global operation experience and offshore/on-site management.
• Appropriate flexibility in work hours
_____________________________________________________________________________________________
Education
Master Degree in Mathematics
Higher Diploma in Software Engineering
Diploma in Relational Database Management Systems
Certificate of Software Engineering from Pace University, NY, USA, 1995
____________________________________________________________________________________________
Organizations / Clients served for
Sr. QA Analyst, MetLife, Greenville, SC, USA Mar 2007 - Mar 2008
Systems Analyst, MetLife, Greenville, SC, USA Feb 2004 - Feb 2007
Programmer Analyst, MetLife, Greenville, SC, USA May 2000 - Feb 2004
Software Consultant, TekSystems, Greenville, SC, USA May 1998 - May 1999
Developer, PowerCerv, Anderson, SC, USA Apr 1997 - May 1998
Programmer Analyst, Cirlacs Data Systems, Chennai, INDIA Dec 1995 - Oct 1996
Senior Executive Training, Aptech, Chennai, INDIA Nov 1994 - Dec 1995
__________________________________________________________________________________
Technical Summary
Operating Systems: Windows NT/2003, Windows XP.
Languages: COBOL, C, C++, JAVA, HTML, XML, MVS COBOL, JCL and TSO
Software: SQL, Sybase Stored Procedures, PowerBuilder™ 9.0, Power TOOL, PFC,
Oracle Forms 4.5, PERL
Database: Oracle 7.1, Sybase™ 10/11, MS SQL Server 6.5, DB2
Report Writer: COGNOS Impromptu, Oracle Report Write 2.5
Testing: Mercury Quality Center
Project Management: MS-Project, MS-Office, MS-VISIO, REMEDY
Document Management: Calligo Authoring.
The core in detail…
METLIFE, Greenville, SC, USA May 2000 - March 2008
_____________________________________________________________________________________________
Sr. QA Analyst March 2007 – March 2008
ESP QC - Centralized Testing Team for all Employer Sponsored Products.
ESP QC is a centralized QA group to Test all the Employer Sponsored Products.
This team is heavily involved in System Test the applications developed by the AD
team before the products are sent to the User Acceptance Test. The team had a
goal to keep the DRE (Defect removal efficiency) count as high as possible and
ensure that the products are thoroughly manual tested, defects are logged,
tracked and reported to the management periodically using Mercury Quality
Center.
Responsible for:
• Supported QC expansion into Life Insurance Product applications by proactively
coordinating training for myself and the new consultant team. Championed change
into the Life team by introducing QC processes and reinforcing important SPS
concepts into the team.
• Created a System Appreciation Document to document all functionality of the
entire Plan Master System which was later used to train new team members.
• Lead Tester for Life GLIF Plan Master - a system developed with Sybase as
backend and PowerBuilder 9.0 as front-end. My responsibilities include Supporting
Project Management activities, Test Planning, Test Case Development, Test
Scripting, Test Data preparation, Test Execution, Defect Tracking, Reporting,
Results validation and relationship management with Plan Master Development Team.
• Used Mercury Quality Center to write Test Cases, Execute Test Cases, Defect
Logging and creating execution reports.
• During my engagement with QC team, I have been a very strong team player,
extremely effective at Time Management, enthusiastic and a quick learner of all
the new application that QC team took over in a short span of time. I was
appreciated for being very proactive and producing excellent results.
• Received a DRE (Defect removal efficiency) score much higher than the score on
prior releases in my first assignment.
• Mentored other new team members by giving several training sessions personally
as well as via web-meetings for new Off-shore resources.
• Received training from other team member from time to time to test the ATLAS
application - Advanced Total Life Administrative System developed using Mainframe
COBOL Ingenium with DB2 database.
• Attended several training classes related to Software Testing given by SQE
(Software Quality Engineering) and QAI (Quality Assurance Institute)
organizations.
• Was the back up Test Lead on BIOS - BIOS - Benefit Information Operating
System, a claims processing system that is developed using Mainframe COBOL
Ingenium with DB2 database. I supported test data preparation and test execution
for BIOS project.
• I was recently assigned the "Resource Management" task to maintain the
Resource and project allocation information for the whole organization.
• Volunteered to be part of Hospitality Committee - a team that works for the
conducting team events with in the organization.
System's Analyst Feb 2004 - Feb 2007
FEGLI (Federal Employees Group Life Insurance)
Federal Employees Group Life Insurance shortly called as FEGLI is a Claims
Processing System. It's exclusively developed for and used by the Federal
Government of United States of America.
FEGLI application is developed using PowerBuilder™ as the GUI front end and
Sybase™ as the Backend FEGLI uses COGNOS Impromptu report writer, Sybase Stored
Procedure and PERL scripts for all its report generation.
Responsible for:
• Application Developers for the FEGLI team. Involved in 5 major releases of the
application. Each release consists of Requirement Analysis, Coding, Unit Testing,
Integration Testing (Systest) and UAT (User acceptance Test) and Production
implementation.
• Worked extensively on the new enhancements and maintenance of the FEGLI
systems.
• Interacted directly with Business users to gathering requirements and
documented them as Functional and Technical requirements.
• Worked extensively in the creation of Stored Procedures in Sybase™ coded and
executed complex SQL statements for creation of the reports related to the
application.
• As part of new Development and Maintenance, I have written many new Stored
Procedures in Sybase and also created several PowerBuilder Objects. I have
extensively used SQL queries both for creating the reports as well as for the
development and testing work.
• FEGLI uses Star Team for version control. I was responsible for the checkout
and checking in of the objects. Handled the promotions from one environment to
other.
• Handled migration procedure for releases
• Worked with Dabs at New Jersey office and handled the Database related work
and issues.
• Worked with Business users at New Jersey office while testing and get the User
approval sign-off before implementing them into Production.
• Used TEST DIRECTOR (now called Mercury Quality Center) to record all my
testing results.
• Performed Peer review of other developer's work.
• Solely responsible for implementing the MS-Word Mail Merge feature to produce
FEGLI e- letters.
• Handled production support and on-call responsibilities for the FEGLI
application.
• Reduced expenses by implementing a COGNOS report change that allowed
elimination of a manual report produced by the FEGLI business team.
• Supported Simplify by developing an automated approach to address common claim
issues in the FEGLI system.
• Ensured regulatory compliance in new assignment as FEGLI SOX Control owner. I
was responsible for getting all the required documents as proof for Risk
1,2,3,6,7,8,9. Constantly maintained in the Risk Navigator and did get Audit
approvals.
Programmer Analyst May 2000 - Feb 2004
As Programmer Analyst I worked on ATLAS and BISO Correspondence, Statement of
Health Projects.
ATLAS - Correspondence -Calligo™
ATLAS - Advanced Total Life Administration System is an application used for
Enrollment and Recording Keeping for all the Group Life Institutional Business
Products. ATLAS is developed using COBOL Ingenium and DB2 database with Web based
interface as Front-End. ATLAS using Calligo for all its automatic correspondence
generation.
Responsible for:
Supported the ATLAS (Advanced Total Life Application System) application in
2001.
• Provided a key support in formatting correspondence documents for the upcoming
ATLAS releases. This involved establishing and supporting a business and working
relationship with the Disability team. During this period, I was exposed to the
Calligo™ product and the Document Management Tool developed by Insystems™,
Canada.
• Attended training courses offered by Insystems™, Advanced Calligo™
Administrator to enable me in my day to day responsibilities.
• The Calligo™ tool is used to print all correspondence letters by running a
scheduled batch job every day. The generated documents are stored in a repository
called Document Management System (DMS).
• Customized code to support integration between ATLAS and Calligo™.
• Self trained myself in Java and used the knowledge to support running the
programs that were used to invoke Calligo™ jobs.
• Performed Knowledge transfer of the systems to other team members.
• Gained knowledge in Calligo™ Authoring with XML files. Also was involved in
the Authoring setup and initial coding for the project.
• Was solely responsible for setting up the Star Team Project for BIOS
correspondence
Programmer Analyst
SOH- Statement of Health
Statement of Health (SOH) is application used for Maintenance of all SOH
requirements for the Group Life Institutional Business. SOH also called as
StarTrak is application developed using PowerBuilder as Front-end and Sybase as
Backend.
Responsible for:
• Was a team member as a PowerBuilder™ developer. I was a key contributor for
two releases of StarTrak in 2001.Responsibilites included coding, system testing
and migration of the Application to the latest versions of PowerBuilder™ and
Sybase™.
• Provided on-call support for both GLIF (Group Life), Plan Master and SOH
during my initial transition.
• Was responsible for addressing production support issues and concerns.
• Played an important role in the analysis phases of the SOH application
redesign. Also provided detailed work and cost estimates.
TEKSystems, Greenville, SC, USA
Client: Flour®, Greenville, SC, USA May 1998 - May 1999
_____________________________________________________________________
Software Consultant
Fluor's® Material Manager system is a flexible system for every type of project,
small or large with all the material management capabilities for construction
execution.
Powerbuilder ,Oracle, Sybase™ and SQL Anywhere databases.
• Material Manager organized project material management work processes into
logical modules namely Material Requirements, Purchasing, Expediting, Logistics,
Material Planning, Warehousing, Supplier Manager and Supplier Quality
Surveillance that can be customized to suit project’s requirements.
• Involved in the design and complete development of ‘Bid Maintenance’ and ‘Bid
Evaluation’ in purchasing module. Bid Maintenance includes listing of all the
issued RFQs, allowing the user to select the bidders to whom the bid should be
added. It gives the user an option to enter the required bid details in two
different formats in which they are comfortable with. Apart from providing way to
add/modify and delete bid details it also allows to maintain cost item details
and bidder notes. Bid Evaluation is a wonderful facility available, which does
the automatic evaluation of bids on two different bases namely ‘By Minimum Price’
or ‘By Lead Time’.
• Involved in the design and development of Import/Export of data across 2
different databases Oracle and SQL Anywhere Runtime using SQL Anywhere Server as
an intermediate transfer database in Supplier Quality Surveillance module. The
process involved transfer of assignments / Reports by the Project Surveillance
Coordinator in the home office to all / selected field inspectors present all
over the world who use laptops. The intermediate transfer database was emailed to
the surveyor’s laptop as a DB file to the target database using an executable
created using Visual Basic Programming. PowerBuilder's Data pipeline technique
was used extensively to achieve this task where more than 35 tables were involved
in the process.
• Involved in the design and development of almost 15 Reports in expediting
module. Expediting involves tracking Purchase Order deliverables in two different
ways namely Document Tracking and Material Tracking. Some of the major reports
worked on Expediting are Audit Trail, Calendar Change Alert, Duration Change
Alert, Material Receiving Report (MRR) Auto Update Alert, and New RFQ Alert. The
other comparison reports like PO Award greater than RAS Alert, PO Current greater
than Scheduled Alert were also developed.
• Apart from playing a major role in development, maintenance was also taken
care for various modules. Major modules worked on during maintenance are
Purchasing, Expediting, Material Requirements, Supplier Quality Surveillance and
Administration. Used PFC, PowerBuilder™ Foundation Class Library during
development of all the modules worked.
PowerCerv®, Anderson, SC, USA Apr 1997 - Apr 1998
Developer, R&D - Distribution
PowerCerv® was a leading software company which provided a complete ERP suite
with excellent features of Client / Server Architecture. The Customer Life Cycle
Product consists of Manufacturing, Distribution, Financial, Customer Asset
Management (CAM) and Sales Force Automation (SFA).
Responsible for:
• Extensive coding using PowerBuilder™ 5.0 as the front end and Sybase™ 11/MS
SQL Server 6.5 as the back end.
• Was involved in the maintenance of three versions of the existing modules.
This included periodic code fixes, Stored Procedure changes etc. Occasionally
involved in Analysis and Design.
• Familiarized with the business and working knowledge of the major modules of
the Distribution system. Some of the modules in which I had worked were the Order
Entry Process, Item Maintenance, Customer Maintenance, Inventory, Receiving,
Shipping, Invoicing, Carrier and Freight, Installation, Reference Maintenance and
Acknowledgement.
• Involved in implementing the ‘Common Query’ mechanism within the Distribution
system. Common Query allows the user to get information about any entity using
all possible combinations from one place.
• Performed Fine Tuning for the SQL used for approximately 100 Booking & Billing
Reports.
Professional Activities and Corporate Training
IT Project Management by ESI at MetLife, Greenville, SC
Software System Testing at MetLife, Greenville, SC
JIT - Just in Time Testing at MetLife, Greenville, SC
Testing Methodologies at MetLife, Greenville, SC
MVS COBOL, JCL and TSO Training from Carolina Computer Training, Greenville, SC
JCL Overview at MetLife, Greenville, SC
SPS (Single Process System) overview at MetLife, Greenville, SC
Ingenium Overview by SOLCORP at MetLife, Greenville, SC
JAVA programming at Greenville Technical College, Greenville, SC
Calligo - Advanced Technical Training by Insystems at MetLife, Liberty Cornet,
NJ
Calligo - Administration and Dispatcher by Insystems at MetLife, Greenville, SC
Introduction to XML at New Horizon Computer Learning Center, SC
DB2 - Database Stored Procedure at New Horizon Computer Learning Center, SC
Java Programming at New Horizons Computer Learning Center, SC
_____________________________________________________________________________________________
References available on request
|
