Management Sql Server

LENA TJANDRA

Greater Los Angeles area, CA

310-***-**** cell ****.*******@*****.***

SUMMARY

Creative, forward thinking, solution oriented database architect, developer and administrator in designing and implementing efficient database solutions. Specializing in MS Sqlserver database design, performance tuning, administration, and writing complex efficient queries to encapsulate core business logic to support client/server applications, reports, and data analysis. Solid experience in designing and developing ETL process and applications. Participated in all aspects of SDLC: requirements gathering, logical/physical design, implementation, stress analysis, unit/user acceptance tests, troubleshooting, user training, and documentation.

TECHNICAL SKILLS

Database: MS Sqlserver 6.5 – 2014, Sybase, Informix, MS Access, Replication Server

BIDS: MS SSIS, DTS, SSRS

Languages: SQL, Xquery/XML, C#, VB 6, C++, Perl, vi, HTML, ASP.net, DOS, CMD shell, MSBuild 4.5

Platforms/APIs: Azure, VS 2014, .NET, COM+, Windows, Unix

Concepts: Database Design, Traditional/Modern Data Warehouse, ERD

Other: Crystal Report/SQR, Erwin ERD, Embarcadero ER/Studio

CORE QUALIFICATIONS

Database Design/Administration

Process automation and standardization

OLTP/Data Warehouse Development

Application Development

Business/Technical Requirements Gathering

Solid experience writing complex SQL, stored procedure, triggers, view, functions

Technical Troubleshooting

Performance Optimization

ETL/SSIS Development

Capacity Planning

Technical Documentation

User Support

ACCOMPLISHMENTS

Responsible for setting DB standards and best practices for the team, and establishing coding framework for error handling, establishing standards for supporting multi-user application through the proper use of database transaction and logical lock implementation to enforce data integrity, consistency, and deadlock retention both in stored procedures and application code written in vb and c#.

Responsible for SQL Server database administration tasks such as, installation, migration, implement security profile, automate backup/restore, disaster recovery planning using disk mirroring and log shipping, capacity planning, performance tuning, and job scheduling.

Designed and implemented complex business process and logic such as signatory trade workflow management using SQL Servers encryption APIs, and RightFAX APIs.

Exploited advance features of SQL Server to facilitate in writing efficient and elegant solutions. Ex, using snapshot isolation strategically to manage the balance between readers and writers and minimize deadlocks. Using table partitions to improve analytical functions. Using CTEs and over function to streamline code and improve performance on rolling aggregation. Using cross join/apply, xml, openxml, xquery to solve complex solutions such as a change data comparison utility; a logical search engine; an export portal that allows the user to choose the logical data points for export.

Mentored and educated team members in advance SQL coding techniques, the importance of transactions and concurrency in multi-user environment, use of indexes, appropriate use of cursors, etc.

Contributed to technical document.

Partner of a consulting company specializing in technology development for the “fixed income” financial investment management sector.

PROFESSIONAL EXPERIENCE

Consultant - Database Design/Application/ETL Developer

Oaktree Capital Management, LLC, Los Angeles, CA 1998-current

Design and implement from the ground up a portfolio management system that supports the ‘Buy’ side of the business. The application encompasses trade entry, compliance check, workflow validation, portfolio management, reports, and integration with third party accounting systems, security and pricing sources, ex Geneva, Total Return, WSO, Mellon, MarkIT, and Bloomberg.

Lead Database Architect/Administrator/DB Developer – designed and developed custom Portfolio Management and Trading System with emphasis on back office operational support.

Tasks include business and technical requirements, design analysis, database architecture, administration, development, and performance tuning.

Primary database engineer in the design and development of several key functions such as, trade management and workflow architecture, core complex business logic such as calculation of accretions, intra-day cash, holdings, cost, price.

Primary architect in the development and integration of third party digital signature API and RightFAX API into the VB application.

Helped convert/migrate Portfolio Management application from VB 6 to C#/.net.

Design and implemented custom digital signature encryption utility using sqlserver’s encryption APIs in order to migrate off legacy third party digital signature APIs. This also allows the execution to reside with the data, thus, improve performance.

Pilot and configured an Azure environment using ARM to setup an off-premise database environment.

Developed ETL process using sqlserver 2000 DTS, 2008 SSIS, and 2012 SSIS to manage inbound/outbound trades, position and security master refresh

The environment consist of MS Windows, application foundation utilizes 3-tier architecture, and written first in VB6, COM+, SQL Server 2000/2008, MS Access, and Crystal Reports, DTS, SSIS and later migrated to sqlserver 2014/.net/c#/Azure.

Consultant - Database Design/Application/ETL Developer

GSC, LLC, New York, NY 2007-2008

Convert legacy analytics data (1 terabyte) and programs to sqlserver 2008, and C#. Succeeded in improving process flow and performance by 24 times.

Assist data analyst in migrating and re-developing analytics engine to improve performance using sqlserver 2008, table partitioning, and c#. Performance improvement was achieved by 24 times.

Implement and integrate proprietary portfolio management system and ETL processes using sqlserver DTS/SSIS.

Create and schedule automated job processes.

Consultant - Performance Tuning/Developer

Barclays Global Investments, San Francisco, CA 1997-1998

Perform database tuning, develop stored procedures to implement multi-source pricing logic, fund to fund look-through, as well as, various SEC filing reports.

Develop ETL process using Unix scripts, schedule jobs, Sybase SQL Server, and InfoPump.

Consultant - Database/ETL Developer

Nicolas Applegate, San Diego, CA 1996-1997

Develop scripts and procedures to facilitate ETL process such as, data scrubbing and migration using Perl scripting language

Develop framework for data mining and reporting using Unix, and Sybase Sqlserver.

Technical Consultant

Informix, Los Angeles, CA 1994-1995

Primary function is to provide onsite technical support of Informix strategic clients.

Level III Technical Consulting Team – work closely with Informix clients and engineers as a liaison to troubleshoot Informix Software issues at key customer base. Often time special fix and version of Informix will be deployed for the key client.

Assist developers in bug fixes, performance tuning, and QA process.

Senior Consultant

Sybase, Los Angeles, CA 1991-1994

Provide technical consultation relating to design, implementation, installation, administration, performance tuning, benchmarking, and troubleshooting.

Work for the Professional Services Group to provide consulting services, pre and post-sales support to Sybase clients.

Teach Sybase courses at client sites.

Assist Sales force in pre and post-sales support.

Fill in temporarily as a business manager to help sell consulting services in a post-sale environment.

EDUCATION

University of California, Davis

BS Computer Science and Mathematics

OTHER ACTIVITIES & HOBBIES

Windsurfing, surfing, skiing, snowboarding, gardening, camping, traveling, cooking

LANGUAGES

English – fluent

Mandarin - speak proficient

Contact this candidate