Information Technology Consultant
SBM & Kafa’at business solutions
Total years of experience :21 years, 0 Months
Project Data Center, serving eGovernment and eServices
Operation Brief Government Data Center with largest DB2 mainframe and largest SQL Server production systems in the country, to feed Data in & out to 36 eGovernment Systems and serve 150+ Applications and eServices. The Data Center is a main source of information for Data warehouse, Data Scientists, Investigation Agencies, Reporting systems (generating 800+ Reports).
Transactional Activity is 24/7 to DB2 & SQL Server. Size of Legacy and Core Data is 5TB with Transactional Databases 25TB consisting of about 1500 Tables, 3000 Indexes, 100 Triggers, 1000 Stored Procedures, 200 SSIS Packages, 200 Scheduled Jobs and Several Replications.
Problem Statement The Data Center, serving millions of transactions and growing, requires upgrade with Scalability and Availability to handle next 10 year growth.
Vision & Mission The Vision is to have a Reliable infrastructure to serve the databases and applications..
The Mission of this Project is to build an infrastructure to serve the upgraded Databases, Applications and Services.
Solution
Component Infrastructure & Hardware.
Software & Licenses.
Consultants for architecture, design & deployment.
Virtualization & deployment.
Upgrade and Migration of Databases
Upgrade and Migration of Applications and Services
Operation & Service Management.
Training for each department team.
Methodology With the need to Accommodate and Merge more Data from 56 new sources and support eServices, analyzed and restructured the Databases and Application to employ the new infrastructure architecture for Scalability, Availability, Security and performance. Applied PMO standards and met KPIs.
Duration Forty-eight 48 (12-Months Executing and 36-Months of Operating).
Benefits
Reduce administration and maintenance costs
Avoid multiple servers power and cooling costs
Unified platform
Resource Optimization
Operational Convenience
Scalable to future growth
Database security and high availability
Application security and performance
Technology Used Virtualization: VMWare SDDC (vSphere, vSAN and NSX)
Storage EMC VMAX 20K
Databases DB2 v 10.1 for zOS
Microsoft SQL Server 2012 and 2014 AlwaysON
Applications CoolGen, CA Gen v8., .net
Roles and Responsibilities
Work with managers across functions, both business and systems.
Project management
Team building, defining roles and positions, interviews and hiring
Defining KPIs, Management processes, Prepare policies and technical standards
Ensure continuous improvement and quality assurance in all activities.
Meetings and Dealings with vendors and service providers.
Meetings and Collaboration with departments and clients
Prepare Presentations and Reports for the management.
Project Building in house development and data analytic team to cater growing needs
Company Brief A marketing and customer relation company, leader in data analytics and strategic marketing.
Problem Statement Management felt the need to build in house team with skills of development, databases and analytics.
Vision & Mission The Vision is to have an modern IT department to cater clients projects.
The Mission of this Project is hire required skill sets, build an infrastructure, acquire software and tools.
Solution
Component Report analysis of services, business model and customer requirements
Define responsibilities and expectation of IT department
Define and submit required IT skill
Detail hardware and software requirements
Interview and Hire team
Purchase, Deploy and Configure Hardware and Software
Analyze and Design Databases Architecture.
Manage the team of 18 IT professionals.
Duration 12-Months Plan and Execute and Ongoing Manage the Operations.
Major clients
BASF, Monsanto, Bayer, Pfizer, NovoPharm, Novartis, Investors Group, Wrigley, Investors Group, HSBC Bank, Royal Bank & Microsoft, Toyota.
Technology Used IBM eServer p5 and Work stations
IBM TotalStorage DS4800
Windows (2003, 2000, XP).
SQL Server (2005, 2000),
Oracle (9i, 10g),
Lotus Notes (Dominos 6.5)
Roles and Responsibilities
Manage SQL Server, Oracle, Lotus Notes Databases.
Manage Database Administrators (3) and Developers (15).
Created specialize and customize algorithms
Deliver client data and information into actionable knowledge and insights.
Data Analytics and Insights using SAS tools.
Deliver decision making reports to the management.
Resolve Performance, Load Balancing and Tuning issues.
Work with managers across functions, both business and systems.
Meetings and Dealings with vendors and service providers
Role, Responsibility & Technical Environment
SQL Server (2005, 2000, 7.0, 6.5), Diagnostic Tools,
CRM and Windows (2003, 2000, XP)
Advisory & Tech. Support for Microsoft’s Corporate/Premium Clients.
Resolve SQL Server Performance, Load Balancing and Tuning issues.
SQL Server Upgrades, Data Migration, Replication and Disaster Recovery.
Deploy SQL Server Databases over High Availability windows 2003 Cluster.
Special Support for high-end disk sub systems (SAN).
Link SQL Server to Oracle, DB2, Sybase, Access and other data sources.
Contribute to Hot Fixes, Solution Objects and Knowledge Base Articles.
Interview new hires, Deliver Trainings and Knowledge Transfer Programs.
Engage in pre-release product enhancement phases and beta testing.
1. Querying Microsoft SQL Server 2012 2. Administering Microsoft SQL Server 2012 Databases 3. Implementing a Data Warehouse with Microsoft SQL Server 2012 4. Developing Microsoft SQL Server Databases 5. Designing Solutions for SQL Server
Specialized in Software and Databases