SUMMARY

• Over 10 years of experience in IT industry and has an excellent domain expertise in Telecomm / Billing Domains.
• Worked extensively in TERADATA, SQL, UNIX, T - SQL and well versed with Teradata Utilities including BTEQ, FLOAD, MLOAD, TPUMP, Fast Export. good experience in Hadoop, Hbase, Hive, Sqoop and Oozie

TECHNICAL SKILLS

• Python Language, R, Windows, C++, Linux, Unix, BI, SQL, Postgres, SQLite, Teradata, Agile project management, BSS, VAS, marketing promotions and offers, telecom strategy
• Lean six sigma, ITIL, PROPS, Hadoop 2.x
• Oracle Report, OBIEE, SSAS/SSIS, Crystal Report, SQL, PL/SQL, T-SQL, ETL, Shell Script, R & Excel Pivot Table
• OWB, ODI, Informatica 8.6.1
• BTEQ, FLOAD, MLOAD, TPUMP, Fast Export, TOAD, SQL Loader
• Hadoop HDFS, Scala, Apache Spark, Apache ambari, Apache impala, Spark streaming, Spark SQL, Sqoop, Hive, Big, Kafka

PROFESSIONAL EXPERIENCE

Confidential

Teradata ETL Developer

Responsibilities:

• Work with Data warehouse and billing teams in order to create buckets for Revenue per customer per month and facilitate business departments analytical reporting
• Design and implementation of Cost and margin daily calculation as per customer requirements
• Extract the data from different sources and create revenue buckets adding all the customer attributes
• Work with finance team to map the revenue per customer to Confidential financial hierarchy
• Developed and tested Teradata BTEQ, Fast Export, Mload and UNIX shell scripts as per the requirements.
• Design and develop scripts for revenue, cost and margin calculation for Confidential consumer and business customers.
• Participate in increasing revenue as decision made through reporting and analytics on revenue, Cost and margin offering customers new promotions and discounts.
• Provide enhancements for customer journey to deliver offers that is personalized on customer profile and margin analysis

Confidential

Technical Lead / Business Support Manager

Technologies Used: Teradata, BTEQ, FLOAD, MLOAD, TPUMP, Fast Export, TOAD, SQL Loader, Unix, SQL, PL/ SQL, Shell Scripting, Oracle Reports, OBIEE, SSIS, Crystal Report.

Responsibilities:

• In charge of managing strong teams in IT department responsible for planning of all convergent Billing & VAS nodes.
• Managed a multitude of projects for Ericsson including but not limited to marketing offers and promotions with Zain Sudan, all Ericsson Nodes upgrades and new platforms
• Responsible for managing phases and offer negotiations
• Led projects using waterfall and agile methodologies and adjusting platform sizes to meet volume/capacity demands
• Responsible of all billing and charging projects and node upgrades
• Followed KPI’s with commercial departments and Ericsson making sure that all the incident are resolved within the agreed time
• Made sure all business processes were documented on a share folder, aligning IT services with Business Needs
• Manage and analyze convergent billing department daily, weekly KPI’s with all commercial departments making sure remedy system tickets resolved within the agreed SLA’s
• Responsible for handling CBIO business configuration (marketing products), Business requirements gathering and SRS formulation, doing the technical acceptance test for configuration before and after the cutover date
• Provided overall support to customer care
• In-depth knowledge of order management process,
• Interacted with the service order management team particularly focusing on fulfillment & solution by making sure the customer received the right product and solution
• Monitor all KPI of charging and billing system nodes and forecast for expansions
• Responsible for providing all the revenue, customer, returnees and churn dealer reports flags and configurations to DWH,RA and quality team
• Oversaw website for monitoring KPI’s that compares years, months, days and even hours of all the traffic types and subscriber all activities
• Responsible for communication with customers, and various departments to assess customer needs while being involved in all phases of SDLC (Software Development Life Cycle) and operational issues diagnostics
• Responsible for the development of procedures for software testing and troubleshooting
• Managed client matters related to projects and evaluate solutions to determine whether customer requirements are met efficiently and effectively

Confidential

Team Leader

Responsibilities:

• Define and assess business drivers including value/reasons for solutions, options, dependencies and constraints.
• Lead the technical design of solutions and delivery of solutions including development, integration testing, quality assurance, user acceptance and deployment.
• Implement all marketing Products and Promotions as per requirements.
• Identify products requirements and make sure that designs meet requirements
• Responsible for Managing suppliers & vendors billing and issues.

System Analyst

Confidential

Responsibilities:

• Responsible for loading, extracting and validation of client data.
• Liaising with end-users and 3rd party suppliers.
• Interfaced with business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR). Created test cases and test scripts.
• Ensured all artifacts complied with corporate SDLC Policies and guidelines.
• Analyzing raw data, drawing conclusions & developing recommendations
• Writing SQL, PL/SQL scripts to manipulate data for data loads and extracts.
• Developing data analytical databases from complex financial source data.
• Working with colleagues to ensure the smooth transition of all enhancements and major projects through to support.
• Work with project managers to ensure that data entry, retrieval, change and delete functions meet business requirements for project completion.
• Designing, developing and implementing new functionality.
• Monitoring the automated loading processes.
• Focus on data analysis and data manipulation to assess the state of all internal processes
• Assist senior leadership in developing service level agreements (SLAs) across Client Services
• Design and maintain productivity reporting structures for the global Client Services team
• Produce ETL design guidelines to ensure a manageable ETL infrastructure for the BI system.
• Troubleshoot BI tools, systems, and software; performance-tune these applications as necessary.
• Evaluate and select database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions.
• Conduct research and make recommendations on BI products, services, and standards in support of procurement and development efforts.
• Develop and maintain installation and configuration procedures.