Piyush Goradia

Cell # 412-***-****/ acagy0@r.postjobfree.com

PROFESSIONAL SUMMARY:

Twelve Years of professional IT experience in Business Systems Analysis/Project Management. Proficient in

requirement analysis and Use Case development. Expertise in various activities such as conducting interviews and

surveys, obtaining sign-offs, defining and reviewing requirements, and creating appropriate data models. Good

understanding of business process and requirements management and excellent Analytical skills. Excellent

communicator, capable of interfacing with both internal and external stakeholders. Prepared flowcharts, project

plans, and systems requirements specifications. Excellent analytical and communication skills.

SPECIFIC EXPERTISE:

• Excellent analytical skills for understanding the Business requirements, Business

rules/processes and detailed design of the application.

• Participated in systems implementations and process improvement projects. Identified internal or external

risks that may adversely affect business operations.

• Good understanding of Scheduling & Planning the Projects in different environment.

• Knowledge of RUP’s Iterative Software Development Life Cycle process. Implementing the Rational Unified

Process (RUP) in all four phases of a project: Inception, Elaboration, Construction and Transition.

• Demonstrated effective project management skills in meeting deadlines, prioritizing multiple tasks, managing

conflicting priorities, preparing timely updates of project status and in extensively interacting with peers in

Internal Audit, Information Systems personnel, Senior Management, external auditors and contractors. Maintained

confidentiality of information obtained during audits.

• Actively involved in User Acceptance Testing and Training of the end users.

TECHNICAL SKILLS:

Hardware: IBM PC Compatibles, Sun SPARCstations, DEC stations

Operating Systems: Windows 3.x/9x/NT, UNIX (Solaris, SCO), MS-DOS

Packages: MS Office, Corel WordPerfect Suite

GUI Tools: Visual Basic 6.0

Languages: C, C++, Java, Fortran, SQL, 4Test, PL/SQL, Java Servlets, Visual Basics/ .Net, MS project.

Databases: Oracle 7.x/8.0/9.0, MS Access, SQL – Server.

Other Tools: Brio / Hyperion, Actuate Reporting, XML Spy, Contivo, Erwin7.0, RDA,

IBM – WBM, Cognos, Business Object, Informatica, MS Dynamics CRM, Salesforce

Internet: JavaScript, HTML, XML, Internet Explorer 4.0/5.0, Netscape Navigator 4.x.

Mainframe CICS, TSO, ISPF, DB2.

Testing Tools: Rational Rose, Rational ClearQuest, ClearCase, Visio, PVCS, RequisitePro

Process Modeling WBM – Websphere Business Process Modeling (IBM)

PROFESSIONAL EXPERIENCE:

Wells Fargo Financials, charlotte, NC Jan 2013 – Present

Business Systems Consultant

Involved in implementation of customer relationship management tool (MS Dynamics – CRM tool) with the necessary

functionality to support wholesale banking Relationship Managers as they manage client relationships, interactions and

sale opportunities

Tiaa-Cref, Charlotte, NC July 2012 – December 2012

Business Systems Consultant

Building Intranet platform with TIAA-CREF supported by SalesForce CRM and Oracle Fatwire as content management

tool.

• Involved in drafting enterprise wide Content Management / Salesforce CRM (Chatter) collaboration platform

requirements, change initiatives & vendors interaction.

• Management of relationship with the front-office internal client users.

• Created Business Requirements for Knowledge Management using Knowledge Centered Support (KCS).

• Involved in writing Enterprise wide federated search requirement.

• Involved in creating Business Case for target state system under Agile Methodology.

• Track and communicate project status to project team, sponsors, and program managers.

• Worked within project management methodology to create and manage project plans and schedules.

• Contributed to initial architectural decisions on CRM, Content Management platform as well as test

optimization effort.

S/W Platform: XML, Toad, Power Point, Excel, Visio, Salesforce CRM & Oracle Web Service Center (Fatwire),

Collage.

Wells Fargo Financials, charlotte, NC Feb 2011 – June 2012

Business Systems Consultant

Building customer relationship management tool (MS Dynamics – CRM tool) with the necessary functionality to support

wholesale banking Relationship Managers as they manage client relationships, interactions and sale opportunities.

Responsibilities:

• Involved in Sprint planning discussion as well as daily scrum meeting to keep the track of Release status under agile

methodology.

• Involved in creating burn down chart using agile tool called as Version One.

• Assisted with CRM call report/contact/activity analysis & design & testing through the entire release cycle.

• Involved in creating various use cases for Referral Tracking System (PWO application).

• Involved in writing integration process flows for Client On Board and establishing workflow around Digital

Signature / Electronic Signature for potential leads.

• Involved in creating as-is / to-be process flows for RTS application

• Involved in requirements gathering for CRM modules like Contacts, Relationship, and Activities.

• Consulted directly with vendors and business users, and provided solutions to the SSRS reporting needs to end

users.

• Finalize list views for Contacts, Call Reports & Opportunity entities.

• Interacted regularly with business partners to define parameters for data presentation. Create / finalize dashboards &

other User Interface specific requirements.

• Involved in architectural improvements feedback from Data point of view.

• Created and defined process model, mapping documents between legacy systems and new system under Agile

Methodology.

• Facilitated requirements gathering sessions in order to identify business requirements and then documented

them in a format that can be reviewed and understood by both business people and technical people & tracked

changes under Agile tool called Version One.

• Analyzed existing system Integration, design and developed Function Specification Documents for upstream and

downstream systems.

S/W Platform: .Net, XML, SQL, Toad, Microsoft Project, Power Point, Excel, MS Dynamics CRM 2011, SSRS,

SSIS, Visio, SalesForce – (WFIS LOB)

Bank Of America, NC Dec 2009 – Feb 2011

Sr. Business Analyst / Lead BA

The purpose of the GCB Enterprise Wide Deepening Referral Project is to use Enterprise Client Referral Standards to

support creation, delivery and tracking of referrals. The new environment provides quality referrals potentially increasing

the number of referrals sent to GCB.

GCB has partnered with the GCC/GRE Team and GWIM Technology to implement tools and processes within GCB

CRM tools that adheres to the Enterprise Client Referral Standards. In addition it involves Automation of Data

Extracts(ETL) to help streamline GCB reporting. This project is in its third phase currently.

Responsibilities:

• Involved in design and implementation consultation on multiple projects.

• Acted as liaison across business units primarily between the Project Manager, developers, Administrators and testers

and the stakeholders.

• Involved in detailed requirements gathering for Cognos Reports, dashboards, periodic and ad hoc reports,

detailed month end reporting for billing, financial (Dynamics), performance, sales, marketing and website

activities.

• Responsible for planning and coordinating the processes required for the provision of user applications and IT

systems.

• Executed strategies that optimized levels of productivity, enhanced business operations and positioned

systems for future growth and scalability.

• Performed click stream analysis.

• Developed requirements, conducted interviews, provided process & workflow analysis, scenarios, use cases for

linking opportunities with referrals throughout the life of referral.

• Managed integrated functionality & technology dependencies, usability, reliability, performance and support

requirements of legacy CRM and web applications.

• Verified the functionality as per the Business Process and validated the interfaces with the other systems.

• Managed mock-up User Interfaces to communicate visual data flow to the end users.

• Interacted and effectively communicated with project managers, customers and management team.

• Managed Support Process Documentation, SLA Process Documentation.

• Maximized & evaluated new/existing Vendor partnership opportunities, created detailed ROI justification.

• Facilitated (JAD) Joint Application Development sessions in order to identify business rules and requirements and

then documented them in a format that can be reviewed and understood by both business people and technical

people.

• Involved in writing business requirements for internal CRM system which involves Client

(New as well as old), Contacts & Associate modules.

• Drafted business requirements for Client On Boarding process.

• Involved in creating high level i/p data requirement for reporting purpose & facilitated requirements gathering for

Canned Reports & Ad-hoc requests for GCB.

• Involved in building Data Mart which can be used for various levels of reporting enterprise wide (GWIM &

GCB).

S/W Platform: Java, XML, SQL, Toad, Microsoft Project, Power Point, Oracle, Excel, Cognos, Rational Data

Architect, Sales Force / In house CRM for whole sale banking.

ServiceLink Mortgage, PA May 2009 – Dec 2009

Change Manager

ServiceLink was purchased by Fidelity National Financial (FNF) in August 2005. FNF provides strong financial backing

and access to an array of products and services that has helped ServiceLink exhibit steady business growth while

maintaining its focus on Client service. In addition, ServiceLink became an operating division for five Fidelity National

Title Group (FNTG) underwriters that include: Chicago Title, Fidelity National Title, Ticor Title, Alamo Title and

Security Union. In 2007 ServiceLink acquired ATM Corporation of America (ATM).

Responsibilities:

• Maintaining Requirement Traceability Matrix using Test Management tool – QualityCenter.

• Creating weekly updates of project status and in extensively interacting with peers in Internal Audit,

Information Systems personnel, Senior Management.

• Directly oversaw a team of 12 on-site functional analysts.

• Ensured prompt delivery of all project initiatives.

• Involved in conducting weekly status meeting within QA team for issues found during

UAT.

• Managed to differentiate between the “as is” and “to be” systems.

• Interviewed the Subject Matter Experts (SME) and carefully recorded the requirements by asking questions

and documented all the requirements so that they could be understood by both business people and technical

teams.

• Used MS Visio to depict whole business workflows in these diagrams.

• Designing the Business Objects reports Layouts.

• Data modeling with respect to claims process Implementation using WBM & Business Objects.

• Created & Implemented Application Certification process enabling Go-live decisions.

• Skilled in conflict resolution, performance evaluation, facilitating diverse learning, and building productive

relationships with Steering committee and senior management.

• Created a new reporting template with Metrics which manipulates the Effort variation and Schedule variation.

• Presented periodic Metrics to the senior management to show the progress, constraints and dependencies in the

project.

S/W Platform: .Net, BizTalk, HTML, XML, SQL, XML spy2007, IBM - WBM, Rational Data Architect (RDA),

Power Point, Quality Center

Highmark, PA May 2008 – April 2009

Change Manager

Highmark was created in 1996 by the consolidation of two Pennsylvania licensees of the Blue

Cross and Blue Shield Association Pennsylvania Blue Shield (now Highmark Blue Shield) and

the Blue Cross plan in western Pennsylvania.

Responsibilities:

• Involved in conducting weekly status meeting within QA team.

• Communicating issues found during testing with higher level management and

System Architects.

• Involved in writing and developing Cost/benefit Justification, Risk Analysis/Management and Mitigation

techniques to resolve severity – one defects.

• Met with Senior Management team to ensure that business / project goals were being met according

to plan

• Established timelines and budgets and consistently met all deadlines

• Facilitate brainstorming sessions by acting as a liaison between QA, Project management and development

teams.

• Identify key risks in development cycles, document BRD (Business requirement Document), FRD (Functional

Requirement Document), TDD (Technical Design Document) and in resource allocation. Implement and

maintain a project management solution.

• Maintain a working environment that promotes productivity, responsiveness, high staff morale, motivation and

excellence.

• Managed Internal and external service partners. Ensure and enforce timely delivery of products and services

including Service Level Agreements (SLA).

• Involved in impact analysis & POC for various tools evaluation exercise

enterprise wide.

• Facilitated collection of functional requirements from system users and preparation of business

requirement documents using Rational Requisite Pro that provided appropriate scope of work for technical team

to work upon.

• Involved in building Architectural diagram / process flow diagram using WBM.

• Involved in Architectural improvement with SOA team.

• Involved in Business Process Flow diagrams/ XML Schemas for various customers and assigning

resource to specific task/process.

• Implemented business process modeling, data modeling using Rational Rose and MS Visio to

develop the business architecture for the application and created use cases, use case diagrams, activity diagrams

and state transition diagrams, using MS Visio in order to understand system flow and data flow, perform data

mapping, analyzed ER diagrams and performed critical path analysis.

• Identified opportunities to improve the business process in terms of XML data feeds from different

sources.

S/W Platform: Java, HTML, XML, SQL, Erwin7.0, XML spy2007, IBM - WBM, Rational Data Architect (RDA), IBM

ESB, Power Point, Home CRM

Sprint Nextel, KS Sep 2007 – Apr 2008

Technical Project Manager/ Consultant

Sprint Nextel offers a comprehensive range of wireless and wire line communications services bringing the freedom of

mobility to consumers, businesses and government users. Sprint Nextel is widely recognized for developing, engineering

and deploying innovative technologies, including two robust wireless networks serving approximately 54 million

customers at the end of 2007; industry-leading mobile data services; instant national and international push-to-talk

capabilities; and a global Tier 1 Internet backbone.

Responsibilities:

• Estimating Effort based on the Projects Conceptualization Documents to Plan for the Offshore and the Onsite

team of the Man Hours required for the Project and thus the cost involved.

• Involved in developing Canonical Data Model which can be used enterprise wide.

• Raised a Work Request based on the Effort Estimation for the offshore team.

Raise Change Request, In case of changes in the Testing Requirements.

• Coordinated with the offshore testing team in the Testing Deliverables and Getting Testing Deliverable

Reviewed from the Client.

• Created mapping document with the help of Contivo.

• Coordinated with the Offshore testing team in the Testing Deliverables and Getting Testing Deliverable

Reviewed from the Client.

• Planned QA resources to manage testing efforts to ensure that it is meeting the deadlines by monitoring and

tracking testing progress.

• oversaw a team of 9 on-site Business Systems analysts & 4 offshore QA testing resources.

• Involved in Data GAP Analysis and Issue Resolutions.

• Coordinated with the Developers/Business analyst regarding new releases/builds.

Scheduling & planning the testing effort based on the testing priority

• Analyzed and performed gap-analysis on the existing Sprint system and processes with the help of Visio &

IBM – WBM (BPM tool)

• Worked closely with the marketing team to drive flow to the site and the IT team to ensure the site is performing

to its maximum potential for Order Management.

• Constantly review web functionality with a view to improve user experience for Product Catalog & managed

requirement for entire Wholesale Order Process & Customer Support Applications. (ACIS, OMS)

• Monitor on-site traffic, conversions, cart abandonment, navigation and other key trends and find ways to

improve performance.

• Managed the complete test cycle for both the ecommerce sites.

S/W Platform: Java, HTML, XML, Data Power, XML spy2007, Contivo Analyst, IBM ESB, ATG Business & Customer

Analytics, SAP – WM, Visio, WBM(BPM), Power Point, Retek – CRM (Oracle)

Wells Fargo Home Mortgage & Financials, IA Mar 2006 – Aug 2007

Business Data Analyst

The Wells Fargo Home Mortgage (WFHM) & Wells Fargo Financials (WFF) project dubbed “CORE” is an integrated

approach for developing and delivering automated decision capabilities to the enterprise, for the purpose of increasing

decision consistency, flexibility, support for salability, and increased speed to change, while effectively managing risks.

Responsibilities:

• Gathered business requirements through interviews, surveys, prototyping and observations

• Create Interface Specifications, mapping documents and data model XML schemas to be used by

various Functional Streams

• Created Use Case Diagrams with Visio, Business Flow diagrams, Activity Diagrams, Sequence

Diagrams in Rational Rose.

• Prepared High Level Logical Data Models and BRD’s (Business Requirement Documents)

supporting documents containing the essential business elements, detailed definitions, and descriptions of the

relationships between the actors to analyze and document business data requirements.

• Created wireframes and mock-up screens with the User interface for developing Services in SOA Data

Architecture.

• Works with business team, developer and major developer to resolve mapping and other data mapping

issues

• Create XML-Spy generated sample XML for test cases used in System Integration Testing and UAT

• Worked with the developers in carrying out System and Integration testing (SIT).

• Wrote full functional and technical specifications and communicated requirements to development

teams

• Created and maintained complete development plans that included functional specifications,

requirements engineering, Use Case modeling, risk assessment and mitigation, internal and external workflow

• Prepared the documentation of Data Acquisition and Interface System Design.

• Conducted presentations and walkthroughs with end users and stakeholders prior to formal training

sessions

S/W Platform: Java, HTML, XML, SQL, Rational Suite, XML spy2007, Contivo, Visio, Power Point

Hartford Insurance, Hartford, CT May 2005 – Dec 2005

Business Systems Analyst

The Hartford is a leading provider of investment products, Life Insurance and group and

employee benefits; automobile and homeowners (P & C Insurance) products; and business

insurance. Worked on the Generic Mass Retailers (GMR) project. The project has been divided

into two phases. The first phase included making of connection to the GMR using XML and the

quote/issue information communicated using ACORD XML for auto only transactions.

Responsibilities

• Worked extensively on writing the Business requirements and making the user requirement

documentation.

• Acted as a liaison between stakeholders: system users, clients and managers, who have a

business problem to gather requirements.

• Followed RUP process to gather requirement in each phase of SDLC.

• Conducting meetings/interviews and JAD sessions with stakeholders to collect business

requirements.

• Managing, linking, tracing and analyzing requirements

• Used MS Visio to make use case models, activity diagrams, class diagrams, depicting

whole business workflows in these diagrams.

• Involved in the Gap Analysis to perform the feasibility of integration between Web Portals

and

• Data Warehouse. Initiated a project to do a prototype between ATG eCommerce and

Product Catalog hosted on ATG Web Application server platform to DataMart.

• Creating and managing project templates, use case project templates, requirement types and

traceability relationships.

• Using MS Visio to construct Business Use Case Model and Business Object Model.

• Implemented a test harness for Integration Testing of the application.

• Wrote the Business Requirement documents for the various initiatives for phase 1 for ATG

Business Customer Analytics.

• Created use case diagrams which will be used by the IT department to estimate the cost for

the implementation.

• Participated walkthroughs of the Business Requirement Document with the business users

and the IT project managers for building Data warehouse/Data Dictionary.

• Involved in creating data mapping specification for Claims Data warehouse.

• Facilitated various brainstorming sessions, requirement gathering session, and

walkthroughs.

S/W Platform: Java, HTML,PVCS tracker, PVCS Suite, XML, SQL, Contivo, Erwin, ATG Business Customer

Analytics (CI), Visio, BPM, WinRunner, MS Dynamics CRM.

High Point Insurance (Palisades Insurance), Red Bank, NJ Dec 2003 – Apr2005

Business Systems Analyst / Process Analyst

High Point and its affiliates provide personal lines insurance protection to over 455,000 New Jersey customers. High

Point was formed when Palisades Safety and Insurance Association purchased the former The Prudential Property and

Casualty of New Jersey and its New Jersey subsidiaries from Prudential Financial, Inc. on November 1, 2003.

Responsibilities:

• Involved in Gathering i/p data requirements from the Reporting users.

• Involved in i/p data analysis (High Level/Low Level) for Underwriting Reports, Cat Reporting, Pcat

Reports.

• Involved in designing Views specifications documents/Template, which can be used in Brio/Hyperion

environment.

• Conducting interviews with the Business Users to find out the actual requirement.

• Responsible for analysis and translation of user requirements into functional and technical

specifications, give design recommendations and work with Developers to ensure successful application

delivery throughout the SDLC for a major Data Warehouse under BI environment.

• Ad-hoc query reporting analysis for Data Warehouse / DataMart.

• Responsible for building up the Data Dictionary which can be used enterprise wide to find out the

business definitions & related meanings & calculations involved with it.

• Facilitated collection of functional requirements from system users and preparation of business

requirement documents using existing templates that provided appropriate scope of work for technical team to

work upon.

• Involved in writing Interface data mapping specifications for ODS (data warehouse) – SpeedPay (third

party interface). This third party application is used to process CreditCard Payment made to the company.

S/W Platform: Brio, Hyperion, Java, DB2, XML, SQL, CICS, COBOL, Erwin, Visio, BPM

Archer Daniels Midland (ADM), IL Oct 2002 – Nov 2003

Business Systems Analyst / Data Analyst

Archer Daniels Midland Company is one of the largest agricultural processors in the world. Serving as a vital link

between farmers and consumers, take crops and process them to make food ingredients, animal feed ingredients,

renewable fuels and naturally derived alternatives to industrial chemicals. Founded in 1902 and incorporated in 1923,

ADM is headquartered in Decatur, Illinois, and operates processing and manufacturing facilities across the United States

and worldwide.

Responsibilities:

• Responsible for reviewing the business process and possible improvements based on user requirement to

implement system testing for Order Management.

• Wrote UAT test cases and test scripts that verified the functional scenarios with in the scope of the work.

• Identified and defined actors, developed various use cases such as Application Use Case, Business Use Case

and Supplemental Use cases.

• Prepared Use case diagrams, activity diagrams, sequence diagrams, state transition diagrams in Rational Rose

and MS Visio.

• Held walkthroughs with the developers and QA teams and communicated interface requirements.

• Used Rational ClearQuest to manage and track defects, prioritized defects with each build and made sure that

they were communicated to the affected teams and also make enhancement requests.

• Assisted in managing various versions in Clear Case.

• Followed RUP process to gather requirement in each phase of SDLC.

• Created the user requirement specifications and helped convert them to system functionality documents

• Building AUC definition dictionary, development and elaboration.

• Arranged formal/informal meeting with the user community/developers.

• Mentoring project team to understand Rational Unified Process and use different Rational tools.

• Worked closely with the QA team during the functionality testing and helped in the user acceptance testing.

S/W Platform: Java, Maximo- SAP MM/WM, Actuate Reporting Websphere, XML, SQL, Maximo 4.11 / Actuate

Reporting 5.0

Hanover Insurance /Allmerica Finance, Worcester, Ma Apr 2001 - Sep 2002

Business Analyst / Process Analyst

Responsibilities:

• Facilitated collection of functional requirements from system users and preparation of business

requirement documents using Rational Requisite Pro that provided appropriate scope of work for technical team

to work upon.

• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the

Implementation of Rational Unified Process effort in different iterations and phases of the Software

Development Life Cycle.

• Worked as an Interface between the users and the different teams involved in the application for the

better understanding of the business and IT processes.

• Followed a structured approach to organize requirements into logical groupings of essential business

processes, business rules, and information needs, and ensures that critical requirements are not missed

• Collected user requirements and converted them into business requirements and finally into functional

requirements.

• Prepared Logical Data Models that contains set of diagrams and supporting documents containing the

essential business elements, detailed definitions, and descriptions of the relationships between the data elements

to analyze and document business data requirements.

• Prepared Business Process Models that includes modeling of all the activities of the business from the

conceptual to procedural level.

• Aided management in standardizing web applications by preparing GUI standards and recommending

alternatives for incorporation in a phased, iterative manner.

• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance

testing and writing test scripts for Life Insurance Products.

S/W Platform: ASP, VBScript, Window XP, Visual Basic, DB2, XML, SQL, CICS, Cobol, BPM

Jun 1999 - Nov 2000

InfoSoft Enterprise

BA/QA Tester

Responsibilities:

• Facilitated collection of functional requirements from system users and preparation of business

requirement documents using Rational Requisite Pro that provided appropriate scope of work for technical team

to develop prototype and overall system.

• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the

Implementation of Rational Unified Process effort in different iterations and phases of the Software

Development Life Cycle.

• Worked as an Interface between the users and the different teams involved in the application

development for the better understanding of the business and IT processes.

• Prepared Logical Data Models that contains set of diagrams and supporting documents containing the

essential business elements, detailed definitions, and descriptions of the relationships between the data elements

to analyze and document business data requirements.

• Prepared Logical process Models covers "What" business processes are required by the business to accomplish

their goals.

• Prepared Business Process Models that includes modeling of all the activities of the business from the

conceptual to procedural level.

S/W Platform: Java,J2EE, Window XP, Sun Solaris, Websphere, DB2, XML, SQL, CICS, Cobol

EDUCATION: Bachelor of Electronics Engineering – Mumbai University ( June/1998)

Contact this candidate