Design, develop & support CCMS (city contracts management system) home made system for DYCD. The system designed to handle vendor’s info and financial processing. The system was design using PowerBuilder (versions 5, 6, 7, 9, 10.5 & 12.5) as front end and MS SQL server (2000/2005/2008) as back end. Analyzed business requirements for application modifications. Developed automated custom ETL process for financial applications• Experienced in troubleshooting and debugging the code (back-end & front-end)• Developed stored procedures, functions, triggers, DTS Packages.• Was responsible for back-end conversion from SQL server 2000 to 2005/2008.• Provide customer support

Results-oriented IT professional with expertise in the architecture, design and development of the all phases of the Software Development Life Cycle. Significantly raised productivity levels by applying reengineering methodologies and innovative technology solutions. Proven ability to build strong relationships with team and clients using negotiation talent, persuasion and demonstrated commitment. Strong analytical and problem solving skills with a proven track record of successful solution delivery in a timely manner.

Designed, developed & supported over 30 home made different systems for more then 300 users across 10 offices (USA, Canada & Ireland). Maintained, supported and validated disaster recovery test. Developed and supported different kinds of Automated Reconciliation systems to identify open balance details. The system was designed using PowerBuilder (version 9) as front end and MS SQL Server (2000/2005) as back end. Designed and implemented logical and physical database architecture for this project, created stored procedures, triggers and views. Was responsible for existing data conversion from CODA to PeopleSoft (PS). The system was able to run automatically - download data from different systems (summary - PS/GL and details - 'Info lease'), runs all kinds of validations, grouping data based on specific parameters and imports data to the Reconciliation system. The systems were designed for domestic and European users.Developed and supported Check Writer System for number of internal and external users. The system was design using PowerBuilder (versions 6, 7 & 9) as front end and MS SQL server (7/2000) as back end. The system was design for creating (printing) paper checks or provides an electronic type of payments (EDI, ACH & WIRE). Users, based on security level, can make manual entries or import data (payment information) from other systems. The system was design to produce checks for 5 different banks (US and Canada - each bank has own standards and rules) and creates output files for PeopleSoft, source systems and payment conformation file for the bank. The checks were printed on Troy printer on the blank check stock paper.Designed and developed application using VB 6.0 and Crystal Reports (6 & 8.5), for generating different type of reports and handle equipment inventory processing. The system was developed using VB 6.0 as front end and MS SQL server as back end.

Responsible for design, development and implementation of application for ChaseMellon SS. The system designed to handle financial processing such as Check Reconciliation, Balance Adjustment, Open Items Report, Security and Maintenance Screens. Environment was PowerBuilder 5.0 & PFC, Windows (front end), Sybase System 11, Transact SQL (back end). Database queries and data manipulations were implemented using stored procedures. Responsibilities consisted of front end design and coding as well as back end coding.Design and development applications using VB5.0, VB 6.0 and Crystal Reports. The applications were design for generating different type of reports and handle financial processing. Responsibilities consisted of front end design and coding as well as back end coding using VB 5.0, VB 6.0 as front end, Sybase System 11 Transact SQL (back end), development and coding of reports based on user's request utilizing Crystal Report.

Was involved in analysis, design, development and implementation of Retailer and Tag portions of a system for E-Z Pass for the TBWMS (Toll BeltWay Management System). The system was developed to process all aspects of operating Customer Service Center in order to provide Electronic Toll Collection Information such as tags, tag holders, suppliers and back office processing. The system was developed with PowerBuilder 5.0 (using PFC), ORACLE 7.3.

Participated in analysis, design and coding of Service and Sales Management Tracking System. The system was designed to handle customer orders, equipment tracking, billing payment collection and various reports. Specific responsibilities include: user interface design, coding using PowerBuilder as front end and Sybase System 10 as back end. Worked closely with users to define and support their needs.

Participated in design, development and testing of the software package for checking PC boards. These programs were developed for Taradyne system 'Zihntel' 1800 and 1820.Prepared documentation, trained users.