01/2005 - Present
SBC Operations Inc., San Antonio, TX USA
Manager Technical Support/Analysis
Created database and web interface for SORD orders retention so that in case of SORD order overflow we would have archived records for up to last 45 days.
Created web Dashboard so that the organization members can Create and Manage their Projects. This reduced significant from each user and the time used to create and publish the final document. This was done manually where each user would update Word document every week then one user would go in and collect all dashboards and converted them into PDF and then published them out.
Providing Support in PreWINDS SBCLD TBS to WFA project. Loaded Oracle on local server where we load fresh dumps of TBS data from production environment and then run PL/SQL scripts on it. This helps in analyzing the data needed for migration from TBS to XNG application saving company $200,000.
Created queries in PL/SQL using TOAD application to extract data for Data Migration from TBS Database.
Creating REV Form process for SBCLD for post migration. This process involves extracts from Xng which contains FR/ATM orders that needs to go to WilTel. Based on each record the user gets an email and link to a web interface where they can review and/or update the Order and send the order in HTML format as an email attachment automatically.
Creating Xng change request forms where users can submit a change request in Xng. This is an automated process where the email goes to the team members responsible for the approval process. When all members approves or rejects the request, the user is notified of the decision via email. The request is stored in a database for references.
09/2003 - 12/2004
SBC Operations Inc., San Antonio, TX USA
Manager - Technical Support/Analysis
Provide WFA/C backup support for ASI.
Maintain IMS Reports website which publishes reports coming out of WFA systems in HTML and Excel format.
Developed RAJSD and SOSTR Monthly reports that come out of ULTRA and published them on line. The reports comprises of summarized data in tabular and graph format as well as detailed report upon request. These reports are updated every
month using data from ULTRA and Business Objects. Queries are run in SQL Server and data is refreshed.
Designed and Developed Cold Fusion based Web Database Application for ASI Security Helpdesk. The database runs on MS SQL 2000 Server. Migrated existing data from Access to the SQL Server.
This provided consistent data for all CSRs, increase customer response time, create effective reports, secure data on the server instead of in Access and save approximately 5 man hours daily, resulting in saving thousands of dollars yearly.
Created macros for weekly update of Access data that used to take 6 hours weekly, now taking only 20 min weekly.
Responsible for the support of the WINDS Project (CIM/CAPCNO, POMS) along with ongoing system support in the Work Force Management Organization.
Duties include attending cross organizational meetings, time management responsibilities, project coordination, system/operational support for applications like WFA, ULTRA, GCAS, and DISC.
09/1999 - 09/2003
SBC-Southwest, Houston, TX USA
Network Center Technician- Special Services GBC
Designed, developed and maintain Houston GBC Special Services website that helped in collecting center policies, procedures and updates at one location. Also developed online form that streamlined circuit design updates between various test centers and circuit provisioning center.
Developed programs in Hummingbird Basic and KEA by Attachmate to automate ticket handling of NMA, Group and official company circuit tickets. This resulted in closure of about 1500 group tickets that were pending since 2000. OCS programs run daily to correct errors in ticket entry process. Spare spans are tested daily by the program to help saving nonproductive dispatches. Center productivity increased and center response time decreased as a result.
Worked on maintaining center quality by scrubbing closed tickets to ensure consistency with SBC procedures.
Duties include performing required maintenance such as analyzing output messages of systems, analyzing the trouble indications, customer trouble reports and taking appropriate steps to correct any malfunctions on Analog, ISDN, ATM/Frame Relay, DDS, DS1, DS3, SONET (fiber optics) and 911 circuits.
Operate terminal(s) to access various computer and Network systems such as NMA, PMI, WFA, TIRKS, REACT, ECRS, EFIS, DCS, SONET, MLT, SARTS, HEKIMIAN, WILTRON, etc.
Review and interpret documents such as service orders, circuit diagrams, engineering documents, trouble analysis manuals, translation guides, trouble report history and data from various support and automated test equipment.
Examine interaction between computer hardware and software to isolate malfunctioning components in the network. Perform remote testing in conjunction with installation and repair of designed circuits. Provide assistance and coordination with the field forces and direct their activities.
01/1999 - 05/1999
University of Houston-Clear Lake, Houston, TX USA
Teaching Assistant
Prepared and setup lab experiments. Assist teacher in helping students on one to one basis.
04/1997 - 08/1998
Analytical Measuring Systems, Karachi, Pakistan
Service Engineer
Installed, maintained and troubleshoot analytical instruments that included Atomic absorption, UV/Visible and FT-IR spectrophotometers and Chromatographs that included GC and HPLC types.
Communication of hardware and software through serial, parallel, or IEEE bus using standard PC.
Skills:
Proficient in ColdFusion, Javascript, ASP, JAVA, BASIC, Assembly Language (Intel & Motorolla, C/C++.
ColdFusion Administrator, TOAD, MS SQL Server 2000, Oracle Server, Web Server, UNIX, SQL Query Language, T-SQL, Business Objects, Dreamweaver MX 2004.
Windows 2000, XP, Microsoft Office, MS Project.
Project Management.
Education:
University of Houston-Clear Lake, Houston, TX USA
Master of Science, Computer Engineering/Networking
NED University of Engineering and Technology, Karachi, Pakistan
Bachelor of Science, Electronics
