SUMMARY:

• Over 15 years of direct/hands - on experience in the IT industry in US with proven track record of successfully implementing/delivering high quality custom and package software solutions within the established deadlines in the Mainframe, Unix/Client-Server and RDBMS-Oracle/DB2/Sysbase environment. Extensively worked as Analyst/Programmer and Technical Team-Lead for various projects; monitored progresses of team/members’ work, assisting programmers in finishing their tasks and resolving technical/design issues; status review/reporting and QA tasks. Used System Management Methodology and worked through full system development life cycle/SDLC. Strong problem solving, multitasking and interpersonal skills; team-oriented and adjust to changing priorities and provide end-user support.
• Involved, at Confidential, in implementing Oracle ERP e-Business suite-11i (Financials/PSB-Budget) which involves application configuration / writing Interfaces to integrate with other legacy Lawson applications. Completed Oracle ERP e-Business suite on GL/PSB-Budget. Also Involved in analyzing system requirements, designing, heavy client interaction for technical/functional aspects of the project; writing technical/program specifications, and extensive programming for different functional areas -Customer Information System GL-AR /AP, PSB, Payroll for Utility, Healthcare, School systems.
• Designed database, monitored standards, procedures, and integration of systems through database design. Developed expertise on RDBMS, SQL, Stored Procedure. Performed Unix admin/Sybase DBA role to support PWC’s development center.
• Development/Programming: Extensive/hands-on programming experience for over 15 years. Wrote complex and critical programs/SQLs of the applications and interfaces/ solutions for integrating 3rd party software with legacy system. Possess strong programming skill and enjoy doing this by applying creativity. Wrote a ‘Program Generator’ that generates COBOL program for on-line data/file maintenance purpose using MS/PC Cobol. Extensively worked on:
• Oracle ERP E-Business suite 11i - PL/SQLs for writing various interfaces for Financial (GL)/ PSB-Budget
• Client-Server - PowerBuilder with Unix/Oracle, Sybase, DB2 and Stored Procedure / Oracle PL/SQL
• Mainframe - DB2, COBOL-II, SAS/Macro, CICS RPC, ADABAS; MVS/Open MV
• Web - Involved in Developing Technical Data Quality publishing module using webMethods, HTML, XML, DB2/UDB
• Extraction /transformation/Loading (ETL) of data using multi platform based databases (DB2, UDB, Sybase)
• Report writing Tools: Discoverer 10g and Oracle BI Publisher (10.x) with Oracle Reports Developer

TECHNICAL SKILLS:

Technology and Tools: Software/Database/Languages Oracle ERP E - Business 11i: PSB Budget/GL(2years) PL/SQL, Stored Procedures (4 years) UNIX, Shell script -Other Knowledge- HTML, XML COBOL/COBOL-II (10+ years) Oracle-10i (4 Years) Sybase (4+ years) JavaScript CICS RPC with DB2 (5 years) DB2 (7+ years) UDB Portal-Epicentric PowerBuilder w/Sybase,DB2 (4 years) webMethods, SAS/Macro Oracle WorkFlow UniBasic/Unidata/Universe/Pick(3yrs) VB .NET/Visual Studio .Net Lawson(HR) Tools/Utilities/Middleware Discoverer 10g, Oracle BI Publisher TOAD, ADI, Data loader, FTP Fileaid, DataXpert, Xpediter TSO/ISPF, SPUFI, JCL/PROC NetGateway / Direct Connect QMF, DB Artisan (Sybase) CA-Endeavor, Panvalet, PVCS ETL-DataStage / Ascential, MS Project/PPT/Excel Visio Hardware/OS IBM Mainframe 9000 Srs, 3090 SUN Solaris/Unix IBM AIX/Unix, Windows/NT - Open/MVS-ESA, OS/390, VM-XA HP 10.xx HP-UX/Unix Data General-Aos, Prime-Primos

PROFESSIONAL EXPERIENCE:

Confidential, Maryland

Responsibilities:

• Working as Application Developer and involved in developing/maintaining PowerBuilder/Oracle based budget application, writing interfaces to integrate with GL and Payroll systems. Provide technical and functional support to budget specialists/ end-users. Developed various interfaces for other systems.
• Closely work with budget specialists to gather /analyze their functional/business requirements, current data source, and translate business needs into technical requirements and accordingly, build/provide appropriate system solution ((Data analysis / Financial monitoring report etc).
• Involved in implementing/maintaining Oracle ERP e-Business suite (Financials/PSB-Budget), which involves application configuration, writing Interfaces using PL/SQL to integrate with other existing applications, Data Conversion and creating complex custom views/reports.
• Developed a budget monitoring system using VB .NET/Visual Studio .Net. The system uses OracleConnection to get data from three different oracle database based applications/systems. A single parameter (e.g. GL Account number) is used to gather data from Oracle ERP/GL, Lawson Payroll and Budget Application (BMA) Databases and present relevant data on the same screen in three separate blocks/DataGrids (for each application’s data). Also, it has a feature to compare data between different databases and provide variance analysis. Result from the each Data Grid can be exported to an XLS/ worksheet file. Execution of SQL and oracle-PL/SQL stored procedures have been utilized in this budget monitoring system. This helps user to inquire/view data from three systems in one place, instead of logging in to three different applications.
• Also responsible to Validate budget data (across the systems) and load budget into Lawson Payroll and Oracle ERP/GL systems using various interfaces/SQL scripts.

Environment: Oracle/ERP e-Business suite, PL/SQL, PowerBuilder, Lawson, SAS/Macro, Unix, Mainframe and various tools (ADI, Data loader, TOAD), VB .NET/Visual Studio .Net

Confidential, VA

Responsibilities:

• Worked as Technical Analyst (Consultant) and Involved in Designing /Developing for Confidential 's Corporate Data Warehouse/Integrated Operational Data Store group (CDW/IODS).
• Also involved in Extraction /Transformation/Loading (ETL work) of data using multi platform based databases (DB2, UDB, Sybase) and Data Stage (Ascential)/Stored Procedure, SAS/Macro, COBOL-II - to convert Loans from Legacy system to Integrated Operational Data Stores in order to Project Enterprise (PE system) use this loan data as needed.
• Developed Confidential 's Web based Technical Data Quality reporting module using webMethods, HTML, XML (with XML/configuration file for connectivity parameters for multi-platform databases/Ftp…), DB2/UDB, Unix

Environment: SAS/Macro, webMethods, COBOL-II, DB2, Unix/UDB, DataStage/Ascential and various tools (SPUFI, JCL/PROC/Runbook, MCM/Harvest, Fileaid, QMF, XML Formatter), HTML, XML, Direct Connect…

Confidential (MD)

Responsibilities:

• Worked as Analyst/Programmer) and Involved in Developing FLASH Reengineering & revenue reporting system.
• Extensively involved in writing complex Programs/back-end processing using COBOL-II, DB2.
• In conjunction with Analysis/Programming task, involved in an effort to extract data from an existing system (form different sources - FOCUS, DB2, GDG/Tape back-up...), and loading into a DB2 database. This involved writing of programs to apply other pertinent information from other DB2 tables, conversion of Revenue/Charge code using old-new matrix and other mainframe load utility/tools as needed.

Environment: IBM Mainframe/MVS/OS-390: DB2, COBOL-II, TSO/ISPF, SPUFI, VSAM, JCL/PROC, Fileaid, QMF.

Confidential, Maryland

Principal consultant

Responsibilities:

• Directly involved in developing and implementing PWC’s Client/Server based proprietary CIS software/product ‘S2K/CS’. This product was developed using 3-Tier Architecture.
• Worked both as Analyst/Programmer; team-leader and closely worked with client management/users (JAD sessions) for successful development and implementation of the application.
• Designed and coded GUI front-end user panels/screens using PowerBuilder & Unix/Sybase & Mainframe - DB2/CICS RPC/COBOL-II/Adabas. Coded Stored Procedures. Gained experience in the client/server technology based application development area through hands-on involvement.
• Extensively involved in writing complex Batch Programs/back-end processing and CICS RPC using COBOL-II, DB2.
• Involved in requirement analysis, system and database design, writing program specifications and test conditions/testing.
• MIS reporting by doing research/data analysis on the different platforms/DBMS and presenting data in one report.
• Used tools like Expediter (batch Cobol), ViaSoft (CICS), FileAid, Spufi, QMF in coding, debugging and testing cycles.
• Used Structured System Management Methodology and worked through full system development life cycle (SDLC) of different modules, including client acceptance testing.
• Monitored progresses of team members’ work, assisted programmers in finishing their tasks and resolving technical/design issues. Involved in status review/reporting and QA/Code review tasks.
• Provided technical support and mentoring for less senior members of the team.
• Pro-actively involved in resolving potential issues, risks and dependencies for projects; interacted with clients/internal stakeholders to resolve reporting issues.
• Involved in a WEB based pilot project to capture meter reading data, to be entered by customers, with required validations /update using HTML/JavaScript to access PowerBuilder User Objects/Function and in-turn used Sybase NetGateway/DirectConnect to execute CIS’s CICS/DB2 RPC on the mainframe to update required tables. This was done to in corporate Web features in to CIS’s 3-Tier architecture and to use existing functionality of the application.
• Created PowerBuilder executable for distributing on the desktop/client machine.
• (Received recognition from the Firm and Clients for successful delivery of work product on time, and effective customer management and team management.)

Environment: DB2, COBOL-II, CICS RPC, PowerBuilder, Sybase, Stored Procedures, Adabas, Unix Shell/scriptTSO/ISPF, SPUFI, ISQL, VSAM, JCL/PROC, CA-Endevor, PVCS, QMF, Platinum (Data Load/Unload/RI), Fileaid, Xpediter, Viasoft/cics, DB Artisan (Sybase DBA tools) ;IBM Mainframe/MVS/Open MVS, Unix: HP/UX, Sun/Solaris, Windows/NT

Confidential

Responsibilities:

• Involved in developing and implementing PWC’s Client/Server based CIS software.
• Worked as Analyst/Programmer and later with team-lead responsibility. Closely worked with client management/users (JAD sessions) for successful development and implementation of the application.
• Designed and coded GUI front-end user panels/screens using PowerBuilder & Unix/Sybase & Mainframe - DB2/CICS RPC/COBOL-II, Coded Stored Procedures. Gained experience in the client/server technology based application development area through direct/hands-on involvement.
• Extensively involved in writing complex Batch Programs/back-end processing and RPC using COBOL-II, DB2, CICS.
• Involved in requirement analysis, system and database design, writing program specifications and test conditions/testing.
• Used tools like, PowerBuilder Debugger, Expediter (for batch Cobol), ViaSoft (for CICS), FileAid, Spufi, QMF…
• Used Structured System Management Methodology and worked through full system development life cycle (SDLC)
• Wrote the Pilot/Cobol program of this project to read/update DB2 and Sybase table/data using Open MVS and later, this program was used as model/standard for MIS reporting purpose when data needed from the multiple platforms/DBMS.
• Assisted programmers in finishing their tasks and resolving technical/design issues within established deadline.
• Provided technical support and involved in mentoring for less senior members of the team.

Environment: DB2, COBOL-II, CICS RPC, PowerBuilder, Sybase, Stored Procedures, Unix Shell/scriptTSO/ISPF, SPUFI, ISQL, VSAM, JCL/PROC, CA-Endevor, PVCS, QMF, Platinum (Data Load/Unload/RI), Fileaid, Xpediter, Viasoft/cics, DB Artisan. IBM Mainframe/MVS/Open MVS, Unix: HP/UX, Sun/Solaris, Windows/NT

Confidential, South Carolina

Responsibilities:

• Designed the Interface/integration process for Confidential 's billing system with other vendor's billing system - BillGen.. BillGen (Runs on ORACLE) computes the consumption-based charges for Industrial accounts. However, the existing billing system will only capture BillGen’s consumption based charges information, and apply other applicable fixed factors/charges and taxes to produce the net amount through its existing complex CIS billing system (Runs on DB2/COBOL-II ).
• The interface/integration design ensured that the changes in the existing system will be minimal and used XML for sending/receiving data between the systems. Also involved in CIS-S2K/CS development work for Confidential . Wrote detailed interface/program specification and system testing and implementation strategy. (*also worked on CIS for Confidential before)

Environment: COBOL-II, CICS RPC, DB2, Oracle, Sybase, PowerBuilder, XML, IBM Mainframe, HP-UX, Windows/NT

Confidential

Responsibilities:

• Involved in setting up PWC's Software Development and Support center. This includes installation and maintenance of Sybase System 11 SQL Servers, NetGateway Server/Direct Connect, set-up the connectivity (Power Builder/Workstation -- Sybase/Unix-- Mainframe/COBOL-II/CICS/DB2).
• Installed/maintained Replication Server to replicate data across the Sybase Servers, Sybase to DB2 and DB2 to Sybase. Created PowerBuilder executable for distributing on the desktop/client machine. Provided application / technical support for development team/customer.
• Created various Unix/Perl scripts for maintaining the system environment and to perform day-to-day system administration activities. Implemented disk concatenation, disk mirroring, system upgrading (new version) and expansion of file systems (root and others) on Sun/Solaris system.

Confidential, Maryland

Responsibilities:

• Worked as Analyst-Programmer to design and develop complex brokerage system and credit control management system. The brokerage is calculated for individual broker, group and broker within a group using group level criteria.
• This application also maintains delinquent accounts for non-payment situations and generates multiple notices as appropriate. Also, involved in migration work of PICK/INFORMATION based Healthcare applications to UNIX based-UNIDATA/UNIVERSE environment and involved in enhancement of its legacy system.

Environment: Unidata/Universe, UniBasic, Cobol, Unix-Sun/Solaris, IBM RS/6000 - AIX/Unix

Confidential, Virginia

Responsibilities:

• Worked as Analyst-Programmer in Designing, developing and implementing TMS and RMS software
• Wrote new Batch and Online Programs using REXX/REXXCUA, RDBMS-SQL/DS.
• Involved in Unit testing, Integration testing and Implementation. Involved in code walk through and reviews.

Environment: IBM Mainframe 3090, VM-XA/CMS, REXX/REXXCUA, SQL/DS, and QMF.

Confidential

Responsibilities:

• Worked as Technical team-lead/Analyst-Programmer for the implementation of a complex billing and sales accounting/AR/SO system with required interfaces for the GL system.. Directly involved in system design, design work presentation to client, programming, implementation and customer and post implementation support.
• Designed/coded Online forms/screen and other complex back-end program using UNIX/INGRESS, ABF/4GL.
• Ingress is used for database connections, tables and Ingress Report Writer for generating MIS reports.

Environment: The application was developed using UNIX/INGRESS, ABF/4GL,and Report Writer.

Confidential

Responsibilities:

• Worked as Technical team-lead/Analyst-Programmer for the implementation of a Financial accounting system
• Designed/developed and implemented Financial modules - GL, AR, AP - Which also includes the functionality to maintain data integrity between the subsystems & GL system by building interfaces, and generating various MIS/Statutory reports.

Environment: DBMS-Information (Unidata) /InfoBasic / PRIMOS, COBOL

Confidential

Responsibilities:

• Worked as Analyst-Programmer. Involved in designing and writing complex programs for payroll application for a large Railway Company using Mainframe (9xxx), MVS-ESA/TSO, DB2/COBOL-II/VSAM and Millennium for generating reports. Assisted team members to finish their assigned tasks in order to achieve project deadline for the team. Provided post implementation/customer support in the application and technical areas.

Environment: IBM Mainframe, MVS-ESA/TSO, DB2/COBOL-II/VSAM and Millennium