abnj1l@r.postjobfree.com
Ramesh Ayyamuthu
ROLES: EXPERIENCE SUMMARY:
• Business Systems Analyst
• • Over 12+ years of total IT experience across all stages of SDLC including
Business Analyst
• Business Analysis, Data Analysis, System Analysis, Design, Development,
Technical Business Analyst
• Testing and Implementation.
QA Analyst
• Proven experience in cross-functional domains/industries as well as
• Systems Analyst
diversified technical environments such as stand alones, client/server, web
• Data Analyst
based (Internet & Intranet), mainframe systems etc.
• Solid experience in documenting Project Plans, Business Vision Documents,
INDUSTRY:
Business Requirement Documents, Business Rules, Estimation
• Health Insurance
Summaries, Use Case Inventories, Test Plans and Naming Conventions.
• Retail
• Strong experience in creating Business/System Use Cases Diagrams &
• Transportation & Logistics
Specifications, Process/Data Flow Diagrams, Wire Frames/Screen
• Automobile
Prototypes and Functional Test Cases.
• eCommerce
• Extensive experience with Change Management. Excellent experience in
• Telecommunications
managing System Integration Testing (SIT) and User Acceptance
• Government Testing (UAT).
EDUCATION:
B.S., India 1990 – 1994
• Detail oriented and demonstrated ability to meet deadlines & project goals in
ADDITIONAL TRAINING: a fast paced and rapidly changing environments.
Flowbuilder • Proven experience in customer/client interaction, work force interaction,
JD Edwards business process out sourcing and offshore/onsite coordination.
Microsoft Visio • Excellent initiation, analytical, interpersonal, communication and
presentation skills.
CERTIFICATIONS: • Result oriented and willing to take ownership of assigned tasks.
PMP (In Progress) • Ability to facilitate meetings and provide alternative solutions as needed.
CBAP (In Progress)
WORK STATUS:
EAD (Visa sponsorship not
required)
SKILLS INVENTORY:
Tools: MS OFFICE (MS Word, MS Excel, MS PowerPoint, MS Outlook),
MS Visio, MS Share Point, MS Project, Adobe
Acrobat, Borland Silk Central Testing Manager,
Rational Requisite Pro, Rational Rose, Rational Clear
Case, Rational Clear Quest, Crystal Reports,
Dreamweaver, Mercury (Test Director), Lotus Notes
Methodologies & Standards: Iterative, RUP, Hybrid, RAD, Waterfall, SDLC, Agile, JAD, HIPAA
Databases: SQL Server, MS Access, DB2, Oracle
Languages: HTML, SQL, XML, Java Script, Java, C, .NET (C UML
CHRONOLOGICAL SUMMARY OF EXPERIENCE:
Page 1 of 8
Wellmark, Blue Cross and Blue Shield, IA 05/06 – till date
Wellmark, Blue Cross & Blue Shield is a leading health insurance provider in Iowa & South Dakota.
Role: Business Systems Analyst
Responsibilities:
• Worked mainly on the Individual and Family Insurance sector followed by Small Group, Life Insurance
& Large Group.
• Worked mainly on Membership & Eligibility followed by Claims Management & Human Resources.
• Interacted and gathered requirements from the business persons of Actuarial, Customer Services,
Internal Sales, Legal, Life Insurance, Marketing & Communications, Membership & Eligibility (IA &
SD), Security & Underwriting departments
• Analyzed requirements and prepared High Level & Detailed Business Requirement Documents.
• Created Wire frames/Screen Prototypes, Story Boards and Use Case Diagrams using HTML and MS
Visio.
• Prepared documents specifying changes & new additions to the applications, for getting approval
from the Insurance Divisions of Iowa and South Dakota.
• Validated business and system requirements against HIPAA standards and got approval from the
Legal and Security departments.
• Designed Online Health Insurance Applications in PDF format using Adobe Acrobat and validated the
fields, text and layout against the Paper Health Applications.
• Facilitated several JAD sessions for the Tyson EID conversion project to resolve a data conversion
issue.
• Interacted with the developers and approval from them before finalizing the screen design.
• Created Functional Specifications documents.
• Performed Data Analysis & Data Mapping and configured a third party Business Continuity product
Alert Find to send automated or manual notifications to Wellmark BCBS employees.
• Reviewed design documents and unit test cases.
• Redesigned workflow for the IET application, updated the business rules & updated Process Flow
documents and Tracking Actions, Events & Statuses.
• Managed Application Change Requests that includes Maintenance Requests, Enhancement Request
and New Requirements.
• Created Test Plans.
• Wrote functional test cases, prepared test data and performed System Integration Testing (SIT) &
Regression Testing.
• Prepared Requirements Traceability Matrix.
• Validated data by comparing values in RTMS – a mainframe Membership application and NRBS – a
mainframe Claims application.
• Executed SQL Queries to make sure the insurance rates are imported properly.
• Actively involved in designing Error report, Offer Acceptance report, Enrollment report & Broker
Utilization report.
• Provided support for Performance Testing.
• Performed Critical Path Analysis and created CPA charts for end to end testing.
• Managed Defect Resolution, generated Test Metrics and provided Status Reports to the
management.
• Prepared Release Notes and provided support for creating Implementation Plan.
• Coordinated User Acceptance Testing (UAT).
• Facilitated KIOT (Keep It On Track) meetings for SIT & UAT.
• Assisted developers and tech lead during production checkout.
• Actively involved in Rapid Process Improvements (RPI) meetings.
• Provided support to technical writers for updating the training materials and the user manual.
• Served as a Subject Matter Expert for the Individual & Family Insurance applications.
Page 2 of 8
Applications & Projects:
eDistribution: A web based Internet application with Rate Quote Tool, Plan Advisor, Plan Selector, Online
Application & the display of filled out application in PDF for Individual and Family, Short Term Major
Medical and Medicare Supplemental Insurances for Iowa and South Dakota for Consumers and Agents.
IET: Individual Enrollment & Tracking is a web based internal & broker application for processing and
enrolling Individual & Family, STMM & Medicare Supplemental Insurance applications.
GLADIS: Group Life and Disability Insurance System is a web based internal application for processing
Life & Disability Insurance Policies for Small Group and Large Group.
eSmile: A web based internal & broker application for generating Initial Quote, Final Quote & Post Sale
Processing for Small Group Contracts.
Tyson EID conversion: A project that converted Wellmark ID of the member to the Tyson Employee ID for
the Tyson Group. This impacted multiple applications such as EVBI, CSI, Blue Exchange, Blue Square,
Compass, IVR, WBI, WEBI, CSI etc. that involve Claims processing, Provider, Member & Group
management.
AlertFind: A Business Continuity product from Dell, configured to send automated/manual phone and
email notifications to Wellmark employees in the event of inclement weather, system crash, disasters etc.
CWR: Central Workforce Repository is a human resources data warehouse which provides data for
Payroll Processing and Organization chart.
Environment & Technologies: Windows XP, SQL Server, Web Services, MS Visio, MS Project, MS
Share Point, MS Power Point, MS Word, MS Excel, HTML, .NET, Silk Central Testing Manager, Serena
Dimensions, MS Team Foundation Server, Crystal Reports, MS Visual Studio, SDLC, Adobe Acrobat, MS
Outlook, IBM Mainframe.
Sears Holdings Corporation, Hoffman Estates, IL 09/05 – 04/06
Sears Holdings Corporation is the nation's fourth largest broad line retailer with approximately 3,900 full-
line and specialty retail stores in the United States and Canada.
Role: Business Analyst
Responsibilities:
•Facilitated meetings with a broad range of stakeholders and gathered requirements.
•Analyzed requirements, performed Data Analysis, prepared Straw Model Proposals reviewed them with
the business and refined these to Stone Model Proposals and reviewed these with the business then
finally refined these to Iron Model Proposals.
•Prepared Use Case Diagrams, Data Flow Diagrams & Process Flow Diagrams and reviewed them with
the business.
•Created functional specifications documents.
•Created Requirements Traceability matrix,
•Facilitated JAD sessions for the Gift Card Redemption module.
•Created test plan & system test cases for the Gift Card Redemption module.
•Executed System Integration Testing and managed defect resolution.
•Generated Test Metrics and provided status reports.
Applications & Projects:
eCommerce Transformation: A web based project that consolidates sears.com, kmart.com,
Kenmore.com, craftsman.com and land’s end.com into a single platform.
Page 3 of 8
Order Management: A project that consolidates Gift Card redemption, Order Management & third party
Load management into a single application.
Environment & Technologies: Windows XP, DB2, MS Visio, MS Project, MS Power Point, MS Word,
MS Excel, HTML, Java, Websphere, SDLC, Lotus Notes, IBM Mainframe.
Schneider National Inc., Green Bay, WI 08/04 – 08/05
Schneider National Inc. is a leading provider of transportation, logistics and related services. Schneider
National serves more than 80 percent of the Fortune 500 companies, offering the broadest portfolio of
services in the industry.
Role: Business Analyst
Responsibilities:
•Conducted meetings & JAD sessions with stake holders and gathered requirements.
•Prepared Use Case Inventories and Estimation Summaries.
•Designed strategic business plans, schema and road maps to achieve targets.
•Analyzed requirements and prepared Wire frames/Screen prototypes, Use Case Diagrams, Data Flow
Diagrams and Process Flow Diagrams and Use Case Documents using Visio and Word and reviewed
these artifacts with the business.
•Performed gap analysis for SRMS – Rate Server conversion.
•Developed Standards & Conventions for naming the project artifacts.
•Assisted Project Manager by doing offshore project management/coordination.
•Monitored Project Status Tracking by comparing the actual vs. planned schedule and delivered vs.
planned functionalities.
•Developed System Test Cases, coordinated System Testing and executed System & Regression Test
Cases.
•Prepared & managed pLogs for defect resolution.
•Provided support for automating test cases using Test Director,
•Updated Rate Server User Guide and created Training Materials.
•Performed End User Training and later coordinated User Acceptance Testing.
Applications & Projects:
Rate Server: A web based application with which rates can be looked up for shipments with Schneider.
This system feeds data into multiple applications such as SSP, ASP, Billing, etc. Rate Server application
is divided into Rate Lookup, Contract Maintenance and Administration.
SRMS: Schneider Rate Management System is a Visual Basic application having rate interfaces that
communicates with Mainframe. Functionalities of SRMS are being implemented in rate server in phases.
Environment & Technologies: Windows 2000, DB2, Web Services, MS Visio, MS Project, MS Power
Point, MS Word, MS Excel, HTML, Java, .Net, Iterative + Waterfall – Hybrid Methodology, Test Director,
Lotus Notes, IBM AS400, IBM Mainframe.
Daimler Chrysler, Auburn Hills, MI 01/03 –
07/04
Daimler Chrysler is the fifth largest car maker and the largest truck manufacturer in the world.
Role: Technical Business Analyst
Responsibilities:
•Facilitated meetings with the business and created Stake Holder requests.
•Developed document templates for Business Use Cases, System Use Cases, Functional Test Cases
Page 4 of 8
and Software Requirement Specification using MS Word.
•Prepared Business Use Cases, System Use Cases, Functional Test Cases and System Requirement
Specifications for the Security and the Plan Modules using MS Word and Rational Requisite Pro.
•Created Technical Requirements Document.
•Developed standards & conventions for naming, coding and version control.
•Created Screen Prototypes, Process Flow diagrams, Pie Charts for the Security and the Plan Modules.
•Performed Gap Analysis, facilitated JAD sessions and documented new business rules for the Security
module.
•Created user interfaces using XSL and XHTML.
•Performed Project Management for RLDMS project.
•Performed Data Migration from Legacy Databases (MS Access, Excel files, CSV files etc.) to DB2 UDB
and created several SQL scripts.
•Performed Functional Testing for Security and Plan Modules.
•Mentored Java technologies to the fellow developers.
•Configured Rational Clear Case for the GRCS project.
•Wrote an Ant script that checks out, compiles & builds the code and scheduled this script to run daily
using Crontab.
•Handled Change Management using Rational Clear Quest.
Applications & Projects:
VEH: Vehicle Engineering Homologation is a Visual Basic + MS Access Application that provides various
reports for presenting to the European Auto Legislative & Regulatory agencies.
EMIS: Emission Systems is a customized third party product which provides several reports for
presenting to EPA (Environmental Protection Agency) and other North American Auto Emission
standards.
SS: Safety Systems is a stand alone system that provides reports for presenting to the North American
Vehicle Safety Agencies.
GRCS: Global Regulatory Compliance System is a web based internal application that consolidates
multiple Regulatory Affair’s applications & databases, legislative requirements and outputs documents for
receiving government and agency certifications. The system has the capability to create, track & manage
the workflow and the vehicle certification process.
ICE: Impact and Crash Engineering is a web based internal application which processes a wide variety of
Impact & Crash test results and provides reports that helps the Auto Engineers.
RLDMS: Road Load Data Management System is a web based internal application which processes the
behavior of vehicles with various loads on various types of roads. This project was outsourced to a third
party vendor.
Environment & Technologies: Java, Websphere Application Server, WSAD, Tomcat, Rational Rose,
Rational Requisite Pro, Rational Clear case, Rational Clear Quest, CDS – Waterfall + RUP (Rational
Unified Process), UML, Ant, MS Excel, MS Word, MS PowerPoint, MS Front Page, XHTML, XML, XML
Spy, XSL, DB2 UDB, Solaris, Cron, Windows NT 4.0.
David Leadbetter Academy, FL 07/01 – 12/02
Role: Systems Analyst
Responsibilities:
•Assisted Project Manager with creating Business Vision Documents.
•Involved in creating UI Standards and Guidelines (Style Guide) document
Page 5 of 8
•Created Business Use Case models using Rational Rose.
•Involved with Data Modeling and created Entity Relationship Diagrams.
•Created Test Plan & Requirements Traceability Matrix.
•Generated ad hoc reports using MS Excel.
•Migrated CSV files into XML files.
•Executed System Test Cases (manual testing).
•Maintained Problem Logs for defect resolution.
Applications & Projects:
Golf Instruction Scheduling System Phase II: A web based application to schedule golf lessons,
instructors and a range of date/time.
Environment & Technologies: Java, Java Beans, JDBC 1.x, AWT, Servlet, HTML, SQL, JBuilder 2.x,
TOAD, Erwin, Windows NT.
Media3net Inc, TX 04/01 – 06/01
Role: Systems Analyst
Responsibilities:
•Migrated data from CSV and Excel files to Oracle 8i database and developed XML templates for
data transfer between Premises Gateway and Services Gateway systems.
•Migrated reports generated in MS Excel to Crystal Reports.
•Created Unit and Functional Test Scripts.
Applications & Projects:
Services and Premises Gateway System: A software product that enables the existing broadband
infrastructure to deliver on-demand data, voice and video services.
Environment & Technologies: Java, Websphere Application Server, iPlanet Application Server, MS
Excel, XML, DTD, Crystal Reports, Oracle 8i, Solaris, Windows NT 4.0.
Department Of Justice, Washington D.C 11/00 – 3/01
Role: Systems Analyst
Responsibilities:
•Performed Object Oriented Analysis & Design and prepared Use Case diagrams, Activity diagrams and
Sequential diagrams for internal administration system using UML and Visio.
•Designed and developed User Interfaces for Program Office and Program Manager Modules using
Dreamweaver.
•Documented Application User Guide and Help.
•Developed reusable classes and interfaces for common functionalities like database connections and
frequently used SQL queries.
Applications & Projects:
Grants Management System: A web based internet application that processes grant applications. The
Grantee Component provides interfaces to submit applications online and the Administration Component
provides tools to store, process & track the applications.
Environment & Technologies: iPlanet Application Server, iPlanet Web Server, JDBC 1.x, AWT, DB2
UDB, Java, Servlet 1.0, HTML, Dreamweaver, JBuilder 2.x, Rational Rose, Windows NT 4.0
Page 6 of 8
David Leadbetter Academy, FL 07/00 – 10/00
Role: Systems Analyst
Responsibilities:
•Facilitated meetings and created Stakeholder Requests.
•Created Use Case Diagrams/Documents, Activity diagrams, Sequential diagrams, Collaboration
diagrams and Class diagrams using Rational Rose.
•Actively involved in Data modeling & created Entity Relationship Diagrams using Erwin.
•Installed and Configured Apache Web server & Tomcat.
•Developed Servlets & Java Beans and interfaced Crystal reports with the system using Java Script.
Applications & Projects:
Golf Instruction Scheduling System Phase I: A web based application to schedule golf lessons, instructors
and a range of date/time.
Environment & Technologies: Java, Java Beans, JDBC 1.x, AWT, Servlet, HTML, JBuilder 2.x, TOAD,
Erwin, Windows NT.
Professional Services, India 01/00 – 06/00
Role: Java Programmer
Responsibilities:
•Created screen prototypes and process flows.
•Designed & developed Consultant and Client detail forms using Java Applets/AWT.
•Created Product/Category templates using a proprietary Template Designer.
Applications & Projects:
Health Care System: A web based Health Care product that handles the interaction between the doctor,
nurses and the hospital administration.
Environment & Technologies: Websphere Application Server 3.0, JDBC 1.x, AWT, Lotus Domino Go
W eb Server, DB2 UDB, Java, Servlet 1.0, HTML, JBuilder 2.x, Windows NT 4.0.
Durable Technologies, India 07/98 – 12/99
Role: Java Programmer
Responsibilities:
•Developed interfaces & controls for Thermal & Pneumatic State Estimator tools such as intake System,
EQR Inlet System, Exhaust System, Throttle Valve System and Rollover Orifice System.
•Developed "Idle Catalyst Monitor" which compares the Emission Standards of various catalytic
converters.
Applications & Projects:
Auto Tune Toolbox: A web based internal application that automates calibration toolboxes, which aid
engineers in the calibration process of Automobile engine management control system.
Environment & Technologies: Java 1.1, Applets, AWT, HTML, JavaScript 1.x, JDBC 1.0, IIS 3.x, Win
Runner 4.x, Windows NT 4.0.
Page 7 of 8
Hygea Minerals, India 10/97 – 06/98
Role: SQL Programmer
Responsibilities:
• Created forms for Quantity Monitors, Re-order levels, Transit-Goods, Material Handling Equipments,
Purchase, Maintenance, Repairs and Wastages for previous deals with the Vendor.
• Generated reports for Stock Movement, Goods on Order, Material Wastages, Material Requirements
and Vendor Payments.
Applications & Projects:
Indent Tracking System: A Client/Server system that handles material management. The system is
divided into Vendor Management, Stock Ledger, Equipment Summary and Reports modules.
Environment & Technologies: SQL plus, PL/SQL, Oracle Forms 3.x, Report Writer 1.1, Oracle 6.x, SQL
Import, SQL Export, SQL Loader & Solaris.
RA Auto Agency, India 12/96 – 09/97
Role: SQL Programmer
Responsibilities:
•Created forms for getting Customer Financial information, Vehicle Manufacturer's details, Vehicle details,
W orkshop location details, Technician details, Salesperson details, Warranty details, Service details,
Delivery details. Post Activity details and Insurance details.
•Developed ad hoc reports that display Locality & Vehicle relationships, Vehicle movement comparisons,
Service & Vehicle relationships, Cost of repairs and Statuses of Vehicle Financiers
Applications & Projects:
Auto Net System: A client/server application that provides valuable Vehicle & Customer information to an
Automobile dealer. It is divided into customer, vehicle, workshop and reporting modules.
Environment & Technologies: SQL plus, PL/SQL, Oracle Forms 3.x, Report Writer 1.1, Oracle 6.x, SQL
Import, SQL Export, SQL Loader & Solaris.
Page 8 of 8