Dan Rosenthal Email & Phone Number

Costa Mesa, Ca

• Manage Databases, Data Warehouse, and COGNOS integration• Work with Executive, Marketing, Finance, and Operations Teams to develop reports used for global company planning and decision making.• SQL Server, Jasper Reports, C#.

Seal Beach

Amonix is the leading designer and manufacturer of concentrated photovoltaic (CPV) commercial solar power systems.• Reports development (SSRS)• Stored procedures• Complex SQL queries• C#/.Net development

Aliso Viejo, Ca

• Assigned to Pacific Life project. • Supported migration of mainframe data to upgraded SQL Server system.• Investigated and solved data inconsistencies due to previously undocumented mainframe rules.

Aliso Viejo, Ca

• Employed by Avanade.• Assigned to Pacific Life project. • Supported migration of mainframe data to upgraded SQL Server system.• Investigated and solved data inconsistencies due to previously undocumented mainframe rules.

• Developed solutions and new functionality for various high-profile projects with varying technologies including ColdFusion, API/XML/Soap web services, and SSIS/SQL Server. • Integrated 3rd party distributor products into flagship ecommerce website. Functionality included loading inventory, price and availability checks, order processing, and order tracking.• Updated and maintained PayPal and eBay web service APIs for one of eBay largest customers.• Redesigned flagship SQL Server website database and front end to not only be flexible for future growth, but to solve the issues that had arisen in the previous model due to rapid company expansion.

• Employed by Tek Systems • Worked with marketing, accounting, and operations executives to develop reports used for global company planning and decision making. • Optimized stored procedures that previously ran 10+ minutes to run in < 10 secs.• Used Jasper Reports, C#, and SQL Server stored procedures.• Position was unexpectedly eliminated due to budgetary constraints. Received praise from superiors and VP of department on performance.

• Managed data warehouse of several million records for profitable digital advertising and entertainment company.• Designed, created and maintained multiple complex reports for top-level management using Microsoft SQL Server Reporting Services.• Optimized heavily used SQL stored procedures for Atrinsic’s branded websites.• Streamlined daily reconcile processes to synchronize billing and subscription data.• Wrote and modified Asp.NET projects as needed.

• Managed data warehouse of several million records for profitable digital advertising and entertainment company.• Designed, created and maintained multiple complex reports for top-level management using Microsoft SQL Server Reporting Services. • Optimized heavily used SQL stored procedures for Atrinsic’s branded websites.• Streamlined daily reconcile processes to synchronize billing and subscription data.• Wrote and modified Asp.NET projects as needed.

• Maintained internal recruiting and tracking website for one of the largest job placement companies in the U.S. • Created new functionality for proprietary system which was built primarily with ColdFusion, JavaScript, and SQL Server.

• Maintained one of the largest automobile information and lead generation websites.• Optimized both SQL Server procedures and ColdFusion code. • Ensured SOX Compliance which included project analysis and clearly documented technical specifications.

• Created and maintained e-commerce and content sites for one of the top internet companies in the world using ColdFusion, SQL Server, flash, and JavaScript.• Created custom content management system (CMS) which allowed designers to upload files into one centralized system for publishing to one or more websites.• Measurably increased website speed by implementing changes to our CMS publishing system. • Created a fully customizable automated email system – complete with back-end reporting – which was used to secure new business.

• Created one of the largest online computer component exchange boards with over 1 billion parts listed.• Designed and implemented “Connections Online” software, a completely customized, full-featured contact management system.