Post Job Free

Resume

Sign in

Senior Business Analyst

Location:
Mountain View, CA
Posted:
April 20, 2017

Contact this candidate

Original resume on Jobvertise

Resume:

Shilpa Gharat

510-***-**** / aczv94@r.postjobfree.com

Summary:

. 13+ years of experience in complete project life cycle including

requirement gathering and analysis, design, development, reviews,

testing, implementation, deployment, support and maintenance of

business applications.

. Experience in working with and managing cross- functional teams

including the Development team (Front End and backend), Testing team,

production support team, QA and the Business users.

. Experience working as a Senior Business Analyst with Technical

background.

. Business and Functional Expertise in Product Configuration, Stock

Exchange, Telecom domains.

. Experience in full lifecycle development using SDLC methodologies such

as Agile, Waterfall and Rational Unified Process (RUP).

. Experienced with tools like UML and Rational Rose for creating and

managing use cases.

. Well versed in coordinating system testing/ UAT through Test Plans and

Test Scripts.

. Excellent communication skills, good organizational abilities and

excellent problem solving skills.

. Experience in conducting End-user training sessions for full user

application.

. Experience in working with SEI-CMM Level 5 and ISO 9001 companies like

Cisco, Capgemini etc.

. Involved in Direct Client and User Interaction.

. 7+ years of Oracle E-Business Suite experience.

. Software development experience on Oracle 8i/9i/10g, PL/SQL, Oracle

Forms and Reports under Windows NT, XP and UNIX environments.

. Expertise in back end programming with strong programming experience

in SQL and PL/SQL.

. Expertise in using tools like TOAD, SQL*Loader.

. Good understanding of SaaS model.

Technical Skills:

Programming languages : SQL, PL/SQL

Development Tools : Forms 6i/10g, VB 6.0

Platform and OS : Windows 95/98/NT/XP, UNIX

Design Tools : UML, Visio

Configuration management tools : Visual Source Safe, Clear Case,

PVCS

Database : Oracle 8i/9i

Reporting Tools : Oracle Reports 6i/10g

Security : VPN, Citrix

Data Load Tools : SQL*Loader

MS Tools : MS Excel, Word, Power Point

Editors : Toad, Editplus, Putty

Data Warehousing Tool : Informatica Power Center 7.1

ERP : Oracle E-business Suite 12.1.1

Professional Training

. Oracle Certified Associates for Oracle 9i DBA (1st, 2nd & 3rd Exams of

OCP DBA).

. Undergone training in Informatica, Data Stage, Profile Stage from

Capgemini.

Education

. Bachelor of Engineering in Computer Engineering (University of Pune).

. Diploma in Electrical Engineering (Mumbai).

Professional Experience:

Cisco Systems Inc, San Jose, CA,

May 2015 - Dec 2015

Business Analyst in PDOps

Pricing & Discounting (P&D Operations) in Cisco is a very dynamic and

complex process. A Price List is a catalog of Cisco products and services

used by Cisco customers and partners for quoting and ordering. Typically,

products and services associated with each Price List define local

availability and pricing. Additionally, the currency of a Price List drives

the denomination of a quote/order and the associated transaction End to

End.

Responsibilities

. Responsible for creating, analyzing and researching contractual

discounts for all types of Cisco products and services through a legal

contract.

. Responsible for researching, analyzing and resolving contractual

discount cases submitted by various departments within Cisco.

. Responsible for setup of standard distributor discounts

. Execute Uplift Price changes for Global and Wholesale Price List .

. Resolve escalated Pricing/Discount support Cases.

. Daily collaboration with IT teams regarding application issues and

application development

Cisco Systems Inc, San Jose, CA,

Sep 2008 -Apr 2015

Business Analyst in CDOS

CDOS (Connected Data operations Services) is part of Cisco's Quote to Cash

organization. CDOS's goal is to set up each product so that the customer

can successfully order compatible configurations.

Responsibilities

. Responsible for managing product setup and life cycle changes for

Cisco's networking product families.

. Responsible for setting up new products in Cisco's Enterprise Resource

Planning systems involving Bill of Material (BOM) structures for all

Cisco Products.

. Writing and managing business rules

Create all quantity checks, compatibility, expansion/inclusion-exclusion

default rules for all cisco products.

Maintain accuracy in all configuration rules.

. Managing the orderability status.

Turn on/off orderability for models, spares and options as determined by

NPIPM.

. Work with Business Unit product managers, New Product Introduction

project managers, pricing and service operation teams to implement

product structure, and implement business rules logic.

. Provide back end transactional support for configuration and ordering

related issues

. Work with the product team to thoroughly test the configuration rules.

. Run the test order to check the order is passes thoroughly w/o any

configuration error.

. Ensured Purchase Orders and Sales Orders are booked through to

completion, making sure all holds are released and orders have been

fully invoiced

. Resolved high level customer satisfaction issues regarding order

failures, conversion failures, and submission issues so deals are

properly booked.

. Collaborate with cross functional teams to correct system issues.

. Daily collaboration with IT teams regarding application issues

. Resolve escalated product, pricing and service support cases.

Environment: Oracle E-business Suite 12.1.1, Selectica's tools for

validation and configuration of products,

Remedy tool for service request Management, MS-Excel.

Cap Gemini, Mumbai, India

Apr 2005 - May 2008

Sr Consultant

Tele Denmark Corporation

Oct 2007 - May 2008

TDC is a leading Telecom company in Denmark. Topas Application is used for

rating of all traffic received from/sent to other Carriers (Operators) and

keeping track of the money. TOPAS covers all the features and facilities

needed to run a Carrier Billing Business for an International Tele Company.

Responsibilities

. Responsible for Change Request process and Impact Analysis.

. Writing Detailed Program Design (DPD) for CR.

. Developed new Oracle PLSQL Store Procedures and Packages for Skip

Rating Module and existing packages are modified according to business

requirements. Worked on DBMS_LOB, DMBS_UTILITY packages.

. Routine support activities like Partition Maintenance, Index

Rebuilding, Analyzing objects, Tablespace maintenance.

. Creation of Test plans.

. Preparing test Data Scripts for the modules designed and developed.

. Creation of User guide and Install guide.

. Coordinated with Testing group and bug fixing is done successfully.

. Tracked defects to closure using bug tracking tools such as Mercury

Quality Center.

Environment: Oracle 9i, Forms 10g, Reports 10g, UNIX, MS-Excel and MS-

Office2000.

UWV for Netherland Government

Nov 2005 - Sep 2007

UWV (Uitvoering Werknemers Verzekering) is a Dutch govt. social security

body handling income data and corresponding allowances for all NL citizens.

The overall data flow within as well as to & from outside the organization

was not serialized and required a lot of efforts from employers as well as

the organization itself.

The project, Policy Administration System, is about reorganizing the

overall data flow affecting all involved parties (municipality, employers,

govt. bodies etc.) and handling the huge amount of data at a central

location (i.e., UWV). The project also involves extraction of this data in

terms of meaningful reports as desired by the interested parties.

Responsibilities:

. Installation and Configuration of oracle products, initial Database

Creation (in development environment).

. Writing pl/sql code in oracle 9i.

. Sql statement and Pl/SQL tuning

. Worked on XML functions for creating views

. Taking backups of development database.

. Preparing test Data Scripts for the modules designed and developed

. Improvement in the Performance of various Database Activities.

. Responsible for preparing the Software Requirement Specifications

(SRS) document, Functional Specification Document (FSD).

. Importing/Exporting data from/to different databases using utilities

like SQL*Loader, Import/Export

. Involved in increasing the tablespaces, extents whenever required.

. Creating corncobs using dbm_jobs package for daily maintenance related

activities.

. Monitoring the database for hung processes.

. Worked closely with the Testing team to develop detailed test plans

and correlate them with requirements to ensure full coverage

. Coordinating the testing effort and making sure that the testing

results adhere to the expected outcomes

Environment: Oracle 9i, Java 1.3, JDBC 1.0, UML, MS Word and Windows NT

ABN AMRO - PDM (Price and Deal Management) Application, Mumbai, India

Apr 2005 - Oct 2005

PL/SQL ETL Developer

PDM Application is an End-to-End Billing solution which helps preparing

Deal/s Review and pricing for the solution.

PDM facilitate Performing EDP, Redefining Pricing and presenting Proposal

to Client activities etc.

Responsibilities:

. Had to write some stored procedures, call them using Informatica

transformations to implement the auditing and exceptional methodology

on the source data.

. Worked extensively on performance issues and fine-tuned SQL overrides

in terms of efficiently writing SQL targets, mappings and sessions.

. Involved in the creation of oracle Tables, Table Partitions, Indexes,

tuning queries and data validations using TOAD.

. Mapplets and reusable transformations have been part of the mappings

since different data types conversions have to be dealt multiple times

which are similar and also most of the lookups have been similar.

. Extensively used transformations like lookup, aggregate, joiner,

filter, and sequence generator, expression to create complex mappings.

. Created mappings to load and maintain aggregate tables in the data

warehouse.

Environment: Oracle 9i (9.2.0.5) on WIN NT server, MS Access 2002,

Informatica Power Center 7.1

National Stock Exchange, Mumbai, India

May 2004 - Mar 2005

System Analyst

Project: IGC

Nov 2004 - Mar 2005

Investor Grievances Cell is a team that addresses the grievances of the

Investor. This project was a maintenance-cum-enhancement project. This

system is used by the IGC team of NSE. This system is used to solve the

problem

Of investors and maintain their records

Responsibilities

. Carrying out the Enhancements in various D2K reports and their testing.

. Extensively involved in writing SQL queries (Sub queries and Join

conditions), PL/SQL programming.

. Involved in Query Level Performance tuning.

. Created stored procedures, Stored functions, Packages, Exception

handlers, Ref Cursors and used in many Reports. Written many database

triggers for automatic updating the tables and views.

. Involved in designing and developing validations plans and test case

documents.

. Prepared Test Plans and successfully ran the Test Cases

. Rolled out the modified programs into production

Environment: Oracle 9i, Forms 6i, Reports 6i, Windows 95, MS Excel

Project: CM Listing

May 2004 - Oct 2004

CM Listing project was a maintenance-cum-enhancement project. This system

is used by the Listing team of NSE. It helps to maintain the flow of

information among the investors, stock exchange and the listed companies.

Responsibilities:

. Importing/Exporting data from/to different databases using utilities like

SQL*Loader, Import/Export (Migration Process).

. Involved in coding data extraction procedures for migration to new

software.

. Interact with User group to gather requirements.

. Creation of project plan and estimates.

. Prepared database design and designs for UI screens.

. Monitoring project status and interact with development team to review

status

. Provide updates to User group on project status and review requirements.

. Developed various Reports for the end users as per their requirements and

created many reports to suit preprinted format of the company.

. Front end coding and creating menus.

. Creation of Test plans.

. Creation of User guide and Install guide.

. Post release activities such as

o Trouble shooting hardware / software issues.

o User follow-ups for feedbacks on latest release post 15 days usage.

. Development of Reports and Database Procedures.

. Responsible for Change Management process and Impact Analysis

. QA Manager

. Delivered data model and design of critical modules.

Environment: Oracle 9i, Visual Basic 6.0, Windows 95, MS-Excel and MS-Word.

Dew Soft Solutions Pvt. Ltd, Mumbai, India

Sep 2003 - Apr 2004 Software Engineer

BMJ is basically an ERP product for manufacturing units, which follows ISO

9001 standards. The main aim of this project is to provide a cost effective

and efficient ERP solution to the small scale-manufacturing units. Various

modules are added as per client requirements. I worked on payroll system.

Responsibilities:

. Collected user requirements for new Payroll Module.

. Preparing database design and designs for UI screens.

. Created stored procedures, Stored functions, Packages, Exception

handlers.

. Importing/Exporting data from/to different databases using utilities like

SQL*Loader, Import/Export (Migration Process).

. Involved in direct interaction with the End Users and implemented reviews

of the application.

. Creation of User guide and Install guide.

Environment: Oracle 9i, Visual Basic 6.0, Windows 95, MS-Excel and MS-Word.

E-Vyapar Info Solutions, Pune, India

Sep 2002 - Aug 2003

The main aim of this utility is to generate the form dynamically, which has

to be filled by customer. This utility can be used by any kind of database

application. It provides us to transfer the data from the local machine to

server where database is stored.

Responsibilities:

. System Design, Program Specification preparation

. Involved in creation of Tables using storage parameters and clusters.

. Coded many generic routines (as functions), which could be called from

other procedures.

. Involved in creation of Sequences for automatic generation of numbers and

created views for hiding SQLs.

. Extensively involved in writing SQL queries (Sub queries and Join

conditions), PL/SQL programming.

. Front end coding and creating menus.

. Developed stored procedures, Functions and Database triggers using

PL/SQL.

. Testing and Implementation of various Procedures and Functions

Environment: Oracle 9i, Java 1.2, JDBC 1.0, and Windows NT.



Contact this candidate