Data Sql Server

Jacob Peysakh

**** ******* ******, *** ******, NJ 08857; Mobile: 914-***-****; Email: ************@*********.***

LinkedIn Public Profile: http://www.linkedin.com/in/jacobpeysakh

EXECUTIVE SUMMARY

Extensive experience in organizing and handling large volumes of data from variety of sources, architecting and developing Databases, Data Warehouses in Financial Services industry with emphasis on Data Analysis / Mining / BI, Dimensional Modeling, Logical/Physical Design, ETL Architecture, Performance Tuning. Knowledgeable, competent, responsible and reliable team player.

BUSINESS KNOWLEDGE

Securities industry: equities, OTC options, convertible bonds; basics of fixed income, FX, structured products, Mutual & Hedge Funds, US Capital & Money Markets; trade surveillance, trading systems, order & trade management, execution, settlement, clearing & workflow processes, book processing, redemption, portfolio & position accounting/reconciliation; contact management; fundamental & technical analysis, equity research & due diligence, options theory, pricing model and P&L, FoF, Value-at-Risk calculations, risk monitoring and credit systems; Firm-Office-Rep-Territory allocations and accounting, complex Business Rules, market & reference data (Bloomberg/BBOP, Thomson/Reuters); compliance, OATS, AML, SOX, Basel II, various SEC regulations

EXPERTISE IN

Transforming complex business requirements into sophisticated, robust and cost-effective business and technical solutions

Business analysis, Dimensional (Star/Snowflake) and ER Data Modeling; Metadata Support; Business Process Modeling

EDW (Kimball, Inmon) and Data Mart Architecture, Design and Development; Performance Tuning of T-SQL and ETL

Stored procedures, triggers, views, system access & data security, data masking

Referential and Data Integrity, Data Quality and Cleansing

BI Reporting design and development with drill down, roll up and drill across functionality

Database Administration and Management, Replication, Standards and Naming Conventions

Database capacity planning, scaling, disaster recovery (DR), business continuity planning (BCP)

Mentoring and coaching the concepts of Data Warehousing, Database and ETL technology to designers and developers

Project Management, Technical Leadership, working in global environment with global outsourced vendors & teams

TECHNICAL SKILLS

Databases: Sybase ASE, MS SQL Server

DW/BI: MS SSIS/SSRS/SSAS, OLAP/Cube, Data Mining, MDX, DTS, ETL

Talend Open Studio & Integration Suite, Data Visualization (Panopticon / Datawatch)

Systems: Unix, Linux, Windows 7

Languages: T-SQL, Excel/VBA/Pivot Table w/Chart, shells (Korn, Bourne, csh, bash, perl, sed, awk)

Data Modeling: Power Designer, DBArtisan, ERwin

Change Control: MS Visual Source Safe (VSS), Subversion

Technologies: C/S, DCE, n-tier architecture

Methodologies: SOA Agile Modeling & Design methodology, OLTP/DSS, Object Oriented Analysis/Design/Programming

Software: MS SharePoint, MS Office 2016 Suite, Visio, Quest Software (Spotlight, Foglight), Panopticon/Datawatch

Trading Platforms: Imagine Software, Fidelity Active Trader Pro, OptionsHouse

PROFESSIONAL EXPERIENCE

Data Warehouse Architect, Imagine Software, Inc., NY

05/2011 – 08/2016

Architected, designed, developed, introduced into production and maintained Risk Aggregation Data Warehouse product.

oFor an overall description and demo please see: http://www.derivatives.com/riskagg

Considerably enhanced and applied the concepts and principles outlined in original research by Jacob Peysakh in 2005 paper "Temporal Data Model Architecture" to the architect, design, and customization of the Risk Aggregation (RA) bi-temporal Data Warehouse product. Instrumental in sales and web-based public-demos of RA product to existing and prospect clients.

Single handedly developed, programmed in T-SQL, QA/UAT tested, introduced into production practice and maintained a fully functional, industrial strength, highly scalable multi-tenant DW RA (with “Chinese Wall” guaranteed separation of tenant’s private data) environment for Portfolio & Risk Managers, Hedge Funds, Managed Accounts & Fund of Funds clients. Designed and implemented bi-temporal role-based data & functionality provisioning - a multi-dimensional cube, with drill-down/up/across and data mining and patterns discovery & identification ability from aggregated Risk Metrics down to Position Level Transparency in 11 major aggregation dimensions (Portfolio/Fund, Asset Class/Security Type, GICS (all 4 levels), Region/Country, Credit Rating) and 13 additional FI instruments specific dimensions.

Designed, developed and implemented in production all of the database side software for the RA DW. (Sybase ASE 15.7, Linux), including end-to-end automated ETL processes for 20+ data streams upload into the DW (with rule-based data quality verification & exceptions capturing, reporting engine and with pre-determined auto-fix ability learn engine to handle up to 97% of data quality, integrity and discrepancy issues automatically) and RA Portal Data Visualization (Panopticon/Datawatch) and Reporting (Crystal Reports) functionality.

Designed and implemented fully functional Workflow Management subsystem, as well as the Data Publishing Workflow in a live-system with simultaneous real-time data feeds and uploads and concurrent production client’s access without any noticeable straining of DW technical performance tolerance boundaries and no impact on client’s end-user access experience

Performance tuned server and database components supporting web-based Data Visualization and Reporting by 2+ orders of magnitude. Fully automated & performance tuned referential and operational data upload into the RA DW. Performance tuned multiple areas of Imagine Trading System (ITS) by 2+ orders of magnitude by surgically replacing deep-core common functionality with a considerably better performing SQL code

Significantly enhanced bi-temporal techniques in application to Risk Analytics - mortgage, betas, correlations, data mining / visualization, time-series, returns model, reporting, 3rd party data feeds, etc.

Developed and enhanced numerous Panopticon/Datawatch-based Data Visualization Dashboards. Programmed, in SQL complex mathematics for statistical and risk analytics (beta's & benchmarks, covariance & correlations, tracking error, VaR (including Conditional, Component and Marginal), FX, worse draw-downs, shocks/stresses, Greeks/sensitivities, risk scenarios, portfolio management, returns model, and alike).

Technical Lead, Credit-Suisse, NY

07/2010 –05/2011

As a member of an Equities IB and Post Trade Technologies departments, responsible for numerous technical aspects of the global multi-year initiative in design and construction of a Cancel & Correct Surveillance System across all product lines (equities, derivatives, fixed income, FX, commodities) consisting of an Oracle-based Data Mart, IBM JRules based Business Rules engine, BOXI-based BI reporting and proprietary Java/JAP/WebLogic based supervisory control workflow application.

Communicated with Business and IT Project Managements and outsources vendors. Participated in numerous project meetings.

Led technical aspects in design of various aspects of the system – from conceptual solution architecture, ETL to Rules and BI Reporting. Wrote numerous project documents – Infrastructure and Environments Specifications, Data Mart DB Access and Data Security Setup, Data Feed Specifications and Handshake Protocols, Data Warehouse Archiving, Trade and Reference Data Reject Processing, ETL and Process Control & Monitoring. Reviewed for technical sign-off purposes numerous project’s documents developed by various client and vendor teams (BA, designers, architects and developers) – Business, Functional and Non-Functional Requirements, High-Level Solution Architecture and Design, Logical & Physical Dimensional and Transactional Data Modeling, Low-level Design and Construction, Testing and QA/UAT Plans. Participated in formal design review process. Maintained project documentation in SDLC+ Workbench.

Worked with various groups/functions in Client’s infrastructure (architects, delivery managers, Unix & storage teams, DBA’s) on designing, requesting and setting up all applications environments – DEV, SIT, QA, UAT and PROD/DR – for all project’s technology stacks – Informatica, BOXI, Java/JAP, JRules.

Worked closely with onshore and offshore outsource vendor teams. Reviewed, evaluated and negotiated with vendor efforts and timelines for various project components; with BA’s on various data and reporting aspects of the system; with data source teams on data feed automation and SLA’s, data mapping, quality and integrity issues; provided UAT sign-offs for data feeds.

Led and participated in technical discussions, brainstorming, design and development, and review sessions in all project streams from HLD to construction. Performed and participated in code review and formal code walkthroughs.

Sr. Data Feed Analyst & Data Warehouse Specialist/Architect, Jefferies & Co., NY

12/2009 –06/2010

As a member of an Equities Data Platform department, was responsible for production support, monitoring and troubleshooting daily ETL cycle into Equities & Derivatives Financial Data Warehouse and Revenue Data Mart. Streamlined Perl scripts and performance tuned Sybase stored procedures. Improved overall stability of the system. Created Production Support guide and manual, documenting all known issues/problems and workaround solutions. Participated in nightly support on rotational basis. Performance improved numerous stored procedures by several orders of magnitude, leading to near-real-time report generation for Data Administration group and various trading desks. Participated in OSI implementation project.

Designed, developed, documented data warehouse Archiving Solution. As a member of a joint developers and DBA team, participated in production implementation of the Archiving Process. (5TB+)

Performed data analysis / problem resolution & remediation, coding / testing, matching / reporting, cross-verification & validation of internal and external Third Party Vendors data (Fidessa, Flex, ADP, Imagine) for Hold Release, Cancel / Correct and Reconciliation areas of the data administration and management.

Market & Reference Data Marts ETL design, implementation, maintenance and documentation (Bloomberg [BBOP/API], Markit, Pershing, Thompson/Reuters, Townsend, Blue Matrix)

Sr. Data Feed Analyst & Data Warehouse Specialist/Architect, Allianz Global Advisers, NY

09/2009 –12/2009

Responsible for entire data feed cycle: establishing list of feeds, consolidating and integrating data streams and formats, ETL mapping to the database, working with CIO, Data Administration Head, Project Managers and end-users on establishing the business rules for each feed; development, testing and deployment of the ETL solution. Responsible for gathering requirements, analysis, communicating status and resolution plans to project manager and delivering the solutions. Responsible for project’s resource estimates (workload, timeline, personnel, milestones, documentation, and deliverables); maintain project plans and monitor progress. Organizing and working with offshore teams.

Database development, conceptual/logical/physical design for performance and scalability. Automation of ETL data loads from various sources, including provider's website portal. Manage the quality of data being imported/exported in/out of the database. Analyze data provided from external entities in non-standard file formats. Designed effective data archiving solution.

Provided accurate estimates for resolution of each task; identified dependencies and risks; planed for QA, UAT and Deployment steps. Acted as business analyst, including meeting with users and data vendors; gathered requirements and researching most optimal solution. Advised Data Warehouse team on strategic alternative of Data Warehouse and Data Mart design and implementation. Proposed innovative design to address temporal issues of maintaining Slowly Changing Dimensions (SCD).

Architected, designed, developed and implemented robust massively-parallel asynchronous ETL solution using Talend (Windows XP, Linux, SFTP, MS SQL 2005). Participated in requirement meetings with Business Analysts and Data Warehouse team to flesh-out the specifications for data model, technical metadata and cleansing/transformation rules, Business Rules. Conducted source system analysis and data profiling.

Market, Reference, Orders, Allocations, Executions & Position Data ETL design, implementation, maintenance and documentation (Bloomberg, Pershing, Prudential, Lincoln Financials, Hartford Financials, DTC)

Sr. Database & Data Warehouse Specialist/Architect, IT Consulting Company, NY

06/2008 – 08/2009

Tangraph: Advised on MySQL server configuration and performance tuning parameters; adjusted database design (tables, indices, normalization) and performance tuned SQL scripts and stored procedures in MySQL web environment.

UBS Financials: Provided Database Architecture, PM and support of Data Center Migration Project (DCMP) for MS SQL Server, Oracle and Sybase. Mapped database/application instances from current environments into new server farms of the hot-swappable, warm standby and cold environments. Assessed storage capacity, performance, throughput, application mix & bandwidth and SLA for new-builds (AIX 5.3 to Solaris 8 hardware & OS migration; upgrades: MS SQL Server from 2000 to 2005/2008; Oracle from 9.x to 10g, Sybase from 12.5.x to 15, 7TB+ EDW). Developed Road Map for database server migration in Waves and by application Tiers. Closely worked with: Infrastructure and Design Deck teams on coordination and scheduling of data servers migration; production DBAs to tune server parameters, I/O load and balancing; application developers – assessed and addressed Data Quality issues, analyzed and performance tuned numerous critical SQL queries, stored procedures and triggers.

Reviewed and streamlined MS SQL Server replication setup and patterns (log shipping, transactional)

Responsible for Oracle Char Set migration to Unicode. Designed Migration Road Map. Analyzed csscan output for char/lang mix, issues of truncation, invalid replacement chars, lossy conversion, etc. Developed test cases addressing issues revealed, designed and developed remediation solutions. Wrote migration scripts for application developers and DBAs.

Managed documents on MS SharePoint. Prepared all relevant documentation in Excel, Visio & PowerPoint presentations.

SOA Solutions: Oracle Application Server 11g “Best Practices” in regards to Identity and Access Management Suite: Oracle Internet Directory, LDAP, Access Manager, Identity System, Single Sign-ON, One-Time Password, AES/SHA. Validated Specifications and Requirements for the State of CA Labor Department UI re-engineering project. Database architecture, modeling, scalability and performance, ETL and legacy data conversion. Advised on database & data related aspects of a series of IVR applications, such as: Initial and Continuous Claims Filing, Sub-contractor Information Query, Driving Directions, Address and Contract Update. Advised on RUP/UML in application to – Functional View (Use Cases diagrams & descriptors), Behavior View (State Transition Diagrams/State Machine Model, Call Flow/IVR Dialogs, Communication Diagrams/Message Flow, Activity Diagrams/Business Processes).

Third Point Advisors: Architected turn-key Sybase ASE production maintenance solution supporting SunGard’s Front Arena applications. Designed, documented, wrote and installed into practice core set of unix scripts required for healthy production operations of data servers. Configured Front Arena logins & users. Created Front Arena’s dev/QA/UAT environment. Implemented “best practice” customized solution for Sybase I/O Subsystem; boost performance for Front Arena databases. Reduced synchronization time from production to UAT Front Arena environments by an order of magnitude. (Sybase ASE 12.5.x, Sun/Solaris 10, Front Arena 3.7)

Sr. Data/DB Architect/Development DBA, Alliance Bernstein, White Plains, NY

04/2007 – 05/2008

Re-architected equities post-trading and front/middle-office database for processing data from Flex Trade, Lava, Oasis Global & Direct Trading systems and manual trades. Improved scalability and throughput by order of magnitude. Prepared and conducted UAT, coordinated production implementation with globally diverse team of DBAs and developers.

Designed and implemented robust data archiving mechanism. Performance tuned workflow processing system. (2TB+)

Performed gap analysis and data consolidation from disparate data sources into target operational data mart. Designed target data model and schema; developed data mapping; wrote data cleansing/scrubbing scripts; error/exception handling, reporting and remediation mechanism; data quality, data & referential integrity check scripts; designed, wrote & automated data migration ETL processes. (Sybase ASE, MS SQL Server 2005, Control-M, PowerBuilder, unix/linux)

Re-architected OMS, Trade Execution / Accounting, Cancel / Correct, Reconciliation / Reporting, cross-verification & validation of internal and external Third Party Vendors data (Flex, Lava, ADP, OASIS).

Architected CPM EDW for banking (MS SQL Server 2005, SSIS/SSRS/SSAS, 5TB+). Developed dashboards and scorecard reports. Designed and developed numerous data marts, among them (with major fact tables in italics):

Decision area & Executive & Risk Management: Income Statement/Balance Sheet, Drill-Down Variance/Cash Balances, CapEx/Strategic Investments/Treasury, Decision Areas/Financial Management/Operational Expense/Assets/Productivity/Compliance, Credit/Operational/Market Risk

Investment & Business Advisory/Customer Services & Product Management: Marketing/Competition/Customer, Revenue/Products/Sales, Delivery/Claims/Benchmarks, Products/Services/Strategy/Management

Operations/HR/IT: Purchasing & Procurement/Capacity & Resources/Network & Logistics, Cost/Quality, Process Efficiency, Organization & Staffing/Compensation/Training/Benefits, Business Value/Portfolio Management/Projects & SDLC/Vendors/Compliance

Sr. Data & Database Architect, Director, UBS IB, Stamford, CT

08/2005 – 04/2007

Architected and re-designed logical and physical data model for Global Equities & Derivatives Trading & Risk Analytics database, covered listed and exotic/structured products, Trade Lifecycle Management. Performance tuned Cash Equities trading database by an order of magnitude, optimized views and stored procedures in Risk database with 100-fold speedup outcome.

Introduced into practice temporal data management for financial market observations, reference and operational data with application to Position Tracking, Market Data and Security Master Data Warehouse projects (Oracle, Sybase, 12TB+ EDW).

Established global performance monitoring and capacity planning infrastructure based on Quest’s Software Foglight s/w suite for major production systems in Equities. Managed vendor’s software evaluation, acquisition, installation and configurations. Trained and mentored a group of developers and DBAs in Foglight.

Provided database production support on the trading floor. Managed a team of 4 Sybase & Oracle DBAs.

Sr. Business Solution Architect, Alexandra Investment Management, New York, NY

10/2004 – 07/2005

Architected end-to-end Business Solution of Portfolio Monitoring & Reporting for Front Office, Trading Desk and Investment Department of the Hedge Fund operation. Designed, developed integrated and delivered a multi-source (OMS, VPM, Tradar, McGregor) Portfolio Reconciliation system (MS Office 2003, MS SQL 2000, SQL, Excel / VBA) for Head Trader.

Developed Portfolio Market Value and Movers & Shakers Analysis system using MS SQL Server 2000 OLAP cubes for Executive level presentation and reporting. Developed cubes with portfolio, fund, strategy, sub-book, custodian and time dimensions (with drilldowns and drill ups) and long/short measures.

Initiated architecture and laid out ground work for development of a financial data warehouse. Designed and developed a sophisticated ETL data quarry process with Rule Based data quality screening, mapping and exceptions handling and reporting mechanisms. Developed a system capable of drilldowns from exception reports to atomic data elements values, propagating modified values to all affected dependent destinations. Designed, developed and implemented numerous tools to assist Data Administration in Data Cleansing process.

Worked directly with Investment Department’s Sr. Quantitative Analyst. Managed 3 senior level application developers.

Sr. Data & Database Architect / Sr. Development DBA, Amaranth, Greenwich, CT

12/2003 – 10/2004

Heavily participated in an effort of decoupling company’s databases from parent-company hosts. Wrote and successfully implemented all SQL scripts for data conversion and transform, data quality & integrity reporting.

Lead development of a financial data warehouse (5TB+) under the Security Master initiative. Participated in data acquisition processes. Thoroughly familiar with Bloomberg Back Office Product. Developed a fully automated system of processing BBOP data feeds into company’s databases, achieving load of data into internal databases within 3 minutes from its appearance on BB ftp hosts. Organized development and implementation of the Security Master data warehouse modules according to ongoing business needs and priorities. Supervised a group of 3 developers.

Designed and developed an innovative approach to handling temporal data in RDBMS. This “valid-time” paradigm enables recording of events in a database such that they become “visible” only at their “effective times”. Applied this technology to handling of Corporate Actions, Historical Prices, Convertible Bond Terms and Analytics, Risk Management, Portfolio Accounting, Custodian, Legal and Due Diligence systems.

Designed and developed an innovative approach to a unified automated ETL architecture capable of handling temporal aspects of incoming data and achieving a significant reduction in database space requirements for storing temporal data historically in RDBMS systems while preserving full functionality of online access to the historical data (Sybase 12.5.x, MS SQL Server, SQL, Perl/Linux, Java, ASP)

Developed and implemented a rule-based data mapping and exceptions handling methodology and mechanism. Supervised the construction of a framework libraries and scripts to automatically parse and recognize metadata, create templates, generate relevant SQL gear and install it into target databases. Developed automated framework of rule-based template-generated scripts for Testing, QA and Data Quality / Integrity Screening.

Designed, developed, documented and implemented State Transition Diagram (STD) based control architecture for end-to-end handling of parallel ETL processes. Supervised the construction of Web interface for animation, visualization, monitoring, alerting and control of the STD processes.

Applied this ETL technology to the Convertible Bonds Data Mart featuring BBOP data feed and inter-system data exchange between CB Analyzer (MS Access) and Security Master data warehouse (Sybase), achieving a complete data exchange of the 1100 bond universe within 1.5 minutes.

Designed, developed and introduced into practice a rule-based and rule-driven system for Data Quality Screening and Information Correction with an ability to arbitrate among the different data feeds, shielding and protecting company’s production systems operational data stores (ODS) while assuring quality data in internal databases. The system’s mechanism allowed for a full concurrency control in data handling and administration, with an ultimate commit / rollback granularity of table/record/field level as well and enabling aggregate actions (both commit and rollback) to be performed over a collection of fields, records and tables at once; the mechanism also featured an override based on a role / function authorization scheme. Implemented in Excel and supervised implementation of the same mechanism via Web. Stressed an easy-of-use and intuitive navigation of the Data Quality (DQ) Tool. Placed the DQ Tool into the hands of immediate users at trading desks and data administration.

Designed and developed OLAP module for Risk Analytics utilizing MS SQL 2000 Analytical Services and Excel Pivot Table with Chart. Designed and developed an innovative methodology based on Characteristics Functions technology for Statistical Arbitrage modeling, allowing practically limitless parameterization of financial strategy models.

Sr. Development DBA, Royal Bank of Canada, NY, NY

01/2002 – 11/2003

Production support sa/dba in Sybase/MS SQL Server replication environments.

Administered, automated and supported production database environment of the Hedge Fund. Established QA environment, change management/control and production rollout process. Improved performance of front-end applications to sub-second response time. Decreased nightly book processing from over 6 hours to less than 30 min.

Close interface with business users and daily support of Hedge Fund front-office production operations. Designed numerous Hedge Fund database components/subsystems: Book processing, Order Entry, Redemption, VaR, Contact Management, Pricing Model, P&L, and Due Diligence

Developed Risk Factors and Pricing Model Analysis tool utilizing Excel Pivot Table with Chart. Used MS SQL Server 2000 OLAP for developing cubes to analyze “Mid-month/End-of-Month model vs. Manager Return Estimates”: with Fund-of-Funds (FoF) fact table with a built-in day/month-level time dimension; star/snowflake dimension of strategy and sub-strategy; aggregating number of funds in FoF, position values, exposure to security instruments across basket, LHU and FoF hierarchies, and %-difference in returns; providing drilldown to daily level and drill up to quarterly, semi-annual and annual levels. Created similar cube for “Operator vs. Pure Model % difference” analysis. In both cases developed reports and graphical representations of aggregated measures vs. certain slice of dimensions – typically by time for strategy/sub-strategy selection; as well as cumulative USD-positions on LHU/FoF levels and time.

Executed overall database design, performance tuned (servers, databases and applications). Designed and developed scores of tables, stored procedures and triggers. Wrote numerous data quality validation, integrity verification and conversion scripts. Improved major Hedge Fund component performance by an order of magnitude. Designed and developed:

Redemption subsystem, enabling on-time processing fund redemption requests, eliminating book runner’s backlog and allowing more precise valuation of portfolios.

Order Entry subsystem, enabling highly cooperative collaboration of book runners and marketers operations.

Due Diligence subsystem, eliminating numerous steps in manual document cross-referencing and enabling online, real-time reporting of Hedge Fund characteristics historical aspects.

Converted proprietary 3rd party MS Access based Contact Management System (ACT) into Sybase & MS SQL Server environment and consolidated with Hedge Fund Contact Management subsystem, eliminating excessive maintenance cost

Sr. Sybase SA/DBA, BlackRock Financial Management, NY, NY

11/1999 – 12/2001

Production support sa/dba in Sybase/MS SQL Server replication environments.

Supported systems: Fixed Income and Equity trading, Risk Monitoring and Credit, and HR

Managed upgrade/migration of numerous business-critical databases/applications

Authored “Best Practice SQL Coding” guide and conducted training seminars for DBAs and application developers. Wrote cross-server schema comparison and reporting application, allowing quick synchronization of home-office and client’s database environments. Developed a performance analysis and tuning tool to capture and analyze Sybase ASE and MS SQL Server performance characteristics, enabling rapid elimination of application performance bottlenecks

Re-designed a number of applications to improve performance and LOS compliance. Re-wrote/tuned critical stored procedures and triggers, resulting in a 50-300% improvement in overall execution cost

Sr. Sybase SA/DBA, MSKCC, NY, NY

02/1999 – 11/1999

Production support sa/dba in Sybase/MS SQL Server/Mainframe environment

Re-wrote/tuned stored procedures and triggers, resulting in 5-50% reduction of overall execution cost

Participated in Y2K certification and testing of major applications

Sr. Sybase SA/DBA, Merck-Medco Managed Care, Montvale, NJ

08/1997 – 02/1999

Production support sa/dba in Sybase/Teradata environment. Support of DWH expert system infrastructure including database architecture, design and capacity planning. Performed EDW data modeling and design.

Re-wrote 600 stored procedures and scores of triggers, streamlining application processing by 3 orders of magnitude, reducing system/database resource consumption/CPU load by a factor of 4, eliminating costly hardware upgrades

Resolved concurrency problem eliminating response-time related financial penalties, positively affected daily operations efficiency, significantly improved timeliness of services and customer satisfaction, directly leading to client’s increased profitability.

Sr. Sybase SA/DBA/Consultant/Mentor/Trainer, IT Consulting Company, NY, NY

08/1994 – 08/1997

HFS Mobility Services: Performed Sybase ASE/repserver production support. Designed architecture, setup and troubleshooting of Replication Servers. Managed day-to-day development and production environments, supporting 5000 concurrent on-line users from numerous international real estate office locations.

Banco

Contact this candidate