Project Data

Paresh Gandhi

*** ******** *****, ********, *** *W8, ON, Canada

Home: 905-***-****: Cell 416-***-****

********@*****.*** http://ca.linkedin.com/pub/paresh-gandhi/13/743/698

Enhance Reliability Security Clearance# 95760088-0001285633 Expiration Date: 2022-02-07

Highlights of Qualification

• 20+ years of total IT experience with focus on 10+ years Business/Systems Analyst in Software

Implementation and Project Delivery within SDLC, ITIL, Infrastructure,

• Work with PM closely to Develop and execute activities related to end-to-end project management,

including project plans, scoping and requirements through implementation and deployment.

Proactively monitor, manage and report on execution of deliverables.

• Proven experience with planning, gathering, analyzing, and documenting requirements within

complex business environments, also an effective enterprise level communicator with ability to

build strong relationships with all types of stakeholders including project sponsors, clients, team

members, users and vendors.

• Able to ensure that IT is effectively utilized through Business Process Engineering to create

profitable and efficient solutions for the business and its users. Work well in a team or

independently and small or large enterprise. Process Mapping for Process Improving, Root Cause,

Problem solving, Validate and verify the process,

• Excellent combination of business, technical and management Process knowledge with more than

12+ years, in financial, banking, retailer, supply chain, and insurance applications. More than 10

years’ experience in using System Development Life Cycle (SDLC) in IT/IS projects. 8 + years’

experience in collecting business requirement analysis through workshop, brain storming session &

JAD. 15 + years’ experience in using SQL and relational databases including Access, DB2 & Excel

in performing Quantitative Data analysis for end to end projects. From High level requirement to

Detail Requirement to Test Strategy, UAT, Test Planning, Functional Testing, black box testing, and

Implementation with full SDLC.

• As a Sr. BSA, liaison/advised VP, Senior Managers, finance about business process improvement

and did presentation of documents for available solutions. Excellent analytical abilities, problem

solving abilities, negotiating skills and strong capability in planning. Extensive experience in using

MS Office, Visio, MS Project, Word & Excel in all the projects. Have experience in both Iterative

& Waterfall methodologies, and agile. Worked closely with developers, DBA, Architect & Business

users in the entire end to end project. Worked on Data Warehouse project in the bank for Data

Extract & Data Load in the Data Warehouse. Work on different kind of third party CRM software,

I.e. SAP, Oracle, etc.,

Key Skills

• Broad technical knowledge of enterprise application platforms, tools and associated technologies,

networks, protocols, ports, firewalls and programming languages

• Process reengineering, project leadership/project analytics, solution delivery,Process Mapping,

• Problem-solving, negotiation, team-building, Solution Driven

• Using software for BI and give the corporate level data for decision making,

• Data modeling, Data Mapping, System Development Life Cycle (SDLC)

Tools

• Methodologies – SDLC, COBIT AD, TI, Zachman Framework SharePoint’s, BI, ITIL

• Hardware – Large IBM mainframes, Windows PC (and compatible), client/server

• Operating Systems – ZS/OS, MVS/ESA, IBM C/390, Windows 95 through Windows 7.

• Languages – COBOL, PL/SQL, Java,

• Software: – Mercury Quality Centre, QTP, QCC, IBM Rational, Visio,

Page 1 of 6

Paresh Gandhi Sr. BSA- 905-***-****

• Applications Support: JDA Transportation, WMS, PCI DSS, FORD Incentive, GOLF, SRF,

CREDIT CARD, AML, AUTO-PARTS, VEHICLE, SALES, ETL, DEBT COLLECTION, Retail,

UTILITY, INSURANCE, RMS, TSYS, 5Q, FINANCIAL, Payments, Credit Bureau, TS2, FDR,

Draft 5,

• Documentation: SRS, SDS, TDS, IDD, Data Mapping, Data modeling, Process flow

diagram/Mapping,

• RDBMS: ORACLE, SQL Server, Data migration, Data Modeling, Data Mapping, DB2

• Report: Crystal, Cognos, SSRS, SSAS

• Third Party CRM Application: Oracle, SAP, Benefits application, JDA Transportation, TSYS

Employment History:

Loblaw Mississauga (Retailer-supply Chain Analyst) M arch 2012 to

M arch 2013

Senior Analyst (JDA Transport Management Systems)

• Liaison between the user’s group, finance group, and Business group for requirements.

• Work with PM closely to Develop and execute activities related to end-to-end project management,

including project plans, scoping and requirements through implementation and deployment. Proactively

monitor, manage and report on execution of deliverables.

• Elicited information and validation for the data, and current Process Mapping to “To be”, to create

different types of reports to make those automated reports.

• Responsible for WEB Based application JDA REAL time Transportation Management System, IPT

(International Product Tracking system).

• Responsible to translate business requirement to the Functional and non-Functional requirement spec for

the developer.

• Responsible for gathering requirements related to Distribution Center operations. Interfaced with

various individuals in the distribution center

• Mapped out Distribution Center processes – ensuring that when Supply Chain received the data from the

WMS that it’s valid and verified throughout the process for the distribution center.

• The WMS group used Manhattan and Supply Chain received the same data without verification. Supply

Chain was then responsible for that verification for Manhattan data and supported the application with

the WMS group.

• Required to fill out eRequisition forms and documentation for Global Delivery, when product goes live

at the implementation time, required all the details regarding product, source code, QA result,

scheduling.

• SAP Migration to legacy and JDA Transportation integration, required data mapping, logic change in

script and program, and worked on several interfaces between SAP and legacy applications to reduce

inconsistencies. Supported a real time truck tracking application to maintain an accurate shipment &

delivery timing record to facilitate operations at distribution centers and stores. End to end Worked on

Financial Reconciliation report enterprise level and gathered requirements from different groups. Using

Process Mapping, Flow Diagram, Data Mapping, Data WH.

• Technology Used: JDA Transportation Real time Tracking system, for inventory, Orders, Freight

movement, Cognos/Crystal Reporting, Oracle 11 /INV/BOM//Manhattan WMS/FP/FM/Transportation,

Oracle PL/SQL, WEB base Application, Java, SSRS, Infrastructure Network, Window Server,

SharePoint, BI Gathered Corporate level data for decision making. Work with Third party CRM

application kind JDA Transportation, SAP, ORACLE, and VISIO

Rogers Communications Inc., PCIDSS June 2011 to September 2011

Senior Business Systems Analyst (contract)

2

• Liaison between IT, Asset Manager, Security, Data server Admin, Application Owner, Vendors and

Network Admins.

• Work with PM/SME/Architect closely to Develop and execute activities related to end-to-end project

management, including project plans, scoping and requirements through implementation and

deployment. Proactively monitor, manage and report on execution of deliverables.

• Worked with Business and Project stakeholders to define business needs and requirements.

• Gathered requirements for POS data secured when Database Centre received, for Payment Credit Card

Industry Data Security Service.

• Wrote functional requirements in the form of Flow Diagram and presentation.

• Presented business needs and functional requirements to Quality Assurance (QA) and Software

Development teams. Using: Visio, MS Office Documentation,

Ford Motor Company of Canada Ltd Sept 2010 - May 2011

Senior Business Systems Analyst

• Led the Reengineering Vehicle Incentive Systems project from beginning to end; gathered information

from local and global users, analyzed requirements, designed and tested solutions for revised

applications. Completed analysis of stored procedure in DB2, Documented Current Process Mapping to

“ TO BE” Data mapping, Process Improving for the new requirements and business rules

• Managed JAD sessions to verify requirements/business rules. Created technical documentation.

• Using: VISIO, SQL and DB2, DB2 Connect, Mainframe, COBOL, ASP, .NET and JAVA.

President’s Choice Financial (Credit Card Division)/ (Loblaw/CIBC) June 2009 - July-

2010

Senior Technical Solutions Manager/Business Systems Analyst

• Liaison between the User group, Finance group, and Business group for the requirements

• Work with PM closely to Develop and execute activities related to end-to-end project management,

including project plans, scoping and requirements through implementation and deployment. Proactively

monitor, manage and report on execution of deliverables.

• Elicited information and validation for the data using BI and BPMN, UML(Flowchart)

• Met stakeholders and identified their requirements for the further process,

• Held an internal client-facing role requiring outstanding skills in management of people, diplomacy and

project coordination. Led the conversion project from end to end with successful conclusion.

• Supported Products involving Payments, Collections, Credit Bureau, Loyalty and Finance. Led technical

teams in conversion, pilot and cutover activities.

• Liaised between internal PC banking clients, business, Vendors, developer, QA and support teams, and

also liaised between users and vendors, such as, Gemma Communications, D+H, TechCom, Score,

Equifax, Telpay and CIBC.

• Understood Data Model in preparing Data Extract, Transformation & Data Load to Data Warehouse

(Relational Database). Analyzed data using SQL to understand Source system data. Preparation of Data

mapping between Source system & Target system.

• Prepared Business Requirement document to Data Load & Data Extract from Data Warehouse, Using BI

to Gathered Corporate level data for decision making, multiple solution and process mapping for current

to “TO BE” process. Support POS real time data for data warehouse.

• Performed SQL queries, Data Mapping, created design documents and functional specifications, wrote

technical solutions document, scripting, test cases, also helping testing, product validation and

verification.

Page 3 of 6

Paresh Gandhi Sr. BSA- 905-***-****

• Required to fill out eRequisition forms and documentation for Global Delivery, when product goes live

at the implementation time, required all the details regarding product, source code, QA result,

scheduling.

• Created documentation: data mapping, testing, scripts and test cases, operational, (BRD, FDD TSD,

IDD, VRD)

• Worked on third party CRM application: TSYS, FDR, ORACLE,

G reat West Life Assurance Company August 2008 – June 2009

Senior Business Systems Analyst

• Liaison between the User group, Finance group, and Business group at the enterprise level for the

requirements.

• Work with PM closely to Develop and execute activities related to end-to-end project management,

including project plans, scoping and requirements through implementation and deployment. Proactively

monitor, manage and report on execution of deliverables.

• Elicited requirement information and met stakeholder’s to identify their requirements for the further

process. Supported a highly complex conversion/AIX OS upgrade project by liaising with vendors,

architects, business operations, development, and quality control and support teams. Analysed user

requirements, prepared data modeling, designed changes, coded, tested and successfully implemented

the new system. Managed releases, created functional and non-functional requirements documents,

executed SQL queries to validate data. Planned and executed testing for this multi-client system.

Worked on Process Mapping for current to “TO BE” using Visio,

• Front-end used .NET, ASP, Oracle, AIX/Unix; Legacy system used CICS/COBOL/DB2/JCL;

methodology included COBIT framework and AD Methodology, TI Methodology with all compliance

requirements, use cases for testing and AD/TI Methodology. Using BI to Gathered Corporate level data

for decision making for users, Business users, stakeholders and executive.

Royal Bank of Canada (RBC Visa) December 2006 –May 2008

Senior Systems Analyst (contract)

• Liaison between IT and Enterprise level groups to identify the requirements and required signoff on

documents

• Functioned as the technical lead responsible for documentation, technical specifications and unit testing

of credit card-related applications. White box/black box testing, functionality testing and system testing

were included. Gathered business/functional requirements, understood business strategies, executed QA

test cases and conducted the analysis of results; determined severity of variances/defects and escalated

accordingly.

• Incorporated business requirements into the software applications, data warehouse and structured

software development lifecycle, thereby maturing the software capabilities. worked on Process Mapping

for current process to “TO BE” using Visio,

Toyota Canada Inc. September 2005 - Dec 2006

Senior Systems Analyst (contract)

• Analysed user requirements, prepared data modeling, designed changes, coded, tested and implemented

changes to the dealer support system, with modules including logistics, parts and service and marketing.

• Worked on Parts WMS for inventory and order application for the enhancement. Modified calculations

for bonuses and reporting. Fixed bugs, documented issues and maintained logs.

• BI to Gathered Corporate level data for decision making for Marketing, Sales, Dealers and many other

groups.

4

Royal Information Services August 2004 - August 2005

Senior Systems Analyst, Financial Applications

• Analysed user requirements, prepared data modeling, coded, tested and implemented changes to the

loan/repayment system and cheque-cashing application, including modules for fraud and anti-money-

laundering.

Nissan Service California and AT &T Universal Billing System June 2001 - July 2004

Senior Systems Analyst (contract)

• Liaison between Users, Business group and IBM clients. Working closely between business/project

teams, development groups, and quality control and support teams. This internal client-facing role

required outstanding people management and project coordination skills. Interacted with different

groups at enterprise level, to identify business requirements.

• Responsibilities included analysis of requirements, designing, coding, testing and implementation of a

risk-analysis system incorporating modules for claims, warranties, data warehousing, customer surveys

and data retention for parts and audits.

• Worked on Parts WMS for inventory and order application for the enhancement. Modified calculations

for bonuses and reporting. Fixed bugs, documented issues and maintained logs.

Canadian Imperial Bank of Commerce (CIBC) April 2000 - June 2001

Senior Systems Analyst

• Wrote and analysed user requirements, prepared data modeling, designed changes, coded, tested and

release-managed the implementation of an audit reporting management system. Provided 24/7 support,

resulting in timely resolutions to critical issues.

BANK OF A MERICA (formerly Nations Bank) February 1997 - March 2000

Senior Systems Analyst

• I converted the credit rating system from mainframe to client/server. I worked on multiple projects in the

Deposit Systems group and the cheque system and also Implemented the Recovery Management

System, credit card system enhancements, mortgage/car loan applications, credit bureau module and

interfaces. Migrated the RMS application from different banks to merge with Bank of America.

CO MPUTER TASK GROUP (various clients) July 1995 - January 1997

Sr. Systems Analyst

• IBM, ANY Banking Online Bill Payment Systems(pilot project)

• FIRST UNION NATIONAL BANK: IMS/DB2 conversion in to COBOL/DB2.

• ROYAL INSURANCE, Online Real time claims Report

• BLUE CROSS - BLUE SHIELD: Paperless Claims/Billing Application

LO WE'S USA Retail June 1993 - June 1995

Senior Systems Programmer /Analyst Worked on WMS

Duke Power USA (thru TSI Inc.) June 1992 - June 1993

Systems Technical Consultant Worked on Asset appliction

Policy Management System Corp. June 1989 - June 1992

Mainframe Programmer /Analyst Worked on Claims and Property

Education

Page 5 of 6

Paresh Gandhi Sr. BSA- 905-***-****

• Specialized in Computer Science: CPCC, Charlotte NC USA (1988-1990)

• Degree: B.S in Mechanical Engineering - India (1980 to 1985)

• Special Training: Business Analyst, COBIT Methodology, AD Methodology, TI Methodology,

Framework, Mercury QA, QCC, QTP, Automation testing, Manual Testing, IBM File Manager, Fault

Analyzer, File Aid

6

Contact this candidate