EHSAN JAVID

Lead Analytics Consultant

**** ***** *****

Sachse, TX 75048

ad07m2@r.postjobfree.com

515-***-****

LinkedIn: www.linkedin.com/in/ehsan-javid-10b85b102 Data Engineer and Analytics professional with over 6 years of diverse experience, starting at John Deere building foundational databases to drive efficient data analysis. Progressed to Wells Fargo, initially aiding in customer remediation efforts using tools like Oracle, SAS, and Python, then later leading projects to ensure data integrity in datasets for EWS. At Cox Communications, I utilized Python and Py-Spark to optimize data processing and developed analytical tools for call center metrics. My strengths lie in creating automated data pipelines, ensuring data quality, and identifying potential risks. I’m passionate about leveraging data for actionable insights and continuously look for innovative solutions to complex problems.

Key Skills: Data Engineering, SQL,Python, Big Quary, AWS Athena, AWS Redshift, Looker,Looker Studio,Cloud SQL,Cloud Spanner, BI-Tools, SAS, Analytics, Data Quality, Data Profiling

Professional Experience

Lead Analytics Consultant

Wells Fargo April 2019 - Present

■Risk Identification and Mitigation: Proactively identified and mitigated many potential risks during the ETL process, resulting in a 40% reduction in data errors. Presented risk findings to management, emphasizing their potential impact on customer remediation efforts, leading to a 25% decrease in customer issues.

■Script Development for Data Mining: Developed Python scripts automating the retrieval of table names and fields from SQL and SAS scripts, saving over 25 hours of manual work per week. Assisted in identifying and automating 15 critical tables for customer remediation, resulting in a 20% boost in data utilization efficiency.

■Data Quality Assurance for EWS: Oversaw the successful transmission of 11 distinct datasets to Early Warning Services (EWS), achieving a 99.5% error-free delivery rate. Achieved a 100% resolution rate for identified data discrepancies, ensuring data accuracy for EWS.

■Data Control Analysis and Insights: Conducted in-depth data control metric analysis, improving data punctuality by 15%.

Provided insights for root cause analysis, leading to a 30% reduction in data anomalies.

■Leadership in Cloud Storage Transition: Led a data transition project to cloud storage, resulting in a 50% reduction in data retrieval time and enhanced data accessibility. Extended data retention beyond the 90-day window, facilitating long-term data analysis and compliance.

■Data Management and Governance Excellence: Ensured strict adherence to data management and governance policies, achieving a 95% data integrity rate. Collaborated effectively with cross-functional teams, successfully resolving 100% of data-related issues and promoting data-driven decision-making.

■Performance Optimization: Proactively addressed performance challenges, leading to a 20% increase in database and SQL query efficiency.

Optimized data retrieval and processing, reducing processing time by 15% and enhancing overall system efficiency.

■Data Extraction and Transformation: Successfully extracted and transformed data from the Oracle database, resulting in a 25% improvement in data quality.

Streamlined data review processes by facilitating the loading of transformed data into the SAS grid, reducing data review time by 30%.

■Leadership and Team Management: Demonstrated the ability to lead and manage a team of data analysts and consultants, ensuring effective collaboration and project execution.

■Database Creation and Maintenance:Successfully created a new database in SQL Server Management Studio, accommodating files received from EWS.

Implemented Python scripts to automate data collection, cleaning, and loading processes, improving data accuracy and efficiency by 20%.

■Ad-hoc Reporting:Addressed ad-hoc reporting requests promptly, showcasing flexibility and adaptability. Provided critical data insights for various stakeholders, enabling informed decision-making and problem- solving.

■Transitioned from a contractor position to a full-time role at Wells Fargo in 2022, following a successful tenure from April 2019 to December 2020. Returned to the team to continue contributing to data engineering excellence.

Data Engineer (Contractor)

Cox Communications, Atlanta, Georgia, United States June 2021 - January 2022

■Call Center Data Analysis: Analyzed call center data, focusing on caller timelines and efficiency, leading to a 15% improvement in call resolution times.

Identified trends in call transfers, reducing unnecessary transfers by 20% through targeted training and process improvements.

■Dashboard Development: Developed Tableau dashboards for managers and supervisors, improving visibility into employee performance.

These dashboards contributed to a 25% increase in the identification of training needs and performance improvements.

■Data Quality and Integrity: Ensured data quality with meticulous data validation, resulting in a 95% data accuracy rate for analysis and interpretation.

Acted as a data steward, ensuring the integrity of data throughout the extraction and visualization process.

■Automation Initiatives: Developed automation scripts, reducing manual effort by 40%. Automated processes such as scanning shared drives for specific keywords, reducing manual review workload by 30%

Data Engineer (Contractor)

State of Iowa - Executive Branch, Des Moines, Iowa, United States December 2020 - March 2021

■Vaccination Allocation Insights: Delivered critical insights on vaccination allocation for the governor's office and government stakeholders, meeting stringent requirements and deadlines. Utilized advanced data analysis techniques to optimize vaccine allocation strategies, resulting in a 15% increase in vaccine distribution efficiency.

■Python Automation Script: Developed a Python script to streamline automation and data extraction from key storage files, reducing manual effort by 40% and improving data accuracy. Implemented advanced data parsing techniques to efficiently extract and process data, enhancing automation capabilities.

■Data Quality Assurance: Conducted rigorous data quality checks, ensuring data readiness for Tableau visualization and analysis.

Achieved a 99% data accuracy rate, providing Tableau teams with clean and reliable data for sound storytelling.

■Strategic Vaccine Allocation: Engineered a data-driven approach for the equitable allocation of vaccines across various counties of Iowa based on population groups, including healthcare workers, frontline workers, and senior citizens.

Optimized vaccine distribution strategies, resulting in a 25% reduction in vaccine wastage and ensuring efficient allocation based on critical priorities. Data Engineer (Contractor)

John Deere, Waterloo, Iowa Area August 2017 - April 2019

■Relational Database Model Proposal:Proposed and implemented a new relational database model, replacing the legacy system, resulting in a 30% reduction in data mining and processing inefficiencies. Enhanced data retrieval and analysis capabilities, improving overall data handling efficiency.

■Multi-Tool Data Analysis:Utilized a diverse set of tools, including Tableau, Web Intelligence, SAP Business Objects, PDM Link, MS Access, and Excel, to analyze data, streamlining product flow processes. Achieved a 20% reduction in data analysis time by leveraging these tools effectively.

■Logistics Process Optimization:Received, researched, and analyzed data to optimize the logistics process for company products, resulting in a 15% improvement in product flow efficiency. Used optimization algorithms to prescribe actions, enabling managers to make informed decisions, leading to a 25% reduction in process-related errors.

■Program Tracker Development:Developed the "Program Tracker" application, allowing managers to track each program individually and make data-driven decisions, leading to a 30% improvement in program management.

Implemented Business Intelligence and web intelligence techniques to extract and analyze inventory data, improving stock management by 20%.

■Timely Information Delivery:Provided timely and accurate information to department members and external customers, enhancing decision-making processes and customer satisfaction.

■Cross-Functional Collaboration:Collaborated closely with team members to plan, design, and develop solutions, resulting in a 25% improvement in product flow and process control. Used JIRA to efficiently communicate project status across the team, ensuring smooth project management.

■Development Team Support:Assisted the development team in designing, developing, testing, performance tuning, and implementing database applications, improving application efficiency by 20%. Effectively coordinated with other groups to ensure successful design, development, and testing efforts, resulting in seamless integration of application components. Education

Iowa State University - College of Engineering degree, Management Information Systems and 2013 - 2017

Contact this candidate