João Pires Email and Phone Number
João Pires personal email
- Valid
Specialties: Areas: Billing SystemsRevenue AssuranceDatabase DevelopingDataWarehousingDatabase Technologies: ORACLESQL Server Programming Languages and Scripting: PL/SQLT-SQLUNIX Shell ScriptCJAVAJavaScriptPython
Bank Of America Merril Lynch
View- Website:
- bankofamerica.com
- Employees:
- 250057
-
Assistant Vice President, Programmer Prof Mkts, Band 5Bank Of America Merril Lynch May 2013 - PresentDublinSales Performance Reporting Project Development of ETL processes to support the CARRS (Custom SQL Server reporting system) using SSIS packages.Application maintenance of the CARRS tool: Creation/maintenance of database objects, Creation/maintenance of stored procedures in SQL Server.Development and Maintenance/Optimization of scripts in the following languages:T-SQL -
Translation Services ProviderKennistranslations Sep 2010 - PresentLisbon Area, PortugalReviewing of technical and technological translations from English to Portuguese -
It Consultant – Revenue Assurance (Wireless + Wireline) ProjectPt Sistemas De Informação, S.A. Oct 2011 - Aug 2012Lisbon Area, PortugalRevenue Assurance (Wireless + Wire line) Project at TMN (Mobile Operator – www.tmn.pt)Development of ETL processes to support the cVidya MoneyMap revenue assurance tool (www.cvidya.com). This was done in MoneyMap’s proprietary JavaScript modules and Informatica Powercenter.Application maintenance of the cVidya MoneyMap tool: Creation of additional tables, multidimensional cubes creation for discrepancies analysis (Using Microsoft SSAS) and dashboard support, Alarms and KPIs creation.Data discrepancies identification in the following systems: MSC (Partner Content Registering), GGSN (Roaming Calls), TAPIX (Roaming Invoice), FACTURIX (TMN Invoice Generation), IN (CDR source for almost all systems), DINO and MT BILLING(Mobile Contents, wallpaper, songs, etc), TAPIN (Roaming CDR format conversion), VOIP (TMN VOIP Service) and MSIPTV (MEO Service - Video On Demand).Development and Maintenance/Optimization of scripts in the following languages: PL-SQL(Oracle), JavaScript, Shellscript
-
It Consultant – Rating & Billing Migration ProjectPt Sistemas De Informação, S.A. May 2011 - Oct 2011Lisbon Area, PortugalRating & Billing Migration Project at TMN (Mobile Operator). Babysitting of the last months of the old Convergys Infinys Rating & Billing system (Maintenance and several ADHOC processes).Design and development of a few modules and interfaces of the new in house Rating & Billing System (HERA).Assisting the design and development of migration processes for migrating data from the old system to the new system.Overall assistance on several subjects to the development team responsible for developing the new system.The following languages were used: PL-SQL (ORACLE), ShellScript.
-
It Consultant – Rating & Billing ProjectPt Sistemas De Informação, S.A. Jan 2009 - May 2011Lisbon Area, PortugalRating & Billing Project at TMN (Mobile Operator - www.tmn.pt).Development, maintenance and optimization of interfaces in PL-SQL between the Rating & Billing system (Convergys Geneva 5.3, Convergys Infinys 3.0) and the EAI (TIBCO) system. (http://www.convergys.com/solutions/bss-oss/revenue-management.php).Intra-system database data discrepancies analysis and correction (Billing & Rating) as well as inter-system database data discrepancies (Billing & Rating – EAI(TIBCO) – CRM).Development and Maintenance/Optimization of scripts in the following languages:PL-SQL (Oracle), ShellScript, ProC.
-
It Consultant – Revenue Assurance & Data Quality ProjectPt Sistemas De Informação Oct 2006 - Jan 2009Lisbon Area, PortugalData Quality and Revenue Assurance Project (QDRA) at ZON TV CaboDevelopment of ETL processes to support the cVidya MoneyMap revenue assurance tool (www.cvidya.com).Aplicational maintenance of the cVidya MoneyMap tool: analysis and optimization of the existing processes.Data discrepancies identification in the following systems: CRM (Siebel), ERP (SAP), EAI (TIBCO), Provisioning (CEON, Sigma), Billing & Rating (Geneva) and network services and authentication (DHCP, Nagra).Analysis and correction of intra and inter system discrepancies on the above mentioned systems.Development and Maintenance/Optimization of scripts in the following languages: T-SQL (SQL SERVER). Python. PL-SQL (ORACLE). ShellScript
João Pires Skills
João Pires Education Details
-
Computer Science -
German & Finnish Languages
Frequently Asked Questions about João Pires
What company does João Pires work for?
João Pires works for Bank Of America Merril Lynch
What is João Pires's role at the current company?
João Pires's current role is IT Consultant @ Bank of America Merril Lynch.
What is João Pires's email address?
João Pires's email address is jo****@****ail.com
What schools did João Pires attend?
João Pires attended Universidade Nova De Lisboa, Universidade Nova De Lisboa.
What skills is João Pires known for?
João Pires has skills like Pl/sql, Sql, Data Warehousing, Databases, Etl, Microsoft Sql Server, Billing Systems, Oracle, T Sql, Oracle Sql, Data Quality, Sql Server.
Who are João Pires's colleagues?
João Pires's colleagues are Andrea Cato, Elena Perry, Rhoda Mohabir, Fran Pecoraro, Cody Kiechle, Cfa, Judith Ramirez, Uttama Hande.
Not the João Pires you were looking for?
-
Joao Paulo Pires Barreto
Dublin -
-
João Pires
Dublin -
1newlandchase.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial