Kalpexa Patel
Sr. Business Analyst/ System Analyst
*******.*****@*****.***
Summary of Qualifications:
. An information systems professional with over 12+ years of extensive
experience as Business Analyst, System Analyst, Subject Matter Expert,
Project Management in System Analysis, Design, Development and
implementation of business applications across diverse domains such as
Stocks, Bonds, the trading cycle, Fixed income, credit cards,
commercial/investment banking, asset management, portfolio and wealth
management, Risk management.
. Extensive Knowledge in the analysis, design, and re-engineering of
system applications and business processes, using established system
analysis, business and system process design, research, and
implementation methodologies, placement of business controls,
diagramming data and process mapping, applying Unified Modelling
Language (UML), and the implementation of performance measures
. Excellent Experience in performing Gap Analysis to check the
compatibility of the existing system infrastructure with the new
business requirements.
. Expertise in the documentation of System and Business Requirements
Specifications (BRS), step-by step technical and user manuals with
illustrations, Design and Development of Use Case and Test-Case
Scenarios and conducting Root-Cause Analysis, developing test plans,
conducting user acceptance testing, training, and implementing new
processes and technology
. Extensively worked on creating of Narrative Use Cases, Use Case
Diagrams, Activity Diagrams, Class diagrams, Task diagrams,
Collaboration, State Transition, Deployment, and Sequence diagrams
using analysis and design models tools like MS Visio, Rational Rose and
Visual Paradigm through RUP and Waterfall Models.
. Solid business, communications, and presentation skills adept at
creating, editing, and coordinating extensive communication networks
(facilitation of joint application design (JAD) sessions and
interviews, written correspondence, reports, implementation
requirements, project status reports, oral presentations, e-mails,
etc.), to keep executive staff and team members apprised of goals,
project status, and resolving issues and conflicts
. Strong experience in architecture, developing and deploying web and
windows applications using .NET and Java technologies
. Strong experience in developing analytical applications like olaps,
pivot tables
. Experience in developing high-quality user interfaces using the
discipline of HCI(Human Computer Interactions)
. Creative and aggressive self-starter with integrative thinking skills,
capable of forming and maintaining positive and productive working
relationships in internal, external, independent, and team environments
. Strong team building, conflict management, time management and meeting
management skills
Technical Skills and Education:
Programming Languages: C#, Java, C, C++, T/SQL, and PL/SQL, Hyperion
Databases: SQL Server 2K, Sybase, Oracle
Web Technologies: ASP.NET, JSP, XML, XSLT, CGI, DHTML, Java script
Business Tools: MS Visio, Rational Suite, Excel, Analysis Server, MS
Project 2000, Visual SourceSafe (VSS), Caretta GUI
Design Studio, TOAD data modeller for Oracle, TOAD
for Oracle Application Developers, Clarity, Microsoft
Expression Blend 4
Operating System: Windows 3.x/98/2000/NT/XP, UNIX, Solaris 8
Other Softwares: Perforce, Nant, NUnit, TestTrack, MS Visual
SourceSafe
Education: M.S. Computer Science, Fairleigh Dickinson
University, Teaneck NJ
B.S. Computer Science
Maharaja Sayajirao University, Baroda, India
Professional Experience Summary:
Thomson Reuters (Thomson Financial), New York, NY
Nov 2006 - Current
Role: Sr. Business Analyst/ System Analyst
Worked on multiple projects in Enterprise Content group of Thomson Reuters.
Projects involved were Fixed Income Security Master (FISM), Deals
Remediation, Investment Banking (Thomson ONE Web), Global Entity Master
(GEM), Organization Authority (OA), Corporate Actions Master (CAM),
Commodities and Energy Master (C&E).
Role & Responsibilities:
. Conducted interviews with Content analyst groups located in different
geo-centers all around the world to collect information about their
legacy systems and gather business requirements for new proposed
system.
. Performed Gap Analysis between Legacy system and new proposed system.
. Created Business Requirement Document (BRD) and classified them into
primary and secondary modules.
. Used business requirements to create detailed Business Use Cases,
System Use Cases and Functional Specification documentation.
. Assisted tech leads in Analysis & Design of application architecture
using Rational Unified Process.
. Facilitated Joint Requirement Planning (JRP), walkthroughs sessions
with the Business User Groups, SME's, Senior Management and conducted
JAD sessions with the IT Community to resolve technical issues.
. Assisted the development team with a reusability analysis to achieve
reusable objects and data independence and Collaborated with
developers to determine the root cause of defects.
. Designed working prototype for key business modules using Caretta GUI
Design Studio. Created work flow simulation of the whole application
to give user hands on experience of the system.
. Conducted demo using GUI Design Studio simulator to get user feedback
before hand to save development rework.
. Created Traceability Matrix based on functional requirements to track
status of each requirement.
. Developed test strategies in partnership with developers, testers, and
facilitated user acceptance testing.
. Managed QA raised bugs/issues in Team Track.
. Used excel to create various tools to aid in requirement gathering and
data dictionaries.
. Assured that all Artefacts are in compliance with corporate SDLC
Policies and guidelines.
. Managed timely Project status repository, change requests, and issues.
. Developed extensive data dictionary of more than 500 key matrix tables
in legacy systems. Also developed automated scripts to aid in the
mapping process. The result was a comprehensive matrix database kept
online for future development and compliance.
. Based on requirements, defined logical data model.
. Participated in Code Reviews to ensure business requirements have been
addressed accurately.
. Reverse Engineered old data sets and produce data dictionaries and
logical data models.
Environment: MS-Project, EXCEL, MS Visio, MS Visual SourceSafe, Caretta GUI
Design Studio, Team Track, TOAD data modeller for Oracle, TOAD for Oracle
Application Developers, Visual Studio.net, C#, SQL Server 2005, Oracle
10.g, Thomson ONE, Clarity, XML, HTML, Microsoft Expression Blend 4
American Express, New York, NY
May 2005 - Oct 2006
Role: Sr. Business Analyst/ System Analyst
Worked on a project to develop a world class Risk Management System, in
compliance with Basel II Accord; efforts were concentrated to develop MIS
to evaluate credit risk and derive economic capital. Main responsibilities
were to perform gap analysis between legacy system and new system, gather
requirements from various business groups, and create business and
functional requirement documents.
Ameritrade, Columbia, MD
Mar 2003 -April 2005
Position: Sr. Business Analyst/System Analyst
Worked on a project to develop an Information Technology Solution for an
Online Stock Trading and Brokerage system to allow the investors trade
online in the major US stocks and options markets. Main responsibilities
included, gathering and synthesizing business requirements, developing use
cases, facilitating JRP and JAD sessions to discuss and resolve issues, and
designing look and feel of the application.
Prudential Financial, New York, NY
May 2000 - Feb 2003
Position: Business Analyst/ System Analyst
Worked on a project to develop trading system for stocks and options. Main
responsibilities included: Analysing requirements and create requirements
document, developing use cases, facilitating JRP and JAD sessions, creating
UI forms using ASP, XML and XSLT, and developing Java Script functions for
client side validations.
FrancoVago, New York, NY
Aug 1999 - Apr 2000
Role: Java Developer/Business System Analyst
Worked on a project to develop a tracking site; which offers a web
interface to track freight and cargo shipped world wide. Main
responsibilities were: developing project plan, gathering system and data
requirements, designing and developing Java based web application using
Java Servlets.
Fashion logistics Inc, Secaucus, NJ
Nov 1998 - Jul 1999
Position: Java Developer/System Analyst
Worked on a project to design and develop the inventory system and
distribution tracking for a fashion company. The program written using
"Java"; the backend data base used was "Sybase". Main responsibilities
involved: gathering and analysing functional requirements, designing ER
diagrams, and developing website using Java and Java Script.
National Informatics Center, Baroda, India
Jan 1997 - Oct 1998
Position: Database Developer/Analyst
Worked on a project to develop Payroll system for Gujarat government. Main
responsibilities included: analysing existing payroll system in FOXBASE,
designing enhanced version using Oracle 7, developing application using
Forms 3.0, and developing reports using Report Writer 2.1.
Gujarat State Fertilizer Company, Baroda, India
Jul 1995 - Dec 1996
Position: Database Developer/Analyst
Worked on a project to develop an inventory system for a product called
Nylon 6; it enabled the user to keep track of the process during various
development stages of Nylon 6. Main responsibilities included: designing
real time system using Oracle 7, developing user data forms using Forms
3.0, developing reports using Report Writer 2.1, and developing Pro* C and
store procedures to perform calculations and data manipulations.
(References provided upon request) [pic]