San Diego, CA 92108
Highly motivated IT professional with experience in database administration, BI and application & customer support. Appreciates challenges, sharp learning curves and high pressure deadlines. Reliable team player with effective troubleshooting skills. Adequate project experience, introduces out-of-the box thinking and problem-solving analysis, seeks excellent quality of customer service.
MS SQL Server 2000 Enterprise Manager ~ MS SQL 2000 Query Analyzer ~ MS SQL 2000 Profiler ~ MS SQL 2005~MS SQL 2008 ~ Microsoft SSAS 2008
Querying MS SQL 2012
Administering MS SQL 2012 databases
Implementing data models & reports with MS SQL 2012
B.Sc. Degree of Computer & Information Sciences.
-Area Application Support Executive North Africa, British American Tobacco, October 2014 till May 2016
British American Tobacco plc is a British multinational tobacco company headquartered in London, United Kingdom. It is one of the world’s five largest tobacco companies.
I have led the application support team and acted as subject matter expert for technical and non technical stakeholders pre and after the migration the previous trade and marketing solution.
I managed new software release of trade and marketing solution implementation and participated in designing future reporting solutions & in reviewing existing reporting structure.
Migrate previous Trade & Marketing solution to BAT regional solution (RCS8) integrated with ERP
Performed data migration from legacy system to new system with minimal margin error.
Upgraded successfully HW devices to become compatible with new software.
Participated in the dry run test before business release.
Participated with the business to perform UAT of new business reports.
Upgraded successfully the database & application server of the HR management system of payroll and leaves from 2005 to 2008.
-Operation Support Specialist, TA Telecom, March 2014 till September 2014
TA Telecom is a company that provides services benefiting more than 10 million users in the MEA mobile market. It generates more than 1.5 billion push alerts annually and process more than 840 million charging transactions on mobile content platforms.
I have worked as part of the operation support team responsible of day to day operations such as pushing alerts to customers on daily basis, billing transactions and ensuring smooth performance of all DB servers.
Published successfully OLAP reports via HTTP through IIS.
Managed Nigeria & Afghanistan customer accounts with minimal disruption on the business.
Established mirroring back up between principal server & mirroring server.
Created technical documentation for all encountered issues & their resolution.
Facilitated business intelligence analysis through providing ad hoq queries without impacting DB performance.
-Job Title: Database Administrator, British American Tobacco, 2009 till 2014
I was part of the DB administration team for more than 5 years where I have worked closely with technical team, vendors and the business to support successfully business operations and form strong relationship with business stakeholders.
I provided second line support for Hand Held mobile devices users for more than 200 sales representative .I was responsible as part of the team for testing new Hand Held software mobiles devices and deployment process.
I created database back up maintenance plans .I granted user access permission to DB and BI reports .I monitored and optimized the performance of the database. I designed map processes for new processes and requirements using Visio.
Created multiple archived databases to improve the production DB performance and provided availability to transactional data to the business. The archiving process was implemented every two years.
Upgraded successfully the test database & application server of the trade and marketing system from 2000 to 2008.
Upgraded the business intelligence solutions (test server) for trade and marketing system using SQL Analysis Services & OLAP from Analysis services 2000 to SSIS 2008.
Created successfully multiple OLAP reports to improve the business visibility on the different sales transactions & conducted CRF & UAT for all new requirements & reports.
Created the customer points collection program for the trade and marketing system, which is an enhanced program to collect points for customers based on sales volumes,,targets, visibility and KPIs, program consisted multiple formulas to calculate the redemption points of the customers via OLAP report and DTS to show some of the reports data on the HH mobile device.