Satya M

Total 7+ Years of IT Experience in the field of Data warehousing. Developing ETL process using tool like Snaplogic. Exposure on AWS services like Redshift, S3, RDS, IAM, EC2, API Gateway & CloudWatch.

Salesforce CRM, Configuration, Data loader. Worked in various domains like Campaigning, Retail and Pharmaceuticals. Strong data processing experience in designing and implementing Data Mart and data warehousing applications, mainly Transformation processes using ETL tool Snaplogic.

Implementation of full lifecycle in Data warehouses and Business Data marts with Star Schema. Working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL). Expertise in implementing Complex Business rules by creating robust Pipelines, reusable transformations.

Experience in programming using SQL. Extensively performed Unit testing, Performance, System, Integration and user testing in various projects.

Experience with Data Cleansing, Data Profiling and Data analysis.

Snaplogic Developer - Snovaspace

(2018-01 - 2023-01)

Lead Consultant - Snovaspace

(2023-01)

Snaplogic Developer - Confidential

(2023-01)

This project deals with creating interfaces and enhancing the data flow to support the transactions, product promotions, Sales management, Customer Interactions of the Users in the European region.

• Designed, developed, managed and monitored pipelines to process data using Snaplogic Elastic Integration iPaas, collected data from heterogeneous sources like flat files, Excel sheets, SOAP and REST services, SQL server databases and loaded to Amazon redshift and other SaaS.
• Automated ETL processes using Snaplogic and cloud technologies (AWS) across billions of rows of data which reduced manual workload by 40% monthly.
• Managed Snaplogic servers, pipelines and scheduled / triggered tasks.
• Participated on a daily standup and sprint planning Meeting.
• Responsible for Application Support activities which include resolving production failures, bug fixing and doing root cause analysis for job failures.
• Creating deployment objects to deploy Snaplogic objects to Dev,Test,UAT and PROD.
• Wrote python and shell script to perform operations or tasks that are currently not supported by Snaplogic.
• Used Amazon S3 as a main storage for loading files and as backup storage Redshift snapshots and unload operations.
• Documented projects and debugging instructions to be used by all level developers.
• Worked directly with Snaplogic support team to debug and fix issues.
• Proficient in AWS services like Redshift, EC2, S3, Athena, RDS, IAM, CloudFormation, CloudWatch.
• Processed and loaded billions historic and hundreds of millions daily incremental feed data to Amazon redshift to be used by analytic team.

BSC - Computer Science - Gujarat, India