Bhopal Singh Resume for Mainframe Developer job

*** ******** ** *********, **. 60102 630-***-****

AT&T Inc.

**/**** – 12/27/16

Technical Skills

Database DB2, Teradata

Office Suite Microsoft Outlook, Word, Visio, Power Point, Xcel

Client Server SQL Assistant, MQ Series

Operating System MVS, UNIX

Methodology SDLC, Agile

Utilities Syncsort, PRISM, Changeman, BTEQ, Multiload, Fast Export, CLIST,

TSO, ISPF, VSAM, QMF, SPUFI, Sharepoint, TDP, TPT, PRISM

OTHER COBOL, CICS, JCL, BAL, Panvalet, ESP, FILEAID, FileManager

Summary

Was responsible for creating and testing over 200 NDM ETL jobs using BTEQ and COBOL on EDW mainframe platform to eCDW Big Data for loading. Used Agile methodology.

Was responsible for adding logic to COBOL housekeeping programs to stop running batch cycle when an input file is missing or out of sequence

Reduced AMBS batch cycle run time from 24 hours to 8 hours by optimizing DB2 database, COBOL programs, and SQL queries, a savings of over $350,000 per year

Was responsible for converting and testing over 100 FileAid jobs to File Manager jobs

Was responsible for reducing online response time 40% by modifying CICS programs

Was responsible for Analyzing and performance related problem solving issues with clients’ SQL queries

Forward engineered Credit & Collections data model to Dev, Test, and Prod environments, optimized indexes on all the table for better performance, created history keeping delta process from scratch using SQL.

Was responsible for problem solving and analyzing SQL queries and data issues with TRACS, CRM and OMS databases

Responsible for creating, capacity planning

Responded to over 300 trouble ticket during 24X7 production support, and resolved all the issues within allowed time. Hosted meetings with source system personal and the client. Communicated data issues with originating source system and notified affected user community for problem resolutions and recovery. Optimized SQL to resolve many issues. Used BMC Remedy for tickets

Reduced database size by compressing tables, a savings of over $100,000 a year

Created Archive, restore, and recovery jobs for DB2 and Teradata database

Responsible for creating testing BTEQ, Mload, Fast Load and Fast Export for CRM, OMS, USAGE, TRACS data base with zeros defects

Implemented CRM, OMS, USAGE, and Granite databases in releases with zero defects, using ITUP methodology. Prepared M6 thru M11 release management Artifacts, stored them in PRISM. Created SQL queries to access Teradata

Proactively identified redundant data on database, created archive jobs, reduced clock and CPU time by 55% by rewriting and optimizing SQL queries resulting in space savings of $125,000 a year

Responsible for DirecTV integration, broad band discount implementation, rebranding of UVERSE, SNET divestiture, UNIX to LINUX conversion, implemented eCI reporting using Agile methodology and TDP

Implemented CRM, OMS, and Granite LightSpeed Teradata database on EDW platform in various releases with zero defects

Delegated work to ABMS developers. Hosted status calls with developer, DBA, and testing teams. Provided weekly project status to Executive Director

11/94 3/98

Sears Roebuck & Co. Hoffman Estates

Was responsible for designing, creating DB2 Database, performance tuning of COBOL, CICS, DB2, SQL and mail delivery vendor software. Created Inventory tracking and linking stores and distribution centers. Cut CICS response time by 40% by tuning CICS table parameters.

12/93-11/94

FIRST Chicago, Corp., Elgin, IL

Was responsible for designing, programing, and implementing Credit Life Insurance software. Worked as Systems Analyst. Used DB2, VSAM, COBOL, JCL

6/91-12/93

Safety Kleen Corp., Elgin, IL

Was responsible for collecting requirement, designing, and data modeling Inventory Hauling System using COBOL, DB2, CICS and SQL. Automated a fleet of vehicles with driver(s) to pick up dirty oil inventory from collection center and deliver it to recycle center. Worked as project manager and reported directly to a director. Delegated work to a team of programmers. Worked as Systems Analyst.

04/86-04/91

LPC, Inc.,

Coded and tested programs for address standardization product FINALIST, and duplicate address elimination product PURGE 1. Used COBOL, BAL, JCL

EDUCATION

Graduated from DePaul University Computer Career Program, 1985.

B.S., Chemistry, University of Meerut renamed to Chaudhry Charan Singh University, India. 1976

Contact this candidate