Idrees Hussain

Currently working on ETISALAT (PTCL) ORDER MANAGEMENT SOLUTION as a Data Migration Lead.
IBM GBS is implementing a catalogue driven order management solution based on a CRM, BPM, Inventory & Workforce Management system, for one of the largest telecommunication company in the country. Following are my responsibilities:

•Team Management
•Client Handling
•Development ETL strategies (Best Practice)
•Optimization of existing ETL processes
•Monitoring and Creating strategies for data migration processes.

•Worked on STC BI Implementation on SAP Business Object 3.0. Looking into the backend issues at database level. ETL development and ETL performance monitoring.
•Worked on the CAREs Project for Ufone. Looking into the backend issues at database level. Creating procedures, functions, triggers, Monitoring performance issues, query optimization etc.

• Worked in MTBC from April 2010 till September 2012. Here I was working as a Senior DBD/DBA. My responsibilities are:

1. Installation of SQL Server Software and Related Products.
2. Establish and Maintain Backups on Local and Remote Media.
3. Performance Monitoring Using Performance Monitor, DBCC Commands, Maintenance Plans, Third Party Tools.
4. Analyze Applications Performance Using Query-Execution Plans, Index Utilization And Procedure Cache Utilization.
5. Performance tuning.
6. In Database Programming, Use of Indexes, Normalization Techniques, Execution Plans, T-SQL and Stored Procedures.
7. Plan Growth and Changes (Capacity Planning) with Team.
8. Data Migration from Other Databases (FoxPro, Access, Med soft) to SQL Server (Import/Export).
9. Write Database Procedures, Functions and Triggers.
10. Tune Database Queries.
11. Optimization of SQL Server, Stored Procedures and SQL Scripts.
12. Monitor Application Related Jobs and Data Replication Activities.
13. Creating and designing reports on reporting server.
14. Managing reporting server issues.
15. Development of ETL (Extract, Transform and Load) and development of multidimensional OLAP cubes.

• Worked in Ora-tech systems as a software engineer from April 2008 to February 2010. Here I was working on a project “ IBM Enterprise Content Management” using the following technologies:
1. IBM DB2.
2. IBM System Administrative client.
3. IBM Portal Server.
4. IBM client for windows.
5. E-forms.
6. Crystal Reports.