PROFESSIONAL SUMMARY:

• IT Professional with over 20 years of experience
• Extensive experience in full SDLC in the Windows multi - tiered Client/Server and Web enabled environment of various enterprise and medium level systems, as well as numerous small-scale mission-critical applications.
• Extensive hands-on experience in data modeling, relational database logical and physical design, forward/reverse engineering, back-end development, maintenance, and performance tuning.
• Extensive experience developing Excel VBA/macro code on multiple projects
• Extensive Shell scripting experience
• Production support and maintenance of FTP interface with XML files using DTS and VBA
• Expertise working in the investment industry (passed Series 7 exam)

TECHNICAL SKILLS:

Backend tools: ERWin/ERX, PowerDesigner, Embarcadero DBArtisian, MS SQL Server (Enterprise Manager, Query Analyzer, DTS, Analysis Services), Oracle (SQL Navigator, SQL*Plus, SQL Worksheet), SQA Manager, ERT Lincoln, Visio Professional, MS Access.

Development tools: PowerBuilder4x - 12x, PFC, InfoMaker.

Program Version Control tools: PVCS 6.5/7.5, VSS 6.0, and SCCS

Other tools: MS Project, MS Office, Robohelp.

Languages: PB Script, VB Script, SQL, T- SQL, PL/SQL, Core Java, HTML, XML, AIX Shell Script, Assembler, PL/I, C, Basic (A, GW, Quick), FORTRAN.

Databases: MS SQL Server 6.5/7/2000/2008 , Sybase System 11/12/15, Oracle 7.3 /8i.

Operating Systems: Windows NT/95/98/2000/XP/7, UNIX.

EXPERIENCE:

Confidential

Sr. Consultant

Responsibilities:

• Responsibilities included maintenance, support, bug fixing, and enhancement of the client Powerbuilder/Sybase based System.
• Design and development of the enhanced intersystem data integration using metadata based file exchange schema (Excel, CSV, TXT) into/from Sybase database table structure based on extensive use of PowerBuilder Excel OLE and Excel VBA Macro coding.

Environment: Powerbuilder 12.5, Sybase 15.5.

Confidential, Los Angeles, CA

Sr.Programmer-Tech Lead

Responsibilities:

• Start-to-end SDLC of the real-time-workflow data processing system for a High Yield (Fixed Income) and Convertibles trading departments.
• The system also includes interface with the Unix based Legacy System, which mainly performs calculations and reporting.
• Extensive use of Excel OLE and VBA Macro coding for import data from Excel files into Sybase database.
• Generating reports from PowerBuilder datawindows as Excel files.
• Front end Real time Order Management System for TRACE, ADP and IPM Reporting Real Time Inventory and PnL Application Real Time Tracking of Traders \ Sales Commissions and Credits for Net Payouts. Feeds from JDOE, Market Axess, Reuters and Bloomberg P&L Report Generating System.
• Front-end: architecture, design; development, full regression testing; debugging, implementation, maintenance, and user support. Back-end: architecture, relational database data modeling, logical and physical design, development (stored procedures, triggers - DDL, DML, and DCL scripts), performance tuning.

Environment: Windows XP, PowerBuilder 10, Excel VBA/Macro, ASE Sybase 12.5/15, UNIX.

Tools: /Languages: Embarcadero DBArtisian, Transact SQL, Sybase Central, SQL Programmer, SQL AnyWhere, FORTRAN88, AIX Shell Script, PERL, TransView, ExeedX.

Confidential, Aliso Viejo, CA

Programmer Analyst

Responsibilities:

• Data modeling, database design, reverse engineering, using PowerDesigner, backend development (stored procedures, triggers, performance tuning), debugging, and testing. Migration of the numerous PowerBuilder PFC and PSD based Applications from version 5 to 9 as well as Full Development Life Cycle of the new applications.

Environment: ASE Sybase 12, Windows 2000, PowerBuilder 5 and 9, PowerDesigner, SQL Programmer.

Confidential, El Segundo, CA

Sr.Consultant

Responsibilities:

• Application front-end (GUI) design, development, debugging, and testing.
• Data modeling, database design, back-end development (stored procedures, triggers, views, SQL scripts and DTS packages for testing and deployment) using ERWin, MS SQL Server 2000 Enterprise Manager and Query Analyzer.
• Development of the related Crystal Reports.
• Production support and maintenance of the K&K Insurance Services data FTP interface with XML files using DTS packages, and Visual Basic 6 application.
• Production support, enhancement, and maintenance of the three-tiered “Policy Processing and Premium Receivables” Powerbuilder application with accessing data from Sybase database.

Environment: Windows NT/XP, Visual Studio 6, VisualStudio.net 2003, EAS 3.6.1 PowerBuilder 7.03, Crystal Reports Enterprise 9, MS SQL Server 7/2000, Sybase/ASE-12, Internet Explorer 6, IIS 5.1., MS Access.

Confidential, Tustin CA

Responsibilities:

• Planning and design of the migration process, assessment of the impact on the production.
• Reorganizing of the PFE layer of the application. Fixing an incompatible code, regenerating, full rebuild, and compiling of the executable.
• Coordinating of the unit-to-full-scale-regression testing.
• Redesign and redevelopment of the legacy data batch process flow systems
• Development of new and modification of existent AIX Shell-script batch modules, parsing data in txt files using UNIX GREP tool.
• Development of new and modification of existent stored procedures as well, as partial redesign of the database and appropriate data allocation.
• Design and development of the GUI (PowerBuilder Application) related to the new established data set maintenance and the control of backend process flow.

Confidential, Newbury Park, CA

Contractor

Responsibilities:

• Debugging, production support, and maintenance of the ERP (Enterprise Resource Planning) system based on Windows 2000-PowerBuilder 9 (PFC) on the front-end and MS SQL Server 2000 on the back-end.
• Analysis, design, and development of the Internet enabled part of the system using Data Transformation Services (VB Script) and XML capability of MS SQL Server 2000.
• Full life cycle development of the “Salesman Commission Split” application.

Confidential, Sunnyvale, CA

Consultant

Responsibilities:

• Definition of User Requirements, development of the Tech Documentation (Requirements, Internal and External Specifications);
• Database reverse engineering, redesign (establishing primary-foreign key relationships) using ERWin, redevelopment (modification of stored procedures, views, establishing triggers, etc.), and performance tuning in an Oracle environment.
• Front-end Application (GUI) redevelopment and modification (PowerBuilder, ASP).
• Database replication and transfer of the data subsets (modification of existent Shell Scripts).
• Unit and full regression testing of the system.

Confidential, Los Angeles, CA

Sr. Contractor

Responsibilities:

• Partial data remodeling and database redesign using ERWin, development (stored procedures, triggers, views etc.), and performance tuning in a Sybase environment.
• Application front-end (GUI) design, development, debugging, testing. Production support and maintenance.

Confidential, Irvine, CA

Business/Programmer Analyst / Application Developer

Responsibilities:

• Business Process Analysis, Work Flow and Data Flow Design, Definition of User Requirements, development of the Tech Documentation ( Requirements, Internal and External Specifications);
• Data Modeling, Database design using ERWin, back-end development (stored procedures, triggers, views, performance tuning, etc), and maintenance.
• Application front-end (GUI) design, development, and implementation.
• Production support and maintenance.

Confidential, Calabasas, CA

Project Lead

Responsibilities:

• Business process analysis, definition of the user requirements, development of the tech documentation;
• Application (GUI) design, development, and implementation. Production support and maintenance. Unit-to-full scale regression testing .
• Data modeling, database design using ERWin and PowerDesigner, development, administering, performance tuning, and maintenance.
• Design, development and maintenance of the data interface from the legacy system using UNIX Shell scripting.
• Supervision of the group of three developers.

Confidential, Simi Valley, CA

Software Systems Engineer

Responsibilities:

• Business process analysis, definition of the user requirements, data modeling, fork flow and application design, development, and implementation. Writing of the tech documentation.
• Production support, application maintenance (production fixes), and user support. Unit-to-full scale regression testing.
• Data modeling, database design using ERWin and PowerDesigner, performance tuning, maintenance, and backend development (stored procedures, triggers, etc.).
• Partcipating in Client - Server (MS SQL Server) - AS400 (DB2) Y2K Data Conversion Process analysis, design, development, testing, and implementation.
• Participated in the development and implementation of the Corporate Project Methodology to improve software development and technology project planning and management practices.