Subhan Singh Karki Email & Phone Number

Kathmandu, Bāgmatī, Nepal

Spearhead and oversee the entire data department, leading a team of skilled data analysts, database administrators, and data engineers.Develop and implement data strategies, aligning them with organizational objectives to enhance efficiency and drive innovation.Identify key performance indicators (KPIs) and implement data tracking mechanisms to measure and report on data-related metrics for continuous improvement.Collaborate with cross-functional teams to establish data governance policies, ensuring data quality, privacy, and security across the organization.Successfully managed data projects, ensuring timely delivery and adherence to budgetary constraints.

Kathmandu, Bāgmatī, Nepal

Design, implement and maintain fault tolerant data pipelines on top of cloud services. Introduce tech stacks for efficient and modern solutions to data problems unique to various data warehouses. Work with cross-functional teams and design systems capable of fulfilling data related needs of such teams for their purpose.

• Responsible for monitoring and maintaining the performance standard of the database server as well as its integrity• Used various BI Tools to create interactive reports for the purpose of business deliverable as well as in-house reporting • Developed programs in Python, scraping data from the web, cleaning it and storing it in the database for further data mining and analysis purpose• Used Python to create data pipelines, while working with heterogenous data sources and API's, followed by data cleansing and aggregation, and finally reporting and information dissemination in a scheduled and automated workflow• Point on digital marketing platforms such as Hubspot (Certified), Google Adwords (Certified), Facebook Ads, etc.• Constant R&D on technologies/platforms to give an insight as to what can be achieved and how it can add to the business profile

Kathmandu, Nepal

• Installation, configuration and maintenance of several instances of Oracle enterprise edition database for both development and production purposes• Installation, Configuration and Maintenance of several instances of MS-SQL database for both development and production purposes.• Continuous support to both Production and Development Team.• Responsible for over 50 (Oracle) and over 50 (MS-SQL) production/development servers involving tasks such as backup, synchronization, space management, user management, etc.• Configuration, Maintenance and continuous R&D on Oracle OEM Cloud Control 12c and monitoring server server pools with Oracle EM cloud control 12c along with multiple regular/maintenance tasks• Security implementation in both OS and Database level of production servers ensuring several standard policies (HIPAA, PHI)• Involvement in Development of Reporting tools for current/future analysis.• Development of automate script as per Easiness and Business need.• Research and development on Heterogeneous Database connectivity (Oracle, MS-SQL, Vertica, etc)• Daily DB health check• 24x7 support• Monitor performance and tune database parameters• Work with Oracle support for bugs and workout solutions to be implemented• Apply PSU/CPU patches for Linux/windows machines with Oracle installed as well as updating SQL Server database to latest stable releases• Deploy new codes in Production environment and synchronize master schemas across all production servers (more than 50)• Continuously work with development team to enhance codes for better performance

Kathmandu, Nepal

• Installation, configuration and maintenance of several instances of Oracle enterprise edition database for both development and production purposes• Installation, Configuration and Maintenance of several instances of MS-SQL database for both development and production purposes.• Continuous support to both Production and Development Team.• Responsible for over 50 (Oracle) and over 50 (MS-SQL) production/development servers involving tasks such as backup, synchronization, space management, user management, etc.• Configuration, Maintenance and continuous R&D on Oracle OEM Cloud Control 12c and monitoring server server pools with Oracle EM cloud control 12c along with multiple regular/maintenance tasks• Security implementation in both OS and Database level of production servers ensuring several standard policies (HIPAA, PHI)• Involvement in Development of Reporting tools for current/future analysis.• Development of automate script as per Easiness and Business need.• Research and development on Heterogeneous Database connectivity (Oracle, MS-SQL, Vertica, etc)• Daily DB health check• 24x7 support• Monitor performance and tune database parameters• Work with Oracle support for bugs and workout solutions to be implemented• Apply PSU/CPU patches• Deploy new codes in Production environment and synchronize master schemas across all production servers (more than 50)• Continuously work with development team to enhance codes for better performance

Kathmandu, Nepal

• Over 3 and half years of programming experience as an Oracle PL/SQL and T-SQL developer in Analysis, Design and Implementation of Business Application using the Oracle.• Involved in all phases of the SDLC from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.• Strong experience in Data warehouse concepts, ETL• Good knowledge on logical and physical data modeling using normalizing techniques.• Developed materialized views for data replication in distributed environments.• Created packages and procedures to automatically drop schema objects such as indexes, tables, synonyms, views etc and re-create them as per need.• Good knowledge of key performance related features such as Query Optimizer, Execution plans and indexes.• Experience in ETL techniques and analysis and reporting.• Created several Shell scripts for invoking SQL scripts and scheduled them using crontab for the purpose of automation as well as monitoring purposes.

Kathmandu

• Involved in all phases of the SDLC from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.• Good knowledge on logical and physical data modeling using normalizing techniques.• Developed materialized views for data replication in distributed environments.• Created packages and procedures to automatically drop schema objects such as indexes, tables, synonyms, views etc and re-create them as per need.• Experience with Performance tuning for Oracle RDBMS using explain plans, HINTS and CBO• Experience in ETL techniques and analysis and reporting.• Created several Shell scripts for invoking SQL scripts and scheduled them using crontab for the purpose of automation as well as monitoring purposes.

Bachelor Of Engineering (B.E.), Computer Engineering

Activities and Societies: Robotics Club (PCRT), Software Club (ICON) Initiation of clubs such as robotics club and software club.

Hseb, Science