Dhanraj Mahendra Email & Phone Number

Scottsdale, Arizona, United States

Scottsdale, Arizona

Developed and Maintained enterprise level database objects and ETL processes using SQL Server 2014 and below for the nation’s 5th largest public home builder.Designed, optimized, and created SQL databases, tables, indexes, views, user defined functions and stored procedures.Upgraded between all SQL versions between 2000 and 2014Maintained over 60 instances of SQL Servers supporting different applicationsDesigned and Implemented SharePoint 2013 on premises and online with SQL 2014 on an AlwaysOn High Availability platform with server’s host in Microsoft Azure public cloud Prepared disaster recovery procedures and participated in High Availability designCreated automated nightly processes to export, encrypt and ftp data to large national banksPerformed system backups, recoveries and data archivesPerformed regular application and database performance tuning as well as assured data integrity and interoperability across all platformsMigrated application code and data from development environments to test and production environmentsApplied Vendor Supplied Software upgrades for the Loan Origination software - Empower Client Server ApplicationDesigned and Developed Automated Business processes for process improvements.Developed and maintained interfaces between Empower Client Server LOS system and the following 3rd party systems: Compliance Ease, Bank of America, Core Logic Appraisal System, Desktop Underwriter, Loan Prospector, Informative Research.Developed applications in Progress 4 GL.Created a data conversion program to migrate the data between two major Loan Origination Systems using Progress Data SQL Server.Migrated 100,000 loans from Progress 91c database to SQL 2000.Migrated all Credit Reports, Flood Certifications Loan Prospector and CLOUT Data.Created interfaces to move data between the Loan Origination System (Unifi – Fiserv), (Empower – Fnis) and the Accounting System (JDEWorld).Maintained Application written in C# which consumed Web Services

• Designed and developed programs as add-on modules in the Distribution, Financial and Manufacturing areas of MFG/PRO.• Customized MFG/PRO extensively.• Wrote data interface programs between MFG/PRO and other packages. • Interacted with customers and analyzed their requirements providing structured solutions.• Served as a Project Leader on 6 major projects with clients such as Black & Decker, Schlumberger, Philips and HADCO.

Westlake Village , Ca

• Leading member of the SunMed Service MFG/PRO ERP Implementation Team.• Successfully managed customer and multi-divisional EDI implementations.• Managed MFG/PRO Order Service, Multi-site Distribution Planning, Shipping and Financial Control reporting systems. • Developed Corporate Sales, Shipping and Receipts Performance Reporting systems.

Carpinteria, Ca

• Developed INTRASTAT Module for Version 7.4 and 8.5 of MFG/PRO. Intrastat refers to the system used by custom authorities for collecting trade statistics on movement of tangible goods between European Union(EU) countries.• Key member of the Standard Product Support Team responsible for the Distribution, Financial and Manufacturing Application Modules.

Long Beach , Ca

• Designed, developed and installed a Customer Mail Order System and Carpet Manufacturing System. Worked on over 10 customer installations for Royal 4 systems. • Supported the installation and custom modifications of standard Accounting, Distribution, and Manufacturing application modules. • Involved in data conversion, user training and documentation.

Bachelor'S Degree, Computer Science

Bachelor Of Science, Physics