Hamza is currently unavailable
Hamza Josh
Verified Expert in Engineering
Data Architect and Developer
South Barrington, IL, United States
Toptal member since July 20, 2020
Bio
Hamza is a skilled data architect with 25+ years of experience in MS SQL server and database development, SSIS, SSRS, BI, and Microsoft Dynamics (Solomon, GP, and CRM). Hamza is an asset to any project due to his deep technical knowledge of data architecture and significant experience in eCommerce, logistics, and consulting industries. Hamza's specific areas of expertise include ERP, CRM, SSAS, PBI, .NET, Dexterity, and marketing automation platforms.
Portfolio
Alif International, Inc.
Batch, Web Map Services (WMS), Customer Relationship Management (CRM)...
Restaurant.com
SSAS, SQL Server Reporting Services (SSRS)...
Business Productivity Solutions
Analysis, VB.NET, Visual Basic for Applications (VBA), Crystal Reports, SSAS...
Experience
- Microsoft SQL Server - 20 years
- Great Plains Accounting Software - 19 years
- Software Engineering - 19 years
- SQL Server Integration Services (SSIS) - 15 years
- SQL Server Reporting Services (SSRS) - 15 years
- Visual Basic for Applications (VBA) - 15 years
- Scribe Server - 10 years
- Microsoft Power BI - 5 years
Work Experience
Principal Consultant
2015 - 2020
Alif International, Inc.
- Created a metadata-driven SSIS framework to manage integrations between GP, WMS, batch, and commodity applications.
- Involved in all phases of the PBI project from data modeling, ETL, Tabular model design, and PBI reports and development.
- Consolidated data from five manufacturing plants into one parent company and creating the structures to manage data independently in each company but reflect changes in the parent company.
- Managed and maintained the code, tables, data integrations, and the overall health of the application for a custom in-house application called Pricing Program in Dexterity.
Technologies: Batch, Web Map Services (WMS), Customer Relationship Management (CRM), Microsoft Power BI, SSAS, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server, Microsoft Dynamics GP
Senior BI Developer
2011 - 2015
Restaurant.com
- Developed ETL processes to migrate data from legacy OLTP databases to newly architected databases in support of a site-wide re-architecture effort. Designed and built data synchronization processes to sync data across OLTP stores in near-real time.
- Developed an enterprise-level data warehouse that integrated data from over ten different sources (including REST API, Flat File, database, and Salesforce)—enabling 90% of all data requests to be served without intervention from IT.
- Led the integration of a new marketing automation platform that leveraged customer data to enable targeted email campaigns and significantly increase customer engagement.
- Designed and built an ETL framework to allow scalable execution of ETL tasks, combined with automatic error recovery and extensive logging.
Technologies: SSAS, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server
IT Technical Consultant
2008 - 2011
Business Productivity Solutions
- Created a VB.NET module for inserting GL entries directly into Solomon tables to eliminate manual entry for Walgreens as well as AIT Worldwide.
- Completed SQL reporting services projects for Option Care/Walgreen’s, Latino Institute, and so on which included the recreation of Crystal Reports in SSRS, data-driven subscriptions, and parameterized reports.
- Developed ASP.NET pages for end-users for the maintenance of SQL tables for integration purposes.
- Created ASP.NET pages that use VB.NET in the back end and allow users to maintain data in a table based on the business rules of clients.
- Created a Forecaster-to-GP integration to bring Forecaster data into GP tables for reporting purposes and comparisons.
Technologies: Analysis, VB.NET, Visual Basic for Applications (VBA), Crystal Reports, SSAS, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server
Project History
Solomon GL Import
I created a custom-designed application that integrates GL entries from Excel files to Solomon ERP. The Excel files come from 100+ remote locations. The application checks the files for business rules. If all the rules are followed, it processes the file and brings JE to Solomon otherwise it returns the file to the user via email with the errors indicated and asking them to correct the errors and re-upload the file.
The application processed ten different templates for different types of GL entries including adding reversing GL entries.
The project ended with 8,000+ lines of code.
The application processed ten different templates for different types of GL entries including adding reversing GL entries.
The project ended with 8,000+ lines of code.
Education
1987 - 1992
Bachelor's Degree in Computer Engineering
Bharati Vidhyapeeth College of Engineering - Pune, India
Certifications
JUNE 2011 - PRESENT
Basic Certification for AX+ Development
Microsoft
JUNE 2008 - PRESENT
3GP 10.0 Integration Manager Certification
Microsoft
JUNE 2008 - PRESENT
GP 10.0 Installation and Configuration Certification
Microsoft
JUNE 2002 - PRESENT
Oracle 9i OCP
Oracle
Skills
Tools
Great Plains Accounting Software, Microsoft Power BI, Scribe Server, Microsoft Dynamics GP, SSAS, Crystal Reports
Languages
Visual Basic for Applications (VBA), VB.NET, C#.NET, SQL, Batch
Storage
SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft SQL Server, Oracle9i
Frameworks
.NET
Platforms
Windows
Other
Software Engineering, Networking, Customer Relationship Management (CRM), Web Map Services (WMS), Analysis
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring