RANJANA GHIMIRE
-Skype: run.jana |Stackoverflow: [user:-]|
LinkedIn:https://www.linkedin.com/in/ranjana-ghimire-557b08120
PROFESSIONAL SUMMARY
Desire to work on a research project to be able enhance my knowledge and skills by studies by utilizing
all abilities and experience with a suitable degree and guidance. I am seeking a work that will be fruitful
which will help me with self-development and growth and opportunities to fuel my passion as a
Database developer/DBA.
EDUCATION
Bachelors in Computer Engineering(BE): Tribhuvan University -)
Intermediate Level/High School(HSEB): (2009 - 2012):Capital College of Research Center
WORK HISTORY
Senior DBA/ Senior Data Engineer (2017 July-Current)
F1soft International Pv.ltd – Hattisar, Kathmandu ,Nepal
Responsibilities:-.
Linux Shell scripting to perform ETL into Oracle.
Data Warehouse Development for MSSQL/Oracle/Mysql.
SQL Server/Oracle/Mysql installation (2014/2016) along with service packs.
Performance tuning in MSSQL/Mysql/Oracle.
Query Optimization for expensive queries in MSSQL/Mysql/Oracle..
Index and statistics maintenance for MSSQL/ORACLE/MySQL
Scripting queries in MSSQL/ORACLE/MySQL
Backup / Restore in MSSQL /Mysql and Export/Import/RMAN in ORACLE.
ODAC installation for data migration/transformation.
Data migration among various product release from old to new version or within products.
Data / Log file management in MSSQL and Undo/ temp management in oracle.
DBA (2015 Nov-2017 June)
VERCEND Technologies Inc, Subsidary of Verscend(f/k/a Verisk health) – Kathmandu Nepal
Responsibilities:
1. MSSQL installation (2008R2,2012,2014,2016) and upgrade
(2008R2=>2012,2012=>2014,2012=>2016) along with service packs.
2. Oracle installation(11.2.0.3) and upgrade(11.2.0.3=>11.2.0.4)
3. Backup and restore (MSSQL , OLAP and Oracle) strategy , deployment and monitoring.
4. Space management in windows (Specially data drive, log drive and System drive)
5. ETL using SSIS (from Oracle to MSSQL and vice versa using Attunity and Linked server , from
dump file to MSSQL)
6. OLAP catalog development , deployment and processing using SSIS
7. MSSQL and Oracle login creation and grants as per the responsibilities.
8. MSSQL performance tuning
9. Audit, job and database mail setup in MSSQL
10. AlwaysOn setup in MSSQL.
11. Log shipping, mirroring and replication setup in MSSQL.
12. SSRS configuration (report generation for testing the configuration, deployment and processing)
13. Script development for testing and automation task in MSSQL and Oracle
14. Python scripting to handle MSSQL and Oracle tasks.
15. Powershell scripting to handle migration scripting in MSSQL( basic backup, login, grant, roles ,
linked server and configuration scripting)
Team Leader (2013 Dec- 2015 Dec)
Cloud Factory Nepal – Kathmandu Nepal
Responsibilities:
- Team leader for data import, data analysis and data cleaning Data review
CERTIFICATION
1. Python for Everybody by University of Michigan on Coursera, Specialization on Python
programming to use data structures, networked application program interfaces, and database in
Python.(Online Certificate)
2. Data Science Certification by Johns Hopkins University on Coursera, the specialization was
designed in R programming and was comprised of 10 separate courses. (Online Certificate)
3. Data Warehousing for Business Intelligence by University of Colorado System, covering
structured data modeling, gain practical SQL coding experience, and develop an in-depth
4. understanding of data warehouse design and data manipulation. (Online Certificate)
5. Java Programming: Arrays, Lists, and Structured Data by Duke University.(Online Certificate)
TECHNICAL SKILLS
-.
STRONG TSQL SCRIPTING IN MSSQL AND GOOD PLSQL SCRIPTING IN ORACLE AND MYSQL
PROGRAMMING IN PYTHON 2.7
WINDOWS POWERSHELL
PROGRAMMING IN C/C++
OBJECT ORIENTED PROGRAMMING WITH JAVA
WEB PROGRAMMING THROUGH PHP5
STRONG REPORTING IN EXCEL
Worked as volunteer for 3 months in Earthquake Relief Program(2015) with BibekSheel Nepali during
which a hub was created for the dissemination of critical information, emergency supplies including
food, water/purification tablets, soaps, and tents.
REFERENCES
1. Kailash Shrestha : Chief Product Officer ,F1soft International(Ph: -,-,Ext.307/305 )
2. Prof. Dr. Subarna Shakya: Department of Electronics and Computer Engineering, Central
Campus, Institute of Engineering, Pulchowk, Tribhuvan University (Ph: -. Neeraj Shah: Director of Engineering (R&D) Verscend Technologies Inc (Ph: -. Sujan Chapagain: Workforce Officer, Cloud Factory Nepal (Ph:-)
