Faramarz Amirshahi
Toronto,Canada
Summary
Detail-oriented Data Engineer, designs, develops and maintains highly scalable, secure and reliable data structures. Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive data models. Proficient at developing database architectural strategies at the modeling, design and implementation stages.
Overview
25
25
years of professional experience
Work History
Data Engineer
Ontario brain Institute
10.2023 - 07.2024
- Conducted extensive prototyping to ensure the solidity of design specifications and obtained 20% increase in design accuracy and a 15% reduction in engineering rework
- Gathered requirements for data discovery, ingestion, long term storage, and data sharing for the new platform hosted on Azure to determine the best approach
- Worked with external partners to enhance data discovery strategies, gather metadata, and standardize terminologies for participation in federated data initiatives
- Designed and implemented a robust data pipeline that recursively extracted data from incoming zip packages, partitioning 500+ tabular files by participant demographics, improving search efficiency by 40%
- Crafted a data interface that enabled the generation of JSON-formatted metadata files for efficient data-sharing process that supported 25+ research collaborations
- Created an end-to-end data ingestion pipeline utilizing Azure Blob Storage, which streamlined data flow, increasing overall data quality and accuracy for data sharing purposes
- Developed a scalable SQL architecture for managing metadata in data packages; reduced data retrieval times by 25%, enabling overall operational efficiency
- Built a comprehensive architecture for data pipelines using Python and Azure Durable Functions, streamlining ETL processes and improving data accuracy, which enhanced reporting speed by 30%
Data Architect
Vector Institute
10.2020 - 04.2023
- Spearheaded the design, development, and deployment of GEMINI data platform for clinical and administrative data that lowered the data processing time by 60% and increased data accuracy by 80%
- Analyzed data patterns to architect and develop reusable base code components for seamless data flow pipeline, reducing development time by 40% and improved scalability
- Leveraged the CIHI data standards specifications documents to map GEMINI clinical data to standard vocabularies such as ICD10, SNOMED, LOINC and RXNORM
- Developed project plan with detailed Work Breakdown Structure to identify project milestones, dependencies, and deadlines; ensured on-time delivery
- Conceived a data cataloging system that enhanced search capability and accessibility of data assets, reducing time spent searching for data by 40%
- Researched clinical data models and identified OHDSI OMOP common data model as optimal choice; adopted model to expose GEMINI data and boosted data integration time by 50%
- Championed the strategic direction of the project by presenting the architecture vision to the stakeholders, garnered support and secured budget for hardware and software procurement
- Mentored junior team members, ensuring adherence to data solutions templates, increasing data accuracy by 15% and raising overall team performance
- Developed a comprehensive security model aligned with research ethics board guidelines, ensuring data governance, and safeguarding sensitive information, dropping data breaches by 20%
Associate Director
IQVIA CANADA
01.2015 - 06.2020
- Led the implementation of a business intelligence system on AWS cloud platform; collaborated with cross-functional teams to integrate data from 20+ sources with a unified data view that lowered data retrieval time by 40%
- Mastered physicians and products in Reltio cloud-hosted MDM, pulled golden records into HIVE database (S3) via API calls and Spark libraries; optimized Spark jobs to improve performance by 60%
- Transformed business operations through effective data management strategies that improved operational efficiency by 15%
- Guided the business analysis team in documenting and tracking incoming data, resulting in a 40% reduction in data entry errors and better data accuracy for more informed decision-making and faster development cycles
- Orchestrated seamless collaboration between on-shore and off-shore delivery teams to ensure successful project delivery; decreased deadline extensions by 40%
Data engineer
IQVIA CANADA
02.2007 - 01.2015
- Performed end-to-end ETL processes using Informatica for data integration from various sources into a centralized data warehouse, obtaining a 40% reduction in data loading time
- Directed efforts to optimize data infrastructure, identifying and resolving bottlenecks to improve data reliability, efficiency, and quality; implemented data governance policies and procedures reducing data errors by 20% and augmenting overall data integrity
- Analyzed sales activity data from 200 Siebel local databases and recovered 95% of lost data back onto the centralized database
- Prepared training material and instructed the non-technical staff on the data processes and data transformation tools
- Composed and executed a data migration plan for multi-tiered environments; errors shrank by 40%
- Counseled the Kaizen team as data SME to develop a more efficient system that shortened delivery time by 30%
Senior consultant
CGI group
04.2006 - 02.2007
- Devised an ETALK voice recording solution within Siebel CRM using web-services that improved the service request response time by 40%
- Created a Java program using Siebel Java beans to update primary and foreign keys to update millions of rows
- Co-ordinated a team of DBAs for Bell Canada Siebel BI implementation to optimize the ETL execution time by 80%
Senior consultant
SKURA CORPORATION
02.2002 - 04.2006
- Led the data migration and integration for five full-cycle Siebel CRM implementation projects
- Designed and built several interfaces for integrating third party suppliers’ sales data into the client CRM system
- Conceived and implemented a harmonized data mart for structuring and centralizing siloed sales activity from Siebel systems across the globe that elevated the sales results by 30%
- Guided a disaster recovery simulation to restore production data using database backups in a remote environment; identified and resolved critical system vulnerabilities, reduced recovery time by 30%
Database administrator
SKURA CORPORATION
01.2000 - 02.2002
- Accelerated the migration of legacy data onto Siebel CRM at BI Pharmaceuticals in a record 3-month timeline; integrated 2 years of data with less than 10% data loss
- Managed the installation and performance tuning of Oracle RDBMs for the CRM implementation
- Revamped existing data processes to improve delivery time by 40%
Education
Bachelor of Science - Electronic Computer Systems
Salford University
Certificate - Data Analytics Boot Camp
University of Toronto S.C.S.
02-2021
Skills
- Data governance
- Data curating
- Data warehousing
- Data modeling
- Data integration
- ETL development
- Scripting languages
- API development
- NoSQL databases
- Performance tuning
- Relational databases
- Database design
- Data pipeline control
- Big data technologies
- SQL and databases
- Data analysis
- SQL programming
Languages
French
Limited Working
Italian
Full Professional
Persian
Native or Bilingual
Timeline
Data Engineer
Ontario brain Institute
10.2023 - 07.2024
Data Architect
Vector Institute
10.2020 - 04.2023
Associate Director
IQVIA CANADA
01.2015 - 06.2020
Data engineer
IQVIA CANADA
02.2007 - 01.2015
Senior consultant
CGI group
04.2006 - 02.2007
Senior consultant
SKURA CORPORATION
02.2002 - 04.2006
Database administrator
SKURA CORPORATION
01.2000 - 02.2002
Bachelor of Science - Electronic Computer Systems
Salford University
Certificate - Data Analytics Boot Camp
University of Toronto S.C.S.
Similar Profiles
Faramarz AmirshahiFaramarz Amirshahi
Data Engineer at Ontario Brain InstituteData Engineer at Ontario Brain Institute
Don GustinDon Gustin
Full Time - Rehabilitation Support Worker at Brain Injury Services of Northern OntarioFull Time - Rehabilitation Support Worker at Brain Injury Services of Northern Ontario
Hanzhang LyuHanzhang Lyu
Lab Assistant at The Brain Cognition And Brain Disease InstituteLab Assistant at The Brain Cognition And Brain Disease Institute
Andrea Lira SanmiguelAndrea Lira Sanmiguel
AUDIO MIXER & BOOM OPERATOR at Toronto Film SchoolAUDIO MIXER & BOOM OPERATOR at Toronto Film School
Mohammad Zahir NasratMohammad Zahir Nasrat
Admin/Finance Officer at NWARA-CPMOAdmin/Finance Officer at NWARA-CPMO