Oneco Careers

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, T-SQL, 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 ad-hoc 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 On-Demand 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 problem-solving 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) Hewlett-Packard (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 Bachelor's Degree,Information 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 team-builder 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!