Resume 15

Profile

• Has 7 years of wide range experience in the Information Technology industry. My strongest skills are in all phases of SDLC Software Development Life Cycle, User interaction, On-call and Help desk support of various applications developed in Oracle 9i/8i/8.0.5/7.3, Forms 6i/6.0/4.5, Reports 6i/6.0/3.0/2.5, PL/SQL, Oracle Web Server 4.0/3.0, C, Pro*C, SQL Forms 3.0, EDI Electronic Data Interchange , HP-UX, Sun O/S, AIX, Sco Unix and Windows NT environment.

• Having strong technical, written and communication skills.

• Strong experience with Telecommunications, Banking and Financial applications

Academic Background

• Master of Computer Applications from Andhra University, India 1992 - 95
• Bachelor of Computer Science from Nagarjuna University, India 1989 - 92

Technical Skills

• Hardwares: HP-9000 series, Sun Sparc Servers, RS-6000, Sco Open Servers, Dec Alpha, IBM PC Compatibles, Diebold ATMs

• O/S: HP-UX 11.0, Sun O/S 5.8, AIX 4.0/3.0, Sco Unix 5.05, Digital Unix, Windows NT/Me/00/98, Novell Netware 4.1

• Databases: Oracle 9i/8i/8.0.5/7.3.4/7.1.6, Sybase 11.9.2, SQL Server 2000/7.0/6.5

• Languages: PL/SQL, SQL*Plus, Pro*C, C, C++, EDI, HTML, Java, Perl, Shell Scrpting and MS-Excel

• Tools and utilities: OEM, TOAD, SVRMGR, SQL*Loader, EXP/IMP, TKPROF, EXPLAIN PLAN, SQL TRACE, RMAN, e*Gate, Net8

• Web Servers: Oracle Web Server

• Front end tools: Designer 6i, Developer 2000 Oracle Forms 4.5/5.0/6.0/6i, Reports 2.5/3.0/6.0/6I, Graphics 2.5 , SQL Forms 3.0, Power Builder and Visual Basic

• ETL Tool: Informatica 4.6

• Case Tools: Designer 2000, ERWIN

• Others: GXS AI Application Integrator , ATM Automated Teller Machine

Professional Experience:

Zwest is one of the telecom majors in US and sole local service provider in 14 states of United States. IMA system enables Co-providers like AT&T, MCI, Sprint, Ameritech etc. to access the Zwest Network for purchasing certain services on a wholesale basis and resell these services to their customers. IMA supports EDI and Java GUI.

Multi-mailbox is an EDI transaction tracking database which stores EDI inbound and outbound transactions. As Zwest implements multiple machines to accommodate production EDI transactions, multiple instances of EDIOPEN/GXS translator must also be implemented.

The purpose of this application is to determine which system received and processed a specific transaction, find the status for that specific transaction, ensure that the CLEC s functional acknowledgements inbound 997 for Zwest s outbound transactions will not return to the issuing translator making reconciliation more difficult.

• Analysis and design of the the complete system for Multi-mailbox
• Logical and Physical data modeling using Designer 2000 and Erwin
• Extensively used Oracle Web Server and PL/SQL for development of the system
• Created several SQL Plus reports and queries for IMA EDI users
• Developed many stored procedures, triggers, functions and packages used for the system
• Performance tuning of the application programs using EXPLAIN PLAN, TKPROF and SQL TRACE
• Implementation and support of the system and several third party applications
• 24X7 Production Support on a rotation basis
• Population of the datawarehouse tables using SQL*Loader
• Developed many scripts using perl and Ks
• scripting
• Developed test plans for system and Unit testing of some third party products Interactive agent, EDIHub and Recovery Manager
• Underwent the Corporate training for EDI mapping using GXS AI Application Integrator
• System and Regression testing of the Multimailbox

Environment: Oracle 9i/8i/8.0.5/7.x, Oracle Web Server 4.0/3.0,SQL, PL/SQL,Perl, HP-UX 11.0, AIX 4.0/3.0, Windows NT/2000, SQL Plus, Java, C, HTML, DHTML, ERWIN, Net8, OEM, GXS AI Application Integrator , EDI and TOAD

This project is installation, configuration and maintainence of EDI/GXS translator error monitoring processes. Once installed and configured these processes activity monitor data during EDI translation and 1. Capture EDI errors 2. Process and Report errors 3. Nightly maintenance routines and utilities 4. On going administration of the process. Errors are reported via a HP-Open View interface file. If HP-Open View is not used the Optional Email/Text page Alert processes may be configured to email or page predefined individuals when errors occur.

• Developed many stored procedures, triggers, functions and packages and implemented them successfully
• Coding using Pro*C and Ks
• Scripting
• Development using Oracle Forms and Reports for enhancements of EDI Translator
• Installation and configuration of the error monitoring processes on all EDI boxes
• Implementation, Maintenance and Trouble shooting of the project
• 24X7 on-call production support on a rotation basis
• System testing of the various utilities and programs

Environment: Oracle 8i/8.0.5/7.x, Forms 6.0/4.5, Reports 6.0/3.0/2.5, SQL, PL/SQL, C, Perl, HP-UX 11.0, Sun O/S 5.8, Windows NT, C, SQL Plus, RMAN, Net8, OEM, Sybase 11.9.2, GXS AI Application Integrator , EDI and TOAD

There are several third party products those will be taking care of verifying, transferring and archiving IMA-EDI data inbound and outbound transactions for ex: 850, 855, 860, 865, 997 etc between Zwest and it s CLECs Competitive Local Exchange Carriers . Interactive Agent, EDIHub, Recovery Manager, EDI and GXS translators are main applications used in IMA-EDI environment. These products are developed in PL/SQL, Oracle, Java, C, C++ and Unix shell scripting.

• Installation of Zwest third party products used in IMA-EDI
• Development of PL/SQL stored procedures, triggers, functions and packages
• Migration of existing applications from Forms 4.5 to 6.0 and Reports 2.5 to 3.0
• Created numerous wizards, forms and reports using Oracle Forms 6.0 and Reports 3.0
• Handling the networking problems with IMA-EDI Oracle databases
• Development of system and Unit test plans for several third party products Interactive Agent, EDIHub, Recovery Manager and GXS translators
• Performing system and unit testing of Interactive Agent, EDIHub, EDI and GXS Translators
• 24X7 on-call production support on a rotation basis
• Technical Documentation
• Unix scripting using Perl and Ksh
• Coordinating between vendors and client regarding the enhancements and bug-fixing of the new releases of IMA EDI products

Environment: Oracle 8i/8.0.5/7.x, Forms 6.0/4.5, Reports 3.0/2.5, SQL, PL/SQL, C, Perl, RS 6000,HP-UX 11.0, Sun O/S 5.7, RS 6000, Windows NT, C, C++, Java and SQL Server 6.5/7.0

Integrated Standard Banking System ISBS is a huge banking application, which deals with several areas of retail banking. It has several modules named Savings, Curent, Deposits, Loans ,ATM and foreign exchange transactions.

• Installation and configuration of Oracle Databases and Unix O/S
• Coding using Developer 2000 Oracle Forms and Reports as part of the enhancements
• Implementation and Maintenance of client applications
• Unix System Administration
• On-call and Helpdesk support
• Backup and recovery of the databases
• Writing several utilities using PL/SQL, Pro*C, SQL Plus and Shell scripting
• Customizing several MIS reports according to the client s requirements
• End user training

Environment : Oracle 8.0.5/7.3.4, PL/SQL, Pro*C, Developer 2000 Forms 4.5 and Reports 2.5 , Sun O/S 5.6, Sco Unix 5.05, SQL*Forms 3.0,Windows NT/98

ISBS 4.05 included a lot of enhancements and this is a migration project from ISBS 4.02 to 4.05.It has some new modules like ATM Automated Teller Machine and automation of Demand Draft s processing etc.

• Implementation of the ATM s
• Development using Oracle Forms 4.5 and Reports 3.0/2.5
• Unix System Administration and Shell scripting
• Implementation of the project which includes loading of new software, conversion processing and Y2K processing of entire data using several utilities
• Performance tuning of the application programs
• Coding and testing several utilities according to the requirements of several branches

Environment : Oracle 7.3.4, Pro*C, Sco Unix 5.05, Oracle Forms and Reports, SQL Forms 3.0,Windows NT/98

ISE Interconnected Stock Exchange has 15 centers all over the country and having the central office at Mumbai.Every member should have a current a/c pay-in and pay-out in any of the ISE 15 centers. Wherever the business is being done by the shareholders his/her account will be updated on-line and an advice will be sent to central office immediately.

• Implementation and maintenance of the project
• Database Administration
• Development using Pro*C, PL/SQL and Shell Scripting
• Customizing MIS reports and other utilities

Environment: Oracle 7.3.4, SQL Server 6.5, Forms 4.5, Reports 2.5, PL/SQL, Pro*C, Sco Unix 5.05, Windows NT/98

Branch Computerization is a project of converting the banking application softwares from Foxpro and COBOL to Oracle and Unix environment in several branches of the bank.

• Migration of applications from FoxPro and COBOL to Oracle and Unix
• Coding using Pro*C, SQL*Forms 3.0 and Shell Scripting
• Installation of ISBS software
• Maintenance of the new and existing products
• Migration of data
• End user training
• Applying patches regularly for the existing application softwares and Unix.
• Underwent corporate training on General Banking

Environment: Oracle 7.1.6, Pro*C, Sco Unix 5.04, Forms 3.0, Foxpro,COBOL and Windows 95

BPRO is a product developed for supporting the retail banking operations. Some of the modules are Savings, Curent, Clearing, Deposits and Loans.

• Analysis, design, coding and testing
• Implementation and maintenance of the product in client sites
• User interaction and getting the enhancement requirements

Environment: Powerbuilder 4.0/5.0, Sybase 11, LAN, Windows NT/95

Any NRSA employee can join NRSA CCS department by following certain procedures .A CCS member can be eligible for investing on Recurring and Fixed deposits and getting some kind of loans.This project is automation of entire NRSA CCS operations.

• Analysis of the requirements
• Design, coding and testing of the software
• Implementation of the software

Environment : Powerbuilder 3.0, Sybase 10, LAN, Novell NetWare