SUMMARY:

• More than 8 Years of experience in developing business related applications in the Client/Server, Unix / Windows, Web, Distributed (Full Life Cycle) (FLCD) environments using PowerBuilder PFC, SSIS, SSRS, Asp,ASP.net,vb.net Visual Basic, Crystal Reports, Oracle, Sybase EAS and Ms - SQL Server, MS-access and Unix shell scripting.
• Extensive experience in Information Systems Analysis, Design, Development, Coding, Testing, Migration, Enhancements (program maintenance), QA Management, Team Management, Documentation and Implementation.
• Strong expertise in user interface, specification development and troubleshooting.
• Solid knowledge of programming and Design methodologies related to RDBMS Applications.
• Solid understanding of Systems life cycle (SDLC), relational databases and software engineering discipline.
• Strong expertise in Advanced software engineering and design principles, including object-oriented methodologies and design patterns, multithreading and massively parallel computing, distributed and multi-tier models, cross-platform development; reliable and redundant server and service design, database-backed persistent services, encryption, authentication, and secure software; et cetera.
• Resolved a lot of Performance Issues in PowerBuilder using PFC.
• Extensive experience in relational database administration, design, development and implementation using Sybase/SQL server and tools and utilities.
• Knowledge of standard languages, coding methods, operations requirements, company coding standards and quality requirements.
• Experience in working with large databases and in designing robust, complex databases, expertise in Client / Server architecture.
• Extensive experience in development of applications using ASP.NET, C#.NET, VB.NET, ADO.NET, ASP, VB 6.0, SQL Server Oracle 8i/9i/10g, Sybase, MS Access.
• Experience in developing different types of reports using Crystal, WebI and DeskI.
• Excellent interpersonal, presentation skills, with demonstrable leadership, verbal and written communications to maintain effective work relationships with all levels of personnel in a team environment or independently.
• Strong experience creating User Guide and Design Documentation.
• Strong in all aspects application development process.
• Strong with RDBMS features like Triggers, Procedures, Packages and Functions.

TECHNICAL SKILLS:

Languages: Power Script, Java, .NET, PL/SQL, SQL, Shell scripting.

Development Tools: PowerBuilder

Network Protocols: TCP/IP, UDP, FTP, HTTP, SOAP.

Methodologies: Agile, SCRUM, TDD, BDD, Design Patterns, Continuous Integration using Cruise Control.

Source Control: Rational Clear Case, CVS, SVN.

Operating Systems: Windows, Unix (Solaris/AIX), Linux (Red Hat).

RDBMS: Oracle 10g, 9i, 8i, 7.x, MS SQL Server 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 Cycle Manager, Microsoft Visual Studio, and Team Foundation Server.

PROFESSIONAL EXPERIENCE:

Confidential, Foster city, CA

Sr. PowerBuilder developer

Responsibilities:

• Responsible for maintaining PowerBuilder 11.5/12.1/12.5 based application.
• Responsible for guiding other developer on analysis, debugging, code review and maintaining PowerBuilder based application.
• Working on a complex processing system that has multiple interfaces to other systems as well as multiple interactions with both internal and external customers.
• Requirement Gathering and Analysis.
• Experience mentoring and transferring knowledge to less experienced staff.
• 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 and altered windows, large data windows with complex queries, user objects (Visual & Non - visual) and functions.
• Wrote complex procedures & functions in Sybase 12.5 environment to in corporate business rules and constraints.
• Conceived system requirements through in depth discussions with the Business and prepared development estimates.
• Wrote Unit Test cases and tested them against the applications being developed.
• Created/Modified Data Windows, 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 Power Script for different Data Windows.
• Created number of new tables, views, triggers, screens and data windows as part of enhancements to existing applications.
• 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 Time debugging skills to resolve complex and show stopper issues.
• Provide required support to team members to solve production issues
• Supported and enhanced institutional accounting software for small to mid-sized applications and designed using PowerBuilder 10 with MSSQL 2005 and T-SQL.
• Major responsibilities include getting requirements from the user, writing stored procedures for reports and developing reports using Crystal Reports 2008. Maintaining proper documentation of the reports for future reference.
• Developed unlinked, on-demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports.
• 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.

Environment: PowerBuilder 11.5/12.5, Windows 2012, PL SQL, Oracle 11g, Crystal Reports, TOAD, Office 2015, MS Visual Studio 2015, TFS, IBM LOTUS.

Confidential, Mineeapolis, MN

Sr. PowerBuilder Programmer

Responsibilities:

• Created/Modified Data Windows, Windows, User Objects, Menus in PowerBuilder.
• Analyze the user requirements and create Use Case documents for each module, technical specifications about the module including the screen design, business process involved and the various ways of implementing the business rules including all the validations, SQL to be written and pseudo code wherever applicable.
• Developed .NET components, Web User Controls, Custom Controls using C#
• Developed SQR programs to generate reports from a Sybase database (including requirements gathering).
• Lead team on Business Intelligence efforts by providing real world training exercises and demonstrations Create prototype SQL Server 2005 Analysis Services (SSAS) cubes using the Unified Dimensional Model (UDM)
• Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS)
• Architect faux data mart solutions to improve performance of SQL Server 2005 Reporting Services (SSRS).
• Created, customized, and managed stored procedures, functions and to triggers for database's
• Implementation of business rules and implemented database conversion.
• 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.
• Led all project efforts including requirements gathering and JAD sessions.
• Developed Systems were designed and implemented using SQL server products and .net technologies and were founded on a complete Service Oriented Application (SOA) architecture.
• Experience in creating and consuming XML Web Services with C#, SOAP Headers and Extensions, WSDL, WSE 2.0, Serialization.
• Created MDX queries to access the OLAP cube information.
• Designed and implemented reports with different layouts using SSRS 2005 and Crystal Reports and exported them into Excel, PDF and HTML.
• Design, development and debugging of Code using Power Builder 12.0.
• 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.
• Experience mentoring and transferring knowledge to less experienced staff.
• Prepare Test plans.
• Perform Unit testing and coordinating with QA team and guiding them through new enhancements and bug fixes.
• Setup version controlling in Clear Case.
• Coordinate with SCCM team for deploying and testing the Power Builder Application Package in QA and Prod environment.
• 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: PowerBuilder 8.0, 10.1, UNIX shell scripting, SSIS, SSRS,, SSAS, ASP.NET, VB.net, SOA, C#, Ms-SQL Server 2005, Windows-NT, VSS, MS-Office'2000

Confidential, Charlotte, NC

PowerBuilder Programmer

Responsibilities:

• Involved in requirement gathering and actively involving in discussions with Business users.
• Working on a complex processing system that has multiple interfaces to other systems as well as multiple interactions with both internal and external customers.
• 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 Script for different Data Windows.
• Created/Modified Data Windows, Windows, User Objects, Menus in PowerBuilder
• Excellent database programming in Oracle 10g.
• Analyze the user requirements and create Use Case documents for each module, technical specifications about the module including the screen design, business process involved and the various ways of implementing the business rules including all the validations, SQL to be written and pseudo code wherever applicable.
• 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.
• Technologies and were founded on a complete Service Oriented Application (SOA) architecture.
• Experience with developing distributed applications (with Jaguar/EAServer, J2EE or equivalent technology)
• Involved extensively in development of PL/SQL Packages, Stored procedures, Triggers, and fine-tuning them for performance.
• Implemented the use of standard templates to create up-to-date SDLC documents.
• Migrated the applications from PB 7.0 to 10.5
• Developed UNIX shell scripts to integrate and execute various pre-scheduled modules, event to execute at production servers and for generating logs on day-to-day basis.
• Involved in development of NVO and base classes which are used across multiple applications.
• Coding, testing, debugging of Windows, complex data windows, User objects, functions, events using Power Builder per company standards and techniques.
• Creating and altering Tables, procedures, functions, triggers and packages.
• Making Builds and deploying executables (Implementation).
• Wrote auditing triggers, complex procedures & functions using PL/SQL to in corporate business rules and constraints.
• Designing standard Framework as per PowerBuilder Foundation class.
• Analysis, Design, development and Enhancements of the various applications.
• Involved in writing design, technical, enhancements documentation and test plans.
• Creating and changing Business objects (Visual and Non-visual), windows, data windows, functions and menus using Power Builder.
• Developed new classes in PowerBuilder(TM) 8.0 utilizing ActiveX technology, for deployment in COM / ASP or Sybase EAServer (web target) environment.
• Developed several PowerBuilder applications using RPC functionality.
• Developed Front end windows using PowerBuilder v10.5 and PFC services with Sybase and Oracle as backend.
• Created stored procedures, cursors, triggers, and views in TSQL and PL/SQL and modified existing ones so that the old and new functionality is supported.

Environment: PowerBuilder 8.03/10.5, PFC, PL/SQL, Oracle 9i/10g, PVCS, SDLC, Shell Scripting, Windows XP, MSOffice, Microsoft Visual Studio 2008, .NET Framework 2.0, Unix.

Confidential

Responsibilities:

• Collected user requirements, created 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.
• Experience mentoring and transferring knowledge to less experienced staff.
• Working on a complex processing system that has multiple interfaces to other systems as well as multiple interactions with both internal and external customers.
• Created deliverable documents, created technical code reviews, assigned task to developer, preparing functional specs for developer.
• Designed & developed business objects using PFC, created base classes using PFC, designed customized PFC Error Message Services, Data window 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 data window.
• Utilized advanced PowerBuilder techniques: Multiple Inheritance, Non - visual User Objects, Drop Down and Shared Data windows, Composite Data Window.
• Extracted business rule from the PowerBuilder code and Oracle stored procedure.
• Optimized SQL Queries by performance tuning using Explain plan, creating Indexes for reporting requirements and providing hints as of when required.
• Supported post production deployments with and code or Database Related Issues.

Environment: PowerBuilder 8.0/9.0, MS SQL server, SQL, Sybase ASE, GUI, shell scripting, UNIX, MS windows