powerbuilder developer
Resume:
Srinivas
PowerBuilder Consultant
717-***-**** adilfs@r.postjobfree.com
Experience Summary
Around 15+ years of experience in System Analysis/Design, Coding, Unit Testing, Testing, implementation, Maintenance and enhancement of Software Applications.
Strong Business Software design and development experience in Pharmaceutical, Manufacturing, State government, Insurance using PowerBuilder, Oracle, MS SQL Server 2000/2005/2008, Sybase, Unified Modeling Language, Rational Rose, C, Unix.
Had a training on C#, Vb.net, Asp.net, Asp.net MVC, Grid View, Ado.net, Linq, JavaScript, Jquery and WCF.
Expertise in writing complex PL/SQL Stored procedures, Functions, Triggers,
Query optimization and Performance Tuning.
Experience in using, successfully completed four full life cycle implementations using PowerBuilder versions 12.5/11.5/10.5/9.0/8.0/7.0/6.5.
Knowledge on migrating applications in PowerBuilder 6.5/7.0/8.0/9.0 to latest version.
Experience with the full life cycle software development of client server based applications and architecture. Quality procedures in development and maintenance of the application.
Extensively worked GUI applications and screens, designed the GUI and coded the GUI. Also involved in project GUI specs, design and prototype.
Generated PowerBuilder Reports 10.5/9.0/8.0/7.0/6.5.
Wrote Technical Documents on Reports developed.
Extensively used QUEST Tools (TOAD), and SQL*PLUS.
Strong Knowledge on Software Models, Software Analysis, Design, Requirements and networks.
Ability to interact effectively with clients, Understanding their requirements and providing optimum solution and support.
Excellent Analytical, interpersonal and communication skills.
Quick learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.
Experienced in working in a team environment.
Skills
Languages
PowerBuilder, SQL, PL/SQL, T-SQL, C, C++, UML, Shell Scripts, Java, XML, .net.
RDBMS
Oracle 9i/10g, SQL Sever 2008/2005/2000, MS-Access, Sybase 10, 11,12.5.
Tools & Utilities
Toad, SQL Developer, Unix, Visual Basic 6.0, WinCvs 1.2, Microsoft Visual Studio 2012.
Servers
Unix Servers, EAS Server
Version Control Tools
Object Cycle, Visual Source Safe, Clear Case, Team Foundation Server
Testing Tools
Test Director, JMeter
Operating Systems
Windows 8/7/vista/XP/2000/NT/98, Unix
Education
Master of Science in Computer Science from Nagarjuna University.
Projects Overview
Client: Texas Education Agency, Austin, TX Feb 19 – Till Date
Role: Sr PowerBuilder Consultant
Description
Educator Certification Online System for Educators (ECOS for Educators) allows Texas educators and prospective Texas educators to apply and pay for certification, renew standard certifications, transfer out of state or country credentials, and fingerprint services. The application also enables certified Texas educators to view and print their certification(s). Educator Certification Online System for Entities (ECOS for Entities) allows personnel from Educator Preparation Programs (EPPs) to add prospective Texas educators to their program approve exams and recommend applicants for certification through their program
Responsibilities
Created robust stored procedures (SP) having custom error handling try-catch blocks with transactions for planned error handling rollbacks to recent commits and save points.
Developed software application using PowerBuilder 12. 5 for Windows.
Study existing power builder application functionality by reviewing the client side powerbuilder code, serverside sybase code (store procedure/triggers) and dabase architecture.
Created the database and developed stored procedures, dynamic SQL, functions and views by using Sybase.
Designing, coding, and testing application components following architecture guidelines.
Interpreting and translating business requirements into functional and technical specifications.
Participating in large development projects and contributing skills in development life cycle phases.
Troubleshooting defects and optimizing for enhancing performance
Successfully developed a web application by using ASP.NET MVC5, Web API with AngularJS and Ado.net in the environment by using Visual Studio.
Environment: PowerBuilder 12.5, Sybase, T-SQL, SQL, Windows 10, Unit Testing, Sql Developer, Tortoise SVN, C#, Asp.net Mvc, Html, Css, Bootstrap, jquery, Web Api, Ado.Net, AnularJs.
Client : NY Human Resources Administration, Brooklyn, NY Jul 16 – Jan 19
Role: Sr PowerBuilder Consultant
Description
The Human Resources Administration or Department of Social Services (HRA/DSS) is the department of the government of New York City in charge of the majority of the city’s social services programs. HRA helps New Yorkers in need through a variety of services that promote employment and personal responsibility while providing temporary assistance and work supports. The Paperless Office System is our Agency’s computer system that will completely change the way work is processed within job centers.
Responsibilities
Developed Front end windows using PowerBuilder 12.5 and Oracle as backend.
Involved in impact analysis, design, and development phases for maintaining the application.
Participated in the client review meetings.
Created technical design documents and performed design reviews.
Created stored procedures, cursors, triggers, and views in PL/SQL and modified existing ones so that the old and new functionality is supported.
Involved in performance tuning of database queries.
Involved in Bug fixing and enhancements of the application.
Participated in code reviews.
Followed the source code check in/checkout procedures in SVN.
Created test cases and performed Unit Testing.
Provided assistance to QA team while testing.
Trained new members.
Developed disability screen projects using Visual Studio 2012, C#, Asp.net Mvc and Oracle.
Coded in ASP.NET MVC4 (Bootstrap/HTML5/C#) Web Application in Schedular Tool interacting with (Oracle 11g/12c) data utilizing Test DriveDevelopment.
Environment: PowerBuilder 12.5, Oracle 11g/12c, PL/SQL, SQL, Windows 7, Unit Testing, Toad, Sql Developer, Tortoise SVN, C#, Asp.net Mvc, Html, Css, Bootstrap, jquery.
Client : Dept. of Housing Preservation & Development, NY, NY Jan 14 – Jun 16
Role: Sr PowerBuilder Consultant
Description
Using a variety of preservation, development and enforcement strategies, HPD strives to improve the availability, affordability and quality of housing in New York City. As the nation’s largest municipal housing organization, HPD works with private, public and community partners to strengthen neighborhoods, and enable more New Yorkers to become homeowners or to rent well-maintained, affordable housing.
Responsibilities
Performed analysis, development and maintenance of a Client Server PowerBuilder application running on an Oracle relational database.
Communicated with team members and end users to acquire an understanding of the business logic.
Worked with business analysts to gather requirements from end users for technical specifications.
Debugged and repaired existing problems found in the PowerBuilder application.
Performed data fixes related to the PowerBuilder applications via SQL Developer on the Oracle database.
Wrote stored procedures.
Created PL/SQL script driven data fixes.
Write and maintain PowerBuilder applications using PowerBuilder objects including windows and data windows etc.
Extensive coding in PowerBuilder, for data window, window, menu,
application object, user objects, OLE objects, interfacing DLL's. On the
database side, expertise with Oracle 11i.
Environment: PowerBuilder 12.0, Oracle 11i, PL/SQL, SQL, Windows 7, Unit Testing, Toad, Sql Developer, Check in/check out tool.
Client : Dept. of Health and Human Resources, Lincoln, NE Sep 12 – Jan 14
Role: Sr PowerBuilder Consultant
Description
The CHARTS System is the automated computer system developed to monitor and maintain Child Support Enforcement information for the State of Nebraska, Department of Health and Human Services (DHHS). Child Support Enforcement (CSE) is one of the many programs that make up the DHHS Division of Children and Family Services.
Responsibilities
Application support and Development of new modules and new Change requests.
Participated in requirement collection, analysis, designing a new module.
Develop and test PowerBuilder code in accordance with business rules, system technical requirements, specifications, and client security standards.
Developed the Test scripts for the new Module.
Developed related PowerBuilder objects and GUI for the new module.
Developed the business functionality using Powerscript and Oracle.
Worked with a team of 8 developers.
Testing the new business logic and modules.
Maintain the application version management using PVCS.
Creating technical design documents.
Environment: PowerBuilder 12.5, Oracle 11i, PL/SQL, SQL, Access database, IBM Lotus Notes, Crystal reports, Windows 7, PVCS, Unit Testing.
Client: Sears, Chicago, IL Jan 12 – Aug 12 Role: Sr PowerBuilder Consultant
Description
Sears is an American chain of department stores. During my tenure at Sears, I worked on CORE/MPI project. There are certain functionalities for adding and maintain Sears items that can be done only in CORE/MPI and not in IMA. CORE/MPI is used for such functionalities. For instance how we have different vendor #’s that are associated with items. When they build their items they also build the vendors associated to it. Allot of time there are items that are sold which are housed in different warehouses. Each of those warehouses have different vendor numbers associated to them. Those warehouse vendor #’s do not exist in IMA open item database.
Responsibilities
Providing technical support for Sears applications, which are developed using PowerBuilder, Oracle and DB2 platforms.
Application support (Tickets) and Development of new modules and new Change requests.
Developed related PowerBuilder objects like (windows, datawindows, UserObjects) and Database Objects like (Stored Procedures, packages, functions, types, Tables, views etc) using Oracle and db2.
Significant experience in project management likes conducting the weekly meeting, having the functional and technical related discussions, Resource management, work distribution, meeting the project deadlines.
Significant experience in User training, pre sales and Project demos.
Maintain the application version management using Tortoise SVN (Open source Version Control).
Involved in Unit testing, module Integrations and preparation of test case.
Coordinated efficiently in a Team of 5.
Involved in writing Technical Specification Document.
Designed the components design using UML and ER diagrams.
Environment: PowerBuilder 11.5, Db2, Oracle, PL/SQL, SQL, Pacman tool, Windows XP/7, PFC, Tortoise SVN, Unit Testing.
Client: Department of Health, Olympia, WA Jul 09 – Dec 11 Role: Sr PowerBuilder Consultant
Description
Client Services application is a part of Client Information Management System (CIMS) for Washington WIC (Women, Infants and Children), used in WIC clinics. This application is used to certify the clients for WIC eligibility. Certification is the process where by an individual is evaluated to determine eligibility for the WIC Program. All persons wishing to participate in the WA WIC Program must have their eligibility determined except those persons transferring within a valid certification period with proper verification. If clients are eligible, the individual will enroll in the program and be issued with supplemental food checks.
Responsibilities
Providing technical support for CIMS applications, which are developed using PowerBuilder and Syabse platforms.
Develop, test and deploy PowerBuilder code in accordance with business rules, system technical requirements, and client security standards.
Wrote Stored Procedures and Triggers.
Optimized the SQL Statements in order to avoid the database overloading.
Involved in Coding, Component development using Power Builder.
Extensive experience with T-SQL, SQL Scripts.
Modified the existing systems to suit user requirements.
Did System Analysis and designing for modifications.
Did Version Control using Surround SCM Client.
Responsible for performing trouble shooting on application and database errors.
Involve implementing ad-hoc reports using sql for business analysts or clinic staff.
Works in a wide range of problems in related applications and functions. Determines system specifications, input/output processes and working parameters to meet business requirements and hardware/software compatibility.
Provided online support to these systems and also provided the on call support after regular business hours.
Environment: PowerBuilder 10.5, Syabse sql anywhere, T-SQL, Source Native, Windows XP/Vista, PFC, Unit Testing, UML.
Client: Kingsway Insurance Information System, Mobile, Al Sep 08 – Jun 09
Role: Sr PowerBuilder Consultant
Description
Kingsway provides insurance solutions to manage specialty risks for individuals and businesses in the United States and Canada. Its primary business is the insuring of drivers who do not qualify for standard automobile insurance coverage because of their payment history, driving record, place of residence, age, vehicle type or other factors. Other products in the Kingsway portfolio include trucking insurance, commercial automobile insurance, commercial and personal property coverages, standard automobile insurance, motorcycle insurance and other specialty lines. Its subsidiaries include Universal Casualty Company, American Service Insurance Company, Southern United Fire Insurance Company, Lincoln General Insurance Company and Hamelton Insurance Company.
Responsibilities
Prepared design/development specification documents from requirement document.
Participated in Gap analysis with business analysts and users.
Worked on several maintenance calls that involved PowerBuilder code changes.
Involved in Unit Testing.
Assisting solutions to problems related to software design.
Supporting Loss Prevention and Incident Management System using PowerBuilder 9.0 and SQL Server 2005.
Recommended solutions to problems related to software design.
Normally received general instruction on routine work, detailed instructions on new assignments.
Did Powerscripting using PFC.
Generation of reports in PowerBuilder and save in different format.
Assisted the client manager with preparation of Reports for review.
Expertise in User objects of PowerBuilder.
Creating tables and Writing SQL Quires.
Design Test Plan, Test Scenario, approving Test cases, Test data & Test results, Issue Log Setting up the Database, GUI and Coding standards for the Project.
Environment: PowerBuilder 9.0, SQL Server 2005, PVCS, ClearQuest, PFC, Windows XP, PowerBrowser, Regression Testing, PowerDelta.
Client: SeaWorld, St. Louis, MO May 07 – Aug 08 Role: Sr PowerBuilder Consultant
Description
SeaWorld is a United States chain of marine mammal parks, oceanariums, and animal theme parks owned by SeaWorld Parks & Entertainment. During my tenure at SeaWorld Parks & Entertainment, I worked on ParkWare project. Parkware has different modules like Attendance Module, Financial Module and Daily Reporting Module. Attendance module handles the total Attendance and Seven FCS categories to the sub category level. The Financial Module includes Profit and Loss reporting on a single park (Park Profit and Loss Statement) and a multiple park (Multi-park Profit and Loss Statement) level.
Responsibilities
Work closely with the customer and functional users to gather requirements to develop or modify the application.
Participate in analyzing, prepare design specification, perform or assist in all phases of system analysis and application development using Powerbuilder and Sybase.
Document customer requirements for development and maintenance of business application.
Analyze and resolve application defects in the production environment.
Writing complex Sybase Stored procedures, triggers & functions to process data.
Worked on PFC’s.
Performance tuning and query optimization of various procedures & Dynamic SQLs / Report SQLs used in the application.
Application deployment, implementation & provide ongoing production support.
Developed custom user objects and used them in the application.
Visual SourceSafe was used as a source repository and Remedy Tool was used to track bugs.
Involved in unit testing, integrated testing and system testing.
Involved in Preparation of Software Maintenance Technical Document for the application maintenance.
Created the Packages and the Stored Procedures to, fetch and update records from/to database.
Environment: PowerBuilder 9.0, Sybase, Visual Source Safe, SQL, T-SQL, Windows2000/XP, Clear Quest, PowerBuilder Foundation Classes.
Client: T-Rex Entreprises, India Feb 06 – Apr 07
Role: PowerBuilder Developer
Environment: PowerBuilder 8.0, PFC, Oracle 8i/9i, PL/SQL, Windows 2000, PVCS (for configuration), TOAD 7.0, PowerDesigner.
Client: MYM Trade and Channel Ltd, India Jun 04 – Jan 06
Project: Financial Scheduling Management (FCM)
Role: PowerBuilder Developer
Environment: PowerBuilder 8.0, PFC, Power Designer, SQL Server 2000, Windows XP, Windows 2000, Windows 98, PVCS (for configuration).
Contact this candidate