Project Developer

Akshay Vijay Dalvi

E-mail ID : ************@*****.***,************@*****.***

Mob : +91-996*******

___________________________________________________________________________

PROFESSIONAL PROFILE:-

Total 5.9 Yrs of Experience in IT Industry.

SYNTEL LTD. (Mumbai, India.) Nov 2006 - Till Date

Job Title: Mainframe Developer

. Having 3.5 yrs Experience in Mainframe Developement in BNFS industry

Domain.

. Thorough understanding of the SDLC process entailing requirement

analysis, design,

Development, testing, change request management and maintenance /

enhancement support to the client with strong skills in Mainframe

technologies.

. Ensured smooth business operations by innovating applications within

deadlines.

. Debugging and diagnostic skills in batch/Online processing.

. Ablity to adapt quickly to changing priorities and environment.

Job Title: DB2 DBA for Z/OS

. Having 1 yr Experience in Z/OS DB2 DBA activities along with Mainframe

Developement.

. DB2 Physical/Logical data model review for new system with DDL De-

Normalization.

. Played a key role in analysis and logical design involved in

converting hierarchical IMS Databases into DB2 tables in SIREN/SOFA

IMS to DB2 Conversion Project.

. Worked on DB2 tables containing XML Data.

. Used DB2 queries with EXPLAIN to tune their and other

techniques.

. DB2 Access Path Tuning and apply maintenance, DB2 Trouble Shooting.

. DB2 utility scheduling and disaster Recovery Planning and testing.

. SQL walk through and SQL Tuning.

Omega Info Serve Pvt. (Mumbai, India.) June 2004 - Mar 2006.

Job Title: SQL Server Developer, Software Testing and Maintaining

Documentation

. Having 2.4 yr Experience as SQL Developer.

. Plan,design and implement application database code objects such as

Stored procs and Views.

. Build and maintain SQL scripts, indexes, and complex queries for data

analysis and extraction.

. Work with business stakeholders, application developers, and

production teams and across functional units to identify business

needs and discuss solution options.

. Experience Software Quality Assurance and manual Testing.

. Mentor and coordinator roles in creation and execution of QA and

testing processes, test strategies and plans, bug documentation and

regression, and bug tracking system development. Experience with both

team and individual work. Professional training in software testing

theories, procedures and methodologies.

. Documentation of code changes and application requirements.

. Effective manual defect tracking and reporting to improve

communications and reduce delay.

EDUCATIONAL QUALIFICATION:-

. Master of Science in Information Technology from Mumbai University.

. Bachelor of Science in Information Technology from Mumbai University.

CERTIFICATIONS:-

. IBM DB2 9 Fundamentals (DB2 730 Examination).

TECHNICAL COMPETENCIES:-

Operating system : Z-OS/2, windows-98, 2000, XP.

Languages : COBOL, JCL

RDBMS : DB2.

HDBMS : IMS DB.

Front End Applications : IMS DC, XML Enabled DB2 Stored

Procedures.

FILE MANAGEMENT : GDG, Flat Files, VSAM.

Tools used : DFSORT, File-aid, Job Track, Info

Man,

Change man, Easy-trive, FTP.

DB2 Utilities : CHECK DATA, CHECK INDEX, COPY,

LOAD/UN-LOAD, MERGECOPY, QUIESCE, REBUILD

INDEX, RECOVER, REORG INDEX, REORG

TABLESPACE, REPAIR, RUNSTATS,

BMC, DB2 APTUNE.

SELECTED ACCOMPLISHMENTS:-

. Participated in Logical data modeling and physical data modeling

along with DB2 DBA.

. Administered and executed disaster recovery techniques and

procedures for merchants Daily submissions database ensuring data and

application integrity achieving successful Database recoverability

within 24 hours.

. As part of RBP Project,acquired $16497 cast saving for IMS/DC screen

to XML based

Stored Procs conversion.

. Zero defect release of SIREN/SOFA IMS to DB2 Conversion.

. Achieved STRETCH team award for successful release of Roc Based Pricing,

a critical

Project based on merchants day to day pricing submissions.

PROJECT DETAILS:-

INDUSTRY Credit Card

CLIENT American Express (AMEX),

Phoenix, USA.

DURATION November 2006 to till date

American Express is one of the largest financial services companies

operating in the USA and other parts of the world. The financial services

offered by AMEX fall under the following Business areas:

. Corporate and personal credit cards.

. Traveler's cheques and other travel related services.

. Corporate and retail Banking

. Gift Cards (Stored value cards).

SCOUT: (SE characteristic Online Update Transaction) is an on-line-IMS-

based system which is used to set up merchants and maintain merchant non-

Financial characteristics. SCOUT includes the SE number generator which

generates and tracks usage of new numbers.

PROJECT TITLE : SIREN/SOFA IMS to DB2 Conversion (AMEX)

Role : Programmer.

Team Size : 15

Duration : Jan 2007 - AUG 2007

Company : Syntel

Description :

The SIREN/SOFA project was based on IMS-DB to DB2 database conversion.

Involved in the following activities,

. Defining relationship between segment types and mapping those with DB2

fields.

. Converting IMS/DB database calls to DB2 database in Cobol Programs.

PROJECT TITLE : Roc Based Pricing (AMEX)

Role : Programmer.

Team Size : 12

Duration : SEP 2007 - APR 2008

Company : Syntel

Description :

Need to define nonstandard pricing option for merchant along with standard

pricing ptions.The current standard Pricing plans used to derived by SE

characteristics. The nonstandard plan can be add/remove to/from any

merchant over standard pricing plan.

Involved in the following activities,

. Complete Analysing the critical flow and impact of Pricing plans and

pricing details.

. Online screen access converted from IMS-DC to XML enabled Stored

Procedure screen.

. Regularly interaction with onsite counterparts and clients for more

details and clarifications and suggesting modifications.

. Involved in Quality process of Design Docs, Code Review & extracted

business logic.

. Need to communicate with the multiple teams in System Integration Testing

(SIT) because changes in pricing changes affected many systems.

PROJECT TITLE : Daily Submission Cycle Enhancement (AMEX)

Role : Programmer.

Team Size : 12

Duration : MAY 2008 - NOV 2008

Company : Syntel

Description :

This enhancement project used four DB2 tables. In this project we

fetched/inserted multiple records using Multi-row FETCH & INSERT.

Involved in the following activities,

. Converting as many normal DB2 cursor calls with Multi-row

FETCH/INSETRT.

. Benefit achieved: Right around 100 rows the performance benefit seen

was a 40%

. Handling team members independently

PROJECT TITLE : Demand Management (AMEX)

Role : Programmer.

Team Size : 4

Duration : DEC 2008 - JAN 2009

Company : Syntel

Description :

The Demand management team was designed for deriving cost/time reduction

existing system. This reduction has been achieved by enhancing existing

system from technical as well business perspective without affecting its

business functionality.

Involved in the following activities,

. Modifying existing COBOL programs/JCL's/Sort Cards/Stored Procedures.

. Analyzed High Cost DB2 queries in Cobol Programs and Stored Procedures

and

Optimized query for better performance.

Some of the ways we adopted for DM activities are,

- Involved in day to day database administration tasks like

running REORG,

RUNSTAT, Import/Export, creating and maintaining Image

Copies.

- Implemented and tested incremental backup for Production

environment.

- Monitoring and providing 24x7 supports for the production

database.

- Supported the development team with new releases.

- Re-Scheduled Long running reporting jobs from peak hours to non

peak hours

- Enhancement of Read-only programs to work on databse unloads

files.

- Recommended indexes for queries with high cost and fine tuned of

queries.

- Modified Bind/ Package options.

- Zip and Unzip of GDG datasets versions after particular time

period.

PROJECT TITLE : Next Generation Merchant Site (AMEX)

Role : Programmer (Mainframe Back-End).

Team Size : 5

Duration : Feb 2009 - Till Date

Company : Syntel

Description :

The Next Generation Merchant Site (NGMS) project is American Express

Website enhancement. The front end for this project was developed in JAVA.

Involved in the following activities,

. Participated in Database design(Logical/physical design) with

interaction of DBA

. Part of writing complex decision making queries for DB2 Database in

batch/online programs as well in stored procedures.

. Involved in the Quality process like Design Docs, Code Review, Exhaustive

Integration and overall system testing.

. Prepared Load/Unload jobs for DB2 table having Static Data in

Production.

PROJECT TITLE : SQL Developer and Testing

Role : SQL Server Programmer.

Team Size : 3

Duration : June 2005 - Oct 2006

Company : Omega Info Serve Pvt

Description :

Omega Info Serve Pvt a freelancing company, which serves multiple clients

in various industries Domain. As SQL Server developer, we used to create

SQL Functions, Stored Procedures which will be called by Visual Basic

Programs to fetch values from database. Contribute to application and

website testing efforts. Managed and trained junior developers and interns.

PERSONAL DETAILS :

Date of Birth : 19th October 1983.

Nationality : Indian

Marital status : Single.

Interests : Reading.

Passport Details :

Passport # : G8365300

Date of Issue : 28 April 2008.

Date of Expiry : 27 April 2018.

Place of Issue : Mumbai.

Permanent Address : 7/40, New Police Colony,

S.L.Raheja Road,

Mahim,

Mumbai - 400 016,

Maharashtra,

India.

Declaration:

I do hereby declare that all the information furnished above is true

and correct to the best of my knowledge and belief.

Date : (Signature)

Akshay V. Dalvi.

Contact this candidate