PRIMARY SKILLS:

SQL Development | ETL (SSIS/C#.NET) | Project Management

PROFESSIONAL EXPERIENCE:

ETL Developer

Confidential, Boca Raton, Florida

Skills Used: T - SQL | Microsoft Office Excel | SQL Server Integration Services (SSIS) | ASP.Net (C#)

Responsibilities:

• Built numerous SSIS packages to transform and move data.
• Used CozyRoc SSIS library.
• Manages ordering process for 501B drugs.
• Worked with teammate to create new data import/export strategies for future Web based Customer System.
• Mentored less-senior colleagues.

ETL Developer

Confidential, Boca Raton, Florida

Skills Used: T-SQL | Microsoft Office Excel | SQL Server Integration Services (SSIS) | ASP.Net (C#)

Responsibilities:

• Rewrote T-SQL existing queries to speed up web searches.
• Built SSIS packages to transform and move data.
• Retrieved data and created Excel pivot tables for specialized report requests.
• Built customized Excel spreadsheets for data capture.
• Built Asp.Net application to add additional data to Confidential.

BI Developer

Confidential

Skills Used: T-SQL | Microsoft Office Excel | MS Azure Databases | ASP.Net (C#)

Responsibilities:

• Analyzed Excel Pivot tables derived from PhD's accumulation and analysis of hospital employee questionnaires.
• Wrote scripts to unpivot the data, validate the data and move it into Azure database tables.
• Redesigned existing table structures for new applications.

SQL Developer

Confidential, Fort Lauderdale, Florida

Skills Used: C#.NET / ASP.NET / VB.NET | SQL Server Development (T-SQL) | Web Services / XML | MySQL Server Development | MySql Workbench | PhpMyAdmin | SQLYog MySql Client | Wordpress Design/Development | Microsoft Project | Microsoft Visio | Microsoft Excel (Advanced) | Project management

Responsibilities:

• Custom development, MySQL development/management, Business Intelligence (BI - MS Stack), Custom CRM development (VB.Net), DNC List Scrubbing (MS SQL Server), List Deduping, Lead Generation funnel development, WordPress Website Development, Local Search Engine Optimization (SEO), Data Mart Development (MS Sql Server/MySql), Content Management Development (VB.NET), Asset Management Development (C#). Project management.
• Converting drop shipping system from Visual FoxPro to C#.NET. Recreated VFP workflow and created enhancements.
• Wrote custom secure FTP to connect with CommerceHub to download text based orders, pdf packing slips.
• Pulled data from pdfs to match orders with pdfs, and merged with pick ticket data from database to print into the pdfs to create a combined pick ticket & packing slip. Saving 2 hours per day processing time for orders.

Data Scientist

Confidential, Pompano Beach, Florida

Skills Used: C#.NET / ASP.NET / VB.NET | Web Services / XML | SQL Server Development (T-SQL) | Microsoft Excel (Advanced)

Responsibilities:

• Business Intelligence. Analytics. Data Marts. Using MS Sql 2014, MySql 5.5, C#.
• Integrating fitment and attribute data to enhance parts categorization & search on Confidential websites.
• Using ACES & PIES data from SEMA.
• Also built add-on tools (desktop applications) to work with Multi Order Manager (MOM) API to enhance warehouse operations for receiving, put away, picking & shipping.

Senior Software Engineer

Confidential, Pompano Beach, Florida

Skills Used: ASP.NET / VB.NET / C#.NET | Web Services / XML | SQL Server Development (T-SQL) | SQL Server Administration | Microsoft Project | Microsoft Visio | Microsoft Excel (Advanced) | Developer Express Components

Responsibilities:

• Built Intranet, Extranet & Desktop software solutions to accelerate the business including a high visibility, configuration-based ordering system for Roller Shades to pass XML based orders to the vendor.
• Using Microsoft stack technologies, Visual Studio 2012/2013, C#, XML, XAML, WPF, SQL Server 2008-2012 and Developer Express components to meet business needs.

DBA/Developer

Confidential, Fort Lauderdale, Florida

Skills Used: SQL Server Development (T-SQL) | Oracle Desktop (PL/SQL) | SQL Server Integration Services (SSIS) | SQL Server Reporting Services (SSRS) | SQL Server Administration | SAP Business Objects | Microsoft Project | Microsoft Visio | Microsoft Excel (Advanced) | ASP.NET / VB.NET / C#.NET | Web Services / XML | Visual FoxPro | Crystal Reports | Project management

Responsibilities:

• Senior DBA/.NET Application Developer in Business Intelligence Group.
• Administrator for multiple SQL Servers in Florida and New York.
• Managed security.
• Modeled and populated Datamarts for manufacturing, wholesale and retail reporting.
• Sourced data from Confidential Footworks (using Relativity), Flexi International Accounting and RetailPro (Oracle based) Point of Sale systems.
• Developed and maintained ETL processes, backup processes, database standards.
• Analyzed data using Microsoft Excel pivot tables.
• Worked with large databases (600+, 800+ tables in RetailPro, Flexi).
• Greatly increased load speed of existing ETL processes, some by as much as 800% and more.
• Developed database related policies and procedures.
• Worked with SAP Business Objects and SSRS for reporting.
• Mentor to all other Business Intelligence personnel.
• Built Asp.Net web applications for the corporate Intranet.
• Converted older FoxPro programs to .NET.
• Planned and successfully executed multiple upgrade projects for Flexi International accounting system for over 40 users.
• Created project plans, software test plans, test servers with upgraded database & test workstations.
• Conducted meetings to ensure execution.

Software Architect

Confidential, Delray Beach, Florida

Skills Used: Software Architecture | SQL Server Development (T-SQL) | Web Services / XML | Message Broker | Microsoft OPOS | eCommerce | ASP.NET / VB.NET / C#.NET | Active Reports (Component One) | Microsoft Visio

Responsibilities:

• Mentor to junior developer and junior DBA. Built a VB.NET component interface to Confidential Systems to pass XML formatted requests and receive XML formatted responses.
• Built a VB.NET file watcher to parse downloaded FTP files into a SQL Server database.
• Built ASP.NET (VB) web services to provide summary reporting information from remote eCommerce Web Sites.
• Built an OPOS printing module using the Microsoft library POS for .NET 1.1.
• Built series of standard reports using Active Reports for .NET 2.0/3.0. Some reports consumed web services.
• Redesigned Restaurant Table Service Point-Of-Sale system (POS) and Restaurant Quick Service Point-Of-Sale system (POS) to use a common set of modules.
• Added common payment interfaces, OPOS interfaces & standard reports.
• Company is now effectively out of business due to management issues and partner breakup.