Amir Sayed
Brandon,FL
Summary
Accomplished Technical Architect offering 15+ years' experience in comprehensive design and development of infrastructure and architecture for software projects. Attentive collaborator and communicator from project conception to completion. Creative in devising solutions to improve business operations and meet clients' technical needs. Seasoned team leader possessing the technical and interpersonal skills to provide exceptional project deliverables.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Technical Architect
HCL America
10.2023 - Current
- Azure Synapse Technical Architect
- Performed quality code review and removed technical debt and security vulnerabilities.
- Provided technical leadership to team members during system design.
- Resolved complex technical issues by troubleshooting systems, analyzing root causes, and implementing effective fixes.
- Developing Data use cases for organization
- Designing Logical Data Model
- Implementing cost effective solution architecture
- Designing End to End Solution Architecture
- Responsible to train & on board new joiner in Team
- Analyzing & Optimizing ADF pipelines & Spark notebooks
- Analyzing & Optimization of SQL stored Procedure & SQL Views i.e
- Estimated execution plan vs actual execution plan
- Responsible to sanitize the unwanted/unused indexes in sql server.
- Responsible to train resources on Devops, i.e
- Pull request & releases
Technical Architect - Data
HCL Technologies
12.2021 - 10.2023
- Azure Synapse Technical Architect
- Performed quality code review and removed technical debt and security vulnerabilities.
- Provided technical leadership to team members during system design.
- Resolved complex technical issues by troubleshooting systems, analyzing root causes, and implementing effective fixes.
- Developing Data use cases for organization
- Designing Logical Data Model
- Implementing cost effective solution architecture
- Designing End to End Solution Architecture
- Responsible to train & on board new joiner in Team
- Analyzing & Optimizing ADF pipelines & Spark notebooks
- Analyzing & Optimization of SQL stored Procedure & SQL Views i.e
- Estimated execution plan vs actual execution plan
- Responsible to sanitize the unwanted/unused indexes in sql server.
- Responsible to train resources on Devops, i.e
- Pull request & releases
Sr. Consultant - Data & BI
Capgemini
03.2016 - 12.2021
- Responsibilities as Solution Architect
- Responsible for data analysis & data cleansing activity
- Responsible to convert data in to meaning full Reports & Dashboard
- Acts as a key contributor to the design and development lifecycle of analytic applications
- Requirement gathering
- Responsible for Technical Design Specification
- Responsible for Development & Deployment
- Responsible to create & maintain dashboard report for Business stack holder
- Responsible to convert BRD document to Technical Specification document
Sr. Software Engineer
Ingram Micro
10.2013 - 03.2016
- Acts as a key contributor to the design and development lifecycle of analytic applications
- Designing & Developing SSRS report, i.e
- Dashboard, Drill down reports
- Responsible to do Data Analysis
- Acts as a key contributor to the design and development lifecycle of analytic applications
- Responsible to create & maintain dashboard report for Business stack holder
- Responsible to configure Azure DevOps ARM Template
Sr. Software Engineer
Ness Technologies
11.2012 - 10.2013
- Responsible for Requirement gathering
- Creating Low Level Technical Design Document
- Creation High Level Technical Design Documents
- Creating for performance optimization of ETL
- Design & Development of SSIS & SSRS reports
Software Engineer
IBM
03.2012 - 08.2012
- Responsible to create data driven Dashboard for Business Executive
- Responsible for data cleansing & consolidation
- Responsible to create & support ETL tool i.e
- SSIS
- Design & Development of SSRS Reports
- Peer Code review optimizing T-SQL queries & report performance
Consultant
Capgemini
04.2008 - 11.2011
- Support & Development of SSIS pipeline
- Support & Development of Resource Utilization Dashboard for RMG
- Requirement gathering & development of BRD documents
- Creating Low Level Design document preparing unit test cases
- Doing peer code review
Education
Bachelors Degree in Commerce -
Mumbai University
01.2010
Higher Secondary School -
Maharashtra College, Mumbai Central
04.2000
Secondary School (S.S.C) -
Diamond Juliee High School, Mazgaon Mumbai
03.1998
Skills
- Building Data Strategy & Roadmaps
- Azure Synapse & Sparks
- Data Governance & Compliance MS Azure
- Cloud Data Lake & Data Warehouse on AZURE
- BI Tool implementation [ Tableau & MS Power BI ]
- Databricks SQL Server Analytics Service, SSRS
- R, Python ETL & ELT performance optimization
- Enterprise Architecture Design
- Infrastructure Automation
- Communicating with clients
- Client Engagement
Certification
- DP203 - Azure Data Engineer
- DA100 - Power BI
- 70-461 - Quering Microsoft SQL server
Volunteer Experience
In-house Trainer, HCL Technologies, 02/2022, Present, Pune, Providing training to new joiner & intern on Azure Data Factory & Azure Synapse Analytics
Experienceyears
15
Hobbies and Interests
- Reading Technical books & blogs
- Technology Evangelist Interest
Timeline
Technical Architect
HCL America
10.2023 - Current
Technical Architect - Data
HCL Technologies
12.2021 - 10.2023
Sr. Consultant - Data & BI
Capgemini
03.2016 - 12.2021
Sr. Software Engineer
Ingram Micro
10.2013 - 03.2016
Sr. Software Engineer
Ness Technologies
11.2012 - 10.2013
Software Engineer
IBM
03.2012 - 08.2012
Consultant
Capgemini
04.2008 - 11.2011
Bachelors Degree in Commerce -
Mumbai University
Higher Secondary School -
Maharashtra College, Mumbai Central
Secondary School (S.S.C) -
Diamond Juliee High School, Mazgaon Mumbai
- DP203 - Azure Data Engineer
- DA100 - Power BI
- 70-461 - Quering Microsoft SQL server
Similar Profiles
Allie StockAllie Stock
ESCALATON MANAGER at HCL AmericaESCALATON MANAGER at HCL America
Gnanamoorthi SundharamoorthiGnanamoorthi Sundharamoorthi
Senior Software Engineer at HCL AmericaSenior Software Engineer at HCL America
ONOME TILAONOME TILA
Sr. SAP Concur Consultant at HCL AmericaSr. SAP Concur Consultant at HCL America