Project Sales Representative
Resume:
` 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 **************@*****.***
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