Huda Elhassan, Ms Email & Phone Number

Washington D.C. Metro Area

• Wrote SQL server stored procedures.• Applied information security and assurance policies, principles and practices for data management services.• Used Talend-Spark and Hadoop to manage, compile and process big data as the monthly Comprehensive Capital Analysis and Review (CCAR) with a 25+ TB size. • Loaded data into partitioned parquet-format Hive tables.• Developed SAS codes and SQL server stored procedures.• Manipulated and loaded the daily Federal Financial Institutions Examination Council data (FFIC) to transaction or transposed tables.• Integrated data stored in Hadoop with data from other sources using Talend and SAS access to Hive.• Captured data requirements, developed ETL jobs and scripts using Talend, SAS Data Integration Studio tools.• Extract and manipulate millions of records from XML, SAS, SQL and Text files.• Transformed and loaded data as SEC FormPF and FormADV into SQL Server databases and Hive databases.• Developed SAS codes to add a User Written Transformation to SAS DI Studio applications. • Added pre-code OPTIONS to manipulate and transfer data between platforms(Linux,windows) or overwrite input files statements.• Created documentation step by step on loading data.• Conducted training and presentations on SAS DI to superiors, co-workers and clients and provided recommendations.• Co-developed a procedures manual with a team.

Washington D.C. Metro Area

• Wrote SQL Server Stored Procedures.• Developed data conversion and migration routines using SQL server utilities in various environments.• Ensured application of information security and information assurance policies, principles and practices in the delivery of data management services.• Used Hadoop to manage, store and process large volumes of data. • Integrated data stored in Hadoop with data from other sources.• Used HADOOP/SAS procedure and options.• Captured data requirements, developed ETL Jobs and scripts using SAS Data Integration Studio tools.• Extracted and manipulated millions of records from XML, SAS, SQL and Text files.• Transformed and loaded data into SQL Server database.• Developed SAS codes to add a User Written Transformation. • Added pre-code OPTIONS to transfer data between platforms or to overwrite input files statements.

Washington D.C. Metro Area

SQL Server Database Administrator/SAS EBI Administrator, 2002 – 2013:• Performed all SQL Server upgrades, maintenance, backup, recovery, security, optimizations and troubleshooting.• Installed, configured and maintained SAS Enterprise Business Intelligence (SAS EBI) server.• Supported 200 economists and mortgage. • Established and maintained user security, authentication and authorization processes. • Created sophisticated yet user-friendly metadata libraries that pull data from across multiple platforms.• Established and coordinated maintenance and backup schedules. Web Application Developer, 2002 – 2013:• Designed, developed, and administered custom census and multiple years of American Community Survey (ACS) data for over millions of records.• Used SAS to perform extract –transformation and load big data into SQL server or Oracle database.• Provided HUD researchers access to create custom extracts of relevant ACS data. • Developed web application for Sustainable Communities Regional Planning Grant Program. SQL DBA/Research Data Analyst, 1996 – 2002:• Developed SQL codes using the Query Analyzer (SQL Server) to select and manipulate data in relational database.• Created OBDC, Accessed data in SAS, MS Access and SPSS.• Wrote scripts to identify and remove duplicate records to increase data integrity.• Provided data support for major HUD study on housing quality in the Section 8 voucher program. • Mailed 300K paper surveys to Section 8 tenants within 30 days of annual inspection. • Optimized sample size based on limited program budget.• Wrote 500+ SAS scripts to import, transform and analyze survey response data.• Extracted assisted housing tenant data from Unisys2 mainframe and wrote custom ETL scripts. • Provided essential statistical and data support for numerous ad-hoc and strategic research projects. • Conducted an analysis and interpretation of 10-year longitudinal study "Moving to Opportunity.”

Master Of Science - Ms, Applied Computer Science

Master Of Science - Ms