Service Project

Laxman Khandagale

Email : ********@*****.***

Phone : +01-408-***-****

Address: *** * ********* **, ***

C308

Sunnyvale, CA, 94087

An IT professional with over 9.5 years of experience, Sr Business Systems

Analyst assignments in IT Organization.

OCA Professional

PROFESSIONAL SNAPSHOT

CORE COMPETENCIES 9.5 + years of solid experience in enterprise application

Software Development Design, Development, Testing, Debugging, Deployment,

Technical expertise Integration, Migration, Support, Documentation of various

Application design, enterprise applications using Java/ J2EE and Oracle

integration technologies

Project estimations, Hands-on experience of building, tuning complex SQLs,

implementations creating/modifying database objects, working on complex DB

Requirement analysis projects, writing PL/SQL blocks and building core java

and end user modules

experience Hands-on expertise in SQL, PL/SQL, Oracle DB2, Oracle

Project and team Apps, Unix / Linux Shell Scripting, Core Java

management Strong knowledge of J2EE (Servlet, JSP), JDBC, Apache

Client Interaction Tomcat 7, HTML, Java Script

Business Impact Hands on expertise on Unix/Linux environments

Analysis Fully equipped in SDLC with Water Fall and Agile

Application Methodologies

Monitoring Experience in using Ant on IBM WebSphere and Apache

Off-shore / Onsite Tomcat, artifactory and SVN. Strong knowledge of Maven

Strong knowledge of services management, supply chain,

CERTIFICATIONS distribution along with Cisco's services business model

(OCA) Oracle and tools

Certified Associate Expert in understanding the customer issues, pain points,

(Developer) manual work, human error prone processes and providing

automated solutions wherever possible along with new

processes

Helped Cisco service teams to improve the productivity by

10% by analyzing and fixing the pain points, automating

the manual processes and reports, auto data feeds to the

systems

Self-driven and be able to work with minimal supervision

and ability to adapt to rapidly changing requirements.

High degree of communication skills, both verbal and

written.

Highly self-motivated and ability to set effective

priorities to achieve Immediate & long-term goals in order

to meet project & operational deadlines

Hands-on expertise in Cisco production environment

application support and support processes, critical issue

handling and management briefing

Full time employee of Zensar Technologies Inc working on

Cisco projects at Cisco office

TECHNICAL EXPERTISE

. Operating Systems: WIN XP/NT/7, UNIX, LINUX

. Programming Skills: Oracle SQL, PL/SQL, Shell Scripting,

Oracle Apps, Oracle D2K, Core Java, Servlet, JSP, HTML, JavaScript

. Database Tools: Golden Gate, Oracle Advance Queues, SQL

Loader

. Development Tools / IDE: Eclipse, TOAD, HP Quality Center, HP PPM,

BMC Remedy 7, Cisco WebEx tools

. Web / Application server: Apache Tomcat 7, IBM WebSphere

. Databases: Oracle 10g,11i,R12

. Configuration Tool: PVCS, CVS, SVN

. Domain: Services, Utilities, Logistics

ACADEMIA

Bachelor of Engineering (BE) University of Pune, India 2003

Computer Engineering (www.unipune.ac.in )

Projects in Annexure

ANNEXURE

PROJECT HISTORY

Project Profile:

Project / Client Name / Location - Cisco Service Contract Center/ Cisco

Systems Inc / San Jose, USA

Duration: Oct 2013 to till date

Technologies -Oracle SQL, PL/SQL, Oracle Advance Queues, Shell Script, Core

Java, Servlet, JSP, JavaScript

Cisco Service Contract Center (CSCC) is one stop shop for Cisco

customers (partners / distributors / Resellers / direct end users) for

buying Cisco services for the products purchased by them. Service contract

is generated from the service quote created in CSCC.

Responsibilities:

As a Computer Systems Analyst, I:

* Develop complex SQLs to fetch data from multiple databases using database

links/temporary tables

* Have hands-on expertize of creating database objects like packages,

procedures, functions, sequences, indexes, views, triggers, synonyms,

database links etc

* Monitor applications, root cause / debug issues in production

environment, handle critical revenue impacting issues

* Develop and deliver complex database projects with multiple databases as

sources

* Tune or re write complex SQLs or logic to improve performance with the

help of explain plan, tkproof and reduce network hops/overhead

* Analyze huge and complex production data using SQL loaders and writing

PL/SQL blocks

* Use shell scripts on Linux for generating reports, alerts, application

monitoring and data updates on Cisco production environment

* Have hands on experience of working on Linux/Unix environments

* Have been using Oracle Golden Gate, Cisco Data Bus for data replication

from one database to another

* Have strong knowledge and experience of object oriented design along with

hands on experience of using Core Java and knowledge of Perl

* Have experience of working on Oracle RAC 12 node databases

* Have extensively used HP Quality Center, JIRA to report/ track defects

and test cases, HP PPM to deploy code to stage/production environment as

well as PVCS, CVS and SVN as version control systems

* Work with business and production support team to gather requirements for

new enhancement, bug and participate in re-architecting the existing

applications, also work on new projects

* Requirement analysis, effort estimation, delivery plan, new project

estimations

* Prepare technical design, test plan document and plan test execution

strategy

* Review the design with required stakeholders and gather the feedback,

change the details as per feedback

* Code requirements, unit test them, system integration test, regression

test

* Drive cross functional engagement and coordinate all efforts till

completion

* Weekly/daily status reporting to cross functional and management team

* Participate in code reviews, solution design

* Prepare preproduction deployment plan along with go live production

deployment planning and support

* Fix the bugs if any reported by QA team, work with business and users for

business acceptance testing (BAT) and user acceptance testing (UAT), data

mining

* Ensure deliverables are documented, clearly understood and timely &

quality delivery

* Impact analysis of code/system changes in the application and/on the

boundary system

* Provide immediate solutions (emergency bug fixes) to revenue impacting

issues

Project / Client Name / Location - Service Commerce BME/ Cisco Systems Inc

/ SJ, USA and Pune, India

Duration: Sep 10 - Sep 13 (Sep 10 to May 12 - Pune, India and Jun 12 to Sep

13 - CA, USA)

Technologies - Oracle SQL, PL/SQL, Oracle Advance Queues, Shell Script,

Core Java, Servlet, JSP, JavaScript

Service Commerce applications (Service Configurator, Customer Profile,

Service availability Matrix) hold the service and product validation rules,

customer orderability information along with discounts and service

availability for the given location. These rules are used to check if the

given customer is eligible to order the service for the given product at

the given location for the given duration.

Responsibilities:

As a Computer Systems Analyst, I was responsible for below activities:

* Work with business and production support team to gather requirements for

new enhancements, bugs

* Effort estimation for release delivery items, prioritization of the bugs,

enhancements

* Drive cross functional engagements in all phases of project delivery

* Create new packages, functions, procedure and modify existing objects

* Create new triggers, indexes, sequences and rewrite queries / code for

performance improvements along with query tuning and optimization

* Solution design for bug or enhancement, code the requirements, unit test,

integration test, regression test

* Work with internal team to complete the initial design, coding, unit

testing and final delivery

* Prepare preproduction deployment plan along with go live production

deployment planning and support

* Prepare technical design, test plan document and plan the test execution

strategy

* Provide support to QA during testing also work with business team for

business acceptance and user acceptance testing

* Conduct regular meetings with client manager, regular follow ups with

cross-flow teams, approvals, daily and weekly status updates

Project / Client Name / Location - Service Configurator/ CISCO Systems Inc

/ SJ USA and Pune India

Duration: Sep 07 to Aug 10 (Sep 07 to May 08 - Pune, India and Jun 08 to

Aug 10- CA, USA)

Technologies -Oracle SQL, PL/SQL, Oracle Advance Queues, Shell Script,

Selectica, Core Java

Service Configurator is used as validation engine to validate service

offerings given by Cisco to its customers. The application is built in

Oracle, Java, Selectica and shell scripts and runs as middle tier jvms on

Sun Solaris servers. SC validates if the requested service is available for

the product or customer are eligible to buy service or service is available

at the requested location along with contract coverage details.

Responsibilities:

As a technical specialist, I was responsible for below activities:

* Gather business requirements and complete design of the solution, code

the requirements, unit test them

* Deploy to production, work to resolve any issues till normalization

* Integrate new quoting application to Service Configurator application

* Debug business critical revenue impacting system issues, dynamic

application configuration changes as per the need from calling

application for scalability

* Analyze integration issues, attend live production environment priority

issues

* Write shell scripts and wrappers as concurrent programs to fix data

issues and generate report

Project / Client Name / Location - Contract Account Assignment / CISCO

Systems Inc / Pune India

Duration: Mar 07 to Aug 07

Technologies - Oracle SQL, PL/SQL

Service contracts are generated for all the services sold by

Cisco. The contract information such as account, renewal team, sales

region, account and renew service sales representative keeps on changing

due to many reasons and should always be updated to most recent. Contract

account assignment engine keeps the information on the contracts updated

and most recent.

Responsibilities:

As a team member, I was responsible for below phases of project:

* Business requirement gathering, modeling the dynamics of the system for

enhancements

* Analysis, design and code development

* Debug the high priority revenue impacting issues, interact with end users

for resolving the technical and functional issues and also report a bug

or enhancement request

* Provide post production support for the deployed project till it is

stabilized by providing fixes to the issues identified in testing phase

Project / Client Name / Location - SMS1R / CISCO Systems Inc / Pune India

Duration: Feb 06 to Feb 07

Technologies - Oracle SQL, PL/SQL, Perl, Core Java

Service Management System 1 Redesign (SMS1R) is an application

used to create tokens (prepaid vouchers) and invoices for customer purchase

orders (PO) and register them in contracts. Customer used to place orders

in Order Entry Systems (ERP), Perl scripts used to extract those Pos and

generate tokens for them. Invoices were extracted and shells were created

for the tokens.

Responsibilities:

As a team member, I was actively part of below phases of project:

* Avoid CISCO loss by destroying $2.5 Million worth duplicate tokens

* Monitor process of extraction of the Pos (token generation) and invoices

(shell generation) in our system from Order system (ERP) and Customer

Invoice Systems

* Gathering the customer requirements for new changes in the system as well

as for the enhancements needed to the system and bugs identified in the

system

Project / Client Name / Location - FullfilmentSCE / China Shipping North

America / Pune India

Duration: Jul 04 to Jan 06

Technologies - Oracle DB2, SQL, PL/SQL

FullfilmentSCE is an application used by shipping and Freight

companies around the world to book the ship, hire containers, and track the

voyages. Shipping companies can also run reports for the transactions. This

application is developed in Oracle forms and reports 6i.

Responsibilities:

As a team member, I was actively part of below phases of project:

* Debug and root cause the system issues and provide solutions to them

* Interact with customers for any technical or function issues and report

bug or enhancements in the system

* Requirement gathering, analysis, impact analysis for the new requirements

* Development of code as per the business requirements, unit testing and

system integration testing of the developed code

PERSONAL VITAE

Visa Status : H1B (petition valid till 15-Sep-2016)

Contact this candidate