Arturo Vargas Venegas Email & Phone Number

Greater Los Angeles Area

Greater Los Angeles Area

Expert in using OBIEE Answers to create ad-hoc reports with added user interactivity.Develop KPI focused dashboards in OBIEE using drill down, prompts, filters and variables.Create and maintain ETL processes to load data from various sources such as Access database tables, Oracle 11g tables, Excel spreadsheets, and flat files.Schedule jobs utilizing SQL Server Agent to fully automate the execution of various SSIS Packages and stored procedures.Automate daily, weekly, monthly, and quarterly reports using MS SQL Server and Excel.Adept in writing simple to complex T-SQL queries.Build, update and maintain ASP.NET web dashboards utilizing VB.NET and MS SQL Server.Produce Ad-Hoc reports and analyses utilizing MS SQL Server, Oracle SQL Developer, Tableau, OBIEE and Excel.

Long Beach, Ca

Supervised, mentored and led a team of Data Analysts through different processes and projects as well as day-to-day activities.Developed and implemented stored procedures, views, indexes, and other database objects for a Points of Interest Database.Designed and optimized complex SQL queries to extract and analyze data.Imported data from various flat files and transformed data in order to load into existing tables.Created Ad-Hoc reports emphasizing actionable insight to present to management.Worked with an external IT company in order to achieve the successful migration of an old production server from 2003 Windows Server to 2012 Windows Server.Performed regression and degradation testing to validate server and database migration.Successfully managed a reprogramming project that aimed to improve, modernize and refactor several in-house applications.Worked closely with software engineers in an agile setting to review functional specifications, business requirements, and design documents.Maintained relationships with vendors and periodically set-up meetings to provide feedback, discuss issues, and monitor quality of products and services received.

Irvine, Ca

Worked closely with management and clients to analyze and identify business requirements for various data extraction projects.Analyzed web sites and determined best approach for development of agents that will extract valuable data.Assisted in the development of several SQL Server Database tables to hold extracted raw data from the web.Developed project plans with milestone timelines to present to both management and clients for various projects.Normalized and cleaned extracted data in order to meet client requirements.Performed analysis and QA checks on extracted data sets in order to insure quality.Maintained, updated, and added functionality to existing web crawling agents as requested.

Long Beach, Ca

Wrote T-SQL queries using Microsoft SQL Server 2008 to retrieve and analyze data for quality control and assurance.Extracted and analyzed data from a Microsoft SQL Server database to provide reports that showcased actionable insight.Utilized various excel formulas such as: VLookups, IF Statements, CountIFs, and SumIFs to analyze data and create reports.Compiled and summarized data in pivot charts to create easy to read reports and graphs.Developed and improved data collection procedures.Trained new analysts on how to use excel formulas, execute SQL queries, and follow processes for GM and Toyota Navigation Production.Performed monthly comparison analysis on supplier data to highlight data issues and recommended improvements.Generated standard operating procedure documents for several routine job activities.

Provided excellent customer service to both internal and external customers. Executed daily order exception reports. Utilized SAP CRM system to log customer interactions.

Pulled orders for various Circuit City Stores. Assisted in the e-commerce department and product return center