Data Support

Objective

A position as a Sr. Global Production Support/DBA Developer.

Summary

Substantial experience as Database Developer using Sybase & Oracle. Earned a reputation with senior management as a dedicated, motivated, committed team player with strong analytical, organizational and solid mathematical skills. Consistently ranked and compensated at top of peer group.

Technical Skills

Software

UNIX, Shell Scripting & Programming, Perl Scripting, Putty, Lotus Notes, MS Office 97, Excel, Word PowerPoint & MS Project, MS Access, Oracle 8 & 9i, 10g, PL/SQL Programming, PowerBuilder V’s 5–9 & PFC, Sybase SQL SERVER System 11,12.5 & 15, MS SQL 2000, Visual Basic 4.0 & 6.0, Oracle Migration Workbench tool (TOAD)

Platform

CITRIX, Winframe and Metaframe Neighborhood environment, WINDOWS NT (V.3.51 AND V.4.O), WNDOWS XP and WINDOWS 3.11 and Sun Solaris UNIX

UBS Wealth Management & Business Banking, NJ (Contractor) 07/14 - Present

Global Production Support/DBA Deployments/Change Management

Support Change Management requests for releases.

Oracle, Sybase and SQL Server Deployments support.

Production related Technical Analysis, requirements gathering, and problem resolution

Exhibit strong domain/technical knowledge which helps in resolving complex Production Support Issues

Support Business Analysts in defining application production issues as required

Periodic Database Tuning (SQL statement and instance tuning)

Batch scheduling experience using Autosys/Unix.

Support and maintain the Production, Test and Development application environments.

Share knowledge with other team members as needed

Strong analytical skills. Strong Unix and Shell Scripting skills.

Also responsible for periodic operational, production support and maintenance

Environment:

Oracle 12.6, SQL Server 2012 and Sybase 12.5, AIX, Sun Solaris 8/10 Unix platforms

UBS Wealth Management & Business Banking, NJ (Contractor) 07/12 - 07/14

Municipal Trading System Platform

Production Support/Release Manager/Infrastructure Lead

Release procedures: Check out and Check in code via Clear Case, using UNIX server. Maintaining SVN Repository.

Deploy release via UBS SAFE tool, to release procedures, tables.

Create Change Management requests for releases.

Diagnose and troubleshoot Impact application and internally developed intra-day and overnight batch processing issues

Work with vendors to implement fixes and software upgrades to the application platforms, triage production issues and resolve them in a timely manner

Worked directly with Vendors: JJ Kenny, Reuters that feeds data into UBS

Rating information for JJ Kenny. Real-Time Price Feeds/updates, production support in this area.

US Treasury Feeds, Option, Futures and Hedging instruments.

Monitor and answer primary help desk phone and email, respond to users, log and maintain requests in incident tracking system

Production related Technical Analysis, requirements gathering, and problem resolution

Exhibit strong domain/technical knowledge which helps in resolving complex Production Support Issues

Support Business Analysts in defining application production issues as required

Maintenance of in-house Trading system software

Support and execute User Acceptance Testing (UAT), Disaster Recovery (DR)

Evaluates changes to system (new software releases, installations, new components, architecture changes) for impact on end-to-end performance; assist in system implementation

Periodic Database Tuning (SQL statement and instance tuning)

Batch scheduling experience using Autosys/Unix

Strong UNIX shell scripting

Support and maintain the Production, Test and Development application environments.

Share knowledge with other team members as needed

Strong analytical skills

Also responsible for periodic operational support and maintenance

Environment:

Sybase SQL SERVER 12.5, AIX, Sun Solaris Unix platforms

JPMorgan Chase Bank, Garden City, NY (Contractor with Accenture) 06/11 – 07/12

Sr. Sybase Developer/Data Lead

As a member of the Compass System/Chase Auto Finance and Student Lending IT

Periodic Database Tuning (SQL statement and instance tuning)

Transact-SQL (T-SQL) writing scripts as well as running and troubleshooting queries

Support and maintain the Production, Test and Development application environments.

Work with users as needed to Investigate and resolve end-user data integrity issues as they arise.

Share knowledge with other team members as needed

Ability to extract and analyze data using in a UNIX environment, and MS Office Tools.

Data knowledge and experience working with large data files. Have experience working on the full life cycle of complex development projects. Very detail oriented and able to work on multiple projects at one time.

JPMorgan Chase Bank, New York, NY (Contractor with Accenture) 06/10 – 06/11

Sr. Sybase Developer/Data Lead

As a member of the Private Wealth Management/Chase Private Banking (CPB) System team

Creating views, stored procedures and other objects in Sybase

Periodic Database Tuning (SQL statement and instance tuning)

T-SQL scripting and performance tuning.

Transact-SQL (T-SQL) writing scripts as well as running and troubleshooting queries

Preparing appropriate builds by distinguishing the objects.

Develop application code changes. Unit test application changes.

Data Model skills and handling of modeling utilizing Erwin/ER Studio

Incorporation of Broad ridge Key Service info into Account Operations.

Working with terabyte database size. Tables as big as 500 million rows.

Proficient in relational database design, data warehousing and database administration.

Create programs and stored procedures based on technical specification and design documents.

Support and maintain the Production, Test and Development application environments.

Work with users as needed to Investigate and resolve end-user data integrity issues as they arise.

Share knowledge with other team members as needed

Ability to extract and analyze data using in a UNIX environment, and MS Office Tools.

Data knowledge and experience working with large data files. Have experience working on the full life cycle of complex development projects. Very detail oriented and able to work on multiple projects at one time.

Also responsible for periodic operational, production support and maintenance

Environment: Sybase 12, DB Artisan, Sun Solaris UNIX

JP Morgan Chase Bank, Whippany, NJ (Contractor with Accenture) 12/09-06/10

Sybase Migration Team Lead

Centralized Email delivery mechanism for GCS systems. Central place for users to register for email notification. Mechanism for GCS systems to register event types and publish event messages. Email delivery for Bear Prime users Provide Bear Prime users the mechanism to register/unregister their email preferences.

As a member of the Bear Prime Email Notification System team

Participated in migration system from a Sybase12 database to Sybase 15 database.

Team leadership and project management, application on-call support, weekly and monthly user meetings

Gathering Steps & Complete Migration Strategy. Managed Offshore Team.

Analyze application and prepare the detail design and inventory of all possible items which will be impacted due to this migration.

Upgrade Java application from JDK1.4 to JDK1.6. Remove dependency of Java application on Web logic 8.1 and upgrade it to utilize web logic 10.3

Analyze all the Sybase Objects residing on the older version of Sybase ASE 12.5

Preparing appropriate builds by distinguishing the objects.

Promoting the build into the new ASE 15 into the DEV environment

Rectifying the errors if any, building unit test cases.

Prepare the Release document and release build after the defect the cycle.

Applying all the required SQL changes which are compatible with the 15.4.3

Implement Migration - Perform Application Migration

Develop application code changes. Unit test application changes.

Analyze and correct application changes. Configure applications to access new server.

Allow users access the system and server. Document acceptance test results. Obtain user signoff on acceptance test results

Environment:

Sybase 12, SQL, Windows XP, Linux

UBS Global Wealth Management & Business Banking, NY (Contractor) 10/07-12/09

Sr. Sybase/Unix Support Developer

DST HI Performance is multi-currency, multi asset performance measurement and attribution and ex-post risk solution. HI Performance will be used for the calculation of daily returns, attribution, composite reporting and the storage of benchmark details.

DST is a performance system designed to replace the basic performance reporting functionality of Perascope/RW. The process is focused on the generation of performance returns based on current, backdated and amended transaction and valuation activity controlled and managed primarily by Global Plus.

Overnight Schedule - The Global Plus overnight process runs Monday – Friday in BOD and generally finishes around 5AM. The files are transferred to the DST-middleware via Oliver. The middleware prepares the files and imports them into Hiperf. Once the files are loaded, the CMP autosys batch is run.

This position provides production support development activities for installed products, and providing assistance in analyzing and resolving any issues as needed. Responsibilities include:

Excellent software development practices and adhere to corporate software development lifecycle

Evaluates changes to system (new software releases, installations, new components, architecture changes) for impact on end-to-end performance; assist in system implementation

Creating views, stored procedures and other objects in Sybase

Periodic Database Tuning (SQL statement and instance tuning)

Batch scheduling experience using Autosys/Unix.

T-SQL scripting and performance tuning.

Transact-SQL (T-SQL) writing scripts as well as running and troubleshooting queries.

Strong UNIX shell scripting and PERL scripting.

Data Model skills and handling of modeling utilizing Erwin/ER Studio

Proficient in relational database design, data warehousing and database

administration.

Experience with Sybase, Transact-SQL and Unix Perl scripting

Bash shell programming experience on Sun Solaris UNIX platform.

Create programs and stored procedures based on technical specification and design documents.

Support and maintain the Production, Test and Development application environments.

Work with users as needed to Investigate and resolve end-user data integrity issues as they arise.

Share knowledge with other team members as needed

Strong analytical skills. Strong Unix and Shell Scripting skills.

Knowledge of SQL and database tools such as DB Artisan or Rapid SQL

Ability to extract and analyze data using Sybase SQL in a UNIX environment, and MS Office Tools.

Data knowledge and experience working with large data files. Have experience working on the full life cycle of complex development projects. Very detail oriented and able to work on multiple projects at one time.

Also responsible for periodic operational, production support and maintenance

Environment:

Sybase SQL SERVER 12.5, Erwin/ER Studio, Windows NT/2000/XP, AIX, Sun Solaris Unix platforms

Unilever Best Foods, NA, Saddle Brook, NJ (Contractor) 10/05-10/07

Sr. Sybase SQL Support Developer

Unilever-AMPS (Automated Management Planning System) was designed as a comprehensive sales force automation solution. The application is an evolving distributed processing system using a Sybase database and a PowerBuilder client.

Developed procedures, views, triggers and functions to establish business rules, to validate the data and Audit Trail, using Sybase 12 as backend

Written optimized SQL scripts to update production tables

Created Shell scripts to run batch jobs for Data load

Creating installation plan for implementing the Audit Trail.

Developed installation/operational scripts in SQL, UNIX Shell Script.

Wrote database triggers to capture audit information and maintain historical data.

Interacted with Sybase DBA to manage user requirements.

Handled data transfer and utilized Import/Export to migrate a data from legacy system

Lead the process of converting Foods and HPC databases into a single Vital end state AMPS database

Implement the process of converting customer and product master data in order to integrate two databases into a single database.

Knowledgeable in UNIX and UNIX Shell Scripting.

Deliverables always met at 100% and ahead of deadlines.

Environment:

Sybase SQL SERVER 12, Windows NT/2000/XP, AIX, Sun Solaris Unix platforms

EMI, New York, NY (Contractor) 02/05-10/05

Sr. Sybase Database Developer

As a member of the Contract Tracking System Development team.

Developed procedures, views, triggers and functions to establish business rules, using Sybase 12 as backend

Created Shell scripts to run batch jobs for Data load

Effectively supported any changes in requirements

Deliverables always met at 100% and ahead of deadlines. Coordinated with team at all times.

Provided primary support of the CTS (Contract Tracking System) Project and RMS (Repertoire Management Systems)

Participated in testing, installation and maintenance of the application in multi-user network environment. Increased involvement in all phases of testing and client sign-off criteria.

Environment:

Sybase 12, SQL, Windows NT/2000/XP, AIX, Sun Solaris Unix platforms

JP Morgan Chase Bank, Jersey City, NJ (Employee) 10/99-02/05

Sybase Database Developer

As a member of the Financial Reporting System Development team

Developed Packages, procedures, views, triggers and functions to establish business rules, to validate the data and Audit Trail, using Oracle 9i as backend

Wrote PL/SQL stored procedures and database triggers

Created External Tables to load data into the tables

Participated in converting system from a Sybase12 database to an Oracle 9i database. The Oracle Migration Workbench tool (TOAD) was used to convert SQL server databases to Oracle database. Oracle PL/SQL, T-SQL statements that are not ANSI-compliant required manual conversion.

Provided support to team leader and project manager, application on-call support, weekly and monthly user meetings

Experience in data architecture, data modeling and configuring data warehouses.

LADS reports utilized credit risk ratings. System gave option to assign credit risk ratings based on judgment and models.

LADS systems have the following product types, Derivatives, investment securities and trading assets

PowerBuilder 9.0 as a front end environment and Oracle 8i/9i n the back end

Environment:

Oracle 9i, Sybase 12, Erwin/ER Studio, PL/SQL, SQL, Windows NT/2000/XP, Sun Solaris UNIX

Andersen Consulting, New York, NY (Employee) 09/97-10/99

Sr. Developer/Analyst

J.P. Morgan, New York, NY (on site)

Responsible for analysis, program design, coding, testing and implementation of Allocation Front End. The objective of this financial application is to provide all business managers and controllers with a consistent, independent methodology for revenue, expense, and client allocations.

Interacted with users from the beginning of the project through the testing phase

The system designed independently to update and to manipulate data for financial, expense, and client allocations. The ALFE application was developed as MDI application utilizing PowerBuilder 5.0 as a front end and Sybase 11.0 as a back end.

Upgraded ALFE application to PowerBuilder version 6.5 and Sybase 11 to use Direct Connect

System based on, entering and updating allocation rules, statistics and reference files

Created views, stored procedures, and triggers. Participated in developing, testing, installation and maintenance of the application in multi-user network environment.

PowerBuilder 5.0 as a front end environment and Sybase 11.0 as a back end.

Environment:

PowerBuilder 6.5, Sybase 11, SQL, Windows NT/2000/XP

J.P. Morgan, New York, NY (onsite)

Responsibilities as a member of the Human Resources Applications Development team included designing, developing, maintaining and testing client-server based software applications, using PowerBuilder and Sybase SQL. Supported the Officer Compensation system.

Designed, developed, maintained and tested client-server based software applications, using PowerBuilder and Sybase SQL

Assessed, analyzed, fixed, tested and documented changes for ‘Year 2000’ compliance on PowerBuilder applications

Documented existing applications on Lotus Notes databases for company-wide access

Installed various software on PCs of client-server based computer systems. Installed desktop PC systems and upgraded hardware.

Created and maintained team's hardware and software inventory on MS Access Database

Acquired strong working knowledge of Windows '95 and Windows NT (versions 3.51 and 4.0) operating systems and Windows NT server

Environment:

PowerBuilder 5.0, Sybase 11, SQL, Windows NT/2000/XP

Education

BS in Computer Production & Cost Management, 1996, FIT, New York, NY

Contact this candidate