Developer Sql

SUDHEER V Email:

Sr. PowerBuilder Developer

Email: *****@**********.***

Phone-240-***-****

PROFESSIONAL SUMMARY

Over 8 years of experience in developing business related applications in the Client/Server, Unix/Windows using PowerBuilder PFC, Sybase, Oracle, SQL-Server, ASP, MS-Access, SQL, T-SQL, PL/SQL, Unix shell script, Web Datawindow, Object Oriented Programming, GUI, Windows API, Crystal Reporting, System Development Life Cycle(SDLC), Multimedia, Web based applications.

Strong experience in programming skills with PowerBuilder (12.5,11.5,10.5, 9, 8, 7, 5.0) and its advanced features such as PowerBuilder Foundation Class Library (PFC) with corporate level, XML Export/import Datawindow using template, Dynamic, Data Windows, Inheritance, Encapsulation, Polymorphism, MDI, User Objects, visual/Non-visual user object and Menus.

Strong knowledge of Object-Oriented software engineering methodologies, Object-Oriented Analysis and Design, Design Contract, UML, Use-Case-driven development, the Unified Software Development Process, the full Software Development Life Cycle (SDLC), and extreme Programming.

Good knowledge in Database analysis, design, normalization, and data manipulation processes.

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).

Knowledge in Tuning SQL statements and procedures for enhancing the load performance in various schemas across databases.

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.

Knowledge of programming and Design methodologies related to RDBMS Applications

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:

GUI: PowerBuilder 5/6/7/8.01/10/11/12, VB 5/6, Developer 2000 and Datawindow Builder

LANGUAGES: C, C++ Java, .NET, COBOL, JCL, CICS, PL/SQL, ISQL/TSQL and SQL*PLUS

RDBMS: Oracle 9.x, 10.x, 11, Sybase 10x/11x, Adaptive server, Sybase SQL anywhere 5/6, WatcomSQL4, DB2, VSAM, MS-SQL server.

O/S: Windows 2008/2012, UNIX (Solaris, AIX), Linux, Novell Netware3.12, MVS

SCRIPTING LANGUAGES: Powerscript, JavaScript, HTML, XML, Perl,Shell.

OTHER SKILLS: API, Installsheild, Cold Fusion, SQL Builder, JSP, PVCS, Object Cycle, SQLProgrammer, Sybase EA Server, MS Office Suite, EDI diagrams, PowerImage, Web Graphics Creation (artwork), Composer, Sun T4-2, Cornerstone.

PROFESSIONAL EXPERIENCE:

Marketing Associates, Detroit, MI Mar 2016 - Present

PowerBuilder Developer

Responsibilities:

Created, Customized and managed stored procedures, functions and to triggers for database.

Implementation of business rules and implemented database conversion.

Migrated PowerBuilder application pbls from version 10.5 to 11.5 and 12.5

Maintain Defects of the PowerBuilder Application along with resolution steps, change request of the PowerBuilder Application and issues with the application.

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.

Wrote complex procedures & functions in Sybase 12.5 environment to incorporate business rules and constraints.

Led all project efforts including requirements gathering and JAD sessions.

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.

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).

Designed, architected, and implemented the system enhancements which utilized PowerBuilder for dynamic front end user interface.

Wrote auditing triggers, complex procedures & functions using PL/SQL to incorporate business rules and constraints.

Designing standard Framework as per PowerBuilder Foundation class.

Reviewed the PowerBuilder code to understand the requirements and created the technical specification documents.

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 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.

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.

Environment: PowerBuilder 10.5/11.5/12.5, PFC, Sybase 12.5 ASC, Crystal Reports 2008, Oracle 9i/10g, PVCS, SDLC, Shell Scripting, Windows XP, MSOffice, Microsoft Visual Studio 2008, .NET Framework2.0, Unix.

Dept. of Motor Vehicles, NV Mar 2014 to Feb 2016

PowerBuilder Developer

Responsibilities:

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 incorporate business rules and constraints.

Conceived system requirements through in depth discussions with the Business and prepared development estimates.

Created number of new tables, views, triggers, screens and data windows as part of enhancements to existing applications.

Wrote Unit Test cases and tested them against the applications being developed.

Provided production support to a number of Power Builder applications by researching and debugging complex problems and solving the issues on time.

Did the Builds for the applications developed and deployed the executable (Implementation).

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.

Wrote new complex stored procedures in Sybase and optimized the existing code written in Sybase.

Participated in requirement collection, analysis, designing for a new module.

Developed related Power Builder objects and GUI for the new module.

Migrated Power Builder application pbls from version 10.5 to 11.5 and 12.5

Provided 24/7 on call production support.

Analyzed end users data needs and developed user oriented solutions which interface with existing applications.

Involved in Bug fixing and enhancements of the application.

Supported and enhanced institutional accounting software for small to mid-sized applications and designed using Power Builder 10 with MSSQL 2005 and T-SQL.

Environment: PowerBuilder 12.5, PFC, Sybase 12.5 ASC, Oracle, SQL server 2008, Windows 7, MS-Office Suite.

Northwestern Mutual Life (NML), WI Jan 2013 to Feb 2014

PowerBuilder Developer

Responsibilities:

Responsible for guiding other developer on analysis, debugging, code review and maintaining PowerBuilder based application.

Requirement Gathering and Analysis.

Involved in the development of the application based on Sybase PowerBuilder.

Built and maintained application based on PowerBuilder 10.5

Prepared Technical Design Documents based on Business Requirements.

Succeed in testing strategies using unit test plans, integration test plans and system test plans.

the PowerBuilder Application and issues with the application.

Develop Deploy guide and lead the development efforts in the Development, Testing, Stage and Production environments.

Maintain the application version management using CVS (Open source Version Control).

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.

Developed and deploy components developed as a Non-visual object and data windows in PowerBuilder.

Involved in writing PowerScript for different DataWindows.

Created/Updated some Triggers and Stored Procedures using Dynamic 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.

Developed complex SQL queries for data retrieval from various database objects including tables, indexes and views

Involved in writing SQL Loader control file for flat file data from other departments and scheduled them in UNIX to load every night in Production Environment.

Performed SQL and PL/SQL tuning using various technics like analyzing, indexing, providing hints, executing stats and explain Plan.

Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

Programming using PowerBuilder Standards.

Involved in installing and configuring of EAServer and conversion of PowerScript code that is compatible for EAServer.

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

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: PowerBuilder 8.03/9.0/10.5, Sybase 11.x, Dynamic SQL, MS Office, SDLC, Agile Methodology, MS-SQL Server 2008, EA Server.

Wells Fargo, Charlotte, NC Dec 2011 to Dec 2012

PowerBuilder 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.

Creating and altering windows, large data windows with complex queries, and procedures, user objects (Visual & Non-visual) and functions.

Responsible for Frame work maintenance and changes as required.

Documentation and implementation procedures for all change requests assigned as scheduled in time estimate.

Maintain the application version management using VSS (Open source Version Control).

Troubleshooting and maintaining applications in a n-tier environment consisting of DB2 RDBMS, Sybase EAS [Jaguar CTS], CICS

Migrating the application from Power builder 8.x to Power builder 9.x

Design program logic, prepare test data, and test programs, system testing.

Creating and altering Tables, procedures, functions, triggers and packages.

Alter Framework and Business objects to achieve needed functionality

Deploying components on to the application server (Middle Tier) Jaguar CTS

Involved in writing design, technical, enhancements documentation.

Creation of Different types of reports such as Master/Detail cross tab and graphic (for trend analysis). Use of filters, conditions, calculations, etc.

Maintain and provide documentation of workload activities and time spent on projects.

Environment: Power builder 6.5/7.0.2, PFC, Oracle8i/9i, Windows NT, PL/SQL, TOAD Suite7.x, MS SQL Server 7, PVCS, HP-UX, MS-Office 2000

Avaya Solutions, Hyderabad, India Sept 2010 to Oct 2011

PowerBuilder Developer

Responsibilities:

Coding, testing, debugging and production support of the application using Power Builder

Analysis, Design, development and Enhancements of the various applications.

Troubleshooting and maintaining applications in a distributed environment consisting of Sybase RDBMS, Sybase EAS [Power dynamo and Jaguar CTS]

Converting User Requirements in to program specifications and prototypes

Design program logic, prepare test data, and test programs, system testing.

Developing Framework and Business objects using PFC.

Maintain the application version management using VSS (Open source Version Control).

Involved in Creating design specifications, ER Diagrams and business flow diagrams using UML

Creating HTML Data windows, server side components

JavaScript was used for data and form validation.

Generating mail messages to notify Property and status changes to respective authorities

Creating components on the application server (Middle Tier) which is Sybase EAS

Utilized PVCS change control to keep track of version object development changes and to track migration changes and specification changes.

Modified and created Tables, Stored procedures, database triggers and complex queries for reports using T-SQL

Involved in writing design, technical, enhancements documentation and test plans

Environment: PowerBuilder 6.5/7.0 with PFC, Sybase EA Server3.0, MS-SQL Server6.5, Sybase 11.x, Java, PVCS, Transact-SQL, Windows NT, MS-Office

Contact this candidate