Darryl Lardizabal Email & Phone Number

San Francisco, California, Us

New York City, New York, Us

- Established the first production connection from Netsuite to Celonis for one of the world's largest cloud network platforms, designed to make everything connected to the Internet secure, private, fast, and reliable leading to confirming and validating $900k in realized value in AP and $7.2M in AR.- Led SAP ECC to SAP S4 migration, giving best practices as to how the migration would affect Celonis from an infrastructure perspective for a leading global food and beverage company, renowned for its diverse portfolio of over 200 household brands. - Led data pipeline migration conversations involving multiple EC2 AWS instances designing a stable data pipeline to cutover to a new Celonis instance for a leading global energy coproration recognized for its integrated operations in the exploration, production, and refining of oil and natural gas.- Setup a data pipeline for a POV from a JD Edwards system to Celonis (to help with a SAP system migration for P2P and O2C); which helped sign a $285,000 ACV deal (amounting to $855,000 for 3 years) for a $6 Billion Potato Agrifarmer which pioneers innovations in agriculture, food processing, and sustainability.- Designing, Consulting, and Developing data integration pipeline from Boomi Middleware system to Celonis for a $500M chemical distributor worth $119,000 ACV, for a 3 year term for Order Management. - Supported Data Architecture and Pipeline discussions to support warehouse transformations for a global leader in materials engineering solutions, renowned for its pivotal role in shaping the semiconductor, display, and solar panel manufacturing industries. This led to an expansion deal with an ARR of $95,337, Celonis Services NRR of $238k, and TCV of $171k.- Consulted on custom data pipeline development for the foremost provider in the cloud-based platform sector, specializing in digital workflow solutions that automate and optimize enterprise operations. This helped land a deal of $5M TCV over 3 years with $1.495M NNACV.

New York City, New York, Us

The Solutions Architect team is responsible for the technical onboarding of Celonis customers to the platform with a focus on setting up the data integration pipeline together with our customers. This also can include knowledge transfer and details on other aspects like user management and authentication which are required to ensure there are no technical barriers to user adoption of Celonis. - Working with enterprise customers (many in the Fortune 500) throughout the implementation and onboarding process of Celonis- Design big data pipelines and ETL processes to establish connection with the Celonis environment that includes source systems such as SAP, ServiceNow, Salesforce, Coupa, Concur, MSSQL, MySQL, and more. - Technical discovery discussions with Clients to deeply understand their data infrastructure.- Monitor the data pipelines, ensure their reliability and help troubleshoot any issues- Building and providing workflows and tools also to other teams within Celonis, you make sure that the solutions you build will scale properly.

Conceptualized, launched and grew this health and fitness organization specializing in providing personalized goal and assessments via hands on leadership into a successful and stable service business.Notable Achievements: • Developed and established the original and second iteration of business website, using WordPress, HTML, and CSS.• Established and managed a successful corporate fitness program, including direct communications with target client CEO’s.• Setup and managed a monthly EFT billing system.• Developed and managed a weekly autoresponder for fitness e-mails with 992 contacts.• Grew this thriving one-on-one business from 3 to 35 clients and managed groups of 5-40 clients in fitness instruction.

Dublin 2, Ie

Responsible for curating data essential in converting 600+ reports from OBIEE to QlikSense to make sure target report data is matching converted source data in AWS RDS.• Reconstructing the ETL pipelines and design patterns in a “like for like” migration.• Managing and deploying ETL jobs through Apache Spark using Python's PySpark API.• Responsible for reverse engineering and systems analysis through design, programming, and unit testing.

Dublin 2, Ie

Assisting in conversion of 600+ reports from OBIEE to QLIKSense to make sure target report data is matching converted source data in AWS RDS and Vizualization Reports.Notable Achievements: • Interim Dashboarding lead managing, delegating, teaching, and assisting a team of 10+ onshore and offshore members.• Created Python script using Jupyter Notebook to semi-automate comparing of reports from source reports to target reports, testing anywhere between 80 to 10,000+ records. • Use ODI to run full load ingestion into tables consisting of thousands to millions of records for Curation testing.• Pandas and NumPy libraries were used to open the two CSV files for comparison and provided documentation as to the expressions used to create the test providing proof if the test case was pass or fail. • Use AWS GLUE web crawler to ingest flat files containing millions of records worth of information from AWS S3 into personal schemas to test via iCEDQ. • Use iCEDQ to compare between source data from Oracle DB and target data in AWS RDS by building testing rules that compare upwards of 10,000,000 - 130,000,000+ records.• Performance tune queries used to pull data from on-prem database and cloud database to help lower test case run time by 200%.

Dublin 2, Ie

• Modify Tableau dashboards to input necessary information used to determine if back-end calculation logic is working correctly for each new release that occurs at CalHEERS. If back-end calculation logic isn't working correctly consumers may receive more or less advanced premium tax credit or state subsidy than they should. • Provide assistance in managing onshore / offshore resources during peak project periods.• Apply multiple data fixes via SQL scripts to: - Merge & Update demographic information for out-of-sync tables. - Merge missing user id information from related tables using revision history to accurately identify user id. This issue affected more than 15 millions records in PROD database, and was critical for client stakeholders as it affected Data Warehouse records causing misinformation in CoveredCA reports. - Update application status for consumer households affecting their ability to select plans they are eligible for. • Develop relationships with key Client stakeholders across multiple State agencies and interest groups (CoveredCA, CalHEERS, DHCS, CWDA, C-IV, LRS, and CalWIN)

Dublin 2, Ie

• Develop relationships with key Client stakeholders across multiple State agencies and interest groups (CoveredCA, CalHEERS, DHCS, CWDA, C-IV, LRS, and CalWIN)• Provide assistance in managing onshore / offshore resources during peak project periods.• Apply multiple data fixes via SQL scripts to: - Merge & Update demographic information for out-of-sync tables. - Insert column values for NULL demographic information by transforming JSON and XML clob information into VARCHAR and NUMERIC values. - Add user_ids to staging table to be queued up for batch processing to update demographic information in bulk. • Perform Root Cause Analysis on system defects including: - Finding and analyzing corresponding design documentation. - Performing Ad-Hoc analysis in Oracle database and Web Application to determine system impacts and number of users affected. - Determine if the issue was caused by code or data issues. - Replicate issues in Non-production application and database to help better pinpoint the issue. • Participate in PRODUCTION triage meetings to discuss impacts of the system defect with stakeholders to determine if the defect warrants fixing.• Find areas for improvement including: refactoring internal queries (changes in database architecture, performance issues), creating knowledge articles on: Eligibility and Enrollment, and others.

Primary Developer, charged with designing, creating, and/or maintaining web sites, using HTML, CSS, JavaScript, and WordPress for brands such as Catalyst Mortgage, Driftwood Marina, Byers Leaf Guard, Shasta Marina and Applied Legal.Notable Achievements: • Identified gaps in service infrastructure and conceptualized the development of localized development, targeting reduction in project length and cost savings of 60-70%. Local development environment includes: local host for live tests, git hub version control to test multiple website versions; and Sublime Text 3 Text Editor for in house testing.• Successfully developed a top to bottom website redesign on time with requirements that changed 3-4 times and the scope evolved to twice the original concept; project included meeting with clients to define scope, built the prototype, established virtual servers, and used multiple languages.• Developed UTM code to repair an email auto responder to redirect users to a contact page; identified gap in code and successfully resolved the issue to restore direct communications with clients.• Used Google Analytics for creating powerpoint decks that revealed potential new target demographics and niches to use for marketing materials for one of the largest Agricultural Bureaus in California - California Farm Bureau of California. Research included:- Determine where the best visitors are located. - Learning what people are searching for on the site. - Visualizing what people click on the most.- Uncovering top content. - Identifying worst performing pages.

Performed a wide range of IT support functions and acquired solid skills, including formatting hard drives, reimaging hundreds of desktops, and testing MiFi connectivity/speeds for use at multiple sites.Notable Achievements: • Improved help desk ticket resolution time from 13 to 10 minutes for 90% of tickets.• Completed security patch updates on approximately 450 computers in just a week to prevent infiltration of the WannaCry ransomware attack.• In conjunction with the IT Specialist 2, performed auditing (typically performed monthly) on 600+ wireless hotspot devices assigned to students and staff members with 3 different carriers. Helped with activation, suspension and deactivation as appropriate saving about $36,000/year to organization. • Troubleshooting, Imaging, Installing, Monitoring, Configuring, Software, Chromebooks, Chromeboxes, etc. for all devices (Desktops, Laptops, Macbooks, Printers, MiFis and APs). • Training End Users to Use Desktops, Macbooks, Laptops, Printers, MiFis, and Software.

Data Analyst Nanodegree

Bachelor Of Science - Bs, Data Management/Data Analytics

Northwestern University 101: Leading With Analytics