PROFESSIONAL SUMMARY

• Having 7 Years of experience in System Analysis/Design, Coding, and Unit Testing, Testing, Implementation, Maintenance and enhancement of Software applications.
• Strong Business Software design and development experience in Retail, Manufacturing and Finance industry using PowerBuilder, Oracle, MS SQL Server, and .NET.
• Have good knowledge and experience in OOAD, Software Development Life Cycle and Quality procedures in development and maintenance of the application.
• Expertise in design and development of application in relational database and client server environment using PowerBuilder 6.0/7.0/8.0/9.0/10/11/12, Oracle 7.x/8.x/9i/10g, PL/SQL.
• Experience integrating third party tools and OLE objects into PowerBuilder applications
• Experienced in database connection using PowerBuilder .ini configuration files.
• Strong programming skills in Datawindow and use of Datawindow.
• Expertise in debugging skills using PB Trace file and Just in time debug.
• Expertise in applying security using PFC objects.
• Created numerous SQL reports for users and familiar with various types of stored procedures, views, joins, union, intersect, sub queries, alias, formatting etc.
• SQL development with skills in creating tables/views/stored procedures on SQL Server and Oracle databases.
• Experience in developing database, with Oracle 9i/10g, SQL Server2000/2005, Sybase.
• Have a wide Business knowledge on EDI industry.
• Knowledge in Test Scripts and Test Cases to perform Unit Testing, System Testing and Load Testing.
• Seamlessly migrated the Code from Development to Testing, UAT and Production.
• Excellent Analytical and Communication skills required to effectively work in the field of applications development and maintenance.
• Admirable Oral, analytical abilities with excellent communication skills and interpersonal skills.
• Very Good at Understanding Integration Technologies, Domains and work flows.
• Experience in revision controlling using tools like, TFS, VSS, Serena Dimensions and IBM Rational Clear Case.

TECHNICAL SKILLS

Operating Systems : Windows NT, Windows 2000 Windows 7, MS Dos, Unix, Linux

Development Tools : PowerBuilder 11.5/12.5,

Languages : C ,PowerScript.

RDBMS : Oracle 10g, 9i, 8i, 7.x, MS SQLServer 2000/2005, Sybase SQL Anywhere, Sybase, DB2, Transact SQL, PL/SQL

Configuration Tools : Serena Dimensions/Business Management Tools, BMC Remedy Help Desk

Ticketing Tool, PVCS, Rational Clear Case, Visual Source Safe, Object CycleManager, Microsoft Visual Studio, and Team Foundation Server.

PROFESSIONAL EXPERIENCE

Confidential

Role: Powerbuilder Programmer

Responsibilities:-

• Business requirement gathering and documentation.
• Understating the business system and interacting with business users and the developers.
• Creating, updating and reviewing understanding documents about the system.
• Impact Analysis, Estimation, Scheduling, Planning.
• Creating Incidents and alerts in BMC remedy and creating new service request.
• Preparing detail design document and traceability documents.
• Prepare Test plans.
• Perform Unit testing and coordinating with QA team and guiding them through new enhancements and bug fixes.
• Setupversion controlling in Clear Case.
• Design, development and debugging of Code using Powerbuilder 12.0.
• Coordinate with SCCM team for deploying and testing the Powerbuilder application Package in QA and Prod environment.
• Created/Modified DataWindows, Windows, User Objects, Menus in PowerBuilder.
• Debugged Functions, Triggers and Stored Procedures in Oracle 10g.
• Perform basic mainframe programming to execute Jobs related to the project.
• Perform basic SQR programming to modify existing job scripts.

Environment:

Windows 7, PowerBuilder 12.0, Oracle 10g, TOAD, Office 2010,MS Visual Studio 2012,Putty,SQL plus,BMC remedy.

Confidential

Role: - Programmer Analyst PowerBuilder.

Responsibilities:-

• Responsible for maintaining PowerBuilder 11.5 based application.
• Responsible for guiding other developer on analysis, debugging, code review and maintaining PowerBuilder based application.
• Requirement Gathering and Analysis.
• Development of the application based on Sybase PowerBuilder.
• Prepare Technical Design Documents based on Business Requirements.
• Prepare unit test plans, integration test plans and system test plans.
• Maintain Defects of the PowerBuilder Application along with resolution steps, change request of the PowerBuilder Application and issues with the application.
• Develop Deploy guide and lead the development efforts in the Development, Testing, Stage and Production environments.
• Created/Modified DataWindows, Windows, User Objects, Menus in PowerBuilder
• Debugging existing software to correct malfunctioning applications
• Responsible for converting user requirements into software solutions
• Expertise in User objects of PowerBuilder.
• Expertise in creating functions of PowerBuilder.
• Involved in writing PowerScriptfor differentDataWindows.
• Created/Updated some Triggers and Stored Procedures using SQL statements.
• Developed SQL code based on requests raised by changes in business logic, norms and standards
• using check in and checkout process while coding the objects.
• Debugged Functions, Triggers and Stored Procedures in Oracle 10g.
• Programming using PowerBuilder Standards.
• Developed the local database using pipe object for faster performance.
• Used Just in Timedebugging skills to resolve complex and show stopper issues.
• Provide required support to team members to solve production issues
• Analyze, designed and programmed different warehouse modules according to business requirements.
• Adding and Managing Source code to the Version control Team Foundation Server and Serena Dimensions.
• Debugged.Net related applications.

Environment:

Windows XP, PowerBuilder 11.5/12.5, Oracle 10g, TOAD, Office 2010,MS Visual Studio 2012,TFS,IBM LOTUS.

Confidential

Role: - Programmer Analyst PowerBuilder.

Responsibilities:

• Responsible for the maintenance of the software programming in PowerBuilder 9, 11.5and 12.
• Involved in requirement gathering and actively involving in discussions with Business users.
• Expertise in User objects of PowerBuilder.
• Created Stored Procedures responsible for generating Reports using Oracle.
• Involved in updating of the existing PFC's according to client's requirement.
• Involved in writing Power Scriptfor differentData Windows.
• Created/Modified Data Windows, Windows, User Objects, Menus in PowerBuilder
• Excellent database programming in Oracle 10g.
• Created/Updated some Triggers and Stored Procedures using SQL statements in TOAD.
• Developed SQL code based on requests raised by changes in business logic, norms and standards.
• Debugged Functions, Triggers and Stored Procedures in Oracle 10g.
• Coding using PowerBuilder Standards.
• Content Management using Serena Dimensions Tool.
• Involved in planning and deploying projects according to the workflow process of Serena Business Manager.
• Business Management Tools BMC Remedy Help Desk Manager, Serena Business Manager and Niku Clarity
• Involved in writing Test cases and performing unit testing.
• Actively involved in Team meeting to provide technical solutions.
• Involved in Creating,Deploying, Packaging and Pushing PowerBuilder apps via Content Management Team and Citrix Team.
• Creating CRF's, IT requests, Remedy Tickets and RFC's for Development, QA and Productions environmentpush.
• Analyze, designed and programmed different warehouse modules according to business requirements.
• Responsible for preparing test cases.
• Involved in Creating Technical Documentation for the projects that has been assigned.

Environment:

Windows XP, PowerBuilder 9.0/10.5/11.5/12, Oracle 10g, PL/SQL, PFC, TOAD, BMC Remedy Help Desk Manager, Serena Dimensions, Serena Business Manager,Office 2010 .

Confidential

Role: Programmer Analyst

Responsibilities:

• Responsible for the maintenance of the software programming in PowerBuilder 11.5
• Created/Modified DataWindows, Windows, User Objects, Menus in PowerBuilder
• Excellent database programming in Oracle 10g.
• Debugging existing software to correct malfunctioning applications
• Responsible for converting user requirements into software solutions
• Expertise in User objects of PowerBuilder.
• Expertise in creating functions of PowerBuilder.
• Involved in updating of the existing PFC's according to client's requirement.
• Coded a part of Payroll, Accounting and Sales modules.
• Involved in writing PowerScript for differentDataWindows.
• Involved in the process of Data Modeling.
• Created/Updated some Triggers and Stored Procedures using SQL statements.
• Developed SQL code based on requests raised by changes in business logic, norms and standards
• Using check in and checkout process while coding the objects.
• Debugged Functions, Triggers and Stored Procedures in Oracle 10g.
• Coding using PowerBuilder Standards.
• Developed the local database using pipe object for faster performance.
• Used Just in Timedebugging skills to resolve complex and show stopper issues.
• Provide required support to team members to solve production issues
• Involved in creating pivot tables and Data tables using Excel.
• Analyze, designed and programmed different warehouse modules according to business requirements.
• Responsible for preparing test cases.
• Did version controlling using VSS.

Environment: Windows 2003, PowerBuilder 11.5, Oracle 10g, PL/SQL, Java, VSS 6.0, PFC, MS Office.

Confidential

Role: .NET Developer

Responsibilities:

• Worked with Business Development Team and Users to analyze, prepare functional scope, High Level Design, Detailed Design..
• Analysis, design of Applications using HTML, CSS and JavaScript.
• Collecting inputs from the Client.
• Worked on Master Pages.
• Developed user controls and validation controls using ASP.NET
• Implemented mailing system Send mail with attachments.
• Involved in coding the Business Logic using Web Services using C .NET.
• Worked with DataReader and Dataset for data manipulations and database operations.
• Created stored Procedures using Oracle 7.3.
• Created XML output from SQL Views.

Environment: Windows 2000, ASP.NET, C .NET, IIS 5.0, HTML, Oracle 7.3, Pl/SQL, XML