Steve Durandisse, Sql Developer, Data Engineer/Analyst Email & Phone Number

Collaborated with cross-functional teams to design and implement data models and solutions that allows for more analyses and sharper accuracy. Developed data validation and quality assurance processes and complex ETL/ELT processes. Created new and optimized existing SQL scripts (SP, Trigger, Function...) to ensure better run time and stability. Automated report processes in SSRS, Power BI, and Crystal Reports. Served as mentor and SME to Junior members of the team.- Sped up by over 30% the processing of incoming EDI data in developing a scalable data pipeline using SQL and SSIS.- Enhanced monthly EOB report processes by creating a mini Data-mart, enabling the creation of new analytical reports, and making new report types available on self-service.- Improved execution time by 20x on some processes through optimizing legacy codes on Existing Stored Procedures and Functions.- Successfully lead a departmental effort that automated about 40% of recurring scheduled reports as of the end of last year, using SSRS, Crystal Reports, SAP BO and Power BI.

Albany, Ny

Collaborated with stakeholders to gather requirements and identify KPI. Used SQL to leverage and analyzed complex data sets, generated reports and dashboards that provide meaningful business Insights. Manage existing reports and processes, developed and documented new procedures as needed. Created new SQL scripts for ad hoc report request. Served as subject matter expert on several regulatory reports.- Decreased weekly ad hoc requests 22% by the creation of self-serving reports using MS Power-BI and SAP Chrystal Reports via Business Object - Reduced overtime hours by automating 50+ reports, using SQL Server Integration Services (SSIS) within single quarter. - Upgraded analytical capability and accuracy on over 60 existing reports and dashboards in SQL Server Report Services(SSRS) and Power-BI by adding granularity and drill down capabilities.- Automated over 12 Analytical processes in Excel using in cell formulas and VBA.

Ridgefield, Ct

· Supported the procurement department with statistical Analysis.··o identify patterns and trends in complex datasets.· Created summary reports for upper management.· creationSupported procurement department with data analyses and report development. Assisted the data migration project with data validation, establishing Data Quality Assessment Framework (DQAF), creating data models, and translating requirements into script. Conducted detailed data analysis for upper management.- Designed a Data-cube and an interactive dashboard in Excel that tracks purchasing expenses per supplier and/or commodity, and compare quarterly figures from previous years to current.- Led the development and deployment of the Purchasing department reporting data warehouse. - Created a data structure that links suppliers to parent corporations using a parent/child hierarchy using DUNS number.- Led the development and deployment of the reporting Data Warehouse for the Purchasing department.- Increased procurement price negotiation leverage by developing an interactive dashboard that illustrated individual supplier’s business volumes share in correlation to their parent company.

Hopwell Junction, Ny

Supported the East Fishkill manufacturing site procurement and chemical departments with their data effort. Leverage multiple sources, manipulate and format data as required· Analyze very large data sets to identify patterns, correlation factors and outliers· Created data mapping for cross system communications. Served as subject expert and support for MS Access, Excel and a legacy Inventory System. Identified process flaws and propose corrective actions. Designed data structures for new tables and databases according to business requirements. System / Business gap analysis. - Led the research analysis for the migration and deployment of DB2 database to an SAP ERP for the East Fishkill manufacturing site.- Reduced inventory storage by 33% and reduced yearly material waste by $300K in creating material category dimension that made possible material ranking based on consumption, average shelf life and supplier availability.- Reduced Consignment inventory by 15% by creating an Excel application that provided more accurate consumption forecasts. - Uncovered a systemic theft of reclaimed materials through the creation of a monitoring process that reconciled original expenses with recovered core values and depreciation. - Automated a COI tracking and reporting process for the Department Of Defence.- Designed a matrix that estimated supplier performance and rank them based on reliability.- Designed in collaboration with Chemical engineering Dept a regulatory SARA tier-II reporting procedure for the EPA

Bachelor’S Degree

Associate’S Degree