SUMMARY

• 11 years of IT Experience in Architecture, Analysis, design, development, implementation, maintenance and support, with experience in developing strategic methods for deploying real - time applications with Snowflake, Python, DBT, Oracle, UNIX, Kubernates, AWS.
• A Cloud enthusiastic team player having around 11 years of Experience in IT industry as a Cloud DevOps Engineer with proven expertise in Automation, Build/Release Engineering and Software development involving cloud computing platforms like Amazon Web Services (AWS and Google Cloud (GCP).

TECHNICAL SKILLS

Technologies: Snowflake, Kafka, Airflow, DBT

Language: SQL, Python, Java Script, Shell scripting, Restful Web Services, XML/JSON.

Databases: Oracle, MySQL, Redshift.

ETL & Reporting Tools: Talend, Tableau and PowerBI

Tools: GoldenGate Replicat, Databricks, Jenkins, Terraform, AWS, Azure, GCP, Kubernetes Service.

PROFESSIONAL EXPERIENCE

Confidential, Duluth, CA

Senior Cloud Lead Engineer

Responsibilities:

• As a Data Engineer in Data Platform team, I am responsible for designing, architecting and implementing secure batch and real-time applications using Snowflake, Python, Airflow, DBT, and Kubernetes.
• Configured three types of blobs, block blobs, page blobs, and append blobs in Azure for storing a large amount of unstructured object data such as text or binary data, that can be accessed from anywhere via HTTP or HTTPS.
• Built Snowpipe for continuous data ingestion into snowflake from different sources.
• Created external and internal stages and loaded the data from external & internal sources.
• Used cloning feature in Snowflake.
• Set up a GCP Firewall rules in order to allow or deny traffic to and from the VM's instances based on specified configuration and used GCP cloud CDN (content delivery network) to deliver content from GCP cache locations drastically improving user experience and latency.
• Hands on Experience in using Timetravel.
• Created roles for different teams like DB Owner, reader analyst.
• Developed cost analysis dashboard using snowsight.
• Used COPY to bulk load the data.
• Experience in DBT to perform transformations, clean and apply aggregations on data.
• Optimized and fine-tuned complex queries.
• Experience in Apache Airflow for orchestration complex workflows, data processing pipelines.
• Created data sharing between snowflake accounts.
• Developed SQL queries using SnowSQL & Web console.
• Knowledge on Dynamic Data masking to hide sensitive customer data.
• Enabled role-based security access using snowflake tag-based security.
• Improved the efficiency of the team by implementing CI/CD process and which enabled faster releases.
• Improved data quality by enabling dynamic quality checks.
• Redesigned the Views in snowflake to increase the performance.
• Developed transformation logic using snowpipe.

Environment: Snowflake, Python, DBT, Airflow, Kubernates, Goldengate Replicat, AWS, Azure, Jenkins, Git, Kafka.

Confidential, Exton, PA

Cloud Engineer

Responsibilities:

• Responsible for all activities related to development, implementation, administration and support for large scale Snowflake cloud data warehouse.
• Define roles, privileges required to access different database objects.
• Define virtual warehouse sizing for Snowflake for different type of workloads.
• Worked on Oracle Databases, Redshift and Snowflakes.
• Experienced in provisioning of IaaS, PaaS, SaaS virtual machines and web/worker roles on Microsoft Azure classic and Azure Resource manager.
• Worked with cloud architect to setup the environment.
• Data cleansing of raw data by applying primary constrains, joins, conditions, date formats, duplicate data removal and moved
• Cleaned data into transformed tables.
• Created tables, databases, schemas, data warehouses, users, file formats.
• Created streams and tasks for change data capture and scheduling tasks.
• Load data into snowflake from internal and external stages using SnowSQL.
• Worked with multiple data sources.

Environment: Snowflake, Git, Python, CI/CD, Oracle, AWS, Azure, SQL.

Confidential, Atlanta, GA

Cloud Engineer

Responsibilities:

• Architected, designed and developed a fully automated payment integrity and fraud detection solution on Hadoop.
• Launching Amazon EC2 Cloud Instances using Amazon Web Services and Configuring launched instances with respect to specific applications.
• Extensive experience in Amazon Web Services (AWS) Cloud services such as EC2, VPC, S3, IAM, EBS, RDS, ELB, Route53, ECS, AutoScaling, CloudFront, CloudTrail, CloudWatch, CloudFormation, Elastic Beanstalk, SNS.
• Setting up databases in AWS using RDS and configuring instance backups to S3 bucket.
• Experience in setting up Elastic Load Balancers (ELB's) and Auto Scaling groups on Production EC2.
• Performed S3 buckets creation, policies and also on the IAM role based polices.
• Created AWS Launch configurations based on customized AMI and use this launch configuration to configure auto scaling groups and Implemented AWS solutions using EC2, S3, RDS, Route53, EBS, Elastic Load Balancer, Auto scaling groups.
• Created customized AMIs based on already existing AWS EC2 instances by using create image functionality, hence using this snapshot for disaster recovery.
• Configured Elastic Load balancer (ELB) including high availability of ELB using various subnets in various availability zones, configured security settings for application.
• Configured Application Load balancer (ALB) including high availability of ALB using various subnets in various availability zones, configured security settings for application.

Environment: AWS Cloud, EC2, S3, RDS, IAM, VPC, Cloud front, Autoscaling, ELB, Route 53, Linux, Microsoft Windows, Jenkins, GIT, Maria DB, My SQL.

Confidential

Oracle EBS Consultant

Responsibilities:

• Involved in the analysis, design, development, enhancement, and testing of the ERP project.
• Actively involved in understanding the business model and gathering the requirements from the user for enhancement of existing components as part of support tasks.
• Studying, understanding and analyzing the given AIM Documents (MD50).
• Development and customization of the assigned RICE Components like reports according to the Client Requirement and development standards.
• Customized existing scripts according to the client requirement.
• Involved in migration of codes from one instance to another instance.
• Creating the scripts for concurrent executables and concurrent programs for interfaces.
• Provided support for various interfaces during testing and UAT phases.
• Prepared AIM documents like MD070 based on the functional document provided by the functional consultant.
• Developed SQL, PLSQL code to obtain the required functionality.
• Created Indexes, synonyms, sequences, tables, packages, functions.
• Performed AOL operations like concurrent program registration, attaching request groups etc.
• Prepared test case documents and captured all the test cases to check the functionality of the interface process.
• Daily monitoring on the critical issues, providing updates and working towards the resolution.
• Developed XML publisher reports and experience in customization of reports.
• Worked on the critical alerts/mails received from customer, investigating and updating root cause analysis and fix.
• Attending daily call with customers and providing updates on the worked tickets.
• Done analysis on critical issues and provided update to the customer.
• Worked on the CR's for the bug fixes and migrated to PROD environment.
• Worked on end-to-end Change deployment using release Tool, uploading code & documents in SVN including Driver Creation and Documentation.
• Applied data fixes for month end and critical business impact incidents.
• Worked on Oracle SR’s and follow up with Oracle to get the solution on the issues.

Environment: Oracle Applications 11i/R12, Oracle 11g, OM, PO, INV, AR, AP, GL, PL/SQL, SQL*Plus, SQL Developer, UNIX, Winscp, Putty.

Confidential

Oracle EBS Consultant

Responsibilities:

• Involved in the analysis, design, development, enhancement, and testing of the ERP project.
• Actively involved in understanding the business model and gathering the requirements from the user for enhancement of existing components as part of support tasks.
• Studying, understanding and analyzing the given AIM Documents (MD50).
• Development and customization of the assigned RICE Components like reports according to the Client Requirement and development standards.
• Customized existing scripts according to the client requirement.
• Involved in migration of codes from one instance to another instance.
• Creating the scripts for concurrent executables and concurrent programs for interfaces.
• Provided support for various interfaces during testing and UAT phases.
• Prepared AIM documents like MD070 based on the functional document provided by the functional consultant.
• Developed SQL, PLSQL code to obtain the required functionality.
• Created Indexes, synonyms, sequences, tables, packages, functions.
• Performed AOL operations like concurrent program registration, attaching request groups etc.
• Prepared test case documents and captured all the test cases to check the functionality of the interface process.
• Daily monitoring on the critical issues, providing updates and working towards the resolution.
• Developed XML publisher reports and experience in customization of reports.
• Worked on the critical alerts/mails received from customer, investigating and updating root cause analysis and fix.
• Attending daily call with customers and providing updates on the worked tickets.
• Done analysis on critical issues and provided update to the customer.
• Worked on the CR's for the bug fixes and migrated to PROD environment.
• Worked on end-to-end Change deployment using release Tool, uploading code & documents in SVN including Driver Creation and Documentation.
• Applied data fixes for month end and critical business impact incidents.
• Worked on Oracle SR’s and follow up with Oracle to get the solution on the issues.

Environment: Oracle Applications 11i/R12, Oracle 11g, OM, PO, INV, AR, AP, GL, PL/SQL, SQL*Plus, SQL Developer, UNIX, Winscp, Putty.