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.