Golnar Bidkhori

ETL Project

• Work on ETL (Extract, Transform, Load) projects using Matillion and Snowflake, overseeing the end-to- end data integration process.
• Monitor and optimize ETL processes for performance, reliability, and data quality, proactively addressing any issues that arise.
• Conduct thorough testing and validation of ETL workflows, ensuring the integrity and completeness of transferred data.
• Stay up-to-date with industry best practices and emerging technologies in ETL and data integration to continuously enhance project efficiency and effectiveness.

Data Issue Identification and Resolution

• Proficiently identify data discrepancies and issues within the organization's databases using SQL queries.
• Conduct comprehensive data analysis to pinpoint root causes of data inaccuracies and anomalies.
• Maintain clear and organized documentation of data issues, resolutions, and preventive measures for future reference.

Client Engagement and Data Solutions

• Collaborate with clients to address data-related concerns and provide effective solutions that align with their goals.
• Provide expert guidance and consultation to clients on data best practices, ensuring data-driven decision- making.
• Regularly assess client satisfaction and feedback, proactively identifying opportunities to enhance service and deliver exceptional value.

Onboarding and Training Leadership

• Take the lead in facilitating the onboarding and training process for new team members, ensuring a seamless transition into the organization.
• Share your expertise in data management tools and best practices, providing comprehensive guidance on data handling, analysis, and reporting.
• Act as a mentor and resource for new hires, offering ongoing support and guidance to promote skill development and professional growth.

Custom Report Design and Data Visualization

• Utilize Sisense, a Business Intelligence (BI) tool, to design and develop custom reports tailored to the specific needs of clients.
• Collaborate with clients to gather report requirements, ensuring alignment with their data-driven objectives.
• Implement data filters, drill-down functionalities, and dynamic features to enhance the usability of reports.
• Ensure the accuracy and reliability of data presented in reports, conducting data validation and verification processes.
• Stay updated with Sisense features and best practices to continuously improve report design and data visualization capabilities.

Documentation Development and Maintenance

• Take ownership of developing and maintaining comprehensive documentation, including process manuals, standard operating procedures (SOPs), and user guides.
• Ensure all documentation is clear, accurate, and accessible, adhering to established company standards and best practices.
• Collaborate with cross-functional teams to gather information and insights necessary for creating effective documentation.
• Conduct audits of existing documentation to identify gaps, inconsistencies, or areas for improvement.
• Maintain version control and organized access to documentation, facilitating efficient retrieval and knowledge sharing.

GitHub Codebase Management

• Regularly push data transformation scripts and code changes to the organization's GitHub repositories.
• Implement best practices for Git workflows, such as feature branching, pull requests, and code reviews, to streamline collaboration and code quality.
• Maintain clear and up-to-date documentation within the codebase, including README files and comments, to facilitate understanding and usage by team members.

CSV Data Ingestion Script Development

• Develop and maintain PHP scripts for the ingestion of data from CSV files into the organization's database.
• Implement error handling and data validation mechanisms to address potential issues during the ingestion process.
• Regularly update and enhance the scripts to accommodate evolving data sources and business needs.
• Document the scripts comprehensively, including usage instructions and data mapping, to facilitate seamless operations for other team members.

Automated Test Creation

• Develop automated test scripts using TestComplete and Cucumber to validate software functionality and performance.

• Collaborate with the development team to ensure automated test cases are aligned with software requirements.

Feature Testing

• Conduct thorough testing of newly released features to verify their functionality and compatibility with existing systems.
• Identify and report any issues or bugs discovered during testing, ensuring timely resolution.

Issue Reproduction and Ticket Creation

• Investigate and reproduce reported issues to verify their validity.
• Document detailed steps to reproduce issues and create Jira tickets for the engineering team, including all relevant information for efficient resolution.

API Testing

• Verify the accuracy of API calls, responses, and data handling.