BARBARA J. DILUCCHIO
949-***-**** Trabuco Canyon, CA email@example.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.
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
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.
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
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
Post-Baccalaureate Certificate in Geographic Information Systems (GIS)—Penn State University