Results-oriented, high-energy, hands-on professional, with a successful record of accomplishments in the Telecom industry; More than 10 years working experience in Financial and Subscriber Reporting.
• Web Application Development & Database Design.
• Data Warehouse.
• Mediation & Provisioning.
• Business Support Systems.
• Call Center solutions.
• Revenue Assurance.
Specialties: Data Warehouse & Reporting:
Location & Cell Based Analysis,Revenue & Usage Analysis, CRM & Marketing Analysis, Subscriber Churn & Sales Analysis, Ad-hoc Query Analysis.
Software Development:
Client Server and relational database design using Oracle, MS-SQL, ASP.NET , C#, Visual Basic.NET & VB Scripting.
Project Management:
- Project Manager for Microsoft Lync 2010 Deployment for 500 users
- Technical & Operational Project Manager for ERP (Microsoft Dynamics 2009)
• Supervise programmers, database administrator and other support staff including assigning work and provides technical direction to them.
• Participate in interviewing, hiring, development and training of new developers.
• Identify resource needs and enforce project and delivery standards.
• Establish clearly articulated project plans. Evaluate and allocate time and resources in order to assign specific tasks to various staff members. Set deadlines and ensure that they are met.
• Ensure that project plans proceed as scheduled and are enforced or modified if needed. Enables all team members to work as efficiently and creatively as possible.
• Establish clear coding/programming guidelines and requirements. Review and approve code generated by subordinate programmers & developers. Coordinate with development resources in order to meet expected outcome and product quality standards.
• Review the software/systems development lifecycle and workflow and application coding.
• Review current status of system applications and prepares recommendations for Improvements.
Key Achievements:
Project Management:
• Microsoft Dynamics 2009 migration to 2012
• Lync 2010 deployment (500 users)
• SharePoint 2010 Deployment.
• Project Manager of NGCC (150 Agent) Call Center.
• Project Manager for E-Topup Dev & implementation.
Software Development: (Dev Tools: ASP.Net, Visual Basic.Net, Oracle, SQL Server)
• Customer Registration Achieving System (CRI).
• Bulk SMS System for submitting SMS in Dari, Pashto & English languages.
• Number Distribution &Tracking System.
• Document Management & Archiving System.
• Project Management System.
• SharePoint 2010 based Intranet.
• Financial Reporting Module.
• Site Management, Payment System, Site Rental System & Online Recruitment Portal
• E-Quiz, Bulk Email, Electronic Appraisal System.
• Coordination with clients for requirement gathering, business rules & source system analysis.
• Preparation of project plans, weekly status reports & technical documents & their review.
• Preparation of new CRF & supporting documents for clients & provide technical support to marketing team for Initiating new projects.
• ETL analysis, report analysis & designing new reports.
• Provide technical support to technical Team Lead & to other team members for data modeling, business rule implementation & testing.
• Pre-sale system analysis of IN and TABS systems for Mobitel- Sudan DWH Project.
• Lead a team of business analyst for system analysis & business rule gathering of TABs and TAP systems for phase-2 of MTC-Atheer, Iraq DWH Project.
Data Warehouse:
• Assisted IBM team in designing the Data Warehouse database model of Paktel & data migration from old reporting system.
• Provided technical support to IBM Team for existing systems analysis & report analysis.
• Reconciliation of DWH reports with the existing systems reports.
• Development of new subscriber, revenue and usage reports in Business Objects for Marketing, Finance and RA departments, Subscriber Churn & Other Adhoc Analysis thru SQL queries & provided other technical support to users in this context.
Software Development: (Development Tools: Oracle and Visual Basic.NET)
• Developed monthly subscription deduction module for subscriber on Talk-Free Package.
• Provisioning module for tariff change of the subscribers on this tariff.
• SMS Notification Module for the subscribers on this tariff.
• Developed a system for providing bonus on incoming off-net calls to prepaid subscribers.
Key Achievements:
• Developed P-To-P Balance Transfer Application (Easy Share).
• Pre-paid Reporting System for providing daily & monthly subscriber, revenue & usage reports to Finance & Marketing and Revenue Assurance.
• Developed Excel based reporting system using VB scripting for auto-generation /delivery of revenue, usage & subscriber activity reports.
• SMS Backup Charging System for TDMA subscribers.
• CRBT Provisioning Application
• HLR Provisioning Application.
• IN Provisioning Application for subscriber card validity change and balance update
• TDMA Subscriber Provisioning using Win Foil Interface.
• Subscriber Reconciliation Module between IN and HLR for Prepaid and Postpaid subscribers.
• Recycle plan for disconnected subscribers
• Subscriber Blocking & De-blocking Applications.
• Subscriber SMS Blocking and De-Blocking Application.
• Application of generating Tax Certificates for Prepaid subscribers.
• Call Detail for Prepaid Subscribers
• On Air ESN Change Application for TDMA Subs.
• Online Puk Code delivery thru SMS.
• Online Tariff Inquiry Application thru SMS
• Mediation Applications for CDR files generated by IN, USSD and CRBT and Fun440 servers.
Key Achievements:
• Developed P-To-P Balance Transfer Application (Insta Share).
• Pre-paid Reporting System for providing Daily & Monthly Subscriber, Revenue & Usage Reports to Finance, Marketing & RA.
• Developed Excel Based Reporting System Using VB Scripting for Auto-Generation/Delivery of Revenue, Usage & Subscriber Activity Reports.
• Provisioning Application for Subscriber Card Validity Change and Balance Update
• Recycle Plan for Disconnected Subscribers
• Subscriber Blocking & De-blocking Applications.
• Subscriber SMS Blocking & De-Blocking Application.
• Application of Generating Tax Certificates for Prepaid Subscribers.
• Call Detail for Prepaid Subscribers
• On Air ESN Change Application for TDMA Subs.
• Mediation Applications.
• Dealer Incentive System
• Configured accounting software SOLOMON IV on SQL Server and provided necessary technical support to accounts department in its implementation.
• Developed procedures in Visual Basic for data migration from old accounting system to Solomon IV.
• Modified Solomon’s Interface using Visual Basic and developed additional reports in addition to customization of existing reports using Solomon IV report writer. Effectively used SQL Plus and PL SQL and other SQL utilities for management of accounting software database.
• Designed Inventory Control System for computer/electronic equipment of Uch using Visual Basic & Access.
• Designed a billing system and a database for keeping record of all the telephone calls made through the PABX in SQL Server 7.0 and Visual Basic 6.0.
• Designed & terminated 48-node network using Base-T cabling system, DLINK 100base-T hubs and network cards.
• Configured Windows NT server and Windows 95 /NT based workstations. Also configured IP Routing, Sub netting, DHCP Server and WIN’s Server.
• Configured SQL Server 7.0, Exchange Server 5.5, Proxy Server 2.0 & Internet Information Server 4.0
• Installed software packages in single user and multi-user environment and carried out trouble shooting of the problems.
• Responsible for procurement of all computer equipment and accessories for the office.