SUMMARY:

• Experienced Senior Database Developer, having over 15 years working with database development in design, development, Performance & Tuning, optimization and data modeling. Highly organized with strong attention to detail, forward thinking, well organized with excellent communication skills. Drive with motivation, to be a self - starter, which anticipates problems and takes a heavily proactive approach to responsibilities. Business Units that I have working experience are with, Customer Relationship Management(CRM) Systems, Portfolio Management, Risk Management, Credit Risk, Fixed Income.
• Database Design/Development
• Project Management
• Full Project Life Cycle
• Project Support

TECHNICAL SKILLS:

Databases: Sybase 12.5/15,Sybase IQ, Oracle 9i, SQL Server 2005/2008

Languages: T-SQL PL/SQL, Perl 5,TCL, Unix Shell,XML

Operating Systems: Unix, Windows NT, VAX/VMS,MS/DOS

Software: Crystal Report, Microsoft Office, MS Project, Business Objects

PROFESSIONAL EXPERIENCE:

Confidential, New York, New York

Consultant - Database and Performance Management Lead

Responsibilities:

• Team Lead of 3 developers working on performance management by optimizing existing database
• Re-evaluate existing stored procedures to optimize and tune performance on slow running procedures. Reduced several long running batch jobs from 30 minutes to under 30 seconds
• Write complex stored procedures base on Business requirements
• Working on a new archiving process to reduce data on live database to archive database. Reduce database size to retain only 93 days versus the existing 15 months. This will reduce the database size from 600GB to 150GB
• Code review all stored procedures from developers to ensure that performance is at its best prior to release to Production.
• Reorganized all Autosys jobs so that there is less contention against the database
• Create Unix shell scripts to automate data loads from feeds.
• Sybase Exit project, including migrating Sybase to SQL Server 2008. Rewriting Sybase Stored procedures to SQL Server Stored procedures
• Migrating data from Sybase to SQL Server
• Process data feeds using Workflow Manager in Informatica 9.1
• Create new stored procedures to monitor processes and to determine contention on the server.

Confidential, New York, New York

Vice President - Senior Database Developer Lead

Responsibilities:

• Develop and maintain product implementations to functional & technical specifications.
• Work within a defined quality assurance process, which includes Unit test, UAT and regression testing and develop complex test plans so that changes made do not cause problems to existing system.
• Ensure all Jira’s are SOX compliant.
• Investigate, debug and resolve issues with pricing the derivative products.
• Liaise with Traders, Developers and Business Analysts globally and to understand requirements and identify technical solutions for Equity and Derivatives and Market Risk.
• Work with Business Analyst and Traders to from the Equities and Derivatives Trade Desk, Market Risk and Quantitative Research teams.
• Develop complex stored procedures and triggers to build new market data from QLib
• Develop complex stored procedures for Equity Derivatives Pricing and Risk management platform
• Performance Management and Tuning database for optimal performance
• Optimize slow running stored procedures
• Currently migrating from Sybase 12.5 to Sybase 15
• Create Unix shell scripts to load data from raw files into the databases
• Light Java development
• Peer review all stored procedure before releasing to Production
• Manage/Coordinate major releases to ensure no issues are raised
• Lead PWG(Peer Work Group) across multiple teams in discussing open issues and resolutions
• Production Support and Off hour support
• SCRUM - Agile Development

Environment: Sybase 12.5/15, Unix, XML

Confidential, New York, New York

Database Development/Content Management (Consultant)

Responsibilities:

• Convert client data to be compatible to our database using SQL Server 2005 and Sybase 12.5
• Develop Sybase and SQL Server stored procedures for retrieving data to the user Interface.
• Data analysis - compared data and reconcile reports using Crystal Reports and Excel.
• Created mapping documents to transform clients raw data to Sybase and SQL Server.
• Create Customized Client Statements and Invoices using Crystal Reports
• Create stored procedures and functions to be used in Crystal Reports
• Modify existing XSL scripts to enhance Innovest’s Accounting Software.
• Create XML script for scheduling tasks such as file processing, scheduled reports.
• Create XML scripts to create new fields to Innovest’s UI.
• Performance Management on database for optimal performance
• Create SSIS packages to import data from files.
• Create Customs Reports using SSRS

Environment: Sybase 15, SQL Server 2005, SQL Server Management, Crystal Reports 9, XSL, XML

Confidential, Stamford, Connecticut

Business/Data Analyst

Responsibilities:

• Managed a CRM system called Fund.Space used by our Sales Team
• Work with business groups in design and implementation of new reports in Crystal Reports
• Review new requirements/specifications with the business and make recommendations on design and layout for new projects
• Support developers in designing new requirements from Business and Sales desk
• Review data and content of the database to make sure the reports reconcile with what the business provided
• Data Cleansing and manipulation to ensure data is consistent across the database
• Light Pyxis work in developing Blackberry reports
• Development on mPlatform/mWholesaler for CRM appplications on Blackberry.
• Communicate with Vendor SalesPage on enhancement of Fund.Space application
• Lead developer in design and migration of CRM and Sales Reporting system
• Migration CRM from Unitrac to FundSpace, which includes designing new database from Sybase 15 to SQL Server 2005 (Full conversion).
• Create Adhoc queries and stored procedures
• Performance and tuning and optimization
• Develop Sybase and SQL Server stored procedures for backend reporting
• Creates SSIS packages to use as a ETL tool to load data from files
• Create reports using SSRS
• Work directly with Business Management team to gather and develop requirements
• Supporting existing reporting system by continuously writing adhoc Crystal reports as well as consolidating reports to new system.
• Develop Wholesaler, Management, Activities, Campaign reports, etc… using Crystal Reports to aid the management and sales team
• Develop New reports in Crystal Version 9.0
• Develop stored procedures to enhance performance for Crystal reporting
• Create complex reports using stored procedures, commands and sub-reports

Confidential, New York, New York

Senior Database Programmer(Consultant)

Responsibilities:

• Designed and maintained database design for Cantor Market Data in Sybase IQ and Sybase ASE
• Create daily trade and tick reports for Fixed Income, specifically for UST, Government bonds by using Sybase, Unix shell and some Perl
• Created a data warehouse for our historical treasury data in Sybase IQ
• Work closely with business group to create new requirements and specifications on new projects/products.
• Support team with all database aspects as in development and educating.

Confidential, Jersey City, NJ

Senior Database Programmer / Technical Analyst(Consultant)

Responsibilities:

• Support Order Management System(OMS) by analyzing all the SQL Server and Sybase stored procedures and C++ programs to gain full understanding of an order process. This includes routing orders to exchanges, commission charges, order requirements, acknowledgements from the exchanges.
• Work with team members to create routers to CBOE, ISE and BRASS exchanges to route FIX messages.
• Work closely with business analyst to develop Business Requirement Documents(BRD) for TD Waterhouse new trading feature for Complex Options, such as Butterfly, Spread, Straddles and Buy-Writes.
• Create test orders for router test.
• Develop, maintain and enhance Sybase stored procedures for the OMS system.

Confidential, New York, NY

Senior Programmer (Consultant)

Responsibilities:

• Developer/analyst in a distributed system/application development team developing, enhancing, and supporting core fixed income and firm wide client data systems.
• Successfully managed and executed system enhancement and development projects, while hands-on in programming and production support.
• Proactive in anticipating, identifying, and rectifying problems and anomalies.
• Act as a liason between business users and the technical staff to develop technical specifications for newly assigned projects and enhancements to the existing system
• Creating adhoc reports for users written with Sybase stored procedures.
• Create unix shell scripts to create automated processes for data integrity.
• Use Autosys to run batch jobs, also include jil scripts.

Confidential, Jersey City, NJ

Senior Programmer (Consultant)

Responsibilities:

• Developed drill down reports as part of Average Price Reconciliation that included Master Account, Detailed and Summary reports.
• AVP Reports created in Crystal Report 8.5 with light Java development using Java Servlets, Java scripts and JDBC.
• Developing an MIS Operations reporting system GOBI(Global Objects Business Intelligence) using Business Objects and Sybase IQ
• Create Unix shell scripts to process feed files into our IQ database with embedded sql(isql and dbisql).
• Develop Sybase stored procedures and adhoc queries from the back-end to provide data to Crystal Report interface.
• Create Universes and administer Business Objects reports for our users as well as scheduling reports using BCA(Broad Cast Agent).
• Use Autosys as a job scheduler to set jobs to run overnight.
• Create Jil scripts in Autosys to add new entries to scheduler.
• Work together with user’s to develop new business requirements.

Environment: Sybase 12, Sybase IQ, Sybase Central, Rapid SQL, Data Warehousing, T-SQLJava Script, Java Servlets, JDBC, Business Objects, shell scripting, Perl 5, Sun Solaris

Confidential, New York, NY

Senior Database Developer/Programmer CRM System - Database Technology

Responsibilities:

• Developed complex SQL Server and Sybase stored procedures, triggers and scripts to maintain the integrity of our databases.
• Developed and supported an automated processing system to load customer and vendor data from flat files using Bulk Copy (BCP), through Perl and TCL scripts. Used Sybase stored procedures to load data into our databases. Flat files consisted of customer profile, acknowledgements of orders to and from our vendors as well as corporate products.
• Designed and implemented scripts to automate and improve database activities using Perl and shell scripts.
• Created and supported DBMS and Data modeling using Erwin.
• Designed database request tracking system to keep trails of database enhancements and gather critical information for production releases and reasons of database modifications.
• Database Conversion from Sybase T-SQL to Oracle PL/SQL, due to merger with Juno and NetZero.
• Replaced Sybase Stored Procedures with Oracle PL/SQL during transition period.
• Created Perl scripts to connect to Sybase databases to extract and load data using Perl DBI.
• Created formal technical documentation for test planning and final development phases.
• Managed Marketing, Customer Relationship Management (CRM) and Fulfillment databases.
• Developed specifications with users, Business Liaison and managers for new project and assignments for team.
• Developed and maintained overall project plans, working closely with product managers, CRM, Marketing, Operations, Quality Assurance and Business Teams.
• Coordinated and reviewed plans for testing, monitoring, reporting, implementation with alpha and beta testing and track project through QA cycle to ensure adherence to plans.
• Effective communication with various departments and staff at all levels to keep the projects apprised of project status.
• Use MS Project To disburse assignments to team and keep group well organized by having weekly staff meetings to meet or exceed business requirements.
• Communicate with product vendors on developing new job requirements for our customers.
• Managed the life cycle of projects and products from early project/product definition to launch and retire legacy systems.
• Worked with all levels of the organization to effectively identify and solve or escalate problems.
• Conducted meetings to ensure all project components are in place before launching into the production environment.
• Making timely decisions and database changes to DBA group.

Environment: Sybase 11.9.2, Oracle 9i, PL/SQL, T-SQL, Tcl, Perl 5, Sun Solaris, Unix, Windows NT

Confidential, New York, NY

Assistant Vice President/Senior Sybase Developer - Risk Management

Responsibilities:

• Developed various applications using Sybase stored procedures, T-SQL, triggers and Unix shell scripts for our Risk Management, Global Risk, Credit Risk, MBS, and Fixed Income business units. Determined risk factors for fixed income and Mortgage-backed securities(MBS). Calculated yields and payment distribution on investments for MBS. Created an automated process to Extract, Transformation and Load data to and from our databases from flat files using Perl and unix shell. Created stored procedures to generate risk calculators for our risk analysts based on detailed specifications as well as exceptions reporting.
• Processed trade order feeds from various trading desks from straight through processing from front office, middle office and back office, to load into our database by using Unix shell scripting/PERL and stored procedures. Created and scheduled nightly batch processes using cronjobs. Responsible for managing Risk Management’s database activities by using unix tools and DBArtisan. Used Project Manager to disburse work assignments as well as to keep track of staff project logs and priority of assignments. Conducted weekly staff meetings to track status’ of existing and new projects. Worked as part of team for Quality assurance testing for user and software applications. Tests consisted of, creating detailed specifications with users and Directors for new projects, developers testing as well as user acceptance testing (UAT), rolling out fully tested projects into production and writing detailed documentation, using PowerPoint, excel and MS Word. Provided 24x7 hour rotational production support for processing feeds to Tokyo, London, Singapore and Hong Kong.

Environment: Sybase 11.92, Perl 5, Unix Shell, Sun Solaris

Confidential, New York, NY

Assistant Treasurer - Investment Technology

Responsibilities:

• Developed a Reporting System based for performance analysis using Crystal Reports, for our Investment Technology Group. Created and Optimized Stored Procedures to its maximum performance for Client Server Environment, using SYBASE System 10 and SQL Server. Developed a Reporting System based for performance analysis using Crystal Reports, for our Investment Technology Group. Created and Optimized Stored Procedures to its maximum performance, using SYBASE System 10. Full development cycle which inlcudes: creating, testing and rolling out scripts into production, as well as maintenance.
• Examined and optimized existing Sybase stored procedures, T-SQL and triggers to have high performance to the database. Used Erwin for database modeling. Some DBA skills encountered are monitoring performance on the development servers, database dumps and loads, update statistics to replenish the indexes for all tables and database design that includes creating normalized tables for our developers, using DBArtisan 4.0 on Windows NT.

Environment: Sybase 10/11.9.2, DBArtisan, Rapid SQL, Windows NT, Crystal Reports, Erwin, Database Administration

Confidential, Staten Island, NY

Programmer Analyst - Technology

Responsibilities:

• Designed and developed a database schema for a Capital Tracking System which maintained purchase orders, invoices, inventory, and reports in a Client Server environment. Applications developed in SYBASE, using T-SQL, SQR and APT Workbench. Migrated existing all APT applications to PASSPORT. Also supported Gentran/EDI for electronically transmitting purchase orders and invoices to our vendors. Mapped data segments and created application flat text files to be transmitted in both inbound and outbound transactions.

Environment: Sybase 10, T-SQL, SQR, Apt Workbench, Passport, Unix, VAX/VMS, EDI

Confidential, New York, NY

Programmer Analyst - Technology

Responsibilities:

• Developed Global Securities Settlements System(GLOSS) applications for financial institutions, using SYBASE and C and used JAM for user interface on SUN SPARC 10. Interface with traders daily for new specifications for international clearance and settlements of trades, transact business in bonds, equities, foreign exchange, money market, and derivative instruments.

Environment: Sybase 10, C, Unix, Jam, T-sql, Sun Sparc

Confidential, New York, NY

Systems Engineer - Network Technology

Responsibilities:

• Developed a banking and distribution application in PROGRESS. Installed and managed 3270 Terminal Emulation/Access and Remote Telecommunications Application, X-25 and Internet Protocols for data transmission on the IBM RISC System/6000. Supported customers in all technical aspects. Assisted Systems Administrator with installing a Local Area Network (LAN).

Environment: IBM RISC System/6000, Progress, Unix, EDI