Vamsi
469-834-9241
srivamsit@live.com
Profile
9+ years of experience with proven
track record in business analysis, process automation and program management,
in e – commerce, Healthcare Insurance , and Financial domains
Analysis and Program Management experience
·
Experience includes conducting Joint
Application Development (JAD) sessions, requirements gathering,
documentation (Project Charter, Business Requirement Document(BRD),
and Functional specification document (FSD)), diagramming (UML)
data and process mapping, compiling detailed project plans, and developing
test plans and test case scenarios.
·
Program management experience
involves delegating responsibilities, designing time schedules and work
breakdown structures, preparing weekly status reports for
management, communicating and presenting the reports, and resolving issues
and conflicts
·
Lead team project planning
activities. Responsible for specific streams of work
·
Participated in all phases of
Software Development Life Cycle (Agile, SCRUM, RUP, Iterative).
·
Working knowledge of CRM and ERP
systems.
·
Considerable knowledge in the
analysis, design, and re-engineering of system applications and business
processes using SDLC and Agile Methodologies.
·
Designed reports using SQL Server
Reporting Services and Crystal Reports
·
Strong database (RDBMS) skills in MS-SQL-Server
(T-SQL), PL - SQL, database design.
·
Strong analytical and problem solving
skills and ability to quickly adapt to complex environments, technologies and
new concepts
·
Excellent written and verbal
communication skills, experience in training business users in
interface usage
Technical Skills
|
|
Business Data Modelling
|
MS Visio▪Project 2010 / Power Point / Front Page ▪ MS Excel / MS Access 2010/ Word 2010, Rational Rose,
Enterprise Architect, Rational Requisite Pro, iRise, Axure
|
Content management Systems
|
Microsoft Sharepoint, Wiki, Confluence
|
Languages/.NET Technologies
|
C#,VC++, C, JAVA,ASP.NET 1.1/2.0/3.0/3.5, ADO.NET
1.1/2.0, VB 6.0, CSS
|
Databases
and supporting tools
|
MS SQL Server 2000/2005/2008, Oracle 8i/9i/10g, T-SQL, MS Access, Litespeed
5.0.2, ETL –SSIS, Informatica, Erwin, OBIEE
|
Reporting Tools
|
Frontier, MS SQL Reporting Services (SSRS), Crystal
Reports, Microstrategy
|
Testing Tools
|
HP Quality Centre, JIRA (Green Hopper)
|
Operating Systems and Web Servers
|
Windows NT - 98/2005/2008/XP/Vista, Linux, Unix,
IIS 5.0/6.0/7.0, Tomcat
|
Education
·
Master of Science, Computer Science
and Engineering, University of North Texas, Denton, TX.
·
Bachelor of Science, Electronics and
Telematics, JNTU, India.
Certifications
|
·
Microsoft Certified Technology
Specialist – Microsoft .NET Framework 2.0
|
·
Microsoft Certified Technology
Specialist – SQL server 2005
·
PMP – In progress
|
VSP Global, Sacramento, CA
Jun 2012 – Present
Business Systems Analyst, Eyefinity - WSO2/Vision Care –
Mobility
Eyefinity (PMI-EV0) is restructuring its Service Oriented
Architecture from IBM Message Broker platform to WSO2 platform. All the
Practice Management Partners will move to the WSO2 platform. This initiative
is also responsible to establish an onshore offshore working model for
Eyefinity and ProKarma. Prokarma is also responsible to asses, analyze and
create strategy for the mobile initiative at VSP at a Global level for all
the lines of businesses involved.
•
Gathered process information through
various mobile strategy meetings, for various lines of businesses within VSP.
Analyzed and assessed the existing business models, concerns.
•
Creating a roadmap and Governance
model to make sure backlog items and features are implemented with
consistency and are sustainable long term.
•
Identifying the existing logical data
farms, available infrastructure, and existing in house mobile technologies.
•
As part of Eyefinity (WSO2) -
responsible to gather and translate business requirements to functional
specifications for SOA web services
•
Defined and established a SOA
Governance team(for engineering perspective) with specific stage gates
and artefacts to support successful implementation of requested webservices
•
Drove GAP analysis and Impact analysis
sessions with partners such as OfficeMate and Acuity Logic
•
Proposed and established requirement
gathering process, created repository structure for business, functional and
technical requirements.
•
Created standardized templates for
requirement artefacts.
•
Gathered signoff on Service
Requests, Change Requests and Service Specifications
•
Followed Agile – Scrum methodology
and enabled requirement prioritization to feed into the requirements backlog,
which in turn fed the development backlog and stories.
•
Supported the sprint cycles within a
distributed Agile ( onshore – offshore) model
•
Documented the deployment process
AS-IS, identified the drag points, documented the automated solutions (
Automate Maven relase/prepare, FitNesse to automate regression testing and so
on)
Environment: Mobile ( web Vs native apps), Eclipse IDE,
SOA-WSO2, SOAP UI, Confluence (Wiki) - Gliffy, JIRA ( green hopper)MS Office,
MS Project, Windows 7, JIRA
Fidelity Investments, Westlake,
TX
Sep 2011 – Jun 2012
Lead Business Systems Analyst, OneBook (Financial)
OneBook is an initiative to move the reconciliation process
of Retail funds held by Fidelity from legacy (FOCAS) system to InvestOne and
Frontier. Reconciliation is part of the Custody and Pricing group, and
reconciles the Settled and Unsettled holdings of Retail and institutional
funds. This included an end to end analysis and documentation of the systems
involved.
•
Analyse the end to end data
flow and systems delivery for the Retail reconciliation
•
Created a process to manage the
requirements changes with impact to overall delivery
•
Managed the dependencies, project
lags, and resources to reach the new milestones.
•
Created the WBS and ETC
for all the BA’s involved across 16 different applications within the
initiative
•
Document and sign off the GAP
analysis, of the Cash Blotters, Auto settle files, transactions involved.
•
Map the required retail funds (Money
Market and Fixed Income and Equity) from legacy to the new InvestOne platform
•
Gather requirements and create the SRA
(System Requirements Analysis) and SDS( System Delivery Specification)
documents and get sign off
•
Managed resources and timelines based
on Work Breakdown Structure, effort analysis and estimate for the analysis
and testing efforts
•
Create an overall test strategy for
QA and UAT
•
Create SIT planning document
including eight inter laced applications and drive the testing initiative
•
Develop and review test plans.
execute test cases and facilitate defect resolution
•
Supported on shore and off shore
(India) development teams
•
Performed Proof of Concept testing
for Traded Vs Settled dates with six different banks – Citi, Chase Manhattan,
State Street, Bank of New York, Mellon ( Bank of New York and Mellon are
merged, but continue to have separate IT systems), Brown Brother’s and
Harriman.
Environment: FSDM (Fidelity Systems Delivery Methodology),
Frontier Securities 4.5, Check Free, MS Visio, Share point, JAVA, Oracle,
Mainframe, HP Quality Center 9.2, Cognos, Windows NT
CVS Pharmacy, Woonsocket,
RI
Apr 11 – Sep 12
Sr Business Analyst, CVS.com (e - commerce)
This project aims at merging the Single Sign on and
redesign of CVS.com pages and creating unique coupon codes. This
involves multiple business partners and vendors. JAVA and web services are
utilized for the UI and business logic design and Oracle is utilized for
data.
•
Partnered with CVSPhoto and
CVS.com business partners to ensure a successful integration of
the two websites and their security requirements
•
Draft project plans, timelines and
resource estimates
•
Identified project dependencies which
were causing the delay and created a projected plan
•
Aligned teams to one project plan for
delivery
•
gathered business requirements and
created functional specifications including creative design, screen mock ups
and wireframes
•
Gathered requirements and
specifications for Third Party Vendor; in conjunction with Commerce Hub,
created screen mock ups and use cases.
•
NetSuite ERP was utilized to maintain ecommerce relations
and and shipping and fulfilment management for specific vendors.
•
Created specifications for the data
migration of user information from CVSPhoto.com to CVS.com.
•
Co-ordinate development cycles
between onshore and off shore teams
•
Created functional specifications for
unique coupon code initiative
•
Reviewed UAT and QA test scripts with
onshore and off shore teams
•
Supported the UAT testing through
daily bug triages
Environment: MS Visio, Share point, Axure, JAVA, ATG,HP
Quality Center 9.2, Windows Server 2005/2008, NetSuite, Windows XP;
JP Morgan Chase, Lewisville, TX
June 10 – Mar11
Sr Lead Business Analyst, Agent Desktop (Retail Financial -
Mortgage)
Agent
Desktop is the default loan modification system used by Chase. It currently
supports MHA, FNMA, Freddie Mac and Chase loan modification plans. This
includes EMC heritage and BearSterns Heritage. This tool emerged from
existing excel and visual basic code based systems and currently has a .NET
UI and JAVA backend and DROOLS engine. We successfully supported the new
mandates that the government pushes on a quarterly basis.
•
Managed requirement gathering
and signoff through summits from business and cross functional teams
such as Capital markets, Reporting and Risk management teams
•
Performed GAP analysis on the
existing hierarchy, legacy mod calculator and proposed prototype
•
Supported the requirement,
development and testing phases of multiple projects with multiple vendors
like Cognizant, TCS in parallel.
•
Reverse engineered and documented the functional logic of proposed MHA changes
provided through whitepapers and VB code
•
Created screen mock ups, use
cases and workflows for the altered requirements
•
Created database update scripts,
reviewed data migration scripts, redesigned nightly data pull Extraction, Transformation,
and Loading (ETL)jobs
•
Designed API calls to add new loans
real time instead of waiting for a nightly job to update the backend data
•
Implemented the treasury error codes
for NPV 4.0 changes and triaged a speedy development to reach certification
deadlines. Drove the compliance certification initiative
•
Trained the UAT and QA
teams with new business requirements, and created and reviewed test scripts,
ran daily triages on existing bugs
•
Managed offshore regression testing
and onshore manual, performance testing teams
Environment: MS Visio, Axure, Share point, .NET 3.5, JAVA,
DROOLS, HP Quality Center 9.2, Windows Server 2005/2008, Windows XP,
Oracle DB
Microsoft, Bellevue,
WA
Jul 08 – June 10
Program Manager, AdCenter - commerce platform (e -
commerce)
FORT
is expanding to accommodate manual review of fraud scenarios in adCenter,
both for Microsoft and Yahoo platforms. This tool will utilizeETL, API calls
to fetch data, and UI will in turn enable decision reporting, negative
listing to enable not only a robust manual review process, but also help
better the automated decision algorithms. The tool was developed and
integrated utilizing .NET 3.5 n tier Framework and SQL
•
Created an overall project plan
consisting of milestones, resource allocation and dependencies
•
Supported cross functional teams FORT;
AdCenter; Microsoft Stores to address business requirements
•
Assisted merging of FORT data with Microsoft
Dynamics CRM for customer support
•
Partnered with Yahoo to integrate
their fraud detection process and requirements to FORT tool
•
Managed development team in India,
Testing team in Philippines
•
Gathered requirements from RiSK,
Fraud and adCenter analysts
•
Responsible for analysing the
existing system, SSRS reports and understanding the partner business process.
•
Developed use cases and functional
specifications to enable design and solution
•
Involved in capturing functional and
technical requirements, prepared vision document, workflowsand data modelling
specification
•
Followed top down technique for
building the business process models
•
Utilized Litespeed for DB
backup and restore
•
Maintained virtual machines using Hyper
V Manager
•
Created an overall project plan
consisting of milestones, resource allocation and dependencies
•
Reviewed the system architecture, DB
design, SSIS packages, UI design and system test plans
•
Logged bugs through share point and
VSTF
•
Conducted daily triages and ran
the war room for final delivery and release
•
Conducted walkthroughs, UAT
sessions, and assisted the development of user manuals for functional
customers
Microsoft, Bellevue,
WA
Business
Systems Analyst, Bing Cashback - commerce platform (e - commerce)
Bing
cashback team within Commerce subscription and Transaction group has a risk
and fraud operations team that utilizes internal tool – FORT (Fraud
Operations and Review Tool) to analyze, detect and prevent fraud. This tool
was developed utilizing, C#, ASP.NET hosted on IIS 7.0, utilizing .NET 3.5 n
- tier architecture
·
Gathered and documented business
requirements by conducting sessions with from Risk and Fraud analysts
·
Proposed and Incorporated DES
encryption for the secure transfer of credentials for Targus and Lexis
NexisAPI’s
·
Updated the translation table for
Visa/MasterCard responses.
·
Transitioned from 2 layer
architecture to n layer architecture, incorporating user Interface,
business layer and dataaccess layer
·
Reviewed the n tier architecture
design and class structure
·
Created use cases, activity
diagrams,and collaboration diagrams to define the data process
model, and the business process model
·
Conducted JAD sessions to
allow different stakeholders to communicate their perspectives with each
other, resolve any issues, and come to an agreement quickly
·
Established Incident reporting and
change control procedures
·
Validated technical designs created
by developers against functional specifications
·
Utilized SSIS for data import
and exportimproved the performance of existing stored procedures and triggers.
·
Horizontal partitioning was utilized, Hash based partitioning mechanism
will be used to calculate the logical partition number for a record in the
partitioned table.
·
Monitored client expectations through
client involvement and communication throughout the lifecycle of the project;
educated clients and stakeholders on the benefits and risks associated with
the project.
·
Project is currently in parallel run
and focused on v2 requirements gathering and design
Environment:MS Visio, MS Project, Share point, VSTF 2008,
SSIS, .NET 3.0, SQL 2005, C#, ASP.NET, Web Services LiteSpeed 5.2 , Hyper V
Manager, Microsoft Dynamics, Windows Server 2005/2008
BMC
Software, Houston, TX
Feb 08 – May 08
Business
Systems Analyst, IT2 Treasury Management System (Customer Support)
The treasury financial system at BMC
software upgraded its IT2 treasury management (e – business – financial
transaction) system used to communicate with other financial institution
through BankServ, this was updated and system has to be integrated with the
existing software working with banks and stock exchange, the development
architecture was based on SOA.
Responsibilities
·
Documented business and system
requirements adhering to Sarbanes Oxley (SOX) Compliance; collaborated
with developers to ensure that the customizations meet the business needs.
·
Facilitated meetings on a weekly
basis to finalize the Misys MT5XX, XML, and BankServe transaction file format
design with financial institutions like JPMC, Bank of America, CitiGroups
etc.
·
Facilitated meetings on an everyday basis to update the development team based
in London, with the support team based in India – for timely and appropriate
interface development.
·
Collaborated with business
continuity and contingency team and documented per SOX compliance,
the failover server for BMC was located in SanDiego, CA.
·
Created Use Case specifications,
business flow diagrams and Activity diagram using MS Visio, so
the developers and other stake holders can understand the business process
according to their perspective with all possible alternate scenarios.
·
Partnered with QA team to create and Test
scenarios, Test Plans and Test Cases for the System Integration
Testing, based on user requirements and functional specifications.
·
Held weekly meeting with the
development and testing team to relay any changed requirements
Environment: Rational Rose, MSOffice (MS-Word, MS-Power
Point, MS-Excel, MS Access), VB.NET, MIcrostrategy,Webservices, XML, Windows
XP/NT, Oracle 10g, Remedy CRM, SWIFT, BankServe, Mysis, Crystal
Reports
GE,
India
Nov 02 – Dec 05
Business Systems analyst, Kintana CRM
Smallworld is a proven solution used by global leaders in
the Communications industry to better manage their network infrastructure of
GE Corporate along with KINTANA (e-business) CRM.
Responsibilities
·
Interacted with the business owners
and Subject Matter Experts (SME) of various fields such as Loan Managers,
Risk Managers, Fund Managers, Asset Managers, and Project Architects to gather
client specific business requirements.
·
Gather requirements for web portals
that provide interface to the intranet as well to the internet that encompass
lending banks, credit vendors, appraisal valuators, loan officers and
underwriters.
·
Synthesized initial requirement data
to produce User Interface and business process requirements, documented the
same in BRD.
·
Creating User Requirement
Specifications, Functional Requirement Specifications and Project
Schedules.
·
Developed RUP artefacts at the
inception and elaboration phases such as Use Case diagram, Class diagram,
Sequence diagrams, Collaboration diagrams and Data models.
·
Implement business rules and to
validate the data entry process, troubleshooting crystal/SQR report problems
for AP and GL modules, setting up foundation tables for HR,
Benefits and Payroll.
·
Provided guidance to QA team for
developing scenarios for validation and testing, and resolve issues related
to specs during QA under UAT and regression testing.
·
Initiated and validated changes and
facilitated new user training and on-going training and support of project
systems, upgrades and modifications in system rules
Environment: Rational Rose, MS-Access/Word, Mercury
Kintana, MS access, Java, DB2, Oracle 9i, Win Runner on Win NT, Informatica
7, ASP.NET 2.0.
Achievements and activities
·
Completed Six Sigma training
·
Superior performance award, overall
performance from Erin Rafferty, GE India
·
Four Consecutive awards for best
voice of the Customer, GE India
·
Outstanding Student in Computer
Engineering, University of North Texas, TX
·
Eagle ambassador, promoting women in
entrepreneurship, University of North Texas
·
Creative coordinator, Public
relations officer, India(Alumni) students Association, TX