` Name

SATYASHTH ANAND

Employer HCL Technologies Limited

Visa Valid H1B Visa

Educational Qualification:

Degree University Institute/Colle Year of Percentag

ge Passing e

B.Tech.(Electri National National 2006 73.4

cal) Institute Of Institute Of

Technology, Technology,

Nagpur (Deemed Nagpur (Deemed

University) University)

12th C.B.S.E. B.S.F. Sr. Sec. 2001 75.4

School,

Paloura, Jammu

10th C.B.S.E. B.S.F. Sr. Sec. 1999 66.5

School,

Paloura, Jammu

Technical Expertise:

Expertise

Details

Operating Systems Window NT,2000, XP

UNIX

Languages Shell Scripting, Perl

Scripting, Batch Scripting,

VB Scripting,JAVA, C/C++

RDBMS Technologies Sybase ASE 12.5,Sybase ASA

8.0,9.0, 11.0, Sybase

Replication, SQL Server,

MSSQL, Oracle

Previous and Current Employers:

Company

Duration

HCL Technologies Limited 06th JAN 2011 - Till Date

Accenture 06th SEP 2010 - 05th JAN

2011

Headstrong 19th OCT 2009 - 27thAUG 2010

HCL Technologies Limited 19th JUN 2006 - 14th OCT

2009

Profile Summary:

I have 7 years and 11 months of experience in software development

and am currently associated with 'HCL Technologies Ltd. as PL

(Project Lead).

I have worked in client server development environment using

technologies like Sybase12.5 (ASE), Sybase ASA 8.9, 9.0, 11.0,

Sybase Replication, SQL Server, Unix, Shell script, Perl Scripting,

JAVA, TSQL, Stored Procedures, Triggers and Cursor. And part of

performance tuning (creating index, locking and update statistics

etc).

In brief, throughout my career I was mainly involved in various

Database activities not only as Sybase Developer but also as

Production Support (L2,L3) Expert and am currently playing dual

role of Developer & L3-Support professional. Though I have played an

active role as SQL, MSSQL, Oracle [support role] & DB2 developer in

few side projects my primary skillset is Sybase, Unix- Shell script.

I have also single handedly upgraded Pearson S&M Greystoke

Application from Sybase ASA version 8.0 to Sybase ASA version 11.0.

I had developed applications related to Publishing & Media and

Financial domains and have valuable experience in deep analysis,

design and development of database requirements for various

applications. I have been actively involved in the full software

development life cycle process of these applications and interacted

with client at various stages of projects.

Experiencing the IT industry since June 2006, I acquired almost 8

years of IT experience in areas of Database Designing, Data

Handling, software development, Unit testing, Operation Support and

handling the Production Environment.

Professional Profile & List of Projects:

PROFESSIONAL PROFILE

Brief Profile 7 years and 11 months of IT Experience.

Experience in Publishing & Media Domain

(Pearson & EMI).

Experience in Financial Domain (Morgan Stanley

& CITI Bank).

Good technical as well as business

understanding of the Publishing, Media &

Financial domains.

Worked on Sybase ASE12.5, Sybase ASA, Sybase

Replication as a developer & support person.

Worked as Java/J2EE (secondary skill) resource

(SCJP Certified).

Worked on Unix, Shell Scripts, Perl scripts,

BJS scheduler, crontab scheduler, Autosys

scheduler.

Also worked on DB2,Oracle & MSSQL for few

months.

Managed as an onsite coordinator for few PCS

(Pearson) Applications & Pearson Sales &

Marketing applications.

Have successfully delivered Sybase upgrade

project from Sybase ASA 8.0 version to Sybase

ASA 11.0 version.

Total Experience 7 years and 11 months.

Education B. Tech.

Operating Systems Windows, Macintosh, UNIX AIX

Languages Sybase (Development & Support), Shell

Scripting, Unix, Perl Scripting, Crontab

scheduling, BJS Scheduling, Autosys

scheduling, Batch scripting, VB

Scripting,Oracle, MSSSQL.

Tools AQT, Tivoli, ASE - ISQL, DB Artisan, Eclipse,

My Eclipse, PVCS, Aqua Studio, SQL Server

Management Studio

Project Experience Summary

Project Name & Technologies Role Period Team

Description Size

Pearson Sales & Sybase, Unix, Shell Development, 12-04-2012 25

Marketing Scripting. Support &

Database To

Upgardtion Till date

CITI Bank (Prime Sybase, MSSQL, L1/L2 06-01-2011 12

Finance) Oracle, Unix, Shell Support

Scripting. To

09-04-2012

Morgan Stanley Sybase, Unix, Shell L2 Support 20-10-2009 10 (8

(Corporate Scripting. as well as L1 and

Services Developer To 2 L2)

Application) 27-08-2010

EMI - MIS Developer DB2 UDB, Offshore 01-04-2009 10

Application Unix AIX, Shell (Application

(Data Scripting along owner) To

warehousing) with few Sybase 14-10-2009

activities.

Pearson - PCS Sybase, Shell Offshore 01-03-2009 3

CES Application scripting (UNIX) Support

along with DB2 UDB (Application To

programming level Owner) 31-03-2009

activities.

Pearson - PCS Sybase, Shell Onsite 01-06-2008 3

CES Application scripting (UNIX) Coordinator

along with DB2 UDB (Application To

programming level Owner) 28-02-2009

activities.

Pearson - PCS Sybase, Shell Developer 01-01-2008 20

PPS-ELT scripting (UNIX),

Java, J2EE along To

with DB2 UDB 31-05-2008

programming level

activities.

Pearson - PCS Sybase, Shell Developer 01-08-2007 15

PPS-Canada scripting (UNIX),

Java, J2EE To

31-12-2007

Pearson - PCS Sybase, Shell Offshore 01-07-2006 3

IMS Application scripting (UNIX). Support

(Application To

Owner) 31-07-2007

PROJECT DETAILS:-

Client Name: Pearson Education

Project Name: Sales & Marketing

Operating UNIX (Sun Solaris), Windows 2008

Software

Languages Shell Scripting, Batch Scripting, Perl, VB

Scripting.

Databases Sybase ASE 12.5, Sybase ASA 8.0, 9.0, 11.0, Sybase

Replication, MSSQL

Tools Used Aqua Data Studio, SQL server Management Studio,

putty, BJS, crontab

Role Developer & L3 Support.

Team Size 15

Project Description:

The Sales & Marketing application is basically the marketing application

Pearson uses to promote new publications along with existing ones. This

applications is primarily used for Pearson field representatives whose main

job is to get in touch with various College professors and convince them to

use Pearson books. This application is designed in such a manner that using

it Sales Representative can easily highlight strengths of any Pearson book

which could make it easier for Sales Representative to convince respective

professors.

My role in the project was to lead various development projects and to

deliver them in time meeting all the client requirements. I as a Database

expert use to finalize the project design and thereafter guide the team to

implement the same successfully. Along with this I have also upgraded

Sybase version from Sybase ASA 8.0 to Sybase ASA 11.0 for one of the Sales

& Marketing applications recently which was also delivered successfully

with no production issues. I am currently also playing the role of L3

support professional at client side in addition to understanding new

requirements from client and coordinating the same with offshore team for

successful project delivery.

Roles & Responsibilities:

. Providing efficient solution in case of an issue.

. Resolving issue in time.

. Maintenance tasks.

. Enhancements.

. Taking care of server and managing it in most efficient manner.

. Taking care of all the jobs being run on the server thereby ensuring

correctness of data feeds

being run.

. Leading and guiding team in delivering projects successfully.

. I am responsible for various Team management tasks

. I am part of the Leadership Team whose main job is to formulate future

plans for the team based upon client discussions and project

visibility.

. Performed code optimization and performance improvements by working on

query plans, indexes, locking, locking schemes and query optimization.

. Implemented new requirements by creating or modifying stored

procedures, triggers, indexes, views, functions, replication

definitions, shell scripts and perl scripts

. Upgraded Application Database from Sybase ASA 8.0 to Sybase ASA 11.0

. Handled day to day replication issues faced in production environment.

. Work closely with business to understand new requirements and then

prepare design to implement the same into existing application system.

. Transfer knowledge and mentor other junior resources in the team.

. Track project completely and closely till the completion and ensure

smooth and successful project delivery.

. Worked on Shell scripts, Perl scripts, Batch scripts, VB Scripts in

order to implement new functionalities.

. Worked on crontab and BJS job scheduler to support the daily

application job run.

. Worked on SQL server and implemented new requirements by creating or

modifying stored procedures, triggers, indexes, views and functions.

Client Name: Citi Bank

Project Name: Prime Brokerage, Prime Finance.

Operating UNIX (Sun Solaris)

Software

Languages Dotnet

Databases Sybase, Oracle, MSSQL

Tools Used Aqua Data Studio, SQL server Management Studio,

putty.

Role L1/L2 Support.

Team Size 12

Project Description:

The Prime Brokerage and Prime Finance applications which mainly contains

the Trade data including

Securities, Brokerage, Equities, Mutual Funds details etc. We mainly deal

with the Feed/Batch processing

part of the application and ensured that everything is correct and in place

as processing completes. Also,

these applications are very critical from business point of view and any

variations/delay may cause high

business impact in dollars. It basically deals in CUSIPS and various trade

details associated with it.

Roles & Responsibilities:

. Providing efficient solution to the issue.

. Resolving issue in time.

. Maintenance tasks.

. Enhancements.

. Taking care of server and managing it in most efficient manner.

. Taking care of all the jobs being run on the server thereby ensuring

correctness of data feeds

. being run.

. Worked as a L2/L3 support professional for prime finance application.

. Performed code optimization and performance improvements by working on

query plans, indexes, locking, locking schemes and query optimization.

. Worked on Sybase & SQL server and implemented new requirements by

creating or modifying stored procedures, triggers, indexes, views and

functions.

. Worked on Autosys scheduler to ensure smooth and successful

application job processing.

. As part of a support professional analyze the impact of delay in

processing of any job and then inform the downstream and upstream

systems accordingly so that any critical outages/downtime must be

managed properly well in advance.

. Worked extensively on Unix, Shell Scripting & Perl Scripting as part

of support and enhancement activities.

Client Name: Morgan Stanley

Project Name: Corporate Services.

Operating UNIX (Sun Solaris)

Software

Languages Dotnet

Databases Sybase, Oracle, MSSQL

Tools Used Aqua Data Studio, SQL server Management Studio,

putty.

Role L1/L2 Support.

Team Size 12

Project Description:-

I am part of the Prime Finance Application (PFS and FIPB mainly) which

mainly deal with the Middle Office part of the financing domain. These

applications mainly deal into Swaps, Instruments, Securities, Trading. We

mainly used to manage the End Of Day processing of the business for the

above mentioned applications and thus our responsibility was to ensure

everything is correctly processed and in place when business returns back

to work next morning. Thus our role was very critical from business

perspective. We mainly used to handle technical issues with little exposure

to the functional area.

Responsibilities:

. Providing efficient solution to the issue.

. Resolving issue in time.

. Maintenance tasks.

. Taking care of server and managing it in most efficient manner.

. Taking care of all the jobs being run on the server thereby ensuring

correctness of data feeds being run.

. Ensuring business continuity

. Worked as a L2/L3 support professional for prime finance application.

. Performed code optimization and performance improvements by working on

query plans, indexes, locking, locking schemes and query optimization.

. Worked on Sybase & SQL server and implemented new requirements by

creating or modifying stored procedures, triggers, indexes, views and

functions.

. Worked on Autosys scheduler to ensure smooth and successful

application job processing.

. As part of a support professional analyze the impact of delay in

processing of any job and then inform the downstream and upstream

systems accordingly so that any critical outages/downtime must be

managed properly well in advance.

. Worked extensively on Unix, Shell Scripting & Perl Scripting as part

of support and enhancement activities.

Client Name: Morgan Stanley

Project Name: Corporate Services.

Operating UNIX (Sun Solaris)

Software

Languages Dotnet

Databases Sybase

Tools Used DB Artisan, SYTS, Autosys, Ab-Initio.

Role L2 Support.

Team Size 10

Project Description:

The Corporate Services division constitutes of various applications

within it out of which we support Regulus, Merlin, Client Money

(Segoob & Chrysalis). 99% of the application processing is carried

out with the help of feeds and this there's a record of all the

daily and historical transactions. Then the finally calcuted data

is sent to the regulatory bodies for approval with help of this.

Responsibilities:

Business understanding.

Providing efficient solution to the issue.

Resolving issue in time.

Maintenance tasks.

Enhancements.

Taking care of server and managing it in most efficient manner.

Taking care of all the jobs being run on the server thereby

ensuring correctness of data feeds being run.

Worked extensively on Unix, Shell Scripting & Perl Scripting as

part of support and enhancement activities.

Worked on Sybase and implemented new requirements by creating or

modifying stored procedures, triggers, indexes, views and

functions.

Client Name: EMI Music

Project Name: MIS Support and Maintenance.

Operating UNIX AIX

Software

Languages Cognos

Databases DB2 UDB

Tools Used AQT, Tivoli.

Role DBA

Team Size 10

Project Description:

MIS is a Data warehousing application which takes care of all the

Sales data of EMI and helps in keeping historical data safe. The

application is mainly used for reporting purpose whose front end is

designed using Cognos technology and backend is completely managed

by IBM-DB2. I play the DB2 UDB developer & DBA role in the team and

have been taking care of this responsibility from past few months.

This is very critical position as there is no other DB2 resource in

the team and thus everything has to be managed independently. Also,

I was involved in few Sybase and SQL Server Database activities

which helped me in being part of all the database activities being

carried out in the team.

Responsibilities:

Business understanding.

Providing efficient solution to the issue.

Resolving issue in time.

Maintenance tasks.

Enhancements.

Taking care of server and managing it in most efficient manner.

Taking care of all the jobs being run on the server thereby

ensuring correctness of data feeds being run.

Worked extensively on Unix, Shell Scripting & Perl Scripting as

part of support and enhancement activities.

Worked on DB2 and implemented new requirements by creating or

modifying stored procedures, triggers, indexes, views and

functions.

Client Name: Pearson

Project Name: CES Application Support and Maintenance.

Operating Windows, Unix.

Software

Languages C++

Databases Sybase

Tools Used DB Artisan, ASE Isql, Presenter.

Role Onsite Coordinator

Team Size 3

Project Description:

CES is basically Cost Estimation System (CES) which supports the

needs of manufacturing functions within PEARSON. Along with this it

performs the low cost vendor analysis by specifying the required

quantity using GSR scales, calculates accurate paper requirements,

refines existing pricing mechanism and enable pricing for the

various other components available in CES, provides easy Paper

selection process - present available paper choices for a given

vendor and its associated prices to the buyers, provides visibility

of back-order title status to buyers, defines printing movement to

another vendor for print movements, defines spec templates to be

used for copying specifications to other title printings. This

application is the most critical application of PCS Team (Pearson

Client) as it interacts with all other applications (PCS) and

systems (SAP & UOPS). As this is associated with Cost and Orders

thus it was the most critical application and required all the

issues to be resolved on priority basis at earliest.

Responsibilities:

Onsite Coordination.

Business understanding.

Providing efficient solution to the issue.

Resolving issue in time.

Maintenance tasks.

Enhancements.

Worked extensively on Unix, Shell Scripting & Perl Scripting as

part of support and enhancement activities.

Worked on Sybase and implemented new requirements by creating or

modifying stored procedures, triggers, indexes, views and

functions.

Client Name: Pearson

Project Name: PPS - ELT

Operating Windows, Unix.

Software

Languages C++

Databases Sybase

Tools Used DB Artisan, ASE Isql, Presenter.

Role Sybase and Java Developer.

Team Size 15

Project Description:

PPS is the Publishing Planning System which is the most important

application of PCS as the Product (Book) life cycle starts from

this application. Through this the various analysis are done on the

basis of which final decisions of printing a book are taken. The

PPS was an existing application for US client only but in PPS-ELT

we customized the existing PPS Application considering ELT (English

Language User's) requirements. We also provided added features of

having access to various financial reports through Web by

integrating Present and Java which was highly appreciated and liked

by client. Also we managed running the Java servers in cluster mode

for this application so that performance of the application is not

affected during heavy load periods. I was responsible for all the

backend (Sybase) coding involved in reports so that reports are

accurate and precise. As on the basis of data through the reports

generated the product finalization is done so it formed the very

critical part in the project.

Responsibilities:

Development - Coding.

Unit Testing - Test cases preparation and execution

Configuration Management

Coordination with Onsite Team - Ensuring On-Time and Bug Free

delivery.

UAT - Production Support

Worked extensively on Unix, Shell Scripting & Perl Scripting as

part of support and enhancement activities.

Worked on Sybase and implemented new requirements by creating or

modifying stored procedures, triggers, indexes, views and

functions.

Client Name: Pearson

Project Name: PPS - Canada

Operating Windows Unix.

Software

Languages C++

Databases Sybase

Tools Used DB Artisan, ASE Isql, Presenter.

Role Sybase and Java Developer.

Team Size 15

Project Description:

PPS is the Publishing Planning System which is the most important

application of PCS as the Product (Book) life cycle starts from

this application. Through this the various analysis are done on the

basis of which final decisions of printing a book are taken. The

PPS was an existing application for US client only but in

PPS-Canada we customized the existing PPS Application considering

Canadian user requirements. We also provided added features of

having access to various financial reports through Web by

integrating Present and Java which was highly appreciated and liked

by client. Also we managed running the Java servers in cluster mode

for this application so that performance of the application is not

affected during heavy load periods. I was responsible for all the

backend (Sybase) coding involved in reports so that reports are

accurate and precise. As on the basis of data through the reports

generated the product finalization is done so it formed the very

critical part in the project. I single handed ly managed the full

back and front end of the titles.

Responsibilities:

Development - Coding.

Unit Testing - Test cases preparation and execution

Configuration Management

Coordination with Onsite Team - Ensuring On-Time and Bug Free

delivery.

UAT - Production Support

Worked extensively on Unix, Shell Scripting & Perl Scripting as

part of support and enhancement activities.

Worked on Sybase and implemented new requirements by creating or

modifying stored procedures, triggers, indexes, views and

functions.

Client Name: Pearson

Project Name: IMS Application Support and Maintenance.

Operating Windows Unix.

Software

Languages C++

Databases Sybase

Tools Used DB Artisan, ASE Isql, Presenter.

Role Developer

Team Size 2

Project Description:

IMS is the Inventory Management System with the help of which the

Pearson manages the inventory for various titles in time at

different warehouse locations in US which results in proper and in

time delivery of the product. This application specifically deals

in titles which are part of Higher Ed. Curriculum. Also there's a

yearly forecast process for all the forecasted titles which

determines the whole year forecast details following which Pearson

manages Inventory and selling of books in time.

Responsibilities:

Business understanding.

Providing efficient solution to the issue.

Resolving issue in time.

Maintenance tasks.

Enhancements.

Worked extensively on Unix, Shell Scripting & Perl Scripting as

part of support and enhancement activities.

Worked on Sybase and implemented new requirements by creating or

modifying stored procedures, triggers, indexes, views and

functions.

Personal Information:

First Name: Last Name: Middle Name: Residence Work Phone:

Phone:

Satyashth Anand 019*-******* 201-***-****

Permanent Address: Email:

Satyashth Anand aced3o@r.postjobfree.com

H.No:-45/3, Trikuta Nagar,

Jammu - 180012, J&K, India.

Present Address: Passport No: F4856930

Satyashth Anand VISA TYPE- H1B

Apt# 123, Issued At: NAGPUR

370 Park Street, Visa Valid Till: 06/14/2016

Hackensack, NJ - 07601,

USA.

Date of Birth: 24-02-1983 Marital Status: Married

Contact this candidate