MANOJ

ab9wuh@r.postjobfree.com.

Mob: 91-808*******

SUMMARY:

Overall 9 years experience in IT

•

Having around 6 year’s strong experience working on DB2 LUW (UDB) on production,

•

test and development environments on Aix, Linux and Windows OS.

Worked on Mainframe application development/support for 3 years initially.

•

Have thorough knowledge of RDBMS concepts.

•

Good experience in DB2 UDB 8.x and 9.x Installations, Configurations and

•

Administration.

Expertise in creating Instances, Databases, Bufferpools, Tablespaces & database objects

•

as per business requirement.

Strong understanding of DB2 architecture and Memory Model.

•

Applying Patchs (fixpacks) to existing environment as per business requirement.

•

Checking and Validating of database Backups and recovering the database to PIT by

•

using Backup images and logs.

Worked on Database restores including Redirected restores within production and

•

development environment.

Used RUNSTATS, REORGCHK and REORG to enhance application performance.

•

Good experience on data movement utilities like EXPORT, IMPORT, LOAD and

•

db2move

SQL Tuning using db2advisor and db2explain tools.

•

Database performance tuning by configuring database and DBM Parameters.

•

Configuring the HADR and monitoring the databases.

•

Good experience in 24*7 production environment support.

•

Ability to perfectly plan and execute the high level DB changes to perfection.

•

Ability to troubleshoot day-to-day problems encountered on production as well as

•

development database environments.

Experience in working with the Business Analyst and Business Subject Matter Experts to

•

understand and translate business requirements, develop and agree appropriate solutions

and produce technical design specifications for new/enhanced functionality within the

Application.

Worked closely with client management to identify and specify complex business

•

requirements and processes. Researches and evaluates alternative solutions and makes

recommendation.

EDUCATIONAL QUALIFICATION:

Master of Computer Applications (MCA) from MaduraiKamarajUniversity (2001).

•

Bachelor of Physics from Kerala Unversity (1998).

•

TECHNICAL SKILLS:

HARDWARE IBM P Series, INTEL PC

OPERATING SYSTEMS IBM AIX, Unix, Linux, Solaris, Windows NT

Windows 95/98/2000/XP.

LANGUAGES Cobol, Jcl,Vsam

DATABASES DB2 8.1, DB2 9.x,DB2 10.1

TOOLS & UTILITIES Tivoli Storage Manager, Rational Clear case, BMC Remedy and

Maximo

PROFESSIONAL EXPERIENCE:

UST GLOBAL INC, Trivandrum :2010 –2012(Permanent)

MARLABS INC US :2008 – 2009 (Onsite)

SUPREMETECH SOLUTIONS,US : 2008 – 2008 (Onsite)

TCS, Pune, US : 2005 – 2008 (offshore & Onsite Permanent)

Biocom Systems, Trivandrum : 2002 – 2005(offshore)

.

Client: NAVISTAR, US(2011 – 2012)

Domain: Manufacturing

Project Description:

Navistar International Corporation is the nation's leading manufacturer of International brand

commercial trucks, MaxxForce brand diesel engines, IC Bus School and commercial buses,

Workhorse brand chassis for motor homes and step vans, and are a private label designer and

manufacturer of diesel engines for the pickup truck, van and SUV markets. Navistar International

offers flexible applications for customers for order and customizing the trucks, parts and engines.

The Navistar International offers web applications which are used for trucks and parts pricing,

invoicing and awarding concessions to the customers.

Contribution:

As a Database Administrator, I am responsible for:

• L2/L3 support and administrating the databases on Linux/AIX/Windows.

• Hands on experience in DB2 UDB V8 & V9.x for multi-partition and single partition

databases over production environment.

• Involved in monitoring & executing database activities like Reorgchk, Performing Reorg

and Runstats on tables/indexes, rebind of packages, application hogging CPU, Health

check for database instances

• Have handled SEV-0 issues and driven them to completion with assistance from IBM

Tech support.

• Grant/Revoke database access to the users and applications.

Creation and maintenance of database objects like Tables, indexes. Managing the

•

database movement activities like Export, Import, and Load.

Working with applications to team deploys various builds on PROD/QA env.

•

Disk space monitoring and management of database for space related issues. SAN

•

estimation /Space addition.

Database Query Performance & Parameter change.

•

Automatic Storage Table space management.

•

Database Backup and Recovery Strategy.

•

Cloning of the databases using Restore/Re-direct restores.

•

Performed Cross-node recovery with TSM

•

Responsible for planning, coordinating with client for performing the DR activities.

•

Client: WELLPOINT, California, US(2010 – 2011)

Enterprise Provider Database System is a consolidation & replacement project for several

existing applications that maintain the Providers (doctors & hospitals) information for WellPoint.

The objective is to build a foundation to enable the entry of Provider Data into a central

repository and thus streamlining and standardizing WellPoint business processes. The EPDS

centers on the heart of WellPoint’s business model of creating, tracking, marketing, and

managing flexible, quality provider networks to support all lines of business, products and

services. The intent of the project is not only to support existing business, but also to provide a

flexible, configurable solution to enable future business initiatives and growth.

Primary resource for:

Monitoring, maintaining and troubleshooting production, staging, test and development

•

DB2 UDB databases on AIX and Solaris

Enhancing application performance by running RUNSTATS, REORGCHK and REORG

•

utilities

Analyze DB2 UDB Event Monitor information, performance characteristics of table

•

spaces, physical I/O rates, and table access activities.

Perform Database Backup/Recovery activities.

•

Monitor DB2 UDB processes and logs for any anomalies, provide corrective actions.

•

Provide assistance to the development team for resolving locking solutions and other

•

table access activities.

Monitor DB by analyzing log files, Snapshot monitors, and Event Monitors for

•

production and nonproduction environment

Taking Snapshots and gathering other information related to the database and the system

•

during stress tests or performance tuning.

Monitored and managed disk space, I/O contention

•

Day-to-day attending to the user queries in sorting out database problems

•

Created IBM problem tickets and involved in the root cause analysis

•

Provided production support for critical applications running on 24/7 basis

•

Client: USBANK, MILWAUKEE, WISCONSIN(2008 – 2009)

U.S. Bancorp, with $238 billion in assets, is the parent company of U.S. Bank, the 6th largest

Commercial bank in the United States. The company operates 2,518 banking offices and 4,867

ATMs, and provides a comprehensive line of banking, brokerage, insurance, investment,

mortgage, trust and payment services products to consumers, businesses and institutions

Responsibilities:

Implementing database configurations: Database, Table space, Table, Index and various

•

objects.

Troubleshooting of DB2 related problems.

•

Database backup and recovery policies.

•

Troubleshooting using db2diag, db2stop, db2pd & db2mtrk tools

•

Data loading across different databases using DB2MOVE, EXPORT and LOAD utilities.

•

Performing weekly maintenance activities like REORG/RUNSTATS.

•

Discussions and meetings with other Team members.

•

Client: PNC, COLUMBUS, OH, USA

(2005 – 2008)

Tata Consultancy Services

Business Overview:

National City Card Services ('NCCS') is a division of National City Bank within the Consumer

Finance Division. The Consumer Finance division is also comprised of indirect lending,

education finance, dealer finance, national home equity lending and non-conforming residential

lending. National City Card Services is headquartered in Kalamazoo, Michigan which houses the

operations units such a collections, customer service and fraud. Columbus operation services as

the credit-processing center. NCCS is responsible for all aspects of credit card marketing,

operations and servicing of products throughout the life cycle of accounts. CLS (Consumer Loan

Services) in Brecksville, Ohio services the 'EQUITY' products.

DB2 UDB DBA (2006 – 2008)

Responsibilities

• Monitoring jobs in staging, test and development DB2 UDB databases on AIX and

Windows

Perform Database Backup/Recovery activities.

•

Database User Administration Including User Creation, Object-level Privilege

•

Administration, Security Management

Mainframes (2005 -2006)

Coordinating with Project Manager regarding the development estimates and timelines.

•

Analyze programs and job streams and decide where best to solve a problem or position

•

an enhancement.

Primary responsibility for reviewing and approving all the changes in production.

•

Involved in customizing and developing several interface programs, Reports as per

•

the user and business requirements including acquisitions and integration in the bank

Develop business oriented programs based on specifications provided by a business

•

analyst.

Worked and understand the business within and outside the applications such as Credit

•

Card processing

THRIVENT FINANCIAL FOR LUTHERANS, MINNEAPOLIS

2003 - 2005

Software Engineer

Business Overview:

Thrivent Financial for Lutherans exists to help its members achieve financial security and

give back to their congregations, institutions and the broader community. The organization and

its affiliates offer a broad range of financial products and services including life insurance,

annuities, mutual funds, disability income insurance, bank products and more.

The project is the Life insurance system which provides new business and product

administration functionality for fixed annuities and life products. Life File Maintenance (FM)

receives input from the New Business file, Customer information file (CIF) triggers, and CICS

created transactions. The Life online is pseudo real-time environment. When a transaction is

entered, a "future row" is added to the master database table and a transaction is created for that

night's batch run. During online activity the future rows are accessed to give the appearance that

the certificate has been updated. Prior to batch file maintenance the "future rows" are deleted and

the transactions are applied updating the database during the file maintenance.

Responsibilities:

Primary resource for:

• Maintaining, Enhancing and Supporting different financial Applications (which also

involves Installation of emergency code changes)

• Carrying out various other tasks such as analysis of user requirements,

• Preparation of Analysis Documents, Analysis of the existing functionality and Coding of

changes in the functionality.

Working with production control and CA7 schedulers for the implementation and

•

resolution of issues.

Working with the development team to identify solutions when necessary.

•

Use analytical, JCL, COBOL, and scripting skills to identify and implement enhanced

•

processes to streamline the validation testing and minimize the possibility of introducing

errors into the test executions.

Testing and Resolution of queries put up by team members. Training the new team

•

members.

Environment:

MVS, COBOL II, CICS web services, JCL, VSAM, DB2, Abendaid, Changeman, FileAid,

SQL, SAS, CA7 Schedulers, NDM, Windows NT, Java, XML, Visio, JSP, EJB, Servlets,

SAR, PAC 2000, WebSphere, Intertest, MQ Client, FTP, Exchange SMTP/POP, SAS, IBM

Db2 Content Management, Expeditor

ING FINANCIAL INSURANCE, NETHERLAND 2002- 2003

Software Engineer

Business Overview:

ING Financial Insurance is the number one financial services company in its home market of

the Netherlands. ING services its retail clients in these markets with a wide range of retail-

banking, insurance and asset management services. Our wholesale banking activities operate

worldwide but with a primary focus on the Netherlands, Belgium&Luxembourg. In the United

States, ING is a top-5 provider of retirement services and life insurance.

Transition and Transformation (TNT) aims at the feasibility and implementation of porting few

software tools under IBM mainframe environment. This project deals in financial and

insurance TNT, an ambitious project, involved with migrating existing tools to a new set of

tools which range from scheduling of critical business applications to performing tape backups

on IBM mainframes. The domain includes all the modules and systems running under different

sub systems of the client environment, for the ongoing projects of the client. The migration of

each tool has its own cycle of analysis, design, development, testing, implementation and final

cutover. At the end of the migration of each tool, normal execution of the system, various batch

jobs and applications needs to be ensured.

Responsibilities:

• Conduct large system tests, unit tests, integration tests, and code walkthroughs

• Planning the strategy for testing the modified programs with the of Business Analysts and

team.

• Executing test cases

• Reporting errors.

• Extensively used SAS for the reporting.

• Modify existing programs developed by other programmers.

• Maintain and support existing programs in customer’s production environment.

• Handling errors arising due to subsystem violation and whole system integration

• Handled Regression testing, Functional testing, UAT, Integration Testing etc.

Environment:

IBM3090, COBOL, DB2, JCL,FILEAID, Clear Quest, Quality center, RACF, QMF,

SPUFI, SAS, FTP, MVS, Assembler.

Contact this candidate