Senior Dashboard/Power Bi/Dax/ETL/SQL Specialist

Emad Hammoud

email: ****@*******.*** phone: 703-***-****

***** ***** **** ***** ***********, VA 20121 USA

SUMMARY

EXPERIENCE: Senior Dashboard BI/ETL/SQL Specialist with extensive experience as a developer. Proven ability to quickly learn and implement Business Intelligence processes and technologies. An innovative, motivated, creative, structured analyst who develops improvement procedures. Performs well in teams as well as independently. Communicates effectively with both technical and non-technical teams. Skilled database professional experienced in packaging Extract, Transform, and Load for authoritative data sources. Produces informative reports that provide actionable insight into on-demand interactive dashboards.

CLEARANCE U.S. Government DoD Secret Clearance (current) EDUCATION B.S., The American University, 1981

Technology of Management, Computer Systems Applications CERTIFICATION CompTia Security+ (current)

SKILLS

Databases:

Microsoft SQL Server, Oracle, TeraData, SAS, MySql, NoSql, CouchBase, Spark Operating Systems:

Windows Server, Linux, Ubuntu

Languages:

T-SQL, ASP.NET, C Sharp, VB.NET, VbScript, JavaScript, HTML, CSS, PHP, COBOL, FoxPro, Drupal, PowerShell, Splunk, Python, R-script Tools:

PowerBI, SQL Server Data Tools 2014 for BI, ETL, SSRS, SSIS, SSAS. MDX, DAX, SSMS, OBIEE, MS Visual Studio, MS Office Professional suite, SpotFire, BMC Remedy ITSM, SharePoint, PerformancePoint, InfoPath

Technologies:

Cloud Computing, Virtualization, Business Intelligence, ETL, Big Data, MultiDimensional Cubes, Tabular Cubes, Active Directory, IIS, MS Exchange, .NET, Web Services, VMWare, Hyper-V, Azure

AWARDS President's Award for Technical Excellence, 2006 Recognitions of performance, 2001 – 2010 LANGUAGES English, Arabic

PROFILES LinkedIN Public profile: https://www.linkedin.com/in/emadhammoud LinkedIN ProFinder profile: https://www.linkedin.com/pro/emadhammoud Freelancer profile: http://RaminData.com

Emad Hammoud

email: ****@*******.*** phone: 703-***-****

14354 Maple Rock Court Centreville, VA 20121 USA

HISTORY:

RAMIN Data Group:

Senior Dashboard BI/ETL/SQL Specialist, May 2015 – Present (Multiple contracts) Successfully built dashboards & visualizations that assist stakeholders and teams to clearly understand priorities and project delivery milestones. I specialize in Actionable Dashboards, Metrics, KPIs, Business Intelligence, Power BI, Power Query, M, SQL, DAX, MDX, Oracle, Cobol, Teradata, MySQL, ETL, SSAS, SSIS, SSDT, SSMS, SSRS, R, PowerShell, and data-driven automation.

Other tasks:

• Automated Host Machines for creation of individual custom Virtual Machines.

• Built Physical and Virtual Machines on networks. Used for Proof-Of-Concepts, diagnostics, repairs, and XP replacements. Drupal, PHP, MySql environments.

• Automated enterprise inventory for Windows resources, systems, KB patches, and updates.

• Ported an operating production datacenter to Azure including DNS, Sql data, and Apps.

• Built VmWare Hosts for POC networks with ESXI 5.1. Built and developed internetfacing production networks.

• For comparison and smaller footprint, developed a fully working POC domain environment as an embedded Host with 6 VMs on a USB-3 stick. Included Domain Controller, Active Directory, Sql, Web, eMail, Sharepoint.

• Designed, built, configured, and secured Sharepoint Portal systems for the internet, intranet, and the extranet.

• Scripted Powershell to provision Virtual Machines in VmWare, Azure, and Hyper-V. Automated enterprise-wide resource queries for efficient system design usage. Created many administrative tools for domains & consistency.

• Created and applied a VMDK file for VmWare Virtual Machines.

• Created and applied a VHD file for Hyper-V and/or Azure Virtual Machines.

• Ported production Virtual Machines.

• Ported Virtual Machines for FedRamp compliance.

Emad Hammoud

email: ****@*******.*** phone: 703-***-****

14354 Maple Rock Court Centreville, VA 20121 USA

DARPA: Supporting Defense Advanced Research Projects Agency (DARPA) Senior Developer, Apr 1998 – Apr 2015 (17 years. Multiple contracts) Enterprise ETL architecture. Revolved around fulfilling complex SLA metrics and BMC Remedy components, AD, and many logs. As it grew more and more tools (some mentioned here) were involved. Today it is still in use & running like clockwork every 20 minutes.

• Tasked to configure & develop prototype OBIEE Dashboards/KPI/Reports for rendering financial, awards, performance data.

• Ported the prototype tables and data to new Oracle Database. Automated the daily data refresh.

• Developed Future Funding tables and views.

• Migrated & adopted dashboards, KPI, reports for groups led by stakeholders.

• Participated & attended the private Oracle BI training for members only.

• Augmented DB info into cubes.

• Built & added the Expenditures cube perspective.

• Composed views to reconciled with BI WriteBack scripts. Other tasks including:

• Wrote web services solving complex SLA, SLO, and Metrics calculations for BMC Remedy ITSM, Help-Desk Incidents, and CMDB Assets on Dashboards with drilldown capabilities.

• Coded Single-Sign-On to be used for BMC Remedy authentication within Active Directory.

• Integrated and customized each BMC Remedy upgrade and wrote training guides.

• Installed, configured, and deployed Apache and Tomcat on Windows Servers for the BMC Remedy Web Mid Tier system.

• Developed ETL automation as custom integrated data with cubes and BI reports. ETL is now the de-facto reporting source with an update frequency of 20 minutes or less on a 24x7 schedule. Most mobile phones/tablets also have successful deployments.

• Developed stringent processes for cross-reference info from authoritative datasources.

• Built, configured, maintained MS SQL Servers with SSMS, SSIS, SSAS, SSRS to be used for ETL automation, SharePoint, BMC Remedy installation.

• Developed SSIS ETL automation packages to collect data from multiple datasources. Including data from BMC Remedy, Web Services, Active Directory, SCCM, SCOM, CACTI and other non-Windows monitoring systems.

• Developed SSAS cubes and data models for BI, KPI, data warehouse and trending.

• Developed custom reports using SSDT, SSRS and Report Builder and Business Intelligence Development Studio and Visual Studio. Also applied the reports as custom Dashboards with drill-downs within SharePoint integrated sites.

• Custom JSP pages for the BMC Remedy Web Mid-Tier system.

• Monitored logs and transaction records for customer satisfaction surveys using SharePoint InfoPath automated deployments.

• Held brown-bag lunches for less formal brainstorming discussions of difficult or new concepts.

Emad Hammoud

email: ****@*******.*** phone: 703-***-****

14354 Maple Rock Court Centreville, VA 20121 USA

• Provided guidance, mentoring, and training to interested staff.

• Communicates with users and cross-team members to translate technical matters into understandable terms.

• Performed Tier-3 assistance and developed interactive FAQ lists for apps.

• Developed proactive mechanisms to highlight potential process problems. Added to a solutions library.

• Install, configure, and administer IIS servers. Develop, design, implement, and maintain Enterprise web and mobile applications in Asp.Net.

• Provides technical and operational support for agency projects.

• Develop solutions using technologies like SQL, SharePoint, ASP.NET, VB.NET, Visual Basic, C#, HTML, XML, HTML5, JQuery, JavaScript, PowerShell, Active Directory, SSDT, SSAS, SSIS, SSRS, BI, and ETL.

• Assists in the development and enforcement of best practices, processes, standards, and policies.

• On-call to provide technical support after regular work hours and weekends.

• Technical lead on agency enterprise projects including ETL with BMC Remedy 7.6, SharePoint 2013, SQL 2014, and SSDT.

Emad Hammoud

email: ****@*******.*** phone: 703-***-****

14354 Maple Rock Court Centreville, VA 20121 USA

ADDITIONAL INFO:

Senior Developer/Data Architect specializing in Business Intelligence, SQL Server 2014, SSDT, SSAS, SSRS, SSIS, MDX,

DAX Microsoft reporting services. Provides support on projects including designing and building Business Intelligence Solutions. Converts customer requests into technical details and solutions ensuring customer objectives are achieved. Broad range of skills and the ability to step in to different roles depending on the size and scope of the project. Experience developing successful Business Intelligence solutions using the Microsoft BI stack.

• 10+ years of experience delivering solutions utilizing the entire Microsoft BI stack (SSAS, SSIS, SSRS)

• 20+ years of Microsoft SQL Server database development (TSQL) experience.

• Built Business Intelligence solutions in a collaborative, agile development environment.

• Demonstrated ability to use discretion and make sound decisions.

• Ability to excel in a collaborative and distributed team environment.

• Ability to work with a minimal amount of direction while being pro active in keeping their management informed of project related issues.

• Ability to work under pressure.

• Ability to respectfully question ideas and share a point of view with others in support of the business requirements and needs.

• Ability to effectively communicate with various levels of employees ranging from entry level to senior leadership.

• Ability to manage multiple projects at the same time and shift priorities quickly.

• Proven strong problem solving skills, troubleshooting, and root cause analysis..

• Proven strong relationship building and communication skills with team members and business users.

• Ability to maintain confidentiality.

• Experience in the financial services industry.

• Possess strong business acumen and consistently demonstrates forward thinking.

• Is able to effectively work with ambiguous or incomplete information.

• Able to routinely work with little or no supervision.

• SSDT, MDX, DAX experience.

• 10+ years of experience working in a data warehouse environment and a strong understanding of dimensional data modeling concepts

• Working knowledge of SharePoint 2013 and PerformancePoint.

• Strong aspiration to learn new technologies.

Contact this candidate