SUMMARY

• Over 14 Years of IT experience in Software application development for various Industries.
• Have worked over 11 years in USA and 3 years in Asia-Pacific countries (India, Malaysia, Singapore and Hong Kong). Have Leaded the Team on various projects.
• Complete knowledge of the Software Development Life Cycle with timely delivery against aggressive deadlines.
• Developed various business application software-using ORACLE, DB2, Infranet Portal, SQL, PL/SQL, ETL, Pro*C, SQL*Loader, DEV 2000 (Forms & Reports), C, UNIX Shell Scripts, Sed, Awk and Perl.
• Extensive work experience in SQL and PL/SQL by writing Packages, Stored Procedures, Functions and Triggers.
• Experienced in Database Optimization by making use of various Performance Tuning techniques.
• Proficient in database and SQL tuning using HINTS, EXPLAIN PLAN and TKPROF.
• Involved in extensive SQL performance tuning for Oracle and DB2. Reduced the CPU processing time by half for many background jobs at Walgreens and Wachovia Securities.
• Experienced in Dynamic SQL, PL/SQL Collections, Oracle built-in packages and Exception handling.
• Extensively used Infranet Portal/Oracle BRM to manage the billing and payment process of the data usage. Used SimLoad utility for manipulation of the usage data into Infranet Portal.
• Thorough understanding of Data Warehouse Architecture and designing Star Schema, Fact & Dimensional tables and Relational Database Management.
• Assisted in Data Warehousing System using Informatica Power Center and supported transaction-creation process for Sales Information system.
• Expertise in Object Oriented Analysis & Design (OOAD) as per Rational Unified Process (RUP) & UML technology/Booch Methodology using Rational Rose and developing n-tier Client/Server and TUXEDO, CORBA & XML Middleware based on C, C++, STL, Java with back-end RDBMS using SQL, PL/SQL procedures.
• Proficient in WebSphereMQ (MQSeries). Sound technical knowledge of JDBC.
• Involved in the analysis, design and development of various systems in the Telecom and Pharmaceutical industries. Worked in new enhancement projects for Wireless Communications.
• Extensive knowledge of AMDOCS billing system in Telecom industry.
• Involved in the largest US Brokerage Conversion ever. Worked in Wachovia and A.G. Edwards merger project. Reengineered many business processes to accommodate the inbound data from A.G.Edwards.
• Provided 24x7 application maintenance support and on call production support in various clients.
• Extensively tested Java application (Shopping Cart - Avetti, Cross World Middleware) for the Virtual Gift Card to all the clients in JET LITHO COLORS.
• Working knowledge of ERP system - PRISM (Estimation, Quotation , Work Order creation, Purchase Order and Job Creation) for JET LITHO COLORS.
• Excellent communication skills, self motivated, fast learning capability, ability to handle assignments independently and as well as team, ability to talk with different client or group for resolving the problems.
• Received SHARED SUCCESS AWARD from WACHOVIA Securities and MVP from Jet Litho.

TECHNICAL SKILLS
Languages : C,C++,JAVA,SQL,PL/SQL,VC++ 4.5/5.0/6.0,COBOL,XML,HTML,
UNIX Shell Script (Ksh, Csh), Awk, Sed, Perl
Debugging Tools : Purify, Sun workshop
Operating Systems : UNIX (Sun Solaris, AIX 4.3), Linux, Windows-95/98/NT/7, Novell
Netware, Mainframe
Back End Systems : Oracle 11g/10g/9.x/8.x/7.x, DB2, Sybase, Infranet, SQL Server
Utilities : Pro*C, SQL*Loader, PL/SQL, ROGUEWAVE, PERSISTENCE,
SimLoad, UD32, Filezilla
Front End Tools : Informatica PowerCenter 7.1.4, Developer 2000 (Forms 4.5/3.0,
Reports 2.5/1.1), Power Builder, Business Objects
Web Technologies : JSP, JDBC, Applets, Servlets, Oracle Web Server
Servers : Web logic 5.1, Tomcat, Apache, Web Sphere
Transaction Monitor : Tuxedo, WebsphereMQ (MQSeries), CEM
Methodologies : UML Rational Rose 2000 using Grady Booch Methods
SCM Tools : Visual Source Safe, PVCS, SCCS, Clear Case, Clear Quest,
Cirrus, CM Synergy, Harvest, Subversion
Scheduling Tools : Autosys, Cron, CONTROL M, DPS Scheduler
Other Tools : ERWIN 4.0, Visio Professional 5.0, Test Director 6.0, Oracle
Application Express 6.1, UCT, UDT, Designer/2000, Toad,
Wosql, PL/SQL Developer, SQL Navigator, Clarify - Trouble
Ticketing system, MERCURY Quality Center 9.0, Service desk,
Bug Tracker
Software : Protobase (Credit Card Processing Software)

PROFESSIONAL EXPERIENCE

CLIENTS:

Confidential,IL – Senior Developer Feb 2010 – Till Date

• Involved in all phases of order fulfillment which includes FTPing the source file, creating order file, loading into card and ERP data bases, releasing the order to cage, scanning the order items, sending orders for activation and settlement and as the final step sending shipping reports to the client.
• Developed and documented the creation of standardized or customized reports for ERP system (PRISM) and batch jobs.
• Wrote many PERL scripts to generate daily, weekly and monthly order processing reports, activation reports and shipping reports for various clients such as Sprint, Benihana, Ra, Sushi, Morton’s, Blockbuster, STI (Sprint), Macys and TopGolf.
• Collaborates with end users to gather report requirements and ensure proper validation and testing.
• Rewrote the entire STI (sprint) process using PERL, Shell Script.
• Got a MVP award for implementing the batch process for Blockbuster in a week.
• Resolved the performance issues occurred during the batch processing which was bottleneck for the loyalty program in inserting the transaction into Prism ERP.
• Automated the valutec payment processing using PERL for TopGolf.
• Communicated with all the department managers to gather the requirement and Involved in design, development and implementation of JOB TICKET (BOM) for the PRODUCTION of physical card.
• Resolved many production issues such as PGP key issues, Shipping Report not copying in proper folder due to the permission issues, Oracle Upgrade, order errors, incorrect bundle/items assignment, order cancellation and reusing the bundle/item after cancellation.
• Modified the QC process for apple client and few customized Shell Scripts for Datacenter using Shell Script (ksh), AWK and Sed.
• Wrote few PL/SQL procedures and functions inside the main packages which is used to check the inventory availability and create orders.
• Wrote SQL *Loader and Shell Scripts to check the duplication of PIN numbers for all the clients.
• Modified and tested extensively Scanning Application which scans the individual item for B2C, B2B and B2S Customers.
• Sent and received XML documents from the payment processor like Cyber Source and PaymentTech.
• Tested and updated the scanner apps application in Visual C++, Oracle which is used

to scan the barcode of the individual items in the bundle or sleeve.
Environment: Oracle 11g/10g, SQL, PLSQL, SQL*Loader, Perl, Shell Script, AWK, Sed, PRISM ERP, Shopping Cart, Cross world Middleware, Web Services, XML, Java, JSF, JSP, Webapps, PWC script, XML, PRISM reports, Payment Processing: Cyber source, PaymentTech, Valutech, Linux, Windows NT/Windows 7, Tomcat Apache, Visual Studio 6.0, C++, TOAD, CRON, DPS scheduler

Confidential,IL – Senior Developer Jun 2009 – Feb 2010
E-Health Solutions:

• Created requirements and design documents for the e-prescription image project.
• Wrote a tuxedo service to archive the prescription images stored in the database as a CLOB data (XML document) into the imaging server.
• Created multiple instances of the tuxedo service to call the imaging server due to slow response time.
• Reengineered many batch jobs to improve the performance and processing time to meet the user requirements using SQL, PLSQL, C, Pro*C and UNIX Shell Script.
• Created adhoc report using Shell script, awk, sed to identify the error caused by the prescription document from source script.
• Performed Unit, Integration, Volume and System testing for those batch jobs.
• Discussed with users for the report verification in those batch jobs.

Environment: ORACLE 10g, SQL, PL/SQL, Pro*C, C, C++, TUXEDO, Centura, AIX, Windows NT, PLSQL Developer, SCCS, Shell Scripting, Cron, XML, Sed and Perl

Confidential,IL- Team Lead Mar 2008 – May 2009
Brokerage Data Management System - A.G. Edwards-Wachovia Integration:

• Acted as primary personnel for the Central File Distribution system.
• Effectively involved in Data Analysis, Design and Development of the ETL Process, Control tables, Shell Scripts and Reports.
• Responsible for delivering files using NDM, FTP, Copy scripts to various down stream systems and external customers.
• Responsible for validating the header data and record counts for the files received from the source system. Also identified and resolved any issues occurred during the transmission.
• Rewrote many processes using DB2, ORACLE SQL, PLSQL, Pro*C, UNIX Shell Script, AWK script, Perl and Sed for process improvements.
• Involved in Data Scalability for all extracts from data warehouse.
• Tuned many DB2 SQLs to improve performance. Created many SESSION tables to avoid creating temporary tables thus increased the performance.
• Created many indexes and added RUNSTATS in the required SQL extracts.
• Resolved frequently occurring production issues related to weekly and monthly jobs and tuned these jobs using tuning techniques.
• Tuned many ORACLE, DB2 SQLs identified by DBA’s in production. Worked closely with DBA to get approvals for critical SQLs which access more than 100 million reads.
• Reduced the processing time of many SQLs in the daily jobs by 4 hours by creating PARTITIONING KEY using hashing, INDEXES, RUNSTATS and using other techniques.
• Involved in different phases of MOCK testing for the merger project such as pre-mock, mock0, mock1 and mock2 and events like mini batch, financial, non-financial and money market.
• Tuned many PL/SQL reports for the data warehouse system.
• Modified many TUXEDO APIs using C and invoked those APIs in C++ modules.
• Created weekly/monthly status reports and submitted them to the project manager.
• Used MS Project to track all the project activities.

Environment: ORACLE 10g, DB2, SQL, PL/SQL, C, C++, TUXEDO, Shell Scripting (Ksh), AWK, Perl, Sed, Informatica Powercenter, Quality Center, Business Objects, Harvest 7.1, CONTROL-M, Windows XP, UNIX, Mainframe, SecureCRT, Toad

Confidential,IL- Senior Application Developer Jun 2007- Feb 2008
Data Warehouse System/AMDOCS billing system-CARES:

• Involved in writing high level design, functional design and detail level design for multiple projects – Out the Door Provisioning, Import Payment.
• Involved in Data modeling and created ER Diagram using Erwin tool.
• Designed and developed few reports – Tiered and Non-Tiered Data Usage report using SQL, PLSQL, JAVA, Ksh, Perl and AWK script.
• Exposed on designing, full testing cycle and developing new Infranet custom database using Perl, UNIX Shell Scripting, SQL and PL/SQL for new billing requirements.
• Worked in Infranet database that holds all usage data. During testing, used SimLoad utility for loading the usage data into the infranet database.
• Tuned many SQL scripts for better performance. Helped fixing SQL for performance team.
• Changed few TUXEDO services for adding new fields due to protobase upgrade (credit card processing software Upgrade). Masked additional sensitive data in the flat files during upgrade. Used UD32 utility for doing unit testing the TUXEDO services.
• Involved in testing payment, reconciliation and settlement processes. Used CARES online system for doing all type of payments.
• Involved in writing shell scripts for ETL process, Encryption and Decryption of Flat files using PGP.
• Wrote test plan and test cases in quality center for the magnetic stripe project. And documented the result in quality center.
• Used FML Debugger for finding the buffer value while doing the online transaction through CARES online.
• Worked in Payment Manager Tuxedo service which is core of all the payment activities.
• Involved in production support activities to solve the issue with payment manager using C++ and Pro*C.
• Leveraged the existing COBOL processes to find out the minimal changes needed for some of the requirements.
• Debugged the COBOL processes to trace the erroneous data and modified the input data to perform a smooth execution.
• Wrote few scripts for file download, file and record validation, formatting and distributing into different market using Ksh, SQL, AWK and Sed scripts.
• Involved in the design for number management project.
• Created weekly status reports and submitted to the PMO team.

Environment: ORACLE 9i, SQLServer, Infranet (PORTAL), ERWIN 4.0, PGP 6.0, SQL, PL/SQL, Pro*C, C, C++, Java, COBOL, TUXEDO, Shell Scripting (Ksh), AWK, Sed, Perl, SimLoad, UD32, MERCURY Quality Center 9.0 AIX, Windows NT, Mainframe, Toad, SCCS

Confidential,IL – Senior Developer Jan 2005-May 2007
Mail Service Facility -- PROMISE:

• Involved in writing design document for Customer Statement batch process. This process sends credit and debit customer statement report to each customer every month.
• Redesigned the critical table in ORACLE for PROMISE system. Removed the part of the key from that table. Changed few batch jobs due to table change.
• Rewrote three processes using SQL, PLSQL, Pro*C and UNIX Shell Script.
• Changed few TUXEDO services which is called from walgreensmail.com to allow the patient to be web registered. Involved in changing make file, build tuxedo server, link newly compiled server and creation of UD32 file for testing.
• Performed Unit, Integration, Volume and System testing for those batch jobs.
• Discussed with users for the report verification in those batch jobs.
• Performed code changes using C, C++ and Pro*C for batch jobs.
• Involved in coding by using UNIX shell script to call many batch jobs.
• Wrote many PLSQL programs for better performance. Used Explain Plan and tkprof.
• Tuned many oracle SQL to give quicker result set from the database.
• Changed eight batch processes for avoiding rollback segment error due to data volume increases.
• Reduced 40% of the processing time by tuning batch application.
• Interacted with many users for solving problems due to increase in data volume in PROMISE system.
• Documented all the process changes and verified with the Manager.

Environment: ORACLE 8/9i, SQL, PL/SQL, Pro*C, C, C++, TUXEDO, Centura, AIX, Windows NT, PLSQL Developer, SCCS, Shell Scripting, Cron, Sed and Perl

Confidential,IL – System Developer Nov 2003-Dec 2004
Billing System -- MILLENNIUM:

• Involved in writing design document for Contract Correction process.
• Created user interface screens for Contract Correction process using Forms 6i.
• Presented the newly created screens to the users (Backdating - changes in Contract Corrections, Order Entry).
• Changed the module in C, C++ and Pro*C for Pricing and invoicing modules. Used STL.
• Involved in the creation of invoice and customer reports using Reports 6i and Pro*C.
• Wrote Test Driver program to do unit testing of all C++ modules.
• Wrote SQL, PL/SQL, DB triggers and UNIX scripts (Shell, AWK, Sed and PERL).
• Wrote few TUXEDO services to do validation and to retrieve the data from oracle.
• Maintained tuxedo config files for CSRS billing system.
• Used TOAD to query the DB. Used PVCS for version control process.
• Created and executed test cases for Integration, Volume and User Acceptance Testing.
• Involved in performance tuning for pricing and invoicing module.
• Worked in PRODUCTION environment to solve the issues created by the users that involve talking with the users, understand the issues, code fixing, testing and meeting with production lead to promote the solution.
• Created release documents for all the projects, which is used by the release team. Responsible for solving the compilation errors encountered when the release team promotes the process to production.

Environment: C++, ORACLE, SQL, PL/SQL, TUXEDO, Forms 6i, Reports 6i, Pro*C, C, Perl,
Shell Scripting (Ksh), Sed, Awk, Windows NT, Autosys, HP, TOAD, PVCS

Confidential,MD – Developer Jan 2003 - Oct 2003
Trouble Management System:

• Involved in the design of the Reporting Server. Created backend jobs to receive the request from client and schedule the reports in different frequency. Performed coding in C++, Pro*C, PL/SQL and XML Dictionary. Request and Response has been done using CEM middleware.
• Was responsible for maintaining the server configuration files (config.par and process. par) for reporting server.
• Created ER Diagram using Erwin tool for Reporting Server and Inventory.
• Created CEM services (RetrieveUserCenterPermissions, UpdateUserCenterPermissions) for VRAS Trouble Management System.
• Worked on some production TRs. Fixed few codes for production issues.
• Designed a UNIX daemon process (RptFTPDaemon) in C++ and Pro*C. Used STL and POSIX.
• Created the make file for Reporting Server and Workforce Server.
• Was responsible for any changes in the Reporting Server.
• Involved in writing shell scripts using sed, awk for doing manipulation with files and database.
• Resolved memory leak in production issues using Purify.

Environment: C++, PL/SQL, Pro*C, C, Perl, Shell Scripting (Ksh), Sed, Awk, XML, CEM, Tuxedo,
Windows NT, Solaris, TOAD, CM Synergy

Confidential,OH – Senior Developer Aug 2001 - Nov 2002
Billing and Customer Care solution for Wireless Communication:

• Involved in Deposit Recommendation feature for Orange France telecom. Wrote Detail Level Design for Business Object and XML API’s for Finance Subsystem.
• Worked in Payment Processing for Finance Subsystem. Involved in validation and payment of Credit Card through Fifth Third Bank.
• Involved in changing the class diagram for all modification in Deposit Management Feature using Rational Rose.
• Extensively used STL and POSIX threads
• Involved in design and discussion about Message Queuing Techniques. Coded Pro*C programs to perform Message Queuing techniques for improving performance. Used Enqueue and Dequeue procedure in Oracle for Advanced Queue Technique.
• Designed a new P2K GUI window using Open Edit Tool. And modified some P2K GUI modules in Service Segmentation by Credit Class Feature for Prime Co client. Created few PL/SQL Packages and one Tuxedo transaction. Involved in Integration testing of this feature.
• Involved in Verizon conversion project. Developed the routines for functional specification using SQL, Procedure, Perl Script, Awk and Ksh. Handled effectively the offshore team of 4.
• Modified the modules for Default Password feature in P2K GUI Product using C++ and Rogue Wave functions. This is implemented for Sprint PCS.
• Modified the Sales Channel feature to include effective and expiration date in P2K GUI using OIT (Open Interface Toolkit). This feature is implemented for France Telecom.
• Introduced XML API’s for sales channel feature to interact with database. Created extension layer and integration layer for all operations like create, update, delete, get.
• Involved in Production Support activities for Verizon. Analyzed and worked in Inventory Order process. Involved in debugging many COBOL, SQL Scripts to fix the code.
• Was responsible for discussing with clients (SPRINT, VERIZON, and TRITON) to resolve the TR (Trouble Report) in Production.

Environment: Oracle, PL/SQL, Pro*C, C, Perl, Shell Scripting (Ksh), C++, XML, Tuxedo, CORBA,
Windows NT, Solaris, wosql

Confidential,CA – Team Lead Jun 2000 - Jun 2001
Network Management Services:

• Developed the routines for functional specification using PL/SQL, Pro*C, UNIX Shell Scripts and C++.
• Coded PL/SQL programs to perform audit control process and batch process on the above system as part of a release requirement.
• Coded Pro*C and C++ programs for the batch process, which helps to generate customer and distributor billing feeds.
• Created and modified many Tuxedo transactions for evaluate the customer and verify some attributes before creating feeds.
• Involved in web development using Java, JSP and Oracle Stored Procedures
• Used JDBC for manipulating the data between User Interface and Oracle Database.
• Supported various phases of project like System Integration Test, System Volume Test and User Acceptance Test.
• Managed the Migration of Oracle 7.3.4 to Oracle 8i for all the billing systems.
• Tested all the Subsystem to find any code changes needed for Oracle Upgrade.
• Responsible for analyzing all Defects, which is opened during various phases of project.
• Involved in Production Support activities and Team Lead for the support Team.

Environment: Oracle 8.1.5, PL/SQL, Pro*C, SQL*Loader, UNIX Shell Scripts, C++, Java, Tuxedo,
Web logic 5, Oracle Web Server, JSP, Forte, SunOS 5.6, Windows NT, Visio Professional 5.0, Test
Director 6.0, Version Control Tools - Clear case, Visual Source Safe and PVCS, Autosys, Toad and Clarify.

Confidential,Hong Kong – Developer Apr 1999-May 2000
Data Warehouse System

• Was responsible for defining user requirements, developing the dataflow diagrams, process models, entity relationship diagrams.
• Designed Staging, Transformation and Aggregation tables.
• Involved in data analysis, design, develop and Schedule ETL process in UNIX.
• Developed data extraction process using Unix Shell Scripts.
• Created validation programs using Pro*C for validate number of record and checksum.
• Developed data staging process using Shell Scripts to execute SQL*Loader scripts.
• Coded Stored procedures and functions using PL/SQL for data transformation process to ensure consistency and integrity.
• Developed PL/SQL routines for data aggregation process.
• Developed Pro*C routines for data distribution process.
• Prepared test plans and test data for all the modules.
• Executed unit and integrated testing of the module.
• Developed Unix Shell Scripts to run and test all the programs.
• Was responsible for analyzing the Defects

Environment: Oracle, DB2, Pro*c, SQL*Loader, PL/SQL, Shell Script, IBM RISC/6000, UNIX AIX
4.3, Mainframe, Oracle Express 6.1, Designer/2000, Star Schema Data Warehouse.

Confidential,Singapore – Developer Oct 1998 - Apr 1999
Custom Solution for Factory Planning System

• Gathered the functional requirements from the Users; prepared the functional specification and program specification.
• Developed the PL/SQL and PRO*C routines for custom solution process specification.
• Wrote PRO*C routines for the different modules as per the need by I2 team.
• Wrote Unix Shell Scripts, Perl Scripts for all custom solution.
• Developed UNIX scripts to use SQL*Loader.
• Helped the web deployment using Java, JDBC and Stored Procedures.
• Was responsible for generating Forms based GUI to run all custom solution in Forms 4.5.
• Involved in creation of user interface tool for this system and (BOM) Bills of Material.
• Unit testing of all the modules.
• Involved in Integration Test for the system.

Environment: Oracle, PL/SQL, Pro*C, SQL*Loader, UNIX Shell Scripts, Perl Scripts,
Developer 2000 (Forms 4.5), Java 2.0, Applets, Servlets, SunOS 5.6, Linux, Windows NT

OTHER EMPLOYMENT HISTORY:

• Confidential,Singapore – Developer Mar 1998-Sep 1998
• Confidential,Malaysia – Developer Jul 1997-Feb 1998
• Confidential,India May1996-May1997
• Confidential,India Feb 1995-Apr 1996

EDUCATION

• Bachelors in Computer Science and Engineering