Data Developer

BARBARA J. DILUCCHIO

949-***-**** Trabuco Canyon, CA ada2aw@r.postjobfree.com https://www.linkedin.com/in/barbara-dilucchio/

Software Tester Data Analyst

DATA WAREHOUSE / ETL DEVELOPER JUNIOR PYTHON DEVELOPER

Remote and onsite Data Warehouse and software Development and testing with experience in all of the phases of the Data Warehouse life cycle, including gathering requirements, data profiling to verify values and existence of fields in source tables, dimensional modeling, physical design, ETL design and development, thorough testing of ETL procedures, deployment and maintenance.

Have assumed DBA duties for Oracle and Informix databases.

Designed and implemented data warehouse using custom coding as well as ETL tools. Utilized a wide variety of support tools to maintain the Data Warehouse and Data Marts.

Commended for willingness to take on new projects and high level of productivity, especially in remote positions.

Masters’ degree in Decision and System Sciences with a passion for continuous learning and growth.

Very responsive to users of the Data Warehouse and, earlier, payroll. Met with them and worked on fixing any errors or clearing up any misunderstandings of the data or user operation.

Course work in Python for Data Science, R for Data Science and Machine Learning with Python. Soon starting Hadoop and Deep Learning

Strong skill in Microsoft Office and Google docs, In particular MS Excel

Working on Machine Learning and Python development to become very good at Python as I really enjoy software development and testing to ensure it works as it should.

TECHNICAL SKILLS

Python Machine Learning Oracle 10g RDBMS ArcGIS JavaScript R HTML CSS Google Maps API OWB

Software Test Excel ETL SQL PL/SQL ESRI JavaScript API MySQL Unix Linux Shell Scripting COBOL

PROFESSIONAL EXPERIENCE

HLB Global Ventures, Trabuco Canyon, CA 2015–Present

FOUNDER/WEB DEVELOPER, SEO GOOGLE ANALYTICS

Founded 100% virtual company for e-commerce and affiliate marketing websites. Trained in and applied WordPress, SEO, and Google Analytics to grow business.

Wright1 Consulting, Inc., Remote 2014

WEB DEVELOPER INTERNSHIP

Internship designed to gain experience and facilitate education in design, layout, and code in HTML, JavaScript, and PHP.

Worked with the employees on of a PHP Web App that tracked most information needed by Attorney Practices.

Created the Add function of this app, which included the coding of all of the PHP, HTML, and adding new rows in MySQL Database.

Orange County Transportation Authority, Orange, CA 2003—2013

SENIOR DATA WAREHOUSE DEVELOPER

Promoted due to initiative and ability to continually learn and excel at new tasks. Collaborated with stakeholders and end users to analyze, designed, developed, maintained, and enhanced data marts in OCTA warehouse. Participated in the gathering of business requirements for new processes and implementations to support analytical needs. Conducted data analysis and data profiling.

Successfully migrated data warehouse from Oracle on HP Unix platform to Oracle on Linux platform.

Developed ETL processes consisting of Oracle warehouse builder mappings combined PL/SQL procedures and functions.

Performed ad-hoc SQL queries to determine cause of data errors in data loads, answer user questions, and enhance dashboards and reports.

Headed project to correct programming issues with out of balance Revenue reporting on GFI Genfare fare boxes report, analyzed everything involved to determine cause of error in program and added revenue adjustment program to ensure accurate actual and adjusted Revenue values; program remains in use to this day.

Orange County Transportation Authority, Remote/Orange, CA 1997—2003

DATA WAREHOUSE/DATABASE ADMINISTRATOR (DBA) I, II & III

Tapped by previous DBA to take over dual position as database administrator and data warehousing. Grew department to include 3 DBAs and 1 data warehouse developer before transitioning solely to data warehouse.

Built data marts and ETL programs, using OWB, Oracle, SQL and Oracle PL/SQL. Converted older systems to Oracle.

Collaborated with consultants to migrate data marts from Informix to Oracle and develop new data marts, improving quality of information.

Orange County Transportation Authority, Remote/Orange, CA 1990—1997

PROGRAMMER / ANALYST I, II & III

Programmed, supported, and enhanced payroll system which required massive changes due to the merger of OCTA with the Orange County Transit Commission systems. Designed, coded, and tested applications using COBOL. Designed and developed client-server applications.

Researched, designed and developed new payroll system, completing project on time with system remaining in production for 20 years without incident.

Developed and added new capabilities to payroll system to accommodate company merger.

EDUCATION

M.S., Decision and System Sciences–St Joseph’s University, Philadelphia, PA, 2010

B.A., Mathematics, University of California, Irvine, CA

B.S., Information and Computer Science, University of California, Irvine, CA

Certified Business Intelligence Professional (CBIP), 2015

TRAINING

Data Science with R & Data Science with Python & Machine Learning–Simplilearn Online

Linear Regression, Logistic Regression, Classification, and Clustering

GIS Mashups for Geospatial Professionals–Penn State University

Google maps, API, ESRI JavaScript API, HTML, XML, CSS, My SQL, PHP

Post-Baccalaureate Certificate in Geographic Information Systems (GIS)—Penn State University

Contact this candidate