Daniel Eisner Email & Phone Number

College Point, Ny, Us

College Point, Ny, Us

Jetro/Restaurant Depot, College Point NY ERP Systems Administrator 6/2013 to 7/2016• Project management for large scale conversion from COBOL/VSAM Systems to C# and SQL Server • Communicate and coordinate with third party providers for systems integration.• Managing development team for various ETL, EDI, SSRS, and other forward facing development tasks• Managing operations team for our buying, accounting, general ledger systems as well as our reporting environment. • Meet with business users to determine how to streamline/automate existing business practices to reduce overhead and busywork.• Training business staff on new procedures or tools available to them.• Training new developers on our systems, practices and procedures.• Maintain overall system health and up-time.Environment: Distributed SQL Servers 2000/2005/2008/2012/2014, Windows Server 2003/2008/2012, DTS/SSIS, SSAS, SSRS, SSMS, Visual Studio Data Tools 2010, Visual Studio 2012, Microsoft SourceSafe, T-SQL, C#, COBOL, VSAM, CICS, IBM Z-Series

College Point, Ny, Us

• Create tables, views, clustered & non-clustered index, and user defined functions.• Create joins and sub-queries for complex queries involving multiple tables across databases and linked servers.• Using SSIS packages to import various Sources, Targets, and Transformations.• Developed SSIS packages to extract and transform data. • Optimize existing ETL processes using a combination of merge to replace older DELETE/INSERT, index utilization, staging tables, stored procedures and SSIS.• Developed Tabular Reports, Web Based and Graphical Reports in Microsoft Visual Studio Using SSRS.• Extensively use Activity Monitor, spWhoIsActive, and analyze execution plans to optimize queries and enhance the performance of database servers.• Used DDL and DML for writing stored procedures, tables, indices, and for data manipulation.• Optimized many existing report stored procedures to help server performance.• Monitored server load during peak performance windows to identify bottlenecks and work to clear them.• Implemented index maintenance plans across multiple servers.• Designed and implemented partitioning functions and schemes for large tables.• Designed and implemented archiving of older data to manage drive space, backup maintenance windows.• Redesign and automate user tasks to eliminate manual data entry and report maintenance and make reports available on demand in the SSRS environment.• Work closely with mainframe team to extract data from VSAM/CICS environment for use in SQL Server based reporting.• Meet with users to collect and analyze system requirements and complex business logic.• Perform ad-hoc reporting to assist various departments produce data.• Designed and deployed C# based web pages with Visual Studio for data validation by users.Environment: Distributed SQL Servers 2000/2005/2008/2012/2014, Windows Server 2003/2008/2012, DTS/SSIS, SSAS, SSRS, SSMS, Visual Studio Data Tools 2010, Visual Studio 2012, Microsoft SourceSafe, T-SQL, C#.

• In concert with the original developer, orchestrated streamlining and rework of proprietary customer and order tracking and processing system in FoxPro 9, including rewriting queries to minimize I/O cost and maximize performance, help automate tasks, and create better reporting tools.• Designed, developed and maintained VB suite of tools for data entry and upkeep that communicates with both the onsite FoxPro database and offsite MS SQL Server database.• Maintained pricing and other website information by parsing and feeding information supplied in various formats between the 2 databases.• Had extensive input on and worked closely with web programmer on various ASP page improvements for the website.• Placed orders with vendors, tracking progress, dealing with issues as they arise.• Dealt with customer issues, resolving them by communicating with in-house sales staff and vendor claims departments.• Responsible for meeting customer deadlines, making sure products are decorated as expected, while maximizing profits by choosing the appropriate vendor.

Master Of Arts (Ma), Computer Science

Bachelor Of Science (Bs), Computer And Information Sciences, General