Database Developer Support Engineer

Matineh Kashani

*******.*******@*****.***

Tel: (604) -442 -7150

Work Authorization: Canadian Citizen

Work Experience

Data Engineer

REEF Technology, Vancouver, BC February 2019 – Present

(AWS, Python, SQL, Redshift, S3, Spark, Hive, Cloudera, Airflow, Git, Jira) Collaborate with Data Science, Business Intelligence, Data Analytics, Product Management and DevOps teams:

• Write code and design ETL pipeline architecture

• Build pipelines that support the ingestion, analysis, and enrichment of data

• Improve the existing pipeline to increase the throughput and accuracy of data

• Identify areas of automation opportunities and implement improvements

• Work with the Product Manager to map general accounting concepts to the internal data models in a repeatable and precise fashion

• Analysis of data models and schemas, and work with other engineering staff to recommend extensions and changes

• Use investigative tools and database queries to automatically flag irreconcilable data within production datasets

Database Developer

BGC Engineering Inc, Vancouver, BC August 2018 – January 2019

(Python, SQL, Power Bi)

Collaborated with Human Resources, Accounting and Software Engineering teams:

• Designed, developed and upgraded the HR system

• Worked on both back-end database MSSQL and the interface dashboard

• Developed queries and/or gathering data from various sources; in addition, interpret the data to provide value added analysis

• Provided support for business process integrity to ensure ongoing employee information accuracy and makes recommendations for process enhancements and improvements by researching methods to continue to automate and streamline processes

• Worked on gathering, identification, documentation and tracking of business requirements and processes

Software Support Engineer/Analyst

CERTONA, San Diego, CA June 2016 – July 2018

(AI – based personalized product recommendation engine software application (SaaS) running on top E-commerce sites)

Collaborated with Client Services, Data Science, Business Intelligence and Analytics teams:

• Performed tasks associated with receiving, processing, modifying, and troubleshooting XML and text-based product catalog feeds from clients and loading data into client specific SQL Server databases

• Worked on writing rules as stored database procedures (T-SQL) to receive data requests and filter appropriate responses in a client server architecture

• Created various forms of complex XSLT transform files in a format that can be used for JSON and web services implementation method to render recommendation boxes on client webpages

• Wrote and modified codes in JavaScript/jQuery and troubleshooting HTML, CSS and JavaScript issues in regular web and mobile environments

• Provided Analysis on client’s implementation and create tagging instruction according to their method of implementation

• Provided technical guidance to technical and non-technical teams and clients Software Support Engineer/Analyst

ECHO, A HealthStream Company, San Diego, CA December 2015 - May 2016 Collaborated with Customer Service, Application Support and Data Analytics teams:

• Analyzed and developed SQL scripts to perform transfer of data from client data sources to company software products

• Write and modify stored procedures and triggers using Microsoft SQL Server

• Created, modified, tested and troubleshot portal pages using SQL, JavaScript/jQuery, VB Script, ASP and HTML/CSS

• Worked with clients during the implementation of all software products, including troubleshooting, Updating, Upgrading and Installing proprietary software on client’s environment

• Worked with multiple departments as necessary to ensure the successful execution of data transfer and software implementation projects to provide a positive experience for clients Researcher (Machine learning and Data mining)

California State University, CSUSM, San Diego, CA September 2014 – May 2015

(Data Mining on Healthcare Data, Machine Learning, Evolutionary Algorithms, Python) Managed and led a team of software engineers and data scientists to research and deliver the project in the field of Bioinformatics and Drug Discovery resulted in two published papers:

• Researched and analyzed linear and non-linear machine learning models to create the QSAR model that can lead to the most accurate prediction of drug performance

• Researched on evolutionary algorithms as feature selection technique for QSAR modeling. Specifically researched on hybrid Differential Evolutionary - Binary Particle Swarm optimization algorithm to improve HIV-1 Integrase inhibitors prediction

• Developed the back end of an interactive System to perform linear and non-linear machine learning modeling with variety of evolutionary algorithms using Python, Django Web Framework and implemented a repository database by PostgreSQL Education

Master of Computer Science, MSc (Machine learning and Data mining) California State University, San Marcos, CA 2013 – 2015 Certificate of Technology in Software Systems Development British Columbia Institute of Technology, Vancouver, BC 2010 – 2011 Bachelor of Computer Sciences and Software Engineering, BSc Tehran Azad University 2004 - 2008

Publications

• IMPROVING THE FEATURE SELECTION FOR THE DEVELOPMENT OF LINEAR MODEL FOR DISCOVERY OF HIV-1 INTEGRASE INHIBITORS

ABDA'15 - THE 2ND INTERNATIONAL CONFERENCE ON ADVANCES IN BIG DATA ANALYTICS. LAS VEGAS, NEVADA. JULY 2015

• IMPROVING PHARMACOLOGICAL RESEARCH OF HIV-1 INTEGRASE INHIBITION USING DIFFERENTIAL EVOLUTION-BINARY PARTICLE SWARM OPTIMIZATION AND NON-LINEAR ADAPTIVE BOOSTING RANDOM FOREST REGRESSION

16TH IEEE INTERNATIONAL CONFERENCE ON INFORMATION REUSE AND INTEGRATION AUGUST 2015. SAN FRANCISCO, CALIFORNIA

References are available upon request

Contact this candidate