Project Sql Server

Nilesh Janardan Sonawale

Mob No. +1-480-***-****. Email - ***.********@*****.***

Functional & Technical skill sets with Tools: -

Expertise in MAINFRAME technology like COBOL, JCL, DB2, VSAM, REXX, DYL

Expertise in Database like DB2, SQL SERVER 2008 & Oracle and also have knowledge about MQ & tools like Platinum and QMF.

Tools & Utilities: File-Aid, Spufi, BMC utility, Control-M, Jobtrac, ChangeMan, QMF(Query Management facility for SQL), Microsoft SharePoint and Visio, MVS OS/390

Methodology - Experience of project implementation in AGILE as well as WATERFALL Methodology.

Experience in Project management and Release planning

Working Experience:

Overall 122 month of Total Experience in the IT Industry

Current Employer – SYNTEL INC - 94 months of Experience in Banking Financial Services and Retail domain. (28-July-2010 to Till date)

Previous Employer - Worked with MAIA-Intelligence Pvt Ltd. from about 28 Months (01-Apr-2008 to 20-July-2010)

Educational Qualification:

Bachelor in Computer Science & Engineering from Shivaji University Kolhapur, INDIA with First Class (64%) in MAY-2007

IBM DB2 730 Certification in 2011

Project 1:

Customer/Client Name - American Express (Banking & Financial Services)

Employer – SYNTEL INC

Project Name - Acquisition Toolbox System (ATS)

Role - Mainframe Lead Analyst

Duration: March 2014 – till date

Project details –

Acquisition Toolbox System (ATS) allows marketing managers the flexibility and ease in defining the various campaign codes that are used by marketing and downstream systems supporting acquisition campaigns, It takes care of campaign management right from setting an offer for a product till receiving the information from the card acquisition team and capturing the acquisitions for each offer marketed. Markets supported by ATS are U.S and other 20 International countries

Technologies/Tool Used –

COBOL, JCL, DB2, VSAM, REXX, DYL, ChangeMan, File-Aid, Spufi, BMC utility, Control-M, Jobtrac, QMF

Responsibilities

Enhancing multiple COBOL-DB2 programs to fulfill business requirements.

Debug & fix multiple stored procs/Batch programs as per bug fix request from prod support team & testers.

Prepare intensive and extensive DB2 SQL queries using multiple joins and various statements in DB2

Work on cross-functional teams to proactively address all issues

Ensure the proper review and testing for the project.

Responsible for Tech point of contact during all the phases of the SDLC life cycle.

Coordination with several interfacing team managing end to end delivery of Projects.

Have worked with the testing team to ensure the built code is tested end to end with no defects after install (No PIV defects).

Experienced in mitigating the risk by taking appropriate measures as required.

Project 2:

Customer/Client Name – BELK Inc (Retail Domain)

Employer – SYNTEL INC

Project Name - Belk Store application Enhancement

Duration: July 2010 - March 2014

Role - Mainframe Lead Analyst

Project details & Responsibilities –

BELK enhancement team in STORES business area, which mainly included following

Strong analysis and understanding on retail point of sale system such as sales, returns, exchanges, gift cards, promotions, discounts, pre-planned promotional sales, manufacturer coupon validation and multiple payment types. Inventory control.

Technologies/Tool Used –

COBOL, JCL, DB2, VSAM, REXX, DYL, ChangeMan, File-Aid, Spufi, BMC utility, Control-M, Jobtrac, QMF

Responsibilities.

Developed COBOL, JCL and CICS modules that were required to incorporate the additional functionality in the application

Designed and developed complex COBOL, JCL, DB2 Utilities for a major tax module that demanded handling files from multiple interfaces and systems.

Prepared test cases for unit testing and testing the changes done as part of development/enhancement.

Successful implementation of enhancements with zero defects.

Ensure the proper review and testing for the enhancement.

As a senior resource provided right direction and solution in time to meet the goals.

Project 3:

Customer/Client Name – IndiaInfoline & Bonanza

Employer – Maia-Intelligence Pvt Ltd

Duration: 6 Months

Responsibility:

Segments like COMMODITY, EQUITY, CURRENCY, IPO, MF, PMS Which are maintained in various databases. A data ware house is created for the purpose of consolidated database and consolidated reports.

Created various MIS reports.

Database: SQL SERVER 2005, DB2

Project 4:

Customer/Client Name – IRB Infrastructure & Glenmark Pharmaceuticals

Employer – Maia-Intelligence Pvt Ltd

Duration: 6 Months

Responsibility:

Financial Consolidated Module (FCM) deals with the financial status of a company, Trail Balance (TB) of a company Imported into a SQL server and created the Schedule-IV and IFRS Reports with consolidation. Now they can analyze their financial result with comparison with any previous period status.

Database: SQL SERVER 2005

Language: C# .Net (Working knowledge)

Visa Details – (Current Location – PHOENIX AZ)

Visa Type

Visa No

US Entry Date

Visa Expiry Date

H1B

H7969962

03/03/2014

12/04/2015

H1B Extension

12/21/2018

Contact this candidate