VIJAY VENKATESWARAN
*******@*****.*** 931-***-****
SUMMARY
● An MBA graduate with around 8 years experience in Scope Definition, Business Requirements, Functional
Specifications, Change Management, Impact Analysis, Technical and User Documentation, Functional
Architecture, Data Analysis, Data Manipulation, Testing, Implementation and Project Life Cycle.
● Thorough understanding of Software Development Life Cycle (SDLC) (Waterfall and AGILE
methodologies) involved in various phases like Requirements, Analysis/Design, Development and Testing
including mapping and functional specification writing
● Experience supporting various lines of businesses including Loan Origination, Loan processing and
Funding of Loans and of residential Mortgage Business and Capital Markets
● Adept in creating Narrative Use Cases, Use Case diagrams, Sequence Diagrams, Activity Diagrams,
Flow Diagrams, Sequence diagrams, Class models and other related UML diagrams. Extensive
knowledge experience using of MS Project, Visio, Word, PowerPoint, Excel, and Rational Suite
● Experience in testing backend applications using SQL and PL/SQL for Data Validation and manipulation with
databases like Oracle, MS-SQL Server and MS Access
● Adept using Gap Analysis techniques to gain a clear understanding of the AS IS of the system and
additionally derive new user scenarios to understand the potential TO BE system.
● Experience in using Automation Tools like Win Runner, Load Runner, Quality Center and Test Director in
Client /Server, Web, Database, and GUI based Applications.
● Good understanding in Business Process; identifying risk, doing risk analysis to identify the business critical
or high-risk areas of business application from USER perspective and providing baseline acceptance criteria
and deliverables.
● Good Knowledge in reviewing Test Procedures, extensively interacted with the QA Team in executing the
Test Plans for UAT, providing Test Data, creating Test Cases, Test Scripts, analyzing bugs, interacting with
team members in fixing errors, conducted multiple Regression Testing initiatives and also assisted in Post–
Production support.
● Adept at creating, editing and coordinating extensive communication networks through the facilitation of
Joint Application Development (JAD) sessions and Joint Requirement Planning (JRP) sessions, written
correspondence, reports, implementation requirements, project status reports, oral presentations and
email, to keep executive staff and team members apprised of goals, project status, and resolving issues
and conflicts.
● Extensive experience with business process analysis, process improvement, operational data analysis
and troubleshooting for middle and front office stakeholders.
● Extensively leveraged SQL queries and spreadsheets for data analysis, Rational Unified Process
methodology
● Highly motivated and goal-oriented individual with a strong background in Project Management and
Resource Planning
● Self-starter and team player with excellent analytical, learning, interpersonal skills and the ability to deliver
solutions under high stress environment.
● Very strong people skills, leadership skills, strong time management and project coordination skills. Highly
proactive, likes to take initiative. Excellent communication, co-ordination and presentation skills
● Excellent team building and problem solving skills, documentation, user training and support in conjunction
with strong business management and engineering background
TECHNICAL SKILLS:
Operating Systems Windows 7/Vista/XP/2003/2000/NT, MS DOS
Automation Tools Rational Robot, Rational Test Manager, WinRunner, Load Runner, Rational
ClearCase
Defect Tracking Tools Rational ClearQuest, HP Quality Center
Languages VB.Net, VBA, SQL, PL/SQL, SQABasic
RDBMS MS SQL Server, MYSQL, MS Access
Designing Tools Microsoft Visio, Pencil Project
Database & Reporting Crystal Reports
Web Development HTML, XML, DHTML, VBScript, Flash
Packages, Servers MS Office, Lotus Notes, Microsoft FrontPage, TestDirector
Business Modeling MS Visio, RUP, UML, Rational Rose, Telelogic DOORS
Version Control Rational ClearCase, MS Visual Source Safe (VSS)
Systems
PROFESSIONAL EXPERIENCE
Inovalon, Inc., MD March 2013 – Present
Sr. Business Analyst
Inovalon develops tools that enable rapid health care data aggregation and validation from medical facilities
for clients that include health insurance plans, hospitals, pharmaceutical companies and regulatory agencies.
Inovalon uses the aggregated data to help customers to manage risk and identify more cost efficient care
options.
• Worked in collaboration with various areas of the organization, identified additional stakeholder
requirements, and prepared use case requirement document
• Involved in analyzing business needs, requirements and functional specifications associated with new
systems development and enhancement work
• Collected and documented business processes as well as business rules. Designed and developed
Use Cases, Activity Diagrams, and Sequence Diagrams.
• Interacted with SMEs to elicit business goals and define goal-level requirements
• Participated in the analysis of detailed project scope documents for purpose of establishing a
thorough test approach and plan
• Performed Functional testing against new builds.
• Performed regression testing on all new builds.
• Executed test cases and track the Defects and ensure Closure of defects.
• Performed walkthrough with the development team and QA team and suggested modifications in the
original test plan
Fannie Mae, D.C Sep 2011 - Dec 2012
Sr. Business Analyst
Fannie Mae is the leading source of residential mortgage credit in the U.S. secondary market. Unified
Committing Portal (UCP) is a new multi-phase initiative that it has taken up to combine all of its lines of
businesses into a single portal where lenders and customers from different establishments could conduct
business with Fannie Mae. The project involved combining the single family pricing and execution tools on
one platform.
• Gathered and clarified client requirements, business needs and project objectives via JAD
and client meetings in collaboration with all stakeholders
• Created and documented project statement of purpose, project objectives and other important
components of project scope
• Identified and implemented strategies such a GAP and SWOT Analysis to ensure proper
understanding of the business needs in requirements and use case documents
• Responsible for documenting Business Requirement Document in IBM DOORS and assisted
in creation and documentation using flowcharts and Swimlane diagrams to reflect business needs in
requirements and use case documents
• Followed AGILE and SDLC software methodologies for the development cycle
• Conducted extensive research on current Selling systems and generated reports used as
support tools for Business Leads
• Explored other Enterprise Level Selling systems to come up with Industry Standard Best
Practices in the new application
• Worked with the development team to design Wire-Frame diagrams to be used as the
blueprint for the new application
• Composed Requirement Traceability Matrix documents to map Business Requirements to
the Wire- Frames
• Developed Test cases and Test scripts to test new functionality in Unit Testing and
Functional Testing
• Led the Regression Testing efforts for the new application developed
• Monitored the development of test cases and test scripts in HP Quality Center from time to
time
• Performed system testing using HP QC which was also used for for defect tracking
• Ensured that defects uncovered during Testing phase were recorded, summarized and
utilized in post project reviews to improve the development and test processes
• Participated in the User Acceptance Testing (UAT)of the application to verify and validate the
quality of the product with regard to the document needs
• Managed the Change Request process to ensure all new enhancement requests
have been accounted for in the appropriate priorities
• Provided project status reports to the Manager and Project Director on a periodic basis
Environment: Windows XP, MS SQL Server, IBM DOORS, MS SharePoint, HP Quality Center, MS Office
Bank of America, CA Sep 2010 – August 2011
Sr. Business Systems SAnalyst
Bank of America is a financial services company and is the largest bank holding company in the USA by
assets. The Home Loans and Insurance Technology (HLIT) division handles consumer lending, wholesale
lending and direct lending of housing mortgages. The EDGE system is BAC’s central Loan Closing Services
System. The current applications and interfaces have some challenges in the dynamic housing market and
the changing business needs and enhancements to the application are necessary to meet demands.
• Worked closely with business partners to define strategies for technical solutions, determine
requirements, and develop High Level functional design documents based on the analysis of Line
Of Business needs, objectives and existing systems infrastructure
• Articulated & drafted business requirements and functional specifications associated with systems
development and/or enhancement work for Domestic Mortgage systems
• Involved in interactions with the Subject Matter Experts, Project Managers, Developers, and the end-
users to determine As-Is workflow and define To-BE functionality
• Gathered product requirements to describe business needs in terms of the main deliverables or
products created and prepared System specific High Level Requirement Documents to be used as
base reference document for the effort
• Prepared Business Requirement Documents including all system impacts and changes after
eliciting the vision and the actual need for the effort.
• Created Use Cases, System Impacts, System Actions, Solution Interaction diagrams, Workflow
diagrams of existing and of proposed systems using MS Visio in HLD to ensure reliable results of
implemented business/functional processes.
• Mapped test procedures and cases to Business and Functional Requirements in specific matrices for
traceability in HLD
• Generated LoanFile XML, EDGE Friendly XML, and other forms of XML files to analyze loan data
interaction with upstream and downstream systems
• Adhered to 3-Tier Architectures and maintained data uniformity through the GUI tier, the Business
Logic tier and the Data Access tier. Analyzed and maintained data relationships and EDGE
databases in MS SQL Server - RDBMS
• Blended technical and business knowledge with communication skills to bridge the gap between
internal business and technical objectives and serve as a liaison with the business user constituents
• Conducted meetings with Project managers, SME’s, Low Level Design, Development and Quality
Assurance teams to clarify requirements and impact on scope and mitigate discrepancies
• Collaborated with Low Level Design team to translate the High Level Requirements to Technical
Specifications and draft Low Level Design Document used by the Development Team
• Worked with QA team to develop and review Test Plans, Test Scripts and Testing Strategies and
performed backend Regression Testing
• Worked with different compliance groups to ensure that the appropriate controls are identified,
documented and executed as they relate to the development and usage of systems by the business
• Created and managed the change request process and analyzed the impact of the change request
on the application in regards to Project Plan, Project Scope and Project Schedule
Environment: Windows XP, MS SQL Server, FoxPro, Visual Source Safe, MS SharePoint, LogMiner, MDR
and Viper.
MedAssurant, Inc., MD Jan 2009 – Sep 2010
Sr. Business Analyst
MedAssurant, Inc. is a leading provider of superior healthcare quality, care management, and financial
performance solutions by advanced data analysis, abstraction, and verification systems. It provides local and
national health insurance plans, employers, regulatory bodies and pharmaceutical companies with turnkey
services addressing disease management, clinical outcomes, revenue enhancement, risk adjustment,
analysis on workers compensation and healthcare data verification. This system and the database with
employer and coverage information were updated taking into account the business process changes
occurring at the board.
● Involved in interactions with the Subject Matter Experts, Project Manager, Developers, and end-users to
create the process requirements and to properly explain to the design and development team the flow of
future data modules.
● Gathered product requirements to describe business needs in terms of the main deliverables and products
created.
● Created use cases, activity diagrams, process diagrams and detailed workflow diagrams of existing and of
proposed systems using Microsoft Visio.
● Preparation and execution of test procedures and cases from business and functional specifications,
responsible for interaction with business users for UAT support and collection of requirements and
enhancements of business rules.
● Defect tracking, submission, documentation, and change requests were carried out using Rational
ClearQuest and ClearCase for version control.
● Data analysis and reporting on workers compensation lapses and penalties.
● Maintained the data dictionary to support the enhancements made to the existing system.
● Involved in monitoring the health of the database and performing corrective actions if any.
● Eliminated false requirements by screening out multiple versions of user input. Final prioritization was based
on an intensive analysis of both, product, and process requirements.
● For front-end applications, appropriate screen prototypes were presented to the business area during the
requirement sessions for approval.
● Created use-cases to ensure reliable results of implemented business/functional processes.
● Identified gaps, performed Gap and SWOT Analysis.
● Documentation of source to target mappings, the source being Mainframe copybooks, and Oracle database
the target.
● Analysis of log files created during the batch run and reporting the failures and tracking defects using PVCS
Tracker.
● Involved in creating queries using MS-Access, SQL navigator and Toad.
● Involved in defect testing, regression testing, UAT and implementing change request for final
product as and when requested by different managers.
● Prepared test data and developed SQL Queries to test values in the database tables. Utilized the benefits of
SQL Joins. “Insert Into” and “Update” and “Delete” were used during testing and in scenarios that required
tweaking data to suit the data analysis and extraction.
● Set operators such as “ Union” and “Intersect” were used to combine results to two SQL queries to generate
a single set of result.
Environment: Windows NT, HP Quality Center, MS Office, MS Excel, MS Access, Oracle, SQL, Rational
RequisitePro, ClearQuest, and Rose
Wells Fargo Home Mortgage, MN Jan 2008 – Dec 2008
Commercial Mortgage Securities Association System
Business Systems Analyst
Wells Fargo Bank is a member of the Commercial Mortgage Securities Association; the current CMSA
application has some challenges in meeting the ever-increasing CMBS market, changing need of the
business for improved functionality and automating some of the processes. The current application’s
limitations require business users to perform lots of manual tasks and functionality within and outside the
application.
● Involved in identifying features based on interviewing business
● Involved in the Functional specification documentation for enhancement identified based on user inputs.
● Extensively used ClearCase for Document versioning and ClearQuest for Bug reporting. Inhouse
Remedy, Project management software used for tracking major milestones, deadlines and deliverables.
● Drafted business requirements and functional specifications (Technical Specification Document) associated
with systems development and/or enhancement work for Commercial Mortgage systems.
● Used Telelogic DOORS Requirements Management Tool for creating Requirements Traceability Matrix.
● Coordinated the testing effort including system testing and User Acceptance Testing (UAT) with the business
users, and involved in preparing the project plan of Enhancements and tracking the same.
● Executed SQL queries for analyzing Input Data, verifying databases and validating various results.
● Used Capability Maturity Model (CMM) to ensure Policies and Procedures were followed according to the
standards and provided
● Developed Technical specifications for developers, ensuring the code accurately implements the requirements
through testing and interacting with the developers
● Worked with different compliance groups to ensure that the appropriate controls are identified, documented
and executed as they relate to the development and usage of systems by the business.
● Used Quality Center (Test Director) to write test cases for testing Functionality and to report and
track defects during the integration testing and System testing.
● Provide Project status to Technology Managers on the status and progress of the project.
● Involved in System Integration Testing, Performance Metrics Monitoring of the system
Environment: Oracle, PL/SQL, MS Project, MS Excel, Telelogic DOORS, HP Quality Center, MS
PowerPoint and MS Access,
GMAC Mortgage Corporation, PA Sep 2007 – Dec 2007
Business Analyst
The mortgage lending software helps eliminate the duplicate data entry between all departments and
becomes your "hub" for all critical loan information. The software enforces accurate data entry and supports
the multilevel Security System built. Brokers and Reps have the ability to access "live" loan status via the
Internet. Mortgage DataTrac contains hundreds of built-in business intelligence tools and reports that gives
instant access to see the exact loan activity throughout the company.
● Conducted interviews with the clients for gathering requirements and evaluation/analysis of their
data. Converted the business requirements into IT specifications.
● Participated in the requirements assessment and gap analysis for the Warehouse Management
system implementation and suggested process re-engineering and documented business
specifications for system changes.
● Identified and documented issues, risk and Gaps, their descriptions, their impact and provided
recommendation and alternatives to develop the application to meet the user requirements.
● Created and managed the change request process and analyzed the impact of the change request
on the application in regards to Project Plan, Project Scope and Project Schedule.
● Coordinated and prioritized outstanding defects and enhancement identified during UAT, and
escalated the same if necessary to achieve the deadline.
● Implemented peer reviews and created Requirement Traceability Matrix using Requisite Pro suite.
● Monitored client expectations through client involvement and communication throughout the
lifecycle of the project; educate clients and stakeholders on the benefits and risks associated with the
project.
Environment: Requisite Pro, Rose, Clear Quest, J2EE, Visual Basic, Crystal Reports, ASP, XML
Micromax Informatics Pvt. Ltd, India June 2005 – Aug 2007
Business Analyst,
Order Management System
An Order driven application, integrated with centralized inventory system for Vending machines, to classify the
request - based on the inventory, and generate orders for purchasing and delivery department.
● Collected data for Engineers and assisted management to develop System request.
● Performed Feasibility analysis for the project and made client presentations and demos.
● Worked closely with the developers to determine the critical paths in the project development.
● Coordinated the activities with the project manager, analysts and the users for the amendments required in
the project as per local condition.
● Assisted in system and user acceptance testing (UAT), perform client presentations,
● Educated engineers on the usability of the system.
● Assisted Project manager in performed the formal usability testing.
● Performing feasibility analysis; financial and operational feasibility.
● Organizing various JAD sessions..
● Developing optimization models for various business scenarios to facilitate management decision making.
Environment: HTML, Windows NT, MS Office, MS Visio
EDUCATION
Tennessee Technological University, Cookeville, Tennessee
Degree: Master of Business Administration
R.M.K. Engineering College-Anna University, Chennai, India
Degree: Bachelor of Electrical and Electronic Engineering