Sangram Mohanty Email & Phone Number

India

1. Orchestrate and automate azure data factory pipelines to extract documents from Veeva vault. 2. Writing notebooks using pyspark to make API call for document extraction, apply file naming convention to files in staging server and copy them into data lake storage gen2. 3. Follow medallion architecture to load data from API source into end tables and create data products for downstream consumers.4. Validate document metadata entries and create XML files to get it processed by proprietary system for archive. Finally copy the files from vault system to azure fileshare.

India

Bengaluru, Karnataka, India

Worked as a data engineer for a reputed oil & petroleum industry and automobile industry. Below were my responsibilities: - 1. Improve quality of data from various source system before ingestion into target system using a common semantic model. 2. Use CI / CD tool to test, build & deploy any python module into application. 3. Collect data from several source system, create mapping to target schema, filter tables/unstructured data and ingest the evolved data into target system.

Bhubaneshwar, Orissa, India

Worked as a Quality Analyst for a Canadian bank client in corporate centre of technology domain.1. Developed a script to perform structure, count and data validation between Oracle source tables and hive target tables before launching them in product environment.2. Created an automation script to validate structure and count between hive source and impala target tables.3. Developed an automation script to validate data between source and target table. I have designed automation scripts based on customer requirements to meet business logics(like view name validation as per business logic, table names versus mapping document validation).4. Created an automation script to validate data between source table versus target view with and without PII columns among Impala tables.

Bhubaneswar, Orissa, India

Worked as a middleware application developer in wholesale banking for a Canadian bank.1. Responsible for supporting wholesale banking application and generating sales trading reports.2. Receive development requirements from client and write PL/SQL stored procedures for meeting business requirements.3. Conducted various testing activities like unit testing, system integration testing to make any change go live to production. I had performed an automation activity to validate count and data between 2 different oracle databases.4. Created mappings and workflows to incrementally load data into target oracle tables using ETL tool Informatica.

Bhubaneswar, Orissa, India

Joined as a database developer and carried out end to end cloud migration of database objects.1. Responsible for migration of Oracle database to Azure SQL. As a database technical lead I was guiding my team to achieve business target by end Oct'2019.2. Migrated table structures, data, indexes, table constraints, stored procedures, functions. To convert Oracle stored procedures & functions to Azure stored procedures and functions.3. Create automation using Unix shell scripts, write Oracle PL/SQL and Azure SQL to data validate data between Oracle and Azure databases.4. Create automation script to validate alignment of table structures between Oracle databases.

Bhubaneswar, Orissa, India

1. As a L2 application support analyst in Wipro Technologies I take my priority to resolve incident tickets on time and providing optimum quality.2. It is my onus to allocate $7.8 billion across all COBs for an international oil company through cost allocation tool every month.3. I am responsible for troubleshooting errors/developing codes for client applications using T-SQL language.4. I take the ownership for deploying code changes to add enhancement to client applications that requires T-SQL and Unix Shell scripting.5. As per the monthly release I upgrade and troubleshoot any issues of client applications in production environment.

Bachelor Of Technology (B.Tech.), Cse, 100

Activities and Societies: I was a member of team 'Codershub'. I use to work with senior developers as database administrator.I was student.

10+2 Intermediate

Activities and Societies: I took part in science exhibition. I had created a science project 'Burning of Ice using Sodium Bicarbonate'. I.

10Th Matriculation, Cbse Curricullum

Activities and Societies: I had participated in science exhibition. I had created a science projects 'Test of Conductor and Insulator'.