Sr. Datawarehousing Consultant
NCR
مجموع سنوات الخبرة :17 years, 5 أشهر
•Managing Teradata customer accounts in UAE (DU telecom, NBAD bank, Emirates group), Oman (NAWRAS), Kuwait (Wataniya telecom), Qatar (Ooredoo telecom) and Nigeria (FCM bank).
•Troubleshooting Teradata technical issues.
•Handling contracts renewal, technical project management (Major and minor patch upgrade).
•Implementing and installing new Teradata systems, applying migration projects from technical prospective.
•Troubleshooting Veratis customer issues (3600, 5000, 5020, 5220, 5230, 5030, 5230, 5330 and 8300 Systems).
DBA Role: Etisalat Egypt.
•Changing, monitoring and recommending workload priorities.
•Monitoring system behavior through viewpoint and TDWM.
•Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.
•Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc.
•Move databases between machines.
•Installed patch sets and upgraded Teradata.
•Automated data warehousing refreshes using Transportable table space option.
•Work on creating and managing the partitions.
•Performed database health checks and tuned the databases using Teradata Manager.
•Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
•Install Teradata drivers for the Teradata utilities.
•Use Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
•With the in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI and USI and NUSI and JI etc.) etc.
•Using Teradata Explain and Visual Explain to analyze and improve query performance.
•Participate in assessing or identifying any risks associated with the new architectural components.
•Participate in any brainstorming activities or meetings pertaining to new projects on Teradata.
•Participate in research solutions to various business and technical problems, evaluate alternatives and be able to present recommendations and justifications to senior staff.
•Develop physical design. (Indexing, Compression, Block size, Soft RI etc.)
Testing responsibilities: Current Project.
•Scope the required tests.
•Design the required test strategy in line with the scope and organization standards.
•Create the software test plan, get it reviewed and approved/ signed-off by the relevant stakeholders.
•Evaluate and identify the required test automation and test management tools.
•Estimate the test effort and team (size, skills, attitude and schedule).
•Create the test schedule (tasks, dependencies and assigned team members).
•Identify any test metrics to be gathered.
•Communicate with the client or on site/ offshore team members, as required.
•Review the test cases and test data generated by the Software Test Engineers and get them to address the review comments.
•Review mapping\modeling and handling issues.
•Get information on the latest releases/ builds from the development team/ the client.
•Work in parallel with ETL team and create similar scripts to re-built loaded data to check data accuracy.
•Contact customer if source provided includes data quality issue.
•Assign returned defect reports and assist the concerned Software Test Engineer, as required.
•Escalate and obtain resolution of the issues related to the test environment and team.
•Report the status to the stakeholders.
•Improve the test process based on the suggestions by others and own judgment.
Trainings via ETL and BI:
•Capture ETL Requirements.
•Define BI application requirements.
•Develop and validate the application design.
•Develop and unit test semantic layers, reports and GUIs.
•Participate in verification of the application.
•Support the data warehouse design and integration efforts, including data sourcing and transformation, logical/physical modeling, and ETL development in support of the application.
•Design, develop, and test processes for extracting data from legacy systems or production Databases.
•Design, develop, and test processes for validating and conditioning data prior to loading into a Data warehouse.
Worked as Global Technical Support (GTS) Engineer, overall Technical Support for all Operating Systems (Linux, MPRAS (Unix) and Windows server).Provided remote software and hardware full technical support for Teradata products/equipment to the EMEA/Americas Teradata customers’ base and business critical.
Administration of the installation, basic DBS snapshot dump analysis, system maintenance, Hardware and Software upgrades, system analysis, account development and planning, asset management, individual development for mission critical customer support and maintaining a high level of customer satisfaction.
Gained Teradata Basics certificate TE0-121, with DBS and OS skills.
•Testing company products.
•Sharing in the Implementation of administration of Microsoft Dynamic AX ( Axapta ).
•Installing and Configuring Retail Pro 8.5.
•Responsible of 30 Branch Plus 80 User.
•Installing and configuring the EPO server and giving permissions to create a secure LAN .
•Installing and Configuring Manage Engine Desk Service and adding rules for users and keep it available for branches as a web form.
•Training for system users.
•Working in team to manage the network that connects company’s Customer branches together, and solve hardware failure.
•Windows 2003\2008 Server & XP\Vista and 7 Administration.
•Configuring DC and Policies.
•Implementing and designing Server2003\2008 active directory Infrastructure.
•Installing, Configuring and Administrating Compris 7i Pro ( AMWS, POS, HDS ) .
•Manage user permissions for providing secure Network.
•Troubleshoot Network infrastructure.
•Other Duties as assigned.
•Fixing Network troubleshots .
•Data Entry
•Management of the The DBA (Oracle10g) .
•Fixing Printers And working on it such as (EGX-300, HP 5500, HP 1018)
•Planning and rebuilding the network infrastructure of the air defence all over egypt .
•Other duties as assigned .
1- Building network infrastructure on customer sites.
2- Installation and troubleshooting of network printers.
3- Preparation and installation of Windows server 2003 and its domain controller.
1-Re-build network infrastructure on customer site.
2- Configuring routers and switches.
3- Preparation of VOIP services on customer site and headquarter.
Graduated from Cairo University , Science college , major of Computer Science and Absolute Math , with grade Pass