Matthew Donner Email & Phone Number

Fair Lawn, Nj, Us

New York, Ny, Us

Pearl River, Ny, Us

Analyzes raw data sources supplied by client. Expert level of data cleansing and manipulation. Solid knowledge of t-SQL 2012 and 2016 software including store procedures and functions within the SSIS framework. Advanced knowledge of transformation and normalization of database design.

• Responsible engineer in all areas of database software solutions in the New York City o Architected normalized table models, related user stored procedures, functions, and triggers coded to take advantage of the underlining indexing. Study the active behavior third party database via the Profiler tool. Oversaw the backup process, disk spaces monitoring, and general system health. Monitored twelve proprietary SQL Servers ranging from 2005 to 2012 databases systemso Coded solutions to increase the Business Intelligence of agent travel bookings by applying advanced SSIS/SSRS language techniques to match raw data with recognized industrial standard travel data. Designed internal Travel Agent as well as Client based performance “report cards” by polling data from the Human Resource, Agresso ERP database, and Sales Force data entities.o Designed a transactional replication database model to keep an updated the telecommunication phone system among the various intercontinental offices. This system included an internal website interface allowing managers to alter key data point modifications – allowing for immediate company wide data updates. o Hands-on in all matters daily activity including database installations; third party propriety software upgrades; specialized client specific ‘CRUD’ applications; and resolving daily support ticketing items.

• Twice voted as New Jersey’s top 500 fast paced growth companies in Fleet Management, (i.e. warehouse asset management of forklifts, tows, cranes, and vehicles) responsibilities included:o Coding solutions to parsing real time binary data; depicting warehouse fleet activity into a structured database system.o Examine t-SQL execution plans, assessing SQL profiler tracing data, and applying clustered/non-clustered index to optimize stored procedures.o Routinely coded t-SQL procedures, functions, and triggers to report and track active fleet activity (i.e. vehicle location, speed, and load amounts)• Provided Clients with specific enhancements including aggregation activity reports, specialized code to exchanged data among independent systems, issued database enhancements (DML/DDL) to satisfy an individual requests, and oversaw replication model depicting inventory. Regularly chosen to be the team lead to present solutions to clients either on-site or via web-conference (i.e. Ford Motor Company, Walmart)• Modified various proprietary baseline systems (CRM Software, Dynamic Link Libraries, and Services) to capture data transmitted via radio airwaves. Routinely expanded standard database model by designing new Tables/Indexes/Stored Procedure to parse, display, and report new features.• Coordinated System Testing procedures (Unit, System, Stress Level) among hardware, software, and system test teams. Documented system test plans for software releases and historical archiving.• t-SQL database programmer required to design database systems for such clients as Ford, Walmart, Avis, Audi, and the United States Postal Service. Project included automating the transmission of data among proprietary systems

• Nationally recognized as the prime source of charitable income source for Hospitals and Universities, daily tasked include interfacing with both Client and Sales Staff to generate detailed personal monetary profiles of potential donors by coding applications and T-SQL stored procedures to match personal information to internal data sources (Thomson Financial, Dun and Bradstreet, Lexus-Nexus, Federal Election Files) to ascertain individual personal wealth. Responsible Engineer required to research potential new optimization solutions among industry solutions (Group1, First Logic, Trillium, AccuZip). • Routine performed DTS functions to maintain various SQL 2000 databases housing Stock Market Transactions by coding User Defined Functions and Stored Procedures, and enhanced Group1/AccuZip tools with exit routines written in C++ and FoxPro, respectfully. Provided Clients Survey Data Statistics by applying extensive knowledge of T-SQL Techniques to extract data.• Application programmer required to enhance proprietary desktop software. Coded in Access 2000 VBA, this application used ADO/DAO connections to allow clients to cross reference of individual financial data; download latest transaction from our servers; and build focused selections of data.

London, Gb

• As an independent contractor, worked directly with divisional management to implemented APRIMO CRM application. Applied Trillium Software techniques to correct and standardized client data on an internal Company and Client data files. Processed data was enhanced with external files (Dun and Bradstreet) data sources. Designed a database system to identify regional client data business information.

• Turn-Keyed a start-up Data Processing Center in Englewood, New Jersey consisting of 25 employees. My mission was to bring in-house outsourced data processing efforts without the disruption of daily business. Required to oversee the • Turn-Keyed a start-up Data Processing Center in Englewood, New Jersey consisting of 25 employees. My mission was to bring in-house outsourced data processing efforts without the disruption of daily business. Required to oversee the construction/maintenance of a web-based customer product/email delivery system, train/mentor junior programmers to follow best practices of t-SQL/ASP Coding techniques, and daily interact with Clients to fulfill data processing requests.• Daily technical tasks included: monitoring multiple SQL RDBMS systems; Validating/Uploading via BCP/DTS client data, defining tables for new lists and their related data dictionary field definitions, proper Index allocation, deep dive into code to resolve errors and enhance product, designing on-the-fly data collection web pages.

Bachelor Of Science In Computer Science, Computer Science

Education record

Business Intelligence And Big Data Solutions With Sql Server.

Designing, Optimizing, And Maintaining A Database Administrative Solution