PALAK PATEL

Professional Summary:

. Experienced in IT Implementation of Business Intelligence

solutions using Business Intelligence applications for various

verticals.

. Experience in decision support systems using Business Intelligence

tools SAP BOBJ 4.0/3.1 / XI R3 / XI R2.

. Experience in gathering requirements from the business users and

prioritizing those requirements, which have the highest business

impact in terms of analysis and decision-making. Worked with

Business users to analyze the business process and made necessary

changes to the schema objects.

. Proficient in translating report requirements into detailed report

specifications, confirm report design with business users.

. Comprehensive knowledge of Software Development Life Cycle (SDLC),

having thorough understanding of various phases like Requirements,

Analysis/Design, Development and Testing.

. Experience interacting with multiple levels of business executives

and team members.

. Well versed in data analyses and data presentation.

. Experience with creating hierarchies, predefined conditions,

customized Lists of Values, Derived Tables and in using @

functions.

. Created complex and sophisticated Ad-Hoc & Canned Reports using

Webi drilldown, slice and dice features using Business Objects.

. Extensively used Business Objects reporting functionalities such as

Master Detailed, Breaks, Slice and Dice, Drilling methodology,

Filters, Ranking, Alerting and Graphs.

. Comprehensive knowledge of RUP, Waterfall, Agile methodologies

. Excellent skills in gathering requirements and creating Business

Requirements Document (BRD) and Functional Requirements Document

(FRD), facilitating Joint Application Development (JAD) sessions,

developing Use Cases, User Acceptance Testing (UAT) and proposed

changes for process improvement.

. Highly proficient in UML, Sequence and Activity Diagrams using MS

Visio.

. Proficient in MS Word, Excel, Access, and PowerPoint, MS SQL

Server, and Data Analysis

. Good problem solving and decision making skills.

. Flexible, Quick learner, project-oriented team player with solid

communication and leadership skills.

TECHNICAL SKILLS:

Operating System Windows XP/VISTA/7, Mac OS x, Unix

Databases Oracle, MySQL, MS Access, SQL Server 2008

Programming SQL,HTML, XML, C, C++, VB, VBScript

languages

BI Tools Business Objects XIR3.1/XIR2 - SAP Business

Objects Web Intelligence, SAP Business Objects

Desktop Intelligence, Info View, CMC, Designer,

Crystal Xcelsius Reports 2008, Crystal Report

Bug tracking Tools HP-QC, Bugzilla, IBM Rational Clear Quest, JIRA

Other Tools Putty, VMware workstation MS Office Suite,

Rational Requisite Pro, Meddler, Business

Objects

Experience:

Wells Fargo, SFO, CA

Dec 2011 -June

2013

BI Reporting Analyst

As a part of WIB team, worked on several projects like Cash Flow Monitor,

Mobile iLabs, SurePay, Isis Wallet Registration, Voice banking App.

Responsibilities:

. Active participant in the implementation of building and

maintaining data warehouse/data repository and business

intelligence environment. Develop Business Objects universes,

information spaces, reports and dashboards.

. Ensure documentation is created and maintained for all processes

and reports supported using business intelligence software.

. Ensure data integrity between source system data and the data

warehouse through an understanding of the flow of data from source

systems to the data warehouse and associated user interfaces.

. Design, develop, analyze and publish data queries and reports in

easy to understand formats consistent with company and business

units needs and specifications. Actively work to move existing

reports and queries into the data warehouse/business intelligence

software.

. Through consistent and timely reporting, monitor and analyze data

and metrics for patterns, trends and anomalies. Provide proactive

assessment and recommendations to business areas on how to leverage

the information within their areas to improve processes, functions

and/or systems.

. Perform ad hoc data requests and analysis as requested.

. Identify test data requirements; create test data and database

queries to assist in test execution. Partner with Systems

Coordinator to ensure test plans are detailed, accurate and

generate desired outcomes when system updates are moved to

production environment.

. Trained the user community in making use of universe to create and

publish ad-hoc reports.

. Created Cardinalities, Contexts, Joins and Aliases for resolving

Loops/Ambiguities and checked the Integrity of the Universes.

. Automated documents Scheduling, Publishing and Distribution for

WebI reports for Info view clients.

. Worked with database connections, SQL joins, cardinalities, loops,

aliases, views, aggregate conditions, parsing of objects and

hierarchies.

. Exported universes to Repository in order to make resources

available to the users

Pepsico, New York, NY

Sept 2009- Nov 2011

Reporting Analyst

As a Project Manager, worked in Pepsico's Supply Chain and Logistics

Division and helped implementing 'Item Pricing Synchronization' (IPS)

initiative which was aimed to streamline Pepsi's Item, Customer and

Pricing database with its customers and vendor and provide electronic

pricing and invoicing to its customers

Responsibilities:

. Implemented technical requirements and data specifications for

creating Business Objects Universes and Reports.

. Interacted with Business Users, Business Owners to better understand

the business and modifying Universes and Reports accordingly

. Provided Decision Support to upper management by generating various

SAP/Excel/Access/SQL reports

. Develop Operational, Transactional reports and complex Management

report metrics using WEBI

. Modified the existing Business Objects universe to facilitate the end-

users in creating custom LOVs, Prompts conditions, Dimensions,

Measures and Details.

. Worked towards optimal design of universes and removed loops with the

use of aliases and contexts.

. Gathered complex statistical data and translated into meaningful

reports with Business Objects i.e. Customer Service, Inventory Levels

. Created various reports like Slice and Dice, Drill Down, Combined

Queries, Formulae for easy-to-use benefit information system by using

WEB

. Part of the daily Agile Sprint and Scrum Processes for the successful

completion of canned and Ad-hoc requests from customers

. Defines database usage concepts, selects records, organizes data and

formats reports; exports

(Distributes) reports; builds, applies and removes report templates.

. Involved in Designing Universes and resolving issues like, Chasm Trap

and Fan Trap using Contexts and Aliases.

. Worked with Administrator to create Users, General Users, and Power

Users and set the security on them.

Toyota Motors, Torrance, CA

Dec

2007-Aug 2009

Reporting Analyst

Worked on projects related to supply chain management of global procurement

to track the lost in transit items for multiple shipments, Exchange part

sales tracking. The Exchange sales project has been developed to support

the warranty system where the parts were being sold and unserviceable cores

received from major customers facilitating the part exchange process. The

stock transfer project will keep track of the orders and shipments of the

parts across different locations of Toyota and it has been streamlined for

more cost effective transfer for all of the Toyota Product Line

Responsibilities:

. Involved in constant Requirements gathering and business needs with

executives and traders for

dashboard design and development.

. Converted Reporting business requirements in to Functional design and

Technical design documents.

. Working along with DBA/s, BA's and Data modelers for data design and

report design.

. Involved and designed the Enterprise level data security, report

security level set up folder structure

and User group access.

. Administered user privileges, access, training and implementation for

SAP BO

. Designed, developed and maintained Universes for supporting canned

reports

. Created various classes and objects,measure objects and User objects

in the Universe keeping in view of the end user requirement

. Detected cardinalities and checked the Integrity of Universes

. Resolved the fan and chasm traps

. Created Hierarchies to provide drill down functionality

. Worked on aggregate navigation to lower the data retrieval rate while

generating reports

. Created Filters and conditions to improve the report generation

Sams Club, Bentonville, AR

Nov 2006-Oct 2007

Sr. Business Analyst

Sams Club has identified process to enhance the member experience to its

samsclub.com. This is mobile application project where we developed

samsclub.com mobile app for iPhone, Android and Blackberry mobiles.

Automated reports are to be generated so that business users will have

information handy in a timely fashion.

Responsibilities:

. Used Agile and Scrum methodology for a sequential development process.

. Worked closely with Subject Matter Expertise (SMEs) and Tech Leads and

did analysis on the high level business requirements to convert them

to system requirements.

. Developed Process flow modeling and simulation using BPM.

. Worked closely with user interface (GUI) web designers to create

screen layouts with emphasis on user friendliness, clarity and

consistency with applications and standards; assist with developing

new standards and help review Heuristic evaluations.

. Gathering Requirements, Create User Stories and Acceptance test

criteria.

. Collaborating requirements with geographically distributed, cross

functional teams (Development, QA, UI Design, Documentation,

Professional Service Team).

. Extensively used QC (Quality Center) for requirements gathering

purposes. Created Test Scripts and defects using HP Quality Center

. Participated in QA meetings such as test strategy, test methodology

and test plan meetings.

. Created Requirements Traceability Matrices (RTM) to trace back the

test cases to the use cases and requirements.

. Facilitated user acceptance testing (UAT) and usability test

strategies with Information Technology Group.

. Worked closely with both testing and development teams for defect

resolution.

. Uploaded the approved requirements and other documents into the

Knowledge Link folder and shared with the team.

. Prepare the AS-IS and TO-BE process flows for all the modules in the

system.

. Generate mock-ups for the reports intended to be developed.

. Worked with application support and maintenance. Working knowledge of

identifying and reporting bugs.

. Prepare the use cases for all the modules.

. Prepare the proto types to demonstrate what can be expected after the

changes are implemented.

. Present the entire project timelines and solution to the business and

technical teams.

Universal Herbs Inc (www.herbspro.com), CA

Jul 2005- Oct 2006

Business Analyst/ QA

The system was developed primarily to support customers on providing the

most valuable and easy shopping user interface. The system advised the

clients on customers buying practices, fast selling products, provide clear

and complete picture of clients assets in products and positions. The

secondary role of the system was to provide client easy automated access to

important data like the shipping collected from customer VS shipping paid

to shipping carriers which helped client to pass the savings to customers

to attract more customers, number of orders delayed and the primary reason

for it, integrating API for different check out or payment options etc.

Responsibilities:

. Conducted requirements elicitation meetings with end users to document

business requirements in BRD and used Rational Requisite Pro for

management of these requirements

. Transformed BRD into Use Cases using UML for new product

functionality. Used tools such as MS Visio to define business Use

Cases, and activity diagrams

. Developed Business Objects reports (including Dashboard reports) based

on the new enhancements and interpret the data (Business Intelligence

Report writing).

. Responsible for identifying and documenting business rules and

creating detailed Use Case

. Conducted user interviews at both in-house and client locations,

gathering and analyzing requirements using RequisitePro.

. Identify, research, Realize, investigate, analyze, define and document

business processes and Use Case Scenarios.

. Liaison for projects with other corporate departments, including

Executive, Legal and Information Services as well as vendor

relationships.

. Used detailed knowledge of application features and functions assess

scope and impact of business needs throughout analysis and completion

of all enhancement specifications

. Performed Gap analysis by identifying existing technologies,

documenting the enhancements to meet the end state requirements.

. Designed and developed Use Cases, Activity Diagrams, Sequence

Diagrams, OOD using UML

. Assisted with user testing of systems (UAT), developing and

maintaining quality procedures, and ensuring that appropriate

documentation is in place

. Worked with development and testing teams to accomplish timely release

objectives.

. Developed timelines for project delivery, and managed projects and

resources to successful completion

Contact this candidate