R ishi Srivastav
Email : r ****.***@*****.***
C ell : 320-***-****
Summary
I can define myself as a Solutions-oriented professional IT consultant who excels at managing
projects, collaborating with project teams, interfacing with clients, and deploying technology
to build successful solutions for clients. Motivated achiever with around nine years of significant,
progressive experience in information-technology consulting, focusing on Web-based and
client/server-based applications, custom development projects. Involved in gathering and
documenting business requirements based on functionality, workflow and business rules. I can
be recognized as proactive facilitator with strong communication and interpersonal skills
with expertise in conducting interviews and surveys, hosting JAD sessions, defining
requirements, sharing knowledge and performing roles in all phases of Rational Unified Process
(RUP), SDLC, UML and Agile methodologies. Skill-set also include proficiency in writing SQL
scripts as well as creating behavioral and structural UML Diagrams including Use Case,
Activity, Sequence Diagrams and ERD. Have developed excellent problem solving, analytical
and Conflict resolution skills while working in diverse team environments.
P rofessional S kills :
• Performed planning and management of projects spread across multiple systems from
initiation to finish.
• Involved in the successful planning of the project leading to the goal execution, Life cycle
monitoring, resource management, project control and project closure.
• Excellent Problem solving and multi-tasking skills.
• Excellent verbal and written communication skills required for the project presentation.
• Proven skills as self starter, team building and coordination among different business and
technical teams including on-shore multiple location and offshore.
• Strong skill set to perform Opportunity management within Salesforce.com.
• Strong skill set to manage accounts and contacts within Salesforce.com
• Strong knowledge on compliance standards including SOX, PCI, DCAA and ISO.
• Strong knowledge of ERP evaluation and implementation (SAP, NAV).
• Experience working with different Business users to understand the Business
Requirements and translate them into technical/functional specs.
• Strong 7+ years of experience on software development and implementation.
• Experience performing data Integration and data analysis exercise on various projects.
• Experience working closely with the business users to understand the current and target
business processes.
• Skilled in creating high level business cases, use cases, Business Requirement
Documents and Functional specs.
• Strong understanding of Source to target mapping structure.
• Worked with IT & Business groups to understand the Impacts to the Data Warehouse.
• Experience in creating various process diagrams using UML and requirement gathering.
• Understanding of Star as well as Snowflake Schema/data models.
• Interacted with QA and development managers during the various phases of the entire
project life cycle.
• Experience applications implementation such as IVR, Document management
(SharePoint) etc.
• Strong knowledge and involvement in conducting UAT and QA test cycles.
• Performed manual test by executing the Test Cases and exceptional scenarios.
• Created traceability matrix, and field matrices for various data elements.
• Command on SQL to create and run scripts and procedures.
2
Technical
Project Management tools: MS Project
Skills: MS Word, MS Excel, MS Access, PowerPoint, Visio, Salesforce
SAP, Microsoft Dynamics
ERP:
Programming Languages: C, C++, UML, Visual Basic 6.0, SQL, HTML
Operating Systems: Windows NT/2000/9x, UNIX, Sun Solaris
Scripting Languages: VBScript, JavaScript, Perl, Shell Scripts
Web Technologies: Java Servlets, JSP, ASP
Rational Tools: Rational Test Manager, Rational Robot, Rational Rose,
Rational Administrator, Rational ClearQuest, Rational
ClearQuest Designer, Rational RequisitePro
Defect Tracking Tools: ClearQuest, Test Director
DBMS: Oracle 9i, SQL Server, MS Access, MySQL
Networking: TCP/IP, UDP, SMTP, SNMP, FTP, RPC, RMI, ATM
IIS, Apache Tomcat, BEA WebLogic, IBM WebSphere
Web/Application Servers:
Reporting Services: SQL Server, Business Objects, Cognos 8.3
Data warehousing tool: Informatica
Training: BPM/BPR trained
P rofessional Experience
Emtec I nc. Plainsboro, N J: September 2009 – P resent
Senior Business System Analyst/Salesforce P roject M anager/ERP P roject Manager
Emtec inc. is a large scale Multinational company with its offices all over USA, Canada and
India. They have a strong hold as government contractors for computer hardware with their
current involvement and exceptional growth as service providers. They are also one of the
largest suppliers for some of the big manufacturers such as HP, Cisco and Lenovo.
Salesforce: Emtec has been the Salesforce customer since last one year and have been shifting
their entire Sales and marketing division over to the Salesforce with the current implementation
of PSA, ServiceMax and Surfwriter to upgrade their Resource management, Service
management and pipeline forecasting. Currently working as a Salesforce project manager,
following are my roles:
• Created project plans and budget analysis charts of the web-based projects involving the
inputs of the technical as well as business teams.
• Worked as a lead Business systems analyst in integration of the Salesforce with
company’s existing ERP system.
• Configured Salesforce dashboards and created new reports within Salesforce for the
entire Federal, Commercial and EMT (Emtec Management Team) departments.
• Performed Opportunity and pipeline management for all different Sales teams.
• Managed Accounts, Contacts and opportunities for various Sales teams.
• Configured Opportunity sales stages and probability based on various methodologies
(ICED, FED).
• Configured related lists for Accounts, Contacts, opportunities, PSA and Services.
• Configured the product requirements for each Sales team (Fed, Commercial, Services and
Education).
• Generated revenue forecasting and invoicing reports for various opportunities.
• Designed Salesforce hierarchy, groups and profiles for the entire list of Salesforce users
within Emtec (currently 150 full users and 400 limited users).
• In talks with ServiceMax to integrate their Service Management piece within Salesforce in
order to manage the field services, service dispatch and warranty claims for entire Emtec.
• Successfully implemented PSA module to manage the entire set of Emtec resources within
Salesforce through Salesforce AppExchange.
• Worked on content management workspace to manage the Emtec contents within
Salesforce.
• Successfully implemented Surfwriter to perform forecasting on revenue to get invoiced.
• Performed support as well as QA (test scenarios)on most of the implementations as well as
integrations.
ERP: Emtec currently uses a client-server, flat-file based ERP system which has very
complicated operations, handling and support as well as lesser ROI. In order to overcome this
problem and have better growth companywide Emtec has decided to opt for SAP. Currently
working as an ERP project manager, following are my roles:
• Managing the Business Requirement Document for the entire ERP solution.
• Reviewed an ERP evaluation documents to cover the solutions provided by different
vendors (SAP, NAV, Oracle).
• Organized and managed Research on Earned Value management chart for various Emtec
projects.
• Created a cost structure sheet to cover the current ERP cost within the entire organization.
• Created CBA chart with the Impact from existing ERP (FACTS) and comparison with the
future option (SAP).
• Created the workflow for the entire HR, Payroll and Service management process within
Emtec.
• Created an ERP requirement document on DCAA.
• Actively participated in the blueprinting exercise from SAP on Project Management, VAR,
Proserv 360 and DCAA.
More information and skill-set on Salesforce and ERP analysis can be produced on request.
Environment: Salesforce, SDLC, MS Project, Agile, SQL Server, MS Office suite, Java, HTML,
Infor, SAP, Test Director, XML, Web Services.
Ho rizon Blue Cross Blue Shield of New Jersey, Newar k, N J: Jan 2009 – July 2009
Senior Business Systems Analyst/D I P roject Manager
HDI (Horizon Data Integrity) project mainly constituted performing data analysis and cleansing
for the recurring incoming bad data on the patient intake and registration level of the revenue
cycle. It involved Ad-hoc report building for senior management portraying the billing charges
and payment posting done by the billing back-office as well as regular communication with the
stakeholders and steering committee through BPI/BPR documents and BRD to make them
understand the level of existing bad data. It also inhibited testing the data quality, analyzing the
4
volume of bad data and restructuring the existing data model. Methodology used was SDLC
and Agile over .NET platform.
• Worked on the Business Process Improvement plan with the Stakeholders and Steering
committee and documented the entire plan.
• Led team of 6 from design to development.
• Directly responsible for the management of the Project and Program financials for all the 3
projects within the DI Program.
• Managed data analysis on the existing Provider data in Provider Networking Organization.
• Managed data analysis and integrity procedure on incoming and outgoing Provider data.
• Reviewed Business Requirement document and functional specifications for web-based
Online Provider Directory.
• Performed Operational risk assessment exercise on the provider data leaks within the
system.
• Interacted with the Business users to understand the business issues and concepts and
explain them to the technical teams.
• Attended interviews with Subject Matter experts, recorded Requirements for review
purposes.
• Created the business flow diagrams to finalize business solutions.
• Created high-level Use Case diagrams and also low-level Class and Sequence diagrams.
• Involved in decision making steps to assess the volume of mismatching data for Provider
Address Validation.
• Experience managing out-sourced and vendor based data loading process.
• Used SQL server and Oracle SQL developer to write procedures and generate reports to
manipulate the provider data.
• Providing directions to the Informatica team on data comparison procedures.
• Reviewed test cases to test the new data model for the provider and the practitioners.
• Reviewed test cases and test scripts to match the desired results on Provider website.
Environment: Oracle 11g, SDLC, Agile, SQL Server, MS Office suite, Java, HTML, Informatica,
Requisite Pro, Salesforce, Test Director, PLSQL, Healthcare Revenue Cycle, Portico, XML, Web
Service
PCS, Santa Monica, CA: October 2007 – December 2008
Sr. Business Analyst/Project manager for eCommerce and Cognos 8.3
PCS is a telecom company that provides prepaid, debit and collect calling facilities to the
inmates at various locations. The project mainly constituted managing the development of new
payment and billing module for the company as well as handling the Cognos 8
implementation on reporting side. Methodology used was SDLC and Agile over .NET
platform.
• Created project plans and budget analysis charts of the web-based projects involving the
inputs of the technical as well as business teams.
• Successfully managed the team of 1 analyst, 2 developers and 1 admin.
• Worked with the business teams to finalize and implement the guidelines of the PCI
Compliance and ensured compliance with required controls.
• Managed Opportunity and service management within Salesforce.
• Provided input for high level business process model and Logical Data Model for the
eCommerce web project.
• Created Implementation plan for the new and updated IVR.
• Served as a technical and project expert combining programming knowledge, market
analysis, and end-user feedback to develop technical project plans and managed through
the development process.
• Performed Source to target mapping on various transactional data.
• Reviewed and implemented high level business process model for the web oriented
project.
• Analyzed the business flow diagrams and explained it to technical team.
• Created Use case, activity, sequence and class diagrams as per UML 2.0
• Perform knowledgeable role in implementation of Informatica as an ETL and data
warehousing tool.
• Performed project sign-off formalities and organized the systematic release.
• Organized meetings with the stakeholders and the business users on regular basis.
• Created Implementation plan for the new and updated IVR.
• Gathered requirements for sales, Marketing and Finance reports on Cognos 8.3
• Perform UAT on the new Cognos reports and company’s Ecommerce portal.
• Interact with the developers, QA, DBAs, and system administrators on the regular basis
to get the status updates on various projects.
• Wrote the Test Plan, organized the Test cases, Test Procedure, Expected results
according to the feature categories specified in the requirements document. Wrote the
positive and negative Test Cases for each feature.
Environment: Oracle 11g, SDLC, Agile, SQL Server, MS Office suite, Java, HTML, Cognos,
Salesforce, Informatica, Requisite Pro. Test Director, PLSQL, PCI compliance
Count rywide, Agoura H ills, CA: May 2006 – October 2007
Sr. Business Systems Analyst
CHL (Countrywide Home Loans) used to be the nation’s largest independent mortgage lender
offering home equity, HELOC, refinance, mortgages, debt consolidation and other various
loan products. Project constituted the development of Pricing, Proposal and underwriting modules
of the Next Origination System (NexOS) being developed as a replacement to the existing
POS system ‘AdvantEDGE’ and LOS ‘Edge”.
• Acted as a Project Manager in Create Documents Module Project and various smaller
projects in NexOS (Proposal Comparisons and Sales Module).
• Performed what-if analysis based on given scenarios using the skills of Portfolio
Management.
• Involved in developing, executing, and monitoring project budgets and schedules using
MS Project.
• Functioned as a primary liaison between the stakeholders, operations, and the technical
team throughout the project life cycle.
• Performed Source to target mapping on various loan data.
• Worked closely with the PM on the in-house tool (VIPER, SharePoint based) and
methodology being used for the project development and the best approach for Requirement
gathering.
• Developed, maintained, and managed system documentation, including Business
Requirements and Business Process Analytics, Test Cases, QA Test Plans, and UAT
plans.
• Performed data mapping techniques using XML services.
• Created the Control Matrices for the various functional and Technical Specs.
• Created the high level and low-level UI documents using Microsoft InfoPath.
6
• Worked on PVCS version control tool for Document Management and Change Request
Management.
• Interacted actively with Mortgage Business Units in gathering Requirements and making
Use Cases design sessions for the addition of all the new features.
• Monitored all phases of project implementations working closely with all levels of
management, end-users, IT personnel, and development teams.
• Interacted with the developers and QA teams on resolving Defect Reports (DR's) and
various technical issues.
Environment: SQL Server, SDLC, Agile, MS Office suite, .NET, HTML, Crystal Reports,
Sharepoint, Informatica, Requisite Pro., Test Director, Viper, StatusMart, InfoPath, Visio
G MAC I nsurance, Fleetwood, PA: May 2005 – Ma rch 2006
Business Analyst
Project constituted the development of Loan processing, application and underwriting module
for the Loan Origination System (LOS) at GMAC’s sister concern CalDirect, as well as
integrating the POS to the Call Centers using Sforce. The project also involved statistical
analysis and forecasting on market growth for California homeowners. Methodology used was
RUP over J2EE platform.
• Designed high level process models in Visio.
• Regularly interacted with stakeholders to come up with business solutions.
• Actively participated in the Inception, Elaboration, Construction and Transition phases of
the lifecycle.
• Performed a role of Business Modeler to form a liaison between the Business Users and
the Software Engineers.
• Created and maintained Traceability Matrix for the high level requirements and detailed
requirements related to the software development.
• Analyzed the Credit card authorization and credit verification requirements; PCI
compliance.
• Created and documented BRD and functional specs using MS Office Suite.
• Used UX Storyboarding to explain the User Experience elements, screens and Screen
contents in an abstract representation.
• Used Rational ClearQuest for defect tracking and prioritizing defects and for enhancements
after base lining the Requirements.
• Use of statistical tools/analysis to predict loan volume trends.
• Involved in creating complex spreadsheet analyzing the loss loops and prepayment
curves.
• Did mathematical calculations as a part of quantitative analysis.
• Managed the Requirements using Rational RequisitePro.
• Reviewed QA Test Plans and facilitated UAT.
Environment: SQL Server, RUP, MS Office suite, .NET, HTML, Business Objects Enterprise
Reporting, Sharepoint, Informatica, Requisite Pro, Test Director, LOS
Northwest Mo rtgage, M inneapolis, M N: December 2003 – April 2005
Business Analyst
Northwest Mortgage is one of Minnesota's leading Mortgage lenders. Project involved
enhancement of the loan origination system to take care of the large-scale mortgage needs in
mid-west. The system included point-of-sale, processing, underwriting closing and funding .
Methodology used was RUP and UML over J2EE platform.
• Played important role in creating the Business Vision document for business users.
• Created user requirement doc and system requirement specs.
• Performed various roles during inception, elaboration and transition phases.
• Analyzed the risk identification and assessment for the new module.
• Created and delivered PowerPoint presentations; led and facilitated planning meetings;
created and conducted training sessions.
• Designed and developed project document templates based on RUP methodology.
• Designed business process models using Rational Rose.
• Carried out the GAP analysis for the enhancements.
Environment: MySQL, SDLC, Agile, MS Office suite, Java, JBox, HTML, Crystal Reports,
Sharepoint, StatusMart, Test Director, WinRunner, Rational Suite
Bank One, Chicago, I L: Janua ry 2003 – December 2003
F inancial Analyst
I worked as financial analyst on the Financial Wisdom Online, which is a financial planning
tool that provides worksheets, forms, calculators and a reference library that helps customers in
gaining a better understanding of their finances and investments. Methodology used was SDLC
over .NET platform.
• Communicated with the end users to understand the scope of the project and gathered
and documented the Requirements. Also worked on the Feasibility analysis.
• Performed portfolio management to create the best possible collection of investment for
each customer’s requirement and managed various risk.
• Interviewed the stakeholders to carefully record the Requirements.
• Managed and documented the gathered Requirements in the Rational RequisitePro.
• Reviewed QA Test Plans and facilitated UAT.
• Organized meetings with the stakeholders and the business users on regular basis.
• Made the traceability matrix so that the changes made to the system can be easily
displayed.
Environment: MySQL, SDLC, MS Office suite, Rational suite, .NET, HTML, Crystal Reports,
Sharepoint, Test Director, WinRunner, LoadRunner
Affinity Plus Federal Credit Union, M inneapolis, M N: November 2001 – Janua ry 2003
Business Analyst
Project involved development of a web based front-end system for remote access to research,
editorial and compliance teams. Methodology RUP, UML over J2EE platform
• Gathered and documented the critical business process requirement.
• Attended interviews with Subject Matter experts, recorded Requirements for review
purposes.
• Created the Business Flow diagrams using RUP methodology.
• Created high-level Use Case diagrams and also low-level Class and Sequence diagrams.
Environment: MySQL, SDLC, Agile, MS Office suite, Java, JBox, HTML, Informatica, Requisite
Pro., Test Director, QTP, PVCS
8