SUMMARY:

• 15+ years of Professional experience working in the capacity of Lead Developer, Application DBA, Performance Tuning Specialist, Sr. Database Developer/Architect and SQL Developer Analyst.
• Extensive experience in T - SQL/SQL Development, Stored Procedures, Triggers, Views, Indexes, data integrity, Dynamic SQL, Error Handling, Data Analysis and Normalization.
• Worked on data masking providing production quality content into non-prod environments with suitable entitlements.
• Upgraded Sybase ASE 12.0 to 15.0.3.
• Migrated Sybase ASE 12.5.3 to Sybase IQ 12.6.
• Maintained and supported SAP Sybase ASE/IQ and MS SQL SERVER applications.
• Implemented database security using data masking, encryption and access control.
• Developed and automated batch processes using Shell / Perl Scripting and workload automation tools.
• Created, Configured and Fine-tuned ETL workflows in SSIS/DTS and PERL.
• Developed Database Tools - Database archival/compare.
• Knowledgeable of various SQL Server tools -DTA, PerfMon, Profiler and DMVs.
• Participated in all phases of software development.
• Provided production support and coordinated support with offshore team.

TECHNICAL SKILLS:

Databases: SAP ASE 15.7/15.0.3/12.5.3/12.0/11.9.2/11.5.1/10, SAP Sybase IQ 15.2.0/12.6 SQL Server 2012/2008/2005/2000, Oracle 10g/8

Database Tools: DBArtisan 9.1.2/8.5.5/8.0.1, Rapid SQL 7.4/5.7, Sybase Central 4.1.1, ADS 10.0, Optdiag, Reorg, Sysmon, BCP, I-SQL, APT 5.3, DWB 5.2, SQL-EM, DTS, Profiler

Languages: C, C++, PERL 5.0

ETL/BI Tools: SSIS/DTS, Perl 5.0, Informatica

Operating Systems: Sun Solaris 10/8/7, Linux 3.5/3.2, HP-UX 11.0/10.0

Data Modeling Tools: ERwin 3.2, Power Designer 11.0

SCM: ClearCase, CVS, Opsware, SCCS, PVCS merant 6.8, VSS

Workload Automation: Autosys 11.0/4.0, SQL Server Agent, Control - M, Cron

PROFESSIONAL EXPERIENCE:

Sybase DBA

Confidential - Secaucus, NJ

Responsibilities:

• Supporting change management - Deploy DS (Data repair) and CM TRACs.
• Generate storage request for storage team. Initialising devices and altering databases as needed.
• Refresh of non-prod environments (DEV, TST, STG, LAB and TRN) from prod environment.
• Resolve tempdb/Log space full related issues.
• Created script for monitoring database fragmentation level and ‘defrag on schedule’ and ‘on demand’.
• Created script to generate automatic SQL Server stats.
• Created Shell Scripts for monitoring and supporting day to day operations.

Lead Database Developer

Confidential - NYC, NY

Responsibilities:

• Worked on a strategic process to generate data extracts from ICEView system to reconcile the notional value of OTC derivative and Listed derivative contracts. This is a requirement of the MRA - FED FFICE101 exam.
• Worked on data masking using an in-house provisioning tool - Alcazar. Alcazar moves data from production to non-prod environments, giving production quality content with suitable entitlements. Sensitive data is detected and masked, automatically and seamlessly once setup using the Discovery Program.
• Created and maintained RegW compliance reports.
• Supported nightly batch cycle and ensured all SLA's are met.

Sr. Database Developer

Confidential - NYC, NY

Responsibilities:

• Evaluated and wrote proposals for improving FSI (Firm wide Stress Initiative) system’s performance/resiliency.
• Optimized FSI module run time from 3 hours to 1.2 hours.
• Created SSIS packages to extract (from Sybase ASE, flat files and excel files) transform and load data into SPAR (SQL Server 2008) data warehouse.
• Developed data validation scripts for SPAR data warehouse.
• Participated in Defect Management and Ongoing enhancements.
• Provided production support and coordinated support with offshore team.

Sr. Database Developer

Confidential - Merrimack, NH

Responsibilities:

• Data Center Migration (MRO to RTP):
• Created shell scripts for results comparison of 200+ daily batch jobs.
• Participated in decommissioning of old MRO servers.
• Application Enhancement:
• Added ‘data transmission’ validation checks to critical path feeds as part of an internal audit requirement.
• Set up feeds (created shell scripts, stored procedures and tables) for RouteHub, TwoFour and PreClear systems on Sybase ASE/IQ databases.
• Provided production support and coordinated support with offshore team.

Sr. Database Developer/Architect

Confidential - Raleigh, NC

Responsibilities:

• Created stored procedures for fair value accounting - FAS157.
• Implemented HUGO product code expansion (data type change), an enterprise-wide effort.
• Created, Configured and Fine-tuned ETL workflows in SSIS.
• Rebuilt highly fragmented indexes on the development databases and convinced Manager that application needs a periodic index rebuild (on most actively used indexes) and coordinated production implementation with the DBA team. Recovered 35 GB of free space from index rebuilt and thus batch cycle improved by 2.5 hours and weekly database maintenance improved by 2 hours.
• Worked on database violations generated due to objects having public roles in production databases as part of SOX compliance. Analyzed current roles and permissions and wrote unix scripts for revoking public access from Americas, Europe and APAC region databases and ensured that all database objects have appropriate permissions.
• Optimized price testing, data upload and mapping modules for product controllers. There is 65% improvement in the run time from 40 minutes to 14 minutes.
• Upgraded Sybase ASE 12.0 to 15.0.3.
• Maintained and supported reports using OBIEE.
• Provided nightly batch support for GPT/SPARTA applications.
• Architect
• Architect the development environment for offshore team and handled critical issues such as data masking of sensitive information (e.g. counterparty and account information).
• Implemented DOL schema for high traffic tables to improve concurrency and minimize deadlocks/ blocks.
• Tool(s) - Data Archival
• Developed a versatile data-archival tool, which archives data to an archival database over the weekend.
• Added functionality to fire a threshold to clear the transaction log to ensure that process runs smoothly.
• An automatic ‘update statistics’ will run to ensure that distributions of key values have been updated.
• A detailed process log is logged into an audit table.

Performance Tuning Engineer

Confidential - Houston, TX

Responsibilities:

• Identified and optimized SQL statements in stored procedures and reports. There was a 25% improvement in the critical path stored procedures and 35% improvements in the reports.
• Converted report SQL’s into stored procedure call to avoid making repeating connections to the database.
• Converted clustered indexes on temp tables in stored procedure & report SQL’s to non-clustered indexes to improve performance.
• Coordinated user log cache (ULC) change from 2k to 8K (based on the observation that transactions started taking up to 14 minutes while doing a commit) with DBA team. Change was implemented and transactions started committing at a normal pace.
• Optimized stored procedures for Basel Allocation module.
• Fine tuned the logic to allocate CPUs to various tranches based on number of paths/deals for load balancing as follows:

Application DBA

Confidential - Jersey City, NJ

Responsibilities:

• Changed high traffic tables from APL to DOL to improve concurrency and minimize blocks/deadlocks. A 40% performance gain was observed. This also helped in recouping 32% disk space resulting into smaller I/O scans.
• Re-engineered batch cycle jobs to make them run in parallel.
• Identified SQL statements that were pain points and improved performance by altering SQL statements appropriately.
• Created indexes as required, restructured indexes with poor selectivity.
• Modified SQL queries to avoid deferred updates, Re-factored SQL queries for performance improvement.
• Changed SARGS to accommodate query optimizers to use the best query plan using indices.
• Modified specific stored procedures producing highly volatile data with ‘with recompile’ to avoid using a cached procedure plan.
• Performed volume test for MTS and TMS feeds.
• Created shell script & stored procedure to load security ratings feed and scheduled it in the batch cycle using autosys.
• Coordinated with SA’s for a largefile safe patch for receiving feed files bigger than 2GB.
• Created DTS packages and scheduled using SQL Agent.
• Created data filter criteria & mappings using Informatica for various transformations such as ‘Credit Calculation’ and ‘numeric conversion’.
• Provided production support and coordinated with offshore team.

Sr. Database Developer

Confidential - Warren, NJ

Responsibilities:

• Sybase ASE 12.5.3 to IQ 12.6 Migration
• Migrated ASE objects (procedures, triggers, tables, Indexes and views) to Sybase IQ.
• Worked with DBA's to create users/groups and granted appropriate permissions.
• Wrote load scripts to migrate data from ASE to IQ and performed load performance analysis.
• Mantas Trading Compliance
• Mapped firm’s order/trading/execution data obtained from various order and trade processing systems.
• Created scripts to validate Trade and Market data.
• Configured scenarios in Mantas.
• Wrote scripts to massage data feeds and fed them into Sybase IQ/Oracle databases for alert generation.
• MSDB Production Support & Maintenance
• Designed tables, wrote stored procedures to setup Order Audit and Trailing System (OATS) feed (Included New, Cancelled and Corrected Orders) for Regulatory Reporting for NASD traded securities.
• Setup feeds for High Frequency Trading (HFT) and easy to borrow (E2B) list.
• Participated in DR tests and performed checkouts to ensure that applications are working as expected.
• Created script for archiving data feeds and deleting log/temp files older than 30 days and scheduled job in autosys.
• Provided nightly batch support that includes diagnose and resolve issues (e.g. Bad feed | File no show/Delayed | Deadlocks | disk space filled etc.) to ensure that batch cycle finish at a decent time and SLA’s are met.
• Developed Perl scripts for data extraction/transformation and load (ETL).