OBJECTIVE:

• Seeking a challenging and engaging position in Information Technology as
• Developer/Database Designer bringing my skills to bear and provide significant contribution to complex IT solutions.

SUMMARY:

• 20 years of progressive experience in analysis, design and development, maintenance and support of information, control and tracking systems.
• Exceptional system architectural design experience for various software projects for industrial, institutional and commercial applications.
• Proven ability to build strong relationship with staff and clients using negotiation, interpersonal communication and demonstrable commitment to team success.
• Self - motivated and innovative, consistently pursuing new challenges to provide value and enhance skill sets enabling greater results to employers.

TECHNICAL SKILLS:

TOOLS: PowerBuilder Enterprise 4.0 - 10.5, .NET, C#, OS/MVS XA, EDI, MS OfficePowerDesigner 6.1, Toad, Embarcadero DBArtisan, Eclipse, Microsoft Visual Studio, Crystal Report, BIC

DATABASES: T-SQL, ORACLE 7.0-10g, PL/SQL, SQL*Plus, SYBASE, SQL Server 2012SQL Server Integration Services(SSIS)

OPERATING SYS: WINDOWS XP/7, MS DOS, OS/2, UNIX

EXPERIENCE:

Confidential

Programmer Analyst, New York, NY

Responsibilities:

• Lead developer for creating Credit Risk Reporting System using SQL Server 2010 and Crystal Report 2010 to build and aggregate Bank’s portfolio data from various source systems (internal and third party).
• Troubleshoot performance problems, fine-tuning of databases and index Analysis SQL Server 2010
• Worked on logical and physical data base modeling
• Lead developer in creating automated load process between Oracle to SQL Server data warehouse systems. The scope includes in this are all customer demographic information, Confidential (trade finance system), OPICS (FX)
• Developed, maintained Middle-tier application for integration of Core Banking to Online Banking. Responsible for application support created on .net, C# and Oracle, MS SQL 12.
• Member of team responsible for solutions delivery of data warehousing application supporting mission critical bank business functionality for a 7 billion dollar international private bank.
• Primary developer, responsible for developing solution to automate load process of various input files, for vendors such as, Pershing, Broadridge, Opics, Confidential . Using Oracle 10g
• Sole designer/developer on multiple data warehouse to third-party data reconciliation projects requiring data mapping, report creation and data warehouse redesign using Oracle and Powerbuilder 9
• Responsible for third-party vendor data integration and data warehouse report generation per business requirements for Confidential, Montran and Confidential proof reports and FIS Systematics for daily reconciliation between vendor applications and bank developed data warehouse.
• Responsible for designing, development and support of Management Information System incorporating client’s financial positions, relationship, collateral modeling and Domestic and International Statement generation using Oracle 10g and Powerbuilder 9
• Responsible for continuous maintenance and improvements for month, quarter and year end deliverables directly to the bank clients.
• Expertise in T-SQL writing stored procedures, triggers and functions.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis Oracle 10g
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Participate in MQSeries 5.x to 6.x upgrade project by acting as an analyst, documenting requirement and design specifications, building test plans, executing testing scripts and providing deliverables in all SDLC phases.
• Well versed in all phases of a structured SDLC lifecycle employing waterfall project delivery methodology and incorporating rigid gating practices.
• Dedicated to meeting client commitments by providing accurate development estimates and delivering on time product within time and budget with uncompromised quality.

Environment: PowerBuilder9.0, Oracle 10g, Embarcadero DBArtisan 8.1.0, SQL Server, Eclipse 3.4.2, .Net 4.0, Microsoft Visual Studio 2008-2012, SQL Server Integration Services(SSIS), Crystal Report 10, BIC ( IBS Business Intelligence XI Report Writing using Desktop intelligence)

Confidential

Senior Programmer Analyst, New York, NY

Responsibilities:

• Extensive involvement in the Analysis, Design, Technical specs, Development.
• Enhancing the 421a System to Automate Checklist Tracking Process
• Writing store procedures for the rent calculation, DB functions
• Creating Owner Affidavit, Preliminary Application forms using Crystal Report environment. The affidavits will be inserted at the end of the 421-an electronic submits application.
• Working knowledge in using Visual Studio .Net 2005, Dream weaver MX 2004 for web applications.

Environment: Oracle 10g, PL/SQL, Embarcadero Rapid SQL 7.3.3, Visual Wed Developer, .net.

Confidential

Senior programmer/analyst, Edison, NJ

Responsibilities:

• Delivered in the class library generic modules used by other developers as building blocks for application, including: basic data maintenance for single and multiple tables with multiple level of linkage between tables, automatic report generation, previewing and printing and datawindow linkage.
• Effective use of Tab controls to meet various data entry requirements, consistent user interface and case maintenance.
• Complex reports using stored procedures as data sources, nested reports, and other datawindow technique.
• Writing store procedures with cursor operations, packages and other Transact-SQL techniques
• Using Confidential services for application functionality.
• Automated Financial Reporting
• Was responsible for implementation of the new General Ledger platform (input / process / output)
• The Confidential system needs to be able to create a file of checks issued that can be transmitted to the Bank
• Implementation of application security to dynamically control user access at object level such as windows, controls and menu items. The methodology involves usage of application tables to store user and object security information, taking advantage of PowerBuilder features such as object inheritance(windows and user objects), recursive functions, datastores, etc.

Environment: Powerbuilder 7.0, 8.0, 9.0, 10.5, Oracle 7.2, 8.0, 8i, 9i, 10g, SYBASE, PL/SQL, Toad