Project Software

Thiru Gundala

**** ****** ****** **, *** Arbor, MI 48108

734-***-**** (H); 734-***-****(M)

e-mail: *****@*******.***

[pic]

EXPERIENCE SUMMARY

A thorough IT Professional with over 15 years of experience in

Application/Business Software Development using a wide and versatile

software skill set gained while working on different domains of IT

industry. Experience includes working on age old Legacy systems such as

Honeywell Bull Mainframe with DOS/VSE as operating system to working on

sophisticated Financial planning and Consolidation tools such as

Outlooksoft (now know as SAP BPC). Extensively used various software and

Business Intelligence tools while working on projects related to various

domains such as Banking, Financial, Insurance, Retail and Manufacturing

Industries. Expertise includes working knowledge of Oracle 7.x to 11.i,

PL/SQL, ETL, Informatica8.5.1/8.6.1, UNIX, Linux, MVS, COBOL, PL/I, JAVA,

JCL, CICS, IMS (DB/DC), DB2 and VSAM. Have sound knowledge of all the

phases of Project Life Cycle viz. Analysis, Design, Coding and Testing

along with excellent skills of Debugging and Trouble Shooting. Has ability

to master new skills quickly. Excellent in interpersonal, communication and

writing skills and is capable to work well in team or individual

environments.

TECHNICAL SKILLS

Operating System : UNIX, LINUX, MVS, OS/390, OS/2 Wrap, DOS/VSE,

Windows 95/98/NT/2000/XP/7, MS DOS

Hardware : IBM ES 9000, Honeywell Bull Mainframe, IBM-3090, IBM ES-

9000,

Pentium PCs, DELL Laptops.

Languages : SQL, PL/SQL, UNIX Shell Scripting, C, C++, COBOL,

PL/I, BAL, Easytrieve +, JCL, JAVA and XML.

Tools & Utilities : Toad, Informatica, Fastload, Multiload,

Fastexport, Mercury Test Director, Quality Center, Cool-

Gen, TSO, ISPF, VSAM, QMF, SPUFI, Expeditor, File-

Aid, VSAM, Abend-Aid, Viasoft, REXX, MF-Revolve,

CA-Roscoe, MS Office and Visio.

HDBMS : Oracle 9i/8.x/7.x, Teradata v2r5 v2r6, Microsoft SQL

Server 6.5/7.0/2000,, DB2, Oracle 7.x, MS

Access

OLTP : CICS, IMS-DC, VB

KEY AREAS OF EXPERTISE

Functional Analysis

Excellent ability to perform independent preliminary analysis of user

requirements and develop effective solutions that satisfy user

requirements.

Software Development and Testing

Extensive experience in designing, developing, testing and implementing a

variety of IT applications in a number of different development,

operational, and industry environments.

Project Coordination

Proven ability to perform as a technical leader; training and directing

small to medium size project teams engaged in developing IT applications

for client organizations.

Software Maintenance and Support

Significant experience in performing day-to-day maintenance and support of

existing applications in parallel with the analysis, design, development

and co-ordination activities for new applications. Has experience of

working on 24/7 support for Business Intelligence, Mainframe and

Outlooksoft applications.

WORK EXPERIENCE

Sr.Programmer Analyst, IT - Business Intelligence, Borders Group Inc (2005-

present)

During my 5 years tenure at Borders I've worked on various projects on

different platforms including Mainframe as well as on Client-Server thus

gaining excellent expertise on cross platform installations. Some of the

responsibilities are listed here.

> Managing applications of the Business Intelligence Team that are

scattered on client/server and mainframe platforms.

> Developed and delivered numerous projects starting with gathering

functional data from end users thru designing technical specs and

culminating in developing, testing of the projects along with post

production support.

> Extensively used ETL tool Informatica to import and export data

between Oracle DB on Unix from/to DB2 on Mainframe.

> Gained extensive knowledge on various reporting tools such as Micro

strategy and Outlooksoft.

> Extensively used Informatica to create complex work flows by using

Work

flow manager to create various vendor data feeds. Data feeds would had

data that comes from DB2 tables on mainframe and Oracle tables on

Unix.

> Migrated from Informatica Power Center 8.5.1 to 8.6.1. Tested all

the perl scripts executing Informatica jobs when Development server

was moved from Windows based server to Linux server as part of

migration.

> Connected to Mainframe DB2 tables using ODBC connection and exchange

data from/to Mainframe with Oracle as the primary data base on

Informatica.

> Involved in design/development/test and implementation phases of

building E-commerce sales reporting module on Informatica when Borders

launched its website borders.com, moving away from Amazon.

> Built huge Data Dictionaries by following standards to have enough

information on each and every column/attribute of three different

systems

that would run on AS/400, Mainframe and Client/Server.

> 24/7 on-call support for critical Business Intelligence and Mainframe

Applications

> Trained many programmers to handle on-call issues during my 2 year

tenure here.

Environment: UNIX, MVS, Windows XP, Oracle 9i/11g.Toad, Sybase, DB2,

Informatica 8.5.1/8.6.1 TSO/ISPF, DB2, COBOL, Platinum, Cntl-M, FTP,

Syncsort, JCL,, Windows XP, MQ Series.

Programmer Analyst, JRD Systems, Inc (2001-2004)

As a free lance consultant for JRD systems, worked with reputable companies

across the country. A brief description of location, tenure and environment

are as follows:

. NISSAN Motors, Smyrna, TN Feb 2004 - Dec 2005

> Worked extensively on MVS, VSAM, JCL, COBOL, IMS, DB2, CICS, MQ-

Series, File-Aid and VIASOFT.

> Problem Tickets that had very severe bugs were analyzed and after

identifying the errors were fixed by me. Tried to resolve theses

issues once for all by giving a permanent solution to the

problem in most of the cases.

> Wrote new programs in COBOL and IMS that were part of a production

cycle to identify the employees whose Insurance's Renewal date is

due within next 3 month. Created detailed reports to help Users by

giving as much information as possible.

> Created various ENDEVOR packages with modified elements and moved them

into Production.

> Worked as 24/7 On- Call support during execution of critical

Production cycles.

> Modified CICS transactions that were abending due to data mismatch in

Databases.

> Successfully tested all these transactions and won appreciation from

Superiors and End-Users.

Environment: IBM-3090, TSO/ISPF, COBOL, VSAM, JCL, IMS, DB2, QMF, SPUFI

FOCUS, GEAC, Plus, ENDEVOR, VIASOFT, File- Aid and Abend-Aid, SAP MM.

. Cendant (Project Highway, 2003) Garden City, NY Jan 2003 - Dec 2003

> To study, analyze, understand and design the process for the merger of

AVIS and BUDGET with respect to FORD cars.

> Enhanced major online application of creating and modifying electronic

POs for FORD.

> Wrote numerous sub-modules to get various bits of information for FORD

in order to populate the main database (Purchase Order Database - POD)

with all required fields that would be required for smooth running of

batch jobs.

> Incorporated all the changes across a series of programs required to

call a sub-module dynamically as part of a transition in one of the

databases.

> Modified MFS panels to meet the required changes in Online system with

induction of FORD into the process and keeping them at par with the

functionalities provided for GM and Chrysler.

> Supported 24/7 during Production implementation and also worked

extensively in Post Production scenarios.

> Worked extensively on Warranty claims for FORD cars by keeping one to

one contact with IT division of FORD Manufacturing Company.

Environment: IBM-3090, TPX (VTAM), UNIX, TSO/ISPF, COBOL, VSAM, JCL,

IMS, DB2, QMF, SPUFI, Oracle7.x,UNIX, PL/SQL, ENDEVOR

. Pitney Bowes(USPS Rate Change 2002), Shelton, CT Feb 2002 -

Dec 2002

> Was involved in finding the details of Customers who were effected by

this rate change.

> Fixed a problem that was lying unnoticed for 3 years and bought a job

into Prod with expected results and actual results matching

completely.

> Wrote new BMPs (Batch Message Programs) to update an IMS database.

Input to these BMPs was coming from a Download Services file which had

details of Customers who would download the latest versions of

Software from the internet directly.

> Create numerous reports to extract Customer details based on the

requirements provided by Business Analysts.

> Changed the Billing Application completely and moved the modified jobs

to Production successfully.

> Moved many new and old jobs to Production and supported these

applications single-handed on a 24/7 round the clock basis.

> Enhanced many applications that were killing CPU time by changing the

code and modifying the JCLs to run them.

> Successfully reduced the time of Execution for many jobs by using JCL

utilities like SORT INCLUDE, IDCAMS, IEBGENER etc.,

Environment: IBM-3090, TSO/ISPF, COBOL, VSAM, JCL, IMS, DB2, QMF, SPUFI

FOCUS, GEAC, Plus, ENDEVOR, VIASOFT, File- Aid and Abend-Aid.

EDUCATION - TRAINING

- Bachelor, Mechanical Engineering, Osmania University, India, 1995.

- Business Planning & Consolidation (BPC previously known as Outlooksoft)

from SAP

- Numerous Seminars on Micro Strategy to learn efficient ways of

Reporting.

REFERENCES

Available upon request

Contact this candidate