Summary

• I am a Experienced Powerbuilder Developer with number of years of hands - on experience in development and enhancements of complex Client Server and Web Based Applications, Database and Reporting Modules Development for various types of Financial, Business and Medical Processing applications, hard working and results oriented person. Quick learner and very good team player.
• I have a significant experience in Programming of Business Applications and Reports for Client Server and Web Applications, Distributed Applications, Data Marts and Data Warehousing Techniques as well as in all stages of Software Development Life Cycle-from gathering, documenting and analyzing users business requirements and design of a Relational Data Bases, Powerbuilder Applications, Interfaces to Third Party Software Applications, Applications integration, Data Marts and Data Warehousing concepts, data conversion, applications development, testing and implementation. I possessed good analytical skills and wide variety of experience in Database Design and Objects-Oriented Powerbuilder Applications development.
• Have extensive knowledge in systems development life cycle concepts and possess good experience in translating business process flow into requirements, developing Business System Process Definition documentation, and translating user's requirements and business needs into software specification requirements and into code as well as in Applications Unit and System testing, Debugging and
• Implementation.
• I have developed and implemented variety of Processing and Reporting Client Server PB 8 and PB 12.5 Based Applications and have considerable experience in Database development, Data Marts Development, Systems Integration, Object Oriented Analysis and Design, OOD Concepts, J2EE, Java, JSP, MS SQL Server, SQL, Transact SQL, Stored Procedures, Triggers, Application Performance Enhancement, Reporting, Framework Foundation Classes for Powerbuilder for Powerbuilder Reports, Universes and Business Objects concepts for Web Intelligence R2 etc.
• Participated in writing manuals and standards for Customer's Requirements gathering process, use of best Development practices, Stored Procedures Naming Conventions etc. Design and development processes, we developed, were designed by best industry developing standards and they are in compliance with ISO 9000 / 6 Sigma practices. I also have an experience in Source Code Management Tools We used MERANT PVCS
• and Clear Case for most of our purposes .
• Have some experience with UNIX / Linux Red Hat 7 and Shell Scripting,
• ftp, files directory structures, copying, Writing, VI editor, etc. . I am not working with UNIX on everyday basis, only using it once in a while, but I am pretty comfortable within UNIX Environment.
• Experience with Web Intelligence Business Objects XI R2 for developing Universes and Reports.
• Some of my accomplishments are:
• Designed, developed and implemented Stored Procedures, Views, and Powerbuilder Framework Objects, to create and process reports for ALL FSCO Processing Applications. This module used for the reports for all applications to create reports, extract data, filter reports based on the users criteria, and store the reports as a Data Windows, Text Files or Excel Files on the certain directories this system was created prior to wide use of Sharepoint and allowed to distribute and exchange reports
• Designed, developed and implemented QIC C2C Application to process 2nd Level of Appeals for multiple subcontractors for all US MAC. Application Included MS SQL 2008 Database with large number of
• Setting tables, Powerbuilder and Open Span Application Interface module that allowed to enter results of appeals entry, claims scraping from mainframe, claim lines selection and appeals processing from
• MS SQL Server Database into Government MAC Website Siebel Applets .
• System also included SQL Server Reporting System, Number of SAS Management Reports and SAP Business Objects WEB INTELLIGENCE XI R2 Application with number of Universes and Drill Down Management Reports
• Participated in the development of IBM DB2 Data Warehouse Star Schema Tables and Views
• Data is being loaded into Data Warehouse from the flat text files, Data from files is treated and loaded into the STAR Schema tables according to Setting/Master Tables entry.
• Data from Data Warehouse is consumed by number of Claims Automatic System CAS Processing applications.
• Designed and developed framework for number of unique Claims Automatic System CAS automations and number of CAS Automation to automate IVR Claims Processing, Flu Rosters Claims Processing, Outstanding RUC Image Claims Processing, ECRS CAS Automations. All Automations are communicating with Mainframe via. HLLAPI and allow to automatically read mainframe image information from mainframe into database and date warehouse, automatically adjust claims, process decisions, automatically create letters, create and process different reports, automatically create report of outstanding accounts and significantly reduce human involvement into claim processing and files creation and uploading into government information systems and data warehouse.
• Designed, developed and implemented number of Database Entities, Views,
• JAVA 1.2. Framework objects and number of Packages for Trucking Company Invoice Factoring WEB Application, Oracle Database Entities, Views, and Java Objects for data access, data manipulation and number of GUI Objects JS and JSP's for GUI..
• Software: Oracle 9i Database, Java 1.2.1, J2EE.
• Graphic User Interface was developed using Java Sever Pages JSP's and HTML.
• Description: WEB Application that enables users from to manage Customers and Debtors Database, Invoices, Billing and Cash Receivables. Customers and debtors have access
• To the number of screens at the number of packages, but have read only rights.
• Extensive use of security, based upon development and implementation of Views,
• Roles security tables and Java Objects. System is replacing old Sybase Based System in Oregon.
• Designed, developed and implemented Smart Tax Decision System for Front End System FES / Client-Server applications, PowerBuilder 8.0
• Software: PowerBuilder 6.5, Corner Stone, Sybase 11 Database, VERTEX Zip Codes
• Description: Analyzed user's requirements and developed business specifications and coded PowerBuilder Application for Smart Tax Decision to enable Financial Analysts to perform new Automatically Calculate and appropriately fill on Invoices Local and State Sales Taxes Up-front, Collateral, etc. based upon Customer Site Zip Code. Application is compatible with VERTEX Vendor Software. reduced erroneously sent bills and invoices by 80, prevent wrong zip codes inserting
• I hope, that my strong experience and background will match your needs, and will be and should make me a useful and hopefully valuable addition to RBS Citizens Financial Group IT team. It would be exciting if I can participate in development of cutting edge Applications and make my contribution in your Reports Development effort.
• I would like the opportunity to discuss my qualifications and your client's requirements with you in person or by phone at

SUMMARY:

• Experienced Software Developer with years of hands-on experience in Client Server and WEB Applications development for various types of Financial and Business applications for different Operating Systems and Platforms. Hard working and results-oriented person, good team player.
• Possess solid experience in all stages of application development life cycle gathering and analyzing users business requirements, Specifications and Test Plans preparation, RDBMS design, Database Development, Object-Oriented design and Development, Reusable business Objects Development, SQL, TSQL, PL SQL, Stored Procedures, Triggers, GUI Development with JSP, etc.

TECHNOLOGIES AND TOOLS:

• Powerbuilder 6.5, 7.0, 8.1, 12.5 PFC., Seagate Crystal Reports 7, 9, Business Intelligence XI R2
• SYBASE 10, 11, 12.5 Releases, ORACLE 8i, 9i, IBM DB2 7 and MS SQL Server 2005 and 2008 RDBMS, SQL, T- SQL, PL /SQL PVCS MERANT, Clear Case and Visual Safe Source Code Management Tools
• MS Windows 95, Windows 98 Windows NT 2000, Windows XP

EXPERIENCE:

Confidential

Programmer Analyst

• Designed, developed and implemented Stored Procedures, Views, and Powerbuilder Framework Objects, to create and process reports for ALL FSCO Processing Applications. This module used for the reports for all applications to create reports, extract data, filter reports based on the users criteria, and store the reports as a Data Windows, Text Files or Excel Files on the certain directories
• Designed, developed and implemented QIC C2C Application to process 2nd Level of Appeals for multiple subcontractors for all US MAC. Application Included MS SQL 2008 Database with large number of
• Setting tables, Powerbuilder 12.5 and Open Span Application Interface module that allowed to enter results of appeals entry, claims scraping from mainframe, claim lines selection and appeals processing from
• MS SQL Server Database into Government MAC Website Siebel Applets .
• Participated in the development of IBM DB2 Data Warehouse Star Schema Tables and Views
• Data is being loaded into Data Warehouse from the flat text files, Data from files is treated and loaded into the STAR Schema tables according to Setting/Master Tables entry.
• Data from Data Warehouse is consumed by number of Claims Automatic System CAS Processing applications.
• Designed and developed framework for number of unique Claims Automatic System CAS automations and number of CAS Automation to automate IVR Claims Processing, Flu Rosters Claims Processing, Outstanding RUC Image Claims Processing, ECRS CAS Automations. All Automations are communicating with Mainframe via. HLLAPI and allow to automatically read mainframe image information from mainframe into database and date warehouse, automatically adjust claims, process decisions, automatically create letters, create and process different reports, automatically create report of outstanding accounts and significantly reduce human involvement into claim processing and filrs creation and uploading into government information systems and data warehouse.
• Converted number of Powerbuilder6.5 IBM DB2 Applications into Powerbuilder8.03.
• COMPLAINT TRACKING APPLICATION, MERPARD, FRAUD TRACKING APP.
• Designed, developed, implemented number of application enhancements, such as Reporting Module,
• Security Module, Data Validation Module, etc. Re-Designed and enhanced existing reports to improve data retrieval and processing efficiency.
• Designed and developed number of Objects, PBL s, Business Objects NVO's and GUI Screens for newly developed COMPLAINT HEARING Application Powerbuilder 8.03 / PFC /MS SQL Server 2000 . Project Implementation helped customer to Bid for Government Contract. Contract awarded in Oct. 2004.
• Developed and designed number of Specifications and Test Plans for the COMPLAINT TRACKING APPLICATION, MERPARD and FRAUD TRACKING APP.
• Designed and developed SQL Server Reporting System, Number of SAS Management Reports and SAP Business Objects WEB INTELLIGENCE XI R2 Application with number of Universes and Drill Down Management Reports for number of DSO Powerbuilder Applications.

Confidential

Senior QA Business Analyst. Contract at Augusta, Maine

• Developed and designed number of Specifications and Test Plans for the State of Maine Bureau of
• Financial Management System Powerbuilder 7 and Oracle 8 Client Server Application
• Streamlined number of Oracle Packages and Store Procedures to improve processing efficiency.

Confidential

Senior Programmer-Analyst.

• Developed and designed number of packages and Framework Objects for Trucking Company Invoice Factoring WEB Application. Including number of Oracle Database Entities, Views, and Java Objects for data access, data manipulation and number of GUI Objects JS and JSP'S for data presentation. Designed and developed number of framework objects for this application.
• Designed and implemented variety of PB 6.5 / 8.0 PFC applications and applications enhancements, such as:
• Consolidated number of multiple Front End Applications from multiple GUI's and multiple Databases for Front End System FES into one single GUI and one single database which significantly reduced code maintenance time up to 70 .
• Developed and implemented Smart Tax Decision System Application for automatically
• selection of Vertex Tax Codes Values based upon Customer Zip Codes for any area in the US,
• Canada and majority of Foreign Countries. Build in Application reduced invoices preparation time and reduced number of erroneously sent invoices by approximately 80
• Developed and implemented on - line Credit Application and Automated Credit Scoring.
• Application capture and validates data from Requests for Loan, submitted trough the Internet. Built Data File is sent to Fair Isaac Credit Bureau and returned Credit Score enables Financial Analyst to make the decision for credit approval or rejection prior to starting loan processing. Implementation Reduced Applications processing time up to 25-40 .
• Designed, developed build-in Separate Application Functionality for retrieving data from Database
• Tables and creating and printing variety of different documents, Loan package comprised of.
• Reduced Loan Documents Package Preparation Time up to 70 .
• Developed and implemented Smart ESCROW Taxing System that enables user to
• calculate, and process ESCROW Taxes for financed commodities. Application is based upon
• extensive use of Remote Procedure Calls, that allow to retrieve information from different servers and Databases, GL and Accounting Systems are stored in remote locations.

Confidential

Programmer-Analyst.

• Designed and implemented number of PB 5 6 applications such as Inventory,
• Purchasing Invoicing, Work Orders, Small Medical Office package that included personnel and patients tracking, appointment scheduling, billing and various reporting capabilities. Duties included preparation of Technical Documentation on various stages of Product Development and providing Users' Training.
• Developed and implemented specialized applications for Material Analysis Labs such as
• Spectrometer Calibration, Chemical Composition and Strength of Materials Reporting using
• Powerbuilder 5 on WIN 95 platform.

Confidential

• Performed general data modeling: normalization referential and entity integrity, access
• ptimization, data validation, business rules development and enforcement, developing Triggers, Stored Procedures, Views, etc.
• Participated in design and implementation of complex database for Materials' Properties
• Selection Materials' Purchasing.
• Participated in design and implementation of very complex database for Help Desk and
• Asset Management application.

Confidential

• Developed and implemented various applications for Metal Casting industry:
• Casting assistant Database - for calculation of Raw Charges,
• Gates Sizes, Melting and Pouring parameters etc. for different types of castings and different
• types of materials, Database / Library of Standard CADD Blocks for Casting Patterns, Foundry Tooling and Shops Layout Design for AutoCAD 9 / 10, etc.

Confidential

Participated in various stages of casting process predictability and parameterization studies.