Hani Sultan

o Provides strategic leadership and hands on expertise in the design, implementation and maintenance of company business systems and resources.
o Collaborates with the key users of the enterprise software system and other operational software and oversees technical management of all software systems.
o Provides leadership of the company's technology and business systems projects to enable effective and efficient execution of business projects.
o Coding, testing, debugging, documenting, implementing and maintaining software applications
o Documents system use cases for functional and non-functional requirements of the applications
o Implements new work flow processes and improves existing processes to meet new business requirements.
o Designs and develops advanced database solutions including logical and physical structure, stored procedures, functions, and other database objects.
o Develops data warehouse process models, including sourcing, loading, transformation and extraction.
o Maps data between resource systems, data warehouses and data marts.
o Analyzes designs and maps data exchange components.
o Provides or coordinates troubleshooting support for data warehouses.
o Develops reports using Data Warehouse and Business Intelligence tools.
o Responsible for delivery of business systems and software related training that supports departmental and organizational technology initiatives and contributes to employees' professional development
o Performs network administrator functions and provides technical support to over 100 employees in multiple locations

o Elicited user’s requests and evaluated business needs to determine, design, and implement a suitable software solution such as database systems, web application, and reports.
o Developed a database application to track company archived documents stored off site. Responsible for eliciting end user requirements, designing and implementing the solution, and performing QA and testing. Also responsible for data migration from the old system to the new database system. The application was developed with MS SQL Server 2008 for the back-end, VB Script/Java Script for the GUI, and is expected to save 80% on labor.
o Migrated employee training records from a third party module (ESS) to the company main application (Spectrum.) Responsible for configuring the training module in Spectrum, extracting and reformatting the ESS data records, then loading them into Spectrum database (MS SQL 2008)
o Upgraded Access 97 database application to Access 2010 and migrated the database tables to MS SQL 2008 server.
o Supported and maintained several Access database structures and front end applications (Queries, Reports and VBA.)
o Developed numerous simple-to-complex stored procedures, functions, and triggers to handle new business requirements and end-users database related requests.
o Tuned and optimized queries by altering database design, analyzed different query options and indexing strategies.
o Developed custom T-SQL stored procedures to perform ETL operations.
o Developed, modified and maintained company moderate and complex reports using SSRS and Crystal Reports.
o Administered and maintained company databases including backup and restore, performance issues, indexing, database integrity, and general maintenance tasks.

o Worked with and maintained the organization’s databases (several databases with few hundred tables and millions of record across multiple platforms including MS SQL 2000, MS SQL 2008, and Access DB.
o Contributed in process development and identified requirements for process enhancement/automation and provide solutions on database architectural and design issues.
o Created, modified, and optimized stored procedures, queries, views, tables, and other database objects to meet new and existing business needs and/or improve code performance and response time.
o Set up and configured company Microsoft Reporting Server to centralize all reports.
o Created reports in SSRS used for sales, marketing, and financial decision making projects.
o Performed standard DBA tasks using SQL 2000/2008 maintenance and performance tools.

o Led the database evaluation and analysis effort to identify problematic areas and implement improvements to accommodate the evolving business priorities and technological changes. The database was developed using MS SQL Server 2008.
o Mapped out the conceptual design for a planned database in outline and refine the logical design so that it can be translated into a specific data model,
o Gathered user’s requirements to extract database requirements, translate them into technical requirements, design practical data model for a scalable database structure, and assisted with the design of the GUI.
o Implemented stored procedures, triggers, views, scheduled job to manage data access across multiple databases
o Planed data migration strategy to insure data consistency and integrity between the current and the new database.
o Wrote database documentation, including data standards, procedures and definitions for the data dictionary
o Assisted with defining application and database testing, QA, source control, and change control strategies.

o Formulated and deployed long-term strategic plans for acquiring and enabling efficient and cost-effective information processing and communication technologies.
o Manage IT department operational and strategic planning, including business requirements, project planning, and organizing and negotiating the allocation of resources.
o Operational Management
o Where necessary, re-engineered applications support to ensure it aligns with business processes, tactical planning, and strategic vision.
o Defined and communicated project milestones, service level agreements, and resource allocation to executive team, department leads, support staff, and end users.
o Developed and reviewed budgets for and from IT department divisions and ensure they comply with stated goals, guidelines, and objectives.
o Reviewed performance of IT systems to determine operating costs, productivity levels, and upgrade requirements.
o Benchmark, report on, and made recommendations for the improvement of the IT infrastructure and IT systems.
o Authorized and oversaw the deployment, monitoring, maintenance, development, and support of all hardware and software based on department needs.
o Developed business case justifications and cost/benefit analyses for IT spending and initiatives.
o Directed research on potential technology solutions and implementations in support of new initiatives, opportunities, and procurement efforts.
o Oversaw provision of end-user services, including help desk and technical support services.
o Developed and implement all IT policies and procedures, including those for architecture, security, disaster recovery, standards, purchasing, and service provision.
o Oversaw negotiation and administration of vendor, outsourcer, and consultant contracts and service agreements.
o Managed IT staffing, including recruitment, supervision, development, evaluation, and disciplinary actions.
o Established and maintained regular written and in-person communications with the organization’s executives, department heads, and end users regarding pertinent IT activities.
o Designed and implemented database application to automate warehouse operations. Responsibilities included database design, data modeling and analysis, physical implementation of the database, complex stored procedures, triggers, schedule maintenance jobs, and perform regular process analysis to improve overall database performance.
o Designed and developed several modules using in MS Access 2007 and VBA for Access. The modules were integrated with M.O.M to add efficiency, flexibilities, and saved the company 50% of its warehouse labor cost.
o Responsible for designing test cases and creating testing plans: black box, white box, and user acceptance testing.
o Implemented security procedures, database maintenance including backup and recovery plans, and server configuration including user permissions and roles, and data import and export for SQL server 2000.
o Designed and implemented the front end and the GUI of the order management systems. It was mostly done in Classic ASP, JavaScript, HTML, CSS, and windows services.
o Preformed data migration from old system to MOM. The migration procedures handled data cleansing, verification, and consistency to ensure its alignment with M.O.M standards.
o Installed, configured, and maintain small business server 2003 including DHCP, WINS, DNS, print, and file servers.
o Implemented and enforced company policies regarding network security, STMP issues, firewalls, backup/recovery, domain policy, disaster and recovery plans.