João Pires

João Pires Email and Phone Number

IT Consultant @ Bank of America Merril Lynch @ Bank of America Merril Lynch
charlotte, north carolina, united states
João Pires's Location
Ireland, Ireland
João Pires's Contact Details

João Pires personal email

About João Pires

Specialties: Areas: Billing SystemsRevenue AssuranceDatabase DevelopingDataWarehousingDatabase Technologies: ORACLESQL Server Programming Languages and Scripting: PL/SQLT-SQLUNIX Shell ScriptCJAVAJavaScriptPython

João Pires's Current Company Details
Bank of America Merril Lynch

Bank Of America Merril Lynch

View
IT Consultant @ Bank of America Merril Lynch
charlotte, north carolina, united states
Employees:
250057
João Pires Work Experience Details
  • Bank Of America Merril Lynch
    Assistant Vice President, Programmer Prof Mkts, Band 5
    Bank Of America Merril Lynch May 2013 - Present
    Dublin
    Sales 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
  • Kennistranslations
    Translation Services Provider
    Kennistranslations Sep 2010 - Present
    Lisbon Area, Portugal
    Reviewing of technical and technological translations from English to Portuguese
  • Pt Sistemas De Informação, S.A.
    It Consultant – Revenue Assurance (Wireless + Wireline) Project
    Pt Sistemas De Informação, S.A. Oct 2011 - Aug 2012
    Lisbon Area, Portugal
    Revenue 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
  • Pt Sistemas De Informação, S.A.
    It Consultant – Rating & Billing Migration Project
    Pt Sistemas De Informação, S.A. May 2011 - Oct 2011
    Lisbon Area, Portugal
    Rating & 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.
  • Pt Sistemas De Informação, S.A.
    It Consultant – Rating & Billing Project
    Pt Sistemas De Informação, S.A. Jan 2009 - May 2011
    Lisbon Area, Portugal
    Rating & 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.
  • Pt Sistemas De Informação
    It Consultant – Revenue Assurance & Data Quality Project
    Pt Sistemas De Informação Oct 2006 - Jan 2009
    Lisbon Area, Portugal
    Data 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

Pl/sql Sql Data Warehousing Databases Etl Microsoft Sql Server Billing Systems Oracle T Sql Oracle Sql Data Quality Sql Server Java Sql*plus Business Intelligence Shell Scripting Oracle Sql Developer Revenue Management Unix Shell Scripting Sql Tuning Revenue Assurance Python Warehousing

João Pires Education Details

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?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

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.