OBJECTIVE:
Experienced software developer/analyst is seeking a position within the IT industry to provide services in the planning, designing, coding, testing, integration and implementation of software development, data analysis for client-server and/or web applications.

SUMMARY:

• Information technology software engineer with 14+ year's hands-on experience.
• Developed and maintained over 40 applications and 1000 reports servicing 1,000-47,000 users.
• Solid experienced with RDBMS ORACLE, MS SQL Server, Sybase AND Programming languages VB/VBA, Crystal
  Reports, Jasper BI/iReports, Perl and Shell scripting, PowerCenter/Informatica, Control-M/Autosys, WEBI/BO, ASP.
• Self-starter with excellent interpersonal, analytical, and problem solving skills.
• Team player, adaptable, flexible, and continuously updating my knowledge with new system technology.

TECHNICAL SKILLS:
Platforms: UNIX (HP, Sun Solaris), Linux (Red Hat), WIN XP/2000/03/NT, and Novell NetWare client.
Software: Oracle-11.x,10.x/9x/8x(PL/SQL), MS-SQL/Server 2000/05/08(Transact SQL,), Oracle Warehouse Builder, UNIX and Shell Programming, SSH and SSH programming for UNIX, Linux Red Hat, Perl, PowerCenter-Informatica 5x/6x/7x/8x, PeopleSoft: FIN and HRMS 7/8, PeopleSoft Tools: Application Designer, Data Mover, Process Scheduler, Import Manager, Workflow; BMC Software/Control-M, LDAP, ERWIN, Sybase 10/11/15, Visual Basic, ASP, Visual Source Safe, SVN, VSS and Perforce directory structure, MS Office, ODBC, OLE 2.0/2.1, OLEDB, Active X, Win API 16/32, Crystal Reports 8/9/X/XI, Sheridan tools, HTML /DHTML, JavaScript, IIS 4/5/6, Apache Tomcat 4/5, Web Logic 8/9/10

• Created, SDLC Development and analysis for conversion Fee Schedules from Aladdin Sybase system to Billing Revport™ system. Application Revport™ - allow users to easily track, calculate, and reconcile fees due to the company, and provides the ability to produce invoices in multiple formats. Nightly batch updates Oracle 11 database by Aladdin daily supplied XML files.Autosys tools then loads XML files based on type of load: Contact, Client, Portfolio, FX rates, Fees and Market Values.
• Develop and deliver dynamic reporting solutions using Oracle BI and Sybase tools.
• Created ETL processes against standard SQL Aladdin system and used by REVPORT Controller loader. Helped in data management, migration and normalization. Developed, implemented partitioning strategies. Applied strategies for data acquisition, warehouse implementation, and archive recovery.
• Developed strategies for archive recovery, data acquisitions, and implementation of database.
• Created various Jasper reports based on iReports and web based Jasper reports to provide Billing Ops with financial data. Developed data transfer from Jasper JRXML to Adobe PDF, Excel and Word document formats. This data transfer was running on weekly basis using Autosys jobs.
• Develop all kind of database objects including PL/SQL packages, IOT tables, partition tables, temporary tables, bitmap and function based indexes and others. Configured Web Logic server 10 forREVPORT billing application
• Design and develop PL/SQL procedures, utilized Oracle Warehouse Builder to perform ETL functions for a 500 GB data warehouse for the billing application.
• Create and implement AUTOSYS JIL scripts, UNIX Shell scripts and Perl scripts programs (under SSH) to archive data sources for disaster-recovery units and applied its for AUTOSYS nightly batch.
• Used Software Configuration Management tools such as SVN/CVS/JIRA/Mercury and HP QCenter.

Sr. System Application Developer, Barclays Wealth, New York City, NY01/2010 - 12/2010
Confidential (CONSULTANT)

• Develop, maintain, and support Billing Revport™ system. Application Revport™ involved (2) platforms: Bonaire Soft (vendor's Java Front application) - allow users to easily track, calculate, and reconcile fees due to the company, and provides the ability to produce invoices in multiple formats. Nightly batch updates Oracle 11g database by AXYS daily supplied flat files.Jasper ETL tools then transforms flat file into multiple XML files based on type of load: Contact, Client, Portfolio, and Market Values.
• Developed, maintain and support SCAT Reporting (Sales and Compensation Application). SCAT will consolidate data integration processes, provide an interface for the new billing system to the Smart Stream systems, create a standard, rules based system for revenue transactions and allocations, and create a data mart style Crystal XI reporting repository. The data comes from SCAT (MS SQL Server 2008). Sales and Compensation then process and generates final reports in Crystal format.
• Develop and deliver dynamic reporting solutions using SQL Server 2008 Reporting Services (SSRS).
• Developed and maintained the ICE Reports application for Capacity Management & CT written in VB.NET which included linked data with Client Associates staff from "Revport" and ATS Data for multiple Branches of BKG Operation ADM Department. Reports were produced in MS Access (22) and Excel (16).
• Used PeopleSoftApplication Designer to modify existing records, pages, and menus. Involved in the Data mapping, Data conversion and Data loading from the external system into people soft tables. Involved in the Data mapping, Data conversion and Data loading from the external system into people soft tables.
• Created various Jasper reports based on iReports and web based Jasper reports to provide Billing Ops with financial data. Developed data transfer from Jasper JRXML to Adobe PDF, Excel and Word document formats. This data transfer was running on weekly basis using Autosys jobs.
• Created PDF and RTF reports dynamically using Jasper API. Developed user interface components using JSF and Oracle ADF; analyzed diverse data sets and designed aggregated data views in Oracle DB.
• Converted existing reports from version Crystal 9 to Crystal XI. Reports for General Ledger and Balances were generated in Adobe format from existing Crystal Reports. Created Crystal Reports Repository objects (business views, reports template, commands).
• Reports, developed OCX system from VB app to automatically load from web and process.
• Developed all kind of database objects including PL/SQL packages, IOT tables, partition tables, temporary tables, bitmap and function based indexes and others.
• Developed ETL flow based on SQL server DTS to migrated data from SQL server DB to Smart Stream system.
• Configured Web Logic server 10 for REVPORT billing application.
• Performed application benchmark testing tuning prior to database migration to Oracle 11 G.
• Designed and developed of SQL, PL/SQL packages, utilized Oracle Warehouse Builder and Informatica 8 to perform ETL functions for a 1-15 multi TB data warehouse for the RAA application.
• Created and implemented UNIX Shell scripts and Perl scripts programs (under SSH) to archive data sources for disaster-recovery units and applied its for AUTOSYS nightly batch.
• Administered total of (2) LINUX Servers: (2) BEA Web Logic 6.1 and (2) Oracle 11g servers.

Sr. Programmer/Analyst, Alliance Bernstein, New York City, NY01/2006 - 11/2009

• Supported, maintained Helmsman/MS SQL 2005 server application. Created command files, Control-M batch tables to load data from SmartStream. Created various database stored procedures for Crystal Reports to supply users with daily reports for: planning budgeting, workflows budget administrations, information for automatic e-mail notification.
• Developed, maintained, and supported Billing Corporate Financial System, including Enterprise Billing System (EBS). Revport™ (EBS) project for Billing Department involved (2) platforms: Bonaire Soft (vendor's Front application) - allow users to easily track, calculate, and reconcile fees due to the company, and provides the ability to produce invoices in multiple formats; and Oracle10g platform for DB management, which keeps, updates and refresh data for Revport application.
• Helped in data management, migration and normalization. Developed, implemented partitioning strategies.
• Applied strategies for data acquisition, warehouse implementation, and archive recovery.
• Developed strategies for archive recovery, data acquisitions, and implementation of database.
• Developed, maintained and supported Recast™ - Revenue Allocation Application (RAA). RAA consolidated data integration processes, provided an interface for the new billing system to the Smart Stream systems, created a standard, rules based system for revenue transactions and allocations, and created a Data Mart style reporting repository. The data comes from Revport: General Ledgerand Balances. Data mappings and rules processed by Informatica performing ETL in mappings/sessions and transfers data to the MS SQL Server 2005 database.
• Created two backend application packages which eliminated the need for a 3rd party software, which resulted in $1,500,000 cost savings on licensing fees.
• Designed and developed of SQL, PL/SQL packages, utilized Oracle Warehouse Builder and Informatica 8 to perform ETL functions for a 500 GB data warehouse for the RAA application.
• Performed application benchmark testing tuning prior to database migration to Oracle 11 G.
• Developed all kind of database objects including PL/SQL packages, IOT tables, partition tables, temporary tables, bitmap and function based indexes and others.
• Working with Production Support Services team provided analysis of the 10,000 jobs within Production Environments. (Windows, UNIX and Mainframe Platforms). With the use of Visual Jobs for Control-M 6.3 to determine any errors/failures relating to IN or OUT Conditions. Compiling of lists for the corrections to the In/Out Conditions and their predecessor or successor jobs. Checked Ordering/Loading/Forcing of jobs or tables into the schedule, monitoring of schedule to include fixes or escalation. Created recursive file watcher table allow running multiple tables for different files

Sr. Software developer, Confidential, Jersey City, NJ 06/2001 - 12/2005

• Engaged in full system development life cycle to design and develop (6) projects for HR System Delivery corporate administration department: "ROMS" "Web-PM", "ETWEB-MAP", "Job Connect", "ESS/MSS", "encompass", "360-reviews". Used tools such as: PowerMart Informatica transformation tools, People Soft 7, Business Objects/WEBI, Oracle 9i database and OFA 11i, UNIX/LINUX, SQL Server 2000, Crystal Reports, VB6.

SYSTEM SPECIALIST, Confidential, New York, NY 06/1998 - 06/2001

• Engaged in full system development life cycle to design and develop the POLARIS and Teller financialapplication for Windows NT client/server written in VBA for Financial AccountingDepartment.

Sr. SYSTEM SOFTWARE DEVELOPER, Merrill Lynch, New York, NY 07/1997 - 05/1998
Confidential (Consultant)

• Engaged in full system development life cycle to design a new Financial Application for two major groups: BankLoan and Total Return Swaps within the Global Derivatives Support Department. The system is based on Windows-NT client/server platform, using Visual Basic 5.0, MS Access 8.0, and Sybase-10.

REPORTS SYSTEM DESIGNER, Dean Witter, New York, NY 05/1997 - 07/1997
Confidential (CONSULTANT)

• Created reports using Crystal Report 6.0 and MS SQL Server 6.5 database.
• Reports refreshed accounts and reflected statistic information for Transfers, Rollovers, and new accounts.

SYSTEM DEVELOPER, Essex Corporation, New York, NY 01/1997 - 05/1997
Confidential (CONSULTANT)

• Developed projects for Life-Health Insurance systems. Used the Life-Trac system application for AMERITRADE trading and accounting transactions, which contained two main groups: Trading/ Distributive Lists (Visual Basic front-end applications running on SQL Server back-end).

TRAINING: Oracle Development, and Oracle Advanced Course, UNIX Shell Programming, UNIX System
Administration, INFORMATICA (CHASE) - ASP.NET, VB.NET, C-Sharp, Java Programming.
(SAM consulting career center)- XML, Dream Weaver, Windows NT 4.0, ASP classic,
DHTML, HTML (ICOS consulting).

EDUCATION:

Academy of Telecommunications
B.S., Electronics Information System