OBJECTIVE

A senior level position as an Application Developer/Business Analyst.

SUMMARY

• Substantial experience in building Client/Server and Web applications. Participated in full life cycle of the projects from business analysis and creation of Specifications through coding, testing and implementation.
• Strong analytical, design, and problem solving skills. Emphasis on data integrity and consistency. Project management skills. Excellent written, oral and user-communication skills.

SOFTWARE

PowerBuilder 12, PFC, PVCS, PowerTool, SYBASE/Transact SQL/BCP, SQL Server, Oracle, DBArtisan, Rapid SQL, Embarcadero Products, Informix, Erwin, VWD, ASP.NET 3.5, Visual C , Visual Basic, Business Objects, Crystal Reporting, UNIX, Control-M, CAST, Merant Version Manager, TOAD, Microsoft Office Tools

EXPERIENCE

Confidential

Senior Application Developer/Consultant

Confidential

• Currently working on improving functionalities of the ACCIS Application, which is the automated child care management and payment processing system. ACCIS is PowerBuilder based application using Informix and Oracle databases.
• Working on enhancements of ACCIS application using advanced PowerBuilder, Oracle, Informix features such as Stored Procedures, Functions ,Triggers, Cursors.

Senior Application Developer/Consultant

Confidential

• Supported HPDInfo Powerbuilder/Oracle application which provides wide range of services for HPD business units. Worked with business entities such as Problem Routing, Complaints, Violations, Contract Maintenance, Invoicing, Procurement and other.
• Responsible for support and new development of the application using advanced PowerBuilder features such as modifying objects dynamically, advanced reporting, OLE.
• Developed advanced Oracle, Sybase database objects.

Senior Application Developer/Business Analyst

Confidential

• Worked on enhancements of NYC Tax Auditor Support System. Communication with tax auditors, gathering business information, writing specifications, implementation of coding and testing of the PowerBuilder/SQL Server/Oracle Front End application.
• Created universes and enhanced reports using Business Objects and Crystal Reporting.

Senior Application Developer/Consultant

Confidential

• Worked on improvement of security of the Bank's PowerBuilder/Sybase Front End Applications to bring the log-in and password change processes to the standards established in the Financial Industry.
• Participated in the Bank's KYC Know Your Customer Project. The purpose of the Project was to improve management of the Risk Ratings for the Bank's individual and institutional clients.
• Performed business analysis, design and coding using advanced Sybase and Powerbuilder features.

Senior Application Developer/Business Analyst

Confidential

• During the last several years responsible for business analysis, design, user communications, development and support of the Company internally built Confidential
• Front End Application called PCOM - Performance of COMposites Composites are aggregates of client accounts with similar investment strategies . PCOM's major role is to help the Performance Department to monitor Rates of Return of Accounts and Composites against various Benchmarks established in the Financial Industry. The application also provides wide range of helpful Maintenance and Reporting functionalities. It became very popular inside the Company and is widely used by other departments as well. To mention some of PCOM subsystems: Wide range of Rate of Return Reports for Accounts, Composites, Benchmarks with breakdowns by different market segments of securities, such as Equates, Fixed Income, Derivatives and other, AIMR Composite Disclosure System , Account/Composite association, Reporting on Positions and Transactions by Account/Composite, by Portfolio Manager, Large Cash Flows, Custom built Blended Benchmarks Time-Blends , Account Approvals for Client Reporting System.

Confidential

• Successfully migrated PCOM Application from the legacy Main Frame upstream source to the Eagle Pace data source. Created Specifications and built Project Plan for this migration. Implemented mapping of reference data between the new source and PCOM. Also, set up environment for quality assurance and user acceptance tests, designed routines to support the tests and document test results. Monitored progress on the Project from the initial stages through Production Implementation. Supervised on-shore and off-shore project contractors.
• Participated in the migration of the Application to the Web. Used ASP.NET Framework, C and SQL Server to replace the Confidential
• foundation of PCOM Application with the advanced Web base and SQL Server Database. Substantial experience with major Visual Studio features.

Confidential

Responsible for maintenance of the Reference Data Management System. The system supported mapping of reference data from different legacy systems into Eagle PACE company data warehouse, which was created after the merger of the Company Value and Growth sides. Used advanced SQL queries to maintain Referential Integrity of the data.

Confidential

• Designed and built from scratch Employee Trading System. The system enables the Legal Department to monitor purchases and sales of securities by Alliance employees on their personal brokerage accounts. Worked closely with the Legal Department to establish Company rules for Employee Trading. Collected business requirements to build project foundation. Created Project Plan and Specifications. Designed the blue print of the new, Employee Trading, database. Implemented the coding and supported the System for several years as it matured. The Frame of the Application included maintenance and reporting windows for the employee brokerage accounts, history of employee trades, history of trade approvals/denials, lists of employee holdings, employee access levels, history of daily restriction lists and others. The Employee Trading System is still actively used by the Legal Department the Client/Server technical base was replaced by the Web base recently .
• Created Design Sketch and Specifications for the new Database objects, which included defining Primary and Foreign Keys, Indexes, User Data Types, Data Defaults, Data Rules, Relationships between tables and views. Actively used advanced Database features to enforce referential and domain data integrity: Stored Procedures, Triggers, Cursors.
• Working on different Projects, actively communicated with business users analyzing their requirements and making suggestions on problem resolution.

Senior Application Developer /Business Analyst

Confidential

• Responsible for maintenance, enhancement and user communications for one of the Production applications - FISI Madison Financial, which is a 'Help-Desk for the Insurance Customers' type application. Supported the user on different stages of the application deployment. Worked on enhancement of the other applications running in Production, such as SEARS and GE.
• Maintained and enforced data integrity using advanced Object Management Tools such as Erwin and CAST. Developed advanced SYBASE triggers and stored procedures.
• Used PowerBuilder as the front-end of the applications and SYBASE Database as the back end. Extensively used advanced PowerBuilder features, such as Object Inheritance, User Objects and User Events. Developed triggers, stored procedures, data types, defaults and other SYBASE entities

Senior Application Developer /Analyst - TTSC Consultant

Confidential

• Worked on creation of the new, 888, Toll-Free-Service. Enhanced COBOL/DB2 programs.
• Used extensively Relational Database features working with DB2/SQL: Queries, Cursor operations, Referential Integrity concept, Database Integrity concept.

Senior Application Developer/Analyst - CGA Consultant

Confidential

• Worked on the Settlement Into The Future Project to enhance the Credit Card Processing. The Project scope included development of a Settlement System Client Server side and building an interface to Transaction Processing System Mainframe side .
• Participated in data analysis and database design phases of the Settlement System. The goal of the Project was to build a flexible, user-oriented Confidential
• Front-End for maintenance of different Banking operations, such as adjustments, postings, reversals, chargebacks.
• Communicated with business users to collect Project requirements. Participated in building of a design sketch of a new databases, which included creation from scratch new tables and views and establishing of relationships between them. Used Relational Database features to enforce data integrity and completeness.
• Extensively used advanced PowerBuilder features. Applications included building an MDI frame containing Sheets for processing of different banking operations. Created DataWindows of different Presentation Styles and Data Sources. Developed stored procedures for ORACLE Database using PL-SQL.

Programmer/Analyst

Confidential

• Enhanced the Invoice Loading part of the Product Movement Management System functioning at the city Central Warehouse. The enhancement minimized the invoice entry processing time and, therefore, the product delivery time. The Warehouse significantly increased its profits by this enhancement.
• Developed new and maintained existing processes, which improved Inventory of product supplies within the Central Warehouse.
• Worked closely with the Central Warehouse management team to reflect Distribution of consumer goods, which improved efficiency of product circulation.
• Developed Inquiry and Reporting applications which facilitated business users' work with data repository and enabled them to observe the product movement from different aspects.
• Performed analysis and created applications using DB2 Relational Database. Extensively used SQL queries and advanced database features.