Syed S A Rizvi

About Syed S A Rizvi

Over 14+ years of experience in Information Technology including full software development life cycle as Architect and Developer in Banking, Retail, Healthcare, Social Media and Telecom domains. Expert in Snowflake Expert in Snowflake Performance tuning and cost optimization of Warehouses, creation of Store Procedures for Database, Schema, Tagging, and Warehouse creation using JavaScript and Terraform. Extensive experience in Data Warehousing implementations, Data Migration, and ETL for Retail, Banking, Telecom & Healthcare Domains. Extensive experience in migrating Multi-Tera Bytes of Oracle Data Warehouse to Amazon Redshift. Extensive experience in AWS Redshift’s encoding, distribution style, storage, and performance. Experience in system analysis, design, and coding. AWS Tech stack experience (IAM / S3 / EC2 / Redshift / Cloudformation / Lambda / Glue / PySpark / CloudWatch / DocumentDB / AppSync). Good understanding of ETL techniques and best practices to handle extremely large volumes of data. Extensive experience in developing stored procedures, functions, Views and Scheduler, Complex queries using SQL, PL/SQL. Experience in resolving ongoing maintenance issues and bug fixes; performance tuning of mappings and sessions. Good experience in loading metadata and data from different source systems into target systems. Conducted training sessions for new team members to understand the process. Exceptional analytical, troubleshooting, organizational, communication, prioritization, problem-solving, and leadership skills with the ability to create and sustain a high work tempo. Superior communication, decision-making, and organizational skills along with outstanding analytical and problem-solving skills to undertake challenging jobs. Able to work well independently and in a team by helping to troubleshoot technology and business-related problems. Working experience with Agile Tools (Jira) & Release Pipeline (Bitbucket) following CI/CD philosophy. Worked on cross-skill technologies like WhereScape RED, StreamSet, InfluxDB & Grafana through self-training. Technology: AWS, Snowflake, Python, UNIX, Bitbucket, WhereScape RED, StreamSet, Oracle 11g, SQL, PL/SQL, MongoDBDatabase: Oracle, AWS Redshift, InfluxDB, BigQuery, DocumentDB, MongoDB, SnowflakeAWS Services: Cloudformation, Lambda, CloudWatch, S3, VPC, API Gateway.GCP : BigQuery, GCS, Data FusionTools: SQL Developer, SQL WorkbenchLanguage: Python, Shell Script, Snowpark, TerraformOther Technology: Jenkins, CI/CD, JIRA s••••••••@gmail.com

Experience

1. Data Engineering Associate Manager

   Accenture

   Feb 2021 — Present · Bengaluru, IN

   Creating Snowflake UDF, Task, Tables, etc using Terraform Writing script to create several types of Alert using Snowflake, Jenkins, Shell script, HTML Working on Redshift WLM, Performance tuning, defining the guidance how to improve the Redshift Database Working on Data Loading and Transformation in Snowflake Working on Snowflake Virtual Warehouse and Concurrency Writing DDL and complex SQL queries to build procedures, monitoring queries, etc. Created Data Sharing in Snowflake by applying automation process Worked on creating Data Masking Created cloning objects, used time travel to recover the lost data Worked on preparing the POC on Streamlit, Snowpark and prepared the guideline. Also working on Snow Analyzer and SnowConvertor(Convert PySpark code to Snowpark compatible code) Build Alerting framework for Snowflake using Jenkins to send alert on email as well as on MS Teams Group Creating Jenkins pipelines to build automation process for Users to perform different types of activities like Password rotation, warehouse creation, user creation, etc. Created MongoDB cluster, database and collections, Setup the Realm app and created functions, Custom resolver, Relationship Created multiple APIs using API Gateway which are getting used from UI to connect to the databaseSetup the AWS DocumentDB and created collection, created AppSync Schema, Resolver and Lambda function with API to trigger the Lambda Setup of SES domain and integrating with Accenture domain to receive the email alert Collaborating with the team to resolve the HTTPS issue for the UI Worked as a tech lead in large scale transformation program for a leading telco, helping them to migrate from AWS Cloud to GCP Cloud Applied logic to fix special character issue in StreamSets pipeline Provided the solution and working on cross skill to resolve on going issues

Education

• S.G.G.S College

  I.Sc (Mathematics), Physics,Chemistry,Maths,English,Hindi,Urdu

  2003 — 2005

• Rajiv Gandhi Prodyogiki Vishwavidyalaya

  Engineer’s Degree, Information Technology

  2005 — 2009

• Patna Muslim High School

  10th, English,Udru,Maths,Science,Soc Science

  2002 — 2003

Skills

• Oracle
• Requirements Analysis
• Database Administration
• Sql
• Oracle Sql
• Extract, Transform, Load (Etl)
• Unix
• Oracle Database
• Sql*Plus
• Scripting
• Amazon Redshift
• Odi
• Data Warehousing
• Etl
• Database Design
• Mysql
• Aws S3
• Postgresql
• Oracle Pl/Sql
• Oracle Sql Developer
• Shell Scripting
• Data Migration
• Business Process
• Unix Shell Scripting
• Sap Hana
• Toad
• Erp
• Team Management
• Databases
• Pl/Sql