Management Design
Resume:
Prasad
Powerbuilder Consultant
*******@*****.***
Experience Summary
About 8+ years of experience in analyzing, developing, implementing,
maintenance of financial and marketing application systems. Extensive
experience in designing client/server applications using Object oriented
programming in software development lifecycle. Worked extensively with
PowerBuilder 8.0/7.0/6.5/6.0/5.0, PFC, Oracle 9/8i/8.x/7.x on Unix/NT,
Sybase, DB2, Infromix4GL, RPG, SQL Anywhere and Power Designer. Skills
include developing packages, procedures, functions and database triggers
using PL/SQL and T-SQL Experience in the design and development of real-
time Radio Frequency (RF) applications that encompass the use of state-of-
art technologies like RFSDK and BarTender, and Symbol PDT 6 Series hand
held devices.
. Extensive experience with PowerBuilder Foundation Classes.
. Migrated PowerBuilder applications from Pb5.0 to Pb6.0, PB6.5 to PB7.0,
PB6.5 to PB8.0 and from PB9 to PB10.
. Experience in the design and development of commercial banking
applications and financial management systems.
. A good practical knowledge of object oriented analysis, design and
programming.
. Experience in the development and maintenance of vertical Laboratory
Information Management Systems (LIMS) applications.
. Developed applications in a client/server environment using PowerBuilder
8.0, 9.0, 10.0 Sybase System 10 & 11, Oracle 9i, and MSSQL Server
2000/2005.
. Hands on experience with reverse engineering using case tools like Power
Designer and S-designer.
. Extensive Knowledge of PL/SQL codes for Oracle 8i/9i like stored
procedures and triggers.
. Extensive experience in developing client server applications.
. Experience in development and administration activities like designing
reports, creating database objects.
. Maintaining different application versions and objects, archive files
through PVCS, Object Cycle
. Creating users, roles privileges and maintaining system security using
DBArtisan.
. Experienced in object oriented methodologies
Technical Expertise
Technologies
PowerBuilder 10.5 8/7.0/6.5/5.0, PFC, InfoMaker, VB 6.0, C,C++,JAVA,J2EE
Databases
Sybase 11.5, Oracle 7.x /8i/9, DB2,Informix, SQLAnywhere, MS SQL Server,
Adaptive Server
Operating systems
Windows98/NT/2000 & XP, Unix
Visual Tools
SQL Navigator, S-Designer, Power Designer, APOL, Remedy, DBArtisan, PVCS,
Visual Sourcesafe6.0, Object Cycle, PadLock, PCAdmin, Crystal Reports 5,
RoboHelp, Oasis
Process-practices and Methodologies
CMM level 2, SDM
Professional Experience:
Children, Youth & Families Department, NM
July 2008 - Present
Programmer/Analyst
Project Description:
The application FACTS performs case tracking function for Youth & Family
Services (YFS), Juvenile Justice Services (JJS), Protective Services (PS)
and Early Childhood Services (ECS) workers. This application was developed
in PowerBuilder with Sybase as database. I work in the development,
enhancement and modification of various objects and functions as required
by the business in the course of time. I used the PowerBuilder Native
Source Control and CVS Push-OK Source Control software for team
development.
Roles and Responsibilities:
. Involved in System Design, and Development and Implementation of a
major release and a minor release.
. Involved in creating technical design documents.
. Reporting to the Supervisor about Project updates
. Involved in Unit testing.
. Participated in hands on design, coding and debugging the existing
applications.
. Developed custom user objects and used them in the application.
. Created and altered tables, procedures, functions triggers and
functions in Sybase
. Created complex Stored Procedures, Views, Triggers and Indexes and
implemented performance driven queries with focus on asynchronous data
access.
. Enhanced modify and maintain Oracle DB objects such as triggers
functions procedures and packages using PL/SQL.
. Extensively used Stored Procedures in PowerBuilder as a data source
for data windows.
. Define and draft new functional design changes in the solution as per
business requirements.
. Generated Reports and Nested reports in regard to CREDX. Developed
various Reports, Customized existing reports according to the
functional specifications including Invoice and Expense reports using
PowerBuilder Reports 11.2.
. Designed interfaces with PowerBuilder class with different types of
windows visual and non visual user objects and menus.
. Created different types of Reports using PowerBuilder Report and
Templtates
. Tracking and reviewing all the deliverables.
. Participated in coding, debugging and software testing.
. Maintained excellent SQL skills with hands-on experience with RDBMS.
. Was responsible for meeting goals within time constraints.
Environment: PowerBuilder 10.5, Sybase12/15, CVS Push-OK, WindowsXP,PL/SQL
Tier Technologies, Inc.
Sep '07 -June 08
Sr PowerBuilder Consultant
Project Description:
Performance Series is designed to satisfy the complex and changing
information and processing needs of a diverse set of users in both large
and small governmental organizations. The system provides a standardized
approach to accounting, budgeting, asset management and procurement events,
strict financial controls, and the efficient use of computer resources.
. Creation and enhancements of design documents based on use case
specifications
. Involved in analysis, design, development and support of application
. Involved in client-specific modifications.
. I was involved in all aspects of SDLC.
. Wrote, Altered, tested and analyzed the Oracle stored procedures
. Worked on Designing Screens and GUI.
. Involved in development using PowerBuilder, OOPS Techniques using
Inheritance, Polymorphism and Encapsulation.
. Migrating the application from Powerbuilder 7.0 to Powerbuilder
9.0/10.2.
. Unit Testing, Testing of the application.
. Application support including on call.
. Documentation of Help for the modules developed.
. Involved in creating Unit Test Cases, Unit testing
. Involved in System Integration Testing (SIT) for the application.
. Build and release management
. Peer reviews.
. Member of project review board to analyze the future enhancements.
. Involved in process of identifying technology upgrade options.
. Involved in creating procedures and Triggers
Environment: Power Builder 10.5/11.5,Oracle 8i/9, Sybase, MSSQL,PL/SQL
PowerGen, EA-Server.
Project: Paradigm (Healthcare Product)
March'06 -Aug'07
Client: BCBS, Tampa, FL
Role: Programmer/Analyst
Description: PARADIGM is an Information System for Managed Healthcare,
primarily a medical claim processing application, it identifies member
eligibility for claims processing, Prices claims based on prior
arrangements and controls payment based on authorization and benefits.
Worked on application and understanding of Health Level 7 (HL7) messages
and interfaces for /Orders/ Dispense/Inventory/Formulary/Results/Scheduling
applications OIS
Responsibilities:
. I was involved in all aspects of SDLC.
. Expertise in User objects of PowerBuilder.
. Expertise in building complex PL/SQL scripts.
. Involved in development using Object Oriented techniques using
Inheritance, Polymorphism and encapsulation. Development also includes
parsing XML file sent by the .Net client and accessing the data from
the file.
. Analyzing the nature of issues and giving the rapid and appropriate
solutions for show stopper production issues.
. Worked on the web application using ASP.Net.
. Used Just in Time debugging skills to resolve complex and show stopper
issues.
. Utilized tools TOAD during development of the application.
. Writing Stored procedures, Packages, Views, Cursors, Functions and
triggers using SQL & PL/SQL.
. Designed table structure and coded scripts to create tables, indexes,
views, sequence, synonyms and database triggers.
. Developed and modified PL/SQL packages, procedures, functions,
triggers, reports as per customer requirement to make new enhancements
or resolve problems
. Prepared the Functional Specification Document and the Technical
Specification Document.
. Involved in System Integration Testing (SIT) for the application.
. Coordinating team members in terms of functional, technical and
logical assistance to resolve the issues reported from customer.
. Troubleshoots system environmental issues.
. Support implementation/training activities.
. Providing code reviews, test cases and component specification design
. Application support including on call.
. Documentation of Help for the modules developed.
. Analysis of necessary requirements for efficient use of the database.
. Works in a wide range of problems in related applications and
functions.
. Performs database analysis, design, development, tuning, management,
and Software testing. provides input to documentation and recommends
design changes and/or enhancements to systems. is responsible for
meeting goals within time constraints.
. Provides guidance to less experienced staff.
. Contributed to the preparation and presentation of results to clients
and the professional community. performed database analysis, design,
development, tuning, management, and Software testing.
. Excellent SQL skills with hands-on experience with RDBMS.
. Used Healthcare Standards including HIPAA, HL7
. Provided input to documentation and recommends design changes and/or
enhancements to systems.
Environment: PowerBuilder 9.0/10.5, Oracle 8i/9i, PL/SQL, OLE, HL 7,
EAServer, DOM, Windows 2000, CVS (for configuration), TOAD, ASP.Net, XML,
UNIX
PIC WISCONSIN SEPT'05 -feb'06
Sr Consultant
Project Description:
PIC Wisconsin is a Madison based firm that offers professional liability
insurance and risk management services to health care professionals. Worked
as part of a team of software developers enhancing existing policy
management system (SpeedBoat), Reports (PIC Report), Oasis (finance
management system).
Responsibilities:
. Responsible for the policy reinsurance - enhancement for the policy
management system.
. User interaction for enhanced requirement analysis.
. Made the distribution of funds to the Member Benefit Plan simpler and
more accurate.
. Modified the application to incorporate the business in new states to
increase the productivity.
. Automated the system that eliminated manual maintenance of finance
department's reports.
. Performs database analysis, design, development, tuning, management,
and Software testing. provides input to documentation and recommends
design changes and/or enhancements to systems. is responsible for
meeting goals within time constraints.
. Provides guidance to less experienced staff.
. Contributed to the preparation and presentation of results to clients
and the professional community. performed database analysis, design,
development, tuning, management, and Software testing.
. Provided input to documentation and recommends design changes and/or
enhancements to systems.
. Involved in creation of reports / letters (MS WORD, MS EXCEL) from the
application using OLE.
Environment: Sqlserver2000 /9, SQL/PLSQL, Power Builder 6.5/8.0, PFC, TOAD,
OLE, PCDocs.
SVK SYSTEMS Ltd, Hyderabad
Sep '04 to Aug'05
Client: Sherwin-Williams, OH, USA
Programmer
Project Description:
Product Evaluation, an integral part of LIMS (Laboratory Information
Management Systems),
Provides comprehensive management capability built on state of the art
client-server architecture and utilizes world wide industry standard object
oriented programming features. It facilitates lab testers of Sherwin-
Williams in identifying the quality of the company's chemicals with that of
the competitors. This tool enhances demographic data collection that drives
the production unit.
Responsibilities:
. Design and development of SW Open Database Model, enabling the
integration of multiple data sources into a single interface using 2-
tiered client server architecture.
. Involved in creating procedures and Triggers in Informix4GL
. Business logic was encapsulated into non-visual objects.
. Design and development of Workflow process automation
. Design and development of Product scheduling and tracking
. Implementation services and application training
. Peer, manager, and business users communication
Environment: PLSQL, Power Builder 7.0.3, PFC, DBArtisan, and Power
Designer,Oracle
C K P Cooperative Bank, Mumbai, India Aug'02 to Aug '04
Programmer
Project Description:
The system automates the retail banking operations of any bank. It includes
end to end functions of a bank starting from account opening, day to day
transactions, clearings, transfers, ledger posting & reports, interest
calculations etc. for all account types and deposits to account closing and
year end reports / activities.
Responsibilities:
. Involved in development of Transactions Module and Activity Monitor
Module.
. Migration of PowerBuilder 5.0 application to PowerBuilder 6.0.
. Stored procedures and triggers were written.
. Procedures to upload data from existing system to this system were coded.
. Reverse Engineering was done using the CASE tool S-designer.
. Used Inheritance in objects that have generic functionality.
. Tasks like lookup, base datawindow processing like sorting, Filtering,
refreshing, updating, security management, etc., are delegated to
services / non-visual user objects from the base class.
. Involved in creation of the base framework libraries
. Maintenance of the system and enhancements.
. Involved in creation of user and system manuals.
Environment: PowerBuilder 5.0/6.0, Sybase, RoboHelp
Contact this candidate