Satyam Machhi
Pune
Summary
Over 12 years of extensive experience in information technology, including 9+ years of specialized expertise in data analysis, ETL design, data modeling, and data architecture. Expertise in Azure cloud architecture and automation, with a strong background in data storage, pipeline, and performance optimization. Proficient in SQL and ETL development within data warehousing environments
Overview
12
12
years of professional experience
1
1
Certification
Work History
Assistant Manager, Professional Services
Nice Software Solutions
Pune
04.2017 - Current
- Designed and executed POCs utilizing Azure Data Factory and Azure Synapse Analytics to demonstrate the efficacy of data integration and analytics solutions. Leveraged these tools to streamline data pipelines, and validate business requirements, resulting in actionable insights for stakeholders
- Architected, Directed, Developed and Managed the Data Pipeline for multiple projects for one of the leading banks in Middle East
- Engaged directly with managers, and group heads to thoroughly understand business requirements and effectively translate those needs into data warehouse schemas and actionable reports on business intelligence platforms
- Completed project assignments focused on developing ETL solutions using Snowflake, where I segregated data using SQL scripts and designed data pipelines to ensure efficient data integration and transformation.
- Served as a consultant on a diverse array of projects, collaborating with clients to identify their challenges & objectives and provided solutions.
- Delivered tailored strategic solutions, leveraging data analysis and industry best practices to enhance operational efficiency and drive measurable improvements in performance.
Associate Projects
Cognizant Technology Solutions
Pune
07.2016 - 04.2017
- Designed the DWH by extracting records from various sources, applying business logic, and loading the data into the warehouse utilizing the SCD Type 2 method, along with an audit table mechanism.
- Created, tested, and validated ETL codes across DEV, UAT, and PROD environments. Extensively employed complex SQL scripts and queries, and developed views and stored procedures for comprehensive data validation at the backend
Software Engineer
Mphasis Limited
Pune
09.2012 - 06.2016
- Participated in the development and enhancement of various applications for report generation through multiple data marts as part of the client onboarding and offboarding process, in response to the relocation of the bank's headquarters from the Netherlands to Edinburgh, UK
- Actively monitored existing workflows to ensure the accurate loading of data from various sources into the respective data warehouse.
Education
Bachelor of Engineering - Electronics & Communications
Dharmasinh Desai Institute of Technology
Gujarat, India05-2011
Skills
- ETL: Informatica PowerCenter, IICS - CDI, CDQ, Informatica Data Quality, Azure Data Factory, Snowflake, SSIS
- Cloud: ADF, Azure Synapse Analytics, IICS, Snowflake
- Database: SQL Server, Oracle, Snowflake, AWS Redshift, DB2
- Other tools: Zeppelin, Hive, ServiceNow
Certification
- SNOWPRO Core
- PC to IICS migration
- CDI modernization
Timeline
Assistant Manager, Professional Services
Nice Software Solutions
04.2017 - Current
Associate Projects
Cognizant Technology Solutions
07.2016 - 04.2017
Software Engineer
Mphasis Limited
09.2012 - 06.2016
Bachelor of Engineering - Electronics & Communications
Dharmasinh Desai Institute of Technology
Similar Profiles
Vijay ChauhanVijay Chauhan
Principal Consultant at Nice Software Solutions Pvt. Ltd.Principal Consultant at Nice Software Solutions Pvt. Ltd.
Nishant AgarwalNishant Agarwal
Senior Consultant at Nice Software Solutions Pvt. LtdSenior Consultant at Nice Software Solutions Pvt. Ltd
Austin HolversonAustin Holverson
RVP of Partner Sales at NICE (Contact Center Software)RVP of Partner Sales at NICE (Contact Center Software)