Summary

• 15 years experience in different phases of Software development life cycle including System Analysis, Design, Preparation of Technical Documentation, Coding, Unit Testing, Integration Testing, User Acceptance Testing, System Testing, Production Deployment, enhancement and maintenance of Client/Server, Multi-tier architecture applications.
• Strong experience in Database Analysis Design and coding using Oracle 11.1/10g/9i/8i/8.0/7.x, Sybase Adaptive Server Enterprise 15.1/12.5/11.0/10.0, MS SQL Server 2008/2005/2000/7.0/6.5.
• Experience in C / C Pro C Programming, Unix shell scripting, Perl, batch jobs and SQLs for reports, Export and Import of Datafiles.
• Experience in relational DB Design, preparing documentation worked with end users/ business with data mapping for data extracts and data conversion.
• Excellent experience in creation and maintenance of database objects like Packages, Stored Procedures, Functions, Triggers, Database Link, Snapshot, Roles, Privileges, Tables, Constraints, Clusters, Views, Indexes, Sequence, Synonym. Used Dynamic Cursors, Predefined User Defined Exceptions.
• Excellent experience in TOAD, PL/SQL Developer, Rapid SQL, SQL developer, SQL Loader, BCP utility, SQL Plus, ODBC writing Optimize SQL.
• Experience in developing Internet based applications using J2EE Java, Java Beans, JDBC, Servlets, JSP , JavaScript, HTML, XML and other application jobs using C,C and Pro C, Sybase DB-Library, UNIX Shell Scripting and batch jobs, Have a exposure to .NET, applications interfacing with Oracle Financial Application EBS , Peoplesoft and Discoverer Reports.
• Responsibilities as Project Leader, Technical lead, Sr. Analyst / Analyst Programmer and Programmer. Strong functional experience includes Budgeting, Financial, Logistics, Retail, Distribution, Inventory Manufacturing and Material management, Health care and NGO. Worked for leading clients , Wells Fargo Bank Home Mortgage, Kinetic concepts Inc, TRANE Ingresol Rand ,National Marrow Donor Program, ADESA Kintetsu Global IT KGIT , Sony Electronics Pte Ltd / Sony International/ Sony India Pvt Ltd , Indus International, Wipro Ltd, NIIT Ltd .
• Experience in programming skills with PowerBuilder 12.1,11.5,10.5,9,8,7,5.0 with advanced features with PowerBuilder Foundation Class Library PFC with corporate level, XML Export/import datawindow using template, Dynamic Datawindows, Inheritance, Encapsulation, Polymorphism, MDI, User Objects, visual/Non visual user object and Menus and Forte 5.0.4
• Involved in Configuration Management, Quality Management and Production support activities - Assist the database administrator and coordinate with other consultants, in trouble-shooting errors in the existing system.
• Excellent experience in Object Oriented Analysis, Design and Development using Agile and Waterfall methodologies. Very good communication / interpersonal skills ability to work under tight schedules.

Skills

• Operating Systems:Sun Solaris, HP Unix, Linux,Windows 7/XP/NT, MS-DOS Novel Netware, Citrix server
• Databases: Oracle 11.1/10g, 9i, 8i,Sybase 15/12.5/11, SQL Server2008/2005/2000/7.0/6.5, Sybase SQL Anywhere, Access
• Languages:SQL, PL/SQL, T-SQL, Perl, C, C , Java, HTML, XML, J2EE
• Utilities: Rapid SQL,Toad, SQL Developer, SQL Navigator, PL/SQL developer, SQL Plus, SFTP, FTP, Batch jobs using scheduling like Cron/ Autosys
• Database Design Tools: Power Designer, Erwin
• Source Control: Subversion,PVCS, WinCVS, TFS, Clear Case,
• Quality Tools : Clear Quest, HP Quality system
• Reporting Tools: Discoverer, Crystal Reports, Business Objects
• GUI: PowerBuilder 12.1/11.5/10.5/9.0/8.0/7.0/5.x with PFC, Visual Basic 6.0/5.0, Visual Studio 2008,2005,2003 6.0, Forte UDB 5 , Java Server Pages JSP , Javascripts

Professional Experience

Confidential

Role: Programmer Analyst

Responsibilities:

• Client Interaction to discuss the Business Requirements
• Involved with DBA in Database design
• Data Mapping and Data transfers for the application using SQL Loader /App loader from flat files.
• Prepared Technical Detail Specification Document and SQL Scripts for onetime data and object creations.
• Implemented Business logic through Packages, Procedures, Triggers
• Performance Tuning
• Unit Testing / Integration Testing / User Acceptance Testing and Production support
• Code review
• New Interface files from existing PB Applications to Customer and Accounts Receivables.
• Created new screens and reports, Modified existing functionalities to support the new requirements for upgrades for Oracle financial implementation.

Environment: PowerBuilder 11.5, XML, PeopleSoft, Oracle Financial Application EBS , Oracle 11g, PL/SQL Procedures and Packages , Pro C, Windows 7, UNIX jobs, Citrix Servers, SubVersion, HP Quality system

Confidential

Role: Programmer Analyst

Responsibilities:

• Client Interaction to discuss the Business Requirements
• Involved with DBA in Database design
• Prepared Technical Detail Specification Document and SQL Scripts for onetime data and object creations.
• Creating new functionalities, implementing business logic through Stored Procedures / Packages
• and interfaces using EBS snap tables.
• Unit Testing / Integration Testing / User Acceptance Testing and Production support
• Performance Tuning and Troubleshooting /debugging procedures/packages
• Code reviews
• Analysis of programming impacts ,preparation of detail design, development and production support issues for the assigned modules. Providing Data and SQL Queries to the Business Analyst from the EBS system.
• Created new screens and reports, modified existing functionalities to support the new requirements for upgrades in HERO and GENESIS.

Environment: PowerBuilder 12.1/ 9, XML , Oracle Financial Application EBS , Oracle 10g, PL/SQL Procedures and Packages , Seibel, Windows XP, UNIX jobs, Serena Change Man, SubVersion, HP Quality system

Confidential

Role: Programmer Analyst /Apps Systems Engineer

Responsibilities:

• Collected Business requirements, Upstream Downstream Impact analysis on Applications with schema changes, created technical design document.
• Data Mapping and conversion of Data for the application.
• Involved with DBA in Database design
• Preparation of detail design, development and production support for the assigned modules.
• Business logic through Stored Procedures.
• Performance Tuning and Troubleshooting /debugging procedures/packages.
• Unix shell scripting to automate the data comparisons , data file extracts and transfer through SFTP NDM
• Created new Screens and Reports to support the new file formats and new data columns.
• Testing and Release support
• Conducted and participated in Peer reviews , Code review and Scrums.
• Investigate and resolve issues relating to the Powerbuilder, Sybase and Unix scripts in the application code.
• Managed and resolved production tickets assigned through PAC 2000. Monitoring and status reporting production jobs. Participated in EACO and Release calls co-ordinating and supporting the business clients and developers.

Environment: Sybase 15, XML ,TIBCO, Oracle 10g, Windows XP/7, UNIX jobs, TFS,IBM Clearcase, Subversion, Clearquest

Confidential

Role: Programmer Analyst

Responsibilities:

• Data Mapping and conversion of Data for the application.
• Unit Testing / Integration Testing / User Acceptance Testing and Production Support
• Preparation of detail design, development and production support for the assigned modules. Providing Data and SQL Queries to the Business Analyst from the EBS system.
• Involved with DBA in Database design
• Conducted and participated in Peer reviews , Code review and Scrums.
• Creating Reports AR,AP,GL and Grants for EBS users using Discoverer
• New Interface files from existing PB Applications to Accounts Payables, Accounts Receivables and Grants.
• Created new screens and reports, Modified existing functionalities to support the new requirements for upgrades and Phoenix.
• Performance Tuning and Troubleshooting /debugging procedures/packages

Environment: PowerBuilder 12.1/11.1/10.5,Oracle Financial Application EBS , Discoverer, Sybase 15/12.5, XML , Oracle 11.1, PL/SQL Procedures and Packages , Windows XP, UNIX, SQL Server 2008/2005, WinCVS, Clearquest, SQL Developer, TOAD, Power Designer

Confidential

Role: Programmer Analyst /Apps Systems Engineer

Responsibilities:

• Collected Business requirements, Upstream Downstream Impact analysis on Applications with schema changes, Created technical design document.
• Data Mapping and conversion of Data for the application.
• Preparation of detail design, development and production support for the assigned modules.
• Business logic through Stored Procedures.
• Created new Screens and Reports to support the New EDI messages.
• Unit Testing / Integration Testing / User Acceptance Testing
• Conducted and participated in Peer reviews and Code review.
• Investigate and resolve issues relating to the Powerbuilder, Sybase and Unix scripts in the application code.
• Managed and resolved production tickets assigned through PAC 2000. Participated in ECO and Release calls co-coordinating and supporting the business clients and developers.

Environment: PowerBuilder 11.1/10.5/9 , Sybase 12.5, XML, TIBCO, Oracle 10g, Windows XP, UNIX, Clearcase, Clearquest

Confidential

Role: Programmer Analyst

Responsibilities:

• Collected Business requirements, Upstream Downstream Impact analysis on Applications with schema changes, Created Functional specification and technical design document.
• Preparation of detail design, development and production support for the assigned modules.
• Implemented XML EDI Message processing and Business logic through Stored Procedures.
• Created new Screens and Reports to support the New EDI messages.
• Unit Testing / Integration Testing / User Acceptance Testing
• Conducted and participated in Peer reviews and Code review.

Environment: PowerBuilder 11.1/10.5 / 9, MS SQLServer 2005 / 2000, XML , Oracle 10g, Windows XP,Citrix Server, UNIX, Rational Rose, Clearcase, Clearquest

Confidential

Role: Programmer Analyst /Apps Systems Engineer

Responsibilities:

• Collected Business requirements, Upstream Downstream Impact analysis on Applications with schema changes, Created Functional specification and technical design document.
• Preparation of detail design, development and production support for the assigned modules.
• Implemented Business logic through Stored Procedures.
• Preparation of validation scripts for the Database modifications for the projects.
• Extensively using Object Oriented Techniques of PowerBuilder like Inheritance, Polymorphism and Encapsulation.
• Unit Testing / Integration Testing / User Acceptance Testing
• Co-coordinating with Offshore team developing the system.
• Conducted and participated in Peer reviews and Code review.
• Investigate and resolve issues relating to the Powerbuilder, Sybase and Unix scripts in the application code.
• Managed and resolved production tickets assigned through PAC 2000. Monitoring and status reporting production Jobs. Participated in EACO and Release calls co-coordinating and supporting the business clients and developers.

Environment: PowerBuilder 10.5 / 9, Sybase Adaptive Server 12.5, Sybase DB-Lib/OS 11, C compiler, UNIX, XML, Rational Rose, Clearcase, Clearquest

Confidential

Role: Programmer Analyst

Responsibilities:

• Collected user requirements, analysis, design GUI Database and developed the system. Interacted with the users to discuss business logic and workflow of the all the system. Created Functional specification, technical design document, Integration and unit test cases.
• Designed GUI Database developed business objects and lead a team of 4 members during construction phase.
• Wrote PL/SQL Stored procedure, Packages and Trigger, created Sequence and tables.
• Conducted and participated in Peer reviews and Code review.
• Investigate and resolving issues relating to the Powerbuilder and PL/SQL during construction.

Environment: PowerBuilder 9 PFC ,Oracle 9i, UNIX

Confidential

Responsibilities:

• Participated in JAD sessions and Collected user requirements, analysis, design GUI Database for the system. Interacted with the users to discuss business logic and workflow of the all the system. Created technical design document, Integration and unit test cases.

Environment: SQL Server 2000, Win2000, .NET

Confidential

Role: Programmer Analyst

Responsibilities:

• Analyzing existing functionalities of the system and provide technical inputs for building retailer functionality
• Designing the Gap analysis document, Prepare functional design document and High-level design document aimed to provide client with details of functional gaps between the two systems and how all the requirements will be achieved functionally and technically.

Environment: PowerBuilder 9 PFC ,Oracle 9i, UNIX

Confidential

Role: Programmer Analyst Core

Responsibility:

• Collected user requirements, Create design specifications, coded, tested and provided user support. This project required extensive communication with end users and ability to produce creative solutions on a timely basis.
• Created deliverable documents and deliverable schedule. Technical code review, assign task to developer, preparing functional specs for developer as a project leader.
• Performed maintenance and enhancement on the system new development enhancements .
• As a project leader supervised, trained and consulted team of 3-5 programmers. Provided troubleshooting and user support.
• Maintained corporate ancestor library and created new ancestors for data entry validation and template creation. Utilized tree view and tab controls linked to datawindow. . Utilized advanced PowerBuilder techniques: Multiple Inheritance, Non visual User Objects, Drop Down and Shared Datawindows, Composite Data Window.
• Created Components in Forte and customized functionalities were implemented.
• Designed developed business objects using PFC, Created base classes using PFC. Used PFC Security Services, Datawindow Services and Application Services. Created new customized PFC Services like Cascade drop downs, Custom Security and Multiple Drag Drops in Tree view etc
• Preparing detailed document specifications, Integration unit Test cases Test Plans

Environment: PowerBuilder 8, PFC, Oracle 8i / 9i, UFE. Forte 5

Confidential

Role: Module leader/Team Leader

Responsibility:

• Implemented full life cycle development for this application, collected user requirements, specifications, coded, tested and provided user support. This project required extensive communication with end users and ability to produce creative solutions on a timely basis.
• Involved in Analysis, design, development new development enhancements maintenance and production support. Interacted with the users to discuss business logic and workflow of the new modules
• Created deliverable documents and deliverable schedule. Technical code review, assign task to developer, preparing functional specs for developer as a project leader.
• Arranged project meeting and user meeting for status of project, current or future delivery.
• Developed reusable components or classes in terms of user objects. Responsible for collecting specifications, technical analysis and technical reviews with client. Involved in Technical design and development of the system.

• Preparing detailed document specifications, Integration unit Test cases Test Plans

Environment: Oracle 8i, PL/SQL, PowerBuilder 7.0,Pro C, Unix, Shell scripts, JSP, Citrix server

Confidential

Role: Module leader

Responsibility:

• Collected user requirements, Create design specifications, coded, tested and provided user support. This project required extensive communication with end users and ability to produce creative solutions on a timely basis.
• Created deliverable documents. Technical code review, assign task to developer, preparing functional specs Designed developed business objects using PFC, Created base classes using PFC. Designed customized PFC Error message Services, Datawindow Services and Application Services as per the architecture requirement.
• Maintained corporate ancestor library and created new ancestors for data entry validation and template creation. Utilized tree view and tab controls linked to datawindow. . Utilized advanced PowerBuilder techniques: Multiple Inheritance, Non visual User Objects, Drop Down and Shared Datawindows, Composite Data Window.

Environment: Oracle 8i, PowerBuilder 7/8, PFC

Confidential

Role: Team member

Responsibility:

• Implemented full life cycle development for these application, collected user requirements, specifications, coded, tested and provided user support. This project required extensive communication with end users and ability to produce creative solutions on a timely basis.
• Involved in Analysis, design, development new development enhancements maintenance and production support. Interacted with the users to discuss business logic and workflow of the new modules
• Developed reusable components or classes in terms of user objects .
• Produced test plans for Production Support.
• As a database developer, Responsible for database schema business analysis, design and implementation. Wrote stored procedures, triggers.

Environment: MS SQL Server 2000/7.0,Oracle 8i,PL/SQL, ASP, EJB, JSP

Confidential

Role: Team member

Responsibilities:

• Business Process / Systems study , Interaction with System Users on either side
• Design and development of Templates using customised User Objects.
• Design and development of GUI components and Unit Test Plans UTP
• Implementation of Stored Procedures and Trigger
• Create user manual , User Training and maintained Version Control

Environment: Window NT, MS SQL Server 7.0, Power builder 7.0/5, Visual Basic, ASP

Confidential

Role: Team member

Responsibilities:

• Business Process / Systems study, Design and development of GUI components
• Maintenance and enhancements in functionalities, Creating Stored Procedures and executing Unit Test

Environment: Window NT, SQL Server 6.5/7.0, Visual Basic, ASP

Confidential

Role: Team member

Responsibilities:

• Business Process / Systems study, Design and development of GUI components, Unit Test Plans UTP
• Business logic has been Implemented using Stored Procedures and Trigger,Create Document for the user.

Environment: Visual Basic, Powerbuilder 5.0, Sybase 10/11.5, SQL Server 6.5, FoxPro 2.6

Confidential

Role: Team member

Responsibilities:

• Initial study and scope definition with the users.
• Provide support for hardware / software troubleshooting and Installations at the centers / client sites.
• Prototyping demonstration training to the users and also involved in implementation at Client sites..

Environment: Window NT, PowerBuilder 5.0, Novell Netware, Unix, Windows 95/98

Confidential

Role: Team member

Responsibilities:

• Part of Internal Auditing team was involved in Procedure Documentation team for ISO-9002 certification
• Provide support for hardware / software troubleshooting, implementation and Installations.
• Responsible for Programming /System administration ,Prototyping demonstration training to the users.

Environment: Window NT, Novell Netware, Windows 95/98

Confidential

Role: Team member

Responsibilities:

• Provide support for hardware / software troubleshooting, implementation and Installations. Prototyping demonstration training to the users.
• Responsible for Programming /System administration Prototyping demonstration training to the users.

Environment: Window NT, Novell Netware, Windows 95