prod testing

Octavio Melo

Data Analyst at ServiceSource

Current

Data Analyst

Past

Business Analyst

Localization Test Engineer

Business Reporting Analyst

SQL Developer

Application Support Engineer (II Level)

Education

Universidad de Guadalajara

Recommendations Received

LitjiHu

Summary

Microsoft certified IT professional with more than eight years working for global companies with wide experience on Data Analytics and Business Intelligence.

Specialties:

Data Engineering Data Analysis Data Visualization Data Modeling Scripting ETL

Reporting and Databases (RDBMS OLAP NoSQL).

Tools:

MS SQL Server MySQL MongoDB TSQL SSIS SSRS SSAS Excel QlikView Tableau

GoodData CloudConnect CloverETL Boomi Shell JavaScript Crystal Reports JSON/XML web services/APIs and VBA.

Experience

Data Analyst

ServiceSource

(Public Company;Information Technology and Services)

12/2012 Present

Design of data flow data transformation from client systems into the Renew OnDemand platform

Design and development of client specific reports metrics and dashboards.

Configure ETL tools data mappings and connectors using integration products to orchestrate data integration. Manage data validation issue identification and issue resolution

Aid in data research and data support requests.

Develop and maintain shell scripts in Unix environment.

Cloud automation solutions using JavaScript (node.js) MongoDB and GoodData.

Perform complex data analysis in support of adhoc and standing customer requests.

Develop programs methodologies and files for analyzing and presenting data.

Use and support database applications and analytical tools: evaluate data quality applications and functions produce output maintain data assets

Research new data sources and analytical tools; contribute to new product development and improvement in product delivery and presentation.

Develop awareness of and familiarity with issues and events affecting SSI data assets.

Develop and Maintain SQL SSIS Packages.

Develop and Maintain SQL SSAS OLAP and SSRS Reports.

Create and design Excel dashboards.

Business Analyst

EF Education First

(Privately Held;Education Management)

4/2011 10/2012

Provide OnDemand reports and analysis to business owners.

Responsible for developing and maintaining a scalable reporting solution on QlikView and SSRS.

Set up and design an ETL process KPIs and Dashboard on QlikView documents.

Act as a problemsolving intermediary between the business owners and data itself. Identify data quality issues and their root cause.

Support proactively product manager and business owners by identifying and flagging remarkable situations.

Localization Test Engineer

Neusoft

(Public Company;Computer Software)

8/2010 4/2011

To perform localization (l10n) and internationalization (i18n) create and maintain test plan and test cases. Set up the test environment Identify report bugs and verifying bug fixes. Analyze the problems of the products provide relevant and constructive solutions for problems solving. Coordinate and work closely with other language teams and ensure the testing results on different platforms and for different languages.

Business Reporting Analyst

Dell

(Public Company;Information Technology and Services)

6/2009 6/2010

Crystal Reports Developer MS SQL server Store procedures creation. Database Data dump scripts creation/modification and DB Maintenance. Analysis Creation Implementation and support of metrics and operation Reports.

SQL Developer

Panacredit

(Privately Held;Information Technology and Services)

1/2008 6/2009

Creation enhancement and implementation of Store Procedures triggers Views jobs. Bug fixing. Analysis creation modification and layout designing of reports. ETL process for application interfaces ASP creation/modification and resolution of Complex tickets related in backend and frontend code.

Application Support Engineer (II Level)

HewlettPackard

(Public Company;Information Technology and Services)

9/2006 8/2007

Monitoring of data processing and transmission incident and problem management design installation and operational support for changes and new versions of software Implementation and development of application management processes. Monitor the HP software load system network including file servers and SQL servers attempt to identify and resolve issues proactively Distribute & install new releases of HP Software tools within the HP system network Maintain all applications and platforms according to HP security rules Identify recurrent problems and help users from Americas EMEA APJ regions to resolve them

Education

Universidad de Guadalajara

Bachelors DegreeInformation Systems.

Recommendations

Recommendation Type : colleague Recommender : Litji Hu

I know Octavio since March 2011. We have worked in the same team for a Nokia Project of localization and internationalization. He has strong skills for dealing and finding efficient yet quick solutions to problems on daily work tasks. Above all he is a great team worker always willing to give a helping hand and an excellent teambuilder to favor newcomers integration.

Furthermore his language skills (fluent English and native Spanish) eloquence at team communication high knowledges about general culture and especially in IT field patience and stable mood under stressing working environments makes him a precious employee for any company looking for a serious professional committed to his job.

I was lucky to have the chance to sit next to him since I got onboard and during the whole time we coincided at Neusoft. By this I had all what I needed to learn rapidly and smoothly about my brand new position (at that time). Thank you Octavio!