Data Customer Service

E. Morales

San Jose, CA

************@*****.*** – 408-***-****

Participate in the planning and carrying out of testing activities for Integrated Data Warehouse projects using DevOps model. Testing activities include Functional Testing, Component and System Integration Testing.

WORK EXPERIENCE

INFOSYS

January 2018 – Present

Charlotte, NC

Consultant

Project Duration: January 2019 – Present

Description: Web Services Testing Lead in consumer banking, consumer profile, account repository and authentication applications being impacted in new functionality release. Data exchanges happen in real time, near real time and batch. Collaborate in work group meetings. Work with offshore team in the creation of test plan, test scripts, test activities in accordance with the design document.

Atlanta, GA

Consultant

Project Duration: April 2018 – August 2018

Description: Application software testing for BI DevOps team, ensure that BI Application is properly tested, pursue reliable and quality Data warehouse and Data marts, copy data from production to non-production environments, maintain test environments, perform Testing in QA Environments.

•Perform Ingestion and Export data validation including count validation, count logic implementation, table and schema validation, Impact Analysis, incremental load count, column description, column constraint.

•Validate S2TM (source to target mapping) functionality according to business logic, analyze SIS document, deploy code to Jenkins.

•Execute audit balance control jobs to perform data quality checks using a single framework Unified ABC REST API.

•Use Control M to maintain schedule of ETL jobs and restart-ability of failed jobs, perform debugging of issues with database, source file, incorrect structure, invalid data, rejected records.

•Upkeep testing activities, defect tracking and application lifecycle management (ALM) using Quality Center (HPQC) repository.

•Participate in daily Stand Up meetings, use Rally to review User Story and metric documentation.

•Interact with enterprise support via Reliance pier ticket for configuration, connection of Oracle, Hadoop, Teradata sources

Raleigh, NC

Training Duration: January 2018 – April 2018

Infosys formal training in Hadoop, a distributed framework to store and process big data. – Raleigh, NC

•Understanding of high performance, parallel computation using MapReduce.

•Understanding of the highly flexible data transformation using Pig.

•Understanding the use of Hive as a data warehousing tool.

•Understanding of MongoDB NoSQL flexible schema to handle horizontally scalable, unstructured data.

•Use of Sqoop to import/export from RDBMS to Hadoop, data warehouse and NoSQL systems.

BANK OF AMERICA - MERRILL LYNCH - MERRILL EDGE

January 2013 – December 2017

Senior Operations Specialist – Menlo Park, CA

May 2016 – December 2017

•Implemented client-focused operations and administrative functions within Merrill Lynch Global Wealth Investment Management.

•Rigorous adherence to internal controls and data governance of client and account systems in keeping with audit readiness.

Investment Specialist – Pennington, NJ

Jan 2013 – April 2016

•Series 7 & 66, delivered high quality customer service in Merrill Edge contact center trading platform while proactively identifying needs and opportunities.

•Order entry/execution, margin buying power, trade correction, maintenance call, quotes, new account, asset consolidation, tax reporting, money movement. Effectively resolved capital markets/brokerage consumer portal inquiries while safeguarding client security; in fast pace, high volume, pressure environment.

EDUCATION

Masters in Information Systems

New Jersey Institute of Technology

2016

SKILLS

Technical Knowledge

Technical: SoapUI, Hadoop QA, Teradata QA, SQL, Unix, HPQC ALM, Rally, Jenkins.

Data Mining: Weka, Jupyter Notebook, PyCharm, Eclipse, Python, OOP, Numpy, Pandas, Supervised and Unsupervised Learning.

Contact this candidate