YOUSSEF IBRAHIM ELMARAGHY

Email: ac25uf@r.postjobfree.com

US citizen

Cell: 614-***-****

SUMMARY:

An inherent passion to excel in the information technology sector, combined with a desired set of qualifications has brought me to this phase of life where I can be a valuable source of knowledge for any organization. Seeking a position in life to utilize my Database/ Analytical skills and abilities and achieve professional growth while being resourceful, innovative, and flexible, and that’s to add valuable assets to your esteemed organization as an active member.

TECHNICAL SKILLS/CERTIFICATIONS:

Programming Languages: experience with T-SQL, HTML, JavaScript, CSS & R

Operating Systems: Windows 2000/XP/Vista/Win 7/ 8/ 10. Windows Server 2008 R2, Windows Server 2012/ Mac OS X

Database: SQL Server 2008 R2, 2012, 2014 and 2016, Oracle

SSMS, SSRS, SSAS and SSIS. Microsoft Azure, Visual Studio 2015.

Experience with Active directory, Group policy, File server, and Exchange.

Experience performing basic management: Backups/ Restores - Basic optimizations - Storage systems -Normalization, Scripting and triggers - SQL Server Audit (Database engine) - User permissions, SQL Server Profiler - Trace flags, - Activity monitoring – Wait and Dead locks – Log Shipping – Failover Cluster – Mirroring - Scheduling maintenance jobs – Utility explorer Modifying and creating SQL server agent jobs - Data mapping and Data mining .

Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, Star and snowflake schema modeling using SSMS, VISO and ER/Studio

Understanding of SQL Server Tabular and Multidimensional models.

Knowledge of Database management principles and practices, Data profiling, Data visualization and Data storytelling.

Experience in development of stored procedures, views and other database objects.

SDLC familiarity.

Understanding of DLP concepts and products (Symantec DLP, IBM Guardian)

Interested in becoming proficient in day-to-day Microsoft SQL Server platform activities and Big Data.

Understanding of Desktop Support, and Software Licensing Services.

Have the ability to work independently and as part of a team, the ability to manage time and resources to meet assigned deadlines (Service Now Tickets - CRM Ticking system - Sales-force).

Fluent in English, native Arabic speaker with a fair knowledge of French and Spanish.

For personal development purposes: I Installed SQL Server 2016 in the cloud on a Windows Server Virtual Machines (VMs) running on Azure. It allows you to run SQL Server inside a virtual machine in the cloud. it is built on standardized hardware that is owned, hosted, and maintained by Microsoft. I have been utilizing Azure as a test environment to implement, apply best practices for SQL server in general, explore, and to solidify my knowledge using different tools such as SSIS (Building SSIS packages to extract, transform and load (ETL) data from different sources into destination targets, Logging and data auditing) SSAS (I have my own cube, tabular module for testing and development) SSRS & Report Builder to create informative, flexible management and operational reports.

Community/ Professional groups:

PASS – (CBusPASS) Columbus, OH, SQL Server User Group.

Columbus Azure ML and Power BI User Group.

TechLife Columbus, Microsoft Business Intelligence, Business Analytics, Big Data, and Artificial Intelligence.

IBM ANALYTICS, BIG DATA & CLOUD COMPUTING Cognos, TM1, Watson, Cloud, Unica, SPSS, Kenexa

EDUCATION:

ASSIUT UNIVERSITY, Assiut, Egypt

Bachelor of Science in Commerce (09/1999 – 11/2003)

Major: Business Management, Minor: Accounting

Highlighted Coursework: Management policies, Management of crisis, Management, Marketing management, Production management, International public relations, personal management and human relations, production planning and control, Public relations, political development, Accounting, Managerial accounting, Statistics, International marketing & advertising, International trade, Organizational behavior, Economics, Purchasing & supply management, Economic development and planning, Auditing, Insurance, Commercial law, Foreign trade, Operational research, Managerial accounting, Finance and financial management, Financial markets and institutions, Intermediate accounting, Cost accounting, Government accounting, Principals of auditing, Financial markets and institutions.

HONDROS COLLEGE OF BUSINESS, Westerville, Ohio

Real Estate (06/2016 – 07/2016)

Highlighted Coursework: Ohio Real Estate Principles & Practices, Finance, Appraisal, and Ohio Real Estate Law, including instruction in civil rights, housing discrimination and desegregation problems

EXPERIENCE:

01/2017 to

Present FAB GLASS AND MIRROR, Columbus, OH

Junior DBA/ System - Data analyst.

Fab Glass and Mirror is one of the fastest growing companies in America (#131 INC 2017 & #183 INC 2016) specializing in manufacturing, distribution of glass and mirror products, supplying the finest products and services to consumers, businesses, distributors and contractors.

Worked on various types of system units monitoring and fixing technical problems that might possibly prevent the database instances from their daily run.

Administered databases including backups/restores, performance monitoring, disk usage, and report gathering using T-SQL.

Administers end-user access and security at the database level.

Monitored database status including CPU, memory, I/O, space, and deadlocks using SQL Server utilities.

Analyzed data to identify sales trends and ensure data integrity using SQL scripts and power-BI

Optimized query and table design with knowledge of database performance and capacity.

Established Entity Relationship Diagrams to help quicken the data processing and data flow.

Collaborated with other programmers on data modeling.

Administered user accounts and security for the company system and for all company databases.

Wrote and modified many SQL queries while working in a very fast paced environment.

Developed business intelligence solutions for all business areas including: operations, accounting, marketing, and executive management.

Troubleshooted Dev/qa issues with connectivity and interacted with tester/developer in resolving issues.

Installed patches and fixes in the databases.

Monitored Scheduled jobs and alerts.

Tested various SSIS packages which pulls data from different data sets

Maintained the daily, weekly and monthly performance reports of the team.

Determined key performance indicators (KPI’s) including visitor profiles, web analytics, mobile and social analytics.

Created and maintained various monthly sales reports to track productivity for certain products to build annual forecasts and budgets.

Organized and manipulated large data sets by historic and forecasted sales patterns.

Self-starter with the ability to take ownership and work independently with minimal supervision.

06/2016 to

Present Self – Employed/ Consultant

Designed, developed, maintained, promoted and updated a variety of web sites as assigned by several local clients.

Developing a Machine learning/ Artificial Intelligence App, partnering with Rev1 www.rev1ventures.com

Tutored a couple students in graphic design using Photoshop elements 14. ( iLearninstitute) http://ilearninstitute.com/

Real Estate.

Life Insurance.

Being an active member in different user groups, such as PASS, Tech-Life Columbus, Microsoft Business Intelligence, Business Analytics, etc.

03/2015 to

05/2016 NETWRIX CORPORATION, Powell, OH

Analyst Engineer/ Support

Netwrix Corporation focuses exclusively on providing complete visibility for data security and risk mitigation in hybrid IT environments, which offers IT auditing solutions of systems and applications across IT infrastructure.

Helped clients monitoring their security of critical systems (e.g., E-mail servers, Database servers, File server, etc) and changes to highly sensitive computer security controls to ensure appropriate system administrative actions, investigate and report on noted irregularities.

Researched different data sources to analyze complex business issues and incorporates. Company and industry knowledge. Like for example: (A non recommended user pattern, password resets, file access/ creation, permissions)

Facilitated requirement gathering and alignment with business and technology partners (Microsoft) for the new-implemented application modules, while supporting other working modules.

Diagnosed and resolved database access issues for different accessible systems and checking on performance issues and that’s through stored procedures, for example: (sp_helprotect, sp_helprolemember, sp_helpuser), GUI or Browser roles.

Monitored SQL server performance in function with the application with an in-depth grasp of SQL server Reporting Services (SSRS), writing, troubleshooting and optimizing SQL queries.

Coordinated with account teams in development of new accounts and maintenance of existing ones for auditing and security purposes to monitor changes to user accounts (Create, modify, delete) member of selected groups and their types (User, Group, Computer, etc. and their statutes if Enabled or Disabled)

Conducted/ enabled Group policies and logon scripts along with recommendations for auditing purposes, to audit GP object changes, settings, and permissions with the name of the originating workstation from which user made the change.

Created interactive SSRS reports allowing clients to review and analyze their data and remits from a Web based application. (Using Report builder or visual studio)

Participated and supported SQL server installations both upgrades and standalone installations.

Involved in performance monitoring and tuning of the database by first looking at the server hardware, operating system, memory, CPU, SQL version, database, SQL Server Profiler and Application version.

Mined and translated inventory data into meaningful metrics used to analyze efficiency and quality.

Interfaced with sys-admins/ IT support users to document requirements to develop effective auditing/ security solutions for our clients audited infrastructure, for example: (Windows servers, File servers, SQL servers, SharePoint,

Identified database issues and resolving them by best practices for the database structures, principles, and theories in function with the application, like for example: (Using Reliability and Performance Monitor applet tool)

Helped in databases upgrades for the purpose of ensuring their ability to use new and/or existing application.

Provided technical assistance to the projects throughout their development phase by customizing the systems to give desired result/ Provide tips and tweaks to cope with newly discovered faults for the applications to eliminate any production issues.

Ensured the software is patched and able to protect from threats. Make recommendations for mitigating identified risks.

Ran scripts through the command prompt to verify that all the needed configurations, settings and modifications are setup correctly on the customer various systems (Windows server 2008 R2 – 2012, 2014, File servers, SQL server, AD, GP) to audit and detect changes for example: Auditing Failed Logins in SQL Server, etc.

Helped with SSIS Logging and data auditing, like for example: I would limit SSIS logging to OnError and OnTaskFail events because it carries a large I/O overhead and can slow the application performance.

Performed server and security audits, system backups, and recovery on Active Directory.

Interacted with third party vendors and identified different external and internal homogenous and heterogeneous sources and extracted and integrated data from flat files, Oracle, SQL Server sources and loaded to staging area and database/ Data-mart tables.

Created workflow rules and defined related tasks, email alerts, and field updates.

See projects to completion within terms of SLA and supervise accurate turnover to Operations staff.

Log problems from incidents and link similar incidents to the problem and document symptoms and analyze the impact of problems to mitigate risk using the CRM ticketing system (Sales force).

07/2013 to MCGRAW-HILL EDUCATION, Gahanna, OH

03/2015 Software Analyst/ Tester

Provided technical assistance/ testing to the projects throughout their development phase by customizing the systems to give desired result.

Research, evaluate, recommend and implement methods, policies, processes, best practices, techniques, technologies and tools for software license management.

Ensure retention of all proof-of-license documentation.

Facilitated requirement gathering and interfaced with sys-admins/ end users for an efficient successful product deployment.

Liaise with Product Owners/Managers, Inventory Management and business representatives to ensure proper tracking of all software product deployed to ensure OLG has sufficient licenses.

Provided support to external customers and sales representatives via telephone and email for all McGraw-Hill School Education Group product lines.

Debug failures, identify design flaws, and suggest solutions on both existing and new applications.

Log hotline calls into a call tracking database, as well as monitor and update open call tickets through resolution using the CRM system (Sales force)

Worked with various Salesforce.com objects like Accounts, Contacts, Leads, Campaigns, Reports, and Opportunities.

Provided tips and tweaks to cope with newly discovered faults for the applications to eliminate any production issues.

Tested and implemented customized software templates for various environments and customers.

Performed user acceptance testing to ensure that defects are recognized as soon as possible.

Interacted with lead and senior support analysts, to report issues and work towards resolutions and that's through weekly meetings, live chats and conference calls.

Strong experience working directly with non-technical customers and translating requirements into actionable prototypes, and developing formal requirements for such prototypes.

01/2010 to TELEPERFORMANCE (VERIZON-FIOS PROJECT), Columbus, OH

06/2013 Technical support Analyst

Promoted from Tier 2 to Tier 3 analyst based on abilities to work independently and efficiently with confidential client information and obtain positive feedback from clients about service.

Employee of the Month for March 2011 and Best Performing Agent for October 2011.

Temporarily managed more than thirty (30) call center agents during my superiors’ vacation time. I Monitored calls and provided feedback during coaching sessions, Implemented effective customer service strategies,

Set goals for the team and provided coaching to ensure achievement, Monitored and evaluated CSR performance to assure quality service, professionalism and courtesy, and identify actions that can improve call quality and customer satisfaction.

Fully investigate, diagnose and resolve consumer issues of various incidents via email, telephone call, letter or chat to solve problems to maintain high levels of consumer satisfaction.

Maintained a "closed-loop" communication style assuring all appropriate individuals are notified of problem resolution status and all consumer follow-up is completed.

Provided support to front line agents in a fast-paced environment and accurately escalate issues as needed.

Configured clients’ equipment and software to connect to the Internet via modem/DSL Router.

Demonstrated proficiency in Internet-related applications such as E-Mail clients, FTP clients and web browsers.

09/2008 to SEARS, Dublin, OH

01/2010 Sales Consultant (Electronics)

Assisted in setting sales strategies and increasing customer satisfaction levels, leveraging cross-sell and up sell opportunities.

Managed periodical sales quotas to meet the store requirements.

03/2004 to CENTER OF ENVIRONMENT & DEVELOPMENT FOR ARAB REGION & EUROPE, Cairo, Egypt

07/2008 Regional ICT Specialist

CEDARE is a non-profit organization established by United Nations Development program (UNDP), the Arab Fund for Economic and Social Development (AFESD), and the government of Egypt

Edited, designed and published several websites and electronic newsletters for E-Learning/online environmental training courses and database backups

Participated in various environmental-related research efforts including Electronic Waste Management (e-Waste)

Prepared presentations for board of trustees’ meetings by gathering and analyzing data from every department

Closely worked with affiliated organizations like UNDP and Arab Water Council (AWC) in managing joint projects and providing detailed progress reports via fax, email and phone to ensure that all deadlines were met

Increased the professional qualifications of staff by means of research and training.

01/2004 to EL-AHRAM ESTABLISHMENT, Cairo, Egypt

02/2004 Intern

Assisted in bookkeeping within the finance department of the largest publishing and advertising organization in the Middle East

Completed training in advertising, distribution and finance duties ( learning different sorts of marketing & advertising techniques, the distribution process and how to organize and regulate the distribution process according to different vendors. Worked on setting up budgets and work sheets for specific projects at that time.

07/2001 to UNITED BANK OF EGYPT, Cairo, Egypt

09/2001 Intern

Gained familiarity with banking functions including issuing Certificates of Deposit, teller services, filing and customer support call center.

Entered and retrieved customer data and maintained accurate database of information.

VOLUNTEER EXPERIENCE:

03/2016 to

Present

Organizing, cleaning and keeping everything in order.

Greeting and welcoming patients.

04/2011 to OHIO STATE UNIVERSITY WEXNER MEDICAL CENTER, Columbus, OH

Present Ambassador/Patient Advisor

Assist staff in-patient care areas and complete clerical and office management duties.

Greet patients and visitors and address any questions or concerns.

REFERENCES: Available upon request.

Contact this candidate