Dan D. Email & Phone Number

Database Architect, ASP.Net C# Web Development, CSS, JavaScript, HTML, SSIS

Islandia, Ny, Us

Support Project Managers and Business Analysts in troubleshooting data issues;Troubleshoot data and data-compilation anomalies;Assist in procedure creation for new and existing processes;Creation and modification of existing and new processes to increase data throughput and efficiency; andPerform other duties as required.

Greenvale, New York, Us

Software Engineer for a company that turns a new face to the coin-op user engagement. Bridging the gap between client facing application development and deployment as well as cloud based financial reporting, responsibilities included working in a C# WPF .NET 4.6 environment with a SQL SERVER 2017 Express client back end. Development was done in Visual Studio 2017 Community Edition. Database migrations were performed with the DBUp .Net Client Library. Prototyped conversion to PostgreSQL 11.0 for DDL/DML and data migration. Data Access was accomplished in Entity Framework 6.2.1 initially with the conversion targeted to EF .Net Core 2.2 for Postgres. Responsible for all client machine database development of tables/views/stored procedures and database design as well as financial reporting development that resulted in conversion of reports designed to print to a custom printer with print jobs converted to images. Whole ecosystem included .Net client machines with Amazon web-services reporting to a multiple device friendly back-end. Source code control was maintained in GitHub.

Senior Technical Solution Provider for the firm that assists clients that use a financial real estate management platform called Yardi. Collaborates with executive management for technical documentation, proposals, technical investigation for reporting enhancements/alternatives as well as laying out enterprise level strategies to replicate data across disparate systems into Yardi. Primarily involved in reporting enhancements with SQL, Excel, and Yardi configuration in the cloud.

DB Architect/Lead Developer for financial reporting to senior stakeholders and bank investors. Responsible for over 2 billion dollars of reporting on a monthly basis for asset back securities and inter-bank deals. Refined intensive manual reporting process from weeks into an automated process taking hours. • Automated an Oracle 12c download into SQL Server 2014 64 bit data lake and ETL into data warehouse environments.• Responsible for all tables/views/stored procedure/user defined function creation and performance tuning. • Automated data feed to Amazon Redshift for data warehouse reporting. • Upgraded Crystal Reports to version 14.1 to pull data from the SQL Server 2014 versus the original ODBC connectivity to MS Access 2013. • Produced a .Net 4.5 console application/LINQ to SQL program to do an address verification for 1098 statements from the UPS web enabled API. • Created a .Net 4.5 console application to download and synchronize files between the MOHELA service provider SFTP site and the local network domain. • Generated a .Net 4.5 console application that automated downloads from the reporting web site which provided text reports which were imported and parsed via TSQL which were then exported to Excel and dropped on Sharepoint. • Used Redgate SQL Compare and Data Compare for synchronization of environments. • Automated Powershell scripts for zipping and emailing reports.

New York, New York, Us

Lead architect/developer for maintaining a corporate intranet website for sales analytics with data from Google, Amazon, Kobo, Apple, B&N, and HarperCollins. • Website was written in ASP.NET C# 4.0. • Aided in the Tableau reporting for multiple KPI indicators. • Multiple MS SQL Server 2008 R2 optimization efforts to ensure website performance and positive user experience.

New York, New York, Us

Lead architect/developer for a point of sale (POS) Ebook pricing analysis application. The application would scrape various websites to determine eBook pricing and eBook meta data analysis. Captured over 2.1 million web pages per day.• Application developed in VS 2010 ASP.Net C# 4.0 JavaScript/JQuery/LINQ/LINQ to SQL with Fusion Charts. • Source code version control was maintained via Team Foundation Services. • Created a C# 4.0 console application to automate the download and saving of POS information from the Amazon.com Vendor Central portal. • Web automation was performed with the WatiN open-source framework. • Produced a C# 4.0 console application to verify and collect pricing information from various retailers using a combination of web API service calls (Amazon XML, Google JSON/JSON.Net) and web automation/web page parsing. Application was redesigned to perform multithreaded using the open source Smart Thread Pool library. • All data was saved in SQL Server 2008 R2. Responsible for all tables/views/stored procedure/user defined function creation and performance tuning. Worked with junior developers to show them how the code, configuration and the deployment should work.Assisted in a SQL Server 2005 data conversion effort targeting 15 years of sales/customer data over to JDE formatted data. Responsible for gathering conversion rules as well as performance tuning and QA testing.

New York, New York, Us

Lead database architect/senior .Net developer for a Marketing Reach Web Reporting enhancement project. Reports included the creation of a promotion report that had the ability to be downloaded to Excel. Evaluated multiple 3rd party HTML to PDF generators that would be able to handle the rendering of Flash Fusion Charts to downloadable PDF files. Reporting data included: shipment information, social currency, total impressions, point of sale information as well as user entered data describing book Print and Distribution, Marketing, Sell Through, and custom efforts leading up to and including the four weeks after a book went on sale. • Integrated an open source project called NPOI to create Excel files to download. • Source code developed in VS 2010 ASP.NET C# 3.5 framework • Source control maintained by Team Foundation Services (TFS) and backend in SQL Server 2005. • Incorporated easyPDF SDK 6.3 from BCL Technologies to download flash Fusion Charts to pdf format.• Responsible for all tables/views/stored procedure/user defined function creation as well as data/business object layer creation and 3rd party software integration. • Reduced the amount of systems the users needed to go to from 4 to 1 and the amount of time to generate the report from 8 hours down to 30 minutes. • Incorporated a free JavaScript HTML editor called Tiny MCE.

New York, New York, Us

Lead database architect/.Net developer for an ECRM Project tracking customer behavior on various HarperCollins public facing websites. • Google Analytics data gathered via a .Net 3.5 C# console application and stored in SQL Server 2008 database. • Created C# console application to download all user profile information from Janrain Capture and store in SQL Server 2008. • Console application used LINQ to SQL to facilitate object relational mapping of registration data.

North Brunswick, Nj, Us

Database Development, ASP.Net C# Web development, windows development, console application development, QA test automation, HTML, JavaScript, CSS

Lead developer for a corporate marketing portal housed within a Sharepoint MOSS 2007 environment. User security information was housed within the Sharepoint environment and passed to the ASP.NET web application. The application captured budget information. The application aided the marketing project managers ability to track objectives, budgeted amounts, allocated resources, burn rate and remaining dollar amounts while enforcing close coordination with the clients during project estimation, staffing, execution and finally completion. This application created a central marketing repository that replaced Excel files that were used to track dollar amounts.• The application called reports developed in SSRS and used Telerik AJAX controls with a SQL Server 2008 backend.• Responsible for table design, stored procedure creation, triggers, schema creation, front end layout, C# class design for the underlying framework as well as web page integration. • Developed jQuery logic for dynamic client side calculations.

New York, New York, Us

Lead developer for a Marketing Reach intranet application. The application identified ROI of different marketing strategies associated with book publishing. The data included web traffic information, retailer level sales broken down by: digital versus print media, publicity events, author appearances, book reviews as well as marketing spend (budget vs. actual). Assisted in the migration from Coremetrics to Google Analytics which saved the company approximately $100,000 annually. • Development was done with ASP.NET C#/ AJAX /JavaScript in Visual Studio 2008 with VSS 2005 as the code management tool. • Data was housed in several MS SQL Server 2005 databases. • Animated Flash graphics included the integration of a 3rd party plug-in called Fusion Charts by InfoSoft Global. Charts were hydrated via XML formed from middle tier. • Responsible, view, table, stored procedure creation/optimization as well as pulling disparate backend data together for the rest of the team.• Created a C# console application to call the Google Analytics web services. The console application used a custom Google Analytics Reader library for .Net along with dimensions, metrics, and configuration parameters stored in the database.

Bachelor’S Degree, Bachelor Of Science Computer Science

High School Diploma, Ap General Studies