Project Sql Server

Bhasheer JANI Mahamed

Tel #: 510-***-**** . E-mail: ********@*****.***

Professional Experience Summary:

> 11+ years of professional Information Technology experience involving

full software development life cycle including: Requirements

gathering, Analysis, Design, Development, Implementation of

application software, maintenance and production support for

manufacturing, Tele communications and Banking/ financial systems.

> 11 years of experience in developing application software on the IBM

Mainframes in Z/OS or MVS/OS390 using VS COBOL II, DB2, IMS, SQL,

CICS, JCL, VSAM, Cool:Gen/Advantage Gen 6.5, IEF.

> Extensive development experience in VS COBOL II, DB2, IMS, CICS,

Cool:Gen, and IEF. Worked on Both Online and Batch systems.

> Having good experience on the tools like QMF, SPUFI, IBM utilities

(IDCAMS, IEBGENER, SORT, etc), ICETOOL, FILE-AID, Intertest,

Changeman, VIASOFT, STROBE, NDM, IEF, Cool: Gen and XPEDITOR among

others.

> Having good exposure on developed applications using Java, J2EE, Web

Sphere, EAI, Cross-worlds, SQL Server, ASP, VB Scripts and Oracle.

> Dedicated international team player with strong verbal and written

communication and leadership skills managing multiple onshore offsite

projects.

> Having good knowledge in PL/I, Adabas, NOMAD, VM O/S and MQ Series.

> Having rich knowledge in Data warehousing tools like Informatica,

Cognos, and Business Objects.

> Possess excellent communication skills, is self-starter and is self-

motivated, is active in team-participation.

> Having good experience as an application team lead and is able to

mentor the junior developers

> Having rich knowledge on Visual Basic, .Net, ASP, SQLServer

> Worked as a Team Lead and Project coordinator for 8 Years at onsite

(USA).

> Performance tuning in Mainframes environment (with respect to DB2

tables and complex queries).

> Played a major role in the feasibility study, gathering requirement

specifications, forming functional specifications, accordingly

designing of the application, further analysis, implementation,

testing, and documentation of all the above Software Engineering

processes.

> Having good documentation skills

> Have good experience in solving critical production problems and in

taking critical business decisions

> Trained in Project Management (PMP)

> Very good in interacting with Business Users, Functional and Technical

Team to meet the Project timelines.

> Consistently recognized for achieving and exceeding company's goals

and objectives for CMM Level 5 Organizations.

Education:

. Bachelor of Engineering (B.E.) in Electronics & Communications

Engineering (ECE)

Technical Skills:

Skills Profile: Requirement Study, New Development, Supporting existing

applications, and testing new/existing systems

Languages: COBOL II, EASYTRIEVE, REXX, JCL, SQL, NOMAD, ASP

Case Tools: AdvantageGen, COOL:Gen, CE-ACCESS

Translation Processor: IMS DC, CICS

Access Methods: VSAM

Operating System: Windows XP, 95/98/NT, S/390, Z/OS, MVS/ESA, VM

& UNIX

Database: DB2, IMS/DB, NOMAD, SQL Server

Tools: TSO/ISPF, QMF, CA-7, FILEAID, SYNCSORT, ENDEVOR, CHANGEMAN,

IDCAMS, SPUFI, DB2 connect, SDF, FTP, FILEAID-DB2 &

IMS, SuperC compare, MS Office, Expediter, NDM, Test

Director,Abend-Aid, MVS, RUMBA,EXTRA PC, Application

Access Secure, Personal Communications, HTML, DB2

stored procedures, PANVALET, PLATINUM, STROBE,

ICETOOL

Professional Accomplishments:

. Implemented the changes in the General Ledger applications to include

Merrill Lynch (ML), Country Wide (CFC), LaSalle acquisitions and provided

the permanent fixes, automated the processes, reduced the number of

abends and made the system very stable at Bank of America.

. Implemented Rebates application for Europe's largest bank ABN AMRO within

budget and short period of time.

. Successfully analyzed the 'Service Bridge Delta ' application (existing

interface application between eOM and GIB), proposed a new design,

programmed, tested, implemented and finally reduced the run time from 12

hours to 2.5 hours for GE Healthcare.

. Successfully Implemented ESPP (Employee Stock Purchase Plan) in Payroll

application for the US West employees after the Qwest acquisition.

Professional Experience:

Tata Consultancy services ltd. - 06/1998 to 01/2010

Client : Bank of America, Charlotte, USA

12/2006 to Present

Senior Programmer Analyst

Working as a Senior Programmer Analyst for Bank of America, is one of

the largest banks in the world.

Provide the support and maintain the General Ledger group of

applications (FCS-EAST & FCS-West) FCS East General Ledger application,

which process the flow of transactions from all surrounding

applications into the Banks General Ledger (Book of Records) which are

VSAM files. Also FCS acts as a source of information for valid company,

account and cost center details for applications out side of FCS.

Consequently the GL application should be controlled from bad data, any

batch delays and uninterrupted services. Some of the surrounding

systems to FCS are FCS online application ASC (Automated Suspense

Clearing) and NVS (National Validation System) which are CICS and DB2

based systems. ASC allows the user to clear the transactions that have

been charged to the designated Suspense Account/Cost center

combinations.

TAXBANDO (WBO) CCD & FXRSYS are called as FCS West General Ledger

applications

TAXBANDO - This application deals with the calculation of the Business

and Occupational Tax to be paid by the business operating out of the

State of Washington. Also produces the reports which are extremely

important since they provide the Gross income information needed for

compliance. Also deals with the deductions in the tax process which

lowers the tax expense incurred.

Corporate Control Database - is repository of the units/Cost centers,

Companies for the BOA west cost applications.

FXRSYS - This application is source for foreign exchange rates across

the bank branches. It gets the feed from Reuters and processes the

rates and stores in the NOMAD database (on VM Operating system) and

will be used by different downstream applications.

The purpose of intranet General Ledger (iGL) application is to provide

a web-based interface for end users to perform data entry, posted

transactions inquiry, General Ledger master information inquiry

(balances at company, account and cost center combination level), chart

of account inquiry, teller information inquiry, open and matched

reconciliation items inquiry, application inquiry etc.

Responsibilities:

. End-to-end responsibility and accountability of all the projects

(Finance Control System (FCS), Automated Suspense Control (ASC),

National Validation System (NVS), Corporate Control Database (CCD),

Foreign Exchange Rate System (FXRSYS) and intranet General Ledger

(iGL)). Manage Teams, monitor/track & communicate the project

status to all stakeholders.

. Monitor the Batch cycles (COBOL, DB2, VSAM, JCL etc.) /Online

screens (CICS, DB2, and DB2 stored procedures) and provide 24 * 7

Production support for GL group of applications on rotation basis.

. Route cause analysis of Problem Logs created thru Peregrine

tool/emails from the users.

. Prioritizing of Production abends/user requests and solving

requests by fixing the code and analyzing the job flow on CA7.

. End-to-end ownership for the support tickets and resolve the

production issues within SLA

. Prepare/Review the impact analysis of design documents of small

enhancements for all modules (General Ledger applications)

. Acting as a Subject Matter Expert (SME) for all General Ledger

applications.

. Develop test plans, perform unit, integration testing and user

Acceptance Testing and ensure all Quality guidelines are followed

by all the team members

. Helps the teams in estimations for the small enhancements

. Understand technical architecture and rationalize applications/

approach for simplifications

. Generate Adhoc reports using QMF/SPUFI (SQL) requested by the

users. Update the DB2 database using SPUFI/DB2 utilities to fix the

production abends/as per the user requests.

. Participation in Disaster Recovery exercises

. Responsible to accept KT from the initiative team

. Management of all implementations of Monthly Deployments and code

releases

. Responsible to maintain the Data integrity in all GL group of

applications

. Accept additional requirements after review meetings with change

control board

. Application level Status reporting to the all Application Managers

. Management of Offshore and onsite Support and Development teams and

activities

Environment:

COBOL II, DB2, CICS, VSAM, JCL, CA7, Changeman, QMF, SPUFI, FILEAID-

DB2, DB2 Stored Procedures, FILEAID, PL/I, SYNCSORT, ISPF,TSO,Z/OS

1.9, SDF, Application Access Secure, Quality Center, HTML, SQL,

PLATINUM, Z/VM, NOMAD, ASP, SQL Server, Eztrieve, VB Scripts, Java

Scripts

Client : ABN AMRO Bank, Mumbai, India

06/2006 to 11/2006

Sr. Mainframe Technical Lead

Involved in development of a new application, "Rebates" for ABN AMRO

Bank using COBOL, JCL, IEF, CoolGen and DB2 in short period of time and

implemented successfully.

Investments domain holds all the data and functionalities of fund

companies, Instrument codes and fee agreements between ABN AMRO BANK and

fund companies. Goal of the sub project REBATES is to automate the

calculation of management fees with position data delivered by SOB. On

the basis of these calculations, the fund companies are invoiced and the

fee received is distributed to the various fee-entitled parties within

the ABN AMRO BANK.

Responsibilities:

. Technical lead for the Development and implementation of the

REBATES project in the investments domain

. Collect all the requirements and do feasibility study

. Preparation of Software requirements document(SRS)

. Participated in Analysis, Design, Development and Implementation.

. Preparing estimations for the new enhancements

. Running the system test cycles

. Coordinated with Data Architect about the data modeling using ERWIN

tool

. Coordinated with DBA about implementation of database changes

. Coordinated with users during UAT testing

. Developed many Batch jobs and online screens IEF, Advantage Gen,

DB2 etc. to meet the Business Requirements

. Project Testing management with emphasis on system Integration and

User Acceptance testing phase.

Environment:

COBOL II, DB2, VSAM, ISPF, JCL, QMF, SPUFI, FILEAID-DB2,ABEND-AID,

TSO, SDF, FTP, EXTRA PC, TEST Director, EXPEDITOR, IEF, Advantage Gen

6.5

Client : GE Healthcare, Hyderabad, India

09/2005 to 05/2006

Sr. Mainframe Technical Lead

Performed a role of Technical analyst and successfully implemented the

Service Bridge delta project which is an interface between eOM (e Order

Management Oracle application) and Legacy Billing applications using

COBOL, DB2, MVS, JCL, IEF, Cool:Gen etc. Adapted a waterfall model life

cycle to analyze, design, code, test, and finally implemented. So that

achieved 80 % performance (Reduced the run time from 12 hours to 2.5

hours) improvement of loading equipment order information from Oracle to

the service legacy systems.

Responsibilities:

. Analyze scope of enhancement of the project.

. Developed low level design for the Service Bridge Delta Project and

coding standards

. Created unit test plan based on the requirements from Customer

. Coordinated with the team for the entire development and coded the

modules assigned using version control

. Created test data, conducted unit testing and created test results

. Conducted peer reviews and fixed bugs using bug tracking tool

. Held regular team status meetings to discuss about issues and

queries and resolved the same effectively

. Conducted system testing using the trace ability matrix and

maintained defect logs and code baseline to secure the code in case

the new changes cause potential failure

. Performed extensive risk assessment prior to production

implementations and carried out validations for post implementation

to ensure successful execution monitoring performance

Environment:

VS-COBOL II, DB2, Cool:Gen, IEF, VSAM, TSO/ISPF, File-AID, XPEDITOR,

VIASOFT, JCL, UNIX, SQL, IMS-DB, IMS-DC, PANVALET, SPUFI, QMF, NDM,

SQL Server, INTERTEST, ABEND-AID, OMEGAMON, CLARIFY, STROBE

Client : GE Healthcare, Milwaukee, USA

06/2002 to 08/2005

Sr. Mainframe Technical Lead

Managed, coordinated and supported the legacy service applications for GE

Healthcare. Lead the Global Install Base (GIB) team to provide the 24/7

support all legacy applications in Service. Lead the offshore team for

enhancements and support activities using COBOL, DB2, MVS, JCL, IEF,

Cool:Gen etc. Used iterative model for all enhancements and defect

mitigation activities

Worked with the Java, EAI, Oracle and Business Intelligence teams on

various releases for Electronic Global Install Base (eGIB),e Order

Management Oracle application and Filed Maintenance Instruction (FMI)

applications.

Responsibilities:

. Responsible to gather customer requirements for all enhancements

and release projects and create requirements and functional test

cases

. Developed many custom Batch programs using COBOL, DB2, DB2 Stored

procedures, JCL, IEF, Cool:Gen, etc. to meet the Business

Requirements

. Created test plans and executed UTP (Unit Test Plan).

. Given Permanent fixes to many Online Screens and batch jobs for GIB

Modules using IEF, Coolgen

. Provided 24 * 7 Production Support and responsible for all GEHC IT

service related issues and resolutions as per defined SLA standards

. Document all the changes made and attended team meetings for risk

management and contingency planning

. Expert level backup of the production support team and responsible

for horizontal and vertical escalation as and when required

. Responsible for delivering the quarterly estimated enhancements and

changes based on availability of resources, fund and business

priority

. Coordinated day to day work packets with the offshore development

team

. Responsible to estimate tasks, efforts and resources for legacy

service projects

. Demonstrated six sigma to the GEHC master black belt panel,

successfully lead and completed a six sigma project and cleared the

six sigma green belt certification in GEHC

. Coordinated with BI team to provide necessary data on a periodic

basis for their financial reports

. Responsible for creating, maintaining and deleting project

repositories using version control

. Represented Legacy service applications in change control meeting

for any production release

. Conducted periodic team appraisal and technical interviews when

needed

. Identified various opportunities for improvement in the systems and

incorporated

. Reviewed existing documents and remodeled the design flow and

support documents

. Retired unused batch and online processes and reduced maintenance

and support cost

. Unified various technical streams to reduce duplicate effort of

enhancement and support

Environment:

COBOL, DB2, SQL, IMS-DB, IEF, Visio, Cool:Gen, TSO/ISPF, Intertest,

JCL, PANVALET, CA-7, EAI, XML, Crossworlds, File-Aid, Data

warehousing tools Informatica, Business Objects, Cognos

Client : Qwest Communications, Chennai, India

05/2001 to 05/2002

Mainframe Programmer/Analyst

Qwest Communications International Inc is a large telecommunications

carrier. This is providing local voice, long distance voice, and data

and Internet (DSL) and many other services to around 25 million

customers in 14 states of America

CRIS (Central - Customer Record Information System) Maintenance project

is a subsystem of CBS of Qwest Inc., based at USA. Qwest is a Telephone

company and provides Telephone services for 14 states in the USA. These

14 states are divided into three regions namely Eastern, Central and

the Western Region. Each region maintains its own billing system.

CRIS is divided into four main modules, Service Order, Usage, Billing

and Cash & Treatment.

CBTM (Cash Billing Treatment Maintenance) module is the main module of

Central CRIS. The scope of this project was to generate the bills of

the customers and to keep track of the payments made by them. It takes

appropriate action against the defaulted customer, like sending notices

to the customers and generating disconnecting orders for the persistent

defaulters.

Cash and Treatment handles all activities involving payment collection

and posting and handling of past due accounts for Central Regions. Cash

and Treatment is also responsible for cash billed to the customer or

paid by the customer and for preparing bills for the customer and

applying adjustments.

Responsibilities:

. Impact Analysis of a change

. Preparing Low Level Designs

. Developing and Unit testing of the change

. Defect Logging

. Involved in status calls with the onsite coordinators on weekly

basis

. Volume testing to cover all the test cases possible for the change

. Monitoring the production jobs on the release day

. Analysis of the production bugs

. Prepared program specifications and diagrams, developing coding

logic flowcharts

Environment:

VS-COBOL II, DB2, Cool:Gen, IEF, VSAM, TSO/ISPF, File-AID, MQ Series,

XPEDITOR, VIASOFT, JCL, UNIX, SQL, IMS-DB, IMS-DC, PANVALET, SPUFI,

QMF, NDM, SQL Server

Client : Qwest Communications, Denver, USA

03/1999 to 04/2001

Mainframe Programmer/Analyst

Responsible for production support of Payroll system and investigate the

Trouble Reports raised by the client and take appropriate corrective

action. This includes analysis; correction of programs, conducting

reviews, delivering corrected programs for production, Communicate with

the clients and formulating recovery methods/ procedures, if necessary.

Responsibilities:

. Modified the existing code to introduce ESPP (Employee Stock

Purchase Plan) to Qwest employees

. Developed new CICS, COBOL, DB2 as part of ESPP project

. Worked with the project team to code, test and implement all

enhancements

. Document all the changes made as per defined SLA and attended team

meetings

. Responsible for 24/7 support of the legacy applications for the

Payroll System as per the SLA defined in the contract for Service

Support

. Worked with other teams to provide necessary data for reporting

. Coordinated with offshore development team for new releases

. Had regular meetings for providing status on daily work packets

. Added value by revising various outdated documents

. Provided permanent fix to age old technical problems

. Initiated knowledge sharing sessions among the team to provide

backup when needed

. Selected as a part of technical analysis team to do feasibility

study

Environment:

VS COBOL II, DB2, CICS, SQL, Adabas, TSO/ISPF, XPEDITOR, JCL,

PANVALET, MQ Series, SQL Server, File-Aid, SPUFI, QMF

Client : Qwest Communications, Chennai, India

06/1998 to 02/1999

Mainframe Programmer/Analyst

Payroll System is Qwest's mechanized vehicle for processing employees'

payment including various benefits, allotments, deductions and savings

plans. The core payment calculation is driven by the time reported by

the employee. This system that comes under the Corporate Financial

System (CFS) of QWEST, reports to the Corporate Systems Department

(CSD).

Responsibilities:

. Prepared program specifications and diagrams, developing coding

logic flowcharts

. Translated business specifications and designs into language coded

programs, packages, and procedures or automated batch scripts

. Involved in the enhancements of online screens using COBOL, CICS,

DB2

. Involved in the preparation of the documentation and user manual of

the application.

Environment:

VS-COBOL II, CICS, DB2, TSO/ISPF, XPEDITOR, JCL, SQL Server

Certifications:

Certified Six Sigma Green Belt, (2 GB projects) 2003 - Trained in Six

Sigma Black Belt

Training in PMP, Informatica, Teradata and Oracle Apps Concepts

Work Eligibility:

o EAD

References:

Will be furnished upon request.

Contact this candidate