Senior Analytics/Data Integration Developer Resume

SUMMARY:

Senior Data Analyst/Integration Developer with more than 14+ years of experience in analyzing and developing Data Warehouse and Big Data - ETL applications for On-Premises( SAP HANA, MS SQL Server and Oracle) and Cloud Database using Snowflake (AWS), Matillion (AWS), Data Build tool (dbt) and Python.
Snowflake Certified Developer (SnowPro).
Excellent experience in using Snowflake features Snowpipes, Streams, Tasks, Stages, Clustering, Stages, Query Profiling and understanding of Time Travel and Fail safe.
Excellent experience in loading and unloading data using COPY, PUT, LIST, GET and REMOVE command in Snowsql.
Excellent experience in integrating Snowflake with S3 (External stage) and extracting the files from S3 bucket and load into Internal stage.
Excellent experience in Data sharing using Secure share and consuming data from Data Marketplace.
Excellent experience in Roles, Resource Monitor and different types of Caching.
Provisioning Virtual Warehouse
Excellent experience in integrating DBT with Snowflake.
Excellent experience in developing models based on different materialization (Tables, Views, Incremental and Ephemeral).
Excellent experience in deploying using the command line and scheduling using DBT Cloud.
Excellent experience in handling python libraries like edi-835-parser, pyodbc, Snowflake. Connector, Pandas, Numpy, Matplotlib and Seaborn
Good experience of Data warehouse concepts.
Excellent experience in working with Matillion - ETL and Data Loader.
Amazon Cloud Products like S3, EC2, Lambda, SNS and SQS.
Relational database - SQL Server.
Git Integration.

SKILL:

Snowflake Cloud DB

Matillion ETL

Matillion Data Loader

Streamsets - Data Collector

Dell Boomi

Lambda

EC2

SNS

SQS

RDS

Data Build Tool (dbt)

Python 3

Jupyter Notebook

PyCharm

JSON

PARQUET

AVRO

ORC

SAP HANA

MS SQL SERVER

SAP DATA SERVICE

SSIS

SQL

PL/SQL

SAP Business Objects

SSRS

Tableau

Windows 10

GitHub

PROFESSIONAL EXPERIENCE:

Confidential

Senior Analytics/Data Integration Developer

Responsibilities:

Understanding the existing ETL Pipeline built on (SSIS/SAP Data Service) dataflow and document it.
Understanding the existing SAP HANA models and document it.
Design the new flow of data using Matillion ETL into Snowflake
Transform the data in Snowflake into different models using DBT.
Breakup the tasks and assign it to peers, follow-up, test it and integrate it.
Creating the migration plan
Support for production migration
Developed SSIS package for extracting Quality Measures data for Clinical (Member, Enrollment, Attribution, Providers, Medical Claims, Lab, Pharmacy and Supplemental) and submitted to Cozeva on weekly basic
Developed SSIS package for extracting supplemental data from different source (Epic and Nextgen) and submitted to different health plan.
Developed ETL jobs using SAP BODS 4.2 and data ingestion/extracted from SAP ECC/ISU systems using ABAPs dataflow, Function Modules and Extractor method as well as from Non SAP system (Oracle, MS SQL SERVER and DB2).
Experienced in data extraction from flat files like Text, Asc and Excel and used Global Address cleaning package to clean the address data in SAP BODS.
Used various transform like Table comparison, map operations, History Preserving, Case, Merge, SQL and Validation.
Experience in Data Migration from Oracle to SAP ECC using IDOCs and BAPI method and used Rapid shared Data mart to migrate the data from SAP to Oracle database and build the reports.
Scheduling, monitoring and executing jobs in DS management console and created Local & Central repository and configured with the job server.
Experienced in converting existing SAP BODS jobs to SSIS solutions and move the solutions from Dev to Test environment using GIT.

Senior Consultant

Confidential

Responsibilities:

Well versed with SAP Native HANA Data Modeling, implementation, administration and created Analytic, Graphical based Calculation and SQL Script based Calculation views.
Experience in data extraction using SLT, Smart Data Access and Smart Data Integration in SAP Native HANA and created roles based on Analytic privileges.
Experienced in creating CDS views, XSJS jobs and used HANA Live Utilities, HANA LCM to transport the objects/views to different environments

Technical Specialist

Confidential

Responsibilities:

Experienced on all phases of Business Intelligence deployment lifecycle from gathering requirements to development, testing and Implementation and strong understanding of Data warehousing Concepts and Dimension modeling.
Experienced in developing universe with IDT using Context, Alias, Derived table, Index Awareness, Aggregate Awareness, @Functions and developed report from both Oracle database and SAP BW using Hyperlink, Rank, Combined Queries, and Merged Dimension using Webi, Crystal Reports, and Lumira.
Developed dashboard in Tableau.
Developed report using hyperlink in SSRS.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship