SUMMARY 
17+ years of experience in designing, executing, implementing and maintenance of medium to large scale projects. Well versed in industry standard software life cycles, methodologies, quality procedures and has worked across multiple geographies.

• Excellent track record in Applications Implementation, Production Support and Release Management
• Expertise in the areas of Application Development using PowerBuilder, Oracle PL/SQL, VC++, Backend processing, Scheduling batch programs, troubleshooting and monitoring Interfaces.
• Experienced in doing estimation and prioritization of user requests.
• Proven track record in System Design and Database Design of Application systems.
• Extensive coding in PL/SQL and very strong in performance tuning and database design expert level Oracle 11g,9i, 8i, /7.x
• Expertise in writing Packages, Functions, Triggers using PL/SQL and scripting in SQL.
• Documented coding as per coding standards for easy maintenance
• Experienced in doing code review, UTC review and peer testing
• Done user documentation and application coding, build and release processes for various clients.
• Experience in creating Entity Relationship Diagram using VISIO and TOAD
• Well versed with ITIL processes using Remedy 7.0. Managed Change requests and Incidents using Remedy.
• Well versed in MS Office Suite (SharePoint, Outlook, Word, Excel, PowerPoint)
• Functional knowledge in Financial Accounting, Invoicing, Order Processing, Export documentation, Trade Finance, Securities trading and Fund Manager.
• Can speak EDI language and have good knowledge of EDI message sets 856,810,304,310,315 & 404.
• Strong technical, analytical, problem solving, communication, and documentation skills.
• Good Knowledge of retail concepts and got certified in “Masters in Precision Retailing Program” from Santa Clara University. .
• Completed SAP-FI configuration training.

SKILLS:
Hardware: IBM-PC Compatibles, HP-UNIX
OP Systems: MS DOS, SCO-UNIX, MS Windows, Novell NetWare.
Languages: C, C++, COBOL, Pascal, FORTRAN, Basic.
Front-Ends: PowerBuilder 5.0/6.0/6.5/7/12, Visual Basic 6.0, VC++ 10.0
ERP: SAP R/3 4.6C, ECC 6.0
DBMS: FoxPro 2.X, FoxBASE+
RDBMS: Oracle 11g\\9i/8i/7.X, MS Access., SQL Server2008
Version Control: PVCS 6.0, VSS.
Modeling: VISIO
Data Base Tools: TOAD, SQLPLUS, PB DB administration
Testing: Rational Robot
Project Mgmt Software: MS PROJECT,IPAT, Ecube, Clarity
Other Tools: Crystal Reports, BRIO, Remedy V 7.0, Citrix Client, JBOSS, Live Meeting, Net meeting, Office XP, Telnet, PC Anywhere, Share point, USD

EDUCATION:

Master of Computer Application (MCA)

Bachelor of Business Administration (BBA)

PROJECTS:

Confidential, Memphis, TN. US 
Sr. Programmer/ Analyst

Confidential is the Order Entry and Invoicing and Materials Receiving system used by the recycling business of International Papers. OEI part of the application is used to maintain customer, supplier, plant, brokerage, grade and pricing information. OEI is used to enter and monitor customer orders, order information and shipment information. OEI is also used to Invoice completed customer orders for billing and sent to SAP A/R system. OEI also generates Voucher payments to suppliers for invoiced orders/services. OEI also consolidates and post the G/L, JVs and SKFs during the month-end to SAP system. MRS part of the application is used to capture the receiving activity of materials and to maintain supplier, location specific basic information, grade and pricing. MRS is also used to Raise and post the payment vouchers to suppliers. MRS is used to invoice for services provided to the supplier and the invoice information is transmitted to SAP A/R system. MRS also transfers data from Scale workstation to Central database thru scheduled batch programs. MRS consolidates and posts the G/L, JVs and SKFs during the month-end to SAP.

This application has been programmed using PowerBuilder 10.0, the EDI interfaces has been developed using VC ++ 6.0 and the database is Oracle 11g. The application has Development/QA and Production Environments. In the production the application is installed in 3 Load balancing Citrix terminal servers and published in the Citrix apps portal.

Contributions:

• Developed month-end batch programs in PL/SQL and automated the process by scheduling the batch programs in windows scheduler.
• Developed a watch dog program to check the status of scale PCs in all plants and send out a report thru e-mail to stakeholders daily at 3AM.
• Done monitoring of batch programs and troubleshooting problems reported by users.
• Developed queries in PL/SQL for adhoc customized reports from users on a daily basis.
• Participated in the planning activities for application upgrade to PB12.5
• Done pilot migration of the application and provided estimates for the PB12.5 upgrade.
• Developed and configured separate application interface instances for Mill divestiture project using VC++.
• Updated the DR test plan
• Done analysis on the usage of CORP IDs and submitted the report to business
• Active participant in all key project meetings
• Tracked change requests, bug fix requests and monitored incidents using USD (Unicenter Service Desk).
• Maintained all Project related documents using Share point

Environment: PowerBuilder 10, PL/SQL, Oracle 11g, VC++ 6.0. The Application is installed in 3 load balanced Citrix terminal WIN2003 servers. The application is accessed by the user using Citrix application portal.

Confidential, SC. US 
Technical Lead/Analyst

Confidential is used by the pulp business of Domtar. CONFIDENTIAL is the order processing, shipment tracking and invoicing system for pulp business. Orders are entered into CONFIDENTIAL and are priced using the system’s pricing functions. All mills except Dryden will have the electronic data exchange between CONFIDENTIAL and the mill production system. When the mill ships against an order, CONFIDENTIAL will receive the actual shipment information electronically through EDI 856 document. The EDI 856 document is processed and the actual shipment information is updated in CONFIDENTIAL and shipment is marked as SHIPPED. The shipped orders are then invoiced to the customer using CONFIDENTIAL\'s Invoicing module. Once the invoice is RECORDED in CONFIDENTIAL it is sent to corporate A/R system for collections. The system also pays ocean freight and truck and rail freight transmitting the freight information to corporate A/P system once in a day through a scheduled batch process. It is the charter of CONFIDENTIAL to be the system of record for all revenue and expense items associated with sales, down to the net sales line, and including sales agent commissions. For this reason, CONFIDENTIAL is used to book month-end numbers for Net Sales, freight, commissions and rebates. This information is used as a historical and statistical database to analyze sales, pricing and cost trends over time.
This application has been programmed using PowerBuilder 12.0, the EDI interfaces has been developed using VC ++ 10.0 and the database is Oracle 11g. The application has Development/QA and Production Environments. In the production the application is installed in 3 Load balancing Citrix terminal servers and published in the Citrix apps portal.

Contributions:

• Done analysis and prepared Business requirement documents for finance related enhancements like Canadian tax implementation, Automating Domestic Invoicing, Automating e-mail and fax capabilities for Invoicing and Canadian Legal Entity Merge projects.
• Done data modeling and design for major enhancements using Visio and TOAD
• Used SQLPLUS, TOAD to create, modify, run and test the PL/SQL blocks, dynamic SQL, database functions, stored procedures and packages
• Designed and developed the package for processing shipments in batch
• Automated the domestic invoice creation package using PL/SQL procedures.
• Wrote the transaction alert package to notify users via e-mail regarding completion of a transaction or reminders for completing a transaction on time.
• Developed the complex Domestic Freight Payment procedure in PL/SQL independently.
• Done database Design for complex and major enhancements using Oracle PL/SQL, PowerBuilder, and VC++
• Prepared Test scripts and data creation
• Documented Test plans and coordinated QA and UAT testing for major application releases
• Documented and executed cutover plans for major application releases and sub projects.
• Done application release management and production support especially for financial transactions interfaces between CONFIDENTIAL and the financial systems of SAP P90 and SAP R14.
• Tracked change requests, bug fix requests and monitored incidents using Remedy.
• Maintained all Project related documents using Share point

Environment: PowerBuilder 12, PL/SQL, Oracle 11g, VC++ 10.0, Crystal Reports. The Application is installed in 3 load balanced Citrix terminal WIN2003 servers. The application is accessed by the user using Citrix application portal. There are 2 applications services which was developed using VC++ runs on the WIN2003 server for processing the inbound and outbound EDI files.

Confidential, SC. US 
Technical Lead

Confidential is used by the pulp business of Domtar. CONFIDENTIAL is the order processing, shipment tracking and invoicing system for pulp business. Based on recent IT planning workshops with the business, it was agreed CONFIDENTIAL is a mission critical application for the Pulp business and as such the system should not be out of support. This application was originally programmed with out of support PowerBuilder 7.0/Oracle9i and VC++6.0. Thru this project the application has been upgraded using PowerBuilder 12.0, the EDI interfaces upgraded using VC ++ 10.0 and the database upgraded to Oracle 11g. The database and application servers were migrated to new Windows2003 servers

Contributions:

• Documented the approach for migration
• Coordinated with the DBAs during migration of Database from Oracle 9i to Oracle 11g
• Validated the database post migration
• Wrote PL/SQL scripts to update the system parameters post migration
• Wrote PL/SQL scripts to initialize data for new foundation tables
• Done Migration of the application and fixed the migration errors
• Retrofitted the changes made on the legacy system
• Lead the Regression, UAT and Integration testing efforts.
• Lead the volume and stress testing efforts.
• Done EDI configuration on the new servers
• Planned and executed the cutover and provided post cutover support to production.
• Prepared the interface diagram for the PROD, TEST/DR and DEV environment using MS VISIO

Environment: PowerBuilder 12, PL/SQL, Oracle 11g, VC++ 10.0. The Application is installed in 3 load balanced Citrix terminal WIN2003 servers. The application is accessed by the user using Citrix application portal. There are 2 applications services which was developed using VC++ runs on the WIN2003 server for processing the inbound and outbound EDI files.

Confidential, WA. US 
Project Manager (Offshore) Jan2005 to July2007 
Onsite coordinator May2002 to Jan2005 Module Leader (Offshore) June2001 to May2002

System2000 is a client server application used by PULP business of Weyerhaeuser. Orders are entered into System2000 at the zone offices and are priced and allocated. When an order is accepted in the system, it is transmitted to the appropriate mill for production or picking from inventory using the Oracle data exchange process which runs every 5 minutes. When the mill ships against an order, System2000 is notified via an electronic shipment notice (EDI 856 transaction). Shipped orders are then invoiced to the customer and a record of the invoice is forwarded to the corporate A/R system for collections. The system also pays ocean freight and truck and rail freight by forwarding a transmittal to the corporate A/P system.

Mill2000 application is being used by the Cosmopolis mill personnel to create production and package details of the cellulose fiber shipped to the customer against the orders received from System2000 application through a database exchange program. Mill2000 is also used by the Quality Analysts to enter the test details on the productions runs. The system has provisions for Inventory management. The Load Browse module is used to maintain load details. When the loading of packages onto the truck is complete the system generates an EDI 856 and transmits to System2000 for invoicing.

Contributions:

• Done database Design for major application enhancements like Willamette Integration, Common Operating Environment migration, EDI Integration, Customer Relationship Management including online and offline versions. I was involved in end to end development of these enhancements.
• Done requirement gathering, analysis, functional design, database design for the facelift enhancement called CRM (Customer Relationship Management). Written program specifications, integration testing and implemented CRM.
• Enhanced the system security procedures and functions in PL/SQL as per SOX recommendations.
• Used SQLPLUS, TOAD to create, modify, run and test the PL/SQL blocks, dynamic SQL, database functions, stored procedures and packages
• Optimized report generation in the application to improve performance.
• Done code review and test case review of fellow developers
• Participated and lead the COE migration of application servers.
• Done production support to keep the system live and running. Accepted and resolved help desk tickets in quick time.
• Prepared the cutover plan and executed it successfully for the EDI traffic conversion to a new WAN (Wide Area Network).
• Updated EDI specifications and provided production support for transactions sets EDI 856,810,304,310,315, 857,404,998 and 997.
• Designed and developed the Report consolidation project. Provide access and master select criteria for all the reports in one place.

Environment: PowerBuilder 7, PL/SQL, Oracle 9i, VC++ 6.0, BRIO. The Application is installed in 2 load balanced Citrix terminal WIN2000 servers. The application is accessed by the user using Citrix application portal. There are 2 applications services which was developed using VC++ runs on the WIN2000 server for processing the inbound and outbound EDI files.

Confidential Oct2000 to June2001
WA. US 
Module Leader

Order Entry and Invoicing (OEI) is a Client/Server application used by the Weyerhaeuser Recycling Group. OEI is used to enter and monitor customer orders, order information and shipment information. To invoice completed customer orders for billing. After an invoice is generated the invoice information is transmitted to the Accounts Receivable Millennium System (ARMS). The invoice information is sent via an automatic Customer Data Consolidation (CDC) transmission. This data transmission ensures that the OEI and ARMS systems have the same information regarding customer orders. The transmission triggered by means of scheduled batch processes

Contributions:

• Done system study and prepared the system maintenance and technical document.
• Involved in design and programming for several enhancements in both front-end and Oracle.
• Involved in the design and development of the major enhancement called Brokerage Accounting and Business entities maintenance module.
• Done test case review and code review.
• Done code optimization and SQL tuning

Environment: PowerBuilder 7, PL/SQL, Oracle 7.3. The Application is installed in 2 load balanced Citrix terminal WINNT servers. The user using Citrix application portal accesses the application.

Confidential Aug1998 to July2000
Project Leader
Reed Invoice Management System (RIMS2000) was developed for Reed Personnel Services, UK. Reed is a manpower agency involved in recruiting Personnel for their Clients. RIMS2000 is being be used by Reed for generating invoices based on the timesheets received from the Personnel they have recruited. The timesheets are received every weekend and fed into RIMS2000, which will generate invoices. The invoice generation is done based on different charge schemes as defined by the user for individual clients. RIMS2000 generates a download to the Accounting and Payroll systems. RIMS2000 also accepts debit/credit entries and generates debit/credit notes for any adjustment made on the invoices printed.

Contributions:

• Done analysis, design, development, and unit testing for the entire Timesheet entry module.
• Played a significant role in all phases of the project development cycle.
• Provided functional and technical assistance to team members
• Weekly reported status to the Project Manager.
• Using PowerBuilder created base class objects and reusable functions for the application; this was used by other Developers.
• Created data stores to retrieve complex queries wrote PL/SQL packages, stored procedures, triggers based on complex requirements and involved in SQL performance tuning.
• Developed the invoice generation program in PL/SQL independently.
• Implemented the software at the Client’s site in UK.

Environment: PowerBuilder 6.0, PL/SQL, Oracle 8.0, Windows NT, PVCS, VISIO

Confidential May1998 to July1998
Systems Analyst
Fixed Income Securities Trading System is an automated system of trading in fixed income securities. FISTS enhances the functioning of the investment / treasury division of a bank by keeping track of deal / delivery / settlement details and by giving the exact position of the bank with respect to its holdings in various securities.

Contributions:

• Worked with users to gather the requirements and participated in the design of the system
• Written program specifications
• Developed the user interface for Deal entry.
• Developed reusable objects and functions.
• Participated in the Integration testing.
• Implemented the application at Client site.

Environment: PowerBuilder 6.0, PL/SQL, Oracle 7.3, Windows NT, PVCS, VISIO

Confidential Nov1997 to April1998
Systems Analyst
FUNDS enable Banks to efficiently manage the Inflow & Outflow of funds. It aids the funds manager in readily ascertaining the balance position with respect to statutory requirements. It features an on line dealing room module integrated to back office operations. It is expected to be profitable weapon in the hands of the treasury to maintain CRR and deploy surplus funds. Future inflows and outflows can also be recorded in the system. The primary objective of the system is to monitor the CRR requirements of the bank. Besides that the system also takes care of Call / Notice money, Bill Re-discounting and Export Refinance transactions.

Contributions:

• Worked with users to gather the requirements and participated in the design of the system
• Written program specifications
• Customized the system based on Client’s requirements
• Participated in the Integration testing.
• Implemented the application at Client site and provided User Training and support.

Environment: Power Builder 6.0, Oracle 7.3

Project: Confidential May1997 to Oct1997
Role: Systems Analyst
TRADES is the product of LOG-IN, which computerizes the entire foreign exchange transactions of any Overseas Bank in India. This package was developed according to the FEDAI rules. This is a multi-user system and is very user friendly. The system provides security checks, user levels, and backup facilities to safeguard valuable data.

Contributions:

• Customized the system based on Client’s requirements
• Participated in the Integration testing.
• Implemented the application at Client site and provided User Training and support.

Environment: FoxPro 2.5, DOS 6.0 Windows 95

Confidential Jan1995 to April1997
Programmer/ Analyst
Integration Management System (IMS) was developed to automate the entire operations of a superstore. The system handles all accounting transactions and generates ledgers. It generates cash payment report, trial balance, trading and profit & loss account along with balance sheet. The system also provides security check for each and every department. Only when the super-user has logged into the system others can use the system. At each entry point a password will be asked and person who enters the valid password will get the corresponding screen of the appropriate department.

Contributions:

• Developed the accounting module independently
• Developed the security of the system independently
• Prepared unit test cases & documented user manual

Environment: FoxPro 2.5, DOS 6.0 Windows 95