SUMMARY:

• Worked in IT for over 3 decades in the Wireless Telecommunications, Education and Finance sectors straddling the mainframes and client/server architecture. Played major roles in the management, development, testing, conversion and implementation of multiple applications.
• Responsible to set up all Informatica server applications in the 23 test environments as Confidential upgrade Informatica from Release 9.6 to Release 10.1
• Update relevant certificates in the UX servers for clients to access Java applications.
• Integrate the non AMDOCS billing system components (ODS, EDW, SHRSQA, BRM, ASA, TELSIT, INT, DRDM, UMART) for Data movement and Warehouse testing
• Coordinate all data refresh from Production - pre-refresh tasks, shutdown DBs, Flash disks, Start instances, post refresh tasks
• Deploy all DMI and EDW changes to the test environments and support the testing efforts before they go to production
• Member of Hadoop User Group - Seeking more efficient ways to interrogate the huge databases Confidential
• Support the Tops Maintenance Windows to deploy code, EPC and Reference Hot fixes to the Test environments
• Assist with TOPS issues in CRM, OMS, RPL, ABP, MCSS, APRM.
• Integrated the Amdocs Billing system (CARES) to external interfaces like Infranet, IVR, AIM, Protobase, Cybersource etc.
• Configured the Golden Gate application to extract and replicate Oracle application data to reporting environments.
• Set up users to access applications through Access Manager in the test environments using IManager and Confidential to update Edir.
• Extract subset of data from production, Encrypt and Decrypt sensitive data, load to testing environments and synchronize with data from other billing systems
• Supported the Cognos application for testing reports
• Developed workflows, sessions and mappings to shakeout procedures to test relation connection in all Informatica applications
• Configured the WNP test servers to connect to Synerverse for port-in/port-out requests
• Upgraded Amdocs Enabler test environments each time a new build is delivered:

TECHNICAL SKILLS:

Hardware: - Cisco UCSB-B200-M3, HP ProLiant DL360 G7, Range of IBM blades and UX servers, Oracle UX servers, VMware Windows Server

Operating Systems: - AIX 7.1, SuSe Linux 12, HP UX -11, Solaris 10, Oracle Linux 6.8, Red Hat Enterprise Linux 7.3, Windows 2000, Windows Server 2016

Databases: - ORACLE 11.2, EXADATA

Software /Tools: - Informatica - Power Center, Jakarta, Apache, Remedy, Citrix, Maestro, Java, JDBC, Ant, MFT, Maestro, IManager, Edir, Perl, Syncsort, Websphere, Tuxedo, Weblogic, Oracle, Splunk, Cognos, Python, Hadoop, Ingrain

PROFESSIONAL EXPERIENCE:

Confidential

Senior Systems Analyst/ Programmer Analyst

Responsibilities:

• Scheduled table refresh and distribution to coincide with implementation mandated by MOPs.
• Configured priceplans, Socs, Features, OTC, Discounts, Promotions etc to meet Product Development and Marketing needs in the various regions of the country based on eligibility rules through the client interfaces.
• Configured the serving and destination areas for Toll and Airtime charges as governed by PMN/BID
• Ensured all relevant information are in tables for A/R, Collections, Billing and Confidential .
• Lead team on the resolution of all billing and activation issues.
• Prepared scripts to credit customers by investigating usage, adjustment and charge tables.

Confidential

Responsibilities:

.

• Build shell script to transfer files from various sources to DB applications.
• Prepare settlement report scripts for Confidential and Confidential .
• Maintain Java code for the Push To Talk wireless application
• Build Outcollect and Incollect application in Java for CIBER and TAP records to and from Syniverse Clearing house.

Confidential

Senior Systems Analyst

Responsibilities:

• Scrutinized the Business Requirements documents, Met with business partners and prepared Detailed Functional Requirements Documents, Design, WBS and schedule.
• Analysed and provided Impact Assessments to changes that affect the global data dictionary, data layers, user and process layers.
• Created, modified and generated domains by adding and modifying records in the tables of the Domain Dictionary to allow specific program language (C, Cobol, SQL) to include the applicable structures Confidential implementation.
• Built servers and clients (in C ) to use Confidential Tuxedo synchronous and asynchronous calls to communicate among local services and between local and remote services.
• Wrote C shell scripts to prepare the environment and call the specific COBOL programs to reference the environmental variables exported by these scripts.
• Modified the data layer by building C functions with embedded SQL, PL/SQL code to select data into cursors and update records in the database.
• Administered the file transfer mechanism between the Mainframe GL system and Unix.
• Developed and maintained many Configuration Control environments for the development of the Amdocs Billing Preprocessor.
• Prepared UNIX Korn and C shell scripts to create team and programmers building blocks for specific versions.
• Used the CC-related scripts provided with the software to manage source files through Confidential .
• Built the Standard File Interface to automatically transfer files between the billing system on Unix server and external systems in many environments.
• Designed the system to capture the essential information for each transmission through a configuration file.
• Coded and built the structured multithread system in C on HP Unix comprising over 10 major functions separately implemented.
• Documented and obtained approvals for baseline documents from all stakeholders.
• Provided the detailed Operating Instructions to production support.
• Responsible for all stages of the life cycle for the External Interfaces ( real time) to Amdocs Billing system including links to the Credit Bureaus, Banks (lockbox payments and Credit Card), Collection Agencies, Dialer, Fraud Buster and Address verification sites. Provided support and facilitated changes through project management over time.
• Identified Requirements, prepared tasks (WBS) and obtained resources (Vendors/local) to meet the objectives within time and budget
• Analyzed the system needs, required changes and impacts and prepared accurate pseudo-code.
• Designed the architecture of the real time system and maintained the structure of all fields on the interface record.
• Developed the real time, multithread Tuxedo application in Visual C++ taking requests from clients, formatting requests and sending to credit Bureau, analyzing, storing and sending back response to clients.
• Installed and configured the system on Windows NT/2000 servers.
• Coded Web Focus programs to produce reports from Credit Evaluation activities.
• Built a simulator in Unix C to emulate transactions from the billing system for Unit testing
• Performed the performance and functionality tests for all changes.
• Prepared all relevant documents including - Requirements, Contingency, Design, OI, SLA, DRP.

Confidential

Application Tester and Conversion Analyst

Responsibilities:

• Configured the testing environment for the Human Resources Information System in Power House running under AIX UNIX. Customised the Shell and set up environments to point to the relevant version of the Sybase databases. Administered security to allow authorised users access to particular areas of the system.
• Prepared over 15 payroll jobs by writing Unix Korn shell scripts with embedded SQL to extract and populate tables in Sybase - Populated reference tables, updated attendance information, calculated pays and updated history tables.
• Wrote the manual for all users of the system. Monitored system activities and identified processes that required intervention. Tested all modules as per user requirements.
• Analysed data from parallel runs for Payroll implementation.
• Scheduled daily, weekly, monthly and annual jobs for processing. Maintained and supported all users on devices attached to IBM mainframe and RS6000 used for managing the financial and student information systems Confidential the Board. Controlled quality of all reports including cheques, report cards, work permits etc.
• Supervised operators in various shifts of the operation cycle
• Wrote Job submission programs in Confidential and EXEC2 for batch processing, incorporating Confidential, data and special parameters from users and various libraries.
• Wrote COBOL programs for Confidential and VSE; extracted data from Oracle database using SQL.
• Wrote job streams ( Confidential ) for batch processing, utilising software packages for Cataloguing, Managing files, Sorting and Printing.
• Effectively managed the computer laser printers (2 Confidential 4850s) by providing superior quality reports by designing forms and using Print Description Language (PDL) to control the data stream on the printed form.
• Maintained data libraries, responsible for deleting unnecessary keep file to accommodate required workspace for production jobs.

Confidential

Economist/Systems Programmer

Responsibilities:

• Gathered data, analyzed and prepared sections on Inflation, Balance of Payments, GDP, Exchange Rates for the Bank’s Annual Reports and Quarterly Economic Bulletins
• Developed and maintained the Quarterly Indexes on GDP, Effective Exchange Rates and Consumer Price Index for the country
• Maintained the 16 Confidential tables for Confidential
• Installed and configured VM and Confidential
• Automated tasks using Confidential .