Premkumar Shukla

Cary, NC ***** USA

732-***-****

act818@r.postjobfree.com

CAREER HIGHLIGHTS

A seasoned DBA with over 22 years of IT experience with 12 years of proven experience as DB2 Application Programmer/ DB2 Database Administrator which includes DB2 UDB on Windows.

DB2 & DBA experience expertise in leveraging DB2 database platform on AS-400 (iSeries), Mainframe (z/OS and MVS), AIX and Windows.

Administered DB2 on AS-400 (iSeries), Mainframe, AIX and Windows environments.

Expert in Data Integration, Performance Tuning and troubleshooting problems.

Extensively worked with DB2 Explain and Snapshot.

Expert skills in Tuning and analyzing application code such as SQL, Triggers, Stored Procedures, Setting up Backup and recovery strategies, Scheduling jobs.

Extensive experience in using Third party tools like Platinum for Database operations like Tuning, monitoring, backups & recovery and other Database operations, HADR utility for disaster recovery, Change Data Capture (previously Data Mirror Transformation) and ERWIN Data Modelling tool.

Hands on experience on Creating and using Federated Database, implementation of DRDA (Distributed Relational Database Architecture)

Expert knowledge of DDL and DML (SQLs)

Have working knowledge of DDS.

Expert Knowledge of DB2 Connect, QMF for Windows, iSeries Navigator and other DB2 utility.

Expert in Complete Software Development and Maintenance Life Cycle.

Expert knowledge of MS SQL Server and related products as SSRS, SSIS and SSAS. (4 Year experience).

Expert Knowledge of SAP BO (Crystal Reports, Dashboard, Universe etc.) and SAP Data Services

Expert Knowledge of using SQL Server Management Studio

Have Experience in (24 x 7) Production Support

Expert knowledge of ALDON (Version Control for iSeries Objects), HP ServiceCenter and Scheduler Control-M.

Worked in domain like Insurance, Manufacturing, Retails and Banking.

Adaptable to any technology.

TECHNICAL SKILLS

Hardware

IBM AS-400, IBM-390, PC

OS

OS/400, MVS, z/OS, Windows, DOS, AIX

Databases

DB2, DB2 UDB, MS SQL Server 2005, 2008R2 and 2012, MS Access

Db2 Tools

DB2 Connect, iSeries Navigator, DB2 utility, QMF, BMC utilities, OMEGAMON, SOFTECH Utility, DB2 File Aid, Data Stage, HADR, Data Mirror Transformation

Languages

SQL, COBOL, JCL, CICS, CL

Version Control Tools

Endevor, ISPF, ALDON

WORK EXPERIENCE

Promantus, Inc., Cary, NC Jan 2016 – Till Date

Promantus Inc. is a team of Technology and Business enthusiasts committed to solving real business challenges to help clients gain competitive advantage by developing actionable strategies to maximize performance and achieve measurable results through the latest Technology solutions.

Database Administrator

Identified database requirements by interviewing customers

Analyzed department applications, programming, and operations

Evaluated existing system and designed proposed systems

Established solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications

Installed revised or new systems by proposing specifications and flowcharts

Recommended optimum access techniques

Coordinated installation requirements

Maintained database performance by calculating optimum values for database parameters

Implemented new releases and completed maintenance requirements

Prepared users by conducting training; provided information to resolve problems

Supported database functions by designing and coding utilities

Maintained quality service by establishing and enforcing organization standards

Technologies

z/OS, JCL, DB2, CL, QMF for Windows, DB2 Connect, iSeries Navigator, TOAD for DB2, AS/400, OS/400 and PC, MS SQL Server 2012, HADR, QREP and related products

IBM, RTP, NC July 2015 – Dec 2015

DB2 Database Administrator

Monitoring the jobs running on Data Collection through JAZZ ETL

Tracking of Database servers

Fine tuning database servers to make job run faster.

Supporting IBM Rational Team Concert and ClearQuest environments

Supporting DB2 servers on AIX and Windows servers.

Migrating DBs from AIX to Red Hat Linux and windows servers

Migrated more than 200 databases (DB2, MS SQL and Oracle) from Old servers to New Servers (From DB2 9.5 to DB2 10.5, MS SQL 2005 to MS SQL 2012 and Oracle 10g Release 2 to Oracle 12c)

Technologies

DB2 UDB 9.5, 9.7, DB2 LUW 10.1 and 10.5, IBM Data Server Manager, IBM Data Studio, Red Hat's Open client for Linux 6.2, IBM Power Server with AIX OS and IBM tools.

BCBSNC, Durham, NC Jan 2014- July 2015

Blue Cross and Blue Shield of North Carolina (BCBSNC) is a fully taxed, not-for-profit North Carolina company that employs more than 4,000 North Carolinians and serves more than 3.7 million customers. BCBSNC delivers value through quality products, information and services to help its customers improve their health and well-being. Their vision is to be a leader in improving the health care system in North Carolina.

Production Support DBA

Monitoring the health of DB2 Region on Mainframe and iSeries

Tracking of DB2 jobs and trouble shooting

Evaluated existing system and recommend solutions

Established solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications

Installed revised or new systems by proposing specifications and flowcharts

Recommended optimum access techniques

Coordinated installation requirements

Maintained database performance by calculating optimum values for database parameters

Implemented new releases and completed maintenance requirements

Supported database functions by designing and coding utilities

Maintained quality service by establishing and enforcing organization standards

Migrated reports from MS SQL Server 2005 to MS SQL Server 2008R2 using SSRS and also migrated integration packages from 2005 to 2008 R2.

Technologies

z/OS, JCL, DB2, CL, dBVisualizer for Windows, iSeries Navigator, ALDON, HP ServiceCenter, CONTROL-M, AS/400, OS/400 and PC

Promantus, Inc., Cary, NC Oct 2013- Jan 2014

Promantus Inc. is a team of Technology and Business enthusiasts committed to solving real business challenges to help clients gain competitive advantage by developing actionable strategies to maximize performance and achieve measurable results through the latest Technology solutions.

Database Administrator

Identified database requirements by interviewing customers

Analyzed department applications, programming, and operations

Evaluated existing system and designed proposed systems

Established solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications

Installed revised or new systems by proposing specifications and flowcharts

Recommended optimum access techniques

Coordinated installation requirements

Maintained database performance by calculating optimum values for database parameters

Implemented new releases and completed maintenance requirements

Prepared users by conducting training; provided information to resolve problems

Supported database functions by designing and coding utilities

Maintained quality service by establishing and enforcing organization standards

Technologies

z/OS, JCL, DB2, CL, QMF for Windows, DB2 Connect, iSeries Navigator, TOAD for DB2, AS/400, OS/400 and PC, MS SQL Server 2012, HADR, QREP and related products

USGBC, Washington, DC May 2009 – Oct 2013

The U.S. Green Building Council (USGBC), co-founded by current CEO Rick Fedrizzi, Mike Italiano, and David Gottfried in 1993, is a private 501(c) 3, membership-based non-profit organization that promotes sustainability in how buildings are designed, built, and operated. USGBC is best known for its development of the Leadership in Energy and Environmental Design (LEED) green building rating systems and its annual Greenbuild International Conference and Expo, the world’s largest conference and expo dedicated to green building.

DB2 DBA

Additional responsibility of MS SQL Server DBA

Designed Implemented and supported databases as well as Custom developed

Database Performance monitoring, tuning and capacity planning

Data maintenance, Backup Planning and Recovery

Object / Data Migration and authority profile from one DB2 subsystem to another

Created Physical and logical file using QMF and Command line CL command

Created tables, indexes and views using DDL

Used TOAD for DB2 to monitor Database health.

Created and reviewed triggers and stored procedures.

Data Modelling and implementation of Database design using ERWIN

Imparted training to the Application Development Team

Development and maintenance of Stored procedures

Reviewed Stored Procedures and user defined functions before moving to production.

Used IFS for many of the admin work on DB2 and AS-400

Used CL command for monitoring jobs and working with objects.

Co-ordinating with network and operational personals for maintaining performance of Database for users. Giving support 24X7 to the users of the AS-400 DB2 Environment.

Performed MS SQL Server installation and configuration

Performed MS SQL Server Reporting System and configuration

Performed database migrations

Provided ongoing database support including performance enhancement maintenance and end-user education

Managed and resolved design issues during development stage and worked closely with developers

Moved database Schema changes to stage or production.

Performed database tuning using Quest monitoring tool, Explain Plan.

Created databases and database objects

Modified and enhanced existing databases

Performed backups recoveries and reorganizations of databases

Replicated database updates using Replication Centre

Created database reports using SSRS

Imported data from difference data resources using SSIS.

Technologies

DB2-400, CL-400, QMF for Windows, DB2 Connect, DataMirror Transformation, iSeries Navigator, TOAD for DB2, AS/400, OS/400, AIX and PC, MS SQL Server and related products, ERWIN, MS SQL Server 2005, 2008R.

IBM, Raleigh, NC Nov 2006 – May 2009

The International Business Machines Corporation (commonly referred as IBM) is a multinational technology and consulting corporation, with headquarters in Armonk, New York, United States. IBM manufactures and markets computer hardware and software, and offers infrastructure, hosting and consulting services in areas ranging from mainframe computers to nanotechnology.

AS400 – DB2 DBA

Interacted with end Users

Designed Intermediate Database

DB2 Support for System X and SEATS (Single Element Arrangement Transaction System)

Developed application using CL programs

Created tables, indexes and views.

Created triggers and stored procedures.

Co-ordinated between application development team and IBM DB2 support team

Kept track of change request and implementation of the same

Kept defect register and took corrective action to remove defect and planned for preventive action to make sure subsequent deliverable should go error free.

Maintained System X

Maintained database model using ERWIN

Technologies

z/OS, JCL, DB2, CL, QMF for Windows, AS/400, OS/400, Lotus Notes, QREP, IBM’s Management tools, ERWIN and PC

Allstate Insurance Company, Chicago, IL Jan 2006 – Sept 2006

The Allstate Corporation is the largest publicly held personal lines property and casualty insurer in America. Allstate was founded in 1931 and became a publicly traded company in 1993. As of year-end 2013, Allstate had $123.5 billion in total assets. In 2013, Allstate was number 92 on the Fortune 500 list of largest companies in America.

Technical Lead

Preparing Impact Analysis for any change requested by business user

Estimating efforts of the module assigned to him.

Participation in the project Status meetings.

Initial problem diagnosis (on-line functionality, output, batch jobs, interfaces, etc.)

Identifying/proposing fixes and recovery steps using COBOL, DB2, SQL, MQ Series and JCL

Testing the changes using JCL & DB2 Stored Procedures in COBOL Environment (development, user acceptance, integration, and regression testing)

Made Extensive enhancements in called programs, which are stored procedure objects, fine-tuned various embedded SQL queries for faster response.

Coding, self-reviewing and doing unit testing using COBOL, IMS DB, DB2 and Scripts.

Writing and modifying JCLs

Used SMARTEST for debugging the code.

Writing Test plans and test cases for unit testing and user acceptance testing

Supporting Production runs.

Resolving Production ABENDs

Interaction with business user to get clarification on the work to be done.

Interaction with Operations people to make production run smooth.

Working with other team members including SME to run jobs as requested by authorized users & monitoring the production on on-call basis

ENDEVOR is used for version control management of all the objects being developed after extensive testing

Responsible to move all the modules from Test environment to Quality control & from there into Production

Migration of DB2 Stored procedures, COBOL, Link cards, JCLs etc. were made with the help of ENDEVOR.

Sign-in & Sign out procedures were also assigned to him using Endeavour to support the entire team requirements.

Performance Tuning the DB2 queries for the faster response.

Preparing and presenting the status report for status meetings.

Preparing and upgrading system documents and design documents.

Providing various report to business users based on their request.

Test data population in Unit, System Integration and regression testing environment.

Loading Data from Mainframe to ORACLE Database

Maintained Database design using ERWIN

Project

Project deals with AUTO Insurance Claims.

Technologies

COBOL, JCL, Scripts, IMS DB, Stored Procedures, SPUFI, TSO, CICS, ENDEAVOR, DB2, IMS File Aid, Smartest, ERWIN, IBM-390, Z/OS and PC.

Humana HealthCare, Louisville, KY Jul 2005 – Dec 2005

Humana Inc. is an American managed health care company that markets and administers health insurance. With over 11.1 million customers in the United States, the company is the largest (by revenues) Fortune 100 company headquartered in the Commonwealth of Kentucky, and has a market cap of over US $13 billion, $36.5 billion in revenue, and over 40,000 employees worldwide.

Technical Lead

Analysed and Designed the HIDCMS.

Interacted with business for Requirements

Understanding business functionality.

Imparted knowledge among the team members.

Prepared and presented the status report for status meetings.

Prepared and upgraded system documents and design documents.

Interaction with business user to get clarification on the work to be done.

Interaction with Operations people to make production run smooth.

Coding, reviewing, testing using COBOL, DB2.

Wrote and modified JCLs.

Stored Procedure building using COBOL, DB2.

Worked with other team members including SME to run jobs as requested by authorized users & monitoring the production on on-call basis

PANVALET is used for version control management of all the objects being developed after extensive testing

Estimated efforts of the system.

Participation in the project Status meetings.

Used SMARTEST for debugging the code.

Monitored team members

Logged defects

Analysed defect pattern and take corrective actions to prevent occurrences of defects.

Test data population in Unit, System Integration and regression testing environment.

Responsible to move all the modules from Test environment to Quality control & from there into Production.

Project

To avoid duplicate print error of Health Insurance Card, lot of duplicate card printing incidents were reported. To prevent the printing of duplicate card, the current system (Client ID Card Management System (HIDCMS)) came into existence. Being proactive in nature, this System provides user to view, hold, release, cancel and do other activities before sending for printing of the ID card to vendor.

Technologies

COBOL, DB2, JCL, SPUFI, TSO, PANVALET, DB2 Platinum, IBM-390, z/OS and PC

American Express, Salt Lake City UT Nov 2004 – Jun 2005

American Express Company, also known as AmEx, is an American multinational financial services corporation headquartered in Three World Financial Center, Manhattan, New York City, New York, and United States. Founded in 1850, it is one of the 30 components of the Dow Jones Industrial Average. The company is best known for its credit card, charge card, and traveler's cheque businesses. Amex cards account for approximately 24% of the total dollar volume of credit card transactions in the US.

Tech Lead with additional role of DBA

Project Status tracking and reporting

Interaction with Business User

Prepared Business process flows using MS-VISIO

Reviewed Business process flow, Requirement Documents (K245s) and Business System Analysis Review (BSARs) Document.

Prepared and presented the status report for status meetings.

Prepared and upgraded system documents and design documents.

Interaction with business user to get clarification on the requirements.

Interaction with Operations people to gather more business requirement and data interpretation.

Participation is project status meetings

Project

GPP (Global Product Platform) is a system which has capability of processing stored value cards issued by Client to its customer. Current system is running on AS/400 platform using Cool: Plex. Client projected for annual growth of 1 Million Cards per year and realised that AS/400 cannot support the growth after some time; therefore they decided to change the platform to Mainframe.

The application was divided into different sub applications and started work of reverse engineering to prepare the requirements as per existing system to arrive at to be future system. In this process, we have captured the requirements for Infrastructure which comprises Payment Engine, MQ Setup, Web-services and Input Output Management.

Client was using “Method 1” for defining Process Management and SDLC.

Technologies

Cool:Plex, MS Visio, AS-400 and PC

Cobol, DB2, JCL, CICS, IMS DB/DC, Job track, SPUFI, TSO, Change man, SOFTECH Utility, DB2 File Aid, IBM-390 and PC, MQ Series, CA7 Scheduling, Stored Procedures

Other Projects Handled Sep 2000 – Oct 2004

GNA( Global New Accounts) for Client using Cobol, DB2, JCL, CICS, IMS DB/DC, Jobtrack, SPUFI, TSO, Changeman, SOFTECH Utility, DB2 File Aid, IBM-390 and PC, MQ Series, CA7 Scheduling, Stored Procedures.

MMIS(Medicaid Management Information System) for Client using IBM-390, COBOL, DB2, CICS, JCL, XPEDITOR, SPUFI, TSO, ENDEAVOR, SOFTECH Utility, DB2 File Aid.

Supply Chain Tracking System for Client using Cobol, DB2, JCL, Xpeditor, Panvalet, SPUFI, TSO, Endevor, SOFTECH Utility, DB2 File Aid, IMS DB/DC, IBM-390 and PC

AIR Simplification for Client using COBOL, DB2, JCL, Xpeditor, Panvalet, SPUFI, TSO, Endeavour, SOFTECH Utility, Db2 File Aid, IBM-390 and PC.

SYNTRANET (In house project) using Cold Fusion, ASP, MS SQL Server 7.0, Crystal Report, VB 6.0 & PCs

WIRED4BIZ (JAJ-MUM) using RPG-400, CL-400, Web Logic, Web Methods, AS/400 and PC with B2B Server

MOPAR for Client using Cobol, CICS, Db2, JCL, IMS DB/DC, Xpeditor, Panvalet, SPUFI and TSO

Independent Software Consultant Nov 1993 – Aug 1998

Worked on projects for the following clients (As Independent Software Consultant):

oFixed of Y2K bugs in Sales Accounting cum FG Inventory & Cash System for Bayer India Ltd., Mumbai.

oStudy, design and development of Technical Maintenance Department’s Inventory using VB 6.0 and Oracle, for Bayer India Ltd., Thane Plant.

oFixed Deposit, Lease & Hire Purchase System and Financial Accounting System (using Clipper) for Alta Leasing & Finance Ltd., Mumbai

oSales Accounting System, Purchase Accounting System and Stores Accounting System for HD Fire Protect Co., Thane

oStudy, design & development of Fixed Deposit in FoxPro for Camphor & Allied Products Ltd., Mumbai

oIntegrated Inventory System (Purchase Accounting, Stores Accounting & Bill Passing) using PC-COBOL for Voltas Ltd. (Motor Plant), Thane

oSmall ERP Package (Purchase accounting, Inventory Management, Sales accounting, Finance accounting & Payroll) for Ceamtronics, Thane

oPayroll System in FoxPro for Bhavan’s SPARC, Mumbai

Inarco Ltd, Thane, India Jul 1991 – Oct 1993

An organisation engaged in manufacturing Acotex aprons and cots-consumable items used in spinning & weaving mills.

Programmer

Design, development & maintenance of Account Receivable System, Account Payable & FAS in Dbase IV

Exxon Computers, Mumbai, India Jul 1989 – Jul 1991

An organisation engaged in software development and data processing

Software Programmer

Project

Major Projects in PC COBOL:

Payroll Accounting System for Hind Cycles, Mumbai

Share Broker System for Dalal & Co., Mumbai

Bank Reconciliation for MHADA

Pre-examination and Post-examination Software for BSRB, CRB-SBI and MSCB-Mumbai.

EDUCATION

MSc. (Mathematics) from Kanpur University, Kanpur in 1982.

BSc. (Maths, Physics, Chemistry) from Kanpur University, Kanpur in 1980.

Contact this candidate