Artificial Intelligence Engineer - Intelligent Predictive System - AMDOCS Date: August 2020 – June 2023 - Design of an Intelligent Predictive System which will immediately help telecommunications companies obtain results that generate greater economic income for telecommunications companies by maintaining customers who can potentially leave the company.
- Identification of input attributes for the neural network. A database of 20 million customers was used to identify attributes and train the neural network.
- Exploratory Data Analysis (EDA) was performed to analyze and investigate data sets and summarize the main characteristics of a telecommunications company's customers.
- Using Python, a Neural Network was implemented using Keras and SKLearn libraries. The Neural Network consisted of 6 Dense layers, configured with ReLu and Sigmoid activation functions.
- 16 million clients were used for Neural Network training and 4 million clients were used for Neural Network evaluation tests.
- With an accuracy of 76%, the Intelligent Predictive System project was presented to the Management of Amdocs Services, which is estimated to help telecommunications companies retain almost 4 million customers per year, which would mean maintaining an income of almost 1.5 billion dollars a year.
Invoicing Product Owner AMDOCS for AT&T México Date: May 2020 – Present - Attending ATT meeting to get the requirements and analyze the impact in Invoicing application.
- Provide Invoicing solutions to new work requests.
- Creation of Impact Assessment for new work requests.
- Define the Epics, Features and User stories for Invoicing solutions.
- Calculation of Effort Estimation for every User Story, Feature and Epic.
- Provide cost of Invoicing solution.
- Follow up of development tasks.
- Acceptance of completed User Stories and Features.
- Documentation of all new developments in Invoicing application.
- Managing the product backlog
- Collaborating with Scoping and Customer team to define the best solution/product.
- Define a sprint goal, determine what backlog items to include in the sprint.
JAVA J2EE / UNIX / PLSQL DEVELOPER / AMDOCS for AT&T México Date: October 2018 – May 2020 - Leading Invoicing Application
- Development of new functionalities for Invoicing application: Restructure of customers installments to new subscribers, enhancement of tax calculation in charges creation process, implementation of new functionality to charge annual device fees for new and existing customers, enhancement of a balance calculator in REST API for cancellation module, implementation of a REST API to calculate the due date of customers, implementation of a new REST API to update the serial number of the sold devices.
- Implementation of new daily jobs to: charge annual device fees and generate new journaling reports.
- Support to new functionalities implemented in past Iterations for Invoicing application.
JAVA J2EE / UNIX / PLSQL TECHNICAL LEAD / AMDOCS for ATT&T USA / México Date: March 2016 – October 2018 - Production Support T1 for AMDOCS Billing System for ATT&T Uverse Project which consists in following applications in USA: CM (Customer Manager), Invoicing and Billing Formatter.
- Leading Mexico Team for developing, fixing and implementation of AMDOCS Billing System for ATT&T México Project which consists in following applications: CM (Customer Manager), Invoicing, AmDD (Amdocs Document and Design), SRM (Subscriber Resource Manager), AR (Account Receivable) using internal Amdocs Framework, Spring, Oracle, SOAP Webservices, JSP.
- Development of a module to send emails to alert for pending customers which needs to be billed using Shell Scripting and PLSQL.
- Development of a module to get statistical and measurement reports of monthly billed AT&T customers using Shell Scripting and PLSQL.
- Development of an Oracle function in PLSQL to synchronize customers between AT&T front end application and Amdocs Billing application.
- Creation and following up of incidents in Billing applications using HP Quality Center and AT&T Webtrax.
- Managing the daily billing cycles of AT&T customers, running processes to extract customer billing information, fixing rejected customers, and providing the PDF invoices to AT&T customers.
- Development of a module to get the report of the financial accounts and amounts from AT&T Customers using Shell Scripting and PLSQL.
- Development of a J2EE application (using Spring, Hibernate, JSP, AJAX, JQuery) to load the telephone numbers, SIM, IMSI and UFI resources provided by AT&T in a flat text file. The resources are loaded by a batch process develop in shell scripting to an Oracle database.
- Development of a Java application to validate the XML invoice files have the correct customers’ information.
- Daily daemon / process monitoring.
JAVA J2EE TECHNICAL LEAD / Senior Project Engineer – Wipro Technologies for CITI Date: February 2014 – March 2016 - Performing Java/J2EE interviews to candidates for Mexico team in A-Series BAU Brazil project.
- Leading Mexico Team for A-Series BAU Brazil project which is developed in Struts, EJB, MDB, Oracle, PL/SQL and html/javascript/JSPs.
- Leading weekly meetings to follow up the status of KT for new hires, reviewing of project status in Mexico team and giving the weekly status to the Project Manager.
- Implementation of best practices in Mexico Team for software development and software delivery according to ITIL and Agile best practices.
- Development of a Webservice module which lets to set the entitlement of the users when they login into the ACIS application through A-Series. This module was implemented using Restful Webservices.
- Development of a new requirement which consists on loading databases with the information of special customers. In front end, it was created a new screen to capture the special customer details which are stored in a new table. These changes implied to change the workflow and to create a new stage before calling the CDN review auto stage. Technologies used: Front-End (JSP, AJAX, AngularJS), Back-End (Spring, EJB, DAO), Database DB2.
- Development of a new flow to generate a new report in ACIS to view the details of applications entered through CMC online in order to know the details of failed and rejected credit cards applications. Technologies that were used to complete the new flow were: Front-End (JSP, AJAX, jQuery), Back-End (Spring, EJB, DAO), Database DB2.
- Development of stored procedures for synchronizing ACIS customer data and requested update of customer information.
- Leading 5 resources which are assign in ACIS/ACWS, OneDispute and OneEclipse projects.
- Provinding daily and weekly status reports to stakeholders about ACIS/ACWS and OneDispute projects.
- Development of new functionalities for OneDispute project which is built in OneEclipse framework. Technologies used in OneDispute project: OneEclipse, JSP, DAO, Oracle Database, javascript.
AB INITIO ETL TECHNICAL LEAD / IT Specialist – Wipro Technologies for CITI Date: August 2015 – January 2016 - Leading AB Initio team for migrating a Data Warehouse application from Cobol to AB Initio for Conversion Brazil project.
- Project Lead for “Enhance Extractors for Sales Practices” with 4 assigned resources.
- Attending meeting with PM, Customers and Stakeholders to provide status of project development.
- Project Schedule Planning for the tasks that covered from Project Acceptance to Project Implementation.
- Analysis and design of: scheduled jobs in Autosys, AB Initio ETL processes and database solution in Teradata.
- Reviewer of AB Initio development and database architecture in Teradata.
- Programming of scheduled jobs which run ETL processes using Autosys.
- Development of Integration Tests.
- Migrating AB Initio ETL graphs from SIT to UAT.
- Reviewer and tester in SIT/UAT environments using test cases.
- Requesting Incidents and Change Requests to implement solution in the different environment from DEV to PROD using CITI Change Management Tool.
CONSULTANT, JAVA J2EE DEVELOPER / IT Specialist – Grupo CINTE for IBM Date: December 2012 – January 2014 - Support and maintenance for the project: Order Status OnLine application (On Going Support) which implements Struts 1.2, Spring, EJB 2.0. OSOL users data are stored in a DB2 database and IBM MQ Broker is implemented as an architectural pattern which mediates the communication between OSOL application and an internal API which is able to connect to a DB2 database that stores all the orders and reports related to IBM customers.
- Development of a module to download the results after performing searches of orders in OSOL application. The results are saved in some of the following files excel, XML, cvs or html file depending on the customer selection. The developed module includes JSP, struts, spring, java classes, javascript, DAO.
- Analysis of data issues. When OSOL displays wrong data that are provided by an internal API through IBM MQ Broker, some tests need to be performed to validate that wrong data are not a Front-End issue. Once it is validated, the issue is transferred to Back-End team for tracking and solving the issue.
- Testing of OSOL application when window maintenance is scheduled. Test cases are performed every weekend to verify that OSOL applications and all its functions are working correctly due to window maintenance.
- Analysis, modeling and documentation of the Business Process that is related with the registration of customers which need to administrate, the Business Partners profiles, and to look for their active orders in OSOL applications. The process design documentation was developed using Business Process Management Notation (BPMN 2.0) and the related documents were developed using Supplier Input Process Output Client (SIPOC).
- Analysis, modeling and documentation of the custom reports process that is related with the reports which are scheduled to be sent to customers’ email. The process design documentation was developed using Business Process Management Notation (BPMN 2.0) and the related documents were developed using Supplier Input Process Output Client (SIPOC).
CONSULTANT, JAVA J2EE DEVELOPER / Production Support - TATA Consultancy Services for Bank of America Date: April 2012 – November 2012 - Support and maintenance of two banking applications: Roll Over Monitoring (ROM) and Inter-Company Loan Services (ICLS). Both applications were implemented in Struts 1.2 framework. The persistence between the applications and the database (DB2) was implemented through the Hibernate v3.0 framework.
- Development of a module to record the last login date of ICLS users into the DB2 database which stores all the users' information. The last login dates are shown to administrators when they are doing users maintenance.
- Development of a standard alone application to get a report of the users who use ICLS application. To access to users data, Data Access Object (DAO) design pattern were implemented. DAO provided an abstract interface to the DB2 database as a persistence mechanism and it helped to provide some specific data operations without exposing the details of the DB2 database as its connection.
- Data Sanitization in development and test environments. This module helps to hide sensitive data from users who use the ROM application in SIT and UAT environment. The algorithm used for hiding the sensitive data was shuffling which consists in shuffling the data randomly within the columns.
- Assistance in the migration process from old servers (Weblogic 10.x, Web Application Server, Java 1.4, SunOne), in which ROM and ICLS applications are installed, to new servers (Weblogic 12c, apache, java6, Linux 5.5).
- Solution to some security issues which were found in ROM application by IT support area.
CONSULTANT, JAVA J2EE DEVELOPER - TATA Consultancy Services for General Electric Date: March 2011 – April 2012 - Development of an application which parsed XML files to get many types of reports that were defined in a XSD file. For developing this application was needed a library for generating and doing the parsing. In addition, JAXB was selected as the library which helped me to generate the necessary java files from the XSD and, then, for reading and parsing the XML files. After getting the reports, some files are created to be read by the Informatica team who uses those reports to insert them into their database.
- Development of General Electric Corporate Site in the Treasury area with TIBCO Tool to create pages and portlets which were subscribed in each page of the site. The site implements portlets, Data Bases connections, JavaScript, JQuery and AJAX.
- Development of a Searching module for GE Treasury portal which is integrated with Google Search Appliance. The XML results which were sent by Google Search Appliance were parsed to HTML with XSLT templates.
- Content Management for GE Treasury portal with Portal Tibco Content Publisher.
CONSULTANT, JAVA J2EE DEVELOPER - HB for Banco Azteca Date: Oct 2009 – March 2011 - Analysis, development and implementation of a Web Service client for parameterized payment services in the Banco Azteca website. The web service client gets the available references and it validates the reference to know if it is correct before doing the payment with the service provider such as GDF, Telmex, Movistar, Iusacell and many other service providers that have a contract with Banco Azteca. Then, the payment is discharged in the treasury system and in the web service. The module, which was developed, implements jsps, struts, web service (axis2, jax-ws, SOAP Webservice), bank transactions, a module for sending emails, PDF generation, validation of transactions through a token or a biometric device.
- Revision and modification of all flows in Banco Azteca website for implementing an RMA module which identifies the company that access in the portal for making some transaction reports of the transactions that were done through the internet banking. The revised flow includes EJBs, JSP, Java classes, and servlets.
- Development of a Java application for sending mass emails to the users which are registered in Banco Azteca website.
- Development of a module within Banco Azteca website for sending some notification emails when the users add new accounts, telephone numbers, frequent transfers or beneficiaries.
|
