Suresh Shrestha

Suresh Shrestha Microsoft Certified Solution Expert Mahalaxmi Municipality, Lalitpur, Nepal Email:-Cell: +977 - Skype: shrestha2lt8 Career Objective: A self-motivated, dynamic professional with over 10+ years of experience in Software Development, Database Administration and mobile development leading teams and working in team and independently with reputed onshore and offshore organizations. I have strong conceptualization and Programming skills in using tools / technologies in but not limited to VB, VB.NET, C#, MS SQL Server, IOS (Objective C), Android , PhoneGap. I am a team player and skilled communicator with strong analytical ability. Summary:       10+ years of professional experience in software design and development. Areas of interest include Objective C, Android, VB.NET, C#, EntityFramework,VB 6, Silverlight, WPF, MVC, Phonegap, SQL Server, Mongo DB and different javascript frameworks. Worked and management in all aspects of software development life cycle (SDLC). Self-motivated & result oriented professional. Looking forward to manifest my innovative ideas and skills in a challenging role. Dedicated sincere, friendly in nature and highly focused. Professional Certification      Microsoft Certified Professional Developer (MCPD) Microsoft Certified Solution Expert (MCSE) SQL Server 2012 Programming in HTML5 with JavaScript and CSS3 10 Gen Certified MongoDB Developer Diploma In Software Engineering Education: Degree: Institution: B.Sc Tri – Chandra College Key Competencies:         Good as individual and team. Ability to work in a diverse team. Good communication & interpersonal skills. Proactive approach in problem solving. Ability to explore and grab new technologies quickly. Quick solution provider Strong debugging skills Can handle, Work, Manage & Lead a team (Desktop , Web , Mobile) 1 Current Professional Status: Company Position: Dates: MYDBA Nepal Pvt. Ltd. Database Consultant June 2014 – Present  To proactively monitor database server and log shipping and make recommendation/ modifications to ensure adequate capacity is maintained for offshore clients and MYDBA servers  To make trend analysis report to the database support team /customer to enable them to make informed decisions regarding resource management  To Monitor performance issues like deadlocks, blocking, missing and unused indexes, I/O Bottlenecks, poor query plans, statistics and wait stats  To Review overall performance of servers of clients (e.g. disk space, CPU utilization, available memory) and providing with a Responsibilities: heath check report.  To use various monitoring tools to identify, analyze and resolve database performance issues  To identify and analyze inefficient queries and make recommendations to make better queries  To analyze and identify blockings and deadlocking and provide the solution  To develop, maintain and monitor SQL Agent jobs, scheduled tasks and batch scripts for the purpose of performing routine database maintenance  To write scripts and stored procedures as required Professional Experiences: Company Grafi Offshore Nepal Pvt. Ltd. Position: Technical Supervisor Dates: Nov 2012 - June 2014 Grafi Nepal is a joint venture company with Grafi Offshore services b.v.b.a. Company Belgium. Grafi Offshore Nepal deals with Dutch and Belgium software Profile development. Responsibilites:  Lead the team.  Communicating with offshore clients and team.  Requirement analysis, system design and database design.  Module breakdown & Estimation of the project.  Task breakdown and assigning to the developers.  Development, testing and debugging.  Giving solution to developers.  Develop coding standard.  Reviewing of Code.  Coordinating with project managers offshore and onshore.  Research/Study on new technologies.  Training to colleagues and subordinates 2 Company Position: Dates: IT Offshore Nepal Pvt. Ltd. Team Leader(.Net & Mobile) March 2009 – Nov 2012 IT Offshore Nepal is a joint venture company with IT Offshore services BVA. Company Profile Belgium. IT Offshore Nepal deals with Dutch and Belgium software development. Responsibilities:  Communicating with offshore clients and team.  Requirement analysis, system design and database design.  Module breakdown & Estimation of project.  Task breakdown and assigning to developers.  Development, testing and debugging.  Giving solution to developers.  Lead the team.  Making coding standard.  Reviewing of Code.  Coordinating with project managers.  Research/Study on new technologies.  Knowledge sharing. Company Position: Sager International Computech (SIC) Software Developer Dates: Oct 2006 – Feb 2008 Company Profile SIC is a software company, which develops application for accounting, school and medical business.  Requirement analysis, design and development.  Development, testing and debugging. Responsibilities:  Interaction with clients regarding requirements. List of Some Major Projects Undertaken (Freelancing): Project: SOZO Role: Developer URL: https://secure.sozoglobal.com/ Date: Jan 2014- June 2014 Description: Responsibilities: Technical Skill Requirements This project is all about the Multi-Level Marketing (MLM) system.     Implementing new requirement Maintenance Front end development Estimation      Asp.net MVC Asp.net Web API Azure SQL Azure Angular JS 3  Bootstrap Project: Role: Description: Specific Tasks: Masspro Developer This project all about the financial evaluation which is suitable for any Medical company. This is also a real time project. Now, it is used in many Pharmaceutical companies in Nepal like Qurex Pharmaceutical Pvt.Ltd, Hukum Pharmaceutical Pvt.Ltd etc. It includes Balance Sheet, Trail Balance, Transaction Vouchers, Journal, Ledger, etc. It also has many utilities like Data import, Data Backup, Recalculate Balance This is complete commercial software for any Medical areas.     Adding new modules. Maintenance of existing modules. Rewriting the Report queries. Writing queries for different reports. Technical Skill Requirements  Visual Basic 6  MS Access  SQL Server 2000 Project: Client: Bingel Vanin Role: Dates: URL DBA June 2010 - June 2014 www.bingel.be Description: Bingel is an educational web application which gives a platform to school, teacher and student to interact with each other. Bingel a virtual classroom provides the students to work on flash exercise assigned by the teachers. Scalability is the primary focus of the product, which handles almost 3000 users per sec. Specific Tasks:  Project estimation, communicating with abroad managers and clients.  Database design ,Query optimization, Table Partition, Database mirroring, Database snapshot , SQL Jobs  Performance tuning on SQL Server. Technical Skill Requirements      . Net Framework 3.5 Enterprise caching and data blocks Web Services SQL Server 2008 R2 Microsoft Office Project 4 Project: Client: Role: Dates: URL Fame Description: Fame is facility management system. Which have different modules like Key Management, Location Management,Reservation etc. It is a multidatabase application. It runs on SQL Server and Oracle. Famas Developer, Team Leader March 2008 – June 2014 http://fmis-fame.com Specific Tasks:  Development of new modules  Maintenance of existing modules  Communicating with the client. Technical Skill Requirements      Project: Zeeland Fietsroutes URL: http://itunes.apple.com/nl/app/zeelandfietsroutes/id-?ls=1& mt=8 Role: Client: Dates: Team Leader and Developer PZD 2011 – 2014 Description: It is cycling route mobile app. This guides cyclist during cycling. It gives detail information about the route like route path, route points, and different objects like hotels, café, restaurants on the route. It’s a map application. Where all route information is shown on the map and user can interact with the map Specific Tasks:        VB. Net SQL Server 2005,2008 ,2008 R2 Oracle Microsoft Reporting Services(SSRS) Component Art Team Lead Requirement analysis. Module breakdown Task break down and assigning to developer Communicating with Project Managers Developement , Testing, Code review Giving solutions to developers 5 Technical Skill Requirements      Objective C. Route Me framework, SB Json parser Openstreet map SQL Lite JSON Webservice Other Skills: Programming Languages and Technologies C#.Net ,VB.Net , VB 6 ASP , ASP.Net, Asp.net MVC, AJAX, XML, LINQ Java Script, Jquery, Jquery Plugins ,Angular Js JQuery Mobile, Phonegap Objective C, Cocos 2D Database MySQL, MS SQL , MS Access Web Servers IIS , Apache Repository SVN , GIT & Team Foundation Server Project management tools Manits, Dotproject , AtTask , JIRA , Basecamp Professional Interest:    Solution architecture ( Software and Mobile) MSSQL Database Administration Project Management and development Reference: Available on request 6