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 consumable files for SQL server and Power BIDocumentation 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

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 pipelines• 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 SharePoint lists into consumable files for SSISCreation of end-to-end project documentation• 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 projectso Developed database and pipeline resourceso Led and documented testing with business ownerso Utilized Lucidchart/Visio to document current state, requirements, data, and process flows

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 and workflows saving over 500 hrs/yr of manual collection and input• 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 and import scripts and PostgreSQL queries to feed machine learning modelso Created Tableau dashboards utilizing business rules to create storytelling dashboards, highlighting client spend trends and model recommendations• 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 business intelligence environment• 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 rules from disparate Excel and Word files into a business schema within Incorta Cloudo Achieved an estimated cost savings of $75k annuallyo Increased leadership visibility of operational KPI’s from three weekly KPI’s in Excel reports to automated, daily reports highlighting twelve KPI’s rolling up from teams within buildings to organizational wide

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.• Led overhaul purchase card expense analysis and monitored with Accounts Payable, with an expected annual savings of $50k over third party analytics.• Led project to automate ETL and analysis of over $80M in payables to contracted medical personnel.

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 by $1M.Led legacy parts classification for third party licensing.• 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.• Collected requirements from non-technical team members, translating them into systems requirements for the technical implementation team.• Led testing on services ERP, ASCP and BI solutions

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 order shipments.• 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 productivity by 5%.Applied the APL Logistics Continuous Improvement (ACI) Model.• 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 sustain a safe, clean and orderly facility.• 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 requirements.• 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 and ensure compliance of building’s clean-up and disposal of hazardous materials in September 2006.

Education record

Education record