Shiba B Kunwar

Generals Ct, Centreville, *****, VA 929-***-**** adzbu6@r.postjobfree.com

linkedin.com/in/shiba-kunwar-b4444865

Objective

Systematic Data Engineer with 11 years of experience in designing, engineering, architecture, data analysis and data modeling in different data domains like US health care, e-commerce, and US general insurance. Proven track record managing all phases of Software Development Life Cycle (SDLC). Analytical thinkers quickly and effectively identify and resolve technical problems.

Skills & abilities

Databases: MSSQL Server, Oracle, MYSQL, Postgres, MongoDB, Redshift, Snowflake

Analytics: Zoho Analytics

ELT: SSIS, Five Tran, Talend

Scripts: Python

Cloud: Microsoft Azure, AWS

Data Analysis

EMR (Electronic Medical Record)

AMS (Agency Management System: EPIC)

Education

Nepal College of Information Technology (Nepal), M.Sc.

Major: Computer Science

Work Experience

Project: US General Insurance

Client: Renegade Insurance

Role: Senior Data Engineer

Period: Feb -2019 - May 2023

Tools: SQL Server, MongoDB, MySQL, Python, Zoho Analytics, EPIC (Agency Management System), Salesforce, Azure

Location: Nepal

Import different data sources in SQL Server database using SQL Scripts and Python

Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.

Data modeling on MongoDB

Load Data from SQL Server to MongoDB using Python script.

Employed data cleansing methods significantly enhanced data quality.

Explored the database architecture implemented by third parties (EPIC Agency Management System)

Design database, schema, tables, views, functions, stored procedures, triggers etc.

Prepared dataset for dashboards and reports

Load data from RDBMS to analytical tool ZOHO Analytics

Designed custom dashboards and reporting interfaces.

Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders.

Mapped data between source systems and warehouses.

Prepared data set for Salesforce application (source is AMS) and loaded that data to salesforce using Salesforce data loader tool.

Used MySQL database to store applications configuration and user management data.

SQL Query Optimization

Provide training to new team members.

Cross-team collaboration

Project: E-Commerce

Client: GrowbyData

Role: Senior Data Engineer

Period: Nov -2015 - Feb 2019

Tools: SQL Server, SSIS, Python, Redshift, Azure cloud

Location: Nepal

Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.

Implemented all the business logic in MSSQL database using stored procedure, function, view etc.

Contributed to internal activities for overall process improvements, efficiencies and innovation.

Proposed database changes to ease monitoring and administrative effort.

Reviewed database design to recommend enhancements or improvements.

Troubleshot complex queries and stored procedures.

Worked with software development and testing team members to design and develop robust solutions to meet client requirements.

Analyzed existing SQL queries for improvements/optimization.

Designed, implemented and maintained complex T-SQL queries, views, stored procedures, functions etc. using MSSQL server.

Resolved complex business issues, proposing long-term solutions to avoid repeat problems.

Prepared data flow using SSIS.

Load data from MSSQL to Redshift (data warehouse) using Python scripts.

Project: US Health Care

Client: Deerwalk Services

Role: Data Engineer

Period: Sep -2012 - Oct 2015

Tools: SQL Server, Python, Redshift, AWS, MySQL, Oracle

Location: Nepal

Load different data source from AWS to Oracle database using PLSQL/python.

Restored different databases provided by clients like Oracle, MSSQL, MySQL for analysis purposes.

Extracted and interpreted data patterns to translate findings into actionable outcomes.

Identified and documented detailed business rules and use cases based on requirements analysis.

Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.

Implemented all the business logic in Oracle database using stored procedure, function, view, triggers etc.

Mapped data between source systems and warehouses.

Validated warehouse data structure and accuracy.

Designed, implemented and maintained complex PL-SQL queries, views, stored procedures, functions etc. using Oracle server.

Supported leadership team with reporting, analysis and business presentations to inform divisional strategies.

Prepared queries for different matrix/report using PL-SQL script.

Query optimization

Automated manual process using PL-SQL script.

Contact this candidate