Jacob Leon Email & Phone Number

San Francisco, CA, US

Chicago, Illinois, US

• Technical Architecture
• Created a 4 node spark cluster in AWS EC2
• Architected a solution with S3, Apache Spark and Redshift to support an initiative to get a 360 degree view of the customer
• S3 is used as the data storage layer, Spark as the data transformation layer and Redshift as the service layer. This design was chosen to give a great amount of flexibility to the data scientists in the department.
• Enabled s3a in Spark to use S3 as pseudo-hdfs to easily read and write parquet files
• Managing the external parquet files in s3 using a hive metastore to take advantage of the cost based optimizer

Seattle, WA, US

Consultant in the Information Management and Analytics Practice Application Engineer for GogoPOC’ed a modernization of the current reporting solution using AWS by using a combination of Kinesis, Lambda, S3 and RedshiftModeled a fact table and dimensions in Redshift which would serve as the basis for tableau dashboardsDeveloped an ELT process in Matillion.

Chicago, Illinois, US

• Modified a prominent association's data warehouse to build logic to measure organizational memberships from Avectra. Then added dashboards to allow everyone from executives to measure membership data by organization.
• Implemented a dashboard for key stakeholders in Western Europe that allows sales reps and managers to gain key insights into how well their products are selling in each country vs the competition -In addition, data.

Chicago, Illinois, US

• Developed a solution for a Top Pharma company to be able to report on the movements high ranking executives along with the evolution of sought after positions around the world. This allowed talent managers to be able.
• Built a way for another Top Pharma company to be able to report on the intersection of formulary, claims, and written prescriptions in order to gain a competitive advantage by focusing their efforts to get their.

Chicago, IL, US

• ETL Lead for supplier cost project which gave the Strategic Sourcing and Direct Material teams increased visibility to direct material demand, supply, receiving and usage
• Eliminated a time consuming manual migration process by automating code migration to testing and production environments
• Built a Sales and Profitability reporting solution for the US and Canada which allows them to have a great deal of insight to thesuccess of various product lines by various segments (Customer, Territory, Date, etc...)
• Implemented an Enterprise Data Warehouse which is the single source of truth for all data at USG

Chicago, IL, US

• Developed technical coding project plans based on complexity. Created SQL to populate type 1 and type 2 dimensions and fact tables.Conducted a series of SQL training sessions with our QA department and IT Directors..
• Designed a solution for the Strategic Sourcing group that concentrated on Corporate PO's and Invoices to indirect suppliers.This project allowed them greater visibility to our main suppliers and thus negotiate more.
• Led a datamart building process that aided in helping management make strategic decisions about staffing levels. Specifically,extracted the data from the Oracle E-Business Database and loaded our custom datamart that.
• Inherited and successfully implemented an HR BI project that was primarily staffed by consultants but were let go due to deteriorating economic conditions.

Chicago, IL, US

• Implemented the Oracle HR module with B2B interfaces to communicate personnel changes to our business partners. Extracted datafrom Oracle using SQL, translated the data into a predefined document format. Constructed an.
• In Spring 2008, I was identified as a high potential employee which allowed me to participate in activities such as taking a weeklong trip to visit plants in the U.S.
• Constructed an EDI interface to send 850's (Purchase Orders) and receive 855 (Purchase Order Acknowledgments) to our mostpopular indirect supplier. This effort saved 2% on each order submitted via the interface.
• Coded a inbound interface from Sirva which came through Trading Networks, once the business logic was performed an PL/SQL wrapper was fed that updated the employee’s end of year tax balances.
• Coded an inbound interface from Hewitt using Trading Networks. Trading Networks would start webMethods code which updated an employees long term disability record in Oracle HR.

Chicago, IL, US

• Designed and supported interfaces that were part of a $250 Million ERP implementation that significantly modernized the Supply Chainsystem giving customers greater visibility to their orders. Created real-time, event.
• Participated in plant roll on by monitoring that the correct data made it into the load diagramming software, Max Load Pro
• Performed as the main EAI contact for solving remedy tickets that were logged in production by functional users
• Optimized the shipment history interface which was taking over 8 hours and nearly 100% CPU usage to process.
• Created a java service that would reformat xml tags into a standard format so webMethods would be able to convert the data intoa “document”
• Corrected code for the ERP implementation project that had defects submitted by QA

Chicago, Illinois, US

• Developed and supported a billing data collection and mediation system that processed over ten million dollars daily. Provided off-hours on-call support for switch and system upgrades. Wrote Perl and Korn Shell scripts.
• Participated in two company wide initiatives. Used my knowledge of C to debug code in our test environment for Push To Talk (PTT) and created a byte audit in Perl for Multimedia Messaging (MMS).
• Coded a script that logged BREW transmissions to Qualcomm, if there was no response from Qualcomm a page would be sent to the person on-call
• Created a utility that displayed collected files by bypassing x-windows and listing them through the standard output. This reduced the time needed to do on call work when using a dialup connection.
• Transitioned our tier 1 responsibilities to another group by documenting our on-call procedures, creating a menu in UNIX listing the most commonly used utilities, and providing on site training