Resume

Sign in

Data Analyst

Location:
Corona, California, United States
Posted:
January 17, 2018

Contact this candidate

Elias Dagher

(951) ***-****

ac32o5@r.postjobfree.com

Summary of Skills

Extensive knowledge and experience analyzing data and creating reports in multiple versions of SQL, comprising of MS SQL, Informix, and Oracle.

Possesses an understanding and extensive experience with relational database design, concepts, and terminology.

Identified, analyzed and interpreted trends and patterns of data sets to figure the correlation of the data files.

Large data Analysis and conversion, data cleansing, production report generation, and upholding scheduled data delivery standards.

Migrated credentialing, medical licensing, and educational data from various sources to SQL databases on AS400 Server.

Performed data validation to ensure accuracy and quality of healthcare-related data.

Provide technical Support on Epicor/Prelude ERP System for users across the USA, Canada, and UK.

Work Experience

Business/Data Analyst (Contract)

Robert Half IT Staffing onsite at Silverado Medical, Irvine, CA

January 2017 to July 2017

Assisting Client with Filtering and Data Cleanup/Management using Excel Formulas and Pivot tables to prep the Accounts, Contacts, Leads, Referrals and any additional information to upload to CRM (Salesforce).

Interact the various data sources by mapping it to Community, Market, and Region and matching Accounts, Contacts and ID's to other sources of Information.

Generate Reports in CRM and using SQL to select data from various tables.

Identify, Analyze and interpret trends and patterns of data sets to figure the correlation of the data files.

Create a clear mapping of data in order to import the key fields into Salesforce.

Writing quick documentation to identify issues and resolutions.

Utilized Excel and Access Database to generate metrics/budgets/dashboard and Statistical formulas to create summarized reports and some exposure to creating Macros in VBA.

Provides support to project team or management by collecting and analyzing data and reporting results.

Collaborate with various functional/operational/telecom teams to generate deviations and statistical reports.

Pick Programmer/Analyst

KLX Aerospace

February 2016 to September 2016

Review and analyze organizational business needs; confers with users to evaluate requirements, discuss solutions, and develop a plan of action.

Working as part of cross-functional teams to do ongoing maintenance and analysis of applications systems and programs.

Manage research and analysis projects in a cost and time efficient manner using most appropriate tools.

Identifies problems and develops proper solutions using Unidata, Pick and System Builder

Perform all aspects of systems design including writing required programs, testing, and evaluation of new processes and implementation of new applications.

Conduct or coordinate user acceptance, performance stress, regression, and integration.

Unit and performance testing and user support for the daily accounting and month end issues.

Maintaining and documenting issues, non-technical and technical documentation.

Business/System Analyst/Data Analyst

PoolCorp Inc.

July 2014 to February 2016

Provide technical Support on Epicor/Prelude ERP System for users across the USA, Canada, and UK.

Worked with multiple datasets to generate financial reports using Excel formulas, Macros and Pivot Tables and Access 2013 Database to join and merge data from tables using Queries and generate reports.

Establish patterns to reoccurring issues and provides input to development teams.

Testing of distribution applications and maintaining source Code control.

Utilize internal and external data sources to derive customer insights through analytics.

Assist team members and give support and solutions to customer queries to meet company goals.

Worked with and integrated various types of data and turned information into doable initiatives. The ERP system developed and maintained in Universe (U2) Pick Technology.

Security compliance reviews and works closely with stakeholders on SOX Audit.

Writing “How To” Documentation for users and publishing them on the web.

Working as part of cross-functional teams to do ongoing maintenance and analysis of applications systems and programs.

Manage research and analysis projects in a cost and time efficient way using proper tools.

Identifies problems and develops proper solutions using Unidata, Pick and System Builder

Perform all aspects of systems design including writing required programs, testing, and evaluation of new processes and implementation of new applications.

Conduct or coordinate user acceptance, performance stress, regression, and integration.

Unit and performance testing and user support for the daily accounting and month end issues.

Maintaining and documenting issues, non-technical and technical documentation.

Informix Developer/Data Conversion Analyst

Gillani Consulting Services

August 2008 to currently on call

Maintained financial and distribution applications using Informix 4gl, SQL, and GUI.

Developed custom screens and reports for their clients i.e. AT&T using Informix 4gl, SQL, and GUI.

Handled and troubleshoot issues for Accounts Receivable and General Ledger.

Conversions of old Legacy system data into IDistribute and creating scripts and handling Installation of the Supply Chain Management Software on AS400 Epicor/Prelude ERP System.

Pick System Programmer

Quest Diagnostics

August 2013 to March 2014

Developed and maintained the AR Billing System using Pick and Unidata.

Generated and modified reports and screens per user requirements.

Generated complex programs for the CPT code Extracts and export to Excel.

Contributed to the improvement of existing programming techniques and applications

MySQL Data Analyst

Revshare

May 2013 to August 2013

Created and ran scripts in MySQL generating reports in Crystal reports for their Marketing Campaign ads and sales leads.

Data Manipulation in Excel to prep data in order to export to Crystal Reports.

Analyzed and Imported data into Excel and used Pivot tables to create reports on sales, profits & losses.

Generating Profit and Losses Reports using Excel.

Information System/MySQL Data Analyst

Applied Statistics Management

April 2012 to July 2012

Maintained the current database and provide accurate reporting.

Migrated credentialing, medical licensing, and educational data from various sources to SQL databases on AS400 Server.

Large data Analysis and conversion, data cleansing, production report generation, and upholding scheduled data delivery standards.

Performed data validation and maintained data to ensure accuracy and quality of healthcare-related data.

Conducted research and collected data ensuring continual product development meeting client needs.

Performed analysis of client data and worked closely with colleagues to try and identify data related problems and solutions.

Wrote SQL Scripts to manipulate and interpret data sets in Excel using formulas and pivot tables to populate various tables in MS SQL Databases.

Tools used: Excel, Access, and MSSQL Server (Database, TSQL, SSIS and SSRS).

System Analyst

Minerva Software, Inc.

October 2011 to April 2012

Maintained the current Inventory Management Software in Magic and XML.

Custom Changes to screens, reports and screen utilities.

Maintained and generated Inventory Custom Reports in Magic software but using Oracle and MS SQL in the background based on the business requirements.

Programmed the RF guns Menus and screens in Magic Software.

Interfaced with SAP tables to build reports and screens for clients.

Fixed Bugs, Troubleshooting and Modifications and testing Reports and Screens.

Data Analyst /Sr Developer (Informix/Pick/Universe (U2)

Keystone Automotive, Inc. (Aftermarket Automotive)

January 2001 to July 2008

Main responsibilities to design/maintain/test code in Informix 4GL/SQL and FourGen.

Developed, wrote and maintained complex programs leveraging Universe (U2) Pick technology.

Conversion of the legacy system to import data into Informix database and write data conversion code in Pick to Port data over to Prelude ERP System.

Worked and partnered with internal teams to define and design robust and user-centric application solutions.

Collaborate closely with users and team members in our joint effort to provide an excellent and reliable solution.

Full research, design, planning, and implementation of Large Data Migration.

Maintained the Activant/Prelude Accounting and Distributions Applications using Pick, System Builder, and Quick Basic.

Generated Financial Reports by using Excel and Access Database.

Uncovered users requirements and clearly articulate to others.

Able to conceive innovatively and produce creative solutions to user's issues.

Performing business & data analysis, business data modeling, and assisting in all aspects of developing projects and ensuring its deliverability in a timely manner.

Worked with multiple sources of information, aggregate, and produce data sets for analysis.

Generated codes and custom screens as reports in Character and GUI Base.

Ability to navigate and get the job done in a matrix environment.

Sound knowledge of budgeting and financial processes and Sox Audits.

Wrote and updated documents, including technical specs specifying tables and attributes followed by implementation and QA Testing.

Effectively engaged IT and with non-technical end users and Sr. management.

Actively partner with all levels of the organization and translated communications into achievable goals.

Perform Security Compliance reviews, QA testing and Sox Audit of financial programs.

OS: AIX and Solaris.

Education

Bachelor of Science in Computer Science, California State University, Fullerton, CA

Recent online training in Advanced (Excel, Access Database, SQL) and Tableau



Contact this candidate