PROFESSIONAL SUMMARY:

• Senior Programmer with 6 years of experience in developing and supporting Client Server, N - Tier and Web based enterprise applications using PowerBuilder, PFC, Oracle, Sybase, Sybase EAS, MS-SQL Server, DB2 and version controls.
• Strong knowledge of Web Application development, systems integration, databases, and consulting. Technical front-end includes the use of C#, ASP.Net, XML, JavaScript, DHTML
• Strong experience in programming skills with PowerBuilder (12.5,11.5,10.5, 9, 8, 7) and its advanced features such as PowerBuilder Foundation Class Library (PFC) with corporate level, XML Export/import Data window using template, Dynamic, Data Windows, Inheritance, Encapsulation, Polymorphism, MDI, User Objects, visual/Non-visual user object and Menus.
• Extensive experience in Information Systems Analysis, Design, Coding, Testing, Debugging, Migration and Implementation.
• Strong knowledge of Object-Oriented software engineering methodologies, Object-Oriented Analysis and Design, Design by Contract, UML, Use-Case-driven development, the Unified Software Development Process, the full Software Development Life Cycle (SDLC), and extreme Programming.
• Involved in Configuration Management and Quality Management activities - Assist the database administrator and coordinate with other consultants
• Knowledge in user interface, specification development and troubleshooting (problem determination/resolution).
• Strong expertise in user interface, specification development and troubleshooting (problem determination/resolution).
• Strong with RDBMS features like Triggers, Procedures, Packages and Functions.
• Knowledge of programming and Design methodologies related to RDBMS Applications
• Knowledge in Tuning SQL statements and procedures for enhancing the load performance in various schemas across databases.
• Appreciation mails from clients for meeting deadlines of the project with good quality
• Excellent record of success in meeting project milestones and developing good relationships with clients.
• Good knowledge in Database analysis, design, normalization, and data manipulation processes.
• Excellent interpersonal, presentation skills, with demonstrable leadership, verbal and written communication skills to maintain effective work relationships with all levels of personnel in a team environment or independently.

TECHNICAL SKILLS:

Languages: Power Script, HTML, PL/SQL, T-SQL, C# .NET, VB.NET

RDBMS: MS-Access97/98/2010, Oracle 8.x/8i/9i/11g, Sybase 10x/11xSybase SQL anywhere, DB2, Adaptive server, MS-SQL server 6x/7

GUI: PowerBuilder 9/10/10.5,11,11.5,12 Infomaker/ DatawindowBuilder

OS: Sun Solaris, UNIX-HP-UX, AIX, Linux, Windows 7/8/10.

Design Tools: Erwin, Power (S) Designer, UML, OOAD

Other skills: PVCS, PB-Native, SQLProgrammer, SQL Navigator, TOAD Suite7.x, MS Office, Shell Scripting, Agile.

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, Missouri

PowerBuilder Developer

Responsibilities:

• Business requirement gathering and documentation.
• Understating the business system and interacting with business users and the developers.
• Analyze, designed and programmed different warehouse modules according to business requirements.
• Development of the application based on Sybase PowerBuilder.
• Impact Analysis, Estimation, Scheduling, Planning.
• 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.
• Assisted the team in following the efficient coding methodologies.
• Expertise in creating functions of PowerBuilder.
• Migrated Power Builder application pbls from version 10.5 to 11.5 and 12.5
• Responsible for writing COM objects for PowerBuilder applications to interface with Windows services written in c#.NET and Web services written in ASP.NET.
• Involved in writing PowerScript for different DataWindows.
• Developed and hosting WCF Services on IIS by following Service Oriented Architecture (SOA).
• Supported development of a speciation control documents for an MS Access Project Management Database.
• Created/Updated some Triggers and Stored Procedures using SQL statements.
• Developed Sybase SQL code based on requests raised by changes in business logic, norms and standards
• Using check in and checkout process while coding the objects.
• Developed the local database using pipe object for faster performance.
• Debugged Functions, Triggers and Stored Procedures in Sybase SQL
• Provide required support to team members to solve production issues
• Adding and Managing Source code to the Version Control Team Foundation Server and Serena Dimensions.
• Debugged.Net related applications.

Environment: PowerBuilder 12.0/11, PFC, PL/SQL, PVCS, Visual Studio, Sybase12.5, Windows 8, MS-Office Suite, MSSQL, Microsoft Visual Studio 2008, .NET Framework 4.5, Sybase SQL, IIS 6.0.

Confidential, Houston, Texas

PowerBuilder Developer

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
• Responsible for writing enhancements to a custom .NET electronic payment application with functionality to process credit card and electronic check payments by implementing C#.NET.
• Involved in Creating Technical Documentation for the projects that has been assigned.
• 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.
• Created an MS Access database to collect data systems in order to provide lists, status reports and management overview reports.
• Involved in writing PowerScript for different DataWindows.
• Used Just in Time debugging 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.
• 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.
• Developed the local database using pipe object for faster performance.
• Used Just in Time debugging 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.

Environment: PowerBuilder 11.5, PFC, Oracle 9i/10g, PVCS, Windows 7, MS-Office Suite, SDLC, Agile Methodology, Sybase ASE 12.0.

Confidential, Detroit, MI

PowerBuilder/SQL Developer

Responsibilities:

• Collecting User Requirements, converting in to program specifications and prototypes
• Documenting requirements and business process
• Coding, testing, debugging of Windows, complex data windows, User objects, functions, events using Power Builder per company standards and techniques.
• Created number of new tables, views, triggers, screens and data windows as part of enhancements to existing applications.
• Responsible for setting up and maintaining MS-Sql Server development and production environments. Helped Database Administrator for 3 productions and 2 developments MS-Sql Server Servers.
• Wrote Unit Test cases and tested them against the applications being developed.
• Provided production support to many Power Builder applications by researching and debugging complex problems and solving the issues on time.
• Recommended technical alternatives through active discussions to meet new requirements of business units.
• Delivered end user training to business users for the enhancements made to applications.
• Maintained and provided documentation of workload activities and time spent on projects.
• Development, maintenance, and performance tuning of Sybase ASE stored procedures, triggers, views, and tables.
• Interacted very closely with Quality Assurance team to test the new products before deployment

Environment: Windows 7, PowerBuilder 11.5 , SQL , PFC, MS Office, Sybase SQL Server, PVCS.