Post Job Free

Resume

Sign in

Sr Business Analyst

Location:
Oakland, CA, 94619
Salary:
75k/yr
Posted:
January 27, 2011

Contact this candidate

Resume:

Technical Skills and Experience:

• SQL and PL-SQL

• Report Development (Cognos BI and SAP BPC)

• Teradata, Sybase, Oracle, and MS Access databases

• OLAP and OLTP databases

• MS SharePoint

• Microsoft Office Suite including very strong Excel and Visio skills

• Microsoft Dynamics

• Java

• HTML

• Source Control/Versioning systems

Education:

Bachelors in Industrial and Systems Engineering May 2006

University of Southern California Los Angeles, CA

University GPA: 3.61/4.00 Major GPA: 3.96/4.00

• President of USC chapter and invited member of Alpha Pi Mu, national ISE Honor’s Society.

• Invited member of Omega Rho, international academic honor society in the field of Operations Research and Management Science.

• USC Viterbi School of Engineering Dean’s list.

Experience:

Hitachi Consulting July, 2007-Present

Senior Consultant – San Francisco, CA

Primary Practice: Business Intelligence and Process Management (BIPM)

• Experience on multiple projects learning new technical and soft skills quickly to deliver high value results in various client facing environments.

• Project: Cognos BI Implementation for Wynn Casino and Resort

Conducted data collection, organization, and analysis.

Primary report developer of corporate hotel and casino reports including:

Report requirement gathering with business users.

Definition of data hierarchies and dimensions as related to reports.

Visual report design.

Data validation with legacy reporting systems.

Conducted user Acceptance Testing and report deployment.

• Project: Sales Commission Report Development and Technical Support for Clearwire

Sales commission process definition.

Develop ‘safe’ commission plans to guard against and identify commission ‘cheating.’

Aid business to drive desired sales activity within the limits of their data.

Primary report developer of sales commissions reports

Report requirement gathering with business users both internal and external reports.

Visual report design.

Data validation with legacy reporting systems.

Conducted user Acceptance Testing and report deployment.

Data investigation using SQL to:

Identify data quality issues.

Determine feasibility of proposed commission changes.

• Project: BI/Revenue Assurance for Virgin Mobile USA

Investigated a telecommunication company’s IT systems related to revenue recognition from sales to booking. Extensive current state process mapping and on site interviews.

Contributed to the definition of project scope, objectives, and methods.

Proposed Solution of 16 control point threshold reports linked to a dynamic visual reporting dashboard. Implementation would give business precise knowledge of revenue movement.

• Project: SAP Business Planning and Consolidation [BPC] (formerly OutlookSoft) Implementations at Kimpton Hotels (Boutique Hotel Chain), and BJ Services (Oil Drilling)

Assisted in report creation and troubleshooting on ongoing BI implementations.

Experience (Continued)

Infosys Technologies Ltd. July, 2006-July 2007

Software Engineer/On-site IT Consultant Bangalore, India/Fremont, CA, USA

• Completed 4 month Infosys training program consisting of 15 courses designed to serve as an introduction to developing J2EE web applications and serving as a business analyst on client engagements.

• High Performer during training (GPA w/ cumulative exams and project: 4.83 on a 5 perfect scale).

• International work experience with an Indian based International company including exposure to a Global Delivery System, a global training center (Mysore, India), a company headquarters/development center (Bangalore, India), and a North American regional branch (Fremont, CA, USA).

Arrow Electronics January-April, 2006

Process Improvement Intern/Supervisor Training Ontario, CA

• Time Studies to benchmark and standardize work tasks.

• Facility Layout Analysis to increase speed and ease of material and personnel flow.

• Job Analysis of the time and ease of manual tasks in the picking and packing departments. Led to tool movement for increased productivity.

• Process Analysis of an automated picking system with the goal of increasing the number of picks.

Rockwell Collins Rollmet September, 2005-May, 2006

USC Engineering Senior Project/Consultant Irvine, Ca

• Complete 5S improvement plan for the manufacture of MK-104 missiles.

• Shop floor layout improvement to clean up parts, WIP, and finished inventory.

• Process Analysis and Improvement to speed up bottlenecks in the production flow.



Contact this candidate