Eric Damko Email & Phone Number

San Diego, CA, US

• Creation of data warehouse objects
• Created Power BI datasetso Combined disparate data sources including SQL databases, Excel spreadsheets, Power BI dataflows and unstructured data into a singular model for end user consumption Creation of data pipelines
• Created SQL stored procedures, SSIS packages and Power Automate flowso Modified scripts, scheduled jobs, and constructed flows to feed Power BIo Designed Power Apps/Automate flows to ingest SharePoint files into.
• Created automated and manually generated documentation of data warehouse pipelineso Detailed field-level data lineage, transformations, and dataflow pipelines utilizing SQL scripts

Racine, WI, US

• Documentation of data pipelines
• Created automated and manually generated documentation of data warehouse pipelineso Detailed field-level data lineage, transformations, and dataflow pipelines utilizing SQL scripts, SSIS diagrams Creation of data.
• Created SSIS packages and SQL stored procedures for new data pipelineso Combined C# scripts with SSIS variables to create scalable solution for ingestion of new fileso Designed Power Apps/Automate flows to ingest.
• Created business requirements and user stories in dual role as business analyst and database developero Assisted in development of an integrated design approacho Led conceptual and logical design initiatives within.

Chicago, IL, US

• Creation of Business Intelligence pipelines and reporting
• Created Tableau Prep and Alteryx dataflows from client legacy Excel reportso Mapped and documented production data sources vs staff input found in spreadsheets o Backwards engineered business logic into BI pipelines.
• Developed Python scripts, PostgreSQL queries, and Tableau dashboards to create and display spend analyticso Created data pipelines between Anvil (Python cloud application) and PostgreSQL database utilizing Python clean.
• Reengineered SQL stored procedures into Tableau Prep Flowso Created Tableau Prep flows to recreate and update client legacy SQL stored procedures as part of migration away from MS SQL Server architecture.
• Created data pipelines and dashboards utilizing Power Apps/Automate, OneDrive and Power BI to centralize client production data gathering and reporting

Mt Horeb, WI, US

• Led development of wing-to-wing warehousing and logistics ELT pipeline, data warehouse and dashboards
• Created ELT pipeline utilizing Oracle-based Softeon databases and Incorta Cloudo Utilized Spark SQL and Python (PySpark) to ELT data from logistics warehouse production Oracle databases and UPS flat files into Incorta.
• Led project to transition organizational reporting from Excel/emails to Incorta Cloud dashboardso Interviewed and collected requirements from stakeholders ranging from CIO to frontline managemento Translated business.

Brentwood, TN, US

• Position downsized with elimination of internal audit functional group within Brookdale in March, 2019.Led the development and implementation of data ETL, warehousing, and data analytics for Internal Audit.
• Created automated ETL of multiple data models, leveraging disparate data sources into integrated models through Microsoft SSIS, SSAS, Excel, and Tableau.
• Reduced Internal Audit analytics administrative hours by 70%, while increasing analysis scope from one month to three years for General Ledger and Executive Expense analyses.
• Co-led the automation of control and substantive population sampling and testing utilizing ACL Analytics.Designing and developing data-centric risk models.
• Created a data model utilizing SSIS / SSAS and Power BI to identify potential credits, write-offs, and refunds fraud.
• Created a multi-dimensional data mining model to identify Coupa purchase card expense fraud.Led cross-functional projects for control and process initiatives.

Schenectady, NY, US

• Led service parts forecasting and materials planning strategy and execution.
• Designed and implemented “Plan for Every Part” analytics and ERP integration using Microsoft Access and Excel to optimize inventory safety stock levels in 1Q 2016; realized $3M in cost out within nine months.
• Implemented forecasting software, Smoothie, for a team of six in 2017, accurately anticipating +15% growth vs previous sales forecast.Led remanufactured parts supply chain planning process.
• Led the team in 2015 - 2016 to reconfigure item master data and design inventory management strategy for reUp remanufactured products, increasing on-time delivery by 50% while decreasing overall program inventory costs.
• Created data analysis classifying over $5M of inventory for licensing agreement in 2015.Services functional team lead for Oracle 11i to R12 migration.
• Worked as liaison between Oracle implementation team and services functional groups.

• Established a program for order management, order analysis, and order profiles.
• Created an analytics package utilizing GE Waukesha channel forecasts and Oracle data to project $190M in order and revenue flows within the fiscal calendar.Developed and monitored metrics for channel incentives
• Created channel partner “Pay for Performance” scorecard tracking key performance indicators; responsible for calculating over $15M in performance rebates.Developed and monitored the SKU watch list to ensure timely.
• Created an analytics package, tracking open orders, shortages, and recognizable revenue critical ship date on over $45M in quarterly orders.

• Promoted employee development through in-house training, goal setting, and achievement feedback.
• Created metrics package using Excel and Access to analyze GE Waukesha and Jenbacher order data to more accurately track employee productivity and establish benchmarks for all departments, helping to improve overall.
• Devised and implemented GE Waukesha small parts reorganization plan as a lean project leader, increasing picker productivity, saving the operation $39,000 year over year.Applied the 5S Lean methodology to create and.
• Designed and implemented 5S/JDI project, reorganizing supplies and standardizing work stations, saving $43,000 annually.Identified and implemented processes in order to ensure the facility meets or exceed budget.
• Created Excel document using WMS queries to calculate real-time staffing needs for departments servicing GE Waukesha.

Atlanta, GA, US

Manage, organize, direct, train and discipline employees concerning service, attendance, loss prevention, production and hazardous materials clean-up. Achieved 5% productivity gains over predecessor within 6 months of promotion.  Effectively supervised 12 – 15 employees without injury March 2006-February 2007.Given additional responsibilities to oversee.

Education record

Education record