Analyst Data
Resume:
Title:Cashier
*******@***.***
Document
Source below
NAME: gurrala, vijay
ADDRESS: **** ******* *** **
ADDRESS2:
CITY: Pearland
STATE: TX
ZIP: 77584
CANDIDATE ID: 2246619
US CITIZENSHIP: US
Citizen
EDUCATION: Bachelor Degree
EXPERIENCE: 5
WILL RELOCATE: Yes -
JOB WANTED: Any
RATE NEEDED
: Open
TELEPHONE: 281-***-****
EMAIL: *******@***.***
HOMEPAGE:
HOTTEST SKILLS: db2 =5+ yrs, oracle =3+ yrs, cobol =5+ yrs, c++ =2+ yrs
REVISION: 27-SEP-01
YOE: 5
RESUME:
VIJAY GURRALA
Pearland Texas 77584 ************@*****.***
SUMMARY:
Twenty plus years working experience in Data Analysis,design, development and maintenance
of (Oracle /DB2/CICS&IMS/DB) database systems utilizing structured methodologies (SDLC).
Six years experience with DB2/Oracle APS/MF Cobol COBOL II,/PLI /VB & CICS IBM/Unix /AIX
based systems.
TECHNICAL SKILLS:
Hardware: UNIX/AIX, UNIX/NT, LAN/SNA, IBM/OS MVS 3033 390
Software Languages: MF COBOL, COBOL II, PL/1, CSP/APS VB, and PL/SQL Peoplesoft
Aplications HRMS Payroll Integral PDS GL/AP/AR OIL/GAS Utilities SQR ABAP/4
Databases: RDBMS DB2 ORACLE, and XDB. IMS/DB
Utility: QMF,SPUFFI/FileAid/Bachman/BMC/CICS/SAS,CSP,QMF,Intersolv,Endeavor
APS/WB, MVS/XA, TSO/SPF, Panvalet,PVCS, REXX, MVS/XA
EDUCATION:
Andhara University
- India
BS Degree
in Math and Physics
University of Sagar
- India
MS Degree
in Mathematics
DePaul University
- Chicago
MS (incomplete) Degree
in Information Systems
EXPERIENCE:
Exxon Mobil
Jan01-june01Programmer Analyst
Convert Mobil data into Exxon format for Lease accounts/Owner accounts into SAP tables
Perform data Analysis Extract using SAS .
Data conversion Using MF Cobol / BDC programs to load the data
Manipulated data using embedded SQL in Cobol II for the Exxon data format.
Design/produce exceptional user reports using RDBMS
Data send/recive using FTP and loaded into SAP Tables for FI/CO modules.
Cobol ii IBM MVS DB/2 QMF ABAP/4 DBC NT
Environment: SAP R/3 NT IBM/MVS,SAS, DB2/390, and SQL
Compaq Computers
Aug 00Nov 00Business Analyst
Major customer support CAMEO system to WEB based OCTANE 2000(CRM) Conversion project.
Performed Functional Analysis prepared Business Flows for Products
/Warranties/Customer/Research and resolutions. Team lead in coordinating work flow with
mage group of four.
Perform Unit/Integrated/stress test and create test cases.Involved in regression test.
Data map of SAP Materials data (tables) to Product/SLA Warranties data (tables) of
Epiphany (OCTANE2000).
Wrote, tested and manipulated PL/SQL scripts to load data into Oracle tables.
Design /Create required User Reports using VB and orient them how to use the system.
Work with RDBMS (Oracle 8i ) /SQL Plus Visio Unix/NT systems and FTP
Environment: Oracle, UNIX system/NT system, VISIO, PL/SLQ and SQL PLUS
AOL/Time Warner
Aug 99July 00Data Analyst/Project Lead
Conversion project from Payroll Developing System (DB2) HR/Payroll to ORACLE/PEOPLESOFT
v7.5
Design Physical and logical tables for required tables
Extract required data from Payroll Developing System (DB2 HR/Payroll) using embedded
SQL MF/Cobol
.
Involved in data mapping, manipulating fields, types and configurations with users.
Inhouse train the staff using the system prepare user manuals for payroll process
procedures.
Organized data flow, testing, end-user training and developed system level test
procedure.
Environment: MF/COBOL CICS IBM3090 AS400 RDBMS(ORACLE 8)/UNIX SQL/SQR/SQA peoplesoft
peoplecode&Peopletools
ANICO
Mar 99Aug 99Sr. Programmer Analyst
Exported Views for user reports and trained plant engineers.
Maintained DB2/CICS databases for Information Systems and Human Resource department.
Conducted Y2K compatibilities/fixes and testing CICS programs using compuware
Hyperstation.
Designed internal and conceptual schemas and logical objects.
Set up backup procedures.
Performed extensive user contact and support systems.
Environment:IBM/DB2,390/AIX/RS6000/VSAM/IMS,COBOLII,CICS/JCL/SPF/PROCS,Endeavor,
Texaco INC
June 98 - Mar 99Database Analyst
Data Base Analysis/design/create for utility systems.
Support applications developers for RDBMS(DB2) using BMC utilities.
Ensure integrity and provide ongoing monitoring/tuning of application database
environments using Patrol.
Support application database changes and perform backup/recovery procedures.
Duties include developing the companys databases and design Schemas using SQL for the
manipulation of data.
Environment: RDBMS(DB2)/SQL BMC IBM TSO/SPF/FILEAID Office/NT Windows
Exxon Chemicals Dec 97 June 98
DBA
Maintain RDBMS DB2/IMS databases and Support daily/periodical production jobs.
Perform measurements and tuning Prepare monthly Graphs/histograms using NT Systems
Towards breakdowns by systems and run explain on production systems.
Work with user groups in creating/plan new tables for shipping systems
Involved in SPF/TELON/CICS Systems version updates. Coordinate
With users and systems personnel in testing and sending files to other areas using FTP.
Environment: MVS, RDBMS(DB2), IMS/DB/TELON/CICS, MS Project /Office, FTP,Windows-NT
Severn Trant Systems
Aug 96Dec 97
Client server conversion.
Data analysis/Map/design client server environment for utilities systems.
Conversion from DB2/VSAM files to ORACLE using MF COBOL on Unix.
Involved in data extract and data mapping data transfer using FTP. Maintain CICS
transactions.
Work with test team using SQA on Unix based Systems.
Environment: DB2/CICS WB MF/COBOL UNIX RDBMS(ORACLE 7.0) / PL/SQL.
Tenneco INC
Jan. 1996August 1996Analyst Consultant
(Technical)
(TBS) Responsibilities among many are as follows:
Helped on developing their High Level Designs to integrate their Payroll Divisions on
to a new Tenneco Division (TBS) migrating into a new payroll system application called
Integral. Create / Design DB2 new tables for systems requirements.
Create plans and binds for use. Other responsibilities include the writing of new
DB2/MF COBOL interface programs accessing the Integral Database.
Wrote JCL, unit and string testing the interfaces and moving of finished projects to
production.
Environment: Using MVS, MF/COBOL, DB2, CSP, TSO, INTEGRAL PAYROLL/HR, MS OFFICE and
VISIO, FTP.
HL&P Company
Apr 95 - Dec 95Programmer Analyst
New development/Part Conversion for Consolidated Revenue Accounting System using
DB2/APS/CICS/MF COBOL to Unix System using FTP .
Loaded VSAM data to various DB2 tables on-line Screens and batch programs using APS
(screen painter and APS/MF COBOL/WB) and reports by using Report Distribution Systems
Reports.
Maintain Industrial Commercial Billing System in DB2/VSAM/CICS/APS(on NT Client Server
Systems).
BFI Aug 94 Apr 95
Senior Programmer Analyst
Major modifications and enhancements were done for Security Reporting System for (On-
line/batch) entry and query using APS/DB2/CICS/PLI.
Used XPEDITOR for testing.
Worked with PLATINUM/SPUFI Fileaid. Implemented (RDS) Report Distribution System.
Involved in conversion with users and (Design/Code) for VMS/CMS Systems using
APS/DB2/PLI.
State of Texas -
Texas Department of Criminal Justice
(TDCJ ) Mar 94Aug 94Systems Support Analyst
Designed and developed on-line CICS programs as part of the Financial Systems for
Substance Abuse Master Plan Information Management System within the Texas Department of
Criminal Justice.
Intersolv's APS code Generator on Unix was used to generate all CICS online programs on
Client Server Flatforms. Walkthru system functions.
Development, testing and data manipulation was done using Microfocus Workbench,
including Animator(GUI).
Responsible for the installation of the SQL XDB/APS products and all database support
for the XDB/MFWB products on six PC workstations .
Installation and integration of the APS product, MF COBOL Workbench and the SQL XDB
product on NT Workstations and train users.
Reports were designed using APS Client/server environment used FTP for all transmittal
information.
SQL MF/Cobol RDBMS(XDB/DB2) Emulator Unix/NT.
Panhandle Eastern Corp. Aug92 Feb 94
Systems Analyst
Designed Physical/logical Sybase tables to Convert DB2 for Legal Systems to PC based
servers on LAN.
Enhanced Charge Back DB2/CICS COBOL II systems. Enhanced PIC (problem information
control) online CSP applications.
Tuning was done to increase response time in changing SQL calls and file access.
Developed and modified TBS (transportation & billing system) online CSP screens for
query nominations and allocation.
SPUFI & File Aide used to test data.
Created DB2 tables/views for Rate Refund System. Utilized BMC Software.
CSP screens for rate analysts' analysis and reports by PL/1 Systems measurement and
tuning was performed for more efficiency of Rate system by runstats, explain and optimize.
Data was normalized.
Maintained Gas security & SOS (standard online system), made program changes to FOCUS &
PL/1.
Exxon Aug 90 Aug 92
Sr. Systems Analyst
Performed feasibility studies, designed and developed online screens for ORAL (Oil
Revenue Accounting Lease) System using Screen Plus and DB2/SQL objects. Converted (IMS/DB)
PTC (pricing, taxing and costing) System to DB2 & PL/1.
Testing was done using QMF/SAS and was on production support for the above systems. DB2
tables & catalogs reorg by Bachman.
Prepared user manuals and systems documentation.
Union Carbide Inc
. June 89July 90DBA
Created data dictionary using Oracle CASE tools for Ethanol based systems.
Designed internal and conceptual schemas and logical objects.
Exported queries for user reports and trained plant engineers using SQL Plus on VAX
system using UNIX Operating System.
Maintained IMS/DB MMIS (Management Maintenance Information Systems) and HRP (Human
Resource Package) System utilizing PL/1 and CICS. Set up backup procedures.
Extensive user contact and support systems.
Texaco Chemicals Inc
. Dec 88June 89Systems Analyst
Converted COMPASS plant system (COBOL IMS/DB) to ORACLE Database.
Used SQL Plus for frontend software tool, which allows user to submit SQL and examined
the results used for the reports.
Reexecutable SQL is exported for future use.
Developed and implemented sub systems for Texaco International clients.
Reorg tables & Set up backups.
Amoco Exploration Group
Dec 87Dec 88Systems Consultant
Provided technical support for geologists and geophysicists in converting IMS/DB to
SQL/DS.
Performed seismic data analysis and well log analysis and developed data modeling.
Designed DB2 tables and indexed for well log data. Set up security on the tables.
Enhanced IMS/DB production jobs. Installed IWS system.
Testing was done using SAS/QMF.
Analysis, DFD's and design were done using Yourdon Methodology.
Involved complete systems life cycle including documentation.
Bally CorporationChicago
Jan 85Dec 87Support Analyst
Developed IMS/DBCICS entry and inquiry RPS Process System using Jackson Methodology.
Involved in OCR project, transmitting data to Burrow Systems.
Conducted user training and documentation.
Obtained user specifications and designed systems.
St. Joseph's Hospital
Dec 82Dec 84Programmer Analyst
Installation of EDS software for hospital Bills systems.
Maintained IMS/DB production systems.
Developed patientdoctor relational database using IMS/DB & PL/1.
Enhanced systems as required and needed by users.
CAN FINANCIAL CORPORATION
JUNE78 - DEC82Programmer Analyst
Maintained Life Actuarial Pension Valuation systems. Performed feasibility studies and
identified automation needs within the division. Provided specifications for systems
enhancements. Designed and developed pricing and claim history database IMS/DB. Maintained
CICS batch modules, program in PL/1 and using SDM770 Methodology, SAS. Installed EDS
software for hospital billing systems. Maintained IMS/DB PCBs and PSBs for the production
systems. Enhanced systems as required and needed by users.
JULY 1976
MAY 1978ANDHARA CHRISTIAN COLLEGE (INDIA) MATH LECTURER
Teach Modern Algebra Calculus/ Trigonometry Numerical Analysis for undergraduate classes.
Contact this candidate