Engineer Developer

Software Engineer with functional and technical expertise in designing, implementing, and maintaining large-scale enterprise Data Warehousing and Business Intelligence solutions, especially in Oracle Retail Analytics

HIGHLIGHTS OF QUALIFICATIONS

Experience with Ruby Language and RVM.

Experience with Ruby on Rails Framework and Ruby Chef Framework.

Extensive knowledge and implementing ROR with TDD (Test Driven Development) and BDD (Behaviors Driven Development).

Hands-on Experience in Deployment Rails framework in Heroku and VPM using Capistrano, Phusion Passenger and Nginx Server.

Experience in Rack Server.

Experience in Nginx and Apache Server.

Experience in Git Tools.

Knowledge in Sqlite, Mysql, Postgre DB, Teradata and Oracle DB.

Experience in Shell Scripting (Bash, ohh-my-zsh, korn Scripiting).

Experience in Rspec, Capybara etc.

Experience in Linux OS (Red Hat, Ubuntu, CentOS, Kali Linux etc),

Experience in Project Management tools (Jira, Trello, Pivotal tracker)

Experience with Mac OS.

Red Hat Certified Engineer (RHCE)

Red Hat Certified System Engineer (RHCSA)

Oracle Certified Associate (OCA)

Oracle Certified Professional (OCP)

TECHNICAL SKILLS

Languages: C/C++, PHP, Ruby, Python, JavaScript, Unix scripting (bash, ksh)

Databases: Oracle, Teradata, Netezza, Mysql, PostgreSQL, SQLite

Tools and Applications: AJAX, Apache, Bash, CSS, Capistrano, Git, Haml, HTML, JQuery, JavaScript, JSON, Linux, NGiNX, OSX, Phusion Passenger, RSpec, Ruby, Ruby on Rails, RVM, Sass, Sidekiq, SQL, SQLite, Nano, XML, ZSH, Ohh-my-zsh, Sublime. Heroku

PROFESSIONAL EXPERIENCE

Yomari Incorporated Pvt. Ltd. December 2014

Software Developer

Understand the ETL (Extract Transform Loading).

Develop ETL scripts for Data Warehousing using Korn Shell scripting.

Assist to understand the business needs of the client to deliver the optimal solution to enhance their business

Build SQL queries for scripts and reports

Perform information systems needs assessment, information gathering and recommend appropriate business systems and IT infrastructure for Yomari customers

Maintain and grow knowledge of Retail industry data warehousing and Business Intelligence functionality and technical skills

Leapfrog Technology December 2012

Software Engineer

Rails Developer

Experience with Ruby Language and RVM.

Experience with Ruby on Rails Framework and Ruby Chef Framework.

Extensive knowledge and implementing ROR with TDD (Test Driven Development) and BDD (Behaviors Driven Development

PROJECTS

Client: Siam Makro, Thailand (May 2015 to Present)

Role: BI consultant

Project Description: Siam Makro is a cash and carry wholesaler selling quality Food and Non Food products, providing the best buying conditions and solutions for their professional customers. With a large registered member base distributed all over the country, the Company continues to successfully operate its principle business of providing solution to a multitude of clientele operating in a wide range of industries; the main focus is small and medium size professionals buying for commercial and household use. Makro main customers are Food retailers, HoReCa Business (Hotel, Restaurants, and Caterers) and service sectors (Hospitals, Schools, Government Agencies etc.).

Responsibilities:

Create BI and OBIEE Reporting

History data migration

Cutover/ go-live with Retail Merchandising team

Project: Express Inc, Columbus, Ohio 43230 (December 2014 – May 2015)

Description: An American fashion retailer that caters mainly to young women and men. The company is headquartered in Columbus, Ohio and New York City.

Express operates more than 625 stores throughout the US, Canada, and Puerto Rico that sell trendy private-label apparel and accessories targeted to men and women between the ages of 20 and 30. It is an effort to create a new Express EDW leverages Logic’s BI data library, which is a library of accelerators for a data model, ETL and metadata elements

Role:

Business Intelligence Consultant, Java Developer, ETL script Developer

Responsibilities:

•Provide overall functional guidance and direction for the project team

•Extraction and Loading script development with Oracle and Teradata as a backend.

•Conduct reviews for specifications and code development

•Assist with test script and scenario development activities

•Participate in testing activities (e.g. system & integration tests)

•Participate in technical issue resolution

•Develop and unit test application modules where applicable

•Assist with data conversion activities

•Assist with integration activities impacting EDW

•Refine and assist with design of the Oracle Retail batch schedule

•Establish and ensure compliance with version control software to be used by the project team

•Participate in technical knowledge transfer to client

•Implement Market Basket Analysis (MBA) feature in Reporting and ELT.

Client: Express Inc, Columbus, USA (February 2015 – Present)

Project: LRDM Implementation, Microstrategy Reports

Description: Express is an American fashion retailer that caters mainly to young women and men. The company is headquartered in Columbus, Ohio and New York City. Express operates more than 625 stores throughout the US, Canada, and Puerto Rico that sell trendy private-label apparel and accessories targeted to men and women between the ages of 20 and 30. It is an effort to create a new Express EDW leverages Logic’s BI data library, which is a library of accelerators for a data model, ETL and metadata elements.

Role: Developer

Responsibilities:

•Editing the dashboards according to the specifications in MicroStrategy.

•Performing test and modification on the reports.

•Preparing of Technical Design Document.

•Creating metrics according to the Technical Design Document.

•Assist with data conversion activities.

•Assist with integration activities impacting EDW.

•Conduct reviews for specifications and code development.

•Resolve technical issues.

•Knowledge sharing with the peers.

Client: Yomari (June 2015)

Role: Developer

Project: Microstrategy

Project Description: This project involves dashboards and reports development with YRDM on Amazon cloud as the back end.

Responsibilities:

Demo data preparation as required

Minor changes in existing reports and dashboards as directed by the team lead

Client: Yomari (May 2015)

Role: Developer

Project: Yomari Retail Data Model (YRDM) Implementation on Teradata at Amazon Cloud

Project Description: This project involves implementation of Yomari's retail data model on Teradata at Amazon cloud server. All the data are migrated from existing YRDM implementation that has been done on Netezza Server.

Responsibilities:

Developing data migration scripts from Netezza to Teradata

Data load plus demo data preparation(as needed) in Teradata

Client: Yomari (April 2015)

Role: Developer

Project: Yomari Retail Data Model (YRDM) Implementation on Teradata

Project Description: This project involves implementation of Yomari's retail data model on Teradata. All the data are migrated from existing YRDM implementation that has been done on Netezza Server.

Responsibilities:

Developing data migration scripts from Netezza to Teradata

Data load plus demo data preparation(as needed) in Teradata

Client: Yomari ( December 2014 to Present)

Role: Data Model Developer

Project: Yomari Retail Data Model (YRDM) Development

Project Description: Yomari Data Warehouse Data Model is the data model being developed by Yomari, which provides an updated standard for data warehousing from RDW and RA.

Responsibilities:

Study and analysis of current business requirements, and developing a simplified Retail warehouse model.

Define the structure of tables from scratch.

Develop data model reference file for users describing each table and field.

Client: Yomari (February 2015 to March 2015)

Role: Developer

Project: History Conversion from RDW 13.1 to RA

Project Description: Migration of data from RDW system to RA using ODI

Responsibilities:

Map the data from RDW to RA.

Develop ODI packages for migrating history data of RDW 13.1 to RA.

Client: Yomari (January 2015 to February 2015)

Role: Developer

Project: Retail Analytics (RA)

Project Description: Oracle Retail Analytics (RA) is an analytical application that provides multiple modules for analysis and reporting on different areas of merchandising management and operations by integrating ODI (Oracle Data Integrator) and OBI (Oracle Business Intelligence). RA provides an updated standard for data warehouse from Retail Data Warehouse (RDW). RA project was about Research on this new technology, preparing internal development environment to work with RA, studying the working mechanism of ODI, how different case scenarios of Retail ETL process were handled in ODI and preparing our own ODI packages to help clients migrate from RDW to RA.

Responsibilities:

Understanding and preparation of Technical Design Documents for various facts and dimensions

Unit Testing ETL processes

Preparation of History Conversion packages and unit testing

Client: Yomari (December 2014)

Role: Installer/Developer

Project: Yomari Extract from RMS)

Project Description: Yomari extract from RMS is software package that extract retail transactional data from Oracle-Retail application stack (primarily from RMS, ReSA and RPM).

Responsibilities:

Installation of RMS 13.2 System (Initial phase)

Map the data from RMS to flat file and from flat file to RDW 13.1.

Develop function and script for extraction of data from RMS and loading into staging table of Oracle and Netezza data warehouse.

Documentation of scripts and library functions

Project: First KidBank(http://firstkidbank.com)

Description: The task of this project was to upgrade in Rails4. It was build in rails2 and was using rails plugin and prototypes JavaScript. There was lot of deprecated warning and was using old syntaxes

Role: Software Engineer (Rails Developer)

Responsibility:

Upgrade to rails3 and finally to rails4.

Replace rails plugin with gem package.

Convert prototypes to javascript.

Remove deprecated warning.

Replace old syntax with new one.

Design new authentication and authorization mechanism using devise.

Implement Assets pipeline.

Make all the test pass.

Write deploy script using Capistrano.

Setup the sever using passenger and NGINX

Project: Talk ESPN(http://talk-espn.herokuapp.com/)

Description: It was design from sketch. It was design to talk about ESPN activity. User were allow to make post about ESPN activity and other user can comment on that post.

Role: Software Engineer (Rails Developer)

Responsibility:

Design Database.

Check user role.

Design Authentication mechanism.

Pass unit and integration test.

Deploy it Heroku.

Project: Grilladex(http://grilladex.herokuapp.com/

Description: It is iOS application design to create recipe with ingredients, steps, cooking time and preparation. I have work as Back end developer for this project.

Role: Software Engineer (Rails Developer)

Responsibility:

Create API while creating User, Recipe, ingredients, tags etc.

Design Database for to store its data and passed data when accepts request.

Create server for it and passed to iOS developer.

Design Admin panel for this application.

CERTIFICATES

Red Hat Certified Engineer (140-221-250)

Red hat Certified System Administrator (140-221-250)

Oracle SQL Fundamentals I [OC1537774]

Oracle Certified Associate (OCA) [OC1537774]

Oracle Certified Professional (OCP) [OC1537774]

EDUCATION

St. Xavier’s College, Maitighar, Kathmandu, Nepal

Bachelor of Information Management (BIM) – March 2012

G.P.A: 3.69

REFERENCE

http://stackoverflow.com/users/1289029/amritdeep-dhungana

https://github.com/amritdeep

https://np.linkedin.com/pub/amritdeep-dhungana/42/77/60a

CONTACT

+977********** (Nepal Mobile Number)

+1-214-***-**** (US Mobile Number)

*****************@*******.***

**************@*******.***

*****************@*****.***

Contact this candidate