IT professional Resume

Profile

Have over 8 years of professional experience on IT field with the experience on Mainframe COBOL, DB2 UDB, Oracle and Visual Basic 6.0 in a challenging, diverse, and dynamic environment. I have worked on various environments like MVS OS/390, AIX, Linux and Microsoft Windows. I am a self-motivated, goal-oriented team player with demonstrated records of individual achievements. My communication skills are excellent. I am also an IBM Certified DB2 UDB Associate.

Education

Bachelor in Computer Science

Certifications

IBM Certified Database Associate - DB2 UDB V8.1

TECHNICAL SKILLS

Programming : COBOL, CICS, Visual Basic 6.0, C, Foxpro, PL/SQL
RDBMS : DB2 UDB ESE, (9.x,8.x/7.x), Oracle(8i,9i), MS Access
Platforms : IBM MVS OS/390, IBM AIX 5.x, Linux (Red Hat), Windows 98/NT/2000
Data Access Tech : SPUFI, ODBC, JDBC, DBI, DB2 Connect(8.x/7.x),
Scripting Languages : JCL, Shell Scripts (PERL, C/K/Bourne Shell), Awk, Sed
Web Technologies : HTML, XML
Networking : TCP/IP, Client - Server Technology
Tools : Expediter, TSO, ISPF/PDF, Endeavor, Win runner, Load Runner, PVCS

Experience

Client: Confidential
Project: MD CHESSIE
Duration: Mar 2006 - Till Date

The Maryland Children Electronic Social Services Information Exchange (MD CHESSIE) is an automated case management tool for child welfare staff throughout the state of Maryland.

The system provides social workers with an interactive system to automate the case record. Includes capabilities to help schedule appointments, generate reminders, print notices, store and access data, issue payments, and monitor availability and compliance of foster and adoptive homes.

I was recruited to this project to support the conversion activity from MVS OS/390 to DB2 UDB on AIX with Power Builder front-end.

Designed conversion methodology and achieved 90% accurate data conversion from mainframe system.
Written COBOL and JCL programs to interface data between Mainframe system and DB2/AIX system.
Used DB2 CONNECT for interface purpose, which interacted with DB2 OS/390 system.
Involved in design team to gather requirements, analyze and design for various functional modules.
Wrote stored procedures, shell scripts and UDF to implement conversion design. Analyzing and fixing the conversion issues.
When DBA not available acted stand by DBA and performed all DBA activities including taking backup, restoring backup to create new environment, EXPORT, LOAD IMPORT and performance tuning etc.
Giving full support to development team by writing stored procedures, UDFs, Triggers for various functional modules and creating database objects to support development team, and move them between each environment.
Developing stored procedures to meet the requirements for Management Reports that is being called from Crystal report.
Developed stored procedures to support expungement team to expunge the old data.
Worked on Ad-hoc reports by writing SQLs to meet on-demand requirements from client.
Analyzing and fixing data issues for all functional modules.
Analyzed complicated SQLs to figure out the performance bottle-neck and fixed them by using Visual access plan.
Created DDL Scripts for creating database objects and schema changes.
Wrote stored procedure and Shell scripts to implement interface requirements in which data will be receiving and sending to/from various application systems.

Client: Confidential
Location: Bangalore, INDIA
Duration: Jul 2000 - Mar 2004

Confidential, is a global pharmaceutical company discovers, develops, manufactures and markets vaccines, medicines and bulk drugs in over 20 therapeutic categories. The company put extensive efforts to increase access to medicines through far-reaching programs to the people who need them.

I worked in EDP department which is responsible for all IT related activities including system/network administering and developing applications to support the business in all departments.

Role:
COBOL (MVS OS/390) and JCL with DB2 were used to develop BALPP application. I was involved Design phase onwards.
Maintained small applications and fixed their issues which were running already in various departments developed on Visual Basic / Oracle and Foxpro.

Responsibilities:

Gathering requirements from concerned staffs
Designing document to outline the application flow for presentation purpose
Coding in COBOL and JCL.
Unit and System Testing
Preparing release document
Scheduling production batch jobs in JCL and reviewing the log.

Description:

Developed application (BALPP) which support Production activities including planning. This application gets order information from marketing department and plan production load by considering material stock and manpower availability, and gives planning as daily task, raw material quantity and number of workers needed. Production staff enters daily yield into system and get the adjusted plan accordingly. This application handles till the finished product goes to the warehouse.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship