Hector Prada Email & Phone Number

Glen Head, New York

• Developed a Tabular SSAS data warehouse that provides sales and inventory business Intelligence analytics.
• Designed and developed a cloud based reporting environment based on Microsoft’s Power BI which is based on the tabular SSAS data warehouse
• Designed and developed ETL processes using SSIS packages to massage and transform OLTP to OLAP data for the data warehouse.
• Implemented row based security on tabular SSAS database using Active Directory Groups.
• Developed MVC web app to maintain BI users based on the latest Active Directory changes.

Bayport, NY

• Developed a Business Intelligence site using SSRS and SSIS to gather and display Sales and Inventory data that allowed management to gauge sales performance and adjust marketing efforts.
• Also brought on board to upgrade e-commerce website to enhance focus on the B2C customer. Utilized ASP.Net (MVC) and SQL Server 2012.
• Gathered requirements from corporate upper management to ensure that solutions aligned with business needs of end users. Reported to CIO.

Holbrook, NY

• Designed and implemented BI solutions for the largest international health/wellness and nutritional supplements company in the world, utilizing SSRS, SSAS and SSIS. Deployed solutions to a SharePoint Performance Point.
• Fully integrated from Lotus Notes environment customer complaint reports with complete analytics.
• Creation of reports for manufacturing line analytics to include packaging and fulfillment efficiencies.
• Cost Accounting data integration supporting monthly and annual reports as well as yearly IRS Audit database
• Developed a Silverlight/.Net 4.0 application which allowed line workers to scan work orders and configure required bottle labels.

DEER PARK, NY

• Enhanced and maintained a B2B fleet service database and reporting system including vehicle Tracking application tied to GPS.
• Using SSRS, created reporting system for prompt customer tracking of fleet status.

., Holbrook, NY

• Designed and executed the corporate e-commerce engine, ensuring full functionality and reliability for the website serving 10,900 member company and generating $197 million revenue.
• Provided web based staff-access to company information aligned with individual clearance levels.
• Assisted with mapping and improving work flow for server and system deployment.
• Responsibilities include database design, code writing in.NET and C#, specification documentation, and flow charting.
• Increased functionality by creating SQL databases and applications to support synchronization of file uploads and image management.
• Created website interfaces allowing divisional leaders to update content and assisted database management by synchronizing data, analyzing data structures and creating a quality assurance environment.