Lance Main Email & Phone Number

● Apply Agile and Waterfall methodologies to effectively manage and execute data analysis projects, ensuring timely delivery and alignment with business goals.● Utilized Python for data manipulation and analysis, automating repetitive tasks such as data cleaning and transformation, which reduced processing time by 50%.● Automated data processing pipelines in Visual Studio Code by integrating various Python libraries, enhancing the scalability and speed of data workflows.● Developed custom data pipelines using Pandas to preprocess and clean data, ensuring high-quality inputs for analysis and modeling.● Created detailed and informative visualizations using Matplotlib, presenting complex data insights through line graphs, bar charts, and scatter plots.● Customized data visualizations in Tableau to highlight critical trends and patterns, enhancing the clarity and impact of presentations.● Developed and maintained data integration packages using SQL Server Integration Services (SSIS), facilitating the seamless flow of data across multiple systems.● Developed and executed ETL processes to integrate data from various sources into Oracle RDBMS and Microsoft SQL Server, ensuring seamless data flow and consistency.● Executed data extraction, transformation, and loading (ETL) processes in AWS RDS, enabling seamless data integration across multiple platforms.

● Utilized Agile methodology for end-to-end project management, including requirements gathering, planning, design, and deployment.● Conducted high-level data analysis using Python, R, and SQL, generating insights that enhance operational efficiency by 15%.● Performed comprehensive data analysis using Python with PySpark, accelerating dataset processing by 50%, and supporting strategic initiatives through actionable insights.● Improved data quality and analysis speed by 30% through advanced data wrangling and cleaning techniques using Pandas and NumPy.● Lead a project to streamline data analysis workflows, achieving a 30% reduction in turnaround time for analytical reports.● Executed data analysis and validation by crafting complex SQL queries using MySQL, ensuring accuracy and reliability of data.

Master Of Science - Ms, Information Systems

Bachelor Of Engineering - Be, Information Technology