Shamila Mafazi
Summary
Cross-functional collaborator with experience in creating Python scripts to automate manual processes such as quarterly user access requests and ETL workflows, improving efficiency and accuracy while significantly reducing processing time and errors. This success is demonstrated through collaboration with 10 software packages, including SQL, Synapse, Azure Data Lakes.
Strong communication skills and the ability to synthesize and deliver information effectively to diverse audiences, leading to successful data transformation in an agile environment.
Experience in managing project details and tasks leveraging a diverse technical skill set including Python, MS SQL Server, MongoDB, HTML, PostgreSQL, Oracle, Tableau, Power BI, Microsoft Visio, Java, C++, Hadoop, Git, GitHub, Jira, and XML, PIDX, Synapse, Azure Data Lakes, XSLT proficiency, as demonstrated by implementing 16 software tools.
7+ years of experience collaborating with stakeholders to identify business requirements and desired outcomes, with a focus on data engineering and analytics to drive well-informed decision-making.
Work Experience
Data Integrator September 2024 to Present
Hilcorp Energy Company
Developed Python, XSLT, and batch scripts to convert XML/PIDX/Excel invoices from multiple vendors into Serrala FS2 XML file format.
Wrote and maintained multiple batch scripts to automate the retrieval of invoice files from an SFTP server, process them using the Python script, and ingest them into Serrala FS2.
Collaborated with 20+ vendors to successfully onboard them to the Serrala platform, ensuring smooth integration and compliance.
Data Analyst April 2022 to July 2024
Cardinal Health
Partnered with cross-functional teams across 30+ healthcare programs to gather and refine project requirements, delivering over 50 Tableau dashboards and reports aligned with strategic business objectives.
Developed Python scripts to automate critical business processes such as quarterly user access requests, resulting in reduced processing time by 30% and enhanced operational efficiency.
Developed and implemented complex SQL scripts to extract data and create dashboards, providing data-driven insights that enhanced decision-making accuracy and operational transparency in an agile environment.
Diagnosed and resolved reporting and dashboard issues, increasing user satisfaction and functionality through systematic troubleshooting.
Data Engineer April 2021 to April 2022
NRG Energy
Managed and optimized data ingestion and visualization workflows, enhancing reporting efficiency.
Used Hadoop to query and extract the data, then transferred it into an Excel spreadsheet for analysis.
Automated ETL processes using Python, significantly reducing errors and improving data handling efficiency.
Demonstrated ability to develop dashboards and use data analytics to identify market trends, customer preferences, and competitive landscapes, enhancing strategic decision-making and product positioning.
Data Engineer November 2018 to April 2021
Infodat International Inc.
Developed multiple Python scripts to streamline data integration and parsing, improving the efficiency of data workflows.
Created and optimized Tableau dashboards for a healthcare client, delivering actionable insights that informed business strategies.
Leveraged AI/ML initiatives to implement machine learning algorithms for analyzing diverse data formats, extract data, develop dashboards and reports that resulted in improving decision-making processes.
Software Engineer March 2018 to October 2018
SmartGeoMetrics
Utilized C# programming to design and develop mobile and web applications for Koch Specialty Plant Services, incorporating integrated database functionality.
Strong analytical and communication abilities for identifying, gathering, and documenting business requirements, with expertise in web scraping techniques to extract and organize competitor data for strategic insights and created more than 30 dashboards and reports.
Versatile software development capabilities with skills in database design and integration to create comprehensive, data-driven applications tailored to specific business needs and collaborated with over 30 CRMs and analysts, producing clear, actionable project requirements for effective execution.
Agile Business Analyst February 2016 to June 2017
Eka Software Solution
Data Analyst March 2015 to February 2016
Alerton
Education
Ph.D. in Computer Science February 2011 to March 2015
University of South Australia
M.S. in Computer and Information Sciences January 2009 to December 2010
University of South Australia
B.S. in Computer Software Engineering January 2001 to January 2005
Shiraz Azad University
Skills List
Data Transformation
Tableau, Power BI, Spotfire
Collaboration Skills
Data Cleaning
Documentation and Reporting
Process Automation
SQL
Technical Writing
Automation
Business Intelligence
Cross-Functional Collaboration
Data Engineer
Organizational Skills
Python
SQL Scripts
AI/ML Initiatives
Business Solutions
Dashboard Development
Data Engineering
Presentation Skills
Requirements Gathering
Stakeholder Communication
Affiliations & Hobbies
Sports enthusiasts, outdoor activities
Association for Women in Computing
Women in Machine Learning (WiML)
PhD Scholarship
*******.******@*****.***
https://www.linkedin.com/in/shamila-mafazi/