Dean Smith

• Streamlined data collection methods to minimize analysis errors.
• Automated repetitive tasks using scripting languages such as Python or PostGRESQL, saving time during the analytical process significantly.
• Evaluated emerging technologies to assess potential applications within the organization''s existing infrastructure or future projects.
• Conducted feature engineering efforts to enhance model performance by creating new relevant variables from raw input data sources.
• Conducted thorough exploratory data analyses for robust model building.
• Assessed accuracy and effectiveness of new and existing data sources and data analysis techniques.
• Utilized advanced querying, visualization and analytics tools to analyze and process complex data sets.
• Set up SQL database on cloud servers to store client data for query analysis.
• Identified, measured and recommended improvement strategies for KPIs across business areas.
• Developed custom data pipelines for streamlined data ingestion and processing, improving workflow efficiency.
• Implemented robust data governance practices, ensuring data integrity and compliance with regulatory standards.
• Automated repetitive data cleaning tasks, freeing up time for more complex analysis.
• Evaluated new data sources for integration into existing models, expanding breadth of insights generated.
• Simplified complex data sets into actionable insights for executive decision-making, enhancing strategic planning.
• Enhanced predictive model accuracy by refining algorithms and incorporating new data sources.
• Streamlined data analysis processes, leading to more timely insights for business strategy adjustments.
• Designed interactive dashboards and reports, providing real-time business intelligence to stakeholders.

• Data Warehousing, Modelling, Design, Architecting and ETL Development
• Working with Enterprise Data Management Team to design, build and maintain Data Systems for the Office of the Comptroller of the Currency.
• Extensive experience in a wide range of Data Engineering activities from Modeling, DW Design, to ETL

• Responsible for ongoing analysis, booking, and loading of Service Source and industry specific data using SSIS and SQL Server Stored Procedures in a SQL Server 2012 environment.
• Utilized data visualization tools to effectively communicate business insights.
• Improved decision-making processes with accurate data analysis and visualization techniques.
• Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
• Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.

• Performed SSAS/SSRS/SSIS Business Intelligence development and support tasking for Williams Medical Supplies – a logistics company concentrating on providing medical supplies to GPs throughout the UK.
• Worked extensively with SSAS Cubes, SQL Server 2008 SSIS, database development and SSRS report creation and daily production support taskings using the NAV OLTP database.
• Supported, maintained and enhanced a SQL Server 2008 R2 Data Warehouse including 7 SSIS Packages and 4 SSAS cubes for ETL transformations and reporting from Microsoft NAV. Provided Production BI Support for 15 Excel Power Pivot end users where Power Pivot was the BI tool which used the SSAS Cubes as a backend.
• WMS Reporting included Excel 2010, Sharepoint Dashboards, SSRS Reports, and Microsoft Sharepoint KPIs and Scorecards.
• Maintained financially oriented Excel Pivots and associated SSAS Cubes.
• Maintained daily SSAS cube refresh process included SSIS runs daily from NAV to the BI Warehouse.
• Highly proficient developing SQL Server 2008 R2 Stored Procedures in support of ETL

• Performed SSAS/SSRS/SSIS Business Intelligence and SSAS Cube/SSRS operational support tasks and development for a Buy as You View – retailer in South Wales.
• Worked extensively with SSAS Cubes, SQL Server 2008 ETL and database development and support tasking along with some associated Oracle 11G application development.

• Managed a Business Intelligence/Web Portal Team.
• Provided expertise and direction in the support of numerous Royal Mail Applications using technologies such as SQL Server, Business Objects.
• Led a team of 9 members in supporting SQL Server/Oracle and Business Objects driven applications.

• Performed research and development and application support for LEDC (Learning Environment Dashboard and Controls) and application designed to provide Navy students, instructors, and staff with indications of student progress.
• Successfully built an Oracle Database and associated packages to support LEDC.
• Converted from SQL Server backend to Oracle.
• Increased the efficiency of LEDC by 75% by developing new keys and indexes in the databases.

• Performed Project Management and Systems Analysis of integrated ASP.NET Web Applications.
• Responsible for coordination of Application Development Projects with Finance, Court Systems, Server and Network groups, and GEAC Mainframe personnel.
• Lead small team of 3 developers in ASP.Net and SQL Server database development and support.

• As an Intermediate Level Avionics Technician I supported Automatic Test Equipment (Hybrid Test Station) used for isolating complex electronic circuitry failures for F/A-18/F14/EA-6B/SH-60B Avionics equipment. Supported the Automated Test Language (ATLAS). Intermediate level support in Cubi Pt. Philippines.
• NAS Lemoore Ca -3 years as an Automatic Test Equipment Instructor 1995-1998.
• As an Organization level Avionics Technician I supported SH-60B/HH-60H, EP-3E aircraft at VQ-1 NAS Agana Guam and HS-6 H-60 Squadron at NAS North Island Ca.
• In my final tour at AIMD North Island (Feb 2001-Feb 2004), I worked outside my Avionics rating as a SQL Server databases and web developer in support of the AIMD Avionics Division, maintain database and application systems to support all Avionics personnel.

Study of Statistical methods and practical applications.