Laxminarayan Sriram (Lucky)

Cleveland, OH.

Ph: +1-216-***-****.

Email: adctk7@r.postjobfree.com

Permanent Resident Visa Status

Summary

15+ years of experience in the information technology arena.

15+ years of experience as a cross database administrator for DB2 LUW, Teradata, Maxdb and Sybase.

11+ years of experience in the implementation and utilization of SAP ERP. Large number of successful implementation, upgrade and improvement projects.

IBM Certified Advanced Database Administrator and IBM Certified Instructor for Database Administration.

SAP Certified Root cause analysis expert and System administrator.

Teradata Certified Database administrator.

Extensively involved in the installation, upgrade, monitoring, performance tuning, troubleshooting and support for NetWeaver products like CRM, ECC, MDM, Portal, Solution manager, Data Services, SLT, LVM, PCA, PI, Content Server, Trex etc .

Extensively involved in analyzing and developing physical database design. Strong experience in performance monitoring, SQL analysis and tuning.

Worked on large scale clustered database of 50+ TB in size.

Worked in various projects, Developed good Technical, Analytical, Design and Development Skills.

Keen sense of observation, meticulous with details, good listener, ability to identify and solve problems, highly initiative and a good team player.

Published several articles in international journals like Xephon, Zjournal, Arcati mainframe and Align.

Certifications

SAP Certified Application Management Expert Root Cause Analysis.

SAP Certified Technology Associate – System Administration (DB2) with SAP Net weaver 7.0.

IBM Certified Database Associate - DB2 UDB Family Fundamentals.

IBM Certified Database Administrator - DB2 UDB for Linux, UNIX, and Windows Database Administration

IBM Certified Advanced Database Administrator for DB2 UDB for Linux UNIX and Windows

IBM Certified Instructor for Database Administration for DB2 UDB

Teradata Certified Professional – Teradata Basics

Professional Experience

American Greetings, Cleveland, USA

Nov’ 06 – Till date,

Senior Basis Lead and technical architect

Project Profile:

Founded in 1906, American Greetings is the world's largest publicly owned creator, manufacturer and distributor of social expression products. Headquartered in Cleveland, Ohio, American Greetings employs approximately 18,000 full-time equivalent associates around the world and is home to one of the world's largest creative studios.

AG’s SAP Production is 15+ TB systems running ERP, CRM, BW, Solman, Mobility etc. Currently most of American Greetings’ IT technology and architecture is based on custom application development using mainframe technologies. American Greetings has selected SAP as their ERP package and are migrating to it. As a Senior Basis Lead and technical architect I am involved in the implementation and support of the technical infrastructure and lead the Basis admin team.

Responsibilities as a SAP BASIS Lead:

Technical lead for the onsite and offshore basis resources and perform management activities like provide guidance, design and strategy to the team, daily reporting, task priorities, defect resolutions, resolve technical escalations, technical SME etc.

Manage and support 200+ SAP systems.

Assist with the implementation of SAP applications like ECC 6.0, CRM 7.1, BI 7.0, MDM 7.1, Content server 4.6, PI/Xi 7.4, BODS 4.2, MaxDB, SLT, LVM, PCA, CE and Solution manager 7.1. Plan and implement upgrades and patches. Roll out of solution monitoring using SAP and 3rd party tools.

Develop best practices for emerging technologies.

Troubleshoot and resolve risks for projects. Basis administration with performance tuning, testing strategies, change management, capacity planning & performance analysis, day to day operations etc.

Implement change management and ITSM procedures using Solution Manager.

Plan and implement archive strategy.

Data migration support – assist migration teams with infrastructure and strategy to migrate legacy data into SAP.

Develop best practices and automation writing scripts to improve system functionality.

Responsible for Basis escalation and 24 hrs system support.

Responsibilities as a DB2 UDB DBA: Technical support to application users in various areas like

Assist and manage the offshore DBA team. Facilitate design, discussions, direction, support, guidance to the dba resources.

Administer and support 200+ DB2 databases

Assist with the Installation and upgrade, Database definitions, Housekeeping, Security administration, Customization of database parameters, Performance monitoring and provide recommendation.

Unix Scripting

Storage Administration and Capacity planning

Disaster Recovery

Responsible for DBA escalations and 24 hrs. system support.

Citibank, Florida, USA

Jun ‘05 – Oct ‘06

DB2 & Teradata DBA (Consultant)

Project Profile:

Citi Cards is the world’s largest provider of credit card products. Citi Cards North America is the industry leader with 2.5 percent of GDP spent using its credit cards and with an estimated 10% of Citi Card sales transacted online. Citi Cards has engaged TCSL to provide production support for its data warehouse.

Responsibilities as a DB2 UDB DBA:

Attending meetings and discussing requirements with clients

Discussing security and capacity management with System DBA

Database Designing based on client requirements

Discussing Database and Application interfacing with application programmers

Maintenance - Technical support to application users in various areas like

Database definitions

Housekeeping

Security administration

Performance monitoring using Teleran, Ambeo and provide recommendations.

Unix Scripting

Installing and upgrading

Customization of DB2 parameters

Storage Administration

Database Designing

Archive & Purging and space management.

Capacity planning

Environment: AIX 5.2, DB2 UDB 8.2 on five IBM p690 systems consisting of SMP nodes each containing 32 1.3 GHz Power4 processors and 48 GB memory. Teleran, Ambeo, DB2 Connect, DB Artisan.

Responsibilities as a Teradata DBA:

Design

Participated in design of large database extending to 50 TB in size

Identify primary Index in Teradata for data distribution and avoiding data skew

Security mapping – Generate Roles & Profiles

Participated in deciding how different types of database need to be created based on schemas in DB2.

DB2 to Teradata Migration

Extract object Definitions from DB2 and port it to Teradata

Migrate data from DB2 to Teradata using OLE Loads and Scripts

Object and Data Validation

Migrating Scripts and perform functional mapping

Maintenance - Technical support to application users in various areas like

Database Definitions.

Using Atana Suite for copying database objects and sync production, development, QA and COB.

Collect Statistics

Security administration

BAR – Backup & Recovery

Storage Administration

Housekeeping

Environment: Teradata v2r6 on MP RAS Enterprise Operating system EOE v 3.03, 4 X NCR5400H Teradata servers, TD administrator, TD Manager, Atena Suites, Ole loads, Veritas Net backup.

Shinsei Bank, Tokyo, JAPAN.

Jul ‘05 - Sept ‘05.

Capacity Analyst (Consultant)

Project Profile:

Shinsei Bank, Limited is a leader in creating a new financial environment for Japan. Established in 1952, as The Long-Term Credit Bank of Japan, Shinsei Bank was reborn under new management in 2000. It boasts just $ 60 billion of assets and only 29 retail branches, in a business it started only in June 2001. It is the first Japanese bank operating under international ownership.

Responsibilities:

Performance Analysis of the current Hitachi Mainframe System.

Provide recommendation to reduce the current 100 % Batch CPU Utilization.

Capacity planning of their Hitachi Mainframe System for the next 4 years.

Study the system and identify performance bottlenecks.

Provide recommendations to implement dynamic CPU allocation and serialization to reduce the 100 % batch CPU utilization.

Provided recommendations for optimum sort memory, buffer pool size, and sort sequence to improve response time.

Involved in SQL Analysis of the applications and provided recommendations for improving performance.

Prepare the technical assessment report and present the findings

Environment: VOS3/FS on 550 MIPS Hitachi AP8000, XDM/SD, XDM/RD

SABA, Mumbai, INDIA.

May ’05 - Jun ‘05

DB2 Performance analyst (Consultant)

Project Profile:

SABA is a leading provider of Human Capital Development and Management (HCDM) solutions to customers in 24 countries whose offerings include an integrated Internet-based platform to manage learning, content, performance, talent, and collaboration; and related professional services. They had migrated their SABA Learning Suite application from Oracle 9i to DB2 UDB v8.2 on windows and facing performance degradation.

Scope of the Project

Responsibilities: Performance assessment of SABA Learning Suite application system to reduce response time and CPU consumption.

Study the system and identify performance bottlenecks.

Performance testing using monitor switches and windows performance monitor and identify opportunities for improvement.

Provided recommendations for optimum Instance and database configuration parameters, buffer pool size, and table space layout and table design.

Involved in SQL Analysis of the applications and provided recommendations for improving performance.

Prepare the technical assessment report and present the findings

Environment: Windows 2000, DB2 UDB 8.1 ESE.

Thomas Cook, Mumbai, INDIA.

Mar ’05 - May ‘05

Database Design & performance Analyst (Consultant)

Project Profile:

Thomas Cook (India) Ltd is a part of Thomas Cook Group, which is one of the world's leading international travel and financial services groups serving over 20 million customers a year in more than 25 countries.

Responsibilities:

Capacity Analysis for FOS application to account for the increase in workload.

To conduct a review exercise of the database design before migration from DB2 UDB v7.1 to v8.2.

To conduct POC for the implementation of Concurrent I/O after migration from AIX 4.1 to AIX 5.2.

Study the resource consumption for the existing system and estimate Memory and DASD requirements.

Prepare the capacity planning review report and recommendations and present the findings.

Review of the Database architecture and high-level design.

Prepare the Database design review report and recommendations for tablespace and table layout.

Conducted POC to show improved performance using Concurrent I/O (CIO).

Performance testing using monitor switches, event monitors, vmstat, iostat and netstat to identify opportunities for improvement.

Provided recommendations for optimum Instance and database configuration parameters and buffer pool size.

Provided recommendations for table space distributions over logical volumes and optimum RAID setting.

Prepare the technical assessment report and present the findings

Environment: AIX 5.1, DB2 UDB 7.2 on symmetrical multiple processors operating in partitioned environment.

Reserve Bank of India, Mumbai, INDIA.

Jan’05 – Feb ‘05

DB2 Performance Analyst (Consultant)

Project Profile:

The Reserve Bank of India (RBI) is the central bank of India, fully owned by the Government of India. TCS has developed and implemented software solutions for the Reserve Bank of India. The transactions for deal processing i.e. SDE0, SDA0 & SDS0 were seen to be taking abnormally long time to process the incoming requests.

Responsibilities:

Study the system environment of RBI.

Analyze the system parameters for performance problems/bottle-necks

Analyze the application for performance issues/bottle-necks

Identity Opportunities for Improvement (OFI)

Recommend performance improvement strategies

Discussions with the RBI system personnel/TCS support team to determine the current performance issues.

Study system parameters.

Study of CPP programs performing memory allocations for identifying the program causing memory leak.

Prepare the technical assessment report and present the findings.

Environment: AIX 5.1, DB2 UDB 7.2

Tata Consultancy Services (TCS)

System Software Group, Mumbai, INDIA.

Jun ‘03 – Dec‘04

DB2UDB and DB2 on Z/OS DBA

Project Profile:

System Software Group (SSG), which is a part of Architecture and Technology Consulting Service Practice (ATC-SP) of Tata Consultancy Services (TCS), offers system software and consulting services to TCS clients in the large systems domain. The range of services offered by SSG include Installation and customization, System software administration, Storage management, Capacity management, Performance management, Security management, Disaster recovery planning, Technical support and a host of other system software related services.

Responsibilities:

DB2 Support:

Technical support to application users in various areas like

Database definitions

Database reorganisation

Housekeeping

Security administration

Performance monitoring and recommendation

System Administration:

Installing products in AIX (DB2, DB2 Tools etc)

Customization of DB2 Environment

Storage Administration

Configuration parameter changes

DB2 training:

Prepared and performed review for DB2 training materials.

Tools Built with REXX on Mainframe:

DECOMPILER: A tool to recover Cobol Source code from the Load module.

SQL ANALYZER TOOL: This Utility scans COBOL-DB2 programs and analysis embedded SQL. It collects various statistics and then prescribes changes to the SQL based on guidelines. This is useful to improve performance, correctness, readability & maintainability of the SQL.

DFH$MOL REPORT FORMATTER TOOL: The program scans the output of the DFH$MOLS and generates a report, collecting necessary information and Formatting the output to be exported to excel sheet.

LOAD MODULE ANALYSER: The Load Analyser processes load modules and extracts information — such as Load module names, Language used, Compilers and release levels, Compiler signature. Used while decompilation of load modules to recover lost source code.

CAPACITY PLANNING TOOL USING QUEUEING NETWORK MODEL

Environment:

AIX 4.8, DB2 UDB 7.1

IBM OS/390, MVS/ESA, VS-COBOL-II, RACF, JCL, QMF, IBM DB2 Administration Tool

Some of my Publications

Magazine Name

Publication Issue

Publication Title

MVS Update, Xephon

May 2005

Decompilation - Generate Source code from the Load Module

ftp://www.cbttape.org/pub/xephonm/mvs0505.pdf

DB2 Update, Xephon

May 2005

Guidelines for coding Efficient SQL

ftp://www.cbttape.org/pub/xephond/db20307.pdf

MVS Update, Xephon

June 2005

Load Analyzer Utility

DB2 Update, Xephon

September 2005

SQL Analyzer Utility

AIX Update – Xephon

October 2005

AIX and DB2 tuning essentials and best practices for DB2 performance

www.cbttape.org/xephon/index.php?path=xephona%2F&download=aix0510.pdf

AIX Update, Xephon

November 2005

AIX and DB2 tuning for DB2 performance - a case study

http://www.cbttape.org/xephon/index.php?path=xephona%2F&download=aix0512.pdf

AIX Update, Xephon

February 2006

Enabling Direct IO or Concurrent IO in DB2 UDB on AIX

ftp://public.dhe.ibm.com/systems/power/community/aix/Central-VUG-Replays/Files/CIO_db_perf_aix.pdf

Z journal

May 2006

Improved Unicode Conversion

http://enterprisesystemsmedia.com/article/db2-for-z-os-version-8-improved-unicode-conversion

Education

Sri Chandrasekharendra Saraswathi Viswa Mahavidyalaya University, INDIA.

Year: 1991-2003.

Graduated with degree in Computer Science and engineering.

Contact this candidate