Sql Server Data

Deepak Hari

PH :+1-470-***-****

Email ID: **************@*****.***

Professional summary

* ***** ** ********** ** Health care and Telecom Domain.

* + years of experience in Oracle SQL, UNIX, K2View ETL tool, Python, AWS, AZURE, and Snowflake data warehouse.

Good experience in Oracle SQL scripts,Joins,Subqueries,Sequence.

Good knowledge in Synonyms,views,Materialized Views,Indexes and SQL functions.

Worked on basic Linux commands and have good knowledge of Linux and Unix.

Good experience in SQL development.

Good knowledge of tools like Apache Airflow, DBT tool.

Experience with Snowflake Multi-Cluster Warehouses.

Experience with Snowflake Virtual Warehouses.

Very good at SQL, data analysis, unit testing, and debugging data quality issues.

Extensively used the utilities like SQL Developer, MS SQL server and DBeaver.

Experienced in creation of user roles, navigation, Database objects, Virtual warehouse creation, loading and querying CSV and JSON data in Snowflake data warehouse cloud technology.

Good experience in Kafka.

Good experience in HTML5, CSS3.

Good knowledge and experience in creating Python variables and data types like strings, lists, sets, tuple, dictionaries, NumPy, pandas, Data Frame, Data Series, PySpark.

Good knowledge of creating Python functions, files, and built-in functions.

Knowledge of developing applications with Docker and deploying using Kubernetes.

Experience in creating AWS S3 bucket, EC2, IAM, RDS and staging files.

Good experience in migration Projects.

Excellent communication, leadership, organizing, debugging, team building and motivation skills.

Technical Skills:

Industry/Domain

Healthcare, Telecom & Financial Services

Databases

Oracle 11g, MS SQL server, Teradata

Tools exposure

SQL Developer, Snowflake, DBeaver, K2View ETL tool, Putty, Docker, Apache Airflow, Power BI, Tableau,PgAdmin4, GitHub, Jira, Informatica,DAGs, VS code

Programming Languages

Oracle SQL, Core Java, Unix, Python

Version Control

SVN, Git

Cloud Technology

Azure, Snowflake Datawarehouse, AWS

Certifications:

Acquired Microsoft certified Azure Fundamentals AZ900.

Work Experience:

Snowflake Developer

Project 1# October 25th 2022 to Present

Capgemini, Remote

SEI INVESTMENTS, Pennsylvania, Oaks.

Responsibilities:

Performed on SQL stored procedures from MSSQL Server converting as per snowflake standard.

Created automation of dynamic DDL script to generate a create statement of tables as per snowflake standard.

Worked on documentation and performed unit testing of tables.

Generated on creation of automating streams script.

Created and executed streams in snowflake for CDC.

Performed Design and build internal snowflake applications. Transferring data to and from the snowflake using DBT ETL tool.

Enhanced and Performed DDL and DML operations in snowflake.

Generated on reconciliation of tables.

Performed tasks on pandas, lists, Set, Tuples, and data series in python.

Performed data quality metrics.

Reconciled and performed DDL and DML operations in MSSQL Server.

Worked on analysis of databases like MS SQL server and snowflake for migration purpose.

Worked and created new Azure Data factory storage and storage account on azure.

Performed on objects like Author, Monitor, Manage in Azure Data factory storage for storing of data using blob containers.

Created pipelines in data factory and load the data in the form of excel file format from source and converted to csv file format using sink in ADF.

Worked on copy of various formats like ADF File path, ADF Wildcard, List of Files, prefix, and storage account for structured and semi structured data for storage.

Environment: MS SQL Server, AZURE ADF, Snowflake, VScode, Git.

Project 2# October 2021 to July 2022

AT&T, Dallas, TX

Snowflake Developer

Tech Mahindra Ltd

Project : CDO Transformation(Snowflake)

Domain : Snowflake

Client : AT &T

Tools : Azure

Role : Developer

Environment : Snowflake, AZURE and LINUX server.

Responsibilities:

Gathered business requirements to determine the feasibility and to convert them to technical tasks in the design document.

Worked on flattening JSON’s into tables.

Create Tasks to schedule the jobs.

Created Snow warehouse 1x/2x Large, Database, Snow pipes and other utilities.

Knowledge in multi cluster, auto scaling and auto suspend the warehouse.

Created worksheets using SQL to stage and transform data.

Developed scripts using PL/SQL and Stored Procedures.

Worked and performed tasks on DBT tool with ETL Data Pipeline.

Worked and performed tasks on Fact tables and dimension tables in data modelling.

Have Good experience on OLTP and OLAP.

Have Good knowledge and hands-on on SCD Type 1 and SCD Type 2 in snowflake.

Created or setup SQS notifications when Kinesis writes new data files to get the data near real time, triggered Lambda script to automate the job to append data into target through Snow pipes.

Performed tuning of Applications for setting right Batch Interval time, correct level of Parallelism and memory tuning.

Clone data bases, tables, schemas etc.

Worked on Create, Alter & update tables, views, file formats, data etc.

Worked with different file formats, like CSV, JSON, PARQUET etc.

Worked using multiple roles Account Admin, SYSADMIN etc.

Project 3#

Snowflake Developer

Tech Mahindra Ltd April 2020 -September 2021

Project : CDO(Snowflake)

Domain : Snowflake &NiFi

Client : AT &T

Tools : DPCT, Schema Registry, Kibana, Postman, Azure

Role : Developer

Environment : Azure and LINUX server

Project Description:

Snowflake project which does data loading from data router to Snowflake cloud environment using Ni-Fi tool which includes DATA PIPELINE CONFIGURATION TOOL, SCHEMA REGISTRY, KIBANA to the respective process for the data loading into ADLS2 and then into Snowflake. Working with ATT client and the Snowflake team. The role is to generate JSON files according to the table being loaded and Avro file generation.

Responsibilities:

Creating data feed for source and target.

Generating app details as JSON file from DPCT tool.

Generating Avro file using schema registry.

Posting the JSON configuration using POSTMAN for API testing.

Using Linux server, the path in which data to be loaded is given.

By running curl command, the file that is already being pushed is loaded into data lake.

In KIBANA the status of the target data can be checked if INGESTION- SUCCESS or INGESTION- FAILURE in AZURE.

In storage accounts and inside container in AZURE the table is loaded

Data is then loaded into snowflake from ADLS2.

Ingestion of data/files using Snowpipe from external stages (AWS S3 bucket) and used copy into command for bulk loading.

Built stored procedures for data migration/loading into stage, raw and core layers in snowflake.

Implemented in-built Snowflake scheduler such as streams and tasks for periodic refresh.

Project #4

Tech Mahindra Ltd November 2018 - April 2020

Project : K2View Test Data Management(TDM) & Snowflake DWH

Domain : Telecom

Client : AT&T

Tools : K2VIEW,DBeaver,Putty

Role : Development

Environment : Oracle 11g,Cassandra.Unix,Java,

Version Control : SVN, Git

Project Description:

K2view Test Data Management (TDM) offers an automated solution to copy a subset of entities from source systems into selected testing environments and provide data to testing teams. Data is organized by the logical unit of the business. Each logical instance is treated as a micro-database containing all data about the entity. K2View’s Fabric retrieves and stores data based on business logic, hence the name Logical Unit. Using the Schema, K2View Fabric automatically retrieves all information associated with a specific Logical Unit Type using embedded, in-memory migration (ETL) capabilities. The data is then accessed, distributed, and stored in K2View Fabric as Logical Unit Instances, allowing for incredible performance, enhanced security, high availability, and customizable data synchronization.

Responsibilities:

Created interfaces for different database sources.

Developed and implemented queries for performing joins, subqueries, and SQL functions.

Designed and developed LU (logical unit) using K2View framework with the interfaces connected.

Worked on creating logical units including configuration of instances, key columns, linking tables and defining the table population.

Created parsers to load data from data files or data sources to Cassandra tables.

Created Reference tables to sync data between data source and target database.

Created key spaces, tables and queries using Cassandra.

Worked on Kafka codes for migration of data from source to target db.

Deploying the design in fabric servers and loading it to the target database using ADI (Advanced Data Integration).

Used GIT for pushing the code changes.

Created sequence for the applications to avoid duplication of data in the target database.

Integrated different applications using TDM GUI.

Project #5

AGS Health Private Limited July 2016 -June 2018

Project : Ensemble

Domain : Health Care

Client : US

Tools : Athena Software

Role : Process Associate

Responsibilities:

To analyze and design the enhancement of web-based health care application Athena.

To participate in scrum meetings and to decide weekly tasks for the sprint with onsite team.

To develop SQL queries and stored procedures to access the customers/patient medical records to the frontend application using angular JS and backend with java spring framework.

To fix bugs and improve production and quality and write Junit testing.

Worked on monitoring and capturing the logs using Splunk for application.

Interact with U.S healthcare customers for claims-related queries and invoice status.

Attend weekly call status with on-site project teams.

Interact with healthcare providers.

Analyze the claims scenarios for processing payment.

Track the status of claims, update the claims status in the tool, and initiate actions as required.

.

Achievements:

Recognized with “Bravo Award” for being a consistent performer for AT&T client at Tech Mahindra Ltd.

Received appreciation and incentives for consistently ensuring Quality at AGS Health Private Limited.

Educational Qualification:

Course

Name of the Institution

Year of passing

B.E

(Electronics and Communication Engineering)

Jaya college of Engineering and Technology,

Poonamalle, Chennai-600056.(Anna University)

2015

HSC

St.Bede’s Anglo Indian Higher Secondary School,

Santhome, Chennai-600004.

2011

SSLC

St.Bede’s Anglo Indian Higher Secondary School,

Santhome, Chennai-600004.

2009

Contact this candidate