Dmitry Pasternak Email & Phone Number

San Diego, Ca, Us

Greater San Diego Area

ANALYST OPERATIONS, Performance & Data Recon 2009 - 2017Develop and support new procedures, tools, and applications using Access databases and SQL. Build Microsoft SQL Queries for Reports. Design and develop relational databases. Develop UI’s, scripts, macros and procedures.• Designed and built a database called Breaks Management Console utilizing over 2500 objects with pass through SQL queries, UI’s, macros and reports which serve as a centralized console for nearly 400 daily users.● Designed and built a database called Pricing Management Console responsible for LPLs pricing of securities. • It was designed with complex SQL stored procedures, nightly jobs and audit features. Nearly 200,000 securities are priced, validated, stored, and updated into various systems daily. It has greatly streamlined the process, increased accuracy, and saved multiple FTEs. • Determine improvement opportunities and develop new tools and workflows supporting them. • Support advisory group, pricing and performance data management (Portfolio Manager reports) with processing and training.• Work on various projects with BTS (Business Technology Solutions), UAT efforts, testing scripts.

Greater San Diego Area

MANAGER, BROKER DEALER SUPPORT SERVICES - 2005-2009 Operational department manager reported directly to VP of Advisory Accounting. ● Led, managed, and trained personnel to work with proprietary built applications. ● Managed employee development, staff cross training, continual education, and mentoring. ● Managed vendor/contractors: recruiting, negotiating prices, controlling progress. ● Created internal procedures for personnel. Developed a standardized template for use in operations to enhance effectiveness and efficiency in daily operations. ● Managed a staff of 15 – by setting professional goals, guiding by knowledge, defining expectations, validating results and performance feedback. ● Provided clear communication line to the senior management by creating and distributing reports containing company sensitive data. Made adjustments to the reports on as needed basis to accommodate various needs in fast paced environment. ● Revamped operational processes to improve productivity and efficiency through a rigid quality control process.

San Diego

SUPERVISOR, BROKER DEALER SUPPORT SERVICES - 2003 – 2005Supervised a group of 11 staff members reporting to a Director of Mutual Funds Administration. SMEacted as a knowledge base for challenging situations and escalated phone calls. Improved efficiencies and streamlined processes by analyzing where a process can be automated and enhanced.● Analyzed, designed and created a Microsoft Access Database that was used as a process flow management tool between various team members. Database saved $250,000 annually and reduced 150 hours of FTE time per month.● Participated in the creation of an online notifications system, which reduced the number of outbound calls to our clients. Savings of over 30 hours per week of phone calls.● Set service quality standards and turnaround times for inquiries to less than 24 hours by creating an innovative technology based strategy and tracking system.● Instituted an innovative accountability processes to insure near 100% efficiency levels that would meet and exceed stated goals.● Operations Specialist Promoted 3 times to the group Supervisor 2000 to 2003

• Assisted Overland Marketing team with various tasks, organized and put together over 40 tradeshows per year. • Attended and represented shows such as Comdex, Networld + Interop and PC Expo.